units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,263 rows where AGNCY_TYP = 3 sorted by map descending
This data as json, copyable, CSV (advanced)
Suggested facets: MNG_AG_LEV, YR_EST
MNG_AGENCY >30
- Los Angeles, County of 155
- Santa Barbara, County of 117
- San Diego, County of 117
- Orange, County of 91
- Los Angeles - Department of Parks and Recreation, County of 60
- Lake, County of 56
- Sacramento, County of 55
- Butte, County of 53
- Santa Cruz, County of 51
- Kern, County of 47
- Monterey, County of 46
- El Dorado, County of 42
- Riverside, County of 38
- San Luis Obispo, County of 31
- Placer, County of 28
- Ventura, County of 24
- Stanislaus, County of 24
- San Joaquin, County of 21
- Yolo, County of 18
- Fresno, County of 17
- San Bernardino, County of 17
- Merced, County of 16
- Tulare, County of 15
- Humboldt, County of 12
- Mono, County of 7
- Tehama, County of 7
- Mendocino, County of 7
- Mariposa, County of 6
- Lassen, County of 6
- Imperial, County of 5
- …
DES_TP >30
- Local Park 687
- Local Other or Unknown 214
- Local Recreation Area 126
- Local Conservation Area 98
- Local Historic or Cultural Area 21
- National Forest 2
- National Monument or Landmark 2
- None 1
- State Conservation Area 1
- None 1
- National Recreation Area 1
- None 1
- Local Resource Management Area 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- …
MNG_AG_TYP 12
ACCESS_TYP 4
- Open Access 1,135
- Restricted Access 63
- Unknown Access 36
- No Public Access 29
Link | rowid | id | map ▲ | ACCESS_TYP | UNIT_ID | UNIT_NAME | SUID_NMA | AGNCY_ID | AGNCY_NAME | AGNCY_LEV | AGNCY_TYP | AGNCY_WEB | LAYER | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | PARK_URL | COUNTY | ACRES | LABEL_NAME | YR_EST | DES_TP | GAP_STS |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12235 | 12235 | 12234 | {"type": "Polygon", "coordinates": [[[-124.35159, 40.57354], [-124.35147, 40.57383], [-124.35065, 40.57366], [-124.35064, 40.57382], [-124.3494, 40.57383], [-124.34941, 40.57334], [-124.35087, 40.57312], [-124.35076, 40.57344], [-124.35159, 40.57354]]]} | Open Access 1 | 25766 | Centerville Beach | 17041 | 348 | Humboldt, County of 552 | County 3 | County Agency 3 | http://co.humboldt.ca.us/portal/living/county_parks/cpdefault.asp | County 3 | 348 | Humboldt, County of 545 | County 3 | County Agency 3 | Humboldt 45 | 2.34 | Centerville Beach | 0 | Local Park 2 | 4 | |
14293 | 14293 | 14292 | {"type": "Polygon", "coordinates": [[[-124.23254, 40.26773], [-124.2322, 40.26879], [-124.2322, 40.26882], [-124.23085, 40.26907], [-124.23083, 40.26963], [-124.22952, 40.26963], [-124.22932, 40.26935], [-124.22906, 40.2691], [-124.22878, 40.26892], [-124.22853, 40.2688], [-124.22824, 40.26872], [-124.22783, 40.26872], [-124.22766, 40.26887], [-124.22753, 40.26908], [-124.22742, 40.2694], [-124.22737, 40.26964], [-124.22653, 40.26964], [-124.22663, 40.26911], [-124.22669, 40.2689], [-124.22677, 40.26883], [-124.22695, 40.26874], [-124.22713, 40.26859], [-124.22729, 40.26842], [-124.22743, 40.26818], [-124.22764, 40.26797], [-124.22769, 40.2677], [-124.22769, 40.26741], [-124.22774, 40.26713], [-124.22776, 40.26676], [-124.22796, 40.2665], [-124.22833, 40.26628], [-124.22869, 40.2662], [-124.23016, 40.26621], [-124.23062, 40.26624], [-124.23162, 40.26643], [-124.23196, 40.26648], [-124.2323, 40.26669], [-124.23243, 40.2669], [-124.23252, 40.26726], [-124.23254, 40.26773]]]} | Open Access 1 | 44227 | Arthur W. Way Park | 15641 | 348 | Humboldt, County of 552 | County 3 | County Agency 3 | http://co.humboldt.ca.us/portal/living/county_parks/cpdefault.asp | County 3 | 348 | Humboldt, County of 545 | County 3 | County Agency 3 | Humboldt 45 | 33.368 | Arthur W. Way Park | 0 | Local Park 2 | 4 | |
2781 | 2781 | 2780 | {"type": "Polygon", "coordinates": [[[-124.21445, 40.77156], [-124.2134, 40.7727], [-124.21288, 40.77334], [-124.21022, 40.77332], [-124.21322, 40.77091], [-124.21357, 40.77045], [-124.21445, 40.77156]]]} | Open Access 1 | 21608 | Samoa Boat Ramp County Park | 30519 | 348 | Humboldt, County of 552 | County 3 | County Agency 3 | http://co.humboldt.ca.us/portal/living/county_parks/cpdefault.asp | County 3 | 348 | Humboldt, County of 545 | County 3 | County Agency 3 | Humboldt 45 | 12.044 | Samoa Boat Ramp County Park | 0 | Local Park 2 | 4 | |
3317 | 3317 | 3316 | {"type": "Polygon", "coordinates": [[[-124.1405, 40.9168], [-124.13948, 40.91945], [-124.13918, 40.92099], [-124.13862, 40.92235], [-124.13723, 40.92536], [-124.1361, 40.92829], [-124.13591, 40.92864], [-124.13588, 40.92955], [-124.1358, 40.93084], [-124.13559, 40.93173], [-124.13514, 40.93311], [-124.135, 40.93361], [-124.13459, 40.93468], [-124.13457, 40.93442], [-124.13005, 40.93436], [-124.13004, 40.93449], [-124.12991, 40.9342], [-124.12991, 40.93361], [-124.12993, 40.93336], [-124.12993, 40.93311], [-124.13003, 40.93278], [-124.13008, 40.93251], [-124.13002, 40.93218], [-124.12999, 40.93184], [-124.12972, 40.9315], [-124.12972, 40.9312], [-124.12966, 40.93091], [-124.12956, 40.92928], [-124.12961, 40.92819], [-124.12975, 40.92698], [-124.13003, 40.92698], [-124.12996, 40.9278], [-124.12996, 40.92822], [-124.13013, 40.92835], [-124.13075, 40.92864], [-124.13105, 40.92873], [-124.13128, 40.92879], [-124.13189, 40.92884], [-124.13227, 40.92893], [-124.13306, 40.9292], [-124.13326, 40.92933], [-124.13343, 40.92951], [-124.13347, 40.9294], [-124.13357, 40.92927], [-124.13412, 40.92958], [-124.13494, 40.9274], [-124.13702, 40.92214], [-124.1392, 40.91654], [-124.1405, 40.9168]]]} | Open Access 1 | 29674 | Mad River County Park | 21640 | 348 | Humboldt, County of 552 | County 3 | County Agency 3 | http://co.humboldt.ca.us/portal/living/county_parks/cpdefault.asp | County 3 | 348 | Humboldt, County of 545 | County 3 | County Agency 3 | Humboldt 45 | 116.352 | Mad River County Park | 0 | Local Park 2 | 4 | |
14918 | 14918 | 14917 | {"type": "Polygon", "coordinates": [[[-124.13354, 41.16255], [-124.1334, 41.16295], [-124.13222, 41.1637], [-124.13198, 41.1638], [-124.13182, 41.16385], [-124.13171, 41.16386], [-124.13145, 41.16382], [-124.13112, 41.16353], [-124.13059, 41.16298], [-124.13059, 41.16293], [-124.13063, 41.16285], [-124.13182, 41.16266], [-124.13212, 41.1625], [-124.13219, 41.16248], [-124.13249, 41.16255], [-124.13277, 41.16255], [-124.13325, 41.16251], [-124.13354, 41.16255]]]} | Open Access 1 | 45488 | Big Lagoon Park | 28318 | 348 | Humboldt, County of 552 | County 3 | County Agency 3 | http://co.humboldt.ca.us/portal/living/county_parks/cpdefault.asp | County 3 | 348 | Humboldt, County of 545 | County 3 | County Agency 3 | http://www.redwoods.info/showrecord.asp?id=1581 | Humboldt 45 | 5.585 | Big Lagoon Park | 0 | Local Park 2 | 4 |
3660 | 3660 | 3659 | {"type": "Polygon", "coordinates": [[[-124.05116, 40.7557], [-124.05103, 40.75618], [-124.04968, 40.75812], [-124.04942, 40.75783], [-124.0492, 40.75749], [-124.04903, 40.75714], [-124.04894, 40.75682], [-124.04935, 40.75622], [-124.04959, 40.75585], [-124.04975, 40.75546], [-124.04981, 40.75519], [-124.0507, 40.75519], [-124.05116, 40.7557]]]} | Open Access 1 | 46916 | Freshwater Park | 30520 | 348 | Humboldt, County of 552 | County 3 | County Agency 3 | http://co.humboldt.ca.us/portal/living/county_parks/cpdefault.asp | County 3 | 348 | Humboldt, County of 545 | County 3 | County Agency 3 | http://co.humboldt.ca.us/portal/living/county_parks/default.asp?parkID=FP | Humboldt 45 | 8.276 | Freshwater Park | 0 | Local Park 2 | 4 |
12588 | 12588 | 12587 | {"type": "Polygon", "coordinates": [[[-123.99351, 40.88039], [-123.99291, 40.88117], [-123.99172, 40.88062], [-123.99228, 40.87997], [-123.99351, 40.88039]]]} | Open Access 1 | 29310 | Gymkhana Field | 19579 | 348 | Humboldt, County of 552 | County 3 | County Agency 3 | http://co.humboldt.ca.us/portal/living/county_parks/cpdefault.asp | County 3 | 348 | Humboldt, County of 545 | County 3 | County Agency 3 | Humboldt 45 | 2.642 | Gymkhana Field | 0 | Local Recreation Area 3 | 4 | |
12250 | 12250 | 12249 | {"type": "Polygon", "coordinates": [[[-123.98647, 40.49898], [-123.98241, 40.49898], [-123.97733, 40.49932], [-123.9773, 40.4995], [-123.97607, 40.49958], [-123.97481, 40.49962], [-123.97472, 40.49964], [-123.97325, 40.4994], [-123.97166, 40.49876], [-123.97059, 40.49784], [-123.97027, 40.49748], [-123.96992, 40.49649], [-123.96947, 40.49486], [-123.96915, 40.49332], [-123.96936, 40.49281], [-123.96941, 40.49162], [-123.96928, 40.4893], [-123.96926, 40.48925], [-123.96865, 40.48863], [-123.9678, 40.48729], [-123.96424, 40.48356], [-123.9651, 40.48276], [-123.96537, 40.48234], [-123.96645, 40.48135], [-123.96749, 40.48067], [-123.96847, 40.4811], [-123.96835, 40.48206], [-123.96841, 40.48325], [-123.96842, 40.48452], [-123.96814, 40.48581], [-123.9682, 40.48695], [-123.96854, 40.48777], [-123.96878, 40.48789], [-123.97058, 40.48784], [-123.9724, 40.48728], [-123.97416, 40.48663], [-123.97595, 40.48657], [-123.97741, 40.48698], [-123.97872, 40.48785], [-123.97866, 40.48895], [-123.9771, 40.48895], [-123.97454, 40.48917], [-123.9726, 40.49005], [-123.97195, 40.49104], [-123.97175, 40.49173], [-123.97174, 40.49269], [-123.97193, 40.49387], [-123.9721, 40.49487], [-123.97299, 40.49584], [-123.974, 40.49668], [-123.97488, 40.49747], [-123.97611, 40.49812], [-123.97683, 40.4987], [-123.97767, 40.49848], [-123.97942, 40.49699], [-123.98167, 40.49559], [-123.98244, 40.49577], [-123.98336, 40.49653], [-123.98467, 40.49758], [-123.98544, 40.49776], [-123.98593, 40.49717], [-123.98641, 40.49678], [-123.98651, 40.49858], [-123.98647, 40.49898]]]} | Open Access 1 | 25767 | Van Duzen Park | 4515 | 348 | Humboldt, County of 552 | County 3 | County Agency 3 | http://co.humboldt.ca.us/portal/living/county_parks/cpdefault.asp | County 3 | 348 | Humboldt, County of 545 | County 3 | County Agency 3 | http://www.humboldtgov.org/1592/County-Parks-Facilities | Humboldt 45 | 212.133 | Van Duzen Park | 0 | Local Park 2 | 4 |
4758 | 4758 | 4757 | {"type": "Polygon", "coordinates": [[[-123.96182, 40.47601], [-123.96157, 40.47625], [-123.96067, 40.47662], [-123.95893, 40.478], [-123.95764, 40.47896], [-123.95666, 40.48], [-123.95668, 40.4767], [-123.95728, 40.4765], [-123.95804, 40.47633], [-123.9587, 40.47616], [-123.95966, 40.47599], [-123.96182, 40.47601]]]} | Restricted Access 2 | 46661 | Unnamed site - Humboldt, County of | 29996 | 348 | Humboldt, County of 552 | County 3 | County Agency 3 | http://co.humboldt.ca.us/portal/living/county_parks/cpdefault.asp | County 3 | 348 | Humboldt, County of 545 | County 3 | County Agency 3 | Humboldt 45 | 19.487 | 0 | Local Other or Unknown 14 | 4 | ||
14296 | 14296 | 14295 | {"type": "Polygon", "coordinates": [[[-123.79899, 40.09038], [-123.79816, 40.09043], [-123.79723, 40.09053], [-123.79654, 40.09066], [-123.79587, 40.09113], [-123.79544, 40.08958], [-123.79611, 40.08922], [-123.79669, 40.08901], [-123.79717, 40.08896], [-123.79765, 40.0889], [-123.79809, 40.08892], [-123.79853, 40.08904], [-123.79868, 40.08913], [-123.79883, 40.08954], [-123.79898, 40.09026], [-123.79899, 40.09038]]]} | Open Access 1 | 44230 | Tooby Memorial Park | 26400 | 348 | Humboldt, County of 552 | County 3 | County Agency 3 | http://co.humboldt.ca.us/portal/living/county_parks/cpdefault.asp | County 3 | 348 | Humboldt, County of 545 | County 3 | County Agency 3 | Humboldt 45 | 11.824 | Tooby Memorial Park | 0 | Local Park 2 | 4 | |
5212 | 5212 | 5211 | {"type": "Polygon", "coordinates": [[[-123.7721, 39.56968], [-123.77167, 39.5697], [-123.77145, 39.56927], [-123.771, 39.56816], [-123.77128, 39.56814], [-123.77136, 39.56839], [-123.77169, 39.56866], [-123.77174, 39.56906], [-123.77185, 39.56918], [-123.7721, 39.56968]]]} | Open Access 1 | 46783 | Coastal View Point | 30237 | 352 | Mendocino, County of 620 | County 3 | County Agency 3 | http://www.co.mendocino.ca.us/gs/parks/ | County 3 | 352 | Mendocino, County of 609 | County 3 | County Agency 3 | Mendocino 24 | 1.451 | Coastal View Point | None 422 | |||
3331 | 3331 | 3330 | {"type": "Polygon", "coordinates": [[[-123.5325, 38.79904], [-123.53139, 38.79955], [-123.53069, 38.799], [-123.53039, 38.79909], [-123.52955, 38.7979], [-123.52979, 38.79762], [-123.53088, 38.79674], [-123.5325, 38.79904]]]} | Open Access 1 | 29749 | Bower Park | 16307 | 352 | Mendocino, County of 620 | County 3 | County Agency 3 | http://www.co.mendocino.ca.us/gs/parks/ | County 3 | 352 | Mendocino, County of 609 | County 3 | County Agency 3 | Mendocino 24 | 9.995 | Bower Park | 0 | Local Park 2 | 4 | |
9402 | 9402 | 9401 | {"type": "Polygon", "coordinates": [[[-123.4405, 39.05938], [-123.44049, 39.05965], [-123.44041, 39.05975], [-123.44021, 39.05983], [-123.43997, 39.0601], [-123.43987, 39.06018], [-123.43962, 39.06044], [-123.4395, 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 | 49017 | Indian Creek County Park | 33715 | 352 | Mendocino, County of 620 | County 3 | County Agency 3 | http://www.co.mendocino.ca.us/gs/parks/ | County 3 | 352 | Mendocino, County of 609 | County 3 | County Agency 3 | https://www.mendocinocounty.org/government/cultural-services-agency/parks/indian-creek | Mendocino 24 | 17.437 | Indian Creek County Park | 1973 | Local Park 2 | 4 |
15380 | 15380 | 15379 | {"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 | 49011 | Faulkner Park | 33709 | 352 | Mendocino, County of 620 | County 3 | County Agency 3 | http://www.co.mendocino.ca.us/gs/parks/ | County 3 | 352 | Mendocino, County of 609 | County 3 | County Agency 3 | https://www.mendocinocounty.org/government/cultural-services-agency/parks/faulkner-park | Mendocino 24 | 40.36 | Faulkner Park | 1930 | Local Park 2 | 4 |
16421 | 16421 | 16420 | {"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.16309], [-123.23188, 39.16317], [-123.23167, 39.16327], [-123.23156, 39.1633], [-123.23146, 39.16329], [-123.2313, 39.16323], [-123.23112, 39.16307], [-123.2309, 39.16297], [-123.23075, 39.16294], [-123.23045, 39.16293], [-123.22986, 39.16285], [-123.22963, 39.16284], [-123.22955, 39.16285], [-123.2295, 39.16289], [-123.22933, 39.16306], [-123.22914, 39.16322], [-123.22907, 39.16326], [-123.22883, 39.16333], [-123.22863, 39.16335], [-123.22854, 39.16334], [-123.22842, 39.1633], [-123.22833, 39.16323], [-123.22782, 39.16311], [-123.2276, 39.16289], [-123.22709, 39.16268], [-123.22695, 39.1624], [-123.22695, 39.16232], [-123.22659, 39.16202], [-123.22625, 39.16195], [-123.22552, 39.16209], [-123.22492, 39.16238], [-123.22307, 39.16188], [-123.22318, 39.1616], [-123.22241, 39.16113], [-123.22206, 39.16105], [-123.22201, 39.16068], [-123.22693, 39.16069], [-123.22694, 39.16039], [-123.22886, 39.16039], [-123.23313, 39.16044], [-123.23328, 39.16378]]]} | Open Access 1 | 44977 | Low Gap Regional Park | 21551 | 352 | Mendocino, County of 620 | County 3 | County Agency 3 | http://www.co.mendocino.ca.us/gs/parks/ | County 3 | 352 | Mendocino, County of 609 | County 3 | County Agency 3 | https://www.mendocinocounty.org/government/cultural-services-agency/parks/low-gap-park | Mendocino 24 | 54.974 | Low Gap RP | 0 | Local Park 2 | 4 |
4186 | 4186 | 4185 | {"type": "Polygon", "coordinates": [[[-123.20725, 39.27079], [-123.2067, 39.27099], [-123.20635, 39.27092], [-123.20581, 39.27127], [-123.2057, 39.27079], [-123.20565, 39.27078], [-123.20548, 39.27018], [-123.20624, 39.27012], [-123.20625, 39.2701], [-123.20614, 39.26983], [-123.20541, 39.2699], [-123.2054, 39.26983], [-123.20702, 39.26969], [-123.20725, 39.27079]]]} | Open Access 1 | 48864 | Redwood Valley Lions Club Park | 33588 | 352 | Mendocino, County of 620 | County 3 | County Agency 3 | http://www.co.mendocino.ca.us/gs/parks/ | County 3 | 352 | Mendocino, County of 609 | County 3 | County Agency 3 | https://www.mendocinocounty.org/government/cultural-services-agency/parks/redwood-valley-lions-club-park | Mendocino 24 | 4.164 | Redwood Valley Lions Club Park | 0 | Local Park 2 | 4 |
12385 | 12385 | 12384 | {"type": "Polygon", "coordinates": [[[-123.18991, 40.55307], [-123.18963, 40.55319], [-123.18939, 40.55326], [-123.18812, 40.55342], [-123.18776, 40.55156], [-123.18815, 40.55155], [-123.18812, 40.55113], [-123.18843, 40.55105], [-123.1891, 40.5508], [-123.18984, 40.55061], [-123.18985, 40.55094], [-123.18974, 40.55099], [-123.18968, 40.55105], [-123.18964, 40.55113], [-123.18963, 40.5512], [-123.18971, 40.55165], [-123.18987, 40.55166], [-123.18991, 40.55307]]]} | Open Access 1 | 26524 | Hayfork Park | 19757 | 349 | Trinity, County of 1022 | County 3 | County Agency 3 | http://www.trinitycounty.org/ | County 3 | 349 | Trinity, County of 984 | County 3 | County Agency 3 | Trinity 46 | 10.43 | Hayfork Park | 0 | Local Park 2 | 4 | |
14982 | 14982 | 14981 | {"type": "Polygon", "coordinates": [[[-123.135, 39.12443], [-123.13499, 39.13171], [-123.12626, 39.13116], [-123.12633, 39.12775], [-123.12597, 39.1242], [-123.135, 39.12443]]]} | Open Access 1 | 45610 | Mill Creek Park | 28437 | 352 | Mendocino, County of 620 | County 3 | County Agency 3 | http://www.co.mendocino.ca.us/gs/parks/ | County 3 | 352 | Mendocino, County of 609 | County 3 | County Agency 3 | http://www.co.mendocino.ca.us/gs/parks/millcreek.htm | Mendocino 24 | 148.09 | Mill Creek Park | 0 | Local Park 2 | 4 |
13929 | 13929 | 13928 | {"type": "Polygon", "coordinates": [[[-123.04559, 40.72947], [-123.045, 40.72987], [-123.04219, 40.72785], [-123.04232, 40.72778], [-123.0429, 40.72771], [-123.04327, 40.72772], [-123.04361, 40.72778], [-123.04451, 40.7284], [-123.04485, 40.72886], [-123.04559, 40.72947]]]} | Open Access 1 | 36535 | Trinity holding 1 | 26540 | 349 | Trinity, County of 1022 | County 3 | County Agency 3 | http://www.trinitycounty.org/ | County 3 | 349 | Trinity, County of 984 | County 3 | County Agency 3 | Trinity 46 | 6.066 | Trinity holding 1 | 0 | Local Other or Unknown 14 | 4 | |
12156 | 12156 | 12155 | {"type": "Polygon", "coordinates": [[[-122.90651, 39.16174], [-122.90459, 39.16158], [-122.90524, 39.15939], [-122.9065, 39.15944], [-122.90653, 39.16111], [-122.90651, 39.16174]]]} | Open Access 1 | 25237 | Upper Lake County Park | 26729 | 345 | Lake, County of 279 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 345 | Lake, County of 275 | County 3 | County Agency 3 | Lake 40 | 8.593 | Upper Lake County Park | 0 | Local Park 2 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([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([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);