units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where DES_TP = 8 and SUID_NMA = 30491
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | id | map | ACCESS_TYP | UNIT_ID | UNIT_NAME | SUID_NMA | AGNCY_ID | AGNCY_NAME | AGNCY_LEV | AGNCY_TYP | AGNCY_WEB | LAYER | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | PARK_URL | COUNTY | ACRES | LABEL_NAME | YR_EST | DES_TP | GAP_STS |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5517 | 5517 | 5516 | {"type": "MultiPolygon", "coordinates": [[[[-119.95634, 38.71971], [-119.95634, 38.72329], [-119.95166, 38.72325], [-119.95168, 38.71982], [-119.95175, 38.71981], [-119.95176, 38.71976], [-119.95627, 38.71969], [-119.95628, 38.71971], [-119.95634, 38.71971]]], [[[-119.96098, 38.70512], [-119.956, 38.70507], [-119.95595, 38.70137], [-119.96086, 38.70139], [-119.96093, 38.70508], [-119.96098, 38.70512]]], [[[-119.96537, 38.68314], [-119.96078, 38.68316], [-119.96075, 38.68315], [-119.96072, 38.67619], [-119.96075, 38.67616], [-119.96075, 38.67577], [-119.96525, 38.67573], [-119.96537, 38.68314]]], [[[-119.98409, 38.70137], [-119.97475, 38.70153], [-119.97477, 38.70426], [-119.97402, 38.7044], [-119.97321, 38.70452], [-119.97231, 38.70459], [-119.97089, 38.7048], [-119.97027, 38.70492], [-119.96945, 38.70491], [-119.96901, 38.70476], [-119.96813, 38.7044], [-119.96786, 38.70425], [-119.9676, 38.70404], [-119.96738, 38.70379], [-119.96725, 38.70359], [-119.96708, 38.70327], [-119.96695, 38.70295], [-119.96687, 38.70217], [-119.96678, 38.70021], [-119.96673, 38.69977], [-119.96657, 38.69949], [-119.96636, 38.69929], [-119.96612, 38.69909], [-119.96605, 38.69839], [-119.966, 38.69814], [-119.96588, 38.69785], [-119.96569, 38.69744], [-119.96549, 38.69717], [-119.96524, 38.69701], [-119.9652, 38.69405], [-119.96079, 38.69407], [-119.96075, 38.6904], [-119.96977, 38.69038], [-119.96975, 38.68689], [-119.97469, 38.68689], [-119.9747, 38.69405], [-119.98407, 38.69397], [-119.98409, 38.70137]]], [[[-119.96575, 38.74152], [-119.961, 38.74152], [-119.96102, 38.7379], [-119.96097, 38.73427], [-119.961, 38.73427], [-119.96102, 38.73424], [-119.96108, 38.73424], [-119.96113, 38.73428], [-119.96569, 38.73427], [-119.96575, 38.74152]]], [[[-119.97452, 38.67576], [-119.96983, 38.67573], [-119.96489, 38.67568], [-119.96485, 38.67263], [-119.97445, 38.67245], [-119.97452, 38.67576]]]]} | Open Access 1 | 22165 | Red Lake Wildlife Area | 30491 | 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 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Red-Lake-WA | Alpine 51 | 861.648 | Red Lake Wildlife Area | 1988 | State Conservation Area 8 | 2 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([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([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);