units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
54 rows where DES_TP = 39 and MNG_AGENCY = 25
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- State Agency 34
MNG_AGENCY 1
- California Department of Fish and Wildlife · 34 ✖
DES_TP 1
- State Recreation Area · 34 ✖
AGNCY_TYP 1 ✖
- State Agency 34
ACCESS_TYP 1
- Open Access 34
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4993 | 4993 | 4992 | {"type": "Polygon", "coordinates": [[[-122.81055, 38.06495], [-122.8078, 38.06673], [-122.80522, 38.06556], [-122.80528, 38.06519], [-122.80528, 38.06493], [-122.80569, 38.06503], [-122.8064, 38.06528], [-122.80677, 38.06539], [-122.80723, 38.06548], [-122.80745, 38.06551], [-122.80796, 38.06549], [-122.80838, 38.06544], [-122.80872, 38.06538], [-122.80973, 38.0651], [-122.80996, 38.06507], [-122.81035, 38.06463], [-122.81043, 38.06451], [-122.81053, 38.06442], [-122.81055, 38.06495]]]} | Open Access 1 | 2042 | Point Reyes Station Public Access | 32268 | 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 | 9.7 | Point Reyes Station PA | 0 | State Recreation Area 39 | 4 | |
7436 | 7436 | 7435 | {"type": "Polygon", "coordinates": [[[-120.55936, 36.14655], [-120.55484, 36.14658], [-120.55048, 36.14653], [-120.54144, 36.14651], [-120.54142, 36.13932], [-120.55041, 36.13938], [-120.55925, 36.13938], [-120.55932, 36.14295], [-120.55936, 36.14655]]]} | Open Access 1 | 6994 | Coalinga Mineral Springs Public Access | 32124 | 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 | 316.828 | Coalinga Mineral Springs PA | 0 | State Recreation Area 39 | 4 | |
7536 | 7536 | 7535 | {"type": "MultiPolygon", "coordinates": [[[[-120.4594, 36.09525], [-120.45884, 36.09971], [-120.45356, 36.09967], [-120.454, 36.096], [-120.45465, 36.09599], [-120.45495, 36.09613], [-120.45535, 36.09628], [-120.4556, 36.09628], [-120.45586, 36.09634], [-120.45597, 36.09635], [-120.45623, 36.09634], [-120.45653, 36.09626], [-120.45684, 36.09612], [-120.45705, 36.096], [-120.45847, 36.09601], [-120.45855, 36.09539], [-120.4594, 36.09525]]], [[[-120.4602, 36.08884], [-120.45943, 36.09501], [-120.45866, 36.09511], [-120.45891, 36.09249], [-120.45453, 36.09211], [-120.45494, 36.08881], [-120.4602, 36.08884]]]]} | Open Access 1 | 7116 | Curry Mountain Public Access | 32142 | 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 | 98.979 | Curry Mtn. PA | 0 | State Recreation Area 39 | 4 | |
7538 | 7538 | 7537 | {"type": "Polygon", "coordinates": [[[-122.08865, 38.51565], [-122.08828, 38.51537], [-122.08787, 38.51513], [-122.08731, 38.51485], [-122.08639, 38.51468], [-122.08545, 38.51472], [-122.08468, 38.51491], [-122.08366, 38.51511], [-122.08246, 38.51529], [-122.08122, 38.51536], [-122.08014, 38.51521], [-122.07911, 38.51481], [-122.07845, 38.51475], [-122.07756, 38.51483], [-122.07722, 38.51473], [-122.07426, 38.51407], [-122.07323, 38.51437], [-122.07181, 38.51439], [-122.06966, 38.51436], [-122.0672, 38.51488], [-122.06675, 38.51502], [-122.06635, 38.51528], [-122.06574, 38.51557], [-122.06368, 38.51588], [-122.06207, 38.51641], [-122.06045, 38.51657], [-122.06011, 38.51666], [-122.05988, 38.51685], [-122.05962, 38.51711], [-122.05914, 38.51743], [-122.05697, 38.51763], [-122.05672, 38.51756], [-122.05628, 38.5175], [-122.05406, 38.51533], [-122.05188, 38.51338], [-122.05002, 38.51217], [-122.04939, 38.51199], [-122.0492, 38.51183], [-122.04854, 38.51109], [-122.04818, 38.51092], [-122.04799, 38.51086], [-122.04748, 38.51087], [-122.04484, 38.51008], [-122.04387, 38.50907], [-122.04332, 38.50861], [-122.04174, 38.50701], [-122.04165, 38.50677], [-122.04148, 38.50657], [-122.04138, 38.50596], [-122.04059, 38.50374], [-122.03966, 38.50201], [-122.03941, 38.50145], [-122.03914, 38.50112], [-122.03862, 38.50059], [-122.038, 38.4999], [-122.03736, 38.49902], [-122.0372, 38.49888], [-122.03674, 38.49872], [-122.0345, 38.49748], [-122.03323, 38.49636], [-122.03412, 38.4963], [-122.03469, 38.4967], [-122.03484, 38.49684], [-122.03564, 38.49724], [-122.03682, 38.49806], [-122.03721, 38.49835], [-122.03765, 38.49877], [-122.03858, 38.49992], [-122.03934, 38.5008], [-122.03961, 38.50119], [-122.04001, 38.50168], [-122.04071, 38.50304], [-122.04125, 38.50387], [-122.04113, 38.50428], [-122.04116, 38.50462], [-122.04145, 38.5054], [-122.04168, 38.50567], [-122.0427, 38.50633], [-122.04386, 38.50702], [-122.04445, 38.50754], [-122.04489, 38.50776], [-122.04518, 38.50787], [-122.04576, 38.50819], [-122.0463, 38.50857], [-122.04658, 38.50898], [-122.04717, 38.50945], [-122.04783, 38.5099], [-122.04825, 38.51013], [-122.05045, 38.51194], [-122.05078, 38.51195], [-122.051, 38.51199], [-122.05168, 38.51219], [-122.05677, 38.51707], [-122.05717, 38.51732], [-122.05761, 38.5174], [-122.05855, 38.51711], [-122.05886, 38.51688], [-122.05927, 38.51625], [-122.05962, 38.51612], [-122.06126, 38.51564], [-122.06235, 38.51545], [-122.0632, 38.51536], [-122.06399, 38.51531], [-122.06553, 38.51507], [-122.06638, 38.51488], [-122.06717, 38.51433], [-122.06761, 38.51419], [-122.06839, 38.51411], [-122.06913, 38.5141], [-122.07022, 38.51416], [-122.07058, 38.51402], [-122.071, 38.51375], [-122.07139, 38.51371], [-122.07204, 38.51371], [-122.07297, 38.51355], [-122.07377, 38.51359], [-122.07552, 38.51378], [-122.07595, 38.5137], [-122.07655, 38.51386], [-122.07713, 38.51407], [-122.07759, 38.51414], [-122.0801, 38.51391], [-122.08034, 38.51405], [-122.08068, 38.51438], [-122.08107, 38.51462], [-122.08209, 38.51488], [-122.08322, 38.51468], [-122.08433, 38.51453], [-122.08659, 38.51432], [-122.0882, 38.51445], [-122.08854, 38.51429], [-122.08865, 38.51565]]]} | Open Access 1 | 9337 | Putah Creek Fishing Access | 32271 | 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 | Solano 26 | 105.709 | Putah Creek FA | 0 | State Recreation Area 39 | 4 | |
7735 | 7735 | 7734 | {"type": "MultiPolygon", "coordinates": [[[[-122.27978, 41.22446], [-122.27892, 41.22432], [-122.27873, 41.22182], [-122.27658, 41.22161], [-122.27713, 41.22081], [-122.27893, 41.2215], [-122.27937, 41.22356], [-122.27978, 41.22446]]], [[[-122.27907, 41.22677], [-122.27849, 41.22742], [-122.27821, 41.22736], [-122.27736, 41.22728], [-122.27787, 41.22665], [-122.27796, 41.22598], [-122.2788, 41.22607], [-122.27855, 41.22649], [-122.27907, 41.22677]]], [[[-122.27977, 41.22692], [-122.27972, 41.22742], [-122.27913, 41.22737], [-122.27977, 41.22692], [-122.27977, 41.22692]]]]} | Open Access 1 | 8158 | Tauhindauli Public Access | 32325 | 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 | 9.322 | Tauhindauli PA | 0 | State Recreation Area 39 | 4 | |
7996 | 7996 | 7995 | {"type": "MultiPolygon", "coordinates": [[[[-120.84563, 37.61895], [-120.84545, 37.61903], [-120.84473, 37.62007], [-120.84403, 37.62084], [-120.84261, 37.62181], [-120.84163, 37.62226], [-120.84153, 37.62225], [-120.84196, 37.62189], [-120.84148, 37.62063], [-120.84163, 37.61955], [-120.84195, 37.61932], [-120.84163, 37.61895], [-120.8422, 37.61857], [-120.84301, 37.61756], [-120.84275, 37.61605], [-120.84369, 37.61618], [-120.84406, 37.61629], [-120.84379, 37.61775], [-120.8443, 37.61762], [-120.84492, 37.61786], [-120.84529, 37.61767], [-120.84563, 37.61895]]], [[[-120.85093, 37.61827], [-120.84939, 37.61906], [-120.84879, 37.61899], [-120.84793, 37.6187], [-120.84729, 37.61865], [-120.84609, 37.61872], [-120.84574, 37.61743], [-120.84684, 37.61692], [-120.84745, 37.61661], [-120.84873, 37.61675], [-120.84972, 37.6172], [-120.85027, 37.61796], [-120.85068, 37.6181], [-120.85055, 37.61819], [-120.85055, 37.61821], [-120.85093, 37.61827]]]]} | Open Access 1 | 468 | Fox Grove Fishing Access | 32167 | 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 | Stanislaus 2 | 51.641 | Fox Grove FA | 0 | State Recreation Area 39 | 4 | |
8024 | 8024 | 8023 | {"type": "Polygon", "coordinates": [[[-122.54551, 41.88727], [-122.5444, 41.88768], [-122.5435, 41.8885], [-122.54277, 41.88937], [-122.54183, 41.88996], [-122.53879, 41.8915], [-122.53586, 41.89274], [-122.53586, 41.89232], [-122.53761, 41.89143], [-122.53801, 41.89105], [-122.53835, 41.89082], [-122.53863, 41.89065], [-122.53877, 41.89048], [-122.53898, 41.89012], [-122.53919, 41.88994], [-122.53929, 41.88973], [-122.53954, 41.88847], [-122.53961, 41.88826], [-122.54052, 41.887], [-122.54549, 41.88699], [-122.54551, 41.88727]]]} | Open Access 1 | 1289 | Klamath River Fishing Access | 32196 | 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 | 36.2 | Klamath River FA | 0 | State Recreation Area 39 | 4 | |
8159 | 8159 | 8158 | {"type": "MultiPolygon", "coordinates": [[[[-122.81064, 40.70578], [-122.81004, 40.70593], [-122.809, 40.70694], [-122.80872, 40.70817], [-122.80814, 40.70853], [-122.80771, 40.70934], [-122.80728, 40.70938], [-122.80691, 40.71639], [-122.80598, 40.71639], [-122.8058, 40.70942], [-122.80587, 40.70899], [-122.80626, 40.70834], [-122.80668, 40.70798], [-122.80707, 40.70772], [-122.8073, 40.70713], [-122.80705, 40.70654], [-122.80737, 40.70648], [-122.8081, 40.70615], [-122.80847, 40.70555], [-122.80891, 40.7056], [-122.81035, 40.70528], [-122.81064, 40.70578]]], [[[-122.81796, 40.71102], [-122.81795, 40.71281], [-122.81715, 40.71313], [-122.81637, 40.71249], [-122.8155, 40.71249], [-122.81448, 40.71101], [-122.81796, 40.71102]]]]} | Open Access 1 | 1520 | Lewiston Fishing Access | 32202 | 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 | Trinity 46 | 48.998 | Lewiston FA | 0 | State Recreation Area 39 | 4 | |
8374 | 8374 | 8373 | {"type": "Polygon", "coordinates": [[[-121.08882, 40.26942], [-121.08854, 40.26983], [-121.08846, 40.27002], [-121.08842, 40.27082], [-121.08795, 40.27058], [-121.08782, 40.27074], [-121.08679, 40.27021], [-121.08692, 40.26987], [-121.08882, 40.26942]]]} | Open Access 1 | 7222 | Hamilton Branch Fishing Access | 32181 | 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 | Plumas 57 | 3.469 | Hamilton Branch FA | 0 | State Recreation Area 39 | 4 | |
8488 | 8488 | 8487 | {"type": "MultiPolygon", "coordinates": [[[[-120.43877, 39.82145], [-120.43839, 39.82166], [-120.43819, 39.82171], [-120.43785, 39.82188], [-120.43755, 39.82196], [-120.43723, 39.822], [-120.43693, 39.82199], [-120.43662, 39.82194], [-120.43634, 39.82185], [-120.4361, 39.8218], [-120.43575, 39.82164], [-120.43576, 39.82128], [-120.43628, 39.82143], [-120.43663, 39.82149], [-120.43688, 39.82151], [-120.43739, 39.8215], [-120.43786, 39.82143], [-120.43877, 39.82145]]], [[[-120.6211, 39.77924], [-120.6211, 39.77924], [-120.61819, 39.77703], [-120.61893, 39.77692], [-120.61945, 39.77704], [-120.61963, 39.77712], [-120.62009, 39.77762], [-120.62049, 39.77786], [-120.62088, 39.77803], [-120.6211, 39.77924]]], [[[-120.62349, 39.7793], [-120.62163, 39.77937], [-120.62146, 39.77817], [-120.6221, 39.77824], [-120.62266, 39.77847], [-120.62302, 39.7787], [-120.62315, 39.77902], [-120.62349, 39.7793]]]]} | Open Access 1 | 7475 | Middle Fork Feather River Fishing Access | 32218 | 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 | Plumas 57 | 11.416 | Middle Fork Feather River FA | 0 | State Recreation Area 39 | 4 | |
8586 | 8586 | 8585 | {"type": "MultiPolygon", "coordinates": [[[[-123.79827, 39.42684], [-123.79795, 39.427], [-123.79736, 39.42734], [-123.79715, 39.42712], [-123.79702, 39.42701], [-123.79711, 39.42678], [-123.79719, 39.42651], [-123.7975, 39.4264], [-123.79826, 39.42676], [-123.79827, 39.42684]]], [[[-123.79844, 39.4263], [-123.7984, 39.42647], [-123.79767, 39.42638], [-123.79763, 39.42621], [-123.79802, 39.4263], [-123.79844, 39.4263]]]]} | Open Access 1 | 21604 | Noyo River Fishing Access | 32248 | 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 | 1.819 | Noyo River FA | 0 | State Recreation Area 39 | 4 | |
8836 | 8836 | 8835 | {"type": "Polygon", "coordinates": [[[-123.77317, 39.57239], [-123.77216, 39.57277], [-123.77198, 39.5719], [-123.77185, 39.57109], [-123.7719, 39.57063], [-123.77189, 39.57026], [-123.77167, 39.5697], [-123.77215, 39.56967], [-123.77221, 39.56979], [-123.77219, 39.56983], [-123.77223, 39.5699], [-123.77235, 39.57009], [-123.77244, 39.57018], [-123.77251, 39.5702], [-123.77259, 39.57034], [-123.77254, 39.57053], [-123.77255, 39.57063], [-123.77278, 39.57097], [-123.77279, 39.57107], [-123.77264, 39.57129], [-123.77262, 39.57138], [-123.77274, 39.57157], [-123.77274, 39.57166], [-123.77278, 39.57181], [-123.7729, 39.57212], [-123.77288, 39.57219], [-123.77283, 39.57227], [-123.7729, 39.57232], [-123.77295, 39.57226], [-123.77304, 39.57228], [-123.77317, 39.57239]]]} | Open Access 1 | 21614 | South Kibesillah Gulch Fishing Access | 32315 | 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 | 5.236 | South Kibesillah Gulch FA | 0 | State Recreation Area 39 | 4 | |
9810 | 9810 | 9809 | {"type": "Polygon", "coordinates": [[[-122.91431, 39.14814], [-122.91237, 39.1479], [-122.91249, 39.14739], [-122.91343, 39.14744], [-122.91384, 39.14771], [-122.91431, 39.14814]]]} | Open Access 1 | 18106 | Bridge Arbor Fishing Access | 32067 | 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 | 1.998 | Bridge Arbor FA | 0 | State Recreation Area 39 | 4 | |
9817 | 9817 | 9816 | {"type": "Polygon", "coordinates": [[[-122.27189, 37.08629], [-122.27082, 37.08655], [-122.26904, 37.08506], [-122.2671, 37.08305], [-122.2636, 37.07903], [-122.2613, 37.07462], [-122.25781, 37.0704], [-122.2592, 37.0701], [-122.25927, 37.07039], [-122.25953, 37.07063], [-122.25925, 37.07061], [-122.25921, 37.07079], [-122.25898, 37.07083], [-122.25897, 37.07084], [-122.25928, 37.07133], [-122.25954, 37.07104], [-122.25993, 37.07115], [-122.25989, 37.07215], [-122.26018, 37.07244], [-122.2602, 37.07267], [-122.26029, 37.07277], [-122.26057, 37.07276], [-122.26087, 37.07295], [-122.26099, 37.07276], [-122.26135, 37.07274], [-122.26128, 37.07243], [-122.26164, 37.07233], [-122.26169, 37.07276], [-122.26166, 37.07326], [-122.262, 37.07327], [-122.26193, 37.0733], [-122.2623, 37.07348], [-122.26261, 37.07354], [-122.26268, 37.07375], [-122.26226, 37.07488], [-122.26225, 37.075], [-122.26231, 37.07498], [-122.26231, 37.075], [-122.26265, 37.07494], [-122.26263, 37.07499], [-122.26334, 37.07595], [-122.26366, 37.07647], [-122.26405, 37.0774], [-122.2655, 37.07818], [-122.26634, 37.07843], [-122.26636, 37.07848], [-122.26655, 37.07849], [-122.26726, 37.07833], [-122.26739, 37.07814], [-122.26752, 37.07747], [-122.26771, 37.07736], [-122.26794, 37.07741], [-122.26791, 37.07792], [-122.26778, 37.07828], [-122.26697, 37.07885], [-122.26698, 37.07897], [-122.26728, 37.07915], [-122.26764, 37.08005], [-122.26758, 37.08033], [-122.26758, 37.08056], [-122.26829, 37.0822], [-122.26862, 37.08277], [-122.26868, 37.0833], [-122.26903, 37.08387], [-122.26968, 37.08488], [-122.27002, 37.08526], [-122.27084, 37.08552], [-122.27146, 37.0858], [-122.27189, 37.08629]]]} | Open Access 1 | 25173 | Greyhound Rock Fishing Access | 32179 | 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 | 68.635 | Greyhound Rock FA | 0 | State Recreation Area 39 | 4 | |
9851 | 9851 | 9850 | {"type": "Polygon", "coordinates": [[[-121.5838, 39.01078], [-121.58379, 39.01281], [-121.58253, 39.01194], [-121.58123, 39.01112], [-121.58087, 39.01091], [-121.58155, 39.01022], [-121.58225, 39.00929], [-121.58311, 39.00948], [-121.58378, 39.00959], [-121.5838, 39.01078]]]} | Open Access 1 | 25239 | Starbend Fishing Access | 32316 | 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 | 14.23 | Starbend FA | 0 | State Recreation Area 39 | 4 | |
10251 | 10251 | 10250 | {"type": "Polygon", "coordinates": [[[-122.3605, 40.5364], [-122.35803, 40.5383], [-122.3578, 40.53844], [-122.35758, 40.53825], [-122.35701, 40.53737], [-122.36041, 40.53623], [-122.3605, 40.5364]]]} | Open Access 1 | 17970 | Bonnyview Road Fishing Access | 32064 | 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 | 6.224 | Bonnyview Road FA | 0 | State Recreation Area 39 | 4 | |
10460 | 10460 | 10459 | {"type": "Polygon", "coordinates": [[[-124.22225, 41.75719], [-124.22204, 41.75755], [-124.22201, 41.75773], [-124.22201, 41.75785], [-124.22163, 41.75787], [-124.22146, 41.75692], [-124.22056, 41.75608], [-124.22011, 41.75579], [-124.21926, 41.7554], [-124.21843, 41.75545], [-124.21839, 41.75512], [-124.21862, 41.75515], [-124.21885, 41.75521], [-124.21942, 41.7553], [-124.22025, 41.75554], [-124.2206, 41.75555], [-124.22087, 41.75559], [-124.22099, 41.75574], [-124.22099, 41.75602], [-124.22107, 41.75621], [-124.22122, 41.75631], [-124.22168, 41.7564], [-124.22197, 41.75639], [-124.22209, 41.75641], [-124.2221, 41.75643], [-124.22206, 41.7566], [-124.22197, 41.7567], [-124.22199, 41.75676], [-124.22199, 41.75682], [-124.22201, 41.75687], [-124.22213, 41.75699], [-124.22225, 41.75719]]]} | Open Access 1 | 21607 | Pebble Beach Fishing Access | 32257 | 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 | 4.3 | Pebble Beach FA | 0 | State Recreation Area 39 | 4 | |
10468 | 10468 | 10467 | {"type": "Polygon", "coordinates": [[[-124.14878, 41.8907], [-124.14743, 41.89072], [-124.14735, 41.89019], [-124.14668, 41.89019], [-124.14664, 41.88979], [-124.14778, 41.88975], [-124.14829, 41.89017], [-124.14878, 41.8907]]]} | Open Access 1 | 21613 | Smith River Fishing Access | 32311 | 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 | 2.706 | Smith River FA | 0 | State Recreation Area 39 | 4 | |
11239 | 11239 | 11238 | {"type": "Polygon", "coordinates": [[[-120.22739, 39.32315], [-120.22725, 39.32342], [-120.22684, 39.32341], [-120.22659, 39.32344], [-120.22637, 39.32349], [-120.22597, 39.32363], [-120.22562, 39.32382], [-120.22154, 39.32332], [-120.2212, 39.32323], [-120.21896, 39.32296], [-120.21834, 39.323], [-120.21841, 39.32218], [-120.2203, 39.32236], [-120.22218, 39.3226], [-120.22366, 39.32287], [-120.22397, 39.32289], [-120.22465, 39.3229], [-120.22461, 39.32306], [-120.22416, 39.32346], [-120.22528, 39.3236], [-120.22543, 39.32361], [-120.22561, 39.32358], [-120.22616, 39.32339], [-120.22657, 39.32331], [-120.22655, 39.32317], [-120.22696, 39.32313], [-120.22739, 39.32315]]]} | Open Access 1 | 21595 | Donner Creek Public Access | 32150 | 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 | 12.262 | Donner Creek PA | 0 | State Recreation Area 39 | 4 | |
11264 | 11264 | 11263 | {"type": "Polygon", "coordinates": [[[-121.52329, 38.38223], [-121.51986, 38.38421], [-121.51959, 38.38389], [-121.52311, 38.38198], [-121.52329, 38.38223]]]} | Open Access 1 | 25906 | Clarksburg Fishing Access | 32116 | 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 | 3.405 | Clarksburg FA | 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]);