units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
3 rows where COUNTY = 30, DES_TP = 8 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15621 | 15621 | 15620 | {"type": "MultiPolygon", "coordinates": [[[[-120.61073, 39.50453], [-120.61064, 39.50618], [-120.60842, 39.50617], [-120.6085, 39.50449], [-120.61073, 39.50453]]], [[[-120.61327, 39.51192], [-120.61072, 39.51188], [-120.61068, 39.50845], [-120.6132, 39.50845], [-120.61323, 39.51019], [-120.61327, 39.51192]]]]} | No Public Access 3 | 21576 | Macklin Creek Ecological Reserve | 32211 | 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 | Nevada 30 | 29.458 | Macklin Creek ER | 0 | State Conservation Area 8 | 2 | |
| 16707 | 16707 | 16706 | {"type": "MultiPolygon", "coordinates": [[[[-121.27982, 39.08348], [-121.27982, 39.08682], [-121.27975, 39.10087], [-121.27976, 39.12408], [-121.27982, 39.12489], [-121.27977, 39.1249], [-121.27971, 39.12976], [-121.27972, 39.13739], [-121.27934, 39.13733], [-121.27487, 39.13731], [-121.274, 39.13717], [-121.27196, 39.13714], [-121.26996, 39.13712], [-121.26709, 39.13715], [-121.26483, 39.13708], [-121.25613, 39.13708], [-121.25615, 39.13151], [-121.25626, 39.12957], [-121.25169, 39.12961], [-121.25156, 39.13315], [-121.25145, 39.13688], [-121.24689, 39.13696], [-121.24677, 39.14076], [-121.24416, 39.14065], [-121.24421, 39.13695], [-121.23906, 39.13688], [-121.23911, 39.13315], [-121.24434, 39.13314], [-121.24439, 39.1296], [-121.24077, 39.12958], [-121.24067, 39.12911], [-121.24047, 39.12844], [-121.24017, 39.12762], [-121.24036, 39.12224], [-121.2403, 39.11737], [-121.23976, 39.11725], [-121.23916, 39.11702], [-121.23865, 39.1167], [-121.23815, 39.11608], [-121.23797, 39.1157], [-121.23798, 39.11526], [-121.24027, 39.11524], [-121.2402, 39.10963], [-121.24028, 39.10813], [-121.24508, 39.10811], [-121.24754, 39.10812], [-121.25653, 39.10807], [-121.2565, 39.10646], [-121.2568, 39.1009], [-121.26596, 39.10086], [-121.26593, 39.09382], [-121.26595, 39.08669], [-121.26589, 39.08319], [-121.26595, 39.07985], [-121.26823, 39.07988], [-121.27452, 39.07988], [-121.27566, 39.07986], [-121.2798, 39.08348], [-121.27982, 39.08348]]], [[[-121.27982, 39.07987], [-121.27982, 39.08318], [-121.27918, 39.08269], [-121.27582, 39.07986], [-121.27982, 39.07987]]]]} | Open Access 1 | 4240 | Spenceville Wildlife Area | 30508 | 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/Spenceville-WA | Nevada 30 | 3724.673 | Spenceville Wildlife Area | 1968 | State Conservation Area 8 | 2 |
| 16764 | 16764 | 16763 | {"type": "MultiPolygon", "coordinates": [[[[-120.19864, 39.31635], [-120.19862, 39.31805], [-120.1983, 39.31826], [-120.19794, 39.3181], [-120.19724, 39.31898], [-120.19559, 39.31946], [-120.19486, 39.3194], [-120.19405, 39.31995], [-120.19345, 39.32054], [-120.19326, 39.32069], [-120.19277, 39.32099], [-120.19207, 39.32174], [-120.19195, 39.32218], [-120.19137, 39.32302], [-120.19114, 39.32333], [-120.19111, 39.32333], [-120.19111, 39.32326], [-120.19009, 39.32134], [-120.19072, 39.32106], [-120.19254, 39.31958], [-120.19392, 39.31797], [-120.19455, 39.3177], [-120.19542, 39.31763], [-120.19703, 39.3168], [-120.1975, 39.31635], [-120.19864, 39.31635]]], [[[-120.01218, 39.31638], [-120.01189, 39.33079], [-120.00537, 39.33082], [-120.00497, 39.33079], [-120.00487, 39.31645], [-120.01218, 39.31638]]], [[[-120.15392, 39.33285], [-120.15227, 39.33314], [-120.15044, 39.33355], [-120.14863, 39.33402], [-120.14686, 39.33458], [-120.1453, 39.33514], [-120.14185, 39.33652], [-120.13596, 39.33896], [-120.12871, 39.34268], [-120.12805, 39.34312], [-120.12722, 39.34374], [-120.12663, 39.34425], [-120.12608, 39.34478], [-120.12556, 39.34478], [-120.12607, 39.34429], [-120.12664, 39.34327], [-120.12737, 39.34257], [-120.12789, 39.34218], [-120.12844, 39.34126], [-120.12858, 39.34046], [-120.12907, 39.34011], [-120.13063, 39.33933], [-120.13133, 39.33899], [-120.13237, 39.33839], [-120.13315, 39.33785], [-120.13342, 39.33764], [-120.1337, 39.3374], [-120.13422, 39.33689], [-120.13459, 39.33657], [-120.13504, 39.33628], [-120.13547, 39.33607], [-120.13575, 39.33596], [-120.13619, 39.33582], [-120.13686, 39.33568], [-120.13736, 39.33564], [-120.13854, 39.33568], [-120.13934, 39.33565], [-120.13968, 39.33561], [-120.14026, 39.33552], [-120.14077, 39.33542], [-120.14144, 39.33524], [-120.1417, 39.33507], [-120.14226, 39.33487], [-120.14324, 39.33424], [-120.14446, 39.33335], [-120.14485, 39.33309], [-120.14569, 39.33277], [-120.14631, 39.33278], [-120.1473, 39.33283], [-120.15006, 39.33266], [-120.15077, 39.33223], [-120.15132, 39.33202], [-120.15167, 39.33197], [-120.1518, 39.33201], [-120.15211, 39.33207], [-120.15272, 39.33207], [-120.15326, 39.33225], [-120.15392, 39.33285]]], [[[-120.02945, 39.35923], [-120.00476, 39.35963], [-120.00471, 39.35901], [-120.00488, 39.3452], [-120.0171, 39.34497], [-120.02935, 39.3447], [-120.02939, 39.35268], [-120.02945, 39.35923]]], [[[-120.07189, 39.36633], [-120.07134, 39.3662], [-120.07068, 39.36612], [-120.07008, 39.36611], [-120.06941, 39.36616], [-120.06884, 39.36627], [-120.06828, 39.36643], [-120.06776, 39.36664], [-120.0672, 39.36694], [-120.06721, 39.36339], [-120.07189, 39.36342], [-120.07189, 39.36633]]], [[[-120.04823, 39.36747], [-120.04772, 39.36734], [-120.04732, 39.36732], [-120.04611, 39.36743], [-120.04144, 39.36873], [-120.0406, 39.36874], [-120.038, 39.36925], [-120.03735, 39.36944], [-120.0359, 39.37013], [-120.03343, 39.37162], [-120.03309, 39.37177], [-120.03286, 39.37195], [-120.02955, 39.37341], [-120.02946, 39.36004], [-120.04815, 39.36001], [-120.04823, 39.36747]]], [[[-120.01626, 39.36349], [-120.01575, 39.37079], [-120.01189, 39.37077], [-120.01185, 39.37429], [-120.0045, 39.3744], [-120.00461, 39.36707], [-120.00464, 39.36345], [-120.01626, 39.36349]]], [[[-120.11479, 39.36845], [-120.11548, 39.36898], [-120.11578, 39.36926], [-120.11597, 39.36951], [-120.11606, 39.36977], [-120.11608, 39.36991], [-120.11606, 39.37015], [-120.11599, 39.37046], [-120.11589, 39.37069], [-120.11577, 39.37092], [-120.11562, 39.37115], [-120.11533, 39.37147], [-120.11505, 39.37172], [-120.11464, 39.37204], [-120.11342, 39.37291], [-120.11234, 39.37361], [-120.11167, 39.374], [-120.11138, 39.37414], [-120.11067, 39.37445], [-120.11006, 39.37457], [-120.10985, 39.3746], [-120.10947, 39.3746], [-120.1087, 39.37453], [-120.10959, 39.37422], [-120.11086, 39.3737], [-120.11178, 39.37327], [-120.1126, 39.37284], [-120.11376, 39.37175], [-120.11409, 39.37058], [-120.1143, 39.37006], [-120.11457, 39.36927], [-120.11479, 39.36845]]], [[[-120.04826, 39.37447], [-120.04787, 39.37453], [-120.04732, 39.3745], [-120.03342, 39.37475], [-120.03652, 39.37268], [-120.04219, 39.37144], [-120.04362, 39.37122], [-120.04588, 39.37069], [-120.0468, 39.37059], [-120.04775, 39.37063], [-120.04823, 39.37076], [-120.04826, 39.37447]]], [[[-120.10668, 39.37427], [-120.10609, 39.37453], [-120.10573, 39.37471], [-120.10417, 39.37619], [-120.10417, 39.37499], [-120.10408, 39.37472], [-120.10003, 39.37467], [-120.10007, 39.37079], [-120.10481, 39.37079], [-120.10479, 39.37235], [-120.10527, 39.3724], [-120.10607, 39.37272], [-120.10642, 39.37325], [-120.10666, 39.37378], [-120.10668, 39.37427]]], [[[-120.10308, 39.37813], [-120.10226, 39.37928], [-120.102, 39.37953], [-120.10162, 39.37967], [-120.10152, 39.37968], [-120.1002, 39.37997], [-120.10308, 39.37813]]], [[[-120.0953, 39.38313], [-120.09528, 39.38336], [-120.09508, 39.38371], [-120.09492, 39.38388], [-120.09477, 39.38407], [-120.0946, 39.38423], [-120.09437, 39.38437], [-120.09397, 39.38448], [-120.09302, 39.38451], [-120.09258, 39.3845], [-120.09214, 39.38446], [-120.09172, 39.3844], [-120.09135, 39.38425], [-120.09098, 39.38412], [-120.09162, 39.38404], [-120.09301, 39.38392], [-120.09352, 39.38385], [-120.09433, 39.38369], [-120.0951, 39.38326], [-120.0953, 39.38313]]], [[[-120.02677, 39.4178], [-120.02533, 39.41774], [-120.02077, 39.41774], [-120.01598, 39.41786], [-120.01578, 39.41011], [-120.01577, 39.40549], [-120.01578, 39.40447], [-120.01581, 39.40347], [-120.01095, 39.40354], [-120.01095, 39.40553], [-120.01097, 39.40739], [-120.01128, 39.41804], [-120.00372, 39.41831], [-120.004, 39.40372], [-120.00979, 39.40356], [-120.01019, 39.39646], [-120.01524, 39.39624], [-120.01518, 39.39711], [-120.01916, 39.39688], [-120.01905, 39.39892], [-120.02002, 39.39895], [-120.01991, 39.39958], [-120.01987, 39.40046], [-120.01991, 39.40156], [-120.02003, 39.40214], [-120.02028, 39.40262], [-120.02078, 39.40329], [-120.02166, 39.4041], [-120.02224, 39.40501], [-120.02271, 39.40593], [-120.02308, 39.4068], [-120.02342, 39.40794], [-120.02369, 39.40862], [-120.02402, 39.40925], [-120.02482, 39.41041], [-120.0251, 39.4111], [-120.02523, 39.41183], [-120.02511, 39.41371], [-120.02526, 39.41494], [-120.02552, 39.41576], [-120.02582, 39.41636], [-120.02677, 39.4178]]], [[[-120.03518, 39.42272], [-120.03512, 39.42441], [-120.03509, 39.42471], [-120.03336, 39.42981], [-120.03243, 39.431], [-120.03219, 39.43124], [-120.03008, 39.43272], [-120.02973, 39.43261], [-120.02982, 39.43148], [-120.03066, 39.43162], [-120.03132, 39.4311], [-120.03206, 39.43003], [-120.03268, 39.42863], [-120.03339, 39.42577], [-120.03355, 39.42488], [-120.03354, 39.42386], [-120.03317, 39.42281], [-120.03279, 39.42219], [-120.03223, 39.42146], [-120.03064, 39.42006], [-120.02987, 39.41894], [-120.02993, 39.41749], [-120.0308, 39.41811], [-120.03145, 39.41875], [-120.03228, 39.41945], [-120.03194, 39.41978], [-120.03381, 39.42138], [-120.03518, 39.42272]]], [[[-120.02992, 39.42186], [-120.02991, 39.42121], [-120.03035, 39.42161], [-120.03148, 39.42249], [-120.03198, 39.42343], [-120.0321, 39.42444], [-120.03193, 39.42644], [-120.03173, 39.42805], [-120.03117, 39.42949], [-120.03065, 39.43028], [-120.03032, 39.43063], [-120.02987, 39.43085], [-120.0281, 39.43116], [-120.02698, 39.43143], [-120.02615, 39.43175], [-120.0255, 39.43228], [-120.02504, 39.43271], [-120.02462, 39.43345], [-120.02429, 39.43391], [-120.02349, 39.43464], [-120.02181, 39.43557], [-120.01967, 39.43652], [-120.01907, 39.43689], [-120.01863, 39.43722], [-120.01779, 39.43804], [-120.0171, 39.43859], [-120.01609, 39.43922], [-120.01555, 39.43943], [-120.01553, 39.4383], [-120.01556, 39.43631], [-120.01556, 39.43293], [-120.02218, 39.43275], [-120.02229, 39.43125], [-120.0245, 39.4313], [-120.02496, 39.42883], [-120.02987, 39.42944], [-120.02988, 39.42558], [-120.02992, 39.42186]]], [[[-120.04832, 39.41812], [-120.04828, 39.43315], [-120.04811, 39.4399], [-120.04826, 39.44509], [-120.04828, 39.4451], [-120.04825, 39.44512], [-120.04825, 39.44514], [-120.03628, 39.44513], [-120.01168, 39.44514], [-120.01169, 39.44502], [-120.01197, 39.44351], [-120.01412, 39.44235], [-120.0173, 39.44147], [-120.0231, 39.43778], [-120.02387, 39.43776], [-120.02406, 39.43768], [-120.02566, 39.43661], [-120.02628, 39.43568], [-120.02868, 39.43451], [-120.02982, 39.43392], [-120.03116, 39.43314], [-120.03171, 39.43269], [-120.03297, 39.4324], [-120.0336, 39.43137], [-120.03516, 39.42994], [-120.0353, 39.42937], [-120.03517, 39.42895], [-120.03544, 39.42842], [-120.03587, 39.42817], [-120.03703, 39.42557], [-120.03779, 39.42516], [-120.03739, 39.42285], [-120.03743, 39.42259], [-120.03738, 39.42229], [-120.03724, 39.42206], [-120.03693, 39.42178], [-120.03641, 39.42162], [-120.03594, 39.42164], [-120.03558, 39.42177], [-120.03449, 39.42087], [-120.0331, 39.41858], [-120.0325, 39.41803], [-120.03061, 39.41697], [-120.02989, 39.41621], [-120.02887, 39.41477], [-120.02888, 39.41231], [-120.02833, 39.40989], [-120.02828, 39.40786], [-120.02767, 39.40731], [-120.02735, 39.40585], [-120.02622, 39.40377], [-120.02579, 39.40383], [-120.02514, 39.40329], [-120.02513, 39.40312], [-120.02489, 39.40314], [-120.02347, 39.40243], [-120.02262, 39.40046], [-120.02248, 39.39995], [-120.02258, 39.39939], [-120.02284, 39.39868], [-120.02318, 39.39796], [-120.02353, 39.39732], [-120.02518, 39.39526], [-120.02585, 39.39457], [-120.02687, 39.39298], [-120.02517, 39.38919], [-120.02551, 39.38905], [-120.02542, 39.38851], [-120.02973, 39.38838], [-120.02977, 39.39647], [-120.04386, 39.39643], [-120.04379, 39.40368], [-120.04356, 39.40369], [-120.04348, 39.40726], [-120.04391, 39.41809], [-120.04832, 39.41812]]]]} | Open Access 1 | 23357 | Truckee River Wildlife Area | 12543 | 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/Truckee-River-WA | Nevada 30 | 5209.91 | Truckee River Wildlife Area | 1996 | 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]);