superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
32 rows where MNG_AGENCY = 36 sorted by map
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9088 | 9088 | 9087 | {"type": "MultiPolygon", "coordinates": [[[[-121.8271, 36.58062], [-121.82287, 36.58502], [-121.81841, 36.58218], [-121.82009, 36.58191], [-121.82254, 36.5794], [-121.82253, 36.57938], [-121.81988, 36.57848], [-121.81974, 36.57825], [-121.82001, 36.57814], [-121.82023, 36.57809], [-121.82059, 36.57806], [-121.82087, 36.57809], [-121.82109, 36.57814], [-121.82169, 36.57835], [-121.82197, 36.5784], [-121.82225, 36.5784], [-121.82261, 36.57836], [-121.82277, 36.57835], [-121.82365, 36.5784], [-121.82406, 36.57838], [-121.82441, 36.57832], [-121.82476, 36.57821], [-121.82509, 36.57804], [-121.82647, 36.57976], [-121.8271, 36.58062]]], [[[-121.82489, 36.57785], [-121.82473, 36.57794], [-121.82453, 36.57802], [-121.82383, 36.57666], [-121.82432, 36.57715], [-121.82462, 36.5775], [-121.82469, 36.57768], [-121.82489, 36.57785]]]]} | Open Access 1 | Ryan Ranch Park | 24759 | 1212 | Monterey, City of 36 | City 2 | City Agency 2 | http://monterey.org/en-us/Departments/Monterey-Recreation/Parks-and-Beaches | City 2 | 75.681 | Ryan Ranch Park | ||
15090 | 15090 | 15089 | {"type": "MultiPolygon", "coordinates": [[[[-121.85322, 36.59869], [-121.8531, 36.59879], [-121.85312, 36.59882], [-121.85274, 36.59888], [-121.85271, 36.5989], [-121.85269, 36.59894], [-121.85273, 36.59905], [-121.8528, 36.59912], [-121.85303, 36.59901], [-121.85316, 36.59914], [-121.85305, 36.59915], [-121.85295, 36.59918], [-121.85295, 36.59928], [-121.85291, 36.59931], [-121.85286, 36.59933], [-121.85276, 36.59931], [-121.8527, 36.59921], [-121.85249, 36.59927], [-121.85247, 36.59932], [-121.85249, 36.5994], [-121.85234, 36.59934], [-121.85195, 36.5988], [-121.85199, 36.59878], [-121.85199, 36.59839], [-121.85213, 36.59853], [-121.85224, 36.59854], [-121.85234, 36.59866], [-121.85237, 36.59875], [-121.85247, 36.59883], [-121.85257, 36.59877], [-121.8532, 36.59867], [-121.85322, 36.59869]]], [[[-121.85704, 36.60304], [-121.85675, 36.60327], [-121.85588, 36.60271], [-121.85607, 36.60248], [-121.85614, 36.60233], [-121.85704, 36.60304]]], [[[-121.85813, 36.60391], [-121.85768, 36.60427], [-121.85757, 36.60411], [-121.85722, 36.60377], [-121.85694, 36.60343], [-121.85687, 36.60337], [-121.85716, 36.60314], [-121.85813, 36.60391]]]]} | Open Access 1 | Laguna Grande Regional Park | 20854 | 1212 | Monterey, City of 36 | City 2 | City Agency 2 | http://monterey.org/en-us/Departments/Monterey-Recreation/Parks-and-Beaches | City 2 | 3.767 | Laguna Grande RP | ||
9804 | 9804 | 9803 | {"type": "MultiPolygon", "coordinates": [[[[-121.86779, 36.60347], [-121.86767, 36.60351], [-121.86754, 36.60329], [-121.86767, 36.60324], [-121.86779, 36.60347]]], [[[-121.86999, 36.60466], [-121.86781, 36.60545], [-121.86756, 36.605], [-121.86974, 36.60421], [-121.86999, 36.60466]]], [[[-121.87023, 36.60511], [-121.86814, 36.60605], [-121.86787, 36.60555], [-121.87004, 36.60477], [-121.87023, 36.60511]]], [[[-121.87071, 36.60374], [-121.86996, 36.60401], [-121.86984, 36.6038], [-121.86971, 36.60383], [-121.86959, 36.60361], [-121.86971, 36.60356], [-121.86983, 36.60378], [-121.86996, 36.60374], [-121.87008, 36.60369], [-121.86996, 36.60347], [-121.87008, 36.60343], [-121.87021, 36.60365], [-121.87058, 36.60352], [-121.87071, 36.60374]]], [[[-121.87151, 36.60411], [-121.87014, 36.60461], [-121.86989, 36.60416], [-121.87126, 36.60366], [-121.87151, 36.60411]]], [[[-121.87171, 36.60447], [-121.87038, 36.60504], [-121.8702, 36.60471], [-121.87157, 36.60422], [-121.87171, 36.60447]]], [[[-121.87052, 36.60288], [-121.8704, 36.60292], [-121.87027, 36.6027], [-121.8704, 36.60265], [-121.87052, 36.60288]]], [[[-121.87096, 36.60365], [-121.87083, 36.6037], [-121.87071, 36.60347], [-121.87083, 36.60343], [-121.87096, 36.60365]]]]} | Open Access 1 | South Monterey Dunes Beach | 25665 | 1212 | Monterey, City of 36 | City 2 | City Agency 2 | http://monterey.org/en-us/Departments/Monterey-Recreation/Parks-and-Beaches | City 2 | 9.492 | South Monterey Dunes Beach | ||
7146 | 7146 | 7145 | {"type": "MultiPolygon", "coordinates": [[[[-121.88765, 36.60006], [-121.88751, 36.60019], [-121.88747, 36.60021], [-121.88747, 36.6007], [-121.87892, 36.60047], [-121.87884, 36.60016], [-121.88219, 36.60025], [-121.88222, 36.60002], [-121.8822, 36.59999], [-121.88235, 36.59999], [-121.88236, 36.60028], [-121.88388, 36.60032], [-121.88391, 36.60003], [-121.88765, 36.60006]]], [[[-121.88875, 36.60014], [-121.88869, 36.60035], [-121.88845, 36.60033], [-121.888, 36.60032], [-121.88797, 36.60018], [-121.88778, 36.60014], [-121.8878, 36.60006], [-121.88829, 36.60006], [-121.88875, 36.60014]]]]} | Open Access 1 | Monterey Bay Waterfront Park / Window on the Bay | 22418 | 1212 | Monterey, City of 36 | City 2 | City Agency 2 | http://monterey.org/en-us/Departments/Monterey-Recreation/Parks-and-Beaches | City 2 | 9.647 | Monterey Bay Waterfront Park / Window on the Bay | ||
3650 | 3650 | 3649 | {"type": "MultiPolygon", "coordinates": [[[[-121.89329, 36.59281], [-121.89328, 36.59282], [-121.89237, 36.59259], [-121.89257, 36.59233], [-121.89262, 36.59231], [-121.89266, 36.59231], [-121.89285, 36.59244], [-121.89327, 36.59271], [-121.89327, 36.59276], [-121.89329, 36.59281]]], [[[-121.90145, 36.58357], [-121.89963, 36.58668], [-121.89925, 36.58719], [-121.89888, 36.5876], [-121.89356, 36.59253], [-121.89347, 36.59253], [-121.89338, 36.59256], [-121.89298, 36.59232], [-121.8928, 36.59217], [-121.89265, 36.59197], [-121.89256, 36.59178], [-121.89252, 36.59155], [-121.89253, 36.59132], [-121.89257, 36.59117], [-121.89299, 36.59016], [-121.89308, 36.58998], [-121.89325, 36.58976], [-121.89372, 36.58997], [-121.89485, 36.58998], [-121.8955, 36.58927], [-121.89593, 36.58842], [-121.8971, 36.58754], [-121.89751, 36.58704], [-121.8985, 36.58658], [-121.89882, 36.5863], [-121.90108, 36.58319], [-121.90131, 36.58334], [-121.90145, 36.58357]]]]} | Open Access 1 | Don Dahvee Greenbelt | 18201 | 1212 | Monterey, City of 36 | City 2 | City Agency 2 | http://monterey.org/en-us/Departments/Monterey-Recreation/Parks-and-Beaches | City 2 | 35.709 | Don Dahvee Greenbelt | ||
5369 | 5369 | 5368 | {"type": "MultiPolygon", "coordinates": [[[[-121.897, 36.58544], [-121.89666, 36.58594], [-121.89617, 36.58567], [-121.89549, 36.58624], [-121.89258, 36.58592], [-121.89131, 36.58632], [-121.89112, 36.58746], [-121.89093, 36.58779], [-121.89094, 36.58805], [-121.89099, 36.58827], [-121.89023, 36.58847], [-121.88896, 36.59007], [-121.88856, 36.59085], [-121.88747, 36.59219], [-121.8873, 36.59308], [-121.88755, 36.59354], [-121.88785, 36.59374], [-121.88758, 36.59385], [-121.88743, 36.59395], [-121.88732, 36.59409], [-121.88725, 36.59427], [-121.88659, 36.59373], [-121.88637, 36.59296], [-121.88639, 36.59207], [-121.88721, 36.59086], [-121.89009, 36.58763], [-121.89006, 36.58736], [-121.88981, 36.58735], [-121.88975, 36.5865], [-121.88985, 36.58615], [-121.88994, 36.58569], [-121.89047, 36.58526], [-121.89077, 36.58481], [-121.89071, 36.58376], [-121.89099, 36.58382], [-121.89156, 36.58357], [-121.89154, 36.58374], [-121.89168, 36.58418], [-121.89194, 36.58463], [-121.89192, 36.58485], [-121.89325, 36.58537], [-121.89503, 36.58558], [-121.89604, 36.58498], [-121.897, 36.58544]]], [[[-121.88834, 36.59487], [-121.88763, 36.59472], [-121.88759, 36.5947], [-121.88748, 36.59442], [-121.88746, 36.59434], [-121.88748, 36.5942], [-121.88757, 36.59407], [-121.8877, 36.59399], [-121.88819, 36.59378], [-121.88832, 36.59399], [-121.88821, 36.59464], [-121.88834, 36.59487]]], [[[-121.89446, 36.58141], [-121.89429, 36.58159], [-121.89419, 36.58151], [-121.89404, 36.58146], [-121.89342, 36.58145], [-121.89328, 36.58144], [-121.89312, 36.58139], [-121.89295, 36.58129], [-121.89282, 36.58118], [-121.89245, 36.58062], [-121.89225, 36.58081], [-121.89178, 36.58144], [-121.8915, 36.58212], [-121.89147, 36.58264], [-121.89152, 36.58282], [-121.89105, 36.58277], [-121.89092, 36.58283], [-121.89093, 36.58262], [-121.89101, 36.58193], [-121.89196, 36.58067], [-121.8923, 36.58034], [-121.8925, 36.58029], [-121.89294, 36.58103], [-121.89305, 36.58115], [-121.89318, 36.58122], [-121.89329, 36.58127], [-121.89344, 36.58129], [-121.89412, 36.5813], [-121.89431, 36.58135], [-121.89446, 36.58141]]]]} | Open Access 1 | Iris Canyon Greenbelt | 20232 | 1212 | Monterey, City of 36 | City 2 | City Agency 2 | http://monterey.org/en-us/Departments/Monterey-Recreation/Parks-and-Beaches | City 2 | 44.737 | Iris Canyon Greenbelt | ||
11178 | 11178 | 11177 | {"type": "MultiPolygon", "coordinates": [[[[-121.89934, 36.58954], [-121.89907, 36.58978], [-121.8988, 36.59009], [-121.8983, 36.58996], [-121.89825, 36.58981], [-121.89898, 36.58939], [-121.89929, 36.58932], [-121.89934, 36.58954]]], [[[-121.90007, 36.58941], [-121.90008, 36.58947], [-121.90007, 36.58958], [-121.90002, 36.58967], [-121.89991, 36.58979], [-121.89972, 36.5899], [-121.8996, 36.59], [-121.89922, 36.59052], [-121.89907, 36.59044], [-121.89911, 36.59037], [-121.89885, 36.59024], [-121.89915, 36.58987], [-121.89947, 36.5896], [-121.89971, 36.58945], [-121.89988, 36.5894], [-121.90001, 36.58937], [-121.90007, 36.58941]]]]} | Open Access 1 | Whispering Pines Park | 27458 | 1212 | Monterey, City of 36 | City 2 | City Agency 2 | http://monterey.org/en-us/Departments/Monterey-Recreation/Parks-and-Beaches | City 2 | 2.382 | Whispering Pines Park | ||
8447 | 8447 | 8446 | {"type": "MultiPolygon", "coordinates": [[[[-121.90724, 36.59296], [-121.90722, 36.59322], [-121.90683, 36.59314], [-121.90652, 36.59319], [-121.90655, 36.5931], [-121.90709, 36.59296], [-121.90724, 36.59296]]], [[[-121.91227, 36.59402], [-121.91094, 36.59514], [-121.90985, 36.59461], [-121.90964, 36.5941], [-121.90818, 36.59341], [-121.90742, 36.59326], [-121.90745, 36.59297], [-121.90793, 36.593], [-121.90797, 36.59274], [-121.9079, 36.59272], [-121.90792, 36.59257], [-121.9073, 36.59174], [-121.9085, 36.59131], [-121.90941, 36.59202], [-121.9089, 36.59259], [-121.90887, 36.59304], [-121.91103, 36.59316], [-121.91108, 36.59318], [-121.91227, 36.59402]]]]} | Open Access 1 | Quarry Park | 24057 | 1212 | Monterey, City of 36 | City 2 | City Agency 2 | http://monterey.org/en-us/Departments/Monterey-Recreation/Parks-and-Beaches | City 2 | 17.336 | Quarry Park | ||
7150 | 7150 | 7149 | {"type": "Polygon", "coordinates": [[[-121.80773, 36.57658], [-121.80773, 36.58183], [-121.80617, 36.58125], [-121.80561, 36.58087], [-121.80526, 36.58066], [-121.80482, 36.58044], [-121.80434, 36.58027], [-121.8037, 36.58007], [-121.80214, 36.57966], [-121.80143, 36.57949], [-121.80018, 36.57926], [-121.79791, 36.5789], [-121.79696, 36.57877], [-121.79602, 36.57867], [-121.79506, 36.57859], [-121.7945, 36.57856], [-121.7935, 36.57873], [-121.79326, 36.57873], [-121.79638, 36.57817], [-121.79781, 36.57789], [-121.80394, 36.5768], [-121.80635, 36.57633], [-121.80665, 36.57631], [-121.80695, 36.57632], [-121.80735, 36.57641], [-121.8076, 36.57651], [-121.80773, 36.57658]]]} | Open Access 1 | Monterey holding 2 | 22422 | 1212 | Monterey, City of 36 | City 2 | City Agency 2 | http://monterey.org/en-us/Departments/Monterey-Recreation/Parks-and-Beaches | City 2 | 77.51 | Monterey holding 2 | ||
7149 | 7149 | 7148 | {"type": "Polygon", "coordinates": [[[-121.82197, 36.58445], [-121.82053, 36.586], [-121.81948, 36.58511], [-121.81901, 36.58475], [-121.81625, 36.58287], [-121.81739, 36.58153], [-121.82197, 36.58445]]]} | Open Access 1 | Monterey holding 1 | 22421 | 1212 | Monterey, City of 36 | City 2 | City Agency 2 | http://monterey.org/en-us/Departments/Monterey-Recreation/Parks-and-Beaches | City 2 | 24.523 | Monterey holding 1 | ||
2673 | 2673 | 2672 | {"type": "Polygon", "coordinates": [[[-121.85224, 36.59449], [-121.85177, 36.59488], [-121.85075, 36.59406], [-121.85181, 36.59419], [-121.85195, 36.59425], [-121.85224, 36.59449]]]} | Open Access 1 | Casanova Oak Knoll Park | 16933 | 1212 | Monterey, City of 36 | City 2 | City Agency 2 | http://monterey.org/en-us/Departments/Monterey-Recreation/Parks-and-Beaches | City 2 | 1.295 | Casanova Oak Knoll Park | ||
3340 | 3340 | 3339 | {"type": "Polygon", "coordinates": [[[-121.85534, 36.57982], [-121.85525, 36.57992], [-121.85519, 36.57986], [-121.85475, 36.58], [-121.85446, 36.57938], [-121.85488, 36.57925], [-121.85494, 36.57919], [-121.85503, 36.57922], [-121.85515, 36.57922], [-121.85534, 36.57982]]]} | Open Access 1 | Fishermans Flats Park | 18924 | 1212 | Monterey, City of 36 | City 2 | City Agency 2 | http://monterey.org/en-us/Departments/Monterey-Recreation/Parks-and-Beaches | City 2 | 1.108 | Fishermans Flats Park | ||
7159 | 7159 | 7158 | {"type": "Polygon", "coordinates": [[[-121.86014, 36.60946], [-121.85999, 36.60944], [-121.85981, 36.60945], [-121.85967, 36.60949], [-121.85951, 36.60957], [-121.85989, 36.6092], [-121.86014, 36.60946]]]} | Open Access 1 | Monterey State Beach | http://www.parks.ca.gov/?page_id=576 | 22432 | 1212 | Monterey, City of 36 | City 2 | City Agency 2 | http://monterey.org/en-us/Departments/Monterey-Recreation/Parks-and-Beaches | City 2 | 0.171 | Monterey SB | 1960 |
5997 | 5997 | 5996 | {"type": "Polygon", "coordinates": [[[-121.86176, 36.5992], [-121.86104, 36.59978], [-121.86034, 36.59922], [-121.86066, 36.59896], [-121.86102, 36.59923], [-121.86141, 36.59892], [-121.86176, 36.5992]]]} | Open Access 1 | Montecito Park | 22410 | 1212 | Monterey, City of 36 | City 2 | City Agency 2 | http://monterey.org/en-us/Departments/Monterey-Recreation/Parks-and-Beaches | City 2 | 1.452 | Montecito Park | ||
3505 | 3505 | 3504 | {"type": "Polygon", "coordinates": [[[-121.86248, 36.57835], [-121.86239, 36.57909], [-121.8616, 36.57872], [-121.86205, 36.57832], [-121.86248, 36.57835]]]} | Open Access 1 | Deer Flats Park | 17996 | 1212 | Monterey, City of 36 | City 2 | City Agency 2 | http://monterey.org/en-us/Departments/Monterey-Recreation/Parks-and-Beaches | City 2 | 1.0 | Deer Flats Park | ||
8060 | 8060 | 8059 | {"type": "Polygon", "coordinates": [[[-121.86747, 36.59748], [-121.867, 36.59835], [-121.86617, 36.59777], [-121.86625, 36.59767], [-121.86747, 36.59748]]]} | Open Access 1 | Peter Ferrante Park | 23626 | 1212 | Monterey, City of 36 | City 2 | City Agency 2 | http://monterey.org/en-us/Departments/Monterey-Recreation/Parks-and-Beaches | City 2 | 1.352 | Peter Ferrante Park | ||
2735 | 2735 | 2734 | {"type": "Polygon", "coordinates": [[[-121.88549, 36.5946], [-121.88475, 36.59709], [-121.88351, 36.597], [-121.8834, 36.59675], [-121.88338, 36.59643], [-121.88343, 36.59604], [-121.88338, 36.59542], [-121.88332, 36.59527], [-121.88304, 36.59496], [-121.88291, 36.59479], [-121.88284, 36.59457], [-121.88276, 36.59438], [-121.88338, 36.59412], [-121.88549, 36.5946]]]} | Open Access 1 | Cementerio El Encinal | 17006 | 1212 | Monterey, City of 36 | City 2 | City Agency 2 | http://monterey.org/en-us/Departments/Monterey-Recreation/Parks-and-Beaches | City 2 | 12.672 | Cementerio El Encinal | ||
3900 | 3900 | 3899 | {"type": "Polygon", "coordinates": [[[-121.88751, 36.59549], [-121.8875, 36.59504], [-121.88814, 36.59515], [-121.88888, 36.59523], [-121.889, 36.59529], [-121.88904, 36.59535], [-121.88906, 36.59542], [-121.88886, 36.59649], [-121.88878, 36.59676], [-121.8887, 36.59691], [-121.88858, 36.59707], [-121.88841, 36.59724], [-121.88802, 36.59752], [-121.88781, 36.59774], [-121.88764, 36.598], [-121.88751, 36.59832], [-121.88722, 36.59963], [-121.88718, 36.59971], [-121.88708, 36.59978], [-121.88695, 36.59981], [-121.88365, 36.59977], [-121.8836, 36.59975], [-121.88352, 36.59944], [-121.88341, 36.59876], [-121.88336, 36.59858], [-121.88325, 36.59833], [-121.88301, 36.59802], [-121.88293, 36.59786], [-121.88273, 36.5971], [-121.88272, 36.59696], [-121.88273, 36.59684], [-121.88285, 36.59632], [-121.88284, 36.59602], [-121.88277, 36.59574], [-121.88248, 36.59502], [-121.88241, 36.59478], [-121.88247, 36.59437], [-121.88255, 36.59418], [-121.88259, 36.59412], [-121.88273, 36.59403], [-121.88289, 36.59401], [-121.88338, 36.59412], [-121.88277, 36.59439], [-121.88284, 36.59456], [-121.88291, 36.59479], [-121.88304, 36.59496], [-121.88332, 36.59527], [-121.88338, 36.59542], [-121.88343, 36.59604], [-121.88338, 36.59643], [-121.8834, 36.59675], [-121.88352, 36.597], [-121.88473, 36.59709], [-121.8848, 36.59689], [-121.88533, 36.59698], [-121.88541, 36.59674], [-121.88717, 36.59705], [-121.88771, 36.59573], [-121.88751, 36.59549]]]} | Open Access 1 | El Estero Park | 18510 | 1212 | Monterey, City of 36 | City 2 | City Agency 2 | http://monterey.org/en-us/Departments/Monterey-Recreation/Parks-and-Beaches | City 2 | 41.718 | El Estero Park | ||
5449 | 5449 | 5448 | {"type": "Polygon", "coordinates": [[[-121.89178, 36.59798], [-121.89141, 36.59939], [-121.89035, 36.59922], [-121.89056, 36.59809], [-121.89178, 36.59798]]]} | Open Access 1 | Jacks Ball Park | 20318 | 1212 | Monterey, City of 36 | City 2 | City Agency 2 | http://monterey.org/en-us/Departments/Monterey-Recreation/Parks-and-Beaches | City 2 | 3.576 | Jacks Ball Park | ||
6441 | 6441 | 6440 | {"type": "Polygon", "coordinates": [[[-121.89403, 36.60846], [-121.89279, 36.60845], [-121.89238, 36.60732], [-121.89352, 36.60702], [-121.89403, 36.60846]]]} | Open Access 1 | Lower Presidio Historic Park | 21563 | 1212 | Monterey, City of 36 | City 2 | City Agency 2 | http://monterey.org/en-us/Departments/Monterey-Recreation/Parks-and-Beaches | City 2 | 3.927 | Lower Presidio Historic 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]);