units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,219 rows where MNG_AG_TYP = 3
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Los Angeles, County of 60
- Butte, County of 45
- Orange, County of 38
- San Diego, County of 34
- Lake, County of 34
- El Dorado, County of 33
- Santa Barbara, County of 20
- Monterey, County of 17
- Placer, County of 9
- Fresno, County of 7
- San Bernardino, County of 7
- Kern, County of 7
- Humboldt, County of 7
- Riverside, County of 6
- San Joaquin, County of 6
- Sacramento, County of 5
- Lassen, County of 5
- San Luis Obispo, County of 4
- Ventura, County of 4
- Stanislaus, County of 3
- Mendocino, County of 3
- Contra Costa, County of 3
- Santa Cruz, County of 2
- Tulare, County of 2
- Merced, County of 2
- Yolo, County of 2
- Tehama, County of 2
- Trinity, County of 2
- Sutter, County of 2
- Calaveras, County of 2
- …
DES_TP 22
- Local Park 171
- Local Other or Unknown 124
- Local Recreation Area 55
- Local Conservation Area 18
- Local Historic or Cultural Area 1
- National Recreation Area 1
- National Monument or Landmark 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
ACCESS_TYP 4
MNG_AG_TYP 1
- County Agency · 386 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12111 | 12111 | 12110 | {"type": "Polygon", "coordinates": [[[-119.14885, 34.28641], [-119.14759, 34.28717], [-119.14695, 34.28643], [-119.14821, 34.28567], [-119.14885, 34.28641]]]} | Open Access 1 | 25020 | Saticoy Park | 25166 | 331 | Ventura, County of 202 | County 3 | County Agency 3 | http://www.ventura.org/general-services-agency/parks-department | County 3 | 331 | Ventura, County of 198 | County 3 | County Agency 3 | Ventura 8 | 3.561 | Saticoy Park | 0 | Local Park 2 | 4 | |
12112 | 12112 | 12111 | {"type": "Polygon", "coordinates": [[[-118.61656, 34.48907], [-118.6132, 34.48908], [-118.61156, 34.48447], [-118.61157, 34.48188], [-118.61217, 34.48188], [-118.61218, 34.48184], [-118.61371, 34.48184], [-118.61372, 34.4819], [-118.61391, 34.48191], [-118.61407, 34.48241], [-118.61404, 34.48241], [-118.61406, 34.48249], [-118.61412, 34.48252], [-118.61473, 34.48408], [-118.6155, 34.48581], [-118.61579, 34.48675], [-118.61601, 34.4873], [-118.61656, 34.48907]]]} | Open Access 1 | 25034 | Castaic Sports Complex | 16946 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 58.013 | Castaic Sports Complex | 0 | Local Recreation Area 3 | 4 | |
12113 | 12113 | 12112 | {"type": "Polygon", "coordinates": [[[-118.33769, 33.99873], [-118.33749, 33.99926], [-118.33744, 33.99931], [-118.33736, 33.99931], [-118.3369, 33.99912], [-118.33688, 33.99909], [-118.3369, 33.99905], [-118.33762, 33.99869], [-118.33767, 33.99869], [-118.33769, 33.99873]]]} | Open Access 1 | 25041 | Monteith Parkway | 29043 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 0.64 | Monteith Parkway | 0 | Local Recreation Area 3 | 4 | |
12137 | 12137 | 12136 | {"type": "Polygon", "coordinates": [[[-116.86437, 32.84792], [-116.86395, 32.84801], [-116.86323, 32.84819], [-116.86121, 32.84874], [-116.86081, 32.84886], [-116.86032, 32.84905], [-116.85989, 32.84924], [-116.85946, 32.84947], [-116.85905, 32.84973], [-116.85909, 32.84962], [-116.85783, 32.84867], [-116.85712, 32.84965], [-116.85469, 32.84965], [-116.85468, 32.8487], [-116.85753, 32.84505], [-116.86185, 32.84502], [-116.86186, 32.84501], [-116.86171, 32.84478], [-116.8618, 32.84476], [-116.86312, 32.84505], [-116.86228, 32.84564], [-116.86362, 32.84766], [-116.86437, 32.84792]]]} | Open Access 1 | 25128 | Flinn Springs County Park | 18950 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/FlinnSprings.html | San Diego 4 | 75.51 | Flinn Springs County Park | 0 | Local Park 2 | 4 |
12152 | 12152 | 12151 | {"type": "Polygon", "coordinates": [[[-120.70427, 38.60566], [-120.70423, 38.60922], [-120.70391, 38.6093], [-120.70371, 38.60956], [-120.70367, 38.60954], [-120.7035, 38.60978], [-120.70347, 38.60984], [-120.703, 38.6096], [-120.70166, 38.6083], [-120.7015, 38.60823], [-120.70042, 38.60721], [-120.70015, 38.60699], [-120.70427, 38.60566]]]} | Open Access 1 | 25187 | Pioneer Park | 23716 | 351 | El Dorado, County of 414 | County 3 | County Agency 3 | http://www.edcgov.us/Parks/ | County 3 | 351 | El Dorado, County of 408 | County 3 | County Agency 3 | El Dorado 34 | 22.828 | Pioneer Park | 0 | Local Park 2 | 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 | |
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 | |
12242 | 12242 | 12241 | {"type": "MultiPolygon", "coordinates": [[[[-117.18634, 33.08768], [-117.18422, 33.08768], [-117.18424, 33.08862], [-117.1842, 33.09134], [-117.18211, 33.09133], [-117.18197, 33.09493], [-117.17742, 33.09493], [-117.17755, 33.08762], [-117.17527, 33.08759], [-117.17541, 33.08587], [-117.17429, 33.08585], [-117.17445, 33.08402], [-117.17778, 33.08404], [-117.17803, 33.08039], [-117.17905, 33.08039], [-117.18143, 33.08206], [-117.18122, 33.08316], [-117.17997, 33.08494], [-117.1802, 33.08476], [-117.18126, 33.08458], [-117.18138, 33.08479], [-117.18209, 33.08429], [-117.1826, 33.08426], [-117.1827, 33.08451], [-117.18264, 33.08506], [-117.18284, 33.08558], [-117.18309, 33.08538], [-117.18327, 33.08488], [-117.18313, 33.08447], [-117.18316, 33.08417], [-117.18324, 33.08408], [-117.18445, 33.08407], [-117.18504, 33.08445], [-117.18538, 33.08469], [-117.18565, 33.08491], [-117.18581, 33.08507], [-117.18633, 33.08568], [-117.18634, 33.08768]]], [[[-117.18635, 33.08529], [-117.186, 33.08489], [-117.18581, 33.08472], [-117.18524, 33.08429], [-117.18491, 33.08407], [-117.18633, 33.08407], [-117.18635, 33.08529]]]]} | No Public Access 3 | 25447 | Sage Hill Preserve | 29254 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | San Diego 4 | 231.523 | Sage Hill Preserve | 0 | Local Conservation Area 4 | 2 | |
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 |
12296 | 12296 | 12295 | {"type": "Polygon", "coordinates": [[[-119.50625, 36.72095], [-119.50623, 36.7228], [-119.50624, 36.72462], [-119.50195, 36.72458], [-119.50192, 36.72283], [-119.50197, 36.72277], [-119.50198, 36.7227], [-119.50194, 36.72262], [-119.50188, 36.72258], [-119.5018, 36.72256], [-119.50169, 36.72257], [-119.50161, 36.72263], [-119.50158, 36.72271], [-119.5016, 36.72279], [-119.50166, 36.72285], [-119.5017, 36.72766], [-119.50164, 36.72783], [-119.50148, 36.72797], [-119.50134, 36.72816], [-119.49746, 36.72813], [-119.49741, 36.72098], [-119.50625, 36.72095]]]} | Open Access 1 | 25952 | China Creek Park | 17202 | 301 | Fresno, County of 296 | County 3 | County Agency 3 | http://www.co.fresno.ca.us/DepartmentPage.aspx?id=51904 | County 3 | 301 | Fresno, County of 292 | County 3 | County Agency 3 | Fresno 9 | 113.797 | China Creek Park | 0 | Local Park 2 | 4 | |
12297 | 12297 | 12296 | {"type": "Polygon", "coordinates": [[[-119.36499, 36.82156], [-119.36484, 36.82167], [-119.36465, 36.82269], [-119.3645, 36.82277], [-119.36352, 36.82264], [-119.36305, 36.8226], [-119.36273, 36.82261], [-119.36239, 36.82267], [-119.36177, 36.82273], [-119.36155, 36.82272], [-119.36075, 36.8225], [-119.36008, 36.82242], [-119.35953, 36.82239], [-119.35875, 36.82224], [-119.35845, 36.82216], [-119.35795, 36.82194], [-119.35762, 36.82183], [-119.35627, 36.82122], [-119.35558, 36.82116], [-119.35494, 36.82132], [-119.35425, 36.82166], [-119.3521, 36.82457], [-119.35158, 36.82517], [-119.3513, 36.82527], [-119.3507, 36.82524], [-119.35047, 36.82532], [-119.35029, 36.82541], [-119.34938, 36.82674], [-119.3481, 36.82793], [-119.34605, 36.82777], [-119.34969, 36.8246], [-119.35288, 36.82118], [-119.35294, 36.8202], [-119.354, 36.81915], [-119.35626, 36.81834], [-119.35729, 36.81815], [-119.35755, 36.81813], [-119.36022, 36.81832], [-119.36486, 36.81775], [-119.36499, 36.82156]]]} | Open Access 1 | 25953 | Choinumni Park | 17214 | 301 | Fresno, County of 296 | County 3 | County Agency 3 | http://www.co.fresno.ca.us/DepartmentPage.aspx?id=51904 | County 3 | 301 | Fresno, County of 292 | County 3 | County Agency 3 | Fresno 9 | 140.591 | Choinumni Park | 0 | Local Park 2 | 4 | |
12299 | 12299 | 12298 | {"type": "Polygon", "coordinates": [[[-119.44789, 36.74967], [-119.44787, 36.75316], [-119.44786, 36.75324], [-119.44785, 36.75402], [-119.44543, 36.75484], [-119.44438, 36.75684], [-119.44384, 36.75753], [-119.44321, 36.75812], [-119.4432, 36.75928], [-119.44317, 36.76005], [-119.44202, 36.76162], [-119.44126, 36.76044], [-119.43947, 36.76041], [-119.43884, 36.75948], [-119.43886, 36.75681], [-119.43707, 36.75679], [-119.43755, 36.7563], [-119.43776, 36.7561], [-119.43831, 36.75579], [-119.43972, 36.75506], [-119.4399, 36.75496], [-119.44006, 36.75484], [-119.44026, 36.75466], [-119.44042, 36.75443], [-119.44053, 36.75416], [-119.4406, 36.75388], [-119.44062, 36.75264], [-119.44234, 36.75208], [-119.44351, 36.75166], [-119.44407, 36.75142], [-119.44732, 36.74965], [-119.44789, 36.74967]]]} | Open Access 1 | 25954 | Kings River Green Belt Park | 20662 | 301 | Fresno, County of 296 | County 3 | County Agency 3 | http://www.co.fresno.ca.us/DepartmentPage.aspx?id=51904 | County 3 | 301 | Fresno, County of 292 | County 3 | County Agency 3 | Fresno 9 | 136.461 | Kings River Green Belt Park | 0 | Local Park 2 | 4 | |
12304 | 12304 | 12303 | {"type": "Polygon", "coordinates": [[[-119.85082, 37.44887], [-119.85015, 37.4499], [-119.84984, 37.44973], [-119.84923, 37.44961], [-119.84861, 37.44946], [-119.84756, 37.44967], [-119.84741, 37.44969], [-119.84747, 37.44898], [-119.84763, 37.44739], [-119.84952, 37.44862], [-119.85082, 37.44887]]]} | Open Access 1 | 25960 | Woodland Park | 27721 | 307 | Mariposa, County of 110 | County 3 | County Agency 3 | https://www.mariposacounty.org/index.aspx?NID=207 | County 3 | 307 | Mariposa, County of 107 | County 3 | County Agency 3 | Mariposa 31 | 10.398 | Woodland Park | 0 | Local Park 2 | 4 | |
12322 | 12322 | 12321 | {"type": "Polygon", "coordinates": [[[-119.47502, 36.7331], [-119.47483, 36.73317], [-119.47481, 36.73326], [-119.47375, 36.73264], [-119.47308, 36.73291], [-119.4716, 36.73202], [-119.47134, 36.73246], [-119.47051, 36.73212], [-119.47043, 36.7321], [-119.47052, 36.73197], [-119.47095, 36.7312], [-119.47206, 36.73151], [-119.47297, 36.73185], [-119.47502, 36.7331]]]} | Open Access 1 | 25985 | Kings river Access Park | 20661 | 301 | Fresno, County of 296 | County 3 | County Agency 3 | http://www.co.fresno.ca.us/DepartmentPage.aspx?id=51904 | County 3 | 301 | Fresno, County of 292 | County 3 | County Agency 3 | Fresno 9 | 7.286 | Kings river Access Park | 0 | Local Recreation Area 3 | 4 | |
12332 | 12332 | 12331 | {"type": "Polygon", "coordinates": [[[-121.09587, 38.20221], [-121.09573, 38.20244], [-121.09539, 38.20279], [-121.09495, 38.2033], [-121.09441, 38.20379], [-121.09392, 38.20414], [-121.09368, 38.20446], [-121.09316, 38.20486], [-121.09294, 38.20498], [-121.09139, 38.2034], [-121.09121, 38.20317], [-121.09066, 38.20236], [-121.09587, 38.20221]]]} | Open Access 1 | 26005 | Stillman Magee Park | 25851 | 322 | San Joaquin, County of 479 | County 3 | County Agency 3 | http://www.sjparks.com/ | County 3 | 322 | San Joaquin, County of 471 | County 3 | County Agency 3 | San Joaquin 39 | 18.43 | Stillman Magee Park | 0 | Local Park 2 | 4 | |
12333 | 12333 | 12332 | {"type": "Polygon", "coordinates": [[[-121.27031, 37.97923], [-121.26981, 37.97935], [-121.26951, 37.97862], [-121.27001, 37.9785], [-121.27031, 37.97923]]]} | Open Access 1 | 26006 | West Jackson Park | 27364 | 322 | San Joaquin, County of 479 | County 3 | County Agency 3 | http://www.sjparks.com/ | County 3 | 322 | San Joaquin, County of 471 | County 3 | County Agency 3 | San Joaquin 39 | 0.966 | West Jackson Park | 0 | Local Park 2 | 4 | |
12345 | 12345 | 12344 | {"type": "MultiPolygon", "coordinates": [[[[-116.36349, 32.9753], [-116.36347, 32.97586], [-116.34903, 32.97614], [-116.34864, 32.97612], [-116.34825, 32.97607], [-116.34782, 32.976], [-116.34743, 32.97589], [-116.34678, 32.97561], [-116.34632, 32.97535], [-116.34609, 32.97521], [-116.34606, 32.97518], [-116.3474, 32.97517], [-116.35338, 32.97521], [-116.36349, 32.9753]]], [[[-116.36369, 32.97613], [-116.36368, 32.97685], [-116.3475, 32.97688], [-116.34745, 32.97619], [-116.34765, 32.97624], [-116.34809, 32.97633], [-116.34847, 32.97638], [-116.34903, 32.97642], [-116.34934, 32.97642], [-116.36369, 32.97613]]]]} | Open Access 1 | 26037 | Vallecito County Park | 29260 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/Vallecito.html | San Diego 4 | 57.618 | Vallecito County Park | 0 | Local Park 2 | 4 |
12365 | 12365 | 12364 | {"type": "Polygon", "coordinates": [[[-121.13882, 41.1215], [-121.1388, 41.12256], [-121.13851, 41.12256], [-121.13851, 41.1227], [-121.13831, 41.1227], [-121.13798, 41.12334], [-121.13683, 41.12331], [-121.13678, 41.12411], [-121.13849, 41.12478], [-121.13372, 41.12466], [-121.13375, 41.12141], [-121.13483, 41.12142], [-121.1348, 41.12231], [-121.13481, 41.12232], [-121.13606, 41.12234], [-121.13611, 41.12143], [-121.13872, 41.12145], [-121.13882, 41.1215]]]} | Open Access 1 | 26506 | Clara Beiber Memorial Park | 17378 | 354 | Lassen, County of 750 | County 3 | County Agency 3 | http://www.co.lassen.ca.us/visiting/parks_and_leisure/ | County 3 | 354 | Lassen, County of 736 | County 3 | County Agency 3 | Lassen 54 | 29.359 | Clara Beiber Memorial 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 | |
12416 | 12416 | 12415 | {"type": "Polygon", "coordinates": [[[-121.08267, 38.93257], [-121.08255, 38.93257], [-121.08236, 38.93233], [-121.08197, 38.93233], [-121.08209, 38.93168], [-121.08212, 38.93165], [-121.08218, 38.93163], [-121.08245, 38.93166], [-121.08266, 38.93166], [-121.08267, 38.93257]]]} | Open Access 1 | 27022 | Springs Meadow Park | 25749 | 314 | Placer, County of 210 | County 3 | County Agency 3 | http://www.placer.ca.gov/departments/facility/parks | County 3 | 314 | Placer, County of 206 | County 3 | County Agency 3 | Placer 35 | 1.137 | Springs Meadow 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]);