units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
26 rows where ACCESS_TYP = 1, DES_TP = 4 and MNG_AGENCY = 101
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
MNG_AGENCY 1
- San Diego, County of · 12 ✖
DES_TP 1
- Local Conservation Area · 12 ✖
ACCESS_TYP 1
- Open Access · 12 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7407 | 7407 | 7406 | {"type": "MultiPolygon", "coordinates": [[[[-116.92757, 33.0656], [-116.92344, 33.06562], [-116.92331, 33.06922], [-116.92324, 33.0692], [-116.91503, 33.0691], [-116.91516, 33.06562], [-116.91502, 33.06561], [-116.91536, 33.05416], [-116.91053, 33.05147], [-116.91053, 33.04782], [-116.90649, 33.04778], [-116.90482, 33.04779], [-116.90481, 33.04762], [-116.90634, 33.04761], [-116.9063, 33.04319], [-116.91054, 33.0432], [-116.91057, 33.04412], [-116.92332, 33.04382], [-116.9233, 33.04181], [-116.92753, 33.04244], [-116.92754, 33.04372], [-116.92749, 33.04509], [-116.92746, 33.04986], [-116.92755, 33.05108], [-116.92763, 33.05833], [-116.92756, 33.06196], [-116.92757, 33.0656]]], [[[-116.93601, 33.03652], [-116.93073, 33.03647], [-116.92754, 33.03643], [-116.92752, 33.03644], [-116.92731, 33.03645], [-116.92737, 33.03962], [-116.91043, 33.03711], [-116.9102, 33.0296], [-116.91019, 33.02797], [-116.91012, 33.02594], [-116.91323, 33.02589], [-116.91342, 33.02951], [-116.91449, 33.02948], [-116.9146, 33.03312], [-116.91887, 33.033], [-116.91878, 33.02936], [-116.92752, 33.02912], [-116.92753, 33.02855], [-116.93283, 33.0301], [-116.9334, 33.03109], [-116.93182, 33.03106], [-116.93182, 33.03196], [-116.93601, 33.03206], [-116.93601, 33.03652]]], [[[-116.9673, 33.07317], [-116.96318, 33.07321], [-116.96246, 33.0732], [-116.95431, 33.07292], [-116.94985, 33.0728], [-116.95008, 33.0765], [-116.94558, 33.07649], [-116.94537, 33.07261], [-116.94514, 33.06916], [-116.93635, 33.06921], [-116.93206, 33.06931], [-116.93207, 33.06563], [-116.9449, 33.0657], [-116.94481, 33.05845], [-116.93614, 33.05838], [-116.93609, 33.0511], [-116.94461, 33.05108], [-116.9569, 33.05119], [-116.95686, 33.04913], [-116.94648, 33.04762], [-116.94656, 33.04718], [-116.94955, 33.04471], [-116.94864, 33.04308], [-116.94486, 33.04306], [-116.94209, 33.04308], [-116.94205, 33.04096], [-116.94204, 33.03821], [-116.93764, 33.03588], [-116.9362, 33.03588], [-116.93619, 33.03301], [-116.94553, 33.03316], [-116.95749, 33.03329], [-116.95744, 33.0405], [-116.95735, 33.04765], [-116.96188, 33.04771], [-116.96191, 33.05133], [-116.96208, 33.05497], [-116.96668, 33.055], [-116.96674, 33.05881], [-116.96679, 33.06251], [-116.96243, 33.06256], [-116.96237, 33.06154], [-116.95791, 33.06161], [-116.95798, 33.06557], [-116.96257, 33.06566], [-116.96715, 33.0657], [-116.9673, 33.07317]]]]} | Open Access 1 | 47592 | Ramona Grasslands Preserve | 31319 | 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 | 3490.938 | Ramona Grasslands Preserve | 0 | Local Conservation Area 4 | 2 | |
7603 | 7603 | 7602 | {"type": "MultiPolygon", "coordinates": [[[[-117.14805, 33.08584], [-117.14789, 33.0859], [-117.14775, 33.08597], [-117.14704, 33.08645], [-117.14671, 33.08662], [-117.14508, 33.08435], [-117.13959, 33.08443], [-117.13958, 33.08442], [-117.13958, 33.08754], [-117.13651, 33.08756], [-117.12968, 33.08756], [-117.12962, 33.09117], [-117.12315, 33.09115], [-117.12313, 33.08756], [-117.11888, 33.08755], [-117.11889, 33.08746], [-117.11885, 33.08602], [-117.1189, 33.08492], [-117.11888, 33.08399], [-117.11911, 33.08376], [-117.11915, 33.08376], [-117.11941, 33.08344], [-117.11939, 33.08342], [-117.1194, 33.08339], [-117.11947, 33.0833], [-117.11965, 33.083], [-117.11982, 33.08265], [-117.11992, 33.08237], [-117.12041, 33.08055], [-117.12047, 33.08025], [-117.12056, 33.07972], [-117.12075, 33.07971], [-117.12076, 33.07899], [-117.12108, 33.07898], [-117.12106, 33.07836], [-117.12084, 33.07835], [-117.1211, 33.07661], [-117.12112, 33.07652], [-117.12116, 33.07652], [-117.1212, 33.07624], [-117.12126, 33.07623], [-117.12136, 33.07562], [-117.12131, 33.0756], [-117.12133, 33.07547], [-117.1213, 33.07546], [-117.12141, 33.07449], [-117.12151, 33.07448], [-117.12178, 33.07265], [-117.1219, 33.07198], [-117.12179, 33.07194], [-117.12245, 33.06783], [-117.12255, 33.06782], [-117.12257, 33.06767], [-117.12265, 33.06739], [-117.12276, 33.06717], [-117.1229, 33.06695], [-117.12283, 33.06691], [-117.1229, 33.06681], [-117.12305, 33.06665], [-117.12318, 33.06653], [-117.12349, 33.06632], [-117.12368, 33.06617], [-117.12387, 33.06596], [-117.12401, 33.06571], [-117.12412, 33.0657], [-117.12411, 33.06544], [-117.12415, 33.06519], [-117.12415, 33.06479], [-117.12423, 33.06438], [-117.12603, 33.06455], [-117.12788, 33.06455], [-117.12814, 33.0646], [-117.12826, 33.0646], [-117.12862, 33.06454], [-117.12897, 33.06451], [-117.12907, 33.06454], [-117.12925, 33.06468], [-117.12939, 33.06474], [-117.12952, 33.06476], [-117.1298, 33.06475], [-117.13004, 33.06483], [-117.13017, 33.06485], [-117.1304, 33.06485], [-117.13053, 33.06486], [-117.13064, 33.0649], [-117.13091, 33.06506], [-117.12933, 33.06755], [-117.1271, 33.06756], [-117.12711, 33.07295], [-117.12718, 33.0802], [-117.13631, 33.08017], [-117.13631, 33.08116], [-117.13629, 33.08152], [-117.13633, 33.08392], [-117.13957, 33.08391], [-117.13955, 33.08019], [-117.14401, 33.08032], [-117.14803, 33.08027], [-117.14803, 33.08388], [-117.14805, 33.08584]]], [[[-117.13193, 33.06024], [-117.1319, 33.06349], [-117.13096, 33.06498], [-117.13069, 33.06483], [-117.13055, 33.06478], [-117.13042, 33.06477], [-117.1302, 33.06477], [-117.13006, 33.06475], [-117.1298, 33.06467], [-117.12954, 33.06467], [-117.12941, 33.06466], [-117.12927, 33.06459], [-117.12914, 33.06448], [-117.129, 33.06443], [-117.12886, 33.06443], [-117.12866, 33.06445], [-117.12833, 33.06451], [-117.12823, 33.06452], [-117.12769, 33.06443], [-117.12734, 33.0643], [-117.12689, 33.06409], [-117.12647, 33.06398], [-117.12639, 33.06391], [-117.12638, 33.06383], [-117.12642, 33.06376], [-117.12671, 33.06361], [-117.12679, 33.06353], [-117.12685, 33.06345], [-117.12688, 33.06336], [-117.12692, 33.0627], [-117.1271, 33.06259], [-117.12723, 33.06248], [-117.12759, 33.06209], [-117.12771, 33.06199], [-117.12786, 33.06191], [-117.12802, 33.06185], [-117.12849, 33.06178], [-117.12867, 33.06172], [-117.12883, 33.06164], [-117.12904, 33.06148], [-117.12933, 33.06112], [-117.12945, 33.06102], [-117.12965, 33.06092], [-117.13193, 33.06024]]]]} | Open Access 1 | 7314 | Del Dios Highlands Preserve | 10675 | 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/DelDiosHighlands.html | San Diego 4 | 781.705 | Del Dios Highlands 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 |
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 |
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 |
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 |
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 |
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 |
15151 | 15151 | 15150 | {"type": "MultiPolygon", "coordinates": [[[[-116.88037, 32.99665], [-116.88033, 33.00055], [-116.87994, 33.00357], [-116.87945, 33.00359], [-116.87922, 33.00355], [-116.87884, 33.00359], [-116.87877, 33.00394], [-116.87546, 33.00405], [-116.87055, 33.0041], [-116.87056, 33.00098], [-116.87153, 33.00056], [-116.87167, 32.99946], [-116.87084, 32.99878], [-116.8659, 33.00008], [-116.86399, 33.00124], [-116.8635, 33.0014], [-116.86286, 32.99999], [-116.86269, 32.99974], [-116.86258, 32.99962], [-116.86244, 32.9995], [-116.8621, 32.99929], [-116.86006, 32.99861], [-116.85989, 32.99857], [-116.85935, 32.99846], [-116.85932, 32.99844], [-116.85743, 32.99818], [-116.85603, 32.99774], [-116.85585, 32.9977], [-116.85536, 32.99764], [-116.85323, 32.99762], [-116.85199, 32.99755], [-116.85178, 32.99756], [-116.85167, 32.99754], [-116.85119, 32.99758], [-116.85076, 32.99767], [-116.85055, 32.99772], [-116.84987, 32.99795], [-116.8499, 32.99391], [-116.85022, 32.9938], [-116.85051, 32.99367], [-116.85421, 32.99372], [-116.85422, 32.99384], [-116.85844, 32.99388], [-116.86869, 32.99391], [-116.8686, 32.98563], [-116.87533, 32.9856], [-116.87565, 32.99388], [-116.87771, 32.99389], [-116.87771, 32.99394], [-116.87778, 32.99394], [-116.87782, 32.99776], [-116.88037, 32.99665]]], [[[-116.86534, 33.00441], [-116.86282, 33.00443], [-116.86282, 33.00121], [-116.86091, 33.0005], [-116.86091, 33.0012], [-116.85836, 33.00125], [-116.85837, 32.99956], [-116.85825, 32.9995], [-116.84987, 33.00111], [-116.84989, 32.99819], [-116.85052, 32.9981], [-116.85507, 32.99781], [-116.85584, 32.99791], [-116.85649, 32.99809], [-116.85689, 32.99825], [-116.85706, 32.9983], [-116.85783, 32.99844], [-116.85827, 32.99849], [-116.85841, 32.99848], [-116.85929, 32.9986], [-116.8596, 32.99867], [-116.85999, 32.99877], [-116.86204, 32.99945], [-116.8623, 32.99961], [-116.86242, 32.99972], [-116.86256, 32.99987], [-116.86268, 33.00006], [-116.86378, 33.00245], [-116.86398, 33.00279], [-116.86425, 33.00308], [-116.86476, 33.0035], [-116.86507, 33.00383], [-116.86517, 33.00399], [-116.86525, 33.00417], [-116.86534, 33.00441]]], [[[-116.85006, 32.99368], [-116.85, 32.9937], [-116.84991, 32.99373], [-116.8499, 32.99368], [-116.85006, 32.99368]]], [[[-116.85253, 32.99779], [-116.85146, 32.99786], [-116.85061, 32.99791], [-116.85093, 32.99781], [-116.85141, 32.99774], [-116.85174, 32.99773], [-116.85253, 32.99779]]]]} | Open Access 1 | 45995 | Barnett Ranch Preserve | 29189 | 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/BarnettRanch.html | San Diego 4 | 717.785 | Barnett 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 | |
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 | |
16904 | 16904 | 16903 | {"type": "Polygon", "coordinates": [[[-116.60256, 33.11614], [-116.60251, 33.11629], [-116.6025, 33.11642], [-116.60251, 33.11657], [-116.60257, 33.11685], [-116.60258, 33.117], [-116.60257, 33.11722], [-116.60255, 33.11743], [-116.60256, 33.11766], [-116.6026, 33.11791], [-116.60279, 33.1185], [-116.60283, 33.11883], [-116.60281, 33.11911], [-116.60275, 33.11936], [-116.60235, 33.12066], [-116.60203, 33.12176], [-116.60181, 33.12225], [-116.60156, 33.12264], [-116.60149, 33.12276], [-116.60141, 33.12304], [-116.60137, 33.12331], [-116.59729, 33.12338], [-116.59745, 33.12582], [-116.59836, 33.12606], [-116.59831, 33.12672], [-116.5984, 33.12723], [-116.59856, 33.12787], [-116.59827, 33.12788], [-116.59829, 33.13385], [-116.59825, 33.13386], [-116.59825, 33.13536], [-116.58954, 33.13585], [-116.58956, 33.13743], [-116.58955, 33.1398], [-116.58984, 33.13987], [-116.59018, 33.1399], [-116.59043, 33.13989], [-116.59079, 33.13982], [-116.59097, 33.1399], [-116.59121, 33.14015], [-116.59132, 33.14024], [-116.59159, 33.14032], [-116.59206, 33.14036], [-116.59243, 33.14035], [-116.59276, 33.14024], [-116.59288, 33.14015], [-116.59301, 33.14001], [-116.59345, 33.1396], [-116.59359, 33.1396], [-116.5936, 33.13971], [-116.59354, 33.14001], [-116.59345, 33.14023], [-116.59334, 33.14043], [-116.59327, 33.14068], [-116.59366, 33.14037], [-116.59393, 33.14029], [-116.59414, 33.1403], [-116.59458, 33.14038], [-116.59477, 33.14049], [-116.59483, 33.14054], [-116.5949, 33.14068], [-116.59491, 33.1408], [-116.59498, 33.14091], [-116.59525, 33.14098], [-116.59573, 33.141], [-116.59628, 33.14097], [-116.59669, 33.1409], [-116.59708, 33.14078], [-116.59736, 33.14068], [-116.59629, 33.14299], [-116.59195, 33.14333], [-116.58527, 33.14393], [-116.58532, 33.14793], [-116.58097, 33.14827], [-116.58088, 33.14433], [-116.58525, 33.14393], [-116.58518, 33.14049], [-116.58576, 33.14155], [-116.58742, 33.1409], [-116.58577, 33.13801], [-116.58564, 33.13639], [-116.58331, 33.13704], [-116.58474, 33.13967], [-116.58504, 33.13966], [-116.58504, 33.14001], [-116.58079, 33.14029], [-116.5807, 33.13633], [-116.58033, 33.12927], [-116.58004, 33.12054], [-116.56782, 33.12137], [-116.56788, 33.12522], [-116.55932, 33.12575], [-116.55915, 33.12187], [-116.55967, 33.12183], [-116.55962, 33.1184], [-116.56364, 33.11824], [-116.56349, 33.10731], [-116.56766, 33.10716], [-116.56736, 33.09696], [-116.57145, 33.09689], [-116.57146, 33.09366], [-116.57968, 33.09373], [-116.58547, 33.09423], [-116.5858, 33.09441], [-116.58605, 33.09451], [-116.58624, 33.09454], [-116.58652, 33.09455], [-116.58676, 33.09458], [-116.58702, 33.09465], [-116.58731, 33.09478], [-116.58752, 33.09499], [-116.58772, 33.09551], [-116.58782, 33.09571], [-116.58796, 33.09586], [-116.58811, 33.09594], [-116.5883, 33.09599], [-116.58849, 33.096], [-116.589, 33.09591], [-116.58913, 33.10051], [-116.59584, 33.10112], [-116.59835, 33.10378], [-116.59974, 33.10508], [-116.59986, 33.10509], [-116.59991, 33.10863], [-116.60027, 33.10864], [-116.60031, 33.11052], [-116.59823, 33.11055], [-116.59823, 33.10864], [-116.58933, 33.10776], [-116.58917, 33.11307], [-116.59824, 33.11415], [-116.59825, 33.115], [-116.60256, 33.11614]], [[-116.57991, 33.09966], [-116.58453, 33.10009], [-116.58442, 33.09705], [-116.5798, 33.09663], [-116.57991, 33.09966]]]} | Open Access 1 | 10653 | Volcan Mountain Wilderness Preserve | 29261 | 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/VolcanMountain.html | San Diego 4 | 3013.276 | Volcan Mtn. Wilderness 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]);