superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
24 rows where MNG_AG_TYP = 16
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14879 | 14879 | 14878 | {"type": "Polygon", "coordinates": [[[-118.22677, 34.25192], [-118.22147, 34.25178], [-118.21696, 34.25173], [-118.21705, 34.24813], [-118.22159, 34.24846], [-118.22162, 34.24484], [-118.22168, 34.24273], [-118.22273, 34.24274], [-118.22322, 34.24194], [-118.22394, 34.24193], [-118.22353, 34.24295], [-118.22307, 34.24366], [-118.22309, 34.24373], [-118.22331, 34.24422], [-118.2239, 34.24472], [-118.22419, 34.24556], [-118.22416, 34.24562], [-118.22416, 34.24572], [-118.22422, 34.24582], [-118.22435, 34.24591], [-118.2245, 34.24592], [-118.22486, 34.24607], [-118.22514, 34.24612], [-118.22528, 34.24618], [-118.22546, 34.24632], [-118.22552, 34.24641], [-118.22555, 34.24651], [-118.22555, 34.24667], [-118.22531, 34.24754], [-118.22529, 34.24766], [-118.2253, 34.24776], [-118.22533, 34.24792], [-118.22539, 34.24805], [-118.22551, 34.24825], [-118.2254, 34.24843], [-118.22556, 34.24872], [-118.22597, 34.24856], [-118.22597, 34.25048], [-118.22621, 34.25075], [-118.22637, 34.251], [-118.22652, 34.25131], [-118.22672, 34.25162], [-118.22677, 34.25192]]]} | No Public Access 3 | La Canada Irrigation District Open Space | 20744 | 2055 | La Canada Irrigation District 359 | Special District 4 | Irrigation District 16 | http://lacanadairrigation.org/ | Special District 4 | 120.9 | La Canada Irrigation District OS | ||
15117 | 15117 | 15116 | {"type": "MultiPolygon", "coordinates": [[[[-120.61168, 37.65074], [-120.61119, 37.6508], [-120.6107, 37.65012], [-120.6096, 37.64943], [-120.60929, 37.64908], [-120.60895, 37.64912], [-120.60862, 37.64956], [-120.6086, 37.64996], [-120.60801, 37.65017], [-120.6077, 37.65055], [-120.60704, 37.65153], [-120.60665, 37.65204], [-120.60629, 37.65264], [-120.60628, 37.65275], [-120.6059, 37.65326], [-120.60575, 37.65389], [-120.60622, 37.65453], [-120.60604, 37.65484], [-120.60602, 37.65518], [-120.60606, 37.65547], [-120.60575, 37.65581], [-120.60564, 37.65648], [-120.60569, 37.65688], [-120.60474, 37.65732], [-120.60465, 37.65722], [-120.6046, 37.6563], [-120.60477, 37.65586], [-120.60476, 37.65579], [-120.60408, 37.65493], [-120.6042, 37.65422], [-120.60368, 37.65372], [-120.60324, 37.6539], [-120.60294, 37.65362], [-120.60342, 37.65323], [-120.60334, 37.65282], [-120.60269, 37.65267], [-120.60234, 37.65284], [-120.60251, 37.65359], [-120.6023, 37.65387], [-120.60181, 37.65423], [-120.60154, 37.65397], [-120.60188, 37.65338], [-120.60183, 37.65277], [-120.6018, 37.65266], [-120.60148, 37.65219], [-120.60099, 37.65184], [-120.60043, 37.65164], [-120.59976, 37.65155], [-120.59972, 37.65124], [-120.60279, 37.6524], [-120.60404, 37.65252], [-120.60566, 37.6518], [-120.6087, 37.64915], [-120.61047, 37.64804], [-120.61067, 37.64782], [-120.61066, 37.64824], [-120.61134, 37.64884], [-120.61129, 37.64988], [-120.61168, 37.65074]]], [[[-120.60572, 37.657], [-120.60529, 37.65791], [-120.60529, 37.65791], [-120.60482, 37.65741], [-120.60572, 37.657]]], [[[-120.61382, 37.64373], [-120.61373, 37.644], [-120.61306, 37.64444], [-120.61109, 37.64514], [-120.61086, 37.64519], [-120.60991, 37.64551], [-120.60933, 37.64563], [-120.60838, 37.64566], [-120.60744, 37.6455], [-120.60696, 37.64524], [-120.60617, 37.64478], [-120.60696, 37.6447], [-120.60916, 37.64471], [-120.61382, 37.64373]]], [[[-120.61428, 37.64851], [-120.61318, 37.64784], [-120.61261, 37.64739], [-120.61218, 37.64685], [-120.61329, 37.64634], [-120.61332, 37.64684], [-120.61382, 37.64735], [-120.61428, 37.64851]]], [[[-120.61487, 37.64591], [-120.61471, 37.64614], [-120.61426, 37.64599], [-120.61426, 37.64599], [-120.61487, 37.64591]]], [[[-120.62931, 37.64723], [-120.62794, 37.64723], [-120.62789, 37.64698], [-120.6276, 37.64638], [-120.62746, 37.64621], [-120.62725, 37.64602], [-120.62695, 37.64584], [-120.62674, 37.64577], [-120.62644, 37.64578], [-120.62565, 37.64609], [-120.62522, 37.64616], [-120.62477, 37.6463], [-120.62443, 37.64636], [-120.62399, 37.64631], [-120.62373, 37.64621], [-120.62354, 37.64617], [-120.62287, 37.64624], [-120.62256, 37.64624], [-120.62074, 37.64615], [-120.62046, 37.64607], [-120.61959, 37.64563], [-120.61933, 37.64553], [-120.62927, 37.64553], [-120.62931, 37.64723]]], [[[-120.62536, 37.65895], [-120.6252, 37.65899], [-120.62484, 37.65895], [-120.62484, 37.65817], [-120.62533, 37.65817], [-120.62536, 37.65895]]], [[[-120.6272, 37.66097], [-120.62719, 37.66184], [-120.62489, 37.66183], [-120.62487, 37.66056], [-120.62557, 37.66062], [-120.62579, 37.66066], [-120.62611, 37.66077], [-120.6266, 37.6609], [-120.62695, 37.6609], [-120.6272, 37.66097]]], [[[-120.63625, 37.64972], [-120.63585, 37.6494], [-120.63538, 37.64896], [-120.63529, 37.64885], [-120.63524, 37.64872], [-120.63507, 37.64851], [-120.63503, 37.64726], [-120.63621, 37.64725], [-120.63625, 37.64972]]], [[[-120.64994, 37.65494], [-120.64928, 37.65562], [-120.64766, 37.65477], [-120.64765, 37.65468], [-120.64803, 37.65443], [-120.64809, 37.65432], [-120.64804, 37.65425], [-120.64792, 37.65421], [-120.64784, 37.65421], [-120.64722, 37.65436], [-120.64708, 37.65437], [-120.64689, 37.65429], [-120.64677, 37.65414], [-120.64679, 37.65381], [-120.64691, 37.65341], [-120.64689, 37.65321], [-120.64691, 37.65304], [-120.64688, 37.6529], [-120.64673, 37.65269], [-120.64624, 37.65235], [-120.64611, 37.65228], [-120.64603, 37.65207], [-120.64585, 37.65201], [-120.64542, 37.65213], [-120.64478, 37.65219], [-120.64457, 37.65219], [-120.64441, 37.65212], [-120.64422, 37.65199], [-120.64394, 37.65172], [-120.64329, 37.65082], [-120.64288, 37.65047], [-120.6427, 37.65034], [-120.64244, 37.65021], [-120.64176, 37.64992], [-120.64068, 37.64968], [-120.64045, 37.64965], [-120.63993, 37.64965], [-120.63992, 37.64885], [-120.64094, 37.64922], [-120.64569, 37.65068], [-120.64825, 37.65269], [-120.64875, 37.6532], [-120.6499, 37.65413], [-120.64994, 37.65494]]], [[[-120.64988, 37.66305], [-120.64977, 37.66334], [-120.64965, 37.66348], [-120.6493, 37.6637], [-120.64926, 37.66292], [-120.64943, 37.6629], [-120.64967, 37.66284], [-120.64986, 37.66297], [-120.64988, 37.66305]]], [[[-120.65144, 37.66129], [-120.65136, 37.66139], [-120.65126, 37.66142], [-120.65059, 37.66148], [-120.65045, 37.66152], [-120.65037, 37.66163], [-120.65036, 37.66177], [-120.65032, 37.66185], [-120.65023, 37.66193], [-120.6501, 37.66198], [-120.64994, 37.66202], [-120.64992, 37.65997], [-120.65088, 37.65998], [-120.65105, 37.66018], [-120.65109, 37.66028], [-120.6511, 37.66069], [-120.65105, 37.6609], [-120.65134, 37.66099], [-120.65141, 37.66104], [-120.65145, 37.66116], [-120.65144, 37.66129]]], [[[-120.67478, 37.65643], [-120.67379, 37.65631], [-120.67277, 37.65654], [-120.67247, 37.65658], [-120.67118, 37.65636], [-120.67052, 37.65609], [-120.67039, 37.65607], [-120.67011, 37.65607], [-120.67009, 37.65624], [-120.67013, 37.65631], [-120.67046, 37.65661], [-120.67045, 37.6567], [-120.67033, 37.65681], [-120.67009, 37.65692], [-120.66998, 37.65695], [-120.66989, 37.65694], [-120.66958, 37.65662], [-120.66943, 37.65654], [-120.66925, 37.65657], [-120.66788, 37.65747], [-120.6678, 37.65754], [-120.66782, 37.65767], [-120.6679, 37.6578], [-120.66817, 37.65804], [-120.66827, 37.65824], [-120.66819, 37.65837], [-120.66792, 37.65837], [-120.66719, 37.65807], [-120.66683, 37.65802], [-120.66668, 37.65806], [-120.66613, 37.65827], [-120.66574, 37.6585], [-120.66564, 37.65865], [-120.66564, 37.65883], [-120.66551, 37.659], [-120.66533, 37.65903], [-120.66525, 37.6589], [-120.6652, 37.65876], [-120.66503, 37.65867], [-120.66477, 37.65878], [-120.66457, 37.65893], [-120.66416, 37.65913], [-120.66388, 37.6592], [-120.6634, 37.65926], [-120.66318, 37.65927], [-120.663, 37.65925], [-120.6628, 37.65921], [-120.66244, 37.65908], [-120.662, 37.65903], [-120.66183, 37.65903], [-120.66123, 37.65908], [-120.66107, 37.65904], [-120.66094, 37.65891], [-120.66091, 37.65883], [-120.66096, 37.65868], [-120.66103, 37.65862], [-120.6611, 37.65845], [-120.66107, 37.65837], [-120.66099, 37.65832], [-120.66044, 37.65834], [-120.66026, 37.65821], [-120.66025, 37.65792], [-120.66021, 37.65787], [-120.66009, 37.65784], [-120.65999, 37.65789], [-120.65981, 37.65808], [-120.65967, 37.65815], [-120.65943, 37.65818], [-120.65934, 37.65814], [-120.65918, 37.65796], [-120.65901, 37.65789], [-120.65903, 37.6576], [-120.6672, 37.65759], [-120.66986, 37.65551], [-120.67132, 37.65502], [-120.67223, 37.65479], [-120.67301, 37.6547], [-120.67366, 37.65465], [-120.67408, 37.65481], [-120.67455, 37.65547], [-120.67475, 37.65549], [-120.67478, 37.65643]]], [[[-120.67644, 37.68455], [-120.67417, 37.68453], [-120.67415, 37.68549], [-120.67304, 37.68551], [-120.67315, 37.69279], [-120.66739, 37.69278], [-120.66739, 37.69174], [-120.66808, 37.69174], [-120.66927, 37.69167], [-120.67001, 37.69099], [-120.67008, 37.69083], [-120.67004, 37.69055], [-120.66994, 37.6903], [-120.66956, 37.6897], [-120.66958, 37.68918], [-120.66972, 37.6889], [-120.67004, 37.68846], [-120.67035, 37.68814], [-120.67084, 37.68775], [-120.67099, 37.68754], [-120.67114, 37.6872], [-120.6712, 37.68672], [-120.67116, 37.68596], [-120.67122, 37.68569], [-120.67146, 37.68535], [-120.6718, 37.6847], [-120.67203, 37.68433], [-120.67298, 37.68325], [-120.67323, 37.68311], [-120.67352, 37.68299], [-120.6739, 37.68288], [-120.6744, 37.68258], [-120.67451, 37.68243], [-120.6745, 37.68229], [-120.67442, 37.68218], [-120.67395, 37.68188], [-120.67641, 37.68188], [-120.67644, 37.68455]]], [[[-120.67471, 37.65419], [-120.67294, 37.65434], [-120.67193, 37.65445], [-120.67136, 37.65413], [-120.67065, 37.65403], [-120.66965, 37.65319], [-120.66833, 37.65251], [-120.66757, 37.65182], [-120.67469, 37.65197], [-120.67469, 37.65355], [-120.67471, 37.65419]]], [[[-120.67472, 37.65441], [-120.67472, 37.65453], [-120.67369, 37.65449], [-120.67369, 37.65449], [-120.67472, 37.65441]]], [[[-120.67475, 37.65533], [-120.67467, 37.65534], [-120.67421, 37.6547], [-120.6741, 37.65466], [-120.67473, 37.65468], [-120.67475, 37.65533]]], [[[-120.67769, 37.65477], [-120.67742, 37.65478], [-120.67637, 37.65487], [-120.67533, 37.65536], [-120.67527, 37.65519], [-120.67527, 37.65495], [-120.67561, 37.65503], [-120.6762, 37.65474], [-120.6774, 37.65478], [-120.67744, 37.65469], [-120.67769, 37.65477]]], [[[-120.68197, 37.66549], [-120.67692, 37.66551], [-120.67681, 37.66535], [-120.67669, 37.66513], [-120.67668, 37.66487], [-120.67675, 37.66467], [-120.6769, 37.66448], [-120.677, 37.66443], [-120.67731, 37.6644], [-120.67771, 37.66439], [-120.67796, 37.66432], [-120.67857, 37.66408], [-120.67943, 37.66389], [-120.67954, 37.66369], [-120.67944, 37.66361], [-120.67913, 37.66357], [-120.67887, 37.66357], [-120.67763, 37.66393], [-120.67683, 37.66394], [-120.67663, 37.66386], [-120.67649, 37.66369], [-120.67646, 37.6636], [-120.67646, 37.66325], [-120.67641, 37.66314], [-120.67642, 37.66303], [-120.67656, 37.66268], [-120.67667, 37.66256], [-120.67684, 37.66247], [-120.67693, 37.66245], [-120.67742, 37.66246], [-120.67759, 37.66252], [-120.67783, 37.66251], [-120.67798, 37.66244], [-120.67842, 37.66218], [-120.67871, 37.66209], [-120.67901, 37.6621], [-120.67938, 37.66228], [-120.67972, 37.66251], [-120.67999, 37.66251], [-120.68023, 37.66232], [-120.68032, 37.66215], [-120.68023, 37.66164], [-120.68022, 37.66103], [-120.68028, 37.66064], [-120.68008, 37.65991], [-120.68006, 37.65964], [-120.6799, 37.6591], [-120.67962, 37.65854], [-120.67899, 37.65777], [-120.67855, 37.65737], [-120.67817, 37.6569], [-120.67778, 37.65662], [-120.67767, 37.65656], [-120.67746, 37.65655], [-120.67736, 37.65659], [-120.67709, 37.65685], [-120.6769, 37.65696], [-120.67669, 37.65696], [-120.67585, 37.65658], [-120.67543, 37.6565], [-120.6753, 37.6565], [-120.67529, 37.65551], [-120.6754, 37.65551], [-120.67642, 37.65501], [-120.67768, 37.65493], [-120.67853, 37.655], [-120.68006, 37.65536], [-120.68013, 37.65525], [-120.68029, 37.65534], [-120.68068, 37.65577], [-120.68106, 37.65605], [-120.68161, 37.65612], [-120.68187, 37.65611], [-120.68197, 37.66549]]], [[[-120.68005, 37.65485], [-120.68003, 37.65492], [-120.67861, 37.65458], [-120.67785, 37.65453], [-120.67977, 37.65419], [-120.68005, 37.65485]]], [[[-120.68187, 37.65585], [-120.68171, 37.65586], [-120.68123, 37.6558], [-120.68095, 37.6556], [-120.68053, 37.65514], [-120.68025, 37.65498], [-120.6803, 37.65486], [-120.68008, 37.65431], [-120.68043, 37.6546], [-120.68186, 37.6551], [-120.68187, 37.65585]]]]} | Open Access 1 | Modesto Reservoir Regional Park | http://www.stancounty.com/ER/PARKS/reservoir.shtm | 29283 | 2081 | Modesto Irrigation District 977 | Special District 4 | Irrigation District 16 | http://www.mid.org/ | Special District 4 | 380.544 | Modesto Reservoir RP | |
15389 | 15389 | 15388 | {"type": "MultiPolygon", "coordinates": [[[[-121.33188, 39.34191], [-121.33189, 39.34216], [-121.33188, 39.34277], [-121.33121, 39.34476], [-121.32791, 39.34345], [-121.32665, 39.344], [-121.32726, 39.34514], [-121.32708, 39.34564], [-121.32807, 39.34709], [-121.32842, 39.34764], [-121.32772, 39.34845], [-121.3264, 39.3485], [-121.32679, 39.35054], [-121.32645, 39.35135], [-121.32611, 39.35143], [-121.32406, 39.35095], [-121.32355, 39.35201], [-121.32411, 39.3543], [-121.32393, 39.35623], [-121.32203, 39.35606], [-121.32233, 39.35703], [-121.32218, 39.35806], [-121.3208, 39.35861], [-121.32109, 39.3604], [-121.32114, 39.36108], [-121.32034, 39.36122], [-121.32035, 39.362], [-121.31996, 39.36193], [-121.3199, 39.36118], [-121.31899, 39.36126], [-121.31866, 39.36182], [-121.31683, 39.36169], [-121.31191, 39.36163], [-121.31381, 39.36072], [-121.31438, 39.35769], [-121.3151, 39.35558], [-121.3156, 39.35493], [-121.31674, 39.35424], [-121.31864, 39.35203], [-121.31711, 39.35045], [-121.31381, 39.35083], [-121.3124, 39.35023], [-121.31157, 39.34868], [-121.30954, 39.34808], [-121.30783, 39.347], [-121.3062, 39.34438], [-121.30459, 39.34319], [-121.3042, 39.34249], [-121.30412, 39.34039], [-121.30516, 39.33994], [-121.30606, 39.33992], [-121.30807, 39.33934], [-121.30807, 39.33857], [-121.3048, 39.33534], [-121.30563, 39.33302], [-121.30741, 39.33138], [-121.30729, 39.33068], [-121.3033, 39.32901], [-121.30466, 39.32782], [-121.30453, 39.32059], [-121.3106, 39.32065], [-121.31527, 39.32072], [-121.31837, 39.32456], [-121.31915, 39.32509], [-121.3195, 39.32553], [-121.32, 39.32597], [-121.32241, 39.32959], [-121.32248, 39.32994], [-121.32225, 39.3305], [-121.32237, 39.33074], [-121.32276, 39.3312], [-121.32426, 39.33264], [-121.32427, 39.33439], [-121.32584, 39.33452], [-121.32707, 39.33532], [-121.32707, 39.33704], [-121.32858, 39.33861], [-121.32912, 39.34105], [-121.33188, 39.34191]]], [[[-121.32123, 39.36596], [-121.32097, 39.36688], [-121.31987, 39.36715], [-121.31905, 39.36651], [-121.31795, 39.36582], [-121.31713, 39.36478], [-121.3153, 39.36402], [-121.31306, 39.36412], [-121.31005, 39.36485], [-121.3087, 39.36396], [-121.30512, 39.36372], [-121.30466, 39.36234], [-121.30758, 39.36172], [-121.31033, 39.36236], [-121.31075, 39.36219], [-121.31169, 39.36174], [-121.31524, 39.36175], [-121.31682, 39.36179], [-121.3186, 39.36191], [-121.31776, 39.36316], [-121.32079, 39.36518], [-121.32123, 39.36596]]], [[[-121.32835, 39.32083], [-121.32741, 39.32099], [-121.32743, 39.32082], [-121.32742, 39.32081], [-121.32611, 39.32104], [-121.32606, 39.32077], [-121.32632, 39.32044], [-121.32753, 39.32028], [-121.32834, 39.32058], [-121.32835, 39.32083]]]]} | Open Access 1 | Collins Lake Recreation Area | http://www.collinslake.com/map | 720 | 2010 | Browns Valley Irrigation District 1114 | Special District 4 | Irrigation District 16 | http://www.bvid.org/ | Special District 4 | 1599.03 | Collins Lake Rec. Area | |
15419 | 15419 | 15418 | {"type": "Polygon", "coordinates": [[[-120.00196, 37.03239], [-120.00171, 37.03243], [-120.00016, 37.03244], [-119.99943, 37.03242], [-119.99724, 37.03242], [-119.99579, 37.03241], [-119.99252, 37.03241], [-119.98734, 37.03239], [-119.98585, 37.0324], [-119.979, 37.03232], [-119.979, 37.03958], [-119.97675, 37.03953], [-119.97457, 37.03941], [-119.97448, 37.03591], [-119.96991, 37.03582], [-119.9699, 37.03231], [-119.97086, 37.03233], [-119.97446, 37.03226], [-119.97437, 37.02492], [-119.9744, 37.02311], [-119.97465, 37.023], [-119.97595, 37.02177], [-119.97705, 37.02028], [-119.9795, 37.01914], [-119.98213, 37.0183], [-119.98262, 37.01829], [-119.98364, 37.01781], [-119.98429, 37.01744], [-119.9852, 37.01715], [-119.98573, 37.01685], [-119.98675, 37.01624], [-119.98722, 37.01571], [-119.98802, 37.0152], [-119.98904, 37.01478], [-119.98933, 37.01476], [-119.98986, 37.01509], [-119.99053, 37.0152], [-119.99118, 37.01519], [-119.99207, 37.01523], [-119.99285, 37.01517], [-119.99361, 37.01483], [-119.99386, 37.0146], [-119.99395, 37.0136], [-119.99422, 37.01325], [-119.99436, 37.01282], [-119.99458, 37.01265], [-119.99507, 37.01245], [-119.99623, 37.0122], [-119.99704, 37.01195], [-119.99831, 37.01198], [-119.99894, 37.01182], [-119.99942, 37.01152], [-120.00002, 37.01106], [-120.00027, 37.01077], [-120.00172, 37.01077], [-120.00185, 37.02526], [-120.00196, 37.03239]]]} | No Public Access 3 | Madera Lake Park And Recreation Area | 21652 | 2275 | Madera Irrigation District 1113 | Special District 4 | Irrigation District 16 | http://www.madera-id.org/ | Special District 4 | 1216.326 | Madera Lake Park And Rec. Area |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);