units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
128 rows where ACCESS_TYP = 3 and COUNTY = 4 sorted by YR_EST
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, MNG_AG_LEV, YR_EST, GAP_STS
MNG_AGENCY >30
- The Environmental Trust 21
- San Diego, City of 19
- Endangered Habitats Conservancy 14
- San Diego, County of 14
- Escondido, City of 10
- Center for Natural Lands Management 8
- San Marcos, City of 4
- California Department of Fish and Wildlife 3
- California Department of Transportation 3
- Fallbrook Land Conservancy 3
- San Dieguito River Valley Land Conservancy 3
- The Nature Conservancy 2
- Poway, City of 2
- Escondido Creek Conservancy 2
- Valley Center Water District 2
- Olivenhain Municipal Water District 2
- San Diego County Water Authority 2
- Santee, City of 1
- United States Fish and Wildlife Service 1
- California Department of Parks and Recreation 1
- Oceanside, City of 1
- Chula Vista, City of 1
- California Department of Forestry and Fire Protection 1
- United States Department of Defense 1
- Yuima Municipal Water District 1
- Anza-Borrego Foundation 1
- Foss Lake Conservation LP 1
- Vallecitos Water District 1
- San Dieguito River Park Joint Powers Authority 1
- Rainbow Municipal Water District 1
- …
DES_TP 20
- Private Conservation 51
- Local Other or Unknown 23
- Local Recreation Area 15
- Local Conservation Area 10
- Local Park 9
- State Resource Management Area 3
- Private Recreation or Education 3
- State Other or Unknown 2
- Local Resource Management Area 1
- National Wildlife Refuge 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
MNG_AG_TYP 9
ACCESS_TYP 1
- No Public Access · 128 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4183 | 4183 | 4182 | {"type": "MultiPolygon", "coordinates": [[[[-117.06172, 32.93278], [-117.06122, 32.93336], [-117.06087, 32.93316], [-117.06071, 32.9331], [-117.06052, 32.93306], [-117.06016, 32.93303], [-117.05996, 32.93305], [-117.05974, 32.9331], [-117.05968, 32.93308], [-117.05965, 32.93305], [-117.05923, 32.93194], [-117.05911, 32.93166], [-117.05887, 32.93122], [-117.05859, 32.93084], [-117.05859, 32.93079], [-117.05882, 32.93064], [-117.05916, 32.93101], [-117.0608, 32.93016], [-117.06098, 32.93018], [-117.0599, 32.93081], [-117.05979, 32.93128], [-117.06026, 32.93172], [-117.0606, 32.93182], [-117.06093, 32.93184], [-117.06127, 32.93176], [-117.0615, 32.93172], [-117.06153, 32.93243], [-117.06172, 32.93278]]], [[[-117.06669, 32.93294], [-117.06648, 32.93266], [-117.06644, 32.93238], [-117.06648, 32.93208], [-117.06625, 32.932], [-117.06608, 32.9318], [-117.06621, 32.93138], [-117.06616, 32.93133], [-117.06597, 32.93138], [-117.06552, 32.93156], [-117.06489, 32.93141], [-117.06501, 32.93102], [-117.06506, 32.93069], [-117.06543, 32.93045], [-117.06548, 32.93009], [-117.0652, 32.92941], [-117.06497, 32.92918], [-117.06473, 32.929], [-117.06367, 32.92871], [-117.06354, 32.92923], [-117.0635, 32.92922], [-117.06361, 32.9287], [-117.06028, 32.92779], [-117.06534, 32.92774], [-117.06556, 32.928], [-117.06579, 32.92819], [-117.06596, 32.92829], [-117.06668, 32.92866], [-117.06669, 32.93294]]], [[[-117.06581, 32.93938], [-117.06576, 32.93969], [-117.06569, 32.93966], [-117.06569, 32.93963], [-117.06539, 32.93946], [-117.06532, 32.93947], [-117.06505, 32.93936], [-117.06446, 32.93929], [-117.06429, 32.9389], [-117.06405, 32.93887], [-117.0639, 32.93843], [-117.063, 32.93833], [-117.06287, 32.93795], [-117.06274, 32.93769], [-117.06286, 32.93761], [-117.06308, 32.93783], [-117.06349, 32.93754], [-117.06399, 32.93805], [-117.06412, 32.93807], [-117.06478, 32.93895], [-117.06507, 32.93898], [-117.06505, 32.93915], [-117.06581, 32.93938]]], [[[-117.06668, 32.92848], [-117.06592, 32.92807], [-117.06573, 32.92792], [-117.06557, 32.92774], [-117.06668, 32.92773], [-117.06668, 32.92848]]]]} | No Public Access 3 | 44864 | South Poway Cornerstone | 25675 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 37.928 | South Poway Cornerstone | None 364 | |||
6462 | 6462 | 6461 | {"type": "Polygon", "coordinates": [[[-116.18721, 33.15378], [-116.18628, 33.1536], [-116.18497, 33.1533], [-116.18496, 33.15281], [-116.18721, 33.15378]]]} | No Public Access 3 | 2055 | Hwy 78 scenic corridor | 20163 | 3004 | Anza-Borrego Foundation 836 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.theabf.org/ | Non Governmental Organization 10 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | San Diego 4 | 1.475 | Hwy 78 scenic corridor | None 522 | |||
7600 | 7600 | 7599 | {"type": "MultiPolygon", "coordinates": [[[[-117.14622, 33.06563], [-117.14613, 33.06566], [-117.14588, 33.06585], [-117.14528, 33.06607], [-117.14395, 33.06651], [-117.14403, 33.07291], [-117.1354, 33.07289], [-117.13529, 33.06938], [-117.13397, 33.06938], [-117.13526, 33.06843], [-117.13522, 33.06723], [-117.13565, 33.06722], [-117.13627, 33.06627], [-117.13698, 33.06604], [-117.13697, 33.0657], [-117.13751, 33.0657], [-117.13751, 33.06452], [-117.13871, 33.06451], [-117.13873, 33.06569], [-117.13792, 33.06571], [-117.13792, 33.06788], [-117.1387, 33.06788], [-117.13956, 33.06701], [-117.14139, 33.06701], [-117.14343, 33.06567], [-117.14394, 33.06566], [-117.14474, 33.0654], [-117.14511, 33.06555], [-117.14583, 33.06531], [-117.14593, 33.06542], [-117.14622, 33.06563]], [[-117.1405, 33.06924], [-117.13933, 33.06837], [-117.1387, 33.06896], [-117.14006, 33.06987], [-117.14072, 33.06942], [-117.1405, 33.06924]]], [[[-117.15278, 33.06829], [-117.15233, 33.06861], [-117.15156, 33.06775], [-117.15135, 33.06683], [-117.1491, 33.06683], [-117.1486, 33.06657], [-117.1484, 33.06641], [-117.14826, 33.06634], [-117.14797, 33.06626], [-117.14766, 33.06624], [-117.14749, 33.06621], [-117.14727, 33.06613], [-117.1463, 33.06547], [-117.14695, 33.06537], [-117.14755, 33.06577], [-117.14788, 33.0658], [-117.14829, 33.06591], [-117.14858, 33.06605], [-117.14921, 33.06644], [-117.15176, 33.06643], [-117.15202, 33.06758], [-117.15242, 33.06802], [-117.15277, 33.06777], [-117.15278, 33.06829]]], [[[-117.15278, 33.06896], [-117.15241, 33.0692], [-117.15221, 33.06918], [-117.15201, 33.06897], [-117.1524, 33.06871], [-117.15278, 33.06843], [-117.15278, 33.06896]]]]} | No Public Access 3 | 7312 | Olivenhain Dam | 23133 | 2102 | Olivenhain Municipal Water District 871 | Special District 4 | Water District 13 | http://www.olivenhain.com/ | Special District 4 | 2102 | Olivenhain Municipal Water District 849 | Special District 4 | Water District 13 | San Diego 4 | 153.269 | Olivenhain Dam | None 632 | |||
7773 | 7773 | 7772 | {"type": "Polygon", "coordinates": [[[-117.13155, 32.60871], [-117.13082, 32.60779], [-117.1306, 32.6076], [-117.1302, 32.60762], [-117.12999, 32.60766], [-117.12894, 32.60764], [-117.12851, 32.60758], [-117.1281, 32.60746], [-117.12761, 32.60717], [-117.12702, 32.60667], [-117.12658, 32.60618], [-117.1259, 32.60554], [-117.12564, 32.60545], [-117.12498, 32.60536], [-117.12444, 32.60519], [-117.12507, 32.60517], [-117.12808, 32.60599], [-117.1287, 32.60621], [-117.12921, 32.60642], [-117.1296, 32.60663], [-117.12996, 32.60686], [-117.13025, 32.60707], [-117.1305, 32.60731], [-117.13071, 32.60753], [-117.13153, 32.60854], [-117.13155, 32.60871]]]} | No Public Access 3 | 47652 | South Bay Marine Biological Study Area | 31395 | 110 | United States Navy 876 | Federal 1 | Federal Agency 1 | http://www.navy.mil/ | Other Federal 13 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 12.569 | South Bay Marine Biological Study Area | None 645 | |||
7799 | 7799 | 7798 | {"type": "Polygon", "coordinates": [[[-117.31508, 33.26166], [-117.31432, 33.26259], [-117.31428, 33.26186], [-117.31404, 33.26172], [-117.31338, 33.26127], [-117.31266, 33.2613], [-117.31162, 33.26213], [-117.3132, 33.26337], [-117.31094, 33.26441], [-117.30968, 33.26347], [-117.30968, 33.26342], [-117.30855, 33.26259], [-117.30882, 33.2621], [-117.31085, 33.25891], [-117.31091, 33.25884], [-117.31117, 33.25856], [-117.31145, 33.25829], [-117.31228, 33.25764], [-117.31243, 33.25778], [-117.31258, 33.25767], [-117.31258, 33.25766], [-117.31243, 33.25752], [-117.3135, 33.25671], [-117.31355, 33.2567], [-117.31361, 33.25671], [-117.31372, 33.25681], [-117.31374, 33.25685], [-117.31373, 33.25691], [-117.31385, 33.25702], [-117.31403, 33.25689], [-117.3142, 33.25705], [-117.31396, 33.25708], [-117.31349, 33.26035], [-117.31401, 33.2604], [-117.31487, 33.26041], [-117.31508, 33.26166]]]} | No Public Access 3 | 47673 | Foss Lake Preserve | 31414 | 7016 | Foss Lake Conservation LP 877 | Private 7 | Mitigation Bank 29 | Private 14 | 7016 | Foss Lake Conservation LP 854 | Private 7 | Mitigation Bank 28 | San Diego 4 | 58.822 | Foss Lake Preserve | None 648 | ||||
7841 | 7841 | 7840 | {"type": "Polygon", "coordinates": [[[-116.95835, 32.58995], [-116.95155, 32.59194], [-116.94918, 32.59009], [-116.947, 32.58786], [-116.94582, 32.58582], [-116.94542, 32.58527], [-116.94808, 32.58424], [-116.94748, 32.58333], [-116.94716, 32.58293], [-116.94705, 32.58296], [-116.94672, 32.58291], [-116.94635, 32.58283], [-116.94603, 32.58271], [-116.94582, 32.58248], [-116.9458, 32.58217], [-116.94581, 32.58211], [-116.94962, 32.58217], [-116.95013, 32.5831], [-116.95155, 32.5844], [-116.95157, 32.58584], [-116.9523, 32.58586], [-116.95595, 32.58857], [-116.95639, 32.58888], [-116.95835, 32.58995]]]} | No Public Access 3 | 47716 | Otay Valley Regional Park | 31498 | 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 | http://www.sdparks.org/content/sdparks/en/park-pages/OVRP.html | San Diego 4 | 146.674 | Otay Valley RP | None 656 | ||
10469 | 10469 | 10468 | {"type": "Polygon", "coordinates": [[[-116.87571, 33.09862], [-116.87572, 33.10309], [-116.87571, 33.10591], [-116.8671, 33.10593], [-116.86705, 33.10975], [-116.85853, 33.10983], [-116.85852, 33.11698], [-116.86277, 33.11704], [-116.8628, 33.12446], [-116.86277, 33.1319], [-116.85839, 33.13185], [-116.85815, 33.14289], [-116.86264, 33.14294], [-116.86258, 33.1466], [-116.86255, 33.15026], [-116.86691, 33.1503], [-116.86681, 33.15392], [-116.86668, 33.15799], [-116.86657, 33.15802], [-116.86628, 33.15822], [-116.86612, 33.15829], [-116.86599, 33.15832], [-116.86579, 33.15836], [-116.86503, 33.15835], [-116.8649, 33.15837], [-116.86443, 33.1585], [-116.86413, 33.15866], [-116.86403, 33.15869], [-116.86345, 33.15885], [-116.86319, 33.15888], [-116.86299, 33.15884], [-116.86254, 33.15865], [-116.86222, 33.15858], [-116.86208, 33.15854], [-116.86182, 33.15842], [-116.86134, 33.15814], [-116.86129, 33.15805], [-116.86144, 33.15801], [-116.86151, 33.15797], [-116.86154, 33.15792], [-116.86159, 33.15779], [-116.86159, 33.15771], [-116.86152, 33.15758], [-116.86143, 33.15753], [-116.86135, 33.15753], [-116.86127, 33.15756], [-116.86121, 33.15762], [-116.86115, 33.15765], [-116.86094, 33.15763], [-116.86056, 33.15763], [-116.86043, 33.15767], [-116.86026, 33.15784], [-116.85986, 33.15809], [-116.85981, 33.15809], [-116.85976, 33.15807], [-116.85971, 33.15797], [-116.85957, 33.15785], [-116.8594, 33.15779], [-116.8593, 33.1578], [-116.85921, 33.15785], [-116.85909, 33.15795], [-116.85902, 33.15804], [-116.85893, 33.15825], [-116.85887, 33.15831], [-116.85876, 33.15835], [-116.85852, 33.15835], [-116.8584, 33.15833], [-116.8582, 33.15827], [-116.85799, 33.15818], [-116.85783, 33.15808], [-116.85743, 33.15792], [-116.85724, 33.15786], [-116.85706, 33.15784], [-116.85677, 33.15776], [-116.85645, 33.15775], [-116.85637, 33.15774], [-116.85601, 33.15752], [-116.85545, 33.15732], [-116.85535, 33.15726], [-116.85533, 33.15727], [-116.85534, 33.15738], [-116.85597, 33.15763], [-116.85629, 33.15783], [-116.85644, 33.15786], [-116.85675, 33.15786], [-116.85707, 33.15795], [-116.85721, 33.15797], [-116.85737, 33.15802], [-116.85773, 33.15816], [-116.85793, 33.15828], [-116.8582, 33.15839], [-116.85837, 33.15844], [-116.85864, 33.15847], [-116.85879, 33.15846], [-116.85891, 33.15842], [-116.85897, 33.15838], [-116.85906, 33.15827], [-116.85914, 33.15809], [-116.85918, 33.15803], [-116.85931, 33.15792], [-116.85936, 33.1579], [-116.85944, 33.15792], [-116.85952, 33.15796], [-116.85972, 33.15818], [-116.85985, 33.15821], [-116.85991, 33.15819], [-116.86035, 33.15791], [-116.86043, 33.15785], [-116.86046, 33.15779], [-116.86054, 33.15775], [-116.86093, 33.15774], [-116.86117, 33.15776], [-116.86126, 33.15773], [-116.86136, 33.15764], [-116.8614, 33.15763], [-116.86146, 33.15772], [-116.86146, 33.15778], [-116.86141, 33.15789], [-116.86124, 33.15794], [-116.86118, 33.15798], [-116.86116, 33.15802], [-116.86116, 33.15809], [-116.86118, 33.15814], [-116.86128, 33.15824], [-116.86157, 33.15842], [-116.86194, 33.1586], [-116.8622, 33.15869], [-116.86252, 33.15875], [-116.86285, 33.15891], [-116.86299, 33.15896], [-116.86315, 33.15899], [-116.86331, 33.15899], [-116.86347, 33.15896], [-116.86408, 33.15879], [-116.8642, 33.15875], [-116.86427, 33.1587], [-116.86455, 33.15857], [-116.86497, 33.15847], [-116.86583, 33.15847], [-116.86603, 33.15843], [-116.86625, 33.15836], [-116.86639, 33.15829], [-116.86664, 33.15812], [-116.86667, 33.15811], [-116.86657, 33.16118], [-116.86232, 33.16116], [-116.86231, 33.16117], [-116.86228, 33.16497], [-116.86646, 33.16496], [-116.86638, 33.16837], [-116.86233, 33.16831], [-116.86242, 33.17187], [-116.85753, 33.17179], [-116.85772, 33.17887], [-116.84925, 33.17895], [-116.84933, 33.18263], [-116.84494, 33.18265], [-116.8448, 33.17533], [-116.84919, 33.1753], [-116.84907, 33.16825], [-116.8492, 33.15756], [-116.84482, 33.15753], [-116.84479, 33.16118], [-116.84029, 33.16122], [-116.84046, 33.15394], [-116.84072, 33.14636], [-116.84494, 33.14641], [-116.84499, 33.14277], [-116.84084, 33.14274], [-116.84093, 33.13967], [-116.84097, 33.13904], [-116.84505, 33.13906], [-116.84522, 33.12799], [-116.84957, 33.12798], [-116.84958, 33.12432], [-116.84954, 33.12064], [-116.8411, 33.12049], [-116.84115, 33.11338], [-116.84547, 33.11339], [-116.84555, 33.1097], [-116.83252, 33.10957], [-116.83263, 33.10587], [-116.84113, 33.10593], [-116.84972, 33.10597], [-116.84972, 33.10233], [-116.85412, 33.10235], [-116.85408, 33.09859], [-116.8581, 33.09877], [-116.85796, 33.09924], [-116.85792, 33.09958], [-116.85793, 33.09982], [-116.85803, 33.10046], [-116.85803, 33.10071], [-116.85791, 33.10179], [-116.85785, 33.10203], [-116.85777, 33.10223], [-116.85708, 33.10362], [-116.85695, 33.10385], [-116.85544, 33.10595], [-116.85544, 33.10598], [-116.85546, 33.10599], [-116.85499, 33.10665], [-116.85467, 33.10709], [-116.85458, 33.10718], [-116.85436, 33.10744], [-116.85407, 33.10784], [-116.85369, 33.10845], [-116.85355, 33.10877], [-116.85351, 33.10891], [-116.85345, 33.10914], [-116.85343, 33.10939], [-116.85334, 33.10982], [-116.85335, 33.11019], [-116.8534, 33.11045], [-116.8534, 33.11055], [-116.85337, 33.11071], [-116.85335, 33.11077], [-116.8533, 33.11123], [-116.8533, 33.11151], [-116.85335, 33.11188], [-116.85343, 33.11217], [-116.85349, 33.11268], [-116.85353, 33.11291], [-116.85356, 33.11327], [-116.85361, 33.11338], [-116.85363, 33.11349], [-116.85365, 33.11402], [-116.8536, 33.11427], [-116.85316, 33.11543], [-116.85304, 33.11564], [-116.85296, 33.11576], [-116.85261, 33.11614], [-116.85234, 33.11642], [-116.85164, 33.11699], [-116.85152, 33.11711], [-116.85135, 33.11735], [-116.85117, 33.11772], [-116.85109, 33.11781], [-116.85068, 33.11809], [-116.85002, 33.11849], [-116.84972, 33.11864], [-116.84964, 33.11871], [-116.84936, 33.11939], [-116.84934, 33.11948], [-116.84935, 33.11965], [-116.84938, 33.11973], [-116.84965, 33.12074], [-116.84971, 33.12116], [-116.84964, 33.12367], [-116.84969, 33.12397], [-116.84975, 33.12419], [-116.84985, 33.12443], [-116.84994, 33.12461], [-116.85018, 33.12493], [-116.85234, 33.12741], [-116.85246, 33.1276], [-116.85262, 33.12802], [-116.85267, 33.12828], [-116.85267, 33.1285], [-116.85259, 33.1293], [-116.85232, 33.13287], [-116.85232, 33.13307], [-116.85226, 33.13388], [-116.8522, 33.1346], [-116.85215, 33.13492], [-116.85208, 33.13624], [-116.85203, 33.13646], [-116.85196, 33.13666], [-116.85171, 33.13711], [-116.85133, 33.13793], [-116.85117, 33.13823], [-116.85107, 33.13838], [-116.85008, 33.14039], [-116.85012, 33.14045], [-116.85002, 33.1405], [-116.84918, 33.14218], [-116.84901, 33.14246], [-116.84888, 33.14264], [-116.84875, 33.14277], [-116.8475, 33.14397], [-116.84737, 33.14414], [-116.84727, 33.14433], [-116.84723, 33.14447], [-116.8472, 33.14469], [-116.84721, 33.14478], [-116.84719, 33.1477], [-116.84713, 33.15025], [-116.84716, 33.15037], [-116.84722, 33.15045], [-116.84743, 33.15071], [-116.84756, 33.15094], [-116.84762, 33.15111], [-116.84762, 33.15115], [-116.84819, 33.15299], [-116.8494, 33.15573], [-116.85055, 33.15751], [-116.85071, 33.15772], [-116.85099, 33.15815], [-116.85137, 33.1587], [-116.85174, 33.15934], [-116.8518, 33.15949], [-116.85184, 33.15968], [-116.85196, 33.16109], [-116.85199, 33.16118], [-116.852, 33.16136], [-116.85213, 33.16137], [-116.85212, 33.16116], [-116.85208, 33.16096], [-116.85197, 33.15967], [-116.85193, 33.15948], [-116.85188, 33.15934], [-116.85148, 33.15863], [-116.85107, 33.15805], [-116.85071, 33.1575], [-116.85056, 33.15731], [-116.8496, 33.15583], [-116.8495, 33.15565], [-116.84866, 33.15374], [-116.84852, 33.15345], [-116.84829, 33.15289], [-116.84775, 33.1511], [-116.84769, 33.15093], [-116.84755, 33.15066], [-116.84742, 33.15049], [-116.8473, 33.15036], [-116.84726, 33.15026], [-116.84733, 33.1477], [-116.84732, 33.1459], [-116.84734, 33.14459], [-116.84739, 33.14438], [-116.84747, 33.14422], [-116.84764, 33.144], [-116.84885, 33.14285], [-116.84902, 33.14267], [-116.84916, 33.14247], [-116.85017, 33.14048], [-116.85118, 33.13843], [-116.85135, 33.13817], [-116.85148, 33.13792], [-116.85187, 33.13708], [-116.85208, 33.1367], [-116.85217, 33.13644], [-116.85221, 33.13628], [-116.85228, 33.13496], [-116.85238, 33.13404], [-116.85244, 33.13329], [-116.85245, 33.13292], [-116.85262, 33.13072], [-116.85262, 33.13058], [-116.8528, 33.12852], [-116.8528, 33.12825], [-116.85276, 33.12803], [-116.85261, 33.12762], [-116.85247, 33.12738], [-116.85029, 33.12487], [-116.8501, 33.12462], [-116.84999, 33.12443], [-116.8499, 33.12423], [-116.84983, 33.12399], [-116.84977, 33.12363], [-116.84984, 33.12114], [-116.84981, 33.12087], [-116.84977, 33.12067], [-116.84951, 33.1197], [-116.84948, 33.11963], [-116.84947, 33.11951], [-116.84948, 33.11944], [-116.84977, 33.11876], [-116.84982, 33.11872], [-116.85003, 33.11862], [-116.85068, 33.11823], [-116.85078, 33.11816], [-116.8508, 33.11816], [-116.85116, 33.11791], [-116.85129, 33.11774], [-116.85147, 33.11739], [-116.85164, 33.11716], [-116.85233, 33.11658], [-116.85268, 33.11625], [-116.85307, 33.11581], [-116.85319, 33.11564], [-116.8533, 33.11543], [-116.85373, 33.11428], [-116.85378, 33.11404], [-116.85376, 33.11346], [-116.85372, 33.11332], [-116.85369, 33.11325], [-116.85367, 33.11295], [-116.85362, 33.11268], [-116.85357, 33.11217], [-116.8535, 33.11197], [-116.85343, 33.11149], [-116.85343, 33.11125], [-116.85353, 33.11058], [-116.85352, 33.11042], [-116.85348, 33.11015], [-116.85347, 33.10983], [-116.85356, 33.1094], [-116.85358, 33.10916], [-116.85365, 33.10889], [-116.85381, 33.1085], [-116.85408, 33.10805], [-116.85428, 33.10775], [-116.8546, 33.10734], [-116.85477, 33.10715], [-116.85519, 33.10659], [-116.85557, 33.10604], [-116.8556, 33.10605], [-116.85562, 33.10603], [-116.85715, 33.1039], [-116.85725, 33.10371], [-116.8579, 33.10241], [-116.85806, 33.10199], [-116.85813, 33.10169], [-116.85823, 33.10075], [-116.85823, 33.10043], [-116.85812, 33.09977], [-116.85812, 33.09946], [-116.85814, 33.09932], [-116.8583, 33.09878], [-116.85832, 33.09878], [-116.85837, 33.10147], [-116.85854, 33.10229], [-116.86711, 33.10226], [-116.8671, 33.09865], [-116.87571, 33.09862]], [[-116.8492, 33.15754], [-116.84921, 33.15755], [-116.85017, 33.15755], [-116.85018, 33.15754], [-116.84922, 33.15667], [-116.8492, 33.15754]]]} | No Public Access 3 | 18526 | Pamo Valley | 23380 | 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 | 3682.059 | Pamo Valley | None 914 | |||
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 | |
208 | 208 | 207 | {"type": "Polygon", "coordinates": [[[-117.09538, 33.13695], [-117.09362, 33.13752], [-117.09362, 33.1357], [-117.09365, 33.13567], [-117.09379, 33.1356], [-117.0939, 33.13563], [-117.09401, 33.1356], [-117.09406, 33.13557], [-117.09407, 33.13551], [-117.09406, 33.1355], [-117.09382, 33.13558], [-117.09362, 33.13548], [-117.09357, 33.13283], [-117.09348, 33.13177], [-117.09397, 33.13182], [-117.09425, 33.13159], [-117.09432, 33.13154], [-117.09436, 33.13154], [-117.09442, 33.13154], [-117.09451, 33.13179], [-117.09458, 33.13207], [-117.09474, 33.13462], [-117.09453, 33.13534], [-117.09455, 33.13535], [-117.0948, 33.13527], [-117.09484, 33.13577], [-117.09489, 33.13594], [-117.09494, 33.13615], [-117.09502, 33.13635], [-117.09522, 33.13672], [-117.0953, 33.13686], [-117.09538, 33.13695]]]} | No Public Access 3 | 654 | Reidy Canyon Creek | 24281 | 1102 | Escondido, City of 86 | City 2 | City Agency 2 | http://www.escondido.org/parks-open-space.aspx | City 2 | 1102 | Escondido, City of 84 | City 2 | City Agency 2 | San Diego 4 | 16.798 | Reidy Canyon Creek | 0 | Local Other or Unknown 14 | 4 | |
235 | 235 | 234 | {"type": "MultiPolygon", "coordinates": [[[[-117.09432, 33.11987], [-117.09377, 33.1199], [-117.09333, 33.11988], [-117.09298, 33.11971], [-117.09292, 33.11957], [-117.0934, 33.11955], [-117.09432, 33.11987]]], [[[-117.09563, 33.1199], [-117.09552, 33.12002], [-117.09533, 33.1203], [-117.09524, 33.12049], [-117.09521, 33.1206], [-117.09497, 33.12181], [-117.09491, 33.12286], [-117.09486, 33.12319], [-117.09477, 33.12344], [-117.0946, 33.1235], [-117.09447, 33.1232], [-117.09458, 33.12282], [-117.0946, 33.12228], [-117.09473, 33.12119], [-117.09482, 33.12061], [-117.09498, 33.12015], [-117.09521, 33.11975], [-117.09563, 33.1199]]]]} | No Public Access 3 | 684 | Reidy Canyon Creek | 24281 | 1102 | Escondido, City of 86 | City 2 | City Agency 2 | http://www.escondido.org/parks-open-space.aspx | City 2 | 1102 | Escondido, City of 84 | City 2 | City Agency 2 | San Diego 4 | 4.055 | Reidy Canyon Creek | 0 | Local Other or Unknown 14 | 4 | |
236 | 236 | 235 | {"type": "Polygon", "coordinates": [[[-117.09461, 33.12373], [-117.09348, 33.12592], [-117.09308, 33.12668], [-117.09291, 33.12629], [-117.09353, 33.12505], [-117.09345, 33.12492], [-117.09371, 33.12472], [-117.09415, 33.12388], [-117.09461, 33.12373]]]} | No Public Access 3 | 687 | Reidy Canyon Creek | 24281 | 1102 | Escondido, City of 86 | City 2 | City Agency 2 | http://www.escondido.org/parks-open-space.aspx | City 2 | 1102 | Escondido, City of 84 | City 2 | City Agency 2 | San Diego 4 | 2.732 | Reidy Canyon Creek | 0 | Local Other or Unknown 14 | 4 | |
251 | 251 | 250 | {"type": "Polygon", "coordinates": [[[-117.0929, 33.12785], [-117.09258, 33.12797], [-117.09245, 33.12767], [-117.09253, 33.12696], [-117.09276, 33.12662], [-117.09289, 33.12693], [-117.09286, 33.12698], [-117.09278, 33.12727], [-117.09278, 33.12756], [-117.0929, 33.12785]]]} | No Public Access 3 | 683 | Reidy Canyon Creek | 24281 | 1102 | Escondido, City of 86 | City 2 | City Agency 2 | http://www.escondido.org/parks-open-space.aspx | City 2 | 1102 | Escondido, City of 84 | City 2 | City Agency 2 | San Diego 4 | 0.966 | Reidy Canyon Creek | 0 | Local Other or Unknown 14 | 4 | |
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 | |
1316 | 1316 | 1315 | {"type": "Polygon", "coordinates": [[[-116.74116, 32.57636], [-116.74114, 32.58363], [-116.73714, 32.58342], [-116.73291, 32.5834], [-116.73278, 32.58732], [-116.72047, 32.58718], [-116.72045, 32.58913], [-116.70751, 32.5894], [-116.69094, 32.5893], [-116.69082, 32.58084], [-116.69077, 32.57124], [-116.73696, 32.56738], [-116.73704, 32.56906], [-116.74116, 32.5691], [-116.74116, 32.5727], [-116.73707, 32.57263], [-116.73709, 32.57623], [-116.74116, 32.57636]]]} | No Public Access 3 | 7399 | Kuchamaa Experimental Forest | 20729 | 202 | California Department of Forestry and Fire Protection 346 | State 5 | State Agency 5 | http://www.fire.ca.gov/ | Other State 5 | 202 | California Department of Forestry and Fire Protection 343 | State 5 | State Agency 5 | San Diego 4 | 2363.684 | Kuchamaa Experimental Forest | 0 | None 113 | ||
1339 | 1339 | 1338 | {"type": "Polygon", "coordinates": [[[-116.73714, 32.58342], [-116.74114, 32.58362], [-116.74116, 32.57636], [-116.73709, 32.57624], [-116.73707, 32.57262], [-116.74115, 32.5727], [-116.74116, 32.5691], [-116.73703, 32.56906], [-116.73696, 32.56738], [-116.75384, 32.56596], [-116.75385, 32.56579], [-116.80114, 32.56182], [-116.80119, 32.56352], [-116.79687, 32.56361], [-116.79696, 32.56738], [-116.78817, 32.56748], [-116.78397, 32.56787], [-116.78402, 32.57978], [-116.77099, 32.58015], [-116.76217, 32.58046], [-116.76212, 32.58426], [-116.75374, 32.58427], [-116.75371, 32.58796], [-116.75367, 32.59538], [-116.74509, 32.59534], [-116.74513, 32.59151], [-116.72846, 32.59121], [-116.72857, 32.58727], [-116.73278, 32.58732], [-116.7329, 32.5834], [-116.73714, 32.58342]]]} | No Public Access 3 | 7398 | Marron Valley Mitigation Bank | 21885 | 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 | 2644.0 | Marron Valley Mitigation Bank | 0 | Local Other or Unknown 14 | 4 | |
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 | ||
3140 | 3140 | 3139 | {"type": "MultiPolygon", "coordinates": [[[[-116.60256, 33.11613], [-116.59824, 33.115], [-116.59824, 33.11394], [-116.60131, 33.11356], [-116.60184, 33.11283], [-116.60185, 33.1129], [-116.6019, 33.11298], [-116.60231, 33.11337], [-116.6024, 33.11349], [-116.60246, 33.1136], [-116.60259, 33.11401], [-116.60286, 33.1151], [-116.60287, 33.11531], [-116.60283, 33.11554], [-116.60272, 33.11583], [-116.60256, 33.11613]]], [[[-116.60241, 33.11223], [-116.60228, 33.11229], [-116.6022, 33.11232], [-116.60227, 33.11223], [-116.60241, 33.11223]]]]} | No Public Access 3 | 25800 | San Dieguito River Park | 24870 | 3066 | San Dieguito River Valley Land Conservancy 378 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sdrvc.org/ | Non Governmental Organization 10 | 3066 | San Dieguito River Valley Land Conservancy 373 | Non Profit 6 | Non Profit - Land Trust 10 | San Diego 4 | 22.717 | San Dieguito River Park | 0 | Private Recreation or Education 65 | 4 | |
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 |
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]);