units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
443 rows where MNG_AGENCY = 25 sorted by YR_EST
This data as json, copyable, CSV (advanced)
DES_TP 6
ACCESS_TYP 3
- Open Access 286
- No Public Access 72
- Restricted Access 65
MNG_AG_TYP 1
- State Agency 423
MNG_AGENCY 1
- California Department of Fish and Wildlife · 423 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
2508 | 2508 | 2507 | {"type": "Polygon", "coordinates": [[[-121.24804, 38.63376], [-121.24739, 38.63522], [-121.24697, 38.63508], [-121.24352, 38.63369], [-121.24282, 38.63347], [-121.242, 38.63327], [-121.24122, 38.63298], [-121.24087, 38.6328], [-121.24054, 38.63257], [-121.24015, 38.63234], [-121.23977, 38.63218], [-121.23316, 38.63264], [-121.23297, 38.63186], [-121.22925, 38.63193], [-121.22925, 38.63137], [-121.23982, 38.63078], [-121.24804, 38.63376]]]} | Open Access 1 | 17562 | American River Access | 32019 | 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 | Sacramento 41 | 59.692 | American River Access | 0 | State Recreation Area 39 | 4 | |
2573 | 2573 | 2572 | {"type": "Polygon", "coordinates": [[[-122.22395, 40.26271], [-122.2237, 40.26323], [-122.22328, 40.26376], [-122.22186, 40.26304], [-122.22219, 40.26302], [-122.22269, 40.26218], [-122.22395, 40.26271]]]} | Open Access 1 | 17891 | Bend Bridge Public Access | 32046 | 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 | 3.867 | Bend Bridge PA | 0 | State Recreation Area 39 | 4 | |
2631 | 2631 | 2630 | {"type": "Polygon", "coordinates": [[[-121.49959, 37.6491], [-121.49457, 37.649], [-121.49018, 37.64886], [-121.49073, 37.64768], [-121.49079, 37.6476], [-121.49097, 37.64704], [-121.49108, 37.64648], [-121.49155, 37.63993], [-121.4916, 37.63962], [-121.49221, 37.6393], [-121.4944, 37.63887], [-121.49444, 37.63989], [-121.4952, 37.64234], [-121.49679, 37.64307], [-121.49847, 37.64757], [-121.49959, 37.6491]], [[-121.49355, 37.64011], [-121.49277, 37.64012], [-121.49267, 37.64151], [-121.49369, 37.64277], [-121.49423, 37.64241], [-121.49463, 37.64166], [-121.49429, 37.64112], [-121.49355, 37.64011]]]} | No Public Access 3 | 18038 | Corral Hollow Ecological Reserve | 32134 | 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 | 125.166 | Corral Hollow ER | 0 | State Conservation Area 8 | 2 | |
2637 | 2637 | 2636 | {"type": "Polygon", "coordinates": [[[-122.93426, 38.43681], [-122.93107, 38.43684], [-122.92903, 38.43689], [-122.92899, 38.4368], [-122.92897, 38.4367], [-122.92903, 38.43623], [-122.92908, 38.43609], [-122.92928, 38.43568], [-122.92964, 38.43476], [-122.92971, 38.43446], [-122.92971, 38.43416], [-122.92954, 38.43343], [-122.92954, 38.43324], [-122.93106, 38.43321], [-122.93269, 38.43323], [-122.93271, 38.43595], [-122.93425, 38.43597], [-122.93426, 38.43681]]]} | Restricted Access 2 | 3289 | Harrison Grade Ecological Reserve | 19698 | 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 | 31.802 | Harrison Grade ER | 0 | State Conservation Area 8 | 2 | |
2782 | 2782 | 2781 | {"type": "Polygon", "coordinates": [[[-123.95018, 40.54432], [-123.95, 40.54774], [-123.95168, 40.56229], [-123.94988, 40.57504], [-123.93142, 40.57538], [-123.91977, 40.57531], [-123.91927, 40.56181], [-123.91363, 40.56177], [-123.91412, 40.55814], [-123.91933, 40.55809], [-123.91986, 40.5472], [-123.92568, 40.54733], [-123.92481, 40.53266], [-123.92997, 40.53268], [-123.94513, 40.53325], [-123.94448, 40.54416], [-123.95018, 40.54432]]]} | Restricted Access 2 | 21606 | Owl Creek Ecological Reserve | 23278 | 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 | 2772.208 | Owl Creek ER | 0 | State Conservation Area 8 | 2 | |
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 | |
2891 | 2891 | 2890 | {"type": "Polygon", "coordinates": [[[-122.27421, 40.4766], [-122.26995, 40.47661], [-122.27039, 40.47569], [-122.26864, 40.47525], [-122.26863, 40.47425], [-122.26907, 40.47419], [-122.26994, 40.47387], [-122.27012, 40.47395], [-122.27418, 40.4704], [-122.27421, 40.4766]]]} | Restricted Access 2 | 18920 | Clover Creek Ecological Reserve | 17434 | 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 | 46.643 | Clover Creek ER | 0 | State Conservation Area 8 | 2 | |
3115 | 3115 | 3114 | {"type": "Polygon", "coordinates": [[[-118.36149, 35.6525], [-118.36077, 35.67176], [-118.36099, 35.67202], [-118.36084, 35.67216], [-118.36083, 35.67225], [-118.36059, 35.67244], [-118.36048, 35.67244], [-118.36035, 35.67254], [-118.36025, 35.67254], [-118.36013, 35.67263], [-118.3599, 35.67264], [-118.35978, 35.67273], [-118.35943, 35.67273], [-118.35932, 35.67283], [-118.3592, 35.67283], [-118.35909, 35.67293], [-118.35897, 35.67293], [-118.35885, 35.67302], [-118.35862, 35.67302], [-118.3585, 35.67312], [-118.35838, 35.67312], [-118.35826, 35.67321], [-118.35814, 35.67321], [-118.35791, 35.67341], [-118.35779, 35.67341], [-118.35756, 35.6736], [-118.35744, 35.6736], [-118.35733, 35.67369], [-118.35698, 35.6737], [-118.35686, 35.67379], [-118.35651, 35.67379], [-118.35639, 35.6737], [-118.35616, 35.6737], [-118.35603, 35.6736], [-118.35581, 35.6736], [-118.35557, 35.67342], [-118.35545, 35.67342], [-118.35522, 35.67322], [-118.35511, 35.67322], [-118.35487, 35.67304], [-118.35475, 35.67304], [-118.35463, 35.67294], [-118.35441, 35.67294], [-118.35428, 35.67285], [-118.35394, 35.67285], [-118.35381, 35.67275], [-118.35359, 35.67275], [-118.35346, 35.67285], [-118.35264, 35.67285], [-118.35253, 35.67275], [-118.35147, 35.67276], [-118.35136, 35.67266], [-118.35101, 35.67267], [-118.35089, 35.67257], [-118.35031, 35.67257], [-118.35018, 35.67248], [-118.34856, 35.67248], [-118.34843, 35.67258], [-118.34762, 35.67258], [-118.34751, 35.67267], [-118.34703, 35.67267], [-118.34691, 35.67277], [-118.34668, 35.67277], [-118.34657, 35.67287], [-118.34621, 35.67287], [-118.3461, 35.67296], [-118.34564, 35.67297], [-118.34551, 35.67306], [-118.34516, 35.67307], [-118.34505, 35.67316], [-118.34494, 35.67316], [-118.34481, 35.67326], [-118.34399, 35.67326], [-118.34364, 35.67355], [-118.34352, 35.67354], [-118.34329, 35.67374], [-118.3426, 35.67374], [-118.34247, 35.67365], [-118.34224, 35.67365], [-118.34212, 35.67355], [-118.34201, 35.67355], [-118.34188, 35.67345], [-118.3413, 35.67346], [-118.34119, 35.67355], [-118.34048, 35.67356], [-118.34037, 35.67346], [-118.34014, 35.67346], [-118.3399, 35.67327], [-118.33966, 35.67327], [-118.33955, 35.67317], [-118.33932, 35.67317], [-118.33919, 35.67308], [-118.33874, 35.67308], [-118.33873, 35.67385], [-118.33861, 35.67394], [-118.33861, 35.6742], [-118.33451, 35.67409], [-118.33451, 35.67086], [-118.33432, 35.67112], [-118.33314, 35.67175], [-118.33047, 35.67254], [-118.32935, 35.67281], [-118.32925, 35.67273], [-118.32913, 35.67273], [-118.32879, 35.67245], [-118.32843, 35.67244], [-118.32838, 35.6724], [-118.33236, 35.67133], [-118.33412, 35.66986], [-118.33575, 35.66799], [-118.33753, 35.66683], [-118.33913, 35.6662], [-118.33909, 35.66591], [-118.33695, 35.66497], [-118.33666, 35.66368], [-118.33669, 35.66322], [-118.33589, 35.66322], [-118.33589, 35.66315], [-118.33635, 35.66277], [-118.33635, 35.66219], [-118.33624, 35.66209], [-118.33623, 35.6618], [-118.33635, 35.66171], [-118.33634, 35.66114], [-118.33623, 35.66105], [-118.33622, 35.66057], [-118.336, 35.66037], [-118.33471, 35.66038], [-118.33459, 35.66028], [-118.33482, 35.66008], [-118.33494, 35.66008], [-118.33506, 35.66], [-118.33517, 35.65999], [-118.33529, 35.6599], [-118.33553, 35.6599], [-118.33576, 35.65971], [-118.33588, 35.65971], [-118.33611, 35.65952], [-118.33623, 35.65951], [-118.3368, 35.65903], [-118.33716, 35.65903], [-118.33774, 35.65855], [-118.33786, 35.65855], [-118.3381, 35.65836], [-118.33821, 35.65836], [-118.33867, 35.65798], [-118.33879, 35.65798], [-118.33902, 35.65779], [-118.33903, 35.65663], [-118.33925, 35.65664], [-118.33949, 35.65645], [-118.33949, 35.65625], [-118.33936, 35.65616], [-118.33948, 35.65606], [-118.34276, 35.65605], [-118.34286, 35.65593], [-118.34288, 35.65558], [-118.34275, 35.65548], [-118.34276, 35.65491], [-118.34288, 35.65481], [-118.34333, 35.65481], [-118.34345, 35.65471], [-118.34345, 35.65433], [-118.34357, 35.65433], [-118.3436, 35.65579], [-118.34416, 35.65538], [-118.34622, 35.65508], [-118.34679, 35.65423], [-118.3472, 35.65436], [-118.34721, 35.65518], [-118.34731, 35.65527], [-118.34837, 35.65441], [-118.34883, 35.65441], [-118.34884, 35.6546], [-118.34907, 35.6546], [-118.34919, 35.6547], [-118.3493, 35.6547], [-118.34943, 35.65479], [-118.34966, 35.65479], [-118.34976, 35.65488], [-118.35012, 35.65489], [-118.35024, 35.65479], [-118.35048, 35.65478], [-118.35105, 35.65431], [-118.35117, 35.65431], [-118.35129, 35.65421], [-118.35141, 35.65421], [-118.35164, 35.65402], [-118.35164, 35.65382], [-118.35211, 35.65344], [-118.35222, 35.65344], [-118.35234, 35.65335], [-118.35234, 35.65268], [-118.35257, 35.65249], [-118.35315, 35.65248], [-118.35325, 35.65241], [-118.36149, 35.6525]], [[-118.33784, 35.66754], [-118.33642, 35.66856], [-118.33543, 35.66955], [-118.3349, 35.67031], [-118.33898, 35.67037], [-118.33903, 35.66701], [-118.33901, 35.66701], [-118.33784, 35.66754]]]} | Open Access 1 | 25332 | South Fork Wildlife Area | 30532 | 100 | United States Army Corps of Engineers 146 | Federal 1 | Federal Agency 1 | http://www.usace.army.mil/ | Other Federal 13 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Kern 36 | 1151.668 | South Fork Wildlife Area | 0 | State Conservation Area 8 | 2 | |
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 | |
3143 | 3143 | 3142 | {"type": "Polygon", "coordinates": [[[-123.31692, 41.78208], [-123.31238, 41.78212], [-123.31239, 41.78306], [-123.31239, 41.78456], [-123.31192, 41.78442], [-123.31147, 41.78461], [-123.31048, 41.78493], [-123.30981, 41.7853], [-123.30965, 41.78553], [-123.30965, 41.78579], [-123.30984, 41.78586], [-123.31041, 41.78733], [-123.31076, 41.7877], [-123.31092, 41.78773], [-123.31167, 41.78838], [-123.3121, 41.7889], [-123.31224, 41.78911], [-123.3121, 41.79128], [-123.30773, 41.79128], [-123.30674, 41.7913], [-123.30302, 41.79125], [-123.30307, 41.78826], [-123.30306, 41.78463], [-123.30294, 41.78141], [-123.30779, 41.78136], [-123.30782, 41.78299], [-123.31011, 41.78297], [-123.31011, 41.78135], [-123.31238, 41.78128], [-123.31236, 41.77967], [-123.31684, 41.77957], [-123.31692, 41.78208]]]} | Restricted Access 2 | 21593 | China Point Ecological Reserve | 17203 | 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 | 209.418 | China Point ER | 0 | State Conservation Area 8 | 2 | |
3144 | 3144 | 3143 | {"type": "Polygon", "coordinates": [[[-124.10173, 40.49177], [-124.09991, 40.49269], [-124.09979, 40.49248], [-124.1004, 40.49204], [-124.10081, 40.4918], [-124.1015, 40.49158], [-124.10173, 40.49177]]]} | Open Access 1 | 21596 | Eel River -- Rio Dell Fishing Access | 32156 | 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 | 1.525 | Eel River -- Rio Dell FA | 0 | State Recreation Area 39 | 4 | |
3145 | 3145 | 3144 | {"type": "MultiPolygon", "coordinates": [[[[-124.12175, 41.03989], [-124.12131, 41.03991], [-124.12121, 41.03987], [-124.12108, 41.03988], [-124.12093, 41.03992], [-124.12068, 41.04038], [-124.12061, 41.04044], [-124.12043, 41.04052], [-124.12027, 41.04068], [-124.12019, 41.04085], [-124.12012, 41.04095], [-124.12012, 41.04076], [-124.11999, 41.04031], [-124.11976, 41.04003], [-124.11934, 41.03975], [-124.11887, 41.03953], [-124.11879, 41.03945], [-124.11867, 41.03927], [-124.11859, 41.0391], [-124.11854, 41.03893], [-124.11849, 41.03884], [-124.11888, 41.03883], [-124.11962, 41.0388], [-124.12031, 41.03915], [-124.12093, 41.03936], [-124.1213, 41.03963], [-124.12175, 41.03989]]], [[[-124.12038, 41.04196], [-124.12008, 41.04195], [-124.1199, 41.04196], [-124.11979, 41.04199], [-124.11958, 41.04198], [-124.11972, 41.04168], [-124.11995, 41.04141], [-124.11995, 41.04147], [-124.12003, 41.04161], [-124.12008, 41.04164], [-124.12021, 41.04175], [-124.12038, 41.04196]]]]} | Open Access 1 | 21601 | Luffenholtz Creek Fishing Access | 32210 | 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 | 6.71 | Luffenholtz Creek FA | 0 | State Recreation Area 39 | 4 | |
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 | |
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 | |
3284 | 3284 | 3283 | {"type": "Polygon", "coordinates": [[[-114.722, 33.08954], [-114.70844, 33.08952], [-114.70802, 33.08874], [-114.70769, 33.08819], [-114.70696, 33.08728], [-114.70612, 33.08661], [-114.70461, 33.08633], [-114.7046, 33.08105], [-114.71315, 33.08099], [-114.71309, 33.075], [-114.72176, 33.07503], [-114.722, 33.08954]]]} | Open Access 1 | 23367 | Colorado River Access | 32132 | 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 | 488.822 | Colorado River Access | 0 | State Recreation Area 39 | 4 | |
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 | |
3286 | 3286 | 3285 | {"type": "Polygon", "coordinates": [[[-122.31276, 38.91619], [-122.30056, 38.91633], [-122.30018, 38.91044], [-122.30064, 38.91037], [-122.30093, 38.9103], [-122.30254, 38.90997], [-122.30296, 38.90992], [-122.30356, 38.90991], [-122.30391, 38.90996], [-122.30423, 38.91005], [-122.30598, 38.91071], [-122.30669, 38.91102], [-122.30716, 38.91107], [-122.30751, 38.91104], [-122.30761, 38.91103], [-122.30833, 38.91081], [-122.30868, 38.91064], [-122.30877, 38.91057], [-122.3089, 38.91042], [-122.30904, 38.9103], [-122.30907, 38.91024], [-122.30929, 38.90996], [-122.30929, 38.90988], [-122.3096, 38.90939], [-122.30981, 38.9092], [-122.31013, 38.90898], [-122.31036, 38.90884], [-122.31044, 38.90882], [-122.31061, 38.90873], [-122.31088, 38.90866], [-122.31144, 38.9086], [-122.312, 38.90866], [-122.31239, 38.90877], [-122.31264, 38.90888], [-122.31273, 38.90893], [-122.31276, 38.91619]]]} | Open Access 1 | 23563 | Cache Creek Public Access | 32077 | 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 | Yolo 33 | 184.731 | Cache Creek PA | 0 | State Recreation Area 39 | 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]);