units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
969 rows where ACCESS_TYP = 3 sorted by UNIT_ID
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- California Department of Fish and Wildlife 72
- East Bay Regional Park District 44
- Los Angeles, City of 36
- The Nature Conservancy 31
- Las Virgenes Municipal Water District 28
- Peninsula Open Space Trust 23
- Natomas Basin Conservancy 22
- Rivers and Lands Conservancy 22
- The Environmental Trust 21
- Torrance, City of 20
- Mountains Restoration Trust 20
- San Diego, City of 19
- Santa Clara Valley Open Space Authority 18
- Midpeninsula Regional Open Space District 18
- Fresno Metropolitan Flood Control District 16
- Endangered Habitats Conservancy 14
- United States Fish and Wildlife Service 13
- California Department of Parks and Recreation 13
- Los Angeles County Flood Control District 13
- Kinneloa Irrigation District 13
- Santa Clara County Parks and Recreation Dept., County of 13
- American River Conservancy 13
- Save Mount Diablo 13
- Littlerock Creek Irrigation District 13
- San Diego, County of 12
- Napa, City of 12
- Sonoma Land Trust 11
- California Department of Water Resources 11
- Sonoma County Agricultural Preservation and Open Space District 10
- Riverside County Habitat Conservation Agency 10
- …
DES_TP >30
- Private Conservation 208
- Local Recreation Area 108
- Local Other or Unknown 87
- Local Park 76
- Local Conservation Area 72
- State Resource Management Area 60
- Private Recreation or Education 25
- Private Other or Unknown 25
- State Conservation Area 20
- State Other or Unknown 18
- National Wildlife Refuge 12
- Local Resource Management Area 8
- Private Agricultural 5
- Resource Management Area 4
- State Park 3
- Federal Other or Unknown 3
- State Historic or Cultural Area 3
- National Public Lands 2
- Conservation Area 2
- National Monument or Landmark 2
- State Recreation Area 1
- Recreation Management Area 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- …
MNG_AG_TYP 20
- Non Profit - Land Trust 213
- City Agency 194
- State Agency 126
- Recreation/Parks District 100
- Flood District 58
- Water District 56
- Non Profit - Conservation 50
- Federal Agency 30
- Irrigation District 29
- County Agency 24
- Open Space District 21
- County Agency - Parks 18
- County Agency - Other 3
- Home Owners Association 1
- Commercial 1
- Sanitation District 1
- Non Profit - Other 1
- Joint Powers Authority 1
- Other 1
- Mitigation Bank 1
ACCESS_TYP 1
- No Public Access · 929 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6386 | 6386 | 6385 | {"type": "Polygon", "coordinates": [[[-117.52541, 33.96645], [-117.52323, 33.96645], [-117.52323, 33.96816], [-117.52308, 33.96816], [-117.52307, 33.96821], [-117.52205, 33.96822], [-117.52205, 33.96841], [-117.5211, 33.96915], [-117.52048, 33.96989], [-117.51961, 33.97059], [-117.51875, 33.97187], [-117.51691, 33.97319], [-117.5158, 33.97365], [-117.5131, 33.97522], [-117.50998, 33.9752], [-117.50918, 33.97488], [-117.50687, 33.9741], [-117.50585, 33.97403], [-117.50479, 33.97394], [-117.50361, 33.97318], [-117.50246, 33.97302], [-117.50143, 33.97293], [-117.5014, 33.97181], [-117.49279, 33.97184], [-117.49277, 33.9709], [-117.49061, 33.97092], [-117.49058, 33.97001], [-117.48845, 33.97007], [-117.4863, 33.96896], [-117.48462, 33.96846], [-117.48335, 33.96843], [-117.48115, 33.9678], [-117.47973, 33.96718], [-117.47972, 33.96719], [-117.47972, 33.96789], [-117.47848, 33.96747], [-117.47631, 33.96659], [-117.47327, 33.96741], [-117.47088, 33.96761], [-117.47004, 33.96751], [-117.47017, 33.96736], [-117.47022, 33.96727], [-117.47026, 33.96712], [-117.47026, 33.96701], [-117.47023, 33.96686], [-117.47019, 33.96676], [-117.47012, 33.96667], [-117.46994, 33.96654], [-117.46977, 33.96648], [-117.46961, 33.96645], [-117.46958, 33.96655], [-117.46789, 33.96629], [-117.46628, 33.96524], [-117.46603, 33.96324], [-117.46598, 33.96295], [-117.46585, 33.9625], [-117.46578, 33.96229], [-117.46557, 33.96188], [-117.46536, 33.96155], [-117.46522, 33.96136], [-117.4649, 33.961], [-117.46467, 33.96077], [-117.46428, 33.96046], [-117.46388, 33.9602], [-117.46301, 33.95955], [-117.46411, 33.95939], [-117.46456, 33.95971], [-117.46482, 33.96024], [-117.46666, 33.96053], [-117.46667, 33.96066], [-117.46709, 33.96066], [-117.46883, 33.96132], [-117.46884, 33.96162], [-117.47095, 33.96164], [-117.47638, 33.96163], [-117.47641, 33.96253], [-117.4789, 33.96253], [-117.47887, 33.96481], [-117.47972, 33.96482], [-117.47977, 33.96254], [-117.48076, 33.96254], [-117.48077, 33.96164], [-117.48403, 33.96166], [-117.48405, 33.96075], [-117.48731, 33.96077], [-117.48732, 33.9605], [-117.49316, 33.96053], [-117.49311, 33.96121], [-117.49543, 33.96154], [-117.49849, 33.96316], [-117.49981, 33.96326], [-117.50044, 33.96291], [-117.50023, 33.96235], [-117.50322, 33.96165], [-117.50579, 33.96291], [-117.50662, 33.9634], [-117.51029, 33.96284], [-117.51273, 33.96201], [-117.51499, 33.96194], [-117.51499, 33.96243], [-117.51546, 33.96243], [-117.51546, 33.9628], [-117.51574, 33.96299], [-117.51821, 33.9628], [-117.52417, 33.95936], [-117.5254, 33.9605], [-117.52537, 33.96097], [-117.5254, 33.96098], [-117.52541, 33.96645]]]} | No Public Access 3 | 1798 | Hidden Valley | 32185 | 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 | Riverside 10 | 1299.756 | Hidden Valley | 0 | State Resource Management Area 55 | 3 | |
545 | 545 | 544 | {"type": "Polygon", "coordinates": [[[-122.31307, 41.2763], [-122.31264, 41.2763], [-122.31266, 41.2752], [-122.31307, 41.2752], [-122.31307, 41.2763]]]} | No Public Access 3 | 1814 | Lower Box Canyon | 32208 | 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.061 | Lower Box Canyon | 0 | State Resource Management Area 55 | 3 | |
6397 | 6397 | 6396 | {"type": "Polygon", "coordinates": [[[-122.11544, 38.38481], [-122.11085, 38.38485], [-122.11091, 38.38267], [-122.11093, 38.38014], [-122.111, 38.37767], [-122.09259, 38.37779], [-122.09265, 38.37418], [-122.09308, 38.37371], [-122.09356, 38.37334], [-122.0949, 38.37217], [-122.09681, 38.3721], [-122.0983, 38.37151], [-122.09981, 38.37125], [-122.10093, 38.37053], [-122.10295, 38.36978], [-122.10869, 38.36903], [-122.10856, 38.36776], [-122.10988, 38.36786], [-122.11024, 38.36696], [-122.11195, 38.3669], [-122.11229, 38.36599], [-122.11168, 38.36504], [-122.11442, 38.36431], [-122.11479, 38.36369], [-122.11499, 38.36371], [-122.11581, 38.36318], [-122.11586, 38.36198], [-122.11638, 38.36158], [-122.11721, 38.36118], [-122.11751, 38.36079], [-122.11748, 38.35989], [-122.11809, 38.35895], [-122.11957, 38.35813], [-122.11997, 38.35753], [-122.12053, 38.35653], [-122.12122, 38.35702], [-122.12167, 38.35723], [-122.12188, 38.35576], [-122.12341, 38.35574], [-122.12355, 38.35555], [-122.12382, 38.35544], [-122.1243, 38.35538], [-122.12565, 38.35533], [-122.1258, 38.35478], [-122.12584, 38.35485], [-122.12745, 38.35453], [-122.12788, 38.35542], [-122.12782, 38.35783], [-122.1305, 38.35809], [-122.13208, 38.35914], [-122.13312, 38.35871], [-122.135, 38.35888], [-122.13607, 38.35969], [-122.13737, 38.36011], [-122.13806, 38.36013], [-122.14092, 38.36156], [-122.14146, 38.36186], [-122.143, 38.3619], [-122.14372, 38.36113], [-122.14487, 38.36143], [-122.14617, 38.36078], [-122.147, 38.36125], [-122.14761, 38.36115], [-122.14965, 38.36007], [-122.15036, 38.35989], [-122.15096, 38.35888], [-122.1527, 38.3596], [-122.15299, 38.36046], [-122.15403, 38.36153], [-122.15406, 38.36222], [-122.15549, 38.36355], [-122.15126, 38.36401], [-122.14689, 38.36435], [-122.14511, 38.36421], [-122.14503, 38.36891], [-122.14499, 38.37022], [-122.14326, 38.37027], [-122.14325, 38.37093], [-122.1428, 38.37066], [-122.1427, 38.37054], [-122.14273, 38.37046], [-122.144, 38.36923], [-122.14424, 38.36897], [-122.14443, 38.36844], [-122.14445, 38.3679], [-122.14446, 38.36562], [-122.1444, 38.36532], [-122.14435, 38.36515], [-122.14429, 38.36501], [-122.14417, 38.36482], [-122.14391, 38.36448], [-122.14354, 38.36412], [-122.14318, 38.36382], [-122.14297, 38.36374], [-122.14284, 38.36373], [-122.14244, 38.36385], [-122.14209, 38.36392], [-122.14187, 38.36391], [-122.14154, 38.36376], [-122.14118, 38.36349], [-122.14045, 38.36313], [-122.13997, 38.36301], [-122.13964, 38.36301], [-122.13927, 38.36294], [-122.13906, 38.3628], [-122.13852, 38.36235], [-122.13817, 38.36222], [-122.13659, 38.36209], [-122.13516, 38.36173], [-122.13481, 38.36166], [-122.13475, 38.36158], [-122.13454, 38.36146], [-122.13414, 38.3614], [-122.13386, 38.36137], [-122.13364, 38.36141], [-122.13331, 38.3614], [-122.13301, 38.36147], [-122.13241, 38.36148], [-122.13123, 38.36138], [-122.13061, 38.3614], [-122.13022, 38.36131], [-122.13003, 38.36124], [-122.12971, 38.36105], [-122.12947, 38.36072], [-122.1293, 38.36005], [-122.129, 38.35959], [-122.12873, 38.35958], [-122.12898, 38.36], [-122.12913, 38.36022], [-122.12914, 38.36054], [-122.12938, 38.36098], [-122.1296, 38.36121], [-122.12991, 38.36141], [-122.13045, 38.36156], [-122.13104, 38.36158], [-122.13157, 38.36156], [-122.13253, 38.36165], [-122.13312, 38.36166], [-122.13337, 38.36161], [-122.13369, 38.36158], [-122.13388, 38.36154], [-122.13442, 38.36164], [-122.13455, 38.36169], [-122.13468, 38.3618], [-122.13497, 38.36189], [-122.13563, 38.362], [-122.13632, 38.36221], [-122.13678, 38.36228], [-122.1372, 38.36229], [-122.13787, 38.36233], [-122.1382, 38.36239], [-122.13839, 38.36248], [-122.13855, 38.36259], [-122.1387, 38.36274], [-122.13879, 38.36286], [-122.13904, 38.36302], [-122.13927, 38.36312], [-122.13961, 38.36316], [-122.13991, 38.36317], [-122.14057, 38.36336], [-122.14122, 38.36376], [-122.14166, 38.364], [-122.14198, 38.36408], [-122.14226, 38.36404], [-122.14281, 38.36389], [-122.14295, 38.3639], [-122.14322, 38.3641], [-122.14346, 38.36433], [-122.14384, 38.36478], [-122.14404, 38.36509], [-122.14416, 38.36534], [-122.14421, 38.36561], [-122.14423, 38.36687], [-122.14423, 38.3675], [-122.1442, 38.36834], [-122.14405, 38.36879], [-122.1438, 38.36917], [-122.14325, 38.36964], [-122.14279, 38.37007], [-122.14257, 38.37033], [-122.14249, 38.3705], [-122.14253, 38.37065], [-122.14267, 38.37084], [-122.14288, 38.37096], [-122.14325, 38.3711], [-122.14328, 38.37163], [-122.14394, 38.37239], [-122.14249, 38.37349], [-122.14246, 38.37491], [-122.13816, 38.37472], [-122.13819, 38.37527], [-122.13871, 38.37775], [-122.13877, 38.38821], [-122.13876, 38.39117], [-122.13879, 38.39262], [-122.13883, 38.39836], [-122.13884, 38.40294], [-122.13429, 38.40294], [-122.12538, 38.40262], [-122.1252, 38.39908], [-122.11618, 38.39882], [-122.11535, 38.38839], [-122.11825, 38.38838], [-122.12002, 38.38842], [-122.12, 38.38757], [-122.12008, 38.38554], [-122.12007, 38.38483], [-122.1174, 38.38474], [-122.11544, 38.38481]]]} | No Public Access 3 | 1835 | Lake Curry | 20880 | 1365 | Vallejo, City of 531 | City 2 | City Agency 2 | http://www.ci.vallejo.ca.us/attractions___events/sports___recreation/parks___trails | City 2 | 1365 | Vallejo, City of 524 | City 2 | City Agency 2 | Napa 11 | 3148.149 | Lake Curry | 0 | None 520 | ||
6428 | 6428 | 6427 | {"type": "Polygon", "coordinates": [[[-121.33786, 36.47151], [-121.33187, 36.47323], [-121.3318, 36.46281], [-121.3377, 36.46284], [-121.33786, 36.47151]]]} | No Public Access 3 | 1938 | Windmill Property | 27628 | 1336 | Soledad, City of 485 | City 2 | City Agency 2 | http://www.cityofsoledad.com/ | City 2 | 1336 | Soledad, City of 476 | City 2 | City Agency 2 | Monterey 14 | 139.773 | Windmill Property | 0 | Local Other or Unknown 14 | 4 | |
6462 | 6462 | 6461 | {"type": "Polygon", "coordinates": [[[-116.18721, 33.15378], [-116.18628, 33.1536], [-116.18497, 33.1533], [-116.18496, 33.15281], [-116.18721, 33.15378]]]} | No Public Access 3 | 2055 | Hwy 78 scenic corridor | 20163 | 3004 | Anza-Borrego Foundation 836 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.theabf.org/ | Non Governmental Organization 10 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | San Diego 4 | 1.475 | Hwy 78 scenic corridor | None 522 | |||
6475 | 6475 | 6474 | {"type": "Polygon", "coordinates": [[[-121.89617, 38.24991], [-121.89615, 38.24998], [-121.87929, 38.26469], [-121.87398, 38.27128], [-121.87387, 38.27167], [-121.86064, 38.27158], [-121.84224, 38.27129], [-121.8423, 38.26401], [-121.85159, 38.26407], [-121.85163, 38.25686], [-121.86065, 38.25686], [-121.87945, 38.25708], [-121.87968, 38.24283], [-121.88134, 38.24278], [-121.88895, 38.24283], [-121.88894, 38.24989], [-121.89617, 38.24991]]]} | No Public Access 3 | 2063 | Wilcox Ranch | 27495 | 3081 | Solano Land Trust 361 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.solanolandtrust.org/ | Non Governmental Organization 10 | 3081 | Solano Land Trust 358 | Non Profit 6 | Non Profit - Land Trust 10 | Solano 26 | 1547.196 | Wilcox Ranch | 0 | Private Conservation 16 | 2 | |
4842 | 4842 | 4841 | {"type": "Polygon", "coordinates": [[[-122.70265, 38.97554], [-122.70213, 38.97651], [-122.7016, 38.97676], [-122.7006, 38.97679], [-122.70085, 38.97617], [-122.70146, 38.9756], [-122.70265, 38.97554]]]} | No Public Access 3 | 2140 | Monitor Island | 32231 | 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 | 3.761 | Monitor Island | 0 | State Resource Management Area 55 | 3 | |
6485 | 6485 | 6484 | {"type": "Polygon", "coordinates": [[[-122.42915, 37.4505], [-122.42441, 37.45111], [-122.4237, 37.44771], [-122.42139, 37.44799], [-122.42207, 37.45138], [-122.4212, 37.45156], [-122.42026, 37.45163], [-122.41984, 37.45193], [-122.41916, 37.452], [-122.41923, 37.45223], [-122.41992, 37.45214], [-122.42031, 37.45205], [-122.42084, 37.45209], [-122.42128, 37.4518], [-122.42193, 37.45165], [-122.4223, 37.45195], [-122.42254, 37.45206], [-122.4228, 37.45208], [-122.42311, 37.45277], [-122.42398, 37.45264], [-122.42399, 37.45263], [-122.42372, 37.4514], [-122.42444, 37.4513], [-122.42444, 37.45125], [-122.42633, 37.45099], [-122.42851, 37.45072], [-122.42907, 37.45498], [-122.42591, 37.45537], [-122.42568, 37.45538], [-122.42558, 37.45561], [-122.42569, 37.45571], [-122.42605, 37.45582], [-122.42616, 37.45584], [-122.42625, 37.45595], [-122.42609, 37.45635], [-122.42603, 37.45668], [-122.41578, 37.4606], [-122.408, 37.46048], [-122.40801, 37.45877], [-122.40418, 37.45874], [-122.40414, 37.45875], [-122.40427, 37.45048], [-122.4043, 37.44593], [-122.40543, 37.44648], [-122.40559, 37.44648], [-122.40784, 37.44778], [-122.4083, 37.4482], [-122.40899, 37.44868], [-122.40932, 37.44881], [-122.41017, 37.44867], [-122.4107, 37.44888], [-122.41093, 37.44901], [-122.41267, 37.44709], [-122.41194, 37.44597], [-122.41278, 37.44544], [-122.41639, 37.44072], [-122.4184, 37.44079], [-122.41862, 37.44125], [-122.4204, 37.44107], [-122.42062, 37.44148], [-122.42765, 37.44089], [-122.42869, 37.44843], [-122.42885, 37.44915], [-122.42904, 37.44987], [-122.42915, 37.4505]]]} | No Public Access 3 | 2314 | Johnston Ranch | 20484 | 3054 | Peninsula Open Space Trust 338 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.openspacetrust.org/ | Non Governmental Organization 10 | 3054 | Peninsula Open Space Trust 335 | Non Profit 6 | Non Profit - Land Trust 10 | San Mateo 15 | 868.418 | Johnston Ranch | 0 | Private Conservation 16 | 2 | |
6493 | 6493 | 6492 | {"type": "Polygon", "coordinates": [[[-120.12173, 36.2483], [-120.12148, 36.2483], [-120.12147, 36.24807], [-120.10457, 36.24812], [-120.10456, 36.24822], [-120.10395, 36.24822], [-120.10394, 36.2482], [-120.10338, 36.24816], [-120.10321, 36.24807], [-120.08575, 36.24814], [-120.08572, 36.25219], [-120.08397, 36.25081], [-120.08324, 36.25055], [-120.08275, 36.25016], [-120.08242, 36.2498], [-120.07876, 36.24666], [-120.07738, 36.24531], [-120.07628, 36.2438], [-120.07409, 36.24039], [-120.07219, 36.23723], [-120.06988, 36.23366], [-120.06783, 36.23367], [-120.06784, 36.23047], [-120.06518, 36.22639], [-120.06119, 36.22002], [-120.05967, 36.22059], [-120.05947, 36.22022], [-120.06106, 36.2196], [-120.06106, 36.21959], [-120.05979, 36.21789], [-120.05716, 36.21086], [-120.05712, 36.21066], [-120.05696, 36.21019], [-120.05185, 36.1961], [-120.05042, 36.19239], [-120.04902, 36.18883], [-120.0482, 36.18882], [-120.0484, 36.18167], [-120.05002, 36.18159], [-120.05751, 36.18176], [-120.05747, 36.18776], [-120.05533, 36.18777], [-120.05526, 36.18884], [-120.05085, 36.18883], [-120.05084, 36.18884], [-120.05225, 36.19238], [-120.05722, 36.19239], [-120.05722, 36.196], [-120.05384, 36.19606], [-120.05383, 36.19608], [-120.05892, 36.21036], [-120.0594, 36.21066], [-120.06768, 36.21071], [-120.06771, 36.21712], [-120.08038, 36.21218], [-120.08246, 36.21139], [-120.08563, 36.21136], [-120.08582, 36.22637], [-120.091, 36.22637], [-120.10353, 36.22642], [-120.12169, 36.22629], [-120.12169, 36.2408], [-120.12173, 36.2483]]]} | No Public Access 3 | 2352 | Arroyo Pasajero Westside Detention Basin | 15624 | 207 | California Department of Water Resources 477 | State 5 | State Agency 5 | http://www.water.ca.gov/ | Other State 5 | 207 | California Department of Water Resources 470 | State 5 | State Agency 5 | Fresno 9 | 3819.876 | Arroyo Pasajero Westside Detention Basin | None 524 | |||
15565 | 15565 | 15564 | {"type": "Polygon", "coordinates": [[[-122.23821, 37.49916], [-122.23884, 37.49964], [-122.24115, 37.5016], [-122.24307, 37.50329], [-122.24334, 37.50312], [-122.24409, 37.50378], [-122.24397, 37.50388], [-122.24419, 37.50407], [-122.24432, 37.50399], [-122.24458, 37.50422], [-122.24447, 37.5043], [-122.24446, 37.50432], [-122.24468, 37.50451], [-122.24481, 37.50443], [-122.24618, 37.50566], [-122.24606, 37.50575], [-122.24628, 37.50595], [-122.24562, 37.50643], [-122.24251, 37.50367], [-122.23994, 37.50551], [-122.24256, 37.50787], [-122.24216, 37.50788], [-122.24137, 37.50795], [-122.24041, 37.50791], [-122.23934, 37.50779], [-122.23901, 37.50769], [-122.23865, 37.50741], [-122.23809, 37.50775], [-122.23815, 37.5079], [-122.23796, 37.50807], [-122.23743, 37.50801], [-122.23714, 37.50802], [-122.23677, 37.50794], [-122.23623, 37.50776], [-122.23566, 37.50748], [-122.23556, 37.50727], [-122.23495, 37.50712], [-122.23456, 37.50689], [-122.23402, 37.50679], [-122.23243, 37.50611], [-122.23102, 37.50574], [-122.23027, 37.50549], [-122.22934, 37.50497], [-122.22894, 37.50458], [-122.22864, 37.50415], [-122.22815, 37.50366], [-122.22781, 37.50279], [-122.22773, 37.50232], [-122.22712, 37.50151], [-122.2261, 37.50079], [-122.22503, 37.50015], [-122.22494, 37.5003], [-122.22459, 37.5004], [-122.22486, 37.50102], [-122.22469, 37.50103], [-122.22456, 37.50109], [-122.22447, 37.5011], [-122.22336, 37.49821], [-122.21968, 37.49817], [-122.21976, 37.4979], [-122.22358, 37.49793], [-122.22364, 37.49767], [-122.22378, 37.49741], [-122.22393, 37.49721], [-122.22412, 37.49704], [-122.2243, 37.49691], [-122.22714, 37.49518], [-122.22728, 37.49534], [-122.22445, 37.49707], [-122.22422, 37.49724], [-122.22405, 37.49742], [-122.22391, 37.49764], [-122.22382, 37.49787], [-122.2238, 37.49813], [-122.23182, 37.49814], [-122.23176, 37.49823], [-122.23135, 37.49871], [-122.23132, 37.49883], [-122.23133, 37.49889], [-122.23137, 37.49895], [-122.23142, 37.499], [-122.23149, 37.49904], [-122.23155, 37.49918], [-122.23183, 37.49924], [-122.23201, 37.49918], [-122.23217, 37.49876], [-122.23249, 37.49825], [-122.23258, 37.49814], [-122.23676, 37.49811], [-122.23821, 37.49916]]]} | No Public Access 3 | 2389 | Bair Island Ecological Reserve | 15764 | 106 | United States Fish and Wildlife Service 45 | Federal 1 | Federal Agency 1 | http://www.fws.gov/ | US Fish and Wildlife Service 8 | 106 | United States Fish and Wildlife Service 44 | Federal 1 | Federal Agency 1 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Bair-Island-ER | San Mateo 15 | 303.484 | Bair Island ER | 1986 | Conservation Area 13 | 2 |
535 | 535 | 534 | {"type": "Polygon", "coordinates": [[[-121.91117, 36.50829], [-121.9087, 36.50828], [-121.9087, 36.50744], [-121.9081, 36.50743], [-121.90839, 36.50686], [-121.90839, 36.50628], [-121.90807, 36.50595], [-121.90715, 36.50527], [-121.90671, 36.50464], [-121.91113, 36.50468], [-121.91117, 36.50829]]]} | No Public Access 3 | 2572 | Canavarro | 16797 | 3008 | Big Sur Land Trust 173 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.bigsurlandtrust.org | Non Governmental Organization 10 | 3008 | Big Sur Land Trust 169 | Non Profit 6 | Non Profit - Land Trust 10 | Monterey 14 | 27.752 | Canavarro | 0 | Private Conservation 16 | 2 | |
6527 | 6527 | 6526 | {"type": "Polygon", "coordinates": [[[-121.21611, 38.65634], [-121.21517, 38.65635], [-121.2144, 38.65533], [-121.21395, 38.65428], [-121.21608, 38.65427], [-121.21611, 38.65634]]]} | No Public Access 3 | 2848 | Phoenix Field Ecological Reserve | 32261 | 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 | 8.007 | Phoenix Field ER | 0 | State Conservation Area 8 | 2 | |
6413 | 6413 | 6412 | {"type": "Polygon", "coordinates": [[[-121.93361, 36.54372], [-121.93342, 36.54391], [-121.9333, 36.54419], [-121.93338, 36.54444], [-121.93337, 36.54452], [-121.93334, 36.54453], [-121.93305, 36.54443], [-121.93288, 36.54441], [-121.93264, 36.54448], [-121.9325, 36.54447], [-121.93239, 36.54448], [-121.93237, 36.54438], [-121.93252, 36.54434], [-121.93284, 36.54436], [-121.93292, 36.54428], [-121.9331, 36.54428], [-121.93338, 36.54376], [-121.93361, 36.54372]]]} | No Public Access 3 | 3340 | Carmel Point | 16873 | 3008 | Big Sur Land Trust 173 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.bigsurlandtrust.org | Non Governmental Organization 10 | 3008 | Big Sur Land Trust 169 | Non Profit 6 | Non Profit - Land Trust 10 | Monterey 14 | 0.545 | Carmel Point | 0 | Private Conservation 16 | 2 | |
6559 | 6559 | 6558 | {"type": "Polygon", "coordinates": [[[-122.25538, 38.00159], [-122.25435, 38.00281], [-122.25412, 38.00263], [-122.25336, 38.00223], [-122.25278, 38.00201], [-122.25257, 38.00201], [-122.25192, 38.00158], [-122.25156, 38.00143], [-122.25141, 38.00151], [-122.25101, 38.00123], [-122.25072, 38.00116], [-122.2507, 38.00114], [-122.25022, 38.00086], [-122.25, 38.00083], [-122.24938, 38.00053], [-122.24896, 38.00066], [-122.24856, 38.00072], [-122.24827, 38.00072], [-122.24798, 38.00065], [-122.24767, 38.00048], [-122.24734, 38.00021], [-122.24715, 37.99991], [-122.24686, 37.99835], [-122.24698, 37.99805], [-122.24718, 37.9979], [-122.24752, 37.99777], [-122.24733, 37.99736], [-122.2477, 37.99706], [-122.24827, 37.99756], [-122.24917, 37.99858], [-122.24991, 37.99904], [-122.25092, 37.99953], [-122.25097, 37.99964], [-122.2513, 37.99978], [-122.25136, 37.99971], [-122.25169, 37.99986], [-122.25173, 37.99985], [-122.25202, 38.0], [-122.25509, 38.00144], [-122.25538, 38.00159]]]} | No Public Access 3 | 3421 | Hercules | 19832 | 1133 | Hercules, City of 354 | City 2 | City Agency 2 | http://www.ci.hercules.ca.us/index.aspx?page=166 | City 2 | 1133 | Hercules, City of 351 | City 2 | City Agency 2 | Contra Costa 12 | 37.784 | Hercules | None 526 | |||
6562 | 6562 | 6561 | {"type": "MultiPolygon", "coordinates": [[[[-122.36595, 40.50811], [-122.36457, 40.50963], [-122.36317, 40.51062], [-122.36286, 40.51141], [-122.36171, 40.51207], [-122.36145, 40.5119], [-122.36142, 40.51191], [-122.36049, 40.5114], [-122.35933, 40.51101], [-122.35937, 40.5084], [-122.36377, 40.50797], [-122.3654, 40.50806], [-122.36595, 40.50811]]], [[[-122.37348, 40.55551], [-122.3734, 40.55564], [-122.37337, 40.55586], [-122.37338, 40.55617], [-122.37197, 40.55594], [-122.37218, 40.55527], [-122.37348, 40.55551]]]]} | No Public Access 3 | 3435 | Sacramento River -- Redding | 32284 | 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 | 40.985 | Sacramento River -- Redding | 0 | State Resource Management Area 55 | 3 | |
6548 | 6548 | 6547 | {"type": "Polygon", "coordinates": [[[-122.27836, 38.16698], [-122.27244, 38.16694], [-122.27213, 38.16617], [-122.26881, 38.16606], [-122.26808, 38.16422], [-122.27137, 38.16431], [-122.27832, 38.16431], [-122.27836, 38.16698]]]} | No Public Access 3 | 3636 | American Canyon Property | 15448 | 1005 | American Canyon, City of 434 | City 2 | City Agency 2 | http://cityofamericancanyon.org/city-departments/parks-recreation | City 2 | 1005 | American Canyon, City of 428 | City 2 | City Agency 2 | Napa 11 | 55.469 | American Canyon Property | 0 | Local Other or Unknown 14 | 4 | |
6583 | 6583 | 6582 | {"type": "Polygon", "coordinates": [[[-116.4581, 33.88588], [-116.45809, 33.88852], [-116.44949, 33.88855], [-116.44946, 33.88418], [-116.45197, 33.88413], [-116.45236, 33.88407], [-116.45273, 33.88394], [-116.45288, 33.88386], [-116.45302, 33.88378], [-116.45327, 33.88357], [-116.45338, 33.88346], [-116.45357, 33.88321], [-116.45371, 33.88285], [-116.45372, 33.88278], [-116.45374, 33.88679], [-116.45483, 33.88678], [-116.45484, 33.88588], [-116.4581, 33.88588]]]} | No Public Access 3 | 3932 | Edom Hill-Willow Hole Preserve | 18455 | 3025 | Friends of the Desert Mountains 281 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.desertmountains.org/ | Non Governmental Organization 10 | 3025 | Friends of the Desert Mountains 277 | Non Profit 6 | Non Profit - Land Trust 10 | Riverside 10 | 75.777 | Edom Hill-Willow Hole Preserve | 0 | Private Conservation 16 | 2 | |
710 | 710 | 709 | {"type": "Polygon", "coordinates": [[[-122.49778, 38.11503], [-122.49513, 38.11705], [-122.49391, 38.11801], [-122.49231, 38.1192], [-122.49241, 38.1189], [-122.49275, 38.11856], [-122.49311, 38.11825], [-122.49339, 38.11787], [-122.49376, 38.11735], [-122.49389, 38.11699], [-122.49396, 38.11668], [-122.49396, 38.11519], [-122.49778, 38.11503]]]} | No Public Access 3 | 4004 | Sonoma Baylands | 25607 | 100 | United States Army Corps of Engineers 146 | Federal 1 | Federal Agency 1 | http://www.usace.army.mil/ | Other Federal 13 | 100 | United States Army Corps of Engineers 142 | Federal 1 | Federal Agency 1 | Sonoma 16 | 14.555 | Sonoma Baylands | None 66 | |||
6593 | 6593 | 6592 | {"type": "Polygon", "coordinates": [[[-122.82446, 38.42544], [-122.82442, 38.42578], [-122.82442, 38.42666], [-122.82445, 38.42934], [-122.8235, 38.42949], [-122.82314, 38.42952], [-122.82295, 38.42956], [-122.82253, 38.42973], [-122.82216, 38.43], [-122.82202, 38.43006], [-122.82193, 38.43014], [-122.82177, 38.43018], [-122.82162, 38.43024], [-122.82125, 38.43031], [-122.82113, 38.43037], [-122.82108, 38.43037], [-122.82099, 38.43033], [-122.82089, 38.43032], [-122.82052, 38.43008], [-122.82053, 38.42921], [-122.82048, 38.4251], [-122.82049, 38.42439], [-122.82216, 38.42482], [-122.82446, 38.42544]]]} | No Public Access 3 | 4022 | Stone Farm | 25869 | 1324 | Santa Rosa, City of 30 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | Sonoma 16 | 46.388 | Stone Farm | None 531 | |||
6597 | 6597 | 6596 | {"type": "MultiPolygon", "coordinates": [[[[-122.81587, 38.40123], [-122.81272, 38.40264], [-122.81266, 38.4026], [-122.81259, 38.40252], [-122.81251, 38.40232], [-122.8125, 38.40212], [-122.81253, 38.40196], [-122.81251, 38.40187], [-122.81245, 38.40185], [-122.81236, 38.40191], [-122.81224, 38.40206], [-122.81216, 38.4022], [-122.81215, 38.40227], [-122.8122, 38.40247], [-122.81207, 38.40279], [-122.81206, 38.40286], [-122.8121, 38.40292], [-122.80774, 38.40488], [-122.80551, 38.40586], [-122.80424, 38.40644], [-122.80102, 38.40784], [-122.8008, 38.40792], [-122.80001, 38.40832], [-122.79906, 38.40885], [-122.79838, 38.40919], [-122.79601, 38.41007], [-122.79446, 38.41071], [-122.79431, 38.4105], [-122.7948, 38.41031], [-122.79481, 38.4103], [-122.79469, 38.41013], [-122.79451, 38.41029], [-122.79424, 38.4104], [-122.79317, 38.40885], [-122.79019, 38.40445], [-122.79012, 38.40432], [-122.78868, 38.40221], [-122.7934, 38.40115], [-122.81277, 38.39668], [-122.81331, 38.39672], [-122.81342, 38.39753], [-122.81363, 38.39754], [-122.81382, 38.39773], [-122.81484, 38.39865], [-122.81524, 38.39907], [-122.8155, 38.39927], [-122.8156, 38.39953], [-122.81568, 38.40008], [-122.81565, 38.40089], [-122.81569, 38.40107], [-122.81573, 38.40118], [-122.81584, 38.40118], [-122.81587, 38.40123]], [[-122.79167, 38.40561], [-122.7905, 38.40387], [-122.79017, 38.40335], [-122.79015, 38.40335], [-122.79016, 38.40341], [-122.79022, 38.40352], [-122.79161, 38.40558], [-122.79166, 38.40564], [-122.79167, 38.40561]], [[-122.79449, 38.40986], [-122.7939, 38.40892], [-122.79355, 38.40842], [-122.7932, 38.40791], [-122.79289, 38.40741], [-122.79257, 38.40696], [-122.79309, 38.40795], [-122.79429, 38.41005], [-122.7943, 38.41005], [-122.79449, 38.40986]]], [[[-122.81641, 38.40121], [-122.81554, 38.4016], [-122.81554, 38.40315], [-122.81577, 38.40353], [-122.8131, 38.40439], [-122.80605, 38.40685], [-122.79987, 38.40907], [-122.79972, 38.40883], [-122.80116, 38.40807], [-122.80147, 38.40794], [-122.80163, 38.40819], [-122.80555, 38.4068], [-122.80919, 38.40545], [-122.81179, 38.40453], [-122.81179, 38.40451], [-122.81153, 38.40448], [-122.81074, 38.40427], [-122.81033, 38.40411], [-122.81012, 38.40399], [-122.81108, 38.40358], [-122.81322, 38.40262], [-122.81613, 38.40122], [-122.81641, 38.40121]]]]} | No Public Access 3 | 4034 | Brown Farm | 16443 | 1324 | Santa Rosa, City of 30 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | Sonoma 16 | 468.322 | Brown Farm | None 532 |
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]);