superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 2, MNG_AGENCY = 25 and PARK_NAME = "Little Red Mountain Ecological Reserve"
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
MNG_AGENCY 1
- California Department of Fish and Wildlife · 1 ✖
ACCESS_TYP 1
- Restricted Access · 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15311 | 15311 | 15310 | {"type": "Polygon", "coordinates": [[[-123.67585, 39.86241], [-123.67556, 39.87486], [-123.67546, 39.87608], [-123.66682, 39.87604], [-123.65783, 39.87597], [-123.65713, 39.87595], [-123.64776, 39.87607], [-123.64804, 39.87287], [-123.64796, 39.86931], [-123.65256, 39.86915], [-123.65252, 39.86823], [-123.65018, 39.8683], [-123.65019, 39.8676], [-123.64794, 39.86771], [-123.6478, 39.86589], [-123.64302, 39.86603], [-123.64322, 39.8728], [-123.64298, 39.87609], [-123.64382, 39.8761], [-123.64373, 39.8869], [-123.63912, 39.88694], [-123.63453, 39.88701], [-123.63448, 39.89067], [-123.63451, 39.89445], [-123.6299, 39.89439], [-123.62987, 39.89068], [-123.63, 39.88714], [-123.6205, 39.88727], [-123.62047, 39.88367], [-123.61607, 39.88359], [-123.61609, 39.87995], [-123.61591, 39.87629], [-123.62046, 39.87631], [-123.62508, 39.87626], [-123.62501, 39.8729], [-123.62042, 39.87286], [-123.62036, 39.86924], [-123.61593, 39.86919], [-123.61593, 39.86211], [-123.61588, 39.85855], [-123.61596, 39.85496], [-123.61593, 39.85382], [-123.61593, 39.85146], [-123.62052, 39.85156], [-123.6206, 39.84809], [-123.6254, 39.84806], [-123.62975, 39.84811], [-123.63881, 39.84816], [-123.6388, 39.84454], [-123.64339, 39.84452], [-123.64332, 39.84811], [-123.64321, 39.85176], [-123.64302, 39.86258], [-123.6478, 39.86253], [-123.64782, 39.86589], [-123.65242, 39.86566], [-123.65235, 39.86245], [-123.65734, 39.86238], [-123.67167, 39.86238], [-123.67585, 39.86241]], [[-123.6339, 39.85532], [-123.63389, 39.85531], [-123.62946, 39.85528], [-123.62044, 39.85511], [-123.62028, 39.86222], [-123.62034, 39.86565], [-123.62453, 39.86567], [-123.62946, 39.8659], [-123.62954, 39.86679], [-123.63389, 39.86676], [-123.63381, 39.86255], [-123.6339, 39.85532]], [[-123.63372, 39.87352], [-123.63371, 39.87351], [-123.62954, 39.87358], [-123.62941, 39.87615], [-123.63373, 39.87613], [-123.63372, 39.87352]]]} | Restricted Access 2 | Little Red Mountain Ecological Reserve | 21355 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 2942.703 | Little Red Mtn. ER |
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]);