superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
124 rows where MNG_AGENCY = 533
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7013 | 7013 | 7012 | {"type": "Polygon", "coordinates": [[[-121.26288, 38.75472], [-121.26165, 38.75576], [-121.26024, 38.75636], [-121.2599, 38.75658], [-121.25957, 38.75693], [-121.25942, 38.7572], [-121.25928, 38.75719], [-121.25913, 38.75715], [-121.25811, 38.75675], [-121.2583, 38.75636], [-121.25846, 38.75613], [-121.25865, 38.75607], [-121.25897, 38.75611], [-121.25925, 38.75602], [-121.25879, 38.75582], [-121.25853, 38.75577], [-121.25864, 38.75568], [-121.25905, 38.75576], [-121.2594, 38.75588], [-121.25963, 38.7556], [-121.25971, 38.75563], [-121.25996, 38.75532], [-121.26005, 38.75535], [-121.26039, 38.75492], [-121.26036, 38.75477], [-121.26023, 38.7547], [-121.26041, 38.75449], [-121.26063, 38.75445], [-121.26067, 38.75462], [-121.26083, 38.75481], [-121.26119, 38.75475], [-121.26116, 38.75459], [-121.26112, 38.75458], [-121.26108, 38.75438], [-121.26112, 38.75435], [-121.26136, 38.75427], [-121.26157, 38.75423], [-121.26148, 38.75381], [-121.26193, 38.75408], [-121.2621, 38.75415], [-121.26238, 38.75435], [-121.2627, 38.75464], [-121.26288, 38.75472]], [[-121.26235, 38.75516], [-121.26235, 38.75514], [-121.26206, 38.75493], [-121.26189, 38.75488], [-121.26133, 38.75525], [-121.26147, 38.75548], [-121.26154, 38.75545], [-121.26208, 38.75534], [-121.26235, 38.75516]]]} | Open Access 1 | Miner's Ravine Trail | 22260 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 12.465 | Miner's Ravine Trail | ||
7069 | 7069 | 7068 | {"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.32074, 38.77439], [-121.32028, 38.77427], [-121.3203, 38.77396], [-121.32003, 38.77396], [-121.31987, 38.77404], [-121.31981, 38.774], [-121.32011, 38.77377], [-121.32012, 38.77375], [-121.32002, 38.7737], [-121.3197, 38.77371], [-121.3194, 38.77368], [-121.31886, 38.77347], [-121.31851, 38.77309], [-121.31834, 38.77285], [-121.31806, 38.77272], [-121.31778, 38.7728], [-121.31727, 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.77327], [-121.32037, 38.77349], [-121.32181, 38.77371], [-121.32205, 38.77382], [-121.32225, 38.77407], [-121.32194, 38.77491], [-121.32235, 38.77502]]]} | Open Access 1 | Misty Wood Park | 22322 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 19.627 | Misty Wood Park | ||
7416 | 7416 | 7415 | {"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.36594, 38.78905], [-121.36575, 38.78911], [-121.36564, 38.78919], [-121.36553, 38.78933], [-121.36549, 38.78949]]]} | Open Access 1 | Norm Fratis Park | 22792 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 6.308 | Norm Fratis Park | ||
7561 | 7561 | 7560 | {"type": "Polygon", "coordinates": [[[-121.29641, 38.73769], [-121.29608, 38.7377], [-121.29606, 38.73671], [-121.29639, 38.7367], [-121.29641, 38.73769]]]} | Open Access 1 | Roseville holding 3 | 24649 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 0.764 | Roseville holding 3 | ||
7575 | 7575 | 7574 | {"type": "Polygon", "coordinates": [[[-121.25572, 38.72971], [-121.25572, 38.73032], [-121.2557, 38.73046], [-121.25562, 38.73062], [-121.25555, 38.73072], [-121.25548, 38.7307], [-121.25502, 38.73118], [-121.25487, 38.73128], [-121.25469, 38.73134], [-121.25452, 38.73102], [-121.25441, 38.73102], [-121.25442, 38.731], [-121.25449, 38.73097], [-121.25448, 38.7306], [-121.25445, 38.73046], [-121.25435, 38.73028], [-121.25413, 38.73021], [-121.25399, 38.73019], [-121.25392, 38.73021], [-121.2539, 38.73008], [-121.25343, 38.73003], [-121.25286, 38.73006], [-121.25286, 38.72987], [-121.2539, 38.72987], [-121.25391, 38.72967], [-121.25567, 38.72967], [-121.25572, 38.72971]]]} | Open Access 1 | Roseville holding 38 | 24658 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 5.222 | Roseville holding 38 | ||
7689 | 7689 | 7688 | {"type": "Polygon", "coordinates": [[[-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.23181, 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.74847], [-121.23117, 38.7484], [-121.231, 38.74823], [-121.23195, 38.74789], [-121.23228, 38.74782], [-121.23266, 38.74778], [-121.233, 38.74779], [-121.2333, 38.74783], [-121.23366, 38.74792], [-121.23379, 38.74796], [-121.23383, 38.748]]]} | Open Access 1 | Olympus Park | 23141 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 9.915 | Olympus Park | ||
8030 | 8030 | 8029 | {"type": "Polygon", "coordinates": [[[-121.32986, 38.7569], [-121.32985, 38.75807], [-121.32812, 38.75774], [-121.32807, 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 | Paul Lunardi Park | 23531 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 7.119 | Paul Lunardi Park | ||
8421 | 8421 | 8420 | {"type": "MultiPolygon", "coordinates": [[[[-121.29299, 38.78675], [-121.29281, 38.78695], [-121.29151, 38.78601], [-121.29153, 38.7857], [-121.29165, 38.78561], [-121.29166, 38.78556], [-121.29165, 38.78546], [-121.29178, 38.78527], [-121.29243, 38.78543], [-121.29257, 38.78589], [-121.29299, 38.78675]]], [[[-121.32257, 38.76796], [-121.32255, 38.76799], [-121.32252, 38.76801], [-121.32191, 38.76817], [-121.32101, 38.76854], [-121.32076, 38.76804], [-121.32034, 38.76803], [-121.32019, 38.76737], [-121.32083, 38.76703], [-121.32074, 38.76639], [-121.31577, 38.76639], [-121.31578, 38.76596], [-121.31577, 38.76579], [-121.31572, 38.76558], [-121.31564, 38.76537], [-121.31596, 38.76536], [-121.31606, 38.76549], [-121.31619, 38.76559], [-121.31638, 38.76567], [-121.31656, 38.76571], [-121.3173, 38.76572], [-121.31743, 38.76571], [-121.31756, 38.76568], [-121.31769, 38.76562], [-121.31793, 38.76545], [-121.31798, 38.76544], [-121.31831, 38.7656], [-121.3186, 38.76569], [-121.31891, 38.76575], [-121.31922, 38.76576], [-121.31959, 38.76571], [-121.3198, 38.76566], [-121.31999, 38.76559], [-121.32028, 38.76544], [-121.32056, 38.76522], [-121.32174, 38.76518], [-121.32181, 38.76503], [-121.32197, 38.76507], [-121.322, 38.76509], [-121.32201, 38.76513], [-121.32185, 38.76559], [-121.32182, 38.76576], [-121.32181, 38.76597], [-121.32183, 38.76617], [-121.3219, 38.76638], [-121.32224, 38.76714], [-121.32257, 38.76796]]]]} | No Public Access 3 | Proposed Park | 24017 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 23.347 | Proposed Park | ||
8563 | 8563 | 8562 | {"type": "Polygon", "coordinates": [[[-121.23265, 38.7393], [-121.23203, 38.73923], [-121.23024, 38.73974], [-121.22955, 38.73943], [-121.22965, 38.7393], [-121.23098, 38.73852], [-121.22984, 38.73731], [-121.23053, 38.7369], [-121.23032, 38.73666], [-121.23082, 38.73667], [-121.23118, 38.73669], [-121.2326, 38.73687], [-121.23265, 38.7393]]]} | Open Access 1 | Ray E. Lockridge Park | 24203 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 15.066 | Ray E. Lockridge Park | ||
8807 | 8807 | 8806 | {"type": "Polygon", "coordinates": [[[-121.32457, 38.76049], [-121.32457, 38.76049], [-121.32436, 38.76079], [-121.32439, 38.7605], [-121.32457, 38.76049]]]} | Open Access 1 | Roseville holding 7 | 24667 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 0.06 | Roseville holding 7 | ||
8828 | 8828 | 8827 | {"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.3343, 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.77395], [-121.33295, 38.77379], [-121.33326, 38.77379], [-121.33351, 38.77377], [-121.33386, 38.7745], [-121.33399, 38.77449], [-121.334, 38.77464], [-121.33474, 38.77469], [-121.33477, 38.77456], [-121.33508, 38.77459], [-121.33509, 38.77466], [-121.33525, 38.77467], [-121.3354, 38.77477], [-121.33547, 38.77477], [-121.33558, 38.77485]]]} | Open Access 1 | Robert L. Doyle Park | 24490 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 7.992 | Robert L. Doyle Park | ||
8891 | 8891 | 8890 | {"type": "Polygon", "coordinates": [[[-121.29997, 38.7584], [-121.29997, 38.75871], [-121.29997, 38.75871], [-121.29978, 38.75851], [-121.29978, 38.75839], [-121.29997, 38.7584]]]} | Open Access 1 | Roseville holding 8 | 24668 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 0.096 | Roseville holding 8 | ||
8954 | 8954 | 8953 | {"type": "Polygon", "coordinates": [[[-121.32679, 38.76689], [-121.3266, 38.76689], [-121.3266, 38.76659], [-121.32679, 38.76659], [-121.32679, 38.76689]]]} | Open Access 1 | Roseville holding 1 | 24627 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 0.139 | Roseville holding 1 | ||
8955 | 8955 | 8954 | {"type": "Polygon", "coordinates": [[[-121.25834, 38.73133], [-121.25794, 38.73149], [-121.25793, 38.73087], [-121.25833, 38.73087], [-121.25834, 38.73133]]]} | Open Access 1 | Roseville holding 10 | 24628 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 0.513 | Roseville holding 10 | ||
8956 | 8956 | 8955 | {"type": "Polygon", "coordinates": [[[-121.30877, 38.73764], [-121.30787, 38.73762], [-121.30771, 38.73765], [-121.30725, 38.73783], [-121.30706, 38.73799], [-121.30698, 38.73822], [-121.30677, 38.73808], [-121.30682, 38.73795], [-121.30676, 38.7379], [-121.30653, 38.738], [-121.30648, 38.73795], [-121.30646, 38.73789], [-121.30648, 38.73782], [-121.30669, 38.73758], [-121.30677, 38.73745], [-121.30717, 38.73751], [-121.30758, 38.73729], [-121.30827, 38.73728], [-121.30855, 38.73732], [-121.30877, 38.73732], [-121.30877, 38.73764]]]} | Open Access 1 | Roseville holding 11 | 24629 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 2.131 | Roseville holding 11 | ||
8957 | 8957 | 8956 | {"type": "Polygon", "coordinates": [[[-121.31748, 38.76975], [-121.31732, 38.76971], [-121.31722, 38.76963], [-121.31737, 38.76942], [-121.31747, 38.76953], [-121.31748, 38.76975]]]} | Open Access 1 | Roseville holding 12 | 24630 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 0.12 | Roseville holding 12 | ||
8958 | 8958 | 8957 | {"type": "Polygon", "coordinates": [[[-121.3399, 38.77607], [-121.33948, 38.77588], [-121.33948, 38.77588], [-121.33969, 38.77582], [-121.3399, 38.77607]]]} | Open Access 1 | Roseville holding 13 | 24631 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 0.081 | Roseville holding 13 | ||
8959 | 8959 | 8958 | {"type": "Polygon", "coordinates": [[[-121.31816, 38.77053], [-121.31806, 38.77076], [-121.31784, 38.77063], [-121.31776, 38.77046], [-121.31816, 38.77053]]]} | Open Access 1 | Roseville holding 14 | 24632 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 0.147 | Roseville holding 14 | ||
8960 | 8960 | 8959 | {"type": "Polygon", "coordinates": [[[-121.2971, 38.73345], [-121.2966, 38.73345], [-121.29659, 38.73255], [-121.297, 38.73265], [-121.29693, 38.73288], [-121.29693, 38.73301], [-121.29691, 38.73305], [-121.29698, 38.73309], [-121.29695, 38.73312], [-121.29697, 38.73321], [-121.29706, 38.73322], [-121.29707, 38.73327], [-121.29709, 38.73331], [-121.2971, 38.73345]]]} | Open Access 1 | Roseville holding 15 | 24633 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 0.802 | Roseville holding 15 | ||
8961 | 8961 | 8960 | {"type": "Polygon", "coordinates": [[[-121.25119, 38.76227], [-121.25118, 38.76283], [-121.2511, 38.76283], [-121.25103, 38.76312], [-121.2508, 38.7631], [-121.25076, 38.76321], [-121.25066, 38.76323], [-121.25051, 38.76324], [-121.25048, 38.7634], [-121.25038, 38.76345], [-121.25015, 38.76348], [-121.25016, 38.76361], [-121.25006, 38.76369], [-121.24974, 38.76379], [-121.24939, 38.76382], [-121.24918, 38.76394], [-121.24886, 38.76392], [-121.24872, 38.76407], [-121.24858, 38.76412], [-121.24851, 38.76423], [-121.24827, 38.76432], [-121.24834, 38.76444], [-121.2483, 38.76454], [-121.24817, 38.76459], [-121.2481, 38.76466], [-121.24802, 38.76467], [-121.24783, 38.76464], [-121.24778, 38.76447], [-121.2475, 38.76446], [-121.2474, 38.76452], [-121.24729, 38.76448], [-121.24719, 38.76453], [-121.24699, 38.76451], [-121.24685, 38.76442], [-121.24659, 38.76445], [-121.24649, 38.76427], [-121.24634, 38.76433], [-121.246, 38.76432], [-121.24588, 38.76427], [-121.24584, 38.76423], [-121.24585, 38.76419], [-121.24589, 38.76416], [-121.24618, 38.7642], [-121.24654, 38.76409], [-121.24674, 38.76424], [-121.24693, 38.76415], [-121.2472, 38.76415], [-121.24724, 38.76406], [-121.24738, 38.76404], [-121.24771, 38.76422], [-121.24794, 38.7639], [-121.24792, 38.76371], [-121.24802, 38.76359], [-121.24826, 38.76352], [-121.24827, 38.76329], [-121.24881, 38.76292], [-121.24897, 38.7627], [-121.24922, 38.76266], [-121.24933, 38.76223], [-121.24988, 38.76224], [-121.24989, 38.76222], [-121.25095, 38.76223], [-121.25096, 38.76227], [-121.25119, 38.76227]]]} | Open Access 1 | Roseville holding 16 | 24634 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 10.667 | Roseville holding 16 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);