units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
444 rows where LAYER = 5
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_WEB, MNG_AG_LEV
MNG_AGENCY >30
- California State Lands Commission 86
- Mountains Recreation and Conservation Authority 56
- University of California 52
- Other State 43
- California Department of Fish and Wildlife 32
- California Department of Transportation 27
- California Department of Parks and Recreation 23
- California Department of Water Resources 20
- Santa Monica Mountains Conservancy 18
- California Department of General Services 14
- East Bay Regional Park District 11
- California Department of Forestry and Fire Protection 10
- California Wildlife Conservation Board 9
- California State Coastal Conservancy 7
- Coachella Valley Mountains Conservancy 5
- United States Fish and Wildlife Service 3
- San Diego, City of 2
- San Luis Obispo, City of 2
- California Department of Veterans Affairs 2
- Napa Valley College 2
- San Diego State University 2
- San Joaquin River Parkway and Conservation Trust 2
- California State University 2
- California Tahoe Conservancy 2
- The Nature Conservancy 1
- Napa County Regional Park and Open Space District 1
- Rosemead, City of 1
- California State University Sonoma 1
- San Fernando, City of 1
- Los Angeles - Department of Parks and Recreation, County of 1
- …
DES_TP >30
- State Resource Management Area 88
- State Conservation Area 82
- State Other or Unknown 55
- Local Park 32
- State Recreation Area 22
- Local Other or Unknown 21
- State Park 15
- Local Recreation Area 9
- Local Conservation Area 4
- National Wildlife Refuge 4
- National Monument or Landmark 2
- 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
- State Historic or Cultural Area 1
- None 1
- None 1
- None 1
- None 1
- None 1
- …
MNG_AG_TYP 9
ACCESS_TYP 4
- Open Access 279
- Restricted Access 74
- No Public Access 51
- Unknown Access 40
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 | |||
115 | 115 | 114 | {"type": "Polygon", "coordinates": [[[-118.77562, 34.03262], [-118.77533, 34.03337], [-118.77526, 34.03417], [-118.77391, 34.03402], [-118.77397, 34.03297], [-118.77225, 34.0325], [-118.77235, 34.03205], [-118.77242, 34.03192], [-118.7725, 34.03184], [-118.7726, 34.03179], [-118.77271, 34.03175], [-118.77283, 34.03174], [-118.773, 34.03177], [-118.77369, 34.03203], [-118.77383, 34.03206], [-118.77404, 34.03206], [-118.77425, 34.03201], [-118.77476, 34.03219], [-118.77512, 34.0325], [-118.77562, 34.03262]]]} | Open Access 1 | 345 | Escondido Canyon Park | 29611 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 10.379 | Escondido Canyon Park | 0 | Local Park 2 | 4 | |
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 | |||
270 | 270 | 269 | {"type": "Polygon", "coordinates": [[[-122.25949, 38.27979], [-122.256, 38.27978], [-122.25255, 38.27973], [-122.25149, 38.27969], [-122.24965, 38.27967], [-122.24894, 38.27968], [-122.24877, 38.2797], [-122.24868, 38.27977], [-122.2455, 38.27976], [-122.24092, 38.27987], [-122.23633, 38.27986], [-122.23623, 38.2692], [-122.23162, 38.2692], [-122.23158, 38.26561], [-122.22698, 38.2656], [-122.21778, 38.26577], [-122.21775, 38.25878], [-122.21356, 38.25877], [-122.21355, 38.25427], [-122.21522, 38.25486], [-122.21607, 38.25492], [-122.21668, 38.25515], [-122.21783, 38.25499], [-122.218, 38.25496], [-122.2181, 38.25491], [-122.21855, 38.25484], [-122.21902, 38.25461], [-122.22004, 38.2545], [-122.22463, 38.2543], [-122.22694, 38.2551], [-122.22708, 38.25525], [-122.22793, 38.25583], [-122.23018, 38.25708], [-122.23043, 38.25707], [-122.23061, 38.25715], [-122.23125, 38.25736], [-122.23153, 38.25752], [-122.2318, 38.2578], [-122.23188, 38.25803], [-122.23203, 38.25818], [-122.23214, 38.25825], [-122.23216, 38.25843], [-122.2361, 38.25846], [-122.23622, 38.26562], [-122.24539, 38.26563], [-122.24554, 38.27172], [-122.24785, 38.27207], [-122.24862, 38.27265], [-122.24555, 38.27268], [-122.24554, 38.27217], [-122.24552, 38.27271], [-122.24869, 38.2727], [-122.25123, 38.27447], [-122.25798, 38.27448], [-122.25809, 38.27431], [-122.25844, 38.27448], [-122.25943, 38.27448], [-122.25949, 38.27979]]]} | Open Access 1 | 916 | Skyline Wilderness Park | 835 | 222 | California Bureau of Real Estate 111 | State 5 | State Agency 5 | http://www.bre.ca.gov/ | Other State 5 | 2268 | Napa County Regional Park and Open Space District 108 | Special District 4 | Recreation/Parks District 4 | http://www.skylinepark.org/ | Napa 11 | 1021.072 | Skyline Wilderness Park | 1983 | Local Conservation Area 4 | 2 |
309 | 309 | 308 | {"type": "MultiPolygon", "coordinates": [[[[-118.61084, 34.27479], [-118.61063, 34.27477], [-118.6103, 34.2747], [-118.61002, 34.27455], [-118.60985, 34.27432], [-118.60969, 34.27388], [-118.60882, 34.27411], [-118.60768, 34.27363], [-118.60854, 34.27246], [-118.61002, 34.27238], [-118.61055, 34.2723], [-118.61121, 34.27215], [-118.61124, 34.27217], [-118.6114, 34.27269], [-118.61141, 34.27284], [-118.6114, 34.27299], [-118.61132, 34.2732], [-118.61092, 34.27389], [-118.61081, 34.27412], [-118.61077, 34.27429], [-118.61077, 34.27446], [-118.61079, 34.27463], [-118.61084, 34.27479]]], [[[-118.61416, 34.27267], [-118.61344, 34.27333], [-118.61346, 34.27364], [-118.61289, 34.27408], [-118.61233, 34.27387], [-118.61196, 34.27395], [-118.61208, 34.27432], [-118.61183, 34.27461], [-118.61168, 34.27461], [-118.61157, 34.2747], [-118.61155, 34.27488], [-118.61138, 34.27494], [-118.61124, 34.27489], [-118.61114, 34.27493], [-118.61105, 34.27475], [-118.611, 34.27459], [-118.61098, 34.27435], [-118.61101, 34.27419], [-118.61111, 34.27396], [-118.61152, 34.27327], [-118.61158, 34.2731], [-118.61162, 34.27293], [-118.61161, 34.27269], [-118.61144, 34.27212], [-118.61146, 34.27209], [-118.61246, 34.27186], [-118.61282, 34.27184], [-118.61306, 34.27186], [-118.61321, 34.27194], [-118.61333, 34.27204], [-118.61343, 34.27216], [-118.61358, 34.27242], [-118.61368, 34.27252], [-118.61379, 34.27259], [-118.61393, 34.27264], [-118.61416, 34.27267]]]]} | Open Access 1 | 826 | Garden of the Gods | 29624 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 27.234 | Garden of the Gods | None 32 | |||
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 | |||
653 | 653 | 652 | {"type": "Polygon", "coordinates": [[[-118.76961, 34.09844], [-118.76746, 34.09841], [-118.76746, 34.09748], [-118.76959, 34.09752], [-118.76961, 34.09844]]]} | Open Access 1 | 5014 | Malibu Creek State Park - Randa House | 29629 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.parks.ca.gov/?page_id=614 | Los Angeles 6 | 5.064 | Malibu Creek SP - Randa House | None 62 | ||
655 | 655 | 654 | {"type": "Polygon", "coordinates": [[[-122.60188, 38.34223], [-122.60099, 38.34219], [-122.59824, 38.34219], [-122.59784, 38.34221], [-122.59674, 38.34238], [-122.59579, 38.34284], [-122.59514, 38.34423], [-122.59427, 38.34493], [-122.59333, 38.34522], [-122.59334, 38.34582], [-122.59113, 38.34633], [-122.5913, 38.34768], [-122.59135, 38.34828], [-122.5912, 38.3487], [-122.59122, 38.34925], [-122.59128, 38.34926], [-122.5913, 38.34965], [-122.59261, 38.35027], [-122.59275, 38.35752], [-122.58592, 38.35768], [-122.58582, 38.35554], [-122.5836, 38.35559], [-122.58354, 38.34758], [-122.58768, 38.34758], [-122.58754, 38.34322], [-122.5927, 38.34315], [-122.59271, 38.33808], [-122.59176, 38.33786], [-122.59079, 38.33744], [-122.58972, 38.33705], [-122.58885, 38.33685], [-122.588, 38.3368], [-122.58729, 38.33644], [-122.5869, 38.33609], [-122.58626, 38.33575], [-122.58571, 38.33561], [-122.58518, 38.33551], [-122.58545, 38.33521], [-122.58614, 38.33528], [-122.58697, 38.33561], [-122.58767, 38.33622], [-122.58824, 38.33643], [-122.58911, 38.33648], [-122.58974, 38.33662], [-122.5905, 38.33687], [-122.59169, 38.33743], [-122.5927, 38.33768], [-122.59271, 38.33767], [-122.59272, 38.33589], [-122.60179, 38.33588], [-122.60186, 38.34013], [-122.60188, 38.34223]], [[-122.5906, 38.3493], [-122.59059, 38.34928], [-122.59046, 38.34931], [-122.59053, 38.34931], [-122.5906, 38.3493]]]} | Restricted Access 2 | 3269 | Fairfield Osborn Preserve | 18798 | 211 | California State University Sonoma 232 | State 5 | State Agency 5 | http://www.sonoma.edu/ | Other State 5 | 211 | California State University Sonoma 228 | State 5 | State Agency 5 | Sonoma 16 | 414.364 | Fairfield Osborn Preserve | 2004 | State Conservation Area 8 | 2 | |
820 | 820 | 819 | {"type": "Polygon", "coordinates": [[[-122.46024, 38.4015], [-122.45904, 38.40373], [-122.45593, 38.40443], [-122.45662, 38.40573], [-122.45384, 38.40685], [-122.45383, 38.40697], [-122.45093, 38.40569], [-122.45012, 38.40836], [-122.44677, 38.40831], [-122.44613, 38.40284], [-122.44659, 38.40275], [-122.44716, 38.40269], [-122.44742, 38.40261], [-122.44761, 38.40251], [-122.44766, 38.40247], [-122.44768, 38.40235], [-122.44764, 38.4023], [-122.44757, 38.40227], [-122.44797, 38.40183], [-122.44828, 38.40157], [-122.46024, 38.4015]]]} | Open Access 1 | 4582 | Bumpy Camp Nature Preserve | 16503 | 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 | 148.027 | Bumpy Camp Nature Preserve | 0 | State Conservation Area 8 | 2 | |
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 | |||
922 | 922 | 921 | {"type": "Polygon", "coordinates": [[[-118.58834, 34.15325], [-118.58689, 34.15235], [-118.5868, 34.15236], [-118.58641, 34.15142], [-118.58633, 34.14834], [-118.58557, 34.14681], [-118.5847, 34.14741], [-118.58252, 34.14676], [-118.58605, 34.14524], [-118.58832, 34.14524], [-118.58834, 34.15325]]]} | Open Access 1 | 6411 | Serrania Park | 29661 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 48.711 | Serrania Park | 0 | Local Park 2 | 4 | |
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 | |||
1157 | 1157 | 1156 | {"type": "Polygon", "coordinates": [[[-116.91384, 32.82128], [-116.9136, 32.82217], [-116.91351, 32.82247], [-116.91325, 32.82312], [-116.91306, 32.82352], [-116.91285, 32.82388], [-116.91253, 32.82436], [-116.91234, 32.8246], [-116.91137, 32.82546], [-116.91041, 32.8248], [-116.9096, 32.82296], [-116.90946, 32.82252], [-116.90948, 32.82219], [-116.91047, 32.82103], [-116.91059, 32.82076], [-116.91384, 32.82128]]]} | Open Access 1 | 7356 | CalTrans TransNet Environmental Mitigation | 16740 | 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 | 33.902 | CalTrans TransNet Environmental Mitigation | 0 | State Other or Unknown 104 | 4 | |
1165 | 1165 | 1164 | {"type": "Polygon", "coordinates": [[[-116.90615, 32.72851], [-116.90484, 32.7283], [-116.90399, 32.72803], [-116.90394, 32.72518], [-116.90608, 32.72533], [-116.90615, 32.72851]]]} | Open Access 1 | 7381 | San Diego National Wildlife Refuge | 24858 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | San Diego 4 | 16.779 | San Diego NWR | 1996 | National Wildlife Refuge 105 | 2 | ||
1186 | 1186 | 1185 | {"type": "Polygon", "coordinates": [[[-118.39663, 34.12324], [-118.39662, 34.12739], [-118.39432, 34.12728], [-118.39349, 34.12698], [-118.39288, 34.12624], [-118.39362, 34.12552], [-118.39315, 34.12515], [-118.39309, 34.12519], [-118.39276, 34.12493], [-118.39381, 34.12374], [-118.39484, 34.12323], [-118.39663, 34.12324]]]} | Open Access 1 | 6876 | Fryman Canyon Park | 29621 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 33.114 | Fryman Canyon Park | 0 | Local Park 2 | 4 | |
1209 | 1209 | 1208 | {"type": "Polygon", "coordinates": [[[-118.61077, 34.34136], [-118.60659, 34.34141], [-118.60658, 34.33946], [-118.61074, 34.33941], [-118.61077, 34.34136]]]} | Open Access 1 | 8436 | Unnamed site - Santa Monica Mountains Conservancy | 29566 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 20.46 | 0 | Local Other or Unknown 14 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([id]), FOREIGN KEY([MNG_AGENCY]) REFERENCES [MNG_AGENCY]([id]), FOREIGN KEY([MNG_AG_LEV]) REFERENCES [MNG_AG_LEV]([id]), FOREIGN KEY([MNG_AG_TYP]) REFERENCES [MNG_AG_TYP]([id]), FOREIGN KEY([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);