units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
130 rows where MNG_AGENCY = 533 sorted by UNIT_ID
This data as json, copyable, CSV (advanced)
DES_TP 7
- Local Park 52
- Local Other or Unknown 46
- Local Recreation Area 7
- Local Conservation Area 2
- 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
10907 | 10907 | 10906 | {"type": "Polygon", "coordinates": [[[-121.32986, 38.7569], [-121.32985, 38.75807], [-121.32812, 38.75774], [-121.32808, 38.75736], [-121.32766, 38.75738], [-121.32737, 38.75735], [-121.32686, 38.75718], [-121.32704, 38.75685], [-121.32717, 38.75645], [-121.3272, 38.75642], [-121.32725, 38.7564], [-121.32986, 38.7569]]]} | Open Access 1 | 20893 | Paul Lunardi Park | 23531 | 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.116 | Paul Lunardi 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 | |
10910 | 10910 | 10909 | {"type": "Polygon", "coordinates": [[[-121.28143, 38.75753], [-121.28031, 38.7582], [-121.27963, 38.7575], [-121.28075, 38.75684], [-121.28143, 38.75753]]]} | Open Access 1 | 20899 | Woodbridge Park | 27687 | 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 | 2.938 | Woodbridge Park | 0 | Local Park 2 | 4 | |
2645 | 2645 | 2644 | {"type": "Polygon", "coordinates": [[[-121.27306, 38.75203], [-121.27181, 38.75204], [-121.27181, 38.75184], [-121.27082, 38.75101], [-121.27076, 38.75092], [-121.27152, 38.75045], [-121.2716, 38.75057], [-121.27169, 38.75052], [-121.27177, 38.75059], [-121.27186, 38.75064], [-121.27206, 38.75069], [-121.27228, 38.75067], [-121.27264, 38.75054], [-121.27306, 38.75203]]]} | Open Access 1 | 20901 | Lincoln Estates Park | 21248 | 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 | 5.411 | Lincoln Estates Park | 0 | Local Park 2 | 4 | |
10911 | 10911 | 10910 | {"type": "Polygon", "coordinates": [[[-121.27603, 38.78552], [-121.27597, 38.78561], [-121.2759, 38.78566], [-121.27561, 38.78584], [-121.27527, 38.78597], [-121.2749, 38.78607], [-121.27452, 38.78613], [-121.27404, 38.78616], [-121.27345, 38.78617], [-121.27316, 38.78614], [-121.27271, 38.78661], [-121.27261, 38.7867], [-121.27241, 38.78681], [-121.27226, 38.78686], [-121.27211, 38.78688], [-121.27194, 38.78688], [-121.27177, 38.78686], [-121.27162, 38.78681], [-121.27149, 38.78675], [-121.27134, 38.78664], [-121.27106, 38.78634], [-121.27107, 38.78628], [-121.27098, 38.78629], [-121.27091, 38.78632], [-121.27019, 38.78602], [-121.26991, 38.78607], [-121.26991, 38.786], [-121.26995, 38.78591], [-121.26994, 38.78586], [-121.26988, 38.78579], [-121.26979, 38.78576], [-121.26963, 38.78578], [-121.26905, 38.78577], [-121.26881, 38.78579], [-121.26857, 38.78582], [-121.26805, 38.78593], [-121.26783, 38.78593], [-121.26776, 38.78596], [-121.26729, 38.78599], [-121.26721, 38.78607], [-121.26697, 38.78664], [-121.26684, 38.78648], [-121.26707, 38.78593], [-121.26736, 38.78575], [-121.26862, 38.78553], [-121.26945, 38.78548], [-121.26981, 38.78552], [-121.2708, 38.78601], [-121.27134, 38.78606], [-121.27207, 38.78582], [-121.27242, 38.78581], [-121.27348, 38.78594], [-121.274, 38.78597], [-121.27441, 38.78594], [-121.2749, 38.78586], [-121.27564, 38.78562], [-121.27583, 38.78542], [-121.27603, 38.78552]]]} | Open Access 1 | 20909 | Melba And William Erven Park | 22107 | 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.15 | Melba And William Erven Park | 0 | Local Park 2 | 4 | |
10912 | 10912 | 10911 | {"type": "Polygon", "coordinates": [[[-121.29644, 38.75001], [-121.29609, 38.75022], [-121.29585, 38.74981], [-121.29616, 38.74994], [-121.29644, 38.75001]]]} | Open Access 1 | 20913 | Shirley Ferretti Park | 25415 | 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.216 | Shirley Ferretti Park | 0 | Local Park 2 | 4 | |
10913 | 10913 | 10912 | {"type": "Polygon", "coordinates": [[[-121.29803, 38.7269], [-121.29665, 38.7269], [-121.29661, 38.72687], [-121.29659, 38.72684], [-121.29664, 38.72603], [-121.29671, 38.72579], [-121.29673, 38.72567], [-121.29803, 38.72567], [-121.29803, 38.7269]]]} | Open Access 1 | 20916 | Cresthaven Park | 17806 | 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.084 | Cresthaven Park | 0 | Local Park 2 | 4 | |
10914 | 10914 | 10913 | {"type": "Polygon", "coordinates": [[[-121.28444, 38.7455], [-121.28427, 38.74563], [-121.28444, 38.74577], [-121.28392, 38.74617], [-121.28383, 38.74643], [-121.28377, 38.74648], [-121.28365, 38.74671], [-121.284, 38.747], [-121.28398, 38.74709], [-121.28391, 38.74718], [-121.28304, 38.74792], [-121.28206, 38.74768], [-121.28214, 38.74735], [-121.28233, 38.74448], [-121.28252, 38.74407], [-121.28257, 38.74405], [-121.28339, 38.74399], [-121.28372, 38.74399], [-121.28374, 38.7448], [-121.28366, 38.74487], [-121.28444, 38.7455]]]} | Open Access 1 | 20917 | Royer Park | 24718 | 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 | 14.77 | Royer 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 | |
10916 | 10916 | 10915 | {"type": "Polygon", "coordinates": [[[-121.23266, 38.74778], [-121.233, 38.74779], [-121.2333, 38.74783], [-121.23366, 38.74792], [-121.23379, 38.74796], [-121.23383, 38.748], [-121.23383, 38.74804], [-121.23346, 38.74887], [-121.23333, 38.74911], [-121.23319, 38.7493], [-121.233, 38.7495], [-121.23282, 38.74966], [-121.23254, 38.74984], [-121.23211, 38.74997], [-121.23183, 38.74985], [-121.23182, 38.74973], [-121.23141, 38.74972], [-121.23143, 38.74887], [-121.23092, 38.74887], [-121.23091, 38.74866], [-121.23115, 38.74854], [-121.2312, 38.74846], [-121.23117, 38.7484], [-121.231, 38.74823], [-121.23195, 38.74789], [-121.23228, 38.74782], [-121.23266, 38.74778]]]} | Open Access 1 | 20921 | Olympus Park | 23141 | 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 | 9.909 | Olympus Park | 0 | Local Park 2 | 4 | |
10917 | 10917 | 10916 | {"type": "Polygon", "coordinates": [[[-121.28958, 38.73527], [-121.2895, 38.73568], [-121.28937, 38.73609], [-121.28927, 38.73609], [-121.28931, 38.73527], [-121.28958, 38.73527]]]} | Open Access 1 | 20922 | SAUGSTAD PARK | 25170 | 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.397 | SAUGSTAD PARK | None 952 | |||
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 | |
10919 | 10919 | 10918 | {"type": "Polygon", "coordinates": [[[-121.27803, 38.72429], [-121.27768, 38.72463], [-121.27752, 38.7245], [-121.27731, 38.72422], [-121.27719, 38.72411], [-121.27719, 38.72409], [-121.27725, 38.72397], [-121.27728, 38.72386], [-121.2778, 38.72386], [-121.27781, 38.72414], [-121.27803, 38.72429]]]} | Open Access 1 | 20925 | Kenwood Oaks Park | 20623 | 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.887 | Kenwood Oaks Park | 0 | Local Park 2 | 4 | |
10921 | 10921 | 10920 | {"type": "Polygon", "coordinates": [[[-121.27193, 38.72703], [-121.2719, 38.72707], [-121.27185, 38.72708], [-121.27094, 38.72708], [-121.2707, 38.72705], [-121.27051, 38.72697], [-121.27035, 38.72685], [-121.27024, 38.72671], [-121.27019, 38.72654], [-121.27018, 38.72645], [-121.27021, 38.72612], [-121.2707, 38.72615], [-121.27071, 38.72557], [-121.27122, 38.72527], [-121.27144, 38.72505], [-121.27154, 38.72489], [-121.27192, 38.72489], [-121.27193, 38.72703]]]} | Open Access 1 | 20926 | Sun Tree Park | 25979 | 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.473 | Sun Tree 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 | |
10926 | 10926 | 10925 | {"type": "MultiPolygon", "coordinates": [[[[-121.2536, 38.73338], [-121.25359, 38.73673], [-121.25357, 38.73677], [-121.25353, 38.73678], [-121.24938, 38.73679], [-121.24936, 38.73636], [-121.24627, 38.73635], [-121.24626, 38.73637], [-121.24688, 38.73754], [-121.24758, 38.73808], [-121.24734, 38.73832], [-121.24707, 38.73853], [-121.24673, 38.73873], [-121.24639, 38.73886], [-121.24604, 38.73896], [-121.24427, 38.7393], [-121.24407, 38.73931], [-121.24386, 38.7393], [-121.24371, 38.73928], [-121.24352, 38.73921], [-121.24325, 38.73907], [-121.24315, 38.73898], [-121.24306, 38.73887], [-121.24299, 38.73876], [-121.24294, 38.73864], [-121.2429, 38.73843], [-121.24289, 38.73642], [-121.24283, 38.73617], [-121.24273, 38.73593], [-121.24259, 38.73573], [-121.24244, 38.73557], [-121.2412, 38.73453], [-121.24105, 38.73433], [-121.24094, 38.73412], [-121.24088, 38.7339], [-121.24088, 38.73367], [-121.2409, 38.73349], [-121.24104, 38.73301], [-121.24106, 38.73273], [-121.24101, 38.73248], [-121.24082, 38.73196], [-121.24081, 38.73182], [-121.24085, 38.73167], [-121.24097, 38.73153], [-121.24112, 38.73144], [-121.24132, 38.73138], [-121.24364, 38.7314], [-121.24389, 38.73138], [-121.24477, 38.73126], [-121.24503, 38.73125], [-121.2452, 38.73126], [-121.24688, 38.73149], [-121.2471, 38.73155], [-121.24731, 38.73164], [-121.24746, 38.73174], [-121.2476, 38.73189], [-121.24767, 38.732], [-121.24804, 38.73269], [-121.2482, 38.7329], [-121.24842, 38.73308], [-121.24864, 38.73321], [-121.24896, 38.73332], [-121.24932, 38.73337], [-121.24933, 38.73334], [-121.25354, 38.73334], [-121.25358, 38.73335], [-121.2536, 38.73338]]], [[[-121.25391, 38.72987], [-121.25287, 38.72987], [-121.25286, 38.73006], [-121.25248, 38.73009], [-121.25234, 38.73036], [-121.25234, 38.73087], [-121.2522, 38.73103], [-121.25207, 38.73115], [-121.25145, 38.73135], [-121.25118, 38.73142], [-121.25096, 38.73157], [-121.25065, 38.73189], [-121.25044, 38.73201], [-121.25006, 38.73205], [-121.24963, 38.7322], [-121.24957, 38.7325], [-121.2496, 38.73289], [-121.2496, 38.73319], [-121.24921, 38.73319], [-121.24893, 38.73314], [-121.2491, 38.73306], [-121.24918, 38.73298], [-121.24898, 38.73243], [-121.24898, 38.73201], [-121.24914, 38.73184], [-121.24956, 38.73162], [-121.25001, 38.73172], [-121.25027, 38.73154], [-121.25032, 38.73137], [-121.2501, 38.73117], [-121.24961, 38.73116], [-121.24928, 38.73094], [-121.24831, 38.73035], [-121.24904, 38.7302], [-121.24895, 38.72992], [-121.24969, 38.72971], [-121.24977, 38.72992], [-121.25016, 38.72983], [-121.25022, 38.7299], [-121.25009, 38.73018], [-121.2501, 38.73019], [-121.25075, 38.73017], [-121.25075, 38.72948], [-121.25391, 38.72955], [-121.25391, 38.72987]]]]} | Open Access 1 | 20931 | Maidu Regional Park | 21687 | 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 | 165.433 | Maidu RP | 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 | |
10924 | 10924 | 10923 | {"type": "Polygon", "coordinates": [[[-121.24017, 38.72845], [-121.24012, 38.72857], [-121.2401, 38.72873], [-121.24009, 38.7297], [-121.24007, 38.72973], [-121.24001, 38.72975], [-121.23919, 38.72965], [-121.23917, 38.72832], [-121.23896, 38.72831], [-121.23894, 38.72817], [-121.23808, 38.72816], [-121.23807, 38.72824], [-121.23775, 38.72824], [-121.23774, 38.72771], [-121.2397, 38.7277], [-121.24017, 38.72845]]]} | Open Access 1 | 20936 | Willard Dietrich Park | 27530 | 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 | 5.806 | Willard Dietrich Park | 0 | Local Park 2 | 4 | |
16167 | 16167 | 16166 | {"type": "MultiPolygon", "coordinates": [[[[-121.24491, 38.74107], [-121.24485, 38.74123], [-121.24457, 38.74138], [-121.24422, 38.74146], [-121.24418, 38.74154], [-121.24404, 38.74157], [-121.24404, 38.74167], [-121.24388, 38.74162], [-121.24361, 38.74174], [-121.24349, 38.74176], [-121.24336, 38.74188], [-121.24332, 38.74202], [-121.24326, 38.74209], [-121.24321, 38.74212], [-121.24305, 38.74211], [-121.24296, 38.74207], [-121.24284, 38.74199], [-121.24319, 38.74176], [-121.24334, 38.74147], [-121.24352, 38.74144], [-121.24416, 38.74138], [-121.24431, 38.74114], [-121.24424, 38.74094], [-121.24427, 38.74082], [-121.24421, 38.74072], [-121.24491, 38.74107]]], [[[-121.24785, 38.7396], [-121.24782, 38.73969], [-121.24773, 38.73968], [-121.24758, 38.73961], [-121.2475, 38.73967], [-121.24747, 38.73977], [-121.24742, 38.73982], [-121.24707, 38.73982], [-121.24693, 38.73977], [-121.2465, 38.73989], [-121.24636, 38.73987], [-121.24623, 38.74001], [-121.24596, 38.74004], [-121.24564, 38.74004], [-121.24543, 38.74002], [-121.2452, 38.73997], [-121.2451, 38.73998], [-121.24492, 38.74025], [-121.24486, 38.7404], [-121.2448, 38.74051], [-121.2447, 38.74063], [-121.24456, 38.74056], [-121.24477, 38.74033], [-121.24497, 38.73995], [-121.24464, 38.73963], [-121.2447, 38.7396], [-121.24482, 38.73963], [-121.24575, 38.73969], [-121.2459, 38.73964], [-121.24624, 38.73959], [-121.24647, 38.73948], [-121.24652, 38.73948], [-121.24659, 38.73955], [-121.24687, 38.73948], [-121.24703, 38.7395], [-121.24713, 38.73947], [-121.24715, 38.73941], [-121.2471, 38.73924], [-121.24711, 38.73914], [-121.24716, 38.7391], [-121.24725, 38.73908], [-121.24717, 38.73902], [-121.24718, 38.73889], [-121.24706, 38.73873], [-121.24772, 38.73942], [-121.24785, 38.7396]]], [[[-121.25347, 38.7387], [-121.25355, 38.7387], [-121.25361, 38.73874], [-121.25361, 38.73897], [-121.25358, 38.73925], [-121.25344, 38.73991], [-121.25342, 38.74016], [-121.25343, 38.74087], [-121.25342, 38.7409], [-121.25337, 38.74092], [-121.25329, 38.74093], [-121.2533, 38.74014], [-121.2531, 38.73997], [-121.25273, 38.73983], [-121.2527, 38.73961], [-121.2524, 38.73945], [-121.2523, 38.73954], [-121.25222, 38.73951], [-121.25215, 38.73951], [-121.25212, 38.73945], [-121.2502, 38.73947], [-121.24987, 38.73937], [-121.25006, 38.73908], [-121.25045, 38.73908], [-121.25053, 38.73904], [-121.25061, 38.73907], [-121.25072, 38.73906], [-121.2508, 38.73911], [-121.25117, 38.73907], [-121.25138, 38.73892], [-121.25157, 38.73883], [-121.25181, 38.73889], [-121.25204, 38.73889], [-121.25226, 38.73886], [-121.25227, 38.73884], [-121.25246, 38.73889], [-121.25272, 38.73904], [-121.25279, 38.73904], [-121.25282, 38.7391], [-121.25288, 38.73914], [-121.25299, 38.73915], [-121.25303, 38.7392], [-121.25341, 38.73932], [-121.25348, 38.73891], [-121.25347, 38.7387]]]]} | Open Access 1 | 20937 | City Open Space | 17336 | 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 | 9.82 | City OS | 0 | Local Recreation Area 3 | 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]);