units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
37 rows where MNG_AGENCY = 157 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, PARK_URL, COUNTY, LABEL_NAME, YR_EST, GAP_STS
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3792 | 3792 | 3791 | {"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 | 47056 | Lytton Plaza | 30706 | 1243 | Palo Alto, City of 161 | City 2 | City Agency 2 | http://www.cityofpaloalto.org/ | City 2 | 1243 | Palo Alto, City of 157 | City 2 | City Agency 2 | Santa Clara 19 | 0.195 | Lytton Plaza | 0 | Local Park 2 | 4 | |
536 | 536 | 535 | {"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 | 15226 | Scott Park | 25205 | 1243 | Palo Alto, City of 161 | City 2 | City Agency 2 | http://www.cityofpaloalto.org/ | City 2 | 1243 | Palo Alto, City of 157 | City 2 | City Agency 2 | Santa Clara 19 | 0.258 | Scott Park | 1973 | Local Park 2 | 4 | |
14275 | 14275 | 14274 | {"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 | 44201 | Sarah Wallis Park | 25156 | 1243 | Palo Alto, City of 161 | City 2 | City Agency 2 | http://www.cityofpaloalto.org/ | City 2 | 1243 | Palo Alto, City of 157 | City 2 | City Agency 2 | Santa Clara 19 | 0.283 | Sarah Wallis Park | 0 | Local Park 2 | 4 | |
9169 | 9169 | 9168 | {"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.14907, 37.42308], [-122.14906, 37.42299], [-122.14903, 37.42292], [-122.14897, 37.42289], [-122.14886, 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 | 15217 | Mayfield Park | 21975 | 1243 | Palo Alto, City of 161 | City 2 | City Agency 2 | http://www.cityofpaloalto.org/ | City 2 | 1243 | Palo Alto, City of 157 | City 2 | City Agency 2 | Santa Clara 19 | 0.562 | Mayfield Park | 0 | Local Park 2 | 4 | |
5288 | 5288 | 5287 | {"type": "Polygon", "coordinates": [[[-122.11692, 37.40842], [-122.1165, 37.40846], [-122.11652, 37.40809], [-122.11656, 37.40805], [-122.11627, 37.40786], [-122.11635, 37.40778], [-122.1164, 37.40776], [-122.11644, 37.40777], [-122.11701, 37.40812], [-122.11702, 37.40816], [-122.11694, 37.40829], [-122.11692, 37.40842]]]} | Open Access 1 | 15201 | Monroe Mini Park | 22373 | 1243 | Palo Alto, City of 161 | City 2 | City Agency 2 | http://www.cityofpaloalto.org/ | City 2 | 1243 | Palo Alto, City of 157 | City 2 | City Agency 2 | Santa Clara 19 | 0.62 | Monroe MP | 1974 | Local Park 2 | 4 | |
6404 | 6404 | 6403 | {"type": "Polygon", "coordinates": [[[-122.13545, 37.42156], [-122.13539, 37.42163], [-122.13501, 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 | 1989 | Boulware Park | 16300 | 1243 | Palo Alto, City of 161 | City 2 | City Agency 2 | http://www.cityofpaloalto.org/ | City 2 | 1243 | Palo Alto, City of 157 | City 2 | City Agency 2 | Santa Clara 19 | 1.094 | Boulware Park | 1965 | Local Park 2 | 4 | |
9158 | 9158 | 9157 | {"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 | 15204 | Weissharr Park | 27334 | 1243 | Palo Alto, City of 161 | City 2 | City Agency 2 | http://www.cityofpaloalto.org/ | City 2 | 1243 | Palo Alto, City of 157 | City 2 | City Agency 2 | Santa Clara 19 | 1.138 | Weissharr Park | 1925 | Local Park 2 | 4 | |
9159 | 9159 | 9158 | {"type": "Polygon", "coordinates": [[[-122.15474, 37.41978], [-122.15451, 37.42006], [-122.15454, 37.42008], [-122.15419, 37.42051], [-122.1537, 37.42025], [-122.1543, 37.41954], [-122.15474, 37.41978]]]} | Open Access 1 | 15207 | Werry Park | 27348 | 1243 | Palo Alto, City of 161 | City 2 | City Agency 2 | http://www.cityofpaloalto.org/ | City 2 | 1243 | Palo Alto, City of 157 | City 2 | City Agency 2 | Santa Clara 19 | 1.169 | Werry Park | 1925 | Local Park 2 | 4 | |
9161 | 9161 | 9160 | {"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 | 15210 | Cameron Park | 16760 | 1243 | Palo Alto, City of 161 | City 2 | City Agency 2 | http://www.cityofpaloalto.org/ | City 2 | 1243 | Palo Alto, City of 157 | City 2 | City Agency 2 | Santa Clara 19 | 1.202 | Cameron Park | 1925 | Local Park 2 | 4 | |
14449 | 14449 | 14448 | {"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 | 47061 | El Palo Alto Park | 30711 | 1243 | Palo Alto, City of 161 | City 2 | City Agency 2 | http://www.cityofpaloalto.org/ | City 2 | 1243 | Palo Alto, City of 157 | City 2 | City Agency 2 | Santa Clara 19 | 1.24 | El Palo Alto Park | 0 | Local Park 2 | 4 | |
1765 | 1765 | 1764 | {"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 | 15229 | Cogswell Plaza | 17477 | 1243 | Palo Alto, City of 161 | City 2 | City Agency 2 | http://www.cityofpaloalto.org/ | City 2 | 1243 | Palo Alto, City of 157 | City 2 | City Agency 2 | Santa Clara 19 | 1.403 | Cogswell Plaza | 1924 | Local Park 2 | 4 | |
9172 | 9172 | 9171 | {"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 | 15220 | Bowling Green Park | 16309 | 1243 | Palo Alto, City of 161 | City 2 | City Agency 2 | http://www.cityofpaloalto.org/ | City 2 | 1243 | Palo Alto, City of 157 | City 2 | City Agency 2 | Santa Clara 19 | 1.621 | Bowling Green Park | 1933 | Local Park 2 | 4 | |
4106 | 4106 | 4105 | {"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.44364], [-122.15743, 37.44385]]]} | Open Access 1 | 47047 | Heritage Park | 30697 | 1243 | Palo Alto, City of 161 | City 2 | City Agency 2 | http://www.cityofpaloalto.org/ | City 2 | 1243 | Palo Alto, City of 157 | City 2 | City Agency 2 | Santa Clara 19 | 2.057 | Heritage Park | 0 | Local Park 2 | 4 | |
2338 | 2338 | 2337 | {"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 | 17054 | J. Bowden Park | 20291 | 1243 | Palo Alto, City of 161 | City 2 | City Agency 2 | http://www.cityofpaloalto.org/ | City 2 | 1243 | Palo Alto, City of 157 | City 2 | City Agency 2 | Santa Clara 19 | 2.088 | J. Bowden Park | 1952 | Local Park 2 | 4 | |
2347 | 2347 | 2346 | {"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 | 17102 | Johnson Park | 20478 | 1243 | Palo Alto, City of 161 | City 2 | City Agency 2 | http://www.cityofpaloalto.org/ | City 2 | 1243 | Palo Alto, City of 157 | City 2 | City Agency 2 | Santa Clara 19 | 2.092 | Johnson Park | 1968 | Local Park 2 | 4 | |
9173 | 9173 | 9172 | {"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 | 15223 | Kellogg Park | 20582 | 1243 | Palo Alto, City of 161 | City 2 | City Agency 2 | http://www.cityofpaloalto.org/ | City 2 | 1243 | Palo Alto, City of 157 | City 2 | City Agency 2 | Santa Clara 19 | 2.513 | Kellogg Park | 1926 | Local Park 2 | 4 | |
396 | 396 | 395 | {"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 | 1442 | Bol Park | 16235 | 1243 | Palo Alto, City of 161 | City 2 | City Agency 2 | http://www.cityofpaloalto.org/ | City 2 | 1243 | Palo Alto, City of 157 | City 2 | City Agency 2 | Santa Clara 19 | 4.248 | Bol Park | 1974 | Local Park 2 | 4 | |
9151 | 9151 | 9150 | {"type": "Polygon", "coordinates": [[[-122.11949, 37.43603], [-122.11883, 37.4365], [-122.11853, 37.43631], [-122.11853, 37.43626], [-122.11849, 37.43621], [-122.11834, 37.43619], [-122.11789, 37.4359], [-122.11827, 37.43551], [-122.11815, 37.43543], [-122.11819, 37.43539], [-122.11819, 37.43538], [-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.11938, 37.43595], [-122.11949, 37.43603]]]} | Open Access 1 | 15197 | Seale Park | 25243 | 1243 | Palo Alto, City of 161 | City 2 | City Agency 2 | http://www.cityofpaloalto.org/ | City 2 | 1243 | Palo Alto, City of 157 | City 2 | City Agency 2 | Santa Clara 19 | 4.257 | Seale Park | 1955 | Local Park 2 | 4 | |
10644 | 10644 | 10643 | {"type": "Polygon", "coordinates": [[[-122.11045, 37.42637], [-122.10956, 37.42684], [-122.1086, 37.42568], [-122.10855, 37.42543], [-122.1099, 37.42524], [-122.10986, 37.42513], [-122.10991, 37.42517], [-122.11045, 37.42637]]]} | Open Access 1 | 18975 | Ramos Park | 24122 | 1243 | Palo Alto, City of 161 | City 2 | City Agency 2 | http://www.cityofpaloalto.org/ | City 2 | 1243 | Palo Alto, City of 157 | City 2 | City Agency 2 | Santa Clara 19 | 4.354 | Ramos Park | 1955 | Local Park 2 | 4 | |
9157 | 9157 | 9156 | {"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 | 15202 | Briones Park | 16393 | 1243 | Palo Alto, City of 161 | City 2 | City Agency 2 | http://www.cityofpaloalto.org/ | City 2 | 1243 | Palo Alto, City of 157 | City 2 | City Agency 2 | Santa Clara 19 | 4.57 | Briones Park | 1965 | 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]);