superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
10,210 rows where MNG_AG_TYP = 2 sorted by YR_EST descending
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AG_LEV
MNG_AGENCY >30
- Los Angeles, City of 465
- San Diego, City of 433
- San Jose, City of 253
- San Francisco, City and County of 240
- Sacramento, City of 218
- Ventura, City of 151
- Long Beach, City of 148
- Roseville, City of 124
- Oakland, City of 122
- Irvine, City of 98
- Fresno, City of 94
- Modesto, City of 84
- Stockton, City of 81
- Santa Rosa, City of 79
- Huntington Beach, City of 76
- Tracy, City of 73
- Torrance, City of 72
- Santa Cruz, City of 69
- Chula Vista, City of 69
- Brentwood, City of 68
- Poway, City of 67
- Newport Beach, City of 65
- Santa Barbara, City of 64
- Davis, City of 64
- San Luis Obispo, City of 63
- Napa, City of 62
- Clovis, City of 62
- Bakersfield, City of 61
- Manteca, City of 60
- Anaheim, City of 59
- …
ACCESS_TYP 4
- Open Access 9,670
- Restricted Access 356
- No Public Access 155
- Unknown Access 29
MNG_AG_TYP 1
- City Agency · 10,210 ✖
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 ▲ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
766 | 766 | 765 | {"type": "Polygon", "coordinates": [[[-119.22071, 35.67312], [-119.2207, 35.67438], [-119.21686, 35.67441], [-119.21687, 35.67315], [-119.22071, 35.67312]]]} | Open Access 1 | Jim White "Blanco" Park | https://www.mcfarlandcity.org/194/Parks-Recreation | 32709 | 1691 | McFarland, City of 944 | City 2 | City Agency 2 | http://www.mcfarlandcity.org/194/Parks-Recreation | City 2 | 11.995 | Jim White "Blanco" Park | 2019 |
901 | 901 | 900 | {"type": "Polygon", "coordinates": [[[-117.1632, 33.14385], [-117.16316, 33.14408], [-117.16282, 33.14405], [-117.16279, 33.144], [-117.16284, 33.1438], [-117.16288, 33.14375], [-117.16304, 33.14365], [-117.1632, 33.14385]]]} | Open Access 1 | Mark J. Noy Jr. Adult Fitness Zone | https://www.san-marcos.net/Home/Components/Calendar/Event/9174/5349 | 32784 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | http://www.ci.san-marcos.ca.us/index.aspx?page=42 | City 2 | 0.308 | Mark J. Noy Jr. Adult Fitness Zone | 2019 |
6817 | 6817 | 6816 | {"type": "Polygon", "coordinates": [[[-121.91965, 37.40115], [-121.91878, 37.40193], [-121.91857, 37.40145], [-121.91833, 37.40099], [-121.91804, 37.40054], [-121.91838, 37.40024], [-121.9184, 37.40032], [-121.91845, 37.40039], [-121.91922, 37.40091], [-121.91923, 37.40098], [-121.91927, 37.40103], [-121.91937, 37.40106], [-121.91947, 37.40102], [-121.91965, 37.40115]]]} | Open Access 1 | Iris Chang Park | https://www.sanjoseca.gov/Home/Components/News/News/402/5103 | 33665 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 2.664 | Iris Chang Park | 2019 |
12063 | 12063 | 12062 | {"type": "Polygon", "coordinates": [[[-117.2044, 33.66004], [-117.2044, 33.66054], [-117.20364, 33.66054], [-117.20359, 33.66062], [-117.20354, 33.6606], [-117.20346, 33.66061], [-117.20341, 33.66063], [-117.20336, 33.66068], [-117.20329, 33.66065], [-117.20297, 33.66079], [-117.20284, 33.66059], [-117.20195, 33.66065], [-117.20188, 33.66067], [-117.20183, 33.66063], [-117.20176, 33.6606], [-117.20171, 33.6606], [-117.20164, 33.66063], [-117.20158, 33.66056], [-117.20124, 33.66056], [-117.20122, 33.66075], [-117.20087, 33.66075], [-117.2008, 33.66083], [-117.20069, 33.6608], [-117.20062, 33.66083], [-117.20058, 33.66086], [-117.20052, 33.66083], [-117.19977, 33.66082], [-117.19974, 33.66126], [-117.19976, 33.66132], [-117.19984, 33.66137], [-117.19983, 33.66196], [-117.19965, 33.66189], [-117.19954, 33.6619], [-117.1991, 33.66179], [-117.19873, 33.66179], [-117.19872, 33.66073], [-117.1987, 33.66058], [-117.19865, 33.66043], [-117.19893, 33.6603], [-117.19895, 33.66028], [-117.19946, 33.66011], [-117.19943, 33.66016], [-117.19942, 33.66021], [-117.19946, 33.66029], [-117.19955, 33.66033], [-117.19967, 33.66031], [-117.19976, 33.6604], [-117.20039, 33.66041], [-117.20046, 33.66038], [-117.20053, 33.66044], [-117.20062, 33.66045], [-117.20069, 33.66043], [-117.20073, 33.66038], [-117.20075, 33.66033], [-117.20074, 33.66025], [-117.20105, 33.66025], [-117.20106, 33.66021], [-117.201, 33.66008], [-117.20101, 33.65909], [-117.2012, 33.65907], [-117.20127, 33.65938], [-117.20143, 33.65965], [-117.20138, 33.65968], [-117.20135, 33.65973], [-117.20134, 33.65978], [-117.20136, 33.65984], [-117.20125, 33.6599], [-117.20127, 33.66018], [-117.2015, 33.66018], [-117.20169, 33.66026], [-117.20192, 33.66029], [-117.20226, 33.66029], [-117.20232, 33.66025], [-117.20237, 33.66029], [-117.20245, 33.66031], [-117.20256, 33.66027], [-117.20261, 33.66031], [-117.20297, 33.66035], [-117.2034, 33.66029], [-117.20345, 33.66024], [-117.20352, 33.66027], [-117.20358, 33.66026], [-117.20366, 33.66022], [-117.20372, 33.66026], [-117.20405, 33.66026], [-117.20406, 33.66004], [-117.2044, 33.66004]]]} | Open Access 1 | Hidden Hills Park | https://www.cityofmenifee.us/285/Parks | 33218 | 1707 | Menifee, City of 655 | City 2 | City Agency 2 | http://www.cityofmenifee.us/284/Community-Services | City 2 | 9.657 | Hidden Hills Park | 2019 |
13302 | 13302 | 13301 | {"type": "Polygon", "coordinates": [[[-117.865, 33.73375], [-117.86499, 33.73389], [-117.86457, 33.7339], [-117.86456, 33.73403], [-117.86354, 33.73405], [-117.86354, 33.73356], [-117.86456, 33.73363], [-117.86494, 33.7337], [-117.865, 33.73375]]]} | Open Access 1 | Pacific Electric Park | https://www.santa-ana.org/parks/parks-location/pacific-electric | 33426 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 1.405 | Pacific Electric Park | 2019 |
13905 | 13905 | 13904 | {"type": "Polygon", "coordinates": [[[-121.49612, 38.47412], [-121.4957, 38.47412], [-121.49569, 38.47406], [-121.49534, 38.47406], [-121.49534, 38.47374], [-121.49529, 38.47367], [-121.49522, 38.47363], [-121.49445, 38.47365], [-121.4944, 38.47363], [-121.49437, 38.47359], [-121.49437, 38.47308], [-121.49435, 38.47289], [-121.49436, 38.47286], [-121.49441, 38.47283], [-121.49467, 38.47279], [-121.49482, 38.47278], [-121.49491, 38.47272], [-121.49494, 38.47263], [-121.49518, 38.47266], [-121.49612, 38.47412]]]} | Open Access 1 | LaVar Burton Park | https://www.cityofsacramento.org/ParksandRec/Parks/Park-Directory/South-Sacramento/LeVar-Burton-Park | 33228 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 3.152 | LaVar Burton Park | 2019 |
14129 | 14129 | 14128 | {"type": "Polygon", "coordinates": [[[-119.82045, 34.43733], [-119.81874, 34.43735], [-119.81907, 34.43679], [-119.81909, 34.43626], [-119.82044, 34.43625], [-119.82045, 34.43733]]]} | Open Access 1 | Jonny D. Wallis Neighborhood Park | https://www.cityofgoleta.org/projects-programs/parks-open-space/old-town-park | 32654 | 1121 | Goleta, City of 175 | City 2 | City Agency 2 | http://www.cityofgoleta.org/index.aspx?page=206 | City 2 | 3.959 | Jonny D. Wallis Neighborhood Park | 2019 |
14440 | 14440 | 14439 | {"type": "Polygon", "coordinates": [[[-121.26493, 38.83074], [-121.26429, 38.83085], [-121.26318, 38.83041], [-121.26365, 38.82968], [-121.26371, 38.82953], [-121.26376, 38.8292], [-121.26378, 38.82917], [-121.26384, 38.82915], [-121.26484, 38.82927], [-121.2648, 38.82959], [-121.2648, 38.83], [-121.26485, 38.8304], [-121.26493, 38.83074]]]} | Open Access 1 | Willard Park | 33743 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 4.813 | Willard Park | 2019 | |
47 | 47 | 46 | {"type": "Polygon", "coordinates": [[[-118.18057, 33.81348], [-118.18057, 33.81362], [-118.18053, 33.8138], [-118.18, 33.81378], [-118.17999, 33.81348], [-118.18057, 33.81348]]]} | Open Access 1 | Signal Hill Dog Park | http://www.cityofsignalhill.org/Facilities/Facility/Details/Signal-Hill-Dog-Park-27 | 31767 | 1334 | Signal Hill, City of 366 | City 2 | City Agency 2 | http://www.cityofsignalhill.org/index.aspx?nid=26 | City 2 | 0.441 | Signal Hill Dog Park | 2018 |
87 | 87 | 86 | {"type": "Polygon", "coordinates": [[[-117.85212, 33.98947], [-117.85182, 33.9896], [-117.8517, 33.98973], [-117.8516, 33.9899], [-117.85177, 33.99025], [-117.85212, 33.99036], [-117.85201, 33.99068], [-117.85197, 33.99071], [-117.85185, 33.99073], [-117.8518, 33.99078], [-117.85179, 33.99085], [-117.85186, 33.99093], [-117.85186, 33.99097], [-117.85184, 33.99102], [-117.8518, 33.99105], [-117.85106, 33.99068], [-117.85088, 33.99061], [-117.8507, 33.99056], [-117.85041, 33.99053], [-117.8496, 33.99057], [-117.84933, 33.99061], [-117.84932, 33.99034], [-117.84954, 33.99025], [-117.8496, 33.99], [-117.84997, 33.98961], [-117.85022, 33.98963], [-117.85052, 33.98959], [-117.85071, 33.9896], [-117.85108, 33.98948], [-117.85119, 33.98952], [-117.85127, 33.98952], [-117.85144, 33.98945], [-117.85182, 33.98949], [-117.85208, 33.98939], [-117.85212, 33.98947]]]} | Open Access 1 | Larkstone Park | https://www.diamondbarca.gov/Facilities/Facility/Details/Larkstone-Park-38 | 31798 | 1085 | Diamond Bar, City of 312 | City 2 | City Agency 2 | http://www.ci.diamond-bar.ca.us/Index.aspx?page=939 | City 2 | 6.425 | Larkstone Park | 2018 |
600 | 600 | 599 | {"type": "Polygon", "coordinates": [[[-117.74684, 34.02858], [-117.74645, 34.02859], [-117.74644, 34.02843], [-117.74684, 34.02842], [-117.74684, 34.02858]]]} | Open Access 1 | Esperanza y Alegria Park | 32693 | 1258 | Pomona, City of 125 | City 2 | City Agency 2 | http://ci.pomona.ca.us/index.php/visitors/park-directory | City 2 | 0.165 | Esperanza y Alegria Park | 2018 | |
1108 | 1108 | 1107 | {"type": "Polygon", "coordinates": [[[-121.07771, 39.22081], [-121.07676, 39.22153], [-121.07673, 39.22149], [-121.07655, 39.22152], [-121.07648, 39.22149], [-121.07549, 39.22233], [-121.07526, 39.22221], [-121.07499, 39.22212], [-121.07443, 39.22199], [-121.07444, 39.22102], [-121.07551, 39.22103], [-121.07557, 39.22092], [-121.07556, 39.22075], [-121.07569, 39.22072], [-121.07668, 39.22003], [-121.07771, 39.22081]]]} | Restricted Access 2 | Margaret G Scotten School Ballfields | 32866 | 1673 | Grass Valley, City of 712 | City 2 | City Agency 2 | http://www.cityofgrassvalley.com/departments/parks-and-rec/city-parks | City 2 | 8.568 | Margaret G Scotten School Ballfields | 2018 | |
1232 | 1232 | 1231 | {"type": "Polygon", "coordinates": [[[-121.85783, 37.71464], [-121.85783, 37.71473], [-121.85752, 37.71497], [-121.85728, 37.71519], [-121.85684, 37.71563], [-121.85657, 37.71602], [-121.85649, 37.71603], [-121.85605, 37.71585], [-121.85602, 37.71588], [-121.85346, 37.71482], [-121.85305, 37.71458], [-121.8528, 37.71439], [-121.85265, 37.71425], [-121.85239, 37.71397], [-121.85226, 37.71378], [-121.85214, 37.71356], [-121.85206, 37.71337], [-121.85199, 37.71316], [-121.85194, 37.71283], [-121.85194, 37.71254], [-121.85207, 37.71144], [-121.85213, 37.71121], [-121.85217, 37.71065], [-121.85226, 37.71058], [-121.8536, 37.71047], [-121.85423, 37.71036], [-121.85473, 37.71025], [-121.85511, 37.71013], [-121.85564, 37.70992], [-121.85597, 37.70976], [-121.85643, 37.7095], [-121.85715, 37.70914], [-121.85726, 37.70917], [-121.85745, 37.70949], [-121.85759, 37.70985], [-121.85766, 37.71022], [-121.85766, 37.71057], [-121.85762, 37.71079], [-121.85756, 37.71101], [-121.85703, 37.71255], [-121.85698, 37.7128], [-121.85697, 37.71317], [-121.85701, 37.71341], [-121.85708, 37.71364], [-121.85725, 37.71398], [-121.85748, 37.71429], [-121.85783, 37.71464]]]} | Open Access 1 | Fallon Sports Park | https://www.dublin.ca.gov/Facilities/Facility/Details/Fallon-Sports-Park-22 | 32911 | 1090 | Dublin, City of 160 | City 2 | City Agency 2 | http://www.ci.dublin.ca.us/index.aspx?nid=1458 | City 2 | 65.297 | Fallon Sports Park | 2018 |
1233 | 1233 | 1232 | {"type": "Polygon", "coordinates": [[[-121.84712, 37.7135], [-121.84714, 37.71357], [-121.8472, 37.71362], [-121.84726, 37.71372], [-121.84732, 37.71388], [-121.84734, 37.71403], [-121.84733, 37.71419], [-121.84728, 37.71435], [-121.8472, 37.71449], [-121.84701, 37.71468], [-121.84686, 37.71478], [-121.84668, 37.71486], [-121.84649, 37.71491], [-121.84569, 37.71507], [-121.84554, 37.71508], [-121.84533, 37.71505], [-121.8452, 37.71499], [-121.84505, 37.71487], [-121.84496, 37.71473], [-121.84487, 37.71469], [-121.84546, 37.71433], [-121.84589, 37.71411], [-121.84639, 37.7139], [-121.8468, 37.71366], [-121.84707, 37.71355], [-121.84712, 37.7135]]]} | Open Access 1 | Jordan Ranch Park | https://ca-dublin2.civicplus.com/Facilities/Facility/Details/Jordan-Ranch-Park-31 | 32912 | 1090 | Dublin, City of 160 | City 2 | City Agency 2 | http://www.ci.dublin.ca.us/index.aspx?nid=1458 | City 2 | 4.982 | Jordan Ranch Park | 2018 |
1244 | 1244 | 1243 | {"type": "Polygon", "coordinates": [[[-121.84613, 37.71921], [-121.8461, 37.71922], [-121.84608, 37.71928], [-121.84603, 37.71931], [-121.84534, 37.71946], [-121.84486, 37.71953], [-121.84439, 37.71957], [-121.84435, 37.71956], [-121.84433, 37.71954], [-121.8443, 37.71954], [-121.84428, 37.71905], [-121.84432, 37.71882], [-121.84438, 37.7186], [-121.84448, 37.71838], [-121.84461, 37.71818], [-121.84485, 37.7179], [-121.84492, 37.71786], [-121.84498, 37.71786], [-121.84503, 37.71789], [-121.84529, 37.7181], [-121.84554, 37.71833], [-121.84584, 37.71871], [-121.84599, 37.71894], [-121.84613, 37.71921]]]} | Open Access 1 | Sean Diamond Park | https://www.dublin.ca.gov/Facilities/Facility/Details/Sean-Diamond-Park-33 | 32917 | 1090 | Dublin, City of 160 | City 2 | City Agency 2 | http://www.ci.dublin.ca.us/index.aspx?nid=1458 | City 2 | 4.986 | Sean Diamond Park | 2018 |
1263 | 1263 | 1262 | {"type": "Polygon", "coordinates": [[[-117.31082, 33.65409], [-117.31079, 33.65427], [-117.30502, 33.65344], [-117.30504, 33.65336], [-117.30568, 33.65345], [-117.30583, 33.65264], [-117.30709, 33.65186], [-117.30779, 33.65154], [-117.30788, 33.65166], [-117.30804, 33.65157], [-117.30845, 33.65132], [-117.30899, 33.65089], [-117.31082, 33.65409]]]} | Open Access 1 | Summerly Community Park | http://www.lake-elsinore.org/city-hall/community-services/parks-and-facilities/parks/summerly-park-2232#ad-image-3 | 32925 | 1389 | Lake Elsinore, City of 183 | City 2 | City Agency 2 | http://www.lake-elsinore.org/index.aspx?page=202 | City 2 | 24.135 | Summerly Community Park | 2018 |
3519 | 3519 | 3518 | {"type": "Polygon", "coordinates": [[[-118.19815, 33.85938], [-118.19488, 33.86461], [-118.19471, 33.86483], [-118.19365, 33.86651], [-118.19195, 33.86924], [-118.1908, 33.86927], [-118.19254, 33.86619], [-118.19511, 33.86194], [-118.19574, 33.86094], [-118.19576, 33.86083], [-118.19594, 33.86053], [-118.1961, 33.86064], [-118.19622, 33.86062], [-118.19765, 33.85861], [-118.19767, 33.85857], [-118.19766, 33.85851], [-118.19785, 33.85833], [-118.19815, 33.85938]]]} | Open Access 1 | DeForest Park | 18015 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 34.119 | DeForest Park | 2018 | |
7709 | 7709 | 7708 | {"type": "Polygon", "coordinates": [[[-120.86774, 37.60385], [-120.86552, 37.60384], [-120.86554, 37.60217], [-120.8656, 37.60212], [-120.8669, 37.60212], [-120.86691, 37.60254], [-120.86682, 37.60254], [-120.86682, 37.60268], [-120.867, 37.60268], [-120.86701, 37.60262], [-120.86773, 37.60261], [-120.86774, 37.60385]]]} | Open Access 1 | Lebright Fields | 33140 | 1140 | Hughson, City of 841 | City 2 | City Agency 2 | http://hughson.org/government/city-departments/parks-and-recreations/ | City 2 | 8.157 | Lebright Fields | 2018 | |
9566 | 9566 | 9565 | {"type": "MultiPolygon", "coordinates": [[[[-119.09596, 36.2106], [-119.09596, 36.21227], [-119.0953, 36.21229], [-119.09519, 36.2123], [-119.0951, 36.21234], [-119.09499, 36.21245], [-119.09479, 36.2129], [-119.09497, 36.21298], [-119.09512, 36.21301], [-119.09561, 36.21301], [-119.09561, 36.2131], [-119.095, 36.21312], [-119.095, 36.21355], [-119.09546, 36.21356], [-119.09546, 36.214], [-119.09346, 36.21401], [-119.09328, 36.21399], [-119.09302, 36.21392], [-119.09275, 36.2139], [-119.09247, 36.21394], [-119.09215, 36.21404], [-119.092, 36.21406], [-119.09176, 36.21407], [-119.09169, 36.21403], [-119.09169, 36.21351], [-119.09171, 36.2135], [-119.09172, 36.21339], [-119.09177, 36.21327], [-119.09185, 36.21316], [-119.09196, 36.21307], [-119.09223, 36.21293], [-119.09241, 36.2128], [-119.09254, 36.21263], [-119.0926, 36.21251], [-119.09262, 36.21238], [-119.09258, 36.21065], [-119.09596, 36.2106]]], [[[-119.09351, 36.21418], [-119.09314, 36.2142], [-119.09313, 36.21509], [-119.0917, 36.2151], [-119.09169, 36.21427], [-119.09176, 36.21423], [-119.09211, 36.21421], [-119.09255, 36.21409], [-119.09279, 36.21407], [-119.09296, 36.21408], [-119.09328, 36.21416], [-119.09351, 36.21418]]]]} | Open Access 1 | Lindsay Sports and Recreation Complex | 33707 | 1176 | Lindsay, City of 134 | City 2 | City Agency 2 | http://www.lindsay.ca.us/citygov/works/parks.cfm | City 2 | 30.092 | Lindsay Sports and Rec. Complex | 2018 | |
9929 | 9929 | 9928 | {"type": "Polygon", "coordinates": [[[-118.2041, 33.77812], [-118.20413, 33.77876], [-118.20407, 33.77891], [-118.20398, 33.77908], [-118.20386, 33.77925], [-118.20372, 33.7794], [-118.2035, 33.77958], [-118.20334, 33.77968], [-118.20106, 33.78128], [-118.20102, 33.78137], [-118.2007, 33.78153], [-118.20044, 33.7817], [-118.20015, 33.78197], [-118.19976, 33.78248], [-118.19955, 33.78248], [-118.19977, 33.78213], [-118.20005, 33.78181], [-118.20033, 33.78157], [-118.20115, 33.781], [-118.20119, 33.78077], [-118.20134, 33.7806], [-118.20151, 33.78056], [-118.20132, 33.78016], [-118.20164, 33.78003], [-118.20194, 33.77984], [-118.20211, 33.77969], [-118.20269, 33.7791], [-118.20278, 33.77899], [-118.20299, 33.77911], [-118.20318, 33.77899], [-118.20317, 33.77898], [-118.20309, 33.77895], [-118.20314, 33.77882], [-118.20323, 33.77885], [-118.20344, 33.77871], [-118.20348, 33.77854], [-118.2035, 33.77836], [-118.20347, 33.77806], [-118.20393, 33.778], [-118.20395, 33.77813], [-118.2041, 33.77812]]]} | Open Access 1 | Drake/Chavez Soccer Fields and Parkway | 27996 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 7.972 | Drake/Chavez Soccer Fields and Parkway | 2018 |
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]);