units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
327 rows where ACCESS_TYP = 3 and GAP_STS = 2 sorted by COUNTY
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV, AGNCY_TYP
MNG_AGENCY >30
- The Nature Conservancy 30
- Peninsula Open Space Trust 22
- The Environmental Trust 21
- East Bay Regional Park District 18
- Midpeninsula Regional Open Space District 18
- United States Fish and Wildlife Service 16
- Endangered Habitats Conservancy 14
- California Department of Fish and Wildlife 13
- American River Conservancy 13
- Save Mount Diablo 13
- Santa Clara Valley Open Space Authority 12
- Sonoma Land Trust 11
- Center for Natural Lands Management 8
- San Diego, County of 8
- Elkhorn Slough Foundation 8
- Marin Audubon Society 7
- Riverside County Habitat Conservation Agency 5
- Wilderness Land Trust 5
- Land Trust of Santa Cruz County 4
- Big Sur Land Trust 4
- Land Conservancy of San Luis Obispo County 4
- Pacific Forest Trust 4
- The Conservation Fund - California 4
- Bear Yuba Land Trust 3
- John Muir Land Trust 3
- Fallbrook Land Conservancy 3
- Placer Land Trust 3
- San Diego, City of 2
- Save the Redwoods League 2
- University of California 2
- …
MNG_AG_TYP 13
DES_TP 5
ACCESS_TYP 1
- No Public Access · 327 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2280 | 2280 | 2279 | {"type": "Polygon", "coordinates": [[[-120.79412, 35.2179], [-120.78887, 35.21784], [-120.7889, 35.21415], [-120.79407, 35.21418], [-120.79412, 35.2179]]]} | No Public Access 3 | 16850 | Hibberd | 19893 | 3032 | Land Conservancy of San Luis Obispo County 506 | Non Profit 6 | Non Profit - Land Trust 10 | http://lcslo.org/ | Non Governmental Organization 10 | 3032 | Land Conservancy of San Luis Obispo County 498 | Non Profit 6 | Non Profit - Land Trust 10 | San Luis Obispo 1 | 48.246 | Hibberd | 0 | Private Conservation 16 | 2 | |
8858 | 8858 | 8857 | {"type": "Polygon", "coordinates": [[[-120.70034, 35.19238], [-120.70034, 35.19247], [-120.69736, 35.19188], [-120.69769, 35.19026], [-120.6994, 35.19064], [-120.69895, 35.19212], [-120.70034, 35.19238]]]} | No Public Access 3 | 14483 | TNC | 26376 | 3032 | Land Conservancy of San Luis Obispo County 506 | Non Profit 6 | Non Profit - Land Trust 10 | http://lcslo.org/ | Non Governmental Organization 10 | 3032 | Land Conservancy of San Luis Obispo County 498 | Non Profit 6 | Non Profit - Land Trust 10 | San Luis Obispo 1 | 7.119 | TNC | 0 | Private Conservation 16 | 2 | |
10046 | 10046 | 10045 | {"type": "MultiPolygon", "coordinates": [[[[-121.08114, 35.55145], [-121.08094, 35.55155], [-121.08081, 35.55137], [-121.081, 35.55127], [-121.08114, 35.55145]]], [[[-121.08169, 35.55293], [-121.08166, 35.55296], [-121.08162, 35.55297], [-121.0814, 35.55288], [-121.08151, 35.55272], [-121.08167, 35.55289], [-121.08169, 35.55293]]], [[[-121.08169, 35.55181], [-121.0815, 35.55191], [-121.08145, 35.55186], [-121.08165, 35.55176], [-121.08169, 35.55181]]], [[[-121.08289, 35.55133], [-121.08268, 35.55142], [-121.0826, 35.55129], [-121.08281, 35.55121], [-121.08289, 35.55133]]], [[[-121.08323, 35.55368], [-121.08304, 35.55379], [-121.083, 35.55374], [-121.08318, 35.55362], [-121.08323, 35.55368]]], [[[-121.08343, 35.5522], [-121.08323, 35.55229], [-121.08305, 35.55203], [-121.08322, 35.55198], [-121.08328, 35.55199], [-121.08343, 35.5522]]], [[[-121.08398, 35.553], [-121.08385, 35.55317], [-121.08371, 35.55309], [-121.08383, 35.55293], [-121.08398, 35.553]]], [[[-121.08484, 35.55543], [-121.08475, 35.55561], [-121.08467, 35.55559], [-121.08476, 35.5554], [-121.08484, 35.55543]]], [[[-121.08514, 35.5535], [-121.08511, 35.55367], [-121.08494, 35.55365], [-121.08497, 35.55347], [-121.08514, 35.5535]]], [[[-121.08639, 35.55379], [-121.08638, 35.55383], [-121.08634, 35.55385], [-121.08599, 35.55394], [-121.08602, 35.55378], [-121.08594, 35.55376], [-121.08597, 35.5536], [-121.0862, 35.55366], [-121.08636, 35.55374], [-121.08639, 35.55379]]], [[[-121.08617, 35.55567], [-121.08611, 35.55581], [-121.08603, 35.55579], [-121.08609, 35.55564], [-121.08617, 35.55567]]], [[[-121.08866, 35.55383], [-121.08865, 35.55389], [-121.08842, 35.55387], [-121.08844, 35.5538], [-121.08866, 35.55383]]], [[[-121.08965, 35.557], [-121.08936, 35.55714], [-121.08931, 35.557], [-121.08958, 35.55687], [-121.0896, 35.55695], [-121.08965, 35.557]]]]} | No Public Access 3 | 17393 | Lodge Hill parcels | 21397 | 3032 | Land Conservancy of San Luis Obispo County 506 | Non Profit 6 | Non Profit - Land Trust 10 | http://lcslo.org/ | Non Governmental Organization 10 | 3032 | Land Conservancy of San Luis Obispo County 498 | Non Profit 6 | Non Profit - Land Trust 10 | San Luis Obispo 1 | 1.127 | Lodge Hill parcels | 0 | Private Conservation 16 | 2 | |
13196 | 13196 | 13195 | {"type": "Polygon", "coordinates": [[[-120.69671, 35.21015], [-120.69648, 35.21383], [-120.69588, 35.21367], [-120.69582, 35.21305], [-120.69488, 35.21206], [-120.69486, 35.21153], [-120.69523, 35.21097], [-120.69491, 35.21018], [-120.6944, 35.21024], [-120.69417, 35.2098], [-120.6947, 35.20957], [-120.69457, 35.20887], [-120.69452, 35.20886], [-120.69458, 35.20871], [-120.69459, 35.20841], [-120.69464, 35.20835], [-120.69465, 35.20829], [-120.69462, 35.20823], [-120.69456, 35.20817], [-120.69453, 35.20811], [-120.69448, 35.20794], [-120.69445, 35.20779], [-120.69445, 35.20765], [-120.69448, 35.20748], [-120.69452, 35.20733], [-120.69463, 35.20708], [-120.69467, 35.20686], [-120.69465, 35.20663], [-120.69452, 35.20621], [-120.69481, 35.20652], [-120.69538, 35.20694], [-120.69566, 35.20712], [-120.69579, 35.20725], [-120.69597, 35.20768], [-120.69611, 35.20786], [-120.69624, 35.20823], [-120.69638, 35.20857], [-120.69638, 35.20863], [-120.69635, 35.2087], [-120.69619, 35.20887], [-120.69611, 35.20902], [-120.69609, 35.2092], [-120.69612, 35.20937], [-120.69621, 35.20956], [-120.69632, 35.20972], [-120.69671, 35.21015]]]} | No Public Access 3 | 35201 | Lower San Luis Obispo Creek Wetland Preserve | 28539 | 3032 | Land Conservancy of San Luis Obispo County 506 | Non Profit 6 | Non Profit - Land Trust 10 | http://lcslo.org/ | Non Governmental Organization 10 | 3032 | Land Conservancy of San Luis Obispo County 498 | Non Profit 6 | Non Profit - Land Trust 10 | San Luis Obispo 1 | 25.543 | Lower San Luis Obispo Creek Wetland Preserve | 0 | Private Conservation 16 | 2 | |
14595 | 14595 | 14594 | {"type": "Polygon", "coordinates": [[[-119.92048, 35.24895], [-119.9167, 35.24893], [-119.91667, 35.24586], [-119.92046, 35.24588], [-119.92048, 35.24895]]]} | No Public Access 3 | 44808 | Carrizo Plains | 30593 | 3091 | The Nature Conservancy 63 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.nature.org/ | Non Governmental Organization 10 | 3091 | The Nature Conservancy 61 | Non Profit 6 | Non Profit - Land Trust 10 | San Luis Obispo 1 | 29.058 | Carrizo Plains | 1988 | Private Conservation 16 | 2 | |
15838 | 15838 | 15837 | {"type": "Polygon", "coordinates": [[[-120.6439, 34.9918], [-120.64384, 34.9919], [-120.64378, 34.99239], [-120.64357, 34.9928], [-120.64329, 34.99393], [-120.64298, 34.99498], [-120.64294, 34.99515], [-120.64281, 34.9954], [-120.64275, 34.99566], [-120.64269, 34.99612], [-120.64233, 34.99725], [-120.6422, 34.99758], [-120.64216, 34.99782], [-120.64201, 34.99809], [-120.64195, 34.99827], [-120.64193, 34.99852], [-120.64188, 34.99881], [-120.64157, 34.99965], [-120.64148, 34.99986], [-120.64143, 35.00008], [-120.64142, 35.0003], [-120.64123, 35.00087], [-120.64107, 35.00159], [-120.64094, 35.0018], [-120.64086, 35.00204], [-120.64077, 35.00275], [-120.64065, 35.00312], [-120.64051, 35.00376], [-120.64033, 35.00428], [-120.64027, 35.00458], [-120.64017, 35.00558], [-120.64, 35.00637], [-120.63988, 35.00705], [-120.6396, 35.00785], [-120.63944, 35.00839], [-120.6393, 35.00916], [-120.63923, 35.00944], [-120.63907, 35.00987], [-120.63903, 35.01037], [-120.63887, 35.01086], [-120.63884, 35.01116], [-120.63887, 35.01153], [-120.63865, 35.01204], [-120.63852, 35.01238], [-120.6384, 35.0128], [-120.63835, 35.01308], [-120.63833, 35.01329], [-120.63824, 35.01358], [-120.63809, 35.01392], [-120.63802, 35.01426], [-120.63796, 35.01466], [-120.63791, 35.01485], [-120.63784, 35.01503], [-120.63765, 35.0153], [-120.63758, 35.01554], [-120.63755, 35.01569], [-120.63756, 35.01602], [-120.63756, 35.01624], [-120.63743, 35.01648], [-120.63735, 35.01682], [-120.63733, 35.01709], [-120.63735, 35.01731], [-120.63733, 35.01745], [-120.63704, 35.01798], [-120.63655, 35.01776], [-120.6003, 35.00805], [-120.59846, 35.00816], [-120.59846, 35.00818], [-120.61198, 35.01744], [-120.60861, 35.0222], [-120.60843, 35.02213], [-120.60438, 35.02099], [-120.60736, 35.01428], [-120.60245, 35.01411], [-120.59815, 35.00853], [-120.59843, 35.00816], [-120.59195, 35.00372], [-120.59023, 34.99117], [-120.60688, 34.9912], [-120.60692, 34.99166], [-120.6439, 34.9918]]]} | No Public Access 3 | 25204 | Guadalupe-Nipomo Dunes National Wildlife Refuge | 19540 | 106 | United States Fish and Wildlife Service 45 | Federal 1 | Federal Agency 1 | http://www.fws.gov/ | US Fish and Wildlife Service 8 | 106 | United States Fish and Wildlife Service 44 | Federal 1 | Federal Agency 1 | San Luis Obispo 1 | 2647.421 | Guadalupe-Nipomo Dunes NWR | 2000 | National Wildlife Refuge 105 | 2 | |
154 | 154 | 153 | {"type": "Polygon", "coordinates": [[[-116.74026, 33.1805], [-116.73988, 33.18051], [-116.73975, 33.18053], [-116.73967, 33.18056], [-116.7395, 33.18056], [-116.73938, 33.18052], [-116.73921, 33.18041], [-116.73814, 33.18041], [-116.73818, 33.18262], [-116.73708, 33.18261], [-116.73375, 33.18275], [-116.73377, 33.17923], [-116.74025, 33.17921], [-116.74026, 33.1805]]]} | No Public Access 3 | 416 | Ewing Oak Preserve | 18771 | 3091 | The Nature Conservancy 63 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.nature.org/ | Non Governmental Organization 10 | 3091 | The Nature Conservancy 61 | Non Profit 6 | Non Profit - Land Trust 10 | San Diego 4 | 45.451 | Ewing Oak Preserve | 0 | Private Conservation 16 | 2 | |
196 | 196 | 195 | {"type": "Polygon", "coordinates": [[[-116.80824, 32.84466], [-116.80813, 32.84546], [-116.80736, 32.84567], [-116.80702, 32.84516], [-116.80704, 32.84466], [-116.80824, 32.84466]]]} | No Public Access 3 | 46830 | Palmer Property | 30298 | 3208 | Endangered Habitats Conservancy 79 | Non Profit 6 | Non Profit - Conservation 12 | http://www.ehleague.org/EndangeredHabitatsConservancy.html | Non Governmental Organization 10 | 3208 | Endangered Habitats Conservancy 77 | Non Profit 6 | Non Profit - Conservation 12 | San Diego 4 | 2.548 | Palmer Property | 0 | Private Conservation 16 | 2 | |
256 | 256 | 255 | {"type": "Polygon", "coordinates": [[[-116.59188, 32.61847], [-116.59183, 32.62191], [-116.5879, 32.62185], [-116.57534, 32.62173], [-116.57533, 32.6218], [-116.57501, 32.62179], [-116.57504, 32.61913], [-116.5737, 32.61912], [-116.57357, 32.61185], [-116.5833, 32.61188], [-116.5833, 32.61473], [-116.58772, 32.61475], [-116.58772, 32.61842], [-116.59188, 32.61847]]]} | No Public Access 3 | 845 | Mason Wildlife Refuge | 21944 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | San Diego 4 | 353.869 | Mason Wildlife Refuge | 0 | Local Conservation Area 4 | 2 | |
1301 | 1301 | 1300 | {"type": "MultiPolygon", "coordinates": [[[[-117.13039, 33.09966], [-117.12847, 33.0991], [-117.12813, 33.09906], [-117.12781, 33.09906], [-117.12747, 33.0991], [-117.12747, 33.09743], [-117.12941, 33.09743], [-117.1294, 33.09846], [-117.13038, 33.09848], [-117.13039, 33.09966]]], [[[-117.13063, 33.0997], [-117.13052, 33.09975], [-117.13053, 33.0991], [-117.13063, 33.09923], [-117.13063, 33.0997]]]]} | No Public Access 3 | 10457 | Quarry Property | 24058 | 3021 | Escondido Creek Conservancy 344 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.escondidocreek.org/ | Non Governmental Organization 10 | 3021 | Escondido Creek Conservancy 341 | Non Profit 6 | Non Profit - Land Trust 10 | San Diego 4 | 11.308 | Quarry Property | 0 | Private Conservation 16 | 2 | |
1625 | 1625 | 1624 | {"type": "Polygon", "coordinates": [[[-117.03443, 32.57835], [-117.03338, 32.57837], [-117.03339, 32.57655], [-117.03443, 32.57653], [-117.03443, 32.57835]]]} | No Public Access 3 | 12395 | Newport 5 Preserve | 22731 | 3088 | The Environmental Trust 395 | Non Profit 6 | Non Profit - Land Trust 10 | Non Governmental Organization 10 | 3088 | The Environmental Trust 389 | Non Profit 6 | Non Profit - Land Trust 10 | San Diego 4 | 4.919 | Newport 5 Preserve | 0 | Private Conservation 16 | 2 | ||
3308 | 3308 | 3307 | {"type": "Polygon", "coordinates": [[[-116.87605, 32.81198], [-116.87602, 32.81296], [-116.87303, 32.81508], [-116.87286, 32.81473], [-116.87304, 32.8145], [-116.87303, 32.81413], [-116.87289, 32.81331], [-116.87318, 32.8132], [-116.87335, 32.81308], [-116.87345, 32.81299], [-116.87353, 32.81288], [-116.87364, 32.81257], [-116.87401, 32.81237], [-116.87427, 32.81228], [-116.87453, 32.81222], [-116.87555, 32.8121], [-116.8758, 32.81205], [-116.87605, 32.81198]]]} | No Public Access 3 | 46828 | La Cresta Hills Property | 30296 | 3208 | Endangered Habitats Conservancy 79 | Non Profit 6 | Non Profit - Conservation 12 | http://www.ehleague.org/EndangeredHabitatsConservancy.html | Non Governmental Organization 10 | 3208 | Endangered Habitats Conservancy 77 | Non Profit 6 | Non Profit - Conservation 12 | San Diego 4 | 12.874 | La Cresta Hills Property | 0 | Private Conservation 16 | 2 | |
3309 | 3309 | 3308 | {"type": "Polygon", "coordinates": [[[-116.86574, 32.79365], [-116.86293, 32.79371], [-116.86299, 32.79622], [-116.86104, 32.79623], [-116.861, 32.79604], [-116.85956, 32.79629], [-116.85947, 32.79387], [-116.85842, 32.79388], [-116.85828, 32.78993], [-116.86564, 32.79012], [-116.86574, 32.79365]]]} | No Public Access 3 | 46829 | Michelson Property | 30297 | 3208 | Endangered Habitats Conservancy 79 | Non Profit 6 | Non Profit - Conservation 12 | http://www.ehleague.org/EndangeredHabitatsConservancy.html | Non Governmental Organization 10 | 3208 | Endangered Habitats Conservancy 77 | Non Profit 6 | Non Profit - Conservation 12 | San Diego 4 | 91.593 | Michelson Property | 0 | Private Conservation 16 | 2 | |
3313 | 3313 | 3312 | {"type": "Polygon", "coordinates": [[[-116.86309, 32.80074], [-116.86305, 32.80446], [-116.86307, 32.8054], [-116.85868, 32.80542], [-116.85866, 32.80438], [-116.85442, 32.80443], [-116.85445, 32.80069], [-116.85863, 32.80069], [-116.86309, 32.80074]]]} | No Public Access 3 | 46834 | Ulrich Property | 30302 | 3208 | Endangered Habitats Conservancy 79 | Non Profit 6 | Non Profit - Conservation 12 | http://www.ehleague.org/EndangeredHabitatsConservancy.html | Non Governmental Organization 10 | 3208 | Endangered Habitats Conservancy 77 | Non Profit 6 | Non Profit - Conservation 12 | San Diego 4 | 93.312 | Ulrich Property | 0 | Private Conservation 16 | 2 | |
3784 | 3784 | 3783 | {"type": "Polygon", "coordinates": [[[-117.20473, 33.05108], [-117.20464, 33.05469], [-117.20246, 33.0547], [-117.20247, 33.0538], [-117.20029, 33.0538], [-117.20031, 33.05284], [-117.20145, 33.05291], [-117.20206, 33.05299], [-117.20261, 33.05309], [-117.20314, 33.05324], [-117.20356, 33.05338], [-117.20345, 33.05243], [-117.20262, 33.05107], [-117.20473, 33.05108]]]} | No Public Access 3 | 10456 | Bumann Property | 16502 | 3021 | Escondido Creek Conservancy 344 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.escondidocreek.org/ | Non Governmental Organization 10 | 3021 | Escondido Creek Conservancy 341 | Non Profit 6 | Non Profit - Land Trust 10 | San Diego 4 | 21.404 | Bumann Property | 0 | Private Conservation 16 | 2 | |
4033 | 4033 | 4032 | {"type": "MultiPolygon", "coordinates": [[[[-116.43699, 32.64546], [-116.43674, 32.66028], [-116.42828, 32.6603], [-116.42816, 32.64566], [-116.43699, 32.64546]]], [[[-116.45411, 32.66395], [-116.4541, 32.66484], [-116.44972, 32.66482], [-116.44972, 32.66394], [-116.45411, 32.66395]]]]} | No Public Access 3 | 46971 | La Posta - Cameron Preserve | 30601 | 3091 | The Nature Conservancy 63 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.nature.org/ | Non Governmental Organization 10 | 3091 | The Nature Conservancy 61 | Non Profit 6 | Non Profit - Land Trust 10 | San Diego 4 | 337.313 | La Posta - Cameron Preserve | 0 | Private Conservation 16 | 2 | |
4191 | 4191 | 4190 | {"type": "Polygon", "coordinates": [[[-117.31392, 33.12069], [-117.31373, 33.12084], [-117.31366, 33.12093], [-117.31361, 33.12104], [-117.31358, 33.12116], [-117.31353, 33.12176], [-117.31334, 33.12176], [-117.31333, 33.12179], [-117.31224, 33.12177], [-117.31177, 33.12178], [-117.3113, 33.12182], [-117.31084, 33.12189], [-117.31038, 33.12197], [-117.30993, 33.12208], [-117.30813, 33.12265], [-117.30811, 33.12068], [-117.31392, 33.12069]]]} | No Public Access 3 | 44875 | Encinas Creek Preserve | 18642 | 3014 | Center for Natural Lands Management 91 | Non Profit 6 | Non Profit - Land Trust 10 | http://cnlm.org/ | Non Governmental Organization 10 | 3014 | Center for Natural Lands Management 89 | Non Profit 6 | Non Profit - Land Trust 10 | San Diego 4 | 18.717 | Encinas Creek Preserve | 0 | Private Conservation 16 | 2 | |
4918 | 4918 | 4917 | {"type": "Polygon", "coordinates": [[[-116.70363, 32.61525], [-116.70362, 32.61622], [-116.69898, 32.61612], [-116.69901, 32.6143], [-116.70262, 32.61442], [-116.70298, 32.61427], [-116.70332, 32.61396], [-116.70321, 32.61425], [-116.70363, 32.61525]]]} | No Public Access 3 | 5150 | MSCP Open Space Preserve Land | 22571 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | San Diego 4 | 21.27 | MSCP OSP Land | 0 | Local Conservation Area 4 | 2 | |
4919 | 4919 | 4918 | {"type": "Polygon", "coordinates": [[[-116.95348, 32.97049], [-116.94486, 32.97075], [-116.94038, 32.97069], [-116.94043, 32.98879], [-116.93164, 32.98892], [-116.93165, 32.99244], [-116.92769, 32.9925], [-116.92746, 32.99195], [-116.92717, 32.99145], [-116.92712, 32.99134], [-116.9271, 32.99123], [-116.92703, 32.98965], [-116.92701, 32.98949], [-116.92694, 32.98925], [-116.92663, 32.98861], [-116.9274, 32.98859], [-116.92743, 32.98054], [-116.92835, 32.98052], [-116.9317, 32.98057], [-116.93267, 32.9801], [-116.93358, 32.97947], [-116.9336, 32.97826], [-116.93376, 32.97758], [-116.93361, 32.97697], [-116.93362, 32.97623], [-116.93287, 32.97482], [-116.93164, 32.9748], [-116.93162, 32.97644], [-116.93154, 32.97731], [-116.93048, 32.9773], [-116.93047, 32.97779], [-116.92975, 32.97775], [-116.92906, 32.9778], [-116.92869, 32.9778], [-116.92802, 32.97777], [-116.92744, 32.97782], [-116.9275, 32.97291], [-116.92755, 32.96326], [-116.92218, 32.96267], [-116.92286, 32.95497], [-116.91692, 32.95427], [-116.91686, 32.95103], [-116.91843, 32.95115], [-116.91844, 32.95114], [-116.91845, 32.9482], [-116.9174, 32.93946], [-116.92765, 32.94122], [-116.93182, 32.94121], [-116.93186, 32.95198], [-116.92763, 32.95203], [-116.92761, 32.95595], [-116.93185, 32.95601], [-116.93186, 32.95964], [-116.94042, 32.95977], [-116.94045, 32.9561], [-116.94879, 32.95602], [-116.94888, 32.95974], [-116.95342, 32.95961], [-116.95348, 32.97049]]]} | No Public Access 3 | 47591 | Boulder Oaks Open Space Preserve | 31318 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/BoulderOaks.html | San Diego 4 | 2020.361 | Boulder Oaks OSP | 0 | Local Conservation Area 4 | 2 |
5384 | 5384 | 5383 | {"type": "MultiPolygon", "coordinates": [[[[-116.68414, 32.63592], [-116.68408, 32.63754], [-116.68186, 32.63754], [-116.68193, 32.63587], [-116.68414, 32.63592]]], [[[-116.73738, 32.62107], [-116.72053, 32.62112], [-116.72052, 32.62207], [-116.72052, 32.62295], [-116.7117, 32.62354], [-116.71149, 32.62647], [-116.70719, 32.6268], [-116.70737, 32.63295], [-116.69486, 32.63301], [-116.6948, 32.63927], [-116.69518, 32.64285], [-116.69112, 32.64286], [-116.69177, 32.64642], [-116.68717, 32.64646], [-116.68654, 32.64172], [-116.68619, 32.63925], [-116.68626, 32.63596], [-116.68515, 32.63593], [-116.6852, 32.63414], [-116.68522, 32.63386], [-116.68629, 32.63392], [-116.68627, 32.63595], [-116.69052, 32.63602], [-116.6907, 32.62656], [-116.69491, 32.62661], [-116.69487, 32.61949], [-116.69897, 32.61962], [-116.69898, 32.61612], [-116.70769, 32.61631], [-116.71809, 32.61565], [-116.71841, 32.61579], [-116.71976, 32.61606], [-116.72042, 32.61573], [-116.72048, 32.61573], [-116.7205, 32.61766], [-116.72724, 32.61758], [-116.72721, 32.61799], [-116.72733, 32.61851], [-116.72734, 32.61863], [-116.7274, 32.6188], [-116.72749, 32.61894], [-116.7276, 32.61905], [-116.72772, 32.61914], [-116.72798, 32.61926], [-116.72822, 32.61931], [-116.72844, 32.61931], [-116.72863, 32.61927], [-116.72879, 32.61922], [-116.72899, 32.6191], [-116.72916, 32.61894], [-116.72964, 32.61831], [-116.73109, 32.61792], [-116.73167, 32.61772], [-116.73243, 32.61755], [-116.73313, 32.61755], [-116.73314, 32.61739], [-116.73495, 32.61697], [-116.73551, 32.61686], [-116.73599, 32.6168], [-116.73648, 32.61676], [-116.737, 32.61675], [-116.73737, 32.61677], [-116.73738, 32.62107]]], [[[-116.73102, 32.61755], [-116.72988, 32.61781], [-116.72962, 32.6179], [-116.72943, 32.61801], [-116.72935, 32.61808], [-116.72835, 32.61869], [-116.72789, 32.61859], [-116.72763, 32.61823], [-116.72768, 32.61763], [-116.72773, 32.61758], [-116.73102, 32.61755]]], [[[-116.73736, 32.61645], [-116.73617, 32.61654], [-116.73521, 32.61659], [-116.73314, 32.61707], [-116.73303, 32.61407], [-116.73736, 32.61399], [-116.73736, 32.61645]]]]} | No Public Access 3 | 7400 | MSCP Open Space Preserve Land | 22572 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 1276.75 | MSCP OSP Land | 0 | Local Conservation Area 4 | 2 |
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]);