units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
56 rows where DES_TP = 39 and LAYER = 6 sorted by UNIT_ID
This data as json, copyable, CSV (advanced)
Suggested facets: YR_EST
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7996 | 7996 | 7995 | {"type": "MultiPolygon", "coordinates": [[[[-120.84563, 37.61895], [-120.84545, 37.61903], [-120.84473, 37.62007], [-120.84403, 37.62084], [-120.84261, 37.62181], [-120.84163, 37.62226], [-120.84153, 37.62225], [-120.84196, 37.62189], [-120.84148, 37.62063], [-120.84163, 37.61955], [-120.84195, 37.61932], [-120.84163, 37.61895], [-120.8422, 37.61857], [-120.84301, 37.61756], [-120.84275, 37.61605], [-120.84369, 37.61618], [-120.84406, 37.61629], [-120.84379, 37.61775], [-120.8443, 37.61762], [-120.84492, 37.61786], [-120.84529, 37.61767], [-120.84563, 37.61895]]], [[[-120.85093, 37.61827], [-120.84939, 37.61906], [-120.84879, 37.61899], [-120.84793, 37.6187], [-120.84729, 37.61865], [-120.84609, 37.61872], [-120.84574, 37.61743], [-120.84684, 37.61692], [-120.84745, 37.61661], [-120.84873, 37.61675], [-120.84972, 37.6172], [-120.85027, 37.61796], [-120.85068, 37.6181], [-120.85055, 37.61819], [-120.85055, 37.61821], [-120.85093, 37.61827]]]]} | Open Access 1 | 468 | Fox Grove Fishing Access | 32167 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Stanislaus 2 | 51.641 | Fox Grove FA | 0 | State Recreation Area 39 | 4 | |
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 | |
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 | |
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 | |
8024 | 8024 | 8023 | {"type": "Polygon", "coordinates": [[[-122.54551, 41.88727], [-122.5444, 41.88768], [-122.5435, 41.8885], [-122.54277, 41.88937], [-122.54183, 41.88996], [-122.53879, 41.8915], [-122.53586, 41.89274], [-122.53586, 41.89232], [-122.53761, 41.89143], [-122.53801, 41.89105], [-122.53835, 41.89082], [-122.53863, 41.89065], [-122.53877, 41.89048], [-122.53898, 41.89012], [-122.53919, 41.88994], [-122.53929, 41.88973], [-122.53954, 41.88847], [-122.53961, 41.88826], [-122.54052, 41.887], [-122.54549, 41.88699], [-122.54551, 41.88727]]]} | Open Access 1 | 1289 | Klamath River Fishing Access | 32196 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Siskiyou 28 | 36.2 | Klamath River FA | 0 | State Recreation Area 39 | 4 | |
8159 | 8159 | 8158 | {"type": "MultiPolygon", "coordinates": [[[[-122.81064, 40.70578], [-122.81004, 40.70593], [-122.809, 40.70694], [-122.80872, 40.70817], [-122.80814, 40.70853], [-122.80771, 40.70934], [-122.80728, 40.70938], [-122.80691, 40.71639], [-122.80598, 40.71639], [-122.8058, 40.70942], [-122.80587, 40.70899], [-122.80626, 40.70834], [-122.80668, 40.70798], [-122.80707, 40.70772], [-122.8073, 40.70713], [-122.80705, 40.70654], [-122.80737, 40.70648], [-122.8081, 40.70615], [-122.80847, 40.70555], [-122.80891, 40.7056], [-122.81035, 40.70528], [-122.81064, 40.70578]]], [[[-122.81796, 40.71102], [-122.81795, 40.71281], [-122.81715, 40.71313], [-122.81637, 40.71249], [-122.8155, 40.71249], [-122.81448, 40.71101], [-122.81796, 40.71102]]]]} | Open Access 1 | 1520 | Lewiston Fishing Access | 32202 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Trinity 46 | 48.998 | Lewiston FA | 0 | State Recreation Area 39 | 4 | |
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 | |
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 | |
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 | |
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 | |
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 | |
7436 | 7436 | 7435 | {"type": "Polygon", "coordinates": [[[-120.55936, 36.14655], [-120.55484, 36.14658], [-120.55048, 36.14653], [-120.54144, 36.14651], [-120.54142, 36.13932], [-120.55041, 36.13938], [-120.55925, 36.13938], [-120.55932, 36.14295], [-120.55936, 36.14655]]]} | Open Access 1 | 6994 | Coalinga Mineral Springs Public Access | 32124 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Fresno 9 | 316.828 | Coalinga Mineral Springs PA | 0 | State Recreation Area 39 | 4 | |
7536 | 7536 | 7535 | {"type": "MultiPolygon", "coordinates": [[[[-120.4594, 36.09525], [-120.45884, 36.09971], [-120.45356, 36.09967], [-120.454, 36.096], [-120.45465, 36.09599], [-120.45495, 36.09613], [-120.45535, 36.09628], [-120.4556, 36.09628], [-120.45586, 36.09634], [-120.45597, 36.09635], [-120.45623, 36.09634], [-120.45653, 36.09626], [-120.45684, 36.09612], [-120.45705, 36.096], [-120.45847, 36.09601], [-120.45855, 36.09539], [-120.4594, 36.09525]]], [[[-120.4602, 36.08884], [-120.45943, 36.09501], [-120.45866, 36.09511], [-120.45891, 36.09249], [-120.45453, 36.09211], [-120.45494, 36.08881], [-120.4602, 36.08884]]]]} | Open Access 1 | 7116 | Curry Mountain Public Access | 32142 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Fresno 9 | 98.979 | Curry Mtn. PA | 0 | State Recreation Area 39 | 4 | |
8374 | 8374 | 8373 | {"type": "Polygon", "coordinates": [[[-121.08882, 40.26942], [-121.08854, 40.26983], [-121.08846, 40.27002], [-121.08842, 40.27082], [-121.08795, 40.27058], [-121.08782, 40.27074], [-121.08679, 40.27021], [-121.08692, 40.26987], [-121.08882, 40.26942]]]} | Open Access 1 | 7222 | Hamilton Branch Fishing Access | 32181 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Plumas 57 | 3.469 | Hamilton Branch FA | 0 | State Recreation Area 39 | 4 | |
8488 | 8488 | 8487 | {"type": "MultiPolygon", "coordinates": [[[[-120.43877, 39.82145], [-120.43839, 39.82166], [-120.43819, 39.82171], [-120.43785, 39.82188], [-120.43755, 39.82196], [-120.43723, 39.822], [-120.43693, 39.82199], [-120.43662, 39.82194], [-120.43634, 39.82185], [-120.4361, 39.8218], [-120.43575, 39.82164], [-120.43576, 39.82128], [-120.43628, 39.82143], [-120.43663, 39.82149], [-120.43688, 39.82151], [-120.43739, 39.8215], [-120.43786, 39.82143], [-120.43877, 39.82145]]], [[[-120.6211, 39.77924], [-120.6211, 39.77924], [-120.61819, 39.77703], [-120.61893, 39.77692], [-120.61945, 39.77704], [-120.61963, 39.77712], [-120.62009, 39.77762], [-120.62049, 39.77786], [-120.62088, 39.77803], [-120.6211, 39.77924]]], [[[-120.62349, 39.7793], [-120.62163, 39.77937], [-120.62146, 39.77817], [-120.6221, 39.77824], [-120.62266, 39.77847], [-120.62302, 39.7787], [-120.62315, 39.77902], [-120.62349, 39.7793]]]]} | Open Access 1 | 7475 | Middle Fork Feather River Fishing Access | 32218 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Plumas 57 | 11.416 | Middle Fork Feather River FA | 0 | State Recreation Area 39 | 4 | |
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 | |
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 | |
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 | |
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 |
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]);