superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,102 rows where MNG_AG_TYP = 3 sorted by PARK_URL descending
This data as json, copyable, CSV (advanced)
Suggested facets: YR_EST
MNG_AGENCY >30
- Los Angeles, County of 171
- San Diego, County of 120
- Santa Barbara, County of 89
- Orange, County of 82
- Lake, County of 56
- Butte, County of 53
- Santa Cruz, County of 50
- Sacramento, County of 48
- Kern, County of 47
- Riverside, County of 39
- San Luis Obispo, County of 31
- Monterey, County of 31
- Placer, County of 28
- Stanislaus, County of 24
- San Joaquin, County of 21
- Ventura, County of 20
- San Bernardino, County of 18
- Fresno, County of 17
- Merced, County of 16
- Yolo, County of 16
- Tulare, County of 15
- Humboldt, County of 12
- El Dorado, County of 9
- Mono, County of 7
- Tehama, County of 7
- Mendocino, County of 7
- Mariposa, County of 6
- Lassen, County of 6
- Imperial, County of 5
- Napa, County of 5
- …
ACCESS_TYP 4
- Open Access 983
- Restricted Access 57
- Unknown Access 36
- No Public Access 26
MNG_AG_TYP 1
- County Agency · 1,102 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13933 | 13933 | 13932 | {"type": "Polygon", "coordinates": [[[-118.05801, 33.90814], [-118.05748, 33.90772], [-118.0555, 33.90773], [-118.05549, 33.906], [-118.05799, 33.90598], [-118.05801, 33.90814]]]} | Restricted Access 2 | Don Knabe Golf Center and Junior Academy | https://www.playknabegolf.com/ | 32519 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 11.278 | Don Knabe Golf Ctr. and Junior Academy | |
14140 | 14140 | 14139 | {"type": "Polygon", "coordinates": [[[-121.17178, 38.78981], [-121.1705, 38.79009], [-121.17044, 38.79009], [-121.17038, 38.79007], [-121.17033, 38.79002], [-121.1699, 38.7888], [-121.17148, 38.78877], [-121.17178, 38.78981]]]} | Open Access 1 | Franklin Community School Park | https://www.placer.ca.gov/6045/Franklin-Community-School-Park | 33699 | 314 | Placer, County of 206 | County 3 | County Agency 3 | http://www.placer.ca.gov/departments/facility/parks | County 3 | 4.348 | Franklin Community School Park | |
14433 | 14433 | 14432 | {"type": "Polygon", "coordinates": [[[-121.09452, 38.93839], [-121.09416, 38.93839], [-121.09416, 38.93785], [-121.09416, 38.93785], [-121.09452, 38.93839]]]} | Open Access 1 | Auburn Plaza Park | https://www.placer.ca.gov/6005/Plaza-Park | 33724 | 314 | Placer, County of 206 | County 3 | County Agency 3 | http://www.placer.ca.gov/departments/facility/parks | County 3 | 0.231 | Auburn Plaza Park | |
14434 | 14434 | 14433 | {"type": "Polygon", "coordinates": [[[-120.81909, 39.02277], [-120.81495, 39.02381], [-120.81432, 39.02209], [-120.81557, 39.02184], [-120.81585, 39.02263], [-120.81673, 39.02246], [-120.81674, 39.02244], [-120.81647, 39.02165], [-120.81844, 39.02125], [-120.81899, 39.02269], [-120.81909, 39.02277]]]} | Open Access 1 | Foresthill Leroy E. Botts Memorial Park | https://www.placer.ca.gov/6000/Foresthill-Leroy-E-Botts-Memorial-Park | 33725 | 314 | Placer, County of 206 | County 3 | County Agency 3 | http://www.placer.ca.gov/departments/facility/parks | County 3 | 15.356 | Foresthill Leroy E. Botts Memorial Park | |
955 | 955 | 954 | {"type": "Polygon", "coordinates": [[[-123.20724, 39.27079], [-123.2067, 39.27099], [-123.20634, 39.27092], [-123.20581, 39.27127], [-123.2057, 39.27079], [-123.20565, 39.27078], [-123.20548, 39.27018], [-123.20623, 39.27012], [-123.20624, 39.2701], [-123.20614, 39.26984], [-123.20541, 39.2699], [-123.2054, 39.26983], [-123.20702, 39.26969], [-123.20724, 39.27079]]]} | Open Access 1 | Redwood Valley Lions Club Park | https://www.mendocinocounty.org/government/cultural-services-agency/parks/redwood-valley-lions-club-park | 33588 | 352 | Mendocino, County of 609 | County 3 | County Agency 3 | http://www.co.mendocino.ca.us/gs/parks/ | County 3 | 4.167 | Redwood Valley Lions Club Park | |
6440 | 6440 | 6439 | {"type": "Polygon", "coordinates": [[[-123.23328, 39.16378], [-123.23272, 39.16366], [-123.23249, 39.16358], [-123.23241, 39.16352], [-123.23233, 39.16328], [-123.2323, 39.16324], [-123.23211, 39.16311], [-123.23206, 39.16309], [-123.23199, 39.1631], [-123.23188, 39.16317], [-123.23166, 39.16327], [-123.23156, 39.1633], [-123.23146, 39.16329], [-123.2313, 39.16323], [-123.23112, 39.16307], [-123.2309, 39.16296], [-123.23075, 39.16294], [-123.23045, 39.16293], [-123.22986, 39.16285], [-123.22964, 39.16284], [-123.22955, 39.16285], [-123.2295, 39.16289], [-123.22933, 39.16306], [-123.22915, 39.16322], [-123.22906, 39.16326], [-123.22883, 39.16333], [-123.22863, 39.16335], [-123.22853, 39.16334], [-123.22842, 39.1633], [-123.22832, 39.16323], [-123.22782, 39.16311], [-123.2276, 39.16289], [-123.22709, 39.16268], [-123.22695, 39.1624], [-123.22694, 39.16232], [-123.22659, 39.16202], [-123.22625, 39.16195], [-123.22552, 39.16209], [-123.22492, 39.16238], [-123.22307, 39.16188], [-123.22317, 39.1616], [-123.22241, 39.16113], [-123.22206, 39.16105], [-123.22201, 39.16068], [-123.22692, 39.16069], [-123.22694, 39.16039], [-123.22886, 39.16039], [-123.23313, 39.16044], [-123.23328, 39.16378]]]} | Open Access 1 | Low Gap Regional Park | https://www.mendocinocounty.org/government/cultural-services-agency/parks/low-gap-park | 21551 | 352 | Mendocino, County of 609 | County 3 | County Agency 3 | http://www.co.mendocino.ca.us/gs/parks/ | County 3 | 54.98 | Low Gap RP | |
10328 | 10328 | 10327 | {"type": "Polygon", "coordinates": [[[-123.4405, 39.05938], [-123.44048, 39.05966], [-123.44041, 39.05975], [-123.44021, 39.05983], [-123.43997, 39.0601], [-123.43987, 39.06018], [-123.43962, 39.06044], [-123.43951, 39.06053], [-123.43949, 39.06058], [-123.4393, 39.06079], [-123.43906, 39.06087], [-123.43892, 39.06095], [-123.43876, 39.06095], [-123.43795, 39.06072], [-123.43766, 39.0607], [-123.4375, 39.06076], [-123.43727, 39.06098], [-123.43715, 39.06109], [-123.43686, 39.06123], [-123.43655, 39.06093], [-123.43605, 39.06052], [-123.43589, 39.0604], [-123.43528, 39.06002], [-123.43639, 39.05958], [-123.43805, 39.05866], [-123.4405, 39.05938]]]} | Open Access 1 | Indian Creek County Park | https://www.mendocinocounty.org/government/cultural-services-agency/parks/indian-creek | 33715 | 352 | Mendocino, County of 609 | County 3 | County Agency 3 | http://www.co.mendocino.ca.us/gs/parks/ | County 3 | 17.437 | Indian Creek County Park | 1973 |
9615 | 9615 | 9614 | {"type": "Polygon", "coordinates": [[[-123.4074, 39.00408], [-123.40742, 39.00624], [-123.40739, 39.00777], [-123.40276, 39.00769], [-123.40285, 39.004], [-123.4074, 39.00408]]]} | Open Access 1 | Faulkner Park | https://www.mendocinocounty.org/government/cultural-services-agency/parks/faulkner-park | 33709 | 352 | Mendocino, County of 609 | County 3 | County Agency 3 | http://www.co.mendocino.ca.us/gs/parks/ | County 3 | 40.359 | Faulkner Park | 1930 |
13857 | 13857 | 13856 | {"type": "Polygon", "coordinates": [[[-120.58203, 38.77208], [-120.58176, 38.77203], [-120.57991, 38.772], [-120.58004, 38.76833], [-120.58042, 38.76844], [-120.58081, 38.76858], [-120.5813, 38.76903], [-120.58158, 38.7696], [-120.58168, 38.77008], [-120.58144, 38.77071], [-120.58152, 38.77158], [-120.58173, 38.77186], [-120.58203, 38.77208]]]} | Open Access 1 | Forebay Park | https://www.edcgov.us/Government/Parks/Pages/forebay_park.aspx | 33175 | 351 | El Dorado, County of 408 | County 3 | County Agency 3 | http://www.edcgov.us/Parks/ | County 3 | 12.621 | Forebay Park | |
15623 | 15623 | 15622 | {"type": "MultiPolygon", "coordinates": [[[[-118.10512, 34.19263], [-118.10495, 34.19317], [-118.1048, 34.19329], [-118.10424, 34.19328], [-118.10399, 34.19293], [-118.10371, 34.19231], [-118.10354, 34.19238], [-118.1038, 34.193], [-118.104, 34.19328], [-118.10044, 34.19324], [-118.10041, 34.1896], [-118.10041, 34.18951], [-118.10037, 34.18595], [-118.10038, 34.18582], [-118.10173, 34.18646], [-118.10183, 34.18719], [-118.10171, 34.1876], [-118.10216, 34.18872], [-118.10269, 34.18896], [-118.10291, 34.18931], [-118.10293, 34.18951], [-118.10319, 34.19046], [-118.10315, 34.19063], [-118.10327, 34.19076], [-118.10336, 34.19121], [-118.10395, 34.19177], [-118.10426, 34.19224], [-118.10479, 34.19236], [-118.10512, 34.19263]]], [[[-118.10571, 34.19254], [-118.10563, 34.19268], [-118.10553, 34.1927], [-118.10502, 34.19312], [-118.10516, 34.19262], [-118.10481, 34.19233], [-118.10428, 34.19222], [-118.10398, 34.19175], [-118.10339, 34.1912], [-118.10331, 34.19075], [-118.10319, 34.19062], [-118.10324, 34.19045], [-118.10298, 34.18951], [-118.10295, 34.1893], [-118.10272, 34.18893], [-118.1022, 34.1887], [-118.10175, 34.1876], [-118.10186, 34.1872], [-118.10176, 34.18644], [-118.10069, 34.18594], [-118.10038, 34.18578], [-118.10038, 34.18574], [-118.10068, 34.18593], [-118.10069, 34.18592], [-118.10079, 34.18485], [-118.10154, 34.18474], [-118.101, 34.18412], [-118.10077, 34.18394], [-118.10058, 34.18376], [-118.10078, 34.1839], [-118.10092, 34.18397], [-118.10117, 34.18406], [-118.10152, 34.18424], [-118.10166, 34.18435], [-118.10214, 34.1848], [-118.10237, 34.18498], [-118.10214, 34.18519], [-118.10241, 34.18574], [-118.10243, 34.18574], [-118.10251, 34.18568], [-118.10281, 34.18591], [-118.10321, 34.18648], [-118.10297, 34.18664], [-118.10297, 34.18666], [-118.10326, 34.18664], [-118.10359, 34.18659], [-118.10361, 34.18666], [-118.10381, 34.18697], [-118.10372, 34.18767], [-118.10396, 34.18819], [-118.10412, 34.18822], [-118.10441, 34.18852], [-118.10486, 34.18921], [-118.10493, 34.18974], [-118.10492, 34.19033], [-118.10482, 34.19037], [-118.10459, 34.19071], [-118.10473, 34.19087], [-118.10491, 34.19087], [-118.10491, 34.1911], [-118.10516, 34.19141], [-118.10541, 34.19194], [-118.10545, 34.19211], [-118.10571, 34.19254]]], [[[-118.10683, 34.19331], [-118.1061, 34.19332], [-118.10604, 34.1933], [-118.1053, 34.1933], [-118.10528, 34.19327], [-118.10508, 34.1933], [-118.10505, 34.19327], [-118.10561, 34.19283], [-118.10575, 34.1928], [-118.10589, 34.19253], [-118.10561, 34.19205], [-118.10558, 34.19192], [-118.10588, 34.19227], [-118.10683, 34.19331]]]]} | Open Access 1 | Eaton Canyon Natural Area Park and Nature Center | https://www.ecnca.org/index.php | 32658 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 82.938 | Eaton Canyon Natural Area Park and Nature Ctr. | |
799 | 799 | 798 | {"type": "Polygon", "coordinates": [[[-120.62079, 34.9228], [-120.61833, 34.92572], [-120.61614, 34.92667], [-120.61284, 34.92723], [-120.61082, 34.9285], [-120.60801, 34.92843], [-120.60579, 34.92913], [-120.60323, 34.92864], [-120.6034, 34.92007], [-120.60505, 34.91213], [-120.60601, 34.91131], [-120.61581, 34.91629], [-120.61728, 34.9197], [-120.62079, 34.9228]]]} | Open Access 1 | Guadalupe Dunes County Park | https://www.countyofsb.org/parks/parks02.aspx?id=13422 | 11773 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 505.538 | Guadalupe Dunes County Park | |
11638 | 11638 | 11637 | {"type": "Polygon", "coordinates": [[[-120.65717, 34.9522], [-120.65432, 34.95978], [-120.6519, 34.96646], [-120.65078, 34.97051], [-120.64878, 34.96944], [-120.64913, 34.96876], [-120.64889, 34.96826], [-120.64936, 34.96771], [-120.64677, 34.96656], [-120.64661, 34.96441], [-120.64568, 34.96166], [-120.64502, 34.96078], [-120.64471, 34.96016], [-120.64403, 34.95965], [-120.64345, 34.95932], [-120.64321, 34.9592], [-120.64235, 34.95893], [-120.64056, 34.95849], [-120.64021, 34.95863], [-120.63876, 34.95838], [-120.63834, 34.95875], [-120.6378, 34.9583], [-120.63663, 34.95771], [-120.63662, 34.95772], [-120.63659, 34.95879], [-120.63347, 34.95834], [-120.63251, 34.95793], [-120.63144, 34.95778], [-120.63125, 34.95708], [-120.6326, 34.95643], [-120.6336, 34.9566], [-120.63361, 34.95605], [-120.63038, 34.95437], [-120.63021, 34.95408], [-120.63031, 34.95324], [-120.62935, 34.95269], [-120.62838, 34.95091], [-120.6414, 34.95112], [-120.64139, 34.95191], [-120.65717, 34.9522]]]} | Open Access 1 | Guadalupe-Nipomo Dunes Preserve Forest | https://www.countyofsb.org/parks/parks02.aspx?id=13422 | 28194 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 611.488 | Guadalupe-Nipomo Dunes Preserve Forest | |
438 | 438 | 437 | {"type": "Polygon", "coordinates": [[[-120.42216, 34.84972], [-120.42192, 34.85046], [-120.42153, 34.85093], [-120.42161, 34.85109], [-120.42151, 34.85123], [-120.42113, 34.8513], [-120.42097, 34.852], [-120.4202, 34.85238], [-120.42045, 34.85272], [-120.42027, 34.85283], [-120.41992, 34.85247], [-120.41927, 34.85288], [-120.41925, 34.85304], [-120.41877, 34.85301], [-120.4185, 34.85298], [-120.41851, 34.85295], [-120.41877, 34.85272], [-120.41876, 34.85243], [-120.41873, 34.85237], [-120.41785, 34.85177], [-120.41792, 34.8515], [-120.41769, 34.85134], [-120.41774, 34.85092], [-120.4174, 34.85061], [-120.41773, 34.85046], [-120.41787, 34.85016], [-120.41891, 34.85012], [-120.41919, 34.84959], [-120.4196, 34.84947], [-120.42048, 34.84963], [-120.42153, 34.84925], [-120.422, 34.8495], [-120.42216, 34.84972]]]} | Open Access 1 | Orcutt Community Park | https://www.countyofsb.org/parks/asset.c/581 | 33496 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 26.029 | Orcutt Community Park | |
13177 | 13177 | 13176 | {"type": "Polygon", "coordinates": [[[-121.3766, 36.81988], [-121.37638, 36.82034], [-121.37622, 36.82054], [-121.37608, 36.82049], [-121.37582, 36.82042], [-121.37567, 36.82035], [-121.37558, 36.82029], [-121.3755, 36.82022], [-121.37567, 36.81997], [-121.37564, 36.81989], [-121.37512, 36.81967], [-121.37525, 36.81968], [-121.37551, 36.81974], [-121.37565, 36.81975], [-121.37582, 36.81974], [-121.37603, 36.8197], [-121.37607, 36.81971], [-121.37618, 36.81982], [-121.37629, 36.81987], [-121.37644, 36.8199], [-121.3766, 36.81988]]]} | Open Access 1 | Oak Creek Park | https://www.cosb.us/business/county-business-parks/ | 33389 | 317 | San Benito, County of 193 | County 3 | County Agency 3 | http://sbcparks.org/ | County 3 | 1.482 | Oak Creek Park | |
13181 | 13181 | 13180 | {"type": "Polygon", "coordinates": [[[-121.37307, 36.8188], [-121.3728, 36.81893], [-121.37252, 36.81851], [-121.37224, 36.81845], [-121.37191, 36.81815], [-121.37183, 36.81815], [-121.37167, 36.81833], [-121.37142, 36.81828], [-121.37143, 36.818], [-121.37109, 36.81795], [-121.37108, 36.81783], [-121.37099, 36.81742], [-121.37099, 36.81731], [-121.37102, 36.81718], [-121.37174, 36.8172], [-121.37177, 36.81733], [-121.37186, 36.81759], [-121.37183, 36.81769], [-121.37186, 36.81777], [-121.37191, 36.81781], [-121.37197, 36.81783], [-121.37222, 36.81815], [-121.37241, 36.81825], [-121.37259, 36.8182], [-121.37307, 36.8188]]]} | Open Access 1 | Quail Hollow Park | https://www.cosb.us/business/county-business-parks/ | 33390 | 317 | San Benito, County of 193 | County 3 | County Agency 3 | http://sbcparks.org/ | County 3 | 2.767 | Quail Hollow Park | |
13183 | 13183 | 13182 | {"type": "Polygon", "coordinates": [[[-121.31264, 36.77495], [-121.31177, 36.77534], [-121.31044, 36.77535], [-121.31017, 36.77441], [-121.30945, 36.77355], [-121.30916, 36.77298], [-121.30903, 36.77276], [-121.3088, 36.77156], [-121.31091, 36.77051], [-121.31165, 36.7714], [-121.31178, 36.77174], [-121.31197, 36.77188], [-121.31214, 36.77188], [-121.31264, 36.77495]]]} | Open Access 1 | San Benito County Historical and Recreational Park | https://www.cosb.us/business/county-business-parks/ | 33391 | 317 | San Benito, County of 193 | County 3 | County Agency 3 | http://sbcparks.org/ | County 3 | 29.721 | San Benito County Historical and Recreational Park | |
1000 | 1000 | 999 | {"type": "Polygon", "coordinates": [[[-117.53184, 33.83651], [-117.52781, 33.83658], [-117.52781, 33.83602], [-117.52859, 33.836], [-117.52865, 33.83597], [-117.52865, 33.83594], [-117.52861, 33.83541], [-117.52852, 33.83513], [-117.52837, 33.83487], [-117.52794, 33.83501], [-117.52726, 33.83357], [-117.52752, 33.83343], [-117.52761, 33.83344], [-117.52777, 33.83335], [-117.5278, 33.83328], [-117.52925, 33.83254], [-117.53, 33.83352], [-117.53166, 33.83607], [-117.53184, 33.83651]]]} | Open Access 1 | El Cerrito Sports Park | https://www.coronaca.gov/Home/Components/FacilityDirectory/FacilityDirectory/95/580 | 33598 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 26.336 | El Cerrito Sports Park | |
13304 | 13304 | 13303 | {"type": "Polygon", "coordinates": [[[-122.54604, 39.88145], [-122.5458, 39.88281], [-122.54366, 39.88282], [-122.54397, 39.88098], [-122.54604, 39.88145]]]} | Open Access 1 | Simpson-Finnell Park | https://www.co.tehama.ca.us/simpson-finnell-park | 33429 | 367 | Tehama, County of 574 | County 3 | County Agency 3 | http://www.co.tehama.ca.us/dep-parks | County 3 | 8.048 | Simpson-Finnell Park | |
11803 | 11803 | 11802 | {"type": "Polygon", "coordinates": [[[-121.63358, 39.27281], [-121.63254, 39.27519], [-121.63254, 39.27536], [-121.6327, 39.27598], [-121.63105, 39.27599], [-121.63025, 39.27499], [-121.63004, 39.27326], [-121.63182, 39.27344], [-121.63195, 39.27327], [-121.63234, 39.27301], [-121.63264, 39.27265], [-121.63358, 39.27281]]]} | Open Access 1 | Live Oak Park and Recreation Area | https://www.co.sutter.ca.us/doc/living/entertainment/recreation/pw_live_oak_park | 28424 | 366 | Sutter, County of 1083 | County 3 | County Agency 3 | http://www.co.sutter.ca.us/ | County 3 | 17.331 | Live Oak Park and Rec. Area | |
14005 | 14005 | 14004 | {"type": "Polygon", "coordinates": [[[-115.69029, 32.78595], [-115.68677, 32.78484], [-115.68075, 32.78206], [-115.68075, 32.78136], [-115.68028, 32.78091], [-115.67977, 32.7807], [-115.67682, 32.77663], [-115.67557, 32.77482], [-115.67435, 32.77444], [-115.67435, 32.77433], [-115.67607, 32.77424], [-115.67688, 32.77433], [-115.67741, 32.77427], [-115.68059, 32.77846], [-115.68065, 32.77892], [-115.68081, 32.77894], [-115.6808, 32.77953], [-115.68244, 32.77946], [-115.69028, 32.77921], [-115.69029, 32.78595]], [[-115.68079, 32.78029], [-115.68077, 32.78029], [-115.68076, 32.78077], [-115.68078, 32.78079], [-115.68079, 32.78029]]]} | Open Access 1 | Sunbeam Lake Park | https://www.co.imperial.ca.us/publicwork/index.asp?fileinc=parksunbeam | 32576 | 302 | Imperial, County of 345 | County 3 | County Agency 3 | http://www.icpds.com/?pid=1048 | County 3 | 154.407 | Sunbeam Lake 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]);