superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
754 rows where ACCESS_TYP = 3 sorted by MNG_AG_ID descending
This data as json, copyable, CSV (advanced)
Suggested facets: MNG_AG_LEV
MNG_AGENCY >30
- California Department of Fish and Wildlife 75
- East Bay Regional Park District 41
- The Nature Conservancy 26
- Peninsula Open Space Trust 24
- Torrance, City of 20
- Natomas Basin Conservancy 20
- Santa Clara Valley Open Space Authority 17
- Midpeninsula Regional Open Space District 17
- Fresno Metropolitan Flood Control District 16
- California Department of Parks and Recreation 15
- San Diego, City of 14
- Endangered Habitats Conservancy 14
- San Diego, County of 14
- American River Conservancy 13
- Save Mount Diablo 13
- United States Fish and Wildlife Service 12
- Santa Clara County Parks and Recreation Dept., County of 12
- Los Angeles, City of 11
- Sonoma Land Trust 11
- Sonoma County Agricultural Preservation and Open Space District 11
- California Department of Water Resources 11
- Rocklin, City of 8
- Center for Natural Lands Management 7
- Napa County Regional Park and Open Space District 7
- Los Angeles - Department of Water and Power, City of 7
- Riverside County Habitat Conservation Agency 7
- Los Angeles County Flood Control District 6
- Elkhorn Slough Foundation 6
- Vallejo, City of 6
- Wilderness Land Trust 6
- …
MNG_AG_TYP 20
- Non Profit - Land Trust 169
- City Agency 155
- State Agency 124
- Recreation/Parks District 97
- Flood District 47
- Non Profit - Conservation 32
- Federal Agency 28
- Water District 27
- County Agency 26
- County Agency - Parks 17
- Open Space District 15
- Irrigation District 7
- County Agency - Other 3
- Home Owners Association 1
- Commercial 1
- Sanitation District 1
- Non Profit - Other 1
- Joint Powers Authority 1
- Other 1
- Mitigation Bank 1
LAYER 12 ✖
ACCESS_TYP 1
- No Public Access · 754 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13862 | 13862 | 13861 | {"type": "Polygon", "coordinates": [[[-117.31508, 33.26166], [-117.31432, 33.26259], [-117.31428, 33.26186], [-117.31404, 33.26172], [-117.31338, 33.26127], [-117.31266, 33.26131], [-117.31163, 33.26213], [-117.3132, 33.26337], [-117.31094, 33.26441], [-117.30968, 33.26347], [-117.30967, 33.26342], [-117.30855, 33.26259], [-117.30882, 33.2621], [-117.31085, 33.25891], [-117.31091, 33.25884], [-117.31117, 33.25856], [-117.31145, 33.25829], [-117.31228, 33.25764], [-117.31243, 33.25778], [-117.31258, 33.25768], [-117.31258, 33.25766], [-117.31243, 33.25752], [-117.3135, 33.25671], [-117.31355, 33.2567], [-117.31361, 33.25671], [-117.31372, 33.25681], [-117.31374, 33.25685], [-117.31374, 33.25691], [-117.31385, 33.25701], [-117.31403, 33.25689], [-117.3142, 33.25705], [-117.31396, 33.25709], [-117.31349, 33.26035], [-117.31401, 33.2604], [-117.31487, 33.26041], [-117.31508, 33.26166]]]} | No Public Access 3 | Foss Lake Preserve | 31414 | 7016 | Foss Lake Conservation LP 854 | Private 7 | Mitigation Bank 28 | Private 14 | 58.856 | Foss Lake Preserve | |||
14450 | 14450 | 14449 | {"type": "Polygon", "coordinates": [[[-119.76638, 36.87034], [-119.76629, 36.87046], [-119.76407, 36.8694], [-119.76326, 36.86964], [-119.76233, 36.87081], [-119.76208, 36.87074], [-119.7624, 36.87065], [-119.76252, 36.8705], [-119.7625, 36.87038], [-119.76256, 36.87037], [-119.76263, 36.87028], [-119.76271, 36.87026], [-119.7628, 36.87015], [-119.76278, 36.87009], [-119.76285, 36.87007], [-119.76291, 36.87001], [-119.76286, 36.86982], [-119.76309, 36.86977], [-119.76322, 36.86962], [-119.76332, 36.8696], [-119.76338, 36.86952], [-119.76353, 36.86947], [-119.76368, 36.86929], [-119.76359, 36.86895], [-119.76313, 36.86876], [-119.76329, 36.86858], [-119.76333, 36.86848], [-119.76336, 36.86837], [-119.76337, 36.8682], [-119.76329, 36.86781], [-119.76331, 36.86778], [-119.76346, 36.86777], [-119.76382, 36.86776], [-119.76417, 36.86781], [-119.76404, 36.86792], [-119.76406, 36.86877], [-119.7637, 36.86897], [-119.76375, 36.86923], [-119.7638, 36.86933], [-119.76389, 36.86937], [-119.76408, 36.86931], [-119.76411, 36.86937], [-119.76417, 36.8694], [-119.76435, 36.86935], [-119.76442, 36.86951], [-119.76448, 36.8695], [-119.76505, 36.86977], [-119.76509, 36.86975], [-119.76525, 36.86982], [-119.76524, 36.86986], [-119.76555, 36.87001], [-119.76558, 36.86999], [-119.76576, 36.87008], [-119.76574, 36.87013], [-119.76616, 36.87033], [-119.76638, 36.87034]]]} | No Public Access 3 | Floyd Boler Park | 33798 | 6130 | Park Fort Washington Association 988 | Private 7 | Home Owners Association 15 | http://parkfortwashington.com/ | Private 14 | 3.22 | Floyd Boler Park | ||
12606 | 12606 | 12605 | {"type": "Polygon", "coordinates": [[[-118.42222, 33.91688], [-118.4218, 33.91688], [-118.42178, 33.91679], [-118.42102, 33.91679], [-118.42102, 33.91638], [-118.42222, 33.91637], [-118.42222, 33.91688]]]} | No Public Access 3 | El Segundo Blue Butterfly Preserve | 29696 | 6107 | Chevron Corporation 1096 | Private 7 | Commercial 18 | http://www.chevron.com/ | Private 14 | 1.359 | El Segundo Blue Butterfly Preserve | ||
894 | 894 | 893 | {"type": "MultiPolygon", "coordinates": [[[[-118.125, 33.83134], [-118.12499, 33.83168], [-118.12426, 33.83168], [-118.12426, 33.83134], [-118.125, 33.83134]]], [[[-118.12601, 33.83154], [-118.12534, 33.83154], [-118.12534, 33.83085], [-118.12601, 33.83085], [-118.12601, 33.83154]]]]} | No Public Access 3 | Heartwell Park | 32767 | 6103 | Private Landowner 774 | Private 7 | Other 26 | Private 14 | 1.819 | Heartwell Park | |||
1163 | 1163 | 1162 | {"type": "MultiPolygon", "coordinates": [[[[-119.26584, 34.42384], [-119.26586, 34.42405], [-119.26582, 34.42427], [-119.26573, 34.42446], [-119.26558, 34.42465], [-119.26538, 34.4248], [-119.26502, 34.42499], [-119.26498, 34.42497], [-119.2645, 34.42516], [-119.26446, 34.42492], [-119.26534, 34.42437], [-119.26528, 34.4238], [-119.26584, 34.42384]]], [[[-119.26666, 34.4262], [-119.26564, 34.42624], [-119.26467, 34.42615], [-119.26454, 34.42539], [-119.26484, 34.42529], [-119.26511, 34.42517], [-119.26511, 34.42514], [-119.26552, 34.42492], [-119.26574, 34.42474], [-119.2659, 34.42454], [-119.26601, 34.42431], [-119.26605, 34.42407], [-119.26604, 34.42385], [-119.26662, 34.42389], [-119.2663, 34.42567], [-119.26666, 34.4262]]]]} | No Public Access 3 | San Antonio Creek Preserve | https://ovlc.org/preserves/san-antonio-creek/ | 32878 | 3296 | Ojai Valley Land Conservancy 1066 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.ovlc.org/ | Non Governmental Organization 10 | 8.728 | San Antonio Creek Preserve | |
1183 | 1183 | 1182 | {"type": "Polygon", "coordinates": [[[-119.31436, 34.38706], [-119.31235, 34.38703], [-119.31157, 34.38578], [-119.31128, 34.38522], [-119.31067, 34.38449], [-119.31045, 34.38389], [-119.3099, 34.38348], [-119.30887, 34.38284], [-119.30853, 34.3822], [-119.3089, 34.38079], [-119.3086, 34.38016], [-119.30753, 34.38024], [-119.30733, 34.37894], [-119.30725, 34.37807], [-119.3073, 34.37757], [-119.30747, 34.37645], [-119.30797, 34.37472], [-119.3125, 34.37439], [-119.31247, 34.37483], [-119.31198, 34.37484], [-119.31169, 34.37557], [-119.31082, 34.37622], [-119.31017, 34.37678], [-119.30997, 34.37738], [-119.30959, 34.37875], [-119.3091, 34.37858], [-119.30874, 34.37861], [-119.30877, 34.3796], [-119.30897, 34.38013], [-119.30919, 34.38061], [-119.30958, 34.38079], [-119.31036, 34.38172], [-119.31062, 34.38219], [-119.31092, 34.3826], [-119.31144, 34.38354], [-119.31191, 34.38413], [-119.31303, 34.38463], [-119.31361, 34.38529], [-119.314, 34.38582], [-119.31421, 34.38639], [-119.31433, 34.38682], [-119.31436, 34.38706]]]} | No Public Access 3 | Ventura River Steelhead Preserve | https://ovlc.org/preserves/ventura-river-steelhead-preserve/ | 32881 | 3296 | Ojai Valley Land Conservancy 1066 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.ovlc.org/ | Non Governmental Organization 10 | 68.919 | Ventura River Steelhead Preserve | 2011 |
13711 | 13711 | 13710 | {"type": "Polygon", "coordinates": [[[-117.76036, 33.6333], [-117.76003, 33.63457], [-117.75946, 33.63534], [-117.75959, 33.6366], [-117.75799, 33.63627], [-117.75777, 33.63505], [-117.75816, 33.6341], [-117.75829, 33.63301], [-117.75797, 33.63238], [-117.75941, 33.63136], [-117.7596, 33.63046], [-117.75905, 33.62932], [-117.75748, 33.62811], [-117.75568, 33.62795], [-117.75455, 33.62681], [-117.75287, 33.62703], [-117.75232, 33.62772], [-117.75125, 33.62755], [-117.75066, 33.62795], [-117.75052, 33.62877], [-117.75004, 33.62956], [-117.75011, 33.62997], [-117.75038, 33.63063], [-117.75039, 33.63152], [-117.75084, 33.63193], [-117.75088, 33.6331], [-117.75252, 33.63418], [-117.75221, 33.63484], [-117.75027, 33.63452], [-117.74936, 33.63421], [-117.7489, 33.63359], [-117.74782, 33.63285], [-117.74759, 33.63246], [-117.74669, 33.63253], [-117.74542, 33.63182], [-117.74514, 33.63121], [-117.74443, 33.63138], [-117.74373, 33.6308], [-117.74323, 33.63067], [-117.74136, 33.63063], [-117.74312, 33.6255], [-117.74522, 33.62259], [-117.74536, 33.6226], [-117.74545, 33.62255], [-117.7455, 33.6224], [-117.74551, 33.62219], [-117.74782, 33.61898], [-117.75092, 33.62051], [-117.75177, 33.62228], [-117.75343, 33.62336], [-117.75265, 33.62571], [-117.75348, 33.62665], [-117.75634, 33.62553], [-117.75672, 33.6262], [-117.75716, 33.62638], [-117.75796, 33.62735], [-117.75843, 33.62773], [-117.76007, 33.62971], [-117.76009, 33.62994], [-117.76033, 33.63064], [-117.75978, 33.63132], [-117.75978, 33.63168], [-117.75996, 33.63186], [-117.75977, 33.63245], [-117.76002, 33.63296], [-117.76036, 33.6333]]]} | No Public Access 3 | Veeh Creek | 31199 | 3257 | Irvine Ranch Conservancy 790 | Non Profit 6 | Non Profit - Conservation 12 | http://irconservancy.org/index.aspx | Non Governmental Organization 10 | 309.658 | Veeh Creek | ||
13691 | 13691 | 13690 | {"type": "Polygon", "coordinates": [[[-120.99082, 39.24618], [-120.99077, 39.24709], [-120.98585, 39.2472], [-120.98576, 39.2455], [-120.98578, 39.24365], [-120.98579, 39.24353], [-120.98584, 39.24339], [-120.98632, 39.24331], [-120.98708, 39.24324], [-120.98799, 39.24321], [-120.98865, 39.24474], [-120.9895, 39.24486], [-120.98917, 39.24559], [-120.98912, 39.24577], [-120.98998, 39.24626], [-120.99082, 39.24618]]]} | No Public Access 3 | Chaparrel Hill | 31188 | 3223 | Bear Yuba Land Trust 98 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.bylt.org/ | Non Governmental Organization 10 | 32.287 | Chaparrel Hill | ||
13693 | 13693 | 13692 | {"type": "Polygon", "coordinates": [[[-121.16534, 39.09693], [-121.1639, 39.09691], [-121.16249, 39.09685], [-121.16023, 39.09689], [-121.16003, 39.09468], [-121.1599, 39.09273], [-121.16025, 39.0927], [-121.16054, 39.09261], [-121.16131, 39.09228], [-121.16128, 39.09315], [-121.16439, 39.09302], [-121.1647, 39.09461], [-121.1648, 39.09492], [-121.16534, 39.09693]]]} | No Public Access 3 | Hannan Wildlife Preserve | 31189 | 3223 | Bear Yuba Land Trust 98 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.bylt.org/ | Non Governmental Organization 10 | 44.788 | Hannan Wildlife Preserve | ||
13694 | 13694 | 13693 | {"type": "Polygon", "coordinates": [[[-121.26128, 39.09372], [-121.26124, 39.0973], [-121.25657, 39.09722], [-121.2565, 39.10084], [-121.2562, 39.1064], [-121.25624, 39.10801], [-121.24725, 39.10806], [-121.24744, 39.10442], [-121.24499, 39.10438], [-121.23999, 39.10436], [-121.23992, 39.10273], [-121.23991, 39.10076], [-121.23885, 39.10075], [-121.23877, 39.09951], [-121.23874, 39.09723], [-121.23865, 39.09371], [-121.24319, 39.09366], [-121.24764, 39.09362], [-121.2579, 39.09366], [-121.26128, 39.09372]]]} | No Public Access 3 | Pioneer Dawson Nichols Ranch | 31190 | 3223 | Bear Yuba Land Trust 98 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.bylt.org/ | Non Governmental Organization 10 | 559.135 | Pioneer Dawson Nichols Ranch | ||
11614 | 11614 | 11613 | {"type": "Polygon", "coordinates": [[[-116.87605, 32.81198], [-116.87602, 32.81296], [-116.87303, 32.81508], [-116.87286, 32.81473], [-116.87304, 32.81449], [-116.87303, 32.81413], [-116.87289, 32.81331], [-116.87318, 32.8132], [-116.87335, 32.81308], [-116.87345, 32.81298], [-116.87353, 32.81288], [-116.87364, 32.81257], [-116.87401, 32.81237], [-116.87427, 32.81228], [-116.87453, 32.81222], [-116.87555, 32.8121], [-116.8758, 32.81205], [-116.87605, 32.81198]]]} | No Public Access 3 | La Cresta Hills Property | 30296 | 3208 | Endangered Habitats Conservancy 77 | Non Profit 6 | Non Profit - Conservation 12 | http://www.ehleague.org/EndangeredHabitatsConservancy.html | Non Governmental Organization 10 | 12.874 | La Cresta Hills Property | ||
11615 | 11615 | 11614 | {"type": "Polygon", "coordinates": [[[-116.86574, 32.79365], [-116.86293, 32.79372], [-116.86299, 32.79622], [-116.86104, 32.79623], [-116.861, 32.79604], [-116.85956, 32.79629], [-116.85947, 32.79388], [-116.85842, 32.79388], [-116.85828, 32.78993], [-116.86564, 32.79012], [-116.86574, 32.79365]]]} | No Public Access 3 | Michelson Property | 30297 | 3208 | Endangered Habitats Conservancy 77 | Non Profit 6 | Non Profit - Conservation 12 | http://www.ehleague.org/EndangeredHabitatsConservancy.html | Non Governmental Organization 10 | 91.621 | Michelson Property | ||
11616 | 11616 | 11615 | {"type": "Polygon", "coordinates": [[[-116.80824, 32.84466], [-116.80813, 32.84546], [-116.80736, 32.84567], [-116.80702, 32.84516], [-116.80705, 32.84466], [-116.80824, 32.84466]]]} | No Public Access 3 | Palmer Property | 30298 | 3208 | Endangered Habitats Conservancy 77 | Non Profit 6 | Non Profit - Conservation 12 | http://www.ehleague.org/EndangeredHabitatsConservancy.html | Non Governmental Organization 10 | 2.548 | Palmer Property | ||
11617 | 11617 | 11616 | {"type": "Polygon", "coordinates": [[[-116.89741, 32.80669], [-116.89677, 32.80744], [-116.89737, 32.80782], [-116.89656, 32.80874], [-116.8966, 32.80905], [-116.89615, 32.80913], [-116.89572, 32.80924], [-116.89504, 32.80952], [-116.894, 32.80809], [-116.89443, 32.80579], [-116.89458, 32.80576], [-116.89741, 32.80669]]]} | No Public Access 3 | Sarjay/La Cresta Property | 30299 | 3208 | Endangered Habitats Conservancy 77 | Non Profit 6 | Non Profit - Conservation 12 | http://www.ehleague.org/EndangeredHabitatsConservancy.html | Non Governmental Organization 10 | 21.557 | Sarjay/La Cresta Property | ||
13047 | 13047 | 13046 | {"type": "Polygon", "coordinates": [[[-116.88975, 32.80209], [-116.88488, 32.80571], [-116.88212, 32.80795], [-116.88059, 32.80794], [-116.88059, 32.80435], [-116.88488, 32.80431], [-116.88492, 32.80091], [-116.87626, 32.80088], [-116.87625, 32.79348], [-116.8719, 32.79355], [-116.87184, 32.7905], [-116.86734, 32.79039], [-116.86564, 32.79011], [-116.86281, 32.79004], [-116.86272, 32.78651], [-116.85814, 32.78609], [-116.8582, 32.78275], [-116.86725, 32.78347], [-116.86726, 32.78691], [-116.87625, 32.78778], [-116.8847, 32.78775], [-116.88471, 32.78835], [-116.88466, 32.80066], [-116.88468, 32.80066], [-116.88552, 32.79992], [-116.88576, 32.79977], [-116.88578, 32.79976], [-116.88582, 32.79981], [-116.88587, 32.79984], [-116.88598, 32.79984], [-116.88607, 32.79978], [-116.88609, 32.79973], [-116.88609, 32.79967], [-116.88613, 32.79963], [-116.88632, 32.79956], [-116.88652, 32.79952], [-116.88688, 32.79951], [-116.88723, 32.79957], [-116.88744, 32.79964], [-116.88765, 32.79975], [-116.88855, 32.80046], [-116.88872, 32.80056], [-116.8889, 32.80061], [-116.88896, 32.80068], [-116.88895, 32.80074], [-116.88882, 32.80092], [-116.88881, 32.801], [-116.88884, 32.80115], [-116.88889, 32.80129], [-116.88902, 32.80148], [-116.88925, 32.80165], [-116.88975, 32.80209]]]} | No Public Access 3 | South Crest Properties | 30301 | 3208 | Endangered Habitats Conservancy 77 | Non Profit 6 | Non Profit - Conservation 12 | http://www.ehleague.org/EndangeredHabitatsConservancy.html | Non Governmental Organization 10 | 586.646 | South Crest Properties | ||
13048 | 13048 | 13047 | {"type": "Polygon", "coordinates": [[[-116.86309, 32.80074], [-116.86305, 32.80446], [-116.86307, 32.8054], [-116.85868, 32.80542], [-116.85865, 32.80438], [-116.85442, 32.80443], [-116.85445, 32.80069], [-116.85863, 32.80069], [-116.86309, 32.80074]]]} | No Public Access 3 | Ulrich Property | 30302 | 3208 | Endangered Habitats Conservancy 77 | Non Profit 6 | Non Profit - Conservation 12 | http://www.ehleague.org/EndangeredHabitatsConservancy.html | Non Governmental Organization 10 | 93.321 | Ulrich Property | ||
13049 | 13049 | 13048 | {"type": "Polygon", "coordinates": [[[-116.89504, 32.80952], [-116.89448, 32.80974], [-116.89425, 32.80982], [-116.89392, 32.80989], [-116.89358, 32.80992], [-116.89315, 32.80992], [-116.89296, 32.80991], [-116.89182, 32.80963], [-116.89176, 32.80812], [-116.89229, 32.80568], [-116.89368, 32.8059], [-116.89443, 32.80579], [-116.894, 32.80809], [-116.89504, 32.80952]]]} | No Public Access 3 | Walker Priest/La Cresta Property | 30303 | 3208 | Endangered Habitats Conservancy 77 | Non Profit 6 | Non Profit - Conservation 12 | http://www.ehleague.org/EndangeredHabitatsConservancy.html | Non Governmental Organization 10 | 25.207 | Walker Priest/La Cresta Property | ||
13055 | 13055 | 13054 | {"type": "Polygon", "coordinates": [[[-117.19588, 33.05838], [-117.19584, 33.06309], [-117.19526, 33.06178], [-117.19481, 33.06132], [-117.19421, 33.06309], [-117.1936, 33.06368], [-117.19386, 33.06453], [-117.19343, 33.06485], [-117.19359, 33.06456], [-117.19334, 33.06394], [-117.19279, 33.06361], [-117.19236, 33.06362], [-117.19211, 33.06312], [-117.19045, 33.06383], [-117.18724, 33.06429], [-117.18724, 33.06097], [-117.19095, 33.0591], [-117.19135, 33.05875], [-117.19134, 33.05841], [-117.19588, 33.05838]]]} | No Public Access 3 | Bridges Property | 30290 | 3208 | Endangered Habitats Conservancy 77 | Non Profit 6 | Non Profit - Conservation 12 | http://www.ehleague.org/EndangeredHabitatsConservancy.html | Non Governmental Organization 10 | 96.351 | Bridges Property | ||
13056 | 13056 | 13055 | {"type": "Polygon", "coordinates": [[[-116.83922, 32.83545], [-116.83783, 32.8379], [-116.83786, 32.83795], [-116.83772, 32.83808], [-116.83739, 32.83845], [-116.83729, 32.83853], [-116.83713, 32.8386], [-116.83711, 32.83786], [-116.83671, 32.83746], [-116.82396, 32.83749], [-116.82414, 32.83012], [-116.83656, 32.83029], [-116.83668, 32.83206], [-116.83671, 32.8343], [-116.83922, 32.83545]]]} | No Public Access 3 | Gibson Property | 30291 | 3208 | Endangered Habitats Conservancy 77 | Non Profit 6 | Non Profit - Conservation 12 | http://www.ehleague.org/EndangeredHabitatsConservancy.html | Non Governmental Organization 10 | 251.411 | Gibson Property | ||
13059 | 13059 | 13058 | {"type": "Polygon", "coordinates": [[[-116.89021, 32.80935], [-116.89021, 32.80935], [-116.88892, 32.80921], [-116.88944, 32.80854], [-116.89012, 32.80849], [-116.89021, 32.80935]]]} | No Public Access 3 | Guyot/La Cresta Property | 30292 | 3208 | Endangered Habitats Conservancy 77 | Non Profit 6 | Non Profit - Conservation 12 | http://www.ehleague.org/EndangeredHabitatsConservancy.html | Non Governmental Organization 10 | 1.954 | Guyot/La Cresta Property |
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]);