units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
17,068 rows
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- California Department of Parks and Recreation 201
- California Department of Fish and Wildlife 185
- San Diego, City of 126
- Mountains Recreation and Conservation Authority 112
- Los Angeles, City of 94
- Ventura, City of 93
- East Bay Regional Park District 78
- Los Angeles, County of 58
- United States Fish and Wildlife Service 57
- California State Lands Commission 55
- Long Beach, City of 54
- Roseville, City of 47
- Butte, County of 44
- Poway, City of 43
- United States Forest Service 37
- Midpeninsula Regional Open Space District 35
- San Diego, County of 31
- Orange, County of 31
- El Dorado, County of 31
- San Jose, City of 30
- Irvine, City of 30
- Lake, County of 30
- Torrance, City of 29
- Conejo Open Space Conservation Agency 29
- Yuba County Water Agency 28
- United States National Park Service 26
- Sunrise Recreation and Park District 26
- Valley-Wide Recreation and Park District 25
- Davis, City of 25
- Fresno Metropolitan Flood Control District 25
- …
DES_TP >30
- Local Park 1,113
- Local Recreation Area 747
- Local Other or Unknown 655
- State Conservation Area 180
- Local Conservation Area 174
- Private Conservation 126
- State Park 123
- Private Recreation or Education 119
- State Resource Management Area 65
- State Recreation Area 61
- National Wildlife Refuge 53
- National Forest 36
- State Historic or Cultural Area 31
- Recreation Management Area 18
- National Monument or Landmark 18
- State Other or Unknown 15
- National Park 11
- National Recreation Area 9
- Conservation Area 8
- Private Other or Unknown 8
- National Public Lands 6
- Local Historic or Cultural Area 5
- Private Agricultural 5
- Federal Other or Unknown 4
- Historic or Cultural Area 3
- Resource Management Area 2
- Wilderness Area 1
- Local Resource Management Area 1
- State Wilderness 1
- Area of Critical Environmental Concern 1
- …
AGNCY_NAME >30 ✖
- California Department of Parks and Recreation 184
- California Department of Fish and Wildlife 160
- San Diego, City of 123
- Los Angeles, City of 97
- Ventura, City of 93
- California State Lands Commission 88
- Mountains Recreation and Conservation Authority 80
- Los Angeles, County of 73
- East Bay Regional Park District 60
- United States Fish and Wildlife Service 54
- Long Beach, City of 52
- Roseville, City of 47
- Butte, County of 44
- Poway, City of 43
- United States Forest Service 39
- Midpeninsula Regional Open Space District 34
- Irvine, City of 33
- San Jose, City of 31
- San Diego, County of 31
- Orange, County of 31
- Lake, County of 30
- United States National Park Service 29
- El Dorado, County of 29
- Torrance, City of 28
- Yuba County Water Agency 28
- Fresno Metropolitan Flood Control District 27
- Sunrise Recreation and Park District 26
- United States Bureau of Land Management 25
- Davis, City of 25
- Marin County Open Space District 24
- …
MNG_AG_TYP 28
- City Agency 1,911
- State Agency 496
- County Agency 339
- Recreation/Parks District 315
- Federal Agency 159
- Open Space District 150
- Non Profit - Land Trust 108
- Home Owners Association 94
- County Agency - Parks 63
- Water District 59
- Non Profit - Conservation 57
- Community Services District 39
- Flood District 30
- Non Profit - Other 9
- Irrigation District 7
- Commercial 6
- School District 6
- County Agency - Other 4
- Special District - Other 4
- Transportation Agency 4
- Cemetery District 3
- Joint Powers Authority 3
- Other 3
- Port/Harbor District 2
- Sanitation District 2
- Conservation District 2
- Mitigation Bank 1
- Non Profit - Education 1
ACCESS_TYP 4
- Open Access 3,060
- Restricted Access 455
- No Public Access 219
- Unknown Access 143
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13192 | 13192 | 13191 | {"type": "Polygon", "coordinates": [[[-121.97264, 36.58026], [-121.97194, 36.58041], [-121.97168, 36.58018], [-121.97156, 36.57995], [-121.97243, 36.57965], [-121.97257, 36.57999], [-121.97264, 36.58026]]]} | Open Access 1 | 35189 | S.F.B. Morse Memorial Lot | 28537 | 3016 | Del Monte Forest Foundation 559 | Non Profit 6 | Non Profit - Conservation 12 | http://www.delmonteforestfoundation.org/ | Non Governmental Organization 10 | 3016 | Del Monte Forest Foundation 552 | Non Profit 6 | Non Profit - Conservation 12 | Monterey 14 | 1.252 | S.F.B. Morse Memorial Lot | 0 | Private Conservation 16 | 2 | |
13193 | 13193 | 13192 | {"type": "Polygon", "coordinates": [[[-121.97332, 36.57802], [-121.97338, 36.57809], [-121.97338, 36.57814], [-121.97336, 36.57819], [-121.97331, 36.57824], [-121.97312, 36.57833], [-121.97302, 36.57843], [-121.97297, 36.57853], [-121.97293, 36.57871], [-121.97263, 36.57919], [-121.97258, 36.57922], [-121.97253, 36.57924], [-121.97246, 36.57923], [-121.97242, 36.57921], [-121.9721, 36.57881], [-121.97039, 36.57694], [-121.97018, 36.57673], [-121.97014, 36.57667], [-121.97012, 36.57657], [-121.97014, 36.57584], [-121.97018, 36.57573], [-121.97027, 36.57565], [-121.97038, 36.5756], [-121.97052, 36.57559], [-121.97066, 36.57564], [-121.97074, 36.57569], [-121.97096, 36.57594], [-121.97118, 36.57611], [-121.97227, 36.57678], [-121.97236, 36.57686], [-121.97251, 36.57711], [-121.97271, 36.57731], [-121.97281, 36.57755], [-121.97292, 36.57771], [-121.97307, 36.57787], [-121.97332, 36.57802]]]} | Open Access 1 | 35190 | Crocker Grove | 28538 | 3016 | Del Monte Forest Foundation 559 | Non Profit 6 | Non Profit - Conservation 12 | http://www.delmonteforestfoundation.org/ | Non Governmental Organization 10 | 3016 | Del Monte Forest Foundation 552 | Non Profit 6 | Non Profit - Conservation 12 | Monterey 14 | 12.522 | Crocker Grove | 0 | Private Conservation 16 | 2 | |
13194 | 13194 | 13193 | {"type": "Polygon", "coordinates": [[[-121.53929, 36.84003], [-121.53858, 36.84054], [-121.5378, 36.8404], [-121.5373, 36.84034], [-121.53695, 36.84032], [-121.53817, 36.83949], [-121.53929, 36.84003]]]} | Open Access 1 | 35257 | Lang Street Park | 28553 | 1304 | San Juan Bautista, City of 856 | City 2 | City Agency 2 | http://www.san-juan-bautista.ca.us/ | City 2 | 1304 | San Juan Bautista, City of 834 | City 2 | City Agency 2 | San Benito 38 | 3.062 | Lang Street Park | 0 | Local Park 2 | 4 | |
13195 | 13195 | 13194 | {"type": "Polygon", "coordinates": [[[-117.19256, 32.86403], [-117.19256, 32.86403], [-117.19255, 32.8664], [-117.19248, 32.86635], [-117.19105, 32.86485], [-117.1908, 32.86416], [-117.19111, 32.86402], [-117.19256, 32.86403]]]} | Open Access 1 | 45213 | Pueblo Lands Open Space | 24025 | 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.523 | Pueblo Lands OS | 0 | Local Recreation Area 3 | 4 | |
13196 | 13196 | 13195 | {"type": "Polygon", "coordinates": [[[-120.69671, 35.21015], [-120.69648, 35.21383], [-120.69588, 35.21367], [-120.69582, 35.21305], [-120.69488, 35.21206], [-120.69486, 35.21153], [-120.69523, 35.21097], [-120.69491, 35.21018], [-120.6944, 35.21024], [-120.69417, 35.2098], [-120.6947, 35.20957], [-120.69457, 35.20887], [-120.69452, 35.20886], [-120.69458, 35.20871], [-120.69459, 35.20841], [-120.69464, 35.20835], [-120.69465, 35.20829], [-120.69462, 35.20823], [-120.69456, 35.20817], [-120.69453, 35.20811], [-120.69448, 35.20794], [-120.69445, 35.20779], [-120.69445, 35.20765], [-120.69448, 35.20748], [-120.69452, 35.20733], [-120.69463, 35.20708], [-120.69467, 35.20686], [-120.69465, 35.20663], [-120.69452, 35.20621], [-120.69481, 35.20652], [-120.69538, 35.20694], [-120.69566, 35.20712], [-120.69579, 35.20725], [-120.69597, 35.20768], [-120.69611, 35.20786], [-120.69624, 35.20823], [-120.69638, 35.20857], [-120.69638, 35.20863], [-120.69635, 35.2087], [-120.69619, 35.20887], [-120.69611, 35.20902], [-120.69609, 35.2092], [-120.69612, 35.20937], [-120.69621, 35.20956], [-120.69632, 35.20972], [-120.69671, 35.21015]]]} | No Public Access 3 | 35201 | Lower San Luis Obispo Creek Wetland Preserve | 28539 | 3032 | Land Conservancy of San Luis Obispo County 506 | Non Profit 6 | Non Profit - Land Trust 10 | http://lcslo.org/ | Non Governmental Organization 10 | 3032 | Land Conservancy of San Luis Obispo County 498 | Non Profit 6 | Non Profit - Land Trust 10 | San Luis Obispo 1 | 25.543 | Lower San Luis Obispo Creek Wetland Preserve | 0 | Private Conservation 16 | 2 | |
13197 | 13197 | 13196 | {"type": "Polygon", "coordinates": [[[-122.00596, 37.00462], [-122.00509, 37.00463], [-122.00509, 37.00415], [-122.00596, 37.00415], [-122.00596, 37.00462]]]} | Open Access 1 | 35209 | Santa Cruz holding 5 | 28176 | 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 | 1.015 | Santa Cruz holding 5 | 0 | Local Other or Unknown 14 | 4 | |
13198 | 13198 | 13197 | {"type": "Polygon", "coordinates": [[[-121.48678, 39.51389], [-121.48532, 39.5139], [-121.48532, 39.51387], [-121.48603, 39.51387], [-121.48603, 39.51308], [-121.48676, 39.51308], [-121.48678, 39.51389]]]} | Open Access 1 | 36274 | Butte holding 1 | 16552 | 342 | Butte, County of 705 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 342 | Butte, County of 692 | County 3 | County Agency 3 | Butte 42 | 1.474 | Butte holding 1 | 0 | Local Other or Unknown 14 | 4 | |
13199 | 13199 | 13198 | {"type": "Polygon", "coordinates": [[[-122.02701, 37.01206], [-122.02689, 37.01231], [-122.02679, 37.01235], [-122.02626, 37.01189], [-122.02641, 37.01177], [-122.02654, 37.01175], [-122.02663, 37.01179], [-122.02701, 37.01206]]]} | Open Access 1 | 35226 | Santa Cruz holding 13 | 28177 | 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.557 | Santa Cruz holding 13 | 0 | Local Other or Unknown 14 | 4 | |
13200 | 13200 | 13199 | {"type": "Polygon", "coordinates": [[[-120.14624, 34.60823], [-120.14615, 34.60863], [-120.14538, 34.60859], [-120.14546, 34.60827], [-120.14599, 34.60822], [-120.14624, 34.60823]]]} | Open Access 1 | 35228 | Solvang holding 1 | 25601 | 1337 | Solvang, City of 81 | City 2 | City Agency 2 | http://www.cityofsolvang.com/index.php/departments/parks-a-recreation | City 2 | 1337 | Solvang, City of 79 | City 2 | City Agency 2 | Santa Barbara 7 | 0.735 | Solvang holding 1 | 0 | Local Other or Unknown 14 | 4 | |
13201 | 13201 | 13200 | {"type": "Polygon", "coordinates": [[[-119.80136, 34.43599], [-119.80122, 34.43578], [-119.80125, 34.43551], [-119.80131, 34.4355], [-119.80138, 34.43544], [-119.80144, 34.43543], [-119.80151, 34.43544], [-119.80177, 34.43554], [-119.8019, 34.43557], [-119.80203, 34.43557], [-119.80218, 34.43556], [-119.80222, 34.43559], [-119.8022, 34.43567], [-119.80216, 34.43575], [-119.8021, 34.43582], [-119.80202, 34.43587], [-119.80193, 34.4359], [-119.80149, 34.43595], [-119.80136, 34.43599]]]} | Open Access 1 | 35221 | Thunderbird Open Space | 28546 | 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 | 0.941 | Thunderbird OS | 0 | Local Recreation Area 3 | 4 | |
13202 | 13202 | 13201 | {"type": "Polygon", "coordinates": [[[-121.8188, 36.64408], [-121.81752, 36.645], [-121.81716, 36.64519], [-121.8167, 36.64538], [-121.81614, 36.64577], [-121.8157, 36.64624], [-121.81464, 36.64706], [-121.81306, 36.64751], [-121.81209, 36.64756], [-121.81208, 36.64729], [-121.81212, 36.64711], [-121.8122, 36.64695], [-121.81231, 36.64679], [-121.81314, 36.64588], [-121.81322, 36.64576], [-121.81327, 36.64563], [-121.81328, 36.64549], [-121.81331, 36.64427], [-121.81329, 36.64421], [-121.81326, 36.64417], [-121.81319, 36.64414], [-121.81313, 36.64413], [-121.81314, 36.64395], [-121.81695, 36.64406], [-121.8188, 36.64408]]]} | Open Access 1 | 35258 | Seaside holding 9 | 25265 | 1330 | Seaside, City of 115 | City 2 | City Agency 2 | http://www.ci.seaside.ca.us/index.aspx?page=313 | City 2 | 1330 | Seaside, City of 112 | City 2 | City Agency 2 | Monterey 14 | 29.165 | Seaside holding 9 | 0 | Local Other or Unknown 14 | 4 | |
13203 | 13203 | 13202 | {"type": "Polygon", "coordinates": [[[-121.80186, 36.69126], [-121.8018, 36.69183], [-121.80169, 36.69184], [-121.80121, 36.69177], [-121.80105, 36.69183], [-121.80105, 36.69187], [-121.8004, 36.69199], [-121.79878, 36.69216], [-121.7988, 36.69187], [-121.7988, 36.69171], [-121.79991, 36.69038], [-121.80005, 36.69047], [-121.79996, 36.69061], [-121.79989, 36.6908], [-121.79987, 36.691], [-121.79991, 36.69115], [-121.79995, 36.69126], [-121.80003, 36.69139], [-121.80012, 36.69149], [-121.80029, 36.6916], [-121.80043, 36.69166], [-121.80171, 36.69145], [-121.80186, 36.69126]]]} | Open Access 1 | 35197 | Monterey Peninsula Regional Park District 1 | 22424 | 2085 | Monterey Peninsula Regional Park District 47 | Special District 4 | Recreation/Parks District 4 | http://www.mprpd.org/ | Special District 4 | 2085 | Monterey Peninsula Regional Park District 46 | Special District 4 | Recreation/Parks District 4 | Monterey 14 | 4.709 | Monterey Peninsula RP District 1 | None 1150 | |||
13204 | 13204 | 13203 | {"type": "Polygon", "coordinates": [[[-116.31502, 34.13125], [-116.31407, 34.13125], [-116.31373, 34.1311], [-116.314, 34.13093], [-116.3143, 34.13079], [-116.31462, 34.1307], [-116.31496, 34.13065], [-116.315, 34.13067], [-116.31502, 34.1307], [-116.31502, 34.13125]]]} | Open Access 1 | 35207 | Joshua Tree Park and Recreation District 1 | 20507 | 2230 | Joshua Tree Park and Recreation District 627 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 2230 | Joshua Tree Park and Recreation District 616 | Special District 4 | Recreation/Parks District 4 | San Bernardino 22 | 1.384 | Joshua Tree Park and Rec. District 1 | 0 | Local Recreation Area 3 | 4 | ||
13205 | 13205 | 13204 | {"type": "MultiPolygon", "coordinates": [[[[-116.92352, 32.60821], [-116.9235, 32.61195], [-116.91216, 32.61202], [-116.91078, 32.61199], [-116.91094, 32.61568], [-116.90658, 32.61567], [-116.90666, 32.61927], [-116.90219, 32.61927], [-116.90214, 32.61198], [-116.91078, 32.61199], [-116.9108, 32.60449], [-116.91928, 32.60446], [-116.91928, 32.6082], [-116.92352, 32.60821]]], [[[-116.91632, 32.65562], [-116.91629, 32.65938], [-116.91356, 32.65931], [-116.91311, 32.65864], [-116.91287, 32.65836], [-116.91254, 32.65791], [-116.91207, 32.65716], [-116.91169, 32.65659], [-116.91154, 32.65645], [-116.91128, 32.65626], [-116.91056, 32.65556], [-116.91239, 32.65554], [-116.91632, 32.65562]]]]} | Open Access 1 | 45236 | Otay Ranch Preserve | 10734 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/pds/mscp/or.html | San Diego 4 | 368.875 | Otay Ranch Preserve | 0 | Local Conservation Area 4 | 2 |
13206 | 13206 | 13205 | {"type": "Polygon", "coordinates": [[[-122.07216, 37.00872], [-122.07141, 37.00885], [-122.07125, 37.00838], [-122.07203, 37.00825], [-122.07216, 37.00872]]]} | Open Access 1 | 35234 | Santa Cruz holding 7 | 28173 | 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.932 | Santa Cruz holding 7 | 0 | Local Other or Unknown 14 | 4 | |
13207 | 13207 | 13206 | {"type": "Polygon", "coordinates": [[[-121.97361, 36.96111], [-121.97328, 36.96111], [-121.97328, 36.96082], [-121.97361, 36.96083], [-121.97361, 36.96111]]]} | Open Access 1 | 35236 | Santa Cruz holding 8 | 25078 | 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.232 | Santa Cruz holding 8 | 0 | Local Other or Unknown 14 | 4 | |
13208 | 13208 | 13207 | {"type": "Polygon", "coordinates": [[[-120.45602, 34.63102], [-120.45601, 34.6313], [-120.45541, 34.63129], [-120.45542, 34.63102], [-120.45602, 34.63102]]]} | Open Access 1 | 35243 | Lompoc holding 3 | 21429 | 1183 | Lompoc, City of 39 | City 2 | City Agency 2 | http://www.cityoflompoc.com/parks_rec/ | City 2 | 1183 | Lompoc, City of 38 | City 2 | City Agency 2 | Santa Barbara 7 | 0.414 | Lompoc holding 3 | 0 | Local Other or Unknown 14 | 4 | |
13209 | 13209 | 13208 | {"type": "Polygon", "coordinates": [[[-121.80773, 36.57658], [-121.80773, 36.58183], [-121.80616, 36.58125], [-121.80561, 36.58087], [-121.80526, 36.58066], [-121.80482, 36.58044], [-121.80434, 36.58027], [-121.8037, 36.58007], [-121.80214, 36.57966], [-121.80143, 36.57949], [-121.80018, 36.57927], [-121.7979, 36.5789], [-121.79696, 36.57877], [-121.79602, 36.57867], [-121.79506, 36.57859], [-121.7945, 36.57856], [-121.7935, 36.57873], [-121.79326, 36.57873], [-121.79638, 36.57817], [-121.79781, 36.57789], [-121.80394, 36.5768], [-121.80635, 36.57633], [-121.80665, 36.57631], [-121.80695, 36.57632], [-121.80735, 36.57641], [-121.8076, 36.57651], [-121.80773, 36.57658]]]} | Open Access 1 | 35245 | Monterey holding 2 | 22422 | 1212 | Monterey, City of 37 | City 2 | City Agency 2 | http://monterey.org/en-us/Departments/Monterey-Recreation/Parks-and-Beaches | City 2 | 1212 | Monterey, City of 36 | City 2 | City Agency 2 | Monterey 14 | 77.51 | Monterey holding 2 | 0 | Local Other or Unknown 14 | 4 | |
13210 | 13210 | 13209 | {"type": "Polygon", "coordinates": [[[-120.45534, 34.63198], [-120.45534, 34.63209], [-120.45504, 34.63209], [-120.45504, 34.63198], [-120.45534, 34.63198]]]} | Open Access 1 | 35246 | Lompoc holding 4 | 21430 | 1183 | Lompoc, City of 39 | City 2 | City Agency 2 | http://www.cityoflompoc.com/parks_rec/ | City 2 | 1183 | Lompoc, City of 38 | City 2 | City Agency 2 | Santa Barbara 7 | 0.083 | Lompoc holding 4 | 0 | Local Other or Unknown 14 | 4 | |
13211 | 13211 | 13210 | {"type": "Polygon", "coordinates": [[[-120.65903, 35.28087], [-120.65874, 35.28105], [-120.65843, 35.2807], [-120.65888, 35.2807], [-120.65903, 35.28087]]]} | Open Access 1 | 35247 | Cheng Park | 28552 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 0.288 | Cheng 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]);