units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
517 rows where MNG_AG_TYP = 1 sorted by AGNCY_ID descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV, AGNCY_TYP
DES_TP >30
- National Forest 96
- National Public Lands 75
- National Wildlife Refuge 70
- Recreation Management Area 61
- National Recreation Area 34
- National Park 26
- Resource Management Area 26
- National Monument or Landmark 24
- Federal Other or Unknown 24
- Conservation Area 14
- Wilderness Area 7
- Area of Critical Environmental Concern 7
- Historic or Cultural Area 5
- Research or Educational Area 3
- None 1
- None 1
- None 1
- None 1
- National Lakeshore or Seashore 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- …
AGNCY_ID 13 ✖
MNG_AGENCY 9
- United States Bureau of Land Management 121
- United States Forest Service 111
- United States National Park Service 89
- United States Fish and Wildlife Service 82
- United States Army Corps of Engineers 52
- United States Bureau of Reclamation 29
- Other Federal 19
- United States Coast Guard 8
- United States Department of Defense 6
ACCESS_TYP 4
- Open Access 397
- Restricted Access 81
- No Public Access 33
- Unknown Access 6
MNG_AG_TYP 1
- Federal Agency · 517 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4900 | 4900 | 4899 | {"type": "MultiPolygon", "coordinates": [[[[-119.58205, 35.03769], [-119.58205, 35.03947], [-119.57943, 35.03945], [-119.57943, 35.03856], [-119.57987, 35.03856], [-119.57987, 35.03767], [-119.58205, 35.03769]]], [[[-119.65938, 35.07435], [-119.65054, 35.0743], [-119.65055, 35.07064], [-119.65937, 35.07068], [-119.65938, 35.07435]]], [[[-119.66381, 35.05124], [-119.65933, 35.05122], [-119.65933, 35.05079], [-119.66381, 35.05081], [-119.66381, 35.05124]]], [[[-119.668, 35.06179], [-119.66383, 35.06179], [-119.66383, 35.05996], [-119.668, 35.05998], [-119.668, 35.06179]]], [[[-119.67246, 35.07075], [-119.67246, 35.07441], [-119.66801, 35.07439], [-119.66801, 35.07073], [-119.67246, 35.07075]]]]} | Open Access 1 | 48252 | Carrizo Plain National Monument | 16914 | 3076 | Sequoia Riverlands Trust 109 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sequoiariverlands.org | Non Governmental Organization 10 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | San Luis Obispo 1 | 156.064 | Carrizo Plain NM | 2001 | National Monument or Landmark 80 | 3 | |
16430 | 16430 | 16429 | {"type": "MultiPolygon", "coordinates": [[[[-117.09275, 32.55093], [-117.08419, 32.55089], [-117.08418, 32.54718], [-117.0885, 32.54724], [-117.08851, 32.54815], [-117.09275, 32.54817], [-117.09274, 32.54879], [-117.09275, 32.55093]]], [[[-117.10589, 32.55459], [-117.10142, 32.55462], [-117.0993, 32.55461], [-117.09923, 32.55817], [-117.09713, 32.55816], [-117.09714, 32.55461], [-117.09632, 32.5546], [-117.09634, 32.55816], [-117.09383, 32.55815], [-117.09383, 32.55778], [-117.09285, 32.55777], [-117.09287, 32.54879], [-117.09289, 32.5476], [-117.09288, 32.54732], [-117.1016, 32.54732], [-117.10155, 32.54367], [-117.10156, 32.53999], [-117.10318, 32.53998], [-117.10318, 32.54033], [-117.10459, 32.54111], [-117.1046, 32.54365], [-117.10584, 32.54365], [-117.10585, 32.54377], [-117.10576, 32.54378], [-117.10576, 32.54731], [-117.10584, 32.54732], [-117.10583, 32.55098], [-117.10589, 32.55459]]], [[[-117.11232, 32.54729], [-117.11231, 32.55095], [-117.11011, 32.55096], [-117.11016, 32.54731], [-117.11232, 32.54729]]]]} | Open Access 1 | 45291 | Tijuana River Valley Regional Park | 26362 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 106 | United States Fish and Wildlife Service 44 | Federal 1 | Federal Agency 1 | http://www.sdparks.org/content/sdparks/en/park-pages/TJRVRP.html | San Diego 4 | 451.08 | Tijuana River Valley RP | None 1401 | ||
15853 | 15853 | 15852 | {"type": "Polygon", "coordinates": [[[-122.40701, 38.1558], [-122.4061, 38.15579], [-122.40609, 38.15581], [-122.40612, 38.15588], [-122.40423, 38.15594], [-122.40393, 38.15584], [-122.3963, 38.15586], [-122.36626, 38.15587], [-122.36687, 38.15482], [-122.36715, 38.15402], [-122.36716, 38.1538], [-122.36714, 38.15358], [-122.36709, 38.15336], [-122.36705, 38.15322], [-122.36685, 38.15288], [-122.36669, 38.15269], [-122.36638, 38.15247], [-122.36605, 38.1523], [-122.36565, 38.15225], [-122.36541, 38.15224], [-122.36505, 38.15233], [-122.36429, 38.15258], [-122.36438, 38.15181], [-122.36434, 38.15055], [-122.36431, 38.14595], [-122.36426, 38.14285], [-122.36434, 38.14207], [-122.36437, 38.14169], [-122.36576, 38.14221], [-122.36811, 38.14332], [-122.3696, 38.14394], [-122.37114, 38.14428], [-122.3755, 38.14554], [-122.37617, 38.14592], [-122.37659, 38.14629], [-122.37756, 38.14698], [-122.37939, 38.14793], [-122.38052, 38.14854], [-122.38053, 38.14853], [-122.38055, 38.14606], [-122.38003, 38.14598], [-122.37858, 38.14525], [-122.37742, 38.14504], [-122.37609, 38.14458], [-122.37307, 38.14323], [-122.36585, 38.14046], [-122.36362, 38.13981], [-122.36295, 38.13953], [-122.36133, 38.13896], [-122.36078, 38.13868], [-122.3602, 38.13857], [-122.35958, 38.13826], [-122.35892, 38.1379], [-122.35782, 38.13749], [-122.35577, 38.13678], [-122.35534, 38.13661], [-122.35486, 38.13658], [-122.35396, 38.13625], [-122.35318, 38.136], [-122.35183, 38.13539], [-122.35053, 38.13484], [-122.34938, 38.13437], [-122.34845, 38.13391], [-122.34763, 38.13358], [-122.3463, 38.13314], [-122.34561, 38.13282], [-122.34488, 38.13241], [-122.34449, 38.13229], [-122.34435, 38.13223], [-122.34434, 38.13224], [-122.34433, 38.13458], [-122.33483, 38.13109], [-122.32238, 38.12607], [-122.31734, 38.12411], [-122.31156, 38.12166], [-122.31076, 38.12118], [-122.30995, 38.12073], [-122.30911, 38.1203], [-122.30825, 38.1199], [-122.30738, 38.11952], [-122.30649, 38.11916], [-122.30559, 38.11883], [-122.30467, 38.11852], [-122.30374, 38.11824], [-122.30162, 38.11788], [-122.30003, 38.11771], [-122.29842, 38.11765], [-122.29514, 38.11767], [-122.29517, 38.12202], [-122.29391, 38.12176], [-122.29147, 38.12115], [-122.29096, 38.12095], [-122.28991, 38.12067], [-122.28949, 38.1205], [-122.28948, 38.12051], [-122.28961, 38.12104], [-122.28905, 38.12096], [-122.28843, 38.12096], [-122.28752, 38.12099], [-122.28684, 38.12105], [-122.28634, 38.12112], [-122.28545, 38.12115], [-122.28516, 38.12112], [-122.28475, 38.12104], [-122.28445, 38.12092], [-122.28428, 38.12081], [-122.28424, 38.12066], [-122.28424, 38.12054], [-122.28442, 38.12047], [-122.28489, 38.12022], [-122.2849, 38.12015], [-122.28483, 38.12013], [-122.28473, 38.12014], [-122.28458, 38.1202], [-122.28436, 38.12025], [-122.28389, 38.12032], [-122.28372, 38.12027], [-122.28358, 38.12021], [-122.28348, 38.12004], [-122.28343, 38.11989], [-122.28331, 38.11964], [-122.2837, 38.11942], [-122.28408, 38.11929], [-122.28482, 38.11962], [-122.28624, 38.11904], [-122.28761, 38.11865], [-122.28884, 38.11843], [-122.28879, 38.11821], [-122.2892, 38.11772], [-122.29018, 38.11765], [-122.29513, 38.11767], [-122.29515, 38.11712], [-122.29842, 38.11716], [-122.30296, 38.1171], [-122.30355, 38.11722], [-122.30514, 38.11791], [-122.30785, 38.11928], [-122.31264, 38.12161], [-122.3168, 38.12337], [-122.31755, 38.1222], [-122.31754, 38.12218], [-122.31088, 38.11879], [-122.3078, 38.11718], [-122.30626, 38.11634], [-122.30514, 38.11566], [-122.30214, 38.11361], [-122.29654, 38.11052], [-122.30158, 38.10554], [-122.37487, 38.10534], [-122.37578, 38.10654], [-122.37608, 38.10703], [-122.37609, 38.10709], [-122.37881, 38.1114], [-122.38859, 38.12709], [-122.39096, 38.13086], [-122.39201, 38.13255], [-122.39286, 38.13382], [-122.39433, 38.13619], [-122.39494, 38.13713], [-122.39602, 38.13888], [-122.3965, 38.13957], [-122.39688, 38.14018], [-122.39728, 38.14077], [-122.39768, 38.14148], [-122.3981, 38.14212], [-122.39867, 38.14315], [-122.39947, 38.14445], [-122.39999, 38.14523], [-122.40043, 38.14576], [-122.40084, 38.14642], [-122.40133, 38.14727], [-122.40173, 38.14786], [-122.40201, 38.14838], [-122.40308, 38.14995], [-122.40338, 38.15027], [-122.40366, 38.15067], [-122.40393, 38.15092], [-122.40435, 38.15143], [-122.40492, 38.15219], [-122.40548, 38.15285], [-122.40584, 38.1534], [-122.40649, 38.15446], [-122.40701, 38.1558]]]} | Restricted Access 2 | 44494 | San Pablo Bay National Wildlife Refuge | 24964 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 106 | United States Fish and Wildlife Service 44 | Federal 1 | Federal Agency 1 | Solano 26 | 6803.264 | San Pablo Bay NWR | 1970 | National Wildlife Refuge 105 | 2 | |
15855 | 15855 | 15854 | {"type": "Polygon", "coordinates": [[[-122.40525, 38.15593], [-122.40518, 38.15666], [-122.40508, 38.15728], [-122.40499, 38.15753], [-122.40485, 38.15777], [-122.4046, 38.15805], [-122.40434, 38.15824], [-122.40366, 38.15857], [-122.40302, 38.15881], [-122.40228, 38.159], [-122.40151, 38.15906], [-122.39974, 38.15901], [-122.39583, 38.15898], [-122.39499, 38.159], [-122.39251, 38.15914], [-122.39105, 38.15916], [-122.38851, 38.15912], [-122.38645, 38.15901], [-122.38456, 38.15884], [-122.38322, 38.15866], [-122.38237, 38.15848], [-122.38056, 38.15787], [-122.37873, 38.15751], [-122.37574, 38.15745], [-122.37394, 38.15744], [-122.37281, 38.15745], [-122.37204, 38.15748], [-122.37137, 38.15755], [-122.37074, 38.15771], [-122.36935, 38.15815], [-122.36896, 38.15829], [-122.36834, 38.15854], [-122.36712, 38.1591], [-122.3662, 38.15877], [-122.36573, 38.15817], [-122.36558, 38.15777], [-122.36522, 38.15586], [-122.38279, 38.15589], [-122.40393, 38.15584], [-122.40423, 38.15594], [-122.40525, 38.15593]]]} | Restricted Access 2 | 44496 | San Pablo Bay National Wildlife Refuge | 24964 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 106 | United States Fish and Wildlife Service 44 | Federal 1 | Federal Agency 1 | Napa 11 | 249.551 | San Pablo Bay NWR | 1970 | National Wildlife Refuge 105 | 2 | |
15863 | 15863 | 15862 | {"type": "MultiPolygon", "coordinates": [[[[-117.1224, 32.59828], [-117.12207, 32.59885], [-117.11716, 32.59546], [-117.11515, 32.59482], [-117.11503, 32.59405], [-117.11241, 32.59327], [-117.11025, 32.59329], [-117.10748, 32.5947], [-117.10747, 32.59472], [-117.10785, 32.59544], [-117.10556, 32.59675], [-117.10535, 32.59862], [-117.10509, 32.60151], [-117.10412, 32.60232], [-117.10235, 32.60392], [-117.10065, 32.60418], [-117.0985, 32.60523], [-117.09818, 32.60519], [-117.09805, 32.60689], [-117.09875, 32.60901], [-117.09863, 32.60984], [-117.0988, 32.61037], [-117.09841, 32.61236], [-117.09592, 32.61163], [-117.09606, 32.61062], [-117.09626, 32.61002], [-117.09618, 32.60967], [-117.09528, 32.60833], [-117.09524, 32.60766], [-117.09464, 32.60685], [-117.09424, 32.60674], [-117.09388, 32.60586], [-117.09397, 32.60586], [-117.09402, 32.60477], [-117.09407, 32.60476], [-117.09456, 32.60103], [-117.09339, 32.60089], [-117.09276, 32.60077], [-117.09285, 32.59869], [-117.09295, 32.59868], [-117.09296, 32.59823], [-117.09301, 32.59774], [-117.09343, 32.59671], [-117.09402, 32.59611], [-117.09712, 32.594], [-117.09712, 32.59392], [-117.10133, 32.59103], [-117.10132, 32.59085], [-117.09712, 32.59374], [-117.0971, 32.58904], [-117.10134, 32.58922], [-117.10134, 32.58948], [-117.10186, 32.5895], [-117.10408, 32.588], [-117.10557, 32.58755], [-117.10558, 32.58818], [-117.10595, 32.58805], [-117.10626, 32.58796], [-117.10676, 32.58789], [-117.10716, 32.58788], [-117.10757, 32.58792], [-117.10793, 32.58799], [-117.10895, 32.58831], [-117.10919, 32.58859], [-117.10932, 32.58882], [-117.10933, 32.58886], [-117.10944, 32.58904], [-117.10957, 32.58919], [-117.10969, 32.58928], [-117.10977, 32.58955], [-117.10998, 32.58969], [-117.11059, 32.58967], [-117.11112, 32.58959], [-117.11162, 32.58956], [-117.11182, 32.5895], [-117.11182, 32.58943], [-117.112, 32.58943], [-117.11226, 32.58946], [-117.11292, 32.58961], [-117.11332, 32.58965], [-117.11461, 32.59036], [-117.11477, 32.59053], [-117.11498, 32.59068], [-117.1161, 32.59115], [-117.11648, 32.59126], [-117.11684, 32.59134], [-117.11751, 32.59137], [-117.11778, 32.59134], [-117.11842, 32.59139], [-117.11837, 32.59142], [-117.11838, 32.59144], [-117.1193, 32.59151], [-117.11999, 32.59172], [-117.12088, 32.59216], [-117.12108, 32.59229], [-117.12132, 32.59247], [-117.12153, 32.59266], [-117.12183, 32.59299], [-117.12196, 32.59317], [-117.1221, 32.59341], [-117.12227, 32.5938], [-117.12237, 32.59419], [-117.12229, 32.59687], [-117.12227, 32.59688], [-117.12226, 32.59733], [-117.12224, 32.59743], [-117.12224, 32.59757], [-117.12234, 32.59805], [-117.1224, 32.59828]]], [[[-117.10811, 32.5879], [-117.10787, 32.58784], [-117.1075, 32.58777], [-117.10718, 32.58775], [-117.10696, 32.58775], [-117.10696, 32.58758], [-117.108, 32.58758], [-117.10803, 32.58772], [-117.10811, 32.5879]]], [[[-117.11454, 32.59024], [-117.11454, 32.59024], [-117.11347, 32.58967], [-117.11393, 32.58968], [-117.11412, 32.58972], [-117.1142, 32.58976], [-117.11439, 32.58992], [-117.11443, 32.58999], [-117.11454, 32.59024]]], [[[-117.12232, 32.59233], [-117.12072, 32.59168], [-117.1201, 32.59147], [-117.11983, 32.5914], [-117.11945, 32.59133], [-117.11861, 32.59124], [-117.11864, 32.58762], [-117.11997, 32.58761], [-117.12059, 32.58709], [-117.1209, 32.58698], [-117.12109, 32.58698], [-117.12132, 32.58759], [-117.12148, 32.58761], [-117.12166, 32.58797], [-117.12181, 32.58835], [-117.12196, 32.58886], [-117.12198, 32.58891], [-117.12175, 32.58899], [-117.12159, 32.58912], [-117.12178, 32.58947], [-117.12201, 32.59009], [-117.12216, 32.59031], [-117.12232, 32.59233]]], [[[-117.12241, 32.59358], [-117.12226, 32.59325], [-117.12207, 32.59296], [-117.12187, 32.59272], [-117.12157, 32.59243], [-117.12131, 32.59224], [-117.1209, 32.59202], [-117.12234, 32.59256], [-117.12241, 32.59339], [-117.12241, 32.59358]]]]} | Open Access 1 | 44825 | San Diego Bay National Wildlife Refuge | 13940 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 106 | United States Fish and Wildlife Service 44 | Federal 1 | Federal Agency 1 | http://www.fws.gov/refuge/san_diego_bay/ | San Diego 4 | 721.883 | San Diego Bay NWR | 1988 | National Wildlife Refuge 105 | 2 |
16495 | 16495 | 16494 | {"type": "Polygon", "coordinates": [[[-117.16473, 32.66737], [-117.16316, 32.66872], [-117.16032, 32.66552], [-117.15991, 32.66503], [-117.1595, 32.66449], [-117.15649, 32.6603], [-117.15592, 32.65948], [-117.15535, 32.6586], [-117.15511, 32.65827], [-117.1549, 32.6579], [-117.15469, 32.65759], [-117.15381, 32.65642], [-117.15356, 32.65605], [-117.1533, 32.65555], [-117.15302, 32.65509], [-117.15274, 32.65456], [-117.15243, 32.65395], [-117.15204, 32.65331], [-117.15173, 32.65276], [-117.15042, 32.65008], [-117.15011, 32.64955], [-117.14975, 32.64907], [-117.14901, 32.64826], [-117.14839, 32.64751], [-117.1481, 32.64718], [-117.14787, 32.64688], [-117.14766, 32.64656], [-117.14744, 32.64616], [-117.14311, 32.63735], [-117.14449, 32.63689], [-117.14454, 32.63704], [-117.14467, 32.63727], [-117.14503, 32.63777], [-117.14512, 32.63797], [-117.1452, 32.63826], [-117.14545, 32.63873], [-117.14562, 32.63901], [-117.14614, 32.64002], [-117.14626, 32.64031], [-117.14644, 32.64064], [-117.14656, 32.64096], [-117.14691, 32.64169], [-117.14732, 32.6424], [-117.14779, 32.64331], [-117.14802, 32.64365], [-117.14816, 32.64397], [-117.14842, 32.64437], [-117.14861, 32.64471], [-117.1489, 32.64538], [-117.14897, 32.64562], [-117.14918, 32.64598], [-117.14982, 32.64691], [-117.15012, 32.64743], [-117.15027, 32.64776], [-117.15043, 32.64805], [-117.15066, 32.64835], [-117.1509, 32.64872], [-117.15173, 32.65013], [-117.15201, 32.65045], [-117.15258, 32.6512], [-117.15283, 32.65174], [-117.153, 32.65202], [-117.15319, 32.65226], [-117.15368, 32.65306], [-117.15389, 32.65331], [-117.15427, 32.65402], [-117.15477, 32.65474], [-117.15498, 32.65501], [-117.15564, 32.65609], [-117.15578, 32.6564], [-117.15593, 32.65663], [-117.15621, 32.65698], [-117.15658, 32.65739], [-117.15677, 32.65757], [-117.15694, 32.65776], [-117.1571, 32.65799], [-117.15739, 32.65851], [-117.15755, 32.65871], [-117.15793, 32.65906], [-117.15812, 32.65921], [-117.15889, 32.66005], [-117.15929, 32.66077], [-117.15946, 32.66097], [-117.15963, 32.66114], [-117.15988, 32.66144], [-117.16003, 32.66169], [-117.16021, 32.66217], [-117.16029, 32.66237], [-117.16043, 32.66261], [-117.16064, 32.66286], [-117.16114, 32.66336], [-117.16165, 32.66393], [-117.16187, 32.66422], [-117.1621, 32.66445], [-117.1626, 32.66505], [-117.16307, 32.66571], [-117.16331, 32.66598], [-117.16363, 32.66625], [-117.16425, 32.66694], [-117.16448, 32.66717], [-117.16473, 32.66737]]]} | No Public Access 3 | 47044 | Silver Strand State Beach | 30694 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 198 | United States Department of Defense 504 | Federal 1 | Federal Agency 1 | http://www.parks.ca.gov/?page_id=654 | San Diego 4 | 158.394 | Silver Strand SB | 1932 | None 1409 | |
911 | 911 | 910 | {"type": "Polygon", "coordinates": [[[-118.51445, 34.12995], [-118.51442, 34.13004], [-118.51434, 34.1301], [-118.51426, 34.13013], [-118.51414, 34.13012], [-118.51299, 34.12951], [-118.51312, 34.12943], [-118.5133, 34.12937], [-118.51381, 34.12933], [-118.51442, 34.12983], [-118.51445, 34.12991], [-118.51445, 34.12995]]]} | No Public Access 3 | 6367 | Encino Reservoir - Federal | 18670 | 199 | Other Federal 284 | Federal 1 | Federal Agency 1 | Other Federal 13 | 199 | Other Federal 280 | Federal 1 | Federal Agency 1 | Los Angeles 6 | 1.48 | Encino Reservoir - Federal | 0 | Resource Management Area 82 | 3 | ||
947 | 947 | 946 | {"type": "MultiPolygon", "coordinates": [[[[-118.30927, 33.77858], [-118.30758, 33.77901], [-118.3066, 33.7792], [-118.30555, 33.77935], [-118.30359, 33.77951], [-118.30379, 33.77922], [-118.30356, 33.7791], [-118.30373, 33.77882], [-118.30371, 33.77863], [-118.30258, 33.77836], [-118.30228, 33.77858], [-118.30213, 33.77866], [-118.30196, 33.77871], [-118.30179, 33.77874], [-118.30145, 33.77873], [-118.30114, 33.77863], [-118.30124, 33.77834], [-118.3011, 33.7783], [-118.30143, 33.77756], [-118.3013, 33.77738], [-118.30092, 33.7772], [-118.30093, 33.77658], [-118.30075, 33.77653], [-118.30073, 33.77656], [-118.3002, 33.77642], [-118.30015, 33.77669], [-118.30004, 33.7768], [-118.29989, 33.77685], [-118.29945, 33.77691], [-118.29942, 33.77696], [-118.29941, 33.77494], [-118.296, 33.77494], [-118.2959, 33.77466], [-118.29444, 33.77083], [-118.29424, 33.77018], [-118.29413, 33.76975], [-118.29404, 33.76934], [-118.29402, 33.76908], [-118.29401, 33.76865], [-118.29405, 33.76753], [-118.29404, 33.76724], [-118.294, 33.76667], [-118.29394, 33.76629], [-118.29718, 33.76629], [-118.29719, 33.76641], [-118.29801, 33.76687], [-118.29825, 33.76705], [-118.29891, 33.76743], [-118.29912, 33.76759], [-118.29932, 33.7677], [-118.30005, 33.76787], [-118.30059, 33.76797], [-118.30179, 33.76827], [-118.30185, 33.76825], [-118.30188, 33.76819], [-118.30407, 33.76881], [-118.30522, 33.76959], [-118.30699, 33.77065], [-118.30701, 33.77105], [-118.30741, 33.77167], [-118.30772, 33.77175], [-118.30895, 33.77159], [-118.30875, 33.77225], [-118.30863, 33.77282], [-118.30859, 33.77321], [-118.3086, 33.77377], [-118.30863, 33.77407], [-118.30927, 33.77858]]], [[[-118.30012, 33.77981], [-118.29971, 33.77989], [-118.29931, 33.78001], [-118.29894, 33.78016], [-118.29858, 33.78034], [-118.29825, 33.78056], [-118.29796, 33.78081], [-118.29759, 33.78122], [-118.2974, 33.78122], [-118.29726, 33.78129], [-118.29689, 33.78086], [-118.29719, 33.7805], [-118.29739, 33.7803], [-118.2976, 33.78013], [-118.2979, 33.77991], [-118.29838, 33.77962], [-118.29904, 33.77935], [-118.29933, 33.77926], [-118.29938, 33.77939], [-118.29967, 33.77967], [-118.29978, 33.77974], [-118.3001, 33.77979], [-118.30012, 33.77981]]]]} | Restricted Access 2 | 5975 | Defense Fuel Supply Point (DFSP) - Hab. Restoration | 18013 | 199 | Other Federal 284 | Federal 1 | Federal Agency 1 | Other Federal 13 | 199 | Other Federal 280 | Federal 1 | Federal Agency 1 | Los Angeles 6 | 326.646 | Defense Fuel Supply Point (DFSP) - Hab. Restoration | 0 | Federal Other or Unknown 87 | 4 | ||
2768 | 2768 | 2767 | {"type": "Polygon", "coordinates": [[[-121.39863, 38.87619], [-121.38647, 38.87621], [-121.3864, 38.87334], [-121.38634, 38.86807], [-121.39569, 38.86804], [-121.39849, 38.86801], [-121.39863, 38.87619]]]} | No Public Access 3 | 21550 | US Air Force | 26741 | 199 | Other Federal 284 | Federal 1 | Federal Agency 1 | Other Federal 13 | 199 | Other Federal 280 | Federal 1 | Federal Agency 1 | Placer 35 | 236.307 | US Air Force | 0 | Federal Other or Unknown 87 | 4 | ||
3126 | 3126 | 3125 | {"type": "Polygon", "coordinates": [[[-124.40959, 40.43808], [-124.40951, 40.43842], [-124.40911, 40.43904], [-124.40909, 40.4399], [-124.40922, 40.44018], [-124.40919, 40.4405], [-124.40914, 40.44056], [-124.40888, 40.44096], [-124.40861, 40.4432], [-124.40831, 40.44347], [-124.40777, 40.4445], [-124.40762, 40.4451], [-124.40694, 40.44581], [-124.40685, 40.44369], [-124.39606, 40.44363], [-124.39606, 40.44008], [-124.40082, 40.44002], [-124.40086, 40.43661], [-124.40676, 40.43647], [-124.40675, 40.43542], [-124.40714, 40.43567], [-124.40757, 40.43584], [-124.40771, 40.43598], [-124.40797, 40.43603], [-124.40813, 40.43615], [-124.40828, 40.43652], [-124.40906, 40.43711], [-124.40912, 40.43739], [-124.40959, 40.43808]]]} | Open Access 1 | 25764 | Other Federal | 23248 | 199 | Other Federal 284 | Federal 1 | Federal Agency 1 | Other Federal 13 | 199 | Other Federal 280 | Federal 1 | Federal Agency 1 | Humboldt 45 | 181.407 | Other Federal | 0 | Federal Other or Unknown 87 | 4 | ||
3128 | 3128 | 3127 | {"type": "Polygon", "coordinates": [[[-121.52562, 38.55872], [-121.51758, 38.55761], [-121.51649, 38.55513], [-121.52493, 38.55425], [-121.52562, 38.55872]]]} | Open Access 1 | 21571 | United States of America | 26668 | 199 | Other Federal 284 | Federal 1 | Federal Agency 1 | Other Federal 13 | 199 | Other Federal 280 | Federal 1 | Federal Agency 1 | Yolo 33 | 68.326 | United States of America | 0 | Federal Other or Unknown 87 | 4 | ||
3154 | 3154 | 3153 | {"type": "Polygon", "coordinates": [[[-121.66267, 38.17881], [-121.66233, 38.1796], [-121.66183, 38.18015], [-121.66057, 38.18049], [-121.6572, 38.18162], [-121.65543, 38.18198], [-121.65393, 38.18244], [-121.65201, 38.1828], [-121.64803, 38.18428], [-121.64712, 38.17403], [-121.65009, 38.17464], [-121.65383, 38.17571], [-121.65488, 38.1762], [-121.6556, 38.17642], [-121.65777, 38.17653], [-121.6602, 38.17778], [-121.6615, 38.17807], [-121.66216, 38.1784], [-121.66267, 38.17881]]]} | Open Access 1 | 21759 | Delta Protection | 18074 | 199 | Other Federal 284 | Federal 1 | Federal Agency 1 | Other Federal 13 | 199 | Other Federal 280 | Federal 1 | Federal Agency 1 | Sacramento 41 | 214.905 | Delta Protection | 0 | Federal Other or Unknown 87 | 4 | ||
4476 | 4476 | 4475 | {"type": "Polygon", "coordinates": [[[-117.65558, 33.90986], [-117.6554, 33.91873], [-117.65315, 33.91871], [-117.65252, 33.91691], [-117.65255, 33.91689], [-117.65245, 33.9166], [-117.65241, 33.91659], [-117.65165, 33.91438], [-117.65169, 33.91436], [-117.65166, 33.91426], [-117.65161, 33.91426], [-117.65146, 33.91385], [-117.6516, 33.91359], [-117.65131, 33.91341], [-117.65124, 33.91319], [-117.6516, 33.9131], [-117.65161, 33.91309], [-117.65123, 33.91201], [-117.65089, 33.91209], [-117.65019, 33.91006], [-117.65189, 33.91007], [-117.65558, 33.90986]]]} | Open Access 1 | 3702 | Unnamed site - Other Federal | 28636 | 199 | Other Federal 284 | Federal 1 | Federal Agency 1 | Other Federal 13 | 199 | Other Federal 280 | Federal 1 | Federal Agency 1 | Riverside 10 | 83.657 | 0 | Federal Other or Unknown 87 | 4 | |||
4488 | 4488 | 4487 | {"type": "Polygon", "coordinates": [[[-117.65093, 33.90642], [-117.64926, 33.90648], [-117.64867, 33.90481], [-117.64847, 33.90433], [-117.64801, 33.90334], [-117.65091, 33.90307], [-117.65093, 33.90642]]]} | Open Access 1 | 4845 | Unnamed site - Other Federal | 28636 | 199 | Other Federal 284 | Federal 1 | Federal Agency 1 | Other Federal 13 | 199 | Other Federal 280 | Federal 1 | Federal Agency 1 | Riverside 10 | 18.733 | 0 | Federal Other or Unknown 87 | 4 | |||
4767 | 4767 | 4766 | {"type": "MultiPolygon", "coordinates": [[[[-124.07188, 40.02141], [-124.0717, 40.02154], [-124.07142, 40.02186], [-124.07138, 40.02194], [-124.07093, 40.02203], [-124.07077, 40.022], [-124.07039, 40.02228], [-124.07027, 40.02238], [-124.07015, 40.02271], [-124.0698, 40.02258], [-124.06982, 40.02124], [-124.07026, 40.02134], [-124.0705, 40.02146], [-124.0707, 40.02155], [-124.07077, 40.02147], [-124.07095, 40.02136], [-124.07113, 40.02143], [-124.07099, 40.02123], [-124.07099, 40.02112], [-124.07109, 40.02104], [-124.0712, 40.02104], [-124.0715, 40.02123], [-124.07164, 40.02124], [-124.07185, 40.02127], [-124.07188, 40.02141]]], [[[-124.07536, 40.02553], [-124.07492, 40.0256], [-124.07487, 40.02547], [-124.0753, 40.02539], [-124.07536, 40.02553]]], [[[-124.07571, 40.02705], [-124.07534, 40.02713], [-124.07525, 40.02686], [-124.07566, 40.02676], [-124.07571, 40.02689], [-124.07571, 40.02705]]], [[[-124.07823, 40.02907], [-124.07811, 40.02949], [-124.07799, 40.02951], [-124.07792, 40.02949], [-124.07753, 40.02925], [-124.07779, 40.02903], [-124.07788, 40.02915], [-124.07778, 40.02926], [-124.07778, 40.02928], [-124.07791, 40.02918], [-124.07802, 40.02918], [-124.07823, 40.02907]]], [[[-124.07922, 40.0299], [-124.07922, 40.03005], [-124.07911, 40.03018], [-124.079, 40.03028], [-124.07875, 40.03011], [-124.07908, 40.02984], [-124.07922, 40.0299]]], [[[-124.07933, 40.03016], [-124.07925, 40.03046], [-124.07904, 40.03031], [-124.07922, 40.03015], [-124.07933, 40.03016]]], [[[-124.1686, 40.57766], [-124.16517, 40.57763], [-124.16391, 40.57524], [-124.16225, 40.57413], [-124.162, 40.57379], [-124.16671, 40.57381], [-124.16859, 40.57486], [-124.1686, 40.57766]]], [[[-124.20702, 40.62484], [-124.20654, 40.62667], [-124.20601, 40.62727], [-124.20538, 40.62782], [-124.20538, 40.62856], [-124.20373, 40.62856], [-124.20373, 40.62912], [-124.20237, 40.62912], [-124.20235, 40.62812], [-124.20222, 40.62451], [-124.20505, 40.62454], [-124.20545, 40.62473], [-124.20547, 40.62483], [-124.20702, 40.62484]]], [[[-124.24507, 40.70111], [-124.23975, 40.70113], [-124.23978, 40.70493], [-124.24384, 40.70491], [-124.24362, 40.70559], [-124.24366, 40.70705], [-124.24345, 40.70806], [-124.2428, 40.70893], [-124.24271, 40.7093], [-124.24081, 40.71136], [-124.23989, 40.71261], [-124.23923, 40.71499], [-124.23912, 40.71609], [-124.2355, 40.71611], [-124.23546, 40.71493], [-124.23555, 40.71084], [-124.23554, 40.70677], [-124.23558, 40.70283], [-124.23689, 40.70132], [-124.23685, 40.70119], [-124.23558, 40.7026], [-124.23559, 40.69411], [-124.24021, 40.69417], [-124.24029, 40.69762], [-124.24506, 40.69761], [-124.24507, 40.70111]]]]} | Unknown Access 4 | 46914 | Unnamed site - Other Federal | 30495 | 199 | Other Federal 284 | Federal 1 | Federal Agency 1 | Other Federal 13 | 199 | Other Federal 280 | Federal 1 | Federal Agency 1 | Humboldt 45 | 389.611 | 0 | Federal Other or Unknown 87 | 4 | |||
5019 | 5019 | 5018 | {"type": "Polygon", "coordinates": [[[-118.96111, 36.3865], [-118.96105, 36.38679], [-118.96089, 36.38693], [-118.96051, 36.38705], [-118.96024, 36.38705], [-118.96009, 36.38719], [-118.95951, 36.38722], [-118.95919, 36.38717], [-118.95861, 36.38716], [-118.95851, 36.38723], [-118.95855, 36.3876], [-118.9584, 36.38789], [-118.95818, 36.38804], [-118.95796, 36.38808], [-118.95774, 36.38803], [-118.95737, 36.3877], [-118.95673, 36.38669], [-118.95654, 36.38633], [-118.95645, 36.38624], [-118.95629, 36.38619], [-118.95614, 36.38611], [-118.95594, 36.38608], [-118.95579, 36.38601], [-118.95528, 36.38547], [-118.95521, 36.38519], [-118.95514, 36.38504], [-118.95498, 36.38488], [-118.95426, 36.38454], [-118.95352, 36.38435], [-118.95309, 36.38418], [-118.95279, 36.384], [-118.95244, 36.38373], [-118.95229, 36.38363], [-118.95197, 36.38362], [-118.95169, 36.38376], [-118.95139, 36.38386], [-118.95097, 36.38385], [-118.95052, 36.38378], [-118.95041, 36.38374], [-118.95012, 36.38358], [-118.95136, 36.38322], [-118.95213, 36.38318], [-118.95297, 36.38321], [-118.95358, 36.38327], [-118.9544, 36.38345], [-118.95589, 36.38398], [-118.95805, 36.38488], [-118.96087, 36.38617], [-118.96111, 36.3865]]]} | Open Access 1 | 1030 | Horse Creek Recreation Area | 20095 | 199 | Other Federal 284 | Federal 1 | Federal Agency 1 | Other Federal 13 | 199 | Other Federal 280 | Federal 1 | Federal Agency 1 | Tulare 29 | 39.18 | Horse Creek Rec. Area | 0 | Recreation Management Area 49 | 4 | ||
5184 | 5184 | 5183 | {"type": "Polygon", "coordinates": [[[-122.00444, 36.96745], [-122.00387, 36.96749], [-122.00391, 36.96788], [-122.00368, 36.96786], [-122.00366, 36.96704], [-122.004, 36.96702], [-122.00401, 36.96714], [-122.00434, 36.96712], [-122.00444, 36.96745]]]} | Open Access 1 | 1479 | Twin Lakes - USA | 26615 | 199 | Other Federal 284 | Federal 1 | Federal Agency 1 | Other Federal 13 | 199 | Other Federal 280 | Federal 1 | Federal Agency 1 | Santa Cruz 5 | 0.895 | Twin Lakes - USA | 0 | Federal Other or Unknown 87 | 4 | ||
9848 | 9848 | 9847 | {"type": "Polygon", "coordinates": [[[-119.62642, 36.59749], [-119.62573, 36.5975], [-119.62574, 36.5981], [-119.62256, 36.59811], [-119.62256, 36.59635], [-119.62389, 36.59572], [-119.62388, 36.59489], [-119.6232, 36.59416], [-119.62192, 36.59418], [-119.62191, 36.59289], [-119.62419, 36.59288], [-119.6242, 36.59467], [-119.62497, 36.59528], [-119.62541, 36.59616], [-119.62639, 36.59616], [-119.62642, 36.59749]]]} | No Public Access 3 | 16838 | Young Pond Federal Wetlands/Selma Pres | 27789 | 199 | Other Federal 284 | Federal 1 | Federal Agency 1 | Other Federal 13 | 199 | Other Federal 280 | Federal 1 | Federal Agency 1 | Fresno 9 | 29.786 | Young Pond Federal Wetlands/Selma Pres | 0 | Federal Other or Unknown 87 | 4 | ||
9934 | 9934 | 9933 | {"type": "MultiPolygon", "coordinates": [[[[-120.91337, 36.99133], [-120.90983, 36.99135], [-120.90983, 36.99135], [-120.90983, 36.99124], [-120.91018, 36.99107], [-120.91061, 36.99088], [-120.91085, 36.99074], [-120.9129, 36.98907], [-120.91258, 36.98963], [-120.91273, 36.99023], [-120.91337, 36.99112], [-120.91337, 36.99133]]], [[[-120.9107, 36.99063], [-120.91051, 36.99074], [-120.91006, 36.99093], [-120.90984, 36.99104], [-120.90986, 36.99061], [-120.9107, 36.99063]]]]} | Open Access 1 | 17099 | Los Banos Reservoir | 21508 | 199 | Other Federal 284 | Federal 1 | Federal Agency 1 | Other Federal 13 | 199 | Other Federal 280 | Federal 1 | Federal Agency 1 | Merced 37 | 8.468 | Los Banos Reservoir | 0 | Resource Management Area 82 | 3 | ||
10040 | 10040 | 10039 | {"type": "Polygon", "coordinates": [[[-119.49172, 34.40088], [-119.49129, 34.40263], [-119.49129, 34.40263], [-119.49072, 34.40237], [-119.49092, 34.40127], [-119.49172, 34.40088]]]} | Open Access 1 | 17367 | Lions Park | 21316 | 199 | Other Federal 284 | Federal 1 | Federal Agency 1 | Other Federal 13 | 199 | Other Federal 280 | Federal 1 | Federal Agency 1 | Santa Barbara 7 | 2.41 | Lions Park | 0 | Recreation Management Area 49 | 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]);