units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
10,394 rows where AGNCY_LEV = 2 sorted by GAP_STS
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- San Diego, City of 525
- Los Angeles, City of 485
- San Jose, City of 251
- San Francisco, City and County of 238
- Sacramento, City of 220
- Ventura, City of 150
- Long Beach, City of 144
- Roseville, City of 130
- Oakland, City of 122
- Irvine, City of 98
- Fresno, City of 90
- Modesto, City of 85
- Santa Rosa, City of 82
- Stockton, City of 81
- Napa, City of 81
- Huntington Beach, City of 76
- Tracy, City of 73
- Torrance, City of 72
- Santa Cruz, City of 71
- Chula Vista, City of 70
- Brentwood, City of 68
- Poway, City of 67
- Davis, City of 65
- Santa Barbara, City of 63
- San Luis Obispo, City of 62
- Newport Beach, City of 62
- Glendale, City of 61
- Bakersfield, City of 61
- Manteca, City of 61
- Riverside, City of 60
- …
DES_TP >30
- Local Park 7,352
- Local Recreation Area 1,414
- Local Other or Unknown 661
- Local Conservation Area 149
- Local Historic or Cultural Area 38
- Local Resource Management Area 6
- National Monument or Landmark 5
- State Conservation Area 2
- National Forest 1
- None 1
- None 1
- National Recreation 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
- None 1
- …
MNG_AG_TYP 14
- City Agency 10,272
- Open Space District 21
- Recreation/Parks District 19
- County Agency 16
- Non Profit - Other 11
- Commercial 9
- Non Profit - Conservation 7
- State Agency 5
- County Agency - Parks 4
- Other 3
- County Agency - Other 2
- Non Profit - Land Trust 2
- Port/Harbor District 2
- Community Services District 1
ACCESS_TYP 4
- Open Access 9,879
- Restricted Access 259
- No Public Access 207
- Unknown 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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
490 | 490 | 489 | {"type": "Polygon", "coordinates": [[[-122.14785, 37.69505], [-122.1456, 37.69512], [-122.14527, 37.69542], [-122.14472, 37.69503], [-122.1447, 37.69334], [-122.14783, 37.69326], [-122.14785, 37.69505]]]} | Open Access 1 | 1962 | Washington Manor | 27270 | 1306 | San Leandro, City of 183 | City 2 | City Agency 2 | http://www.sanleandro.org/depts/rec/parks/default.asp | City 2 | 1306 | San Leandro, City of 179 | City 2 | City Agency 2 | Alameda 17 | 13.829 | Washington Manor | None 51 | |||
494 | 494 | 493 | {"type": "Polygon", "coordinates": [[[-117.27317, 32.85074], [-117.27304, 32.85083], [-117.27295, 32.85079], [-117.27295, 32.85077], [-117.27298, 32.85075], [-117.273, 32.85069], [-117.27288, 32.8505], [-117.27277, 32.85041], [-117.27279, 32.85034], [-117.27292, 32.85028], [-117.27299, 32.85025], [-117.27301, 32.85027], [-117.27317, 32.85046], [-117.27323, 32.85056], [-117.27322, 32.85066], [-117.27317, 32.85074]]]} | Open Access 1 | 47473 | La Jolla Cove | 31200 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.lajollabythesea.com/la-jolla-cove | San Diego 4 | 0.357 | La Jolla Cove | None 52 | ||
588 | 588 | 587 | {"type": "Polygon", "coordinates": [[[-121.8244, 37.32448], [-121.82588, 37.32597], [-121.82589, 37.32601], [-121.82586, 37.32606], [-121.82416, 37.3272], [-121.82262, 37.32574], [-121.82324, 37.32527], [-121.8244, 37.32448]]]} | Open Access 1 | 1999 | Welch | 27336 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 11.064 | Welch | 1995 | None 59 | ||
614 | 614 | 613 | {"type": "Polygon", "coordinates": [[[-117.00547, 33.78338], [-117.00547, 33.78397], [-117.00477, 33.78398], [-117.00477, 33.78368], [-117.00472, 33.78364], [-117.00476, 33.78359], [-117.00478, 33.78353], [-117.00475, 33.78336], [-117.00522, 33.78336], [-117.00547, 33.78338]]]} | Open Access 1 | 48399 | Parkside Village | 32966 | 1416 | San Jacinto, City of 222 | City 2 | City Agency 2 | http://www.ci.san-jacinto.ca.us/residents/parks.html | City 2 | 1416 | San Jacinto, City of 218 | City 2 | City Agency 2 | http://sanjacintoca.hosted.civiclive.com/cms/one.aspx?portalId=10384430&pageId=13304572 | Riverside 10 | 1.101 | Parkside Village | None 60 | ||
665 | 665 | 664 | {"type": "Polygon", "coordinates": [[[-121.91687, 37.25892], [-121.91694, 37.25895], [-121.9176, 37.25989], [-121.9176, 37.25993], [-121.91518, 37.26101], [-121.91514, 37.26101], [-121.91509, 37.26099], [-121.91444, 37.26006], [-121.91444, 37.26002], [-121.91445, 37.25999], [-121.91687, 37.25892]]]} | Open Access 1 | 5056 | Butcher | 16545 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 8.116 | Butcher | 1981 | None 63 | ||
723 | 723 | 722 | {"type": "Polygon", "coordinates": [[[-122.8297, 38.43042], [-122.82526, 38.43042], [-122.82525, 38.42579], [-122.8253, 38.42547], [-122.82624, 38.42547], [-122.82716, 38.42577], [-122.82941, 38.42635], [-122.82931, 38.42976], [-122.82941, 38.43012], [-122.8297, 38.43042]]]} | No Public Access 3 | 4499 | Stone Farm | 25869 | 1324 | Santa Rosa, City of 30 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | Sonoma 16 | 45.409 | Stone Farm | None 67 | |||
744 | 744 | 743 | {"type": "Polygon", "coordinates": [[[-117.47083, 34.12883], [-117.47082, 34.13125], [-117.47075, 34.13131], [-117.46928, 34.13131], [-117.46928, 34.12876], [-117.47075, 34.12876], [-117.47083, 34.12883]]]} | Open Access 1 | 4839 | Koehler Park / The Landings | 20712 | 1109 | Fontana, City of 168 | City 2 | City Agency 2 | http://www.fontana.org/index.aspx?NID=551 | City 2 | 1109 | Fontana, City of 164 | City 2 | City Agency 2 | San Bernardino 22 | 9.998 | Koehler Park / The Landings | None 68 | |||
751 | 751 | 750 | {"type": "Polygon", "coordinates": [[[-122.02681, 37.30115], [-122.02645, 37.30262], [-122.02649, 37.30263], [-122.02622, 37.30302], [-122.02611, 37.30314], [-122.02528, 37.30385], [-122.02406, 37.30433], [-122.02399, 37.30413], [-122.02384, 37.30385], [-122.0238, 37.30366], [-122.02375, 37.30168], [-122.0238, 37.30147], [-122.02381, 37.30133], [-122.02383, 37.30129], [-122.02389, 37.30126], [-122.02608, 37.30126], [-122.02635, 37.30123], [-122.02668, 37.30115], [-122.02681, 37.30115]]]} | Open Access 1 | 5576 | Calabazas | 16668 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 16.77 | Calabazas | 1978 | None 69 | ||
806 | 806 | 805 | {"type": "Polygon", "coordinates": [[[-118.36891, 33.73931], [-118.36872, 33.73989], [-118.36801, 33.74037], [-118.3676, 33.74059], [-118.36705, 33.7408], [-118.36659, 33.74091], [-118.36593, 33.741], [-118.36518, 33.74102], [-118.36184, 33.74064], [-118.36135, 33.74054], [-118.36085, 33.74039], [-118.36043, 33.74023], [-118.35991, 33.74], [-118.36013, 33.7397], [-118.36194, 33.73906], [-118.36225, 33.73793], [-118.36307, 33.73841], [-118.36421, 33.7389], [-118.36458, 33.73893], [-118.36486, 33.73874], [-118.36576, 33.73874], [-118.36599, 33.73867], [-118.36603, 33.73842], [-118.36669, 33.73848], [-118.36759, 33.73837], [-118.36825, 33.73811], [-118.3684, 33.7379], [-118.36858, 33.73667], [-118.36844, 33.73652], [-118.36862, 33.73606], [-118.36885, 33.7361], [-118.36869, 33.73753], [-118.36863, 33.73839], [-118.36868, 33.73907], [-118.36891, 33.73931]]]} | Restricted Access 2 | 5870 | Abalone Cove Shoreline Archery Range | 29497 | 1265 | Rancho Palos Verdes, City of 265 | City 2 | City Agency 2 | http://palosverdes.com/rpv/recreationparks/index.cfm | City 2 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 45.317 | Abalone Cove Shoreline Archery Range | None 73 | |||
807 | 807 | 806 | {"type": "Polygon", "coordinates": [[[-122.49956, 37.74793], [-122.49848, 37.74797], [-122.49847, 37.74777], [-122.49954, 37.74772], [-122.49956, 37.74793]]]} | Open Access 1 | 5871 | Parking Area | 23443 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 0.541 | Parking Area | None 74 | |||
816 | 816 | 815 | {"type": "Polygon", "coordinates": [[[-121.80478, 37.67824], [-121.80306, 37.67892], [-121.80129, 37.67953], [-121.80062, 37.67969], [-121.79957, 37.67975], [-121.79748, 37.67946], [-121.79627, 37.67965], [-121.7953, 37.67994], [-121.79396, 37.67982], [-121.79254, 37.67974], [-121.7915, 37.67976], [-121.79158, 37.67946], [-121.79158, 37.67939], [-121.79205, 37.6795], [-121.79326, 37.67955], [-121.79464, 37.67963], [-121.79547, 37.6796], [-121.79602, 37.67934], [-121.7967, 37.67905], [-121.79774, 37.6791], [-121.79887, 37.67934], [-121.79991, 37.67942], [-121.80079, 37.67936], [-121.80188, 37.67901], [-121.80281, 37.67855], [-121.80429, 37.6779], [-121.80478, 37.67824]]]} | Open Access 1 | 5263 | Arroyo Mocho | 15613 | 1178 | Livermore, City of 256 | City 2 | City Agency 2 | http://www.larpd.org/parks/parks.html | City 2 | 1178 | Livermore, City of 252 | City 2 | City Agency 2 | Alameda 17 | 10.963 | Arroyo Mocho | None 75 | |||
827 | 827 | 826 | {"type": "Polygon", "coordinates": [[[-118.29052, 33.70593], [-118.29052, 33.70629], [-118.2901, 33.70629], [-118.28968, 33.70635], [-118.28937, 33.70643], [-118.28917, 33.70649], [-118.28883, 33.70664], [-118.28863, 33.70632], [-118.28909, 33.70613], [-118.28954, 33.70601], [-118.29003, 33.70594], [-118.29052, 33.70593]]]} | Open Access 1 | 5952 | Wilder's Addition (Point Fermin Park) | 27505 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 1.693 | Wilder's Addition (Point Fermin Park) | None 76 | |||
859 | 859 | 858 | {"type": "Polygon", "coordinates": [[[-122.4154, 37.74429], [-122.41519, 37.74462], [-122.41503, 37.74455], [-122.41523, 37.74423], [-122.4154, 37.74429]]]} | Open Access 1 | 5530 | Coso St (vacated Portion) | 17671 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 0.157 | Coso St (vacated Portion) | None 77 | |||
861 | 861 | 860 | {"type": "Polygon", "coordinates": [[[-122.41555, 37.74491], [-122.41552, 37.74496], [-122.41507, 37.74482], [-122.41512, 37.74474], [-122.41555, 37.74491]]]} | Open Access 1 | 5535 | Vacated Portion Of Bocana St | 26751 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 0.089 | Vacated Portion Of Bocana St | None 78 | |||
941 | 941 | 940 | {"type": "MultiPolygon", "coordinates": [[[[-122.38349, 37.73385], [-122.38327, 37.7339], [-122.38325, 37.73385], [-122.38312, 37.73387], [-122.38306, 37.73371], [-122.38342, 37.73363], [-122.38349, 37.73385]]], [[[-122.38398, 37.73378], [-122.38398, 37.73378], [-122.38374, 37.73403], [-122.38366, 37.73382], [-122.38396, 37.73374], [-122.38398, 37.73378]]]]} | Open Access 1 | 5955 | Hunters Point Park Lands | 20155 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 0.289 | Hunters Point Park Lands | None 84 | |||
946 | 946 | 945 | {"type": "Polygon", "coordinates": [[[-122.42112, 37.80171], [-122.41972, 37.80189], [-122.41956, 37.80114], [-122.42097, 37.80097], [-122.42112, 37.80171]]]} | Open Access 1 | 6514 | Geo Sterling Park (alice Marble Tennis Courts) | 19258 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 2.597 | Geo Sterling Park (alice Marble Tennis Courts) | None 86 | |||
949 | 949 | 948 | {"type": "Polygon", "coordinates": [[[-118.39498, 33.80348], [-118.3947, 33.80383], [-118.39442, 33.80424], [-118.39395, 33.80426], [-118.39473, 33.80352], [-118.39498, 33.80348]]]} | Open Access 1 | 5982 | RAT Beach / Malaga Cove | 24191 | 1244 | Palos Verdes Estates, City of 293 | City 2 | City Agency 2 | http://www.pvestates.org/ | City 2 | 1244 | Palos Verdes Estates, City of 289 | City 2 | City Agency 2 | Los Angeles 6 | 0.619 | RAT Beach / Malaga Cove | None 88 | |||
988 | 988 | 987 | {"type": "Polygon", "coordinates": [[[-118.16985, 34.14278], [-118.16959, 34.14308], [-118.1692, 34.14334], [-118.16812, 34.14389], [-118.16797, 34.14398], [-118.16783, 34.14409], [-118.16766, 34.14428], [-118.16757, 34.14447], [-118.16748, 34.14453], [-118.16747, 34.14456], [-118.16743, 34.14456], [-118.16743, 34.14473], [-118.16701, 34.14491], [-118.16598, 34.14528], [-118.16486, 34.14554], [-118.16403, 34.14571], [-118.16402, 34.14556], [-118.16404, 34.14544], [-118.1641, 34.1453], [-118.16419, 34.14519], [-118.16428, 34.14512], [-118.16515, 34.14459], [-118.16533, 34.14444], [-118.16541, 34.14433], [-118.16551, 34.14411], [-118.16558, 34.14335], [-118.1656, 34.14328], [-118.16613, 34.1424], [-118.16615, 34.14233], [-118.16613, 34.14214], [-118.16591, 34.14174], [-118.16589, 34.14167], [-118.16589, 34.14157], [-118.16591, 34.14151], [-118.16606, 34.14124], [-118.16607, 34.14115], [-118.16607, 34.14105], [-118.1656, 34.13996], [-118.16556, 34.13981], [-118.16569, 34.13877], [-118.16576, 34.13856], [-118.16585, 34.13845], [-118.166, 34.13833], [-118.16666, 34.13793], [-118.16678, 34.13779], [-118.16682, 34.13771], [-118.16684, 34.13761], [-118.16684, 34.13752], [-118.16682, 34.13742], [-118.16671, 34.13726], [-118.16659, 34.13716], [-118.1661, 34.13689], [-118.16602, 34.13681], [-118.16598, 34.13671], [-118.16598, 34.13664], [-118.16611, 34.13577], [-118.16644, 34.13491], [-118.16646, 34.13481], [-118.16646, 34.13471], [-118.16642, 34.13456], [-118.16634, 34.13443], [-118.16626, 34.13433], [-118.16578, 34.13391], [-118.16573, 34.13382], [-118.16581, 34.13304], [-118.16564, 34.13214], [-118.16555, 34.1319], [-118.16536, 34.1316], [-118.16529, 34.13139], [-118.1653, 34.13116], [-118.16542, 34.13071], [-118.16542, 34.13059], [-118.1654, 34.13049], [-118.16534, 34.13039], [-118.16527, 34.1303], [-118.16518, 34.13022], [-118.16506, 34.13016], [-118.16483, 34.13011], [-118.16456, 34.13012], [-118.16442, 34.13011], [-118.16424, 34.13006], [-118.16409, 34.12997], [-118.16398, 34.12986], [-118.1639, 34.12972], [-118.16384, 34.12955], [-118.16381, 34.12933], [-118.16382, 34.12903], [-118.16402, 34.12903], [-118.16405, 34.12891], [-118.16437, 34.12886], [-118.16506, 34.12835], [-118.16531, 34.12795], [-118.16536, 34.12778], [-118.16532, 34.12752], [-118.16499, 34.12685], [-118.16502, 34.12674], [-118.16504, 34.12646], [-118.16507, 34.12645], [-118.16507, 34.12641], [-118.16505, 34.12638], [-118.1651, 34.12619], [-118.16509, 34.12614], [-118.16505, 34.12609], [-118.16513, 34.12588], [-118.16507, 34.12587], [-118.16505, 34.12581], [-118.16462, 34.12585], [-118.16484, 34.12532], [-118.16506, 34.12514], [-118.16515, 34.12512], [-118.16525, 34.12517], [-118.16544, 34.12546], [-118.16553, 34.12537], [-118.16545, 34.12525], [-118.16538, 34.12509], [-118.16537, 34.12497], [-118.1654, 34.1248], [-118.16542, 34.12479], [-118.16544, 34.12471], [-118.16553, 34.12461], [-118.16584, 34.12415], [-118.16596, 34.12389], [-118.16846, 34.12391], [-118.16826, 34.1243], [-118.16759, 34.12497], [-118.16575, 34.12557], [-118.16552, 34.12605], [-118.16541, 34.12683], [-118.16549, 34.12767], [-118.16552, 34.12776], [-118.16564, 34.128], [-118.16585, 34.12801], [-118.16587, 34.12805], [-118.16584, 34.12837], [-118.16604, 34.12835], [-118.16616, 34.12892], [-118.16595, 34.12897], [-118.16594, 34.12898], [-118.16624, 34.12913], [-118.16639, 34.13092], [-118.16639, 34.13094], [-118.16636, 34.13096], [-118.16666, 34.13196], [-118.16705, 34.13273], [-118.1671, 34.13311], [-118.16706, 34.1333], [-118.16754, 34.1338], [-118.16754, 34.13383], [-118.16723, 34.13398], [-118.16712, 34.13413], [-118.16715, 34.13414], [-118.16721, 34.13412], [-118.16724, 34.13413], [-118.16755, 34.13429], [-118.16762, 34.13446], [-118.16768, 34.13452], [-118.16766, 34.13509], [-118.16837, 34.1355], [-118.16855, 34.13571], [-118.16872, 34.13602], [-118.16884, 34.13656], [-118.16889, 34.13656], [-118.16891, 34.13668], [-118.16837, 34.13746], [-118.169, 34.13787], [-118.16919, 34.13784], [-118.16922, 34.13785], [-118.16876, 34.13917], [-118.16873, 34.13919], [-118.16877, 34.13967], [-118.1689, 34.13966], [-118.16894, 34.14009], [-118.1686, 34.14034], [-118.16919, 34.14068], [-118.16966, 34.14199], [-118.16984, 34.14255], [-118.16985, 34.14278]]]} | Open Access 1 | 6717 | Lower Arroyo Seco | 21558 | 1246 | Pasadena, City of 301 | City 2 | City Agency 2 | http://cityofpasadena.net/PublicWorks/Parks_Natural_Resources_Division/ | City 2 | 1246 | Pasadena, City of 297 | City 2 | City Agency 2 | Los Angeles 6 | 112.416 | Lower Arroyo Seco | None 89 | |||
1009 | 1009 | 1008 | {"type": "Polygon", "coordinates": [[[-121.85208, 37.24596], [-121.85169, 37.24702], [-121.85135, 37.24693], [-121.85055, 37.24676], [-121.8482, 37.24621], [-121.84858, 37.24515], [-121.85208, 37.24596]]]} | Open Access 1 | 5500 | Cahalan | 16655 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 9.757 | Cahalan | 1978 | None 91 | ||
1032 | 1032 | 1031 | {"type": "Polygon", "coordinates": [[[-118.31535, 34.20234], [-118.31479, 34.20286], [-118.31405, 34.20238], [-118.31459, 34.20179], [-118.31535, 34.20234]]]} | Open Access 1 | 6838 | Bel Air Ballfield | 29539 | 1038 | Burbank, City of 138 | City 2 | City Agency 2 | http://burbankca.gov/departments/park-recreation-and-community-services/parks-facilities | City 2 | 1038 | Burbank, City of 135 | City 2 | City Agency 2 | Los Angeles 6 | 1.786 | Bel Air Ballfield | None 92 |
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]);