units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
40 rows where ACCESS_TYP = 3, COUNTY = 4 and MNG_AG_TYP = 10 sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: SUID_NMA, AGNCY_NAME, GAP_STS
UNIT_NAME 22 ✖
- Land Pres/Mitigation Bank - The Environmental Trust 17
- Rancho La Costa Preserve 2
- San Dieguito River Park 2
- Appleton Preserve 1
- Blossom Valley Habitat Conservation Area 1
- Bumann Property 1
- Cassia Professional Offices Preserve 1
- Corral Mountain Open Space 1
- Durling Preserve 1
- Encinas Creek Preserve 1
- Ewing Oak Preserve 1
- Granger Preserve 1
- La Posta - Cameron Preserve 1
- Mesquite Bosque 1
- Morro Hills/Foss Lake Habitat Conservation Area 1
- Newport 5 Preserve 1
- Poway Creek Riparian Preserve 1
- Quarry Property 1
- Rattlesnake Mountain 1
- Robinhood Ridge 1
- Vista de la Valle - Land Preserve/Mitigation Area 1
- Wilmont Preserve 1
MNG_AGENCY 7
DES_TP 2
MNG_AG_TYP 1
- Non Profit - Land Trust · 40 ✖
ACCESS_TYP 1
- No Public Access · 40 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16918 | 16918 | 16917 | {"type": "MultiPolygon", "coordinates": [[[[-117.00734, 32.82839], [-117.00392, 32.82838], [-117.0039, 32.82652], [-117.00386, 32.82602], [-117.0038, 32.82557], [-117.00368, 32.82495], [-117.00357, 32.82448], [-117.00326, 32.82344], [-117.00307, 32.82251], [-117.00276, 32.8221], [-117.00268, 32.82025], [-117.00321, 32.82077], [-117.00576, 32.82077], [-117.00573, 32.82409], [-117.00731, 32.82409], [-117.00734, 32.82839]]], [[[-116.95669, 32.82962], [-116.95654, 32.83497], [-116.95635, 32.83495], [-116.95638, 32.83471], [-116.95628, 32.83455], [-116.95619, 32.83452], [-116.9561, 32.83434], [-116.95588, 32.83427], [-116.9558, 32.83427], [-116.95567, 32.83419], [-116.95552, 32.83414], [-116.95532, 32.83416], [-116.95531, 32.83414], [-116.95521, 32.83415], [-116.95506, 32.834], [-116.95488, 32.83367], [-116.95483, 32.83348], [-116.95482, 32.83335], [-116.95466, 32.83319], [-116.95474, 32.83289], [-116.95481, 32.83275], [-116.95485, 32.83257], [-116.95491, 32.83249], [-116.95499, 32.83243], [-116.95509, 32.83233], [-116.95517, 32.83224], [-116.95527, 32.83218], [-116.9553, 32.83219], [-116.95532, 32.83217], [-116.95532, 32.83212], [-116.95541, 32.83201], [-116.95548, 32.83199], [-116.95558, 32.83188], [-116.95562, 32.83175], [-116.95561, 32.83161], [-116.95555, 32.83146], [-116.95535, 32.83134], [-116.955, 32.83137], [-116.95486, 32.83146], [-116.95482, 32.83152], [-116.9548, 32.83153], [-116.9546, 32.83141], [-116.9544, 32.83131], [-116.95436, 32.83119], [-116.95433, 32.83116], [-116.95433, 32.8311], [-116.95428, 32.83098], [-116.95418, 32.83088], [-116.95405, 32.83081], [-116.9539, 32.83078], [-116.95377, 32.83079], [-116.95348, 32.83086], [-116.95322, 32.83097], [-116.95299, 32.83113], [-116.95286, 32.83129], [-116.95282, 32.83142], [-116.95268, 32.83165], [-116.95265, 32.83179], [-116.95256, 32.83194], [-116.95252, 32.83207], [-116.95241, 32.83209], [-116.95223, 32.83206], [-116.95219, 32.83203], [-116.95217, 32.83197], [-116.95212, 32.83195], [-116.95207, 32.83182], [-116.95202, 32.83174], [-116.95199, 32.83163], [-116.95184, 32.83144], [-116.95172, 32.83137], [-116.95157, 32.83134], [-116.9515, 32.83116], [-116.95147, 32.83115], [-116.95132, 32.83126], [-116.95125, 32.83126], [-116.95124, 32.83118], [-116.95112, 32.83102], [-116.95112, 32.83092], [-116.95141, 32.83042], [-116.95153, 32.83037], [-116.95186, 32.83031], [-116.95204, 32.83022], [-116.95224, 32.83004], [-116.95232, 32.82994], [-116.95238, 32.82984], [-116.95242, 32.82963], [-116.95669, 32.82962]]], [[[-116.95131, 32.82963], [-116.95131, 32.83021], [-116.95122, 32.83027], [-116.95114, 32.83034], [-116.9508, 32.83075], [-116.95075, 32.83091], [-116.95075, 32.83101], [-116.95077, 32.83111], [-116.95047, 32.83118], [-116.95015, 32.83128], [-116.94998, 32.83117], [-116.95013, 32.83091], [-116.95013, 32.8308], [-116.95008, 32.83067], [-116.94998, 32.83058], [-116.94958, 32.83037], [-116.94911, 32.83033], [-116.94862, 32.83057], [-116.94837, 32.83096], [-116.94836, 32.83124], [-116.94827, 32.83151], [-116.9481, 32.83187], [-116.94808, 32.83205], [-116.94813, 32.83206], [-116.94814, 32.83214], [-116.94818, 32.83221], [-116.94828, 32.8323], [-116.94837, 32.83233], [-116.94857, 32.83236], [-116.94871, 32.83283], [-116.94883, 32.83308], [-116.94895, 32.83323], [-116.94908, 32.83337], [-116.94922, 32.83348], [-116.94941, 32.8336], [-116.9494, 32.83373], [-116.94933, 32.83388], [-116.94937, 32.83402], [-116.94929, 32.83426], [-116.94925, 32.83428], [-116.94916, 32.83441], [-116.94916, 32.83458], [-116.94927, 32.83474], [-116.94935, 32.83481], [-116.94904, 32.83507], [-116.94889, 32.83516], [-116.94877, 32.83519], [-116.94865, 32.83519], [-116.94847, 32.83514], [-116.94833, 32.83504], [-116.94802, 32.83464], [-116.94782, 32.83444], [-116.94775, 32.83427], [-116.94741, 32.83415], [-116.94744, 32.83397], [-116.94744, 32.83386], [-116.94738, 32.83376], [-116.94719, 32.83358], [-116.94684, 32.83345], [-116.94671, 32.83333], [-116.94656, 32.83289], [-116.94632, 32.83245], [-116.94585, 32.83196], [-116.94545, 32.83191], [-116.94523, 32.83219], [-116.94506, 32.83233], [-116.94483, 32.83222], [-116.94437, 32.83145], [-116.94414, 32.83127], [-116.94397, 32.831], [-116.94378, 32.83089], [-116.94367, 32.8309], [-116.94335, 32.83102], [-116.94301, 32.83041], [-116.94316, 32.83037], [-116.94328, 32.83025], [-116.94331, 32.82988], [-116.94227, 32.82818], [-116.94213, 32.8282], [-116.94168, 32.82763], [-116.94133, 32.82731], [-116.94086, 32.82743], [-116.94112, 32.82837], [-116.9421, 32.83001], [-116.94262, 32.8298], [-116.94287, 32.83056], [-116.94318, 32.83109], [-116.94315, 32.8311], [-116.94297, 32.83097], [-116.94291, 32.83096], [-116.94281, 32.83096], [-116.94277, 32.83093], [-116.94254, 32.83101], [-116.94259, 32.83114], [-116.94266, 32.83123], [-116.94267, 32.83128], [-116.94263, 32.83149], [-116.94257, 32.83151], [-116.94251, 32.83141], [-116.94238, 32.83131], [-116.94194, 32.83113], [-116.94183, 32.83111], [-116.94152, 32.83112], [-116.9415, 32.83121], [-116.94097, 32.83047], [-116.94132, 32.83014], [-116.94004, 32.82856], [-116.93998, 32.82777], [-116.93891, 32.82645], [-116.93871, 32.82573], [-116.93798, 32.82498], [-116.93798, 32.82414], [-116.9438, 32.82422], [-116.9434, 32.82478], [-116.94597, 32.82657], [-116.94531, 32.82749], [-116.94581, 32.82963], [-116.95131, 32.82963]]], [[[-116.95321, 32.83622], [-116.95321, 32.83622], [-116.95179, 32.83622], [-116.95199, 32.83605], [-116.95199, 32.83583], [-116.95203, 32.83582], [-116.95203, 32.83578], [-116.9521, 32.83584], [-116.95218, 32.83588], [-116.95233, 32.83589], [-116.95239, 32.83598], [-116.95246, 32.83603], [-116.95283, 32.8361], [-116.95312, 32.83607], [-116.95314, 32.83611], [-116.95321, 32.83611], [-116.95321, 32.83622]]], [[[-116.95858, 32.83819], [-116.95645, 32.83814], [-116.95649, 32.83674], [-116.95652, 32.83678], [-116.95669, 32.83684], [-116.95683, 32.83684], [-116.95693, 32.83682], [-116.95696, 32.83687], [-116.95704, 32.83685], [-116.95729, 32.83718], [-116.95733, 32.83734], [-116.95738, 32.83739], [-116.95745, 32.83744], [-116.9576, 32.8375], [-116.95769, 32.83751], [-116.9578, 32.8375], [-116.9581, 32.83787], [-116.95824, 32.83794], [-116.95838, 32.83797], [-116.9585, 32.83812], [-116.95858, 32.83819]]], [[[-116.95265, 32.84001], [-116.95263, 32.84088], [-116.95214, 32.84086], [-116.95181, 32.84042], [-116.95154, 32.8401], [-116.95121, 32.83982], [-116.95087, 32.83959], [-116.95007, 32.83933], [-116.94968, 32.83922], [-116.94891, 32.83909], [-116.94852, 32.83906], [-116.94812, 32.83904], [-116.9472, 32.83907], [-116.94662, 32.83921], [-116.94627, 32.83963], [-116.94597, 32.84032], [-116.94593, 32.8407], [-116.94594, 32.84114], [-116.94614, 32.84158], [-116.94644, 32.8419], [-116.9467, 32.84202], [-116.94509, 32.84199], [-116.94511, 32.83552], [-116.94473, 32.83538], [-116.94445, 32.83451], [-116.94396, 32.83412], [-116.94368, 32.83361], [-116.94319, 32.83321], [-116.94306, 32.83331], [-116.94248, 32.8328], [-116.94175, 32.83178], [-116.94187, 32.83172], [-116.9419, 32.83174], [-116.94194, 32.83169], [-116.94197, 32.83162], [-116.94198, 32.83155], [-116.94196, 32.83149], [-116.94184, 32.83135], [-116.94225, 32.83152], [-116.94231, 32.83161], [-116.94234, 32.83176], [-116.9424, 32.83188], [-116.94248, 32.83193], [-116.94258, 32.83195], [-116.9427, 32.83193], [-116.94286, 32.83169], [-116.94289, 32.83161], [-116.94295, 32.83129], [-116.9431, 32.83146], [-116.9431, 32.83153], [-116.94313, 32.83157], [-116.9432, 32.8316], [-116.94317, 32.8318], [-116.9432, 32.83199], [-116.94342, 32.83234], [-116.94347, 32.83255], [-116.94356, 32.83267], [-116.94366, 32.83273], [-116.94379, 32.83301], [-116.94399, 32.83327], [-116.94447, 32.83355], [-116.94464, 32.83373], [-116.94479, 32.83397], [-116.94517, 32.83442], [-116.94533, 32.83466], [-116.94544, 32.8348], [-116.94544, 32.83493], [-116.9456, 32.83516], [-116.94577, 32.83527], [-116.94598, 32.83524], [-116.94629, 32.83513], [-116.94656, 32.83499], [-116.94678, 32.83481], [-116.94705, 32.83491], [-116.94732, 32.83489], [-116.94759, 32.83468], [-116.94771, 32.8348], [-116.94788, 32.83503], [-116.9479, 32.83516], [-116.94804, 32.83531], [-116.94817, 32.83534], [-116.9483, 32.83541], [-116.94845, 32.83547], [-116.94869, 32.8355], [-116.9487, 32.83556], [-116.95115, 32.83556], [-116.95109, 32.83771], [-116.95174, 32.83773], [-116.95169, 32.83944], [-116.95202, 32.83945], [-116.952, 32.84], [-116.95265, 32.84001]], [[-116.94884, 32.83757], [-116.94908, 32.83757], [-116.94938, 32.8373], [-116.94947, 32.83675], [-116.94879, 32.83666], [-116.94884, 32.83757]]], [[[-116.96895, 32.87857], [-116.96687, 32.87858], [-116.96687, 32.87678], [-116.96894, 32.87677], [-116.96895, 32.87857]]]]} | No Public Access 3 | 45248 | Rattlesnake Mountain | 24195 | 3014 | Center for Natural Lands Management 91 | Non Profit 6 | Non Profit - Land Trust 10 | http://cnlm.org/ | Non Governmental Organization 10 | 3014 | Center for Natural Lands Management 89 | Non Profit 6 | Non Profit - Land Trust 10 | San Diego 4 | 324.276 | Rattlesnake Mtn. | 0 | Private Conservation 16 | 2 | |
14826 | 14826 | 14825 | {"type": "MultiPolygon", "coordinates": [[[[-117.25428, 33.10195], [-117.25401, 33.10226], [-117.2537, 33.10222], [-117.25227, 33.10155], [-117.25246, 33.10141], [-117.25268, 33.10128], [-117.25292, 33.10116], [-117.25317, 33.10106], [-117.25321, 33.10136], [-117.25349, 33.10158], [-117.25428, 33.10195]]], [[[-117.26306, 33.10422], [-117.26284, 33.10448], [-117.26277, 33.10424], [-117.26273, 33.10402], [-117.26293, 33.104], [-117.26306, 33.10422]]], [[[-117.26155, 33.1024], [-117.26156, 33.10258], [-117.26139, 33.10325], [-117.26103, 33.1048], [-117.26095, 33.10504], [-117.26079, 33.10567], [-117.26052, 33.10562], [-117.26001, 33.10598], [-117.25985, 33.106], [-117.25988, 33.10555], [-117.25951, 33.10542], [-117.25903, 33.10554], [-117.25873, 33.1055], [-117.25862, 33.10555], [-117.25802, 33.10538], [-117.2583, 33.10534], [-117.25854, 33.10525], [-117.25876, 33.10511], [-117.25892, 33.10492], [-117.25918, 33.10422], [-117.2599, 33.10429], [-117.26016, 33.10381], [-117.26024, 33.10324], [-117.26002, 33.10264], [-117.25981, 33.10245], [-117.25949, 33.10251], [-117.25941, 33.10245], [-117.25922, 33.10157], [-117.25977, 33.10193], [-117.26002, 33.10206], [-117.26029, 33.10217], [-117.26063, 33.10227], [-117.26092, 33.10233], [-117.26122, 33.10237], [-117.26155, 33.1024]]], [[[-117.26363, 33.10629], [-117.26343, 33.10649], [-117.26329, 33.10643], [-117.26308, 33.10599], [-117.26292, 33.10592], [-117.26307, 33.10567], [-117.26311, 33.10554], [-117.26312, 33.10541], [-117.26309, 33.10519], [-117.26292, 33.10472], [-117.26315, 33.10506], [-117.26328, 33.10612], [-117.26363, 33.10629]]], [[[-117.25568, 33.10254], [-117.25538, 33.10271], [-117.25501, 33.10319], [-117.25483, 33.10366], [-117.25481, 33.10392], [-117.2549, 33.10425], [-117.25496, 33.10436], [-117.25505, 33.10449], [-117.25535, 33.10481], [-117.25547, 33.10497], [-117.2556, 33.10521], [-117.25567, 33.10544], [-117.2557, 33.10562], [-117.2557, 33.10578], [-117.25553, 33.10607], [-117.25546, 33.10625], [-117.25542, 33.10648], [-117.25543, 33.10681], [-117.25542, 33.10687], [-117.25532, 33.107], [-117.25527, 33.1071], [-117.25523, 33.1073], [-117.25525, 33.10745], [-117.25531, 33.1076], [-117.25538, 33.10772], [-117.25563, 33.10801], [-117.25563, 33.10805], [-117.25502, 33.10824], [-117.25493, 33.10858], [-117.25469, 33.1087], [-117.2548, 33.10855], [-117.25473, 33.10833], [-117.25444, 33.10823], [-117.25437, 33.10807], [-117.25412, 33.10797], [-117.25388, 33.108], [-117.25341, 33.10788], [-117.25322, 33.10788], [-117.25329, 33.10771], [-117.25351, 33.10751], [-117.2541, 33.10758], [-117.25422, 33.10768], [-117.25436, 33.1077], [-117.25451, 33.10764], [-117.2546, 33.10758], [-117.25466, 33.1075], [-117.2547, 33.1074], [-117.2547, 33.10729], [-117.25466, 33.10719], [-117.2546, 33.10711], [-117.2545, 33.10704], [-117.25462, 33.10688], [-117.25467, 33.10671], [-117.25467, 33.1066], [-117.25464, 33.10647], [-117.25466, 33.10593], [-117.25484, 33.10555], [-117.25488, 33.10541], [-117.25487, 33.10523], [-117.25476, 33.10487], [-117.2548, 33.10468], [-117.25479, 33.10461], [-117.25474, 33.10441], [-117.25442, 33.10407], [-117.25408, 33.10379], [-117.25409, 33.10356], [-117.25439, 33.10299], [-117.25477, 33.10271], [-117.25475, 33.10248], [-117.25464, 33.10236], [-117.25419, 33.10229], [-117.25442, 33.10202], [-117.25491, 33.10224], [-117.25498, 33.10225], [-117.25568, 33.10254]]], [[[-117.25438, 33.10939], [-117.25417, 33.10954], [-117.25348, 33.10977], [-117.25335, 33.10991], [-117.25323, 33.10988], [-117.25282, 33.10996], [-117.25282, 33.10842], [-117.25307, 33.10854], [-117.25346, 33.10863], [-117.25371, 33.10873], [-117.2536, 33.10889], [-117.25359, 33.10896], [-117.25363, 33.10903], [-117.2539, 33.10918], [-117.25409, 33.10922], [-117.25411, 33.10929], [-117.25419, 33.10935], [-117.25438, 33.10939]]], [[[-117.26436, 33.11082], [-117.26412, 33.11076], [-117.26395, 33.1107], [-117.26379, 33.11062], [-117.26366, 33.11053], [-117.26297, 33.10981], [-117.26286, 33.10967], [-117.26279, 33.10955], [-117.26273, 33.10939], [-117.26269, 33.10924], [-117.26268, 33.10909], [-117.2627, 33.10877], [-117.26269, 33.1086], [-117.26258, 33.10812], [-117.26255, 33.10795], [-117.26257, 33.10728], [-117.26265, 33.10729], [-117.26309, 33.10803], [-117.26317, 33.10843], [-117.26331, 33.10867], [-117.26339, 33.10929], [-117.26333, 33.10955], [-117.2634, 33.10987], [-117.26364, 33.10992], [-117.26364, 33.11019], [-117.26396, 33.11052], [-117.26436, 33.11082]]], [[[-117.26086, 33.10574], [-117.26075, 33.10625], [-117.26069, 33.1064], [-117.26063, 33.10652], [-117.2601, 33.1073], [-117.26, 33.10747], [-117.25989, 33.10775], [-117.25983, 33.108], [-117.25981, 33.10837], [-117.25986, 33.1087], [-117.25992, 33.10891], [-117.2604, 33.1102], [-117.26049, 33.11049], [-117.26058, 33.11096], [-117.26061, 33.11144], [-117.26059, 33.11172], [-117.26055, 33.11199], [-117.26037, 33.11278], [-117.26033, 33.1129], [-117.26026, 33.11304], [-117.26016, 33.11318], [-117.25974, 33.11364], [-117.25925, 33.11325], [-117.25936, 33.11323], [-117.25984, 33.11327], [-117.26002, 33.11321], [-117.26015, 33.11291], [-117.26014, 33.11279], [-117.26003, 33.11259], [-117.25998, 33.11225], [-117.25993, 33.11208], [-117.25971, 33.11166], [-117.25968, 33.11113], [-117.25949, 33.11075], [-117.25931, 33.11061], [-117.25909, 33.1106], [-117.25872, 33.11067], [-117.2584, 33.11056], [-117.25835, 33.11016], [-117.25884, 33.10958], [-117.25908, 33.10956], [-117.25943, 33.10913], [-117.25961, 33.10867], [-117.2596, 33.10825], [-117.25949, 33.10784], [-117.25964, 33.10739], [-117.25986, 33.10712], [-117.26002, 33.10672], [-117.26035, 33.10637], [-117.26044, 33.10615], [-117.26025, 33.10595], [-117.2602, 33.10595], [-117.26058, 33.10569], [-117.26086, 33.10574]]], [[[-117.26012, 33.11446], [-117.2601, 33.11451], [-117.25782, 33.115], [-117.25614, 33.1156], [-117.2528, 33.11686], [-117.25281, 33.11311], [-117.25297, 33.11329], [-117.25349, 33.1133], [-117.25361, 33.11343], [-117.25424, 33.11352], [-117.25466, 33.11351], [-117.25494, 33.11344], [-117.25518, 33.11353], [-117.25491, 33.11385], [-117.25504, 33.11417], [-117.25526, 33.11446], [-117.25562, 33.11452], [-117.25578, 33.11469], [-117.25605, 33.11466], [-117.25613, 33.11449], [-117.25633, 33.11425], [-117.25656, 33.11422], [-117.25659, 33.11401], [-117.25631, 33.1137], [-117.25633, 33.11367], [-117.25688, 33.11368], [-117.25699, 33.11363], [-117.25746, 33.11362], [-117.25763, 33.11369], [-117.25791, 33.11366], [-117.25819, 33.11346], [-117.2588, 33.11347], [-117.25891, 33.11349], [-117.25937, 33.11381], [-117.25933, 33.11387], [-117.25992, 33.11426], [-117.26012, 33.11446]]], [[[-117.26188, 33.11586], [-117.26215, 33.1163], [-117.26224, 33.11674], [-117.26218, 33.11706], [-117.26224, 33.11769], [-117.2622, 33.11792], [-117.26209, 33.11824], [-117.26191, 33.11853], [-117.26176, 33.11864], [-117.26136, 33.11906], [-117.26127, 33.11892], [-117.26104, 33.11879], [-117.26098, 33.11861], [-117.26127, 33.11829], [-117.26125, 33.11792], [-117.26139, 33.11745], [-117.26158, 33.11729], [-117.26157, 33.11684], [-117.26118, 33.1163], [-117.26059, 33.11608], [-117.2604, 33.11612], [-117.26008, 33.11674], [-117.25973, 33.11689], [-117.25962, 33.11683], [-117.25892, 33.11688], [-117.25874, 33.11715], [-117.25854, 33.11727], [-117.25818, 33.11772], [-117.25801, 33.11757], [-117.25805, 33.11733], [-117.25834, 33.11731], [-117.25866, 33.11706], [-117.25865, 33.11694], [-117.25877, 33.11681], [-117.25893, 33.11656], [-117.2591, 33.11664], [-117.25939, 33.11655], [-117.25948, 33.11637], [-117.25977, 33.1161], [-117.25986, 33.11566], [-117.25951, 33.11524], [-117.25998, 33.11516], [-117.26033, 33.11517], [-117.26063, 33.11508], [-117.2609, 33.11536], [-117.26115, 33.11549], [-117.26119, 33.1157], [-117.26134, 33.11577], [-117.26154, 33.11571], [-117.26188, 33.11586]]], [[[-117.27021, 33.11569], [-117.26982, 33.11556], [-117.26908, 33.11558], [-117.26869, 33.11598], [-117.26848, 33.1159], [-117.26809, 33.1156], [-117.26782, 33.11566], [-117.2676, 33.11588], [-117.26756, 33.11608], [-117.2677, 33.11658], [-117.26778, 33.1173], [-117.26757, 33.11731], [-117.26736, 33.11763], [-117.26738, 33.11779], [-117.26776, 33.11797], [-117.26707, 33.11877], [-117.26671, 33.11903], [-117.26639, 33.1194], [-117.26623, 33.11976], [-117.26629, 33.1202], [-117.26624, 33.12064], [-117.26608, 33.12089], [-117.26551, 33.12108], [-117.26515, 33.12102], [-117.265, 33.12089], [-117.26471, 33.12086], [-117.26441, 33.12095], [-117.26429, 33.12121], [-117.2643, 33.12153], [-117.26463, 33.12243], [-117.26462, 33.12287], [-117.2622, 33.12286], [-117.26219, 33.12259], [-117.26214, 33.12226], [-117.26186, 33.12144], [-117.26191, 33.12113], [-117.26178, 33.12077], [-117.26162, 33.1205], [-117.26166, 33.11997], [-117.26174, 33.11957], [-117.26173, 33.11928], [-117.2623, 33.1188], [-117.26245, 33.1186], [-117.2626, 33.11866], [-117.26274, 33.11845], [-117.26279, 33.11841], [-117.26284, 33.11839], [-117.26296, 33.11841], [-117.26304, 33.11847], [-117.26305, 33.11852], [-117.26306, 33.11872], [-117.26309, 33.11878], [-117.26332, 33.11887], [-117.26357, 33.11871], [-117.26426, 33.11874], [-117.26455, 33.11897], [-117.26486, 33.11874], [-117.26456, 33.11804], [-117.26472, 33.11778], [-117.26507, 33.11785], [-117.26508, 33.11784], [-117.26495, 33.11675], [-117.26522, 33.11651], [-117.26518, 33.11629], [-117.26437, 33.11597], [-117.26426, 33.11532], [-117.26451, 33.11437], [-117.26382, 33.11379], [-117.26363, 33.11352], [-117.2637, 33.11347], [-117.26397, 33.11347], [-117.26413, 33.11353], [-117.26493, 33.11336], [-117.26516, 33.11303], [-117.26565, 33.11296], [-117.26575, 33.113], [-117.26603, 33.11294], [-117.26604, 33.11287], [-117.2665, 33.1127], [-117.26663, 33.11273], [-117.267, 33.11262], [-117.2674, 33.11235], [-117.26762, 33.11188], [-117.2682, 33.11155], [-117.26825, 33.11131], [-117.26928, 33.11046], [-117.26951, 33.11003], [-117.26974, 33.1099], [-117.27021, 33.11055], [-117.27021, 33.11569]]]]} | No Public Access 3 | 45238 | Rancho La Costa Preserve | 24148 | 3014 | Center for Natural Lands Management 91 | Non Profit 6 | Non Profit - Land Trust 10 | http://cnlm.org/ | Non Governmental Organization 10 | 3014 | Center for Natural Lands Management 89 | Non Profit 6 | Non Profit - Land Trust 10 | San Diego 4 | 213.743 | Rancho La Costa Preserve | 0 | Private Conservation 16 | 2 | |
14622 | 14622 | 14621 | {"type": "Polygon", "coordinates": [[[-117.27099, 33.11486], [-117.27071, 33.11529], [-117.27021, 33.11588], [-117.27021, 33.11462], [-117.27039, 33.11459], [-117.27068, 33.11463], [-117.27068, 33.11466], [-117.27084, 33.11474], [-117.27085, 33.11484], [-117.2709, 33.11482], [-117.27099, 33.11486]]]} | No Public Access 3 | 44873 | Cassia Professional Offices Preserve | 16944 | 3014 | Center for Natural Lands Management 91 | Non Profit 6 | Non Profit - Land Trust 10 | http://cnlm.org/ | Non Governmental Organization 10 | 3014 | Center for Natural Lands Management 89 | Non Profit 6 | Non Profit - Land Trust 10 | San Diego 4 | 1.462 | Cassia Professional Offices Preserve | 0 | Private Conservation 16 | 2 | |
9761 | 9761 | 9760 | {"type": "Polygon", "coordinates": [[[-117.01978, 33.34227], [-117.01951, 33.34216], [-117.01831, 33.34175], [-117.01701, 33.34157], [-117.01718, 33.34144], [-117.01789, 33.34103], [-117.01817, 33.34027], [-117.01511, 33.33929], [-117.01499, 33.3393], [-117.01482, 33.33925], [-117.01477, 33.33931], [-117.01403, 33.33932], [-117.01408, 33.339], [-117.01668, 33.33534], [-117.0194, 33.33715], [-117.01974, 33.33725], [-117.01978, 33.34227]]]} | No Public Access 3 | 47872 | Granger Preserve | 31817 | 3022 | Fallbrook Land Conservancy 339 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.fallbrooklandconservancy.org/ | Non Governmental Organization 10 | 3022 | Fallbrook Land Conservancy 336 | Non Profit 6 | Non Profit - Land Trust 10 | San Diego 4 | 53.474 | Granger Preserve | 2016 | Private Conservation 16 | 2 | |
9759 | 9759 | 9758 | {"type": "Polygon", "coordinates": [[[-117.33309, 33.47838], [-117.32511, 33.4758], [-117.32508, 33.47488], [-117.32412, 33.47486], [-117.32413, 33.47409], [-117.32497, 33.4741], [-117.32544, 33.47311], [-117.32616, 33.47088], [-117.32581, 33.46875], [-117.32987, 33.4687], [-117.3299, 33.46759], [-117.32883, 33.46768], [-117.32931, 33.46611], [-117.33054, 33.46549], [-117.3304, 33.46403], [-117.3287, 33.46412], [-117.32431, 33.46406], [-117.32041, 33.46405], [-117.32059, 33.46391], [-117.32871, 33.4639], [-117.33309, 33.46368], [-117.33301, 33.46731], [-117.33085, 33.46751], [-117.33071, 33.47105], [-117.33073, 33.47106], [-117.33304, 33.47086], [-117.33309, 33.47838]]]} | No Public Access 3 | 47870 | Durling Preserve | 31815 | 3022 | Fallbrook Land Conservancy 339 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.fallbrooklandconservancy.org/ | Non Governmental Organization 10 | 3022 | Fallbrook Land Conservancy 336 | Non Profit 6 | Non Profit - Land Trust 10 | https://www.fallbrooklandconservancy.org/durling.html | San Diego 4 | 186.908 | Durling Preserve | 2012 | Private Conservation 16 | 2 |
8339 | 8339 | 8338 | {"type": "Polygon", "coordinates": [[[-116.53359, 33.16797], [-116.53794, 33.16809], [-116.53811, 33.17231], [-116.53815, 33.17515], [-116.54258, 33.17521], [-116.54272, 33.17873], [-116.53401, 33.17867], [-116.53373, 33.17153], [-116.52949, 33.17168], [-116.52931, 33.16798], [-116.53359, 33.16797]]]} | No Public Access 3 | 12844 | San Dieguito River Park | 24870 | 3066 | San Dieguito River Valley Land Conservancy 378 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sdrvc.org/ | Non Governmental Organization 10 | 3066 | San Dieguito River Valley Land Conservancy 373 | Non Profit 6 | Non Profit - Land Trust 10 | San Diego 4 | 197.03 | San Dieguito River Park | 0 | Private Recreation or Education 65 | 4 | |
8308 | 8308 | 8307 | {"type": "Polygon", "coordinates": [[[-117.33623, 33.21599], [-117.33279, 33.22069], [-117.33193, 33.22042], [-117.33199, 33.22009], [-117.33205, 33.21957], [-117.33208, 33.21908], [-117.33208, 33.2186], [-117.33211, 33.21826], [-117.33221, 33.21782], [-117.3323, 33.21756], [-117.33241, 33.2172], [-117.33249, 33.21674], [-117.33251, 33.21653], [-117.33255, 33.21549], [-117.33262, 33.21504], [-117.33268, 33.21475], [-117.33282, 33.2143], [-117.33327, 33.21307], [-117.33336, 33.21277], [-117.33342, 33.21248], [-117.33471, 33.21244], [-117.33623, 33.21599]]]} | No Public Access 3 | 12737 | Vista de la Valle - Land Preserve/Mitigation Area | 27166 | 3088 | The Environmental Trust 395 | Non Profit 6 | Non Profit - Land Trust 10 | Non Governmental Organization 10 | 3088 | The Environmental Trust 389 | Non Profit 6 | Non Profit - Land Trust 10 | San Diego 4 | 50.738 | Vista de la Valle - Land Preserve/Mitigation Area | 0 | Private Conservation 16 | 2 | ||
8235 | 8235 | 8234 | {"type": "Polygon", "coordinates": [[[-117.00398, 32.95858], [-117.00347, 32.95885], [-117.00267, 32.95902], [-117.00248, 32.9592], [-117.00238, 32.95921], [-117.00228, 32.95927], [-117.00224, 32.95935], [-117.00223, 32.95942], [-117.00187, 32.95949], [-117.00142, 32.95963], [-117.00107, 32.95966], [-117.0005, 32.9599], [-117.00031, 32.95999], [-117.00015, 32.96009], [-116.99999, 32.96022], [-116.99938, 32.96082], [-116.99922, 32.961], [-116.999, 32.96116], [-116.99869, 32.96076], [-116.9986, 32.96055], [-116.99857, 32.96041], [-116.99857, 32.96028], [-116.99889, 32.96032], [-116.99894, 32.96017], [-116.99903, 32.96003], [-116.99919, 32.9599], [-117.0004, 32.9591], [-117.00022, 32.95889], [-117.00036, 32.95882], [-117.00045, 32.9588], [-117.00053, 32.95908], [-117.00071, 32.95907], [-117.0009, 32.95908], [-117.00109, 32.95914], [-117.00158, 32.95908], [-117.00154, 32.9589], [-117.00171, 32.95887], [-117.00396, 32.95799], [-117.00398, 32.95858]]]} | No Public Access 3 | 12569 | Poway Creek Riparian Preserve | 23931 | 3088 | The Environmental Trust 395 | Non Profit 6 | Non Profit - Land Trust 10 | Non Governmental Organization 10 | 3088 | The Environmental Trust 389 | Non Profit 6 | Non Profit - Land Trust 10 | San Diego 4 | 10.021 | Poway Creek Riparian Preserve | 0 | Private Conservation 16 | 2 | ||
8184 | 8184 | 8183 | {"type": "Polygon", "coordinates": [[[-116.89139, 32.83481], [-116.89096, 32.83513], [-116.8907, 32.83504], [-116.89049, 32.83468], [-116.89006, 32.83463], [-116.88961, 32.8348], [-116.88948, 32.8348], [-116.88926, 32.83474], [-116.88904, 32.83445], [-116.88865, 32.83423], [-116.88889, 32.83406], [-116.88925, 32.83386], [-116.88981, 32.83345], [-116.88981, 32.83333], [-116.88976, 32.83318], [-116.8895, 32.83284], [-116.88914, 32.83251], [-116.88893, 32.83244], [-116.88873, 32.8324], [-116.88896, 32.83162], [-116.8896, 32.83155], [-116.89091, 32.83191], [-116.89059, 32.8325], [-116.8912, 32.83331], [-116.89086, 32.8336], [-116.89081, 32.83374], [-116.89109, 32.83382], [-116.89111, 32.83389], [-116.89115, 32.83392], [-116.89124, 32.83415], [-116.89095, 32.83426], [-116.89139, 32.83481]]]} | No Public Access 3 | 12400 | Land Pres/Mitigation Bank - The Environmental Trust | 21002 | 3088 | The Environmental Trust 395 | Non Profit 6 | Non Profit - Land Trust 10 | Non Governmental Organization 10 | 3088 | The Environmental Trust 389 | Non Profit 6 | Non Profit - Land Trust 10 | San Diego 4 | 14.229 | Land Pres/Mitigation Bank - The Environmental Trust | 0 | Private Conservation 16 | 2 | ||
8183 | 8183 | 8182 | {"type": "Polygon", "coordinates": [[[-117.01448, 32.58373], [-117.01447, 32.58791], [-117.01414, 32.58782], [-117.01392, 32.58773], [-117.01354, 32.58752], [-117.01332, 32.58737], [-117.0132, 32.58726], [-117.01306, 32.5871], [-117.01298, 32.58697], [-117.01279, 32.58662], [-117.0127, 32.5865], [-117.0125, 32.58632], [-117.01219, 32.58617], [-117.01186, 32.5861], [-117.00764, 32.58606], [-117.00745, 32.58604], [-117.00722, 32.586], [-117.00705, 32.58594], [-117.00676, 32.5858], [-117.00648, 32.58561], [-117.00562, 32.58532], [-117.00752, 32.58336], [-117.01448, 32.58373]]]} | No Public Access 3 | 12398 | Robinhood Ridge | 24501 | 3088 | The Environmental Trust 395 | Non Profit 6 | Non Profit - Land Trust 10 | Non Governmental Organization 10 | 3088 | The Environmental Trust 389 | Non Profit 6 | Non Profit - Land Trust 10 | San Diego 4 | 58.533 | Robinhood Ridge | 0 | Private Conservation 16 | 2 | ||
8182 | 8182 | 8181 | {"type": "Polygon", "coordinates": [[[-117.22114, 33.1097], [-117.22113, 33.11125], [-117.21683, 33.11123], [-117.21682, 33.10968], [-117.22114, 33.1097]]]} | No Public Access 3 | 12396 | Land Pres/Mitigation Bank - The Environmental Trust | 21002 | 3088 | The Environmental Trust 395 | Non Profit 6 | Non Profit - Land Trust 10 | Non Governmental Organization 10 | 3088 | The Environmental Trust 389 | Non Profit 6 | Non Profit - Land Trust 10 | San Diego 4 | 17.099 | Land Pres/Mitigation Bank - The Environmental Trust | 0 | Private Conservation 16 | 2 | ||
8181 | 8181 | 8180 | {"type": "Polygon", "coordinates": [[[-117.30491, 33.0932], [-117.30453, 33.09207], [-117.30484, 33.09153], [-117.30491, 33.09304], [-117.30491, 33.0932]]]} | No Public Access 3 | 12389 | Land Pres/Mitigation Bank - The Environmental Trust | 21002 | 3088 | The Environmental Trust 395 | Non Profit 6 | Non Profit - Land Trust 10 | Non Governmental Organization 10 | 3088 | The Environmental Trust 389 | Non Profit 6 | Non Profit - Land Trust 10 | San Diego 4 | 0.747 | Land Pres/Mitigation Bank - The Environmental Trust | 0 | Private Conservation 16 | 2 | ||
8180 | 8180 | 8179 | {"type": "Polygon", "coordinates": [[[-117.14409, 32.97117], [-117.14395, 32.97109], [-117.14349, 32.97116], [-117.14334, 32.9712], [-117.14311, 32.97129], [-117.14298, 32.97143], [-117.14283, 32.97134], [-117.14262, 32.97134], [-117.14241, 32.97126], [-117.14226, 32.97152], [-117.14221, 32.97148], [-117.14212, 32.97145], [-117.142, 32.97148], [-117.14191, 32.97142], [-117.14158, 32.97142], [-117.14184, 32.97106], [-117.14409, 32.97105], [-117.14409, 32.97117]]]} | No Public Access 3 | 12386 | Land Pres/Mitigation Bank - The Environmental Trust | 21002 | 3088 | The Environmental Trust 395 | Non Profit 6 | Non Profit - Land Trust 10 | Non Governmental Organization 10 | 3088 | The Environmental Trust 389 | Non Profit 6 | Non Profit - Land Trust 10 | San Diego 4 | 1.452 | Land Pres/Mitigation Bank - The Environmental Trust | 0 | Private Conservation 16 | 2 | ||
8179 | 8179 | 8178 | {"type": "Polygon", "coordinates": [[[-117.28623, 33.14129], [-117.28623, 33.14129], [-117.28489, 33.14169], [-117.28558, 33.1409], [-117.28623, 33.14129]]]} | No Public Access 3 | 12385 | Land Pres/Mitigation Bank - The Environmental Trust | 21002 | 3088 | The Environmental Trust 395 | Non Profit 6 | Non Profit - Land Trust 10 | Non Governmental Organization 10 | 3088 | The Environmental Trust 389 | Non Profit 6 | Non Profit - Land Trust 10 | San Diego 4 | 1.011 | Land Pres/Mitigation Bank - The Environmental Trust | 0 | Private Conservation 16 | 2 | ||
8178 | 8178 | 8177 | {"type": "Polygon", "coordinates": [[[-117.14201, 32.97455], [-117.14188, 32.97462], [-117.14104, 32.97463], [-117.14104, 32.97435], [-117.14107, 32.97432], [-117.14158, 32.97431], [-117.14176, 32.97445], [-117.14201, 32.97446], [-117.14201, 32.97455]]]} | No Public Access 3 | 12383 | Land Pres/Mitigation Bank - The Environmental Trust | 21002 | 3088 | The Environmental Trust 395 | Non Profit 6 | Non Profit - Land Trust 10 | Non Governmental Organization 10 | 3088 | The Environmental Trust 389 | Non Profit 6 | Non Profit - Land Trust 10 | San Diego 4 | 0.632 | Land Pres/Mitigation Bank - The Environmental Trust | 0 | Private Conservation 16 | 2 | ||
8176 | 8176 | 8175 | {"type": "Polygon", "coordinates": [[[-117.15025, 32.95895], [-117.15003, 32.95917], [-117.1497, 32.95925], [-117.14969, 32.9593], [-117.14961, 32.9593], [-117.14941, 32.95895], [-117.14876, 32.95912], [-117.14845, 32.95926], [-117.14835, 32.95934], [-117.14824, 32.95936], [-117.148, 32.95949], [-117.14804, 32.9596], [-117.14794, 32.95968], [-117.14786, 32.95974], [-117.14762, 32.95983], [-117.14765, 32.96011], [-117.14764, 32.96012], [-117.14761, 32.96013], [-117.14759, 32.96003], [-117.14731, 32.96003], [-117.14723, 32.96006], [-117.14719, 32.9601], [-117.14715, 32.96018], [-117.14715, 32.96045], [-117.14455, 32.96044], [-117.14455, 32.96012], [-117.14488, 32.96004], [-117.14506, 32.95993], [-117.14533, 32.95982], [-117.14537, 32.95985], [-117.14568, 32.95985], [-117.14596, 32.95977], [-117.14619, 32.95965], [-117.14712, 32.95861], [-117.14726, 32.95838], [-117.14697, 32.95782], [-117.14752, 32.95772], [-117.14758, 32.95783], [-117.14766, 32.95789], [-117.14776, 32.95794], [-117.14786, 32.95796], [-117.14823, 32.95831], [-117.1497, 32.95723], [-117.14991, 32.95743], [-117.14998, 32.95742], [-117.15001, 32.95759], [-117.15003, 32.95795], [-117.15013, 32.95807], [-117.15013, 32.95841], [-117.15022, 32.95874], [-117.15018, 32.9588], [-117.15018, 32.95886], [-117.15023, 32.95894], [-117.15025, 32.95895]]]} | No Public Access 3 | 12377 | Land Pres/Mitigation Bank - The Environmental Trust | 21002 | 3088 | The Environmental Trust 395 | Non Profit 6 | Non Profit - Land Trust 10 | Non Governmental Organization 10 | 3088 | The Environmental Trust 389 | Non Profit 6 | Non Profit - Land Trust 10 | San Diego 4 | 17.999 | Land Pres/Mitigation Bank - The Environmental Trust | 0 | Private Conservation 16 | 2 | ||
8175 | 8175 | 8174 | {"type": "Polygon", "coordinates": [[[-117.14408, 32.9718], [-117.14406, 32.97356], [-117.14366, 32.97373], [-117.14361, 32.97379], [-117.14344, 32.97374], [-117.14342, 32.97375], [-117.14341, 32.97381], [-117.1428, 32.97381], [-117.14271, 32.97416], [-117.1422, 32.97415], [-117.14219, 32.97414], [-117.14219, 32.97335], [-117.14224, 32.97304], [-117.14249, 32.97305], [-117.14268, 32.97301], [-117.14321, 32.97288], [-117.14349, 32.97275], [-117.14374, 32.97241], [-117.14386, 32.9722], [-117.14393, 32.97197], [-117.14408, 32.9718]]]} | No Public Access 3 | 12375 | Land Pres/Mitigation Bank - The Environmental Trust | 21002 | 3088 | The Environmental Trust 395 | Non Profit 6 | Non Profit - Land Trust 10 | Non Governmental Organization 10 | 3088 | The Environmental Trust 389 | Non Profit 6 | Non Profit - Land Trust 10 | San Diego 4 | 5.393 | Land Pres/Mitigation Bank - The Environmental Trust | 0 | Private Conservation 16 | 2 | ||
8170 | 8170 | 8169 | {"type": "Polygon", "coordinates": [[[-117.31369, 33.22397], [-117.31367, 33.22603], [-117.31264, 33.22629], [-117.31264, 33.22547], [-117.31196, 33.22473], [-117.31161, 33.22423], [-117.3111, 33.22435], [-117.31051, 33.22469], [-117.31045, 33.22461], [-117.31046, 33.2246], [-117.3104, 33.22453], [-117.31045, 33.22451], [-117.31051, 33.2245], [-117.31054, 33.22448], [-117.31073, 33.22451], [-117.31079, 33.22448], [-117.31122, 33.22413], [-117.31136, 33.22399], [-117.31142, 33.22396], [-117.31153, 33.22396], [-117.31163, 33.22401], [-117.31169, 33.22401], [-117.31178, 33.22395], [-117.31181, 33.22387], [-117.3126, 33.22409], [-117.31337, 33.22425], [-117.31369, 33.22397]]]} | No Public Access 3 | 12374 | Land Pres/Mitigation Bank - The Environmental Trust | 21002 | 3088 | The Environmental Trust 395 | Non Profit 6 | Non Profit - Land Trust 10 | Non Governmental Organization 10 | 3088 | The Environmental Trust 389 | Non Profit 6 | Non Profit - Land Trust 10 | San Diego 4 | 8.217 | Land Pres/Mitigation Bank - The Environmental Trust | 0 | Private Conservation 16 | 2 | ||
8169 | 8169 | 8168 | {"type": "Polygon", "coordinates": [[[-117.01797, 32.65356], [-117.01795, 32.65355], [-117.01732, 32.65317], [-117.01775, 32.65304], [-117.01797, 32.65356]]]} | No Public Access 3 | 12372 | Land Pres/Mitigation Bank - The Environmental Trust | 21002 | 3088 | The Environmental Trust 395 | Non Profit 6 | Non Profit - Land Trust 10 | Non Governmental Organization 10 | 3088 | The Environmental Trust 389 | Non Profit 6 | Non Profit - Land Trust 10 | San Diego 4 | 0.332 | Land Pres/Mitigation Bank - The Environmental Trust | 0 | Private Conservation 16 | 2 | ||
8168 | 8168 | 8167 | {"type": "Polygon", "coordinates": [[[-117.12669, 33.03476], [-117.12472, 33.03477], [-117.12484, 33.03391], [-117.12484, 33.03378], [-117.12481, 33.03366], [-117.12473, 33.03352], [-117.1246, 33.0334], [-117.12405, 33.03307], [-117.124, 33.03303], [-117.12394, 33.03293], [-117.12394, 33.03282], [-117.12398, 33.03273], [-117.12407, 33.03258], [-117.12418, 33.03248], [-117.12431, 33.0324], [-117.12466, 33.03224], [-117.12479, 33.0322], [-117.12548, 33.03208], [-117.12568, 33.032], [-117.12579, 33.03194], [-117.1259, 33.03184], [-117.12603, 33.03166], [-117.12608, 33.03149], [-117.12607, 33.03131], [-117.12668, 33.03103], [-117.12667, 33.03291], [-117.12669, 33.03476]]]} | No Public Access 3 | 12371 | Land Pres/Mitigation Bank - The Environmental Trust | 21002 | 3088 | The Environmental Trust 395 | Non Profit 6 | Non Profit - Land Trust 10 | Non Governmental Organization 10 | 3088 | The Environmental Trust 389 | Non Profit 6 | Non Profit - Land Trust 10 | San Diego 4 | 16.427 | Land Pres/Mitigation Bank - The Environmental Trust | 0 | Private Conservation 16 | 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]);