superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
15,638 rows
This data as json, copyable, CSV (advanced)
MNG_AG_TYP >30
- City Agency 5,192
- Recreation/Parks District 593
- County Agency 569
- State Agency 549
- Non Profit - Land Trust 315
- Open Space District 164
- Federal Agency 150
- County Agency - Parks 141
- Water District 136
- Home Owners Association 109
- Non Profit - Conservation 81
- Community Services District 81
- Flood District 56
- Cemetery District 28
- Non Profit - Other 24
- County Agency - Other 20
- Port/Harbor District 20
- School District 13
- Irrigation District 12
- Commercial 10
- Sanitation District 5
- Special District - Other 5
- Other 5
- Joint Powers Authority 4
- Non Profit - Cemetery District 4
- Conservation District 4
- Transportation Agency 4
- Mitigation Bank 3
- Metropolitan Planning Organization 2
- Non Profit - Education 2
- …
MNG_AGENCY >30
- San Diego, City of 332
- Los Angeles, City of 287
- California Department of Fish and Wildlife 267
- California Department of Parks and Recreation 160
- Ventura, City of 127
- Mountains Recreation and Conservation Authority 122
- San Jose, City of 107
- Sacramento, City of 100
- Los Angeles, County of 98
- San Francisco, City and County of 96
- Long Beach, City of 96
- East Bay Regional Park District 93
- San Diego, County of 89
- Roseville, City of 82
- Orange, County of 57
- Fresno, City of 56
- Los Angeles - Department of Parks and Recreation, County of 56
- Poway, City of 55
- Santa Barbara, County of 53
- Torrance, City of 51
- Yuba County Water Agency 48
- Santa Cruz, City of 47
- Davis, City of 46
- United States Fish and Wildlife Service 42
- Irvine, City of 42
- Rocklin, City of 41
- Midpeninsula Regional Open Space District 41
- Oakland, City of 40
- Napa, City of 40
- Clovis, City of 39
- …
ACCESS_TYP 4
- Open Access 6,914
- Restricted Access 713
- No Public Access 496
- Unknown Access 181
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7335 | 7335 | 7334 | {"type": "Polygon", "coordinates": [[[-119.81988, 36.72408], [-119.81985, 36.72531], [-119.81777, 36.72532], [-119.8178, 36.7241], [-119.81988, 36.72408]]]} | Open Access 1 | Neilson Park | 22690 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 6.257 | Neilson Park | ||
7336 | 7336 | 7335 | {"type": "MultiPolygon", "coordinates": [[[[-121.21771, 38.43508], [-121.21767, 38.43514], [-121.21731, 38.43503], [-121.21701, 38.43503], [-121.21678, 38.43513], [-121.21658, 38.43516], [-121.21641, 38.43515], [-121.21609, 38.43504], [-121.21579, 38.43498], [-121.21541, 38.43495], [-121.21521, 38.43491], [-121.21521, 38.43479], [-121.2153, 38.43448], [-121.21529, 38.43433], [-121.2152, 38.43412], [-121.21522, 38.43403], [-121.2154, 38.43378], [-121.21556, 38.43335], [-121.21562, 38.43316], [-121.21558, 38.433], [-121.21538, 38.43274], [-121.21497, 38.43244], [-121.2147, 38.4323], [-121.21424, 38.43218], [-121.21361, 38.43208], [-121.21335, 38.43213], [-121.21298, 38.43228], [-121.21241, 38.43242], [-121.21216, 38.43255], [-121.21175, 38.43285], [-121.21165, 38.43299], [-121.21163, 38.4332], [-121.21162, 38.43355], [-121.21155, 38.43361], [-121.21145, 38.4336], [-121.21134, 38.43357], [-121.21111, 38.43335], [-121.21093, 38.43326], [-121.21068, 38.43323], [-121.21074, 38.43315], [-121.21279, 38.43099], [-121.2167, 38.43328], [-121.21655, 38.43334], [-121.21649, 38.43335], [-121.2163, 38.43349], [-121.21623, 38.43364], [-121.21624, 38.43385], [-121.21637, 38.43403], [-121.21673, 38.43437], [-121.21706, 38.43464], [-121.21766, 38.43499], [-121.21771, 38.43508]]], [[[-121.22965, 38.44085], [-121.22946, 38.44104], [-121.22924, 38.44124], [-121.22905, 38.44133], [-121.2284, 38.44141], [-121.22792, 38.44165], [-121.22743, 38.44203], [-121.22713, 38.44222], [-121.22653, 38.44252], [-121.22623, 38.44284], [-121.226, 38.443], [-121.22581, 38.44318], [-121.22536, 38.44373], [-121.22511, 38.44393], [-121.22441, 38.44463], [-121.22389, 38.44499], [-121.22347, 38.44513], [-121.22277, 38.44533], [-121.22211, 38.44582], [-121.22187, 38.44601], [-121.22168, 38.4462], [-121.22097, 38.44668], [-121.22032, 38.44693], [-121.21922, 38.44722], [-121.21851, 38.44722], [-121.21769, 38.44713], [-121.21696, 38.447], [-121.21555, 38.44658], [-121.21532, 38.44655], [-121.21716, 38.4446], [-121.21532, 38.4435], [-121.21807, 38.44059], [-121.21514, 38.43887], [-121.2152, 38.43879], [-121.21524, 38.43868], [-121.21537, 38.43863], [-121.2156, 38.43866], [-121.21601, 38.43877], [-121.21619, 38.4388], [-121.21635, 38.43874], [-121.21674, 38.43846], [-121.2169, 38.43837], [-121.21706, 38.43839], [-121.21718, 38.43847], [-121.21725, 38.43882], [-121.21726, 38.43969], [-121.2173, 38.43983], [-121.21741, 38.43991], [-121.2176, 38.43996], [-121.21794, 38.43998], [-121.21845, 38.44009], [-121.21868, 38.44008], [-121.21886, 38.43998], [-121.21899, 38.43996], [-121.21916, 38.44006], [-121.21933, 38.44013], [-121.21959, 38.44017], [-121.21986, 38.44018], [-121.21998, 38.44033], [-121.21998, 38.44046], [-121.21989, 38.44088], [-121.2199, 38.44104], [-121.21996, 38.44117], [-121.22011, 38.44136], [-121.22013, 38.44145], [-121.22008, 38.44158], [-121.22009, 38.44168], [-121.22019, 38.44185], [-121.22041, 38.44203], [-121.22087, 38.44236], [-121.22104, 38.44243], [-121.2212, 38.44241], [-121.22138, 38.44231], [-121.22142, 38.44216], [-121.22142, 38.442], [-121.2214, 38.44198], [-121.22138, 38.44206], [-121.22133, 38.44208], [-121.22124, 38.44202], [-121.22115, 38.44202], [-121.22114, 38.44194], [-121.22118, 38.44188], [-121.22124, 38.44183], [-121.2213, 38.44186], [-121.22137, 38.44193], [-121.22139, 38.44193], [-121.22125, 38.44166], [-121.22108, 38.44122], [-121.22086, 38.44092], [-121.22063, 38.44071], [-121.22042, 38.44048], [-121.22025, 38.44006], [-121.21964, 38.43942], [-121.21954, 38.43924], [-121.21951, 38.43898], [-121.21963, 38.43889], [-121.21975, 38.43889], [-121.21991, 38.43898], [-121.22013, 38.43921], [-121.22054, 38.43948], [-121.22075, 38.43968], [-121.22107, 38.44003], [-121.22131, 38.44023], [-121.2215, 38.44033], [-121.22166, 38.44034], [-121.22211, 38.44031], [-121.22236, 38.44034], [-121.22271, 38.44034], [-121.22306, 38.4403], [-121.22328, 38.44022], [-121.22356, 38.44006], [-121.2241, 38.43986], [-121.22413, 38.43978], [-121.22409, 38.4397], [-121.22399, 38.43964], [-121.22367, 38.43955], [-121.22339, 38.43955], [-121.22304, 38.43959], [-121.22272, 38.4396], [-121.22234, 38.43955], [-121.22181, 38.43943], [-121.22165, 38.43931], [-121.22141, 38.43903], [-121.22119, 38.43864], [-121.22098, 38.43849], [-121.22077, 38.43842], [-121.22022, 38.43828], [-121.22, 38.43813], [-121.21952, 38.43768], [-121.21906, 38.43738], [-121.21873, 38.43708], [-121.21861, 38.43684], [-121.21863, 38.43653], [-121.21878, 38.43618], [-121.21908, 38.43587], [-121.21941, 38.43558], [-121.21997, 38.4353], [-121.22004, 38.43525], [-121.22004, 38.43523], [-121.22007, 38.43523], [-121.22008, 38.43525], [-121.22965, 38.44085]]]]} | Restricted Access 2 | Nelson Family Ranch | 22696 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 208.905 | Nelson Family Ranch | ||
7337 | 7337 | 7336 | {"type": "Polygon", "coordinates": [[[-121.36136, 37.98621], [-121.36133, 37.98643], [-121.36097, 37.98725], [-121.36089, 37.98729], [-121.36082, 37.98737], [-121.36084, 37.98748], [-121.36095, 37.9875], [-121.36103, 37.9875], [-121.36116, 37.98745], [-121.36116, 37.98823], [-121.35912, 37.98821], [-121.35913, 37.98797], [-121.3591, 37.98777], [-121.35898, 37.98745], [-121.35879, 37.98715], [-121.35854, 37.98689], [-121.35808, 37.98654], [-121.35827, 37.98636], [-121.35862, 37.98624], [-121.36004, 37.98613], [-121.36036, 37.98613], [-121.36136, 37.98621]]]} | Open Access 1 | Nelson Park | 22697 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 11.881 | Nelson Park | ||
7338 | 7338 | 7337 | {"type": "Polygon", "coordinates": [[[-121.95309, 38.34744], [-121.95188, 38.34744], [-121.95186, 38.34764], [-121.95078, 38.34765], [-121.95044, 38.34751], [-121.95006, 38.3475], [-121.94945, 38.34772], [-121.94916, 38.34773], [-121.94891, 38.34763], [-121.94871, 38.3474], [-121.94869, 38.34696], [-121.94884, 38.34673], [-121.94905, 38.34666], [-121.94932, 38.34661], [-121.94961, 38.34638], [-121.94961, 38.34618], [-121.94918, 38.34605], [-121.94937, 38.34573], [-121.95005, 38.34565], [-121.95035, 38.34515], [-121.95043, 38.34516], [-121.95084, 38.34536], [-121.9512, 38.34559], [-121.9516, 38.34597], [-121.95186, 38.3462], [-121.95216, 38.3463], [-121.95269, 38.34638], [-121.953, 38.3464], [-121.95306, 38.34646], [-121.95309, 38.34669], [-121.95309, 38.34744]]]} | Open Access 1 | Nelson Park | 22698 | 1364 | Vacaville, City of 147 | City 2 | City Agency 2 | http://www.cityofvacaville.com/index.aspx?page=374 | City 2 | 16.695 | Nelson Park | ||
7339 | 7339 | 7338 | {"type": "Polygon", "coordinates": [[[-121.57867, 39.52781], [-121.5776, 39.52782], [-121.5776, 39.52519], [-121.57866, 39.5252], [-121.57867, 39.52781]]]} | Open Access 1 | Nelson Park | 22699 | 2222 | Feather River Recreation and Park District 305 | Special District 4 | Recreation/Parks District 4 | http://www.frrpd.com/ | Special District 4 | 6.582 | Nelson Park | ||
7340 | 7340 | 7339 | {"type": "Polygon", "coordinates": [[[-122.27644, 37.78387], [-122.27625, 37.78369], [-122.27553, 37.78258], [-122.27515, 37.78152], [-122.27638, 37.78152], [-122.27644, 37.78387]]]} | Open Access 1 | Neptune Park | 22700 | 1001 | Alameda, City of 176 | City 2 | City Agency 2 | http://alamedaca.gov/recreation | City 2 | 4.139 | Neptune Park | ||
7341 | 7341 | 7340 | {"type": "MultiPolygon", "coordinates": [[[[-121.56761, 38.79009], [-121.55865, 38.79021], [-121.55838, 38.7897], [-121.55831, 38.78945], [-121.55828, 38.78913], [-121.5583, 38.78872], [-121.55898, 38.78631], [-121.55907, 38.78572], [-121.559, 38.78306], [-121.5628, 38.78305], [-121.56283, 38.78417], [-121.56754, 38.78412], [-121.56761, 38.79009]]], [[[-121.5769, 38.7889], [-121.5769, 38.79001], [-121.5678, 38.79009], [-121.56773, 38.78412], [-121.57225, 38.78407], [-121.57227, 38.7866], [-121.57639, 38.78658], [-121.57654, 38.78666], [-121.57683, 38.78666], [-121.57683, 38.78685], [-121.5765, 38.78685], [-121.57631, 38.78675], [-121.57515, 38.78677], [-121.57513, 38.7889], [-121.57514, 38.78891], [-121.5769, 38.7889]]]]} | No Public Access 3 | Nestor | 22702 | 2092 | Natomas Basin Conservancy 623 | Special District 4 | Flood District 9 | http://www.natomasbasin.org/ | Special District 4 | 229.885 | Nestor | ||
7342 | 7342 | 7341 | {"type": "Polygon", "coordinates": [[[-121.2683, 38.7177], [-121.26769, 38.71781], [-121.26746, 38.71783], [-121.26736, 38.71789], [-121.26714, 38.71792], [-121.26714, 38.71772], [-121.26729, 38.71769], [-121.26752, 38.71753], [-121.2683, 38.71752], [-121.2683, 38.7177]]]} | Restricted Access 2 | Nevinshire | 22705 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 0.662 | Nevinshire | ||
7343 | 7343 | 7342 | {"type": "Polygon", "coordinates": [[[-121.45549, 37.74985], [-121.45549, 37.75012], [-121.45482, 37.75012], [-121.45482, 37.74986], [-121.45489, 37.7498], [-121.45542, 37.7498], [-121.45549, 37.74985]]]} | Open Access 1 | New Harmon Park | 22707 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 0.505 | New Harmon Park | ||
7344 | 7344 | 7343 | {"type": "Polygon", "coordinates": [[[-118.25416, 34.23366], [-118.25404, 34.23433], [-118.25313, 34.23376], [-118.25314, 34.23305], [-118.25416, 34.23366]]]} | Open Access 1 | New York Park | 22711 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 1.78 | New York Park | ||
7345 | 7345 | 7344 | {"type": "Polygon", "coordinates": [[[-117.73254, 33.59302], [-117.73253, 33.59307], [-117.73166, 33.59479], [-117.73144, 33.59562], [-117.73133, 33.59566], [-117.73088, 33.59553], [-117.73023, 33.59525], [-117.72966, 33.59488], [-117.72903, 33.59433], [-117.72888, 33.59414], [-117.72891, 33.59404], [-117.72909, 33.59393], [-117.72931, 33.59375], [-117.72981, 33.59331], [-117.73016, 33.59294], [-117.73055, 33.59246], [-117.73066, 33.59232], [-117.7308, 33.59208], [-117.73132, 33.59105], [-117.73173, 33.59121], [-117.73157, 33.59153], [-117.73144, 33.59197], [-117.73141, 33.59256], [-117.73145, 33.5926], [-117.73154, 33.59264], [-117.73178, 33.59269], [-117.73191, 33.59274], [-117.73212, 33.59284], [-117.73242, 33.59294], [-117.73253, 33.593], [-117.73254, 33.59302]]]} | Open Access 1 | Ridgecrest Park | 24352 | 1004 | Aliso Viejo, City of 743 | City 2 | City Agency 2 | http://www.cityofalisoviejo.com/CityHall/Departments/EconomicDevelopment/InteractiveMap.aspx?category=1 | City 2 | 19.318 | Ridgecrest Park | ||
7346 | 7346 | 7345 | {"type": "Polygon", "coordinates": [[[-122.04309, 37.54756], [-122.04204, 37.54884], [-122.043, 37.54927], [-122.04271, 37.54949], [-122.04272, 37.5495], [-122.04285, 37.54956], [-122.04234, 37.54989], [-122.04175, 37.55019], [-122.04123, 37.5504], [-122.04059, 37.5506], [-122.04075, 37.55038], [-122.03993, 37.54926], [-122.04072, 37.54829], [-122.04156, 37.5465], [-122.04277, 37.54732], [-122.04309, 37.54756]]]} | Open Access 1 | Newark Community Park | 22712 | 1221 | Newark, City of 372 | City 2 | City Agency 2 | http://www.ci.newark.ca.us/departments/recreation-and-community-services/parks/ | City 2 | 16.332 | Newark Community Park | 1973 | |
7347 | 7347 | 7346 | {"type": "Polygon", "coordinates": [[[-122.01182, 37.51583], [-122.01166, 37.51629], [-122.01053, 37.51879], [-122.01011, 37.51977], [-122.00949, 37.51959], [-122.0089, 37.51937], [-122.00863, 37.51996], [-122.00771, 37.51964], [-122.00981, 37.51481], [-122.01051, 37.51513], [-122.01045, 37.51521], [-122.01046, 37.51523], [-122.01182, 37.51583]]]} | Open Access 1 | Newark Sportsfield Park | 22713 | 1221 | Newark, City of 372 | City 2 | City Agency 2 | http://www.ci.newark.ca.us/departments/recreation-and-community-services/parks/ | City 2 | 25.975 | Newark Sportsfield Park | 1984 | |
7348 | 7348 | 7347 | {"type": "Polygon", "coordinates": [[[-117.29528, 34.18298], [-117.29413, 34.18249], [-117.29299, 34.18199], [-117.29314, 34.18175], [-117.29427, 34.18224], [-117.29478, 34.18238], [-117.29482, 34.1824], [-117.29528, 34.18298]]]} | Open Access 1 | Newberry Park | 22714 | 1293 | San Bernardino, City of 163 | City 2 | City Agency 2 | http://www.ci.san-bernardino.ca.us/cityhall/parks/default.asp | City 2 | 1.653 | Newberry Park | ||
7349 | 7349 | 7348 | {"type": "Polygon", "coordinates": [[[-124.13906, 40.59247], [-124.13676, 40.59354], [-124.13602, 40.5939], [-124.13375, 40.59256], [-124.13595, 40.59061], [-124.13772, 40.59169], [-124.13906, 40.59247]]]} | Open Access 1 | Newburg Park | 22715 | 1434 | Fortuna, City of 974 | City 2 | City Agency 2 | http://friendlyfortuna.com/index.aspx?nid=95 | City 2 | 20.167 | Newburg Park | ||
7350 | 7350 | 7349 | {"type": "Polygon", "coordinates": [[[-118.92828, 34.17927], [-118.92827, 34.17981], [-118.9281, 34.18001], [-118.92782, 34.18015], [-118.92755, 34.18041], [-118.92724, 34.18051], [-118.92703, 34.18066], [-118.92722, 34.18095], [-118.92737, 34.18092], [-118.92746, 34.18099], [-118.92741, 34.18111], [-118.92771, 34.18141], [-118.92733, 34.18174], [-118.92674, 34.18145], [-118.92554, 34.18141], [-118.9251, 34.18136], [-118.92529, 34.1803], [-118.92553, 34.1803], [-118.92596, 34.18017], [-118.92604, 34.17943], [-118.92614, 34.17943], [-118.9264, 34.17961], [-118.9263, 34.1797], [-118.92648, 34.18011], [-118.9265, 34.1803], [-118.92672, 34.18048], [-118.92732, 34.18029], [-118.92766, 34.17993], [-118.92792, 34.1794], [-118.92804, 34.17906], [-118.92828, 34.17927]]]} | Open Access 1 | Newbury Gateway Park | 22716 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.org/ | Special District 4 | 8.514 | Newbury Gateway Park | ||
7351 | 7351 | 7350 | {"type": "Polygon", "coordinates": [[[-121.12914, 38.87509], [-121.12851, 38.87524], [-121.12815, 38.87545], [-121.12789, 38.87511], [-121.12762, 38.87489], [-121.12767, 38.87476], [-121.12877, 38.87452], [-121.12914, 38.87509]]]} | Open Access 1 | Newcastle Ball Diamond | 22717 | 314 | Placer, County of 206 | County 3 | County Agency 3 | http://www.placer.ca.gov/departments/facility/parks | County 3 | 1.872 | Newcastle Ball Diamond | ||
7352 | 7352 | 7351 | {"type": "Polygon", "coordinates": [[[-118.03541, 34.14555], [-118.03539, 34.14633], [-118.03528, 34.14666], [-118.03358, 34.14558], [-118.03541, 34.14555]]]} | Open Access 1 | Newcastle Park | 22718 | 1009 | Arcadia, City of 299 | City 2 | City Agency 2 | http://www.ci.arcadia.ca.us/home/index.asp?page=1160 | City 2 | 2.661 | Newcastle Park | ||
7353 | 7353 | 7352 | {"type": "Polygon", "coordinates": [[[-121.14527, 37.47444], [-121.14472, 37.47469], [-121.14451, 37.47482], [-121.14451, 37.47484], [-121.14457, 37.47488], [-121.14435, 37.47509], [-121.14375, 37.47469], [-121.14375, 37.47462], [-121.14395, 37.47443], [-121.14407, 37.47433], [-121.14432, 37.47419], [-121.14487, 37.47396], [-121.14497, 37.47398], [-121.14527, 37.47444]]]} | Open Access 1 | Newcastle Park | 22719 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 2.055 | Newcastle Park | ||
7354 | 7354 | 7353 | {"type": "Polygon", "coordinates": [[[-117.95924, 33.74856], [-117.95924, 33.74929], [-117.95809, 33.74929], [-117.95808, 33.74857], [-117.95924, 33.74856]]]} | Open Access 1 | Newcastle Park | 22720 | 1378 | Westminster, City of 149 | City 2 | City Agency 2 | http://www.westminster-ca.gov/depts/cs/parks_n_facilities/default.asp | City 2 | 2.116 | Newcastle 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]);