superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
4 rows where ACRES = "0.248"
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP
ACCESS_TYP 2
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1580 | 1580 | 1579 | {"type": "Polygon", "coordinates": [[[-120.57744, 35.12353], [-120.57711, 35.12368], [-120.57694, 35.1235], [-120.57731, 35.1233], [-120.57744, 35.12353]]]} | Open Access 1 | Village Green | 27113 | 1454 | Arroyo Grande, City of 600 | City 2 | City Agency 2 | http://www.arroyogrande.org/ | City 2 | 0.248 | Village Green | ||
1899 | 1899 | 1898 | {"type": "Polygon", "coordinates": [[[-122.2734, 37.81151], [-122.27319, 37.81157], [-122.27305, 37.81166], [-122.27319, 37.81109], [-122.27321, 37.81107], [-122.27324, 37.81107], [-122.27326, 37.81109], [-122.2734, 37.81151]]]} | Open Access 1 | Begin Plaza Park | 15954 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 0.248 | Begin Plaza Park | ||
8872 | 8872 | 8871 | {"type": "Polygon", "coordinates": [[[-122.24362, 37.84525], [-122.24333, 37.84541], [-122.2431, 37.84557], [-122.24304, 37.84555], [-122.24291, 37.84531], [-122.24294, 37.84529], [-122.24336, 37.84527], [-122.24362, 37.84525]]]} | Open Access 1 | Rockridge Park | 24533 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 0.248 | Rockridge Park | ||
14327 | 14327 | 14326 | {"type": "Polygon", "coordinates": [[[-118.25828, 33.88611], [-118.25795, 33.88612], [-118.25789, 33.88584], [-118.25805, 33.88581], [-118.25821, 33.88581], [-118.25828, 33.88611]]]} | No Public Access 3 | Unnamed site - Carson, City of | 29713 | 1400 | Los Angeles - Department of Water and Power, City of 278 | City 2 | City Agency 2 | http://www.ladwp.com/ | City 2 | 0.248 |
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]);