units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,989 rows where DES_TP = 3
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- San Diego, City of 197
- Los Angeles, City of 104
- San Francisco, City and County of 59
- Mountains Recreation and Conservation Authority 51
- Conejo Open Space Conservation Agency 29
- Los Angeles, County of 27
- East Bay Regional Park District 27
- Las Virgenes Municipal Water District 25
- San Luis Obispo, City of 24
- Davis, City of 23
- Long Beach, City of 21
- Santa Barbara, County of 18
- Santa Clarita, City of 18
- Sacramento, City of 18
- Glendale, City of 17
- Vacaville, City of 16
- San Jose, City of 15
- Los Angeles - Department of Parks and Recreation, County of 15
- Santa Cruz, City of 14
- Oakland, City of 14
- Thousand Oaks, City of 14
- East Bay Municipal Utility District 13
- Tiburon, Town of 13
- Fullerton, City of 12
- Carlsbad, City of 12
- Poway, City of 12
- San Marcos, City of 12
- Sunrise Recreation and Park District 12
- Littlerock Creek Irrigation District 12
- Conejo Recreation and Park District 11
- …
MNG_AG_TYP 17
- City Agency 1,285
- Recreation/Parks District 154
- County Agency 109
- Open Space District 81
- Water District 66
- County Agency - Parks 35
- Irrigation District 22
- Community Services District 14
- Flood District 8
- School District 5
- County Agency - Other 4
- Port/Harbor District 4
- Special District - Other 4
- Sanitation District 3
- Cemetery District 2
- Conservation District 1
- Transportation Agency 1
ACCESS_TYP 4
- Open Access 1,475
- Restricted Access 206
- No Public Access 103
- Unknown Access 14
DES_TP 1
- Local Recreation Area · 1,798 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2550 | 2550 | 2549 | {"type": "Polygon", "coordinates": [[[-122.4469, 37.72308], [-122.44688, 37.72368], [-122.44681, 37.72389], [-122.44654, 37.72452], [-122.44566, 37.72454], [-122.44567, 37.72508], [-122.44619, 37.72507], [-122.44618, 37.7251], [-122.44621, 37.72511], [-122.44606, 37.7253], [-122.44588, 37.72531], [-122.4454, 37.726], [-122.44534, 37.72599], [-122.445, 37.72648], [-122.44499, 37.72653], [-122.44503, 37.72655], [-122.44496, 37.72665], [-122.44181, 37.72667], [-122.44482, 37.72306], [-122.44674, 37.72306], [-122.4469, 37.72308]]]} | Open Access 1 | 17801 | Balboa Park & Pool | 15772 | 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 | 23.774 | Balboa Park & Pool | 0 | Local Recreation Area 3 | 4 | |
2552 | 2552 | 2551 | {"type": "Polygon", "coordinates": [[[-122.04515, 37.0409], [-122.04469, 37.04113], [-122.04428, 37.0406], [-122.04472, 37.04039], [-122.04515, 37.0409]]]} | Open Access 1 | 17807 | Michael Gray Field Park | 22196 | 1328 | Scotts Valley, City of 107 | City 2 | City Agency 2 | http://www.scottsvalley.org/parks/parks_recs.html | City 2 | 1328 | Scotts Valley, City of 104 | City 2 | City Agency 2 | Santa Cruz 5 | 0.798 | Michael Gray Field Park | 0 | Local Recreation Area 3 | 4 | |
2581 | 2581 | 2580 | {"type": "Polygon", "coordinates": [[[-119.66557, 34.42181], [-119.6652, 34.42296], [-119.66446, 34.42284], [-119.66145, 34.42302], [-119.66143, 34.42284], [-119.66412, 34.42212], [-119.66557, 34.42181]]]} | Unknown Access 4 | 17913 | Montecity Country Club | 22411 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | Santa Barbara 7 | 6.027 | Montecity Country Club | 0 | Local Recreation Area 3 | 4 | |
2591 | 2591 | 2590 | {"type": "MultiPolygon", "coordinates": [[[[-121.89718, 36.61024], [-121.89709, 36.61029], [-121.89629, 36.60934], [-121.8964, 36.60932], [-121.89718, 36.61024]]], [[[-121.89804, 36.61126], [-121.89796, 36.61131], [-121.89719, 36.6104], [-121.89727, 36.61035], [-121.89804, 36.61126]]], [[[-121.89857, 36.61213], [-121.89845, 36.6122], [-121.89841, 36.61202], [-121.89831, 36.61179], [-121.89821, 36.61162], [-121.89805, 36.61143], [-121.89816, 36.61137], [-121.89831, 36.61155], [-121.89846, 36.6118], [-121.89852, 36.61194], [-121.89857, 36.61213]]], [[[-121.89976, 36.61454], [-121.8996, 36.61463], [-121.89874, 36.61359], [-121.89862, 36.61339], [-121.89853, 36.61314], [-121.8985, 36.61297], [-121.89847, 36.61266], [-121.89862, 36.61283], [-121.89864, 36.61302], [-121.89868, 36.61318], [-121.89875, 36.61336], [-121.89886, 36.61355], [-121.89942, 36.61422], [-121.89947, 36.6142], [-121.89976, 36.61454]]], [[[-121.90075, 36.61569], [-121.90057, 36.61579], [-121.89971, 36.61477], [-121.89987, 36.61468], [-121.90006, 36.61489], [-121.90008, 36.61489], [-121.90075, 36.61569]]], [[[-121.90167, 36.61684], [-121.90153, 36.61692], [-121.90067, 36.6159], [-121.9008, 36.61582], [-121.90167, 36.61684]]], [[[-121.90242, 36.6177], [-121.90225, 36.61776], [-121.90163, 36.61703], [-121.90177, 36.61695], [-121.90242, 36.6177]]], [[[-121.90324, 36.61833], [-121.90322, 36.61834], [-121.90314, 36.61831], [-121.903, 36.61821], [-121.90291, 36.61811], [-121.90302, 36.61806], [-121.90324, 36.61833]]]]} | Open Access 1 | 17932 | Monterey Bay Coastal Trail | 22417 | 2084 | Monterey Peninsula Recreational Trail Joint Powers 537 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 2084 | Monterey Peninsula Recreational Trail Joint Powers 530 | Special District 4 | Recreation/Parks District 4 | Monterey 14 | 3.184 | Monterey Bay Coastal Trail | 0 | Local Recreation Area 3 | 4 | ||
2606 | 2606 | 2605 | {"type": "MultiPolygon", "coordinates": [[[[-118.65203, 34.0785], [-118.65188, 34.07884], [-118.65156, 34.07893], [-118.65122, 34.07868], [-118.65139, 34.07845], [-118.65163, 34.07837], [-118.65203, 34.0785]]], [[[-118.68181, 34.15509], [-118.68163, 34.15516], [-118.68156, 34.155], [-118.68174, 34.15494], [-118.68181, 34.15509]]]]} | No Public Access 3 | 12427 | Las Virgenes Municipal Water District Open Space | 21072 | 2059 | Las Virgenes Municipal Water District 398 | Special District 4 | Water District 13 | http://www.lvmwd.com/ | Special District 4 | 2059 | Las Virgenes Municipal Water District 392 | Special District 4 | Water District 13 | Los Angeles 6 | 0.817 | Las Virgenes Municipal Water District OS | 0 | Local Recreation Area 3 | 4 | |
2615 | 2615 | 2614 | {"type": "Polygon", "coordinates": [[[-119.80483, 34.42522], [-119.80482, 34.42554], [-119.80247, 34.42582], [-119.8009, 34.42611], [-119.80039, 34.42613], [-119.79935, 34.42613], [-119.79881, 34.42614], [-119.79835, 34.42616], [-119.7981, 34.4262], [-119.79785, 34.42626], [-119.79761, 34.42634], [-119.79738, 34.42644], [-119.79607, 34.42714], [-119.7965, 34.42603], [-119.7965, 34.42592], [-119.79466, 34.42424], [-119.801, 34.42408], [-119.80117, 34.42409], [-119.80132, 34.42412], [-119.80156, 34.4242], [-119.80248, 34.42446], [-119.80249, 34.4255], [-119.80483, 34.42522]]]} | Open Access 1 | 17990 | More Mesa Open Space | 22473 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 36.882 | More Mesa OS | 0 | Local Recreation Area 3 | 4 | |
2616 | 2616 | 2615 | {"type": "Polygon", "coordinates": [[[-119.80757, 34.42522], [-119.80482, 34.42554], [-119.80483, 34.42523], [-119.80248, 34.4255], [-119.80248, 34.42446], [-119.8037, 34.42461], [-119.80398, 34.42462], [-119.80426, 34.4246], [-119.80465, 34.42455], [-119.80523, 34.4244], [-119.80659, 34.42394], [-119.80746, 34.4237], [-119.80757, 34.42522]]]} | Open Access 1 | 17994 | More Mesa Open Space | 22474 | 2141 | Santa Barbara Flood Control and Water Conserv. District 46 | Special District 4 | Flood District 8 | http://cosb.countyofsb.org/pwd/pwwater.aspx?id=3572 | Special District 4 | 2141 | Santa Barbara Flood Control and Water Conserv. District 45 | Special District 4 | Flood District 9 | Santa Barbara 7 | 13.532 | More Mesa OS | 0 | Local Recreation Area 3 | 4 | |
2635 | 2635 | 2634 | {"type": "Polygon", "coordinates": [[[-121.19149, 38.80011], [-121.1911, 38.80088], [-121.1908, 38.80122], [-121.18981, 38.80258], [-121.18969, 38.80269], [-121.18665, 38.80518], [-121.18527, 38.80442], [-121.18256, 38.80439], [-121.18249, 38.80331], [-121.18259, 38.79922], [-121.18607, 38.79906], [-121.18761, 38.79897], [-121.18885, 38.79896], [-121.18883, 38.80012], [-121.19149, 38.80011]]]} | Open Access 1 | 20824 | Indian Creek County Club | 20199 | 1354 | Loomis, Town of 415 | City 2 | City Agency 2 | http://www.loomis.ca.gov/ | City 2 | 1354 | Loomis, Town of 409 | City 2 | City Agency 2 | Placer 35 | 92.67 | Indian Creek County Club | 0 | Local Recreation Area 3 | 4 | |
2664 | 2664 | 2663 | {"type": "Polygon", "coordinates": [[[-118.79074, 34.17831], [-118.79083, 34.17883], [-118.79085, 34.17913], [-118.79081, 34.17938], [-118.79071, 34.1796], [-118.79039, 34.18012], [-118.79027, 34.18039], [-118.79029, 34.18095], [-118.78987, 34.18098], [-118.78894, 34.18098], [-118.78894, 34.18079], [-118.78879, 34.18062], [-118.78855, 34.1805], [-118.78858, 34.18019], [-118.78876, 34.17983], [-118.78868, 34.17964], [-118.78895, 34.17945], [-118.789, 34.17905], [-118.78924, 34.17889], [-118.78889, 34.17857], [-118.78936, 34.1781], [-118.79015, 34.17831], [-118.79074, 34.17831]]]} | Open Access 1 | 18176 | North Ranch Playfield | 22854 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.org/ | Special District 4 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 11.94 | North Ranch Playfield | 0 | Local Recreation Area 3 | 4 | |
2683 | 2683 | 2682 | {"type": "Polygon", "coordinates": [[[-121.50573, 38.5653], [-121.50536, 38.56616], [-121.50299, 38.56552], [-121.50337, 38.56466], [-121.50573, 38.5653]]]} | Open Access 1 | 21146 | O'Neil Field | 22952 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 5.437 | O'Neil Field | 0 | Local Recreation Area 3 | 4 | |
2694 | 2694 | 2693 | {"type": "Polygon", "coordinates": [[[-120.62642, 35.1044], [-120.62597, 35.10496], [-120.62525, 35.10457], [-120.6257, 35.10401], [-120.62642, 35.1044]]]} | Open Access 1 | 18257 | Oceano Memorial Campground | 23064 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | San Luis Obispo 1 | 1.456 | Oceano Memorial Campground | 0 | Local Recreation Area 3 | 4 | |
2710 | 2710 | 2709 | {"type": "Polygon", "coordinates": [[[-118.17189, 33.79348], [-118.17189, 33.79369], [-118.17147, 33.79396], [-118.17068, 33.79345], [-118.17083, 33.79329], [-118.17083, 33.79327], [-118.16931, 33.79229], [-118.16929, 33.79021], [-118.17188, 33.79021], [-118.17189, 33.79321], [-118.17163, 33.79322], [-118.17163, 33.79347], [-118.17189, 33.79348]]]} | Open Access 1 | 6683 | Chittick Field | 29942 | 2272 | Los Angeles County Flood Control District 287 | Special District 4 | Flood District 8 | http://dpw.lacounty.gov/lacfcd/ | Special District 4 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 19.452 | Chittick Field | 2014 | Local Recreation Area 3 | 4 | |
2711 | 2711 | 2710 | {"type": "MultiPolygon", "coordinates": [[[[-118.19943, 33.79521], [-118.19929, 33.79521], [-118.19927, 33.79361], [-118.19943, 33.79359], [-118.19943, 33.79521]]], [[[-118.19942, 33.79542], [-118.19941, 33.79702], [-118.19929, 33.79703], [-118.19927, 33.79542], [-118.19942, 33.79542]]], [[[-118.19944, 33.79178], [-118.19943, 33.79341], [-118.19928, 33.79342], [-118.1993, 33.79177], [-118.19944, 33.79178]]], [[[-118.19946, 33.79006], [-118.19943, 33.7916], [-118.19929, 33.7916], [-118.19931, 33.79007], [-118.19946, 33.79006]]]]} | Open Access 1 | 6685 | Daisy Greenbelt | 17892 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 2.32 | Daisy Greenbelt | 0 | Local Recreation Area 3 | 4 | |
2713 | 2713 | 2712 | {"type": "MultiPolygon", "coordinates": [[[[-118.41186, 34.00258], [-118.41016, 34.00467], [-118.41, 34.00457], [-118.4117, 34.00247], [-118.41186, 34.00258]]], [[[-118.41365, 34.00036], [-118.41201, 34.00239], [-118.41185, 34.00229], [-118.41347, 34.00029], [-118.41365, 34.00036]]], [[[-118.41793, 33.99507], [-118.41374, 34.00024], [-118.41356, 34.00017], [-118.41777, 33.99497], [-118.41793, 33.99507]]], [[[-118.42101, 33.99126], [-118.41808, 33.99489], [-118.41792, 33.99479], [-118.42084, 33.99118], [-118.42087, 33.99116], [-118.42101, 33.99126]]], [[[-118.4256, 33.98559], [-118.42119, 33.99104], [-118.42104, 33.99093], [-118.42514, 33.98586], [-118.4256, 33.98559]]]]} | Open Access 1 | 6688 | Culver Boulevard Median Bicycle Path | 17851 | 1075 | Culver City, City of 18 | City 2 | City Agency 2 | http://www.culvercity.org/Home/Government/PRCS | City 2 | 1075 | Culver City, City of 18 | City 2 | City Agency 2 | Los Angeles 6 | 11.005 | Culver Boulevard Median Bicycle Path | 0 | Local Recreation Area 3 | 4 | |
2760 | 2760 | 2759 | {"type": "Polygon", "coordinates": [[[-117.18439, 32.80319], [-117.18381, 32.80474], [-117.18375, 32.80478], [-117.18357, 32.80474], [-117.18342, 32.80474], [-117.18327, 32.80477], [-117.18314, 32.80482], [-117.18281, 32.80473], [-117.18214, 32.80285], [-117.18401, 32.80233], [-117.18402, 32.80309], [-117.18439, 32.80319]]]} | Open Access 1 | 18457 | East Clairemont Athletic Area | 18365 | 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 | San Diego 4 | 9.192 | East Clairemont Athletic Area | 0 | Local Recreation Area 3 | 4 | |
2764 | 2764 | 2763 | {"type": "Polygon", "coordinates": [[[-117.24414, 32.86664], [-117.24413, 32.8688], [-117.24266, 32.86878], [-117.24315, 32.86665], [-117.24414, 32.86664]]]} | Open Access 1 | 18467 | La Jolla Athletic Area - Allen Field | 30078 | 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 | San Diego 4 | 6.779 | La Jolla Athletic Area - Allen Field | 0 | Local Recreation Area 3 | 4 | |
2777 | 2777 | 2776 | {"type": "Polygon", "coordinates": [[[-117.24598, 32.85902], [-117.24599, 32.85969], [-117.24598, 32.85977], [-117.24591, 32.85992], [-117.24578, 32.86005], [-117.24495, 32.86044], [-117.24472, 32.86048], [-117.24414, 32.86051], [-117.24598, 32.85902]]]} | Open Access 1 | 18516 | La Jolla Open Space | 20766 | 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 | San Diego 4 | 2.612 | La Jolla OS | 0 | Local Recreation Area 3 | 4 | |
2778 | 2778 | 2777 | {"type": "Polygon", "coordinates": [[[-117.04655, 32.98981], [-117.04644, 32.99002], [-117.04624, 32.98988], [-117.04549, 32.99], [-117.04438, 32.98961], [-117.04432, 32.98956], [-117.04366, 32.98955], [-117.04282, 32.99048], [-117.04281, 32.99102], [-117.04207, 32.99065], [-117.04173, 32.99079], [-117.04172, 32.99156], [-117.04071, 32.99164], [-117.04067, 32.98935], [-117.04001, 32.98937], [-117.03979, 32.9893], [-117.03874, 32.9893], [-117.03872, 32.98932], [-117.0387, 32.98932], [-117.03452, 32.98928], [-117.03447, 32.98902], [-117.03441, 32.98896], [-117.03432, 32.98895], [-117.03425, 32.98881], [-117.03424, 32.98875], [-117.03456, 32.98881], [-117.03497, 32.98871], [-117.03501, 32.9882], [-117.03501, 32.98798], [-117.0346, 32.98742], [-117.03455, 32.98719], [-117.03413, 32.98665], [-117.03405, 32.9862], [-117.03378, 32.98578], [-117.03374, 32.98563], [-117.03632, 32.98566], [-117.03637, 32.9884], [-117.04066, 32.98844], [-117.04062, 32.98567], [-117.04493, 32.98579], [-117.04494, 32.98939], [-117.04639, 32.98941], [-117.04636, 32.98975], [-117.04655, 32.98981]]]} | Open Access 1 | 18531 | Twin Peaks Open Space | 26620 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | http://powaytrails.com/trails/TwinPeaksTrail/ | San Diego 4 | 81.613 | Twin Peaks OS | 0 | Local Recreation Area 3 | 4 |
2780 | 2780 | 2779 | {"type": "MultiPolygon", "coordinates": [[[[-116.97064, 32.98874], [-116.97048, 32.99571], [-116.97003, 32.99569], [-116.96974, 32.9957], [-116.96935, 32.99576], [-116.96907, 32.99583], [-116.96869, 32.99598], [-116.96747, 32.99662], [-116.96603, 32.99716], [-116.96572, 32.99726], [-116.96537, 32.99735], [-116.965, 32.99742], [-116.9641, 32.99752], [-116.96409, 32.99739], [-116.96193, 32.99737], [-116.96202, 32.99245], [-116.95777, 32.99241], [-116.95776, 32.9887], [-116.96204, 32.98869], [-116.97064, 32.98874]]], [[[-116.97043, 32.99718], [-116.97037, 33.00014], [-116.96611, 33.0001], [-116.96618, 32.99841], [-116.96646, 32.99827], [-116.968, 32.99778], [-116.96936, 32.99733], [-116.97043, 32.99718]]]]} | Open Access 1 | 18539 | Rock Haven Spring Open Space | 24509 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 244.004 | Rock Haven Spring OS | 0 | Local Recreation Area 3 | 4 | |
2787 | 2787 | 2786 | {"type": "MultiPolygon", "coordinates": [[[[-117.1655, 32.74559], [-117.1651, 32.7456], [-117.16509, 32.74433], [-117.1655, 32.74432], [-117.1655, 32.74559]]], [[[-117.16661, 32.74404], [-117.1661, 32.74404], [-117.16611, 32.74459], [-117.16556, 32.7446], [-117.16555, 32.74405], [-117.16556, 32.74392], [-117.16661, 32.7439], [-117.16661, 32.74404]]], [[[-117.16849, 32.74062], [-117.16808, 32.74063], [-117.16809, 32.74086], [-117.16797, 32.74096], [-117.16759, 32.74142], [-117.16751, 32.74153], [-117.16669, 32.74154], [-117.16668, 32.74105], [-117.16763, 32.74103], [-117.16764, 32.74064], [-117.16763, 32.74022], [-117.16809, 32.74021], [-117.16809, 32.73983], [-117.16848, 32.73982], [-117.16849, 32.74062]]], [[[-117.16935, 32.73926], [-117.16914, 32.73957], [-117.16907, 32.7397], [-117.169, 32.73971], [-117.16899, 32.73918], [-117.16934, 32.73918], [-117.16935, 32.73926]]]]} | Open Access 1 | 18557 | Albatross Canyon Open Space | 15332 | 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 | San Diego 4 | 5.812 | Albatross Canyon OS | 0 | Local Recreation Area 3 | 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]);