superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
36 rows where MNG_AGENCY = 157 sorted by LABEL_NAME
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | ||
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 | |
8840 | 8840 | 8839 | {"type": "Polygon", "coordinates": [[[-122.12346, 37.41546], [-122.12335, 37.41556], [-122.12327, 37.41553], [-122.12251, 37.4162], [-122.12163, 37.41564], [-122.12112, 37.41537], [-122.12212, 37.41449], [-122.12346, 37.41546]]]} | Open Access 1 | Robles Park | 24505 | 1243 | Palo Alto, City of 157 | City 2 | City Agency 2 | http://www.cityofpaloalto.org/ | City 2 | 4.691 | Robles Park | 1956 | |
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 | ||
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 | |
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 | |
10286 | 10286 | 10285 | {"type": "Polygon", "coordinates": [[[-122.12673, 37.40193], [-122.12661, 37.40184], [-122.12648, 37.40197], [-122.12604, 37.40189], [-122.12565, 37.40208], [-122.12556, 37.40226], [-122.12552, 37.40242], [-122.1254, 37.40246], [-122.12533, 37.40254], [-122.12512, 37.40323], [-122.12444, 37.40294], [-122.1239, 37.40228], [-122.12396, 37.40223], [-122.12422, 37.40168], [-122.12432, 37.40153], [-122.12442, 37.40133], [-122.12661, 37.40112], [-122.12673, 37.40193]]]} | Open Access 1 | Terman Park | 26250 | 1243 | Palo Alto, City of 157 | City 2 | City Agency 2 | http://www.cityofpaloalto.org/ | City 2 | 7.665 | Terman Park | 1985 | |
10370 | 10370 | 10369 | {"type": "Polygon", "coordinates": [[[-122.168, 37.44966], [-122.1679, 37.45019], [-122.16792, 37.45081], [-122.16731, 37.45104], [-122.16636, 37.4508], [-122.16592, 37.45103], [-122.16577, 37.45165], [-122.16545, 37.45228], [-122.16541, 37.45294], [-122.16474, 37.453], [-122.16422, 37.45262], [-122.16384, 37.45288], [-122.16347, 37.45324], [-122.16297, 37.45348], [-122.16226, 37.45406], [-122.16154, 37.45412], [-122.16082, 37.45422], [-122.16066, 37.45458], [-122.15943, 37.45465], [-122.15886, 37.45421], [-122.15834, 37.4536], [-122.15739, 37.45358], [-122.15695, 37.45407], [-122.15629, 37.45426], [-122.15563, 37.4545], [-122.1557, 37.45494], [-122.15599, 37.45547], [-122.15528, 37.45588], [-122.15456, 37.45616], [-122.15335, 37.45693], [-122.15259, 37.45766], [-122.15214, 37.45766], [-122.15167, 37.45714], [-122.15034, 37.45721], [-122.15106, 37.45697], [-122.15184, 37.45683], [-122.15246, 37.45695], [-122.15328, 37.45627], [-122.15437, 37.45554], [-122.15535, 37.45513], [-122.15507, 37.45446], [-122.15588, 37.45378], [-122.15644, 37.45373], [-122.15705, 37.45336], [-122.15777, 37.45335], [-122.15911, 37.45337], [-122.1597, 37.4542], [-122.16008, 37.45415], [-122.16063, 37.45383], [-122.16124, 37.45351], [-122.16258, 37.45357], [-122.16274, 37.45335], [-122.16312, 37.45294], [-122.16378, 37.45248], [-122.16439, 37.45238], [-122.16494, 37.45215], [-122.16557, 37.45081], [-122.1665, 37.45017], [-122.16691, 37.4506], [-122.16741, 37.45055], [-122.16756, 37.45007], [-122.1676, 37.44958], [-122.16726, 37.44914], [-122.16736, 37.44891], [-122.16773, 37.44828], [-122.16781, 37.44895], [-122.16782, 37.44926], [-122.168, 37.44966]]]} | Open Access 1 | Timothy Hopkins Park | 26372 | 1243 | Palo Alto, City of 157 | City 2 | City Agency 2 | http://www.cityofpaloalto.org/ | City 2 | 27.365 | Timothy Hopkins Park | 1907 | |
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 |
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]);