units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
22 rows where ACCESS_TYP = 1 and DES_TP = 18 sorted by MNG_AG_ID
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15799 | 15799 | 15798 | {"type": "Polygon", "coordinates": [[[-116.97887, 35.72293], [-116.97428, 35.72295], [-116.9745, 35.73155], [-116.93889, 35.73164], [-116.9389, 35.74996], [-116.93904, 35.79547], [-116.93479, 35.79546], [-116.92266, 35.79538], [-116.90559, 35.7954], [-116.90557, 35.79543], [-116.9011, 35.79543], [-116.90106, 35.7954], [-116.83544, 35.79544], [-116.83542, 35.78493], [-116.81773, 35.78487], [-116.81772, 35.78488], [-116.81771, 35.79545], [-116.78406, 35.79538], [-116.76013, 35.7954], [-116.53233, 35.79496], [-116.53231, 35.79501], [-116.53207, 35.79501], [-116.49995, 35.79491], [-116.47973, 35.79476], [-116.45372, 35.7946], [-116.42024, 35.79443], [-116.3402, 35.79391], [-116.34019, 35.79386], [-116.355, 35.79395], [-116.35502, 35.79398], [-116.35503, 35.79396], [-116.35503, 35.79013], [-116.35305, 35.78821], [-116.35243, 35.7873], [-116.35187, 35.7866], [-116.35132, 35.78598], [-116.35088, 35.78529], [-116.34994, 35.78405], [-116.34938, 35.78347], [-116.34911, 35.78331], [-116.34847, 35.78305], [-116.34767, 35.78215], [-116.34733, 35.78169], [-116.34082, 35.76343], [-116.33873, 35.76252], [-116.3383, 35.7623], [-116.33762, 35.76215], [-116.33707, 35.76194], [-116.33658, 35.76177], [-116.33473, 35.76122], [-116.3321, 35.76066], [-116.33143, 35.76057], [-116.33019, 35.76034], [-116.32975, 35.76024], [-116.32926, 35.76], [-116.32871, 35.75977], [-116.32793, 35.75927], [-116.32753, 35.75897], [-116.32722, 35.75883], [-116.32695, 35.75876], [-116.3266, 35.75871], [-116.32608, 35.75873], [-116.32566, 35.75877], [-116.32424, 35.75899], [-116.3235, 35.75781], [-116.32325, 35.75735], [-116.3226, 35.7565], [-116.32222, 35.75595], [-116.32081, 35.7543], [-116.32014, 35.75361], [-116.31945, 35.75283], [-116.31907, 35.75234], [-116.31848, 35.75164], [-116.31824, 35.7512], [-116.31769, 35.75049], [-116.31744, 35.7501], [-116.31693, 35.74958], [-116.31682, 35.74949], [-116.31613, 35.74811], [-116.315, 35.74506], [-116.31491, 35.74471], [-116.3137, 35.73883], [-116.31291, 35.73473], [-116.31199, 35.73024], [-116.3104, 35.72229], [-116.3078, 35.71017], [-116.30775, 35.70997], [-116.3038, 35.69094], [-116.29171, 35.63362], [-116.29401, 35.6346], [-116.30464, 35.63955], [-116.30521, 35.63979], [-116.30645, 35.64017], [-116.30717, 35.64033], [-116.31098, 35.64097], [-116.33614, 35.64543], [-116.33622, 35.65744], [-116.35401, 35.65752], [-116.35396, 35.64821], [-116.35566, 35.64845], [-116.35755, 35.64866], [-116.3581, 35.64868], [-116.35884, 35.6486], [-116.36273, 35.64797], [-116.36751, 35.64724], [-116.36977, 35.64683], [-116.37152, 35.64661], [-116.37254, 35.64659], [-116.3751, 35.64662], [-116.38237, 35.64665], [-116.39951, 35.64697], [-116.4036, 35.64695], [-116.40459, 35.64703], [-116.40617, 35.64705], [-116.40669, 35.64716], [-116.4074, 35.64735], [-116.40794, 35.64754], [-116.40843, 35.6478], [-116.40949, 35.64825], [-116.4132, 35.65002], [-116.44192, 35.64995], [-116.44199, 35.65723], [-116.45084, 35.65721], [-116.45065, 35.65013], [-116.45996, 35.64993], [-116.46476, 35.64984], [-116.4765, 35.64958], [-116.50083, 35.64966], [-116.52968, 35.64938], [-116.54821, 35.64929], [-116.54821, 35.65687], [-116.54822, 35.65688], [-116.56558, 35.6567], [-116.56567, 35.64928], [-116.58384, 35.6491], [-116.60047, 35.64931], [-116.62584, 35.6491], [-116.65413, 35.6488], [-116.65416, 35.65629], [-116.65418, 35.6563], [-116.67199, 35.65605], [-116.67195, 35.64858], [-116.68991, 35.64873], [-116.70753, 35.64864], [-116.72603, 35.64962], [-116.74383, 35.64998], [-116.75087, 35.65008], [-116.76498, 35.65006], [-116.7651, 35.657], [-116.78284, 35.65692], [-116.78277, 35.65004], [-116.81493, 35.65001], [-116.81494, 35.64788], [-116.81495, 35.64779], [-116.81494, 35.64774], [-116.86799, 35.64777], [-116.868, 35.65511], [-116.88587, 35.65509], [-116.88606, 35.64778], [-116.92551, 35.64782], [-116.92452, 35.70994], [-116.94774, 35.70982], [-116.94781, 35.71698], [-116.94782, 35.71701], [-116.97443, 35.71703], [-116.97444, 35.71702], [-116.97441, 35.71567], [-116.97885, 35.71571], [-116.97886, 35.72272], [-116.97887, 35.72293]], [[-116.34936, 35.73006], [-116.33601, 35.73006], [-116.33602, 35.74456], [-116.35383, 35.74455], [-116.35381, 35.73006], [-116.34936, 35.73006]], [[-116.40933, 35.78451], [-116.40932, 35.7845], [-116.40547, 35.78318], [-116.40237, 35.78862], [-116.40612, 35.78999], [-116.40933, 35.78451]], [[-116.44197, 35.72954], [-116.44196, 35.72955], [-116.44215, 35.74435], [-116.4595, 35.74433], [-116.45941, 35.72956], [-116.44197, 35.72954]], [[-116.49482, 35.68611], [-116.49481, 35.68612], [-116.49487, 35.70066], [-116.51247, 35.70072], [-116.51245, 35.68611], [-116.49482, 35.68611]], [[-116.50364, 35.77266], [-116.50351, 35.78721], [-116.51232, 35.7871], [-116.51222, 35.77263], [-116.50364, 35.77266]], [[-116.54802, 35.72973], [-116.54807, 35.74409], [-116.56564, 35.74402], [-116.56559, 35.7296], [-116.54802, 35.72973]], [[-116.60029, 35.68611], [-116.60035, 35.70061], [-116.6181, 35.70054], [-116.61831, 35.68603], [-116.60029, 35.68611]], [[-116.60066, 35.7727], [-116.60065, 35.77271], [-116.60078, 35.78734], [-116.61841, 35.78728], [-116.61843, 35.77267], [-116.60066, 35.7727]], [[-116.65906, 35.7307], [-116.65905, 35.73071], [-116.65913, 35.74518], [-116.67689, 35.74517], [-116.67685, 35.73067], [-116.65906, 35.7307]], [[-116.71205, 35.77245], [-116.71204, 35.77246], [-116.7121, 35.787], [-116.73025, 35.78718], [-116.73019, 35.77245], [-116.71205, 35.77245]], [[-116.7122, 35.68651], [-116.71223, 35.70119], [-116.73018, 35.70026], [-116.73018, 35.68642], [-116.7122, 35.68651]], [[-116.76551, 35.72966], [-116.76548, 35.74424], [-116.78309, 35.74423], [-116.7831, 35.72968], [-116.76551, 35.72966]], [[-116.83279, 35.69765], [-116.83258, 35.68426], [-116.81457, 35.68426], [-116.81453, 35.69756], [-116.81748, 35.69758], [-116.81752, 35.71231], [-116.83544, 35.71231], [-116.83545, 35.69766], [-116.83279, 35.69765]], [[-116.87106, 35.74142], [-116.87105, 35.74144], [-116.87109, 35.75601], [-116.889, 35.75604], [-116.88894, 35.74141], [-116.87106, 35.74142]], [[-116.96543, 35.71704], [-116.96542, 35.71703], [-116.95762, 35.71871], [-116.94838, 35.71871], [-116.94076, 35.71704], [-116.93439, 35.71908], [-116.93094, 35.72153], [-116.92911, 35.72806], [-116.9374, 35.72988], [-116.94631, 35.72926], [-116.94753, 35.72494], [-116.95828, 35.72537], [-116.96569, 35.72146], [-116.96543, 35.71704]]]} | Open Access 1 | 18440 | Death Valley National Park | 14210 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 108 | United States National Park Service 59 | Federal 1 | Federal Agency 1 | http://www.nps.gov/deva/index.htm | San Bernardino 22 | 214238.566 | Death Valley NP | 1994 | National Park 18 | 2 |
15801 | 15801 | 15800 | {"type": "MultiPolygon", "coordinates": [[[[-121.24459, 36.50282], [-121.24435, 36.51005], [-121.23996, 36.51007], [-121.23966, 36.51731], [-121.23062, 36.5172], [-121.22987, 36.53167], [-121.22988, 36.53168], [-121.23887, 36.53184], [-121.23882, 36.53546], [-121.22982, 36.53532], [-121.22978, 36.53894], [-121.23428, 36.53902], [-121.23419, 36.54626], [-121.23868, 36.54633], [-121.23878, 36.53908], [-121.24346, 36.53906], [-121.2434, 36.54632], [-121.23869, 36.54633], [-121.2386, 36.54994], [-121.22957, 36.54981], [-121.22931, 36.55703], [-121.22476, 36.55697], [-121.22462, 36.56058], [-121.22005, 36.56052], [-121.21991, 36.56492], [-121.21537, 36.56499], [-121.21547, 36.56054], [-121.21091, 36.56055], [-121.21129, 36.55329], [-121.20222, 36.5533], [-121.19776, 36.55326], [-121.19795, 36.54962], [-121.19347, 36.5496], [-121.19362, 36.54596], [-121.1937, 36.54233], [-121.19822, 36.54233], [-121.19836, 36.53506], [-121.19386, 36.53505], [-121.19393, 36.53142], [-121.18497, 36.53143], [-121.18468, 36.5423], [-121.1667, 36.54224], [-121.16217, 36.54218], [-121.16229, 36.53492], [-121.15776, 36.53485], [-121.15782, 36.53121], [-121.1533, 36.53114], [-121.15323, 36.53478], [-121.1487, 36.53472], [-121.1487, 36.53446], [-121.14854, 36.53451], [-121.14826, 36.53398], [-121.14765, 36.53372], [-121.14661, 36.53314], [-121.14639, 36.53289], [-121.14618, 36.53262], [-121.14611, 36.53224], [-121.14611, 36.53201], [-121.14566, 36.53124], [-121.14532, 36.53058], [-121.14486, 36.53014], [-121.14443, 36.5297], [-121.1443, 36.52945], [-121.14415, 36.52885], [-121.14423, 36.52789], [-121.14413, 36.52747], [-121.14384, 36.52705], [-121.14305, 36.52627], [-121.14148, 36.52441], [-121.14123, 36.52425], [-121.14066, 36.52402], [-121.14025, 36.52375], [-121.14, 36.52338], [-121.13997, 36.52294], [-121.13989, 36.52271], [-121.13976, 36.52247], [-121.13918, 36.52208], [-121.1389, 36.52156], [-121.13829, 36.52083], [-121.13828, 36.52072], [-121.13886, 36.51762], [-121.13694, 36.5176], [-121.13667, 36.51687], [-121.13639, 36.51636], [-121.13635, 36.51601], [-121.13665, 36.51533], [-121.13705, 36.51499], [-121.13724, 36.51469], [-121.13733, 36.51406], [-121.13749, 36.51224], [-121.13745, 36.51186], [-121.1373, 36.51144], [-121.1373, 36.511], [-121.13748, 36.51048], [-121.13768, 36.51029], [-121.13766, 36.5101], [-121.13781, 36.50977], [-121.13811, 36.50924], [-121.13823, 36.50891], [-121.13952, 36.508], [-121.1396, 36.5078], [-121.13955, 36.50762], [-121.13933, 36.50635], [-121.13919, 36.50592], [-121.13924, 36.50568], [-121.13933, 36.50537], [-121.13931, 36.50519], [-121.13922, 36.50499], [-121.13939, 36.50415], [-121.13946, 36.50367], [-121.13919, 36.50295], [-121.13933, 36.50248], [-121.13938, 36.5021], [-121.1395, 36.50185], [-121.14, 36.50133], [-121.14012, 36.50113], [-121.14001, 36.50088], [-121.14007, 36.50046], [-121.14042, 36.50013], [-121.14068, 36.50002], [-121.14086, 36.49985], [-121.14086, 36.49942], [-121.14098, 36.49906], [-121.14174, 36.49811], [-121.14227, 36.49726], [-121.1437, 36.49608], [-121.1443, 36.49566], [-121.1452, 36.49536], [-121.14616, 36.49495], [-121.14709, 36.49362], [-121.14765, 36.49318], [-121.14854, 36.4926], [-121.14924, 36.49206], [-121.14949, 36.49134], [-121.14963, 36.4908], [-121.14998, 36.49057], [-121.15095, 36.48985], [-121.15184, 36.48904], [-121.15243, 36.48876], [-121.15336, 36.48815], [-121.15336, 36.48813], [-121.15316, 36.48813], [-121.15235, 36.48867], [-121.15175, 36.48895], [-121.15085, 36.48977], [-121.1499, 36.49048], [-121.14951, 36.49074], [-121.14936, 36.49132], [-121.14912, 36.492], [-121.14845, 36.49252], [-121.14756, 36.49309], [-121.14698, 36.49355], [-121.14606, 36.49487], [-121.14514, 36.49526], [-121.14422, 36.49557], [-121.14361, 36.496], [-121.14216, 36.49719], [-121.14162, 36.49806], [-121.14085, 36.49901], [-121.14073, 36.4994], [-121.14072, 36.49981], [-121.14062, 36.49992], [-121.14033, 36.50004], [-121.13994, 36.50041], [-121.13987, 36.50089], [-121.13997, 36.50112], [-121.13988, 36.50128], [-121.13938, 36.5018], [-121.13925, 36.50207], [-121.1392, 36.50246], [-121.13905, 36.50295], [-121.13933, 36.50368], [-121.13925, 36.50413], [-121.13908, 36.505], [-121.13917, 36.50521], [-121.13919, 36.50536], [-121.1391, 36.50565], [-121.13905, 36.50593], [-121.1392, 36.50637], [-121.13941, 36.50764], [-121.13946, 36.50779], [-121.13941, 36.50794], [-121.13811, 36.50885], [-121.13798, 36.5092], [-121.13768, 36.50973], [-121.13753, 36.51008], [-121.13754, 36.51025], [-121.13736, 36.51043], [-121.13716, 36.51098], [-121.13716, 36.51145], [-121.13732, 36.51188], [-121.13735, 36.51224], [-121.1372, 36.51405], [-121.1371, 36.51466], [-121.13694, 36.51493], [-121.13653, 36.51527], [-121.13621, 36.516], [-121.13626, 36.51639], [-121.13654, 36.51691], [-121.1368, 36.5176], [-121.13597, 36.51759], [-121.1359, 36.51704], [-121.13556, 36.51667], [-121.13524, 36.51683], [-121.13504, 36.51755], [-121.13405, 36.51727], [-121.13254, 36.51702], [-121.13068, 36.51684], [-121.1295, 36.51686], [-121.1285, 36.51708], [-121.1279, 36.51724], [-121.12739, 36.51714], [-121.12592, 36.51678], [-121.12452, 36.51607], [-121.12373, 36.51549], [-121.12325, 36.51516], [-121.12212, 36.51475], [-121.12132, 36.51431], [-121.12026, 36.51355], [-121.11927, 36.51298], [-121.11686, 36.51154], [-121.11611, 36.51124], [-121.11492, 36.51036], [-121.11439, 36.51007], [-121.11325, 36.50935], [-121.1127, 36.50874], [-121.11206, 36.50828], [-121.11105, 36.50773], [-121.11057, 36.50749], [-121.11009, 36.50688], [-121.10989, 36.5066], [-121.10955, 36.50631], [-121.10889, 36.50621], [-121.10824, 36.50621], [-121.1079, 36.50583], [-121.10749, 36.50561], [-121.1067, 36.5051], [-121.10583, 36.50442], [-121.10525, 36.50423], [-121.10472, 36.50395], [-121.10319, 36.50194], [-121.10272, 36.50116], [-121.10155, 36.49996], [-121.10083, 36.49903], [-121.13197, 36.49913], [-121.13216, 36.49546], [-121.13674, 36.49553], [-121.13714, 36.48819], [-121.12991, 36.48818], [-121.12749, 36.48821], [-121.126, 36.48817], [-121.11888, 36.48811], [-121.11885, 36.48839], [-121.11564, 36.48837], [-121.11614, 36.49173], [-121.11404, 36.49171], [-121.11402, 36.49201], [-121.11167, 36.49197], [-121.11118, 36.48828], [-121.10804, 36.4882], [-121.1081, 36.48454], [-121.11254, 36.48463], [-121.11266, 36.47733], [-121.1171, 36.47743], [-121.11717, 36.47378], [-121.12611, 36.47384], [-121.13057, 36.47389], [-121.13068, 36.47022], [-121.13516, 36.47028], [-121.14391, 36.47028], [-121.14405, 36.46306], [-121.14469, 36.46306], [-121.1447, 36.46292], [-121.14478, 36.46268], [-121.1448, 36.46255], [-121.14479, 36.46233], [-121.14481, 36.46199], [-121.14485, 36.46162], [-121.14497, 36.46115], [-121.14497, 36.46089], [-121.14521, 36.45998], [-121.14533, 36.4597], [-121.14561, 36.4592], [-121.14628, 36.45822], [-121.14674, 36.45765], [-121.14718, 36.45721], [-121.1475, 36.45704], [-121.14794, 36.45681], [-121.14848, 36.45661], [-121.14849, 36.45588], [-121.14941, 36.45588], [-121.14948, 36.45567], [-121.1497, 36.45558], [-121.15015, 36.45548], [-121.15062, 36.45545], [-121.15089, 36.4554], [-121.15116, 36.45542], [-121.15139, 36.45537], [-121.1521, 36.45508], [-121.15214, 36.45256], [-121.15283, 36.4526], [-121.1535, 36.45254], [-121.15415, 36.45111], [-121.15387, 36.45053], [-121.15285, 36.45008], [-121.15284, 36.45005], [-121.15265, 36.44993], [-121.15222, 36.44959], [-121.15205, 36.44925], [-121.1521, 36.44899], [-121.15238, 36.44853], [-121.1525, 36.44819], [-121.15255, 36.44795], [-121.15246, 36.44776], [-121.1523, 36.44759], [-121.15196, 36.44695], [-121.15193, 36.44667], [-121.15197, 36.44631], [-121.15212, 36.44602], [-121.15288, 36.44558], [-121.1529, 36.4456], [-121.15377, 36.44515], [-121.15375, 36.4448], [-121.15289, 36.44481], [-121.15303, 36.43052], [-121.15749, 36.43045], [-121.15759, 36.41965], [-121.15758, 36.41964], [-121.15311, 36.41976], [-121.15313, 36.41617], [-121.15591, 36.4161], [-121.16554, 36.42371], [-121.16961, 36.42696], [-121.1736, 36.43003], [-121.17649, 36.43236], [-121.18318, 36.43771], [-121.1855, 36.43948], [-121.18795, 36.44147], [-121.191, 36.44386], [-121.1951, 36.4481], [-121.20193, 36.45522], [-121.20182, 36.45908], [-121.20627, 36.45903], [-121.20583, 36.47364], [-121.21484, 36.47358], [-121.22391, 36.47328], [-121.22852, 36.47329], [-121.22851, 36.47347], [-121.22993, 36.48835], [-121.23103, 36.48835], [-121.23163, 36.48986], [-121.23223, 36.49105], [-121.23215, 36.4926], [-121.23218, 36.4937], [-121.23197, 36.49446], [-121.23203, 36.49532], [-121.23274, 36.49533], [-121.23178, 36.50274], [-121.24024, 36.50282], [-121.24459, 36.50282]], [[-121.15013, 36.50067], [-121.14993, 36.50217], [-121.15252, 36.50215], [-121.15253, 36.50066], [-121.15013, 36.50067]], [[-121.15753, 36.48814], [-121.15596, 36.48814], [-121.15523, 36.49527], [-121.15991, 36.49537], [-121.1599, 36.49277], [-121.16037, 36.48828], [-121.15753, 36.48814]]], [[[-121.14827, 36.53427], [-121.14507, 36.53528], [-121.14462, 36.53446], [-121.14546, 36.53416], [-121.14611, 36.53403], [-121.14628, 36.53382], [-121.14649, 36.53369], [-121.14704, 36.53351], [-121.14758, 36.53381], [-121.14815, 36.53406], [-121.14827, 36.53427]]]]} | Open Access 1 | 18547 | Pinnacles National Park | 14264 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 108 | United States National Park Service 59 | Federal 1 | Federal Agency 1 | http://www.nps.gov/pinn/index.htm | San Benito 38 | 24001.115 | Pinnacles NP | 2013 | National Park 18 | 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]);