units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
130 rows where MNG_AGENCY = 533 and MNG_AG_TYP = 2 sorted by LABEL_NAME
This data as json, copyable, CSV (advanced)
DES_TP 9
- Local Park 53
- Local Other or Unknown 45
- Local Recreation Area 4
- Local Conservation Area 3
- None 1
- None 1
- None 1
- None 1
- None 1
ACCESS_TYP 3
MNG_AG_TYP 1
- City Agency · 110 ✖
MNG_AGENCY 1
- Roseville, City of · 110 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3636 | 3636 | 3635 | {"type": "Polygon", "coordinates": [[[-121.2735, 38.793], [-121.2735, 38.793], [-121.27194, 38.79238], [-121.27218, 38.79202], [-121.2723, 38.79191], [-121.27246, 38.79182], [-121.27265, 38.79175], [-121.27284, 38.79173], [-121.27305, 38.79174], [-121.27326, 38.79179], [-121.27343, 38.79187], [-121.27359, 38.792], [-121.2737, 38.79214], [-121.27376, 38.79231], [-121.27377, 38.79243], [-121.27374, 38.7926], [-121.27369, 38.7927], [-121.2735, 38.793]]]} | Open Access 1 | 29460 | Del Stephenson Park | 18056 | 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.526 | Del Stephenson Park | 0 | Local Park 2 | 4 | |
2641 | 2641 | 2640 | {"type": "Polygon", "coordinates": [[[-121.3441, 38.77738], [-121.34408, 38.77766], [-121.34393, 38.77766], [-121.34396, 38.77738], [-121.3441, 38.77738]]]} | Open Access 1 | 20860 | Diamond Oaks | 18143 | 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.102 | Diamond Oaks | None 218 | |||
15713 | 15713 | 15712 | {"type": "Polygon", "coordinates": [[[-121.2973, 38.77105], [-121.29627, 38.77371], [-121.29594, 38.77403], [-121.29577, 38.77402], [-121.29576, 38.77359], [-121.29542, 38.77352], [-121.29546, 38.77342], [-121.29591, 38.77321], [-121.29601, 38.77268], [-121.2955, 38.77257], [-121.29562, 38.77115], [-121.29349, 38.77107], [-121.29137, 38.77075], [-121.29084, 38.77092], [-121.29032, 38.77139], [-121.28966, 38.77215], [-121.28931, 38.77274], [-121.28892, 38.77308], [-121.28835, 38.77325], [-121.28818, 38.77293], [-121.28885, 38.77244], [-121.28935, 38.77178], [-121.28959, 38.77131], [-121.28809, 38.7716], [-121.28649, 38.77128], [-121.28652, 38.77291], [-121.28546, 38.77328], [-121.28462, 38.77144], [-121.28459, 38.76955], [-121.28436, 38.76929], [-121.28281, 38.77027], [-121.28139, 38.7708], [-121.28093, 38.7708], [-121.28071, 38.77166], [-121.28002, 38.77322], [-121.27909, 38.77296], [-121.27906, 38.77121], [-121.27965, 38.77107], [-121.27963, 38.76941], [-121.27856, 38.76711], [-121.27973, 38.76678], [-121.28008, 38.76721], [-121.28113, 38.76857], [-121.28131, 38.76955], [-121.28279, 38.76867], [-121.28443, 38.76812], [-121.28496, 38.76747], [-121.28522, 38.76753], [-121.28546, 38.76755], [-121.28633, 38.76749], [-121.28662, 38.7675], [-121.28693, 38.76756], [-121.28685, 38.76785], [-121.28844, 38.76817], [-121.29064, 38.76944], [-121.2926, 38.76935], [-121.29565, 38.76984], [-121.29572, 38.76949], [-121.29698, 38.76923], [-121.2973, 38.77105]]]} | Restricted Access 2 | 29458 | Diamond Oaks Golf Course | 33092 | 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 | 121.659 | Diamond Oaks GC | 0 | Local Recreation Area 3 | 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 | |
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 | |
10922 | 10922 | 10921 | {"type": "Polygon", "coordinates": [[[-121.27901, 38.73239], [-121.2788, 38.73232], [-121.27873, 38.73243], [-121.27892, 38.73251], [-121.27869, 38.73277], [-121.27831, 38.73283], [-121.2775, 38.73351], [-121.27583, 38.73453], [-121.27563, 38.73433], [-121.27536, 38.73447], [-121.27526, 38.73461], [-121.27509, 38.73456], [-121.27482, 38.73439], [-121.27458, 38.73409], [-121.2743, 38.73402], [-121.27367, 38.73381], [-121.27264, 38.73401], [-121.27218, 38.73396], [-121.27218, 38.73383], [-121.27261, 38.73373], [-121.27368, 38.73368], [-121.27409, 38.73372], [-121.27464, 38.73387], [-121.27487, 38.73406], [-121.27508, 38.73426], [-121.2757, 38.73391], [-121.27672, 38.73326], [-121.27699, 38.73311], [-121.27698, 38.7331], [-121.27618, 38.7331], [-121.27618, 38.73276], [-121.27621, 38.73272], [-121.27623, 38.73267], [-121.27618, 38.73256], [-121.27616, 38.73239], [-121.27618, 38.73213], [-121.2762, 38.73209], [-121.27624, 38.73208], [-121.27729, 38.73207], [-121.27747, 38.73203], [-121.27776, 38.73191], [-121.2778, 38.73193], [-121.278, 38.7321], [-121.27828, 38.73226], [-121.27835, 38.73232], [-121.27843, 38.73235], [-121.27851, 38.73236], [-121.27858, 38.73234], [-121.27865, 38.73229], [-121.27868, 38.73225], [-121.2787, 38.73217], [-121.27882, 38.73201], [-121.27888, 38.73194], [-121.27899, 38.73186], [-121.27901, 38.73239]], [[-121.27652, 38.73374], [-121.27652, 38.73373], [-121.27648, 38.7337], [-121.27631, 38.73384], [-121.27636, 38.73386], [-121.27652, 38.73374]]]} | Open Access 1 | 20927 | Eastwood Park | 18403 | 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.18 | Eastwood 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 | |
3050 | 3050 | 3049 | {"type": "MultiPolygon", "coordinates": [[[[-121.24452, 38.72086], [-121.24452, 38.72174], [-121.24392, 38.72198], [-121.24348, 38.72211], [-121.243, 38.72216], [-121.24087, 38.72215], [-121.24088, 38.72187], [-121.24142, 38.72131], [-121.24229, 38.72048], [-121.2424, 38.72035], [-121.24247, 38.72024], [-121.24255, 38.72001], [-121.24256, 38.71981], [-121.24243, 38.71901], [-121.24317, 38.71934], [-121.24452, 38.72086]]], [[[-121.24324, 38.72673], [-121.24287, 38.72694], [-121.24263, 38.72659], [-121.24242, 38.72641], [-121.24196, 38.72561], [-121.24212, 38.7254], [-121.24228, 38.7254], [-121.24235, 38.72544], [-121.24262, 38.72546], [-121.24261, 38.72582], [-121.24268, 38.72605], [-121.24282, 38.72626], [-121.24324, 38.72673]]], [[[-121.24705, 38.72776], [-121.24669, 38.72806], [-121.24614, 38.7276], [-121.24538, 38.7271], [-121.24461, 38.72713], [-121.24464, 38.72905], [-121.24408, 38.72926], [-121.24395, 38.72917], [-121.24386, 38.72913], [-121.24372, 38.7291], [-121.24358, 38.7291], [-121.24358, 38.72874], [-121.24324, 38.72824], [-121.24342, 38.72813], [-121.24353, 38.72797], [-121.24366, 38.72722], [-121.24366, 38.72705], [-121.24361, 38.7269], [-121.24353, 38.7268], [-121.2429, 38.72609], [-121.24281, 38.72588], [-121.2428, 38.7257], [-121.24283, 38.72526], [-121.24329, 38.72527], [-121.24334, 38.72506], [-121.2433, 38.72484], [-121.24337, 38.72448], [-121.24365, 38.72414], [-121.24385, 38.72389], [-121.24388, 38.72355], [-121.24381, 38.72292], [-121.24399, 38.72224], [-121.24462, 38.72224], [-121.24462, 38.72236], [-121.24444, 38.72249], [-121.24437, 38.72277], [-121.24432, 38.72287], [-121.2443, 38.72308], [-121.24453, 38.72352], [-121.24447, 38.72389], [-121.24432, 38.7242], [-121.24392, 38.72447], [-121.2439, 38.72451], [-121.24388, 38.72482], [-121.24387, 38.72589], [-121.24392, 38.72603], [-121.24398, 38.72612], [-121.2441, 38.72622], [-121.24423, 38.72622], [-121.24505, 38.72665], [-121.2456, 38.72668], [-121.2461, 38.72696], [-121.24705, 38.72776]]], [[[-121.24936, 38.72958], [-121.24879, 38.72974], [-121.24869, 38.72944], [-121.2471, 38.72837], [-121.24684, 38.72817], [-121.24721, 38.72788], [-121.24746, 38.72807], [-121.24913, 38.72919], [-121.24936, 38.72958]]]]} | Open Access 1 | 20932 | Flood Control | 18952 | 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 | 37.251 | Flood Control | 0 | Local Other or Unknown 14 | 4 | |
10918 | 10918 | 10917 | {"type": "Polygon", "coordinates": [[[-121.28931, 38.73527], [-121.28926, 38.73535], [-121.28919, 38.73532], [-121.28927, 38.73501], [-121.28923, 38.73477], [-121.28889, 38.73486], [-121.28886, 38.73484], [-121.2892, 38.73473], [-121.28893, 38.73434], [-121.28848, 38.73416], [-121.28827, 38.73404], [-121.28811, 38.73391], [-121.28768, 38.73376], [-121.28769, 38.73373], [-121.28697, 38.73301], [-121.28696, 38.73287], [-121.28596, 38.73286], [-121.28595, 38.73305], [-121.28563, 38.73306], [-121.28482, 38.73357], [-121.2845, 38.73363], [-121.28378, 38.73346], [-121.28357, 38.73328], [-121.28339, 38.73323], [-121.28305, 38.73259], [-121.2832, 38.73219], [-121.2832, 38.73179], [-121.28349, 38.73159], [-121.28366, 38.73137], [-121.28382, 38.73123], [-121.28412, 38.73154], [-121.28378, 38.73159], [-121.28366, 38.73184], [-121.28366, 38.73285], [-121.28421, 38.7332], [-121.28441, 38.73322], [-121.28474, 38.73313], [-121.28474, 38.73306], [-121.28486, 38.73306], [-121.28508, 38.73292], [-121.28537, 38.73268], [-121.28574, 38.73246], [-121.28582, 38.73234], [-121.28596, 38.73234], [-121.28597, 38.73238], [-121.2864, 38.73239], [-121.28691, 38.73245], [-121.28733, 38.73266], [-121.28753, 38.73284], [-121.2878, 38.73301], [-121.28786, 38.73307], [-121.28825, 38.7333], [-121.28826, 38.73334], [-121.28844, 38.73337], [-121.28862, 38.73345], [-121.28884, 38.73347], [-121.28928, 38.73373], [-121.28931, 38.73527]]]} | Open Access 1 | 20924 | Flood Control | 18952 | 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 | 10.315 | Flood Control | 0 | Local Other or Unknown 14 | 4 | |
4096 | 4096 | 4095 | {"type": "Polygon", "coordinates": [[[-121.36411, 38.77865], [-121.36211, 38.77865], [-121.36211, 38.77832], [-121.36206, 38.77773], [-121.36206, 38.77704], [-121.36204, 38.77703], [-121.36206, 38.77698], [-121.36209, 38.77695], [-121.36214, 38.77694], [-121.36326, 38.77694], [-121.36351, 38.77693], [-121.36375, 38.77689], [-121.36411, 38.77678], [-121.36411, 38.77865]]]} | Open Access 1 | 44551 | Fred Festersen Park | 19074 | 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.398 | Fred Festersen Park | 0 | Local Park 2 | 4 | |
10915 | 10915 | 10914 | {"type": "Polygon", "coordinates": [[[-121.27631, 38.74104], [-121.27637, 38.74105], [-121.27689, 38.74135], [-121.27712, 38.74146], [-121.27775, 38.74169], [-121.27777, 38.74174], [-121.27776, 38.7422], [-121.27774, 38.74223], [-121.27767, 38.74226], [-121.27718, 38.74225], [-121.27631, 38.74215], [-121.27626, 38.74213], [-121.27624, 38.74208], [-121.27624, 38.7411], [-121.27626, 38.74106], [-121.27631, 38.74104]]]} | Open Access 1 | 20919 | Garbolino Park | 19190 | 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.058 | Garbolino Park | 0 | Local Park 2 | 4 | |
3625 | 3625 | 3624 | {"type": "Polygon", "coordinates": [[[-121.23567, 38.76043], [-121.23447, 38.76115], [-121.23515, 38.76186], [-121.23484, 38.762], [-121.23451, 38.76206], [-121.23424, 38.76215], [-121.23403, 38.76226], [-121.23382, 38.76241], [-121.23376, 38.76241], [-121.23359, 38.76234], [-121.23358, 38.7624], [-121.23339, 38.76233], [-121.23322, 38.76224], [-121.23306, 38.7621], [-121.23248, 38.76151], [-121.23439, 38.76039], [-121.23427, 38.75995], [-121.23329, 38.75891], [-121.23395, 38.75854], [-121.23567, 38.76043]]]} | Open Access 1 | 29473 | George Goto Park | 19266 | 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.672 | George Goto Park | 0 | Local Park 2 | 4 | |
10908 | 10908 | 10907 | {"type": "Polygon", "coordinates": [[[-121.34235, 38.75638], [-121.34232, 38.75641], [-121.34232, 38.75703], [-121.34234, 38.75706], [-121.34229, 38.75713], [-121.3423, 38.75721], [-121.34225, 38.75723], [-121.34225, 38.75766], [-121.34206, 38.75775], [-121.34193, 38.75784], [-121.34169, 38.75804], [-121.34127, 38.75784], [-121.34105, 38.75768], [-121.34084, 38.75747], [-121.34068, 38.75721], [-121.34061, 38.75702], [-121.34057, 38.75681], [-121.34058, 38.75567], [-121.34062, 38.75563], [-121.34066, 38.75562], [-121.34232, 38.75563], [-121.34232, 38.7562], [-121.34235, 38.75623], [-121.34232, 38.75631], [-121.34235, 38.75638]]]} | Open Access 1 | 20896 | H.C. Elliot Park | 19583 | 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.627 | H.C. Elliot 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 | |
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 | |
10929 | 10929 | 10928 | {"type": "Polygon", "coordinates": [[[-121.22577, 38.73138], [-121.22577, 38.73238], [-121.2235, 38.73236], [-121.22286, 38.73217], [-121.2221, 38.73211], [-121.2221, 38.73192], [-121.22212, 38.73176], [-121.22224, 38.73147], [-121.22228, 38.73131], [-121.22238, 38.73114], [-121.22268, 38.73073], [-121.22275, 38.73069], [-121.22281, 38.7307], [-121.22317, 38.73083], [-121.22352, 38.73094], [-121.22415, 38.73109], [-121.22471, 38.73117], [-121.22489, 38.73121], [-121.22561, 38.73123], [-121.22572, 38.73129], [-121.22577, 38.73138]]]} | Open Access 1 | 20941 | Hillsborough Park | 19976 | 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 | 10.773 | Hillsborough Park | 0 | Local Park 2 | 4 | |
10901 | 10901 | 10900 | {"type": "Polygon", "coordinates": [[[-121.31804, 38.75775], [-121.31713, 38.75822], [-121.31682, 38.75837], [-121.31629, 38.75858], [-121.31573, 38.75875], [-121.31504, 38.75891], [-121.31443, 38.759], [-121.31396, 38.75904], [-121.31348, 38.75905], [-121.31343, 38.75904], [-121.31339, 38.759], [-121.31341, 38.75865], [-121.31345, 38.7585], [-121.3135, 38.75837], [-121.31358, 38.75823], [-121.31369, 38.75809], [-121.31397, 38.75784], [-121.31458, 38.75829], [-121.31596, 38.7574], [-121.31702, 38.75682], [-121.31804, 38.75775]]]} | Open Access 1 | 20892 | JAMES W. WANISH PARK | 20354 | 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.213 | JAMES W. WANISH PARK | None 950 | |||
10900 | 10900 | 10899 | {"type": "Polygon", "coordinates": [[[-121.33031, 38.75424], [-121.33027, 38.75428], [-121.32987, 38.75429], [-121.32986, 38.75538], [-121.32913, 38.75519], [-121.32896, 38.75513], [-121.32875, 38.75502], [-121.32837, 38.75476], [-121.32797, 38.7546], [-121.32792, 38.75455], [-121.32793, 38.7545], [-121.32819, 38.75407], [-121.32825, 38.75403], [-121.32874, 38.75417], [-121.32889, 38.75419], [-121.3291, 38.75419], [-121.32942, 38.75414], [-121.32993, 38.75394], [-121.32997, 38.75396], [-121.33016, 38.75414], [-121.33031, 38.75424]]]} | Open Access 1 | 20891 | James A. Hall Park | 20341 | 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 | 4.361 | James A. Hall 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 | |
10906 | 10906 | 10905 | {"type": "Polygon", "coordinates": [[[-121.30716, 38.75279], [-121.30714, 38.75468], [-121.30669, 38.75477], [-121.30648, 38.75479], [-121.3063, 38.75479], [-121.30601, 38.75474], [-121.30582, 38.75473], [-121.30319, 38.75473], [-121.30315, 38.75472], [-121.30313, 38.75469], [-121.30314, 38.75393], [-121.3034, 38.75392], [-121.30343, 38.75346], [-121.30456, 38.75345], [-121.30457, 38.75284], [-121.30485, 38.75284], [-121.30487, 38.7526], [-121.30597, 38.75261], [-121.30599, 38.75276], [-121.30716, 38.75279]]]} | Open Access 1 | 20889 | Kaseberg Park | 20556 | 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 | 16.595 | Kaseberg 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]);