units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
145 rows where DES_TP = 39 sorted by SUID_NMA 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
16266 | 16266 | 16265 | {"type": "Polygon", "coordinates": [[[-120.60008, 37.87728], [-120.5994, 37.87755], [-120.5987, 37.87787], [-120.59749, 37.87871], [-120.59669, 37.88092], [-120.59607, 37.88162], [-120.59598, 37.88201], [-120.59579, 37.88199], [-120.59575, 37.88212], [-120.59567, 37.88372], [-120.59567, 37.88438], [-120.59598, 37.88591], [-120.59646, 37.88636], [-120.59794, 37.88707], [-120.5979, 37.88755], [-120.59538, 37.88749], [-120.5934, 37.88742], [-120.59249, 37.8862], [-120.59202, 37.88562], [-120.59209, 37.88529], [-120.59286, 37.88446], [-120.59285, 37.88196], [-120.59335, 37.88146], [-120.59393, 37.88111], [-120.59433, 37.88065], [-120.59482, 37.88016], [-120.59512, 37.87986], [-120.59603, 37.87903], [-120.59659, 37.87792], [-120.59663, 37.87734], [-120.59708, 37.87734], [-120.59731, 37.87731], [-120.59892, 37.87728], [-120.60008, 37.87728]]]} | Open Access 1 | 697 | Tulloch Reservoir Public Access | 32330 | 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 | 70.188 | Tulloch Reservoir PA | 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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
15639 | 15639 | 15638 | {"type": "MultiPolygon", "coordinates": [[[[-123.77482, 40.18351], [-123.77339, 40.18521], [-123.77292, 40.1862], [-123.77241, 40.18737], [-123.77148, 40.18859], [-123.77097, 40.189], [-123.77031, 40.19059], [-123.77002, 40.19148], [-123.77011, 40.19293], [-123.77114, 40.19444], [-123.76896, 40.19433], [-123.76867, 40.19404], [-123.76903, 40.19328], [-123.76916, 40.19245], [-123.76916, 40.19172], [-123.76911, 40.19145], [-123.76887, 40.19146], [-123.76897, 40.19109], [-123.76951, 40.1906], [-123.76952, 40.19017], [-123.76983, 40.18938], [-123.77129, 40.18818], [-123.77164, 40.18773], [-123.77168, 40.18709], [-123.77179, 40.18692], [-123.77214, 40.1862], [-123.77302, 40.18471], [-123.77339, 40.184], [-123.77392, 40.1835], [-123.77482, 40.18351]]], [[[-123.77704, 40.18211], [-123.77516, 40.18275], [-123.77499, 40.18248], [-123.77676, 40.18179], [-123.77704, 40.18211]]], [[[-123.78179, 40.17873], [-123.78177, 40.17879], [-123.78185, 40.17932], [-123.7816, 40.18012], [-123.78034, 40.18038], [-123.7814, 40.17917], [-123.7816, 40.17874], [-123.78179, 40.17873]]], [[[-123.78232, 40.17179], [-123.78261, 40.17241], [-123.78267, 40.17276], [-123.78248, 40.17395], [-123.78221, 40.17459], [-123.78193, 40.17583], [-123.78199, 40.17663], [-123.78188, 40.17722], [-123.78159, 40.17857], [-123.78136, 40.17848], [-123.78169, 40.1757], [-123.7819, 40.17248], [-123.7819, 40.17179], [-123.78232, 40.17179]]]]} | Open Access 1 | 21580 | South Fork Eel River Fishing Access | 32314 | 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 | 35.527 | South Fork Eel River 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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 |
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]);