superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
9 rows where MNG_AGENCY = 600 sorted by rowid
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1580 | 1580 | 1579 | {"type": "Polygon", "coordinates": [[[-120.57744, 35.12353], [-120.57711, 35.12368], [-120.57694, 35.1235], [-120.57731, 35.1233], [-120.57744, 35.12353]]]} | Open Access 1 | Village Green | 27113 | 1454 | Arroyo Grande, City of 600 | City 2 | City Agency 2 | http://www.arroyogrande.org/ | City 2 | 0.248 | Village Green | ||
2922 | 2922 | 2921 | {"type": "Polygon", "coordinates": [[[-120.57814, 35.12144], [-120.57791, 35.12153], [-120.57748, 35.12096], [-120.57813, 35.12143], [-120.57814, 35.12144]]]} | Open Access 1 | Christmas Tree Island Park | 17229 | 1454 | Arroyo Grande, City of 600 | City 2 | City Agency 2 | http://www.arroyogrande.org/ | City 2 | 0.222 | Christmas Tree Island Park | ||
8518 | 8518 | 8517 | {"type": "Polygon", "coordinates": [[[-120.58744, 35.13299], [-120.58703, 35.13408], [-120.58703, 35.1342], [-120.58706, 35.13429], [-120.58711, 35.13439], [-120.58718, 35.13446], [-120.58672, 35.13481], [-120.58633, 35.13464], [-120.58594, 35.1345], [-120.58479, 35.13423], [-120.58599, 35.1326], [-120.58744, 35.13299]]]} | Open Access 1 | Rancho Grande Park | 24145 | 1454 | Arroyo Grande, City of 600 | City 2 | City Agency 2 | http://www.arroyogrande.org/ | City 2 | 8.55 | Rancho Grande Park | ||
9006 | 9006 | 9005 | {"type": "Polygon", "coordinates": [[[-120.57668, 35.12287], [-120.57621, 35.12313], [-120.57614, 35.12305], [-120.57585, 35.1232], [-120.57564, 35.12292], [-120.57639, 35.12251], [-120.57668, 35.12287]]]} | Open Access 1 | Rotary Bandstand | 24681 | 1454 | Arroyo Grande, City of 600 | City 2 | City Agency 2 | http://www.arroyogrande.org/ | City 2 | 0.904 | Rotary Bandstand | ||
10034 | 10034 | 10033 | {"type": "Polygon", "coordinates": [[[-120.55825, 35.12993], [-120.55762, 35.13046], [-120.55751, 35.13053], [-120.556, 35.12927], [-120.55616, 35.12917], [-120.55683, 35.12853], [-120.55694, 35.12862], [-120.55682, 35.12869], [-120.55676, 35.12888], [-120.5578, 35.12976], [-120.55806, 35.12975], [-120.55825, 35.12993]]]} | Open Access 1 | Strother Park | 25930 | 1454 | Arroyo Grande, City of 600 | City 2 | City Agency 2 | http://www.arroyogrande.org/ | City 2 | 4.114 | Strother Park | ||
10253 | 10253 | 10252 | {"type": "MultiPolygon", "coordinates": [[[[-120.56623, 35.13207], [-120.56587, 35.13226], [-120.56577, 35.13369], [-120.56583, 35.13383], [-120.56555, 35.13367], [-120.56518, 35.13334], [-120.56536, 35.13185], [-120.56516, 35.13179], [-120.56518, 35.13175], [-120.56537, 35.13179], [-120.56539, 35.13144], [-120.56574, 35.13153], [-120.56584, 35.13167], [-120.56623, 35.13207]]], [[[-120.56924, 35.13231], [-120.56897, 35.13297], [-120.5688, 35.13299], [-120.56858, 35.13313], [-120.56822, 35.13349], [-120.56811, 35.1337], [-120.56806, 35.13376], [-120.56793, 35.1337], [-120.56811, 35.13331], [-120.5681, 35.13318], [-120.56804, 35.13302], [-120.56791, 35.13283], [-120.56743, 35.13266], [-120.56727, 35.13258], [-120.56748, 35.13193], [-120.56924, 35.13231]]]]} | Open Access 1 | Terra de Oro Park | 26252 | 1454 | Arroyo Grande, City of 600 | City 2 | City Agency 2 | http://www.arroyogrande.org/ | City 2 | 7.339 | Terra de Oro Park | ||
13814 | 13814 | 13813 | {"type": "Polygon", "coordinates": [[[-120.60822, 35.11477], [-120.60789, 35.11477], [-120.60766, 35.11474], [-120.60738, 35.11468], [-120.60693, 35.11464], [-120.6007, 35.11463], [-120.60066, 35.1146], [-120.60065, 35.11457], [-120.60063, 35.1127], [-120.60796, 35.11271], [-120.60821, 35.11292], [-120.60822, 35.11477]]]} | Open Access 1 | Soto Sports Complex | 33130 | 1454 | Arroyo Grande, City of 600 | City 2 | City Agency 2 | http://www.arroyogrande.org/ | City 2 | 36.628 | Soto Sports Complex | ||
14413 | 14413 | 14412 | {"type": "Polygon", "coordinates": [[[-120.60711, 35.11657], [-120.60704, 35.11689], [-120.60706, 35.11725], [-120.60696, 35.11734], [-120.60688, 35.11736], [-120.60678, 35.11731], [-120.60667, 35.11716], [-120.60661, 35.11701], [-120.60662, 35.11686], [-120.60667, 35.11672], [-120.60688, 35.11652], [-120.60697, 35.11648], [-120.60701, 35.11649], [-120.60711, 35.11657]]]} | Open Access 1 | Kingo Park | 33469 | 1454 | Arroyo Grande, City of 600 | City 2 | City Agency 2 | http://www.arroyogrande.org/ | City 2 | 0.756 | Kingo Park | ||
14415 | 14415 | 14414 | {"type": "Polygon", "coordinates": [[[-120.57874, 35.12285], [-120.57868, 35.12291], [-120.57863, 35.12287], [-120.57789, 35.12326], [-120.57772, 35.12305], [-120.57762, 35.12296], [-120.5778, 35.12286], [-120.57841, 35.12275], [-120.57845, 35.12287], [-120.57873, 35.12277], [-120.57874, 35.12285]]]} | Open Access 1 | Kiwanis Park | 33470 | 1454 | Arroyo Grande, City of 600 | City 2 | City Agency 2 | http://www.arroyogrande.org/ | City 2 | 0.637 | Kiwanis Park |
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]);