units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
145 rows where ACCESS_TYP = 2 and AGNCY_TYP = 5 sorted by GAP_STS
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_WEB, LAYER, MNG_AG_ID, YR_EST, GAP_STS
DES_TP >30
- State Conservation Area 96
- State Resource Management Area 7
- State Recreation Area 4
- State Park 3
- Local Recreation Area 2
- National Wildlife Refuge 2
- Local Park 1
- None 1
- State Other or Unknown 1
- State Historic or Cultural 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
- …
MNG_AGENCY 15
- California Department of Fish and Wildlife 64
- University of California 43
- California Department of Parks and Recreation 10
- East Bay Regional Park District 5
- California State Coastal Conservancy 4
- California State Lands Commission 3
- Other State 3
- California Department of Water Resources 3
- San Luis Obispo, City of 2
- United States Fish and Wildlife Service 2
- San Diego State University 2
- The Nature Conservancy 1
- California State University Sonoma 1
- National Audubon Society 1
- Santa Barbara Trust for Historic Preservation 1
MNG_AG_TYP 7
ACCESS_TYP 1
- Restricted Access · 145 ✖
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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
125 | 125 | 124 | {"type": "Polygon", "coordinates": [[[-122.16054, 37.91443], [-122.15949, 37.91447], [-122.15824, 37.91493], [-122.15833, 37.91517], [-122.15835, 37.9154], [-122.15843, 37.91558], [-122.15855, 37.91562], [-122.1591, 37.91596], [-122.15923, 37.916], [-122.15932, 37.91606], [-122.15944, 37.9161], [-122.15978, 37.91678], [-122.15987, 37.91706], [-122.15989, 37.91733], [-122.15981, 37.91743], [-122.15968, 37.9175], [-122.15952, 37.91752], [-122.1583, 37.91752], [-122.15781, 37.91755], [-122.15781, 37.9177], [-122.15682, 37.91818], [-122.15556, 37.91921], [-122.15437, 37.92001], [-122.15249, 37.92204], [-122.15111, 37.92218], [-122.14987, 37.92221], [-122.14886, 37.92159], [-122.14828, 37.92145], [-122.14816, 37.92139], [-122.14803, 37.92129], [-122.14763, 37.92077], [-122.14752, 37.92071], [-122.14689, 37.92039], [-122.14573, 37.91988], [-122.14487, 37.91881], [-122.14368, 37.91819], [-122.14285, 37.91769], [-122.14266, 37.9176], [-122.14226, 37.91738], [-122.14209, 37.91701], [-122.14195, 37.91666], [-122.14182, 37.91621], [-122.14211, 37.9161], [-122.14325, 37.91561], [-122.14391, 37.91541], [-122.14487, 37.91524], [-122.14541, 37.91512], [-122.14599, 37.91505], [-122.14652, 37.91488], [-122.14719, 37.91472], [-122.14806, 37.91437], [-122.14828, 37.91418], [-122.14845, 37.91387], [-122.14876, 37.91372], [-122.14919, 37.91365], [-122.14961, 37.91369], [-122.14986, 37.91367], [-122.15009, 37.91362], [-122.15051, 37.91345], [-122.15067, 37.91336], [-122.1508, 37.91331], [-122.15093, 37.9132], [-122.15112, 37.91294], [-122.15129, 37.91276], [-122.15141, 37.91268], [-122.15173, 37.91256], [-122.15298, 37.91254], [-122.15334, 37.91257], [-122.15363, 37.91257], [-122.15418, 37.9127], [-122.15462, 37.91292], [-122.15559, 37.91319], [-122.15586, 37.91333], [-122.15636, 37.91343], [-122.15653, 37.91344], [-122.15685, 37.9134], [-122.15756, 37.9135], [-122.15813, 37.9136], [-122.15841, 37.91372], [-122.15882, 37.91396], [-122.15901, 37.91397], [-122.15914, 37.91394], [-122.1593, 37.91388], [-122.15958, 37.91383], [-122.15976, 37.91392], [-122.1601, 37.91419], [-122.16054, 37.91443]]]} | Restricted Access 2 | 315 | Russell Research Station (UC) | 24744 | 217 | University of California 53 | State 5 | State Agency 5 | http://nrs.ucop.edu/ | Other State 5 | 217 | University of California 51 | State 5 | State Agency 5 | Contra Costa 12 | 247.32 | Russell Research Station (UC) | None 17 | |||
2162 | 2162 | 2161 | {"type": "Polygon", "coordinates": [[[-122.1072, 38.49368], [-122.10672, 38.49336], [-122.10649, 38.49316], [-122.10637, 38.49012], [-122.10659, 38.49004], [-122.10674, 38.48989], [-122.10698, 38.4896], [-122.10718, 38.48928], [-122.1072, 38.49368]]]} | Restricted Access 2 | 17585 | Quail Ridge | 24047 | 217 | University of California 53 | State 5 | State Agency 5 | http://nrs.ucop.edu/ | Other State 5 | 217 | University of California 51 | State 5 | State Agency 5 | Napa 11 | 6.615 | Quail Ridge | 1991 | None 178 | ||
3528 | 3528 | 3527 | {"type": "Polygon", "coordinates": [[[-120.73191, 40.62673], [-120.72607, 40.62669], [-120.72666, 40.62644], [-120.72861, 40.62224], [-120.72666, 40.62227], [-120.72674, 40.61939], [-120.72188, 40.61937], [-120.72192, 40.61796], [-120.72202, 40.61567], [-120.72661, 40.61542], [-120.72693, 40.61539], [-120.72841, 40.61537], [-120.73165, 40.6202], [-120.7318, 40.62318], [-120.73191, 40.62673]]]} | Restricted Access 2 | 28071 | Eagle Lake Field Station | 18339 | 217 | University of California 53 | State 5 | State Agency 5 | http://nrs.ucop.edu/ | Other State 5 | 217 | University of California 51 | State 5 | State Agency 5 | Lassen 54 | 147.826 | Eagle Lake Field Station | None 293 | |||
3734 | 3734 | 3733 | {"type": "MultiPolygon", "coordinates": [[[[-122.31785, 37.90207], [-122.31749, 37.90263], [-122.3175, 37.90285], [-122.31661, 37.90177], [-122.31604, 37.90104], [-122.31593, 37.90086], [-122.31581, 37.90061], [-122.31574, 37.90032], [-122.31575, 37.90024], [-122.31577, 37.90016], [-122.31585, 37.90005], [-122.31596, 37.89998], [-122.31612, 37.89993], [-122.31785, 37.90207]]], [[[-122.31976, 37.90599], [-122.31923, 37.906], [-122.3171, 37.90343], [-122.31757, 37.90318], [-122.31802, 37.90409], [-122.31829, 37.90458], [-122.31976, 37.90599]]]]} | Restricted Access 2 | 113 | McLaughlin Eastshore State Park | 29198 | 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 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/parks/eastshore | Contra Costa 12 | 7.835 | McLaughlin Eastshore SP | None 312 | ||
4103 | 4103 | 4102 | {"type": "Polygon", "coordinates": [[[-120.13295, 34.59237], [-120.13291, 34.59524], [-120.12773, 34.5952], [-120.12768, 34.59802], [-120.12682, 34.59784], [-120.12694, 34.59711], [-120.12699, 34.59605], [-120.1268, 34.59601], [-120.12734, 34.59501], [-120.12845, 34.59417], [-120.12826, 34.59379], [-120.1283, 34.59233], [-120.13295, 34.59237]]]} | Restricted Access 2 | 47041 | Santa Ines Mission Mill | 30693 | 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 | 3372 | Santa Barbara Trust for Historic Preservation 706 | Non Profit 6 | Non Profit - Other 20 | http://www.sbthp.org/ | Santa Barbara 7 | 40.009 | Santa Ines Mission Mill | None 356 | ||
4306 | 4306 | 4305 | {"type": "Polygon", "coordinates": [[[-121.47627, 38.28439], [-121.47627, 38.28439], [-121.47626, 38.29098], [-121.47106, 38.28433], [-121.47627, 38.28439]]]} | Restricted Access 2 | 45350 | Stone Lakes | 25872 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Sacramento 41 | 41.206 | Stone Lakes | None 380 | ||||
4350 | 4350 | 4349 | {"type": "MultiPolygon", "coordinates": [[[[-116.4033, 33.63437], [-116.40313, 33.6346], [-116.40304, 33.63478], [-116.40298, 33.63498], [-116.40295, 33.63518], [-116.40295, 33.63581], [-116.40292, 33.63608], [-116.40286, 33.63631], [-116.40277, 33.63657], [-116.40256, 33.63694], [-116.40226, 33.6373], [-116.40178, 33.63777], [-116.4014, 33.63824], [-116.40107, 33.63875], [-116.40058, 33.63974], [-116.40027, 33.64025], [-116.39983, 33.64081], [-116.39904, 33.64162], [-116.39092, 33.64162], [-116.39091, 33.67062], [-116.3821, 33.67067], [-116.37575, 33.67069], [-116.37657, 33.67462], [-116.37352, 33.67895], [-116.37352, 33.6778], [-116.36487, 33.67777], [-116.36488, 33.67069], [-116.35623, 33.67066], [-116.35622, 33.65615], [-116.33884, 33.65617], [-116.33884, 33.64166], [-116.35622, 33.64164], [-116.3562, 33.62714], [-116.33883, 33.62715], [-116.33882, 33.61264], [-116.3562, 33.61263], [-116.35621, 33.62714], [-116.37349, 33.62716], [-116.39092, 33.62711], [-116.40321, 33.62712], [-116.40314, 33.62853], [-116.40306, 33.62853], [-116.40304, 33.6288], [-116.40311, 33.62883], [-116.40304, 33.62909], [-116.40295, 33.62935], [-116.40284, 33.62959], [-116.40239, 33.63034], [-116.40232, 33.63049], [-116.40224, 33.63081], [-116.40222, 33.63098], [-116.40225, 33.63131], [-116.40236, 33.63163], [-116.4025, 33.63189], [-116.40269, 33.63213], [-116.40291, 33.63232], [-116.40327, 33.63257], [-116.40339, 33.63269], [-116.40349, 33.63281], [-116.40361, 33.63301], [-116.40368, 33.63323], [-116.40371, 33.63346], [-116.40369, 33.63369], [-116.40363, 33.63388], [-116.40355, 33.63406], [-116.40345, 33.6342], [-116.4033, 33.63437]]], [[[-116.46016, 33.61247], [-116.44282, 33.61252], [-116.44282, 33.61006], [-116.44269, 33.61005], [-116.44269, 33.60952], [-116.44294, 33.60951], [-116.44294, 33.60891], [-116.44282, 33.6089], [-116.44283, 33.6044], [-116.44501, 33.6044], [-116.44504, 33.60344], [-116.45248, 33.60347], [-116.45249, 33.59796], [-116.46006, 33.59793], [-116.46016, 33.61247]]]]} | Restricted Access 2 | 48461 | Boyd Deep Canyon Desert Research Center | 33174 | 217 | University of California 53 | State 5 | State Agency 5 | http://nrs.ucop.edu/ | Other State 5 | 217 | University of California 51 | State 5 | State Agency 5 | https://ucnrs.org/reserves/boyd-deep-canyon-desert-research-center/ | Riverside 10 | 6239.662 | Boyd Deep Canyon Desert Research Ctr. | None 384 | ||
5751 | 5751 | 5750 | {"type": "MultiPolygon", "coordinates": [[[[-115.64839, 34.81949], [-115.63082, 34.81943], [-115.6308, 34.80941], [-115.62627, 34.80938], [-115.62642, 34.80577], [-115.64835, 34.80584], [-115.64839, 34.81949]]], [[[-115.66529, 34.77683], [-115.66528, 34.78407], [-115.6483, 34.78406], [-115.64827, 34.78408], [-115.6483, 34.79132], [-115.63077, 34.79127], [-115.63075, 34.79129], [-115.63077, 34.77678], [-115.66529, 34.77683]]], [[[-115.68285, 34.81958], [-115.66525, 34.81956], [-115.66531, 34.80578], [-115.68279, 34.80584], [-115.68285, 34.81958]]]]} | Restricted Access 2 | 3199 | Sweeney Granite Mountains Desert Research Center | 26101 | 217 | University of California 53 | State 5 | State Agency 5 | http://nrs.ucop.edu/ | Other State 5 | 217 | University of California 51 | State 5 | State Agency 5 | San Bernardino 22 | 2193.744 | Sweeney Granite Mtns. Desert Research Ctr. | None 463 | |||
6190 | 6190 | 6189 | {"type": "Polygon", "coordinates": [[[-119.70992, 34.46417], [-119.70991, 34.46472], [-119.70956, 34.46473], [-119.70965, 34.46495], [-119.70989, 34.46535], [-119.70981, 34.46588], [-119.7094, 34.46606], [-119.70917, 34.46612], [-119.70901, 34.46629], [-119.70864, 34.46641], [-119.70706, 34.4664], [-119.70705, 34.46633], [-119.70692, 34.46627], [-119.70661, 34.46602], [-119.70648, 34.46582], [-119.70629, 34.46566], [-119.70606, 34.46556], [-119.70574, 34.46546], [-119.70572, 34.46839], [-119.70153, 34.46838], [-119.7015, 34.47222], [-119.69721, 34.4722], [-119.69734, 34.46472], [-119.70858, 34.46473], [-119.70858, 34.46476], [-119.70865, 34.46494], [-119.70912, 34.46495], [-119.70925, 34.46472], [-119.70939, 34.46472], [-119.70941, 34.46447], [-119.70973, 34.4642], [-119.70992, 34.46417]]]} | Restricted Access 2 | 1555 | UC Reserve System land | 26639 | 217 | University of California 53 | State 5 | State Agency 5 | http://nrs.ucop.edu/ | Other State 5 | 217 | University of California 51 | State 5 | State Agency 5 | Santa Barbara 7 | 133.642 | UC Reserve System land | None 499 | |||
6367 | 6367 | 6366 | {"type": "MultiPolygon", "coordinates": [[[[-122.40288, 38.42006], [-122.39982, 38.42256], [-122.39819, 38.42129], [-122.40153, 38.41858], [-122.40288, 38.42006]]], [[[-122.4118, 38.42984], [-122.41092, 38.43057], [-122.41011, 38.43121], [-122.40947, 38.43071], [-122.40833, 38.42986], [-122.4072, 38.42896], [-122.40913, 38.42735], [-122.4118, 38.42984]]]]} | Restricted Access 2 | 1750 | UC Agricultural Research Station | 26634 | 217 | University of California 53 | State 5 | State Agency 5 | http://nrs.ucop.edu/ | Other State 5 | 217 | University of California 51 | State 5 | State Agency 5 | Napa 11 | 40.126 | UC Agricultural Research Station | None 517 | |||
8391 | 8391 | 8390 | {"type": "Polygon", "coordinates": [[[-119.00082, 37.62582], [-119.00081, 37.6306], [-118.99984, 37.63154], [-118.99949, 37.63197], [-118.99927, 37.63229], [-118.99906, 37.63264], [-118.99879, 37.63316], [-118.99607, 37.63312], [-118.99605, 37.63429], [-118.99278, 37.63466], [-118.99276, 37.63471], [-118.99276, 37.63445], [-118.9919, 37.63432], [-118.99152, 37.63428], [-118.99137, 37.63399], [-118.9914, 37.63239], [-118.99193, 37.63238], [-118.99191, 37.63111], [-118.99183, 37.6311], [-118.99179, 37.62805], [-118.99295, 37.62728], [-118.9931, 37.6272], [-118.99327, 37.62714], [-118.99345, 37.6271], [-118.99363, 37.62709], [-118.99368, 37.62779], [-118.99456, 37.62775], [-118.99527, 37.62808], [-118.99528, 37.62709], [-118.99548, 37.62703], [-118.99567, 37.62695], [-118.9959, 37.62679], [-118.99599, 37.62669], [-118.99605, 37.62658], [-118.99609, 37.62646], [-118.9961, 37.62634], [-118.99601, 37.62589], [-119.00082, 37.62582]]]} | Restricted Access 2 | 48488 | Valentine Eastern Sierra Reserve - Valentine Camp | 33199 | 217 | University of California 53 | State 5 | State Agency 5 | http://nrs.ucop.edu/ | Other State 5 | 217 | University of California 51 | State 5 | State Agency 5 | https://ucnrs.org/reserves/valentine-camp-reserve/ | Mono 32 | 149.894 | Valentine Eastern Sierra Reserve - Valentine Camp | None 704 | ||
8447 | 8447 | 8446 | {"type": "MultiPolygon", "coordinates": [[[[-121.62267, 37.80157], [-121.62226, 37.80072], [-121.62267, 37.80062], [-121.62267, 37.80062], [-121.62267, 37.80157]]], [[[-121.55271, 37.82044], [-121.5527, 37.82055], [-121.55258, 37.82072], [-121.55211, 37.82084], [-121.5519, 37.82083], [-121.55134, 37.82068], [-121.55128, 37.82061], [-121.55125, 37.82052], [-121.55127, 37.82045], [-121.55133, 37.82041], [-121.55148, 37.82039], [-121.55211, 37.82049], [-121.55256, 37.82043], [-121.55271, 37.82044]]], [[[-121.61977, 37.80132], [-121.61811, 37.80233], [-121.60775, 37.81064], [-121.60703, 37.81129], [-121.60645, 37.81193], [-121.59685, 37.82357], [-121.59566, 37.82283], [-121.59566, 37.82262], [-121.59995, 37.81661], [-121.60495, 37.81028], [-121.60494, 37.80939], [-121.60484, 37.80938], [-121.60486, 37.80574], [-121.60879, 37.80398], [-121.61977, 37.80132]]], [[[-121.62324, 37.80314], [-121.62261, 37.80386], [-121.62268, 37.80861], [-121.62145, 37.80934], [-121.61396, 37.80941], [-121.60494, 37.81918], [-121.60473, 37.81939], [-121.59966, 37.82384], [-121.59888, 37.82485], [-121.59861, 37.82466], [-121.59756, 37.82401], [-121.6072, 37.81232], [-121.60773, 37.81173], [-121.60839, 37.81115], [-121.62101, 37.80102], [-121.62209, 37.80076], [-121.62267, 37.80196], [-121.62267, 37.80228], [-121.62283, 37.80228], [-121.62324, 37.80314]]], [[[-121.60028, 37.83829], [-121.59481, 37.83821], [-121.59483, 37.83946], [-121.59478, 37.83962], [-121.59461, 37.83973], [-121.59436, 37.83973], [-121.59423, 37.83967], [-121.59408, 37.83952], [-121.59409, 37.83933], [-121.59415, 37.83907], [-121.59372, 37.83863], [-121.59371, 37.83864], [-121.59376, 37.83898], [-121.59362, 37.83937], [-121.59289, 37.8395], [-121.59271, 37.84067], [-121.59224, 37.84168], [-121.5918, 37.84299], [-121.59147, 37.84356], [-121.59136, 37.84414], [-121.59164, 37.84485], [-121.5914, 37.84562], [-121.59176, 37.84608], [-121.592, 37.84684], [-121.59184, 37.84734], [-121.59107, 37.84797], [-121.59055, 37.84814], [-121.59054, 37.84838], [-121.5902, 37.84881], [-121.58979, 37.84904], [-121.58929, 37.84921], [-121.58897, 37.84925], [-121.58851, 37.84919], [-121.58805, 37.84896], [-121.58786, 37.84883], [-121.58727, 37.8488], [-121.58631, 37.84888], [-121.5852, 37.84904], [-121.58491, 37.84914], [-121.5849, 37.84975], [-121.58538, 37.84994], [-121.58533, 37.85066], [-121.58551, 37.8512], [-121.58601, 37.85189], [-121.58598, 37.85264], [-121.58555, 37.85313], [-121.58501, 37.85341], [-121.58502, 37.85346], [-121.5844, 37.85383], [-121.58409, 37.85522], [-121.58396, 37.85539], [-121.58346, 37.85618], [-121.58343, 37.85676], [-121.58347, 37.85742], [-121.58344, 37.85804], [-121.58332, 37.85835], [-121.58306, 37.85853], [-121.58233, 37.85875], [-121.58124, 37.85883], [-121.58047, 37.85883], [-121.58013, 37.85882], [-121.57969, 37.85865], [-121.5764, 37.8585], [-121.5764, 37.85848], [-121.5775, 37.85806], [-121.57724, 37.85739], [-121.57561, 37.85733], [-121.57328, 37.85701], [-121.56941, 37.85671], [-121.56829, 37.85672], [-121.56799, 37.85707], [-121.56788, 37.85681], [-121.56625, 37.85743], [-121.56515, 37.85624], [-121.56291, 37.85322], [-121.56211, 37.85322], [-121.55881, 37.8459], [-121.55961, 37.84589], [-121.553, 37.82898], [-121.55738, 37.82822], [-121.55891, 37.8263], [-121.56794, 37.82621], [-121.56796, 37.82531], [-121.57554, 37.82543], [-121.57738, 37.82369], [-121.58162, 37.82007], [-121.58339, 37.82005], [-121.58611, 37.82058], [-121.58617, 37.82384], [-121.58999, 37.82384], [-121.59262, 37.82531], [-121.59363, 37.82576], [-121.59479, 37.82384], [-121.59565, 37.82384], [-121.59568, 37.82497], [-121.59656, 37.82391], [-121.59727, 37.82435], [-121.59569, 37.82627], [-121.59571, 37.82748], [-121.59686, 37.82747], [-121.59659, 37.82758], [-121.59507, 37.8298], [-121.59535, 37.83007], [-121.59559, 37.83007], [-121.59881, 37.83171], [-121.59931, 37.83214], [-121.60036, 37.83424], [-121.60028, 37.83829]]]]} | Restricted Access 2 | 13126 | Clifton Court Forebay | 29182 | 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 | 3217.242 | Clifton Court Forebay | 0 | None 707 | ||
8999 | 8999 | 8998 | {"type": "Polygon", "coordinates": [[[-116.70159, 33.88765], [-116.70159, 33.88807], [-116.69746, 33.88804], [-116.69744, 33.89518], [-116.68886, 33.89519], [-116.68875, 33.888], [-116.68638, 33.88798], [-116.68652, 33.88782], [-116.68635, 33.88771], [-116.68882, 33.8877], [-116.68884, 33.888], [-116.69731, 33.88804], [-116.69732, 33.88767], [-116.70159, 33.88765]]]} | Restricted Access 2 | 14873 | UC Oasis de Los Osos | 26638 | 217 | University of California 53 | State 5 | State Agency 5 | http://nrs.ucop.edu/ | Other State 5 | 217 | University of California 51 | State 5 | State Agency 5 | Riverside 10 | 163.171 | UC Oasis de Los Osos | None 748 | |||
9238 | 9238 | 9237 | {"type": "Polygon", "coordinates": [[[-117.00635, 34.01893], [-117.00623, 34.03414], [-116.99983, 34.03445], [-116.99983, 34.03355], [-116.99977, 34.0335], [-116.99545, 34.03333], [-116.99546, 34.02975], [-116.99022, 34.02962], [-116.99015, 34.03315], [-116.98469, 34.03296], [-116.98051, 34.03284], [-116.98041, 34.0259], [-116.99028, 34.02608], [-116.99036, 34.02243], [-116.98606, 34.02232], [-116.98628, 34.01867], [-116.99042, 34.0188], [-116.99038, 34.0183], [-116.98998, 34.01603], [-116.99139, 34.0165], [-116.9918, 34.01637], [-116.99214, 34.0163], [-116.99253, 34.01631], [-116.993, 34.01627], [-116.99345, 34.01602], [-116.99383, 34.0157], [-116.9941, 34.0157], [-116.99454, 34.01566], [-116.99512, 34.01572], [-116.99546, 34.01578], [-116.99573, 34.01569], [-116.99713, 34.01637], [-116.99777, 34.01644], [-116.99863, 34.01623], [-116.99915, 34.01625], [-116.99969, 34.01638], [-116.99977, 34.01645], [-117.00026, 34.0165], [-117.00066, 34.01657], [-117.00137, 34.01608], [-117.00196, 34.01594], [-117.00204, 34.01569], [-117.00213, 34.01554], [-117.00221, 34.01516], [-117.00269, 34.01519], [-117.00242, 34.01682], [-117.00105, 34.01837], [-117.00129, 34.01856], [-117.00108, 34.01901], [-117.00635, 34.01893]], [[-117.00051, 34.01841], [-117.00053, 34.01822], [-117.00036, 34.01817], [-117.00013, 34.01807], [-116.99983, 34.0183], [-116.99985, 34.01898], [-116.99982, 34.01899], [-116.99982, 34.01902], [-117.00049, 34.019], [-117.00078, 34.01867], [-117.00057, 34.01852], [-117.00051, 34.01841]]]} | Restricted Access 2 | 15366 | Wildwood Canyon | 27517 | 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 | San Bernardino 22 | 843.596 | Wildwood Canyon | 2002 | None 764 | ||
10050 | 10050 | 10049 | {"type": "MultiPolygon", "coordinates": [[[[-121.5504, 37.81996], [-121.55037, 37.82003], [-121.55026, 37.82006], [-121.55015, 37.82005], [-121.55003, 37.82001], [-121.5497, 37.81985], [-121.54955, 37.8198], [-121.54921, 37.81974], [-121.54909, 37.81969], [-121.54905, 37.81963], [-121.54906, 37.81953], [-121.54904, 37.81943], [-121.54883, 37.81913], [-121.5488, 37.81906], [-121.54885, 37.81898], [-121.54892, 37.81894], [-121.54902, 37.81894], [-121.54918, 37.81899], [-121.54959, 37.81916], [-121.54998, 37.81948], [-121.55031, 37.81964], [-121.55038, 37.8197], [-121.55038, 37.81981], [-121.5504, 37.81996]]], [[[-121.55519, 37.81644], [-121.5552, 37.81652], [-121.55515, 37.81671], [-121.55508, 37.81681], [-121.55496, 37.8169], [-121.5547, 37.81714], [-121.55391, 37.81771], [-121.55365, 37.81793], [-121.55346, 37.81816], [-121.55327, 37.81857], [-121.55309, 37.81929], [-121.55301, 37.81955], [-121.55289, 37.81981], [-121.55287, 37.81989], [-121.55264, 37.82016], [-121.55244, 37.82024], [-121.5522, 37.82026], [-121.5519, 37.82024], [-121.55144, 37.82011], [-121.55116, 37.81998], [-121.55094, 37.81982], [-121.55077, 37.81964], [-121.55053, 37.81949], [-121.54958, 37.81885], [-121.54934, 37.81872], [-121.55268, 37.8155], [-121.55287, 37.81562], [-121.55298, 37.81575], [-121.55328, 37.81602], [-121.55345, 37.81609], [-121.5538, 37.81617], [-121.55403, 37.8162], [-121.55452, 37.81624], [-121.55477, 37.81622], [-121.55505, 37.8163], [-121.55519, 37.81644]]]]} | Restricted Access 2 | 17388 | Clifton Court Forebay | 29182 | 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 Joaquin 39 | 34.457 | Clifton Court Forebay | None 867 | |||
10502 | 10502 | 10501 | {"type": "MultiPolygon", "coordinates": [[[[-122.50494, 38.0833], [-122.50283, 38.08438], [-122.50242, 38.08446], [-122.5019, 38.08401], [-122.50167, 38.08357], [-122.50164, 38.08318], [-122.50338, 38.08236], [-122.50428, 38.08204], [-122.50477, 38.08284], [-122.50494, 38.0833]]], [[[-122.50616, 38.07765], [-122.50607, 38.07778], [-122.50376, 38.07881], [-122.50225, 38.07899], [-122.50211, 38.07872], [-122.50208, 38.07744], [-122.50246, 38.07689], [-122.50263, 38.07687], [-122.50616, 38.07765]]], [[[-122.52681, 38.07788], [-122.52681, 38.07802], [-122.5259, 38.07858], [-122.52583, 38.07857], [-122.52545, 38.07827], [-122.52507, 38.07734], [-122.52478, 38.07693], [-122.52426, 38.07651], [-122.52464, 38.07376], [-122.52473, 38.07379], [-122.52522, 38.07418], [-122.52528, 38.07479], [-122.52516, 38.07509], [-122.52516, 38.07557], [-122.52588, 38.07617], [-122.52643, 38.07731], [-122.52681, 38.07788]]], [[[-122.52959, 38.08051], [-122.52804, 38.08099], [-122.52751, 38.08086], [-122.52649, 38.08112], [-122.52605, 38.08132], [-122.52594, 38.08124], [-122.52613, 38.08116], [-122.52704, 38.08059], [-122.52732, 38.08038], [-122.52755, 38.08015], [-122.52815, 38.07944], [-122.52834, 38.07928], [-122.52856, 38.07915], [-122.52894, 38.07901], [-122.52959, 38.08051]]]]} | Restricted Access 2 | 18623 | Bel Marin Keys #5 | 15962 | 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 | 43.415 | Bel Marin Keys #5 | 2001 | None 918 | ||
12259 | 12259 | 12258 | {"type": "MultiPolygon", "coordinates": [[[[-121.79497, 36.91818], [-121.79476, 36.92157], [-121.79287, 36.92142], [-121.792, 36.92038], [-121.79156, 36.91989], [-121.79092, 36.91958], [-121.79044, 36.91919], [-121.79006, 36.91924], [-121.78959, 36.9184], [-121.7892, 36.91777], [-121.79015, 36.91691], [-121.79042, 36.91742], [-121.79241, 36.9166], [-121.79251, 36.91675], [-121.79276, 36.91731], [-121.79314, 36.91807], [-121.79321, 36.91828], [-121.79323, 36.91864], [-121.79447, 36.91813], [-121.79497, 36.91818]]], [[[-121.79513, 36.91547], [-121.79504, 36.91694], [-121.79469, 36.91689], [-121.79447, 36.91679], [-121.79439, 36.91659], [-121.79438, 36.91643], [-121.79442, 36.91627], [-121.79454, 36.9161], [-121.79471, 36.91597], [-121.79464, 36.91567], [-121.79513, 36.91547]]]]} | Restricted Access 2 | 25824 | Struve Slough - California Coastal Conservancy | 25932 | 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 | Santa Cruz 5 | 40.585 | Struve Slough - California Coastal Conservancy | None 1069 | |||
12466 | 12466 | 12465 | {"type": "Polygon", "coordinates": [[[-122.31807, 37.82977], [-122.3145, 37.83558], [-122.31384, 37.83676], [-122.31367, 37.83701], [-122.30448, 37.837], [-122.30448, 37.83642], [-122.30311, 37.83642], [-122.3031, 37.83648], [-122.30259, 37.83653], [-122.3021, 37.83672], [-122.30152, 37.83669], [-122.30051, 37.83676], [-122.29922, 37.83705], [-122.29895, 37.83704], [-122.29802, 37.83651], [-122.29744, 37.83499], [-122.29694, 37.83457], [-122.29688, 37.8339], [-122.29615, 37.83373], [-122.29546, 37.83375], [-122.29554, 37.83363], [-122.29611, 37.83345], [-122.29659, 37.83311], [-122.29672, 37.8329], [-122.29619, 37.83224], [-122.29627, 37.83193], [-122.29587, 37.83155], [-122.29613, 37.83127], [-122.29629, 37.83082], [-122.29615, 37.83062], [-122.29632, 37.83055], [-122.29641, 37.83044], [-122.29629, 37.83016], [-122.29573, 37.82964], [-122.29595, 37.82963], [-122.29654, 37.82997], [-122.29727, 37.83023], [-122.29786, 37.83006], [-122.29816, 37.83018], [-122.2983, 37.82971], [-122.2982, 37.82942], [-122.29796, 37.82915], [-122.29825, 37.82843], [-122.29849, 37.82846], [-122.29865, 37.82825], [-122.29901, 37.82821], [-122.29925, 37.8278], [-122.30112, 37.82678], [-122.3011, 37.82645], [-122.30548, 37.82556], [-122.30748, 37.82592], [-122.30868, 37.82589], [-122.31807, 37.82977]]]} | Restricted Access 2 | 28130 | McLaughlin Eastshore State Park | 29198 | 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 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/parks/eastshore | Alameda 17 | 456.308 | McLaughlin Eastshore SP | None 1084 | ||
12606 | 12606 | 12605 | {"type": "MultiPolygon", "coordinates": [[[[-122.31376, 37.89702], [-122.31276, 37.89724], [-122.3125, 37.89694], [-122.31163, 37.89607], [-122.31036, 37.89455], [-122.31003, 37.89409], [-122.30983, 37.89374], [-122.30966, 37.89338], [-122.30945, 37.89281], [-122.30928, 37.89225], [-122.30916, 37.89226], [-122.30913, 37.89207], [-122.30909, 37.89161], [-122.3091, 37.89106], [-122.30915, 37.89066], [-122.3093, 37.8898], [-122.30997, 37.89189], [-122.31013, 37.89227], [-122.31036, 37.89272], [-122.31064, 37.89313], [-122.31376, 37.89702]]], [[[-122.32444, 37.89221], [-122.32262, 37.89493], [-122.32102, 37.89532], [-122.32101, 37.89498], [-122.31872, 37.89504], [-122.31871, 37.89587], [-122.31644, 37.89642], [-122.31394, 37.89698], [-122.31081, 37.89309], [-122.31056, 37.89272], [-122.31042, 37.89247], [-122.31022, 37.89207], [-122.31011, 37.89177], [-122.30943, 37.88963], [-122.30934, 37.88963], [-122.30949, 37.88875], [-122.30955, 37.8886], [-122.30959, 37.88857], [-122.30966, 37.88854], [-122.30979, 37.88855], [-122.30993, 37.88863], [-122.31022, 37.88909], [-122.31037, 37.88923], [-122.31047, 37.88963], [-122.31333, 37.88964], [-122.31334, 37.88985], [-122.312, 37.88997], [-122.31197, 37.89022], [-122.31394, 37.8917], [-122.31624, 37.89169], [-122.31634, 37.8909], [-122.31763, 37.89086], [-122.31991, 37.88993], [-122.32312, 37.8899], [-122.32356, 37.8913], [-122.32409, 37.89131], [-122.32444, 37.89221]]]]} | Restricted Access 2 | 29272 | Albany State Marine Reserve | 30562 | 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 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 181.83 | Albany State Marine Reserve | 1985 | None 1092 | ||
12997 | 12997 | 12996 | {"type": "Polygon", "coordinates": [[[-122.3031, 37.83648], [-122.3031, 37.837], [-122.30105, 37.837], [-122.2977, 37.83767], [-122.29768, 37.83765], [-122.29741, 37.8377], [-122.29731, 37.83767], [-122.2972, 37.83753], [-122.29701, 37.83713], [-122.29573, 37.83491], [-122.29545, 37.83431], [-122.29554, 37.83429], [-122.29554, 37.83428], [-122.2955, 37.83419], [-122.29541, 37.83422], [-122.29463, 37.83251], [-122.29457, 37.8323], [-122.29463, 37.83228], [-122.29454, 37.83192], [-122.29448, 37.83192], [-122.29442, 37.83131], [-122.29443, 37.83091], [-122.29455, 37.82968], [-122.29459, 37.82943], [-122.29471, 37.82908], [-122.29486, 37.82876], [-122.29532, 37.82895], [-122.2954, 37.82883], [-122.29539, 37.82882], [-122.29494, 37.82864], [-122.29515, 37.82836], [-122.29537, 37.82813], [-122.29566, 37.82789], [-122.29604, 37.82765], [-122.2964, 37.82748], [-122.29679, 37.82734], [-122.29713, 37.82725], [-122.3011, 37.82645], [-122.30112, 37.82678], [-122.29925, 37.8278], [-122.29901, 37.82821], [-122.29865, 37.82825], [-122.29849, 37.82846], [-122.29825, 37.82844], [-122.29796, 37.82915], [-122.2982, 37.82942], [-122.2983, 37.82971], [-122.29816, 37.83018], [-122.29786, 37.83006], [-122.29727, 37.83023], [-122.29654, 37.82997], [-122.29596, 37.82963], [-122.29574, 37.82964], [-122.29629, 37.83016], [-122.29641, 37.83044], [-122.29632, 37.83055], [-122.29616, 37.83062], [-122.29629, 37.83081], [-122.29613, 37.83127], [-122.29587, 37.83155], [-122.29628, 37.83193], [-122.29619, 37.83224], [-122.29672, 37.8329], [-122.29659, 37.83311], [-122.29611, 37.83345], [-122.29554, 37.83363], [-122.29547, 37.83374], [-122.29615, 37.83373], [-122.29688, 37.8339], [-122.29694, 37.83457], [-122.29744, 37.83499], [-122.29802, 37.83651], [-122.29895, 37.83704], [-122.29922, 37.83705], [-122.30051, 37.83676], [-122.30152, 37.83669], [-122.3021, 37.83672], [-122.30259, 37.83653], [-122.3031, 37.83648]]]} | Restricted Access 2 | 46940 | Emeryville Crescent State Marine Reserve | 30564 | 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 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 58.981 | Emeryville Crescent State Marine Reserve | 1985 | None 1127 |
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]);