superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
63 rows where MNG_AGENCY = 273 and MNG_AG_TYP = 7 sorted by PARK_URL
This data as json, copyable, CSV (advanced)
Suggested facets: PARK_URL
ACCESS_TYP 3
MNG_AG_TYP 1
- County Agency - Parks · 63 ✖
MNG_AGENCY 1
- Los Angeles - Department of Parks and Recreation, County of · 63 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
588 | 588 | 587 | {"type": "Polygon", "coordinates": [[[-118.12621, 34.18904], [-118.12602, 34.18935], [-118.12595, 34.18934], [-118.12593, 34.18924], [-118.12595, 34.18897], [-118.12609, 34.18896], [-118.1262, 34.18898], [-118.12621, 34.18904]]]} | Open Access 1 | Ganesha Park | 32689 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | http://parks.lacounty.gov/ | County 3 | 0.18 | Ganesha Park | ||
3495 | 3495 | 3494 | {"type": "MultiPolygon", "coordinates": [[[[-118.27617, 33.85812], [-118.27617, 33.85816], [-118.27614, 33.85821], [-118.27453, 33.85821], [-118.27423, 33.85869], [-118.26803, 33.85869], [-118.26804, 33.8569], [-118.26809, 33.8569], [-118.26813, 33.85686], [-118.27082, 33.85686], [-118.27114, 33.85688], [-118.27155, 33.85696], [-118.27208, 33.85714], [-118.27333, 33.85777], [-118.27384, 33.85794], [-118.27418, 33.85801], [-118.27419, 33.85806], [-118.27458, 33.85811], [-118.27465, 33.8581], [-118.27467, 33.85806], [-118.27609, 33.85806], [-118.27613, 33.85807], [-118.27617, 33.85812]]], [[[-118.27424, 33.85775], [-118.27413, 33.85773], [-118.27412, 33.85778], [-118.27364, 33.85764], [-118.27336, 33.85752], [-118.27235, 33.85701], [-118.27202, 33.85687], [-118.27155, 33.85673], [-118.27119, 33.85666], [-118.27087, 33.85665], [-118.27096, 33.85622], [-118.27131, 33.85627], [-118.2729, 33.855], [-118.2733, 33.85587], [-118.27323, 33.85599], [-118.27424, 33.85775]]]]} | Open Access 1 | Victoria Community Regional Park | 32502 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | http://parks.lacounty.gov/ | County 3 | 34.393 | Victoria Community RP | ||
6241 | 6241 | 6240 | {"type": "MultiPolygon", "coordinates": [[[[-117.82298, 34.00931], [-117.82284, 34.00936], [-117.82285, 34.00942], [-117.82262, 34.00997], [-117.82239, 34.0103], [-117.8221, 34.01066], [-117.82141, 34.01145], [-117.82045, 34.01247], [-117.81939, 34.01369], [-117.81895, 34.01423], [-117.81792, 34.01559], [-117.81716, 34.0165], [-117.81428, 34.01933], [-117.81308, 34.01782], [-117.81286, 34.0177], [-117.81479, 34.01516], [-117.81665, 34.01382], [-117.81651, 34.01257], [-117.81514, 34.01064], [-117.81561, 34.01027], [-117.81631, 34.00983], [-117.82166, 34.00683], [-117.82172, 34.00683], [-117.82176, 34.00685], [-117.82194, 34.0071], [-117.82233, 34.00774], [-117.82252, 34.00813], [-117.82274, 34.00866], [-117.82298, 34.00931]]], [[[-117.82998, 34.00371], [-117.82917, 34.00439], [-117.82774, 34.00547], [-117.82702, 34.00603], [-117.827, 34.00606], [-117.82701, 34.00608], [-117.82489, 34.00787], [-117.82467, 34.00809], [-117.82428, 34.00843], [-117.82419, 34.00849], [-117.82414, 34.00859], [-117.82372, 34.00894], [-117.82358, 34.00893], [-117.82338, 34.00909], [-117.82333, 34.00903], [-117.82323, 34.0089], [-117.82265, 34.00767], [-117.82228, 34.00704], [-117.82203, 34.00671], [-117.82201, 34.00664], [-117.82205, 34.00659], [-117.82244, 34.00638], [-117.82264, 34.00625], [-117.82287, 34.00606], [-117.82311, 34.00581], [-117.82333, 34.00548], [-117.82391, 34.0044], [-117.82417, 34.00405], [-117.82451, 34.00371], [-117.82484, 34.00346], [-117.825, 34.00336], [-117.82538, 34.00316], [-117.82579, 34.00299], [-117.8264, 34.00283], [-117.82673, 34.00279], [-117.82725, 34.00277], [-117.82757, 34.00278], [-117.82786, 34.00282], [-117.82993, 34.00368], [-117.82998, 34.00371]]]]} | Restricted Access 2 | Diamond Bar Golf Course | 32474 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | http://parks.lacounty.gov/ | County 3 | 172.32 | Diamond Bar GC | ||
12577 | 12577 | 12576 | {"type": "Polygon", "coordinates": [[[-118.25168, 33.92627], [-118.25166, 33.92628], [-118.25155, 33.92629], [-118.24941, 33.92628], [-118.24939, 33.92627], [-118.24939, 33.92597], [-118.24941, 33.92501], [-118.25156, 33.92501], [-118.25156, 33.92543], [-118.25146, 33.92545], [-118.25168, 33.92627]]]} | Open Access 1 | George Washington Carver Park | 32461 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | http://parks.lacounty.gov/ | County 3 | 6.974 | George Washington Carver Park | ||
12580 | 12580 | 12579 | {"type": "MultiPolygon", "coordinates": [[[[-118.25097, 33.92044], [-118.25063, 33.92044], [-118.24952, 33.91637], [-118.24986, 33.91637], [-118.25097, 33.92044]]], [[[-118.25181, 33.92354], [-118.25148, 33.92354], [-118.25064, 33.92046], [-118.25098, 33.92046], [-118.25181, 33.92354]]]]} | Open Access 1 | Compton Creek Walking Path | 32466 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | http://parks.lacounty.gov/ | County 3 | 6.12 | Compton Creek Walking Path | ||
12581 | 12581 | 12580 | {"type": "Polygon", "coordinates": [[[-118.41805, 34.31271], [-118.41661, 34.314], [-118.4166, 34.31402], [-118.41582, 34.3146], [-118.41577, 34.31471], [-118.41592, 34.31501], [-118.41611, 34.31503], [-118.41609, 34.31522], [-118.41573, 34.31521], [-118.41572, 34.31529], [-118.41544, 34.31527], [-118.41495, 34.31527], [-118.4138, 34.31568], [-118.41347, 34.31573], [-118.41316, 34.3157], [-118.411, 34.31509], [-118.41012, 34.31425], [-118.41031, 34.31237], [-118.41054, 34.31151], [-118.41012, 34.31103], [-118.41026, 34.31092], [-118.41148, 34.31205], [-118.41155, 34.31189], [-118.4113, 34.31165], [-118.41147, 34.3114], [-118.412, 34.31043], [-118.41191, 34.30973], [-118.41258, 34.3094], [-118.41299, 34.3091], [-118.41356, 34.30864], [-118.4136, 34.30864], [-118.41634, 34.31122], [-118.41805, 34.31271]]]} | Restricted Access 2 | El Cariso Golf Course | 32460 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | http://parks.lacounty.gov/ | County 3 | 85.222 | El Cariso GC | ||
12583 | 12583 | 12582 | {"type": "Polygon", "coordinates": [[[-118.41968, 34.3167], [-118.41529, 34.3206], [-118.40962, 34.31621], [-118.41066, 34.31545], [-118.41064, 34.31535], [-118.411, 34.31509], [-118.41316, 34.3157], [-118.41337, 34.31573], [-118.41355, 34.31572], [-118.4138, 34.31568], [-118.41495, 34.31527], [-118.41544, 34.31527], [-118.4157, 34.31529], [-118.41571, 34.31521], [-118.41608, 34.31522], [-118.4161, 34.31504], [-118.41592, 34.31502], [-118.41577, 34.31471], [-118.4158, 34.31462], [-118.4166, 34.31401], [-118.41968, 34.3167]]]} | Open Access 1 | El Cariso Community Regional Park | 32459 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | http://parks.lacounty.gov/ | County 3 | 79.979 | El Cariso Community RP | ||
12598 | 12598 | 12597 | {"type": "Polygon", "coordinates": [[[-118.06988, 33.99872], [-118.06952, 33.9999], [-118.06945, 33.9999], [-118.06895, 34.00172], [-118.06907, 33.99981], [-118.06853, 33.99908], [-118.06839, 33.99832], [-118.06841, 33.99817], [-118.06988, 33.99872]]]} | Open Access 1 | Amigo Park | 32468 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | http://parks.lacounty.gov/ | County 3 | 4.807 | Amigo Park | ||
12633 | 12633 | 12632 | {"type": "Polygon", "coordinates": [[[-118.2177, 34.20115], [-118.21768, 34.20295], [-118.2157, 34.20324], [-118.21548, 34.20354], [-118.21334, 34.20352], [-118.21332, 34.20457], [-118.21156, 34.20393], [-118.21147, 34.20383], [-118.21132, 34.20373], [-118.20854, 34.20257], [-118.20856, 34.19793], [-118.21281, 34.19534], [-118.2146, 34.19619], [-118.21534, 34.19727], [-118.21672, 34.19778], [-118.217, 34.20047], [-118.21721, 34.20098], [-118.2177, 34.20115]]]} | Open Access 1 | Descanso Gardens | 32473 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | http://parks.lacounty.gov/ | County 3 | 149.091 | Descanso Gardens | ||
12645 | 12645 | 12644 | {"type": "MultiPolygon", "coordinates": [[[[-118.26507, 33.9181], [-118.26506, 33.92099], [-118.26088, 33.92099], [-118.26086, 33.92364], [-118.25652, 33.92364], [-118.2565, 33.92361], [-118.25612, 33.92361], [-118.25612, 33.92103], [-118.25634, 33.92102], [-118.25636, 33.92093], [-118.25939, 33.92093], [-118.2594, 33.92099], [-118.25955, 33.92098], [-118.25957, 33.91649], [-118.26343, 33.91649], [-118.26343, 33.9181], [-118.26507, 33.9181]]], [[[-118.25943, 33.9168], [-118.25939, 33.91821], [-118.25787, 33.9182], [-118.25785, 33.91879], [-118.25783, 33.91879], [-118.25779, 33.91871], [-118.2577, 33.91867], [-118.25747, 33.9187], [-118.25637, 33.9187], [-118.25635, 33.91868], [-118.25636, 33.91772], [-118.25639, 33.91758], [-118.2566, 33.91695], [-118.25662, 33.91684], [-118.25663, 33.91652], [-118.25665, 33.9165], [-118.25937, 33.91649], [-118.25942, 33.91654], [-118.25943, 33.9168]]]]} | Open Access 1 | Earvin 'Magic' Johnson Recreation Area | 32475 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | http://parks.lacounty.gov/ | County 3 | 102.946 | Earvin 'Magic' Johnson Rec. Area | ||
13104 | 13104 | 13103 | {"type": "Polygon", "coordinates": [[[-118.33629, 34.11612], [-118.33546, 34.11612], [-118.33544, 34.11609], [-118.33234, 34.1161], [-118.33228, 34.11594], [-118.33232, 34.11551], [-118.33232, 34.11506], [-118.33189, 34.11472], [-118.33171, 34.11449], [-118.33202, 34.11411], [-118.33197, 34.11389], [-118.33217, 34.11348], [-118.33211, 34.11328], [-118.33207, 34.11327], [-118.33207, 34.11295], [-118.33225, 34.11309], [-118.33236, 34.11311], [-118.33244, 34.11309], [-118.33249, 34.11303], [-118.3325, 34.11294], [-118.33246, 34.11288], [-118.33256, 34.11293], [-118.33264, 34.1129], [-118.33265, 34.11288], [-118.33276, 34.11288], [-118.33277, 34.11291], [-118.3331, 34.11291], [-118.33312, 34.11289], [-118.3336, 34.11288], [-118.3337, 34.11284], [-118.33384, 34.1127], [-118.33385, 34.11246], [-118.3353, 34.11246], [-118.33544, 34.11286], [-118.3357, 34.11376], [-118.33573, 34.11419], [-118.33571, 34.11421], [-118.33572, 34.11434], [-118.3358, 34.115], [-118.33582, 34.11502], [-118.33587, 34.11502], [-118.33598, 34.11531], [-118.33606, 34.11543], [-118.33608, 34.11565], [-118.33617, 34.11575], [-118.3362, 34.11585], [-118.33619, 34.1159], [-118.33621, 34.11603], [-118.33628, 34.11609], [-118.33629, 34.11612]], [[-118.33391, 34.1135], [-118.33398, 34.11349], [-118.33403, 34.11346], [-118.33407, 34.11342], [-118.33409, 34.11337], [-118.33408, 34.11332], [-118.33404, 34.11327], [-118.33399, 34.11324], [-118.33393, 34.11322], [-118.33387, 34.11323], [-118.33381, 34.11326], [-118.33377, 34.1133], [-118.33376, 34.11335], [-118.33377, 34.11341], [-118.3338, 34.11345], [-118.33385, 34.11349], [-118.33391, 34.1135]], [[-118.33577, 34.11531], [-118.33576, 34.11529], [-118.33567, 34.1153], [-118.33567, 34.11538], [-118.33577, 34.11538], [-118.33577, 34.11531]]]} | Open Access 1 | John Anson Ford Amphitheatre and County Parkland | 32478 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | http://parks.lacounty.gov/ | County 3 | 31.371 | John Anson Ford Amphitheatre and County Parkland | ||
13400 | 13400 | 13399 | {"type": "Polygon", "coordinates": [[[-117.98939, 34.03587], [-117.98835, 34.03691], [-117.98681, 34.03585], [-117.98693, 34.0357], [-117.98631, 34.03527], [-117.98645, 34.03513], [-117.98709, 34.03556], [-117.98778, 34.03487], [-117.98818, 34.03514], [-117.9886, 34.03472], [-117.98924, 34.03517], [-117.98892, 34.03551], [-117.98916, 34.03568], [-117.98916, 34.03571], [-117.98939, 34.03587]]]} | Open Access 1 | Avocado Heights Park | 32469 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | http://parks.lacounty.gov/ | County 3 | 8.164 | Avocado Heights Park | ||
13401 | 13401 | 13400 | {"type": "MultiPolygon", "coordinates": [[[[-118.63104, 34.48996], [-118.62998, 34.48997], [-118.63, 34.49077], [-118.6298, 34.49064], [-118.62911, 34.4906], [-118.62852, 34.49022], [-118.62868, 34.49003], [-118.62891, 34.48982], [-118.62916, 34.48964], [-118.62959, 34.48941], [-118.62992, 34.48929], [-118.62996, 34.48928], [-118.62998, 34.48932], [-118.63014, 34.48925], [-118.63046, 34.48916], [-118.63071, 34.4891], [-118.63102, 34.48905], [-118.63104, 34.48996]]], [[[-118.63006, 34.48904], [-118.63005, 34.48905], [-118.62996, 34.48909], [-118.62996, 34.48904], [-118.63006, 34.48904]]]]} | Open Access 1 | Del Valle Park | 32472 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | http://parks.lacounty.gov/ | County 3 | 5.479 | Del Valle Park | ||
13406 | 13406 | 13405 | {"type": "Polygon", "coordinates": [[[-117.90325, 33.97998], [-117.90158, 33.98014], [-117.90166, 33.97993], [-117.90157, 33.97938], [-117.90144, 33.97842], [-117.90299, 33.97827], [-117.90325, 33.97998]]]} | Open Access 1 | Carolyn Rosas Park | 32479 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | http://parks.lacounty.gov/ | County 3 | 6.897 | Carolyn Rosas Park | ||
13410 | 13410 | 13409 | {"type": "Polygon", "coordinates": [[[-118.37652, 33.91718], [-118.37652, 33.91844], [-118.37531, 33.91844], [-118.37531, 33.9191], [-118.37445, 33.9191], [-118.37445, 33.91718], [-118.37652, 33.91718]]]} | Open Access 1 | Del Aire Park | 32481 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | http://parks.lacounty.gov/ | County 3 | 8.065 | Del Aire Park | ||
13411 | 13411 | 13410 | {"type": "MultiPolygon", "coordinates": [[[[-118.1575, 34.20252], [-118.15539, 34.20268], [-118.15534, 34.20222], [-118.15742, 34.20206], [-118.15745, 34.2021], [-118.1575, 34.20252]]], [[[-118.15899, 34.20112], [-118.15799, 34.20099], [-118.15803, 34.20185], [-118.15593, 34.20201], [-118.15628, 34.20126], [-118.15588, 34.20113], [-118.15642, 34.19994], [-118.15896, 34.20076], [-118.15899, 34.20112]]], [[[-118.15918, 34.20422], [-118.1569, 34.20411], [-118.15721, 34.20392], [-118.15738, 34.20378], [-118.15741, 34.20376], [-118.15741, 34.20374], [-118.15755, 34.20359], [-118.15768, 34.20337], [-118.15774, 34.20316], [-118.15776, 34.20299], [-118.15766, 34.20208], [-118.15768, 34.20204], [-118.15909, 34.20194], [-118.15918, 34.20422]]]]} | Open Access 1 | Loma Alta Park | 32482 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | http://parks.lacounty.gov/ | County 3 | 20.507 | Loma Alta Park | ||
13416 | 13416 | 13415 | {"type": "Polygon", "coordinates": [[[-118.25395, 33.98347], [-118.25395, 33.98424], [-118.25222, 33.98424], [-118.25221, 33.98296], [-118.25369, 33.98295], [-118.25369, 33.98333], [-118.25356, 33.98334], [-118.25356, 33.98346], [-118.25395, 33.98347]]]} | Open Access 1 | Mary M. Bethune Park | 32493 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | http://parks.lacounty.gov/ | County 3 | 5.276 | Mary M. Bethune Park | ||
13488 | 13488 | 13487 | {"type": "Polygon", "coordinates": [[[-118.00926, 33.90301], [-118.00874, 33.90302], [-118.00867, 33.90309], [-118.00867, 33.90371], [-118.00875, 33.90379], [-118.0083, 33.90379], [-118.00778, 33.90418], [-118.00777, 33.90427], [-118.00774, 33.9043], [-118.00774, 33.90434], [-118.00761, 33.90436], [-118.00762, 33.90638], [-118.0079, 33.90662], [-118.00921, 33.90662], [-118.00921, 33.90809], [-118.00916, 33.90821], [-118.00915, 33.90834], [-118.00925, 33.90878], [-118.00924, 33.90887], [-118.00916, 33.90905], [-118.00752, 33.90941], [-118.00747, 33.90953], [-118.00556, 33.90974], [-118.00537, 33.9098], [-118.00522, 33.90991], [-118.00477, 33.90994], [-118.00445, 33.90995], [-118.0044, 33.90993], [-118.00439, 33.90989], [-118.00436, 33.90621], [-118.00432, 33.9058], [-118.00438, 33.90577], [-118.00428, 33.9054], [-118.00395, 33.90458], [-118.00398, 33.90454], [-118.00371, 33.90401], [-118.00362, 33.90373], [-118.00355, 33.90331], [-118.00355, 33.90284], [-118.00361, 33.9028], [-118.00379, 33.90279], [-118.0038, 33.90274], [-118.00805, 33.90279], [-118.00811, 33.90272], [-118.00926, 33.90271], [-118.00926, 33.90301]]]} | Open Access 1 | La Mirada Community Regional Park | 32634 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | http://parks.lacounty.gov/ | County 3 | 75.339 | La Mirada Community RP | ||
13894 | 13894 | 13893 | {"type": "Polygon", "coordinates": [[[-118.19323, 33.89597], [-118.19317, 33.89601], [-118.19241, 33.89603], [-118.19236, 33.896], [-118.19235, 33.89575], [-118.19232, 33.8957], [-118.19227, 33.89498], [-118.19219, 33.89361], [-118.19264, 33.8936], [-118.19265, 33.89352], [-118.19306, 33.89352], [-118.19315, 33.89475], [-118.19323, 33.89597]]]} | Open Access 1 | East Rancho Dominguez Park | 32484 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | http://parks.lacounty.gov/ | County 3 | 5.518 | East Rancho Dominguez Park | ||
13895 | 13895 | 13894 | {"type": "Polygon", "coordinates": [[[-118.06276, 33.9794], [-118.06276, 33.97946], [-118.06244, 33.97978], [-118.0624, 33.97979], [-118.06229, 33.9799], [-118.06229, 33.97994], [-118.06156, 33.98068], [-118.06148, 33.98069], [-118.05955, 33.97935], [-118.06083, 33.97806], [-118.06276, 33.9794]]]} | Open Access 1 | Sorensen Park | 32486 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | http://parks.lacounty.gov/ | County 3 | 10.893 | Sorensen 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]);