units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
55 rows where ACCESS_TYP = 1 and MNG_AG_TYP = 12 sorted by YR_EST descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_TYP, GAP_STS
MNG_AGENCY 27
- Del Monte Forest Foundation 10
- Mountains Restoration Trust 7
- National Audubon Society 3
- Trust for Public Land 3
- San Diego River Park Foundation 3
- Irvine Ranch Conservancy 3
- Marin Audubon Society 2
- Morro Coast Audubon Society 2
- Community Environmental Council 2
- Friends of the Enchanted Meadow 2
- Audubon Canyon Ranch 2
- Serra Cross Conservancy 1
- Westport Village Society 1
- Friends of Palm Springs Mountains 1
- The Living Desert 1
- The Old Mill Foundation 1
- Elings Park Foundation 1
- Moat Creek Managing Agency 1
- Redwood Coast Land Conservancy 1
- Palo Cerdo Community Park Association 1
- Placer Legacy 1
- Watsonville Wetlands Watch 1
- Marin Conservation League 1
- Los Angeles Conservation Corps 1
- Batiquitos Lagoon Foundation 1
- Stewards of the Coast and Redwoods 1
- Redwood Coast Recreation Center 1
DES_TP 13
- Private Conservation 27
- Private Recreation or Education 11
- Private Other or Unknown 7
- State Recreation Area 1
- National Monument or Landmark 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
MNG_AG_TYP 1
- Non Profit - Conservation · 55 ✖
ACCESS_TYP 1
- Open Access · 55 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14726 | 14726 | 14725 | {"type": "Polygon", "coordinates": [[[-118.33306, 33.97936], [-118.33306, 33.97952], [-118.33244, 33.97953], [-118.33244, 33.97936], [-118.33306, 33.97936]]]} | Open Access 1 | 45078 | South Victoria Avenue Park | 28103 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 3094 | Trust for Public Land 718 | Non Profit 6 | Non Profit - Conservation 12 | http://www.tpl.org/our-work/parks-for-people/fitness-zones/south-victoria-avenue-park | Los Angeles 6 | 0.261 | South Victoria Avenue Park | 2019 | None 1261 | |
15167 | 15167 | 15166 | {"type": "Polygon", "coordinates": [[[-117.27449, 33.09512], [-117.27025, 33.09505], [-117.27019, 33.09492], [-117.27019, 33.09488], [-117.27023, 33.09483], [-117.27016, 33.09464], [-117.27011, 33.09465], [-117.27011, 33.09307], [-117.2703, 33.09301], [-117.27048, 33.09283], [-117.27071, 33.09282], [-117.27099, 33.09295], [-117.27164, 33.09308], [-117.2715, 33.09331], [-117.27151, 33.09332], [-117.27233, 33.09353], [-117.27312, 33.09348], [-117.27325, 33.09329], [-117.27351, 33.09329], [-117.27355, 33.09311], [-117.27415, 33.09307], [-117.27413, 33.09316], [-117.27439, 33.09325], [-117.27448, 33.09326], [-117.27449, 33.09512]]]} | Open Access 1 | 47291 | Cholla Point | 30996 | 3220 | Batiquitos Lagoon Foundation 1138 | Non Profit 6 | Non Profit - Conservation 12 | http://www.batiquitosfoundation.org/about/ | Non Governmental Organization 10 | 3220 | Batiquitos Lagoon Foundation 1093 | Non Profit 6 | Non Profit - Conservation 12 | http://www.batiquitosfoundation.org/category/visit/ | San Diego 4 | 20.824 | Cholla Point | 2011 | Private Conservation 16 | 2 |
9139 | 9139 | 9138 | {"type": "Polygon", "coordinates": [[[-123.64935, 38.84992], [-123.64931, 38.84997], [-123.64904, 38.85012], [-123.6491, 38.8502], [-123.64922, 38.8503], [-123.64935, 38.85043], [-123.64926, 38.85052], [-123.64925, 38.85081], [-123.64913, 38.85087], [-123.64879, 38.8509], [-123.6488, 38.85097], [-123.64889, 38.851], [-123.64926, 38.851], [-123.64932, 38.85103], [-123.64924, 38.85123], [-123.64905, 38.85129], [-123.64886, 38.85128], [-123.64865, 38.85135], [-123.64865, 38.8514], [-123.64859, 38.85151], [-123.64858, 38.8516], [-123.64874, 38.85164], [-123.64862, 38.8517], [-123.64861, 38.85178], [-123.6485, 38.85183], [-123.64834, 38.85186], [-123.64822, 38.85194], [-123.64778, 38.85177], [-123.6477, 38.85162], [-123.64757, 38.85111], [-123.64735, 38.85059], [-123.64703, 38.8501], [-123.64817, 38.84956], [-123.6482, 38.84968], [-123.64816, 38.84975], [-123.64816, 38.84981], [-123.64797, 38.84979], [-123.64779, 38.84979], [-123.64762, 38.85], [-123.64765, 38.85012], [-123.64778, 38.85034], [-123.64793, 38.85047], [-123.64806, 38.85051], [-123.64829, 38.85043], [-123.64844, 38.85027], [-123.64843, 38.85018], [-123.64865, 38.85004], [-123.64885, 38.84997], [-123.64907, 38.84994], [-123.64935, 38.84992]]]} | Open Access 1 | 48998 | Hearn Gulch | 33693 | 3303 | Redwood Coast Land Conservancy 904 | Non Profit 6 | Non Profit - Conservation 12 | http://www.rc-lc.org/ | Non Governmental Organization 10 | 3303 | Redwood Coast Land Conservancy 879 | Non Profit 6 | Non Profit - Conservation 12 | https://www.rclc.org/hearn-gulch/ | Mendocino 24 | 6.409 | Hearn Gulch | 2008 | Private Conservation 16 | 2 |
10363 | 10363 | 10362 | {"type": "Polygon", "coordinates": [[[-122.23717, 40.56026], [-122.2369, 40.56056], [-122.23549, 40.56201], [-122.23102, 40.56204], [-122.2313, 40.56082], [-122.23339, 40.56082], [-122.23339, 40.56028], [-122.23717, 40.56026]]]} | Open Access 1 | 48567 | Palo Cedro Community Park | 33316 | 3394 | Palo Cerdo Community Park Association 950 | Non Profit 6 | Non Profit - Conservation 12 | https://pcpark.org/ | Non Governmental Organization 10 | 3394 | Palo Cerdo Community Park Association 922 | Non Profit 6 | Non Profit - Conservation 12 | Shasta 27 | 18.256 | Palo Cedro Community Park | 2006 | Private Recreation or Education 65 | 4 | |
6912 | 6912 | 6911 | {"type": "Polygon", "coordinates": [[[-116.46015, 33.62703], [-116.46015, 33.6416], [-116.44281, 33.6416], [-116.4428, 33.62706], [-116.46015, 33.62703]]]} | Open Access 1 | 5786 | Santa Rosa and San Jacinto Mountains National Monument | 13072 | 3090 | The Living Desert 845 | Non Profit 6 | Non Profit - Conservation 12 | http://www.livingdesert.org/ | Non Governmental Organization 10 | 3090 | The Living Desert 823 | Non Profit 6 | Non Profit - Conservation 12 | Riverside 10 | 641.789 | Santa Rosa and San Jacinto Mtns. NM | 2000 | National Monument or Landmark 80 | 3 | |
16810 | 16810 | 16809 | {"type": "Polygon", "coordinates": [[[-123.53176, 38.79603], [-123.52979, 38.79762], [-123.52905, 38.79637], [-123.52785, 38.79494], [-123.52811, 38.79484], [-123.52838, 38.79482], [-123.5285, 38.79482], [-123.52897, 38.79489], [-123.52942, 38.79536], [-123.53153, 38.79567], [-123.53176, 38.79603]]]} | Open Access 1 | 48503 | Redwood Coast Recreation Center | 33212 | 3389 | Redwood Coast Recreation Center 1176 | Non Profit 6 | Non Profit - Conservation 12 | http://rcrcpool.org/#about | Non Governmental Organization 10 | 3389 | Redwood Coast Recreation Center 1116 | Non Profit 6 | Non Profit - Conservation 12 | http://rcrcpool.org/ | Mendocino 24 | 11.148 | Redwood Coast Rec. Ctr. | 1999 | Private Conservation 16 | 2 |
6751 | 6751 | 6750 | {"type": "Polygon", "coordinates": [[[-122.49667, 37.96721], [-122.49568, 37.97019], [-122.49389, 37.96873], [-122.49305, 37.96873], [-122.49385, 37.96635], [-122.49592, 37.96699], [-122.49667, 37.96721]]]} | Open Access 1 | 5187 | San Rafael Tidelands | 30323 | 3039 | Marin Audubon Society 261 | Non Profit 6 | Non Profit - Conservation 12 | http://www.marinaudubon.org | Non Governmental Organization 10 | 3039 | Marin Audubon Society 257 | Non Profit 6 | Non Profit - Conservation 12 | Marin 23 | 18.615 | San Rafael Tidelands | 1978 | Private Conservation 16 | 2 | |
16658 | 16658 | 16657 | {"type": "MultiPolygon", "coordinates": [[[[-123.0767, 38.55966], [-123.07524, 38.56305], [-123.07437, 38.56486], [-123.07367, 38.56642], [-123.06127, 38.56613], [-123.06033, 38.56614], [-123.05927, 38.56941], [-123.05928, 38.56942], [-123.06811, 38.56953], [-123.0656, 38.57548], [-123.0656, 38.57549], [-123.07418, 38.5755], [-123.0737, 38.58223], [-123.07323, 38.58793], [-123.07326, 38.59136], [-123.07328, 38.59164], [-123.06893, 38.59167], [-123.06487, 38.59217], [-123.06484, 38.58862], [-123.06013, 38.5894], [-123.05375, 38.59049], [-123.05371, 38.59053], [-123.04864, 38.5921], [-123.04906, 38.58871], [-123.04896, 38.58724], [-123.04865, 38.58717], [-123.04817, 38.58735], [-123.04811, 38.58705], [-123.048, 38.58702], [-123.04751, 38.58359], [-123.04619, 38.58372], [-123.04608, 38.58326], [-123.04515, 38.57978], [-123.04057, 38.58003], [-123.04009, 38.57801], [-123.03605, 38.57804], [-123.03545, 38.57806], [-123.03599, 38.58033], [-123.02847, 38.5852], [-123.02017, 38.58505], [-123.01617, 38.58502], [-123.01617, 38.58183], [-123.01616, 38.58182], [-123.01404, 38.58186], [-123.01408, 38.58499], [-123.01078, 38.58499], [-123.01081, 38.58112], [-123.00233, 38.58073], [-122.9969, 38.58289], [-122.99333, 38.58121], [-122.99325, 38.57872], [-122.99077, 38.57226], [-122.99085, 38.56825], [-122.99564, 38.56827], [-122.99546, 38.5595], [-122.99521, 38.55207], [-122.99771, 38.55212], [-122.99779, 38.54973], [-122.99803, 38.54973], [-122.99804, 38.54952], [-123.00149, 38.54949], [-123.00119, 38.5451], [-123.00904, 38.54512], [-123.00904, 38.55225], [-123.01367, 38.5522], [-123.01405, 38.5578], [-123.01385, 38.55838], [-123.01394, 38.55945], [-123.01757, 38.55941], [-123.03507, 38.55804], [-123.03549, 38.55803], [-123.03965, 38.55824], [-123.0395, 38.55891], [-123.03949, 38.55907], [-123.03875, 38.56183], [-123.04774, 38.5622], [-123.04865, 38.5587], [-123.04878, 38.5478], [-123.05671, 38.54794], [-123.05731, 38.54793], [-123.07134, 38.54861], [-123.07136, 38.54868], [-123.07204, 38.55945], [-123.0767, 38.55966]], [[-123.01966, 38.57379], [-123.01965, 38.5738], [-123.0202, 38.5778], [-123.02021, 38.58327], [-123.02844, 38.5831], [-123.02804, 38.57314], [-123.01966, 38.57379]]], [[[-123.07594, 38.54551], [-123.07147, 38.54555], [-123.07145, 38.54385], [-123.07153, 38.54362], [-123.07153, 38.54357], [-123.07158, 38.54349], [-123.07171, 38.54336], [-123.07186, 38.54325], [-123.07185, 38.54196], [-123.07588, 38.54192], [-123.07594, 38.54551]]]]} | Open Access 1 | 17520 | Austin Creek State Recreation Area | 30575 | 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 | 3371 | Stewards of the Coast and Redwoods 1112 | Non Profit 6 | Non Profit - Conservation 12 | http://www.parks.ca.gov/?page_id=452 | Sonoma 16 | 5650.514 | Austin Creek SRA | 1964 | State Recreation Area 39 | 4 |
2004 | 2004 | 2003 | {"type": "Polygon", "coordinates": [[[-120.83864, 35.3316], [-120.83864, 35.33176], [-120.83843, 35.33176], [-120.83823, 35.33167], [-120.83823, 35.33139], [-120.83864, 35.3316]]]} | Open Access 1 | 16907 | Audubon Overlook | 15703 | 3043 | Morro Coast Audubon Society 468 | Non Profit 6 | Non Profit - Conservation 12 | http://www.morrocoastaudubon.org/ | Non Governmental Organization 10 | 3043 | Morro Coast Audubon Society 461 | Non Profit 6 | Non Profit - Conservation 12 | San Luis Obispo 1 | 0.256 | Audubon Overlook | 0 | Private Conservation 16 | 2 | |
2300 | 2300 | 2299 | {"type": "Polygon", "coordinates": [[[-119.71423, 34.41147], [-119.71286, 34.41261], [-119.71211, 34.41205], [-119.71252, 34.41167], [-119.71232, 34.41149], [-119.71267, 34.41116], [-119.7132, 34.41071], [-119.71401, 34.41104], [-119.71423, 34.41147]]]} | Open Access 1 | 16932 | Honda Valley Park - Community Environmental Council | 20066 | 3015 | Community Environmental Council 508 | Non Profit 6 | Non Profit - Conservation 12 | http://www.communityenvironmentalcouncil.org/ | Non Governmental Organization 10 | 3015 | Community Environmental Council 500 | Non Profit 6 | Non Profit - Conservation 12 | Santa Barbara 7 | 5.43 | Honda Valley Park - Community Environmental Council | 0 | Private Conservation 16 | 2 | |
2838 | 2838 | 2837 | {"type": "Polygon", "coordinates": [[[-121.93421, 36.60999], [-121.93184, 36.60975], [-121.932, 36.60951], [-121.93212, 36.60925], [-121.93222, 36.60897], [-121.93226, 36.6088], [-121.93229, 36.60854], [-121.93229, 36.60833], [-121.93227, 36.60812], [-121.93222, 36.60787], [-121.93214, 36.60765], [-121.93203, 36.60742], [-121.9319, 36.60721], [-121.93327, 36.60681], [-121.93327, 36.60718], [-121.9333, 36.60759], [-121.9334, 36.60812], [-121.9335, 36.60851], [-121.93372, 36.60916], [-121.93395, 36.60967], [-121.93405, 36.60983], [-121.93421, 36.60999]]]} | Open Access 1 | 65 | Rip Van Winkle Open Space | 24395 | 3016 | Del Monte Forest Foundation 559 | Non Profit 6 | Non Profit - Conservation 12 | http://www.delmonteforestfoundation.org/ | Non Governmental Organization 10 | 3016 | Del Monte Forest Foundation 552 | Non Profit 6 | Non Profit - Conservation 12 | Monterey 14 | 9.948 | Rip Van Winkle OS | 0 | Private Recreation or Education 65 | 4 | |
4024 | 4024 | 4023 | {"type": "Polygon", "coordinates": [[[-119.29637, 34.28467], [-119.29622, 34.28505], [-119.29605, 34.2852], [-119.29592, 34.28522], [-119.29579, 34.28522], [-119.29576, 34.28518], [-119.29569, 34.28521], [-119.29557, 34.28515], [-119.29543, 34.28497], [-119.29559, 34.28481], [-119.29613, 34.2845], [-119.29628, 34.28453], [-119.29637, 34.28467]]]} | Open Access 1 | 46895 | Serra Cross Park | 30394 | 3369 | San Buenaventura Heritage 711 | Non Profit 6 | Non Profit - Other 22 | http://dudleyhouse.org/ | Non Governmental Organization 10 | 3370 | Serra Cross Conservancy 696 | Non Profit 6 | Non Profit - Conservation 12 | Ventura 8 | 1.051 | Serra Cross Park | 0 | Private Recreation or Education 65 | 4 | |
4108 | 4108 | 4107 | {"type": "Polygon", "coordinates": [[[-123.7877, 39.63706], [-123.78765, 39.63715], [-123.78756, 39.63709], [-123.78747, 39.63706], [-123.78742, 39.637], [-123.78734, 39.63695], [-123.78728, 39.63696], [-123.78707, 39.63694], [-123.78693, 39.63696], [-123.78677, 39.63716], [-123.7867, 39.63731], [-123.78664, 39.63756], [-123.78663, 39.63766], [-123.78665, 39.63786], [-123.78672, 39.63793], [-123.78675, 39.63799], [-123.78679, 39.63805], [-123.78703, 39.63809], [-123.78709, 39.63817], [-123.78709, 39.63824], [-123.78705, 39.63828], [-123.78701, 39.6383], [-123.78677, 39.63832], [-123.78672, 39.63838], [-123.78583, 39.63835], [-123.78581, 39.63823], [-123.78569, 39.63822], [-123.78568, 39.63835], [-123.78539, 39.63835], [-123.78536, 39.6379], [-123.785, 39.63789], [-123.78502, 39.63729], [-123.785, 39.63673], [-123.78517, 39.63673], [-123.78518, 39.63661], [-123.78502, 39.63659], [-123.785, 39.63648], [-123.7852, 39.63649], [-123.78521, 39.63616], [-123.785, 39.63614], [-123.785, 39.63607], [-123.78515, 39.63606], [-123.78514, 39.63598], [-123.785, 39.63598], [-123.78501, 39.6358], [-123.78536, 39.6358], [-123.78538, 39.63565], [-123.78636, 39.63564], [-123.78647, 39.63567], [-123.78654, 39.63571], [-123.78654, 39.63579], [-123.7865, 39.63582], [-123.78642, 39.63586], [-123.78625, 39.63582], [-123.78619, 39.63582], [-123.78615, 39.63585], [-123.78613, 39.6359], [-123.78613, 39.63594], [-123.78616, 39.636], [-123.7862, 39.63604], [-123.78636, 39.63606], [-123.78643, 39.63609], [-123.78645, 39.63618], [-123.78636, 39.63628], [-123.78634, 39.63634], [-123.78636, 39.63639], [-123.78656, 39.63645], [-123.78683, 39.63661], [-123.78692, 39.63669], [-123.78707, 39.63669], [-123.78713, 39.63662], [-123.78723, 39.63664], [-123.78731, 39.63668], [-123.78739, 39.63676], [-123.78757, 39.63684], [-123.78764, 39.6369], [-123.78769, 39.63698], [-123.7877, 39.63706]]]} | Open Access 1 | 47070 | Westport Headlands Park | 30721 | 3375 | Westport Village Society 722 | Non Profit 6 | Non Profit - Conservation 12 | http://www.westportvillagesociety.org/ | Non Governmental Organization 10 | 3375 | Westport Village Society 707 | Non Profit 6 | Non Profit - Conservation 12 | Mendocino 24 | 10.269 | Westport Headlands Park | 0 | Private Recreation or Education 65 | 4 | |
4230 | 4230 | 4229 | {"type": "Polygon", "coordinates": [[[-118.25946, 34.06588], [-118.25927, 34.06617], [-118.25885, 34.06598], [-118.25904, 34.06569], [-118.25946, 34.06588]]]} | Open Access 1 | 45071 | Patton Street Park | 28079 | 3094 | Trust for Public Land 734 | Non Profit 6 | Non Profit - Conservation 12 | http://www.tpl.org/ | Non Governmental Organization 10 | 3094 | Trust for Public Land 718 | Non Profit 6 | Non Profit - Conservation 12 | https://www.tpl.org/our-work/parks-for-people/patton-street-park | Los Angeles 6 | 0.4 | Patton Street Park | 0 | Private Recreation or Education 65 | 4 |
4321 | 4321 | 4320 | {"type": "Polygon", "coordinates": [[[-123.72841, 39.25459], [-123.72836, 39.25477], [-123.72774, 39.25477], [-123.72734, 39.25423], [-123.72695, 39.2538], [-123.72614, 39.25278], [-123.72607, 39.25268], [-123.72573, 39.25242], [-123.7255, 39.25223], [-123.7254, 39.25204], [-123.72532, 39.25184], [-123.72532, 39.25161], [-123.72539, 39.25135], [-123.72509, 39.25077], [-123.72528, 39.25029], [-123.72534, 39.24985], [-123.72518, 39.24933], [-123.72499, 39.24893], [-123.72531, 39.24875], [-123.72585, 39.24829], [-123.72603, 39.24822], [-123.72628, 39.24841], [-123.72658, 39.24867], [-123.72676, 39.24878], [-123.72664, 39.24928], [-123.72705, 39.24987], [-123.7272, 39.25039], [-123.72728, 39.25059], [-123.72746, 39.25075], [-123.72761, 39.25109], [-123.7274, 39.25158], [-123.72737, 39.25191], [-123.7272, 39.2526], [-123.72734, 39.25285], [-123.72759, 39.25311], [-123.72813, 39.25374], [-123.72841, 39.25459]]]} | Open Access 1 | 45423 | Raven's Call | 28205 | 3353 | Friends of the Enchanted Meadow 744 | Non Profit 6 | Non Profit - Conservation 12 | http://www.friendsofenchantedmeadow.org/ | Non Governmental Organization 10 | 3353 | Friends of the Enchanted Meadow 730 | Non Profit 6 | Non Profit - Conservation 12 | http://www.friendsofenchantedmeadow.org/raven.html | Mendocino 24 | 23.564 | Raven's Call | 0 | Private Conservation 16 | 2 |
4322 | 4322 | 4321 | {"type": "Polygon", "coordinates": [[[-123.7274, 39.24845], [-123.72682, 39.2487], [-123.72662, 39.2486], [-123.72645, 39.24844], [-123.72609, 39.24815], [-123.72594, 39.24806], [-123.72562, 39.24794], [-123.72529, 39.24766], [-123.72488, 39.24741], [-123.72471, 39.24728], [-123.72437, 39.24658], [-123.72419, 39.2464], [-123.72412, 39.2462], [-123.72418, 39.24532], [-123.72483, 39.24527], [-123.72523, 39.24513], [-123.7251, 39.24577], [-123.72525, 39.24628], [-123.72568, 39.24692], [-123.72603, 39.24724], [-123.72638, 39.24732], [-123.72713, 39.24796], [-123.72724, 39.24812], [-123.72735, 39.24824], [-123.7274, 39.24845]]]} | Open Access 1 | 45424 | Albert Cattalini Conservancy | 28204 | 3353 | Friends of the Enchanted Meadow 744 | Non Profit 6 | Non Profit - Conservation 12 | http://www.friendsofenchantedmeadow.org/ | Non Governmental Organization 10 | 3353 | Friends of the Enchanted Meadow 730 | Non Profit 6 | Non Profit - Conservation 12 | http://www.friendsofenchantedmeadow.org/acc.html | Mendocino 24 | 9.326 | Albert Cattalini Conservancy | 0 | Private Conservation 16 | 2 |
4598 | 4598 | 4597 | {"type": "Polygon", "coordinates": [[[-122.49894, 38.01446], [-122.49539, 38.01456], [-122.48924, 38.01369], [-122.48627, 38.01271], [-122.48623, 38.01267], [-122.48309, 38.01166], [-122.47894, 38.01029], [-122.47893, 38.00548], [-122.47958, 38.00571], [-122.48005, 38.00605], [-122.48038, 38.00636], [-122.48081, 38.00667], [-122.48135, 38.00724], [-122.4815, 38.00754], [-122.48158, 38.00762], [-122.48167, 38.00768], [-122.48183, 38.00773], [-122.48192, 38.00774], [-122.48203, 38.00772], [-122.48215, 38.00768], [-122.48231, 38.00767], [-122.48259, 38.00772], [-122.48287, 38.00766], [-122.48416, 38.00777], [-122.4859, 38.00918], [-122.48688, 38.0108], [-122.48795, 38.01262], [-122.48831, 38.01285], [-122.48847, 38.01316], [-122.48923, 38.01368], [-122.4895, 38.0131], [-122.48932, 38.01235], [-122.49261, 38.01094], [-122.49894, 38.01446]]]} | Open Access 1 | 35609 | Unnamed site - National Audubon Society | 30327 | 3046 | National Audubon Society 651 | Non Profit 6 | Non Profit - Conservation 12 | http://ca.audubon.org/ | Non Governmental Organization 10 | 3046 | National Audubon Society 640 | Non Profit 6 | Non Profit - Conservation 12 | Marin 23 | 123.625 | 0 | Private Other or Unknown 399 | 4 | ||
4685 | 4685 | 4684 | {"type": "Polygon", "coordinates": [[[-119.72173, 34.41045], [-119.72161, 34.41166], [-119.72134, 34.41164], [-119.72147, 34.41038], [-119.72173, 34.41045]]]} | Open Access 1 | 43089 | Unnamed site - Community Environmental Council | 28696 | 3015 | Community Environmental Council 508 | Non Profit 6 | Non Profit - Conservation 12 | http://www.communityenvironmentalcouncil.org/ | Non Governmental Organization 10 | 3015 | Community Environmental Council 500 | Non Profit 6 | Non Profit - Conservation 12 | Santa Barbara 7 | 0.838 | 0 | Private Other or Unknown 399 | 4 | ||
4806 | 4806 | 4805 | {"type": "MultiPolygon", "coordinates": [[[[-116.57588, 33.86683], [-116.57583, 33.86863], [-116.57481, 33.86799], [-116.57389, 33.86748], [-116.57281, 33.86696], [-116.56836, 33.86466], [-116.5693, 33.86342], [-116.57588, 33.86683]]], [[[-116.58857, 33.87432], [-116.58641, 33.8765], [-116.5835, 33.8743], [-116.57999, 33.8743], [-116.58009, 33.87175], [-116.57794, 33.87017], [-116.57805, 33.867], [-116.58853, 33.86709], [-116.5885, 33.86893], [-116.58848, 33.87431], [-116.58857, 33.87432]], [[-116.58424, 33.87431], [-116.58425, 33.8743], [-116.5842, 33.87071], [-116.58126, 33.87068], [-116.58129, 33.86975], [-116.58018, 33.86974], [-116.58011, 33.87138], [-116.58399, 33.8743], [-116.58424, 33.87431]]], [[[-116.59703, 33.84893], [-116.59628, 33.84774], [-116.59315, 33.84624], [-116.59266, 33.84624], [-116.59266, 33.84775], [-116.59182, 33.85041], [-116.59013, 33.8521], [-116.58881, 33.8521], [-116.58694, 33.85056], [-116.58252, 33.85498], [-116.58043, 33.85497], [-116.58041, 33.85259], [-116.5842, 33.84764], [-116.58807, 33.84439], [-116.58805, 33.84438], [-116.58749, 33.84448], [-116.58576, 33.84492], [-116.58525, 33.84492], [-116.58542, 33.84468], [-116.58523, 33.84457], [-116.59005, 33.8418], [-116.59181, 33.84035], [-116.59466, 33.83871], [-116.59548, 33.83871], [-116.597, 33.84], [-116.59703, 33.84893]]]]} | Open Access 1 | 48582 | Unnamed site - Friends of Palm Springs Mountains | 33292 | 3378 | Friends of Palm Springs Mountains 787 | Non Profit 6 | Non Profit - Conservation 12 | http://friendsofpalmspringsmountains.org/ | Non Governmental Organization 10 | 3378 | Friends of Palm Springs Mountains 766 | Non Profit 6 | Non Profit - Conservation 12 | http://friendsofpalmspringsmountains.org | Riverside 10 | 501.078 | 0 | Private Other or Unknown 399 | 4 | |
5006 | 5006 | 5005 | {"type": "Polygon", "coordinates": [[[-118.62819, 34.09631], [-118.62814, 34.1035], [-118.62683, 34.10349], [-118.62683, 34.10402], [-118.62661, 34.10402], [-118.6266, 34.10349], [-118.6238, 34.10347], [-118.62382, 34.09987], [-118.62381, 34.09806], [-118.61947, 34.09805], [-118.61948, 34.09625], [-118.62381, 34.09625], [-118.62819, 34.09631]]]} | Open Access 1 | 12508 | Mountains Restoration Trust Parkland | 22563 | 3044 | Mountains Restoration Trust 533 | Non Profit 6 | Non Profit - Conservation 12 | http://www.mountainstrust.org/ | Non Governmental Organization 10 | 3044 | Mountains Restoration Trust 526 | Non Profit 6 | Non Profit - Conservation 12 | Los Angeles 6 | 99.528 | Mtns. Restoration Trust Parkland | 0 | Private Recreation or Education 65 | 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]);