units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
37 rows where MNG_AGENCY = 157 sorted by GAP_STS
This data as json, copyable, CSV (advanced)
ACCESS_TYP 2
MNG_AG_TYP 1
- City Agency 17
MNG_AGENCY 1
- Palo Alto, City of · 17 ✖
DES_TP 1
- Local Park 17
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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8830 | 8830 | 8829 | {"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 | 16038 | Eleanor Pardee Park | 18556 | 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 | 9.675 | Eleanor Pardee Park | 1920 | Local Park 2 | 4 | |
9002 | 9002 | 9001 | {"type": "Polygon", "coordinates": [[[-122.12346, 37.41546], [-122.12335, 37.41556], [-122.12328, 37.41552], [-122.12251, 37.4162], [-122.12163, 37.41564], [-122.12112, 37.41537], [-122.12212, 37.41449], [-122.12346, 37.41546]]]} | Open Access 1 | 15199 | Robles Park | 24505 | 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.691 | Robles Park | 1956 | 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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
9511 | 9511 | 9510 | {"type": "Polygon", "coordinates": [[[-122.16977, 37.44657], [-122.16838, 37.4457], [-122.16687, 37.44457], [-122.16699, 37.44444], [-122.16685, 37.44406], [-122.16645, 37.44381], [-122.16671, 37.44355], [-122.16623, 37.4432], [-122.16534, 37.44264], [-122.16536, 37.44257], [-122.16544, 37.44253], [-122.16695, 37.4435], [-122.16738, 37.44386], [-122.16795, 37.44425], [-122.16812, 37.44438], [-122.16897, 37.44518], [-122.16909, 37.44523], [-122.16924, 37.44521], [-122.17031, 37.44605], [-122.17066, 37.44636], [-122.17072, 37.44644], [-122.1707, 37.44647], [-122.17056, 37.44651], [-122.16977, 37.44657]]]} | Open Access 1 | 15953 | El Camino Park | 33377 | 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 | 9.439 | El Camino Park | 1914 | Local Park 2 | 4 | |
9612 | 9612 | 9611 | {"type": "Polygon", "coordinates": [[[-122.14069, 37.3925], [-122.13956, 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.13633, 37.38957], [-122.13507, 37.38952], [-122.13507, 37.38854], [-122.13633, 37.38859], [-122.13695, 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 | 16180 | Esther Clark Park | 18727 | 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 | 21.824 | Esther Clark Park | 1965 | Local Park 2 | 4 | |
9733 | 9733 | 9732 | {"type": "Polygon", "coordinates": [[[-122.20028, 37.35643], [-122.20024, 37.35647], [-122.19706, 37.35796], [-122.1956, 37.35913], [-122.19551, 37.35915], [-122.19283, 37.36128], [-122.19343, 37.364], [-122.19163, 37.36491], [-122.19121, 37.36486], [-122.18979, 37.36548], [-122.18785, 37.36605], [-122.18758, 37.36631], [-122.18746, 37.3668], [-122.18581, 37.36661], [-122.18362, 37.36568], [-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.36062], [-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.33774], [-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.3488], [-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.1992, 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 | 16498 | Foothills Park | 18984 | 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 | 1303.372 | Foothills Park | 2000 | Local Park 2 | 4 | |
10490 | 10490 | 10489 | {"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 | 18587 | Peers Park | 23564 | 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.803 | Peers Park | 1926 | 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 | |
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 | |
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 |
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]);