units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
72 rows where DES_TP = 55 and MNG_AGENCY = 25 sorted by ACCESS_TYP
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_NAME, AGNCY_WEB, LAYER, YR_EST
ACCESS_TYP 3
MNG_AG_TYP 1
- State Agency 72
MNG_AGENCY 1
- California Department of Fish and Wildlife · 72 ✖
DES_TP 1
- State Resource Management Area · 72 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2853 | 2853 | 2852 | {"type": "Polygon", "coordinates": [[[-123.12633, 39.12775], [-123.12199, 39.12765], [-123.12186, 39.12406], [-123.12181, 39.12124], [-123.12251, 39.12168], [-123.12399, 39.12253], [-123.12435, 39.12276], [-123.1246, 39.12316], [-123.12473, 39.12355], [-123.12507, 39.12389], [-123.12597, 39.1242], [-123.12633, 39.12775]]]} | Open Access 1 | 22154 | Mill Creek | 32219 | 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 | Mendocino 24 | 49.861 | Mill Creek | 0 | State Resource Management Area 55 | 3 | |
3142 | 3142 | 3141 | {"type": "Polygon", "coordinates": [[[-124.10364, 40.82505], [-124.10204, 40.8308], [-124.10044, 40.83153], [-124.0966, 40.82984], [-124.08606, 40.82989], [-124.08663, 40.82862], [-124.08651, 40.82861], [-124.08712, 40.82752], [-124.08784, 40.82592], [-124.08642, 40.82542], [-124.08642, 40.82541], [-124.08628, 40.82535], [-124.08666, 40.82496], [-124.08699, 40.82469], [-124.08887, 40.82328], [-124.08903, 40.82319], [-124.08922, 40.82304], [-124.10364, 40.82505]], [[-124.08767, 40.82431], [-124.08749, 40.82436], [-124.08737, 40.8245], [-124.08721, 40.82478], [-124.08704, 40.82493], [-124.08715, 40.82496], [-124.08717, 40.82494], [-124.09118, 40.82586], [-124.0918, 40.8249], [-124.0918, 40.82489], [-124.08767, 40.82431]]]} | Open Access 1 | 21590 | Bracut Tidelands | 32065 | 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 | Humboldt 45 | 222.41 | Bracut Tidelands | 0 | State Resource Management Area 55 | 3 | |
3437 | 3437 | 3436 | {"type": "Polygon", "coordinates": [[[-122.4138, 38.46446], [-122.41344, 38.465], [-122.41272, 38.46514], [-122.41239, 38.46481], [-122.41285, 38.46468], [-122.41297, 38.46463], [-122.41332, 38.46455], [-122.41347, 38.4645], [-122.41361, 38.46442], [-122.41379, 38.46439], [-122.4138, 38.46446]]]} | Open Access 1 | 25245 | Rutherford Crossroad | 32278 | 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 | Napa 11 | 1.213 | Rutherford Crossroad | 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 | |
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 | |
14181 | 14181 | 14180 | {"type": "Polygon", "coordinates": [[[-121.66704, 38.30674], [-121.66711, 38.29215], [-121.66689, 38.29214], [-121.66479, 38.28461], [-121.66567, 38.28461], [-121.66546, 38.28383], [-121.66512, 38.28384], [-121.66506, 38.2834], [-121.66532, 38.28258], [-121.6652, 38.28236], [-121.66582, 38.2792], [-121.66565, 38.27778], [-121.66604, 38.27487], [-121.66586, 38.2745], [-121.6662, 38.27417], [-121.66682, 38.27319], [-121.66798, 38.27229], [-121.66873, 38.27113], [-121.66893, 38.27056], [-121.67055, 38.26728], [-121.67071, 38.26663], [-121.67115, 38.26627], [-121.67166, 38.26594], [-121.67172, 38.26571], [-121.67128, 38.26549], [-121.67108, 38.2653], [-121.67117, 38.26509], [-121.67135, 38.26481], [-121.67137, 38.26456], [-121.6713, 38.26404], [-121.67114, 38.26361], [-121.67086, 38.26332], [-121.671, 38.2631], [-121.67108, 38.26268], [-121.6708, 38.26223], [-121.6711, 38.26175], [-121.67118, 38.26061], [-121.67141, 38.25938], [-121.6719, 38.25794], [-121.67193, 38.25681], [-121.67226, 38.25623], [-121.67221, 38.25603], [-121.67205, 38.25592], [-121.67175, 38.25486], [-121.67171, 38.2545], [-121.6722, 38.25419], [-121.67289, 38.25384], [-121.67332, 38.2534], [-121.67328, 38.25262], [-121.6734, 38.25189], [-121.67488, 38.24991], [-121.67537, 38.2491], [-121.67571, 38.24824], [-121.67615, 38.24774], [-121.67768, 38.24681], [-121.67798, 38.24622], [-121.67884, 38.24467], [-121.6796, 38.24357], [-121.67995, 38.24296], [-121.68045, 38.24277], [-121.68096, 38.24265], [-121.68156, 38.2422], [-121.68197, 38.24163], [-121.6821, 38.24018], [-121.6823, 38.23991], [-121.68291, 38.23965], [-121.6835, 38.23914], [-121.68373, 38.23907], [-121.68396, 38.23915], [-121.68414, 38.23999], [-121.68443, 38.24064], [-121.68682, 38.2428], [-121.68722, 38.24331], [-121.6874, 38.24379], [-121.68732, 38.2444], [-121.68723, 38.2447], [-121.68625, 38.24654], [-121.68615, 38.24708], [-121.68627, 38.2481], [-121.68604, 38.24866], [-121.68596, 38.24898], [-121.68645, 38.24994], [-121.6867, 38.25102], [-121.68674, 38.25173], [-121.68639, 38.25299], [-121.68645, 38.25409], [-121.68668, 38.25514], [-121.68686, 38.25555], [-121.68787, 38.25645], [-121.68873, 38.25706], [-121.6907, 38.25773], [-121.69112, 38.25798], [-121.69112, 38.25842], [-121.69098, 38.25908], [-121.69069, 38.26088], [-121.69048, 38.26148], [-121.69042, 38.26187], [-121.69038, 38.26242], [-121.69017, 38.26295], [-121.69025, 38.26341], [-121.69106, 38.26589], [-121.69161, 38.26645], [-121.69192, 38.26775], [-121.69201, 38.26829], [-121.69176, 38.26862], [-121.6915, 38.26951], [-121.69164, 38.27004], [-121.69274, 38.27049], [-121.69295, 38.27093], [-121.69269, 38.27144], [-121.6924, 38.27197], [-121.69227, 38.27236], [-121.69283, 38.27315], [-121.69344, 38.27387], [-121.69361, 38.27471], [-121.69394, 38.27552], [-121.69417, 38.27629], [-121.69443, 38.27699], [-121.69449, 38.27782], [-121.69429, 38.27817], [-121.69371, 38.27938], [-121.69339, 38.27988], [-121.69231, 38.28247], [-121.69222, 38.28336], [-121.69228, 38.28474], [-121.69337, 38.28475], [-121.6934, 38.28572], [-121.69344, 38.2912], [-121.69345, 38.30007], [-121.69343, 38.30224], [-121.69348, 38.3024], [-121.69346, 38.30395], [-121.69348, 38.3055], [-121.69345, 38.30655], [-121.69172, 38.30635], [-121.69169, 38.30626], [-121.69052, 38.30645], [-121.67593, 38.30641], [-121.67594, 38.30653], [-121.69054, 38.30657], [-121.69123, 38.30649], [-121.69181, 38.30646], [-121.6932, 38.3066], [-121.69345, 38.30671], [-121.69341, 38.31443], [-121.66772, 38.31408], [-121.66723, 38.31409], [-121.66704, 38.30674]]]} | Open Access 1 | 43100 | Liberty Island | 32352 | 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/Liberty-Island-ER | Solano 26 | 3873.908 | Liberty Island | 0 | State Resource Management Area 55 | 3 |
3285 | 3285 | 3284 | {"type": "Polygon", "coordinates": [[[-120.0828, 38.3461], [-120.08263, 38.35322], [-120.08006, 38.35324], [-120.0736, 38.35313], [-120.07364, 38.35139], [-120.07808, 38.35147], [-120.07829, 38.34769], [-120.07828, 38.34768], [-120.07372, 38.34762], [-120.07376, 38.346], [-120.0828, 38.3461]]]} | Restricted Access 2 | 23368 | Sands Meadow | 25024 | 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 | Tuolumne 21 | 114.054 | Sands Meadow | 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 | |
12572 | 12572 | 12571 | {"type": "Polygon", "coordinates": [[[-117.69973, 33.97316], [-117.6997, 33.97405], [-117.6991, 33.97403], [-117.6991, 33.97333], [-117.69894, 33.97306], [-117.69971, 33.97306], [-117.69971, 33.97316], [-117.69973, 33.97316]]]} | Restricted Access 2 | 29090 | Chino Fish & Wildlife Base | 17207 | 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 Bernardino 22 | 1.585 | Chino Fish & Wildlife Base | 0 | State Resource Management Area 55 | 3 | |
14659 | 14659 | 14658 | {"type": "MultiPolygon", "coordinates": [[[[-118.941, 35.42402], [-118.94048, 35.42386], [-118.94016, 35.42372], [-118.9391, 35.42317], [-118.93871, 35.42304], [-118.93844, 35.423], [-118.93803, 35.42298], [-118.93734, 35.42304], [-118.93692, 35.42306], [-118.9365, 35.42306], [-118.93576, 35.42302], [-118.93528, 35.42301], [-118.9348, 35.42302], [-118.93432, 35.42305], [-118.93431, 35.4198], [-118.94097, 35.41976], [-118.941, 35.42402]]], [[[-118.941, 35.42419], [-118.941, 35.42531], [-118.93974, 35.42582], [-118.93948, 35.4254], [-118.93905, 35.42554], [-118.93874, 35.42561], [-118.937, 35.42582], [-118.93641, 35.42595], [-118.93585, 35.42613], [-118.93532, 35.42637], [-118.93499, 35.42656], [-118.93433, 35.42702], [-118.93432, 35.42322], [-118.9348, 35.42319], [-118.93527, 35.42317], [-118.93575, 35.42318], [-118.93649, 35.42323], [-118.93692, 35.42323], [-118.93736, 35.42321], [-118.93804, 35.42314], [-118.93829, 35.42315], [-118.93854, 35.42318], [-118.93878, 35.42323], [-118.93901, 35.42331], [-118.9399, 35.42379], [-118.94025, 35.42395], [-118.94062, 35.42408], [-118.941, 35.42419]]]]} | Restricted Access 2 | 44922 | Bakersfield | 15768 | 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 | 98.585 | Bakersfield | 0 | State Resource Management Area 55 | 3 | |
545 | 545 | 544 | {"type": "Polygon", "coordinates": [[[-122.31307, 41.2763], [-122.31264, 41.2763], [-122.31266, 41.2752], [-122.31307, 41.2752], [-122.31307, 41.2763]]]} | No Public Access 3 | 1814 | Lower Box Canyon | 32208 | 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 | 1.061 | Lower Box Canyon | 0 | State Resource Management Area 55 | 3 | |
1130 | 1130 | 1129 | {"type": "Polygon", "coordinates": [[[-118.05045, 37.26696], [-118.05032, 37.28884], [-118.04578, 37.2888], [-118.0458, 37.28518], [-118.04122, 37.28514], [-118.04125, 37.28152], [-118.03671, 37.28148], [-118.03674, 37.27786], [-118.03221, 37.27783], [-118.0323, 37.26688], [-118.05045, 37.26696]]]} | No Public Access 3 | 6619 | Deep Springs Lake | 32146 | 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 | 725.874 | Deep Springs Lake | 0 | State Resource Management Area 55 | 3 | |
1362 | 1362 | 1361 | {"type": "MultiPolygon", "coordinates": [[[[-120.54592, 36.6911], [-120.53904, 36.69108], [-120.53903, 36.68751], [-120.53931, 36.68748], [-120.53932, 36.67661], [-120.53965, 36.67662], [-120.54592, 36.6911]]], [[[-120.54644, 36.69054], [-120.54632, 36.69071], [-120.54625, 36.69074], [-120.54003, 36.67662], [-120.54028, 36.67664], [-120.54644, 36.69054]]]]} | No Public Access 3 | 8074 | Pilobos | 32263 | 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 | 134.36 | Pilobos | 0 | State Resource Management Area 55 | 3 | |
1581 | 1581 | 1580 | {"type": "Polygon", "coordinates": [[[-115.54599, 33.539], [-115.53693, 33.53898], [-115.53689, 33.53374], [-115.53922, 33.53373], [-115.53931, 33.53565], [-115.54152, 33.53564], [-115.54145, 33.53741], [-115.54597, 33.53769], [-115.54599, 33.539]]]} | No Public Access 3 | 12128 | Chuckwalla Bench | 32115 | 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 | 66.962 | Chuckwalla Bench | 0 | State Resource Management Area 55 | 3 | |
1949 | 1949 | 1948 | {"type": "Polygon", "coordinates": [[[-119.3411, 35.24915], [-119.33804, 35.25071], [-119.33274, 35.25344], [-119.32347, 35.25337], [-119.32342, 35.24243], [-119.33225, 35.24252], [-119.3322, 35.23881], [-119.34107, 35.23889], [-119.3411, 35.24915]]]} | No Public Access 3 | 16653 | Elk Hills | 32158 | 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 | 517.552 | Elk Hills | 0 | State Resource Management Area 55 | 3 | |
1956 | 1956 | 1955 | {"type": "Polygon", "coordinates": [[[-117.8303, 35.57191], [-117.83026, 35.57926], [-117.82582, 35.57925], [-117.82581, 35.58284], [-117.82577, 35.58649], [-117.82128, 35.58644], [-117.82132, 35.58281], [-117.82141, 35.57924], [-117.82581, 35.57924], [-117.82587, 35.57561], [-117.82586, 35.5756], [-117.82143, 35.57557], [-117.82145, 35.57191], [-117.8303, 35.57191]]]} | No Public Access 3 | 16665 | Indian Wells Valley | 32190 | 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 | 201.555 | Indian Wells Valley | 0 | State Resource Management Area 55 | 3 | |
2417 | 2417 | 2416 | {"type": "Polygon", "coordinates": [[[-120.82613, 36.92597], [-120.81978, 36.92585], [-120.82012, 36.91517], [-120.82491, 36.91943], [-120.82613, 36.92597]]]} | No Public Access 3 | 17273 | Dos Amigos | 32151 | 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 | Merced 37 | 114.925 | Dos Amigos | 0 | State Resource Management Area 55 | 3 | |
2428 | 2428 | 2427 | {"type": "MultiPolygon", "coordinates": [[[[-120.39692, 37.50741], [-120.39664, 37.51843], [-120.39339, 37.51813], [-120.39035, 37.51702], [-120.3889, 37.51665], [-120.38848, 37.51633], [-120.3843, 37.51606], [-120.38436, 37.5155], [-120.38449, 37.51059], [-120.38471, 37.51053], [-120.38563, 37.51016], [-120.38827, 37.50854], [-120.3895, 37.50769], [-120.39086, 37.50715], [-120.39629, 37.50707], [-120.39692, 37.50741]]], [[[-120.39693, 37.50636], [-120.39692, 37.50692], [-120.39645, 37.50666], [-120.39073, 37.50674], [-120.38921, 37.50734], [-120.38794, 37.50822], [-120.38536, 37.50981], [-120.3845, 37.51015], [-120.38462, 37.50621], [-120.39333, 37.50635], [-120.39693, 37.50636]]]]} | No Public Access 3 | 17291 | Merced River | 32217 | 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 | Merced 37 | 311.747 | Merced River | 0 | State Resource Management Area 55 | 3 | |
2481 | 2481 | 2480 | {"type": "Polygon", "coordinates": [[[-122.19661, 40.26979], [-122.19658, 40.27249], [-122.19162, 40.27297], [-122.18953, 40.27326], [-122.19087, 40.26973], [-122.19661, 40.26979]]]} | No Public Access 3 | 17478 | Bend Ferry Road | 32047 | 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 | Tehama 18 | 45.388 | Bend Ferry Road | 0 | State Resource Management Area 55 | 3 | |
3147 | 3147 | 3146 | {"type": "MultiPolygon", "coordinates": [[[[-120.81642, 38.5584], [-120.8161, 38.55859], [-120.81609, 38.55862], [-120.81611, 38.55839], [-120.81642, 38.5584]]], [[[-120.82405, 38.55808], [-120.82414, 38.55836], [-120.82417, 38.55862], [-120.82414, 38.55901], [-120.82407, 38.55919], [-120.82377, 38.55954], [-120.82358, 38.55964], [-120.82332, 38.55973], [-120.82311, 38.55974], [-120.82289, 38.55977], [-120.82264, 38.55976], [-120.82233, 38.5597], [-120.82197, 38.55968], [-120.82166, 38.55965], [-120.82129, 38.55955], [-120.82089, 38.55941], [-120.8206, 38.55925], [-120.82011, 38.55885], [-120.81942, 38.55845], [-120.81877, 38.55822], [-120.81842, 38.55813], [-120.81821, 38.55806], [-120.82405, 38.55808]]]]} | No Public Access 3 | 21619 | Upper Cosumnes River | 32342 | 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 | Amador 52 | 15.616 | Upper Cosumnes River | 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]);