units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
37 rows where DES_TP = 4 and MNG_AGENCY = 101 sorted by map
This data as json, copyable, CSV (advanced)
ACCESS_TYP 3
MNG_AG_TYP 1
MNG_AGENCY 1
- San Diego, County of · 17 ✖
DES_TP 1
- Local Conservation Area · 17 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
7361 | 7361 | 7360 | {"type": "Polygon", "coordinates": [[[-116.80495, 32.6658], [-116.7972, 32.66593], [-116.79691, 32.66573], [-116.79678, 32.66565], [-116.79554, 32.66464], [-116.7957, 32.65742], [-116.78827, 32.65749], [-116.78821, 32.65701], [-116.77957, 32.65689], [-116.77935, 32.64654], [-116.78382, 32.64644], [-116.78381, 32.64588], [-116.78409, 32.64598], [-116.78439, 32.64605], [-116.78463, 32.64607], [-116.78512, 32.64609], [-116.7853, 32.64611], [-116.78551, 32.64618], [-116.78574, 32.64629], [-116.78584, 32.64636], [-116.78591, 32.64644], [-116.78597, 32.64653], [-116.786, 32.64664], [-116.78603, 32.64794], [-116.78609, 32.64813], [-116.78635, 32.64851], [-116.78641, 32.64863], [-116.78641, 32.64876], [-116.78636, 32.64911], [-116.78634, 32.64918], [-116.78636, 32.64927], [-116.78685, 32.65008], [-116.78694, 32.65019], [-116.78706, 32.65029], [-116.78722, 32.65038], [-116.7874, 32.65043], [-116.78819, 32.65052], [-116.78833, 32.65059], [-116.78845, 32.65071], [-116.7885, 32.65082], [-116.78869, 32.65163], [-116.7887, 32.65178], [-116.78869, 32.65209], [-116.78872, 32.65231], [-116.78884, 32.65264], [-116.78898, 32.65285], [-116.78902, 32.65304], [-116.78907, 32.65314], [-116.78921, 32.65323], [-116.78954, 32.65329], [-116.78969, 32.65328], [-116.78976, 32.65325], [-116.78984, 32.6532], [-116.79019, 32.65284], [-116.79056, 32.65268], [-116.7907, 32.65263], [-116.79084, 32.65261], [-116.791, 32.65262], [-116.79115, 32.65265], [-116.79157, 32.6528], [-116.79173, 32.6529], [-116.79181, 32.65303], [-116.79189, 32.65332], [-116.79204, 32.65374], [-116.79201, 32.65377], [-116.79204, 32.65382], [-116.79217, 32.65396], [-116.79232, 32.65409], [-116.79251, 32.6542], [-116.7927, 32.65427], [-116.79413, 32.65454], [-116.79453, 32.65443], [-116.79454, 32.65439], [-116.79458, 32.65438], [-116.79479, 32.65439], [-116.79609, 32.65457], [-116.79742, 32.65446], [-116.79772, 32.65438], [-116.798, 32.65424], [-116.79813, 32.65414], [-116.7988, 32.65358], [-116.79906, 32.65342], [-116.79963, 32.65313], [-116.79982, 32.65306], [-116.80012, 32.65298], [-116.80041, 32.65296], [-116.80065, 32.65297], [-116.8009, 32.65301], [-116.80291, 32.6536], [-116.80322, 32.65367], [-116.80397, 32.6538], [-116.80484, 32.65407], [-116.80495, 32.6658]]]} | No Public Access 3 | 47588 | Lawrence and Barbara Daley Preserve | 31315 | 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 | 580.873 | Lawrence and Barbara Daley Preserve | 0 | Local Conservation Area 4 | 2 | |
5408 | 5408 | 5407 | {"type": "Polygon", "coordinates": [[[-116.81981, 33.02977], [-116.8111, 33.02981], [-116.81109, 33.03475], [-116.81112, 33.03724], [-116.80247, 33.03726], [-116.80249, 33.03342], [-116.79575, 33.03337], [-116.7939, 33.03338], [-116.78948, 33.03332], [-116.7896, 33.02616], [-116.78509, 33.02618], [-116.78506, 33.0267], [-116.78495, 33.02974], [-116.78077, 33.02975], [-116.78072, 33.03206], [-116.78073, 33.03214], [-116.78051, 33.0373], [-116.77195, 33.03733], [-116.77187, 33.04415], [-116.76347, 33.04418], [-116.7635, 33.04086], [-116.76778, 33.04085], [-116.76776, 33.03734], [-116.77194, 33.03732], [-116.77212, 33.03338], [-116.77631, 33.03336], [-116.77632, 33.03302], [-116.77635, 33.03297], [-116.77634, 33.03283], [-116.77654, 33.02623], [-116.77239, 33.02624], [-116.77253, 33.02267], [-116.77191, 33.00828], [-116.77177, 33.00579], [-116.77467, 33.00636], [-116.78232, 33.01272], [-116.78474, 33.01283], [-116.78474, 33.0184], [-116.7894, 33.01824], [-116.79601, 33.0188], [-116.7999, 33.01916], [-116.79819, 33.0217], [-116.79691, 33.02514], [-116.79561, 33.02902], [-116.7956, 33.02911], [-116.80396, 33.02931], [-116.8139, 33.02775], [-116.81537, 33.0275], [-116.81616, 33.02756], [-116.81691, 33.02777], [-116.81803, 33.02843], [-116.81981, 33.02942], [-116.81981, 33.02977]]]} | Open Access 1 | 12525 | Mt. Gower Preserve | 30285 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/MtGower.html | San Diego 4 | 1522.886 | Mt. Gower Preserve | 0 | Local Conservation Area 4 | 2 |
7629 | 7629 | 7628 | {"type": "Polygon", "coordinates": [[[-116.84027, 33.01834], [-116.83705, 33.01834], [-116.83717, 33.02213], [-116.83644, 33.02214], [-116.8364, 33.02578], [-116.83485, 33.02582], [-116.83228, 33.02593], [-116.83257, 33.03336], [-116.83043, 33.03338], [-116.83026, 33.02966], [-116.82814, 33.02969], [-116.82823, 33.03136], [-116.82824, 33.03224], [-116.82823, 33.03238], [-116.82824, 33.03245], [-116.82394, 33.03251], [-116.8239, 33.03133], [-116.82546, 33.03083], [-116.82452, 33.0293], [-116.82396, 33.02877], [-116.82355, 33.02788], [-116.82302, 33.02711], [-116.82334, 33.02651], [-116.82289, 33.0261], [-116.82291, 33.02604], [-116.8234, 33.02558], [-116.82306, 33.02488], [-116.82232, 33.02497], [-116.82155, 33.02487], [-116.82082, 33.02466], [-116.82045, 33.02503], [-116.81997, 33.02455], [-116.82018, 33.0244], [-116.82021, 33.02401], [-116.82008, 33.02382], [-116.8199, 33.02371], [-116.81972, 33.02355], [-116.81973, 33.02302], [-116.81961, 33.02275], [-116.81974, 33.02235], [-116.81971, 33.02184], [-116.8202, 33.02104], [-116.82014, 33.02005], [-116.82053, 33.01979], [-116.82083, 33.01917], [-116.82089, 33.01895], [-116.82117, 33.0185], [-116.82113, 33.01833], [-116.82129, 33.01777], [-116.82106, 33.01725], [-116.82137, 33.0167], [-116.82134, 33.01596], [-116.82119, 33.01574], [-116.82122, 33.01514], [-116.82113, 33.01494], [-116.83235, 33.01511], [-116.83292, 33.01547], [-116.83337, 33.01495], [-116.83359, 33.01465], [-116.83388, 33.01418], [-116.83408, 33.01408], [-116.83417, 33.01399], [-116.83429, 33.01393], [-116.83466, 33.01384], [-116.83553, 33.01346], [-116.83611, 33.01317], [-116.83622, 33.01315], [-116.83687, 33.01315], [-116.83723, 33.01318], [-116.83751, 33.01325], [-116.83762, 33.01332], [-116.83784, 33.01353], [-116.83801, 33.0138], [-116.83826, 33.01404], [-116.83838, 33.01427], [-116.8384, 33.01445], [-116.83844, 33.01452], [-116.83859, 33.01464], [-116.83869, 33.01476], [-116.83906, 33.0153], [-116.83904, 33.01556], [-116.83905, 33.0157], [-116.83907, 33.01583], [-116.83913, 33.01595], [-116.83922, 33.01608], [-116.83942, 33.01622], [-116.83957, 33.0163], [-116.83983, 33.01646], [-116.83991, 33.01657], [-116.84001, 33.01679], [-116.84002, 33.01693], [-116.83999, 33.01711], [-116.83983, 33.01756], [-116.83981, 33.01768], [-116.83982, 33.01781], [-116.83986, 33.01792], [-116.83999, 33.01815], [-116.84011, 33.01825], [-116.84027, 33.01834]], [[-116.82809, 33.02787], [-116.8281, 33.02786], [-116.82809, 33.02756], [-116.82771, 33.02756], [-116.82771, 33.02787], [-116.82809, 33.02787]]]} | Open Access 1 | 47643 | Simon Preserve | 28939 | 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/Simon.html | San Diego 4 | 617.232 | Simon Preserve | 0 | Local Conservation Area 4 | 2 |
14638 | 14638 | 14637 | {"type": "Polygon", "coordinates": [[[-116.84781, 32.81671], [-116.84748, 32.81672], [-116.84777, 32.8198], [-116.84467, 32.81979], [-116.84438, 32.81976], [-116.84405, 32.81984], [-116.84368, 32.82], [-116.84367, 32.82002], [-116.84416, 32.82064], [-116.84341, 32.8209], [-116.84061, 32.82312], [-116.84059, 32.82714], [-116.83973, 32.82708], [-116.83905, 32.82696], [-116.83843, 32.82681], [-116.83748, 32.82646], [-116.83725, 32.82644], [-116.83711, 32.82646], [-116.83698, 32.82651], [-116.83686, 32.82658], [-116.83677, 32.82668], [-116.83669, 32.82685], [-116.83667, 32.82721], [-116.83661, 32.82732], [-116.83661, 32.82663], [-116.83504, 32.82663], [-116.83441, 32.82619], [-116.83421, 32.82601], [-116.83404, 32.82583], [-116.83249, 32.82342], [-116.83244, 32.82331], [-116.83263, 32.81992], [-116.83284, 32.81992], [-116.83334, 32.8206], [-116.83363, 32.82031], [-116.83325, 32.81993], [-116.83383, 32.81994], [-116.83503, 32.81942], [-116.83545, 32.81932], [-116.83687, 32.81933], [-116.83688, 32.81895], [-116.83764, 32.81876], [-116.83867, 32.81899], [-116.83951, 32.81796], [-116.83905, 32.81756], [-116.83911, 32.81748], [-116.83955, 32.81767], [-116.83971, 32.81649], [-116.83921, 32.81568], [-116.84772, 32.81572], [-116.84781, 32.81671]]]} | Open Access 1 | 44876 | Stoneridge Preserve | 25897 | 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/AboutUs/Plans/MSCP.html | San Diego 4 | 246.46 | Stoneridge Preserve | 0 | Local Conservation Area 4 | 2 |
6865 | 6865 | 6864 | {"type": "Polygon", "coordinates": [[[-116.88206, 32.9016], [-116.87735, 32.90152], [-116.87743, 32.90675], [-116.87754, 32.91269], [-116.87364, 32.91266], [-116.87363, 32.91259], [-116.86927, 32.9126], [-116.86073, 32.91264], [-116.86073, 32.91536], [-116.85906, 32.91535], [-116.85857, 32.91537], [-116.84119, 32.9155], [-116.84121, 32.91914], [-116.84126, 32.92277], [-116.83271, 32.92285], [-116.83293, 32.93288], [-116.83278, 32.93287], [-116.83277, 32.93288], [-116.83424, 32.93483], [-116.82384, 32.93501], [-116.8236, 32.92202], [-116.82359, 32.91926], [-116.8236, 32.91642], [-116.83981, 32.91648], [-116.83994, 32.90146], [-116.83993, 32.90145], [-116.82362, 32.90223], [-116.82372, 32.8874], [-116.828, 32.8874], [-116.82799, 32.89121], [-116.83615, 32.89146], [-116.84492, 32.89538], [-116.84472, 32.89861], [-116.84891, 32.89856], [-116.84889, 32.90108], [-116.8525, 32.90092], [-116.85243, 32.90479], [-116.84825, 32.9049], [-116.84828, 32.9088], [-116.85647, 32.90867], [-116.85649, 32.90782], [-116.8565, 32.90482], [-116.86949, 32.9051], [-116.86958, 32.90132], [-116.86968, 32.8984], [-116.86146, 32.89843], [-116.86208, 32.89371], [-116.87781, 32.88967], [-116.87782, 32.89258], [-116.88195, 32.89201], [-116.88202, 32.89926], [-116.88206, 32.9016]]]} | Open Access 1 | 5516 | El Capitan Preserve | 30283 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/ElCapitan.html | San Diego 4 | 2603.63 | El Capitan Preserve | 0 | Local Conservation Area 4 | 2 |
7606 | 7606 | 7605 | {"type": "Polygon", "coordinates": [[[-116.90151, 32.99285], [-116.90006, 32.99285], [-116.89973, 32.99269], [-116.89904, 32.99263], [-116.89811, 32.99303], [-116.89825, 32.99348], [-116.89825, 32.99373], [-116.89793, 32.99416], [-116.89783, 32.99417], [-116.89735, 32.99429], [-116.89733, 32.99429], [-116.89704, 32.99353], [-116.89678, 32.99328], [-116.89418, 32.99342], [-116.89312, 32.99327], [-116.89283, 32.98927], [-116.9011, 32.98907], [-116.90151, 32.99285]]]} | Open Access 1 | 7325 | Luelf Pond Preserve | 29246 | 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/LuelfPond.html | San Diego 4 | 87.077 | Luelf Pond Preserve | 0 | Local Conservation Area 4 | 2 |
14637 | 14637 | 14636 | {"type": "Polygon", "coordinates": [[[-116.90222, 32.84651], [-116.90218, 32.84649], [-116.90213, 32.84651], [-116.9021, 32.84659], [-116.90205, 32.84692], [-116.9019, 32.84712], [-116.89878, 32.84713], [-116.89877, 32.84549], [-116.89944, 32.84553], [-116.90108, 32.84593], [-116.90178, 32.84602], [-116.90196, 32.84615], [-116.9022, 32.84643], [-116.90222, 32.84651]]]} | Open Access 1 | 44871 | Lakeside Linkage Preserve | 20976 | 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/LakesideLinkage.html | San Diego 4 | 11.424 | Lakeside Linkage Preserve | 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 |
15152 | 15152 | 15151 | {"type": "Polygon", "coordinates": [[[-117.02397, 33.1489], [-117.0239, 33.14891], [-117.0239, 33.1525], [-117.02365, 33.15577], [-117.02352, 33.15771], [-117.02307, 33.16317], [-117.01963, 33.16302], [-117.01956, 33.16279], [-117.01479, 33.16263], [-117.01268, 33.16299], [-117.00684, 33.16413], [-117.00685, 33.16376], [-117.00731, 33.16309], [-117.00787, 33.16232], [-117.00813, 33.16193], [-117.00823, 33.1618], [-117.00842, 33.16163], [-117.00899, 33.16133], [-117.0092, 33.16115], [-117.00963, 33.16057], [-117.01, 33.16016], [-117.0109, 33.15901], [-117.011, 33.15891], [-117.01118, 33.15879], [-117.01141, 33.15874], [-117.01164, 33.15874], [-117.01189, 33.15882], [-117.01208, 33.15849], [-117.01212, 33.15834], [-117.01213, 33.1582], [-117.01201, 33.15618], [-117.01198, 33.15605], [-117.01192, 33.15593], [-117.01179, 33.15576], [-117.01168, 33.15567], [-117.01173, 33.15501], [-117.01431, 33.15464], [-117.01429, 33.15444], [-117.01429, 33.15428], [-117.0145, 33.15332], [-117.01455, 33.15225], [-117.01465, 33.15223], [-117.01927, 33.15236], [-117.01936, 33.14882], [-117.02397, 33.1489]]]} | Open Access 1 | 45997 | Bottle Peak Preserve | 29192 | 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 | 373.609 | Bottle Peak Preserve | 0 | Local Conservation Area 4 | 2 | |
6179 | 6179 | 6178 | {"type": "Polygon", "coordinates": [[[-117.11321, 33.4123], [-117.11289, 33.41266], [-117.1124, 33.41359], [-117.11121, 33.41278], [-117.11054, 33.41298], [-117.10972, 33.4128], [-117.10938, 33.41231], [-117.10899, 33.41231], [-117.10623, 33.4129], [-117.10374, 33.41236], [-117.1033, 33.4123], [-117.10365, 33.41528], [-117.0977, 33.41534], [-117.09748, 33.41496], [-117.09743, 33.41491], [-117.09735, 33.41487], [-117.09697, 33.41478], [-117.09692, 33.41473], [-117.09693, 33.41467], [-117.09689, 33.41455], [-117.09675, 33.41441], [-117.09648, 33.41432], [-117.09612, 33.414], [-117.09606, 33.41398], [-117.09598, 33.414], [-117.09593, 33.41405], [-117.09582, 33.41435], [-117.09578, 33.41451], [-117.09559, 33.41471], [-117.09566, 33.41531], [-117.09569, 33.41535], [-117.0958, 33.41567], [-117.0958, 33.41579], [-117.09578, 33.41591], [-117.09565, 33.41619], [-117.09546, 33.41631], [-117.09512, 33.4166], [-117.09511, 33.41667], [-117.09518, 33.41676], [-117.09519, 33.41684], [-117.09516, 33.41689], [-117.09497, 33.41701], [-117.09486, 33.41713], [-117.09482, 33.41726], [-117.09484, 33.41742], [-117.09483, 33.4175], [-117.09475, 33.41763], [-117.09472, 33.41775], [-117.09473, 33.41799], [-117.09479, 33.41844], [-117.09481, 33.41855], [-117.09476, 33.41895], [-117.09476, 33.41905], [-117.09483, 33.41908], [-117.09506, 33.41908], [-117.0951, 33.4198], [-117.09514, 33.4209], [-117.09526, 33.42291], [-117.09097, 33.42296], [-117.09102, 33.42379], [-117.08878, 33.42387], [-117.08865, 33.42348], [-117.08854, 33.42301], [-117.09096, 33.42296], [-117.09042, 33.41541], [-117.09032, 33.41197], [-117.0873, 33.41198], [-117.08728, 33.40855], [-117.09023, 33.40853], [-117.09014, 33.40506], [-117.08586, 33.40504], [-117.08585, 33.40349], [-117.08401, 33.40348], [-117.08388, 33.40276], [-117.08385, 33.4021], [-117.08377, 33.40175], [-117.08584, 33.40179], [-117.10209, 33.40231], [-117.10282, 33.40838], [-117.10377, 33.40848], [-117.10378, 33.40847], [-117.10306, 33.40238], [-117.11128, 33.4029], [-117.11148, 33.40933], [-117.11249, 33.40945], [-117.11291, 33.41202], [-117.11321, 33.4123]]]} | No Public Access 3 | 1219 | Mt. Olympus Preserve | 29249 | 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 | 801.066 | Mt. Olympus Preserve | 0 | Local Conservation Area 4 | 2 | |
4184 | 4184 | 4183 | {"type": "Polygon", "coordinates": [[[-117.13525, 33.02933], [-117.1352, 33.03273], [-117.1346, 33.03273], [-117.13459, 33.03241], [-117.13336, 33.03194], [-117.13294, 33.0302], [-117.13281, 33.0301], [-117.13258, 33.03004], [-117.1325, 33.02998], [-117.13233, 33.02954], [-117.1323, 33.02934], [-117.13525, 33.02933]]]} | Open Access 1 | 44865 | Greenfield Preserve | 19479 | 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 | 17.374 | Greenfield Preserve | 0 | Local Conservation Area 4 | 2 | |
14809 | 14809 | 14808 | {"type": "Polygon", "coordinates": [[[-117.14066, 33.25449], [-117.14028, 33.2546], [-117.14032, 33.2547], [-117.14037, 33.25475], [-117.14057, 33.25543], [-117.1406, 33.25571], [-117.14058, 33.2559], [-117.14028, 33.25665], [-117.14037, 33.25683], [-117.13807, 33.25672], [-117.13802, 33.25307], [-117.13827, 33.25307], [-117.13853, 33.25318], [-117.13868, 33.25322], [-117.13897, 33.25337], [-117.13918, 33.25314], [-117.13955, 33.25349], [-117.14011, 33.25382], [-117.14025, 33.25392], [-117.14035, 33.25403], [-117.14066, 33.25449]]]} | Restricted Access 2 | 45227 | Knollwood Preserve | 31493 | 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 | 20.712 | Knollwood Preserve | 0 | Local Conservation Area 4 | 2 | |
6825 | 6825 | 6824 | {"type": "Polygon", "coordinates": [[[-117.17513, 33.01315], [-117.17085, 33.01592], [-117.16887, 33.01455], [-117.16549, 33.01457], [-117.16225, 33.01456], [-117.16124, 33.01454], [-117.16134, 33.01093], [-117.15898, 33.01092], [-117.15897, 33.0073], [-117.16989, 33.00728], [-117.1699, 33.01127], [-117.17283, 33.01129], [-117.1732, 33.01127], [-117.17395, 33.01128], [-117.174, 33.01125], [-117.17441, 33.01238], [-117.17513, 33.01315]]]} | Open Access 1 | 5419 | Lusardi Creek Preserve | 29247 | 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/LusardiCreek.html | San Diego 4 | 225.646 | Lusardi Creek Preserve | 0 | Local Conservation Area 4 | 2 |
6830 | 6830 | 6829 | {"type": "Polygon", "coordinates": [[[-117.18338, 33.25274], [-117.18272, 33.25297], [-117.18189, 33.25323], [-117.18125, 33.25339], [-117.18097, 33.25343], [-117.18104, 33.24925], [-117.18302, 33.24925], [-117.18305, 33.2493], [-117.18316, 33.24949], [-117.18322, 33.24967], [-117.1836, 33.25208], [-117.18366, 33.2523], [-117.18378, 33.25255], [-117.18377, 33.25259], [-117.18374, 33.25261], [-117.18338, 33.25274]]]} | Open Access 1 | 5437 | Gopher Canyon Reserve | 19407 | 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 | 23.859 | Gopher Canyon Reserve | 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 | |
6785 | 6785 | 6784 | {"type": "Polygon", "coordinates": [[[-117.25752, 33.40873], [-117.25323, 33.40878], [-117.25324, 33.41265], [-117.24915, 33.41271], [-117.24922, 33.40887], [-117.24932, 33.40872], [-117.24939, 33.40856], [-117.24945, 33.40837], [-117.24947, 33.40824], [-117.24939, 33.40734], [-117.24924, 33.40619], [-117.24924, 33.4061], [-117.24935, 33.40529], [-117.24926, 33.40393], [-117.24924, 33.40289], [-117.24928, 33.40267], [-117.24932, 33.40252], [-117.24946, 33.40219], [-117.24965, 33.40189], [-117.25008, 33.4014], [-117.25014, 33.40129], [-117.2503, 33.40084], [-117.2503, 33.40072], [-117.25027, 33.40062], [-117.25028, 33.40061], [-117.25015, 33.40032], [-117.25013, 33.4002], [-117.25023, 33.3996], [-117.25023, 33.39948], [-117.25019, 33.39938], [-117.25013, 33.39929], [-117.24996, 33.39916], [-117.25256, 33.39932], [-117.25255, 33.39925], [-117.25239, 33.39903], [-117.25238, 33.39893], [-117.25242, 33.39881], [-117.25252, 33.3987], [-117.25256, 33.39862], [-117.25258, 33.39847], [-117.25682, 33.39851], [-117.25613, 33.40205], [-117.25582, 33.40206], [-117.25572, 33.40275], [-117.25524, 33.4065], [-117.2575, 33.40647], [-117.25752, 33.40873]]]} | Open Access 1 | 5282 | Santa Margarita Preserve | 25099 | 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/SantaMargarita.html | San Diego 4 | 211.224 | Santa Margarita 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]);