units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
98 rows where AGNCY_TYP = 3 and DES_TP = 4 sorted by AGNCY_ID descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_WEB, MNG_AG_ID, MNG_AG_LEV, COUNTY
MNG_AGENCY 18
- San Diego, County of 32
- Orange, County of 17
- Los Angeles, County of 14
- Santa Barbara, County of 5
- San Luis Obispo, County of 5
- Riverside, County of 5
- Sacramento, County of 4
- Santa Cruz, County of 3
- Monterey, County of 2
- Placer, County of 2
- San Bernardino, County of 2
- Mountains Recreation and Conservation Authority 1
- Tulare, County of 1
- Los Angeles - Department of Parks and Recreation, County of 1
- Lake, County of 1
- San Joaquin, County of 1
- Napa, County of 1
- Midpeninsula Regional Open Space District 1
MNG_AG_TYP 4
ACCESS_TYP 4
DES_TP 1
- Local Conservation Area · 98 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9975 | 9975 | 9974 | {"type": "Polygon", "coordinates": [[[-122.11034, 37.25814], [-122.1099, 37.25831], [-122.10963, 37.25848], [-122.10956, 37.25855], [-122.10952, 37.25863], [-122.10951, 37.25873], [-122.10953, 37.25882], [-122.10846, 37.25883], [-122.10844, 37.25755], [-122.11032, 37.25756], [-122.11034, 37.25814]]]} | No Public Access 3 | 47967 | Saratoga Gap Open Space Preserve | 31468 | 373 | Santa Clara, County of 941 | County 3 | County Agency 3 | http://www.sccgov.org/sites/scc/Pages/default.aspx | County 3 | 2079 | Midpeninsula Regional Open Space District 631 | Special District 4 | Recreation/Parks District 4 | http://www.openspace.org/preserves/pr_saratoga_gap.asp | Santa Clara 19 | 4.827 | Saratoga Gap OSP | 2006 | Local Conservation Area 4 | 2 |
12511 | 12511 | 12510 | {"type": "Polygon", "coordinates": [[[-122.88176, 39.1186], [-122.88175, 39.11912], [-122.87917, 39.11957], [-122.87867, 39.11973], [-122.87835, 39.11987], [-122.8781, 39.12], [-122.87511, 39.12088], [-122.87443, 39.11976], [-122.87471, 39.11976], [-122.87471, 39.11945], [-122.87507, 39.11939], [-122.87554, 39.11916], [-122.87568, 39.11893], [-122.87573, 39.11877], [-122.87571, 39.11844], [-122.87566, 39.11801], [-122.87569, 39.11746], [-122.87738, 39.11623], [-122.87753, 39.11618], [-122.87832, 39.11638], [-122.87874, 39.11687], [-122.87937, 39.11686], [-122.87941, 39.11692], [-122.87975, 39.1171], [-122.88022, 39.11721], [-122.88119, 39.1179], [-122.88155, 39.11829], [-122.88158, 39.11856], [-122.88166, 39.11861], [-122.88176, 39.1186]]]} | Open Access 1 | 28342 | Rodman Slough | 24551 | 345 | Lake, County of 279 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 345 | Lake, County of 275 | County 3 | County Agency 3 | Lake 40 | 43.698 | Rodman Slough | 0 | Local Conservation Area 4 | 2 | |
262 | 262 | 261 | {"type": "MultiPolygon", "coordinates": [[[[-119.51628, 36.5064], [-119.51628, 36.50687], [-119.51596, 36.50697], [-119.5159, 36.50697], [-119.51578, 36.50704], [-119.51571, 36.50706], [-119.51541, 36.50717], [-119.51519, 36.50722], [-119.51504, 36.50729], [-119.5146, 36.50739], [-119.51446, 36.5074], [-119.51416, 36.5074], [-119.51366, 36.50732], [-119.51344, 36.50726], [-119.51285, 36.50704], [-119.51229, 36.5069], [-119.51198, 36.50687], [-119.5116, 36.50688], [-119.51097, 36.50675], [-119.51085, 36.50679], [-119.51073, 36.50687], [-119.51069, 36.50704], [-119.51062, 36.50717], [-119.51053, 36.50724], [-119.51037, 36.50734], [-119.5101, 36.50745], [-119.50998, 36.50746], [-119.50976, 36.5076], [-119.50924, 36.50769], [-119.50894, 36.5078], [-119.50879, 36.50781], [-119.50838, 36.5078], [-119.50839, 36.5066], [-119.50732, 36.50658], [-119.50733, 36.50532], [-119.50718, 36.50531], [-119.50723, 36.50332], [-119.51176, 36.50332], [-119.51176, 36.50188], [-119.51343, 36.50219], [-119.51503, 36.50228], [-119.51505, 36.50638], [-119.51628, 36.5064]]], [[[-119.51651, 36.50754], [-119.5165, 36.50802], [-119.51522, 36.50835], [-119.51522, 36.5079], [-119.5154, 36.50788], [-119.51546, 36.50784], [-119.51651, 36.50754]]]]} | Restricted Access 2 | 733 | Kings River Nature Preserve | 20663 | 330 | Tulare, County of 96 | County 3 | County Agency 3 | http://www.tularecounty.ca.gov/cao/index.cfm/general-services/parks-and-recreation/county-parks/ | County 3 | 330 | Tulare, County of 94 | County 3 | County Agency 3 | Tulare 29 | 86.678 | Kings River Nature Preserve | 0 | Local Conservation Area 4 | 2 | |
9135 | 9135 | 9134 | {"type": "Polygon", "coordinates": [[[-121.8062, 36.9086], [-121.80603, 36.90929], [-121.80576, 36.90997], [-121.80555, 36.91066], [-121.80541, 36.91092], [-121.80506, 36.91124], [-121.8049, 36.9115], [-121.80481, 36.91148], [-121.80472, 36.91147], [-121.80272, 36.91153], [-121.80291, 36.90858], [-121.8062, 36.9086]]]} | Restricted Access 2 | 16765 | Harkins Slough | 28149 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 20.48 | Harkins Slough | 0 | Local Conservation Area 4 | 2 | |
9698 | 9698 | 9697 | {"type": "MultiPolygon", "coordinates": [[[[-121.81062, 36.91], [-121.81032, 36.90991], [-121.81001, 36.91005], [-121.80937, 36.91143], [-121.80919, 36.91137], [-121.8094, 36.9109], [-121.80963, 36.91001], [-121.80983, 36.90957], [-121.80981, 36.90862], [-121.81062, 36.91]]], [[[-121.8208, 36.91677], [-121.81946, 36.91684], [-121.8184, 36.91715], [-121.81784, 36.91788], [-121.81749, 36.91791], [-121.81589, 36.91711], [-121.81536, 36.91645], [-121.8149, 36.91595], [-121.81467, 36.91595], [-121.81398, 36.91524], [-121.81264, 36.91331], [-121.81191, 36.9127], [-121.81154, 36.9117], [-121.81148, 36.91147], [-121.81215, 36.91259], [-121.81332, 36.91179], [-121.8138, 36.91263], [-121.81399, 36.91289], [-121.81422, 36.91312], [-121.81616, 36.91481], [-121.81662, 36.91515], [-121.81714, 36.91542], [-121.8177, 36.91562], [-121.8183, 36.91574], [-121.81892, 36.91578], [-121.81954, 36.91574], [-121.82052, 36.91553], [-121.8208, 36.91677]]]]} | Restricted Access 2 | 16385 | Gallighan Slough | 28152 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 41.877 | Gallighan Slough | 0 | Local Conservation Area 4 | 2 | |
9887 | 9887 | 9886 | {"type": "MultiPolygon", "coordinates": [[[[-122.07465, 37.09388], [-122.07452, 37.0943], [-122.07432, 37.0947], [-122.07404, 37.09507], [-122.07345, 37.09551], [-122.07319, 37.09568], [-122.07298, 37.09588], [-122.07282, 37.09611], [-122.06231, 37.09602], [-122.06222, 37.09358], [-122.07465, 37.09388]]], [[[-122.07657, 37.09618], [-122.0732, 37.09611], [-122.0731, 37.09611], [-122.07328, 37.09589], [-122.07427, 37.09516], [-122.07455, 37.09477], [-122.07476, 37.09435], [-122.07489, 37.09389], [-122.07653, 37.09393], [-122.07657, 37.09618]]]]} | Open Access 1 | 18330 | Pace Family Wilderness Park | 23289 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 79.551 | Pace Family Wilderness Park | 0 | Local Conservation Area 4 | 2 | |
345 | 345 | 344 | {"type": "Polygon", "coordinates": [[[-119.5898, 34.42352], [-119.58906, 34.42428], [-119.5885, 34.42388], [-119.58922, 34.42315], [-119.5898, 34.42352]]]} | Open Access 1 | 1191 | Summerland Greenwell Preserve | 25961 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 1.774 | Summerland Greenwell Preserve | 0 | Local Conservation Area 4 | 2 | |
1618 | 1618 | 1617 | {"type": "Polygon", "coordinates": [[[-119.74281, 34.40401], [-119.74274, 34.40423], [-119.74231, 34.40436], [-119.7421, 34.40437], [-119.74078, 34.40476], [-119.7407, 34.40454], [-119.74281, 34.40401]]]} | Open Access 1 | 13836 | Douglas Family Reserve | 18242 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 1.079 | Douglas Family Reserve | 0 | Local Conservation Area 4 | 2 | |
9798 | 9798 | 9797 | {"type": "Polygon", "coordinates": [[[-120.65717, 34.9522], [-120.65432, 34.95978], [-120.6519, 34.96646], [-120.65078, 34.97051], [-120.64878, 34.96944], [-120.64914, 34.96875], [-120.64889, 34.96826], [-120.64937, 34.96772], [-120.64677, 34.96656], [-120.64661, 34.96442], [-120.64568, 34.96166], [-120.64502, 34.96078], [-120.64471, 34.96016], [-120.64403, 34.95965], [-120.64345, 34.95932], [-120.64321, 34.9592], [-120.64235, 34.95893], [-120.64056, 34.95849], [-120.64021, 34.95863], [-120.63876, 34.95838], [-120.63834, 34.95875], [-120.6378, 34.9583], [-120.63663, 34.9577], [-120.63662, 34.95771], [-120.63659, 34.95879], [-120.63347, 34.95834], [-120.63251, 34.95793], [-120.63144, 34.95778], [-120.63125, 34.95708], [-120.6326, 34.95643], [-120.63361, 34.95661], [-120.63361, 34.95605], [-120.63038, 34.95437], [-120.63021, 34.95408], [-120.63031, 34.95324], [-120.62935, 34.95269], [-120.62838, 34.95091], [-120.6414, 34.95112], [-120.64138, 34.95191], [-120.65717, 34.9522]]]} | Open Access 1 | 16704 | Guadalupe-Nipomo Dunes Preserve Forest | 28194 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | https://www.countyofsb.org/parks/parks02.aspx?id=13422 | Santa Barbara 7 | 611.44 | Guadalupe-Nipomo Dunes Preserve Forest | 0 | Local Conservation Area 4 | 2 |
10002 | 10002 | 10001 | {"type": "Polygon", "coordinates": [[[-119.85366, 34.44306], [-119.85276, 34.44347], [-119.85337, 34.44455], [-119.8527, 34.44481], [-119.84965, 34.4455], [-119.84954, 34.44511], [-119.84907, 34.44512], [-119.8486, 34.44517], [-119.84766, 34.44503], [-119.8476, 34.4451], [-119.84732, 34.44499], [-119.84702, 34.44491], [-119.84672, 34.44486], [-119.84642, 34.44483], [-119.84611, 34.44482], [-119.84581, 34.44485], [-119.84551, 34.4449], [-119.84502, 34.44504], [-119.84435, 34.44329], [-119.84429, 34.443], [-119.84425, 34.44272], [-119.84423, 34.44243], [-119.84423, 34.44189], [-119.84417, 34.44156], [-119.84321, 34.44012], [-119.84296, 34.4393], [-119.84304, 34.4392], [-119.84742, 34.43854], [-119.84918, 34.43857], [-119.84949, 34.43861], [-119.84978, 34.43869], [-119.85005, 34.43883], [-119.85018, 34.43891], [-119.85041, 34.43912], [-119.85121, 34.4401], [-119.85133, 34.44022], [-119.85148, 34.44031], [-119.85164, 34.44038], [-119.85184, 34.44042], [-119.85204, 34.44044], [-119.85207, 34.44067], [-119.8523, 34.44083], [-119.85269, 34.4408], [-119.85279, 34.44126], [-119.85293, 34.44172], [-119.85303, 34.442], [-119.85315, 34.44223], [-119.85339, 34.44266], [-119.85366, 34.44306]]]} | Open Access 1 | 17215 | Lake Los Carneros Natural and Historical Preserve | 20949 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 133.546 | Lake Los Carneros Natural and Historical Preserve | 0 | Local Conservation Area 4 | 2 | |
10246 | 10246 | 10245 | {"type": "Polygon", "coordinates": [[[-120.67009, 34.90633], [-120.6671, 34.91364], [-120.66438, 34.92044], [-120.66391, 34.92673], [-120.655, 34.91725], [-120.64527, 34.90698], [-120.64528, 34.90274], [-120.65299, 34.90277], [-120.66179, 34.90273], [-120.66183, 34.90636], [-120.67009, 34.90633]]]} | Open Access 1 | 18725 | Point Sal Preserve | 23860 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 759.061 | Point Sal Preserve | 0 | Local Conservation Area 4 | 2 | |
1720 | 1720 | 1719 | {"type": "Polygon", "coordinates": [[[-120.83252, 35.33196], [-120.83067, 35.3336], [-120.83044, 35.33382], [-120.82384, 35.33374], [-120.82365, 35.33357], [-120.82366, 35.33193], [-120.83252, 35.33196]]]} | Open Access 1 | 14878 | Elfin Forest Natural Preserve | 18558 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | San Luis Obispo 1 | 35.806 | Elfin Forest Natural Preserve | 0 | Local Conservation Area 4 | 2 | |
3906 | 3906 | 3905 | {"type": "Polygon", "coordinates": [[[-120.68988, 35.7518], [-120.68637, 35.75282], [-120.68543, 35.7525], [-120.68529, 35.75228], [-120.68512, 35.75228], [-120.68514, 35.75221], [-120.68616, 35.75215], [-120.6861, 35.75083], [-120.68543, 35.75084], [-120.68542, 35.74725], [-120.68987, 35.74723], [-120.68988, 35.7518]]]} | Open Access 1 | 1959 | Wolf Property Natural Area | 27671 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | San Luis Obispo 1 | 54.586 | Wolf Property Natural Area | 0 | Local Conservation Area 4 | 2 | |
5980 | 5980 | 5979 | {"type": "MultiPolygon", "coordinates": [[[[-120.4173, 35.31679], [-120.40935, 35.31666], [-120.40964, 35.31285], [-120.411, 35.3143], [-120.41124, 35.31444], [-120.41153, 35.31454], [-120.41174, 35.31458], [-120.41192, 35.31459], [-120.41216, 35.31458], [-120.41704, 35.31472], [-120.41731, 35.31477], [-120.41757, 35.31488], [-120.41771, 35.31496], [-120.41782, 35.31508], [-120.41788, 35.31522], [-120.41789, 35.31537], [-120.41781, 35.31555], [-120.41758, 35.31597], [-120.41746, 35.31622], [-120.41737, 35.31647], [-120.4173, 35.31679]]], [[[-120.50681, 35.32693], [-120.5068, 35.34504], [-120.48918, 35.34481], [-120.48917, 35.34537], [-120.48362, 35.34331], [-120.47178, 35.33897], [-120.47169, 35.3526], [-120.46721, 35.35253], [-120.46726, 35.346], [-120.45847, 35.34562], [-120.4583, 35.35033], [-120.44546, 35.34994], [-120.44546, 35.34567], [-120.43653, 35.34543], [-120.43643, 35.34175], [-120.4413, 35.34186], [-120.44114, 35.33459], [-120.43623, 35.33442], [-120.43612, 35.33085], [-120.42645, 35.33093], [-120.4269, 35.32274], [-120.42249, 35.32245], [-120.42254, 35.3195], [-120.41869, 35.31901], [-120.4181, 35.31857], [-120.41785, 35.31834], [-120.41799, 35.31565], [-120.41806, 35.31548], [-120.41809, 35.31529], [-120.41806, 35.31512], [-120.41799, 35.315], [-120.41787, 35.31486], [-120.4177, 35.31475], [-120.41743, 35.31463], [-120.41726, 35.31459], [-120.41706, 35.31456], [-120.41215, 35.31441], [-120.41188, 35.31442], [-120.41165, 35.31439], [-120.4115, 35.31435], [-120.41131, 35.31428], [-120.41114, 35.31419], [-120.40997, 35.31293], [-120.40965, 35.31261], [-120.40973, 35.31163], [-120.40999, 35.31162], [-120.41001, 35.31103], [-120.40978, 35.31101], [-120.40988, 35.30958], [-120.41438, 35.3094], [-120.42561, 35.30914], [-120.42572, 35.31301], [-120.43054, 35.31319], [-120.43058, 35.31709], [-120.43577, 35.31779], [-120.44373, 35.31771], [-120.44383, 35.31362], [-120.45392, 35.31394], [-120.45387, 35.30961], [-120.4577, 35.30976], [-120.45818, 35.3015], [-120.46285, 35.30148], [-120.46288, 35.30578], [-120.46685, 35.30579], [-120.46686, 35.31422], [-120.47191, 35.31425], [-120.47181, 35.332], [-120.48917, 35.33827], [-120.48919, 35.32291], [-120.47969, 35.31989], [-120.47985, 35.31681], [-120.47542, 35.31538], [-120.47634, 35.30343], [-120.4892, 35.30926], [-120.48919, 35.31601], [-120.49278, 35.31592], [-120.49289, 35.3195], [-120.49738, 35.31934], [-120.49736, 35.3228], [-120.49619, 35.32344], [-120.49566, 35.32369], [-120.49491, 35.324], [-120.49417, 35.32435], [-120.49384, 35.32447], [-120.4935, 35.32458], [-120.49191, 35.32494], [-120.49176, 35.325], [-120.49165, 35.32508], [-120.49153, 35.3252], [-120.49146, 35.32535], [-120.49128, 35.32635], [-120.49128, 35.32664], [-120.49133, 35.32692], [-120.4914, 35.3272], [-120.49151, 35.32747], [-120.49164, 35.32744], [-120.49153, 35.32717], [-120.49146, 35.3269], [-120.49142, 35.32658], [-120.49142, 35.32631], [-120.49159, 35.32537], [-120.49165, 35.32525], [-120.49174, 35.32516], [-120.49183, 35.3251], [-120.49195, 35.32505], [-120.49345, 35.3247], [-120.49406, 35.32451], [-120.49448, 35.32434], [-120.49503, 35.32407], [-120.49594, 35.32369], [-120.49644, 35.32344], [-120.49763, 35.32345], [-120.49796, 35.3238], [-120.49794, 35.32503], [-120.50014, 35.32514], [-120.50002, 35.33047], [-120.50232, 35.33054], [-120.50243, 35.32688], [-120.50681, 35.32693]]], [[[-120.41833, 35.31896], [-120.41782, 35.3189], [-120.41783, 35.31858], [-120.41796, 35.31869], [-120.41833, 35.31896]]]]} | Open Access 1 | 564 | Santa Margarita Lake Regional Park and Natural Area | 11439 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/activities/santa_margarita.htm | San Luis Obispo 1 | 5623.374 | Santa Margarita Lake RP and Natural Area | 0 | Local Conservation Area 4 | 2 |
10185 | 10185 | 10184 | {"type": "MultiPolygon", "coordinates": [[[[-120.51236, 35.03141], [-120.51151, 35.03142], [-120.50616, 35.0315], [-120.50672, 35.03036], [-120.50677, 35.03033], [-120.50812, 35.0308], [-120.50813, 35.03123], [-120.51014, 35.03122], [-120.5108, 35.03095], [-120.51138, 35.03074], [-120.51225, 35.03007], [-120.51225, 35.02817], [-120.5119, 35.02817], [-120.5119, 35.02787], [-120.51192, 35.02784], [-120.51196, 35.02782], [-120.51235, 35.02782], [-120.51236, 35.03141]]], [[[-120.50742, 35.03009], [-120.50724, 35.03034], [-120.50686, 35.03021], [-120.50683, 35.03017], [-120.50683, 35.03014], [-120.50708, 35.02961], [-120.50714, 35.02943], [-120.50717, 35.0294], [-120.50723, 35.0294], [-120.50741, 35.02947], [-120.50714, 35.02999], [-120.50742, 35.03009]]], [[[-120.50768, 35.02852], [-120.50733, 35.02929], [-120.50726, 35.02926], [-120.50723, 35.02921], [-120.50728, 35.02905], [-120.50756, 35.02853], [-120.50761, 35.0285], [-120.50768, 35.02852]]], [[[-120.51174, 35.02817], [-120.51117, 35.02818], [-120.51117, 35.02918], [-120.5108, 35.02919], [-120.51056, 35.02923], [-120.51033, 35.02932], [-120.51011, 35.02947], [-120.5095, 35.02885], [-120.50923, 35.02904], [-120.50905, 35.02889], [-120.50882, 35.02877], [-120.50771, 35.02838], [-120.50767, 35.02833], [-120.50791, 35.02787], [-120.50797, 35.02784], [-120.50911, 35.02784], [-120.51168, 35.02782], [-120.51172, 35.02784], [-120.51174, 35.02787], [-120.51174, 35.02817]]]]} | Open Access 1 | 17778 | Mesa Meadows Natural Area | 22177 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | San Luis Obispo 1 | 21.08 | Mesa Meadows Natural Area | 0 | Local Conservation Area 4 | 2 | |
10228 | 10228 | 10227 | {"type": "Polygon", "coordinates": [[[-120.86112, 35.31032], [-120.86111, 35.31276], [-120.86105, 35.31586], [-120.86045, 35.31587], [-120.86045, 35.31573], [-120.86041, 35.31569], [-120.86078, 35.31419], [-120.86095, 35.31265], [-120.85951, 35.31264], [-120.85951, 35.31144], [-120.8592, 35.31143], [-120.85933, 35.31126], [-120.85933, 35.3112], [-120.8593, 35.31114], [-120.8592, 35.3111], [-120.85909, 35.31112], [-120.859, 35.31102], [-120.85674, 35.31101], [-120.85674, 35.31089], [-120.85678, 35.31076], [-120.85674, 35.31066], [-120.85667, 35.31059], [-120.85667, 35.3103], [-120.86112, 35.31032]]]} | Open Access 1 | 17895 | Monarch Grove Natural Area | 22365 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | San Luis Obispo 1 | 17.519 | Monarch Grove Natural Area | 0 | Local Conservation Area 4 | 2 | |
16300 | 16300 | 16299 | {"type": "Polygon", "coordinates": [[[-121.31549, 38.16334], [-121.31531, 38.16334], [-121.31523, 38.16345], [-121.31476, 38.16386], [-121.3135, 38.16385], [-121.31336, 38.16368], [-121.31335, 38.16359], [-121.31338, 38.16349], [-121.31374, 38.163], [-121.31386, 38.16277], [-121.3141, 38.16245], [-121.31416, 38.16237], [-121.31418, 38.1623], [-121.31417, 38.16211], [-121.31414, 38.16205], [-121.31396, 38.1618], [-121.31384, 38.16167], [-121.31377, 38.16162], [-121.3136, 38.16147], [-121.3133, 38.16128], [-121.31285, 38.16112], [-121.31259, 38.16107], [-121.31208, 38.16107], [-121.31085, 38.16126], [-121.31056, 38.16127], [-121.31033, 38.16126], [-121.31021, 38.16124], [-121.31015, 38.16078], [-121.31019, 38.15968], [-121.31067, 38.15967], [-121.31194, 38.15973], [-121.31208, 38.15969], [-121.31234, 38.15953], [-121.31297, 38.15966], [-121.31414, 38.16067], [-121.31442, 38.16097], [-121.3147, 38.16131], [-121.31514, 38.16195], [-121.31519, 38.16209], [-121.31529, 38.16229], [-121.31549, 38.16293], [-121.31549, 38.16334]]]} | Open Access 1 | 17364 | Woodbridge Wilderness Area Regional Park | 27697 | 322 | San Joaquin, County of 479 | County 3 | County Agency 3 | http://www.sjparks.com/ | County 3 | 322 | San Joaquin, County of 471 | County 3 | County Agency 3 | San Joaquin 39 | 22.347 | Woodbridge Wilderness Area RP | 0 | Local Conservation Area 4 | 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 | |
273 | 273 | 272 | {"type": "Polygon", "coordinates": [[[-117.22664, 33.05068], [-117.22596, 33.05276], [-117.2242, 33.05232], [-117.22397, 33.05269], [-117.22342, 33.05309], [-117.22333, 33.0532], [-117.22327, 33.05335], [-117.22319, 33.05333], [-117.22285, 33.05437], [-117.2217, 33.05409], [-117.22056, 33.05378], [-117.21929, 33.05347], [-117.21921, 33.05335], [-117.2161, 33.05151], [-117.2152, 33.05153], [-117.21517, 33.05106], [-117.21518, 33.05083], [-117.21545, 33.0506], [-117.21594, 33.05075], [-117.21635, 33.05105], [-117.21679, 33.05145], [-117.21732, 33.05162], [-117.21818, 33.05212], [-117.21855, 33.05236], [-117.2191, 33.05245], [-117.21953, 33.05245], [-117.22, 33.05237], [-117.22063, 33.05218], [-117.22118, 33.05198], [-117.22176, 33.05197], [-117.22196, 33.05142], [-117.22206, 33.05144], [-117.22209, 33.05145], [-117.2219, 33.052], [-117.2221, 33.05204], [-117.22236, 33.0522], [-117.22247, 33.05237], [-117.22239, 33.05293], [-117.22239, 33.05312], [-117.22257, 33.05319], [-117.22287, 33.05307], [-117.22318, 33.05292], [-117.22333, 33.05278], [-117.22331, 33.05265], [-117.22347, 33.05211], [-117.22328, 33.0517], [-117.2231, 33.0515], [-117.22291, 33.05106], [-117.22291, 33.05094], [-117.22294, 33.05091], [-117.22296, 33.0508], [-117.22288, 33.05078], [-117.22291, 33.05061], [-117.22294, 33.0506], [-117.22293, 33.05044], [-117.22297, 33.0501], [-117.22301, 33.0501], [-117.22307, 33.05], [-117.22299, 33.04997], [-117.22302, 33.04982], [-117.22309, 33.04984], [-117.22316, 33.04971], [-117.22322, 33.04966], [-117.2235, 33.04936], [-117.22355, 33.04924], [-117.22352, 33.04914], [-117.22363, 33.049], [-117.22362, 33.04898], [-117.22385, 33.04877], [-117.2239, 33.04867], [-117.22389, 33.04866], [-117.22404, 33.04837], [-117.22402, 33.04835], [-117.22407, 33.04826], [-117.22407, 33.04819], [-117.22411, 33.04819], [-117.22416, 33.04806], [-117.2241, 33.04804], [-117.22416, 33.0479], [-117.2241, 33.04783], [-117.22609, 33.04832], [-117.22544, 33.05038], [-117.22664, 33.05068]]]} | Open Access 1 | 745 | Val Sereno Preserve | 26755 | 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 | 54.542 | Val Sereno Preserve | 0 | Local Conservation Area 4 | 2 | |
1137 | 1137 | 1136 | {"type": "MultiPolygon", "coordinates": [[[[-117.02885, 33.34502], [-117.02695, 33.34498], [-117.02614, 33.34414], [-117.02426, 33.34497], [-117.02419, 33.34265], [-117.02878, 33.34259], [-117.02885, 33.34502]]], [[[-117.05093, 33.3583], [-117.04668, 33.35835], [-117.04442, 33.35814], [-117.04443, 33.35429], [-117.04345, 33.35427], [-117.0434, 33.35804], [-117.04323, 33.35802], [-117.04326, 33.35059], [-117.04225, 33.35057], [-117.04224, 33.35058], [-117.04223, 33.35424], [-117.04258, 33.35426], [-117.04258, 33.35796], [-117.04222, 33.35793], [-117.04221, 33.35603], [-117.04114, 33.35604], [-117.0411, 33.35792], [-117.04095, 33.35765], [-117.04058, 33.35758], [-117.03982, 33.35725], [-117.03928, 33.35674], [-117.03849, 33.35579], [-117.03828, 33.35582], [-117.03668, 33.35448], [-117.03357, 33.35447], [-117.03356, 33.35433], [-117.02942, 33.35428], [-117.0292, 33.3542], [-117.02912, 33.35051], [-117.02563, 33.35045], [-117.02562, 33.34983], [-117.0257, 33.34859], [-117.02569, 33.3484], [-117.02565, 33.34824], [-117.02555, 33.34803], [-117.02542, 33.34786], [-117.02435, 33.34678], [-117.02433, 33.34655], [-117.03346, 33.34656], [-117.03331, 33.34315], [-117.04228, 33.34309], [-117.05066, 33.3431], [-117.05068, 33.34591], [-117.0508, 33.35071], [-117.05093, 33.3583]]]]} | Open Access 1 | 7251 | Wilderness Gardens Preserve | 29262 | 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/WildernessGardens.html | San Diego 4 | 732.625 | Wilderness Gardens Preserve | 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]);