units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
137 rows where ACCESS_TYP = 3 and MNG_AG_TYP = 5
This data as json, copyable, CSV (advanced)
DES_TP 27
- State Resource Management Area 54
- State Conservation Area 18
- State Other or Unknown 17
- State Park 4
- State Historic or Cultural Area 2
- State Recreation Area 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
MNG_AGENCY 14
- California Department of Fish and Wildlife 68
- California Department of Parks and Recreation 13
- California Department of Water Resources 10
- California Department of General Services 9
- California Department of Transportation 5
- California Wildlife Conservation Board 2
- Coachella Valley Mountains Conservancy 2
- California Tahoe Conservancy 2
- University of California 1
- California State Lands Commission 1
- Other State 1
- Napa Valley College 1
- California State University 1
- California State Coastal Conservancy 1
MNG_AG_TYP 1
- State Agency · 117 ✖
ACCESS_TYP 1
- No Public Access · 117 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
3155 | 3155 | 3154 | {"type": "Polygon", "coordinates": [[[-121.52015, 38.36105], [-121.52, 38.36138], [-121.51988, 38.36172], [-121.51976, 38.36228], [-121.51967, 38.36299], [-121.51968, 38.36374], [-121.51983, 38.36443], [-121.51986, 38.3652], [-121.51994, 38.36596], [-121.52002, 38.3666], [-121.51995, 38.36694], [-121.51977, 38.3671], [-121.51892, 38.36686], [-121.51857, 38.36669], [-121.51813, 38.36655], [-121.51157, 38.3651], [-121.51168, 38.35783], [-121.51938, 38.36011], [-121.51901, 38.36077], [-121.52015, 38.36105]]]} | No Public Access 3 | 21762 | Hood Test Facilities | 30565 | 207 | California Department of Water Resources 477 | State 5 | State Agency 5 | http://www.water.ca.gov/ | Other State 5 | 207 | California Department of Water Resources 470 | State 5 | State Agency 5 | Sacramento 41 | 136.958 | Hood Test Facilities | None 257 | |||
3159 | 3159 | 3158 | {"type": "Polygon", "coordinates": [[[-121.50125, 38.31704], [-121.50005, 38.31773], [-121.49878, 38.31973], [-121.49852, 38.31959], [-121.4985, 38.3196], [-121.49847, 38.31958], [-121.4946, 38.31753], [-121.49279, 38.31453], [-121.50082, 38.31445], [-121.50125, 38.31704]]]} | No Public Access 3 | 21834 | Stone Lakes | 25871 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Sacramento 41 | 68.284 | Stone Lakes | None 259 | ||||
3167 | 3167 | 3166 | {"type": "MultiPolygon", "coordinates": [[[[-116.68524, 34.06247], [-116.6852, 34.07681], [-116.66784, 34.07682], [-116.66779, 34.06235], [-116.65036, 34.06223], [-116.65034, 34.04784], [-116.66779, 34.04785], [-116.6678, 34.06235], [-116.68524, 34.06247]]], [[[-116.6938, 34.10576], [-116.69375, 34.11974], [-116.68527, 34.11965], [-116.6851, 34.10573], [-116.66771, 34.1057], [-116.66798, 34.09129], [-116.68529, 34.09155], [-116.6851, 34.10573], [-116.6938, 34.10576]]]]} | No Public Access 3 | 21980 | Mission Creek | 32221 | 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 | 2202.531 | Mission Creek | 0 | State Resource Management Area 55 | 3 | |
3296 | 3296 | 3295 | {"type": "Polygon", "coordinates": [[[-121.61412, 37.7845], [-121.61412, 37.78579], [-121.61407, 37.78736], [-121.60506, 37.78748], [-121.605, 37.78452], [-121.6051, 37.78452], [-121.60511, 37.78451], [-121.61412, 37.7845]]]} | No Public Access 3 | 23599 | Christensen Road Burrowing Owl Site | 32113 | 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 | Alameda 17 | 63.899 | Christensen Road Burrowing Owl Site | 0 | State Resource Management Area 55 | 3 | |
3312 | 3312 | 3311 | {"type": "Polygon", "coordinates": [[[-117.05061, 34.06564], [-117.05016, 34.06761], [-117.04942, 34.06795], [-117.04771, 34.06692], [-117.04766, 34.06428], [-117.04902, 34.06452], [-117.05061, 34.06564]]]} | No Public Access 3 | 29659 | Crafton Hills Reservoir | 17748 | 207 | California Department of Water Resources 477 | State 5 | State Agency 5 | http://www.water.ca.gov/ | Other State 5 | 207 | California Department of Water Resources 470 | State 5 | State Agency 5 | San Bernardino 22 | 19.391 | Crafton Hills Reservoir | None 270 | |||
3427 | 3427 | 3426 | {"type": "Polygon", "coordinates": [[[-122.01238, 36.97053], [-122.01187, 36.97081], [-122.01185, 36.97079], [-122.01191, 36.97056], [-122.01223, 36.97036], [-122.01238, 36.97053]]]} | No Public Access 3 | 25174 | South Branciforte | 32313 | 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 Cruz 5 | 0.251 | South Branciforte | 0 | State Resource Management Area 55 | 3 | |
3439 | 3439 | 3438 | {"type": "Polygon", "coordinates": [[[-116.69795, 34.67637], [-116.68049, 34.67634], [-116.68049, 34.67369], [-116.69794, 34.67376], [-116.69795, 34.67637]]]} | No Public Access 3 | 25252 | Ord Rodman | 32252 | 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 | 115.534 | Ord Rodman | 0 | State Resource Management Area 55 | 3 | |
3441 | 3441 | 3440 | {"type": "Polygon", "coordinates": [[[-120.25813, 38.62982], [-120.25788, 38.63346], [-120.25343, 38.63333], [-120.25308, 38.63683], [-120.24397, 38.63654], [-120.2445, 38.63308], [-120.24896, 38.63318], [-120.2494, 38.62968], [-120.25813, 38.62982]]]} | No Public Access 3 | 25249 | Leek Springs Ecological Reserve | 32201 | 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 | El Dorado 34 | 151.078 | Leek Springs ER | 0 | State Conservation Area 8 | 2 | |
3442 | 3442 | 3441 | {"type": "Polygon", "coordinates": [[[-123.96676, 41.87177], [-123.95707, 41.87178], [-123.95706, 41.86815], [-123.96193, 41.86808], [-123.96197, 41.86444], [-123.96673, 41.86439], [-123.96667, 41.86953], [-123.96676, 41.87177]]]} | No Public Access 3 | 25256 | Stoney Creek | 32321 | 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 | Del Norte 50 | 120.393 | Stoney Creek | 0 | State Resource Management Area 55 | 3 | |
3485 | 3485 | 3484 | {"type": "Polygon", "coordinates": [[[-123.05209, 38.33746], [-123.05198, 38.33754], [-123.05179, 38.33741], [-123.05131, 38.33782], [-123.05136, 38.33837], [-123.04991, 38.33944], [-123.04926, 38.33873], [-123.05025, 38.33836], [-123.05118, 38.33786], [-123.05131, 38.33741], [-123.05145, 38.33698], [-123.05209, 38.33746]]]} | No Public Access 3 | 25904 | Bodega Bay Monarch Butterfly | 32057 | 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 | Sonoma 16 | 4.076 | Bodega Bay Monarch Butterfly | 0 | State Resource Management Area 55 | 3 | |
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 | |
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 | |
3744 | 3744 | 3743 | {"type": "Polygon", "coordinates": [[[-117.00555, 32.56116], [-117.00554, 32.56472], [-117.00446, 32.56471], [-117.00445, 32.56601], [-117.00443, 32.56603], [-117.00418, 32.566], [-117.00401, 32.56588], [-117.00338, 32.56582], [-117.00337, 32.56469], [-117.00123, 32.56466], [-117.00126, 32.56109], [-117.00555, 32.56116]]]} | No Public Access 3 | 44877 | Anderprises TransNet Environmental Mitigation | 32283 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | San Diego 4 | 42.881 | Anderprises TransNet Environmental Mitigation | 0 | State Other or Unknown 104 | 4 | |
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 | |
4112 | 4112 | 4111 | {"type": "MultiPolygon", "coordinates": [[[[-116.10313, 32.97253], [-116.08534, 32.97217], [-116.06792, 32.9725], [-116.05047, 32.97274], [-116.03293, 32.97275], [-116.0329, 32.94732], [-115.9981, 32.94734], [-115.99811, 32.91832], [-116.00641, 32.91832], [-116.00641, 32.91436], [-116.011, 32.91439], [-116.01099, 32.91832], [-116.01542, 32.91833], [-116.01532, 32.90381], [-115.99811, 32.90381], [-115.9981, 32.89992], [-115.98549, 32.89992], [-115.98547, 32.89629], [-115.98544, 32.85633], [-116.00259, 32.85632], [-116.01982, 32.85635], [-116.03708, 32.8563], [-116.05427, 32.85633], [-116.07149, 32.85628], [-116.10254, 32.85628], [-116.10241, 32.85775], [-116.10377, 32.88899], [-116.10332, 32.89611], [-116.10334, 32.90363], [-116.10325, 32.91815], [-116.1032, 32.94713], [-116.10313, 32.97253]], [[-116.06795, 32.96175], [-116.06799, 32.94726], [-116.05046, 32.94736], [-116.05046, 32.96188], [-116.06795, 32.96175]], [[-116.06859, 32.87224], [-116.0686, 32.87223], [-116.06867, 32.85753], [-116.05054, 32.85746], [-116.05052, 32.8721], [-116.06859, 32.87224]]], [[[-116.08442, 33.33923], [-116.067, 33.33919], [-116.04977, 33.3391], [-116.03248, 33.33904], [-116.01568, 33.339], [-116.01214, 33.33901], [-116.01232, 33.33891], [-116.01218, 33.33872], [-116.01207, 33.33869], [-116.01196, 33.33864], [-116.01182, 33.3385], [-116.0118, 33.33847], [-116.01178, 33.33806], [-116.00945, 33.33805], [-116.00893, 33.33786], [-116.00864, 33.3377], [-116.00861, 33.33772], [-116.00835, 33.33754], [-116.00819, 33.3374], [-116.00791, 33.33709], [-116.00779, 33.33691], [-116.0021, 33.32939], [-116.00204, 33.32921], [-116.00202, 33.3291], [-116.00202, 33.32888], [-116.00227, 33.32779], [-116.0023, 33.32753], [-116.00228, 33.32728], [-116.00224, 33.32715], [-116.00214, 33.32691], [-116.00197, 33.32662], [-116.00247, 33.32632], [-116.00331, 33.32589], [-116.00317, 33.3257], [-116.00231, 33.32612], [-116.00179, 33.32632], [-116.00162, 33.32612], [-116.0014, 33.32593], [-116.00128, 33.32585], [-116.00101, 33.32571], [-116.00071, 33.3256], [-115.99955, 33.32533], [-115.99917, 33.32516], [-115.99895, 33.32501], [-115.99877, 33.32483], [-115.99869, 33.3244], [-115.99864, 33.32431], [-115.99855, 33.32426], [-115.99844, 33.32424], [-115.99836, 33.32425], [-115.99822, 33.32432], [-115.99808, 33.32411], [-115.99843, 33.32374], [-115.99897, 33.32328], [-115.99988, 33.3227], [-116.00023, 33.32253], [-116.00053, 33.32241], [-116.00079, 33.3224], [-116.00101, 33.32231], [-116.0012, 33.32205], [-116.00123, 33.32173], [-116.00134, 33.32158], [-116.00153, 33.32145], [-116.00174, 33.32141], [-116.00196, 33.32145], [-116.00218, 33.32157], [-116.00235, 33.3216], [-116.00257, 33.32157], [-116.00275, 33.32149], [-116.00298, 33.32131], [-116.0034, 33.32087], [-116.00368, 33.32069], [-116.00396, 33.32061], [-116.00444, 33.32054], [-116.00477, 33.32052], [-116.00553, 33.32038], [-116.00585, 33.32027], [-116.00613, 33.32024], [-116.00634, 33.32024], [-116.00671, 33.32003], [-116.00695, 33.31968], [-116.00712, 33.31954], [-116.00735, 33.31946], [-116.0076, 33.3194], [-116.00804, 33.31942], [-116.00828, 33.31941], [-116.00843, 33.31933], [-116.00855, 33.31915], [-116.00856, 33.31893], [-116.00851, 33.31868], [-116.00855, 33.31849], [-116.0087, 33.31833], [-116.00893, 33.31819], [-116.00945, 33.31799], [-116.00993, 33.31784], [-116.01006, 33.31776], [-116.01013, 33.31754], [-116.01009, 33.31729], [-116.01016, 33.3171], [-116.01035, 33.31702], [-116.01069, 33.31698], [-116.01097, 33.31697], [-116.01123, 33.317], [-116.01146, 33.31701], [-116.01165, 33.31694], [-116.01178, 33.31681], [-116.01179, 33.31668], [-116.01172, 33.31656], [-116.01162, 33.31646], [-116.01112, 33.31635], [-116.01087, 33.31636], [-116.01067, 33.3163], [-116.01054, 33.31619], [-116.01049, 33.31601], [-116.01054, 33.31584], [-116.01065, 33.31576], [-116.0114, 33.31576], [-116.01221, 33.31569], [-116.01303, 33.31575], [-116.01329, 33.31569], [-116.01367, 33.31551], [-116.01394, 33.31529], [-116.01423, 33.3151], [-116.01489, 33.31473], [-116.0151, 33.31465], [-116.01527, 33.31465], [-116.0155, 33.3147], [-116.01575, 33.31466], [-116.01632, 33.31446], [-116.01658, 33.31444], [-116.017, 33.31434], [-116.01721, 33.31442], [-116.01754, 33.31467], [-116.01765, 33.31468], [-116.01778, 33.31461], [-116.01787, 33.31449], [-116.01803, 33.31418], [-116.01812, 33.31411], [-116.01823, 33.31409], [-116.01837, 33.31411], [-116.01845, 33.31416], [-116.01864, 33.31463], [-116.01882, 33.31478], [-116.01899, 33.31495], [-116.01908, 33.31514], [-116.01921, 33.31518], [-116.01935, 33.31514], [-116.01951, 33.31505], [-116.01967, 33.31499], [-116.01979, 33.31499], [-116.02025, 33.31518], [-116.02041, 33.31519], [-116.02059, 33.31517], [-116.02069, 33.31523], [-116.02078, 33.31534], [-116.02093, 33.31545], [-116.02109, 33.31551], [-116.02187, 33.3154], [-116.02225, 33.3155], [-116.02249, 33.31568], [-116.0226, 33.31571], [-116.02279, 33.31563], [-116.02278, 33.31557], [-116.02257, 33.31531], [-116.02254, 33.31516], [-116.02263, 33.31509], [-116.0227, 33.31506], [-116.02294, 33.31504], [-116.02362, 33.31519], [-116.02393, 33.31522], [-116.02423, 33.3152], [-116.02469, 33.3151], [-116.02541, 33.3149], [-116.02582, 33.3147], [-116.02629, 33.3144], [-116.02681, 33.314], [-116.02702, 33.31394], [-116.02727, 33.31389], [-116.02726, 33.31421], [-116.02728, 33.31434], [-116.02738, 33.31447], [-116.02761, 33.3146], [-116.02791, 33.31457], [-116.02808, 33.31462], [-116.0282, 33.31478], [-116.02834, 33.31491], [-116.02857, 33.31501], [-116.02882, 33.31508], [-116.02935, 33.3153], [-116.02948, 33.31544], [-116.02957, 33.31557], [-116.0297, 33.31556], [-116.02993, 33.31541], [-116.02996, 33.3153], [-116.03002, 33.31521], [-116.03003, 33.31511], [-116.03021, 33.31491], [-116.03023, 33.31476], [-116.03031, 33.31469], [-116.03034, 33.31461], [-116.03034, 33.3144], [-116.03042, 33.31432], [-116.03057, 33.31425], [-116.03069, 33.31425], [-116.03105, 33.31437], [-116.03123, 33.31445], [-116.03136, 33.31448], [-116.03159, 33.31431], [-116.03184, 33.31417], [-116.03188, 33.31411], [-116.03218, 33.31406], [-116.03232, 33.31406], [-116.03302, 33.31383], [-116.03336, 33.31391], [-116.03351, 33.31387], [-116.0336, 33.3138], [-116.03358, 33.31362], [-116.03361, 33.31359], [-116.03366, 33.31355], [-116.03369, 33.3135], [-116.03382, 33.31343], [-116.03387, 33.31344], [-116.0341, 33.31362], [-116.0342, 33.31366], [-116.03433, 33.31366], [-116.0345, 33.31359], [-116.0348, 33.31355], [-116.03491, 33.31356], [-116.03518, 33.31362], [-116.03536, 33.31351], [-116.03538, 33.31341], [-116.03536, 33.31328], [-116.03539, 33.3132], [-116.03544, 33.3131], [-116.03554, 33.31306], [-116.03563, 33.31308], [-116.03573, 33.31318], [-116.0359, 33.3132], [-116.03607, 33.31324], [-116.03616, 33.31324], [-116.03631, 33.31327], [-116.0364, 33.31335], [-116.03644, 33.31342], [-116.03636, 33.31362], [-116.03636, 33.31374], [-116.03644, 33.31384], [-116.03655, 33.31388], [-116.03662, 33.31393], [-116.03662, 33.314], [-116.03666, 33.31409], [-116.03683, 33.31429], [-116.03682, 33.31436], [-116.03689, 33.31447], [-116.03698, 33.31449], [-116.03709, 33.31443], [-116.03713, 33.31433], [-116.03726, 33.31422], [-116.03749, 33.31417], [-116.03759, 33.3141], [-116.03782, 33.31399], [-116.03806, 33.31386], [-116.03831, 33.31386], [-116.0385, 33.31389], [-116.03859, 33.31395], [-116.03846, 33.31425], [-116.03835, 33.31448], [-116.03831, 33.31467], [-116.03833, 33.31485], [-116.03847, 33.31512], [-116.03859, 33.31523], [-116.03875, 33.3153], [-116.03911, 33.3154], [-116.0392, 33.31548], [-116.03923, 33.31571], [-116.0393, 33.3158], [-116.03943, 33.31584], [-116.03957, 33.31583], [-116.03979, 33.31577], [-116.04001, 33.31569], [-116.04025, 33.31563], [-116.04042, 33.31554], [-116.04089, 33.31523], [-116.04114, 33.31519], [-116.04134, 33.31524], [-116.04199, 33.31565], [-116.04233, 33.31584], [-116.04267, 33.31608], [-116.04277, 33.31623], [-116.04281, 33.3165], [-116.04276, 33.31669], [-116.04267, 33.31686], [-116.04272, 33.317], [-116.04285, 33.31719], [-116.04312, 33.31734], [-116.04353, 33.31734], [-116.04386, 33.31718], [-116.04415, 33.31675], [-116.0442, 33.31662], [-116.04446, 33.31649], [-116.0446, 33.31648], [-116.04474, 33.31649], [-116.04487, 33.31656], [-116.04511, 33.31694], [-116.0452, 33.31704], [-116.04529, 33.3172], [-116.04547, 33.31744], [-116.04569, 33.31762], [-116.04595, 33.31775], [-116.04615, 33.31778], [-116.0463, 33.31774], [-116.04637, 33.31767], [-116.04671, 33.31713], [-116.04698, 33.31675], [-116.0471, 33.31644], [-116.04722, 33.31623], [-116.0472, 33.31613], [-116.04723, 33.31601], [-116.04713, 33.31587], [-116.0469, 33.31563], [-116.04686, 33.31536], [-116.04705, 33.31512], [-116.04726, 33.31505], [-116.04733, 33.31501], [-116.04757, 33.31479], [-116.04781, 33.31469], [-116.04798, 33.31462], [-116.04831, 33.31462], [-116.0485, 33.31456], [-116.04879, 33.31443], [-116.04923, 33.31435], [-116.04943, 33.31419], [-116.04946, 33.31395], [-116.04952, 33.31375], [-116.04966, 33.31362], [-116.04964, 33.30977], [-116.06695, 33.30979], [-116.06692, 33.2951], [-116.06995, 33.2951], [-116.06996, 33.29509], [-116.06983, 33.29504], [-116.06961, 33.29498], [-116.06944, 33.29489], [-116.06923, 33.29455], [-116.0692, 33.29443], [-116.06918, 33.29421], [-116.06911, 33.29415], [-116.06887, 33.29414], [-116.06867, 33.29417], [-116.0682, 33.29436], [-116.0681, 33.29437], [-116.06796, 33.2943], [-116.06785, 33.29416], [-116.06781, 33.294], [-116.0678, 33.2938], [-116.06785, 33.29368], [-116.06812, 33.29345], [-116.06817, 33.29336], [-116.06815, 33.29329], [-116.06809, 33.2932], [-116.06807, 33.29311], [-116.06807, 33.293], [-116.0681, 33.29295], [-116.06816, 33.29289], [-116.06858, 33.29275], [-116.06868, 33.29268], [-116.06871, 33.29263], [-116.06872, 33.29258], [-116.06867, 33.29253], [-116.06846, 33.29253], [-116.06835, 33.29249], [-116.06812, 33.29227], [-116.06812, 33.29219], [-116.06814, 33.29202], [-116.06809, 33.29194], [-116.06799, 33.29187], [-116.06788, 33.29183], [-116.06774, 33.29185], [-116.06767, 33.29192], [-116.06759, 33.29204], [-116.06743, 33.2922], [-116.06734, 33.29226], [-116.06724, 33.29228], [-116.06711, 33.29225], [-116.06699, 33.2922], [-116.06692, 33.29214], [-116.06684, 33.29202], [-116.06666, 33.29178], [-116.06664, 33.2917], [-116.06664, 33.29156], [-116.06672, 33.29137], [-116.06685, 33.2912], [-116.0669, 33.29109], [-116.0669, 33.29094], [-116.06687, 33.29083], [-116.0668, 33.29077], [-116.06674, 33.29075], [-116.06647, 33.29089], [-116.0663, 33.29093], [-116.0661, 33.29094], [-116.06595, 33.29091], [-116.06586, 33.29084], [-116.06583, 33.29073], [-116.06581, 33.29033], [-116.06577, 33.29023], [-116.06571, 33.29015], [-116.06563, 33.29012], [-116.06552, 33.2901], [-116.06536, 33.29009], [-116.06523, 33.29012], [-116.06512, 33.29011], [-116.06493, 33.29], [-116.06484, 33.28993], [-116.06473, 33.28974], [-116.06463, 33.28962], [-116.06438, 33.28943], [-116.064, 33.28926], [-116.06369, 33.28917], [-116.06339, 33.28904], [-116.06369, 33.28857], [-116.06393, 33.28814], [-116.06406, 33.28768], [-116.06425, 33.28751], [-116.0645, 33.28746], [-116.06512, 33.28755], [-116.06617, 33.28791], [-116.06691, 33.28802], [-116.06757, 33.28801], [-116.06806, 33.28795], [-116.06878, 33.28799], [-116.06903, 33.28797], [-116.06921, 33.28789], [-116.06955, 33.28762], [-116.06967, 33.28749], [-116.06975, 33.28728], [-116.06983, 33.28718], [-116.07, 33.28709], [-116.07018, 33.28705], [-116.07082, 33.28704], [-116.07152, 33.2871], [-116.07182, 33.28716], [-116.07255, 33.28741], [-116.0731, 33.28764], [-116.07349, 33.28772], [-116.07379, 33.28774], [-116.07399, 33.28766], [-116.07413, 33.28751], [-116.07419, 33.2873], [-116.07423, 33.28692], [-116.07425, 33.28685], [-116.07433, 33.28671], [-116.0746, 33.28648], [-116.0747, 33.28645], [-116.07504, 33.28658], [-116.07536, 33.28666], [-116.07562, 33.28676], [-116.07577, 33.2868], [-116.07592, 33.2868], [-116.07617, 33.28673], [-116.07634, 33.28657], [-116.07656, 33.28644], [-116.07703, 33.2864], [-116.07715, 33.28638], [-116.07735, 33.28642], [-116.07765, 33.28652], [-116.07793, 33.28668], [-116.07829, 33.28707], [-116.07839, 33.28714], [-116.07854, 33.28716], [-116.07864, 33.28715], [-116.07878, 33.28709], [-116.07906, 33.28677], [-116.07929, 33.28654], [-116.07969, 33.28629], [-116.08001, 33.28622], [-116.08032, 33.28626], [-116.0806, 33.28643], [-116.0809, 33.28655], [-116.0812, 33.28664], [-116.08142, 33.28663], [-116.08146, 33.2865], [-116.08143, 33.28638], [-116.08133, 33.28619], [-116.08119, 33.28605], [-116.08118, 33.28587], [-116.08139, 33.28572], [-116.08163, 33.28558], [-116.08193, 33.28546], [-116.08207, 33.2853], [-116.08206, 33.28519], [-116.0821, 33.28509], [-116.08231, 33.28494], [-116.08252, 33.28482], [-116.08274, 33.28483], [-116.08295, 33.28492], [-116.08318, 33.28498], [-116.0834, 33.28491], [-116.08389, 33.2844], [-116.08401, 33.28417], [-116.08407, 33.28397], [-116.08441, 33.28392], [-116.08441, 33.30246], [-116.0844, 33.30979], [-116.08442, 33.3098], [-116.08442, 33.33923]], [[-116.03243, 33.3245], [-116.01534, 33.32447], [-116.01551, 33.33172], [-116.02821, 33.33176], [-116.02819, 33.32812], [-116.03244, 33.32813], [-116.03243, 33.3245]], [[-116.03248, 33.33857], [-116.03249, 33.33858], [-116.03255, 33.33857], [-116.03246, 33.33059], [-116.03248, 33.33857]]], [[[-116.00161, 33.32639], [-116.00058, 33.32661], [-115.99915, 33.32552], [-115.99879, 33.32506], [-115.99894, 33.32522], [-115.9992, 33.32537], [-115.99934, 33.32544], [-115.99963, 33.32553], [-116.00065, 33.32576], [-116.00092, 33.32585], [-116.00104, 33.32591], [-116.00127, 33.32605], [-116.00147, 33.32622], [-116.00161, 33.32639]]], [[[-116.00188, 33.32936], [-116.00116, 33.32817], [-116.00122, 33.32711], [-116.00182, 33.32673], [-116.00195, 33.32697], [-116.00204, 33.32719], [-116.00207, 33.3273], [-116.0021, 33.32752], [-116.00207, 33.32775], [-116.00181, 33.32886], [-116.00182, 33.32911], [-116.00184, 33.32924], [-116.00188, 33.32936]]]]} | No Public Access 3 | 47090 | Anza-Borrego Desert State Park | 30751 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=638 | Imperial 20 | 34662.1 | Anza-Borrego Desert SP | 1933 | State Park 15 | 4 |
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]);