units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,141 rows where MNG_AG_TYP = 5 sorted by GAP_STS
This data as json, copyable, CSV (advanced)
DES_TP >30
- State Conservation Area 380
- State Park 207
- State Resource Management Area 159
- State Recreation Area 144
- State Other or Unknown 69
- State Historic or Cultural Area 62
- National Monument or Landmark 2
- National Wildlife Refuge 2
- State Wilderness 2
- National 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
- …
MNG_AGENCY 20
- California Department of Fish and Wildlife 442
- California Department of Parks and Recreation 378
- California State Lands Commission 82
- University of California 55
- Other State 40
- California Department of Transportation 29
- California Department of Water Resources 19
- Santa Monica Mountains Conservancy 17
- California Department of General Services 13
- California Department of Forestry and Fire Protection 9
- California Wildlife Conservation Board 9
- San Diego State University 7
- California State Coastal Conservancy 7
- Coachella Valley Mountains Conservancy 5
- Napa Valley College 2
- California State University 2
- California Tahoe Conservancy 2
- California Department of Veterans Affairs 1
- California State University Sonoma 1
- California State University Long Beach 1
ACCESS_TYP 4
- Open Access 814
- Restricted Access 147
- No Public Access 132
- Unknown Access 28
MNG_AG_TYP 1
- State Agency · 1,121 ✖
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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3189 | 3189 | 3188 | {"type": "Polygon", "coordinates": [[[-119.71275, 36.9916], [-119.71191, 36.99249], [-119.7112, 36.99207], [-119.71091, 36.99196], [-119.71085, 36.99186], [-119.71077, 36.99183], [-119.71053, 36.99176], [-119.71044, 36.99178], [-119.71062, 36.99139], [-119.71109, 36.99063], [-119.71154, 36.99058], [-119.71275, 36.9916]]]} | Open Access 1 | 28051 | Friant Cove | 19113 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Fresno 9 | 5.884 | Friant Cove | None 262 | ||||
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 | |||
3458 | 3458 | 3457 | {"type": "Polygon", "coordinates": [[[-123.78183, 40.4786], [-123.78172, 40.47967], [-123.78083, 40.47987], [-123.78082, 40.47937], [-123.78064, 40.47893], [-123.78183, 40.4786]]]} | Open Access 1 | 35585 | Other State 43 | 23264 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Humboldt 45 | 2.359 | Other State 43 | None 287 | ||||
3467 | 3467 | 3466 | {"type": "Polygon", "coordinates": [[[-123.67235, 40.14486], [-123.67136, 40.14484], [-123.67139, 40.14413], [-123.67233, 40.14419], [-123.67235, 40.14486]]]} | Open Access 1 | 35712 | Other State 11 | 23251 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Humboldt 45 | 1.562 | Other State 11 | None 289 | ||||
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 | |||
3593 | 3593 | 3592 | {"type": "Polygon", "coordinates": [[[-117.85857, 34.66067], [-117.85414, 34.66065], [-117.84525, 34.66054], [-117.84522, 34.65319], [-117.85854, 34.65328], [-117.85857, 34.66067]]]} | Open Access 1 | 29212 | BLM | 16166 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | Los Angeles 6 | 247.189 | BLM | None 300 | |||
3833 | 3833 | 3832 | {"type": "Polygon", "coordinates": [[[-121.81298, 36.94641], [-121.81273, 36.94671], [-121.81211, 36.94655], [-121.81235, 36.94589], [-121.81273, 36.94612], [-121.81298, 36.94641]]]} | Open Access 1 | 45359 | Rancho San Andreas | 24168 | 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 | Santa Cruz 5 | 0.999 | Rancho San Andreas | 2002 | None 323 | ||
3858 | 3858 | 3857 | {"type": "Polygon", "coordinates": [[[-123.83901, 40.46367], [-123.839, 40.46751], [-123.83762, 40.46759], [-123.83761, 40.46748], [-123.83745, 40.46699], [-123.83691, 40.46742], [-123.83606, 40.46793], [-123.83528, 40.46801], [-123.83421, 40.46791], [-123.83496, 40.46784], [-123.83542, 40.46767], [-123.83587, 40.46725], [-123.83707, 40.46638], [-123.83754, 40.46561], [-123.8379, 40.46507], [-123.83813, 40.46474], [-123.83856, 40.46406], [-123.83884, 40.46367], [-123.83901, 40.46367]]]} | Open Access 1 | 35592 | Other State 4 | 23263 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Humboldt 45 | 14.851 | Other State 4 | None 326 | ||||
3860 | 3860 | 3859 | {"type": "Polygon", "coordinates": [[[-123.84468, 40.46319], [-123.84303, 40.46319], [-123.84302, 40.4623], [-123.8433, 40.46219], [-123.84379, 40.4621], [-123.84428, 40.46233], [-123.8444, 40.46257], [-123.84445, 40.46277], [-123.84468, 40.46319]]]} | Open Access 1 | 35598 | Other State 5 | 23265 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Humboldt 45 | 3.304 | Other State 5 | None 327 | ||||
3861 | 3861 | 3860 | {"type": "Polygon", "coordinates": [[[-123.62865, 40.48836], [-123.62865, 40.48852], [-123.62837, 40.48861], [-123.62769, 40.48868], [-123.62714, 40.48877], [-123.62629, 40.48945], [-123.62628, 40.48822], [-123.62671, 40.48819], [-123.62692, 40.48819], [-123.62682, 40.48845], [-123.62683, 40.48846], [-123.62714, 40.48835], [-123.62753, 40.4883], [-123.62865, 40.48836]]]} | Open Access 1 | 35607 | Other State 18 | 23254 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Humboldt 45 | 2.876 | Other State 18 | None 328 | ||||
3862 | 3862 | 3861 | {"type": "Polygon", "coordinates": [[[-123.67237, 40.14091], [-123.67235, 40.14147], [-123.67148, 40.1415], [-123.6715, 40.14089], [-123.67237, 40.14091]]]} | Open Access 1 | 35608 | Other State 14 | 23252 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Humboldt 45 | 1.203 | Other State 14 | None 329 | ||||
3877 | 3877 | 3876 | {"type": "Polygon", "coordinates": [[[-122.82002, 41.67891], [-122.82001, 41.68248], [-122.81502, 41.6825], [-122.815, 41.67891], [-122.82002, 41.67891]]]} | Open Access 1 | 35687 | Other State 17 | 23253 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Siskiyou 28 | 40.983 | Other State 17 | None 332 | ||||
3933 | 3933 | 3932 | {"type": "Polygon", "coordinates": [[[-119.21361, 38.30059], [-119.21338, 38.30059], [-119.21339, 38.29848], [-119.21349, 38.29872], [-119.21356, 38.29909], [-119.21361, 38.30059]]]} | Open Access 1 | 36234 | Other State 26 | 23258 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Mono 32 | 0.864 | Other State 26 | None 338 | ||||
3934 | 3934 | 3933 | {"type": "Polygon", "coordinates": [[[-121.0547, 39.80881], [-121.05325, 39.80955], [-121.0533, 39.8095], [-121.04991, 39.8062], [-121.05152, 39.80559], [-121.0547, 39.80881]]]} | Open Access 1 | 36250 | Other State 23 | 23256 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Plumas 57 | 16.582 | Other State 23 | None 339 | ||||
3967 | 3967 | 3966 | {"type": "Polygon", "coordinates": [[[-122.18624, 37.13506], [-122.18623, 37.13512], [-122.18606, 37.13501], [-122.18556, 37.13484], [-122.18456, 37.13439], [-122.18391, 37.13379], [-122.18339, 37.13353], [-122.18225, 37.13281], [-122.18232, 37.13093], [-122.1818, 37.1305], [-122.18216, 37.13004], [-122.18219, 37.12981], [-122.17623, 37.13003], [-122.17622, 37.13004], [-122.17628, 37.13022], [-122.17015, 37.13295], [-122.16845, 37.13183], [-122.16708, 37.13008], [-122.16652, 37.12959], [-122.1658, 37.12917], [-122.16478, 37.12861], [-122.16458, 37.12846], [-122.1644, 37.12829], [-122.16521, 37.12841], [-122.17376, 37.12442], [-122.17542, 37.12787], [-122.17618, 37.12994], [-122.18257, 37.1297], [-122.18258, 37.12969], [-122.18248, 37.12937], [-122.18309, 37.12927], [-122.18335, 37.13025], [-122.18278, 37.13035], [-122.18261, 37.1298], [-122.18227, 37.12981], [-122.18223, 37.13005], [-122.1819, 37.13049], [-122.18236, 37.1309], [-122.18229, 37.13277], [-122.18343, 37.13349], [-122.18395, 37.13375], [-122.18461, 37.13435], [-122.18557, 37.13479], [-122.18611, 37.13497], [-122.18624, 37.13506]]]} | Open Access 1 | 36653 | Other State 38 | 23261 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Santa Cruz 5 | 130.805 | Other State 38 | None 342 | ||||
3998 | 3998 | 3997 | {"type": "Polygon", "coordinates": [[[-120.65625, 38.38805], [-120.65624, 38.38955], [-120.65544, 38.39046], [-120.65623, 38.39091], [-120.65622, 38.39435], [-120.6562, 38.3953], [-120.65458, 38.39529], [-120.65457, 38.39584], [-120.65152, 38.39572], [-120.65155, 38.39167], [-120.65162, 38.38805], [-120.64725, 38.38813], [-120.64721, 38.38904], [-120.64558, 38.38909], [-120.64561, 38.38897], [-120.64557, 38.38882], [-120.64548, 38.3886], [-120.64534, 38.38857], [-120.64525, 38.38849], [-120.64526, 38.38819], [-120.64286, 38.38825], [-120.64297, 38.38669], [-120.64316, 38.3846], [-120.65168, 38.38443], [-120.65162, 38.38805], [-120.65625, 38.38805]]]} | Open Access 1 | 46796 | Mount Zion Demonstration Forest | 30255 | 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 | Amador 52 | 162.295 | Mount Zion Demonstration Forest | None 348 | |||
4152 | 4152 | 4151 | {"type": "Polygon", "coordinates": [[[-117.97658, 33.91104], [-117.97658, 33.91143], [-117.97591, 33.91182], [-117.97546, 33.91214], [-117.96943, 33.91722], [-117.96887, 33.91721], [-117.97303, 33.91372], [-117.97303, 33.9137], [-117.97384, 33.91309], [-117.9751, 33.91199], [-117.97561, 33.91162], [-117.97658, 33.91104]]]} | Open Access 1 | 48288 | Coyote Creek Bikeway | 32861 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | http://www.lhcm.org/386/Bikeways | Orange 3 | 8.381 | Coyote Creek Bikeway | 2011 | None 358 | |
4180 | 4180 | 4179 | {"type": "Polygon", "coordinates": [[[-121.7562, 37.72355], [-121.75619, 37.73783], [-121.75386, 37.73785], [-121.7539, 37.7308], [-121.7516, 37.73078], [-121.75166, 37.72355], [-121.7562, 37.72355]]]} | No Public Access 3 | 1793 | Livermore Monitoring Station | 21382 | 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 | Alameda 17 | 119.329 | Livermore Monitoring Station | None 362 | |||
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 |
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]);