units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where LABEL_NAME = "Honey Lake Wildlife Area" and MNG_AG_TYP = 5
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16724 | 16724 | 16723 | {"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.28073, 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.28538, 40.32615], [-120.2854, 40.32254], [-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.29032, 40.33738], [-120.29027, 40.34461], [-120.30476, 40.34452], [-120.30479, 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.42039, 40.30187], [-120.41568, 40.30193], [-120.41573, 40.30725], [-120.41583, 40.3145], [-120.40811, 40.3146], [-120.40818, 40.32178], [-120.39877, 40.32185], [-120.39861, 40.31108], [-120.40334, 40.31103], [-120.40327, 40.30735], [-120.39855, 40.30742], [-120.38937, 40.30745], [-120.38986, 40.32196], [-120.37044, 40.3222], [-120.37037, 40.31859], [-120.36566, 40.31867], [-120.36092, 40.31879], [-120.35622, 40.31881], [-120.35612, 40.31156], [-120.34192, 40.31165], [-120.34189, 40.30806], [-120.34631, 40.30436], [-120.35105, 40.30434], [-120.35096, 40.30073], [-120.35115, 40.29341], [-120.36057, 40.29343], [-120.3607, 40.30062], [-120.37014, 40.30042], [-120.37007, 40.29317], [-120.36994, 40.28987], [-120.38412, 40.28953], [-120.38889, 40.28943], [-120.3889, 40.29292], [-120.39365, 40.2929], [-120.39839, 40.29287], [-120.39846, 40.30008], [-120.40791, 40.30003], [-120.42037, 40.29994], [-120.42039, 40.30187]], [[-120.38936, 40.30745], [-120.38937, 40.30744], [-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.3007], [-120.38878, 40.3008], [-120.38883, 40.30091], [-120.38896, 40.301], [-120.38902, 40.30744], [-120.38936, 40.30745]]]]} | Open Access 1 | 7320 | Honey Lake Wildlife Area | 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 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Honey-Lake-WA | Lassen 54 | 6569.617 | Honey Lake Wildlife Area | 1953 | State Conservation Area 8 | 2 |
16783 | 16783 | 16782 | {"type": "MultiPolygon", "coordinates": [[[[-120.39365, 40.28935], [-120.39365, 40.2929], [-120.38889, 40.29292], [-120.38889, 40.28943], [-120.39365, 40.28935]]], [[[-120.40789, 40.2928], [-120.40788, 40.29639], [-120.40316, 40.29643], [-120.40318, 40.30006], [-120.39846, 40.30008], [-120.39839, 40.29287], [-120.40789, 40.2928]]], [[[-120.38413, 40.28701], [-120.38412, 40.28953], [-120.36995, 40.28987], [-120.37007, 40.29317], [-120.37015, 40.30042], [-120.36069, 40.30062], [-120.36057, 40.29343], [-120.35116, 40.29341], [-120.35096, 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.33755, 40.30386], [-120.33553, 40.30225], [-120.33367, 40.30414], [-120.33031, 40.30184], [-120.33717, 40.2974], [-120.33755, 40.30386]]], [[[-120.40334, 40.31103], [-120.39861, 40.31109], [-120.39877, 40.32185], [-120.38986, 40.32196], [-120.38937, 40.30745], [-120.39855, 40.30742], [-120.40327, 40.30735], [-120.40334, 40.31103]]]]} | Open Access 1 | 29209 | Honey Lake Wildlife Area | 30454 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Honey-Lake-WA | Lassen 54 | 1014.534 | Honey Lake Wildlife Area | 1953 | 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]);