superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
3 rows where ACRES = "0.981" and MNG_AG_TYP = 2
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2077 | 2077 | 2076 | {"type": "Polygon", "coordinates": [[[-121.5211, 38.67146], [-121.52034, 38.6716], [-121.52019, 38.6711], [-121.52096, 38.67095], [-121.5211, 38.67146]]]} | Open Access 1 | Blue Oak Park | 16180 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 0.981 | Blue Oak Park | ||
3665 | 3665 | 3664 | {"type": "Polygon", "coordinates": [[[-122.27064, 37.90131], [-122.27015, 37.9015], [-122.26976, 37.90154], [-122.26967, 37.90149], [-122.26967, 37.90134], [-122.27008, 37.90083], [-122.27047, 37.90104], [-122.27064, 37.90131]]]} | Open Access 1 | Dorothy Bolte Park | 18222 | 1028 | Berkeley, City of 334 | City 2 | City Agency 2 | http://www.ci.berkeley.ca.us/PRW/ | City 2 | 0.981 | Dorothy Bolte Park | ||
6702 | 6702 | 6701 | {"type": "Polygon", "coordinates": [[[-118.16696, 33.97193], [-118.16688, 33.97253], [-118.16625, 33.97247], [-118.16632, 33.97187], [-118.16696, 33.97193]]]} | Open Access 1 | Marlow Park | 21881 | 1023 | Bell Gardens, City of 222 | City 2 | City Agency 2 | http://www.bellgardens.org/GOVERNMENT/CityDepartments/RecreationCommunityServices/ParksandFacilities.aspx | City 2 | 0.981 | Marlow 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]);