units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
145 rows where DES_TP = 39 sorted by map descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, MNG_AG_ID, MNG_AG_LEV
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
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11542 | 11542 | 11541 | {"type": "Polygon", "coordinates": [[[-124.25267, 41.78246], [-124.25248, 41.78431], [-124.25191, 41.78429], [-124.25189, 41.78253], [-124.25267, 41.78246]]]} | Open Access 1 | 29640 | North Beach Fishing Access | 32245 | 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.776 | North Beach 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 | |
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 | |
16660 | 16660 | 16659 | {"type": "Polygon", "coordinates": [[[-123.82852, 40.06923], [-123.8284, 40.06931], [-123.82833, 40.06939], [-123.82828, 40.06949], [-123.82826, 40.06959], [-123.82827, 40.07021], [-123.82842, 40.07231], [-123.82843, 40.07264], [-123.8284, 40.07297], [-123.82833, 40.0733], [-123.82808, 40.07413], [-123.82689, 40.07376], [-123.82684, 40.0739], [-123.82676, 40.07407], [-123.82658, 40.07434], [-123.8256, 40.07545], [-123.82526, 40.07581], [-123.82483, 40.07622], [-123.82452, 40.07647], [-123.82412, 40.07673], [-123.82374, 40.06606], [-123.80985, 40.06641], [-123.80979, 40.06534], [-123.80793, 40.06484], [-123.80484, 40.06488], [-123.80483, 40.06482], [-123.80471, 40.06483], [-123.8042, 40.0651], [-123.80364, 40.06525], [-123.80347, 40.06558], [-123.80301, 40.06575], [-123.80266, 40.06613], [-123.80256, 40.06617], [-123.80256, 40.06644], [-123.80024, 40.06774], [-123.80024, 40.0678], [-123.80016, 40.06779], [-123.79981, 40.06784], [-123.7995, 40.06776], [-123.79917, 40.06752], [-123.79772, 40.06758], [-123.79738, 40.06753], [-123.79627, 40.06769], [-123.79588, 40.0676], [-123.79569, 40.06768], [-123.79552, 40.06801], [-123.79547, 40.06804], [-123.79534, 40.0674], [-123.7951, 40.06749], [-123.79484, 40.06755], [-123.79474, 40.06762], [-123.7947, 40.0676], [-123.79468, 40.06756], [-123.79457, 40.06756], [-123.79453, 40.06765], [-123.79448, 40.06771], [-123.79439, 40.06774], [-123.79427, 40.06772], [-123.79413, 40.06777], [-123.79392, 40.06782], [-123.79367, 40.06795], [-123.79372, 40.06816], [-123.79287, 40.06815], [-123.7926, 40.06816], [-123.79233, 40.06823], [-123.79191, 40.06816], [-123.79158, 40.06816], [-123.79115, 40.06823], [-123.79111, 40.06822], [-123.79117, 40.06798], [-123.79118, 40.06779], [-123.79115, 40.0676], [-123.79108, 40.06741], [-123.79098, 40.06723], [-123.79085, 40.06707], [-123.7907, 40.06692], [-123.79042, 40.06673], [-123.7903, 40.06668], [-123.79021, 40.06679], [-123.78984, 40.06661], [-123.78964, 40.06684], [-123.78808, 40.06607], [-123.78779, 40.06582], [-123.7876, 40.0656], [-123.78713, 40.06543], [-123.78523, 40.0648], [-123.78464, 40.06456], [-123.78358, 40.06403], [-123.78338, 40.06392], [-123.7832, 40.06379], [-123.78213, 40.06291], [-123.78185, 40.06274], [-123.78164, 40.06264], [-123.78142, 40.06256], [-123.78119, 40.0625], [-123.78087, 40.06245], [-123.78032, 40.06239], [-123.77935, 40.06218], [-123.77916, 40.06213], [-123.77899, 40.06205], [-123.77875, 40.06191], [-123.77863, 40.06179], [-123.77854, 40.06167], [-123.77837, 40.06134], [-123.77835, 40.06121], [-123.77835, 40.06109], [-123.77838, 40.06096], [-123.77863, 40.06044], [-123.7787, 40.06024], [-123.77874, 40.06006], [-123.77886, 40.05898], [-123.77926, 40.05863], [-123.7813, 40.05827], [-123.78128, 40.05728], [-123.7815, 40.05719], [-123.78192, 40.05699], [-123.78352, 40.05645], [-123.78374, 40.0564], [-123.78396, 40.05637], [-123.78418, 40.05636], [-123.7847, 40.05642], [-123.78558, 40.05629], [-123.78578, 40.05624], [-123.78663, 40.05596], [-123.78729, 40.05583], [-123.78786, 40.05578], [-123.78825, 40.05577], [-123.78947, 40.05585], [-123.79003, 40.05584], [-123.79041, 40.0558], [-123.7918, 40.05562], [-123.79169, 40.05432], [-123.79151, 40.05406], [-123.79142, 40.05389], [-123.79137, 40.05372], [-123.79135, 40.05354], [-123.79137, 40.05336], [-123.79164, 40.05219], [-123.79172, 40.0517], [-123.79141, 40.05007], [-123.79106, 40.04968], [-123.79508, 40.05025], [-123.80534, 40.05096], [-123.80536, 40.05429], [-123.81047, 40.05452], [-123.81046, 40.06236], [-123.81511, 40.06221], [-123.82203, 40.06227], [-123.82216, 40.06203], [-123.82224, 40.06162], [-123.82227, 40.06152], [-123.82239, 40.06132], [-123.82246, 40.06124], [-123.82272, 40.06102], [-123.82291, 40.06089], [-123.82318, 40.06078], [-123.82344, 40.06072], [-123.82362, 40.06223], [-123.8255, 40.06223], [-123.82538, 40.06249], [-123.82526, 40.06297], [-123.82519, 40.06337], [-123.82524, 40.06358], [-123.82541, 40.06413], [-123.82557, 40.06458], [-123.8257, 40.06488], [-123.82606, 40.06571], [-123.82615, 40.06587], [-123.82649, 40.06624], [-123.8272, 40.0669], [-123.82734, 40.06707], [-123.82746, 40.06728], [-123.8276, 40.06762], [-123.82788, 40.06854], [-123.82796, 40.06897], [-123.82789, 40.06923], [-123.82852, 40.06923]]]} | Open Access 1 | 20458 | Benbow State Recreation Area | 30556 | 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=426 | Humboldt 45 | 1137.787 | Benbow SRA | 1958 | State Recreation Area 39 | 4 |
2976 | 2976 | 2975 | {"type": "Polygon", "coordinates": [[[-123.7844, 39.94648], [-123.78441, 39.94683], [-123.78435, 39.94708], [-123.78407, 39.94778], [-123.78392, 39.94811], [-123.78379, 39.94856], [-123.78249, 39.94857], [-123.78136, 39.94676], [-123.78036, 39.94442], [-123.78005, 39.94309], [-123.78049, 39.94179], [-123.77938, 39.94079], [-123.77914, 39.94063], [-123.77901, 39.94025], [-123.77821, 39.93938], [-123.77841, 39.93907], [-123.77847, 39.93855], [-123.77837, 39.93806], [-123.77853, 39.93765], [-123.77851, 39.93708], [-123.77914, 39.93668], [-123.77941, 39.93678], [-123.77966, 39.93706], [-123.78091, 39.93646], [-123.78141, 39.93673], [-123.78151, 39.93687], [-123.78157, 39.93706], [-123.78158, 39.93725], [-123.78152, 39.93743], [-123.78143, 39.93758], [-123.78129, 39.93769], [-123.78078, 39.93804], [-123.78048, 39.93817], [-123.78019, 39.93827], [-123.77996, 39.9384], [-123.77979, 39.93858], [-123.77972, 39.93869], [-123.77971, 39.93884], [-123.77977, 39.93898], [-123.77995, 39.93931], [-123.78, 39.93948], [-123.78009, 39.93965], [-123.78034, 39.94008], [-123.78041, 39.94016], [-123.78147, 39.94084], [-123.78187, 39.94116], [-123.78232, 39.94165], [-123.78257, 39.94203], [-123.78276, 39.94237], [-123.78299, 39.94285], [-123.78316, 39.94327], [-123.78357, 39.94413], [-123.78386, 39.94487], [-123.78416, 39.94572], [-123.7844, 39.94648]]]} | Open Access 1 | 20514 | Reynolds Wayside Campgrounds | 1704 | 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=428 | Mendocino 24 | 68.476 | Reynolds Wayside Campgrounds | 1966 | 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 | |
2525 | 2525 | 2524 | {"type": "Polygon", "coordinates": [[[-123.62389, 39.64708], [-123.6238, 39.64742], [-123.62309, 39.64784], [-123.62253, 39.64744], [-123.62189, 39.64786], [-123.61327, 39.64798], [-123.61378, 39.64766], [-123.61419, 39.64711], [-123.61424, 39.64691], [-123.6147, 39.64626], [-123.61443, 39.6461], [-123.61453, 39.64591], [-123.61541, 39.6462], [-123.61603, 39.64616], [-123.61642, 39.64567], [-123.61611, 39.64514], [-123.61634, 39.64482], [-123.61905, 39.64553], [-123.62042, 39.64618], [-123.62084, 39.64617], [-123.62153, 39.64579], [-123.62214, 39.64578], [-123.62369, 39.64684], [-123.62389, 39.64708]]]} | Open Access 1 | 20456 | Admiral William Standley State Recreation Area | 1385 | 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=424 | Mendocino 24 | 46.532 | Admiral William Standley SRA | 1944 | 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 | |
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 | |
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 | |
15636 | 15636 | 15635 | {"type": "Polygon", "coordinates": [[[-122.84086, 38.1053], [-122.83932, 38.10885], [-122.83927, 38.10871], [-122.83925, 38.1086], [-122.83954, 38.10779], [-122.83973, 38.10583], [-122.84007, 38.10548], [-122.84012, 38.10544], [-122.84019, 38.10536], [-122.84024, 38.10522], [-122.84022, 38.10512], [-122.84018, 38.10503], [-122.8401, 38.10496], [-122.83999, 38.1049], [-122.83912, 38.10455], [-122.83903, 38.1045], [-122.83892, 38.10439], [-122.83886, 38.10426], [-122.83858, 38.10384], [-122.83847, 38.10372], [-122.83837, 38.10365], [-122.8382, 38.10357], [-122.83801, 38.10354], [-122.83756, 38.10354], [-122.83742, 38.10352], [-122.83732, 38.10348], [-122.83723, 38.10343], [-122.83716, 38.10336], [-122.83712, 38.10327], [-122.8371, 38.10313], [-122.83727, 38.10224], [-122.83732, 38.10214], [-122.83731, 38.10201], [-122.83727, 38.10192], [-122.83719, 38.10185], [-122.83647, 38.10098], [-122.83635, 38.10086], [-122.83625, 38.10079], [-122.83614, 38.10073], [-122.83596, 38.10066], [-122.83565, 38.10059], [-122.83517, 38.10059], [-122.835, 38.10053], [-122.83487, 38.10045], [-122.8348, 38.10037], [-122.83475, 38.10028], [-122.8342, 38.09949], [-122.83412, 38.09933], [-122.83399, 38.09917], [-122.83388, 38.09907], [-122.83378, 38.09901], [-122.83301, 38.09862], [-122.83287, 38.09852], [-122.83272, 38.09836], [-122.8327, 38.09829], [-122.83261, 38.09814], [-122.83243, 38.09798], [-122.8322, 38.09785], [-122.83154, 38.09766], [-122.83108, 38.0975], [-122.83072, 38.09742], [-122.8297, 38.09728], [-122.82957, 38.09728], [-122.8294, 38.09722], [-122.82927, 38.09713], [-122.82919, 38.097], [-122.82913, 38.09661], [-122.82914, 38.09652], [-122.82922, 38.09639], [-122.82952, 38.09614], [-122.82968, 38.09603], [-122.8298, 38.09589], [-122.82988, 38.09572], [-122.82988, 38.09554], [-122.82987, 38.09546], [-122.82978, 38.09529], [-122.82885, 38.09403], [-122.82858, 38.09378], [-122.82825, 38.09359], [-122.82803, 38.09341], [-122.82794, 38.09331], [-122.82783, 38.09315], [-122.82741, 38.09271], [-122.82698, 38.09243], [-122.82682, 38.09238], [-122.82665, 38.09236], [-122.82637, 38.0924], [-122.82603, 38.09259], [-122.82592, 38.09259], [-122.82581, 38.09256], [-122.8257, 38.09246], [-122.82568, 38.09241], [-122.82569, 38.09227], [-122.82563, 38.09213], [-122.82551, 38.09202], [-122.82534, 38.09195], [-122.82515, 38.09183], [-122.82504, 38.0917], [-122.82496, 38.09155], [-122.82489, 38.09146], [-122.82476, 38.09135], [-122.82466, 38.0913], [-122.82444, 38.09121], [-122.82425, 38.09119], [-122.82358, 38.09093], [-122.82314, 38.09074], [-122.82262, 38.09045], [-122.8225, 38.09042], [-122.82226, 38.09044], [-122.82207, 38.09053], [-122.82197, 38.09066], [-122.82148, 38.09112], [-122.82135, 38.09123], [-122.82108, 38.09138], [-122.82085, 38.09147], [-122.82061, 38.09154], [-122.81956, 38.09165], [-122.82049, 38.09129], [-122.82139, 38.08918], [-122.82504, 38.09074], [-122.82604, 38.09126], [-122.82666, 38.09164], [-122.82725, 38.09203], [-122.82818, 38.09274], [-122.82886, 38.09336], [-122.82948, 38.09401], [-122.82977, 38.09435], [-122.83018, 38.09487], [-122.83042, 38.09521], [-122.83038, 38.0953], [-122.8321, 38.09721], [-122.83174, 38.09716], [-122.83171, 38.09725], [-122.83231, 38.09736], [-122.8379, 38.10183], [-122.84071, 38.10517], [-122.84086, 38.1053]]]} | Open Access 1 | 1665 | Tomales Bay Fishing Access | 32327 | 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 | 52.616 | Tomales Bay FA | 0 | State Recreation Area 39 | 4 | |
15646 | 15646 | 15645 | {"type": "Polygon", "coordinates": [[[-122.81955, 38.06281], [-122.81919, 38.0628], [-122.81891, 38.06285], [-122.81842, 38.06298], [-122.81768, 38.06309], [-122.81685, 38.06315], [-122.81634, 38.06311], [-122.81511, 38.06299], [-122.81302, 38.06306], [-122.81281, 38.06305], [-122.81271, 38.06303], [-122.8126, 38.06297], [-122.81766, 38.06154], [-122.81852, 38.06235], [-122.81913, 38.06261], [-122.81955, 38.06281]]]} | Open Access 1 | 29598 | White House Pool Fishing Access | 32349 | 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 | 12.717 | White House Pool FA | 0 | State Recreation Area 39 | 4 | |
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 | |
11467 | 11467 | 11466 | {"type": "Polygon", "coordinates": [[[-122.80585, 40.71739], [-122.80501, 40.71749], [-122.80433, 40.7175], [-122.80228, 40.7173], [-122.80209, 40.71687], [-122.80259, 40.71646], [-122.80453, 40.71712], [-122.80523, 40.71718], [-122.80585, 40.71739]]]} | Open Access 1 | 29196 | Deadwood Hole Fishing Access | 32145 | 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 | 4.23 | Deadwood Hole 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 | |
4964 | 4964 | 4963 | {"type": "Polygon", "coordinates": [[[-122.43108, 41.43777], [-122.43089, 41.43822], [-122.4304, 41.43783], [-122.43008, 41.43741], [-122.43055, 41.43722], [-122.43108, 41.43777]]]} | Open Access 1 | 3682 | Shasta River Fishing Access | 32306 | 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.086 | Shasta River FA | 0 | State Recreation Area 39 | 4 | |
9535 | 9535 | 9534 | {"type": "Polygon", "coordinates": [[[-122.38699, 38.39466], [-122.37714, 38.39469], [-122.37938, 38.38742], [-122.38029, 38.38436], [-122.37717, 38.39444], [-122.37409, 38.39566], [-122.37335, 38.39398], [-122.37121, 38.39263], [-122.3693, 38.39221], [-122.36874, 38.39053], [-122.36846, 38.38914], [-122.36755, 38.38821], [-122.366, 38.38782], [-122.37008, 38.38595], [-122.37392, 38.39097], [-122.37515, 38.39047], [-122.37727, 38.38728], [-122.37763, 38.38706], [-122.37758, 38.38599], [-122.37775, 38.3841], [-122.3772, 38.38216], [-122.37717, 38.38217], [-122.37531, 38.38163], [-122.37518, 38.38087], [-122.37591, 38.37813], [-122.3817, 38.37932], [-122.38186, 38.37922], [-122.38154, 38.38027], [-122.38184, 38.38028], [-122.38222, 38.39106], [-122.38683, 38.39105], [-122.38699, 38.39466]]]} | Open Access 1 | 15987 | Veterans Home Open Space | 1819 | 206 | California Department of Veterans Affairs 170 | State 5 | State Agency 5 | http://www.cdva.ca.gov/ | Other State 5 | 206 | California Department of Veterans Affairs 166 | State 5 | State Agency 5 | Napa 11 | 347.642 | Veterans Home OS | 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 | |
12440 | 12440 | 12439 | {"type": "Polygon", "coordinates": [[[-122.36331, 37.16623], [-122.36144, 37.16664], [-122.36109, 37.16567], [-122.36133, 37.16546], [-122.36125, 37.16527], [-122.36285, 37.16507], [-122.36298, 37.16548], [-122.36304, 37.16562], [-122.36313, 37.16573], [-122.36326, 37.16613], [-122.36331, 37.16623]]]} | Open Access 1 | 28093 | Gazos Creek Fishing Access | 32169 | 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 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | San Mateo 15 | 5.84 | Gazos Creek FA | 2008 | 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]);