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 sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: COUNTY, YR_EST
ACCESS_TYP 2
MNG_AG_TYP 1
- State Agency 54
MNG_AGENCY 1
- California Department of Fish and Wildlife · 54 ✖
LAYER 1 ✖
DES_TP 1
- State Recreation Area · 54 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
15645 | 15645 | 15644 | {"type": "Polygon", "coordinates": [[[-121.9752, 38.1883], [-121.97501, 38.18844], [-121.97456, 38.18828], [-121.97424, 38.18823], [-121.97403, 38.18826], [-121.97369, 38.18821], [-121.97322, 38.1882], [-121.97279, 38.18816], [-121.9715, 38.18789], [-121.97085, 38.18789], [-121.97038, 38.18761], [-121.97037, 38.18713], [-121.97034, 38.18699], [-121.97037, 38.18681], [-121.97046, 38.18671], [-121.97061, 38.18668], [-121.97351, 38.18742], [-121.97394, 38.18748], [-121.97425, 38.18755], [-121.97444, 38.18772], [-121.97491, 38.18782], [-121.97501, 38.18788], [-121.97501, 38.18814], [-121.9751, 38.18823], [-121.9752, 38.1883]]]} | Open Access 1 | 29190 | Belden's Landing Fishing Access | 32045 | 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 | 9.739 | Belden's Landing FA | 0 | State Recreation Area 39 | 4 | |
15644 | 15644 | 15643 | {"type": "Polygon", "coordinates": [[[-121.00139, 39.06934], [-120.99874, 39.069], [-120.99789, 39.06951], [-120.99788, 39.06952], [-120.999, 39.07047], [-120.99886, 39.07205], [-120.99861, 39.07295], [-120.99796, 39.0731], [-120.99607, 39.0738], [-120.99433, 39.07435], [-120.99373, 39.0745], [-120.99325, 39.07469], [-120.99326, 39.07569], [-120.99322, 39.07675], [-120.99435, 39.07741], [-120.99498, 39.07788], [-120.9959, 39.07848], [-120.99739, 39.07957], [-120.99723, 39.0813], [-120.99661, 39.08206], [-120.9963, 39.08237], [-120.99442, 39.08236], [-120.99343, 39.08238], [-120.99246, 39.0823], [-120.99231, 39.08231], [-120.99208, 39.08257], [-120.99044, 39.0847], [-120.98935, 39.08652], [-120.98869, 39.08647], [-120.98866, 39.08616], [-120.98849, 39.08586], [-120.98849, 39.08569], [-120.98866, 39.085], [-120.98892, 39.08446], [-120.98911, 39.08425], [-120.98944, 39.08399], [-120.98968, 39.08384], [-120.98982, 39.08372], [-120.98994, 39.08355], [-120.99005, 39.08328], [-120.99017, 39.08312], [-120.99036, 39.08297], [-120.99067, 39.08261], [-120.99095, 39.08213], [-120.99121, 39.08201], [-120.99145, 39.08195], [-120.99166, 39.0819], [-120.99237, 39.0818], [-120.99265, 39.08184], [-120.99293, 39.08186], [-120.99307, 39.08184], [-120.9935, 39.08168], [-120.99402, 39.08142], [-120.99418, 39.08135], [-120.9943, 39.08132], [-120.9947, 39.08125], [-120.99486, 39.08124], [-120.99505, 39.08127], [-120.99534, 39.08126], [-120.99555, 39.0812], [-120.99574, 39.08112], [-120.996, 39.08085], [-120.99607, 39.08067], [-120.99606, 39.08027], [-120.996, 39.0801], [-120.9959, 39.07985], [-120.99562, 39.07937], [-120.9955, 39.07919], [-120.99528, 39.07891], [-120.99505, 39.0787], [-120.9947, 39.07832], [-120.99434, 39.07809], [-120.99402, 39.07796], [-120.99345, 39.07782], [-120.99319, 39.07772], [-120.993, 39.07768], [-120.99251, 39.07753], [-120.99184, 39.07724], [-120.99161, 39.07702], [-120.99151, 39.07673], [-120.99147, 39.07651], [-120.99149, 39.07621], [-120.99158, 39.07602], [-120.99189, 39.07557], [-120.9925, 39.07488], [-120.99267, 39.07476], [-120.993, 39.07459], [-120.99322, 39.0745], [-120.99385, 39.07434], [-120.99409, 39.07418], [-120.99484, 39.07381], [-120.99607, 39.07334], [-120.99649, 39.07321], [-120.99713, 39.07298], [-120.99738, 39.07283], [-120.99767, 39.07269], [-120.9981, 39.07243], [-120.99838, 39.07221], [-120.99849, 39.072], [-120.99854, 39.07182], [-120.99855, 39.07157], [-120.99824, 39.07081], [-120.99812, 39.07063], [-120.99784, 39.07034], [-120.99765, 39.07025], [-120.99734, 39.07012], [-120.9971, 39.07005], [-120.99687, 39.06992], [-120.99659, 39.06968], [-120.99646, 39.06946], [-120.99637, 39.06927], [-120.99635, 39.06914], [-120.99637, 39.06886], [-120.99644, 39.06871], [-120.99652, 39.06857], [-120.99666, 39.06839], [-120.99682, 39.06823], [-120.99699, 39.06815], [-121.00137, 39.0689], [-121.00139, 39.06934]]]} | Open Access 1 | 25248 | Bear River Fishing Access | 32044 | 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 | 67.17 | Bear River FA | 0 | State Recreation Area 39 | 4 | |
15643 | 15643 | 15642 | {"type": "Polygon", "coordinates": [[[-120.99671, 39.06834], [-120.99652, 39.06857], [-120.99644, 39.06871], [-120.99637, 39.06886], [-120.99635, 39.06914], [-120.99637, 39.06927], [-120.99646, 39.06946], [-120.99659, 39.06968], [-120.99687, 39.06992], [-120.9971, 39.07005], [-120.99734, 39.07012], [-120.99765, 39.07025], [-120.99784, 39.07034], [-120.99812, 39.07063], [-120.99824, 39.07081], [-120.99855, 39.07157], [-120.99854, 39.07182], [-120.99849, 39.072], [-120.99838, 39.07221], [-120.9981, 39.07243], [-120.99767, 39.07269], [-120.99738, 39.07283], [-120.99713, 39.07298], [-120.99649, 39.07321], [-120.99607, 39.07334], [-120.99484, 39.07381], [-120.99409, 39.07418], [-120.99385, 39.07434], [-120.99322, 39.0745], [-120.993, 39.07459], [-120.99267, 39.07476], [-120.9925, 39.07488], [-120.99189, 39.07557], [-120.99158, 39.07602], [-120.99149, 39.07621], [-120.99147, 39.07651], [-120.99151, 39.07673], [-120.99161, 39.07702], [-120.99184, 39.07724], [-120.99251, 39.07753], [-120.993, 39.07768], [-120.99319, 39.07772], [-120.99345, 39.07782], [-120.99402, 39.07796], [-120.99434, 39.07809], [-120.9947, 39.07832], [-120.99505, 39.0787], [-120.99528, 39.07891], [-120.99562, 39.07937], [-120.9959, 39.07985], [-120.996, 39.0801], [-120.99606, 39.08027], [-120.99607, 39.08067], [-120.996, 39.08085], [-120.99574, 39.08112], [-120.99555, 39.0812], [-120.99534, 39.08126], [-120.99505, 39.08127], [-120.99486, 39.08124], [-120.9947, 39.08125], [-120.9943, 39.08132], [-120.99418, 39.08135], [-120.99402, 39.08142], [-120.9935, 39.08168], [-120.99307, 39.08184], [-120.99293, 39.08186], [-120.99265, 39.08184], [-120.99237, 39.0818], [-120.99166, 39.0819], [-120.99145, 39.08195], [-120.99121, 39.08201], [-120.99095, 39.08213], [-120.99067, 39.08261], [-120.99036, 39.08297], [-120.99017, 39.08312], [-120.99005, 39.08328], [-120.98994, 39.08355], [-120.98982, 39.08372], [-120.98968, 39.08384], [-120.98944, 39.08399], [-120.98911, 39.08425], [-120.98892, 39.08446], [-120.98866, 39.085], [-120.98849, 39.08569], [-120.98849, 39.08586], [-120.98866, 39.08616], [-120.98869, 39.08655], [-120.98862, 39.08703], [-120.98855, 39.0873], [-120.98845, 39.08793], [-120.98843, 39.08826], [-120.9885, 39.08873], [-120.9885, 39.08893], [-120.98842, 39.08946], [-120.98829, 39.08984], [-120.98807, 39.09034], [-120.98777, 39.09082], [-120.98758, 39.09124], [-120.98746, 39.0917], [-120.98744, 39.09194], [-120.98753, 39.09229], [-120.98763, 39.09261], [-120.98767, 39.09305], [-120.98764, 39.09386], [-120.98765, 39.09424], [-120.9877, 39.09478], [-120.98769, 39.09523], [-120.9875, 39.09581], [-120.98734, 39.09612], [-120.98718, 39.09657], [-120.98701, 39.09686], [-120.98693, 39.09713], [-120.98595, 39.09711], [-120.98599, 39.09674], [-120.98612, 39.09664], [-120.98632, 39.09614], [-120.98629, 39.09545], [-120.98596, 39.09498], [-120.98503, 39.0942], [-120.98558, 39.09368], [-120.98546, 39.09235], [-120.98657, 39.09107], [-120.98674, 39.09083], [-120.9867, 39.09033], [-120.98696, 39.08997], [-120.98691, 39.08986], [-120.9866, 39.08927], [-120.98671, 39.08913], [-120.98676, 39.08867], [-120.98713, 39.08755], [-120.98727, 39.08678], [-120.98727, 39.08652], [-120.98507, 39.08644], [-120.9851, 39.08641], [-120.98519, 39.0857], [-120.98792, 39.08572], [-120.98804, 39.0846], [-120.98534, 39.08446], [-120.98552, 39.08418], [-120.98554, 39.08391], [-120.98553, 39.08389], [-120.98595, 39.08391], [-120.98618, 39.08365], [-120.98626, 39.08324], [-120.98589, 39.08303], [-120.98525, 39.08302], [-120.98405, 39.08281], [-120.98364, 39.08242], [-120.98361, 39.08227], [-120.98482, 39.0823], [-120.98631, 39.08198], [-120.98669, 39.08217], [-120.98741, 39.0821], [-120.98798, 39.08208], [-120.98812, 39.08203], [-120.98858, 39.08163], [-120.9892, 39.08157], [-120.99035, 39.08116], [-120.99165, 39.08076], [-120.99174, 39.08067], [-120.99174, 39.08048], [-120.99121, 39.08021], [-120.99107, 39.0799], [-120.99046, 39.07976], [-120.99046, 39.07954], [-120.99108, 39.07911], [-120.99089, 39.07826], [-120.99068, 39.07809], [-120.99046, 39.07809], [-120.99002, 39.07837], [-120.98978, 39.07857], [-120.98899, 39.07846], [-120.98851, 39.078], [-120.98798, 39.07804], [-120.98799, 39.07753], [-120.98813, 39.0775], [-120.98861, 39.07731], [-120.98907, 39.07721], [-120.98929, 39.07706], [-120.98955, 39.07697], [-120.98991, 39.0767], [-120.99015, 39.07635], [-120.99047, 39.07543], [-120.99047, 39.07502], [-120.99045, 39.0749], [-120.99083, 39.07446], [-120.99109, 39.07398], [-120.99131, 39.0739], [-120.9926, 39.07315], [-120.99373, 39.07267], [-120.99362, 39.07229], [-120.99347, 39.07218], [-120.99296, 39.0721], [-120.99253, 39.07211], [-120.9922, 39.07202], [-120.99207, 39.07186], [-120.99213, 39.07158], [-120.99196, 39.07135], [-120.99185, 39.07089], [-120.99161, 39.07074], [-120.99178, 39.07028], [-120.99209, 39.07027], [-120.99237, 39.07012], [-120.99289, 39.07067], [-120.99332, 39.07063], [-120.99403, 39.07028], [-120.99413, 39.07005], [-120.99342, 39.06931], [-120.99361, 39.06918], [-120.99384, 39.06887], [-120.99374, 39.0683], [-120.99662, 39.06833], [-120.99663, 39.06835], [-120.99671, 39.06834]]]} | Open Access 1 | 17849 | Bear River Fishing Access | 32044 | 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 | Placer 35 | 202.774 | Bear River 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 | |
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 | |
15610 | 15610 | 15609 | {"type": "Polygon", "coordinates": [[[-121.72405, 38.8023], [-121.723, 38.802], [-121.72279, 38.80192], [-121.72263, 38.80183], [-121.72246, 38.80166], [-121.72346, 38.80108], [-121.72358, 38.8014], [-121.72365, 38.80151], [-121.72405, 38.8023]]]} | Open Access 1 | 21358 | Knights Landing Fishing Access | 32198 | 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 | 2.104 | Knights Landing FA | 0 | State Recreation Area 39 | 4 | |
15605 | 15605 | 15604 | {"type": "Polygon", "coordinates": [[[-119.72836, 38.76932], [-119.72373, 38.76933], [-119.7237, 38.76577], [-119.72821, 38.76567], [-119.72836, 38.76932]]]} | Open Access 1 | 20782 | East Fork Carson River Fishing Access | 32153 | 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 | Alpine 51 | 39.271 | East Fork Carson River FA | 0 | State Recreation Area 39 | 4 | |
15595 | 15595 | 15594 | {"type": "MultiPolygon", "coordinates": [[[[-121.68867, 38.1275], [-121.68824, 38.12823], [-121.68816, 38.12841], [-121.68798, 38.1287], [-121.68785, 38.12897], [-121.68754, 38.12941], [-121.68728, 38.1298], [-121.68701, 38.13033], [-121.68702, 38.13034], [-121.68706, 38.13035], [-121.68718, 38.13022], [-121.68731, 38.13013], [-121.68731, 38.13025], [-121.68714, 38.13082], [-121.68674, 38.13287], [-121.68666, 38.13305], [-121.68649, 38.13315], [-121.68632, 38.13314], [-121.68623, 38.1332], [-121.68621, 38.13383], [-121.686, 38.13383], [-121.68599, 38.13345], [-121.686, 38.13318], [-121.68608, 38.13262], [-121.68618, 38.13226], [-121.68662, 38.13085], [-121.68679, 38.13039], [-121.68701, 38.12992], [-121.68765, 38.12883], [-121.6877, 38.12882], [-121.68848, 38.12743], [-121.68867, 38.1275]]], [[[-121.69005, 38.12496], [-121.69001, 38.1252], [-121.68961, 38.12519], [-121.68986, 38.12492], [-121.69005, 38.12496]]]]} | Open Access 1 | 18062 | Brannan Island Fishing Access | 32066 | 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 | 6.245 | Brannan Island FA | 0 | State Recreation Area 39 | 4 | |
12280 | 12280 | 12279 | {"type": "Polygon", "coordinates": [[[-122.01675, 39.96925], [-122.01628, 39.96961], [-122.0158, 39.96979], [-122.01445, 39.96984], [-122.01447, 39.9697], [-122.01532, 39.96964], [-122.01591, 39.96951], [-122.0165, 39.96916], [-122.01675, 39.96925]]]} | Open Access 1 | 25907 | Deer Creek Fishing Access | 32147 | 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 | 1.1 | Deer Creek 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 | |
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 | |
11462 | 11462 | 11461 | {"type": "Polygon", "coordinates": [[[-122.179, 40.39296], [-122.17893, 40.39304], [-122.17881, 40.3933], [-122.17839, 40.39374], [-122.17821, 40.39349], [-122.17821, 40.39301], [-122.17663, 40.39309], [-122.17653, 40.3925], [-122.17678, 40.39242], [-122.177, 40.39239], [-122.17736, 40.39239], [-122.1779, 40.39233], [-122.17853, 40.39231], [-122.17893, 40.39282], [-122.179, 40.39296]]]} | Open Access 1 | 29185 | Battle Creek Public Access | 32043 | 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 | 4.326 | Battle 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 | |
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 | |
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 | |
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 | |
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 | |
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 |
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]);