units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
4 rows where DES_TP = 4, MNG_AG_LEV = 4 and MNG_AG_TYP = 13
This data as json, copyable, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8399 | 8399 | 8398 | {"type": "MultiPolygon", "coordinates": [[[[-117.25509, 33.42391], [-117.25507, 33.42577], [-117.25286, 33.42579], [-117.25273, 33.43184], [-117.24942, 33.4319], [-117.25152, 33.43492], [-117.252, 33.43574], [-117.25059, 33.43576], [-117.24973, 33.43469], [-117.24851, 33.43454], [-117.24779, 33.43513], [-117.2476, 33.43454], [-117.24771, 33.43361], [-117.24702, 33.43192], [-117.24698, 33.43184], [-117.24686, 33.4317], [-117.24681, 33.43162], [-117.24676, 33.43134], [-117.24664, 33.43092], [-117.2459, 33.43091], [-117.2441, 33.43197], [-117.24414, 33.43116], [-117.24436, 33.43085], [-117.24534, 33.42972], [-117.24615, 33.42945], [-117.24678, 33.42915], [-117.24696, 33.42886], [-117.24702, 33.4284], [-117.24745, 33.4284], [-117.24782, 33.42813], [-117.24852, 33.42754], [-117.24812, 33.42723], [-117.24751, 33.42724], [-117.24704, 33.42665], [-117.24677, 33.42611], [-117.24752, 33.42605], [-117.24752, 33.42553], [-117.24685, 33.42478], [-117.2467, 33.42393], [-117.2455, 33.42393], [-117.24662, 33.42307], [-117.2465, 33.42189], [-117.24605, 33.4206], [-117.24457, 33.42331], [-117.24486, 33.41718], [-117.24236, 33.41935], [-117.2399, 33.41965], [-117.23991, 33.41736], [-117.23931, 33.41655], [-117.23894, 33.41655], [-117.23738, 33.41734], [-117.23721, 33.41772], [-117.2373, 33.41852], [-117.23646, 33.41851], [-117.23622, 33.4189], [-117.23614, 33.4203], [-117.236, 33.42051], [-117.23549, 33.42086], [-117.2332, 33.42063], [-117.23378, 33.41972], [-117.23407, 33.41937], [-117.23428, 33.41916], [-117.23335, 33.4184], [-117.23368, 33.41792], [-117.23382, 33.41693], [-117.23352, 33.41659], [-117.23368, 33.41658], [-117.23519, 33.41582], [-117.23477, 33.41483], [-117.23423, 33.41477], [-117.23353, 33.41511], [-117.23288, 33.4157], [-117.23222, 33.4144], [-117.23277, 33.41441], [-117.23322, 33.41397], [-117.2329, 33.41341], [-117.23326, 33.41297], [-117.23326, 33.41296], [-117.23302, 33.41296], [-117.23256, 33.41337], [-117.23179, 33.41343], [-117.23062, 33.41386], [-117.23029, 33.41339], [-117.22974, 33.41406], [-117.22768, 33.41368], [-117.22766, 33.41316], [-117.22758, 33.41343], [-117.22758, 33.41368], [-117.22527, 33.41322], [-117.22527, 33.41192], [-117.22604, 33.41159], [-117.22617, 33.4115], [-117.22629, 33.41139], [-117.22719, 33.41042], [-117.22762, 33.40973], [-117.22762, 33.40945], [-117.22444, 33.40946], [-117.22349, 33.40961], [-117.22213, 33.41032], [-117.22076, 33.41071], [-117.21932, 33.41271], [-117.21896, 33.41299], [-117.21774, 33.41308], [-117.21644, 33.41474], [-117.21702, 33.41563], [-117.21594, 33.41659], [-117.21385, 33.41852], [-117.21129, 33.41814], [-117.21055, 33.41853], [-117.21011, 33.41882], [-117.2099, 33.41899], [-117.20947, 33.41944], [-117.207, 33.42027], [-117.20594, 33.42169], [-117.20646, 33.42219], [-117.20604, 33.42298], [-117.20624, 33.42356], [-117.20525, 33.42514], [-117.20514, 33.42791], [-117.20073, 33.42797], [-117.19932, 33.42801], [-117.19721, 33.42851], [-117.19685, 33.429], [-117.19525, 33.42933], [-117.19537, 33.42845], [-117.19556, 33.42806], [-117.19593, 33.42745], [-117.19672, 33.42693], [-117.19772, 33.42653], [-117.19837, 33.42617], [-117.19885, 33.4263], [-117.19919, 33.42637], [-117.19993, 33.4263], [-117.2004, 33.42604], [-117.20153, 33.42545], [-117.20215, 33.42477], [-117.20225, 33.42481], [-117.2025, 33.42438], [-117.2025, 33.42416], [-117.20231, 33.42401], [-117.20283, 33.42333], [-117.20327, 33.42289], [-117.20342, 33.42241], [-117.20295, 33.42201], [-117.20339, 33.4218], [-117.20385, 33.42105], [-117.20471, 33.42044], [-117.20594, 33.41899], [-117.20611, 33.41841], [-117.20696, 33.41799], [-117.20765, 33.41759], [-117.20767, 33.41674], [-117.20997, 33.41674], [-117.20997, 33.41493], [-117.21132, 33.4149], [-117.21179, 33.41458], [-117.2137, 33.41181], [-117.21313, 33.411], [-117.21023, 33.41193], [-117.20983, 33.41151], [-117.20953, 33.41087], [-117.20855, 33.41062], [-117.20832, 33.41026], [-117.20857, 33.4101], [-117.21083, 33.41009], [-117.21126, 33.40946], [-117.21146, 33.40946], [-117.21206, 33.40839], [-117.21285, 33.40648], [-117.21303, 33.40595], [-117.2143, 33.40738], [-117.21505, 33.40782], [-117.21727, 33.4079], [-117.21877, 33.40592], [-117.21866, 33.40206], [-117.22354, 33.40206], [-117.22373, 33.40177], [-117.22472, 33.40101], [-117.22477, 33.40099], [-117.22477, 33.40111], [-117.22469, 33.40125], [-117.22436, 33.40193], [-117.2244, 33.40236], [-117.22463, 33.40283], [-117.22482, 33.4037], [-117.22515, 33.40437], [-117.22525, 33.40477], [-117.22524, 33.40504], [-117.22511, 33.40524], [-117.22472, 33.40539], [-117.22411, 33.40544], [-117.22362, 33.40558], [-117.22325, 33.40576], [-117.2228, 33.4061], [-117.22244, 33.40669], [-117.22072, 33.40777], [-117.22023, 33.40797], [-117.2197, 33.40804], [-117.21918, 33.40848], [-117.21885, 33.40867], [-117.21885, 33.40876], [-117.21886, 33.40876], [-117.21922, 33.40856], [-117.21972, 33.40814], [-117.22026, 33.40806], [-117.22075, 33.40785], [-117.2225, 33.40675], [-117.22286, 33.40617], [-117.22327, 33.40586], [-117.22366, 33.40567], [-117.22412, 33.40553], [-117.22477, 33.40547], [-117.22514, 33.40531], [-117.22532, 33.40508], [-117.22533, 33.40505], [-117.22533, 33.40477], [-117.22522, 33.40436], [-117.22492, 33.4037], [-117.22472, 33.40278], [-117.2245, 33.40234], [-117.22446, 33.40196], [-117.22488, 33.40108], [-117.22487, 33.40095], [-117.22492, 33.40093], [-117.22492, 33.40086], [-117.22518, 33.40065], [-117.2252, 33.40067], [-117.2258, 33.40384], [-117.22622, 33.40402], [-117.22731, 33.40361], [-117.22776, 33.40329], [-117.22772, 33.40377], [-117.22729, 33.40412], [-117.2279, 33.40412], [-117.2279, 33.40422], [-117.22751, 33.4043], [-117.22737, 33.40445], [-117.22709, 33.40521], [-117.22709, 33.40523], [-117.22744, 33.40534], [-117.22784, 33.40535], [-117.22853, 33.40476], [-117.23007, 33.40526], [-117.23064, 33.40534], [-117.23333, 33.40613], [-117.23355, 33.40699], [-117.23408, 33.40723], [-117.23414, 33.40566], [-117.2354, 33.40563], [-117.23556, 33.40492], [-117.23618, 33.40304], [-117.23813, 33.4025], [-117.2391, 33.40374], [-117.24061, 33.40553], [-117.24062, 33.40673], [-117.24143, 33.40775], [-117.24141, 33.40901], [-117.24137, 33.40924], [-117.24158, 33.40981], [-117.24256, 33.41119], [-117.24329, 33.41148], [-117.24371, 33.41134], [-117.24446, 33.41048], [-117.24467, 33.41009], [-117.24499, 33.40889], [-117.24516, 33.40741], [-117.24625, 33.40749], [-117.24633, 33.40767], [-117.24793, 33.40884], [-117.24795, 33.40995], [-117.2492, 33.40993], [-117.24916, 33.41271], [-117.25324, 33.41265], [-117.25326, 33.41662], [-117.25018, 33.41663], [-117.2501, 33.42028], [-117.2528, 33.42029], [-117.25283, 33.42212], [-117.25509, 33.42211], [-117.25509, 33.42391]], [[-117.24494, 33.4121], [-117.24494, 33.41189], [-117.24384, 33.41259], [-117.24369, 33.41273], [-117.2435, 33.41295], [-117.24313, 33.41333], [-117.24302, 33.41341], [-117.2429, 33.41348], [-117.24273, 33.41353], [-117.24257, 33.41356], [-117.24181, 33.41353], [-117.24163, 33.41356], [-117.24154, 33.4136], [-117.24143, 33.41368], [-117.24054, 33.41454], [-117.24047, 33.41457], [-117.24041, 33.41457], [-117.24035, 33.41454], [-117.23968, 33.41387], [-117.23954, 33.41362], [-117.23945, 33.41349], [-117.23935, 33.41338], [-117.23919, 33.41325], [-117.23908, 33.41312], [-117.23899, 33.41304], [-117.23876, 33.41294], [-117.23855, 33.4129], [-117.23833, 33.41293], [-117.23812, 33.41301], [-117.23796, 33.41314], [-117.23785, 33.41331], [-117.23746, 33.41479], [-117.23693, 33.4159], [-117.23676, 33.41636], [-117.23659, 33.41665], [-117.23651, 33.41672], [-117.2363, 33.41687], [-117.23615, 33.41703], [-117.23605, 33.4172], [-117.23616, 33.41726], [-117.23629, 33.41705], [-117.2364, 33.41693], [-117.2366, 33.4168], [-117.23669, 33.41672], [-117.23686, 33.41645], [-117.23693, 33.41631], [-117.23706, 33.41594], [-117.23735, 33.41533], [-117.23764, 33.41482], [-117.23805, 33.41332], [-117.23812, 33.41323], [-117.2382, 33.41316], [-117.23831, 33.41311], [-117.23842, 33.41308], [-117.23855, 33.41307], [-117.23866, 33.41308], [-117.23883, 33.41314], [-117.2389, 33.41319], [-117.23904, 33.41336], [-117.2393, 33.4136], [-117.23953, 33.41399], [-117.24102, 33.41547], [-117.24114, 33.41556], [-117.24126, 33.41562], [-117.24257, 33.41613], [-117.24277, 33.41617], [-117.24397, 33.41603], [-117.24407, 33.416], [-117.24438, 33.41586], [-117.24484, 33.41572], [-117.24496, 33.41567], [-117.24505, 33.41559], [-117.24513, 33.41551], [-117.24518, 33.41542], [-117.24524, 33.41528], [-117.24529, 33.41506], [-117.24529, 33.41497], [-117.24527, 33.41486], [-117.24522, 33.41476], [-117.24515, 33.41468], [-117.24504, 33.41462], [-117.24427, 33.41434], [-117.24413, 33.41425], [-117.24402, 33.41416], [-117.2438, 33.41391], [-117.24351, 33.41367], [-117.24334, 33.41346], [-117.24333, 33.41342], [-117.24335, 33.41337], [-117.24365, 33.41307], [-117.2438, 33.41287], [-117.24393, 33.41275], [-117.24494, 33.4121]]], [[[-117.24492, 33.41475], [-117.24499, 33.41478], [-117.24506, 33.41485], [-117.24509, 33.41492], [-117.2451, 33.41499], [-117.24506, 33.41518], [-117.245, 33.41535], [-117.24494, 33.41545], [-117.24484, 33.41552], [-117.24474, 33.41557], [-117.24428, 33.41571], [-117.24393, 33.41587], [-117.24277, 33.416], [-117.24263, 33.41598], [-117.24127, 33.41543], [-117.24117, 33.41536], [-117.24064, 33.41482], [-117.24061, 33.41475], [-117.24064, 33.41469], [-117.24158, 33.41379], [-117.24167, 33.41373], [-117.24181, 33.4137], [-117.24242, 33.41373], [-117.24262, 33.41372], [-117.24286, 33.41367], [-117.24314, 33.41356], [-117.24321, 33.41359], [-117.24336, 33.41377], [-117.24364, 33.414], [-117.24388, 33.41427], [-117.24404, 33.4144], [-117.24419, 33.41448], [-117.24492, 33.41475]]]]} | Open Access 1 | 47790 | Santa Margarita River Preserve | 31668 | 2034 | Fallbrook Public Utility District 870 | Special District 4 | Water District 13 | https://www.fpud.com/ | Special District 4 | 2034 | Fallbrook Public Utility District 866 | Special District 4 | Water District 13 | San Diego 4 | 1377.733 | Santa Margarita River Preserve | 0 | Local Conservation Area 4 | 2 | |
| 9221 | 9221 | 9220 | {"type": "Polygon", "coordinates": [[[-116.54539, 33.87038], [-116.54531, 33.88839], [-116.52908, 33.8882], [-116.51701, 33.88079], [-116.51072, 33.87731], [-116.51072, 33.87426], [-116.52798, 33.87415], [-116.52798, 33.8741], [-116.52804, 33.87409], [-116.52804, 33.87175], [-116.52813, 33.86807], [-116.52889, 33.8684], [-116.53005, 33.86884], [-116.53122, 33.86923], [-116.53242, 33.86956], [-116.53324, 33.86975], [-116.53488, 33.87006], [-116.53571, 33.87017], [-116.53697, 33.87031], [-116.53823, 33.87039], [-116.53908, 33.87041], [-116.54539, 33.87038]]]} | Restricted Access 2 | 15339 | Whitewater Floodplain Preserve | 27469 | 2019 | Coachella Valley Water District 905 | Special District 4 | Water District 13 | http://www.cvwd.org/ | Special District 4 | 2019 | Coachella Valley Water District 880 | Special District 4 | Water District 13 | Riverside 10 | 1162.356 | Whitewater Floodplain Preserve | 0 | Local Conservation Area 4 | 2 | |
| 9240 | 9240 | 9239 | {"type": "MultiPolygon", "coordinates": [[[[-121.54901, 36.93552], [-121.549, 36.93611], [-121.54882, 36.93705], [-121.5486, 36.93685], [-121.54862, 36.93671], [-121.54872, 36.9366], [-121.54873, 36.93648], [-121.54867, 36.93646], [-121.5487, 36.93629], [-121.54861, 36.93569], [-121.54765, 36.93513], [-121.54763, 36.935], [-121.54515, 36.93499], [-121.54345, 36.93831], [-121.54138, 36.93918], [-121.54121, 36.93996], [-121.541, 36.94031], [-121.54047, 36.94128], [-121.53849, 36.94129], [-121.53673, 36.94358], [-121.53605, 36.94437], [-121.53605, 36.9465], [-121.53608, 36.94709], [-121.53607, 36.94755], [-121.53593, 36.94879], [-121.53593, 36.94916], [-121.53288, 36.94791], [-121.53326, 36.94725], [-121.53339, 36.9469], [-121.53349, 36.94609], [-121.53361, 36.94562], [-121.53373, 36.94514], [-121.53399, 36.94451], [-121.53398, 36.94417], [-121.53409, 36.94385], [-121.5344, 36.94343], [-121.5352, 36.94296], [-121.53533, 36.94274], [-121.53554, 36.94223], [-121.53583, 36.94169], [-121.53613, 36.94152], [-121.5366, 36.94107], [-121.53708, 36.94057], [-121.53739, 36.94022], [-121.53765, 36.94005], [-121.53796, 36.93996], [-121.53848, 36.93963], [-121.53873, 36.93952], [-121.53905, 36.93942], [-121.53931, 36.93929], [-121.53947, 36.93915], [-121.53996, 36.93831], [-121.54011, 36.93814], [-121.5404, 36.93796], [-121.54127, 36.93765], [-121.54166, 36.93754], [-121.54203, 36.93714], [-121.54223, 36.93682], [-121.54249, 36.93648], [-121.54252, 36.93618], [-121.5425, 36.93566], [-121.54256, 36.93528], [-121.54275, 36.93504], [-121.54359, 36.93439], [-121.54367, 36.93419], [-121.54371, 36.93387], [-121.54367, 36.93359], [-121.54351, 36.93318], [-121.54321, 36.93265], [-121.54301, 36.93193], [-121.54284, 36.93149], [-121.54251, 36.93097], [-121.5423, 36.93054], [-121.54211, 36.92995], [-121.54197, 36.92966], [-121.54181, 36.92901], [-121.54178, 36.92873], [-121.54167, 36.92818], [-121.54113, 36.92744], [-121.54088, 36.92687], [-121.54069, 36.92647], [-121.54061, 36.9261], [-121.5407, 36.92576], [-121.54068, 36.92576], [-121.5404, 36.92599], [-121.53995, 36.92599], [-121.53994, 36.92598], [-121.5401, 36.92588], [-121.54048, 36.92572], [-121.54081, 36.92545], [-121.54092, 36.92515], [-121.54089, 36.92486], [-121.54082, 36.92472], [-121.54051, 36.92429], [-121.54031, 36.92409], [-121.54008, 36.9239], [-121.53984, 36.92368], [-121.53949, 36.92343], [-121.53923, 36.92302], [-121.53919, 36.92291], [-121.54048, 36.92421], [-121.54068, 36.92418], [-121.54125, 36.92449], [-121.54134, 36.92457], [-121.54213, 36.92541], [-121.54282, 36.92621], [-121.54293, 36.92628], [-121.54308, 36.92635], [-121.54349, 36.92644], [-121.54377, 36.92647], [-121.54438, 36.9265], [-121.54449, 36.92652], [-121.54466, 36.9266], [-121.54508, 36.9269], [-121.54522, 36.92703], [-121.54535, 36.92722], [-121.54559, 36.92765], [-121.54568, 36.92777], [-121.5465, 36.92859], [-121.54681, 36.92879], [-121.54713, 36.92881], [-121.54738, 36.92913], [-121.54803, 36.92996], [-121.54809, 36.93056], [-121.54454, 36.93123], [-121.54454, 36.93125], [-121.54508, 36.9325], [-121.54551, 36.93284], [-121.54631, 36.93284], [-121.54665, 36.93301], [-121.5474, 36.93298], [-121.54763, 36.9334], [-121.54758, 36.93377], [-121.5477, 36.93414], [-121.54788, 36.93444], [-121.54796, 36.93491], [-121.54901, 36.93552]]], [[[-121.55239, 36.94284], [-121.55219, 36.94286], [-121.55189, 36.94222], [-121.55171, 36.94155], [-121.55116, 36.94063], [-121.55112, 36.93858], [-121.54879, 36.93856], [-121.54916, 36.93661], [-121.55147, 36.93685], [-121.5515, 36.93708], [-121.5516, 36.9394], [-121.55153, 36.94059], [-121.55207, 36.94146], [-121.55238, 36.94236], [-121.55239, 36.94284]]]]} | No Public Access 3 | 15376 | Carnadero Preserve | 16881 | 2143 | Santa Clara Valley Water District 483 | Special District 4 | Water District 13 | http://www.valleywater.org/ | Special District 4 | 2143 | Santa Clara Valley Water District 798 | Special District 4 | Water District 13 | Santa Clara 19 | 196.338 | Carnadero Preserve | 0 | Local Conservation Area 4 | 2 | |
| 9405 | 9405 | 9404 | {"type": "Polygon", "coordinates": [[[-119.96624, 37.50102], [-119.96556, 37.50341], [-119.96444, 37.50422], [-119.96448, 37.50478], [-119.96518, 37.50519], [-119.96586, 37.50517], [-119.96582, 37.50589], [-119.96583, 37.50609], [-119.96585, 37.50628], [-119.9659, 37.50648], [-119.96598, 37.5067], [-119.96623, 37.50714], [-119.9663, 37.5073], [-119.96636, 37.50761], [-119.96635, 37.50779], [-119.96632, 37.50788], [-119.96625, 37.508], [-119.96616, 37.50811], [-119.96606, 37.50819], [-119.96591, 37.50827], [-119.9654, 37.50848], [-119.96506, 37.50865], [-119.96459, 37.50895], [-119.96442, 37.50912], [-119.96436, 37.50923], [-119.96432, 37.50935], [-119.96429, 37.50974], [-119.96426, 37.50995], [-119.9642, 37.51021], [-119.96409, 37.51056], [-119.96395, 37.5109], [-119.96378, 37.51124], [-119.96364, 37.51148], [-119.96347, 37.51172], [-119.9632, 37.51199], [-119.96288, 37.51221], [-119.96223, 37.51256], [-119.96057, 37.5135], [-119.95902, 37.51434], [-119.95847, 37.51483], [-119.95726, 37.51661], [-119.95646, 37.51732], [-119.95523, 37.51781], [-119.95478, 37.51801], [-119.95444, 37.51819], [-119.95337, 37.51884], [-119.95306, 37.51901], [-119.95264, 37.51921], [-119.95219, 37.51938], [-119.95162, 37.51956], [-119.95114, 37.51968], [-119.95063, 37.51977], [-119.95068, 37.51288], [-119.95404, 37.51292], [-119.95424, 37.50499], [-119.95743, 37.50084], [-119.95628, 37.49975], [-119.95711, 37.49844], [-119.95956, 37.49675], [-119.96147, 37.49852], [-119.9622, 37.49803], [-119.96371, 37.49895], [-119.9644, 37.50016], [-119.96624, 37.50102]]]} | Open Access 1 | 47813 | Stockton Creek Preserve | 31695 | 2415 | Mariposa Public Utility District 909 | Special District 4 | Water District 13 | http://www.mariposapud.org/ | Special District 4 | 2415 | Mariposa Public Utility District 882 | Special District 4 | Water District 13 | Mariposa 31 | 457.205 | Stockton Creek Preserve | 2011 | 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]);