superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where MNG_AG_TYP = 4 and PARK_URL = "http://www.ebparks.org/parks/kennedy"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
413 | 413 | 412 | {"type": "Polygon", "coordinates": [[[-122.26941, 37.95602], [-122.26837, 37.95734], [-122.26599, 37.95498], [-122.26344, 37.95587], [-122.26117, 37.9548], [-122.25983, 37.95454], [-122.25946, 37.95486], [-122.25818, 37.95369], [-122.25423, 37.94996], [-122.25637, 37.94855], [-122.25637, 37.94853], [-122.25595, 37.94817], [-122.25938, 37.94547], [-122.25949, 37.94554], [-122.2597, 37.94571], [-122.25984, 37.94571], [-122.25994, 37.94566], [-122.26004, 37.94558], [-122.2666, 37.94626], [-122.26733, 37.94758], [-122.26754, 37.94784], [-122.26408, 37.94964], [-122.26424, 37.94986], [-122.26431, 37.95016], [-122.26465, 37.95013], [-122.26471, 37.95039], [-122.26638, 37.95045], [-122.26638, 37.95097], [-122.26555, 37.95135], [-122.26489, 37.95103], [-122.26445, 37.95156], [-122.26422, 37.95236], [-122.26577, 37.95294], [-122.26736, 37.95407], [-122.26771, 37.95451], [-122.26812, 37.95439], [-122.26893, 37.95492], [-122.26888, 37.95507], [-122.26876, 37.95561], [-122.26941, 37.95602]]]} | Open Access 1 | Kennedy Grove Regional Recreation Area | http://www.ebparks.org/parks/kennedy | 3271 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 217.932 | Kennedy Grove Reg. Rec. Area | 1967 |
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]);