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 8,515
- County Agency 881
- Recreation/Parks District 874
- State Agency 631
- Non Profit - Land Trust 436
- Open Space District 204
- County Agency - Parks 182
- Federal Agency 181
- Water District 161
- Community Services District 160
- Home Owners Association 137
- Non Profit - Conservation 99
- Flood District 77
- Cemetery District 47
- Non Profit - Other 33
- Port/Harbor District 29
- County Agency - Other 28
- Irrigation District 16
- School District 13
- Commercial 10
- Sanitation District 9
- Special District - Other 9
- Joint Powers Authority 5
- Other 5
- Non Profit - Cemetery District 5
- Conservation District 5
- Mitigation Bank 4
- Transportation Agency 4
- Non Profit - Education 3
- Metropolitan Planning Organization 2
- …
MNG_AGENCY >30
- Los Angeles, City of 397
- San Diego, City of 384
- California Department of Fish and Wildlife 299
- San Jose, City of 198
- San Francisco, City and County of 188
- Sacramento, City of 183
- California Department of Parks and Recreation 163
- Mountains Recreation and Conservation Authority 158
- Los Angeles, County of 144
- Ventura, City of 143
- Long Beach, City of 128
- San Diego, County of 113
- Roseville, City of 112
- East Bay Regional Park District 107
- Oakland, City of 97
- Irvine, City of 89
- Fresno, City of 83
- Consumnes Community Services District 79
- Santa Barbara, County of 72
- Orange, County of 70
- Torrance, City of 70
- Stockton, City of 69
- Hayward Area Recreation and Park District 68
- Modesto, City of 68
- Huntington Beach, City of 66
- Tracy, City of 66
- Chula Vista, City of 64
- Santa Cruz, City of 63
- Poway, City of 61
- Santa Rosa, City of 60
- …
ACCESS_TYP 4
- Open Access 10,995
- Restricted Access 897
- No Public Access 639
- Unknown Access 237
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2871 | 2871 | 2870 | {"type": "Polygon", "coordinates": [[[-117.30179, 33.13802], [-117.30174, 33.13819], [-117.30151, 33.13825], [-117.30101, 33.13828], [-117.30039, 33.13846], [-117.30037, 33.13863], [-117.30055, 33.1388], [-117.29992, 33.13877], [-117.30001, 33.13674], [-117.29812, 33.13667], [-117.29824, 33.13312], [-117.29871, 33.13306], [-117.2992, 33.13303], [-117.2995, 33.13305], [-117.29988, 33.13309], [-117.30021, 33.13316], [-117.30049, 33.13324], [-117.30079, 33.13334], [-117.30047, 33.13362], [-117.30025, 33.13408], [-117.29992, 33.13447], [-117.29989, 33.13469], [-117.29968, 33.13496], [-117.29966, 33.13527], [-117.29974, 33.13534], [-117.29979, 33.13542], [-117.29986, 33.13543], [-117.30003, 33.13541], [-117.30019, 33.13536], [-117.3004, 33.13527], [-117.3005, 33.13529], [-117.30059, 33.13542], [-117.30099, 33.13627], [-117.30068, 33.13678], [-117.3007, 33.13713], [-117.30076, 33.13745], [-117.30079, 33.13778], [-117.30093, 33.13801], [-117.30114, 33.13811], [-117.30148, 33.13803], [-117.30171, 33.13794], [-117.30179, 33.13802]]]} | Open Access 1 | Macario Canyon Preserve | 32975 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | http://www.carlsbadca.gov/services/depts/parks/default.asp | City 2 | 24.859 | Macario Canyon Preserve | ||
2872 | 2872 | 2871 | {"type": "Polygon", "coordinates": [[[-124.20238, 41.75231], [-124.20192, 41.75256], [-124.20167, 41.7523], [-124.20213, 41.75206], [-124.20238, 41.75231]]]} | Open Access 1 | Crescent City Skate Park | 32976 | 1427 | Crescent City, City of 735 | City 2 | City Agency 2 | http://www.crescentcity.org/ | City 2 | 0.405 | Crescent City Skate Park | ||
2873 | 2873 | 2872 | {"type": "MultiPolygon", "coordinates": [[[[-118.21043, 34.19465], [-118.21042, 34.19681], [-118.20855, 34.19793], [-118.20784, 34.19795], [-118.2078, 34.19801], [-118.20775, 34.19797], [-118.20767, 34.19783], [-118.20761, 34.19779], [-118.20753, 34.19779], [-118.20749, 34.19782], [-118.20747, 34.19785], [-118.20723, 34.1978], [-118.20725, 34.1977], [-118.20723, 34.19761], [-118.20718, 34.19752], [-118.20706, 34.19742], [-118.20669, 34.19729], [-118.20637, 34.19712], [-118.2061, 34.19703], [-118.20588, 34.19699], [-118.20589, 34.1969], [-118.20545, 34.19661], [-118.20516, 34.19663], [-118.20464, 34.19646], [-118.20464, 34.19628], [-118.20363, 34.196], [-118.20377, 34.19575], [-118.20364, 34.19522], [-118.20347, 34.19494], [-118.20297, 34.19471], [-118.20386, 34.19431], [-118.20377, 34.19418], [-118.20374, 34.19409], [-118.20371, 34.19396], [-118.20362, 34.19381], [-118.20354, 34.19374], [-118.20344, 34.19368], [-118.20338, 34.19369], [-118.20335, 34.19374], [-118.20326, 34.19362], [-118.20327, 34.1936], [-118.20351, 34.19344], [-118.20355, 34.19346], [-118.20376, 34.19338], [-118.20418, 34.19339], [-118.20462, 34.1931], [-118.20447, 34.19293], [-118.20413, 34.19281], [-118.20425, 34.19256], [-118.20607, 34.19304], [-118.20638, 34.19295], [-118.20658, 34.19219], [-118.20647, 34.19208], [-118.2061, 34.19186], [-118.20588, 34.19136], [-118.20537, 34.19109], [-118.2057, 34.1908], [-118.20568, 34.19047], [-118.2045, 34.18997], [-118.20341, 34.18966], [-118.20295, 34.1892], [-118.20278, 34.18948], [-118.20221, 34.1896], [-118.20203, 34.18953], [-118.20192, 34.18948], [-118.20179, 34.18863], [-118.20153, 34.18845], [-118.20205, 34.1879], [-118.20216, 34.18786], [-118.20324, 34.18789], [-118.20375, 34.18757], [-118.20525, 34.1891], [-118.20713, 34.18763], [-118.20746, 34.18778], [-118.20771, 34.18779], [-118.20778, 34.18782], [-118.2079, 34.18795], [-118.20803, 34.18798], [-118.20778, 34.1893], [-118.20791, 34.19013], [-118.20802, 34.1906], [-118.21042, 34.19233], [-118.21043, 34.19465]]], [[[-118.21345, 34.19409], [-118.21264, 34.19505], [-118.2128, 34.19534], [-118.21098, 34.19647], [-118.21098, 34.19475], [-118.21193, 34.19493], [-118.21195, 34.19446], [-118.21098, 34.19443], [-118.21098, 34.19273], [-118.21102, 34.19276], [-118.21216, 34.1927], [-118.21345, 34.19409]]]]} | Open Access 1 | Cherry Canyon Park | 17166 | 1154 | La Canada Flintridge, City of 330 | City 2 | City Agency 2 | http://www.lcf.ca.gov/parks-rec | City 2 | 136.974 | Cherry Canyon Park | ||
2874 | 2874 | 2873 | {"type": "Polygon", "coordinates": [[[-118.16656, 33.85055], [-118.16483, 33.85055], [-118.16483, 33.84988], [-118.16655, 33.84988], [-118.16656, 33.85055]]]} | Open Access 1 | Cherry Cove Park | 17167 | 1168 | Lakewood, City of 255 | City 2 | City Agency 2 | http://www.lakewoodcity.org/ | City 2 | 2.961 | Cherry Cove Park | ||
2875 | 2875 | 2874 | {"type": "Polygon", "coordinates": [[[-121.30119, 38.67445], [-121.30091, 38.67484], [-121.30047, 38.67468], [-121.30035, 38.67441], [-121.29992, 38.67421], [-121.2994, 38.67448], [-121.2988, 38.67434], [-121.29862, 38.67432], [-121.29864, 38.67415], [-121.29816, 38.6737], [-121.29776, 38.67344], [-121.29772, 38.67344], [-121.29767, 38.67337], [-121.29756, 38.67331], [-121.29688, 38.67257], [-121.29667, 38.67246], [-121.29633, 38.67237], [-121.29631, 38.67233], [-121.2963, 38.67214], [-121.29687, 38.67227], [-121.29722, 38.67242], [-121.29767, 38.67288], [-121.29844, 38.67353], [-121.29879, 38.67377], [-121.2998, 38.67379], [-121.30011, 38.67385], [-121.30119, 38.67445]]]} | Open Access 1 | Cherry Creek Park | 17168 | 2199 | Sunrise Recreation and Park District 639 | Special District 4 | Recreation/Parks District 4 | http://sunriseparks.com/ | Special District 4 | 5.477 | Cherry Creek Park | ||
2876 | 2876 | 2875 | {"type": "Polygon", "coordinates": [[[-122.17236, 37.71567], [-122.17024, 37.7163], [-122.17, 37.71565], [-122.17052, 37.71554], [-122.1717, 37.71482], [-122.17232, 37.71541], [-122.17236, 37.71567]]]} | Open Access 1 | Cherry Grove Park | 17169 | 1306 | San Leandro, City of 179 | City 2 | City Agency 2 | http://www.sanleandro.org/depts/rec/parks/default.asp | City 2 | 4.114 | Cherry Grove Park | ||
2877 | 2877 | 2876 | {"type": "Polygon", "coordinates": [[[-119.26942, 36.30909], [-119.26793, 36.30907], [-119.26794, 36.30806], [-119.2683, 36.30801], [-119.26875, 36.30791], [-119.26896, 36.30787], [-119.26921, 36.30785], [-119.26938, 36.30786], [-119.26941, 36.3079], [-119.26942, 36.30909]]]} | Open Access 1 | Cherry Meadow Park | 17171 | 1368 | Visalia, City of 152 | City 2 | City Agency 2 | http://www.ci.visalia.ca.us/depts/parks_n_recreation/default.asp | City 2 | 4.155 | Cherry Meadow Park | ||
2878 | 2878 | 2877 | {"type": "Polygon", "coordinates": [[[-117.68222, 33.63233], [-117.68179, 33.63268], [-117.68138, 33.63282], [-117.68118, 33.63301], [-117.68117, 33.63328], [-117.6815, 33.63322], [-117.68152, 33.63326], [-117.68122, 33.63333], [-117.68122, 33.63341], [-117.68106, 33.63342], [-117.68088, 33.6332], [-117.68062, 33.63271], [-117.68045, 33.6325], [-117.68046, 33.63244], [-117.68071, 33.6321], [-117.68077, 33.63193], [-117.68077, 33.63168], [-117.68075, 33.63156], [-117.68068, 33.63139], [-117.68055, 33.63121], [-117.68018, 33.63089], [-117.68011, 33.63081], [-117.68004, 33.63061], [-117.68005, 33.63042], [-117.68062, 33.6309], [-117.68128, 33.63149], [-117.68133, 33.6315], [-117.68133, 33.63154], [-117.68136, 33.63158], [-117.68144, 33.63161], [-117.68145, 33.63169], [-117.6818, 33.63199], [-117.68194, 33.63201], [-117.68197, 33.63204], [-117.68204, 33.63208], [-117.68202, 33.63215], [-117.68222, 33.63233]]]} | Open Access 1 | Cherry Park | 17172 | 1167 | Lake Forest, City of 231 | City 2 | City Agency 2 | http://www.lakeforestca.gov/depts/cs/city_parks/default.asp | City 2 | 5.441 | Cherry Park | ||
2879 | 2879 | 2878 | {"type": "Polygon", "coordinates": [[[-122.65571, 38.24345], [-122.65543, 38.24366], [-122.65535, 38.24362], [-122.65517, 38.24361], [-122.65505, 38.24377], [-122.65505, 38.24386], [-122.65516, 38.24392], [-122.65466, 38.24428], [-122.65343, 38.24401], [-122.65391, 38.2427], [-122.6541, 38.24267], [-122.65493, 38.24288], [-122.65496, 38.24293], [-122.65532, 38.24313], [-122.65534, 38.24319], [-122.6557, 38.24327], [-122.65571, 38.24345]]]} | Open Access 1 | Cherry Valley Park | 17173 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 5.355 | Cherry Valley Park | ||
2880 | 2880 | 2879 | {"type": "Polygon", "coordinates": [[[-122.10726, 37.67622], [-122.10552, 37.67683], [-122.10512, 37.67609], [-122.10694, 37.67552], [-122.10726, 37.67622]]]} | Open Access 1 | Cherryland Park | 17174 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 3.634 | Cherryland Park | ||
2881 | 2881 | 2880 | {"type": "Polygon", "coordinates": [[[-122.17111, 37.72884], [-122.17104, 37.72922], [-122.17093, 37.7291], [-122.17107, 37.72899], [-122.17109, 37.7289], [-122.17023, 37.72815], [-122.16981, 37.72808], [-122.16974, 37.72827], [-122.16965, 37.72826], [-122.16952, 37.72826], [-122.16913, 37.7282], [-122.16888, 37.72809], [-122.16876, 37.728], [-122.16863, 37.72786], [-122.16855, 37.72769], [-122.16845, 37.7274], [-122.16827, 37.72711], [-122.16811, 37.72693], [-122.1679, 37.72677], [-122.16765, 37.72669], [-122.16744, 37.72668], [-122.16672, 37.72685], [-122.16664, 37.72686], [-122.1665, 37.72685], [-122.1664, 37.72683], [-122.16629, 37.72676], [-122.16623, 37.72671], [-122.16624, 37.72669], [-122.16616, 37.72657], [-122.16677, 37.7265], [-122.16698, 37.72645], [-122.16711, 37.72639], [-122.16755, 37.72638], [-122.16774, 37.72639], [-122.16826, 37.72681], [-122.16855, 37.72713], [-122.16894, 37.72763], [-122.16891, 37.72781], [-122.17018, 37.72802], [-122.17111, 37.72884]]]} | Restricted Access 2 | Cherrywood Park | 17175 | 1306 | San Leandro, City of 179 | City 2 | City Agency 2 | http://www.sanleandro.org/depts/rec/parks/default.asp | City 2 | 3.337 | Cherrywood Park | ||
2882 | 2882 | 2881 | {"type": "Polygon", "coordinates": [[[-117.29824, 33.13313], [-117.29812, 33.13667], [-117.29552, 33.13657], [-117.29529, 33.13554], [-117.29538, 33.1353], [-117.29548, 33.13507], [-117.29561, 33.13484], [-117.29582, 33.13456], [-117.296, 33.13436], [-117.29626, 33.13411], [-117.29655, 33.13389], [-117.29678, 33.13374], [-117.29768, 33.13329], [-117.29796, 33.13319], [-117.29824, 33.13313]]]} | Open Access 1 | Veterans Park Preserve | http://www.carlsbadca.gov/civicax/filebank/blobdload.aspx?BlobID=37992 | 32977 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | http://www.carlsbadca.gov/services/depts/parks/default.asp | City 2 | 19.572 | Veterans Park Preserve | |
2883 | 2883 | 2882 | {"type": "Polygon", "coordinates": [[[-124.20362, 41.75891], [-124.20165, 41.7589], [-124.20165, 41.75859], [-124.20151, 41.75858], [-124.20151, 41.75823], [-124.20234, 41.75823], [-124.20182, 41.75767], [-124.20212, 41.75756], [-124.20212, 41.75755], [-124.20205, 41.75746], [-124.2025, 41.7572], [-124.20347, 41.75822], [-124.2035, 41.75824], [-124.20362, 41.75824], [-124.20362, 41.75891]]]} | Open Access 1 | Pyke Field | 32981 | 347 | Del Norte County Parks, County of 661 | County 3 | County Agency - Parks 7 | http://www.dnco.org/ | County 3 | 5.197 | Pyke Field | ||
2884 | 2884 | 2883 | {"type": "Polygon", "coordinates": [[[-122.43454, 37.73883], [-122.43413, 37.73884], [-122.43411, 37.73877], [-122.43447, 37.73876], [-122.43454, 37.73883]]]} | Open Access 1 | Diamond & Farnum Open Space | 18138 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.069 | Diamond & Farnum OS | ||
2885 | 2885 | 2884 | {"type": "Polygon", "coordinates": [[[-121.72098, 37.12625], [-121.72074, 37.12705], [-121.71994, 37.12674], [-121.71867, 37.12586], [-121.71666, 37.12538], [-121.71328, 37.12336], [-121.71202, 37.12322], [-121.71031, 37.1239], [-121.70847, 37.12388], [-121.70782, 37.12443], [-121.70714, 37.12548], [-121.70569, 37.12583], [-121.70477, 37.12519], [-121.70452, 37.12419], [-121.70372, 37.12296], [-121.70352, 37.123], [-121.70303, 37.12251], [-121.70261, 37.12126], [-121.70278, 37.12087], [-121.70219, 37.12033], [-121.70201, 37.11947], [-121.70031, 37.11878], [-121.69953, 37.11889], [-121.6985, 37.11855], [-121.69645, 37.11872], [-121.69476, 37.11834], [-121.69386, 37.11816], [-121.69338, 37.11708], [-121.69242, 37.11639], [-121.69228, 37.11591], [-121.69232, 37.1159], [-121.69247, 37.1153], [-121.6915, 37.11446], [-121.69207, 37.11431], [-121.69281, 37.11473], [-121.69669, 37.1143], [-121.69704, 37.11364], [-121.69832, 37.11545], [-121.6989, 37.1157], [-121.69952, 37.1153], [-121.70012, 37.11588], [-121.70096, 37.11611], [-121.7014, 37.11606], [-121.70166, 37.11624], [-121.70314, 37.11652], [-121.70373, 37.11585], [-121.70377, 37.11676], [-121.70459, 37.11703], [-121.70403, 37.11737], [-121.70452, 37.11779], [-121.70579, 37.11958], [-121.70672, 37.11956], [-121.70837, 37.11872], [-121.70693, 37.12048], [-121.70635, 37.12078], [-121.70651, 37.12125], [-121.70735, 37.12169], [-121.70879, 37.12155], [-121.7095, 37.12176], [-121.70981, 37.12151], [-121.7103, 37.12152], [-121.71087, 37.12123], [-121.71192, 37.12133], [-121.71272, 37.12116], [-121.71281, 37.12098], [-121.71324, 37.12081], [-121.71398, 37.12043], [-121.71385, 37.12116], [-121.71444, 37.12122], [-121.7151, 37.1208], [-121.71502, 37.12103], [-121.71537, 37.12149], [-121.71565, 37.12161], [-121.71648, 37.12215], [-121.71703, 37.12212], [-121.71689, 37.12234], [-121.7173, 37.12305], [-121.71769, 37.12316], [-121.71681, 37.12434], [-121.71844, 37.12451], [-121.71898, 37.12449], [-121.71952, 37.12559], [-121.71994, 37.126], [-121.72057, 37.12625], [-121.72098, 37.12625]]]} | Restricted Access 2 | Chesbro | 17176 | 326 | Santa Clara County Parks and Recreation Dept., County of 465 | County 3 | County Agency - Parks 7 | http://www.sccgov.org/sites/parks/Pages/Welcome-to-Santa-Clara-County-Parks.aspx | County 3 | 232.334 | Chesbro | ||
2886 | 2886 | 2885 | {"type": "Polygon", "coordinates": [[[-118.31374, 33.99241], [-118.31374, 33.99312], [-118.31268, 33.99313], [-118.31269, 33.99242], [-118.31374, 33.99241]]]} | Open Access 1 | Chesterfield Square | 17180 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1.893 | Chesterfield Square | ||
2887 | 2887 | 2886 | {"type": "Polygon", "coordinates": [[[-120.09738, 36.21032], [-120.09447, 36.21033], [-120.09447, 36.20915], [-120.09451, 36.20874], [-120.0947, 36.20879], [-120.09602, 36.20817], [-120.09619, 36.20819], [-120.09738, 36.21032]]]} | Open Access 1 | Chestnut Park | 17182 | 2021 | Coalinga-Huron Recreation and Park District 270 | Special District 4 | Recreation/Parks District 4 | http://www.chrpd.org/ | Special District 4 | 10.905 | Chestnut Park | ||
2888 | 2888 | 2887 | {"type": "Polygon", "coordinates": [[[-121.55129, 39.10154], [-121.55129, 39.10208], [-121.55128, 39.10252], [-121.55114, 39.1024], [-121.55101, 39.10223], [-121.55098, 39.10215], [-121.55097, 39.10202], [-121.55102, 39.10186], [-121.5512, 39.1015], [-121.55129, 39.10154]]]} | Open Access 1 | Chestnut Park | 17183 | 2101 | Olivehurst Public Utility District 548 | Special District 4 | Water District 13 | http://www.opud.org/ | Special District 4 | 0.52 | Chestnut Park | ||
2889 | 2889 | 2888 | {"type": "Polygon", "coordinates": [[[-118.12098, 33.99203], [-118.12037, 33.99309], [-118.11973, 33.99285], [-118.11924, 33.99371], [-118.1184, 33.99342], [-118.11894, 33.9925], [-118.11905, 33.99248], [-118.11968, 33.99156], [-118.12098, 33.99203]]]} | Open Access 1 | Chet Holified Park | 17184 | 1211 | Montebello, City of 248 | City 2 | City Agency 2 | http://www.cityofmontebello.com/depts/parks/default.asp | City 2 | 6.557 | Chet Holified Park | ||
2890 | 2890 | 2889 | {"type": "Polygon", "coordinates": [[[-124.08886, 40.8933], [-124.08859, 40.8939], [-124.08786, 40.89378], [-124.08791, 40.89359], [-124.08798, 40.89359], [-124.08806, 40.89356], [-124.08811, 40.89352], [-124.08813, 40.89347], [-124.08813, 40.89341], [-124.0881, 40.89337], [-124.08804, 40.89333], [-124.08798, 40.89331], [-124.08813, 40.89282], [-124.08864, 40.89295], [-124.08853, 40.89321], [-124.08886, 40.8933]]]} | Open Access 1 | Chevret-Vaissade Park | 17186 | 1432 | Arcata, City of 577 | City 2 | City Agency 2 | http://www.cityofarcata.org/rec | City 2 | 1.48 | Chevret-Vaissade 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]);