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)
Suggested facets: AGNCY_LEV, AGNCY_TYP
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
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- 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
- …
MNG_AGENCY 20
- California Department of Fish and Wildlife 443
- California Department of Parks and Recreation 380
- California State Lands Commission 86
- University of California 58
- Other State 43
- California Department of Transportation 30
- California Department of Water Resources 20
- Santa Monica Mountains Conservancy 19
- California Department of General Services 14
- California Department of Forestry and Fire Protection 10
- California Wildlife Conservation Board 9
- San Diego State University 7
- California State Coastal Conservancy 7
- Coachella Valley Mountains Conservancy 5
- California Department of Veterans Affairs 2
- Napa Valley College 2
- California State University 2
- California Tahoe Conservancy 2
- California State University Sonoma 1
- California State University Long Beach 1
ACCESS_TYP 4
- Open Access 827
- Restricted Access 149
- No Public Access 137
- Unknown Access 28
MNG_AG_TYP 1
- State Agency · 1,141 ✖
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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25 | 25 | 24 | {"type": "Polygon", "coordinates": [[[-122.27747, 38.29885], [-122.27706, 38.29891], [-122.27702, 38.29871], [-122.27743, 38.29865], [-122.27747, 38.29885]]]} | No Public Access 3 | 64 | Real Estate Services Division | 24211 | 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.203 | Real Estate Services Division | None 6 | |||
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 | |||
190 | 190 | 189 | {"type": "Polygon", "coordinates": [[[-119.54817, 34.40521], [-119.54802, 34.4054], [-119.54792, 34.40532], [-119.54714, 34.40436], [-119.54706, 34.40429], [-119.54684, 34.40419], [-119.54661, 34.40416], [-119.54636, 34.40425], [-119.54631, 34.40432], [-119.54628, 34.40444], [-119.5462, 34.40436], [-119.54604, 34.40426], [-119.54606, 34.40336], [-119.54817, 34.40521]]]} | Open Access 1 | 524 | Santa Claus Lane Beach | 25061 | 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 | Santa Barbara 7 | 1.665 | Santa Claus Lane Beach | None 20 | |||
228 | 228 | 227 | {"type": "Polygon", "coordinates": [[[-122.33028, 41.31414], [-122.32908, 41.31415], [-122.32909, 41.31022], [-122.32966, 41.31067], [-122.33018, 41.31094], [-122.33021, 41.31196], [-122.33028, 41.31197], [-122.33028, 41.31414]]]} | No Public Access 3 | 621 | Elsa Rupp Natural Area | 32160 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Siskiyou 28 | 9.475 | Elsa Rupp Natural Area | None 26 | |||
325 | 325 | 324 | {"type": "Polygon", "coordinates": [[[-122.0502, 36.9496], [-122.04978, 36.94953], [-122.04949, 36.94929], [-122.04942, 36.94927], [-122.04942, 36.94924], [-122.04951, 36.94925], [-122.04961, 36.94935], [-122.04967, 36.94936], [-122.04979, 36.94944], [-122.04993, 36.94948], [-122.05019, 36.9495], [-122.0502, 36.9496]]]} | Open Access 1 | 1106 | Stockton Avenue Beach | 25857 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Santa Cruz 5 | 0.139 | Stockton Avenue Beach | None 33 | ||||
374 | 374 | 373 | {"type": "Polygon", "coordinates": [[[-122.51401, 38.08952], [-122.50961, 38.09217], [-122.5071, 38.09337], [-122.50547, 38.08821], [-122.50462, 38.08689], [-122.50476, 38.08671], [-122.50434, 38.08636], [-122.50461, 38.086], [-122.50537, 38.08538], [-122.50578, 38.08514], [-122.50622, 38.08495], [-122.50736, 38.08466], [-122.50838, 38.08465], [-122.50977, 38.08483], [-122.5107, 38.08507], [-122.51158, 38.08542], [-122.51221, 38.08579], [-122.51271, 38.0862], [-122.51324, 38.08682], [-122.51374, 38.08778], [-122.51391, 38.08855], [-122.51402, 38.08937], [-122.51401, 38.08952]]]} | Open Access 1 | 1105 | North Antenna Field | 22804 | 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 | Marin 23 | 128.205 | North Antenna Field | None 38 | |||
426 | 426 | 425 | {"type": "MultiPolygon", "coordinates": [[[[-122.54467, 38.63634], [-122.54012, 38.63646], [-122.54006, 38.65103], [-122.53546, 38.65099], [-122.53551, 38.64373], [-122.52645, 38.64367], [-122.52656, 38.64004], [-122.52204, 38.64003], [-122.52219, 38.63641], [-122.5214, 38.6255], [-122.52598, 38.62553], [-122.52577, 38.62209], [-122.52841, 38.62192], [-122.53977, 38.62201], [-122.54003, 38.62199], [-122.54431, 38.62189], [-122.5444, 38.62378], [-122.54448, 38.62912], [-122.54467, 38.63634]], [[-122.54011, 38.63644], [-122.54012, 38.63643], [-122.53988, 38.62923], [-122.52622, 38.62917], [-122.52645, 38.63279], [-122.53549, 38.63283], [-122.53564, 38.63643], [-122.54008, 38.63642], [-122.54011, 38.63644]]], [[[-122.56278, 38.61434], [-122.55805, 38.61443], [-122.5534, 38.6145], [-122.55346, 38.61809], [-122.54883, 38.61821], [-122.54419, 38.6183], [-122.54405, 38.61108], [-122.54868, 38.611], [-122.54863, 38.60741], [-122.55798, 38.6073], [-122.56112, 38.60719], [-122.5627, 38.60725], [-122.56278, 38.61434]]]]} | Open Access 1 | 1318 | Swartz Canyon | 1994 | 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 | 1307.545 | Swartz Canyon | None 43 | |||
434 | 434 | 433 | {"type": "Polygon", "coordinates": [[[-122.3521, 38.44442], [-122.34572, 38.4492], [-122.34565, 38.44615], [-122.3358, 38.44548], [-122.3314, 38.44557], [-122.33138, 38.4492], [-122.3184, 38.44966], [-122.29917, 38.448], [-122.29908, 38.44438], [-122.31821, 38.44584], [-122.31804, 38.44201], [-122.33143, 38.44194], [-122.33145, 38.43832], [-122.32239, 38.43823], [-122.32228, 38.43447], [-122.33607, 38.43482], [-122.34065, 38.43479], [-122.34065, 38.43521], [-122.34066, 38.43522], [-122.3429, 38.43515], [-122.34817, 38.43528], [-122.34848, 38.43602], [-122.34809, 38.44201], [-122.3521, 38.44442]]]} | Open Access 1 | 837 | Silverado Trail Rector Dam Watershed | 1818 | 206 | California Department of Veterans Affairs 170 | State 5 | State Agency 5 | http://www.cdva.ca.gov/ | Other State 5 | 206 | California Department of Veterans Affairs 166 | State 5 | State Agency 5 | Napa 11 | 959.679 | Silverado Trail Rector Dam Watershed | None 44 | |||
909 | 909 | 908 | {"type": "MultiPolygon", "coordinates": [[[[-116.98194, 32.66387], [-116.98012, 32.66389], [-116.98006, 32.66252], [-116.98113, 32.66321], [-116.98194, 32.66387]]], [[[-116.99533, 32.66736], [-116.9952, 32.6671], [-116.99494, 32.66669], [-116.9947, 32.66636], [-116.99446, 32.6661], [-116.99404, 32.6657], [-116.99371, 32.66545], [-116.99336, 32.66523], [-116.99305, 32.66506], [-116.99253, 32.66482], [-116.99242, 32.66479], [-116.99241, 32.66479], [-116.9924, 32.66481], [-116.98955, 32.66381], [-116.98915, 32.66383], [-116.98534, 32.66471], [-116.98442, 32.66526], [-116.98444, 32.66385], [-116.98299, 32.66386], [-116.98277, 32.66357], [-116.98191, 32.66274], [-116.98083, 32.66182], [-116.98012, 32.66126], [-116.98162, 32.66028], [-116.99252, 32.66025], [-116.99312, 32.66169], [-116.99324, 32.66166], [-116.99346, 32.66211], [-116.99359, 32.6624], [-116.99369, 32.66237], [-116.99393, 32.6629], [-116.99407, 32.66325], [-116.9942, 32.66361], [-116.9944, 32.66434], [-116.99449, 32.66471], [-116.99456, 32.66515], [-116.99455, 32.66531], [-116.99458, 32.66546], [-116.99462, 32.66554], [-116.9947, 32.66567], [-116.99489, 32.66587], [-116.99513, 32.66618], [-116.99523, 32.66641], [-116.99531, 32.66663], [-116.99536, 32.66698], [-116.99535, 32.66725], [-116.99533, 32.66736]]], [[[-117.00156, 32.67463], [-116.99849, 32.67546], [-116.99657, 32.67064], [-116.99567, 32.66833], [-116.9957, 32.66831], [-116.99555, 32.66794], [-116.99562, 32.6678], [-116.99568, 32.66754], [-116.99571, 32.66723], [-116.99569, 32.66683], [-116.99561, 32.66648], [-116.99551, 32.66623], [-116.99533, 32.66591], [-116.99522, 32.66576], [-116.99497, 32.66549], [-116.99488, 32.66534], [-116.99485, 32.66493], [-116.99477, 32.66442], [-116.99459, 32.66368], [-116.9944, 32.66315], [-116.99369, 32.66154], [-116.99617, 32.66084], [-116.99614, 32.66208], [-116.99667, 32.66343], [-116.99675, 32.66451], [-116.99781, 32.66579], [-116.99839, 32.6665], [-116.99859, 32.66701], [-116.99879, 32.66746], [-116.99892, 32.66874], [-117.00005, 32.6695], [-117.00038, 32.67013], [-117.00035, 32.67151], [-117.00156, 32.67463]]]]} | Open Access 1 | 5809 | Blue-Bonita Meadows | 1797 | 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 | San Diego 4 | 240.067 | Blue-Bonita Meadows | None 81 | |||
993 | 993 | 992 | {"type": "Polygon", "coordinates": [[[-118.25813, 33.78468], [-118.25775, 33.7847], [-118.25773, 33.78459], [-118.2574, 33.78461], [-118.25738, 33.78437], [-118.2581, 33.78433], [-118.25813, 33.78468]]]} | Open Access 1 | 6191 | Drum Barracks | 1504 | 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 | http://ohp.parks.ca.gov/ListedResources/Detail/169 | Los Angeles 6 | 0.539 | Drum Barracks | None 90 | ||
1041 | 1041 | 1040 | {"type": "Polygon", "coordinates": [[[-118.42426, 34.13667], [-118.4242, 34.13642], [-118.42398, 34.13639], [-118.42387, 34.13567], [-118.42373, 34.13499], [-118.42361, 34.13458], [-118.42363, 34.13425], [-118.42376, 34.13401], [-118.42374, 34.13394], [-118.42342, 34.13373], [-118.42341, 34.13374], [-118.42341, 34.13384], [-118.42315, 34.13384], [-118.42288, 34.13459], [-118.42283, 34.13517], [-118.42249, 34.13506], [-118.42249, 34.13323], [-118.4226, 34.13311], [-118.42266, 34.13301], [-118.4227, 34.13274], [-118.4228, 34.13262], [-118.42292, 34.13241], [-118.42306, 34.13231], [-118.42347, 34.1322], [-118.42374, 34.13209], [-118.42389, 34.132], [-118.42401, 34.1319], [-118.42405, 34.13183], [-118.42406, 34.13177], [-118.424, 34.13167], [-118.424, 34.13163], [-118.42418, 34.1315], [-118.42433, 34.13143], [-118.42462, 34.13136], [-118.42518, 34.13136], [-118.42524, 34.1314], [-118.42525, 34.13148], [-118.42521, 34.13154], [-118.4251, 34.13164], [-118.42508, 34.13171], [-118.42508, 34.13178], [-118.42516, 34.13194], [-118.42515, 34.13207], [-118.42524, 34.13217], [-118.42525, 34.13221], [-118.42522, 34.13226], [-118.42512, 34.1323], [-118.42507, 34.13235], [-118.42506, 34.13241], [-118.42509, 34.13257], [-118.42506, 34.13266], [-118.42499, 34.13278], [-118.42498, 34.13287], [-118.42501, 34.13294], [-118.42513, 34.13297], [-118.42515, 34.13302], [-118.42502, 34.13334], [-118.42497, 34.13352], [-118.42457, 34.13439], [-118.42426, 34.13667]]]} | Open Access 1 | 6864 | Dixie Canyon Park | 18170 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 215 | Santa Monica Mountains Conservancy 303 | State 5 | State Agency 5 | Los Angeles 6 | 18.289 | Dixie Canyon Park | None 94 | |||
1278 | 1278 | 1277 | {"type": "Polygon", "coordinates": [[[-118.6782, 34.06005], [-118.67818, 34.06166], [-118.67738, 34.06166], [-118.67739, 34.06315], [-118.67624, 34.06312], [-118.67625, 34.06492], [-118.67606, 34.06492], [-118.67361, 34.06522], [-118.67342, 34.06526], [-118.6733, 34.06532], [-118.67235, 34.06588], [-118.67225, 34.06598], [-118.67216, 34.06609], [-118.67203, 34.0664], [-118.67183, 34.06641], [-118.67177, 34.06417], [-118.67225, 34.06392], [-118.67224, 34.06325], [-118.67223, 34.06324], [-118.67156, 34.06326], [-118.67146, 34.06003], [-118.6782, 34.06005]]]} | Open Access 1 | 7228 | Piuma Ridge Park | 23752 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 215 | Santa Monica Mountains Conservancy 303 | State 5 | State Agency 5 | Los Angeles 6 | 73.241 | Piuma Ridge Park | 0 | None 111 | ||
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 | ||
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 | ||
2230 | 2230 | 2229 | {"type": "Polygon", "coordinates": [[[-122.24161, 37.87448], [-122.24145, 37.87464], [-122.24127, 37.87475], [-122.24114, 37.87493], [-122.24111, 37.87512], [-122.24092, 37.87526], [-122.24065, 37.87538], [-122.24047, 37.87566], [-122.24018, 37.87587], [-122.23966, 37.8759], [-122.23923, 37.87598], [-122.23904, 37.87594], [-122.23883, 37.87578], [-122.23877, 37.87566], [-122.23862, 37.87565], [-122.23832, 37.87568], [-122.23798, 37.87544], [-122.23732, 37.87513], [-122.23676, 37.87512], [-122.2366, 37.87502], [-122.23663, 37.87463], [-122.23526, 37.87337], [-122.2356, 37.87318], [-122.23585, 37.87323], [-122.2367, 37.87277], [-122.23926, 37.87339], [-122.23954, 37.87339], [-122.2396, 37.87354], [-122.23954, 37.87373], [-122.23993, 37.87403], [-122.23976, 37.87413], [-122.23956, 37.87434], [-122.2395, 37.87432], [-122.23953, 37.8746], [-122.23982, 37.87455], [-122.23995, 37.87444], [-122.24027, 37.87459], [-122.24058, 37.87447], [-122.24075, 37.87429], [-122.24072, 37.87405], [-122.24082, 37.87385], [-122.24138, 37.87419], [-122.24161, 37.87448]]]} | Open Access 1 | 47876 | University of California Botanical Garden at Berkeley | 31820 | 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://botanicalgarden.berkeley.edu | Alameda 17 | 25.411 | University of California Botanical Garden at Berkeley | 1890 | None 183 | |
2266 | 2266 | 2265 | {"type": "Polygon", "coordinates": [[[-121.88959, 36.95741], [-121.88855, 36.95826], [-121.88843, 36.95817], [-121.88948, 36.95731], [-121.88959, 36.95741]]]} | Open Access 1 | 16858 | Hidden Beach | 19901 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Santa Cruz 5 | 0.488 | Hidden Beach | None 188 | ||||
2965 | 2965 | 2964 | {"type": "Polygon", "coordinates": [[[-121.49995, 38.57528], [-121.49977, 38.5757], [-121.49934, 38.57558], [-121.49952, 38.57517], [-121.49995, 38.57528]]]} | Open Access 1 | 20483 | Heilbron Mansion | 1561 | 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 | 0.477 | Heilbron Mansion | None 244 | |||
3020 | 3020 | 3019 | {"type": "Polygon", "coordinates": [[[-119.12918, 37.77888], [-119.12889, 37.77916], [-119.12872, 37.77944], [-119.12851, 37.77957], [-119.1283, 37.77961], [-119.12814, 37.77968], [-119.12769, 37.77969], [-119.12762, 37.77965], [-119.12752, 37.77968], [-119.1274, 37.7798], [-119.12735, 37.77996], [-119.12705, 37.78023], [-119.12692, 37.7803], [-119.12673, 37.78035], [-119.12679, 37.78041], [-119.12681, 37.7805], [-119.1267, 37.78064], [-119.12645, 37.78113], [-119.12613, 37.78152], [-119.12571, 37.78189], [-119.12554, 37.78217], [-119.12545, 37.78224], [-119.12537, 37.78227], [-119.12504, 37.78268], [-119.12481, 37.78285], [-119.12472, 37.7829], [-119.12465, 37.7829], [-119.12458, 37.78289], [-119.12452, 37.78284], [-119.12449, 37.78254], [-119.12444, 37.78241], [-119.12441, 37.78191], [-119.12437, 37.78163], [-119.12431, 37.78144], [-119.12427, 37.78109], [-119.12421, 37.78094], [-119.12417, 37.78078], [-119.12401, 37.78038], [-119.12394, 37.78026], [-119.12365, 37.77943], [-119.12343, 37.77889], [-119.12333, 37.77872], [-119.12321, 37.77845], [-119.12301, 37.77811], [-119.12283, 37.77778], [-119.12266, 37.77755], [-119.1226, 37.77741], [-119.12247, 37.77687], [-119.12238, 37.7767], [-119.12227, 37.77657], [-119.12215, 37.77635], [-119.12211, 37.77625], [-119.12211, 37.77612], [-119.12207, 37.77598], [-119.12195, 37.77583], [-119.12186, 37.77567], [-119.12174, 37.77551], [-119.12165, 37.77542], [-119.12163, 37.7753], [-119.12159, 37.77519], [-119.12158, 37.77504], [-119.1216, 37.775], [-119.12165, 37.77498], [-119.12178, 37.77503], [-119.12181, 37.77495], [-119.12183, 37.7748], [-119.12188, 37.77475], [-119.12194, 37.77462], [-119.12184, 37.77454], [-119.1218, 37.77447], [-119.12183, 37.77443], [-119.12189, 37.77441], [-119.12186, 37.77427], [-119.12178, 37.77419], [-119.1218, 37.77411], [-119.12184, 37.77405], [-119.12185, 37.77396], [-119.12183, 37.77384], [-119.12181, 37.77379], [-119.12184, 37.77374], [-119.12205, 37.77369], [-119.12217, 37.77363], [-119.12222, 37.77348], [-119.12225, 37.77344], [-119.12227, 37.77327], [-119.12233, 37.77324], [-119.12257, 37.77322], [-119.12275, 37.77302], [-119.12277, 37.7729], [-119.12275, 37.77282], [-119.12279, 37.77273], [-119.12286, 37.77264], [-119.12298, 37.77255], [-119.12318, 37.77251], [-119.12338, 37.7725], [-119.12368, 37.77252], [-119.12377, 37.77255], [-119.12391, 37.77265], [-119.12402, 37.77284], [-119.12402, 37.77294], [-119.12408, 37.77329], [-119.12412, 37.77336], [-119.12417, 37.77337], [-119.12431, 37.77334], [-119.12443, 37.77319], [-119.12449, 37.77316], [-119.12456, 37.77315], [-119.12465, 37.77318], [-119.12483, 37.7732], [-119.12495, 37.77314], [-119.12496, 37.77302], [-119.12493, 37.7729], [-119.12484, 37.77265], [-119.12486, 37.77244], [-119.12491, 37.77227], [-119.12501, 37.7721], [-119.12502, 37.77202], [-119.12499, 37.77164], [-119.12503, 37.77161], [-119.12512, 37.77171], [-119.12513, 37.77196], [-119.12515, 37.77204], [-119.1252, 37.77211], [-119.12531, 37.77218], [-119.12544, 37.77221], [-119.12546, 37.7722], [-119.12537, 37.77061], [-119.12555, 37.77102], [-119.12569, 37.7714], [-119.1258, 37.77175], [-119.12595, 37.77227], [-119.12604, 37.77252], [-119.12605, 37.77261], [-119.12603, 37.77286], [-119.12611, 37.77312], [-119.12623, 37.77337], [-119.12641, 37.7736], [-119.12662, 37.77382], [-119.12698, 37.77435], [-119.12664, 37.77446], [-119.12663, 37.77448], [-119.12676, 37.77471], [-119.12696, 37.77489], [-119.12726, 37.77511], [-119.12752, 37.77555], [-119.12784, 37.77583], [-119.12805, 37.77614], [-119.12843, 37.77657], [-119.12914, 37.77845], [-119.12918, 37.77888]]]} | Open Access 1 | 20776 | Silver Lake | 25487 | 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 | Mono 32 | 107.687 | Silver Lake | 0 | None 247 | ||
3155 | 3155 | 3154 | {"type": "Polygon", "coordinates": [[[-121.52015, 38.36105], [-121.52, 38.36138], [-121.51988, 38.36172], [-121.51976, 38.36228], [-121.51967, 38.36299], [-121.51968, 38.36374], [-121.51983, 38.36443], [-121.51986, 38.3652], [-121.51994, 38.36596], [-121.52002, 38.3666], [-121.51995, 38.36694], [-121.51977, 38.3671], [-121.51892, 38.36686], [-121.51857, 38.36669], [-121.51813, 38.36655], [-121.51157, 38.3651], [-121.51168, 38.35783], [-121.51938, 38.36011], [-121.51901, 38.36077], [-121.52015, 38.36105]]]} | No Public Access 3 | 21762 | Hood Test Facilities | 30565 | 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 | Sacramento 41 | 136.958 | Hood Test Facilities | None 257 | |||
3159 | 3159 | 3158 | {"type": "Polygon", "coordinates": [[[-121.50125, 38.31704], [-121.50005, 38.31773], [-121.49878, 38.31973], [-121.49852, 38.31959], [-121.4985, 38.3196], [-121.49847, 38.31958], [-121.4946, 38.31753], [-121.49279, 38.31453], [-121.50082, 38.31445], [-121.50125, 38.31704]]]} | No Public Access 3 | 21834 | Stone Lakes | 25871 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Sacramento 41 | 68.284 | Stone Lakes | None 259 |
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]);