superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
10,210 rows where MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- San Diego, City of 359
- Los Angeles, City of 343
- San Jose, City of 151
- San Francisco, City and County of 145
- Sacramento, City of 140
- Ventura, City of 136
- Long Beach, City of 116
- Roseville, City of 96
- Irvine, City of 76
- Fresno, City of 74
- Oakland, City of 65
- Poway, City of 60
- Torrance, City of 57
- Santa Cruz, City of 55
- Davis, City of 51
- Stockton, City of 51
- Napa, City of 50
- Chula Vista, City of 49
- Rocklin, City of 49
- Clovis, City of 48
- Modesto, City of 48
- Huntington Beach, City of 47
- San Ramon, City of 46
- Santa Barbara, City of 44
- Santa Rosa, City of 43
- Newport Beach, City of 43
- San Luis Obispo, City of 42
- Fremont, City of 40
- Tracy, City of 40
- Novato, City of 40
- …
ACCESS_TYP 4
- Open Access 6,453
- Restricted Access 254
- No Public Access 132
- Unknown Access 23
MNG_AG_TYP 1
- City Agency · 6,862 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5057 | 5057 | 5056 | {"type": "Polygon", "coordinates": [[[-117.57751, 33.84415], [-117.57745, 33.84458], [-117.57741, 33.84466], [-117.57731, 33.84478], [-117.57728, 33.84484], [-117.57731, 33.84492], [-117.57738, 33.84498], [-117.57734, 33.8453], [-117.57585, 33.84516], [-117.57613, 33.84334], [-117.57618, 33.84334], [-117.57617, 33.84345], [-117.57612, 33.84363], [-117.57612, 33.84368], [-117.57618, 33.84378], [-117.57626, 33.84383], [-117.57623, 33.84413], [-117.57666, 33.84413], [-117.5769, 33.8441], [-117.57751, 33.84415]]]} | Open Access 1 | Heritage Park | 19846 | 1068 | Corona, City of 63 | City 2 | City Agency 2 | http://www.coronadwp.com/parkmaint/index.shtml | City 2 | 4.404 | Heritage Park | ||
5058 | 5058 | 5057 | {"type": "Polygon", "coordinates": [[[-117.69807, 33.46235], [-117.69807, 33.46339], [-117.69794, 33.46342], [-117.69795, 33.46533], [-117.69789, 33.46539], [-117.6979, 33.46445], [-117.69788, 33.4643], [-117.69782, 33.46425], [-117.69786, 33.46418], [-117.69785, 33.46412], [-117.69791, 33.46409], [-117.6979, 33.46398], [-117.69775, 33.46365], [-117.69764, 33.46368], [-117.69743, 33.46356], [-117.69742, 33.4635], [-117.69737, 33.46345], [-117.69742, 33.46336], [-117.69733, 33.46325], [-117.69717, 33.46316], [-117.69702, 33.46313], [-117.69679, 33.46322], [-117.69672, 33.46317], [-117.69662, 33.46317], [-117.69659, 33.46319], [-117.69656, 33.46324], [-117.69646, 33.46323], [-117.69625, 33.4633], [-117.69608, 33.46344], [-117.69602, 33.46343], [-117.69596, 33.46343], [-117.69589, 33.4635], [-117.6958, 33.46349], [-117.69567, 33.46318], [-117.69558, 33.46257], [-117.69807, 33.46235]]]} | Open Access 1 | Heritage Park | 19847 | 1079 | Dana Point, City of 131 | City 2 | City Agency 2 | http://www.danapoint.org/index.aspx?page=170 | City 2 | 5.924 | Heritage Park | ||
5059 | 5059 | 5058 | {"type": "Polygon", "coordinates": [[[-117.84397, 33.97359], [-117.84302, 33.97478], [-117.84226, 33.97435], [-117.84321, 33.97317], [-117.84397, 33.97359]]]} | Open Access 1 | Heritage Park | 19848 | 1085 | Diamond Bar, City of 312 | City 2 | City Agency 2 | http://www.ci.diamond-bar.ca.us/Index.aspx?page=939 | City 2 | 3.321 | Heritage Park | ||
5060 | 5060 | 5059 | {"type": "Polygon", "coordinates": [[[-117.95117, 33.70777], [-117.95117, 33.70828], [-117.9504, 33.70829], [-117.9504, 33.70816], [-117.95045, 33.70811], [-117.95045, 33.70804], [-117.95053, 33.70802], [-117.95052, 33.70786], [-117.95104, 33.70785], [-117.95106, 33.70777], [-117.95117, 33.70777]]]} | Open Access 1 | Heritage Park | 19849 | 1111 | Fountain Valley, City of 268 | City 2 | City Agency 2 | http://www.fountainvalley.org/visitors/parks/ | City 2 | 0.804 | Heritage Park | ||
5061 | 5061 | 5060 | {"type": "Polygon", "coordinates": [[[-117.78086, 33.70027], [-117.78075, 33.70072], [-117.7807, 33.7008], [-117.7806, 33.70085], [-117.78027, 33.70086], [-117.78023, 33.70088], [-117.78016, 33.70097], [-117.77979, 33.70281], [-117.77977, 33.70299], [-117.77956, 33.70288], [-117.77939, 33.70284], [-117.77925, 33.70283], [-117.77909, 33.70284], [-117.77894, 33.70289], [-117.77872, 33.7031], [-117.77862, 33.7033], [-117.7785, 33.70404], [-117.77844, 33.70421], [-117.77816, 33.70418], [-117.77764, 33.70341], [-117.77759, 33.70343], [-117.77669, 33.70213], [-117.7772, 33.70185], [-117.7765, 33.70075], [-117.77767, 33.69954], [-117.77828, 33.69995], [-117.77854, 33.69994], [-117.77909, 33.69938], [-117.77899, 33.69929], [-117.77925, 33.69903], [-117.78064, 33.69999], [-117.78059, 33.70007], [-117.78086, 33.70027]]]} | Open Access 1 | Heritage Park | 19850 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 30.629 | Heritage Park | ||
5062 | 5062 | 5061 | {"type": "Polygon", "coordinates": [[[-117.77666, 34.12771], [-117.77648, 34.12776], [-117.77611, 34.1278], [-117.7758, 34.12781], [-117.77566, 34.12789], [-117.77553, 34.128], [-117.77518, 34.12847], [-117.77516, 34.12873], [-117.77513, 34.12876], [-117.77504, 34.12875], [-117.77491, 34.12831], [-117.77483, 34.12796], [-117.77483, 34.12784], [-117.77492, 34.12751], [-117.77553, 34.12759], [-117.77594, 34.12763], [-117.77604, 34.12765], [-117.77661, 34.12766], [-117.77665, 34.12768], [-117.77666, 34.12771]]]} | Open Access 1 | Heritage Park | 19851 | 1162 | La Verne, City of 301 | City 2 | City Agency 2 | http://www.ci.la-verne.ca.us/index.php/residents/parks | City 2 | 1.914 | Heritage Park | ||
5063 | 5063 | 5062 | {"type": "Polygon", "coordinates": [[[-117.93514, 33.73981], [-117.93478, 33.74004], [-117.93455, 33.74022], [-117.93426, 33.74049], [-117.93398, 33.7408], [-117.93383, 33.74101], [-117.93354, 33.74148], [-117.93336, 33.74182], [-117.9331, 33.74245], [-117.93308, 33.74147], [-117.93261, 33.74146], [-117.93261, 33.73985], [-117.93299, 33.73995], [-117.93392, 33.73994], [-117.93401, 33.73984], [-117.93402, 33.73981], [-117.93514, 33.73981]]]} | Open Access 1 | Heritage Park | 19854 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 6.8 | Heritage Park | ||
5064 | 5064 | 5063 | {"type": "MultiPolygon", "coordinates": [[[[-118.07484, 33.94086], [-118.07444, 33.94153], [-118.07459, 33.94162], [-118.07441, 33.94237], [-118.07292, 33.94176], [-118.07286, 33.94168], [-118.07286, 33.94086], [-118.07484, 33.94086]]], [[[-118.07801, 33.93894], [-118.07672, 33.94086], [-118.07657, 33.94091], [-118.07636, 33.94094], [-118.0762, 33.94095], [-118.07598, 33.94093], [-118.07577, 33.94087], [-118.07561, 33.9408], [-118.07547, 33.94071], [-118.0753, 33.94057], [-118.0753, 33.94053], [-118.07531, 33.9405], [-118.07546, 33.94036], [-118.07559, 33.94022], [-118.07585, 33.93981], [-118.07611, 33.93909], [-118.07615, 33.93904], [-118.07621, 33.93903], [-118.07745, 33.93902], [-118.07772, 33.93906], [-118.07784, 33.93902], [-118.07792, 33.93894], [-118.07801, 33.93894]]]]} | Open Access 1 | Heritage Park | 19855 | 1321 | Santa Fe Springs, City of 207 | City 2 | City Agency 2 | http://www.santafesprings.org/cityhall/community_serv/parks/default.asp | City 2 | 12.827 | Heritage Park | ||
5065 | 5065 | 5064 | {"type": "Polygon", "coordinates": [[[-122.02496, 38.24674], [-122.02492, 38.24958], [-122.02414, 38.2496], [-122.0235, 38.24955], [-122.02346, 38.24783], [-122.02373, 38.24775], [-122.02372, 38.2467], [-122.02496, 38.24674]]]} | Open Access 1 | Heritage Park | 19856 | 1344 | Suisun City, City of 770 | City 2 | City Agency 2 | http://www.suisun.com/departments/recreation-community-services/suisun-city-parks/ | City 2 | 9.413 | Heritage Park | 2000 | |
5066 | 5066 | 5065 | {"type": "MultiPolygon", "coordinates": [[[[-122.02756, 37.35569], [-122.02706, 37.35718], [-122.02573, 37.35689], [-122.02573, 37.35683], [-122.02593, 37.35668], [-122.02591, 37.3566], [-122.02541, 37.35623], [-122.02527, 37.3563], [-122.02507, 37.35626], [-122.02488, 37.35608], [-122.02463, 37.35617], [-122.02461, 37.35623], [-122.02459, 37.3566], [-122.02424, 37.35662], [-122.02413, 37.3567], [-122.02403, 37.35669], [-122.0246, 37.35502], [-122.02464, 37.355], [-122.02469, 37.355], [-122.0275, 37.3556], [-122.02755, 37.35563], [-122.02756, 37.35569]]], [[[-122.02762, 37.35884], [-122.0276, 37.35888], [-122.02754, 37.35892], [-122.02722, 37.35899], [-122.02692, 37.35907], [-122.02664, 37.35918], [-122.02638, 37.35931], [-122.02602, 37.35955], [-122.02581, 37.35973], [-122.02559, 37.35996], [-122.02551, 37.35997], [-122.02544, 37.35994], [-122.02431, 37.35901], [-122.02454, 37.35876], [-122.02474, 37.35877], [-122.02487, 37.35867], [-122.02505, 37.35883], [-122.02503, 37.35889], [-122.0251, 37.35895], [-122.02527, 37.35883], [-122.02521, 37.35875], [-122.02532, 37.35868], [-122.02527, 37.35861], [-122.02542, 37.35851], [-122.02551, 37.35857], [-122.0256, 37.35853], [-122.02567, 37.35855], [-122.02582, 37.3584], [-122.02573, 37.35831], [-122.02653, 37.35777], [-122.02687, 37.35806], [-122.02713, 37.35787], [-122.02745, 37.35832], [-122.02753, 37.35849], [-122.0276, 37.35874], [-122.02762, 37.35884]]]]} | Open Access 1 | Heritage Park | 19857 | 1345 | Sunnyvale, City of 413 | City 2 | City Agency 2 | http://sunnyvale.ca.gov/Departments/CommunityServices/Parks.aspx | City 2 | 18.827 | Heritage Park | ||
5067 | 5067 | 5066 | {"type": "Polygon", "coordinates": [[[-117.79607, 33.73433], [-117.79549, 33.73543], [-117.79537, 33.73547], [-117.79461, 33.73512], [-117.79448, 33.73499], [-117.79435, 33.73497], [-117.79427, 33.735], [-117.79401, 33.73485], [-117.79493, 33.7337], [-117.79524, 33.73394], [-117.79553, 33.73407], [-117.79601, 33.73423], [-117.79607, 33.73433]]]} | Open Access 1 | Heritage Park | 19858 | 1360 | Tustin, City of 274 | City 2 | City Agency 2 | http://www.tustinca.org/departments/parksrec/index.html | City 2 | 4.987 | Heritage Park | ||
5068 | 5068 | 5067 | {"type": "Polygon", "coordinates": [[[-117.8726, 34.05496], [-117.87256, 34.05763], [-117.87241, 34.05747], [-117.8721, 34.05723], [-117.87146, 34.05685], [-117.87082, 34.05667], [-117.87053, 34.0566], [-117.87027, 34.05658], [-117.87028, 34.05563], [-117.87025, 34.05561], [-117.87026, 34.05429], [-117.87106, 34.05432], [-117.87173, 34.05453], [-117.8726, 34.05496]]]} | Open Access 1 | Heritage Park | 19859 | 1374 | West Covina, City of 315 | City 2 | City Agency 2 | http://www.westcovina.org/departments/community-recreation-services/park-facility-rentals | City 2 | 14.33 | Heritage Park | ||
5071 | 5071 | 5070 | {"type": "Polygon", "coordinates": [[[-121.90826, 37.34403], [-121.90825, 37.34406], [-121.90731, 37.34471], [-121.90726, 37.34472], [-121.90722, 37.3447], [-121.90628, 37.34386], [-121.90732, 37.34314], [-121.90825, 37.34399], [-121.90826, 37.34403]]]} | Open Access 1 | Heritage Rose Garden | 19864 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 3.935 | Heritage Rose Garden | ||
5072 | 5072 | 5071 | {"type": "Polygon", "coordinates": [[[-118.21282, 34.08604], [-118.21279, 34.0861], [-118.21277, 34.0861], [-118.21265, 34.08637], [-118.21229, 34.0864], [-118.21188, 34.08647], [-118.21132, 34.08662], [-118.21073, 34.08685], [-118.21027, 34.08709], [-118.20971, 34.08746], [-118.20817, 34.08873], [-118.20788, 34.08904], [-118.20765, 34.08934], [-118.20734, 34.08932], [-118.20749, 34.0892], [-118.20785, 34.08875], [-118.20774, 34.08869], [-118.20778, 34.0886], [-118.20747, 34.08846], [-118.20787, 34.08805], [-118.20821, 34.08774], [-118.20832, 34.08767], [-118.20877, 34.08744], [-118.20891, 34.0874], [-118.20975, 34.08693], [-118.2099, 34.08687], [-118.21071, 34.08645], [-118.21071, 34.08643], [-118.21055, 34.0864], [-118.21158, 34.08576], [-118.21178, 34.08581], [-118.2118, 34.08576], [-118.21282, 34.08604]]]} | Open Access 1 | Heritage Square | 19865 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 8.473 | Heritage Square | ||
5074 | 5074 | 5073 | {"type": "Polygon", "coordinates": [[[-122.41355, 37.63561], [-122.41355, 37.63561], [-122.41334, 37.63565], [-122.41336, 37.63552], [-122.41342, 37.63547], [-122.41351, 37.63555], [-122.41355, 37.63561]]]} | Open Access 1 | Herman Tot Lot | 19867 | 1294 | San Bruno, City of 434 | City 2 | City Agency 2 | http://www.sanbruno.ca.gov/parks_main.html | City 2 | 0.055 | Herman Tot Lot | 1940 | |
5075 | 5075 | 5074 | {"type": "Polygon", "coordinates": [[[-118.40966, 33.87693], [-118.40916, 33.87712], [-118.40823, 33.87745], [-118.40805, 33.87708], [-118.40801, 33.87707], [-118.40813, 33.87703], [-118.40816, 33.8771], [-118.40822, 33.87711], [-118.40823, 33.8771], [-118.40822, 33.87708], [-118.40836, 33.87708], [-118.40837, 33.87706], [-118.40666, 33.87357], [-118.40626, 33.87284], [-118.40629, 33.87284], [-118.40629, 33.87282], [-118.40491, 33.87024], [-118.40366, 33.86737], [-118.40335, 33.86655], [-118.40197, 33.8626], [-118.40194, 33.86259], [-118.40145, 33.86122], [-118.40147, 33.8612], [-118.39993, 33.85693], [-118.39788, 33.85239], [-118.39919, 33.85195], [-118.39906, 33.85149], [-118.39933, 33.85141], [-118.3994, 33.85192], [-118.39969, 33.85292], [-118.40028, 33.85445], [-118.40058, 33.85514], [-118.4014, 33.85734], [-118.40174, 33.85811], [-118.4023, 33.85951], [-118.40309, 33.86178], [-118.40365, 33.86348], [-118.40422, 33.86503], [-118.40487, 33.86666], [-118.40569, 33.86859], [-118.40699, 33.87144], [-118.40772, 33.87286], [-118.40805, 33.87357], [-118.40912, 33.87571], [-118.40966, 33.87693]]]} | Open Access 1 | Hermosa City Beach | 19869 | 1134 | Hermosa Beach, City of 290 | City 2 | City Agency 2 | http://www.hermosabch.org/index.aspx?page=115 | City 2 | 91.817 | Hermosa City Beach | ||
5076 | 5076 | 5075 | {"type": "Polygon", "coordinates": [[[-117.5846, 34.13116], [-117.58458, 34.13119], [-117.58453, 34.13122], [-117.58266, 34.13123], [-117.58263, 34.12928], [-117.58458, 34.12927], [-117.5846, 34.13116]]]} | Open Access 1 | Hermosa Park | 19870 | 1263 | Rancho Cucamonga, City of 192 | City 2 | City Agency 2 | http://www.cityofrc.us/cityhall/cs/parks/default.asp | City 2 | 9.576 | Hermosa Park | ||
5077 | 5077 | 5076 | {"type": "MultiPolygon", "coordinates": [[[[-118.39448, 33.85549], [-118.39417, 33.85555], [-118.39408, 33.85529], [-118.39387, 33.85486], [-118.39328, 33.85395], [-118.39335, 33.85394], [-118.39338, 33.85394], [-118.39353, 33.85406], [-118.39367, 33.85413], [-118.39379, 33.85422], [-118.39392, 33.85436], [-118.39413, 33.85469], [-118.39434, 33.85508], [-118.39448, 33.85549]]], [[[-118.39374, 33.85407], [-118.39363, 33.85402], [-118.39346, 33.85391], [-118.3936, 33.85387], [-118.39374, 33.85407]]], [[[-118.39453, 33.85565], [-118.39456, 33.85576], [-118.39461, 33.85604], [-118.39464, 33.85632], [-118.39463, 33.85675], [-118.39457, 33.85718], [-118.39443, 33.85769], [-118.39418, 33.85847], [-118.39408, 33.85904], [-118.39407, 33.85951], [-118.39417, 33.8601], [-118.39386, 33.86016], [-118.3938, 33.85992], [-118.39375, 33.85956], [-118.39374, 33.85913], [-118.39376, 33.85892], [-118.39385, 33.85843], [-118.39415, 33.85749], [-118.39423, 33.85718], [-118.39429, 33.85684], [-118.39431, 33.8566], [-118.3943, 33.85627], [-118.39428, 33.85609], [-118.39417, 33.85589], [-118.39404, 33.85575], [-118.3942, 33.8557], [-118.39453, 33.85565]]], [[[-118.39536, 33.86445], [-118.39504, 33.86451], [-118.39389, 33.86032], [-118.39421, 33.86026], [-118.39536, 33.86445]]], [[[-118.40176, 33.87623], [-118.40145, 33.87635], [-118.40139, 33.87605], [-118.40129, 33.87574], [-118.40112, 33.8754], [-118.4009, 33.87508], [-118.40072, 33.87486], [-118.4003, 33.87447], [-118.39989, 33.87415], [-118.39942, 33.87374], [-118.39899, 33.87331], [-118.39879, 33.87309], [-118.39837, 33.87256], [-118.39797, 33.87194], [-118.39776, 33.87156], [-118.39764, 33.8713], [-118.39609, 33.86793], [-118.39589, 33.8674], [-118.39571, 33.86687], [-118.39512, 33.86478], [-118.3954, 33.86473], [-118.39594, 33.86669], [-118.39617, 33.86737], [-118.39642, 33.868], [-118.39798, 33.87137], [-118.39825, 33.87186], [-118.39856, 33.87234], [-118.39882, 33.87268], [-118.399, 33.87291], [-118.3995, 33.87344], [-118.39994, 33.87385], [-118.40047, 33.87427], [-118.40052, 33.87427], [-118.40074, 33.87446], [-118.401, 33.87472], [-118.40112, 33.87486], [-118.40138, 33.87522], [-118.40155, 33.87554], [-118.4017, 33.87597], [-118.40176, 33.87623]]], [[[-118.40194, 33.8771], [-118.4016, 33.87711], [-118.40149, 33.8765], [-118.40178, 33.87638], [-118.40194, 33.8771]]]]} | Open Access 1 | Hermosa Valley Greenbelt Park | 19872 | 1134 | Hermosa Beach, City of 290 | City 2 | City Agency 2 | http://www.hermosabch.org/index.aspx?page=115 | City 2 | 19.082 | Hermosa Valley Greenbelt Park | ||
5078 | 5078 | 5077 | {"type": "Polygon", "coordinates": [[[-118.0783, 33.88585], [-118.07617, 33.88585], [-118.07614, 33.8841], [-118.07735, 33.8841], [-118.07753, 33.88415], [-118.07799, 33.88438], [-118.07814, 33.88441], [-118.07826, 33.88442], [-118.0783, 33.88585]]]} | Open Access 1 | Hermosillo Park | 19873 | 1225 | Norwalk, City of 235 | City 2 | City Agency 2 | http://www.ci.norwalk.ca.us/city-hall/departments/recreation-park-services | City 2 | 9.048 | Hermosillo Park | ||
5079 | 5079 | 5078 | {"type": "Polygon", "coordinates": [[[-120.61241, 35.11026], [-120.61236, 35.11057], [-120.61232, 35.11061], [-120.61228, 35.11061], [-120.61184, 35.11056], [-120.61162, 35.11056], [-120.61162, 35.11015], [-120.61204, 35.11017], [-120.61239, 35.11023], [-120.61241, 35.11026]]]} | Open Access 1 | Hero Community Park | 19875 | 1452 | Grover Beach, City of 643 | City 2 | City Agency 2 | http://www.grover.org/index.aspx?nid=141 | City 2 | 0.77 | Hero Community 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]);