units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
145 rows where DES_TP = 39 sorted by MNG_AG_ID
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_TYP, AGNCY_WEB, LAYER, MNG_AG_ID
MNG_AGENCY 8
- California Department of Parks and Recreation 75
- California Department of Fish and Wildlife 54
- Santa Monica Mountains Conservancy 10
- California Department of Water Resources 2
- University of California 1
- California Department of Veterans Affairs 1
- California State Coastal Conservancy 1
- Stewards of the Coast and Redwoods 1
ACCESS_TYP 3
MNG_AG_TYP 2
MNG_AG_LEV 2 ✖
- State 144
- Non Profit 1
DES_TP 1
- State Recreation Area · 145 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16080 | 16080 | 16079 | {"type": "MultiPolygon", "coordinates": [[[[-118.74218, 34.04546], [-118.74197, 34.04576], [-118.74191, 34.04574], [-118.74197, 34.04547], [-118.74218, 34.04546]]], [[[-118.74463, 34.04567], [-118.74456, 34.04578], [-118.74452, 34.04592], [-118.74452, 34.04607], [-118.74454, 34.04612], [-118.74453, 34.04621], [-118.74451, 34.04623], [-118.7442, 34.04609], [-118.74426, 34.04604], [-118.74431, 34.04596], [-118.74438, 34.04561], [-118.7444, 34.04558], [-118.74447, 34.04554], [-118.74456, 34.04555], [-118.7446, 34.04557], [-118.74463, 34.04561], [-118.74463, 34.04567]]], [[[-118.74446, 34.04548], [-118.74437, 34.04551], [-118.74431, 34.04557], [-118.74421, 34.04596], [-118.74415, 34.04602], [-118.744, 34.04611], [-118.74395, 34.04613], [-118.74382, 34.04613], [-118.74345, 34.04593], [-118.74332, 34.04589], [-118.7432, 34.04589], [-118.74306, 34.04594], [-118.74297, 34.046], [-118.7429, 34.0461], [-118.74286, 34.04628], [-118.74282, 34.04633], [-118.74271, 34.04643], [-118.7427, 34.04644], [-118.74262, 34.04637], [-118.74267, 34.04631], [-118.74269, 34.04624], [-118.74268, 34.04615], [-118.74263, 34.04607], [-118.74263, 34.04597], [-118.74314, 34.04563], [-118.74343, 34.04562], [-118.74352, 34.04555], [-118.74354, 34.04547], [-118.74446, 34.04548]]], [[[-118.74095, 34.04695], [-118.74058, 34.04695], [-118.7406, 34.04596], [-118.74094, 34.04595], [-118.74092, 34.04601], [-118.74087, 34.04606], [-118.7408, 34.04609], [-118.74073, 34.04616], [-118.7407, 34.04627], [-118.74072, 34.04634], [-118.74077, 34.0464], [-118.74093, 34.04649], [-118.74099, 34.04655], [-118.741, 34.04664], [-118.74095, 34.04695]]], [[[-118.74489, 34.04699], [-118.74421, 34.047], [-118.74418, 34.04693], [-118.74419, 34.04683], [-118.74424, 34.04677], [-118.74431, 34.04674], [-118.74452, 34.0467], [-118.74459, 34.04665], [-118.74464, 34.04659], [-118.74465, 34.04655], [-118.74464, 34.04615], [-118.74461, 34.04604], [-118.7446, 34.04592], [-118.74489, 34.04592], [-118.74489, 34.04699]]], [[[-118.74346, 34.0455], [-118.74339, 34.04555], [-118.74312, 34.04556], [-118.74261, 34.04588], [-118.74257, 34.04592], [-118.74254, 34.04599], [-118.74254, 34.04608], [-118.7426, 34.04618], [-118.74261, 34.04625], [-118.74259, 34.04629], [-118.7423, 34.04651], [-118.74226, 34.04658], [-118.74224, 34.04664], [-118.74196, 34.04662], [-118.74199, 34.04687], [-118.74227, 34.04678], [-118.74228, 34.04679], [-118.74268, 34.04737], [-118.74268, 34.0474], [-118.74264, 34.04745], [-118.7426, 34.04747], [-118.74241, 34.04748], [-118.74225, 34.04756], [-118.74218, 34.04762], [-118.74213, 34.04771], [-118.74211, 34.0478], [-118.74212, 34.04788], [-118.7417, 34.04787], [-118.74169, 34.04767], [-118.74183, 34.04726], [-118.74181, 34.04714], [-118.74169, 34.04699], [-118.74163, 34.04687], [-118.74163, 34.04678], [-118.74174, 34.04608], [-118.74176, 34.04603], [-118.7418, 34.04598], [-118.74191, 34.04594], [-118.74197, 34.04589], [-118.74206, 34.04576], [-118.74231, 34.04585], [-118.74259, 34.04547], [-118.74346, 34.04547], [-118.74346, 34.0455]]], [[[-118.74099, 34.0474], [-118.741, 34.04747], [-118.74087, 34.04795], [-118.74084, 34.04833], [-118.7406, 34.04833], [-118.74059, 34.04728], [-118.74092, 34.04728], [-118.74099, 34.0474]]], [[[-118.74165, 34.04709], [-118.74169, 34.04713], [-118.74173, 34.04724], [-118.7416, 34.04767], [-118.7416, 34.04789], [-118.74158, 34.04794], [-118.74126, 34.04789], [-118.74115, 34.04844], [-118.74095, 34.04847], [-118.74093, 34.04843], [-118.74093, 34.04837], [-118.74094, 34.04799], [-118.74108, 34.04745], [-118.74107, 34.04738], [-118.74099, 34.04728], [-118.74098, 34.04723], [-118.74109, 34.04662], [-118.74107, 34.04655], [-118.74103, 34.04648], [-118.74093, 34.0464], [-118.74085, 34.04638], [-118.74079, 34.0463], [-118.7408, 34.0462], [-118.74085, 34.04614], [-118.74093, 34.0461], [-118.74098, 34.04605], [-118.74124, 34.04611], [-118.74126, 34.04601], [-118.74165, 34.04606], [-118.74153, 34.04679], [-118.74155, 34.04693], [-118.74159, 34.04702], [-118.74165, 34.04709]]], [[[-118.7413, 34.0486], [-118.74115, 34.04892], [-118.74113, 34.04894], [-118.74108, 34.04894], [-118.74106, 34.04892], [-118.74106, 34.04889], [-118.74109, 34.04882], [-118.74109, 34.04872], [-118.74102, 34.0486], [-118.7413, 34.0486]]], [[[-118.74489, 34.04905], [-118.74445, 34.04905], [-118.74445, 34.04894], [-118.7444, 34.04878], [-118.74434, 34.04869], [-118.74427, 34.04861], [-118.74422, 34.04853], [-118.74421, 34.04845], [-118.74422, 34.04832], [-118.74427, 34.04818], [-118.74433, 34.04809], [-118.74436, 34.048], [-118.74436, 34.04789], [-118.74434, 34.04783], [-118.74435, 34.04777], [-118.74439, 34.04771], [-118.74451, 34.04763], [-118.74454, 34.04759], [-118.74456, 34.04752], [-118.74452, 34.0474], [-118.74446, 34.04735], [-118.74439, 34.04731], [-118.7443, 34.04717], [-118.74489, 34.04717], [-118.74489, 34.04905]]], [[[-118.74456, 34.04655], [-118.74451, 34.04662], [-118.74428, 34.04667], [-118.74419, 34.04672], [-118.7441, 34.04682], [-118.74409, 34.04692], [-118.74411, 34.04698], [-118.74427, 34.04729], [-118.74434, 34.04737], [-118.74443, 34.04743], [-118.74443, 34.04746], [-118.74424, 34.04755], [-118.74403, 34.04763], [-118.74397, 34.04767], [-118.74354, 34.04807], [-118.74347, 34.04815], [-118.7433, 34.0485], [-118.74327, 34.0486], [-118.74326, 34.04875], [-118.74332, 34.04905], [-118.74272, 34.04905], [-118.74274, 34.04896], [-118.74273, 34.04889], [-118.7427, 34.04883], [-118.74261, 34.04872], [-118.7426, 34.04861], [-118.74263, 34.04853], [-118.74278, 34.04841], [-118.74284, 34.04831], [-118.74287, 34.04821], [-118.74289, 34.04804], [-118.74292, 34.04795], [-118.74301, 34.04781], [-118.7431, 34.04772], [-118.74314, 34.0477], [-118.74343, 34.04786], [-118.74384, 34.04743], [-118.74384, 34.04733], [-118.74352, 34.04734], [-118.74349, 34.04663], [-118.74353, 34.04654], [-118.74362, 34.04646], [-118.74369, 34.04644], [-118.74383, 34.04643], [-118.74408, 34.04649], [-118.74418, 34.04649], [-118.74428, 34.04646], [-118.74451, 34.04633], [-118.74455, 34.04633], [-118.74456, 34.04655]]], [[[-118.74441, 34.04761], [-118.74432, 34.04768], [-118.74426, 34.04776], [-118.74425, 34.04782], [-118.74428, 34.04796], [-118.74426, 34.04805], [-118.74417, 34.04819], [-118.74412, 34.04838], [-118.74413, 34.0485], [-118.74415, 34.04858], [-118.7443, 34.04877], [-118.74435, 34.04888], [-118.74436, 34.04905], [-118.74341, 34.04905], [-118.74335, 34.04875], [-118.74335, 34.04866], [-118.74337, 34.04857], [-118.74344, 34.0484], [-118.74358, 34.04814], [-118.74402, 34.04772], [-118.74437, 34.04757], [-118.74441, 34.04758], [-118.74441, 34.04761]]], [[[-118.74405, 34.04641], [-118.74385, 34.04636], [-118.74369, 34.04636], [-118.74354, 34.04643], [-118.74347, 34.04649], [-118.74343, 34.04656], [-118.74341, 34.04665], [-118.74343, 34.04734], [-118.74342, 34.04741], [-118.74334, 34.04754], [-118.74326, 34.04759], [-118.74308, 34.04764], [-118.74295, 34.04774], [-118.74283, 34.04797], [-118.74277, 34.04828], [-118.74272, 34.04835], [-118.74259, 34.04846], [-118.74254, 34.04854], [-118.74251, 34.04862], [-118.74252, 34.04868], [-118.74254, 34.04876], [-118.74264, 34.04889], [-118.74265, 34.04896], [-118.74263, 34.04905], [-118.74151, 34.04905], [-118.74163, 34.049], [-118.74168, 34.04896], [-118.74173, 34.0489], [-118.74175, 34.04882], [-118.74174, 34.0487], [-118.74184, 34.04824], [-118.74191, 34.04817], [-118.74208, 34.04812], [-118.74218, 34.04804], [-118.74222, 34.04794], [-118.7422, 34.04776], [-118.74227, 34.04765], [-118.7424, 34.04756], [-118.74266, 34.04752], [-118.74277, 34.04745], [-118.7428, 34.0474], [-118.74282, 34.04734], [-118.74282, 34.04727], [-118.74266, 34.04683], [-118.74266, 34.04668], [-118.74272, 34.04653], [-118.74293, 34.04632], [-118.74297, 34.04621], [-118.74298, 34.04613], [-118.74304, 34.04605], [-118.74316, 34.04597], [-118.74334, 34.04596], [-118.74344, 34.046], [-118.74377, 34.04618], [-118.74387, 34.04621], [-118.74402, 34.04619], [-118.74405, 34.04641]]]]} | Open Access 1 | 7211 | El Nido Open Space Lots | 18520 | 200 | California State Coastal Conservancy 859 | State 5 | State Agency 5 | http://www.scc.ca.gov/ | Other State 5 | 200 | California State Coastal Conservancy 837 | State 5 | State Agency 5 | Los Angeles 6 | 27.385 | El Nido OS Lots | 0 | State Recreation Area 39 | 4 | |
391 | 391 | 390 | {"type": "Polygon", "coordinates": [[[-122.90647, 38.50264], [-122.90621, 38.50264], [-122.9057, 38.50237], [-122.90378, 38.50239], [-122.90186, 38.50146], [-122.89966, 38.50045], [-122.89918, 38.50012], [-122.89896, 38.49992], [-122.89874, 38.4996], [-122.89862, 38.49815], [-122.89817, 38.49687], [-122.89757, 38.49608], [-122.89836, 38.49578], [-122.8985, 38.4953], [-122.89887, 38.49556], [-122.90061, 38.49693], [-122.90352, 38.49951], [-122.90396, 38.49992], [-122.90513, 38.50094], [-122.90559, 38.50128], [-122.90647, 38.50264]], [[-122.90226, 38.49992], [-122.90214, 38.49984], [-122.90159, 38.50028], [-122.90262, 38.50107], [-122.90325, 38.50075], [-122.90325, 38.50074], [-122.90226, 38.49992]]]} | Open Access 1 | 1165 | Steelhead Beach Fishing Access | 32317 | 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 | 54.507 | Steelhead Beach FA | 0 | State Recreation Area 39 | 4 | |
689 | 689 | 688 | {"type": "Polygon", "coordinates": [[[-122.27644, 41.23646], [-122.27565, 41.23673], [-122.27558, 41.23593], [-122.27633, 41.2358], [-122.27644, 41.23646]]]} | Open Access 1 | 3506 | Sacramento River -- Prospect Ave. Fishing Access | 32282 | 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.339 | Sacramento River -- Prospect Ave. FA | 0 | State Recreation Area 39 | 4 | |
1224 | 1224 | 1223 | {"type": "Polygon", "coordinates": [[[-122.86042, 38.59925], [-122.86034, 38.59981], [-122.86039, 38.60018], [-122.86041, 38.60169], [-122.85992, 38.60156], [-122.85954, 38.60002], [-122.85952, 38.60002], [-122.85941, 38.60012], [-122.85928, 38.59999], [-122.85995, 38.5991], [-122.86042, 38.59925]]]} | Open Access 1 | 8807 | Healdsburg Fishing Access | 32183 | 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.182 | Healdsburg FA | 0 | State Recreation Area 39 | 4 | |
1642 | 1642 | 1641 | {"type": "MultiPolygon", "coordinates": [[[[-122.91501, 38.23223], [-122.91436, 38.23304], [-122.91323, 38.23292], [-122.91298, 38.23269], [-122.91332, 38.23235], [-122.91362, 38.23199], [-122.91396, 38.23141], [-122.91403, 38.23117], [-122.91417, 38.23093], [-122.91444, 38.23065], [-122.91472, 38.2304], [-122.91498, 38.23013], [-122.91479, 38.23083], [-122.91501, 38.23223]]], [[[-122.92228, 38.22119], [-122.92219, 38.22138], [-122.9222, 38.2214], [-122.92205, 38.22171], [-122.921, 38.22207], [-122.92063, 38.22229], [-122.91984, 38.22279], [-122.9192, 38.22313], [-122.91832, 38.22349], [-122.91766, 38.22384], [-122.9169, 38.22438], [-122.91676, 38.22491], [-122.91692, 38.22544], [-122.91697, 38.2261], [-122.91706, 38.22669], [-122.9171, 38.22705], [-122.91691, 38.22739], [-122.9167, 38.22796], [-122.91636, 38.22833], [-122.91608, 38.22869], [-122.9155, 38.22952], [-122.91512, 38.22995], [-122.91571, 38.22916], [-122.91592, 38.2289], [-122.91618, 38.22848], [-122.91635, 38.22809], [-122.91629, 38.22676], [-122.91608, 38.22537], [-122.91611, 38.22521], [-122.91622, 38.22491], [-122.91629, 38.22477], [-122.91649, 38.22449], [-122.91673, 38.22425], [-122.91702, 38.22406], [-122.91779, 38.22361], [-122.91846, 38.22313], [-122.91928, 38.22288], [-122.9198, 38.22249], [-122.92014, 38.22228], [-122.92196, 38.22151], [-122.92215, 38.22137], [-122.92228, 38.22119]]]]} | Open Access 1 | 1917 | Keys Creek Fishing Access | 32194 | 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 | 15.8 | Keys Creek FA | 0 | State Recreation Area 39 | 4 | |
1849 | 1849 | 1848 | {"type": "MultiPolygon", "coordinates": [[[[-122.94254, 40.6514], [-122.94075, 40.65216], [-122.94037, 40.65217], [-122.94034, 40.65114], [-122.94131, 40.65085], [-122.94254, 40.6514]]], [[[-122.94341, 40.6502], [-122.94276, 40.65044], [-122.94314, 40.65089], [-122.94277, 40.65114], [-122.94173, 40.6506], [-122.94119, 40.65048], [-122.94161, 40.6503], [-122.94222, 40.6503], [-122.94227, 40.64999], [-122.94239, 40.64988], [-122.94276, 40.64961], [-122.94341, 40.6502]]]]} | Open Access 1 | 14107 | Trinity River Fishing Access | 32329 | 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 | 7.06 | Trinity River FA | 0 | State Recreation Area 39 | 4 | |
2024 | 2024 | 2023 | {"type": "Polygon", "coordinates": [[[-122.37678, 38.2076], [-122.3765, 38.20788], [-122.37427, 38.20626], [-122.37478, 38.2058], [-122.37528, 38.20615], [-122.37569, 38.20667], [-122.37625, 38.20725], [-122.3765, 38.20744], [-122.37678, 38.2076]]]} | Open Access 1 | 17014 | Hudeman Slough Fishing Access | 32186 | 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 | 3.392 | Hudeman Slough FA | 1962 | State Recreation Area 39 | 4 | |
2169 | 2169 | 2168 | {"type": "Polygon", "coordinates": [[[-122.26026, 40.46551], [-122.25995, 40.4661], [-122.25878, 40.46717], [-122.25844, 40.46756], [-122.25829, 40.46797], [-122.25851, 40.46908], [-122.25823, 40.46964], [-122.25693, 40.46679], [-122.257, 40.46675], [-122.25734, 40.4669], [-122.25754, 40.46693], [-122.25755, 40.46692], [-122.25569, 40.46488], [-122.25569, 40.46461], [-122.25488, 40.464], [-122.25532, 40.46233], [-122.25635, 40.46254], [-122.25663, 40.46264], [-122.25701, 40.46333], [-122.25815, 40.46388], [-122.25913, 40.46406], [-122.25986, 40.46436], [-122.26021, 40.46499], [-122.26026, 40.46551]]]} | Open Access 1 | 17642 | Anderson Fishing Access | 32022 | 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 | 37.547 | Anderson FA | 0 | State Recreation Area 39 | 4 | |
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 | |
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 | |
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 | |
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 | |
3443 | 3443 | 3442 | {"type": "Polygon", "coordinates": [[[-122.27607, 38.12156], [-122.27576, 38.12178], [-122.2757, 38.12104], [-122.27592, 38.12097], [-122.27607, 38.12156]]]} | Open Access 1 | 25259 | Vallejo Fishing Pier | 32344 | 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 | 0.461 | Vallejo Fishing Pier | 0 | State Recreation Area 39 | 4 | |
3597 | 3597 | 3596 | {"type": "Polygon", "coordinates": [[[-120.42453, 41.423], [-120.42447, 41.42337], [-120.42407, 41.42367], [-120.42401, 41.42387], [-120.42359, 41.42413], [-120.42319, 41.42405], [-120.42179, 41.4233], [-120.42091, 41.423], [-120.42064, 41.42284], [-120.42067, 41.42262], [-120.42116, 41.42223], [-120.42189, 41.42202], [-120.42261, 41.422], [-120.4235, 41.42232], [-120.42413, 41.42232], [-120.42432, 41.42243], [-120.42453, 41.423]]]} | Open Access 1 | 29187 | Pine Creek Reservoir Public Access | 32264 | 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 | Modoc 56 | 11.894 | Pine Creek Reservoir PA | 0 | State Recreation Area 39 | 4 | |
3951 | 3951 | 3950 | {"type": "MultiPolygon", "coordinates": [[[[-122.92088, 40.65941], [-122.90654, 40.65933], [-122.90652, 40.65755], [-122.90653, 40.65578], [-122.90892, 40.6558], [-122.90893, 40.65758], [-122.91198, 40.65759], [-122.91302, 40.65654], [-122.9133, 40.65678], [-122.91445, 40.6576], [-122.92086, 40.65764], [-122.92088, 40.65941]]], [[[-122.93008, 40.65443], [-122.93007, 40.65583], [-122.92977, 40.65583], [-122.92978, 40.65452], [-122.93008, 40.65443]]]]} | Open Access 1 | 1124 | Indian Creek Public Access | 32188 | 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 | 72.715 | Indian Creek PA | 0 | State Recreation Area 39 | 4 | |
4066 | 4066 | 4065 | {"type": "Polygon", "coordinates": [[[-119.73129, 36.97793], [-119.7303, 36.97877], [-119.72525, 36.98164], [-119.72042, 36.98537], [-119.72043, 36.98505], [-119.72124, 36.98436], [-119.72154, 36.98342], [-119.72122, 36.98287], [-119.72074, 36.98281], [-119.72075, 36.98168], [-119.72235, 36.9798], [-119.72305, 36.97932], [-119.72304, 36.97794], [-119.73031, 36.97791], [-119.73129, 36.97793]]]} | Open Access 1 | 44427 | Lost Lake Fishing Access | 32207 | 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 | 73.033 | Lost Lake FA | 0 | State Recreation Area 39 | 4 | |
4070 | 4070 | 4069 | {"type": "Polygon", "coordinates": [[[-122.26206, 37.57356], [-122.25329, 37.58145], [-122.25329, 37.58145], [-122.25315, 37.58126], [-122.26174, 37.57345], [-122.26206, 37.57356]]]} | Restricted Access 2 | 44448 | San Mateo Fishing Pier | 24951 | 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 Mateo 15 | 7.589 | San Mateo Fishing Pier | 0 | State Recreation Area 39 | 4 | |
4862 | 4862 | 4861 | {"type": "Polygon", "coordinates": [[[-121.66948, 38.16979], [-121.66941, 38.16983], [-121.66936, 38.16994], [-121.66935, 38.17035], [-121.66932, 38.17042], [-121.66873, 38.17075], [-121.66858, 38.17088], [-121.66823, 38.17112], [-121.66788, 38.17132], [-121.66746, 38.17165], [-121.66698, 38.17205], [-121.66674, 38.17196], [-121.66754, 38.1713], [-121.66837, 38.17043], [-121.66914, 38.16955], [-121.66948, 38.16979]]]} | Open Access 1 | 22113 | Cliff House Fishing Access | 32119 | 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 | 3.203 | Cliff House 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]);