units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
14,510 rows where ACCESS_TYP = 1 sorted by YR_EST
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 30
- City Agency 9,911
- County Agency 1,096
- Recreation/Parks District 991
- State Agency 824
- Federal Agency 397
- Open Space District 247
- County Agency - Parks 206
- Non Profit - Land Trust 205
- Community Services District 194
- Water District 113
- Cemetery District 62
- Non Profit - Conservation 55
- Flood District 40
- Non Profit - Other 35
- Port/Harbor District 33
- County Agency - Other 20
- Irrigation District 17
- Special District - Other 15
- Sanitation District 6
- Commercial 5
- Non Profit - Cemetery District 5
- Joint Powers Authority 2
- Other 2
- Conservation District 2
- Non Profit - Education 2
- Airport District 1
- Metropolitan Planning Organization 1
- Utility 1
- Fire District 1
- Transportation Agency 1
MNG_AGENCY >30
- San Diego, City of 503
- Los Angeles, City of 432
- California Department of Parks and Recreation 354
- California Department of Fish and Wildlife 293
- San Jose, City of 247
- San Francisco, City and County of 238
- Sacramento, City of 216
- Mountains Recreation and Conservation Authority 190
- Los Angeles, County of 153
- Ventura, City of 148
- Long Beach, City of 135
- Roseville, City of 123
- Oakland, City of 122
- United States Forest Service 109
- United States Bureau of Land Management 105
- Santa Barbara, County of 105
- San Diego, County of 104
- East Bay Regional Park District 101
- Irvine, City of 100
- Consumnes Community Services District 94
- Fresno, City of 92
- Orange, County of 88
- United States National Park Service 80
- Modesto, City of 78
- Hayward Area Recreation and Park District 77
- Stockton, City of 77
- Huntington Beach, City of 76
- California State Lands Commission 73
- Tracy, City of 73
- Santa Rosa, City of 72
- …
DES_TP >30
- Local Park 9,084
- Local Recreation Area 1,640
- Local Other or Unknown 859
- Local Conservation Area 350
- State Conservation Area 250
- Private Conservation 212
- State Park 199
- State Recreation Area 140
- Local Historic or Cultural Area 113
- National Forest 99
- State Resource Management Area 81
- National Public Lands 64
- State Historic or Cultural Area 59
- Recreation Management Area 50
- Private Recreation or Education 48
- National Recreation Area 38
- National Monument or Landmark 33
- State Other or Unknown 32
- National Wildlife Refuge 25
- National Park 22
- Resource Management Area 20
- Federal Other or Unknown 14
- Local Resource Management Area 11
- Private Other or Unknown 9
- Conservation Area 6
- Wilderness Area 6
- Area of Critical Environmental Concern 6
- Historic or Cultural Area 5
- Private Historic or Cultural 4
- Private Agricultural 3
- …
ACCESS_TYP 1
- Open Access · 14,490 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
426 | 426 | 425 | {"type": "MultiPolygon", "coordinates": [[[[-122.54467, 38.63634], [-122.54012, 38.63646], [-122.54006, 38.65103], [-122.53546, 38.65099], [-122.53551, 38.64373], [-122.52645, 38.64367], [-122.52656, 38.64004], [-122.52204, 38.64003], [-122.52219, 38.63641], [-122.5214, 38.6255], [-122.52598, 38.62553], [-122.52577, 38.62209], [-122.52841, 38.62192], [-122.53977, 38.62201], [-122.54003, 38.62199], [-122.54431, 38.62189], [-122.5444, 38.62378], [-122.54448, 38.62912], [-122.54467, 38.63634]], [[-122.54011, 38.63644], [-122.54012, 38.63643], [-122.53988, 38.62923], [-122.52622, 38.62917], [-122.52645, 38.63279], [-122.53549, 38.63283], [-122.53564, 38.63643], [-122.54008, 38.63642], [-122.54011, 38.63644]]], [[[-122.56278, 38.61434], [-122.55805, 38.61443], [-122.5534, 38.6145], [-122.55346, 38.61809], [-122.54883, 38.61821], [-122.54419, 38.6183], [-122.54405, 38.61108], [-122.54868, 38.611], [-122.54863, 38.60741], [-122.55798, 38.6073], [-122.56112, 38.60719], [-122.5627, 38.60725], [-122.56278, 38.61434]]]]} | Open Access 1 | 1318 | Swartz Canyon | 1994 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 209 | California State Lands Commission 73 | State 5 | State Agency 5 | Napa 11 | 1307.545 | Swartz Canyon | None 43 | |||
434 | 434 | 433 | {"type": "Polygon", "coordinates": [[[-122.3521, 38.44442], [-122.34572, 38.4492], [-122.34565, 38.44615], [-122.3358, 38.44548], [-122.3314, 38.44557], [-122.33138, 38.4492], [-122.3184, 38.44966], [-122.29917, 38.448], [-122.29908, 38.44438], [-122.31821, 38.44584], [-122.31804, 38.44201], [-122.33143, 38.44194], [-122.33145, 38.43832], [-122.32239, 38.43823], [-122.32228, 38.43447], [-122.33607, 38.43482], [-122.34065, 38.43479], [-122.34065, 38.43521], [-122.34066, 38.43522], [-122.3429, 38.43515], [-122.34817, 38.43528], [-122.34848, 38.43602], [-122.34809, 38.44201], [-122.3521, 38.44442]]]} | Open Access 1 | 837 | Silverado Trail Rector Dam Watershed | 1818 | 206 | California Department of Veterans Affairs 170 | State 5 | State Agency 5 | http://www.cdva.ca.gov/ | Other State 5 | 206 | California Department of Veterans Affairs 166 | State 5 | State Agency 5 | Napa 11 | 959.679 | Silverado Trail Rector Dam Watershed | None 44 | |||
436 | 436 | 435 | {"type": "MultiPolygon", "coordinates": [[[[-122.50735, 38.11473], [-122.50721, 38.11477], [-122.50708, 38.11492], [-122.50687, 38.11486], [-122.50673, 38.11475], [-122.50645, 38.11496], [-122.50608, 38.11467], [-122.50597, 38.11454], [-122.5062, 38.11444], [-122.50605, 38.11434], [-122.50643, 38.1142], [-122.50655, 38.11334], [-122.50673, 38.11403], [-122.50667, 38.11408], [-122.50674, 38.11407], [-122.50688, 38.11442], [-122.5068, 38.1145], [-122.50682, 38.11454], [-122.50703, 38.11464], [-122.50716, 38.11469], [-122.50735, 38.11473]]], [[[-122.50745, 38.11324], [-122.50722, 38.11345], [-122.50723, 38.11346], [-122.50737, 38.11346], [-122.50737, 38.11352], [-122.50703, 38.11382], [-122.50688, 38.11383], [-122.50682, 38.11385], [-122.50685, 38.11358], [-122.50677, 38.11331], [-122.50745, 38.11324]]]]} | Open Access 1 | 840 | Black Point Boat Launch | 16137 | 306 | Marin County Parks Department, County of 154 | County 3 | County Agency - Parks 7 | http://www.marincountyparks.org/depts/pk | County 3 | 306 | Marin County Parks Department, County of 150 | County 3 | County Agency - Parks 7 | Marin 23 | 2.255 | Black Point Boat Launch | None 45 | |||
456 | 456 | 455 | {"type": "MultiPolygon", "coordinates": [[[[-122.00177, 36.96808], [-122.00152, 36.9681], [-122.0015, 36.96795], [-122.00161, 36.96797], [-122.00162, 36.96796], [-122.00175, 36.96793], [-122.00177, 36.96808]]], [[[-122.00288, 36.96971], [-122.00236, 36.97013], [-122.00204, 36.97012], [-122.00244, 36.9697], [-122.00288, 36.96971]]]]} | Open Access 1 | 1471 | Twin Lakes | 26614 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.cityofsantacruz.com/departments/parks-recreation | City 2 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | Santa Cruz 5 | 0.484 | Twin Lakes | None 47 | |||
460 | 460 | 459 | {"type": "Polygon", "coordinates": [[[-117.24981, 33.2545], [-117.24943, 33.25596], [-117.245, 33.25509], [-117.245, 33.25326], [-117.24532, 33.25324], [-117.24564, 33.25323], [-117.24597, 33.25326], [-117.2464, 33.25334], [-117.24907, 33.2543], [-117.24981, 33.2545]]]} | Open Access 1 | 1842 | San Luis Rey River | 24941 | 1230 | Oceanside, City of 77 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/ | City 2 | 1230 | Oceanside, City of 75 | City 2 | City Agency 2 | San Diego 4 | 21.567 | San Luis Rey River | None 48 | |||
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 | ||
576 | 576 | 575 | {"type": "Polygon", "coordinates": [[[-122.14526, 37.74311], [-122.14524, 37.74315], [-122.14492, 37.74341], [-122.14434, 37.74398], [-122.14423, 37.74406], [-122.1437, 37.7433], [-122.14342, 37.74306], [-122.14482, 37.7425], [-122.14526, 37.74311]]]} | Open Access 1 | 3448 | Poaks Headquarters | 23819 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 3.419 | Poaks Headquarters | None 57 | |||
587 | 587 | 586 | {"type": "Polygon", "coordinates": [[[-119.01482, 34.20968], [-119.01465, 34.21039], [-119.01452, 34.21114], [-119.01418, 34.21111], [-119.014, 34.21118], [-119.01319, 34.21098], [-119.01318, 34.21095], [-119.01357, 34.20947], [-119.01362, 34.20945], [-119.01422, 34.20959], [-119.01433, 34.20959], [-119.01441, 34.20956], [-119.01445, 34.20961], [-119.01482, 34.20968]]]} | Open Access 1 | 1987 | Woodside Park - PVRPD | 27744 | 2113 | Pleasant Valley Recreation and Park District 149 | Special District 4 | Recreation/Parks District 4 | http://www.pvrpd.org/ | Special District 4 | 2113 | Pleasant Valley Recreation and Park District 145 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 5.147 | Woodside Park - PVRPD | None 58 | |||
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 | ||
653 | 653 | 652 | {"type": "Polygon", "coordinates": [[[-118.76961, 34.09844], [-118.76746, 34.09841], [-118.76746, 34.09748], [-118.76959, 34.09752], [-118.76961, 34.09844]]]} | Open Access 1 | 5014 | Malibu Creek State Park - Randa House | 29629 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.parks.ca.gov/?page_id=614 | Los Angeles 6 | 5.064 | Malibu Creek SP - Randa House | None 62 | ||
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 | |||
758 | 758 | 757 | {"type": "Polygon", "coordinates": [[[-122.55923, 37.90312], [-122.55909, 37.9032], [-122.55885, 37.90307], [-122.55846, 37.90316], [-122.55821, 37.90333], [-122.55809, 37.90333], [-122.5574, 37.9029], [-122.55707, 37.90266], [-122.5576, 37.90241], [-122.55842, 37.90238], [-122.55874, 37.90234], [-122.55897, 37.9025], [-122.5592, 37.90278], [-122.55923, 37.90312]]]} | Open Access 1 | 4950 | Watershed Lands | 27306 | 2071 | Marin Municipal Water District 254 | Special District 4 | Water District 13 | http://www.marinwater.org/ | Special District 4 | 2071 | Marin Municipal Water District 250 | Special District 4 | Water District 13 | Marin 23 | 3.312 | Watershed Lands | None 70 | |||
759 | 759 | 758 | {"type": "Polygon", "coordinates": [[[-122.5442, 37.91301], [-122.54403, 37.91312], [-122.54383, 37.91293], [-122.54399, 37.91283], [-122.54405, 37.91288], [-122.54417, 37.91281], [-122.5442, 37.91301]]]} | Open Access 1 | 4954 | Watershed Lands | 27306 | 2071 | Marin Municipal Water District 254 | Special District 4 | Water District 13 | http://www.marinwater.org/ | Special District 4 | 2071 | Marin Municipal Water District 250 | Special District 4 | Water District 13 | Marin 23 | 0.152 | Watershed Lands | None 71 | |||
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 | |||
862 | 862 | 861 | {"type": "MultiPolygon", "coordinates": [[[[-122.44333, 37.73556], [-122.44313, 37.73558], [-122.44241, 37.73578], [-122.44241, 37.73539], [-122.44331, 37.73537], [-122.44333, 37.73556]]], [[[-122.44368, 37.73938], [-122.44259, 37.73944], [-122.44255, 37.73931], [-122.44256, 37.73921], [-122.44259, 37.73912], [-122.44267, 37.73868], [-122.44269, 37.73845], [-122.44264, 37.73816], [-122.44246, 37.73767], [-122.44246, 37.73757], [-122.44249, 37.73744], [-122.44257, 37.73728], [-122.44269, 37.73716], [-122.44346, 37.73669], [-122.44358, 37.7381], [-122.44349, 37.73818], [-122.44344, 37.73829], [-122.44338, 37.73885], [-122.44341, 37.73894], [-122.44347, 37.73903], [-122.44356, 37.73911], [-122.44367, 37.73917], [-122.44368, 37.73938]]], [[[-122.44373, 37.73995], [-122.44352, 37.73987], [-122.44296, 37.73975], [-122.44281, 37.73967], [-122.44271, 37.7396], [-122.4437, 37.73954], [-122.44373, 37.73995]]], [[[-122.44456, 37.74017], [-122.44413, 37.74021], [-122.44402, 37.74012], [-122.44397, 37.7396], [-122.44443, 37.73996], [-122.44456, 37.74017]]], [[[-122.44606, 37.74084], [-122.44535, 37.74089], [-122.44491, 37.74082], [-122.44474, 37.74076], [-122.44454, 37.74065], [-122.44437, 37.7405], [-122.44425, 37.74033], [-122.44464, 37.7403], [-122.4448, 37.74057], [-122.4449, 37.74061], [-122.44511, 37.74067], [-122.44576, 37.74076], [-122.44606, 37.74084]]], [[[-122.44842, 37.74265], [-122.44711, 37.74253], [-122.44681, 37.74245], [-122.44656, 37.74233], [-122.44641, 37.74222], [-122.4463, 37.74206], [-122.44626, 37.74193], [-122.44622, 37.7415], [-122.44617, 37.74137], [-122.44609, 37.74122], [-122.44609, 37.74118], [-122.4462, 37.74109], [-122.44632, 37.74106], [-122.44643, 37.74117], [-122.44652, 37.74132], [-122.44657, 37.74144], [-122.4466, 37.74158], [-122.44659, 37.74176], [-122.44665, 37.74191], [-122.44677, 37.74209], [-122.44687, 37.74219], [-122.44699, 37.74227], [-122.44714, 37.74234], [-122.4473, 37.74235], [-122.44731, 37.74229], [-122.44768, 37.74232], [-122.44765, 37.7425], [-122.44842, 37.74257], [-122.44842, 37.74265]]], [[[-122.44946, 37.74283], [-122.44941, 37.7429], [-122.44925, 37.74282], [-122.44905, 37.74275], [-122.44863, 37.74267], [-122.44863, 37.74259], [-122.44905, 37.74267], [-122.44926, 37.74274], [-122.44946, 37.74283]]], [[[-122.45165, 37.74524], [-122.45158, 37.74527], [-122.45152, 37.74525], [-122.45075, 37.74432], [-122.45075, 37.74419], [-122.45081, 37.74427], [-122.45083, 37.74426], [-122.45083, 37.74424], [-122.45093, 37.74441], [-122.45165, 37.74524]]]]} | Open Access 1 | 5544 | Reservoir Lands (Glen Park) | 24301 | 321 | San Francisco - Public Utilities Commission, City and County of 31 | County 3 | County Agency - Other 9 | http://sfwater.org/ | County 3 | 321 | San Francisco - Public Utilities Commission, City and County of 30 | County 3 | County Agency - Other 8 | San Francisco 13 | 10.112 | Reservoir Lands (Glen Park) | None 79 |
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]);