units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where DES_TP = 3, MNG_AG_TYP = 2 and UNIT_NAME = "Hodges Reservoir"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 676 | 676 | 675 | {"type": "MultiPolygon", "coordinates": [[[[-117.13268, 33.04382], [-117.13241, 33.04442], [-117.1322, 33.04434], [-117.13203, 33.04454], [-117.13199, 33.04452], [-117.13148, 33.04487], [-117.13139, 33.04475], [-117.13113, 33.04487], [-117.13102, 33.0449], [-117.13102, 33.04538], [-117.13079, 33.0455], [-117.13057, 33.04567], [-117.13041, 33.04581], [-117.13026, 33.04601], [-117.13021, 33.04599], [-117.13013, 33.04604], [-117.13005, 33.04602], [-117.1299, 33.04621], [-117.12978, 33.04623], [-117.12952, 33.04635], [-117.12936, 33.04655], [-117.12901, 33.04663], [-117.12856, 33.0467], [-117.12837, 33.04678], [-117.12828, 33.04679], [-117.12773, 33.04681], [-117.12756, 33.04683], [-117.12736, 33.0469], [-117.12718, 33.04698], [-117.12704, 33.04706], [-117.12696, 33.04713], [-117.12684, 33.04728], [-117.12645, 33.04762], [-117.12639, 33.04764], [-117.12634, 33.04764], [-117.12597, 33.04752], [-117.12568, 33.04746], [-117.12558, 33.04746], [-117.12538, 33.0475], [-117.12518, 33.04761], [-117.12485, 33.04797], [-117.12454, 33.04839], [-117.1245, 33.04849], [-117.12447, 33.04865], [-117.12443, 33.0487], [-117.12437, 33.0487], [-117.12435, 33.04868], [-117.12419, 33.0485], [-117.12408, 33.04833], [-117.12402, 33.04827], [-117.12393, 33.04823], [-117.1238, 33.04818], [-117.12366, 33.04817], [-117.12357, 33.04819], [-117.12343, 33.04826], [-117.12329, 33.04842], [-117.12326, 33.04856], [-117.12326, 33.0487], [-117.12329, 33.04886], [-117.12339, 33.04911], [-117.12337, 33.04917], [-117.12326, 33.04929], [-117.12315, 33.04935], [-117.12271, 33.04954], [-117.12235, 33.04972], [-117.12217, 33.04988], [-117.12209, 33.05002], [-117.12195, 33.0504], [-117.1219, 33.05063], [-117.12186, 33.05083], [-117.12182, 33.05126], [-117.12175, 33.05139], [-117.12153, 33.0517], [-117.12146, 33.05184], [-117.12142, 33.05215], [-117.12134, 33.0524], [-117.12125, 33.05278], [-117.12118, 33.05304], [-117.12108, 33.05326], [-117.12065, 33.05398], [-117.12053, 33.05409], [-117.1204, 33.05414], [-117.11975, 33.05407], [-117.1194, 33.05406], [-117.1184, 33.05417], [-117.11837, 33.05417], [-117.11817, 33.05423], [-117.11807, 33.05428], [-117.11799, 33.05435], [-117.11791, 33.05444], [-117.11787, 33.05462], [-117.1179, 33.05482], [-117.11827, 33.05534], [-117.11834, 33.05549], [-117.11836, 33.05561], [-117.11834, 33.05566], [-117.11826, 33.05576], [-117.11781, 33.05594], [-117.11764, 33.05604], [-117.11754, 33.05624], [-117.11756, 33.05634], [-117.11762, 33.05647], [-117.11786, 33.05667], [-117.11794, 33.05677], [-117.11807, 33.05715], [-117.11813, 33.05727], [-117.11824, 33.0574], [-117.11837, 33.05752], [-117.11881, 33.05778], [-117.11891, 33.05789], [-117.11895, 33.05796], [-117.11899, 33.05803], [-117.119, 33.05812], [-117.11898, 33.05825], [-117.1189, 33.05837], [-117.11884, 33.05843], [-117.11859, 33.05859], [-117.11853, 33.05866], [-117.11845, 33.05878], [-117.11838, 33.05898], [-117.11838, 33.05904], [-117.11832, 33.05913], [-117.118, 33.06002], [-117.11799, 33.06014], [-117.11801, 33.06028], [-117.11805, 33.06045], [-117.1182, 33.06067], [-117.11837, 33.06081], [-117.11871, 33.061], [-117.11878, 33.06108], [-117.11881, 33.06116], [-117.11883, 33.06125], [-117.11883, 33.06134], [-117.11869, 33.06167], [-117.11867, 33.06188], [-117.11871, 33.06201], [-117.11882, 33.06216], [-117.11891, 33.06223], [-117.11911, 33.06235], [-117.11935, 33.06239], [-117.1199, 33.0624], [-117.11999, 33.06244], [-117.12004, 33.06252], [-117.12004, 33.06262], [-117.11926, 33.06391], [-117.1192, 33.06407], [-117.11919, 33.06422], [-117.11924, 33.06446], [-117.1193, 33.06457], [-117.11938, 33.06468], [-117.11952, 33.06478], [-117.11995, 33.06496], [-117.12007, 33.06506], [-117.12011, 33.06514], [-117.12013, 33.06521], [-117.12014, 33.06628], [-117.12013, 33.06637], [-117.12007, 33.06651], [-117.11954, 33.06723], [-117.11943, 33.06743], [-117.11854, 33.06991], [-117.11842, 33.07012], [-117.11822, 33.07043], [-117.11814, 33.07061], [-117.11809, 33.07075], [-117.11797, 33.07224], [-117.118, 33.07242], [-117.11816, 33.07275], [-117.11819, 33.07285], [-117.11816, 33.073], [-117.11798, 33.07342], [-117.11794, 33.07365], [-117.11795, 33.07379], [-117.1182, 33.07508], [-117.11822, 33.07535], [-117.11814, 33.07659], [-117.11811, 33.07674], [-117.11807, 33.07684], [-117.11788, 33.07718], [-117.11778, 33.07729], [-117.11762, 33.07741], [-117.11748, 33.07748], [-117.11626, 33.07787], [-117.11606, 33.07798], [-117.11591, 33.0781], [-117.11581, 33.07821], [-117.11545, 33.07875], [-117.11539, 33.07886], [-117.11536, 33.07904], [-117.1153, 33.07922], [-117.11519, 33.07944], [-117.11507, 33.07961], [-117.11497, 33.07955], [-117.11471, 33.07969], [-117.11457, 33.08006], [-117.11469, 33.08017], [-117.11465, 33.0803], [-117.11464, 33.08177], [-117.11467, 33.08201], [-117.11477, 33.08224], [-117.11479, 33.08226], [-117.1148, 33.08236], [-117.11475, 33.08252], [-117.11461, 33.08275], [-117.11456, 33.08291], [-117.11455, 33.083], [-117.11457, 33.08306], [-117.11463, 33.08393], [-117.11457, 33.08393], [-117.11457, 33.08403], [-117.11451, 33.08421], [-117.11449, 33.08434], [-117.11434, 33.08484], [-117.11431, 33.08503], [-117.11429, 33.08531], [-117.11434, 33.08556], [-117.11432, 33.08564], [-117.11432, 33.08579], [-117.1143, 33.08598], [-117.11417, 33.08671], [-117.11307, 33.08687], [-117.113, 33.0875], [-117.11051, 33.08748], [-117.11048, 33.08636], [-117.11047, 33.08471], [-117.11048, 33.08458], [-117.11046, 33.08388], [-117.10658, 33.08385], [-117.10621, 33.08339], [-117.10612, 33.08331], [-117.10518, 33.08224], [-117.10512, 33.08227], [-117.10479, 33.08185], [-117.10536, 33.07954], [-117.10657, 33.07427], [-117.10663, 33.07423], [-117.10596, 33.07399], [-117.10564, 33.07142], [-117.10372, 33.07008], [-117.1036, 33.07008], [-117.10341, 33.06992], [-117.10324, 33.06971], [-117.10304, 33.06959], [-117.10271, 33.06959], [-117.10205, 33.06942], [-117.10143, 33.06894], [-117.10116, 33.06895], [-117.10126, 33.06885], [-117.1013, 33.06878], [-117.10108, 33.06857], [-117.10089, 33.06855], [-117.1008, 33.06849], [-117.10073, 33.06823], [-117.10036, 33.06808], [-117.10014, 33.06824], [-117.10006, 33.06813], [-117.10007, 33.0681], [-117.10003, 33.06789], [-117.09995, 33.06782], [-117.09978, 33.06779], [-117.0997, 33.06775], [-117.09966, 33.06771], [-117.09942, 33.06765], [-117.09911, 33.0676], [-117.09888, 33.0676], [-117.09871, 33.06763], [-117.09868, 33.06761], [-117.0987, 33.06753], [-117.09869, 33.06746], [-117.09867, 33.06742], [-117.09859, 33.06734], [-117.09863, 33.06733], [-117.09872, 33.06737], [-117.09881, 33.06738], [-117.09894, 33.06734], [-117.09902, 33.0673], [-117.09906, 33.06724], [-117.09908, 33.06717], [-117.09908, 33.06711], [-117.09881, 33.06652], [-117.0988, 33.06612], [-117.09888, 33.06592], [-117.09887, 33.06566], [-117.0988, 33.06542], [-117.09876, 33.06536], [-117.09873, 33.06524], [-117.09869, 33.0652], [-117.09863, 33.06508], [-117.09863, 33.06495], [-117.09861, 33.06482], [-117.09858, 33.06472], [-117.0985, 33.06459], [-117.09842, 33.0645], [-117.0982, 33.06433], [-117.09805, 33.06426], [-117.09787, 33.06421], [-117.09758, 33.06421], [-117.09738, 33.06428], [-117.09726, 33.06436], [-117.09721, 33.06435], [-117.09731, 33.06392], [-117.09732, 33.06385], [-117.0973, 33.06383], [-117.09731, 33.0638], [-117.0973, 33.06374], [-117.09728, 33.06367], [-117.09721, 33.06357], [-117.09697, 33.06341], [-117.09651, 33.06334], [-117.09621, 33.06337], [-117.09593, 33.06338], [-117.09559, 33.06346], [-117.09516, 33.06349], [-117.09494, 33.06356], [-117.09478, 33.06366], [-117.09474, 33.06366], [-117.09472, 33.06364], [-117.09478, 33.06355], [-117.09479, 33.0635], [-117.09476, 33.06346], [-117.09467, 33.06342], [-117.09466, 33.06339], [-117.09469, 33.06337], [-117.09488, 33.06337], [-117.09503, 33.06331], [-117.09522, 33.06312], [-117.09531, 33.06299], [-117.09535, 33.06283], [-117.09535, 33.06269], [-117.09547, 33.06251], [-117.09549, 33.06242], [-117.09548, 33.06228], [-117.09538, 33.06216], [-117.09537, 33.0621], [-117.09538, 33.06199], [-117.09542, 33.06191], [-117.09547, 33.06184], [-117.09563, 33.06174], [-117.09572, 33.06163], [-117.09574, 33.06156], [-117.09575, 33.06149], [-117.09569, 33.06139], [-117.09559, 33.06127], [-117.09544, 33.06116], [-117.09532, 33.06111], [-117.09508, 33.06103], [-117.09456, 33.06074], [-117.09428, 33.06063], [-117.09379, 33.06047], [-117.09288, 33.06008], [-117.09286, 33.06009], [-117.09286, 33.06032], [-117.09274, 33.06028], [-117.0926, 33.06017], [-117.09239, 33.06006], [-117.09228, 33.05987], [-117.09213, 33.05976], [-117.09201, 33.05974], [-117.09184, 33.05974], [-117.09164, 33.05978], [-117.09168, 33.05958], [-117.09174, 33.05947], [-117.09172, 33.05933], [-117.09166, 33.0592], [-117.09135, 33.05904], [-117.09121, 33.05888], [-117.09103, 33.05874], [-117.09084, 33.05853], [-117.09061, 33.05832], [-117.09039, 33.058], [-117.09025, 33.05791], [-117.08988, 33.05787], [-117.08965, 33.0578], [-117.08852, 33.05762], [-117.0884, 33.05745], [-117.08825, 33.05736], [-117.08816, 33.05731], [-117.08804, 33.05729], [-117.08783, 33.05729], [-117.08773, 33.05731], [-117.08767, 33.05738], [-117.0876, 33.05758], [-117.08761, 33.0577], [-117.08767, 33.05785], [-117.08713, 33.058], [-117.08569, 33.05861], [-117.08499, 33.05989], [-117.08444, 33.06032], [-117.08432, 33.06043], [-117.08427, 33.06051], [-117.08387, 33.06082], [-117.08379, 33.06096], [-117.08378, 33.06105], [-117.08385, 33.06118], [-117.08376, 33.06128], [-117.08367, 33.0615], [-117.08335, 33.0619], [-117.08304, 33.06214], [-117.08256, 33.06263], [-117.08251, 33.06298], [-117.08242, 33.06312], [-117.0824, 33.06322], [-117.08246, 33.06348], [-117.08265, 33.06372], [-117.08265, 33.06402], [-117.08259, 33.06429], [-117.0825, 33.06439], [-117.08257, 33.06486], [-117.08253, 33.06494], [-117.08234, 33.0666], [-117.08234, 33.06622], [-117.08219, 33.06598], [-117.08207, 33.06589], [-117.08202, 33.06553], [-117.0816, 33.06539], [-117.08203, 33.06463], [-117.08189, 33.06454], [-117.08154, 33.06449], [-117.08149, 33.0644], [-117.08135, 33.06431], [-117.08112, 33.06425], [-117.08088, 33.06427], [-117.08064, 33.06414], [-117.08056, 33.06417], [-117.08056, 33.06409], [-117.08037, 33.06399], [-117.08016, 33.06407], [-117.07998, 33.06409], [-117.07985, 33.06416], [-117.0796, 33.06394], [-117.0795, 33.06388], [-117.07932, 33.06388], [-117.07931, 33.06362], [-117.07874, 33.06369], [-117.07909, 33.06342], [-117.07924, 33.06317], [-117.07915, 33.06298], [-117.0789, 33.06258], [-117.07886, 33.06228], [-117.07835, 33.06191], [-117.07819, 33.06184], [-117.07778, 33.06191], [-117.07804, 33.0616], [-117.07805, 33.06126], [-117.07803, 33.06081], [-117.07798, 33.06069], [-117.07766, 33.06059], [-117.0771, 33.06083], [-117.07684, 33.061], [-117.07674, 33.061], [-117.07665, 33.06106], [-117.07663, 33.06091], [-117.0765, 33.06083], [-117.07639, 33.06082], [-117.07631, 33.06075], [-117.07599, 33.06071], [-117.07576, 33.06059], [-117.07556, 33.06063], [-117.07549, 33.06056], [-117.07508, 33.06044], [-117.07485, 33.06045], [-117.07452, 33.06041], [-117.07416, 33.06044], [-117.0739, 33.06049], [-117.07371, 33.06057], [-117.07356, 33.06059], [-117.07326, 33.06068], [-117.07297, 33.06106], [-117.07294, 33.06119], [-117.07293, 33.06133], [-117.07282, 33.06136], [-117.0727, 33.06156], [-117.07276, 33.06197], [-117.07263, 33.06189], [-117.0722, 33.06186], [-117.07201, 33.0619], [-117.07145, 33.06184], [-117.07124, 33.06186], [-117.071, 33.06195], [-117.07073, 33.06224], [-117.07058, 33.06236], [-117.07053, 33.06247], [-117.07045, 33.06248], [-117.06984, 33.06278], [-117.06962, 33.06201], [-117.06976, 33.06174], [-117.07007, 33.06157], [-117.06989, 33.06123], [-117.07161, 33.05693], [-117.07174, 33.05675], [-117.07189, 33.05658], [-117.07198, 33.05651], [-117.07229, 33.05634], [-117.07244, 33.05628], [-117.07286, 33.05618], [-117.07316, 33.05609], [-117.07378, 33.05585], [-117.07431, 33.05562], [-117.07428, 33.05548], [-117.07454, 33.05531], [-117.07469, 33.05518], [-117.07497, 33.05489], [-117.0751, 33.05473], [-117.07609, 33.05336], [-117.07628, 33.05301], [-117.07637, 33.0528], [-117.07642, 33.05262], [-117.07648, 33.05227], [-117.07649, 33.05201], [-117.07644, 33.05164], [-117.07638, 33.05141], [-117.07623, 33.05103], [-117.07602, 33.05071], [-117.07575, 33.05041], [-117.07613, 33.04995], [-117.07686, 33.04884], [-117.07733, 33.04853], [-117.07744, 33.04827], [-117.0777, 33.04805], [-117.07778, 33.0469], [-117.07765, 33.04667], [-117.07681, 33.04619], [-117.07646, 33.04577], [-117.07581, 33.04506], [-117.07512, 33.04473], [-117.07454, 33.04485], [-117.07742, 33.04195], [-117.07767, 33.04165], [-117.07786, 33.04135], [-117.07859, 33.04164], [-117.07894, 33.04181], [-117.07964, 33.04197], [-117.07989, 33.04198], [-117.08023, 33.04196], [-117.08024, 33.04211], [-117.08027, 33.04224], [-117.08016, 33.04246], [-117.07979, 33.04262], [-117.07963, 33.04286], [-117.07966, 33.04329], [-117.07974, 33.04342], [-117.08846, 33.0445], [-117.09088, 33.04481], [-117.091, 33.04484], [-117.09044, 33.04709], [-117.09043, 33.04721], [-117.0904, 33.04726], [-117.08991, 33.04926], [-117.09485, 33.05503], [-117.1018, 33.05914], [-117.11033, 33.05917], [-117.11402, 33.04382], [-117.12244, 33.04384], [-117.13268, 33.04382]], [[-117.10946, 33.08122], [-117.10947, 33.08171], [-117.11043, 33.08171], [-117.11043, 33.08038], [-117.10945, 33.0804], [-117.10947, 33.08118], [-117.10946, 33.08122]]], [[[-117.12306, 33.04975], [-117.12293, 33.04986], [-117.12272, 33.05008], [-117.12257, 33.0503], [-117.12241, 33.05064], [-117.12235, 33.05083], [-117.12223, 33.05083], [-117.12208, 33.05144], [-117.122, 33.05185], [-117.12211, 33.05188], [-117.12205, 33.05215], [-117.12184, 33.05312], [-117.12173, 33.05311], [-117.12164, 33.05351], [-117.12168, 33.05352], [-117.12166, 33.05366], [-117.12166, 33.05397], [-117.12173, 33.05398], [-117.12179, 33.05436], [-117.12168, 33.05439], [-117.12175, 33.0546], [-117.12183, 33.05481], [-117.11808, 33.05481], [-117.11805, 33.05475], [-117.11804, 33.05468], [-117.11804, 33.05457], [-117.11806, 33.05452], [-117.11809, 33.05446], [-117.11815, 33.0544], [-117.11827, 33.05434], [-117.11882, 33.05425], [-117.11941, 33.05419], [-117.1197, 33.0542], [-117.12044, 33.05427], [-117.1206, 33.05422], [-117.1208, 33.05405], [-117.12124, 33.0533], [-117.12135, 33.05305], [-117.12147, 33.05256], [-117.12148, 33.05249], [-117.12157, 33.05221], [-117.12161, 33.05189], [-117.12168, 33.05175], [-117.12181, 33.0516], [-117.12187, 33.0515], [-117.12198, 33.05128], [-117.122, 33.0512], [-117.12203, 33.05083], [-117.1221, 33.05043], [-117.12225, 33.05005], [-117.12231, 33.04995], [-117.12244, 33.04984], [-117.12291, 33.04962], [-117.12306, 33.04975]]], [[[-117.12652, 33.04775], [-117.12629, 33.04798], [-117.12642, 33.04812], [-117.1259, 33.04856], [-117.12571, 33.04868], [-117.12557, 33.04854], [-117.12516, 33.04876], [-117.12468, 33.04887], [-117.12472, 33.04911], [-117.12407, 33.04926], [-117.124, 33.04904], [-117.1236, 33.04915], [-117.12352, 33.04901], [-117.12343, 33.04875], [-117.12342, 33.04859], [-117.12346, 33.04845], [-117.12352, 33.04838], [-117.12359, 33.04833], [-117.12366, 33.04832], [-117.12376, 33.04832], [-117.12388, 33.04835], [-117.12393, 33.0484], [-117.12411, 33.04863], [-117.12429, 33.04882], [-117.12435, 33.04884], [-117.12447, 33.04884], [-117.12454, 33.04879], [-117.12461, 33.04872], [-117.12464, 33.04865], [-117.12469, 33.04843], [-117.12492, 33.04813], [-117.12526, 33.04775], [-117.12538, 33.04766], [-117.12552, 33.04761], [-117.12568, 33.0476], [-117.12595, 33.04766], [-117.12631, 33.04777], [-117.12642, 33.04778], [-117.12652, 33.04775]]], [[[-117.12933, 33.04672], [-117.12906, 33.04683], [-117.1279, 33.04711], [-117.12762, 33.04723], [-117.12739, 33.04735], [-117.12721, 33.04748], [-117.12681, 33.0475], [-117.12695, 33.04739], [-117.12717, 33.04715], [-117.12727, 33.04708], [-117.12756, 33.04698], [-117.12781, 33.04693], [-117.12815, 33.04695], [-117.12826, 33.04694], [-117.12842, 33.0469], [-117.12857, 33.04684], [-117.12933, 33.04672]]], [[[-117.12985, 33.04642], [-117.12977, 33.04649], [-117.12959, 33.04659], [-117.12959, 33.04653], [-117.12967, 33.04644], [-117.12978, 33.04642], [-117.12985, 33.04642]]]]} | Open Access 1 | 3408 | Hodges Reservoir | 29224 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/water/recreation/reservoirs/hodges.shtml | San Diego 4 | 2271.486 | Hodges Reservoir | 0 | Local Recreation Area 3 | 4 |
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]);