units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
159 rows where DES_TP = 55 sorted by AGNCY_ID
This data as json, copyable, CSV (advanced)
ACCESS_TYP 4
MNG_AGENCY 3
MNG_AG_TYP 1
- State Agency 139
DES_TP 1
- State Resource Management Area · 139 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3489 | 3489 | 3488 | {"type": "Polygon", "coordinates": [[[-121.97758, 37.42901], [-121.97746, 37.43245], [-121.97438, 37.4325], [-121.97433, 37.42904], [-121.97758, 37.42901]]]} | No Public Access 3 | 25900 | San Francisco Bay | 32293 | 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 | Santa Clara 19 | 26.519 | San Francisco Bay | 1980 | State Resource Management Area 55 | 3 | |
3490 | 3490 | 3489 | {"type": "MultiPolygon", "coordinates": [[[[-115.13976, 33.41494], [-115.13975, 33.4189], [-115.13539, 33.41889], [-115.13545, 33.41469], [-115.13976, 33.41494]]], [[[-115.19698, 33.413], [-115.18761, 33.41303], [-115.18762, 33.40954], [-115.1968, 33.40952], [-115.19681, 33.40939], [-115.19685, 33.40941], [-115.19698, 33.413]]], [[[-115.21504, 33.39466], [-115.20553, 33.39498], [-115.20542, 33.3912], [-115.21496, 33.39121], [-115.21504, 33.39466]]]]} | No Public Access 3 | 25902 | Tabaseca | 32324 | 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 | Imperial 20 | 215.634 | Tabaseca | 0 | State Resource Management Area 55 | 3 | |
3491 | 3491 | 3490 | {"type": "MultiPolygon", "coordinates": [[[[-119.50998, 35.36521], [-119.50076, 35.36536], [-119.50076, 35.36145], [-119.50129, 35.36134], [-119.50218, 35.36122], [-119.50274, 35.36122], [-119.50324, 35.36126], [-119.50374, 35.36134], [-119.50422, 35.36146], [-119.50467, 35.36161], [-119.50529, 35.36191], [-119.50667, 35.36283], [-119.50706, 35.36313], [-119.50998, 35.36521]]], [[[-119.63933, 35.48483], [-119.63646, 35.48481], [-119.63652, 35.47193], [-119.63789, 35.47208], [-119.63786, 35.47474], [-119.63778, 35.47861], [-119.63933, 35.48483]]]]} | No Public Access 3 | 25905 | California Aqueduct, Region 4 | 32081 | 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 | Kern 36 | 118.425 | California Aqueduct, Region 4 | 0 | State Resource Management Area 55 | 3 | |
3675 | 3675 | 3674 | {"type": "Polygon", "coordinates": [[[-117.5972, 33.67495], [-117.59564, 33.67532], [-117.59561, 33.6788], [-117.59438, 33.67879], [-117.59174, 33.67873], [-117.59136, 33.67839], [-117.59108, 33.67825], [-117.58996, 33.67822], [-117.58984, 33.67353], [-117.58986, 33.67178], [-117.59522, 33.6718], [-117.59706, 33.67178], [-117.59708, 33.6737], [-117.59716, 33.67436], [-117.5972, 33.67495]]]} | No Public Access 3 | 44353 | Trabuco Canyon | 32328 | 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 | Orange 3 | 112.275 | Trabuco Canyon | 0 | State Resource Management Area 55 | 3 | |
3677 | 3677 | 3676 | {"type": "Polygon", "coordinates": [[[-118.24726, 36.83321], [-118.24275, 36.83325], [-118.24273, 36.82962], [-118.24642, 36.8296], [-118.24725, 36.8304], [-118.24726, 36.83321]]]} | Open Access 1 | 44355 | Mount Whitney Facility | 32237 | 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 | Inyo 43 | 39.204 | Mount Whitney Facility | 0 | State Resource Management Area 55 | 3 | |
3678 | 3678 | 3677 | {"type": "Polygon", "coordinates": [[[-117.17431, 33.05469], [-117.17231, 33.05468], [-117.17229, 33.05456], [-117.17224, 33.05445], [-117.17216, 33.05434], [-117.17206, 33.05426], [-117.17194, 33.05419], [-117.17181, 33.05416], [-117.17142, 33.05413], [-117.17121, 33.05407], [-117.17104, 33.05396], [-117.17068, 33.05363], [-117.17054, 33.05374], [-117.17047, 33.05382], [-117.1704, 33.05399], [-117.17038, 33.05408], [-117.1704, 33.05417], [-117.17059, 33.05467], [-117.17004, 33.05467], [-117.16999, 33.05106], [-117.172, 33.05106], [-117.17202, 33.0523], [-117.17429, 33.0523], [-117.17431, 33.05469]]]} | No Public Access 3 | 44356 | Escondido Creek | 32162 | 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 | San Diego 4 | 29.504 | Escondido Creek | 0 | State Resource Management Area 55 | 3 | |
4050 | 4050 | 4049 | {"type": "Polygon", "coordinates": [[[-121.2962, 39.21942], [-121.29618, 39.2203], [-121.29437, 39.22303], [-121.29491, 39.22306], [-121.29612, 39.22304], [-121.29618, 39.22871], [-121.28779, 39.22877], [-121.283, 39.23055], [-121.28206, 39.23057], [-121.2796, 39.2303], [-121.27958, 39.22694], [-121.27961, 39.22337], [-121.27959, 39.22084], [-121.28264, 39.21905], [-121.28214, 39.21734], [-121.28476, 39.21721], [-121.28485, 39.21747], [-121.28646, 39.21812], [-121.28688, 39.21794], [-121.28712, 39.21789], [-121.28681, 39.21716], [-121.28717, 39.21709], [-121.28742, 39.2167], [-121.28746, 39.21639], [-121.28755, 39.2162], [-121.28766, 39.21607], [-121.2878, 39.21598], [-121.28795, 39.21593], [-121.28814, 39.21573], [-121.28824, 39.21558], [-121.28836, 39.21545], [-121.28864, 39.21524], [-121.28879, 39.21504], [-121.28892, 39.21504], [-121.2889, 39.2138], [-121.29403, 39.21379], [-121.29394, 39.21941], [-121.2962, 39.21942]]]} | No Public Access 3 | 44338 | Lower Yuba River | 32209 | 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 | Yuba 25 | 484.28 | Lower Yuba River | 0 | State Resource Management Area 55 | 3 | |
4051 | 4051 | 4050 | {"type": "Polygon", "coordinates": [[[-121.27961, 39.22337], [-121.27958, 39.22694], [-121.2796, 39.22999], [-121.27914, 39.22898], [-121.27879, 39.22844], [-121.27823, 39.22799], [-121.27781, 39.22703], [-121.27639, 39.22608], [-121.27591, 39.22485], [-121.27507, 39.22354], [-121.27479, 39.22338], [-121.27342, 39.224], [-121.27329, 39.22399], [-121.27173, 39.22401], [-121.2705, 39.22417], [-121.27039, 39.22416], [-121.27084, 39.22377], [-121.27139, 39.22335], [-121.27327, 39.22335], [-121.27325, 39.2197], [-121.27353, 39.2197], [-121.2746, 39.21575], [-121.27954, 39.21525], [-121.27961, 39.22337]]]} | No Public Access 3 | 44339 | Lower Yuba River | 32209 | 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 | 150.794 | Lower Yuba River | 0 | State Resource Management Area 55 | 3 | |
4842 | 4842 | 4841 | {"type": "Polygon", "coordinates": [[[-122.70265, 38.97554], [-122.70213, 38.97651], [-122.7016, 38.97676], [-122.7006, 38.97679], [-122.70085, 38.97617], [-122.70146, 38.9756], [-122.70265, 38.97554]]]} | No Public Access 3 | 2140 | Monitor Island | 32231 | 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 | Lake 40 | 3.761 | Monitor Island | 0 | State Resource Management Area 55 | 3 | |
5245 | 5245 | 5244 | {"type": "Polygon", "coordinates": [[[-122.52297, 41.8958], [-122.52259, 41.89608], [-122.52198, 41.89642], [-122.5213, 41.89687], [-122.52065, 41.89629], [-122.52078, 41.89611], [-122.52229, 41.89521], [-122.52297, 41.8958]]]} | No Public Access 3 | 1341 | Klamathon Station | 32197 | 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 | Siskiyou 28 | 4.018 | Klamathon Station | 0 | State Resource Management Area 55 | 3 | |
5300 | 5300 | 5299 | {"type": "MultiPolygon", "coordinates": [[[[-121.18376, 38.65361], [-121.18399, 38.65391], [-121.18416, 38.6543], [-121.18413, 38.65478], [-121.1838, 38.65551], [-121.18292, 38.65658], [-121.18294, 38.65671], [-121.18263, 38.65677], [-121.18258, 38.65676], [-121.18253, 38.65672], [-121.18241, 38.65632], [-121.18252, 38.6563], [-121.18297, 38.65581], [-121.18297, 38.65579], [-121.18327, 38.65543], [-121.18339, 38.65523], [-121.18347, 38.65505], [-121.18351, 38.65489], [-121.18353, 38.65459], [-121.18351, 38.65442], [-121.18347, 38.65426], [-121.18341, 38.65411], [-121.18332, 38.65395], [-121.18376, 38.65361]]], [[[-121.1775, 38.65766], [-121.17724, 38.65766], [-121.17681, 38.65767], [-121.17695, 38.6573], [-121.17699, 38.65723], [-121.17727, 38.6573], [-121.1775, 38.65766]]], [[[-121.18181, 38.6564], [-121.18133, 38.65641], [-121.18118, 38.65638], [-121.18154, 38.65764], [-121.17965, 38.65765], [-121.17951, 38.65699], [-121.17964, 38.65691], [-121.17978, 38.6568], [-121.17998, 38.65658], [-121.18023, 38.6566], [-121.18049, 38.65647], [-121.18085, 38.65634], [-121.18106, 38.65628], [-121.18174, 38.65614], [-121.18181, 38.6564]]], [[[-121.16883, 38.65782], [-121.16836, 38.65788], [-121.16795, 38.65796], [-121.1624, 38.65959], [-121.16182, 38.65971], [-121.16065, 38.65986], [-121.16031, 38.65992], [-121.15986, 38.66003], [-121.1592, 38.66024], [-121.15812, 38.66065], [-121.15819, 38.66028], [-121.15832, 38.65994], [-121.15854, 38.65957], [-121.15879, 38.65927], [-121.1591, 38.659], [-121.15945, 38.65877], [-121.15984, 38.65858], [-121.16031, 38.65842], [-121.1607, 38.65833], [-121.16104, 38.65829], [-121.16214, 38.65827], [-121.16277, 38.65822], [-121.1634, 38.65812], [-121.16389, 38.65802], [-121.16461, 38.65781], [-121.16519, 38.65759], [-121.16574, 38.65734], [-121.16634, 38.657], [-121.16673, 38.65683], [-121.1672, 38.6567], [-121.16753, 38.65664], [-121.1678, 38.65661], [-121.16833, 38.65659], [-121.1684, 38.65662], [-121.16854, 38.65713], [-121.16883, 38.65782]]], [[[-121.17581, 38.6616], [-121.17428, 38.66147], [-121.17177, 38.65885], [-121.17157, 38.65867], [-121.1714, 38.65854], [-121.17118, 38.65839], [-121.17093, 38.65825], [-121.17067, 38.65813], [-121.1704, 38.65803], [-121.16989, 38.6579], [-121.16954, 38.65784], [-121.16927, 38.65782], [-121.16894, 38.65702], [-121.16886, 38.65674], [-121.16884, 38.65663], [-121.16885, 38.65659], [-121.16892, 38.65655], [-121.1708, 38.65644], [-121.17123, 38.65639], [-121.17176, 38.65628], [-121.17197, 38.65661], [-121.17204, 38.65701], [-121.17178, 38.65703], [-121.17187, 38.65762], [-121.17193, 38.6577], [-121.17199, 38.65773], [-121.17206, 38.65774], [-121.17272, 38.65767], [-121.17294, 38.65768], [-121.1731, 38.65773], [-121.17393, 38.65813], [-121.17408, 38.65817], [-121.1742, 38.65817], [-121.17433, 38.65815], [-121.17525, 38.65775], [-121.17525, 38.65774], [-121.17491, 38.65778], [-121.17502, 38.65771], [-121.17522, 38.65753], [-121.17547, 38.65753], [-121.17523, 38.65863], [-121.17581, 38.6616]]]]} | No Public Access 3 | 5033 | Willow Creek | 32350 | 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/Willow-Creek-WA | Sacramento 41 | 78.145 | Willow Creek | 0 | State Resource Management Area 55 | 3 |
5461 | 5461 | 5460 | {"type": "Polygon", "coordinates": [[[-121.92008, 41.91622], [-121.91521, 41.91623], [-121.91508, 41.91209], [-121.91028, 41.91215], [-121.91043, 41.91631], [-121.9057, 41.91629], [-121.90546, 41.90908], [-121.91976, 41.90901], [-121.92008, 41.91622]]]} | No Public Access 3 | 6269 | Cedar Point | 32109 | 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 | Siskiyou 28 | 190.648 | Cedar Point | 0 | State Resource Management Area 55 | 3 | |
5484 | 5484 | 5483 | {"type": "Polygon", "coordinates": [[[-121.45171, 37.99673], [-121.45157, 37.99753], [-121.45125, 37.99803], [-121.44772, 37.99697], [-121.449, 37.99516], [-121.45045, 37.99469], [-121.45112, 37.99482], [-121.4517, 37.99592], [-121.45175, 37.99649], [-121.45171, 37.99673]]]} | No Public Access 3 | 18030 | Acker Island | 32009 | 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 | San Joaquin 39 | 20.966 | Acker Island | 0 | State Resource Management Area 55 | 3 | |
5599 | 5599 | 5598 | {"type": "Polygon", "coordinates": [[[-121.47811, 37.34772], [-121.47387, 37.3477], [-121.46884, 37.34757], [-121.46895, 37.33318], [-121.46053, 37.33314], [-121.46052, 37.33308], [-121.4511, 37.33303], [-121.4422, 37.33311], [-121.44212, 37.3367], [-121.43286, 37.33679], [-121.43288, 37.33629], [-121.43285, 37.33628], [-121.43278, 37.33294], [-121.4237, 37.33291], [-121.42378, 37.32944], [-121.44188, 37.3294], [-121.44189, 37.32584], [-121.43282, 37.32592], [-121.43304, 37.31848], [-121.43306, 37.30399], [-121.44215, 37.30401], [-121.45398, 37.30406], [-121.46945, 37.3042], [-121.46948, 37.31146], [-121.47544, 37.3115], [-121.47528, 37.327], [-121.47514, 37.32718], [-121.4748, 37.3277], [-121.47471, 37.3279], [-121.4747, 37.32801], [-121.47473, 37.32924], [-121.47478, 37.3295], [-121.47473, 37.32951], [-121.47529, 37.33069], [-121.47621, 37.33255], [-121.47625, 37.33392], [-121.47643, 37.33555], [-121.47612, 37.3369], [-121.47647, 37.33844], [-121.477, 37.33945], [-121.47769, 37.3407], [-121.47786, 37.34295], [-121.47808, 37.34527], [-121.47767, 37.34679], [-121.47766, 37.34708], [-121.47811, 37.34772]]]} | Restricted Access 2 | 20680 | San Antonio Valley | 24836 | 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 | Santa Clara 19 | 3259.009 | San Antonio Valley | 0 | State Resource Management Area 55 | 3 | |
5734 | 5734 | 5733 | {"type": "Polygon", "coordinates": [[[-121.70367, 39.80488], [-121.70358, 39.8067], [-121.69866, 39.8105], [-121.69855, 39.81401], [-121.69396, 39.81401], [-121.69395, 39.81215], [-121.69416, 39.80653], [-121.69368, 39.80652], [-121.68461, 39.80657], [-121.68726, 39.80502], [-121.70367, 39.80488]]]} | No Public Access 3 | 1651 | Little Chico Canyon | 32204 | 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 | Butte 42 | 170.568 | Little Chico Canyon | 0 | State Resource Management Area 55 | 3 | |
6173 | 6173 | 6172 | {"type": "Polygon", "coordinates": [[[-122.64262, 37.8994], [-122.64213, 37.8998], [-122.64167, 37.8996], [-122.64213, 37.89912], [-122.64242, 37.8992], [-122.64262, 37.8994]]]} | No Public Access 3 | 1204 | Stinson Beach | 32319 | 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 | Marin 23 | 0.833 | Stinson Beach | 0 | State Resource Management Area 55 | 3 | |
6243 | 6243 | 6242 | {"type": "Polygon", "coordinates": [[[-116.96211, 32.96295], [-116.95351, 32.96324], [-116.95342, 32.95961], [-116.94888, 32.95974], [-116.94878, 32.95602], [-116.94045, 32.9561], [-116.94043, 32.95977], [-116.93185, 32.95964], [-116.93185, 32.95601], [-116.92761, 32.95596], [-116.92763, 32.95203], [-116.93186, 32.95198], [-116.93182, 32.94121], [-116.92765, 32.94122], [-116.92248, 32.94033], [-116.9225, 32.94032], [-116.92218, 32.93627], [-116.92764, 32.93755], [-116.92764, 32.93401], [-116.93615, 32.93378], [-116.93618, 32.93562], [-116.94046, 32.93556], [-116.94047, 32.93366], [-116.9447, 32.93354], [-116.94886, 32.93352], [-116.94892, 32.94093], [-116.95334, 32.9409], [-116.9534, 32.94251], [-116.95366, 32.94251], [-116.95404, 32.94257], [-116.95419, 32.94253], [-116.95424, 32.9425], [-116.95433, 32.94237], [-116.95436, 32.94199], [-116.95436, 32.94189], [-116.95434, 32.94179], [-116.95417, 32.94158], [-116.95413, 32.94147], [-116.95414, 32.94141], [-116.95421, 32.94125], [-116.9543, 32.94118], [-116.95462, 32.94098], [-116.95478, 32.94093], [-116.9549, 32.9409], [-116.95518, 32.94089], [-116.95541, 32.94094], [-116.95553, 32.94095], [-116.95568, 32.94125], [-116.95518, 32.94132], [-116.95504, 32.94139], [-116.95494, 32.94146], [-116.95486, 32.94158], [-116.95481, 32.94169], [-116.95481, 32.94184], [-116.95484, 32.94192], [-116.95488, 32.94211], [-116.95483, 32.94232], [-116.95478, 32.94241], [-116.9547, 32.94251], [-116.95461, 32.94259], [-116.95445, 32.94268], [-116.95429, 32.94272], [-116.95411, 32.94274], [-116.95366, 32.94268], [-116.95324, 32.94271], [-116.95308, 32.94269], [-116.95286, 32.94263], [-116.9527, 32.94263], [-116.95253, 32.94268], [-116.9524, 32.94276], [-116.9513, 32.94378], [-116.95115, 32.94389], [-116.95109, 32.94392], [-116.95165, 32.94469], [-116.94886, 32.94473], [-116.94889, 32.95222], [-116.95298, 32.9522], [-116.95323, 32.95222], [-116.95318, 32.94851], [-116.95783, 32.94845], [-116.95798, 32.95947], [-116.96207, 32.95939], [-116.96211, 32.96295]]]} | No Public Access 3 | 1316 | San Vicente Highlands | 32296 | 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 | San Diego 4 | 1545.08 | San Vicente Highlands | 0 | State Resource Management Area 55 | 3 | |
6386 | 6386 | 6385 | {"type": "Polygon", "coordinates": [[[-117.52541, 33.96645], [-117.52323, 33.96645], [-117.52323, 33.96816], [-117.52308, 33.96816], [-117.52307, 33.96821], [-117.52205, 33.96822], [-117.52205, 33.96841], [-117.5211, 33.96915], [-117.52048, 33.96989], [-117.51961, 33.97059], [-117.51875, 33.97187], [-117.51691, 33.97319], [-117.5158, 33.97365], [-117.5131, 33.97522], [-117.50998, 33.9752], [-117.50918, 33.97488], [-117.50687, 33.9741], [-117.50585, 33.97403], [-117.50479, 33.97394], [-117.50361, 33.97318], [-117.50246, 33.97302], [-117.50143, 33.97293], [-117.5014, 33.97181], [-117.49279, 33.97184], [-117.49277, 33.9709], [-117.49061, 33.97092], [-117.49058, 33.97001], [-117.48845, 33.97007], [-117.4863, 33.96896], [-117.48462, 33.96846], [-117.48335, 33.96843], [-117.48115, 33.9678], [-117.47973, 33.96718], [-117.47972, 33.96719], [-117.47972, 33.96789], [-117.47848, 33.96747], [-117.47631, 33.96659], [-117.47327, 33.96741], [-117.47088, 33.96761], [-117.47004, 33.96751], [-117.47017, 33.96736], [-117.47022, 33.96727], [-117.47026, 33.96712], [-117.47026, 33.96701], [-117.47023, 33.96686], [-117.47019, 33.96676], [-117.47012, 33.96667], [-117.46994, 33.96654], [-117.46977, 33.96648], [-117.46961, 33.96645], [-117.46958, 33.96655], [-117.46789, 33.96629], [-117.46628, 33.96524], [-117.46603, 33.96324], [-117.46598, 33.96295], [-117.46585, 33.9625], [-117.46578, 33.96229], [-117.46557, 33.96188], [-117.46536, 33.96155], [-117.46522, 33.96136], [-117.4649, 33.961], [-117.46467, 33.96077], [-117.46428, 33.96046], [-117.46388, 33.9602], [-117.46301, 33.95955], [-117.46411, 33.95939], [-117.46456, 33.95971], [-117.46482, 33.96024], [-117.46666, 33.96053], [-117.46667, 33.96066], [-117.46709, 33.96066], [-117.46883, 33.96132], [-117.46884, 33.96162], [-117.47095, 33.96164], [-117.47638, 33.96163], [-117.47641, 33.96253], [-117.4789, 33.96253], [-117.47887, 33.96481], [-117.47972, 33.96482], [-117.47977, 33.96254], [-117.48076, 33.96254], [-117.48077, 33.96164], [-117.48403, 33.96166], [-117.48405, 33.96075], [-117.48731, 33.96077], [-117.48732, 33.9605], [-117.49316, 33.96053], [-117.49311, 33.96121], [-117.49543, 33.96154], [-117.49849, 33.96316], [-117.49981, 33.96326], [-117.50044, 33.96291], [-117.50023, 33.96235], [-117.50322, 33.96165], [-117.50579, 33.96291], [-117.50662, 33.9634], [-117.51029, 33.96284], [-117.51273, 33.96201], [-117.51499, 33.96194], [-117.51499, 33.96243], [-117.51546, 33.96243], [-117.51546, 33.9628], [-117.51574, 33.96299], [-117.51821, 33.9628], [-117.52417, 33.95936], [-117.5254, 33.9605], [-117.52537, 33.96097], [-117.5254, 33.96098], [-117.52541, 33.96645]]]} | No Public Access 3 | 1798 | Hidden Valley | 32185 | 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 | Riverside 10 | 1299.756 | Hidden Valley | 0 | State Resource Management Area 55 | 3 | |
6562 | 6562 | 6561 | {"type": "MultiPolygon", "coordinates": [[[[-122.36595, 40.50811], [-122.36457, 40.50963], [-122.36317, 40.51062], [-122.36286, 40.51141], [-122.36171, 40.51207], [-122.36145, 40.5119], [-122.36142, 40.51191], [-122.36049, 40.5114], [-122.35933, 40.51101], [-122.35937, 40.5084], [-122.36377, 40.50797], [-122.3654, 40.50806], [-122.36595, 40.50811]]], [[[-122.37348, 40.55551], [-122.3734, 40.55564], [-122.37337, 40.55586], [-122.37338, 40.55617], [-122.37197, 40.55594], [-122.37218, 40.55527], [-122.37348, 40.55551]]]]} | No Public Access 3 | 3435 | Sacramento River -- Redding | 32284 | 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 | Shasta 27 | 40.985 | Sacramento River -- Redding | 0 | State Resource Management Area 55 | 3 | |
7132 | 7132 | 7131 | {"type": "MultiPolygon", "coordinates": [[[[-119.41323, 36.78389], [-119.41298, 36.78429], [-119.41297, 36.78478], [-119.41308, 36.78757], [-119.41299, 36.78847], [-119.41167, 36.78916], [-119.4116, 36.78454], [-119.40887, 36.78451], [-119.40928, 36.78346], [-119.41097, 36.78354], [-119.411, 36.7831], [-119.41, 36.78308], [-119.41079, 36.78223], [-119.41154, 36.78298], [-119.41323, 36.78389]]], [[[-119.41291, 36.78956], [-119.41289, 36.7902], [-119.41169, 36.79021], [-119.41169, 36.79009], [-119.41163, 36.79008], [-119.41163, 36.78953], [-119.41265, 36.78953], [-119.41266, 36.78957], [-119.41291, 36.78956]]]]} | Open Access 1 | 6750 | Avocado Lake | 32030 | 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 | Fresno 9 | 29.362 | Avocado Lake | 0 | State Resource Management Area 55 | 3 |
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]);