units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
37 rows where GAP_STS = 2, MNG_AGENCY = 101 and MNG_AG_TYP = 3
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, PARK_URL, YR_EST
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
| 1560 | 1560 | 1559 | {"type": "MultiPolygon", "coordinates": [[[[-116.67869, 33.12778], [-116.67507, 33.1291], [-116.67083, 33.12914], [-116.66826, 33.12896], [-116.66617, 33.12917], [-116.66555, 33.12932], [-116.66459, 33.12981], [-116.66349, 33.13111], [-116.66203, 33.13263], [-116.66257, 33.13857], [-116.65983, 33.1441], [-116.65087, 33.13807], [-116.64428, 33.13531], [-116.64222, 33.13439], [-116.64213, 33.13433], [-116.64207, 33.13431], [-116.64201, 33.13432], [-116.63822, 33.13266], [-116.63537, 33.13001], [-116.62768, 33.12661], [-116.61609, 33.1216], [-116.61608, 33.1216], [-116.6161, 33.12308], [-116.60157, 33.12331], [-116.60159, 33.12309], [-116.60164, 33.12292], [-116.60177, 33.12264], [-116.60204, 33.12221], [-116.60219, 33.12188], [-116.6028, 33.11983], [-116.60294, 33.11942], [-116.61572, 33.10683], [-116.61854, 33.10692], [-116.63257, 33.10687], [-116.63264, 33.10942], [-116.63262, 33.11709], [-116.63264, 33.11777], [-116.63951, 33.11478], [-116.63967, 33.11501], [-116.64538, 33.11233], [-116.64539, 33.11232], [-116.64534, 33.11224], [-116.64807, 33.11104], [-116.65016, 33.11031], [-116.65016, 33.10895], [-116.65283, 33.10895], [-116.65665, 33.10729], [-116.6568, 33.10743], [-116.65693, 33.10752], [-116.65708, 33.1076], [-116.65724, 33.10766], [-116.65756, 33.10773], [-116.65784, 33.10773], [-116.65788, 33.1078], [-116.65812, 33.10777], [-116.65812, 33.10769], [-116.65843, 33.10758], [-116.6587, 33.10742], [-116.65882, 33.10731], [-116.65895, 33.10714], [-116.65905, 33.10696], [-116.65909, 33.1068], [-116.65913, 33.10621], [-116.66452, 33.10387], [-116.66715, 33.10274], [-116.66726, 33.1029], [-116.66744, 33.10304], [-116.66752, 33.10314], [-116.66774, 33.10343], [-116.6679, 33.10373], [-116.66802, 33.10409], [-116.66808, 33.1044], [-116.66808, 33.10477], [-116.66803, 33.10504], [-116.66778, 33.10603], [-116.66776, 33.10634], [-116.66779, 33.10659], [-116.66782, 33.10675], [-116.6679, 33.10696], [-116.66874, 33.10895], [-116.66871, 33.10899], [-116.66882, 33.10921], [-116.66748, 33.10958], [-116.66806, 33.11096], [-116.6704, 33.11028], [-116.67082, 33.11127], [-116.67421, 33.1103], [-116.67598, 33.11473], [-116.67648, 33.11617], [-116.67686, 33.1175], [-116.67738, 33.12013], [-116.67869, 33.12778]]], [[[-116.65874, 33.10638], [-116.65872, 33.10671], [-116.65869, 33.10681], [-116.65863, 33.10695], [-116.65855, 33.10706], [-116.65843, 33.10719], [-116.65831, 33.10728], [-116.65819, 33.10736], [-116.65812, 33.10733], [-116.65786, 33.10737], [-116.65781, 33.10743], [-116.65751, 33.10742], [-116.65733, 33.10737], [-116.65713, 33.1073], [-116.65696, 33.10715], [-116.65874, 33.10638]]], [[[-116.72151, 33.13325], [-116.71595, 33.13859], [-116.70914, 33.13903], [-116.70195, 33.13862], [-116.69711, 33.13219], [-116.69318, 33.12693], [-116.69264, 33.12424], [-116.68438, 33.12422], [-116.6784, 33.12414], [-116.67819, 33.12293], [-116.68439, 33.12295], [-116.70166, 33.12273], [-116.70167, 33.12271], [-116.7084, 33.12261], [-116.70589, 33.11347], [-116.70159, 33.10945], [-116.69487, 33.10266], [-116.69544, 33.10219], [-116.69685, 33.10083], [-116.69907, 33.09843], [-116.69941, 33.09801], [-116.69975, 33.09756], [-116.70055, 33.0964], [-116.70072, 33.09608], [-116.70092, 33.09561], [-116.7011, 33.09529], [-116.7021, 33.09356], [-116.70233, 33.09324], [-116.70258, 33.09301], [-116.70399, 33.09204], [-116.70418, 33.09185], [-116.70443, 33.09149], [-116.70462, 33.09129], [-116.70478, 33.09116], [-116.70551, 33.09069], [-116.70566, 33.09057], [-116.7058, 33.09043], [-116.70592, 33.09025], [-116.70598, 33.09009], [-116.70626, 33.08876], [-116.70719, 33.08867], [-116.70708, 33.10671], [-116.70849, 33.10944], [-116.71004, 33.11173], [-116.71661, 33.12406], [-116.71794, 33.12675], [-116.71988, 33.13024], [-116.72151, 33.13325]]]]} | Open Access 1 | 11729 | Santa Ysabel Preserve | 29255 | 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/SantaYsabel.html | San Diego 4 | 5407.378 | Santa Ysabel 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 | |
| 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 |
| 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 |
| 6086 | 6086 | 6085 | {"type": "MultiPolygon", "coordinates": [[[[-117.00116, 33.01884], [-116.99647, 33.01886], [-116.99635, 33.01507], [-117.00112, 33.01494], [-117.00116, 33.01884]]], [[[-117.01695, 33.01451], [-117.01452, 33.01459], [-117.00983, 33.01471], [-117.00983, 33.01458], [-117.01035, 33.01452], [-117.01054, 33.01217], [-117.01092, 33.01197], [-117.01481, 33.01197], [-117.01603, 33.01335], [-117.01695, 33.01451]]]]} | Restricted Access 2 | 891 | Blue Sky Ecological Reserve | 29220 | 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 | 83.938 | Blue Sky ER | 1991 | Local Conservation Area 4 | 2 | |
| 6171 | 6171 | 6170 | {"type": "Polygon", "coordinates": [[[-116.29585, 33.26389], [-116.28718, 33.26345], [-116.28666, 33.25667], [-116.28614, 33.24923], [-116.29523, 33.25029], [-116.29514, 33.2503], [-116.29515, 33.25033], [-116.29516, 33.25762], [-116.29517, 33.25777], [-116.29534, 33.25778], [-116.29585, 33.26389]]]} | Open Access 1 | 1189 | Old Springs Road Open Space Preserve | 29251 | 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 | 307.721 | Old Springs Road OSP | 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 | |
| 6269 | 6269 | 6268 | {"type": "MultiPolygon", "coordinates": [[[[-116.98966, 32.91956], [-116.98937, 32.91956], [-116.9895, 32.9339], [-116.98364, 32.93398], [-116.98356, 32.9343], [-116.98403, 32.93561], [-116.98442, 32.93603], [-116.98441, 32.93658], [-116.98424, 32.93807], [-116.98354, 32.93871], [-116.98159, 32.94012], [-116.98109, 32.94034], [-116.98048, 32.93979], [-116.98033, 32.93986], [-116.98058, 32.9412], [-116.97817, 32.94117], [-116.97813, 32.943], [-116.97815, 32.94301], [-116.97847, 32.94277], [-116.97891, 32.9428], [-116.97894, 32.94363], [-116.97912, 32.94418], [-116.97809, 32.9459], [-116.97938, 32.9459], [-116.98105, 32.94585], [-116.98105, 32.94859], [-116.97935, 32.94853], [-116.97058, 32.94833], [-116.97082, 32.94447], [-116.97099, 32.94104], [-116.96183, 32.94088], [-116.96174, 32.93343], [-116.95747, 32.93346], [-116.95777, 32.92622], [-116.96202, 32.92624], [-116.96229, 32.91927], [-116.96218, 32.91552], [-116.95771, 32.9155], [-116.95773, 32.9085], [-116.96197, 32.90851], [-116.96182, 32.9035], [-116.97162, 32.90168], [-116.97155, 32.91577], [-116.9809, 32.91574], [-116.98072, 32.90852], [-116.98503, 32.90855], [-116.98502, 32.90763], [-116.98936, 32.90765], [-116.98938, 32.90859], [-116.98504, 32.90855], [-116.98507, 32.91031], [-116.98943, 32.91034], [-116.98966, 32.91956]]], [[[-116.96655, 32.94369], [-116.9663, 32.94401], [-116.96603, 32.94429], [-116.96578, 32.9445], [-116.96516, 32.94497], [-116.96477, 32.94521], [-116.96302, 32.94614], [-116.96296, 32.94615], [-116.96292, 32.94612], [-116.96269, 32.94584], [-116.96241, 32.94553], [-116.96213, 32.94526], [-116.96188, 32.94506], [-116.96187, 32.94452], [-116.96109, 32.94453], [-116.96052, 32.94424], [-116.959, 32.94362], [-116.95841, 32.94333], [-116.95808, 32.94313], [-116.95775, 32.94291], [-116.95774, 32.94223], [-116.961, 32.94226], [-116.96099, 32.94127], [-116.96649, 32.9413], [-116.96655, 32.94369]]], [[[-116.9654, 32.94517], [-116.96539, 32.94575], [-116.96341, 32.94681], [-116.96315, 32.94645], [-116.96315, 32.94639], [-116.96318, 32.94636], [-116.965, 32.94542], [-116.9654, 32.94517]]], [[[-116.98432, 32.90496], [-116.98062, 32.90494], [-116.98042, 32.90307], [-116.9843, 32.90304], [-116.98432, 32.90496]]], [[[-116.98934, 32.90675], [-116.98501, 32.90674], [-116.98498, 32.90496], [-116.98929, 32.90498], [-116.98934, 32.90675]]]]} | Open Access 1 | 1358 | Goodan Ranch Sycamore Canyon Preserve | 29238 | 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/GoodanSycamore.html | San Diego 4 | 2571.686 | Goodan Ranch Sycamore Canyon 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 |
| 6802 | 6802 | 6801 | {"type": "MultiPolygon", "coordinates": [[[[-116.91462, 33.22682], [-116.91453, 33.23359], [-116.91037, 33.23358], [-116.91038, 33.23708], [-116.90136, 33.23707], [-116.90139, 33.227], [-116.90169, 33.22659], [-116.91067, 33.22678], [-116.91462, 33.22682]]], [[[-116.92783, 33.19759], [-116.92778, 33.20078], [-116.92782, 33.2009], [-116.92779, 33.20311], [-116.9278, 33.20838], [-116.91504, 33.20852], [-116.91746, 33.20521], [-116.92314, 33.19761], [-116.92783, 33.19759]]], [[[-116.96695, 33.2241], [-116.96284, 33.22408], [-116.96285, 33.22763], [-116.96266, 33.23129], [-116.95379, 33.23114], [-116.95353, 33.23836], [-116.95793, 33.23848], [-116.95778, 33.2421], [-116.94485, 33.24154], [-116.92792, 33.2417], [-116.91891, 33.24172], [-116.91909, 33.2343], [-116.91916, 33.23058], [-116.92233, 33.23056], [-116.92215, 33.23127], [-116.92182, 33.2315], [-116.92221, 33.23241], [-116.92339, 33.23242], [-116.92344, 33.23055], [-116.92777, 33.23051], [-116.92787, 33.22694], [-116.93242, 33.22711], [-116.93206, 33.22005], [-116.93192, 33.2162], [-116.93202, 33.2162], [-116.93202, 33.21615], [-116.93604, 33.21632], [-116.93838, 33.21647], [-116.94032, 33.21654], [-116.94079, 33.22037], [-116.94526, 33.22053], [-116.9496, 33.22055], [-116.94957, 33.22402], [-116.95836, 33.22405], [-116.95837, 33.22057], [-116.96282, 33.22058], [-116.96695, 33.22052], [-116.96695, 33.2241]], [[-116.9453, 33.22652], [-116.94303, 33.22648], [-116.943, 33.22742], [-116.9453, 33.22745], [-116.9453, 33.22652]]]]} | Open Access 1 | 5317 | Hellhole Canyon Preserve | 29239 | 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/HellholeCanyon.html | San Diego 4 | 2451.423 | Hellhole Canyon 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 | |
| 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 |
| 6918 | 6918 | 6917 | {"type": "MultiPolygon", "coordinates": [[[[-117.23536, 33.03391], [-117.23513, 33.03422], [-117.2342, 33.03397], [-117.23474, 33.03348], [-117.23477, 33.03348], [-117.23517, 33.03379], [-117.23536, 33.03391]]], [[[-117.23609, 33.03514], [-117.23555, 33.03678], [-117.23459, 33.03653], [-117.23477, 33.03601], [-117.23609, 33.03514]]], [[[-117.23732, 33.03115], [-117.23555, 33.03272], [-117.23531, 33.03354], [-117.23553, 33.03368], [-117.23569, 33.03369], [-117.23557, 33.03381], [-117.23525, 33.0336], [-117.23497, 33.03337], [-117.23493, 33.03326], [-117.23496, 33.03324], [-117.2351, 33.03295], [-117.23513, 33.03282], [-117.23514, 33.0326], [-117.23511, 33.03241], [-117.23505, 33.03223], [-117.23496, 33.03209], [-117.23577, 33.03136], [-117.23603, 33.03158], [-117.23624, 33.0314], [-117.23625, 33.03135], [-117.23668, 33.03095], [-117.23612, 33.03046], [-117.23629, 33.0303], [-117.23732, 33.03115]]], [[[-117.24184, 33.03031], [-117.24168, 33.03057], [-117.24148, 33.03079], [-117.24127, 33.03094], [-117.24071, 33.03129], [-117.24106, 33.03011], [-117.24184, 33.03031]]], [[[-117.27719, 33.00739], [-117.27719, 33.00739], [-117.27717, 33.00818], [-117.27696, 33.00739], [-117.27719, 33.00739]]], [[[-117.27882, 33.01168], [-117.27819, 33.01179], [-117.27803, 33.01121], [-117.27846, 33.01114], [-117.2784, 33.01123], [-117.2784, 33.01129], [-117.27872, 33.01159], [-117.2788, 33.01158], [-117.27882, 33.01168]]]]} | Open Access 1 | 724 | San Elijo Lagoon Ecological Reserve | 24878 | 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/SanElijo.html | San Diego 4 | 12.338 | San Elijo Lagoon ER | 1983 | Local Conservation Area 4 | 2 |
| 7109 | 7109 | 7108 | {"type": "MultiPolygon", "coordinates": [[[[-116.88462, 32.91635], [-116.88184, 32.91632], [-116.88177, 32.91164], [-116.88174, 32.91156], [-116.88176, 32.9108], [-116.88173, 32.90896], [-116.88411, 32.90898], [-116.88487, 32.91321], [-116.88487, 32.91346], [-116.88462, 32.91635]]], [[[-116.90743, 32.91287], [-116.90741, 32.91652], [-116.90314, 32.91651], [-116.90316, 32.92005], [-116.89739, 32.92002], [-116.89018, 32.92002], [-116.89019, 32.91943], [-116.88957, 32.91944], [-116.88966, 32.91642], [-116.88483, 32.91635], [-116.88507, 32.91354], [-116.88507, 32.91322], [-116.88501, 32.91285], [-116.88481, 32.91175], [-116.89029, 32.91174], [-116.89031, 32.90899], [-116.89462, 32.90904], [-116.8947, 32.91274], [-116.90743, 32.91287]]]]} | Open Access 1 | 6185 | Oakoasis Preserve | 29250 | 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/Oakoasis.html | San Diego 4 | 443.34 | Oakoasis Preserve | 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 |
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]);