superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
6 rows where ACCESS_TYP = 1 and PARK_NAME = "Garfield Park"
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY
MNG_AG_TYP 1
ACCESS_TYP 1
- Open Access · 6 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3552 | 3552 | 3551 | {"type": "Polygon", "coordinates": [[[-118.16982, 33.89865], [-118.16899, 33.89865], [-118.16899, 33.89833], [-118.16906, 33.89827], [-118.16982, 33.89827], [-118.16982, 33.89865]]]} | Open Access 1 | Garfield Park | 19214 | 1245 | Paramount, City of 281 | City 2 | City Agency 2 | http://www.paramountcity.com/ps.parksrecreation.cfm?ID=6 | City 2 | 0.794 | Garfield Park | ||
4064 | 4064 | 4063 | {"type": "Polygon", "coordinates": [[[-117.7344, 34.06396], [-117.73343, 34.06398], [-117.73339, 34.06293], [-117.7344, 34.06291], [-117.7344, 34.06396]]]} | Open Access 1 | Garfield Park | 19215 | 1258 | Pomona, City of 125 | City 2 | City Agency 2 | http://ci.pomona.ca.us/index.php/visitors/park-directory | City 2 | 2.654 | Garfield Park | ||
4070 | 4070 | 4069 | {"type": "Polygon", "coordinates": [[[-122.04308, 36.95834], [-122.04233, 36.95843], [-122.04218, 36.95748], [-122.04293, 36.95738], [-122.04308, 36.95834]]]} | Open Access 1 | Garfield Park | 19216 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.cityofsantacruz.com/departments/parks-recreation | City 2 | 1.778 | Garfield Park | ||
4399 | 4399 | 4398 | {"type": "Polygon", "coordinates": [[[-122.23485, 37.78563], [-122.23432, 37.7862], [-122.23352, 37.78576], [-122.23411, 37.78532], [-122.23485, 37.78563]]]} | Open Access 1 | Garfield Park | 19213 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1.445 | Garfield Park | ||
4498 | 4498 | 4497 | {"type": "Polygon", "coordinates": [[[-118.14761, 34.11561], [-118.14713, 34.11686], [-118.14711, 34.11686], [-118.14708, 34.11692], [-118.14706, 34.11702], [-118.14668, 34.11802], [-118.14657, 34.11825], [-118.14637, 34.11854], [-118.14609, 34.11883], [-118.14581, 34.11883], [-118.14576, 34.1182], [-118.14641, 34.11565], [-118.14761, 34.11561]]]} | Open Access 1 | Garfield Park | 19217 | 1340 | South Pasadena, City of 306 | City 2 | City Agency 2 | http://www.ci.south-pasadena.ca.us/ | City 2 | 7.505 | Garfield Park | ||
4499 | 4499 | 4498 | {"type": "Polygon", "coordinates": [[[-122.30257, 38.33174], [-122.30009, 38.33299], [-122.29868, 38.33123], [-122.29887, 38.33115], [-122.29897, 38.33107], [-122.29953, 38.33077], [-122.29956, 38.33078], [-122.29991, 38.33061], [-122.30058, 38.33052], [-122.30079, 38.33048], [-122.3009, 38.33044], [-122.30104, 38.33034], [-122.30124, 38.33028], [-122.30135, 38.33029], [-122.30139, 38.33028], [-122.30257, 38.33174]]]} | Open Access 1 | Garfield Park | 19218 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 14.0 | Garfield Park |
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]);