superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where MNG_AGENCY = 47 and YR_EST = 1961
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15135 | 15135 | 15134 | {"type": "Polygon", "coordinates": [[[-119.26541, 34.23599], [-119.25688, 34.23631], [-119.25665, 34.23018], [-119.25652, 34.23016], [-119.2563, 34.22443], [-119.25623, 34.2237], [-119.25614, 34.22326], [-119.25605, 34.22289], [-119.25925, 34.22208], [-119.25584, 34.21311], [-119.25536, 34.21313], [-119.25535, 34.21369], [-119.25557, 34.2153], [-119.25603, 34.21657], [-119.25298, 34.21527], [-119.25194, 34.21237], [-119.25072, 34.21269], [-119.25045, 34.21219], [-119.25285, 34.21153], [-119.25283, 34.21005], [-119.25324, 34.20933], [-119.25376, 34.20932], [-119.25348, 34.20878], [-119.25476, 34.2088], [-119.25541, 34.21015], [-119.25619, 34.21166], [-119.25708, 34.21368], [-119.25742, 34.21446], [-119.25792, 34.21579], [-119.25844, 34.21739], [-119.25874, 34.21817], [-119.25908, 34.21895], [-119.26053, 34.22202], [-119.26063, 34.22255], [-119.26124, 34.22411], [-119.26196, 34.22565], [-119.26245, 34.22696], [-119.26397, 34.23119], [-119.26469, 34.2336], [-119.2649, 34.23441], [-119.26541, 34.23599]], [[-119.26099, 34.22684], [-119.26061, 34.22637], [-119.25995, 34.22672], [-119.26051, 34.22738], [-119.26114, 34.22705], [-119.26099, 34.22684]], [[-119.26257, 34.23415], [-119.26258, 34.23413], [-119.26233, 34.2335], [-119.26151, 34.23355], [-119.26177, 34.23419], [-119.26257, 34.23415]]]} | Open Access 1 | McGrath State Beach | http://www.parks.ca.gov/?page_id=607 | 1629 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 308.789 | McGrath SB | 1961 |
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]);