units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
19 rows where ACCESS_TYP = 1, GAP_STS = 4 and MNG_AG_TYP = 12
This data as json, copyable, CSV (advanced)
MNG_AGENCY 10
- Del Monte Forest Foundation 5
- Mountains Restoration Trust 4
- National Audubon Society 2
- Trust for Public Land 2
- Community Environmental Council 1
- Serra Cross Conservancy 1
- Westport Village Society 1
- Friends of Palm Springs Mountains 1
- Palo Cerdo Community Park Association 1
- Stewards of the Coast and Redwoods 1
MNG_AG_TYP 1
- Non Profit - Conservation · 19 ✖
ACCESS_TYP 1
- Open Access · 19 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
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 | |
5407 | 5407 | 5406 | {"type": "Polygon", "coordinates": [[[-118.44355, 34.10751], [-118.443, 34.10752], [-118.44352, 34.10878], [-118.44023, 34.10877], [-118.44022, 34.10977], [-118.43891, 34.10965], [-118.4389, 34.11005], [-118.43864, 34.11005], [-118.43799, 34.10993], [-118.43749, 34.10981], [-118.43745, 34.10968], [-118.43747, 34.10956], [-118.43721, 34.10939], [-118.43722, 34.10936], [-118.43714, 34.10934], [-118.43707, 34.10929], [-118.43709, 34.10922], [-118.43709, 34.10895], [-118.43705, 34.10884], [-118.43772, 34.10905], [-118.43841, 34.10906], [-118.4389, 34.1088], [-118.43891, 34.10871], [-118.44022, 34.10836], [-118.44023, 34.10745], [-118.44353, 34.10745], [-118.44355, 34.10751]]]} | Open Access 1 | 12500 | 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 | 18.111 | Mtns. Restoration Trust Parkland | 0 | Private Recreation or Education 65 | 4 | |
5650 | 5650 | 5649 | {"type": "Polygon", "coordinates": [[[-121.91973, 36.57135], [-121.91927, 36.57204], [-121.91913, 36.57218], [-121.91899, 36.57228], [-121.9188, 36.57237], [-121.91865, 36.57242], [-121.91734, 36.57272], [-121.91712, 36.57281], [-121.91691, 36.57295], [-121.91673, 36.57312], [-121.91662, 36.57329], [-121.91656, 36.57344], [-121.91651, 36.57366], [-121.91641, 36.57382], [-121.91592, 36.57423], [-121.91582, 36.57434], [-121.91426, 36.57282], [-121.91371, 36.572], [-121.91315, 36.57044], [-121.91344, 36.5697], [-121.91321, 36.569], [-121.91335, 36.56903], [-121.91351, 36.56904], [-121.91351, 36.56926], [-121.9144, 36.57029], [-121.91474, 36.57044], [-121.91522, 36.57083], [-121.91546, 36.57079], [-121.91582, 36.57063], [-121.91625, 36.57039], [-121.91654, 36.57045], [-121.91675, 36.57035], [-121.91716, 36.57037], [-121.91973, 36.57135]]]} | Open Access 1 | 35182 | Unnamed site - Del Monte Forest Foundation | 28634 | 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 | 37.011 | 0 | Private Other or Unknown 399 | 4 | ||
7265 | 7265 | 7264 | {"type": "Polygon", "coordinates": [[[-118.6346, 34.10682], [-118.63459, 34.10718], [-118.6335, 34.10718], [-118.63333, 34.10682], [-118.63356, 34.10682], [-118.63372, 34.1069], [-118.63389, 34.10682], [-118.6346, 34.10682]]]} | Open Access 1 | 6453 | Red Rock Canyon Park | 24227 | 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 | 1.049 | Red Rock Canyon Park | 0 | Private Recreation or Education 65 | 4 | |
7599 | 7599 | 7598 | {"type": "Polygon", "coordinates": [[[-117.35825, 33.16477], [-117.35811, 33.16484], [-117.35793, 33.16488], [-117.35776, 33.16502], [-117.35773, 33.16507], [-117.35761, 33.1652], [-117.35715, 33.1652], [-117.35715, 33.16625], [-117.35629, 33.16543], [-117.35617, 33.16533], [-117.35607, 33.16521], [-117.35598, 33.1652], [-117.35586, 33.16509], [-117.35548, 33.16483], [-117.35555, 33.16478], [-117.3555, 33.16464], [-117.35547, 33.16431], [-117.35558, 33.16437], [-117.35557, 33.16441], [-117.35563, 33.16466], [-117.35569, 33.16472], [-117.35576, 33.16486], [-117.35757, 33.16474], [-117.3576, 33.16476], [-117.35792, 33.16464], [-117.35803, 33.16453], [-117.35825, 33.16477]]]} | Open Access 1 | 7307 | Buena Vista Lagoon and Nature Center | 16487 | 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 | http://bvaudubon.org/nature-center/ | San Diego 4 | 3.999 | Buena Vista Lagoon and Nature Ctr. | 0 | Private Recreation or Education 65 | 4 |
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 | |
14713 | 14713 | 14712 | {"type": "Polygon", "coordinates": [[[-118.2902, 34.09309], [-118.2894, 34.0931], [-118.2894, 34.09282], [-118.2902, 34.09282], [-118.2902, 34.09309]]]} | Open Access 1 | 45052 | Madison Avenue Park | 28044 | 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 | http://www.tpl.org/our-work/parks-for-people/madison-ave-park | Los Angeles 6 | 0.559 | Madison Avenue Park | 0 | Private Recreation or Education 65 | 4 |
15455 | 15455 | 15454 | {"type": "Polygon", "coordinates": [[[-121.92654, 36.55993], [-121.92639, 36.56001], [-121.92627, 36.56009], [-121.92593, 36.5604], [-121.92586, 36.56052], [-121.92584, 36.56072], [-121.9258, 36.56082], [-121.92535, 36.56122], [-121.92524, 36.56139], [-121.92521, 36.56155], [-121.92522, 36.56169], [-121.92527, 36.56181], [-121.92548, 36.56213], [-121.9255, 36.56223], [-121.9255, 36.5623], [-121.92531, 36.56285], [-121.9253, 36.56346], [-121.92527, 36.56357], [-121.92521, 36.56369], [-121.92503, 36.56395], [-121.92494, 36.56423], [-121.92488, 36.56435], [-121.92364, 36.56601], [-121.92339, 36.5663], [-121.92263, 36.56706], [-121.92253, 36.56721], [-121.92229, 36.56781], [-121.9215, 36.56899], [-121.92037, 36.57038], [-121.91973, 36.57135], [-121.9174, 36.57047], [-121.91788, 36.57038], [-121.91798, 36.57033], [-121.91806, 36.57027], [-121.91812, 36.57016], [-121.91814, 36.57004], [-121.91814, 36.56987], [-121.9181, 36.56969], [-121.91852, 36.56965], [-121.91856, 36.5695], [-121.91863, 36.5694], [-121.91908, 36.56966], [-121.91949, 36.5694], [-121.91981, 36.56917], [-121.92027, 36.56865], [-121.92032, 36.56821], [-121.91981, 36.56826], [-121.91938, 36.56839], [-121.91933, 36.56832], [-121.91974, 36.56816], [-121.9197, 36.56792], [-121.92011, 36.56765], [-121.92071, 36.56744], [-121.92063, 36.56718], [-121.92068, 36.56711], [-121.9207, 36.56705], [-121.92069, 36.56697], [-121.92066, 36.56691], [-121.92055, 36.56682], [-121.92021, 36.56676], [-121.92018, 36.56674], [-121.92018, 36.56671], [-121.92025, 36.56654], [-121.9203, 36.56634], [-121.92033, 36.5663], [-121.92052, 36.56619], [-121.92061, 36.56608], [-121.92064, 36.56598], [-121.92065, 36.56577], [-121.92069, 36.56566], [-121.92074, 36.5656], [-121.92079, 36.56558], [-121.92083, 36.56559], [-121.92123, 36.56582], [-121.92138, 36.56588], [-121.92156, 36.5659], [-121.92174, 36.56589], [-121.92193, 36.56583], [-121.9225, 36.56551], [-121.92266, 36.5653], [-121.92316, 36.56553], [-121.92356, 36.56515], [-121.92407, 36.56498], [-121.92359, 36.56459], [-121.92364, 36.56458], [-121.92411, 36.56494], [-121.9244, 36.5646], [-121.92459, 36.56419], [-121.92475, 36.56316], [-121.92474, 36.56315], [-121.92413, 36.5632], [-121.92413, 36.56317], [-121.92476, 36.56311], [-121.92476, 36.56234], [-121.92442, 36.56176], [-121.92466, 36.56167], [-121.92466, 36.56142], [-121.92486, 36.56142], [-121.92486, 36.56128], [-121.92498, 36.56112], [-121.92508, 36.56103], [-121.92507, 36.56041], [-121.92531, 36.56034], [-121.92639, 36.55982], [-121.92654, 36.55993]]]} | Open Access 1 | 35191 | Unnamed site - Del Monte Forest Foundation | 28634 | 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 | 38.319 | 0 | Private Other or Unknown 399 | 4 | ||
15456 | 15456 | 15455 | {"type": "Polygon", "coordinates": [[[-121.93147, 36.56365], [-121.93048, 36.56454], [-121.93017, 36.56492], [-121.92926, 36.56425], [-121.93065, 36.56304], [-121.93147, 36.56365]]]} | Open Access 1 | 35193 | Unnamed site - Del Monte Forest Foundation | 28634 | 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 | 4.643 | 0 | Private Other or Unknown 399 | 4 | ||
15484 | 15484 | 15483 | {"type": "Polygon", "coordinates": [[[-121.96137, 36.58829], [-121.96126, 36.5894], [-121.96019, 36.58938], [-121.9593, 36.58896], [-121.95808, 36.58933], [-121.95723, 36.58925], [-121.95638, 36.58921], [-121.95543, 36.58899], [-121.95365, 36.58957], [-121.95329, 36.58964], [-121.953, 36.58949], [-121.95272, 36.58928], [-121.95237, 36.58925], [-121.9525, 36.58896], [-121.95323, 36.58923], [-121.95342, 36.58928], [-121.95368, 36.58932], [-121.95394, 36.58932], [-121.9542, 36.58931], [-121.95445, 36.58926], [-121.95475, 36.58916], [-121.95495, 36.58906], [-121.95511, 36.58897], [-121.95577, 36.58843], [-121.95587, 36.58828], [-121.95593, 36.58806], [-121.956, 36.58793], [-121.9561, 36.58779], [-121.95621, 36.58768], [-121.95638, 36.58758], [-121.95672, 36.58744], [-121.95702, 36.58735], [-121.95723, 36.58732], [-121.95762, 36.5873], [-121.95783, 36.58732], [-121.95808, 36.58736], [-121.96137, 36.58829]]]} | Open Access 1 | 43084 | Unnamed site - Del Monte Forest Foundation | 28634 | 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 | 22.917 | 0 | Private Other or Unknown 399 | 4 | ||
15852 | 15852 | 15851 | {"type": "Polygon", "coordinates": [[[-118.65341, 34.04402], [-118.65239, 34.04383], [-118.65222, 34.04364], [-118.65222, 34.04358], [-118.65237, 34.0435], [-118.65252, 34.04337], [-118.65338, 34.04326], [-118.65341, 34.04402]]]} | Open Access 1 | 12524 | 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 | 1.603 | Mtns. Restoration Trust Parkland | 0 | Private Recreation or Education 65 | 4 | |
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 |
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]);