superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
15,638 rows sorted by rowid descending
This data as json, copyable, CSV (advanced)
MNG_AG_TYP >30
- City Agency 6,073
- County Agency 635
- Recreation/Parks District 593
- State Agency 371
- Non Profit - Land Trust 226
- Federal Agency 156
- Community Services District 128
- Home Owners Association 100
- Open Space District 90
- County Agency - Parks 85
- Water District 73
- Flood District 45
- Cemetery District 43
- Non Profit - Conservation 43
- School District 25
- Non Profit - Other 21
- County Agency - Other 17
- Port/Harbor District 14
- Irrigation District 12
- Special District - Other 10
- Commercial 5
- Sanitation District 5
- Joint Powers Authority 4
- Conservation District 3
- Transportation Agency 3
- Non Profit - Cemetery District 2
- Mitigation Bank 2
- Airport District 1
- Other 1
- Non Profit - Education 1
- …
MNG_AGENCY >30
- Los Angeles, City of 209
- San Jose, City of 184
- San Francisco, City and County of 169
- Sacramento, City of 155
- California Department of Fish and Wildlife 144
- San Diego, City of 120
- California Department of Parks and Recreation 119
- Oakland, City of 92
- Los Angeles, County of 77
- Irvine, City of 70
- Mountains Recreation and Conservation Authority 67
- Modesto, City of 64
- Consumnes Community Services District 62
- Santa Rosa, City of 61
- Valley-Wide Recreation and Park District 60
- Long Beach, City of 59
- Tracy, City of 57
- Hayward Area Recreation and Park District 55
- Stockton, City of 54
- Orange, County of 53
- Butte, County of 52
- Poway, City of 50
- Roseville, City of 49
- Santa Barbara, County of 48
- Huntington Beach, City of 48
- Fresno, City of 47
- United States National Park Service 47
- Anaheim, City of 45
- East Bay Regional Park District 45
- Lake, County of 45
- …
ACCESS_TYP 4
- Open Access 7,931
- Restricted Access 464
- No Public Access 303
- Unknown Access 90
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8788 | 8788 | 8787 | {"type": "Polygon", "coordinates": [[[-120.06706, 36.96913], [-120.06617, 36.96914], [-120.06554, 36.96905], [-120.0649, 36.9689], [-120.06379, 36.96856], [-120.06329, 36.96848], [-120.06328, 36.96845], [-120.06372, 36.9684], [-120.06391, 36.96842], [-120.06572, 36.96897], [-120.06659, 36.96907], [-120.06685, 36.969], [-120.06701, 36.96907], [-120.06706, 36.96913]]]} | Open Access 1 | Riverside Park | 24455 | 1192 | Madera, City of 456 | City 2 | City Agency 2 | http://www.cityofmadera.org/ | City 2 | 1.216 | Riverside Park | ||
8787 | 8787 | 8786 | {"type": "Polygon", "coordinates": [[[-118.42497, 35.75299], [-118.42497, 35.75303], [-118.42462, 35.75326], [-118.42442, 35.75341], [-118.42419, 35.75362], [-118.42398, 35.75384], [-118.42373, 35.75418], [-118.42356, 35.75449], [-118.42343, 35.75481], [-118.42332, 35.7552], [-118.42327, 35.75522], [-118.42306, 35.75522], [-118.42305, 35.75504], [-118.42321, 35.75489], [-118.42336, 35.7547], [-118.42351, 35.75446], [-118.42365, 35.75417], [-118.42384, 35.75362], [-118.42392, 35.75343], [-118.424, 35.75312], [-118.42397, 35.7527], [-118.42383, 35.75239], [-118.4238, 35.7521], [-118.42369, 35.75164], [-118.42424, 35.75165], [-118.42452, 35.75211], [-118.42497, 35.75299]]]} | Open Access 1 | Riverside Park | 24454 | 303 | Kern, County of 393 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 4.265 | Riverside Park | ||
8786 | 8786 | 8785 | {"type": "Polygon", "coordinates": [[[-121.54977, 38.99138], [-121.54945, 38.99229], [-121.54933, 38.99267], [-121.54925, 38.99298], [-121.54919, 38.99307], [-121.54847, 38.99306], [-121.5485, 38.99143], [-121.54881, 38.99128], [-121.54944, 38.99082], [-121.54963, 38.99098], [-121.54972, 38.9912], [-121.54977, 38.99138]]]} | Open Access 1 | Riverside Meadows Park | 24451 | 2101 | Olivehurst Public Utility District 548 | Special District 4 | Water District 13 | http://www.opud.org/ | Special District 4 | 4.782 | Riverside Meadows Park | ||
8785 | 8785 | 8784 | {"type": "Polygon", "coordinates": [[[-116.80135, 33.49175], [-116.79698, 33.49202], [-116.79687, 33.48835], [-116.80122, 33.4881], [-116.80135, 33.49175]]]} | No Public Access 3 | Riverside County Habitat Conservation Agency 1 | 24445 | 2122 | Riverside County Habitat Conservation Agency 562 | Special District 4 | Open Space District 6 | http://www.skrplan.org/ | Special District 4 | 40.691 | Riverside County Habitat Conservation Agency 1 | ||
8784 | 8784 | 8783 | {"type": "Polygon", "coordinates": [[[-118.853, 35.42737], [-118.85233, 35.4275], [-118.85224, 35.42756], [-118.85217, 35.42753], [-118.85184, 35.4276], [-118.85182, 35.42812], [-118.85173, 35.42816], [-118.85168, 35.42824], [-118.85158, 35.42823], [-118.85154, 35.4284], [-118.85135, 35.42839], [-118.85126, 35.42841], [-118.85118, 35.42845], [-118.85088, 35.42875], [-118.85052, 35.42852], [-118.85038, 35.42865], [-118.84965, 35.42802], [-118.84831, 35.42726], [-118.85175, 35.4272], [-118.85169, 35.42722], [-118.85164, 35.42725], [-118.8516, 35.42729], [-118.85159, 35.42735], [-118.85161, 35.4274], [-118.85165, 35.42744], [-118.85176, 35.42748], [-118.85185, 35.42746], [-118.85193, 35.42738], [-118.85197, 35.42736], [-118.85261, 35.42736], [-118.85275, 35.4273], [-118.85283, 35.42719], [-118.853, 35.42718], [-118.853, 35.42737]]]} | Open Access 1 | Rivers Edge Park | 24444 | 1019 | Bakersfield, City of 244 | City 2 | City Agency 2 | http://www.bakersfieldcity.us/recreation/ | City 2 | 8.207 | Rivers Edge Park | ||
8783 | 8783 | 8782 | {"type": "MultiPolygon", "coordinates": [[[[-122.99606, 38.50153], [-122.99573, 38.50173], [-122.99551, 38.50189], [-122.99444, 38.50252], [-122.99426, 38.50269], [-122.99358, 38.50215], [-122.99512, 38.50083], [-122.99561, 38.50114], [-122.99562, 38.50132], [-122.99606, 38.50153]]], [[[-122.99562, 38.5004], [-122.99561, 38.50099], [-122.99561, 38.50099], [-122.99523, 38.50073], [-122.99562, 38.5004]]]]} | No Public Access 3 | Riverkeeper Park | 24442 | 3132 | Russian Riverkeeper 983 | Non Profit 6 | Non Profit - Conservation 12 | http://www.russianriverkeeper.org/ | Non Governmental Organization 10 | 5.046 | Riverkeeper Park | ||
8782 | 8782 | 8781 | {"type": "Polygon", "coordinates": [[[-122.38162, 40.59099], [-122.38032, 40.59104], [-122.3796, 40.59113], [-122.37875, 40.59131], [-122.37863, 40.59074], [-122.3787, 40.59061], [-122.37892, 40.59067], [-122.3791, 40.59069], [-122.37947, 40.59068], [-122.37974, 40.59065], [-122.37984, 40.59073], [-122.38016, 40.59078], [-122.38062, 40.59073], [-122.3811, 40.59081], [-122.38162, 40.59082], [-122.38162, 40.59099]]]} | Open Access 1 | Riverfront Park | 24441 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 2.462 | Riverfront Park | ||
8781 | 8781 | 8780 | {"type": "Polygon", "coordinates": [[[-117.81994, 33.85368], [-117.8184, 33.85415], [-117.81795, 33.85199], [-117.81887, 33.85177], [-117.8195, 33.85168], [-117.81994, 33.85368]]]} | Open Access 1 | Riverdale Park | 24440 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 8.668 | Riverdale Park | ||
8780 | 8780 | 8779 | {"type": "Polygon", "coordinates": [[[-121.03961, 37.61249], [-121.03853, 37.61234], [-121.03855, 37.61167], [-121.03939, 37.61135], [-121.03959, 37.61164], [-121.03961, 37.61249]]]} | Open Access 1 | Riverdale Park | 24439 | 329 | Stanislaus, County of 497 | County 3 | County Agency 3 | http://www.stancounty.com/er/parks/ | County 3 | 2.32 | Riverdale Park | ||
8779 | 8779 | 8778 | {"type": "Polygon", "coordinates": [[[-122.35486, 40.54442], [-122.35483, 40.5452], [-122.35479, 40.5453], [-122.35479, 40.54536], [-122.35367, 40.54535], [-122.35324, 40.54401], [-122.35446, 40.54404], [-122.35438, 40.54437], [-122.35486, 40.54442]]]} | Open Access 1 | Rivercrest Park | 24438 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 3.885 | Rivercrest Park | ||
8778 | 8778 | 8777 | {"type": "Polygon", "coordinates": [[[-117.19226, 34.07018], [-117.19224, 34.07362], [-117.19126, 34.07361], [-117.19128, 34.07017], [-117.19226, 34.07018]]]} | Open Access 1 | Texonia Park | 26274 | 1269 | Redlands, City of 99 | City 2 | City Agency 2 | http://www.cityofredlands.org/ | City 2 | 8.527 | Texonia Park | ||
8777 | 8777 | 8776 | {"type": "Polygon", "coordinates": [[[-119.90601, 36.84991], [-119.90514, 36.85098], [-119.90334, 36.8516], [-119.89998, 36.85175], [-119.8968, 36.85271], [-119.8963, 36.85226], [-119.89313, 36.85186], [-119.89311, 36.85193], [-119.89311, 36.85227], [-119.89279, 36.85211], [-119.8925, 36.852], [-119.89239, 36.85197], [-119.89231, 36.85193], [-119.89166, 36.85179], [-119.89119, 36.85175], [-119.89085, 36.85175], [-119.89017, 36.85181], [-119.88985, 36.85188], [-119.88952, 36.85198], [-119.88916, 36.85211], [-119.88936, 36.85127], [-119.88934, 36.85125], [-119.88939, 36.851], [-119.89048, 36.85117], [-119.89102, 36.85119], [-119.89182, 36.85127], [-119.89197, 36.85126], [-119.89206, 36.8513], [-119.89216, 36.8513], [-119.89237, 36.85134], [-119.8925, 36.85132], [-119.89259, 36.85135], [-119.89281, 36.85138], [-119.893, 36.85138], [-119.8931, 36.85136], [-119.89312, 36.85138], [-119.89352, 36.85142], [-119.8942, 36.85139], [-119.89439, 36.85135], [-119.89457, 36.85124], [-119.89461, 36.85124], [-119.89479, 36.85133], [-119.89496, 36.85136], [-119.89599, 36.85117], [-119.89622, 36.8511], [-119.89647, 36.85107], [-119.89672, 36.851], [-119.8968, 36.85091], [-119.89685, 36.85089], [-119.89709, 36.85087], [-119.89718, 36.85083], [-119.89729, 36.85082], [-119.8974, 36.85077], [-119.89761, 36.85052], [-119.89794, 36.85047], [-119.89817, 36.85016], [-119.89815, 36.85013], [-119.89822, 36.85009], [-119.89888, 36.84987], [-119.89952, 36.84974], [-119.89995, 36.84962], [-119.90022, 36.84965], [-119.90068, 36.84957], [-119.90181, 36.84954], [-119.90254, 36.84948], [-119.90325, 36.84925], [-119.90334, 36.84931], [-119.90358, 36.84923], [-119.90444, 36.84977], [-119.90533, 36.84896], [-119.90567, 36.84919], [-119.90539, 36.8495], [-119.90601, 36.84991]]]} | Open Access 1 | Riverbottom Park | 24437 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 57.831 | Riverbottom Park | ||
8776 | 8776 | 8775 | {"type": "Polygon", "coordinates": [[[-119.29281, 36.35312], [-119.2928, 36.35315], [-119.29277, 36.35317], [-119.29255, 36.35324], [-119.29236, 36.35334], [-119.2919, 36.35373], [-119.29154, 36.35395], [-119.29133, 36.35368], [-119.29089, 36.35286], [-119.29103, 36.35281], [-119.29244, 36.35212], [-119.29246, 36.35235], [-119.29253, 36.35258], [-119.29261, 36.35278], [-119.29281, 36.35312]]]} | Open Access 1 | Riverbend Park | 24436 | 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.482 | Riverbend Park | ||
8775 | 8775 | 8774 | {"type": "Polygon", "coordinates": [[[-120.96209, 37.72901], [-120.96038, 37.72734], [-120.96038, 37.72548], [-120.96205, 37.72549], [-120.96209, 37.72901]]]} | Open Access 1 | Riverbank Sports Complex | 24435 | 1278 | Riverbank, City of 40 | City 2 | City Agency 2 | http://www.riverbank.org/Depts/Recreation/default.aspx | City 2 | 10.965 | Riverbank Sports Complex | ||
8774 | 8774 | 8773 | {"type": "Polygon", "coordinates": [[[-118.09908, 33.96287], [-118.09833, 33.9645], [-118.09521, 33.96352], [-118.09589, 33.96184], [-118.09908, 33.96287]]]} | Open Access 1 | Rivera Park | 24433 | 1250 | Pico Rivera, City of 367 | City 2 | City Agency 2 | http://www.ci.pico-rivera.ca.us/depts/parks/default.asp | City 2 | 15.037 | Rivera Park | ||
8773 | 8773 | 8772 | {"type": "MultiPolygon", "coordinates": [[[[-117.8957, 34.16384], [-117.89546, 34.1639], [-117.8952, 34.16394], [-117.89433, 34.16395], [-117.89319, 34.16241], [-117.89005, 34.16241], [-117.89005, 34.16128], [-117.89046, 34.16131], [-117.89059, 34.16129], [-117.89099, 34.16119], [-117.89118, 34.16117], [-117.89138, 34.16116], [-117.8917, 34.16119], [-117.89194, 34.16124], [-117.89227, 34.16133], [-117.89254, 34.16143], [-117.89292, 34.16192], [-117.89309, 34.16205], [-117.89327, 34.16213], [-117.89369, 34.16221], [-117.89395, 34.1623], [-117.89427, 34.16243], [-117.89453, 34.16259], [-117.8947, 34.16275], [-117.89484, 34.16291], [-117.89496, 34.16313], [-117.89504, 34.16336], [-117.89514, 34.16349], [-117.89525, 34.16359], [-117.89539, 34.16365], [-117.89552, 34.16376], [-117.8957, 34.16384]]], [[[-117.89687, 34.1626], [-117.89652, 34.16308], [-117.89636, 34.16321], [-117.89621, 34.16328], [-117.89607, 34.16332], [-117.89588, 34.16334], [-117.89572, 34.16332], [-117.89551, 34.16325], [-117.89533, 34.16313], [-117.89522, 34.163], [-117.89514, 34.16285], [-117.895, 34.16266], [-117.89489, 34.16254], [-117.89472, 34.1624], [-117.89463, 34.1624], [-117.89435, 34.16223], [-117.89405, 34.16211], [-117.89319, 34.1619], [-117.89315, 34.16185], [-117.89312, 34.16172], [-117.89306, 34.16161], [-117.89294, 34.16146], [-117.8928, 34.16136], [-117.89233, 34.16111], [-117.89207, 34.16104], [-117.89153, 34.16095], [-117.89136, 34.16094], [-117.89105, 34.16098], [-117.89046, 34.16113], [-117.8903, 34.16111], [-117.89028, 34.16113], [-117.89005, 34.16112], [-117.89005, 34.15966], [-117.89127, 34.15925], [-117.89224, 34.15922], [-117.89264, 34.15949], [-117.89276, 34.15977], [-117.89324, 34.15995], [-117.89368, 34.16002], [-117.89387, 34.16008], [-117.89416, 34.16019], [-117.89441, 34.16033], [-117.89459, 34.16034], [-117.8961, 34.16015], [-117.8966, 34.15994], [-117.8966, 34.16153], [-117.89595, 34.16238], [-117.89645, 34.16255], [-117.89687, 34.1626]]], [[[-117.89267, 34.16401], [-117.89244, 34.16404], [-117.89223, 34.16412], [-117.89222, 34.16349], [-117.89233, 34.1637], [-117.89267, 34.16401]]], [[[-117.89812, 34.16211], [-117.89703, 34.16364], [-117.89674, 34.16391], [-117.89656, 34.16403], [-117.89638, 34.16413], [-117.89617, 34.16422], [-117.89596, 34.16429], [-117.89459, 34.16456], [-117.89305, 34.16475], [-117.89289, 34.16481], [-117.89224, 34.1651], [-117.89224, 34.16445], [-117.89235, 34.16437], [-117.8925, 34.16431], [-117.89269, 34.16428], [-117.89515, 34.16422], [-117.89538, 34.16419], [-117.89558, 34.16415], [-117.8958, 34.16408], [-117.89598, 34.164], [-117.89628, 34.16382], [-117.89656, 34.1636], [-117.89669, 34.16347], [-117.89685, 34.16327], [-117.89704, 34.1629], [-117.89727, 34.16258], [-117.89736, 34.16249], [-117.8975, 34.16238], [-117.8977, 34.16226], [-117.89788, 34.16211], [-117.89812, 34.16211]]], [[[-117.89881, 34.16211], [-117.8988, 34.16512], [-117.89253, 34.16513], [-117.89299, 34.16492], [-117.89312, 34.16488], [-117.89462, 34.1647], [-117.89601, 34.16442], [-117.89642, 34.16427], [-117.89667, 34.16413], [-117.89686, 34.164], [-117.89703, 34.16386], [-117.89719, 34.16369], [-117.89831, 34.16211], [-117.89881, 34.16211]]]]} | Open Access 1 | River Wilderness Park | 24432 | 2177 | Watershed Conservation Authority 838 | Special District 4 | Conservation District 30 | https://www.wca.ca.gov/ | Special District 4 | 70.531 | River Wilderness Park | ||
8772 | 8772 | 8771 | {"type": "MultiPolygon", "coordinates": [[[[-116.37096, 33.91459], [-116.37095, 33.91825], [-116.36879, 33.91825], [-116.36881, 33.9146], [-116.37096, 33.91459]]], [[[-116.75455, 33.48392], [-116.75058, 33.48397], [-116.75043, 33.48095], [-116.75448, 33.4809], [-116.75455, 33.48392]]]]} | No Public Access 3 | Riverside County Habitat Conservation Agency 4 | 24448 | 2122 | Riverside County Habitat Conservation Agency 562 | Special District 4 | Open Space District 6 | http://www.skrplan.org/ | Special District 4 | 50.844 | Riverside County Habitat Conservation Agency 4 | ||
8771 | 8771 | 8770 | {"type": "Polygon", "coordinates": [[[-117.89406, 34.16397], [-117.89267, 34.16401], [-117.89233, 34.1637], [-117.89222, 34.16349], [-117.89221, 34.16311], [-117.89406, 34.16397]]]} | Open Access 1 | River Wilderness Park | 24431 | 1018 | Azusa, City of 143 | City 2 | City Agency 2 | http://www.ci.azusa.ca.us/index.aspx?NID=249 | City 2 | 1.846 | River Wilderness Park | ||
8770 | 8770 | 8769 | {"type": "Polygon", "coordinates": [[[-121.50983, 38.58131], [-121.50973, 38.58142], [-121.50949, 38.58136], [-121.50941, 38.58145], [-121.50934, 38.58159], [-121.50918, 38.58208], [-121.5089, 38.58266], [-121.50882, 38.58298], [-121.50878, 38.5833], [-121.50887, 38.58333], [-121.50822, 38.58674], [-121.50794, 38.58664], [-121.50743, 38.58653], [-121.50761, 38.58602], [-121.50791, 38.58377], [-121.50837, 38.58265], [-121.50889, 38.58161], [-121.50899, 38.58134], [-121.50917, 38.5811], [-121.50966, 38.58123], [-121.50983, 38.58131]]]} | Open Access 1 | River Walk Park | 24430 | 1376 | West Sacramento, City of 541 | City 2 | City Agency 2 | http://www.cityofwestsacramento.org/city/depts/pcs/default.asp | City 2 | 9.259 | River Walk Park | ||
8769 | 8769 | 8768 | {"type": "Polygon", "coordinates": [[[-119.73125, 36.98478], [-119.73073, 36.98528], [-119.72986, 36.98556], [-119.72892, 36.9862], [-119.72812, 36.98615], [-119.72732, 36.98671], [-119.72713, 36.98843], [-119.72603, 36.98869], [-119.72487, 36.99101], [-119.72383, 36.99097], [-119.72294, 36.99154], [-119.72257, 36.99189], [-119.72123, 36.99292], [-119.72037, 36.99324], [-119.71923, 36.99432], [-119.71902, 36.99486], [-119.71869, 36.99531], [-119.71453, 36.9918], [-119.71485, 36.99148], [-119.71495, 36.99127], [-119.71539, 36.99089], [-119.71615, 36.99035], [-119.71649, 36.99027], [-119.71675, 36.99029], [-119.71709, 36.99018], [-119.71734, 36.99008], [-119.71707, 36.99034], [-119.71691, 36.99053], [-119.71644, 36.99085], [-119.71607, 36.99103], [-119.716, 36.9911], [-119.71601, 36.99112], [-119.7161, 36.99111], [-119.71634, 36.99099], [-119.71667, 36.99078], [-119.71696, 36.99057], [-119.71715, 36.9904], [-119.71734, 36.99018], [-119.71756, 36.99005], [-119.71786, 36.98983], [-119.71812, 36.98976], [-119.71841, 36.98965], [-119.71879, 36.98943], [-119.71938, 36.98901], [-119.72004, 36.9887], [-119.72093, 36.98816], [-119.72121, 36.98794], [-119.72144, 36.98772], [-119.72232, 36.98703], [-119.72335, 36.98634], [-119.72393, 36.98604], [-119.7243, 36.98578], [-119.7243, 36.98575], [-119.72418, 36.98575], [-119.72431, 36.98567], [-119.72443, 36.98546], [-119.72464, 36.98524], [-119.72514, 36.98512], [-119.72539, 36.98496], [-119.72531, 36.98452], [-119.72543, 36.98436], [-119.72601, 36.98431], [-119.72649, 36.98423], [-119.7268, 36.98407], [-119.72708, 36.98388], [-119.72723, 36.98375], [-119.7277, 36.98344], [-119.72824, 36.98301], [-119.72864, 36.98276], [-119.72918, 36.98246], [-119.73125, 36.98478]], [[-119.72524, 36.98839], [-119.72525, 36.98841], [-119.72562, 36.98816], [-119.72573, 36.98802], [-119.72553, 36.98814], [-119.72524, 36.98839]]]} | Unknown Access 4 | River Vista | 24429 | 3069 | San Joaquin River Parkway and Conservation Trust 491 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.riverparkway.org | Non Governmental Organization 10 | 160.742 | River Vista |
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]);