units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
137 rows where ACCESS_TYP = 3 and MNG_AG_TYP = 5 sorted by SUID_NMA
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_TYP, AGNCY_WEB, MNG_AG_ID, YR_EST, GAP_STS
DES_TP 30
- State Resource Management Area 64
- State Conservation Area 22
- State Other or Unknown 18
- State Park 5
- State Historic or Cultural Area 3
- None 1
- None 1
- State Recreation Area 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
MNG_AGENCY 16
- California Department of Fish and Wildlife 79
- California Department of Parks and Recreation 15
- California Department of Water Resources 11
- California Department of General Services 10
- California Department of Transportation 5
- University of California 3
- California Department of Forestry and Fire Protection 2
- California Wildlife Conservation Board 2
- Coachella Valley Mountains Conservancy 2
- California Tahoe Conservancy 2
- California State Lands Commission 1
- Other State 1
- Napa Valley College 1
- San Diego State University 1
- California State University 1
- California State Coastal Conservancy 1
LAYER 4 ✖
MNG_AG_TYP 1
- State Agency · 137 ✖
ACCESS_TYP 1
- No Public Access · 137 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7312 | 7312 | 7311 | {"type": "Polygon", "coordinates": [[[-122.27901, 38.29895], [-122.27868, 38.299], [-122.27861, 38.29876], [-122.27894, 38.2987], [-122.27901, 38.29895]]]} | No Public Access 3 | 6623 | 575 Third St | 15206 | 203 | California Department of General Services 17 | State 5 | State Agency 5 | http://www.dgs.ca.gov/default.htm | Other State 5 | 203 | California Department of General Services 17 | State 5 | State Agency 5 | Napa 11 | 0.21 | 575 Third St | None 604 | |||
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 | |||
13068 | 13068 | 13067 | {"type": "MultiPolygon", "coordinates": [[[[-121.99945, 39.45642], [-121.99894, 39.45698], [-121.99638, 39.45713], [-121.9963, 39.45659], [-121.99606, 39.45657], [-121.99602, 39.45688], [-121.99611, 39.45714], [-121.99595, 39.45715], [-121.99595, 39.45706], [-121.99599, 39.45693], [-121.99602, 39.45668], [-121.99608, 39.45639], [-121.99612, 39.45579], [-121.99625, 39.45526], [-121.99627, 39.45507], [-121.99628, 39.45472], [-121.99622, 39.45459], [-121.99612, 39.45419], [-121.99608, 39.454], [-121.99608, 39.45386], [-121.99602, 39.45371], [-121.99603, 39.45339], [-121.99602, 39.45321], [-121.996, 39.45303], [-121.99601, 39.45283], [-121.996, 39.4526], [-121.99589, 39.45218], [-121.99581, 39.45172], [-121.99565, 39.45129], [-121.99553, 39.45117], [-121.99539, 39.45097], [-121.9953, 39.4499], [-121.99614, 39.44991], [-121.99593, 39.45068], [-121.99785, 39.45334], [-121.99798, 39.45443], [-121.99945, 39.45642]]], [[[-121.99896, 39.45721], [-121.9974, 39.45877], [-121.99654, 39.45958], [-121.9966, 39.45826], [-121.99648, 39.45806], [-121.99647, 39.4578], [-121.99634, 39.45749], [-121.99624, 39.45732], [-121.99896, 39.45721]]]]} | No Public Access 3 | 34944 | Butte City Project | 16549 | 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 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | Glenn 55 | 35.952 | Butte City Project | None 1134 | |||
12265 | 12265 | 12264 | {"type": "Polygon", "coordinates": [[[-122.53034, 38.61119], [-122.52572, 38.61121], [-122.52574, 38.61484], [-122.52112, 38.61486], [-122.52091, 38.614], [-122.52089, 38.61399], [-122.52101, 38.61821], [-122.51659, 38.61803], [-122.51647, 38.6144], [-122.51625, 38.60714], [-122.52067, 38.60732], [-122.52401, 38.60734], [-122.53031, 38.60743], [-122.53034, 38.61119]]]} | No Public Access 3 | 25816 | California State Lands Commission | 16723 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 209 | California State Lands Commission 73 | State 5 | State Agency 5 | Napa 11 | 245.258 | SLC | 0 | State Resource Management Area 55 | 3 | |
3312 | 3312 | 3311 | {"type": "Polygon", "coordinates": [[[-117.05061, 34.06564], [-117.05016, 34.06761], [-117.04942, 34.06795], [-117.04771, 34.06692], [-117.04766, 34.06428], [-117.04902, 34.06452], [-117.05061, 34.06564]]]} | No Public Access 3 | 29659 | Crafton Hills Reservoir | 17748 | 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 | San Bernardino 22 | 19.391 | Crafton Hills Reservoir | None 270 | |||
9163 | 9163 | 9162 | {"type": "Polygon", "coordinates": [[[-122.46839, 38.40869], [-122.46606, 38.40871], [-122.46603, 38.40487], [-122.46579, 38.40181], [-122.46609, 38.40194], [-122.46628, 38.402], [-122.46661, 38.40209], [-122.46676, 38.4021], [-122.4669, 38.40215], [-122.46726, 38.40233], [-122.4675, 38.40235], [-122.46761, 38.40231], [-122.46771, 38.40225], [-122.46801, 38.40199], [-122.46819, 38.40193], [-122.46832, 38.40179], [-122.46839, 38.40869]]]} | No Public Access 3 | 15212 | Dale Peters Clyde | 17895 | 223 | Napa Valley College 268 | State 5 | State Agency 5 | http://www.napavalley.edu/ | Other State 5 | 223 | Napa Valley College 263 | State 5 | State Agency 5 | Napa 11 | 37.395 | Dale Peters Clyde | None 758 | |||
14856 | 14856 | 14855 | {"type": "Polygon", "coordinates": [[[-124.18903, 40.79066], [-124.18902, 40.79082], [-124.18514, 40.7908], [-124.1852, 40.79064], [-124.18903, 40.79066]]]} | No Public Access 3 | 45366 | Del Norte Street Pier | 18042 | 212 | California Wildlife Conservation Board 766 | State 5 | State Agency 5 | http://www.wcb.ca.gov/ | Other State 5 | 212 | California Wildlife Conservation Board 747 | State 5 | State Agency 5 | Humboldt 45 | 1.467 | Del Norte Street Pier | None 1279 | |||
10166 | 10166 | 10165 | {"type": "Polygon", "coordinates": [[[-121.50965, 38.26426], [-121.504, 38.26799], [-121.50354, 38.26776], [-121.49741, 38.2718], [-121.49714, 38.27079], [-121.49718, 38.27056], [-121.49735, 38.27044], [-121.49739, 38.27031], [-121.49769, 38.27006], [-121.49778, 38.26953], [-121.49789, 38.2695], [-121.49772, 38.26927], [-121.4976, 38.26904], [-121.49618, 38.27013], [-121.49636, 38.27139], [-121.49639, 38.27268], [-121.49826, 38.27354], [-121.49845, 38.27456], [-121.49793, 38.27673], [-121.4954, 38.27672], [-121.49517, 38.27538], [-121.4951, 38.27483], [-121.49506, 38.27443], [-121.49502, 38.27373], [-121.49502, 38.27313], [-121.49508, 38.27226], [-121.49523, 38.27126], [-121.49541, 38.27047], [-121.49531, 38.27045], [-121.49556, 38.2696], [-121.49584, 38.26887], [-121.49583, 38.26885], [-121.49576, 38.26885], [-121.49617, 38.26803], [-121.49757, 38.26552], [-121.49751, 38.26545], [-121.49743, 38.26543], [-121.49724, 38.26541], [-121.49715, 38.26534], [-121.49699, 38.26526], [-121.49701, 38.2652], [-121.4968, 38.26514], [-121.4967, 38.26509], [-121.49661, 38.26509], [-121.49571, 38.26502], [-121.49553, 38.26473], [-121.49532, 38.26455], [-121.49523, 38.26454], [-121.49511, 38.26435], [-121.49489, 38.26415], [-121.49478, 38.26414], [-121.4945, 38.2639], [-121.49426, 38.26356], [-121.49412, 38.26323], [-121.49401, 38.26242], [-121.49388, 38.26202], [-121.49327, 38.26127], [-121.49309, 38.26093], [-121.49298, 38.26063], [-121.49294, 38.25993], [-121.49297, 38.25961], [-121.49309, 38.25931], [-121.49341, 38.25904], [-121.4938, 38.25889], [-121.4939, 38.25893], [-121.49429, 38.25876], [-121.49445, 38.25876], [-121.49481, 38.25864], [-121.49524, 38.25847], [-121.49556, 38.25815], [-121.49606, 38.25758], [-121.49621, 38.25729], [-121.4963, 38.25716], [-121.49746, 38.25638], [-121.49789, 38.25614], [-121.49806, 38.25609], [-121.49821, 38.25602], [-121.49851, 38.25559], [-121.49843, 38.25518], [-121.4982, 38.25464], [-121.49814, 38.25443], [-121.49806, 38.25399], [-121.49802, 38.25353], [-121.49797, 38.25326], [-121.49795, 38.25286], [-121.4979, 38.25256], [-121.49773, 38.25179], [-121.49772, 38.25147], [-121.50104, 38.25101], [-121.50156, 38.25114], [-121.5038, 38.25083], [-121.50375, 38.25063], [-121.50339, 38.25068], [-121.5027, 38.24588], [-121.50353, 38.24609], [-121.5037, 38.24612], [-121.50384, 38.24617], [-121.50863, 38.24741], [-121.50921, 38.24635], [-121.50958, 38.24651], [-121.5081, 38.24892], [-121.50797, 38.24894], [-121.50805, 38.24901], [-121.50763, 38.24968], [-121.50783, 38.25006], [-121.50797, 38.25004], [-121.50312, 38.25795], [-121.5029, 38.25787], [-121.50269, 38.25821], [-121.50498, 38.25966], [-121.5073, 38.26083], [-121.50771, 38.26135], [-121.5083, 38.26215], [-121.50965, 38.26426]]]} | No Public Access 3 | 20470 | Delta Meadows Park Property | 18073 | 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 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | Sacramento 41 | 533.415 | Delta Meadows Park Property | 1985 | State Other or Unknown 104 | 4 | |
9361 | 9361 | 9360 | {"type": "MultiPolygon", "coordinates": [[[[-122.29969, 38.27466], [-122.29947, 38.27466], [-122.29946, 38.27356], [-122.29948, 38.27356], [-122.29969, 38.27466]]], [[[-122.46397, 38.50119], [-122.46394, 38.50121], [-122.46301, 38.50039], [-122.46304, 38.50037], [-122.46397, 38.50119]]]]} | No Public Access 3 | 15638 | Department of Transportation | 18097 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | Napa 11 | 0.423 | Department of Transportation | None 770 | |||
6759 | 6759 | 6758 | {"type": "Polygon", "coordinates": [[[-122.22476, 38.22438], [-122.22475, 38.22525], [-122.2237, 38.22526], [-122.2237, 38.22472], [-122.22307, 38.22433], [-122.2222, 38.22245], [-122.22221, 38.22188], [-122.22324, 38.22127], [-122.22322, 38.22152], [-122.22316, 38.22152], [-122.22316, 38.22161], [-122.22261, 38.22185], [-122.22242, 38.22209], [-122.22241, 38.22244], [-122.22307, 38.22385], [-122.22384, 38.22431], [-122.22415, 38.22431], [-122.22452, 38.22437], [-122.22476, 38.22438]]]} | No Public Access 3 | 5145 | Department Of Water Resourses | 18099 | 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 | Napa 11 | 4.793 | Department Of Water Resourses | None 549 | |||
6778 | 6778 | 6777 | {"type": "Polygon", "coordinates": [[[-122.25654, 38.2078], [-122.25633, 38.20788], [-122.2563, 38.20749], [-122.2564, 38.20753], [-122.25652, 38.20754], [-122.25654, 38.2078]]]} | No Public Access 3 | 5258 | Dept Of Transportation/Paul Kenny | 18103 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | Napa 11 | 0.163 | Dept Of Transportation/Paul Kenny | None 551 | |||
13162 | 13162 | 13161 | {"type": "Polygon", "coordinates": [[[-121.69523, 37.99864], [-121.69516, 37.99875], [-121.69492, 37.99898], [-121.69489, 37.99899], [-121.69479, 37.99908], [-121.6946, 37.99933], [-121.69451, 37.99949], [-121.69412, 38.00034], [-121.69357, 38.00137], [-121.69349, 38.00155], [-121.69341, 38.00178], [-121.69332, 38.00199], [-121.69256, 38.00334], [-121.69235, 38.00375], [-121.69214, 38.00408], [-121.69172, 38.00498], [-121.69157, 38.0052], [-121.6915, 38.00533], [-121.69134, 38.00615], [-121.6913, 38.00678], [-121.69131, 38.00698], [-121.69117, 38.00802], [-121.69114, 38.00835], [-121.69102, 38.00912], [-121.691, 38.00933], [-121.69101, 38.01008], [-121.69106, 38.01024], [-121.69104, 38.01035], [-121.69121, 38.01057], [-121.69102, 38.01082], [-121.69092, 38.01111], [-121.6909, 38.01129], [-121.69083, 38.01153], [-121.69057, 38.01169], [-121.69041, 38.01184], [-121.69042, 38.01202], [-121.69037, 38.01241], [-121.68974, 38.01329], [-121.68931, 38.01338], [-121.68885, 38.01329], [-121.68808, 38.0132], [-121.68616, 38.01353], [-121.68476, 38.01351], [-121.68233, 38.012], [-121.6797, 38.01151], [-121.6779, 38.01073], [-121.67466, 38.01191], [-121.67439, 38.01196], [-121.67438, 38.01228], [-121.66372, 38.01239], [-121.66372, 38.01234], [-121.66361, 38.01228], [-121.66332, 38.01219], [-121.66305, 38.01222], [-121.66269, 38.0124], [-121.66098, 38.01241], [-121.66075, 38.01191], [-121.66066, 38.01164], [-121.6605, 38.0114], [-121.65932, 38.0089], [-121.65922, 38.00863], [-121.65914, 38.00835], [-121.65911, 38.00795], [-121.65919, 37.99845], [-121.66012, 37.99845], [-121.66014, 37.99791], [-121.66013, 37.9979], [-121.6592, 37.9979], [-121.65925, 37.99124], [-121.66028, 37.99208], [-121.66047, 37.99221], [-121.66068, 37.99233], [-121.6609, 37.99243], [-121.66357, 37.99352], [-121.66415, 37.99377], [-121.67363, 37.99756], [-121.67366, 37.99754], [-121.67405, 37.99767], [-121.67431, 37.99772], [-121.67459, 37.99775], [-121.6759, 37.99776], [-121.67585, 37.99946], [-121.67687, 38.0005], [-121.67805, 38.00051], [-121.67798, 38.00067], [-121.67805, 38.00087], [-121.67806, 38.00179], [-121.67966, 38.00179], [-121.67966, 38.00051], [-121.68253, 38.00051], [-121.68379, 38.0001], [-121.68381, 37.99788], [-121.68397, 37.99792], [-121.6859, 37.99855], [-121.6862, 37.99862], [-121.68641, 37.99865], [-121.68662, 37.99866], [-121.69523, 37.99864]]]} | No Public Access 3 | 35110 | Dutch Slough | 18320 | 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 | Contra Costa 12 | 1185.171 | Dutch Slough | 0 | State Conservation Area 8 | 2 | |
2095 | 2095 | 2094 | {"type": "Polygon", "coordinates": [[[-121.70681, 38.27679], [-121.69559, 38.279], [-121.69594, 38.27864], [-121.69605, 38.27822], [-121.69594, 38.27776], [-121.69591, 38.27776], [-121.69526, 38.27319], [-121.69496, 38.27168], [-121.6945, 38.26631], [-121.69503, 38.266], [-121.69541, 38.26585], [-121.69632, 38.26585], [-121.69693, 38.26661], [-121.69714, 38.2671], [-121.69799, 38.2678], [-121.69895, 38.26831], [-121.69965, 38.26846], [-121.69988, 38.26865], [-121.70056, 38.26926], [-121.70453, 38.27349], [-121.70503, 38.27408], [-121.70574, 38.27512], [-121.70586, 38.27551], [-121.70622, 38.27614], [-121.70681, 38.27679]]]} | No Public Access 3 | 15834 | DWR Mitigation | 18327 | 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 | Solano 26 | 213.26 | DWR Mitigation | 0 | State Other or Unknown 104 | 4 | |
9250 | 9250 | 9249 | {"type": "MultiPolygon", "coordinates": [[[[-116.44947, 33.88499], [-116.44723, 33.88499], [-116.44529, 33.88496], [-116.4457, 33.88489], [-116.44596, 33.88482], [-116.44707, 33.88443], [-116.44732, 33.88435], [-116.44773, 33.88427], [-116.44824, 33.8842], [-116.44946, 33.88418], [-116.44947, 33.88499]]], [[[-116.46255, 33.8886], [-116.46251, 33.89218], [-116.45813, 33.89218], [-116.45819, 33.88861], [-116.46255, 33.8886]]], [[[-116.47988, 33.89224], [-116.47985, 33.89496], [-116.47554, 33.89498], [-116.47555, 33.89223], [-116.47988, 33.89224]]]]} | No Public Access 3 | 15404 | Edom Hill-Willow Hole Preserve | 18453 | 214 | Coachella Valley Mountains Conservancy 767 | State 5 | State Agency 5 | http://www.cvmc.ca.gov/ | Other State 5 | 214 | Coachella Valley Mountains Conservancy 748 | State 5 | State Agency 5 | Riverside 10 | 75.092 | Edom Hill-Willow Hole Preserve | 0 | State Conservation Area 8 | 2 | |
9251 | 9251 | 9250 | {"type": "Polygon", "coordinates": [[[-116.47394, 33.88857], [-116.47122, 33.88857], [-116.47122, 33.88785], [-116.47129, 33.88596], [-116.47394, 33.88857]]]} | No Public Access 3 | 15407 | Edom Hill-Willow Hole Preserve | 18453 | 214 | Coachella Valley Mountains Conservancy 767 | State 5 | State Agency 5 | http://www.cvmc.ca.gov/ | Other State 5 | 214 | Coachella Valley Mountains Conservancy 748 | State 5 | State Agency 5 | Riverside 10 | 9.085 | Edom Hill-Willow Hole Preserve | 0 | State Conservation Area 8 | 2 | |
13158 | 13158 | 13157 | {"type": "Polygon", "coordinates": [[[-122.52495, 38.06971], [-122.52293, 38.06978], [-122.52096, 38.07133], [-122.51104, 38.06343], [-122.5006, 38.06098], [-122.49657, 38.06008], [-122.49222, 38.05907], [-122.49669, 38.05127], [-122.498, 38.04907], [-122.49841, 38.04941], [-122.49892, 38.04861], [-122.49891, 38.04859], [-122.49831, 38.04855], [-122.49847, 38.04828], [-122.49848, 38.04785], [-122.50668, 38.04784], [-122.50668, 38.04742], [-122.50731, 38.04741], [-122.50732, 38.0474], [-122.50668, 38.04689], [-122.50851, 38.04693], [-122.50972, 38.04814], [-122.51013, 38.04801], [-122.51102, 38.04913], [-122.51148, 38.05001], [-122.51052, 38.05012], [-122.51044, 38.05017], [-122.5105, 38.05049], [-122.50943, 38.05062], [-122.50805, 38.05113], [-122.50669, 38.0522], [-122.50669, 38.05222], [-122.5098, 38.05469], [-122.51448, 38.06081], [-122.51476, 38.06197], [-122.51638, 38.06325], [-122.51678, 38.06343], [-122.51743, 38.06392], [-122.51755, 38.06389], [-122.51761, 38.06395], [-122.5176, 38.06404], [-122.51799, 38.06436], [-122.51829, 38.06465], [-122.51843, 38.0647], [-122.51859, 38.06467], [-122.52495, 38.06971]]]} | No Public Access 3 | 35102 | Hamilton Wetlands | 19625 | 200 | California State Coastal Conservancy 859 | State 5 | State Agency 5 | http://www.scc.ca.gov/ | Other State 5 | 200 | California State Coastal Conservancy 837 | State 5 | State Agency 5 | Marin 23 | 632.955 | Hamilton Wetlands | 0 | State Conservation Area 8 | 2 | |
9826 | 9826 | 9825 | {"type": "MultiPolygon", "coordinates": [[[[-121.91219, 36.56857], [-121.91123, 36.5683], [-121.91108, 36.56762], [-121.91105, 36.56707], [-121.91065, 36.5649], [-121.91017, 36.56418], [-121.91037, 36.56395], [-121.91008, 36.56346], [-121.90961, 36.56327], [-121.90942, 36.56284], [-121.90903, 36.56204], [-121.90847, 36.56144], [-121.90782, 36.56089], [-121.90742, 36.56071], [-121.90669, 36.55928], [-121.90585, 36.55863], [-121.90484, 36.55822], [-121.90469, 36.55735], [-121.90429, 36.55682], [-121.90401, 36.55626], [-121.90434, 36.55495], [-121.90465, 36.55341], [-121.90432, 36.5527], [-121.90501, 36.55087], [-121.90518, 36.55003], [-121.90553, 36.54902], [-121.90565, 36.54784], [-121.90602, 36.54689], [-121.90573, 36.545], [-121.90586, 36.54402], [-121.90582, 36.54395], [-121.90574, 36.54391], [-121.90573, 36.54384], [-121.90686, 36.54383], [-121.90735, 36.54379], [-121.90776, 36.54368], [-121.90808, 36.54357], [-121.9082, 36.54356], [-121.90833, 36.54361], [-121.90835, 36.54401], [-121.90845, 36.54417], [-121.90749, 36.54437], [-121.90728, 36.54489], [-121.90728, 36.5453], [-121.90764, 36.54636], [-121.90754, 36.54714], [-121.90769, 36.54835], [-121.90765, 36.55077], [-121.90574, 36.55393], [-121.90528, 36.55507], [-121.90512, 36.55553], [-121.90513, 36.55641], [-121.90548, 36.55669], [-121.90526, 36.55693], [-121.9069, 36.558], [-121.90756, 36.55788], [-121.90788, 36.5581], [-121.90869, 36.55849], [-121.90912, 36.55886], [-121.90924, 36.55913], [-121.90953, 36.55941], [-121.91054, 36.56218], [-121.91149, 36.56218], [-121.9114, 36.56234], [-121.91133, 36.56256], [-121.91128, 36.56273], [-121.91123, 36.563], [-121.91121, 36.56336], [-121.91124, 36.56362], [-121.91128, 36.5638], [-121.91141, 36.56414], [-121.91153, 36.56439], [-121.9123, 36.56549], [-121.91244, 36.56573], [-121.91258, 36.56606], [-121.91262, 36.56623], [-121.91267, 36.56649], [-121.91267, 36.56685], [-121.91262, 36.56719], [-121.91254, 36.56745], [-121.9123, 36.56813], [-121.91219, 36.56857]]], [[[-121.90999, 36.53947], [-121.90993, 36.53961], [-121.9083, 36.54156], [-121.90802, 36.54224], [-121.90795, 36.54252], [-121.90803, 36.54259], [-121.90813, 36.54329], [-121.90818, 36.54335], [-121.90755, 36.54355], [-121.90716, 36.54364], [-121.90679, 36.54365], [-121.90641, 36.54363], [-121.9051, 36.54372], [-121.90508, 36.54348], [-121.90594, 36.54347], [-121.90601, 36.54346], [-121.90607, 36.54342], [-121.9061, 36.54337], [-121.90638, 36.54271], [-121.90698, 36.54197], [-121.9082, 36.54074], [-121.90952, 36.53918], [-121.90989, 36.53936], [-121.90997, 36.53941], [-121.90999, 36.53947]]], [[[-121.91235, 36.53624], [-121.9118, 36.53681], [-121.91158, 36.53712], [-121.91134, 36.53758], [-121.91109, 36.53814], [-121.911, 36.53829], [-121.91077, 36.53861], [-121.91026, 36.53919], [-121.91022, 36.53923], [-121.91014, 36.53923], [-121.90973, 36.53901], [-121.91205, 36.53616], [-121.91228, 36.5362], [-121.91235, 36.53624]]]]} | No Public Access 3 | 16787 | Hatton Canyon | 19737 | 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 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | Monterey 14 | 126.188 | Hatton Canyon | 2002 | None 850 | ||
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 | |||
1316 | 1316 | 1315 | {"type": "Polygon", "coordinates": [[[-116.74116, 32.57636], [-116.74114, 32.58363], [-116.73714, 32.58342], [-116.73291, 32.5834], [-116.73278, 32.58732], [-116.72047, 32.58718], [-116.72045, 32.58913], [-116.70751, 32.5894], [-116.69094, 32.5893], [-116.69082, 32.58084], [-116.69077, 32.57124], [-116.73696, 32.56738], [-116.73704, 32.56906], [-116.74116, 32.5691], [-116.74116, 32.5727], [-116.73707, 32.57263], [-116.73709, 32.57623], [-116.74116, 32.57636]]]} | No Public Access 3 | 7399 | Kuchamaa Experimental Forest | 20729 | 202 | California Department of Forestry and Fire Protection 346 | State 5 | State Agency 5 | http://www.fire.ca.gov/ | Other State 5 | 202 | California Department of Forestry and Fire Protection 343 | State 5 | State Agency 5 | San Diego 4 | 2363.684 | Kuchamaa Experimental Forest | 0 | None 113 | ||
2472 | 2472 | 2471 | {"type": "Polygon", "coordinates": [[[-122.42431, 38.57076], [-122.40796, 38.56534], [-122.40763, 38.56593], [-122.40441, 38.56433], [-122.40437, 38.56388], [-122.39965, 38.56388], [-122.39938, 38.56002], [-122.39765, 38.56007], [-122.39459, 38.56008], [-122.3945, 38.55878], [-122.3939, 38.55243], [-122.38916, 38.55225], [-122.38901, 38.54848], [-122.39374, 38.54861], [-122.40827, 38.54845], [-122.40883, 38.55601], [-122.41284, 38.55633], [-122.41246, 38.55706], [-122.41819, 38.55884], [-122.41876, 38.55979], [-122.4195, 38.56112], [-122.42027, 38.56235], [-122.4221, 38.56629], [-122.42372, 38.56906], [-122.42377, 38.56909], [-122.42384, 38.56927], [-122.4243, 38.57012], [-122.42431, 38.57076]]]} | No Public Access 3 | 17455 | Las Posadas State Forest | 21064 | 202 | California Department of Forestry and Fire Protection 346 | State 5 | State Agency 5 | http://www.fire.ca.gov/ | Other State 5 | 202 | California Department of Forestry and Fire Protection 343 | State 5 | State Agency 5 | Napa 11 | 843.001 | Las Posadas State Forest | 0 | State Resource Management Area 55 | 3 |
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]);