units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
17,068 rows sorted by UNIT_NAME
This data as json, copyable, CSV (advanced)
MNG_AG_TYP >30
- City Agency 9,786
- County Agency 1,142
- Recreation/Parks District 1,086
- State Agency 1,061
- Non Profit - Land Trust 574
- Federal Agency 424
- Open Space District 412
- Water District 233
- County Agency - Parks 217
- Home Owners Association 194
- Community Services District 182
- Non Profit - Conservation 142
- Flood District 78
- Cemetery District 59
- Irrigation District 50
- Non Profit - Other 45
- School District 35
- County Agency - Other 34
- Port/Harbor District 31
- Commercial 15
- Special District - Other 12
- Sanitation District 9
- Joint Powers Authority 8
- Other 5
- Non Profit - Cemetery District 5
- Conservation District 5
- Mitigation Bank 4
- Transportation Agency 4
- Non Profit - Education 3
- Metropolitan Planning Organization 2
- …
MNG_AGENCY >30
- San Diego, City of 506
- Los Angeles, City of 441
- California Department of Fish and Wildlife 411
- California Department of Parks and Recreation 343
- Mountains Recreation and Conservation Authority 338
- San Jose, City of 235
- San Francisco, City and County of 214
- Sacramento, City of 204
- East Bay Regional Park District 157
- Los Angeles, County of 155
- Ventura, City of 148
- Long Beach, City of 133
- Roseville, City of 126
- San Diego, County of 113
- Santa Barbara, County of 110
- United States Forest Service 107
- Oakland, City of 107
- Irvine, City of 100
- Orange, County of 89
- Fresno, City of 88
- California State Lands Commission 86
- Consumnes Community Services District 86
- United States National Park Service 85
- Modesto, City of 80
- Hayward Area Recreation and Park District 79
- United States Fish and Wildlife Service 78
- Napa, City of 77
- Santa Rosa, City of 76
- Stockton, City of 73
- Huntington Beach, City of 70
- …
DES_TP >30
- Local Park 8,702
- Local Recreation Area 1,847
- Local Other or Unknown 1,162
- Private Conservation 601
- Local Conservation Area 455
- State Conservation Area 355
- Private Recreation or Education 254
- State Park 193
- State Resource Management Area 154
- State Recreation Area 125
- Local Historic or Cultural Area 110
- National Forest 95
- National Wildlife Refuge 74
- State Other or Unknown 67
- State Historic or Cultural Area 59
- Recreation Management Area 54
- Private Other or Unknown 51
- National Monument or Landmark 39
- National Recreation Area 37
- National Park 26
- Resource Management Area 25
- Federal Other or Unknown 24
- Local Resource Management Area 22
- Private Agricultural 12
- Conservation Area 11
- Wilderness Area 7
- Area of Critical Environmental Concern 7
- Historic or Cultural Area 5
- Private Historic or Cultural 4
- National Public Lands 3
- …
ACCESS_TYP 4
- Open Access 13,454
- Restricted Access 1,121
- No Public Access 913
- Unknown Access 371
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5737 | 5737 | 5736 | {"type": "Polygon", "coordinates": [[[-119.5816, 36.67854], [-119.58049, 36.67855], [-119.58052, 36.67774], [-119.58158, 36.67773], [-119.5816, 36.6778], [-119.5816, 36.67854]]]} | Open Access 1 | 1770 | Bethel Cemetery | 16047 | 2138 | Sanger/Del Rey Cemetery District 815 | Special District 4 | Cemetery District 11 | Special District 4 | 2138 | Sanger/Del Rey Cemetery District 794 | Special District 4 | Cemetery District 11 | Fresno 9 | 2.179 | Bethel Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | ||
992 | 992 | 991 | {"type": "Polygon", "coordinates": [[[-117.21966, 33.87834], [-117.21749, 33.87836], [-117.21748, 33.87735], [-117.21965, 33.87736], [-117.21966, 33.87834]]]} | Open Access 1 | 5497 | Bethune Park | 16048 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | http://www.moreno-valley.ca.us/city_hall/departments/pcs/index-parks.shtml | City 2 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | Riverside 10 | 5.479 | Bethune Park | 0 | Local Park 2 | 4 | |
11759 | 11759 | 11758 | {"type": "Polygon", "coordinates": [[[-121.43856, 38.4322], [-121.43773, 38.43316], [-121.43751, 38.43309], [-121.4383, 38.43218], [-121.43841, 38.43218], [-121.43856, 38.4322]]]} | Open Access 1 | 24052 | Betschart Park | 16049 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | Sacramento 41 | 0.634 | Betschart Park | 0 | Local Park 2 | 4 | |
12543 | 12543 | 12542 | {"type": "Polygon", "coordinates": [[[-121.44049, 38.4306], [-121.44003, 38.4306], [-121.43918, 38.43156], [-121.43899, 38.43148], [-121.43873, 38.43143], [-121.43846, 38.43139], [-121.43708, 38.43138], [-121.43685, 38.43139], [-121.43668, 38.43144], [-121.43645, 38.43151], [-121.43619, 38.43155], [-121.43418, 38.43163], [-121.43414, 38.43161], [-121.43412, 38.43158], [-121.43412, 38.43063], [-121.43409, 38.43062], [-121.43409, 38.43039], [-121.4341, 38.43035], [-121.43413, 38.43034], [-121.43492, 38.43033], [-121.43493, 38.43062], [-121.43972, 38.4306], [-121.43973, 38.43003], [-121.43984, 38.43003], [-121.44029, 38.43008], [-121.44049, 38.43016], [-121.44049, 38.4306]]]} | Open Access 1 | 29047 | Betschart Park | 16049 | 2194 | Consumnes Community Services District 567 | Special District 4 | Community Services District 19 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | Sacramento 41 | 13.204 | Betschart Park | 0 | Local Park 2 | 4 | |
1586 | 1586 | 1585 | {"type": "Polygon", "coordinates": [[[-117.06676, 32.94232], [-117.06643, 32.94283], [-117.06594, 32.94275], [-117.06601, 32.94232], [-117.06676, 32.94232]]]} | Open Access 1 | 12145 | Bette Bendixen Park | 16050 | 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://poway.org/Facilities/Facility/Details/Bette-Bendixen-Park-60 | San Diego 4 | 0.774 | Bette Bendixen Park | 0 | Local Park 2 | 4 |
772 | 772 | 771 | {"type": "Polygon", "coordinates": [[[-118.04189, 33.86024], [-118.04187, 33.8616], [-118.04175, 33.8616], [-118.0409, 33.86124], [-118.04104, 33.86112], [-118.04104, 33.86109], [-118.04097, 33.86103], [-118.04189, 33.86024]]]} | Open Access 1 | 4495 | Bettencourt Park | 29947 | 1051 | Cerritos, City of 225 | City 2 | City Agency 2 | http://www.ci.cerritos.ca.us/ | City 2 | 1051 | Cerritos, City of 221 | City 2 | City Agency 2 | Orange 3 | 1.883 | Bettencourt Park | 0 | Local Park 2 | 4 | |
16229 | 16229 | 16228 | {"type": "Polygon", "coordinates": [[[-122.41218, 37.79435], [-122.41147, 37.79444], [-122.41139, 37.79407], [-122.4121, 37.79398], [-122.41218, 37.79435]]]} | Open Access 1 | 47172 | Betty Ong Recreation Center | 30863 | 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 | http://sfrecpark.org/destination/betty-ong-rec-center/ | San Francisco 13 | 0.653 | Betty Ong Rec. Ctr. | 0 | Local Recreation Area 3 | 4 |
15259 | 15259 | 15258 | {"type": "Polygon", "coordinates": [[[-118.39973, 34.0679], [-118.39891, 34.06846], [-118.3987, 34.06824], [-118.39952, 34.06768], [-118.39973, 34.0679]]]} | Open Access 1 | 46324 | Beverly Canon Gardens Park | 29610 | 1029 | Beverly Hills, City of 204 | City 2 | City Agency 2 | http://www.beverlyhills.org/living/recreationparks/ | City 2 | 1029 | Beverly Hills, City of 200 | City 2 | City Agency 2 | Los Angeles 6 | 0.735 | Beverly Canon Gardens Park | 0 | Local Park 2 | 4 | |
5309 | 5309 | 5308 | {"type": "Polygon", "coordinates": [[[-118.4146, 34.06717], [-118.41459, 34.06739], [-118.41341, 34.06736], [-118.41217, 34.06729], [-118.41035, 34.06755], [-118.39058, 34.0811], [-118.38983, 34.08056], [-118.40966, 34.06717], [-118.4146, 34.06717]]]} | Open Access 1 | 4585 | Beverly Gardens Park | 16052 | 1029 | Beverly Hills, City of 204 | City 2 | City Agency 2 | http://www.beverlyhills.org/living/recreationparks/ | City 2 | 1029 | Beverly Hills, City of 200 | City 2 | City Agency 2 | Los Angeles 6 | 50.415 | Beverly Gardens Park | 0 | Local Park 2 | 4 | |
7227 | 7227 | 7226 | {"type": "MultiPolygon", "coordinates": [[[[-118.44706, 34.11605], [-118.44644, 34.11605], [-118.44654, 34.11542], [-118.44655, 34.11514], [-118.44658, 34.1151], [-118.44665, 34.1151], [-118.44668, 34.11513], [-118.44706, 34.11605]]], [[[-118.44618, 34.11604], [-118.44484, 34.11604], [-118.44484, 34.1151], [-118.44451, 34.1151], [-118.4445, 34.11352], [-118.44396, 34.11337], [-118.44376, 34.11384], [-118.44371, 34.11405], [-118.44371, 34.11421], [-118.44373, 34.11433], [-118.44387, 34.11474], [-118.44384, 34.1148], [-118.44378, 34.11479], [-118.44346, 34.11499], [-118.44346, 34.11536], [-118.44338, 34.11548], [-118.44279, 34.11594], [-118.44274, 34.11612], [-118.44265, 34.11627], [-118.44222, 34.11633], [-118.44215, 34.11642], [-118.4422, 34.11662], [-118.44246, 34.11684], [-118.44251, 34.11711], [-118.4426, 34.11728], [-118.44245, 34.11747], [-118.44228, 34.11752], [-118.44193, 34.11748], [-118.4418, 34.11756], [-118.44158, 34.11756], [-118.44113, 34.11732], [-118.44103, 34.11704], [-118.44049, 34.11692], [-118.44021, 34.11673], [-118.44021, 34.11602], [-118.4379, 34.11601], [-118.4379, 34.1145], [-118.43905, 34.11444], [-118.44021, 34.1146], [-118.44022, 34.10877], [-118.44407, 34.10878], [-118.44428, 34.10927], [-118.44309, 34.1102], [-118.44397, 34.11237], [-118.44555, 34.11239], [-118.44635, 34.11437], [-118.44631, 34.11477], [-118.44631, 34.11523], [-118.44628, 34.1155], [-118.44618, 34.11604]]]]} | Open Access 1 | 6394 | Beverly Glen Park | 29532 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 95.504 | Beverly Glen Park | 0 | Local Park 2 | 4 | |
15260 | 15260 | 15259 | {"type": "MultiPolygon", "coordinates": [[[[-118.41144, 34.06053], [-118.41139, 34.0606], [-118.41083, 34.06087], [-118.41086, 34.06092], [-118.41072, 34.06099], [-118.41068, 34.06094], [-118.40952, 34.06146], [-118.40927, 34.06126], [-118.40916, 34.06114], [-118.40908, 34.061], [-118.40903, 34.06085], [-118.40902, 34.0607], [-118.40902, 34.06015], [-118.40961, 34.05987], [-118.40985, 34.05982], [-118.40998, 34.05983], [-118.41003, 34.05986], [-118.4101, 34.05989], [-118.41017, 34.05998], [-118.41025, 34.05995], [-118.4103, 34.06003], [-118.41097, 34.05971], [-118.4114, 34.06031], [-118.41144, 34.06044], [-118.41144, 34.06053]]], [[[-118.41243, 34.06254], [-118.41205, 34.06271], [-118.41213, 34.06284], [-118.41212, 34.06285], [-118.41172, 34.06272], [-118.41123, 34.06236], [-118.411, 34.06223], [-118.41066, 34.0618], [-118.41142, 34.06141], [-118.41159, 34.06162], [-118.41191, 34.06147], [-118.41232, 34.06203], [-118.41217, 34.06212], [-118.41226, 34.06224], [-118.41224, 34.06227], [-118.41243, 34.06254]]]]} | Restricted Access 2 | 46326 | Beverly Hills High School Park | 31849 | 2366 | Beverly Hills Unified School District 1146 | Special District 4 | School District 14 | http://www.bhusd.org/ | Special District 4 | 1029 | Beverly Hills, City of 200 | City 2 | City Agency 2 | Los Angeles 6 | 10.447 | Beverly Hills High School Park | 0 | Local Park 2 | 4 | |
5910 | 5910 | 5909 | {"type": "Polygon", "coordinates": [[[-122.22737, 38.08113], [-122.22737, 38.08127], [-122.22732, 38.0813], [-122.22665, 38.0811], [-122.22659, 38.08121], [-122.22732, 38.08142], [-122.22736, 38.08146], [-122.22736, 38.08153], [-122.22527, 38.08137], [-122.22508, 38.0818], [-122.22533, 38.08199], [-122.22562, 38.08233], [-122.2258, 38.08248], [-122.22596, 38.08257], [-122.22615, 38.08265], [-122.22657, 38.08278], [-122.22737, 38.08289], [-122.22736, 38.08356], [-122.22733, 38.0836], [-122.22727, 38.08363], [-122.22714, 38.08359], [-122.22705, 38.08366], [-122.22731, 38.08391], [-122.22736, 38.08398], [-122.22736, 38.08407], [-122.22734, 38.08418], [-122.2273, 38.08424], [-122.22719, 38.08431], [-122.22705, 38.08411], [-122.22645, 38.08357], [-122.2252, 38.08307], [-122.22521, 38.08267], [-122.2252, 38.0825], [-122.22483, 38.08248], [-122.22483, 38.08238], [-122.22468, 38.08238], [-122.22469, 38.0822], [-122.2246, 38.08215], [-122.22442, 38.08215], [-122.22438, 38.08187], [-122.2243, 38.08155], [-122.22427, 38.08139], [-122.22417, 38.08108], [-122.22401, 38.08111], [-122.22378, 38.08066], [-122.22419, 38.08059], [-122.22433, 38.08062], [-122.22518, 38.08067], [-122.22518, 38.08079], [-122.2257, 38.08086], [-122.22572, 38.08082], [-122.22704, 38.08094], [-122.22705, 38.08112], [-122.22737, 38.08113]]]} | Open Access 1 | 362 | Beverly Hills Park | 16056 | 2224 | Greater Vallejo Recreation and Park District 341 | Special District 4 | Recreation/Parks District 4 | http://www.gvrd.org/ | Special District 4 | 2224 | Greater Vallejo Recreation and Park District 338 | Special District 4 | Recreation/Parks District 4 | http://www.gvrd.org/?page=Beverly_Hills_Park | Solano 26 | 11.756 | Beverly Hills Park | 0 | Local Park 2 | 4 |
16052 | 16052 | 16051 | {"type": "Polygon", "coordinates": [[[-118.42051, 34.12846], [-118.4152, 34.12824], [-118.41504, 34.12721], [-118.41468, 34.12719], [-118.41468, 34.12714], [-118.41474, 34.12701], [-118.41491, 34.12675], [-118.41499, 34.12667], [-118.41509, 34.1266], [-118.41521, 34.12656], [-118.41533, 34.12654], [-118.41546, 34.12656], [-118.41614, 34.12678], [-118.41626, 34.12687], [-118.4164, 34.12711], [-118.4165, 34.12721], [-118.41662, 34.12728], [-118.41675, 34.12733], [-118.41697, 34.12736], [-118.41795, 34.12725], [-118.41804, 34.12725], [-118.41814, 34.12728], [-118.41837, 34.1274], [-118.41913, 34.12761], [-118.41941, 34.12776], [-118.42051, 34.12846]]]} | Open Access 1 | 6865 | Beverly Park Estates Open Space | 16057 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 215 | Santa Monica Mountains Conservancy 303 | State 5 | State Agency 5 | Los Angeles 6 | 13.755 | Beverly Park Estates OS | 0 | State Recreation Area 39 | 4 | |
1978 | 1978 | 1977 | {"type": "Polygon", "coordinates": [[[-118.38008, 33.86755], [-118.37992, 33.86755], [-118.37992, 33.86714], [-118.38008, 33.86714], [-118.38008, 33.86755]]]} | Open Access 1 | 6081 | Beverly Parkette | 16058 | 1270 | Redondo Beach, City of 246 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | Los Angeles 6 | 0.169 | Beverly Parkette | 0 | Local Park 2 | 4 | |
15264 | 15264 | 15263 | {"type": "Polygon", "coordinates": [[[-118.39479, 34.06229], [-118.39479, 34.06361], [-118.39394, 34.06362], [-118.39394, 34.06229], [-118.39479, 34.06229]]]} | Restricted Access 2 | 46328 | Beverly Vista Elementary School Park | 31882 | 2366 | Beverly Hills Unified School District 1146 | Special District 4 | School District 14 | http://www.bhusd.org/ | Special District 4 | 1029 | Beverly Hills, City of 200 | City 2 | City Agency 2 | Los Angeles 6 | 2.838 | Beverly Vista Elementary School Park | 0 | Local Park 2 | 4 | |
6608 | 6608 | 6607 | {"type": "Polygon", "coordinates": [[[-117.03964, 32.5565], [-117.03952, 32.55674], [-117.03854, 32.5569], [-117.03824, 32.55697], [-117.03804, 32.55697], [-117.03763, 32.55706], [-117.03762, 32.55704], [-117.03717, 32.55717], [-117.03738, 32.55766], [-117.03743, 32.55783], [-117.03746, 32.55795], [-117.03747, 32.55822], [-117.03369, 32.55819], [-117.03357, 32.55452], [-117.03776, 32.55454], [-117.03928, 32.55638], [-117.03964, 32.5565]]]} | No Public Access 3 | 4168 | Beyer Community Park | 30224 | 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 | 43.828 | Beyer Community Park | 0 | Local Park 2 | 4 | |
2245 | 2245 | 2244 | {"type": "Polygon", "coordinates": [[[-118.84354, 34.17707], [-118.84327, 34.17764], [-118.84313, 34.17791], [-118.84297, 34.17808], [-118.84271, 34.178], [-118.84174, 34.17697], [-118.84123, 34.17723], [-118.84141, 34.17751], [-118.84091, 34.17775], [-118.84047, 34.17714], [-118.84173, 34.17649], [-118.84228, 34.17687], [-118.84243, 34.17692], [-118.84354, 34.17707]]]} | Restricted Access 2 | 18017 | Beyer Park | 31603 | 2026 | Conejo Valley Unified School District 501 | Special District 4 | School District 14 | http://www.conejo.k12.ca.us/ | Special District 4 | 2026 | Conejo Valley Unified School District 493 | Special District 4 | School District 21 | Ventura 8 | 5.138 | Beyer Park | 0 | Local Park 2 | 4 | |
2765 | 2765 | 2764 | {"type": "Polygon", "coordinates": [[[-120.9697, 37.69312], [-120.96964, 37.68905], [-120.97159, 37.68904], [-120.97162, 37.68908], [-120.97164, 37.68943], [-120.97171, 37.68961], [-120.97183, 37.68977], [-120.97208, 37.68996], [-120.9721, 37.68999], [-120.97178, 37.69031], [-120.9717, 37.69044], [-120.97165, 37.69064], [-120.97167, 37.69308], [-120.97163, 37.69311], [-120.9697, 37.69312]]]} | Open Access 1 | 18471 | Beyer Park | 16059 | 1208 | Modesto, City of 517 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | Stanislaus 2 | 19.974 | Beyer Park | 0 | Local Park 2 | 4 | |
15314 | 15314 | 15313 | {"type": "Polygon", "coordinates": [[[-118.39417, 33.8568], [-118.39413, 33.85701], [-118.3936, 33.85718], [-118.39348, 33.85693], [-118.39387, 33.8568], [-118.39391, 33.85688], [-118.39417, 33.8568]]]} | Open Access 1 | 46494 | Bi-Centennial Park | 29778 | 1134 | Hermosa Beach, City of 294 | City 2 | City Agency 2 | http://www.hermosabch.org/index.aspx?page=115 | City 2 | 1134 | Hermosa Beach, City of 290 | City 2 | City Agency 2 | Los Angeles 6 | 0.395 | Bi-Centennial Park | 0 | Local Park 2 | 4 | |
3674 | 3674 | 3673 | {"type": "Polygon", "coordinates": [[[-121.5396, 38.7289], [-121.53955, 38.73052], [-121.53953, 38.73375], [-121.53067, 38.73375], [-121.53068, 38.72896], [-121.5396, 38.7289]]]} | No Public Access 3 | 29739 | Bianchi West | 16062 | 2092 | Natomas Basin Conservancy 634 | Special District 4 | Flood District 8 | http://www.natomasbasin.org/ | Special District 4 | 2092 | Natomas Basin Conservancy 623 | Special District 4 | Flood District 9 | Sacramento 41 | 102.179 | Bianchi West | 0 | None 307 |
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]);