units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
67 rows where DES_TP = 2 and MNG_AGENCY = 533 sorted by rowid descending
This data as json, copyable, CSV (advanced)
ACCESS_TYP 3
MNG_AG_TYP 1
- City Agency 67
MNG_AGENCY 1
- Roseville, City of · 67 ✖
DES_TP 1
- Local Park · 67 ✖
Link | rowid ▲ | id | map | ACCESS_TYP | UNIT_ID | UNIT_NAME | SUID_NMA | AGNCY_ID | AGNCY_NAME | AGNCY_LEV | AGNCY_TYP | AGNCY_WEB | LAYER | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | PARK_URL | COUNTY | ACRES | LABEL_NAME | YR_EST | DES_TP | GAP_STS |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14426 | 14426 | 14425 | {"type": "Polygon", "coordinates": [[[-121.36549, 38.78949], [-121.36537, 38.78765], [-121.3654, 38.78776], [-121.36547, 38.78786], [-121.36562, 38.78798], [-121.36575, 38.78803], [-121.36596, 38.78806], [-121.36754, 38.78805], [-121.36768, 38.78807], [-121.36781, 38.7881], [-121.36793, 38.78816], [-121.36803, 38.78824], [-121.36813, 38.78839], [-121.36816, 38.78856], [-121.36812, 38.78872], [-121.368, 38.78887], [-121.36783, 38.78897], [-121.36769, 38.78901], [-121.36755, 38.78903], [-121.36607, 38.78903], [-121.36593, 38.78905], [-121.36574, 38.78911], [-121.36564, 38.78919], [-121.36553, 38.78933], [-121.36549, 38.78949]]]} | Open Access 1 | 44553 | Norm Fratis Park | 22792 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 6.308 | Norm Fratis Park | 0 | Local Park 2 | 4 | |
14425 | 14425 | 14424 | {"type": "Polygon", "coordinates": [[[-121.35177, 38.80533], [-121.35238, 38.8056], [-121.35242, 38.80565], [-121.35241, 38.80569], [-121.35202, 38.8062], [-121.35196, 38.80623], [-121.35189, 38.80623], [-121.35125, 38.80594], [-121.35112, 38.80583], [-121.35107, 38.80568], [-121.35108, 38.80556], [-121.35112, 38.80548], [-121.35118, 38.8054], [-121.35127, 38.80534], [-121.35139, 38.8053], [-121.35152, 38.80528], [-121.35165, 38.80529], [-121.35177, 38.80533]]]} | Open Access 1 | 44552 | Harrigan Greens | 19695 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 1.997 | Harrigan Greens | 0 | Local Park 2 | 4 | |
14290 | 14290 | 14289 | {"type": "Polygon", "coordinates": [[[-121.35845, 38.79005], [-121.35832, 38.79005], [-121.35801, 38.78987], [-121.35768, 38.78982], [-121.35753, 38.78978], [-121.35739, 38.78972], [-121.35714, 38.78957], [-121.35687, 38.78944], [-121.35657, 38.78937], [-121.3568, 38.78856], [-121.35699, 38.78751], [-121.35759, 38.78756], [-121.35844, 38.78756], [-121.35845, 38.79005]]]} | Restricted Access 2 | 44224 | School House Park | 31647 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 8.706 | School House Park | 0 | Local Park 2 | 4 | |
12659 | 12659 | 12658 | {"type": "Polygon", "coordinates": [[[-121.28134, 38.7654], [-121.28136, 38.76557], [-121.28134, 38.76592], [-121.28135, 38.76634], [-121.28132, 38.76649], [-121.28128, 38.76661], [-121.28125, 38.76663], [-121.28121, 38.76664], [-121.28086, 38.76661], [-121.27972, 38.76663], [-121.27971, 38.76655], [-121.27919, 38.76655], [-121.27893, 38.76649], [-121.2789, 38.76545], [-121.27895, 38.76545], [-121.27897, 38.76551], [-121.27901, 38.76555], [-121.27913, 38.76557], [-121.27922, 38.76554], [-121.27926, 38.7655], [-121.27927, 38.76545], [-121.27968, 38.76545], [-121.27969, 38.76543], [-121.28089, 38.76547], [-121.28134, 38.7654]]]} | Open Access 1 | 29534 | Diamond Oaks Park | 18146 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 6.557 | Diamond Oaks Park | 0 | Local Park 2 | 4 | |
12648 | 12648 | 12647 | {"type": "Polygon", "coordinates": [[[-121.25289, 38.7212], [-121.25269, 38.72121], [-121.25269, 38.72142], [-121.25255, 38.72143], [-121.25255, 38.72224], [-121.25093, 38.72224], [-121.25087, 38.72221], [-121.25085, 38.72076], [-121.25288, 38.72077], [-121.25289, 38.7212]]]} | Open Access 1 | 29485 | Crestmont Park | 17809 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 6.387 | Crestmont Park | 0 | Local Park 2 | 4 | |
12647 | 12647 | 12646 | {"type": "Polygon", "coordinates": [[[-121.2594, 38.74656], [-121.2593, 38.74661], [-121.25925, 38.7467], [-121.25919, 38.74691], [-121.2591, 38.747], [-121.25877, 38.747], [-121.25821, 38.74694], [-121.258, 38.74697], [-121.258, 38.74604], [-121.2582, 38.74599], [-121.25828, 38.74594], [-121.25832, 38.74583], [-121.25832, 38.74568], [-121.25867, 38.74549], [-121.25883, 38.74544], [-121.25893, 38.74525], [-121.25912, 38.74525], [-121.25913, 38.7458], [-121.25914, 38.74601], [-121.25924, 38.7463], [-121.2594, 38.74656]]]} | Open Access 1 | 29482 | Marco Dog Park | 21796 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 3.975 | Marco Dog Park | 0 | Local Park 2 | 4 | |
12646 | 12646 | 12645 | {"type": "MultiPolygon", "coordinates": [[[[-121.28756, 38.7378], [-121.28714, 38.7382], [-121.28686, 38.73842], [-121.28655, 38.73872], [-121.28634, 38.7391], [-121.28621, 38.73939], [-121.2859, 38.73951], [-121.2857, 38.73966], [-121.28558, 38.73989], [-121.28541, 38.73989], [-121.2852, 38.74024], [-121.2851, 38.74025], [-121.2851, 38.74041], [-121.28509, 38.74041], [-121.28465, 38.74133], [-121.28396, 38.74288], [-121.28397, 38.74289], [-121.28403, 38.7429], [-121.28403, 38.74386], [-121.28266, 38.74384], [-121.2826, 38.74382], [-121.28258, 38.74378], [-121.28259, 38.74216], [-121.28252, 38.74214], [-121.28253, 38.7407], [-121.2834, 38.74074], [-121.28341, 38.74], [-121.28348, 38.7399], [-121.28406, 38.7399], [-121.28419, 38.7398], [-121.28419, 38.73974], [-121.28477, 38.73949], [-121.28494, 38.73905], [-121.28513, 38.73878], [-121.28578, 38.73851], [-121.28643, 38.73781], [-121.28756, 38.7378]]], [[[-121.28933, 38.73623], [-121.28922, 38.73665], [-121.28846, 38.73666], [-121.28846, 38.73686], [-121.28862, 38.73686], [-121.28856, 38.737], [-121.28856, 38.73713], [-121.28846, 38.73714], [-121.28829, 38.73733], [-121.28805, 38.73725], [-121.28753, 38.73769], [-121.28694, 38.7377], [-121.28738, 38.73735], [-121.28776, 38.73714], [-121.28804, 38.73687], [-121.2883, 38.73666], [-121.2884, 38.73666], [-121.28865, 38.73635], [-121.28875, 38.7362], [-121.28931, 38.73527], [-121.28927, 38.73609], [-121.28933, 38.73623]]]]} | Open Access 1 | 29481 | Saugstad Park | 25169 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 25.464 | Saugstad Park | 0 | Local Park 2 | 4 | |
12644 | 12644 | 12643 | {"type": "Polygon", "coordinates": [[[-121.23738, 38.7669], [-121.23737, 38.76733], [-121.23735, 38.76747], [-121.2373, 38.76762], [-121.23715, 38.76789], [-121.23692, 38.76813], [-121.23663, 38.76832], [-121.23412, 38.76962], [-121.23287, 38.76814], [-121.23345, 38.76783], [-121.23361, 38.76772], [-121.2337, 38.76762], [-121.2338, 38.76747], [-121.23387, 38.76731], [-121.23389, 38.76718], [-121.2339, 38.76685], [-121.23398, 38.76681], [-121.23398, 38.76679], [-121.23674, 38.7668], [-121.23727, 38.76682], [-121.23727, 38.76684], [-121.23733, 38.76686], [-121.23735, 38.7669], [-121.23738, 38.7669]]]} | Open Access 1 | 29479 | Harry Crabb Park | 19705 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 18.82 | Harry Crabb Park | 0 | Local Park 2 | 4 | |
12642 | 12642 | 12641 | {"type": "Polygon", "coordinates": [[[-121.23375, 38.76677], [-121.23373, 38.76704], [-121.2333, 38.76698], [-121.23292, 38.76735], [-121.23232, 38.76763], [-121.2317, 38.76788], [-121.23105, 38.76811], [-121.22949, 38.76852], [-121.22919, 38.76864], [-121.22843, 38.7688], [-121.22828, 38.76894], [-121.22805, 38.76934], [-121.22789, 38.7695], [-121.2274, 38.76968], [-121.22692, 38.76968], [-121.22675, 38.76998], [-121.22677, 38.77033], [-121.22568, 38.77034], [-121.22612, 38.76974], [-121.2261, 38.76952], [-121.22446, 38.76905], [-121.22456, 38.76889], [-121.2247, 38.76876], [-121.22482, 38.76862], [-121.22494, 38.76845], [-121.22497, 38.76835], [-121.22497, 38.76821], [-121.22493, 38.76808], [-121.22472, 38.76779], [-121.22505, 38.76765], [-121.22532, 38.76804], [-121.22568, 38.76821], [-121.22575, 38.76826], [-121.22585, 38.76841], [-121.22598, 38.76882], [-121.22593, 38.76886], [-121.22621, 38.76924], [-121.22715, 38.76899], [-121.2277, 38.76851], [-121.22791, 38.76837], [-121.22838, 38.76813], [-121.22865, 38.76804], [-121.22891, 38.76798], [-121.23007, 38.7678], [-121.23105, 38.76724], [-121.23083, 38.76692], [-121.23118, 38.76679], [-121.23147, 38.76718], [-121.23193, 38.76712], [-121.23215, 38.76691], [-121.23228, 38.76661], [-121.23231, 38.7665], [-121.23236, 38.76643], [-121.23263, 38.76653], [-121.23299, 38.76663], [-121.23335, 38.76671], [-121.23375, 38.76677]]]} | Open Access 1 | 29469 | Secret Ravine Park | 25281 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 18.508 | Secret Ravine Park | 0 | Local Park 2 | 4 | |
12641 | 12641 | 12640 | {"type": "Polygon", "coordinates": [[[-121.24502, 38.75872], [-121.24496, 38.75878], [-121.2447, 38.75881], [-121.24447, 38.75887], [-121.24429, 38.75896], [-121.24399, 38.75914], [-121.24374, 38.75926], [-121.24348, 38.75936], [-121.24299, 38.75949], [-121.24279, 38.75957], [-121.24235, 38.75977], [-121.24169, 38.76015], [-121.2414, 38.75979], [-121.23915, 38.76145], [-121.23854, 38.76172], [-121.23809, 38.76199], [-121.2378, 38.76218], [-121.23758, 38.76239], [-121.23708, 38.76296], [-121.23585, 38.76411], [-121.23562, 38.76444], [-121.23528, 38.76514], [-121.23459, 38.76562], [-121.23434, 38.76586], [-121.23412, 38.76621], [-121.23406, 38.76646], [-121.23405, 38.76658], [-121.23342, 38.76651], [-121.23314, 38.76645], [-121.23281, 38.76636], [-121.23285, 38.76629], [-121.23304, 38.76626], [-121.23321, 38.76619], [-121.23348, 38.76597], [-121.23359, 38.76581], [-121.2336, 38.76527], [-121.23419, 38.76527], [-121.23425, 38.7652], [-121.23426, 38.76478], [-121.2342, 38.76472], [-121.23425, 38.76469], [-121.23428, 38.76465], [-121.23427, 38.76455], [-121.23466, 38.76454], [-121.23499, 38.7643], [-121.23516, 38.76398], [-121.23519, 38.76378], [-121.23459, 38.76336], [-121.23428, 38.76336], [-121.23428, 38.76303], [-121.23423, 38.76289], [-121.23417, 38.76276], [-121.23504, 38.76264], [-121.23563, 38.76224], [-121.23612, 38.76226], [-121.23651, 38.76192], [-121.23653, 38.76148], [-121.2359, 38.76106], [-121.236, 38.76095], [-121.23612, 38.76087], [-121.23637, 38.76076], [-121.2367, 38.76068], [-121.23694, 38.76109], [-121.23753, 38.76086], [-121.23781, 38.76068], [-121.23951, 38.75949], [-121.24003, 38.75919], [-121.24031, 38.75908], [-121.24147, 38.75881], [-121.24147, 38.7588], [-121.24104, 38.75821], [-121.24112, 38.75808], [-121.24117, 38.75805], [-121.24161, 38.75813], [-121.24167, 38.75838], [-121.24187, 38.75871], [-121.24237, 38.7586], [-121.24282, 38.75826], [-121.24306, 38.75811], [-121.24391, 38.75776], [-121.24418, 38.75768], [-121.24484, 38.75755], [-121.24492, 38.75779], [-121.24499, 38.75811], [-121.24502, 38.75872]]]} | Open Access 1 | 29468 | False Ravine Park | 18840 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 44.406 | False Ravine Park | 0 | Local Park 2 | 4 | |
12640 | 12640 | 12639 | {"type": "Polygon", "coordinates": [[[-121.27515, 38.75394], [-121.27379, 38.75397], [-121.27323, 38.75423], [-121.27256, 38.75336], [-121.27242, 38.75326], [-121.27147, 38.75324], [-121.27081, 38.75361], [-121.27047, 38.75404], [-121.27048, 38.75274], [-121.27131, 38.7524], [-121.27181, 38.75204], [-121.27232, 38.75203], [-121.27233, 38.75259], [-121.27515, 38.75257], [-121.27515, 38.75394]]]} | Open Access 1 | 29466 | William L. Taylor Park | 27548 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 13.609 | William L. Taylor Park | 0 | Local Park 2 | 4 | |
12638 | 12638 | 12637 | {"type": "Polygon", "coordinates": [[[-121.32235, 38.77502], [-121.3223, 38.77522], [-121.32183, 38.77515], [-121.32143, 38.77515], [-121.32093, 38.77498], [-121.3209, 38.77459], [-121.32073, 38.77439], [-121.32028, 38.77427], [-121.3203, 38.77396], [-121.32003, 38.77396], [-121.31987, 38.77404], [-121.31981, 38.774], [-121.32012, 38.77377], [-121.32012, 38.77376], [-121.32002, 38.7737], [-121.3197, 38.77371], [-121.3194, 38.77368], [-121.31886, 38.77347], [-121.31851, 38.77309], [-121.31834, 38.77284], [-121.31806, 38.77272], [-121.31778, 38.7728], [-121.31726, 38.77267], [-121.31716, 38.77296], [-121.31683, 38.77291], [-121.31615, 38.77284], [-121.31597, 38.7728], [-121.31579, 38.7727], [-121.31567, 38.77257], [-121.31561, 38.77242], [-121.31561, 38.7724], [-121.31565, 38.77236], [-121.31601, 38.77225], [-121.31646, 38.77209], [-121.31704, 38.77184], [-121.31745, 38.77162], [-121.31775, 38.77144], [-121.31832, 38.77103], [-121.31878, 38.7714], [-121.31909, 38.77184], [-121.31935, 38.77202], [-121.31952, 38.77225], [-121.31994, 38.77213], [-121.32013, 38.77274], [-121.32024, 38.7729], [-121.32039, 38.77303], [-121.32013, 38.77326], [-121.32037, 38.77349], [-121.32181, 38.77371], [-121.32205, 38.77382], [-121.32225, 38.77407], [-121.32193, 38.77492], [-121.32235, 38.77502]]]} | Open Access 1 | 29455 | Misty Wood Park | 22322 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 19.608 | Misty Wood Park | 0 | Local Park 2 | 4 | |
12633 | 12633 | 12632 | {"type": "Polygon", "coordinates": [[[-121.33558, 38.77485], [-121.33557, 38.77538], [-121.33532, 38.77535], [-121.33505, 38.77534], [-121.33478, 38.77535], [-121.33455, 38.7754], [-121.33429, 38.77547], [-121.33406, 38.77557], [-121.33384, 38.77569], [-121.33364, 38.77585], [-121.33255, 38.77481], [-121.33216, 38.77437], [-121.33272, 38.77405], [-121.33283, 38.77396], [-121.33295, 38.77379], [-121.33326, 38.77379], [-121.33351, 38.77377], [-121.33386, 38.77451], [-121.33399, 38.77449], [-121.334, 38.77464], [-121.33475, 38.77469], [-121.33477, 38.77456], [-121.33508, 38.77459], [-121.33508, 38.77466], [-121.33525, 38.77467], [-121.3354, 38.77477], [-121.33547, 38.77477], [-121.33558, 38.77485]]]} | Open Access 1 | 29454 | Robert L. Doyle Park | 24490 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 7.987 | Robert L. Doyle Park | 0 | Local Park 2 | 4 | |
12632 | 12632 | 12631 | {"type": "Polygon", "coordinates": [[[-121.33004, 38.80349], [-121.33001, 38.80378], [-121.32951, 38.80379], [-121.3295, 38.80433], [-121.32959, 38.80456], [-121.32963, 38.80473], [-121.32929, 38.80473], [-121.32924, 38.80477], [-121.32924, 38.80497], [-121.32934, 38.80541], [-121.32933, 38.80565], [-121.329, 38.80558], [-121.32867, 38.80546], [-121.32716, 38.80474], [-121.32736, 38.80433], [-121.32762, 38.80403], [-121.32763, 38.80357], [-121.32678, 38.803], [-121.32671, 38.80301], [-121.32645, 38.80325], [-121.32646, 38.80331], [-121.32634, 38.80335], [-121.32604, 38.80315], [-121.32597, 38.80315], [-121.32549, 38.80367], [-121.32526, 38.80412], [-121.32454, 38.80436], [-121.32429, 38.80448], [-121.32406, 38.80461], [-121.32365, 38.80493], [-121.32348, 38.80511], [-121.32333, 38.8053], [-121.32283, 38.80627], [-121.3226, 38.80646], [-121.32225, 38.80658], [-121.32206, 38.8068], [-121.32204, 38.80704], [-121.32242, 38.80776], [-121.32257, 38.8078], [-121.32256, 38.80784], [-121.32257, 38.80789], [-121.32265, 38.80794], [-121.32258, 38.80806], [-121.32274, 38.80834], [-121.323, 38.80861], [-121.32324, 38.80865], [-121.32327, 38.80863], [-121.32337, 38.80866], [-121.32344, 38.80865], [-121.32351, 38.8086], [-121.32354, 38.80852], [-121.32357, 38.80848], [-121.32375, 38.80834], [-121.32381, 38.80832], [-121.32415, 38.80851], [-121.32439, 38.80861], [-121.32468, 38.80869], [-121.32494, 38.80874], [-121.32532, 38.80876], [-121.32666, 38.8087], [-121.32671, 38.80873], [-121.32672, 38.80881], [-121.32671, 38.80922], [-121.32668, 38.80928], [-121.32668, 38.80934], [-121.32673, 38.80942], [-121.32679, 38.80945], [-121.32685, 38.80946], [-121.32675, 38.80972], [-121.3268, 38.80977], [-121.32693, 38.80985], [-121.3271, 38.80988], [-121.32987, 38.80987], [-121.32987, 38.81003], [-121.32676, 38.81004], [-121.32606, 38.80908], [-121.32259, 38.80908], [-121.32238, 38.80893], [-121.32239, 38.80784], [-121.32198, 38.80731], [-121.32199, 38.80648], [-121.32291, 38.80567], [-121.32329, 38.80496], [-121.32275, 38.80452], [-121.32311, 38.80415], [-121.32451, 38.8043], [-121.32502, 38.80412], [-121.32596, 38.80303], [-121.32666, 38.80275], [-121.32756, 38.80283], [-121.32831, 38.80358], [-121.32981, 38.80359], [-121.32983, 38.80315], [-121.33004, 38.80349]]]} | Open Access 1 | 29452 | Dr Paul J Dugan Park | 18263 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 22.134 | Dr Paul J Dugan Park | 0 | Local Park 2 | 4 | |
12626 | 12626 | 12625 | {"type": "Polygon", "coordinates": [[[-121.26237, 38.75515], [-121.26208, 38.75534], [-121.26154, 38.75545], [-121.26146, 38.75549], [-121.26132, 38.75524], [-121.26189, 38.75488], [-121.26206, 38.75493], [-121.26237, 38.75515]]]} | Open Access 1 | 29477 | Sculpture Park | 25220 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 0.815 | Sculpture Park | 0 | Local Park 2 | 4 | |
12625 | 12625 | 12624 | {"type": "Polygon", "coordinates": [[[-121.2488, 38.75554], [-121.24795, 38.75599], [-121.24775, 38.75603], [-121.24729, 38.75548], [-121.24815, 38.75497], [-121.24838, 38.7552], [-121.2488, 38.75554]]]} | Open Access 1 | 29475 | John Piches Park | 20462 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 1.981 | John Piches Park | 0 | Local Park 2 | 4 | |
12617 | 12617 | 12616 | {"type": "Polygon", "coordinates": [[[-121.35653, 38.7572], [-121.35652, 38.75723], [-121.35638, 38.75744], [-121.35619, 38.75768], [-121.35508, 38.75889], [-121.35308, 38.75775], [-121.35457, 38.75615], [-121.3546, 38.75621], [-121.35466, 38.75625], [-121.35474, 38.75626], [-121.35483, 38.75624], [-121.35492, 38.75626], [-121.3565, 38.75716], [-121.35653, 38.7572]]]} | Open Access 1 | 29443 | Bill Santucci Park | 16112 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 11.977 | Bill Santucci Park | 0 | Local Park 2 | 4 | |
12464 | 12464 | 12463 | {"type": "Polygon", "coordinates": [[[-121.23271, 38.75219], [-121.23154, 38.75352], [-121.23154, 38.75353], [-121.23185, 38.75369], [-121.23132, 38.75434], [-121.23097, 38.75418], [-121.23058, 38.75403], [-121.23016, 38.75392], [-121.22977, 38.75386], [-121.22993, 38.75339], [-121.23034, 38.75346], [-121.2304, 38.75322], [-121.23049, 38.75273], [-121.23058, 38.75271], [-121.23064, 38.75264], [-121.23064, 38.75259], [-121.23062, 38.75254], [-121.23053, 38.7525], [-121.2306, 38.75219], [-121.23271, 38.75219]]]} | Open Access 1 | 48763 | Waltrip Park | 33490 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | https://www.roseville.ca.us/cms/One.aspx?portalId=7964922&pageId=10993299 | Placer 35 | 7.777 | Waltrip Park | 0 | Local Park 2 | 4 |
12463 | 12463 | 12462 | {"type": "Polygon", "coordinates": [[[-121.37341, 38.77033], [-121.37244, 38.77128], [-121.3699, 38.76952], [-121.37086, 38.76865], [-121.37341, 38.77033]]]} | Open Access 1 | 48762 | Mahan Park | 33489 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | https://www.roseville.ca.us/government/departments/parks/parks_places/mahan_park | Placer 35 | 9.505 | Mahan Park | 0 | Local Park 2 | 4 |
12462 | 12462 | 12461 | {"type": "Polygon", "coordinates": [[[-121.32842, 38.79859], [-121.32841, 38.7991], [-121.32835, 38.79916], [-121.32623, 38.79916], [-121.32624, 38.79857], [-121.32842, 38.79859]]]} | Open Access 1 | 48761 | Walter and Doris Rickey Park | 33488 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 3.029 | Walter and Doris Rickey Park | 0 | Local Park 2 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([id]), FOREIGN KEY([MNG_AGENCY]) REFERENCES [MNG_AGENCY]([id]), FOREIGN KEY([MNG_AG_LEV]) REFERENCES [MNG_AG_LEV]([id]), FOREIGN KEY([MNG_AG_TYP]) REFERENCES [MNG_AG_TYP]([id]), FOREIGN KEY([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);