superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
200 rows where MNG_AG_TYP = 15 sorted by PARK_NAME descending
This data as json, copyable, CSV (advanced)
Suggested facets: PARK_URL
MNG_AGENCY >30
- Woodbridge Village Association 31
- Home Owners Association - Unknown Name 25
- Rancho Santa Margarita Landscape and Recreation Corporation 17
- Amerige Heights Community Association 7
- Paseo Westpark Maintenance Association 4
- Deerfield Community Association 4
- Nellie Gail Ranch Owners Association 4
- Westpark Maintenance District 4
- Sierra Bonita Community Association 4
- Town Center Association 4
- Quail Hill Community Association 3
- East Highlands Ranch MHOA 3
- Northpark Square Maintenance Association 3
- Turtle Rock Broadmoor Community Association 3
- Summerly Homes 2
- Oak Creek Village Maintenance Association 2
- Broadmoor Campus View Community Association 2
- Woodbridge Owners Association 2
- Northpark Maintenance Association 2
- Windwood Homeowners Association 2
- Johnson Ranch Community Association 2
- Woodbury Community Association 2
- Park Paseo Homeowners Association 2
- Harvard Square Maintenance Association 1
- Liberty Park Homeowners Association 1
- Turtle Rock Ridge Association 1
- Parkside Community Association 1
- Wagon Wheel Canyon Community Association 1
- L F Maintenance Corporation 1
- Serrano Park Community Association 1
- …
ACCESS_TYP 2
MNG_AG_TYP 1
- Home Owners Association · 200 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1448 | 1448 | 1447 | {"type": "Polygon", "coordinates": [[[-117.79032, 33.68059], [-117.78996, 33.68096], [-117.78968, 33.68077], [-117.78973, 33.68055], [-117.78979, 33.68042], [-117.7899, 33.68029], [-117.79032, 33.68059]]]} | Restricted Access 2 | Woodspring Pool | 32225 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | http://www.wva.org/ | Private 14 | 0.596 | Woodspring Pool | ||
12338 | 12338 | 12337 | {"type": "Polygon", "coordinates": [[[-117.79367, 33.69628], [-117.7937, 33.69669], [-117.7937, 33.69681], [-117.79363, 33.69698], [-117.79351, 33.69709], [-117.79334, 33.69718], [-117.79322, 33.69721], [-117.79305, 33.69722], [-117.79334, 33.69695], [-117.79323, 33.69685], [-117.7933, 33.69679], [-117.79334, 33.69666], [-117.79299, 33.69636], [-117.79367, 33.69628]]]} | Restricted Access 2 | Woodrush Park | 32388 | 6006 | Deerfield Community Association 656 | Private 7 | Home Owners Association 15 | http://www.accellpmassoc.com/Deerfield/ | Private 14 | 0.949 | Woodrush Park | ||
11399 | 11399 | 11398 | {"type": "Polygon", "coordinates": [[[-117.80523, 33.68667], [-117.8047, 33.68721], [-117.80468, 33.6872], [-117.8047, 33.68714], [-117.80468, 33.68707], [-117.80463, 33.68704], [-117.80447, 33.68703], [-117.80433, 33.68695], [-117.80385, 33.68661], [-117.80384, 33.68655], [-117.80393, 33.68641], [-117.80406, 33.68628], [-117.80409, 33.68622], [-117.80433, 33.68608], [-117.80523, 33.68667]]]} | Restricted Access 2 | Woodpine Park | 27731 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | http://www.wva.org/ | Private 14 | 2.006 | Woodpine Park | ||
8425 | 8425 | 8424 | {"type": "Polygon", "coordinates": [[[-117.80027, 33.66991], [-117.80018, 33.67024], [-117.80008, 33.67049], [-117.80006, 33.67053], [-117.80003, 33.67054], [-117.79893, 33.67026], [-117.79915, 33.66963], [-117.80027, 33.66991]]]} | Restricted Access 2 | Woodflower Park | 32361 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | http://www.wva.org/ | Private 14 | 2.012 | Woodflower Park | ||
13028 | 13028 | 13027 | {"type": "Polygon", "coordinates": [[[-116.99842, 32.62091], [-116.9984, 32.62094], [-116.99795, 32.62104], [-116.99791, 32.62102], [-116.99774, 32.62046], [-116.99776, 32.62042], [-116.99821, 32.62033], [-116.99825, 32.62035], [-116.99842, 32.62091]]]} | Restricted Access 2 | Wisteria Park | 33350 | 6074 | Home Owners Association - Unknown Name 629 | Private 7 | Home Owners Association 15 | Private 14 | 0.857 | Wisteria Park | |||
11342 | 11342 | 11341 | {"type": "Polygon", "coordinates": [[[-117.80304, 33.6655], [-117.80296, 33.66592], [-117.80301, 33.66599], [-117.80294, 33.66604], [-117.80285, 33.66622], [-117.80277, 33.66631], [-117.80242, 33.66649], [-117.80227, 33.66661], [-117.80216, 33.66673], [-117.80208, 33.66688], [-117.80202, 33.66707], [-117.80206, 33.6668], [-117.80218, 33.66645], [-117.80241, 33.66541], [-117.80304, 33.6655]]]} | Restricted Access 2 | Wintermist Park | 27654 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | http://www.wva.org/ | Private 14 | 1.725 | Wintermist Park | ||
388 | 388 | 387 | {"type": "Polygon", "coordinates": [[[-117.79919, 33.70158], [-117.79917, 33.70162], [-117.79897, 33.70148], [-117.79893, 33.70151], [-117.79887, 33.70146], [-117.79888, 33.70142], [-117.7986, 33.70122], [-117.79855, 33.70125], [-117.79849, 33.7012], [-117.79851, 33.70116], [-117.79822, 33.70096], [-117.79818, 33.70099], [-117.79812, 33.70094], [-117.79814, 33.7009], [-117.798, 33.7008], [-117.79808, 33.7007], [-117.79794, 33.70061], [-117.79788, 33.70065], [-117.79785, 33.70061], [-117.79782, 33.70061], [-117.79785, 33.70055], [-117.79756, 33.70035], [-117.7975, 33.70038], [-117.79747, 33.70035], [-117.79744, 33.70036], [-117.79739, 33.7004], [-117.79723, 33.7003], [-117.79704, 33.70049], [-117.79702, 33.70047], [-117.79702, 33.70042], [-117.79723, 33.70021], [-117.79725, 33.70014], [-117.7973, 33.70015], [-117.79744, 33.70024], [-117.79754, 33.70021], [-117.79777, 33.70037], [-117.79786, 33.70029], [-117.79787, 33.7003], [-117.79784, 33.70037], [-117.79788, 33.70045], [-117.79796, 33.70049], [-117.79805, 33.70048], [-117.79821, 33.70059], [-117.79832, 33.70048], [-117.79832, 33.70046], [-117.79837, 33.70041], [-117.7984, 33.70041], [-117.79863, 33.70017], [-117.79861, 33.70013], [-117.79866, 33.70008], [-117.79871, 33.7001], [-117.79882, 33.69998], [-117.798, 33.69939], [-117.79829, 33.6991], [-117.79817, 33.699], [-117.79825, 33.69889], [-117.79719, 33.69814], [-117.79754, 33.69802], [-117.79764, 33.69806], [-117.79779, 33.69828], [-117.79799, 33.69851], [-117.7982, 33.6987], [-117.79867, 33.69904], [-117.79879, 33.69915], [-117.79888, 33.69928], [-117.79895, 33.69943], [-117.79899, 33.69965], [-117.79897, 33.6998], [-117.79893, 33.69995], [-117.79887, 33.70008], [-117.79878, 33.70019], [-117.7984, 33.70058], [-117.79823, 33.70071], [-117.7982, 33.70076], [-117.79819, 33.70082], [-117.79822, 33.7009], [-117.79826, 33.70094], [-117.79847, 33.70105], [-117.79917, 33.70154], [-117.79919, 33.70158]]]} | Restricted Access 2 | Windwood Park | 31992 | 6033 | Windwood Homeowners Association 899 | Private 7 | Home Owners Association 15 | Private 14 | 3.281 | Windwood Park | |||
11319 | 11319 | 11318 | {"type": "Polygon", "coordinates": [[[-117.81322, 33.67765], [-117.81281, 33.67806], [-117.81272, 33.67808], [-117.81269, 33.67807], [-117.8117, 33.6774], [-117.8122, 33.67696], [-117.81322, 33.67765]]]} | Restricted Access 2 | Windjammer Park | 27627 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | http://www.wva.org/ | Private 14 | 2.035 | Windjammer Park | ||
11225 | 11225 | 11224 | {"type": "Polygon", "coordinates": [[[-117.78759, 33.68347], [-117.78758, 33.6835], [-117.78705, 33.68403], [-117.78624, 33.68348], [-117.78675, 33.68297], [-117.78688, 33.68301], [-117.78707, 33.68309], [-117.78757, 33.68342], [-117.78759, 33.68347]]]} | Restricted Access 2 | Wildwood Park | 27526 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | http://www.wva.org/ | Private 14 | 1.939 | Wildwood Park | ||
356 | 356 | 355 | {"type": "Polygon", "coordinates": [[[-117.82529, 33.67215], [-117.8251, 33.67255], [-117.82503, 33.67255], [-117.82494, 33.67261], [-117.82493, 33.67271], [-117.82497, 33.67277], [-117.8247, 33.67331], [-117.82459, 33.67328], [-117.82449, 33.67348], [-117.82452, 33.67353], [-117.82445, 33.67361], [-117.82445, 33.67369], [-117.82438, 33.67371], [-117.82418, 33.67412], [-117.82366, 33.67394], [-117.82386, 33.67353], [-117.82384, 33.67349], [-117.8239, 33.67347], [-117.82394, 33.67342], [-117.82394, 33.67337], [-117.82392, 33.67333], [-117.82396, 33.67331], [-117.82406, 33.67311], [-117.82394, 33.67305], [-117.82417, 33.67256], [-117.82428, 33.67257], [-117.82434, 33.67254], [-117.82438, 33.6725], [-117.82439, 33.67243], [-117.82436, 33.67239], [-117.82445, 33.67235], [-117.82461, 33.67194], [-117.82529, 33.67215]]]} | Restricted Access 2 | WestPark Village One Association Park | 31985 | 6005 | Culverdale Community Association 1024 | Private 7 | Home Owners Association 15 | http://www.westparkvillageone.org/ | Private 14 | 3.69 | WestPark Village One Association Park | ||
12330 | 12330 | 12329 | {"type": "Polygon", "coordinates": [[[-117.62859, 33.66568], [-117.62831, 33.66593], [-117.62829, 33.66592], [-117.62829, 33.66585], [-117.62826, 33.6658], [-117.62819, 33.66573], [-117.62727, 33.66515], [-117.62659, 33.66477], [-117.62657, 33.66475], [-117.62657, 33.66472], [-117.62661, 33.66467], [-117.62678, 33.66483], [-117.62681, 33.66484], [-117.62683, 33.66483], [-117.62705, 33.66497], [-117.62717, 33.66494], [-117.62721, 33.66499], [-117.62727, 33.66502], [-117.62734, 33.66502], [-117.6274, 33.66499], [-117.6275, 33.6648], [-117.6277, 33.66493], [-117.62779, 33.66485], [-117.62812, 33.66497], [-117.6282, 33.66491], [-117.62823, 33.66497], [-117.62853, 33.66525], [-117.62843, 33.66552], [-117.62859, 33.66568]]]} | Restricted Access 2 | Wandering Trails Park | 32380 | 6050 | Painted Trails Community Association 1051 | Private 7 | Home Owners Association 15 | http://www.paintedtrails.org/ | Private 14 | 1.972 | Wandering Trails Park | ||
14230 | 14230 | 14229 | {"type": "Polygon", "coordinates": [[[-117.57444, 33.64923], [-117.5744, 33.64929], [-117.57435, 33.64931], [-117.57435, 33.64936], [-117.57416, 33.64937], [-117.57379, 33.64929], [-117.5735, 33.64935], [-117.57367, 33.64963], [-117.57381, 33.64979], [-117.57379, 33.64982], [-117.57383, 33.65015], [-117.57356, 33.65015], [-117.57353, 33.6499], [-117.57342, 33.64976], [-117.57325, 33.64939], [-117.573, 33.6491], [-117.57296, 33.64904], [-117.57295, 33.64897], [-117.57295, 33.6489], [-117.57311, 33.64844], [-117.57314, 33.64821], [-117.57315, 33.64777], [-117.57312, 33.6473], [-117.57329, 33.64725], [-117.57335, 33.64753], [-117.57338, 33.64755], [-117.57342, 33.64771], [-117.57383, 33.64748], [-117.5741, 33.64778], [-117.574, 33.64784], [-117.574, 33.6479], [-117.57396, 33.64794], [-117.57384, 33.64799], [-117.5738, 33.64804], [-117.5738, 33.6481], [-117.57385, 33.64819], [-117.57398, 33.64812], [-117.57435, 33.64858], [-117.57438, 33.64859], [-117.57441, 33.64872], [-117.57443, 33.64874], [-117.57444, 33.64887], [-117.57444, 33.64923]]]} | Restricted Access 2 | Walden Park | 31714 | 6061 | Rancho Santa Margarita Landscape and Recreation Corporation 611 | Private 7 | Home Owners Association 15 | http://www.samlarc.org/ | Private 14 | 5.766 | Walden Park | ||
14229 | 14229 | 14228 | {"type": "Polygon", "coordinates": [[[-117.5971, 33.63467], [-117.59708, 33.63469], [-117.59704, 33.63464], [-117.59698, 33.63462], [-117.59688, 33.63463], [-117.59683, 33.6347], [-117.59679, 33.63483], [-117.59669, 33.63486], [-117.59628, 33.63476], [-117.59581, 33.63472], [-117.59577, 33.63471], [-117.59574, 33.63468], [-117.59571, 33.63444], [-117.59569, 33.63441], [-117.59561, 33.63437], [-117.59564, 33.63431], [-117.59571, 33.63431], [-117.59579, 33.63427], [-117.5958, 33.63425], [-117.59583, 33.63408], [-117.59591, 33.63399], [-117.59601, 33.63391], [-117.59614, 33.63384], [-117.59682, 33.63362], [-117.59663, 33.63306], [-117.59655, 33.6329], [-117.59639, 33.63268], [-117.59603, 33.63231], [-117.59616, 33.63221], [-117.59659, 33.63264], [-117.59675, 33.63288], [-117.59679, 33.63298], [-117.59718, 33.63409], [-117.59717, 33.63434], [-117.5971, 33.63467]]]} | Restricted Access 2 | Vista Verde Park | 31713 | 6061 | Rancho Santa Margarita Landscape and Recreation Corporation 611 | Private 7 | Home Owners Association 15 | http://www.samlarc.org/ | Private 14 | 4.149 | Vista Verde Park | ||
6568 | 6568 | 6567 | {"type": "Polygon", "coordinates": [[[-121.33415, 38.0047], [-121.33339, 38.0049], [-121.33335, 38.0049], [-121.33331, 38.00487], [-121.33306, 38.00439], [-121.33306, 38.00436], [-121.33311, 38.00433], [-121.33386, 38.00414], [-121.33415, 38.0047]]]} | Restricted Access 2 | Village Oaks Community Park | https://www.villageoakscommonareasassociation.org/ | 33647 | 6136 | Lincoln Village Home Association 832 | Private 7 | Home Owners Association 15 | Private 14 | 1.255 | Village Oaks Community Park | ||
10642 | 10642 | 10641 | {"type": "Polygon", "coordinates": [[[-117.77074, 33.64293], [-117.77069, 33.64363], [-117.77064, 33.64366], [-117.77029, 33.64361], [-117.76995, 33.64358], [-117.76969, 33.64352], [-117.76952, 33.64344], [-117.76934, 33.6433], [-117.76928, 33.64323], [-117.76922, 33.64313], [-117.76924, 33.64307], [-117.7694, 33.64301], [-117.76944, 33.64307], [-117.7695, 33.64306], [-117.76951, 33.64304], [-117.7695, 33.643], [-117.76969, 33.64291], [-117.76988, 33.64273], [-117.76992, 33.64272], [-117.77034, 33.64285], [-117.77072, 33.64291], [-117.77074, 33.64293]]]} | Restricted Access 2 | Valley View Park | 26809 | 6019 | Quail Hill Community Association 402 | Private 7 | Home Owners Association 15 | http://www.quailhillhoa.org/ | Private 14 | 2.457 | Valley View Park | ||
14373 | 14373 | 14372 | {"type": "MultiPolygon", "coordinates": [[[[-117.23584, 34.05241], [-117.23549, 34.05282], [-117.23539, 34.05282], [-117.23539, 34.05228], [-117.23553, 34.05229], [-117.23564, 34.05231], [-117.23584, 34.05241]]], [[[-117.23799, 34.05321], [-117.23708, 34.05429], [-117.23702, 34.05429], [-117.23669, 34.0541], [-117.23668, 34.05405], [-117.23759, 34.05298], [-117.23765, 34.05297], [-117.23798, 34.05316], [-117.23799, 34.05321]]], [[[-117.23727, 34.04704], [-117.23727, 34.04741], [-117.23683, 34.04741], [-117.23684, 34.04703], [-117.23703, 34.04703], [-117.23706, 34.04698], [-117.23708, 34.04703], [-117.23727, 34.04704]]], [[[-117.23878, 34.0544], [-117.23852, 34.05439], [-117.23842, 34.05435], [-117.2383, 34.05429], [-117.23867, 34.05386], [-117.23878, 34.05386], [-117.23878, 34.0544]]]]} | Restricted Access 2 | Unnamed Park - Mission Trails HOA | 33179 | 7032 | Mission Trails HOA 763 | Private 7 | Home Owners Association 15 | https://www.facebook.com/pg/missiontrailshoa/about/?ref=page_internal | Private 14 | 2.938 | |||
14405 | 14405 | 14404 | {"type": "MultiPolygon", "coordinates": [[[[-119.63533, 36.86486], [-119.63533, 36.86486], [-119.63468, 36.86486], [-119.63468, 36.86484], [-119.63503, 36.86465], [-119.63507, 36.86466], [-119.63533, 36.86484], [-119.63533, 36.86486]]], [[[-119.63664, 36.86487], [-119.6357, 36.86487], [-119.63566, 36.86484], [-119.63602, 36.86449], [-119.63664, 36.86487]]], [[[-119.64194, 36.86363], [-119.64191, 36.86365], [-119.6416, 36.86365], [-119.64158, 36.86363], [-119.6416, 36.86306], [-119.64163, 36.86303], [-119.6419, 36.86303], [-119.64193, 36.86306], [-119.64194, 36.86363]]], [[[-119.64596, 36.86344], [-119.64596, 36.86363], [-119.64537, 36.86363], [-119.64537, 36.86344], [-119.64596, 36.86344]]], [[[-119.6463, 36.86046], [-119.6463, 36.86082], [-119.64628, 36.86085], [-119.64624, 36.86087], [-119.6457, 36.86088], [-119.64566, 36.86086], [-119.64564, 36.86083], [-119.64564, 36.86047], [-119.64565, 36.86043], [-119.64569, 36.86041], [-119.64624, 36.86041], [-119.64627, 36.86042], [-119.6463, 36.86046]]]]} | Restricted Access 2 | Unknown park - Harlan Ranch Community Association | 33655 | 6138 | Harlan Ranch Community Association 793 | Private 7 | Home Owners Association 15 | http://www.harlanranchca.com/default.php | Private 14 | 2.17 | |||
14404 | 14404 | 14403 | {"type": "Polygon", "coordinates": [[[-116.9052, 33.74329], [-116.90501, 33.7433], [-116.905, 33.74348], [-116.90478, 33.74342], [-116.90428, 33.74342], [-116.90426, 33.74343], [-116.90382, 33.74341], [-116.9038, 33.74359], [-116.90363, 33.74359], [-116.90362, 33.74341], [-116.9023, 33.74342], [-116.90203, 33.74347], [-116.90203, 33.74298], [-116.90225, 33.74307], [-116.90248, 33.74307], [-116.90266, 33.74299], [-116.90283, 33.74306], [-116.90306, 33.74306], [-116.90324, 33.74299], [-116.90342, 33.74306], [-116.90364, 33.74306], [-116.90383, 33.74298], [-116.90401, 33.74306], [-116.90423, 33.74306], [-116.90442, 33.74298], [-116.90459, 33.74306], [-116.90482, 33.74305], [-116.905, 33.74298], [-116.90501, 33.74326], [-116.9052, 33.74326], [-116.9052, 33.74329]]]} | Restricted Access 2 | Unknown park - Briarcliff Homeowners Association | 33654 | 6137 | Briarcliff Homeowners Association 792 | Private 7 | Home Owners Association 15 | https://www.briarcliff.org/ | Private 14 | 3.012 | |||
14361 | 14361 | 14360 | {"type": "Polygon", "coordinates": [[[-117.09427, 33.49075], [-117.09413, 33.4908], [-117.09236, 33.48975], [-117.09204, 33.48957], [-117.09188, 33.48943], [-117.09177, 33.48927], [-117.0916, 33.48886], [-117.09146, 33.48864], [-117.09201, 33.48839], [-117.09211, 33.48855], [-117.09206, 33.4891], [-117.09195, 33.48923], [-117.09198, 33.4893], [-117.09222, 33.48943], [-117.09228, 33.48942], [-117.09233, 33.48948], [-117.09239, 33.48951], [-117.09238, 33.4896], [-117.09326, 33.49009], [-117.09336, 33.49005], [-117.09339, 33.49009], [-117.09345, 33.49012], [-117.09356, 33.49012], [-117.09361, 33.4902], [-117.09398, 33.49024], [-117.09411, 33.49022], [-117.09427, 33.49075]]]} | Restricted Access 2 | Unknown Park - Paseo del Sol Master Association | 31757 | 6110 | Paseo del Sol Master Association 760 | Private 7 | Home Owners Association 15 | http://www.twmc.com/paseodelsol/ | Private 14 | 2.529 | |||
8423 | 8423 | 8422 | {"type": "Polygon", "coordinates": [[[-117.76051, 33.723], [-117.76018, 33.72345], [-117.7593, 33.723], [-117.75877, 33.72276], [-117.75964, 33.7227], [-117.76006, 33.72279], [-117.76051, 33.723]]]} | Restricted Access 2 | Trailwood Park | 32357 | 6025 | Trailwood Maintenance Association 694 | Private 7 | Home Owners Association 15 | http://www.trailwood.org/ | Private 14 | 1.521 | Trailwood Park |
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]);