calands: units_with_maps: 1 row where ACCESS_TYP = 1, DES_TP = 8 and UNIT

Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette

1 row where ACCESS_TYP = 1, DES_TP = 8 and UNIT_NAME = "Canebrake Ecological Reserve"

Search:

descending

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
5420	5420	5419	{"type": "MultiPolygon", "coordinates": [[[[-118.27242, 35.67433], [-118.27014, 35.67796], [-118.2638, 35.67802], [-118.264, 35.67436], [-118.27242, 35.67433]]], [[[-118.25472, 35.68133], [-118.24592, 35.68145], [-118.24585, 35.67796], [-118.25458, 35.67776], [-118.25472, 35.68133]]], [[[-118.30794, 35.68146], [-118.30358, 35.68149], [-118.30356, 35.68506], [-118.29466, 35.68502], [-118.29457, 35.68151], [-118.29027, 35.68149], [-118.29025, 35.6794], [-118.29219, 35.67908], [-118.29209, 35.67798], [-118.29896, 35.67796], [-118.29889, 35.67609], [-118.3055, 35.67607], [-118.30557, 35.67964], [-118.30793, 35.67964], [-118.30794, 35.68146]]], [[[-118.29007, 35.68826], [-118.29007, 35.68874], [-118.27693, 35.68874], [-118.27689, 35.68515], [-118.27242, 35.68512], [-118.27241, 35.68149], [-118.27672, 35.68152], [-118.27657, 35.67804], [-118.28099, 35.67803], [-118.28093, 35.67704], [-118.28533, 35.67702], [-118.2853, 35.67602], [-118.29004, 35.67601], [-118.29007, 35.68486], [-118.28896, 35.68487], [-118.28899, 35.68822], [-118.29007, 35.68826]]], [[[-118.21906, 35.67774], [-118.21902, 35.68119], [-118.21668, 35.68123], [-118.21668, 35.68289], [-118.21404, 35.68305], [-118.21331, 35.68302], [-118.21274, 35.68295], [-118.21236, 35.68288], [-118.21182, 35.68275], [-118.2113, 35.68256], [-118.211, 35.68242], [-118.21065, 35.68222], [-118.21038, 35.68203], [-118.21014, 35.68183], [-118.2098, 35.68146], [-118.208, 35.67926], [-118.20792, 35.67929], [-118.20745, 35.67872], [-118.20723, 35.67849], [-118.20694, 35.67825], [-118.20662, 35.67804], [-118.20627, 35.67786], [-118.20588, 35.6777], [-118.20558, 35.67753], [-118.20535, 35.67736], [-118.20515, 35.67717], [-118.20366, 35.67516], [-118.20254, 35.67356], [-118.20119, 35.67084], [-118.201, 35.67052], [-118.20073, 35.67015], [-118.19972, 35.66952], [-118.1987, 35.66895], [-118.19842, 35.66882], [-118.19821, 35.66876], [-118.19797, 35.6687], [-118.19619, 35.6685], [-118.19611, 35.66845], [-118.1961, 35.66842], [-118.19604, 35.66785], [-118.19599, 35.66766], [-118.19592, 35.6675], [-118.19582, 35.66735], [-118.1957, 35.66722], [-118.19532, 35.66688], [-118.19507, 35.66662], [-118.19485, 35.66635], [-118.19469, 35.66614], [-118.19451, 35.66584], [-118.19435, 35.66554], [-118.19421, 35.66523], [-118.19411, 35.66491], [-118.194, 35.66439], [-118.19397, 35.66406], [-118.19397, 35.66381], [-118.194, 35.66339], [-118.19426, 35.66142], [-118.1943, 35.66097], [-118.19431, 35.66051], [-118.19429, 35.66006], [-118.19418, 35.65931], [-118.19408, 35.65886], [-118.19395, 35.65842], [-118.19367, 35.6577], [-118.19313, 35.65609], [-118.1928, 35.65521], [-118.19257, 35.6545], [-118.19233, 35.65396], [-118.19163, 35.65255], [-118.19165, 35.65247], [-118.19163, 35.65241], [-118.19158, 35.65235], [-118.19149, 35.65232], [-118.19142, 35.65233], [-118.19134, 35.65237], [-118.19131, 35.65243], [-118.19132, 35.6525], [-118.19136, 35.65256], [-118.19144, 35.65261], [-118.19215, 35.65405], [-118.19238, 35.65457], [-118.1926, 35.65525], [-118.19318, 35.65686], [-118.19347, 35.65775], [-118.19374, 35.65845], [-118.19387, 35.65888], [-118.19397, 35.65932], [-118.19408, 35.66006], [-118.1941, 35.6605], [-118.1941, 35.6608], [-118.19406, 35.66139], [-118.19379, 35.66339], [-118.19377, 35.66365], [-118.19377, 35.664], [-118.19378, 35.66426], [-118.19382, 35.66452], [-118.19389, 35.66486], [-118.19398, 35.66518], [-118.19411, 35.6655], [-118.1943, 35.66588], [-118.1945, 35.6662], [-118.19466, 35.66642], [-118.1949, 35.66671], [-118.19522, 35.66704], [-118.19555, 35.66733], [-118.19564, 35.66743], [-118.19573, 35.66758], [-118.19579, 35.6677], [-118.19584, 35.66787], [-118.19589, 35.66844], [-118.19593, 35.66853], [-118.19602, 35.66862], [-118.19613, 35.66866], [-118.19789, 35.66886], [-118.19815, 35.66891], [-118.19836, 35.66898], [-118.19859, 35.66909], [-118.19966, 35.66969], [-118.20058, 35.67026], [-118.20078, 35.67053], [-118.201, 35.67091], [-118.20236, 35.67363], [-118.20349, 35.67525], [-118.20499, 35.67727], [-118.2052, 35.67747], [-118.20545, 35.67765], [-118.20576, 35.67783], [-118.20621, 35.67802], [-118.20654, 35.67819], [-118.2068, 35.67836], [-118.20711, 35.67862], [-118.20728, 35.6788], [-118.20776, 35.67938], [-118.2077, 35.67942], [-118.2077, 35.67943], [-118.20957, 35.68172], [-118.20991, 35.68207], [-118.2103, 35.68237], [-118.21079, 35.68267], [-118.21106, 35.6828], [-118.2114, 35.68294], [-118.21176, 35.68305], [-118.21226, 35.68317], [-118.21297, 35.68329], [-118.21355, 35.68334], [-118.21405, 35.68335], [-118.21668, 35.68319], [-118.21678, 35.68857], [-118.21455, 35.68857], [-118.21014, 35.68864], [-118.2057, 35.68868], [-118.20568, 35.68512], [-118.20124, 35.6851], [-118.20123, 35.6742], [-118.18818, 35.67423], [-118.18819, 35.66821], [-118.18816, 35.66173], [-118.18806, 35.65614], [-118.18346, 35.65614], [-118.18348, 35.64518], [-118.18347, 35.64151], [-118.18792, 35.64154], [-118.1879, 35.64517], [-118.19238, 35.64518], [-118.19241, 35.64893], [-118.20127, 35.64886], [-118.20127, 35.65245], [-118.20125, 35.6577], [-118.20127, 35.65971], [-118.20124, 35.6633], [-118.20578, 35.66334], [-118.20581, 35.66689], [-118.2102, 35.66689], [-118.21026, 35.67055], [-118.21464, 35.67054], [-118.21462, 35.67416], [-118.21464, 35.67777], [-118.21906, 35.67774]]], [[[-118.17001, 35.69804], [-118.16563, 35.69811], [-118.16563, 35.69627], [-118.16998, 35.69616], [-118.17001, 35.69804]]], [[[-118.18179, 35.70339], [-118.1811, 35.70432], [-118.17771, 35.70876], [-118.17713, 35.7095], [-118.17664, 35.71004], [-118.17612, 35.71056], [-118.17482, 35.71178], [-118.17446, 35.71209], [-118.17393, 35.71263], [-118.17377, 35.71282], [-118.17362, 35.71302], [-118.17335, 35.71344], [-118.17314, 35.71389], [-118.17297, 35.71433], [-118.17291, 35.71456], [-118.17288, 35.71462], [-118.16558, 35.7148], [-118.16558, 35.71093], [-118.15677, 35.71101], [-118.15673, 35.70738], [-118.15214, 35.70738], [-118.15215, 35.70368], [-118.15651, 35.70363], [-118.15654, 35.7], [-118.14768, 35.70013], [-118.14768, 35.69655], [-118.14761, 35.68927], [-118.15649, 35.6891], [-118.15654, 35.69273], [-118.16101, 35.69271], [-118.16106, 35.69994], [-118.16563, 35.69994], [-118.17001, 35.6999], [-118.17002, 35.70351], [-118.17238, 35.70351], [-118.17454, 35.70348], [-118.17455, 35.69987], [-118.17902, 35.69983], [-118.17905, 35.70342], [-118.18179, 35.70339]], [[-118.16782, 35.70353], [-118.16781, 35.70352], [-118.16566, 35.70353], [-118.16562, 35.70734], [-118.1678, 35.70733], [-118.16782, 35.70353]]], [[[-118.19242, 35.71062], [-118.19023, 35.71064], [-118.19024, 35.71353], [-118.18806, 35.71353], [-118.18805, 35.71441], [-118.18696, 35.71442], [-118.18695, 35.71525], [-118.18468, 35.71528], [-118.18467, 35.71702], [-118.1836, 35.71704], [-118.1836, 35.71794], [-118.17991, 35.71803], [-118.18036, 35.71744], [-118.18164, 35.71554], [-118.18265, 35.7142], [-118.18303, 35.71377], [-118.18339, 35.71341], [-118.18357, 35.71325], [-118.18376, 35.71311], [-118.18417, 35.71285], [-118.18438, 35.71272], [-118.18517, 35.71235], [-118.18811, 35.71115], [-118.18896, 35.71077], [-118.18983, 35.71035], [-118.19026, 35.71013], [-118.19145, 35.7094], [-118.19183, 35.70916], [-118.19241, 35.70872], [-118.19242, 35.71062]]], [[[-118.17152, 35.71825], [-118.17057, 35.72054], [-118.1705, 35.72075], [-118.17031, 35.72119], [-118.17006, 35.72201], [-118.16999, 35.72201], [-118.17007, 35.71828], [-118.17152, 35.71825]]], [[[-118.31683, 35.68866], [-118.31685, 35.69236], [-118.31689, 35.70327], [-118.31681, 35.71416], [-118.31671, 35.71777], [-118.30821, 35.71772], [-118.30779, 35.72501], [-118.30398, 35.72507], [-118.30394, 35.72486], [-118.30294, 35.72434], [-118.3029, 35.72299], [-118.30342, 35.72257], [-118.30387, 35.72162], [-118.30521, 35.72111], [-118.3059, 35.7202], [-118.30549, 35.71844], [-118.30557, 35.71773], [-118.30821, 35.71771], [-118.30815, 35.71412], [-118.30812, 35.7105], [-118.30496, 35.71054], [-118.30317, 35.70803], [-118.30182, 35.70591], [-118.30209, 35.70413], [-118.30214, 35.70273], [-118.30226, 35.70192], [-118.30228, 35.70158], [-118.30227, 35.70131], [-118.30222, 35.70097], [-118.30217, 35.70075], [-118.3012, 35.69766], [-118.30116, 35.69751], [-118.30109, 35.69735], [-118.30092, 35.69712], [-118.30074, 35.69696], [-118.30051, 35.69683], [-118.30022, 35.69674], [-118.30011, 35.69669], [-118.29992, 35.69664], [-118.29975, 35.69663], [-118.29953, 35.69667], [-118.29933, 35.69676], [-118.29919, 35.69676], [-118.29856, 35.69641], [-118.29801, 35.69619], [-118.29764, 35.69608], [-118.29727, 35.69605], [-118.29715, 35.69602], [-118.29912, 35.69601], [-118.29907, 35.68873], [-118.30796, 35.68871], [-118.31683, 35.68866]]], [[[-118.30569, 35.72018], [-118.30507, 35.72099], [-118.30371, 35.72151], [-118.30325, 35.72248], [-118.30269, 35.72293], [-118.30274, 35.72444], [-118.30375, 35.72497], [-118.30377, 35.72507], [-118.29005, 35.72506], [-118.28104, 35.72495], [-118.28119, 35.7178], [-118.28701, 35.71781], [-118.29054, 35.71784], [-118.29046, 35.71417], [-118.29044, 35.71057], [-118.29924, 35.71058], [-118.2991, 35.70334], [-118.29048, 35.70335], [-118.2904, 35.69604], [-118.2968, 35.69602], [-118.29695, 35.69612], [-118.2971, 35.69619], [-118.29725, 35.69622], [-118.29749, 35.69622], [-118.29761, 35.69624], [-118.29809, 35.6964], [-118.29853, 35.69659], [-118.29904, 35.69688], [-118.29912, 35.69691], [-118.29925, 35.69693], [-118.29938, 35.69692], [-118.29957, 35.69684], [-118.29973, 35.6968], [-118.29983, 35.6968], [-118.29998, 35.69682], [-118.30013, 35.69689], [-118.30038, 35.69697], [-118.30054, 35.69704], [-118.30073, 35.69719], [-118.30087, 35.69737], [-118.30096, 35.69755], [-118.301, 35.6977], [-118.30197, 35.70079], [-118.30203, 35.70106], [-118.30207, 35.70138], [-118.30208, 35.70165], [-118.30206, 35.70191], [-118.30194, 35.70272], [-118.30188, 35.70414], [-118.30164, 35.706], [-118.30299, 35.70812], [-118.30475, 35.71054], [-118.29924, 35.71059], [-118.29937, 35.71778], [-118.30535, 35.71773], [-118.3053, 35.71849], [-118.30569, 35.72018]]], [[[-118.16854, 35.72741], [-118.16845, 35.72766], [-118.16839, 35.72781], [-118.16821, 35.72806], [-118.1681, 35.72817], [-118.16785, 35.72835], [-118.16742, 35.72861], [-118.16707, 35.72873], [-118.16653, 35.72885], [-118.16581, 35.72893], [-118.16546, 35.72893], [-118.16546, 35.72663], [-118.1665, 35.72663], [-118.16854, 35.72741]]], [[[-118.1924, 35.70834], [-118.19159, 35.70894], [-118.19087, 35.70943], [-118.19007, 35.70989], [-118.18965, 35.71012], [-118.1888, 35.71053], [-118.18794, 35.71091], [-118.18531, 35.71197], [-118.18472, 35.71223], [-118.18396, 35.71262], [-118.18355, 35.71289], [-118.18333, 35.71305], [-118.18295, 35.71339], [-118.18257, 35.71381], [-118.18197, 35.71455], [-118.18135, 35.7154], [-118.18077, 35.71625], [-118.18042, 35.71679], [-118.17989, 35.71754], [-118.17951, 35.71803], [-118.17903, 35.71805], [-118.17899, 35.71862], [-118.17843, 35.71916], [-118.17761, 35.71984], [-118.17561, 35.72132], [-118.17492, 35.72185], [-118.17445, 35.72226], [-118.17397, 35.72271], [-118.17311, 35.72359], [-118.1721, 35.7248], [-118.17165, 35.72543], [-118.17145, 35.72574], [-118.17112, 35.72638], [-118.17101, 35.72666], [-118.1704, 35.72731], [-118.16989, 35.7278], [-118.16944, 35.72818], [-118.16907, 35.72847], [-118.16874, 35.72869], [-118.16846, 35.72885], [-118.16819, 35.72897], [-118.16769, 35.72916], [-118.16662, 35.72947], [-118.16579, 35.72964], [-118.16523, 35.72972], [-118.16245, 35.72989], [-118.16123, 35.72999], [-118.16055, 35.73002], [-118.15569, 35.73044], [-118.15298, 35.73065], [-118.14959, 35.73088], [-118.14883, 35.73092], [-118.14739, 35.73096], [-118.14458, 35.73098], [-118.1423, 35.73103], [-118.14071, 35.73111], [-118.13919, 35.73122], [-118.13916, 35.72947], [-118.14362, 35.72955], [-118.14799, 35.72967], [-118.14994, 35.72967], [-118.15224, 35.72963], [-118.15665, 35.72951], [-118.16107, 35.72934], [-118.1637, 35.72921], [-118.16408, 35.72917], [-118.166, 35.72907], [-118.16658, 35.729], [-118.16695, 35.72894], [-118.16715, 35.72888], [-118.16734, 35.72882], [-118.16768, 35.72866], [-118.16813, 35.72839], [-118.16838, 35.72816], [-118.16859, 35.72788], [-118.16865, 35.72772], [-118.16877, 35.72734], [-118.1688, 35.72713], [-118.16891, 35.72671], [-118.16991, 35.72318], [-118.17026, 35.72201], [-118.17058, 35.72101], [-118.17068, 35.7208], [-118.17161, 35.71852], [-118.17172, 35.71823], [-118.17456, 35.71816], [-118.17451, 35.71458], [-118.17309, 35.71461], [-118.17316, 35.71437], [-118.17342, 35.71372], [-118.17366, 35.7133], [-118.17394, 35.71291], [-118.17442, 35.71237], [-118.17495, 35.71187], [-118.17534, 35.71155], [-118.17626, 35.71067], [-118.1768, 35.71013], [-118.17745, 35.70941], [-118.17861, 35.70792], [-118.17988, 35.70622], [-118.18203, 35.70338], [-118.18797, 35.70333], [-118.18796, 35.69763], [-118.1887, 35.69711], [-118.19037, 35.69609], [-118.19238, 35.69607], [-118.19237, 35.70331], [-118.1924, 35.70834]]], [[[-118.17895, 35.71909], [-118.17867, 35.72532], [-118.17447, 35.72542], [-118.17456, 35.72905], [-118.17878, 35.72896], [-118.17865, 35.73247], [-118.17868, 35.7361], [-118.1786, 35.73972], [-118.17856, 35.74313], [-118.17736, 35.74314], [-118.17723, 35.74301], [-118.1771, 35.74283], [-118.17685, 35.74245], [-118.17662, 35.74201], [-118.17635, 35.74132], [-118.17629, 35.74109], [-118.17621, 35.74063], [-118.17616, 35.74018], [-118.17615, 35.73995], [-118.17616, 35.73951], [-118.17617, 35.7393], [-118.17617, 35.73865], [-118.17613, 35.73823], [-118.17605, 35.73784], [-118.17593, 35.7375], [-118.17576, 35.73721], [-118.17552, 35.73698], [-118.17525, 35.73677], [-118.17495, 35.7366], [-118.17399, 35.73608], [-118.17368, 35.73588], [-118.17337, 35.73565], [-118.17296, 35.73519], [-118.17269, 35.73481], [-118.17243, 35.73434], [-118.17218, 35.73381], [-118.17193, 35.73321], [-118.17159, 35.73224], [-118.1715, 35.7319], [-118.17126, 35.73088], [-118.17115, 35.73018], [-118.17108, 35.7295], [-118.17104, 35.72847], [-118.17106, 35.72812], [-118.17109, 35.72778], [-118.17122, 35.72712], [-118.17144, 35.72648], [-118.17159, 35.72616], [-118.17176, 35.72585], [-118.17202, 35.72544], [-118.17238, 35.72495], [-118.17287, 35.72435], [-118.17338, 35.72376], [-118.17394, 35.72318], [-118.17446, 35.72266], [-118.17516, 35.72205], [-118.17619, 35.72126], [-118.1772, 35.72052], [-118.17814, 35.7198], [-118.17895, 35.71909]]], [[[-118.17695, 35.74316], [-118.17419, 35.7432], [-118.17427, 35.73972], [-118.16533, 35.73979], [-118.16539, 35.73633], [-118.16107, 35.73651], [-118.1524, 35.73666], [-118.1481, 35.73667], [-118.14371, 35.73659], [-118.14379, 35.7401], [-118.14385, 35.74369], [-118.13496, 35.74391], [-118.13494, 35.74026], [-118.13935, 35.74016], [-118.13919, 35.73136], [-118.14073, 35.73124], [-118.14232, 35.73117], [-118.14459, 35.73112], [-118.14739, 35.7311], [-118.14884, 35.73106], [-118.1496, 35.73102], [-118.15224, 35.73085], [-118.15907, 35.73029], [-118.16187, 35.73007], [-118.16526, 35.72986], [-118.16639, 35.72966], [-118.16722, 35.72945], [-118.16802, 35.72919], [-118.16855, 35.72897], [-118.16883, 35.72882], [-118.16914, 35.72861], [-118.1695, 35.72834], [-118.1699, 35.72798], [-118.17037, 35.72752], [-118.17092, 35.72693], [-118.17087, 35.72706], [-118.17074, 35.72776], [-118.17069, 35.72846], [-118.1707, 35.72916], [-118.17076, 35.72986], [-118.17086, 35.73057], [-118.17105, 35.73161], [-118.17123, 35.7323], [-118.17159, 35.73329], [-118.17197, 35.73419], [-118.17223, 35.73471], [-118.17252, 35.73515], [-118.17281, 35.73552], [-118.17297, 35.73569], [-118.17328, 35.73596], [-118.17379, 35.73631], [-118.1749, 35.7369], [-118.17528, 35.73717], [-118.17547, 35.73738], [-118.17563, 35.73762], [-118.17573, 35.73791], [-118.17582, 35.73847], [-118.17582, 35.73868], [-118.17585, 35.73889], [-118.17583, 35.73909], [-118.17582, 35.73953], [-118.17583, 35.7402], [-118.17585, 35.74044], [-118.17591, 35.74091], [-118.17603, 35.7414], [-118.17631, 35.74212], [-118.17668, 35.74277], [-118.17695, 35.74316]]], [[[-118.13901, 35.73659], [-118.13022, 35.73677], [-118.13022, 35.74385], [-118.12585, 35.7439], [-118.1259, 35.73675], [-118.12828, 35.7367], [-118.12812, 35.73322], [-118.13887, 35.73296], [-118.13901, 35.73659]]], [[[-118.11731, 35.75125], [-118.11291, 35.75131], [-118.11286, 35.74954], [-118.11729, 35.74955], [-118.11731, 35.75125]]]]}	Open Access 1	16631	Canebrake Ecological Reserve	32094	201	California Department of Fish and Wildlife 25	State 5	State Agency 5	https://www.wildlife.ca.gov/	California Department of Fish and Wildlife 6	201	California Department of Fish and Wildlife 25	State 5	State Agency 5	https://www.wildlife.ca.gov/Lands/Places-to-Visit/Canebrake-ER	Kern 36	7374.74	Canebrake ER	1995	State Conservation Area 8	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]);