superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where MNG_AG_TYP = 5 and PARK_URL = "https://www.wildlife.ca.gov/Lands/Places-to-Visit/Honey-Lake-WA"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11875 | 11875 | 11874 | {"type": "MultiPolygon", "coordinates": [[[[-120.3144, 40.35906], [-120.30965, 40.3591], [-120.30972, 40.36428], [-120.30498, 40.36331], [-120.30309, 40.36278], [-120.29033, 40.36014], [-120.29033, 40.35925], [-120.28632, 40.35929], [-120.28077, 40.35826], [-120.28072, 40.35573], [-120.26879, 40.35577], [-120.26656, 40.35527], [-120.26649, 40.35217], [-120.2664, 40.3421], [-120.27616, 40.33409], [-120.28486, 40.32615], [-120.28537, 40.32615], [-120.2854, 40.32255], [-120.28527, 40.32253], [-120.28531, 40.32139], [-120.2854, 40.31295], [-120.28618, 40.31273], [-120.2876, 40.31248], [-120.28902, 40.31234], [-120.29018, 40.31228], [-120.29027, 40.31494], [-120.30463, 40.31533], [-120.30941, 40.31531], [-120.30938, 40.32259], [-120.3023, 40.32259], [-120.30232, 40.32619], [-120.30232, 40.32987], [-120.29513, 40.32987], [-120.29506, 40.33734], [-120.29033, 40.33738], [-120.29027, 40.34461], [-120.30476, 40.34452], [-120.3048, 40.34814], [-120.31426, 40.34812], [-120.31429, 40.3518], [-120.3144, 40.35906]]], [[[-120.28374, 40.3593], [-120.28274, 40.35931], [-120.28261, 40.35934], [-120.2808, 40.35923], [-120.28079, 40.35873], [-120.28374, 40.3593]]], [[[-120.30069, 40.36279], [-120.29039, 40.36289], [-120.29035, 40.36069], [-120.29243, 40.36112], [-120.30069, 40.36279]]], [[[-120.30976, 40.36643], [-120.30502, 40.36648], [-120.30498, 40.36385], [-120.30972, 40.36477], [-120.30976, 40.36643]]], [[[-120.33755, 40.30386], [-120.33553, 40.30225], [-120.33367, 40.30414], [-120.33031, 40.30184], [-120.33717, 40.2974], [-120.33755, 40.30386]]], [[[-120.42039, 40.30187], [-120.41568, 40.30193], [-120.41573, 40.30725], [-120.41583, 40.3145], [-120.40812, 40.3146], [-120.40818, 40.32178], [-120.39877, 40.32185], [-120.37044, 40.3222], [-120.37036, 40.31859], [-120.36566, 40.31867], [-120.36092, 40.31879], [-120.35622, 40.31881], [-120.35611, 40.31156], [-120.34192, 40.31165], [-120.34189, 40.30806], [-120.34631, 40.30436], [-120.35104, 40.30434], [-120.35105, 40.30433], [-120.35095, 40.30073], [-120.34179, 40.30076], [-120.34177, 40.29732], [-120.34169, 40.29354], [-120.34648, 40.29347], [-120.35177, 40.29286], [-120.36512, 40.29112], [-120.36917, 40.29015], [-120.37056, 40.2892], [-120.3746, 40.28835], [-120.37935, 40.28756], [-120.37998, 40.2873], [-120.38387, 40.28701], [-120.38413, 40.28701], [-120.38413, 40.28953], [-120.39365, 40.28935], [-120.39365, 40.2929], [-120.40789, 40.2928], [-120.40788, 40.29639], [-120.40316, 40.29644], [-120.40319, 40.30006], [-120.42037, 40.29994], [-120.42039, 40.30187]], [[-120.38936, 40.30745], [-120.38937, 40.30743], [-120.38928, 40.30101], [-120.38941, 40.30092], [-120.38947, 40.30075], [-120.38943, 40.30066], [-120.38935, 40.30056], [-120.38922, 40.30051], [-120.38908, 40.30049], [-120.38893, 40.30053], [-120.38885, 40.30058], [-120.38876, 40.30071], [-120.38878, 40.3008], [-120.38883, 40.30091], [-120.38896, 40.301], [-120.38902, 40.30743], [-120.38936, 40.30745]]]]} | Open Access 1 | Honey Lake Wildlife Area | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Honey-Lake-WA | 30454 | 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 | 7584.371 | Honey Lake Wildlife Area | 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]);