units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
51 rows where ACCESS_TYP = 3, COUNTY = 4 and DES_TP = 16 sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_TYP, AGNCY_WEB, MNG_AG_ID, YR_EST
Link | rowid ▲ | id | map | ACCESS_TYP | UNIT_ID | UNIT_NAME | SUID_NMA | AGNCY_ID | AGNCY_NAME | AGNCY_LEV | AGNCY_TYP | AGNCY_WEB | LAYER | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | PARK_URL | COUNTY | ACRES | LABEL_NAME | YR_EST | DES_TP | GAP_STS |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
14177 | 14177 | 14176 | {"type": "MultiPolygon", "coordinates": [[[[-116.83661, 32.82754], [-116.83656, 32.83029], [-116.82414, 32.83012], [-116.82764, 32.82602], [-116.82778, 32.82508], [-116.82831, 32.82471], [-116.83026, 32.82475], [-116.83027, 32.82503], [-116.83055, 32.82502], [-116.83059, 32.82476], [-116.83239, 32.8248], [-116.8324, 32.82659], [-116.8347, 32.82661], [-116.8361, 32.82754], [-116.83622, 32.82758], [-116.83634, 32.8276], [-116.83647, 32.82759], [-116.83661, 32.82754]]], [[[-116.83662, 32.82663], [-116.83661, 32.82732], [-116.83649, 32.82741], [-116.83635, 32.82744], [-116.83626, 32.82742], [-116.83617, 32.82739], [-116.83504, 32.82663], [-116.83662, 32.82663]]]]} | No Public Access 3 | 46827 | Kemerko Property | 30295 | 3208 | Endangered Habitats Conservancy 79 | Non Profit 6 | Non Profit - Conservation 12 | http://www.ehleague.org/EndangeredHabitatsConservancy.html | Non Governmental Organization 10 | 3208 | Endangered Habitats Conservancy 77 | Non Profit 6 | Non Profit - Conservation 12 | San Diego 4 | 122.681 | Kemerko Property | 0 | Private Conservation 16 | 2 | |
11547 | 11547 | 11546 | {"type": "Polygon", "coordinates": [[[-116.90449, 32.86918], [-116.90258, 32.86929], [-116.90321, 32.8702], [-116.90357, 32.87149], [-116.90313, 32.87153], [-116.90277, 32.87162], [-116.90228, 32.87168], [-116.89941, 32.871], [-116.89778, 32.87065], [-116.89597, 32.87065], [-116.89596, 32.86588], [-116.89775, 32.86452], [-116.89789, 32.8644], [-116.89813, 32.86414], [-116.89845, 32.86372], [-116.89896, 32.86285], [-116.90128, 32.86311], [-116.90141, 32.86392], [-116.90299, 32.86415], [-116.90314, 32.86538], [-116.90379, 32.8653], [-116.90449, 32.86918]]]} | No Public Access 3 | 46825 | Hanson Property | 30293 | 3208 | Endangered Habitats Conservancy 79 | Non Profit 6 | Non Profit - Conservation 12 | http://www.ehleague.org/EndangeredHabitatsConservancy.html | Non Governmental Organization 10 | 3208 | Endangered Habitats Conservancy 77 | Non Profit 6 | Non Profit - Conservation 12 | San Diego 4 | 141.528 | Hanson Property | 0 | Private Conservation 16 | 2 | |
11546 | 11546 | 11545 | {"type": "Polygon", "coordinates": [[[-116.89021, 32.80935], [-116.89021, 32.80935], [-116.88892, 32.80921], [-116.88944, 32.80854], [-116.89012, 32.80849], [-116.89021, 32.80935]]]} | No Public Access 3 | 46824 | Guyot/La Cresta Property | 30292 | 3208 | Endangered Habitats Conservancy 79 | Non Profit 6 | Non Profit - Conservation 12 | http://www.ehleague.org/EndangeredHabitatsConservancy.html | Non Governmental Organization 10 | 3208 | Endangered Habitats Conservancy 77 | Non Profit 6 | Non Profit - Conservation 12 | San Diego 4 | 1.954 | Guyot/La Cresta Property | 0 | Private Conservation 16 | 2 | |
11545 | 11545 | 11544 | {"type": "Polygon", "coordinates": [[[-116.83922, 32.83545], [-116.83782, 32.83791], [-116.83786, 32.83795], [-116.83772, 32.83808], [-116.83739, 32.83845], [-116.83729, 32.83853], [-116.83713, 32.8386], [-116.83711, 32.83786], [-116.83671, 32.83746], [-116.82396, 32.83749], [-116.82414, 32.83012], [-116.83656, 32.83029], [-116.83668, 32.83206], [-116.83671, 32.83431], [-116.83922, 32.83545]]]} | No Public Access 3 | 46823 | Gibson Property | 30291 | 3208 | Endangered Habitats Conservancy 79 | Non Profit 6 | Non Profit - Conservation 12 | http://www.ehleague.org/EndangeredHabitatsConservancy.html | Non Governmental Organization 10 | 3208 | Endangered Habitats Conservancy 77 | Non Profit 6 | Non Profit - Conservation 12 | San Diego 4 | 251.399 | Gibson Property | 0 | Private Conservation 16 | 2 | |
11544 | 11544 | 11543 | {"type": "Polygon", "coordinates": [[[-117.19588, 33.05838], [-117.19584, 33.06309], [-117.19526, 33.06178], [-117.19482, 33.0613], [-117.19421, 33.06309], [-117.1936, 33.06368], [-117.19386, 33.06453], [-117.19343, 33.06485], [-117.19359, 33.06456], [-117.19334, 33.06393], [-117.19279, 33.06361], [-117.19236, 33.06362], [-117.19211, 33.06312], [-117.19045, 33.06383], [-117.18724, 33.06429], [-117.18724, 33.06097], [-117.19095, 33.0591], [-117.19135, 33.05875], [-117.19134, 33.05841], [-117.19588, 33.05838]]]} | No Public Access 3 | 46822 | Bridges Property | 30290 | 3208 | Endangered Habitats Conservancy 79 | Non Profit 6 | Non Profit - Conservation 12 | http://www.ehleague.org/EndangeredHabitatsConservancy.html | Non Governmental Organization 10 | 3208 | Endangered Habitats Conservancy 77 | Non Profit 6 | Non Profit - Conservation 12 | San Diego 4 | 96.326 | Bridges Property | 0 | Private Conservation 16 | 2 | |
11541 | 11541 | 11540 | {"type": "Polygon", "coordinates": [[[-116.88975, 32.80209], [-116.88488, 32.80571], [-116.88212, 32.80795], [-116.88059, 32.80794], [-116.88059, 32.80435], [-116.88489, 32.80431], [-116.88492, 32.80091], [-116.87626, 32.80088], [-116.87625, 32.79348], [-116.8719, 32.79355], [-116.87185, 32.7905], [-116.86734, 32.79039], [-116.86564, 32.79011], [-116.86281, 32.79004], [-116.86273, 32.78651], [-116.85814, 32.78609], [-116.8582, 32.78275], [-116.86725, 32.78347], [-116.86725, 32.78691], [-116.87625, 32.78778], [-116.8847, 32.78775], [-116.88471, 32.78835], [-116.88466, 32.80066], [-116.88467, 32.80066], [-116.88552, 32.79991], [-116.88576, 32.79977], [-116.88578, 32.79976], [-116.88582, 32.79981], [-116.88587, 32.79984], [-116.88598, 32.79984], [-116.88607, 32.79978], [-116.88609, 32.79973], [-116.88609, 32.79967], [-116.88613, 32.79963], [-116.88632, 32.79956], [-116.88653, 32.79952], [-116.88688, 32.79951], [-116.88723, 32.79957], [-116.88744, 32.79964], [-116.88765, 32.79975], [-116.88855, 32.80046], [-116.88872, 32.80056], [-116.8889, 32.80061], [-116.88896, 32.80068], [-116.88895, 32.80074], [-116.88882, 32.80092], [-116.88881, 32.801], [-116.88883, 32.80115], [-116.88889, 32.80129], [-116.88902, 32.80148], [-116.88925, 32.80165], [-116.88975, 32.80209]]]} | No Public Access 3 | 46833 | South Crest Properties | 30301 | 3208 | Endangered Habitats Conservancy 79 | Non Profit 6 | Non Profit - Conservation 12 | http://www.ehleague.org/EndangeredHabitatsConservancy.html | Non Governmental Organization 10 | 3208 | Endangered Habitats Conservancy 77 | Non Profit 6 | Non Profit - Conservation 12 | San Diego 4 | 586.423 | South Crest Properties | 0 | Private Conservation 16 | 2 | |
11540 | 11540 | 11539 | {"type": "Polygon", "coordinates": [[[-116.88944, 32.80854], [-116.88892, 32.80921], [-116.88842, 32.809], [-116.8881, 32.80881], [-116.88819, 32.80758], [-116.88937, 32.8079], [-116.88944, 32.80854]]]} | No Public Access 3 | 46832 | Saxena/La Cresta Property | 30300 | 3208 | Endangered Habitats Conservancy 79 | Non Profit 6 | Non Profit - Conservation 12 | http://www.ehleague.org/EndangeredHabitatsConservancy.html | Non Governmental Organization 10 | 3208 | Endangered Habitats Conservancy 77 | Non Profit 6 | Non Profit - Conservation 12 | San Diego 4 | 4.044 | Saxena/La Cresta Property | 0 | Private Conservation 16 | 2 | |
11539 | 11539 | 11538 | {"type": "Polygon", "coordinates": [[[-116.89741, 32.80669], [-116.89677, 32.80745], [-116.89737, 32.80782], [-116.89656, 32.80874], [-116.8966, 32.80905], [-116.89615, 32.80913], [-116.89571, 32.80924], [-116.89504, 32.80952], [-116.894, 32.80809], [-116.89443, 32.80579], [-116.89458, 32.80576], [-116.89741, 32.80669]]]} | No Public Access 3 | 46831 | Sarjay/La Cresta Property | 30299 | 3208 | Endangered Habitats Conservancy 79 | Non Profit 6 | Non Profit - Conservation 12 | http://www.ehleague.org/EndangeredHabitatsConservancy.html | Non Governmental Organization 10 | 3208 | Endangered Habitats Conservancy 77 | Non Profit 6 | Non Profit - Conservation 12 | San Diego 4 | 21.548 | Sarjay/La Cresta Property | 0 | Private Conservation 16 | 2 | |
11530 | 11530 | 11529 | {"type": "MultiPolygon", "coordinates": [[[[-116.84201, 32.81202], [-116.84191, 32.8121], [-116.84131, 32.81251], [-116.8413, 32.81202], [-116.84201, 32.81202]]], [[[-116.84567, 32.81198], [-116.84566, 32.81571], [-116.84136, 32.8157], [-116.84133, 32.81349], [-116.84145, 32.81348], [-116.84145, 32.81308], [-116.84132, 32.81295], [-116.84132, 32.81279], [-116.84209, 32.81225], [-116.84236, 32.81201], [-116.84567, 32.81198]]]]} | No Public Access 3 | 46826 | Harbison Canyon Property | 30294 | 3208 | Endangered Habitats Conservancy 79 | Non Profit 6 | Non Profit - Conservation 12 | http://www.ehleague.org/EndangeredHabitatsConservancy.html | Non Governmental Organization 10 | 3208 | Endangered Habitats Conservancy 77 | Non Profit 6 | Non Profit - Conservation 12 | San Diego 4 | 40.355 | Harbison Canyon Property | 0 | Private Conservation 16 | 2 | |
11527 | 11527 | 11526 | {"type": "Polygon", "coordinates": [[[-116.89504, 32.80952], [-116.89448, 32.80974], [-116.89425, 32.80982], [-116.89392, 32.80989], [-116.89358, 32.80992], [-116.89315, 32.80992], [-116.89296, 32.80991], [-116.89182, 32.80963], [-116.89176, 32.80812], [-116.89229, 32.80568], [-116.89368, 32.8059], [-116.89443, 32.80579], [-116.894, 32.80809], [-116.89504, 32.80952]]]} | No Public Access 3 | 46835 | Walker Priest/La Cresta Property | 30303 | 3208 | Endangered Habitats Conservancy 79 | Non Profit 6 | Non Profit - Conservation 12 | http://www.ehleague.org/EndangeredHabitatsConservancy.html | Non Governmental Organization 10 | 3208 | Endangered Habitats Conservancy 77 | Non Profit 6 | Non Profit - Conservation 12 | San Diego 4 | 25.204 | Walker Priest/La Cresta Property | 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 |
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 |
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]);