superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where MNG_AGENCY = 47, MNG_AG_TYP = 5 and PARK_NAME = "Emerald Bay State Park"
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- State Agency · 1 ✖
MNG_AGENCY 1
- California Department of Parks and Recreation · 1 ✖
ACCESS_TYP 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15268 | 15268 | 15267 | {"type": "Polygon", "coordinates": [[[-120.11123, 38.95078], [-120.11122, 38.95411], [-120.11094, 38.95439], [-120.11033, 38.95475], [-120.1101, 38.95493], [-120.10987, 38.95525], [-120.10972, 38.95562], [-120.10927, 38.95629], [-120.1087, 38.9568], [-120.10769, 38.95759], [-120.10724, 38.95777], [-120.10604, 38.95815], [-120.10549, 38.95837], [-120.10227, 38.95843], [-120.10228, 38.96101], [-120.10208, 38.9612], [-120.10178, 38.96144], [-120.10145, 38.96163], [-120.10093, 38.96197], [-120.09796, 38.96197], [-120.09798, 38.96568], [-120.0937, 38.96566], [-120.09332, 38.96568], [-120.08934, 38.96883], [-120.08934, 38.96885], [-120.08937, 38.96884], [-120.08402, 38.97336], [-120.0741, 38.96542], [-120.0746, 38.95335], [-120.07811, 38.95344], [-120.08426, 38.95142], [-120.08429, 38.95148], [-120.08435, 38.95152], [-120.0846, 38.95153], [-120.08499, 38.95149], [-120.08637, 38.95111], [-120.08667, 38.95104], [-120.08762, 38.95094], [-120.08785, 38.95096], [-120.08788, 38.95106], [-120.0878, 38.95123], [-120.08769, 38.95137], [-120.08767, 38.95149], [-120.08771, 38.95152], [-120.08782, 38.95154], [-120.08816, 38.95143], [-120.08871, 38.95102], [-120.08962, 38.95048], [-120.09025, 38.94995], [-120.09095, 38.9496], [-120.09134, 38.94937], [-120.09176, 38.94915], [-120.09211, 38.94893], [-120.09309, 38.9485], [-120.09358, 38.94832], [-120.09443, 38.94786], [-120.09784, 38.94773], [-120.1073, 38.94752], [-120.10838, 38.94803], [-120.10888, 38.94834], [-120.10908, 38.94857], [-120.10927, 38.94888], [-120.10938, 38.94899], [-120.10955, 38.94916], [-120.11006, 38.94947], [-120.11056, 38.94998], [-120.11123, 38.95078]]]} | Open Access 1 | Emerald Bay State Park | http://www.parks.ca.gov/?page_id=506 | 1951 | 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 | 1339.84 | Emerald Bay SP | 1953 |
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]);