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 ACRES
This data as json, copyable, CSV (advanced)
ACCESS_TYP 3
MNG_AG_TYP 1
MNG_AGENCY 1
- San Diego, County of · 37 ✖
DES_TP 1
- Local Conservation Area · 37 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
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 |
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 | |
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 | |
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 | |
15953 | 15953 | 15952 | {"type": "MultiPolygon", "coordinates": [[[[-117.124, 33.02413], [-117.12257, 33.02413], [-117.12257, 33.02322], [-117.124, 33.02355], [-117.124, 33.02413]]], [[[-117.13535, 33.02536], [-117.13525, 33.02933], [-117.13012, 33.02935], [-117.13012, 33.02888], [-117.12976, 33.02888], [-117.12976, 33.02694], [-117.12954, 33.02684], [-117.12933, 33.02663], [-117.12881, 33.02639], [-117.12849, 33.0263], [-117.12825, 33.02611], [-117.12803, 33.02617], [-117.12759, 33.02615], [-117.12683, 33.02594], [-117.12697, 33.02576], [-117.12691, 33.02569], [-117.12678, 33.02585], [-117.12597, 33.02557], [-117.12573, 33.02631], [-117.12505, 33.02622], [-117.12441, 33.02566], [-117.12413, 33.02585], [-117.12413, 33.02513], [-117.12463, 33.02513], [-117.12549, 33.02508], [-117.12609, 33.02509], [-117.1261, 33.02455], [-117.12475, 33.0242], [-117.12512, 33.02389], [-117.12563, 33.02406], [-117.12575, 33.02402], [-117.1259, 33.02408], [-117.12601, 33.02406], [-117.12607, 33.02423], [-117.1261, 33.02424], [-117.12689, 33.02403], [-117.12791, 33.02407], [-117.12785, 33.02453], [-117.12792, 33.02502], [-117.12834, 33.02606], [-117.12851, 33.02619], [-117.12893, 33.02618], [-117.12934, 33.02647], [-117.12986, 33.02668], [-117.13013, 33.02675], [-117.13114, 33.02674], [-117.1319, 33.02662], [-117.1321, 33.02653], [-117.13217, 33.02657], [-117.13251, 33.02641], [-117.13264, 33.02673], [-117.13301, 33.027], [-117.13325, 33.02706], [-117.13334, 33.02696], [-117.13342, 33.0267], [-117.13415, 33.02595], [-117.13498, 33.02538], [-117.13535, 33.02536]]], [[[-117.13541, 33.02216], [-117.13536, 33.02509], [-117.13519, 33.02509], [-117.13423, 33.02439], [-117.13423, 33.02404], [-117.13391, 33.02364], [-117.13391, 33.02355], [-117.13422, 33.02335], [-117.13425, 33.02292], [-117.13427, 33.02218], [-117.13541, 33.02216]]]]} | Open Access 1 | 44866 | Santa Fe Valley Open Space Preserve | 25091 | 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 | 67.159 | Santa Fe Valley OSP | 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 | |
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 |
7963 | 7963 | 7962 | {"type": "MultiPolygon", "coordinates": [[[[-116.96231, 32.5888], [-116.95891, 32.58979], [-116.96013, 32.59278], [-116.95959, 32.59293], [-116.95911, 32.5929], [-116.95864, 32.593], [-116.95789, 32.59309], [-116.95733, 32.59319], [-116.95703, 32.59325], [-116.95686, 32.59339], [-116.95657, 32.59347], [-116.95598, 32.59351], [-116.95514, 32.59365], [-116.95421, 32.59393], [-116.95377, 32.59419], [-116.95265, 32.59474], [-116.95221, 32.59489], [-116.95194, 32.59494], [-116.9508, 32.59216], [-116.95833, 32.58995], [-116.95639, 32.58888], [-116.95595, 32.58857], [-116.9523, 32.58586], [-116.95369, 32.58588], [-116.96222, 32.58619], [-116.96231, 32.5888]]], [[[-116.96197, 32.5973], [-116.96128, 32.5975], [-116.96123, 32.59737], [-116.96109, 32.59724], [-116.96094, 32.5972], [-116.96072, 32.59721], [-116.96053, 32.59726], [-116.96038, 32.59735], [-116.96029, 32.59743], [-116.96024, 32.59751], [-116.9602, 32.59766], [-116.96014, 32.59775], [-116.96003, 32.59785], [-116.95988, 32.59786], [-116.95969, 32.5978], [-116.95952, 32.59771], [-116.95914, 32.59765], [-116.95898, 32.59758], [-116.95875, 32.59759], [-116.95844, 32.59767], [-116.95811, 32.59787], [-116.95753, 32.5982], [-116.95669, 32.59855], [-116.95642, 32.59876], [-116.95623, 32.59892], [-116.95384, 32.59959], [-116.95285, 32.59719], [-116.95353, 32.59743], [-116.95424, 32.59722], [-116.95498, 32.59694], [-116.95604, 32.59641], [-116.95638, 32.5962], [-116.95675, 32.59608], [-116.95783, 32.59581], [-116.9586, 32.59566], [-116.95917, 32.59523], [-116.95938, 32.59502], [-116.96077, 32.59435], [-116.96197, 32.5973]]]]} | Restricted Access 2 | 47729 | Otay Ranch Preserve | 31529 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/openspace/Otay_Ranch.html | San Diego 4 | 179.037 | Otay Ranch 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 |
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 |
12242 | 12242 | 12241 | {"type": "MultiPolygon", "coordinates": [[[[-117.18634, 33.08768], [-117.18422, 33.08768], [-117.18424, 33.08862], [-117.1842, 33.09134], [-117.18211, 33.09133], [-117.18197, 33.09493], [-117.17742, 33.09493], [-117.17755, 33.08762], [-117.17527, 33.08759], [-117.17541, 33.08587], [-117.17429, 33.08585], [-117.17445, 33.08402], [-117.17778, 33.08404], [-117.17803, 33.08039], [-117.17905, 33.08039], [-117.18143, 33.08206], [-117.18122, 33.08316], [-117.17997, 33.08494], [-117.1802, 33.08476], [-117.18126, 33.08458], [-117.18138, 33.08479], [-117.18209, 33.08429], [-117.1826, 33.08426], [-117.1827, 33.08451], [-117.18264, 33.08506], [-117.18284, 33.08558], [-117.18309, 33.08538], [-117.18327, 33.08488], [-117.18313, 33.08447], [-117.18316, 33.08417], [-117.18324, 33.08408], [-117.18445, 33.08407], [-117.18504, 33.08445], [-117.18538, 33.08469], [-117.18565, 33.08491], [-117.18581, 33.08507], [-117.18633, 33.08568], [-117.18634, 33.08768]]], [[[-117.18635, 33.08529], [-117.186, 33.08489], [-117.18581, 33.08472], [-117.18524, 33.08429], [-117.18491, 33.08407], [-117.18633, 33.08407], [-117.18635, 33.08529]]]]} | No Public Access 3 | 25447 | Sage Hill Preserve | 29254 | 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 | 231.523 | Sage Hill 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 |
14608 | 14608 | 14607 | {"type": "MultiPolygon", "coordinates": [[[[-117.14468, 32.93894], [-117.14052, 32.93899], [-117.14057, 32.93988], [-117.13978, 32.93993], [-117.13697, 32.94021], [-117.13424, 32.94028], [-117.13399, 32.94024], [-117.13382, 32.94026], [-117.13366, 32.94039], [-117.13345, 32.94061], [-117.13322, 32.94079], [-117.13311, 32.94085], [-117.13284, 32.94094], [-117.13257, 32.94096], [-117.13182, 32.9409], [-117.131, 32.9409], [-117.13065, 32.94087], [-117.13032, 32.94074], [-117.13004, 32.94058], [-117.12976, 32.9405], [-117.12959, 32.94047], [-117.12929, 32.94047], [-117.12927, 32.94039], [-117.12922, 32.94039], [-117.12887, 32.93931], [-117.12873, 32.93902], [-117.12858, 32.93879], [-117.12808, 32.93813], [-117.12695, 32.93676], [-117.12904, 32.93619], [-117.12976, 32.93634], [-117.13003, 32.93637], [-117.13116, 32.93622], [-117.13225, 32.93618], [-117.13369, 32.93583], [-117.13409, 32.93549], [-117.13406, 32.93501], [-117.13567, 32.93494], [-117.13568, 32.93482], [-117.13675, 32.93478], [-117.13631, 32.93532], [-117.13604, 32.9357], [-117.13604, 32.93572], [-117.13916, 32.93565], [-117.13942, 32.93485], [-117.14136, 32.93576], [-117.14268, 32.93569], [-117.14408, 32.93456], [-117.14434, 32.93456], [-117.14467, 32.93605], [-117.14468, 32.93894]]], [[[-117.16982, 32.94862], [-117.16683, 32.94859], [-117.16682, 32.94854], [-117.16512, 32.94853], [-117.1651, 32.94814], [-117.1651, 32.94682], [-117.16714, 32.94686], [-117.16715, 32.94642], [-117.16771, 32.94614], [-117.16748, 32.94568], [-117.16713, 32.94559], [-117.16713, 32.94514], [-117.16961, 32.94511], [-117.16982, 32.94862]]], [[[-117.20536, 32.90698], [-117.20535, 32.90716], [-117.20503, 32.90727], [-117.20468, 32.90741], [-117.20434, 32.90758], [-117.20409, 32.90773], [-117.20365, 32.90805], [-117.20281, 32.9088], [-117.20259, 32.90878], [-117.20241, 32.90878], [-117.20204, 32.90881], [-117.20188, 32.90885], [-117.2017, 32.90891], [-117.20152, 32.90899], [-117.20141, 32.90907], [-117.20137, 32.90907], [-117.20022, 32.9076], [-117.20351, 32.90659], [-117.20536, 32.90698]]], [[[-117.21151, 32.90728], [-117.21058, 32.90768], [-117.20851, 32.90765], [-117.20853, 32.90715], [-117.20941, 32.90736], [-117.2101, 32.90743], [-117.21034, 32.90744], [-117.21078, 32.90741], [-117.21102, 32.90738], [-117.21151, 32.90728]]], [[[-117.21354, 32.90559], [-117.21337, 32.90582], [-117.21319, 32.90601], [-117.21282, 32.90632], [-117.21267, 32.90643], [-117.21224, 32.9067], [-117.21204, 32.90679], [-117.21184, 32.90688], [-117.21139, 32.90702], [-117.2109, 32.90712], [-117.21041, 32.90716], [-117.21014, 32.90717], [-117.20989, 32.90715], [-117.20934, 32.90707], [-117.20855, 32.90687], [-117.2086, 32.90558], [-117.21354, 32.90559]]], [[[-117.21547, 32.9056], [-117.2135, 32.90694], [-117.21235, 32.90695], [-117.21262, 32.90681], [-117.21289, 32.90664], [-117.21336, 32.90626], [-117.21351, 32.90611], [-117.21364, 32.90594], [-117.21378, 32.90576], [-117.21389, 32.90559], [-117.21547, 32.9056]]]]} | Open Access 1 | 44831 | Los Penasquitos Canyon Preserve | 21528 | 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/LosPenasquitos.html | San Diego 4 | 255.079 | Los Penasquitos Canyon Preserve | 0 | 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 | |
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 | |
13205 | 13205 | 13204 | {"type": "MultiPolygon", "coordinates": [[[[-116.92352, 32.60821], [-116.9235, 32.61195], [-116.91216, 32.61202], [-116.91078, 32.61199], [-116.91094, 32.61568], [-116.90658, 32.61567], [-116.90666, 32.61927], [-116.90219, 32.61927], [-116.90214, 32.61198], [-116.91078, 32.61199], [-116.9108, 32.60449], [-116.91928, 32.60446], [-116.91928, 32.6082], [-116.92352, 32.60821]]], [[[-116.91632, 32.65562], [-116.91629, 32.65938], [-116.91356, 32.65931], [-116.91311, 32.65864], [-116.91287, 32.65836], [-116.91254, 32.65791], [-116.91207, 32.65716], [-116.91169, 32.65659], [-116.91154, 32.65645], [-116.91128, 32.65626], [-116.91056, 32.65556], [-116.91239, 32.65554], [-116.91632, 32.65562]]]]} | Open Access 1 | 45236 | Otay Ranch Preserve | 10734 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/pds/mscp/or.html | San Diego 4 | 368.875 | Otay Ranch Preserve | 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 |
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]);