superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
36 rows where MNG_AGENCY = 157 sorted by PARK_URL
This data as json, copyable, CSV (advanced)
Suggested facets: YR_EST
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
3933 | 3933 | 3932 | {"type": "Polygon", "coordinates": [[[-122.1431, 37.44885], [-122.14308, 37.45144], [-122.14138, 37.4509], [-122.14138, 37.44884], [-122.1431, 37.44885]]]} | Open Access 1 | Eleanor Pardee Park | 18556 | 1243 | Palo Alto, City of 157 | City 2 | City Agency 2 | http://www.cityofpaloalto.org/ | City 2 | 9.674 | Eleanor Pardee Park | 1920 | |
4072 | 4072 | 4071 | {"type": "Polygon", "coordinates": [[[-122.14069, 37.3925], [-122.13957, 37.39227], [-122.1395, 37.39221], [-122.1394, 37.39219], [-122.1387, 37.39224], [-122.1384, 37.39233], [-122.1383, 37.3923], [-122.13823, 37.3923], [-122.13728, 37.39099], [-122.13634, 37.39095], [-122.13632, 37.38958], [-122.13507, 37.38952], [-122.13507, 37.38854], [-122.13633, 37.38859], [-122.13696, 37.38912], [-122.13824, 37.38917], [-122.13824, 37.38964], [-122.13879, 37.38967], [-122.13879, 37.39107], [-122.14017, 37.39108], [-122.14069, 37.3925]]]} | Open Access 1 | Esther Clark Park | 18727 | 1243 | Palo Alto, City of 157 | City 2 | City Agency 2 | http://www.cityofpaloalto.org/ | City 2 | 21.85 | Esther Clark Park | 1965 | |
4297 | 4297 | 4296 | {"type": "Polygon", "coordinates": [[[-122.20028, 37.35643], [-122.20024, 37.35647], [-122.19706, 37.35796], [-122.1956, 37.35913], [-122.19551, 37.35915], [-122.19284, 37.36128], [-122.19343, 37.364], [-122.19163, 37.36491], [-122.19121, 37.36487], [-122.18979, 37.36548], [-122.18785, 37.36605], [-122.18758, 37.36631], [-122.18746, 37.3668], [-122.1858, 37.36661], [-122.18362, 37.36569], [-122.1833, 37.36619], [-122.18307, 37.36647], [-122.18209, 37.36668], [-122.18172, 37.36693], [-122.18155, 37.3674], [-122.18133, 37.36761], [-122.18086, 37.36775], [-122.18039, 37.36775], [-122.17994, 37.36759], [-122.17931, 37.36763], [-122.17847, 37.36744], [-122.17787, 37.36834], [-122.17612, 37.3684], [-122.17396, 37.37054], [-122.17031, 37.37008], [-122.17135, 37.36699], [-122.17198, 37.36518], [-122.17335, 37.36092], [-122.17368, 37.36063], [-122.1744, 37.36061], [-122.17451, 37.36045], [-122.17473, 37.36023], [-122.17521, 37.35985], [-122.17572, 37.35871], [-122.17541, 37.35837], [-122.17478, 37.35829], [-122.1746, 37.35829], [-122.17433, 37.35832], [-122.17417, 37.35828], [-122.17865, 37.34535], [-122.18261, 37.33356], [-122.18261, 37.33335], [-122.18272, 37.333], [-122.18278, 37.33298], [-122.18293, 37.33313], [-122.18307, 37.33336], [-122.18316, 37.3336], [-122.18354, 37.33423], [-122.18396, 37.33471], [-122.18422, 37.33493], [-122.18425, 37.33503], [-122.18425, 37.33511], [-122.18433, 37.33527], [-122.18455, 37.33559], [-122.18472, 37.33589], [-122.18511, 37.33643], [-122.18569, 37.33745], [-122.18575, 37.33775], [-122.18573, 37.33808], [-122.18575, 37.33829], [-122.1858, 37.33847], [-122.18587, 37.33862], [-122.18598, 37.33872], [-122.18642, 37.33897], [-122.18674, 37.33917], [-122.18701, 37.33938], [-122.18755, 37.33983], [-122.18816, 37.34023], [-122.18896, 37.34079], [-122.18981, 37.34152], [-122.19022, 37.34193], [-122.19054, 37.34227], [-122.19063, 37.34234], [-122.19078, 37.34256], [-122.19104, 37.34304], [-122.19123, 37.34331], [-122.19132, 37.3434], [-122.19172, 37.34369], [-122.19225, 37.34397], [-122.19245, 37.34411], [-122.19334, 37.34485], [-122.19415, 37.34572], [-122.19477, 37.34656], [-122.19495, 37.34674], [-122.19507, 37.3469], [-122.19527, 37.34727], [-122.19537, 37.34737], [-122.19573, 37.34791], [-122.19587, 37.34819], [-122.19587, 37.34861], [-122.19583, 37.34881], [-122.19585, 37.34915], [-122.19597, 37.3496], [-122.19595, 37.34979], [-122.19585, 37.34997], [-122.19578, 37.35027], [-122.19576, 37.35063], [-122.19589, 37.35103], [-122.19597, 37.35123], [-122.19616, 37.35138], [-122.19628, 37.35152], [-122.19681, 37.35201], [-122.19698, 37.35212], [-122.19724, 37.35244], [-122.19734, 37.35259], [-122.19748, 37.35297], [-122.19769, 37.35325], [-122.19788, 37.35361], [-122.19802, 37.35406], [-122.19823, 37.35432], [-122.19849, 37.35445], [-122.19866, 37.35465], [-122.19887, 37.35483], [-122.19921, 37.35517], [-122.19939, 37.35529], [-122.19955, 37.35533], [-122.19972, 37.35545], [-122.19997, 37.35579], [-122.20002, 37.35596], [-122.20014, 37.35615], [-122.20028, 37.35643]]]} | Restricted Access 2 | Foothills Park | 18984 | 1243 | Palo Alto, City of 157 | City 2 | City Agency 2 | http://www.cityofpaloalto.org/ | City 2 | 1303.416 | Foothills Park | 2000 | |
5247 | 5247 | 5246 | {"type": "Polygon", "coordinates": [[[-122.13014, 37.43015], [-122.12886, 37.43144], [-122.12794, 37.43085], [-122.12807, 37.4307], [-122.12758, 37.43039], [-122.1287, 37.42924], [-122.13014, 37.43015]]]} | Open Access 1 | Hoover Park | 20080 | 1243 | Palo Alto, City of 157 | City 2 | City Agency 2 | http://www.cityofpaloalto.org/ | City 2 | 7.016 | Hoover Park | 1955 | |
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 | |
5566 | 5566 | 5565 | {"type": "Polygon", "coordinates": [[[-122.1208, 37.44259], [-122.11901, 37.44439], [-122.11896, 37.44441], [-122.1189, 37.44441], [-122.11862, 37.44417], [-122.11799, 37.44357], [-122.11805, 37.4426], [-122.11637, 37.441], [-122.11573, 37.44141], [-122.11564, 37.44127], [-122.1153, 37.44058], [-122.11656, 37.43987], [-122.1174, 37.44054], [-122.11754, 37.44057], [-122.11798, 37.44033], [-122.11805, 37.44037], [-122.11773, 37.44055], [-122.11773, 37.44057], [-122.1182, 37.44095], [-122.1208, 37.44259]]]} | Open Access 1 | John Lucas Greer Park | 20452 | 1243 | Palo Alto, City of 157 | City 2 | City Agency 2 | http://www.cityofpaloalto.org/ | City 2 | 21.489 | John Lucas Greer Park | 1963 | |
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 | |
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 | ||
7071 | 7071 | 7070 | {"type": "Polygon", "coordinates": [[[-122.11693, 37.42294], [-122.11586, 37.42351], [-122.1151, 37.4226], [-122.11452, 37.42289], [-122.11398, 37.42226], [-122.11284, 37.42285], [-122.11264, 37.42273], [-122.11246, 37.42258], [-122.11211, 37.42217], [-122.11335, 37.42152], [-122.11299, 37.42106], [-122.11332, 37.42087], [-122.11344, 37.42076], [-122.11352, 37.42064], [-122.11343, 37.4206], [-122.11335, 37.42071], [-122.11324, 37.42081], [-122.11293, 37.42099], [-122.11243, 37.42038], [-122.11336, 37.41989], [-122.11345, 37.42002], [-122.11351, 37.42022], [-122.11352, 37.42035], [-122.11347, 37.42054], [-122.11356, 37.42057], [-122.11361, 37.42043], [-122.11362, 37.42021], [-122.11355, 37.41999], [-122.11345, 37.41984], [-122.11408, 37.41951], [-122.11693, 37.42294]]]} | Open Access 1 | Mitchell Park | 22324 | 1243 | Palo Alto, City of 157 | City 2 | City Agency 2 | http://www.cityofpaloalto.org/ | City 2 | 20.875 | Mitchell Park | 1952 | |
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 | |
8064 | 8064 | 8063 | {"type": "Polygon", "coordinates": [[[-122.14838, 37.43222], [-122.14757, 37.43262], [-122.14724, 37.43258], [-122.14592, 37.43175], [-122.14629, 37.43131], [-122.14638, 37.43135], [-122.14666, 37.43138], [-122.1472, 37.43129], [-122.14729, 37.43129], [-122.14793, 37.43162], [-122.14838, 37.43222]]]} | Open Access 1 | Peers Park | 23564 | 1243 | Palo Alto, City of 157 | City 2 | City Agency 2 | http://www.cityofpaloalto.org/ | City 2 | 4.802 | Peers Park | 1926 | |
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 | |
8713 | 8713 | 8712 | {"type": "MultiPolygon", "coordinates": [[[[-122.14058, 37.44459], [-122.14058, 37.44487], [-122.14054, 37.44488], [-122.14054, 37.44511], [-122.13985, 37.44511], [-122.13986, 37.44459], [-122.14058, 37.44459]]], [[[-122.14425, 37.44411], [-122.14416, 37.44423], [-122.14415, 37.44446], [-122.13986, 37.44445], [-122.13986, 37.44359], [-122.14025, 37.44358], [-122.14023, 37.44309], [-122.14166, 37.44267], [-122.14173, 37.44278], [-122.14184, 37.44285], [-122.14186, 37.44298], [-122.14188, 37.44303], [-122.14203, 37.44315], [-122.14207, 37.44321], [-122.14209, 37.44331], [-122.14207, 37.44337], [-122.14203, 37.44343], [-122.14205, 37.4435], [-122.14226, 37.44365], [-122.14277, 37.44372], [-122.14366, 37.44367], [-122.14368, 37.44363], [-122.14396, 37.44364], [-122.14402, 37.44378], [-122.14423, 37.44394], [-122.14425, 37.44411]]]]} | Open Access 1 | Rinconada Park | 24372 | 1243 | Palo Alto, City of 157 | City 2 | City Agency 2 | http://www.cityofpaloalto.org/ | City 2 | 12.606 | Rinconada Park | 1922 |
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]);