superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
36 rows where MNG_AGENCY = 157 sorted by ACRES
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13354 | 13354 | 13353 | {"type": "Polygon", "coordinates": [[[-122.16264, 37.4447], [-122.16245, 37.44488], [-122.16218, 37.44471], [-122.16237, 37.44453], [-122.16264, 37.4447]]]} | Open Access 1 | Lytton Plaza | 30706 | 1243 | Palo Alto, City of 157 | City 2 | City Agency 2 | http://www.cityofpaloalto.org/ | City 2 | 0.195 | Lytton Plaza | ||
9409 | 9409 | 9408 | {"type": "Polygon", "coordinates": [[[-122.15574, 37.44328], [-122.1555, 37.44352], [-122.15524, 37.44335], [-122.15548, 37.44311], [-122.15574, 37.44328]]]} | Open Access 1 | Scott Park | 25205 | 1243 | Palo Alto, City of 157 | City 2 | City Agency 2 | http://www.cityofpaloalto.org/ | City 2 | 0.258 | Scott Park | 1973 | |
9357 | 9357 | 9356 | {"type": "Polygon", "coordinates": [[[-122.14317, 37.42585], [-122.143, 37.42606], [-122.14261, 37.42586], [-122.14279, 37.42565], [-122.14317, 37.42585]]]} | Open Access 1 | Sarah Wallis Park | 25156 | 1243 | Palo Alto, City of 157 | City 2 | City Agency 2 | http://www.cityofpaloalto.org/ | City 2 | 0.282 | Sarah Wallis Park | ||
6778 | 6778 | 6777 | {"type": "MultiPolygon", "coordinates": [[[[-122.14889, 37.42343], [-122.14866, 37.42371], [-122.1482, 37.42347], [-122.14844, 37.42318], [-122.14858, 37.42326], [-122.14847, 37.42337], [-122.14846, 37.42343], [-122.14858, 37.42348], [-122.14877, 37.42339], [-122.14889, 37.42343]]], [[[-122.14925, 37.423], [-122.14903, 37.42325], [-122.14888, 37.42318], [-122.14893, 37.42313], [-122.14906, 37.42308], [-122.14906, 37.42299], [-122.14902, 37.42292], [-122.14897, 37.42289], [-122.14885, 37.42287], [-122.14876, 37.42289], [-122.1487, 37.42295], [-122.14869, 37.423], [-122.14864, 37.42305], [-122.14858, 37.42301], [-122.14879, 37.42276], [-122.14925, 37.423]]]]} | Open Access 1 | Mayfield Park | 21975 | 1243 | Palo Alto, City of 157 | City 2 | City Agency 2 | http://www.cityofpaloalto.org/ | City 2 | 0.564 | Mayfield Park | ||
7119 | 7119 | 7118 | {"type": "Polygon", "coordinates": [[[-122.11702, 37.40816], [-122.11694, 37.40829], [-122.11692, 37.40842], [-122.1165, 37.40846], [-122.11652, 37.40809], [-122.11655, 37.40804], [-122.11627, 37.40786], [-122.11635, 37.40778], [-122.1164, 37.40776], [-122.11644, 37.40777], [-122.11701, 37.40812], [-122.11702, 37.40816]]]} | Open Access 1 | Monroe Mini Park | 22373 | 1243 | Palo Alto, City of 157 | City 2 | City Agency 2 | http://www.cityofpaloalto.org/ | City 2 | 0.621 | Monroe MP | 1974 | |
2168 | 2168 | 2167 | {"type": "Polygon", "coordinates": [[[-122.13545, 37.42156], [-122.13539, 37.42163], [-122.13502, 37.42143], [-122.13497, 37.42147], [-122.13433, 37.42114], [-122.13446, 37.42098], [-122.13477, 37.42113], [-122.13515, 37.42068], [-122.1353, 37.42076], [-122.13529, 37.42096], [-122.13531, 37.42112], [-122.13535, 37.42128], [-122.13545, 37.42156]]]} | Open Access 1 | Boulware Park | 16300 | 1243 | Palo Alto, City of 157 | City 2 | City Agency 2 | http://www.cityofpaloalto.org/ | City 2 | 1.096 | Boulware Park | 1965 | |
11086 | 11086 | 11085 | {"type": "Polygon", "coordinates": [[[-122.15279, 37.41874], [-122.1522, 37.41945], [-122.15174, 37.41921], [-122.15233, 37.4185], [-122.15279, 37.41874]]]} | Open Access 1 | Weissharr Park | 27334 | 1243 | Palo Alto, City of 157 | City 2 | City Agency 2 | http://www.cityofpaloalto.org/ | City 2 | 1.137 | Weissharr Park | 1925 | |
9509 | 9509 | 9508 | {"type": "Polygon", "coordinates": [[[-122.15474, 37.41978], [-122.15452, 37.42005], [-122.15454, 37.42008], [-122.15419, 37.42051], [-122.1537, 37.42025], [-122.1543, 37.41954], [-122.15474, 37.41978]]]} | Open Access 1 | Werry Park | 27348 | 1243 | Palo Alto, City of 157 | City 2 | City Agency 2 | http://www.cityofpaloalto.org/ | City 2 | 1.169 | Werry Park | 1925 | |
1812 | 1812 | 1811 | {"type": "Polygon", "coordinates": [[[-122.15124, 37.42405], [-122.15065, 37.42476], [-122.15016, 37.42451], [-122.15075, 37.4238], [-122.15124, 37.42405]]]} | Open Access 1 | Cameron Park | 16760 | 1243 | Palo Alto, City of 157 | City 2 | City Agency 2 | http://www.cityofpaloalto.org/ | City 2 | 1.202 | Cameron Park | 1925 | |
13360 | 13360 | 13359 | {"type": "Polygon", "coordinates": [[[-122.17027, 37.4473], [-122.17017, 37.44738], [-122.16955, 37.44764], [-122.1694, 37.44711], [-122.16913, 37.44708], [-122.16893, 37.44699], [-122.16906, 37.44681], [-122.16912, 37.44677], [-122.16938, 37.44674], [-122.17027, 37.4473]]]} | Open Access 1 | El Palo Alto Park | 30711 | 1243 | Palo Alto, City of 157 | City 2 | City Agency 2 | http://www.cityofpaloalto.org/ | City 2 | 1.241 | El Palo Alto Park | ||
2388 | 2388 | 2387 | {"type": "Polygon", "coordinates": [[[-122.1633, 37.4461], [-122.16283, 37.44657], [-122.16208, 37.4461], [-122.16255, 37.44562], [-122.1633, 37.4461]]]} | Open Access 1 | Cogswell Plaza | 17477 | 1243 | Palo Alto, City of 157 | City 2 | City Agency 2 | http://www.cityofpaloalto.org/ | City 2 | 1.403 | Cogswell Plaza | 1924 | |
2180 | 2180 | 2179 | {"type": "Polygon", "coordinates": [[[-122.14841, 37.44053], [-122.14746, 37.4408], [-122.14691, 37.44045], [-122.14744, 37.43992], [-122.14841, 37.44053]]]} | Open Access 1 | Bowling Green Park | 16309 | 1243 | Palo Alto, City of 157 | City 2 | City Agency 2 | http://www.cityofpaloalto.org/ | City 2 | 1.621 | Bowling Green Park | 1933 | |
12262 | 12262 | 12261 | {"type": "Polygon", "coordinates": [[[-122.15743, 37.44385], [-122.15664, 37.44464], [-122.15607, 37.44428], [-122.15714, 37.4432], [-122.15737, 37.44334], [-122.15709, 37.44365], [-122.15743, 37.44385]]]} | Open Access 1 | Heritage Park | 30697 | 1243 | Palo Alto, City of 157 | City 2 | City Agency 2 | http://www.cityofpaloalto.org/ | City 2 | 2.06 | Heritage Park | ||
5429 | 5429 | 5428 | {"type": "Polygon", "coordinates": [[[-122.14194, 37.42969], [-122.14151, 37.43021], [-122.14024, 37.42941], [-122.14023, 37.42936], [-122.1402, 37.42933], [-122.14013, 37.42931], [-122.14006, 37.42934], [-122.13997, 37.42927], [-122.14047, 37.4293], [-122.14063, 37.42925], [-122.14078, 37.42913], [-122.14088, 37.42912], [-122.14194, 37.42969]]]} | Open Access 1 | J. Bowden Park | 20291 | 1243 | Palo Alto, City of 157 | City 2 | City Agency 2 | http://www.cityofpaloalto.org/ | City 2 | 2.088 | J. Bowden Park | 1952 | |
5589 | 5589 | 5588 | {"type": "Polygon", "coordinates": [[[-122.16402, 37.44949], [-122.16354, 37.44998], [-122.16245, 37.44929], [-122.16293, 37.4488], [-122.16402, 37.44949]]]} | Open Access 1 | Johnson Park | 20478 | 1243 | Palo Alto, City of 157 | City 2 | City Agency 2 | http://www.cityofpaloalto.org/ | City 2 | 2.092 | Johnson Park | 1968 | |
5690 | 5690 | 5689 | {"type": "Polygon", "coordinates": [[[-122.14937, 37.44026], [-122.14842, 37.44053], [-122.14744, 37.43992], [-122.14798, 37.43938], [-122.14937, 37.44026]]]} | Open Access 1 | Kellogg Park | 20582 | 1243 | Palo Alto, City of 157 | City 2 | City Agency 2 | http://www.cityofpaloalto.org/ | City 2 | 2.513 | Kellogg Park | 1926 | |
2120 | 2120 | 2119 | {"type": "Polygon", "coordinates": [[[-122.13963, 37.41148], [-122.13861, 37.41094], [-122.13867, 37.41065], [-122.1386, 37.41047], [-122.13841, 37.41035], [-122.13814, 37.41004], [-122.13828, 37.40965], [-122.13811, 37.40928], [-122.13786, 37.40907], [-122.13807, 37.40875], [-122.13818, 37.40851], [-122.13834, 37.40845], [-122.13963, 37.41148]]]} | Open Access 1 | Bol Park | 16235 | 1243 | Palo Alto, City of 157 | City 2 | City Agency 2 | http://www.cityofpaloalto.org/ | City 2 | 4.249 | Bol Park | 1974 | |
9439 | 9439 | 9438 | {"type": "Polygon", "coordinates": [[[-122.11949, 37.43603], [-122.11883, 37.4365], [-122.11853, 37.43631], [-122.11853, 37.43626], [-122.11849, 37.43622], [-122.11834, 37.43619], [-122.11789, 37.4359], [-122.11826, 37.43551], [-122.11815, 37.43543], [-122.11819, 37.43539], [-122.11818, 37.43537], [-122.11756, 37.43498], [-122.11798, 37.43455], [-122.11906, 37.43523], [-122.1193, 37.43501], [-122.11938, 37.43506], [-122.11892, 37.43552], [-122.11946, 37.43587], [-122.11939, 37.43595], [-122.11949, 37.43603]]]} | Open Access 1 | Seale Park | 25243 | 1243 | Palo Alto, City of 157 | City 2 | City Agency 2 | http://www.cityofpaloalto.org/ | City 2 | 4.27 | Seale Park | 1955 | |
8502 | 8502 | 8501 | {"type": "Polygon", "coordinates": [[[-122.11045, 37.42637], [-122.10956, 37.42684], [-122.1086, 37.42568], [-122.10855, 37.42543], [-122.10989, 37.42525], [-122.1099, 37.42523], [-122.10986, 37.42513], [-122.10991, 37.42517], [-122.11045, 37.42637]]]} | Open Access 1 | Ramos Park | 24122 | 1243 | Palo Alto, City of 157 | City 2 | City Agency 2 | http://www.cityofpaloalto.org/ | City 2 | 4.353 | Ramos Park | 1955 | |
2262 | 2262 | 2261 | {"type": "Polygon", "coordinates": [[[-122.12795, 37.4072], [-122.12739, 37.40802], [-122.12736, 37.40801], [-122.12732, 37.40803], [-122.12572, 37.40734], [-122.12569, 37.40729], [-122.12625, 37.40646], [-122.12795, 37.4072]]]} | Open Access 1 | Briones Park | 16393 | 1243 | Palo Alto, City of 157 | City 2 | City Agency 2 | http://www.cityofpaloalto.org/ | City 2 | 4.57 | Briones Park | 1965 |
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]);