superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,118 rows where ACCESS_TYP = 2
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- California Department of Fish and Wildlife 66
- University of California 39
- Woodbridge Village Association 31
- United States Fish and Wildlife Service 25
- Home Owners Association - Unknown Name 23
- Sacramento, County of 21
- Whittier, City of 20
- Los Angeles, City of 19
- East Bay Regional Park District 18
- Rancho Santa Margarita Landscape and Recreation Corporation 17
- Sempervirens Fund 16
- San Ramon, City of 15
- Los Angeles Unified School District 15
- Land Trust of Napa County 14
- Big Sur Land Trust 14
- Los Angeles, County of 13
- The Nature Conservancy 13
- California Department of Parks and Recreation 11
- San Diego, City of 10
- Long Beach, City of 9
- San Francisco - Public Utilities Commission, City and County of 8
- Sonoma Land Trust 8
- Sonoma County Agricultural Preservation and Open Space District 8
- Manhattan Beach, City of 8
- Hayward Area Recreation and Park District 7
- Amerige Heights Community Association 7
- Los Angeles - Department of Parks and Recreation, County of 7
- San Jose, City of 6
- Carlsbad, City of 6
- United States Army Corps of Engineers 6
- …
MNG_AG_TYP 25
- City Agency 351
- Home Owners Association 190
- Non Profit - Land Trust 129
- State Agency 125
- Recreation/Parks District 62
- County Agency 56
- Federal Agency 52
- School District 36
- Non Profit - Conservation 17
- Water District 13
- County Agency - Parks 11
- County Agency - Other 10
- Commercial 9
- Open Space District 7
- Non Profit - Other 6
- Joint Powers Authority 5
- Flood District 3
- Community Services District 3
- Other 3
- Conservation District 3
- Irrigation District 2
- Sanitation District 2
- Metropolitan Planning Organization 1
- Home Owners Associatin 1
- Non Profit - Education 1
ACCESS_TYP 1
- Restricted Access · 1,098 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
168 | 168 | 167 | {"type": "Polygon", "coordinates": [[[-117.99846, 33.91409], [-117.99722, 33.91503], [-117.99693, 33.91519], [-117.99664, 33.9153], [-117.99651, 33.91534], [-117.99616, 33.91537], [-117.99445, 33.91539], [-117.99442, 33.91319], [-117.99449, 33.91314], [-117.9955, 33.91313], [-117.99551, 33.91327], [-117.99564, 33.91327], [-117.99564, 33.91353], [-117.99557, 33.91355], [-117.99556, 33.9138], [-117.99565, 33.91381], [-117.99567, 33.91413], [-117.99623, 33.91412], [-117.99624, 33.91418], [-117.99629, 33.91419], [-117.99636, 33.91434], [-117.99675, 33.91415], [-117.99666, 33.91396], [-117.99716, 33.91371], [-117.99728, 33.91385], [-117.99741, 33.91379], [-117.99741, 33.91373], [-117.99757, 33.91367], [-117.99742, 33.91337], [-117.99773, 33.91325], [-117.9983, 33.91344], [-117.99833, 33.91366], [-117.99846, 33.91409]]]} | Restricted Access 2 | Benton Middle School Park | 31848 | 2417 | Norwalk La Mirada Unified School District 892 | Special District 4 | School District 21 | https://www.nlmusd.org/ | Special District 4 | 15.071 | Benton Middle School Park | ||
169 | 169 | 168 | {"type": "MultiPolygon", "coordinates": [[[[-118.41144, 34.06052], [-118.41139, 34.0606], [-118.41084, 34.06086], [-118.41086, 34.06092], [-118.41072, 34.06099], [-118.41068, 34.06094], [-118.40952, 34.06146], [-118.40927, 34.06126], [-118.40916, 34.06114], [-118.40908, 34.061], [-118.40903, 34.06085], [-118.40902, 34.0607], [-118.40902, 34.06015], [-118.40961, 34.05987], [-118.40985, 34.05982], [-118.40998, 34.05983], [-118.41003, 34.05986], [-118.4101, 34.05989], [-118.41017, 34.05998], [-118.41025, 34.05995], [-118.4103, 34.06002], [-118.41097, 34.05971], [-118.4114, 34.06031], [-118.41144, 34.06044], [-118.41144, 34.06052]]], [[[-118.41243, 34.06254], [-118.41206, 34.06271], [-118.41213, 34.06284], [-118.41212, 34.06285], [-118.41172, 34.06272], [-118.41123, 34.06236], [-118.411, 34.06223], [-118.41066, 34.0618], [-118.41142, 34.06141], [-118.41159, 34.06162], [-118.41191, 34.06147], [-118.41231, 34.06203], [-118.41218, 34.06212], [-118.41226, 34.06224], [-118.41224, 34.06227], [-118.41243, 34.06254]]]]} | Restricted Access 2 | Beverly Hills High School Park | 31849 | 1029 | Beverly Hills, City of 200 | City 2 | City Agency 2 | http://www.beverlyhills.org/living/recreationparks/ | City 2 | 10.454 | Beverly Hills High School Park | ||
175 | 175 | 174 | {"type": "MultiPolygon", "coordinates": [[[[-121.12574, 36.20479], [-121.12572, 36.2048], [-121.12555, 36.20471], [-121.12534, 36.20465], [-121.12512, 36.20465], [-121.12496, 36.20469], [-121.12271, 36.20586], [-121.12271, 36.20588], [-121.12331, 36.20664], [-121.1226, 36.20702], [-121.12158, 36.20725], [-121.12096, 36.2065], [-121.11972, 36.20706], [-121.11881, 36.20599], [-121.11886, 36.20594], [-121.11821, 36.205], [-121.11858, 36.20483], [-121.11869, 36.20432], [-121.11985, 36.20344], [-121.12047, 36.20329], [-121.12069, 36.20336], [-121.12112, 36.20368], [-121.12174, 36.20387], [-121.12159, 36.20398], [-121.12159, 36.204], [-121.12179, 36.20394], [-121.12301, 36.20385], [-121.12318, 36.20369], [-121.12353, 36.20281], [-121.12473, 36.20293], [-121.125, 36.20297], [-121.12471, 36.2037], [-121.1249, 36.20371], [-121.12574, 36.20479]]], [[[-121.12664, 36.20208], [-121.12626, 36.20229], [-121.12648, 36.20249], [-121.12617, 36.20244], [-121.12532, 36.20239], [-121.12362, 36.20222], [-121.12415, 36.201], [-121.12359, 36.20061], [-121.12434, 36.19963], [-121.12494, 36.19982], [-121.12496, 36.20087], [-121.12489, 36.20119], [-121.12487, 36.20141], [-121.12589, 36.20169], [-121.12664, 36.20208]]]]} | Restricted Access 2 | King City Golf Course | 33052 | 1152 | King City, City of 473 | City 2 | City Agency 2 | http://www.kingcity.com/ | City 2 | 53.754 | King City GC | ||
181 | 181 | 180 | {"type": "Polygon", "coordinates": [[[-122.28084, 38.26895], [-122.2782, 38.26902], [-122.27677, 38.2671], [-122.27631, 38.26737], [-122.27697, 38.26817], [-122.27675, 38.26949], [-122.27213, 38.27026], [-122.2719, 38.2693], [-122.27173, 38.26867], [-122.27151, 38.26765], [-122.27138, 38.26693], [-122.27119, 38.26559], [-122.27113, 38.26497], [-122.27106, 38.26416], [-122.27105, 38.26351], [-122.27168, 38.26331], [-122.27332, 38.2629], [-122.27458, 38.26299], [-122.2765, 38.26337], [-122.27675, 38.2632], [-122.27694, 38.26317], [-122.27776, 38.26348], [-122.27804, 38.26326], [-122.27815, 38.26282], [-122.27845, 38.26244], [-122.27855, 38.26202], [-122.2785, 38.26124], [-122.2787, 38.26096], [-122.27943, 38.26047], [-122.28056, 38.25989], [-122.28082, 38.2597], [-122.28084, 38.26895]]]} | Restricted Access 2 | Napa Golf Course | https://www.playnapa.com/ | 33054 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 156.018 | Napa GC | 1958 |
183 | 183 | 182 | {"type": "Polygon", "coordinates": [[[-119.25659, 34.24231], [-119.25428, 34.2423], [-119.25451, 34.244], [-119.25412, 34.24391], [-119.25352, 34.24372], [-119.2535, 34.2436], [-119.25333, 34.24354], [-119.25321, 34.24362], [-119.25217, 34.24328], [-119.25168, 34.24317], [-119.25117, 34.24308], [-119.25049, 34.24303], [-119.2489, 34.24299], [-119.24828, 34.24302], [-119.24768, 34.2431], [-119.24766, 34.24276], [-119.24749, 34.24276], [-119.24709, 34.24323], [-119.24437, 34.24382], [-119.2436, 34.24393], [-119.24348, 34.24318], [-119.24343, 34.24302], [-119.24322, 34.24276], [-119.24288, 34.24238], [-119.2422, 34.24282], [-119.24183, 34.24303], [-119.24184, 34.24356], [-119.24141, 34.24358], [-119.24116, 34.24321], [-119.24087, 34.23673], [-119.24288, 34.23684], [-119.25623, 34.23634], [-119.25629, 34.23783], [-119.25642, 34.23784], [-119.25659, 34.24231]]]} | Restricted Access 2 | Olivas Links Golf Course | 33063 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 254.625 | Olivas Links GC | ||
188 | 188 | 187 | {"type": "Polygon", "coordinates": [[[-121.01091, 37.61013], [-121.01091, 37.61163], [-121.01087, 37.61165], [-121.01029, 37.61166], [-121.01028, 37.61259], [-121.00951, 37.6126], [-121.0095, 37.61333], [-121.00713, 37.61333], [-121.00712, 37.6133], [-121.0069, 37.6132], [-121.00574, 37.61394], [-121.00469, 37.61511], [-121.00313, 37.61607], [-121.00289, 37.61661], [-121.00346, 37.61667], [-121.00337, 37.61699], [-121.00483, 37.617], [-121.00483, 37.61781], [-121.00413, 37.61781], [-121.00412, 37.61791], [-121.00265, 37.61791], [-121.00265, 37.61769], [-121.00263, 37.61768], [-121.00076, 37.62018], [-121.00023, 37.62069], [-120.99954, 37.62116], [-120.99932, 37.62134], [-120.99844, 37.62135], [-120.99856, 37.61961], [-120.99866, 37.61853], [-120.99872, 37.61772], [-120.9986, 37.61696], [-120.99845, 37.61648], [-120.99809, 37.61568], [-120.99824, 37.61515], [-121.00054, 37.61294], [-121.0023, 37.61183], [-121.00496, 37.61077], [-121.00724, 37.61022], [-121.00952, 37.60948], [-121.00953, 37.60976], [-121.00959, 37.60976], [-121.01091, 37.61013]]]} | Restricted Access 2 | Dryden Park Golf Course | 33067 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 145.269 | Dryden Park GC | ||
193 | 193 | 192 | {"type": "Polygon", "coordinates": [[[-116.80676, 32.87373], [-116.80265, 32.87367], [-116.8023, 32.85874], [-116.80627, 32.85879], [-116.80663, 32.86644], [-116.80676, 32.87373]]]} | Restricted Access 2 | Peutz Creek Preserve | 31861 | 3206 | San Diego River Park Foundation 784 | Non Profit 6 | Non Profit - Conservation 12 | http://sandiegoriver.org/ | Non Governmental Organization 10 | 156.952 | Peutz Creek Preserve | ||
194 | 194 | 193 | {"type": "Polygon", "coordinates": [[[-116.66647, 32.96362], [-116.66615, 32.96362], [-116.66613, 32.96401], [-116.66421, 32.96406], [-116.66329, 32.96512], [-116.66112, 32.96511], [-116.6611, 32.96361], [-116.66364, 32.96362], [-116.66451, 32.96339], [-116.66476, 32.96328], [-116.66507, 32.96309], [-116.66533, 32.96298], [-116.66555, 32.963], [-116.66584, 32.96322], [-116.66599, 32.96323], [-116.66612, 32.96329], [-116.66623, 32.96337], [-116.6663, 32.96347], [-116.66644, 32.96353], [-116.66647, 32.96362]]]} | Restricted Access 2 | Boulder Creek Preserve | 31862 | 3206 | San Diego River Park Foundation 784 | Non Profit 6 | Non Profit - Conservation 12 | http://sandiegoriver.org/ | Non Governmental Organization 10 | 15.044 | Boulder Creek Preserve | ||
195 | 195 | 194 | {"type": "Polygon", "coordinates": [[[-116.6651, 33.04926], [-116.66506, 33.05292], [-116.65653, 33.05293], [-116.65227, 33.05291], [-116.65232, 33.04918], [-116.65233, 33.04202], [-116.64727, 33.04204], [-116.64767, 33.04131], [-116.64771, 33.04121], [-116.64771, 33.0411], [-116.64766, 33.04089], [-116.64766, 33.04078], [-116.6477, 33.04058], [-116.64766, 33.04037], [-116.64769, 33.04027], [-116.64776, 33.04019], [-116.64805, 33.03994], [-116.64812, 33.03986], [-116.64816, 33.03976], [-116.64815, 33.03965], [-116.64798, 33.03931], [-116.64799, 33.03924], [-116.64802, 33.03918], [-116.64825, 33.03902], [-116.6483, 33.03894], [-116.65227, 33.03896], [-116.65257, 33.03929], [-116.65264, 33.03932], [-116.65433, 33.03932], [-116.65435, 33.04021], [-116.65646, 33.04022], [-116.65649, 33.04229], [-116.66092, 33.04229], [-116.66092, 33.0459], [-116.66084, 33.04923], [-116.6651, 33.04926]]]} | Restricted Access 2 | Eagle Peak Ranch | 31863 | 3206 | San Diego River Park Foundation 784 | Non Profit 6 | Non Profit - Conservation 12 | http://sandiegoriver.org/ | Non Governmental Organization 10 | 335.505 | Eagle Peak Ranch | ||
200 | 200 | 199 | {"type": "Polygon", "coordinates": [[[-116.83991, 32.9052], [-116.83982, 32.91649], [-116.8236, 32.91642], [-116.82363, 32.90747], [-116.82362, 32.90223], [-116.83778, 32.90156], [-116.83777, 32.90524], [-116.83991, 32.9052]]]} | Restricted Access 2 | El Cajon Mountain Preserve | 31859 | 3206 | San Diego River Park Foundation 784 | Non Profit 6 | Non Profit - Conservation 12 | http://sandiegoriver.org/ | Non Governmental Organization 10 | 588.407 | El Cajon Mtn. Preserve | ||
215 | 215 | 214 | {"type": "Polygon", "coordinates": [[[-118.17442, 34.11313], [-118.17382, 34.11314], [-118.17249, 34.1138], [-118.1717, 34.11481], [-118.17141, 34.1152], [-118.17123, 34.11541], [-118.17063, 34.11525], [-118.17023, 34.11568], [-118.1699, 34.11588], [-118.16957, 34.11604], [-118.1687, 34.11633], [-118.1684, 34.11659], [-118.16778, 34.11722], [-118.16752, 34.1172], [-118.16721, 34.11716], [-118.16702, 34.11722], [-118.16668, 34.1172], [-118.16617, 34.11698], [-118.1663, 34.1167], [-118.16644, 34.11652], [-118.16714, 34.1158], [-118.16736, 34.11565], [-118.16786, 34.11535], [-118.16903, 34.11436], [-118.17094, 34.11312], [-118.17138, 34.11306], [-118.1719, 34.11287], [-118.17256, 34.11271], [-118.17296, 34.1125], [-118.17362, 34.11232], [-118.17402, 34.11239], [-118.17442, 34.11313]]]} | Restricted Access 2 | Arroyo Seco Golf Course | http://www.arroyosecogolf.com/Home.html | 29411 | 1340 | South Pasadena, City of 306 | City 2 | City Agency 2 | http://www.ci.south-pasadena.ca.us/ | City 2 | 31.165 | Arroyo Seco GC | |
225 | 225 | 224 | {"type": "Polygon", "coordinates": [[[-117.80198, 33.70068], [-117.80192, 33.70074], [-117.80161, 33.70026], [-117.80139, 33.69982], [-117.80015, 33.69992], [-117.79916, 33.69984], [-117.79919, 33.69972], [-117.80014, 33.69978], [-117.80132, 33.69968], [-117.80117, 33.69913], [-117.8011, 33.69879], [-117.80097, 33.69768], [-117.80103, 33.69767], [-117.80109, 33.69772], [-117.80121, 33.69876], [-117.80128, 33.69916], [-117.80152, 33.69981], [-117.80176, 33.70031], [-117.80198, 33.70068]]]} | Restricted Access 2 | HOA Community Park | 31871 | 6033 | Windwood Homeowners Association 899 | Private 7 | Home Owners Association 15 | Private 14 | 1.699 | HOA Community Park | |||
226 | 226 | 225 | {"type": "Polygon", "coordinates": [[[-117.75409, 33.72128], [-117.75404, 33.72147], [-117.75388, 33.72142], [-117.7531, 33.72153], [-117.75267, 33.72164], [-117.75228, 33.72157], [-117.75231, 33.72142], [-117.75246, 33.72142], [-117.75253, 33.72139], [-117.75258, 33.72133], [-117.7527, 33.72104], [-117.75279, 33.72089], [-117.75298, 33.72067], [-117.75324, 33.72082], [-117.75332, 33.72092], [-117.75356, 33.72104], [-117.75365, 33.72099], [-117.75373, 33.72104], [-117.75372, 33.72113], [-117.75396, 33.72125], [-117.75409, 33.72128]]]} | Restricted Access 2 | HOA Community Park | 31872 | 6002 | Canyon Creek Homeowners Association 1030 | Private 7 | Home Owners Association 15 | http://www.canyoncreekhomeowners.com/ | Private 14 | 2.166 | HOA Community Park | ||
227 | 227 | 226 | {"type": "Polygon", "coordinates": [[[-117.81031, 33.63096], [-117.81032, 33.63157], [-117.8103, 33.63183], [-117.81025, 33.63185], [-117.80958, 33.63183], [-117.80933, 33.63128], [-117.80932, 33.63125], [-117.80933, 33.63121], [-117.80973, 33.63106], [-117.80993, 33.63099], [-117.81026, 33.63092], [-117.81031, 33.63096]]]} | Restricted Access 2 | Sierra Ridge Park | 31873 | 6021 | Sierra Bonita Community Association 1012 | Private 7 | Home Owners Association 15 | Private 14 | 1.826 | Sierra Ridge Park | |||
228 | 228 | 227 | {"type": "MultiPolygon", "coordinates": [[[[-117.79757, 33.68517], [-117.79737, 33.68538], [-117.7968, 33.68499], [-117.797, 33.68478], [-117.79757, 33.68517]]], [[[-117.79923, 33.69094], [-117.79815, 33.69104], [-117.79804, 33.69013], [-117.79871, 33.69009], [-117.79915, 33.69018], [-117.79923, 33.69094]]]]} | Restricted Access 2 | HOA Community Park | 31874 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | http://www.wva.org/ | Private 14 | 2.944 | HOA Community Park | ||
229 | 229 | 228 | {"type": "MultiPolygon", "coordinates": [[[[-117.7521, 33.70058], [-117.75208, 33.70061], [-117.75199, 33.70067], [-117.75192, 33.70067], [-117.75189, 33.70072], [-117.75139, 33.70036], [-117.75151, 33.70021], [-117.75156, 33.70019], [-117.75161, 33.7002], [-117.75209, 33.70054], [-117.7521, 33.70058]]], [[[-117.75657, 33.69395], [-117.75656, 33.69399], [-117.75648, 33.69405], [-117.75629, 33.69423], [-117.75626, 33.69428], [-117.75623, 33.6943], [-117.75618, 33.69428], [-117.75613, 33.69424], [-117.75575, 33.69397], [-117.75566, 33.69393], [-117.75564, 33.69389], [-117.75566, 33.69385], [-117.75574, 33.69379], [-117.75597, 33.69355], [-117.75602, 33.69355], [-117.75611, 33.69362], [-117.75612, 33.69368], [-117.75614, 33.6937], [-117.75617, 33.6937], [-117.75618, 33.69367], [-117.75646, 33.69387], [-117.75655, 33.69391], [-117.75657, 33.69395]]]]} | Restricted Access 2 | HOA Community Park | 31875 | 6035 | Woodbury Community Association 1011 | Private 7 | Home Owners Association 15 | http://woodburyhoa.org/ | Private 14 | 1.326 | HOA Community Park | ||
230 | 230 | 229 | {"type": "Polygon", "coordinates": [[[-117.81582, 33.63161], [-117.81557, 33.63212], [-117.81544, 33.63246], [-117.81538, 33.63248], [-117.81494, 33.63243], [-117.8149, 33.63239], [-117.81501, 33.63206], [-117.81515, 33.63175], [-117.81531, 33.63144], [-117.81536, 33.63142], [-117.81579, 33.63157], [-117.81582, 33.63161]]]} | Restricted Access 2 | Sierra Oro Park | 31876 | 6021 | Sierra Bonita Community Association 1012 | Private 7 | Home Owners Association 15 | Private 14 | 1.427 | Sierra Oro Park | |||
232 | 232 | 231 | {"type": "Polygon", "coordinates": [[[-118.38356, 34.06628], [-118.38312, 34.0663], [-118.3831, 34.06602], [-118.38268, 34.06603], [-118.38267, 34.06595], [-118.38262, 34.06594], [-118.3826, 34.06506], [-118.38346, 34.06506], [-118.38351, 34.06508], [-118.38356, 34.06628]]]} | Restricted Access 2 | Horace Mann Elementary School Park | 31881 | 1029 | Beverly Hills, City of 200 | City 2 | City Agency 2 | http://www.beverlyhills.org/living/recreationparks/ | City 2 | 2.535 | Horace Mann Elementary School Park | ||
235 | 235 | 234 | {"type": "Polygon", "coordinates": [[[-118.39479, 34.06229], [-118.39479, 34.06361], [-118.39394, 34.06362], [-118.39394, 34.06229], [-118.39479, 34.06229]]]} | Restricted Access 2 | Beverly Vista Elementary School Park | 31882 | 1029 | Beverly Hills, City of 200 | City 2 | City Agency 2 | http://www.beverlyhills.org/living/recreationparks/ | City 2 | 2.838 | Beverly Vista Elementary School Park | ||
236 | 236 | 235 | {"type": "MultiPolygon", "coordinates": [[[[-118.40382, 34.07823], [-118.40328, 34.0785], [-118.40298, 34.07798], [-118.40351, 34.07775], [-118.40382, 34.07823]]], [[[-118.40519, 34.07988], [-118.404, 34.08055], [-118.40365, 34.08016], [-118.40422, 34.07986], [-118.40483, 34.07951], [-118.40519, 34.07988]]]]} | Restricted Access 2 | Hawthorne Elementary School Park | 31883 | 1029 | Beverly Hills, City of 200 | City 2 | City Agency 2 | http://www.beverlyhills.org/living/recreationparks/ | City 2 | 2.582 | Hawthorne Elementary School 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]);