units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 1, MNG_AGENCY = 25 and PARK_URL = "https://www.wildlife.ca.gov/Lands/Places-to-Visit/Coon-Hollow-WA"
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP, DES_TP
ACCESS_TYP 1
- Open Access · 1 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16677 | 16677 | 16676 | {"type": "MultiPolygon", "coordinates": [[[[-121.447, 40.0526], [-121.44686, 40.057], [-121.44208, 40.057], [-121.44228, 40.05255], [-121.42801, 40.05254], [-121.42829, 40.04877], [-121.44244, 40.04882], [-121.44229, 40.05254], [-121.447, 40.0526]]], [[[-121.48715, 40.05814], [-121.48686, 40.05837], [-121.48664, 40.05858], [-121.48626, 40.05858], [-121.48613, 40.05892], [-121.48606, 40.05924], [-121.48588, 40.05964], [-121.48517, 40.0602], [-121.48459, 40.06031], [-121.48363, 40.06053], [-121.48289, 40.0608], [-121.48162, 40.06154], [-121.48136, 40.06165], [-121.48102, 40.06172], [-121.48096, 40.06056], [-121.47642, 40.06054], [-121.47641, 40.06412], [-121.46218, 40.06418], [-121.46221, 40.05703], [-121.46531, 40.05702], [-121.48686, 40.05714], [-121.48686, 40.05813], [-121.48715, 40.05814]]], [[[-121.42873, 40.08609], [-121.42883, 40.08262], [-121.44297, 40.08259], [-121.44729, 40.08264], [-121.44649, 40.08286], [-121.44519, 40.08343], [-121.44403, 40.08382], [-121.44209, 40.08409], [-121.44046, 40.08457], [-121.43865, 40.08525], [-121.4365, 40.08642], [-121.43563, 40.08655], [-121.43472, 40.08685], [-121.43439, 40.0871], [-121.43419, 40.08764], [-121.43369, 40.08794], [-121.43329, 40.08838], [-121.43323, 40.08859], [-121.43338, 40.08926], [-121.433, 40.08977], [-121.4287, 40.08975], [-121.42873, 40.08609]]], [[[-121.44781, 40.08265], [-121.44768, 40.08609], [-121.44294, 40.08606], [-121.43821, 40.08607], [-121.43825, 40.08978], [-121.43325, 40.08977], [-121.43359, 40.08929], [-121.43348, 40.08845], [-121.43384, 40.08806], [-121.43437, 40.08774], [-121.43457, 40.08718], [-121.43482, 40.08699], [-121.43569, 40.08671], [-121.43661, 40.08657], [-121.4386, 40.08547], [-121.44071, 40.08467], [-121.44214, 40.08425], [-121.44421, 40.08394], [-121.44516, 40.08362], [-121.44659, 40.08301], [-121.44781, 40.08265]]]]} | Open Access 1 | 61 | Coon Hollow Wildlife Area | 30428 | 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/Coon-Hollow-WA | Butte 42 | 721.573 | Coon Hollow Wildlife Area | 1980 | 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]);