units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,162 rows where MNG_AG_TYP = 4 sorted by MNG_AGENCY descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV, GAP_STS
MNG_AGENCY >30
- East Bay Regional Park District 167
- Hayward Area Recreation and Park District 84
- Valley-Wide Recreation and Park District 67
- Rancho Simi Recreation and Park District 54
- Midpeninsula Regional Open Space District 51
- Conejo Recreation and Park District 50
- Marin County Open Space District 41
- Southgate Recreation and Park District 41
- Sunrise Recreation and Park District 39
- Cordova Recreation and Park District 38
- Greater Vallejo Recreation and Park District 33
- Pleasant Valley Recreation and Park District 31
- North of the River Recreation and Park District 27
- Monterey Peninsula Regional Park District 25
- Santa Clara Valley Open Space Authority 25
- Sonoma County Agricultural Preservation and Open Space District 21
- Isla Vista Recreation and Park District 18
- Jurupa Area Recreation and Park District 18
- Desert Recreation District 15
- Mission Oaks Recreation and Park District 14
- Apple Valley Recreation and Park District 13
- Livermore Area Recreation and Park District 13
- Pleasant Hill Recreation and Park District 12
- Carmichael Recreation and Park District 12
- Auburn Area Recreation and Park District 11
- Hesperia Recreation and Park District 11
- North Highland Recreation and Park District 11
- Napa County Regional Park and Open Space District 10
- Miraleste Recreation and Park District 10
- Rio Linda Elverta Recreation and Park District 9
- …
DES_TP >30
- Local Park 704
- Local Conservation Area 172
- Local Recreation Area 164
- Local Other or Unknown 28
- Local Historic or Cultural Area 3
- Local Resource Management Area 2
- 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
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- …
ACCESS_TYP 4
- Open Access 991
- No Public Access 106
- Restricted Access 64
- Unknown Access 1
MNG_AG_TYP 1
- Recreation/Parks District · 1,162 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16901 | 16901 | 16900 | {"type": "Polygon", "coordinates": [[[-121.99742, 37.3099], [-121.99742, 37.31032], [-121.99733, 37.31095], [-121.99727, 37.311], [-121.99717, 37.311], [-121.99687, 37.31043], [-121.99662, 37.31014], [-121.99673, 37.31007], [-121.99654, 37.30984], [-121.99704, 37.30983], [-121.99736, 37.30986], [-121.9974, 37.3099], [-121.99742, 37.3099]]]} | Open Access 1 | 24310 | Rancho Rinconada Recreation Center | 24167 | 2251 | Rancho Rinconada Recreation and Park District 1180 | Special District 4 | Recreation/Parks District 4 | http://www.ranchoreccenter.com/ | Special District 4 | 2251 | Rancho Rinconada Recreation and Park District 1119 | Special District 4 | Recreation/Parks District 4 | Santa Clara 19 | 1.514 | Rancho Rinconada Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
16900 | 16900 | 16899 | {"type": "Polygon", "coordinates": [[[-122.19908, 37.40441], [-122.19859, 37.40468], [-122.19843, 37.40469], [-122.19797, 37.40388], [-122.19864, 37.40363], [-122.19908, 37.40441]]]} | Open Access 1 | 24309 | Ladera Recreation Center | 20823 | 2233 | Ladera Recreation District 1179 | Special District 4 | Recreation/Parks District 4 | http://www.lrdrec.com/ | Special District 4 | 2233 | Ladera Recreation District 1118 | Special District 4 | Recreation/Parks District 4 | San Mateo 15 | 1.613 | Ladera Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
16899 | 16899 | 16898 | {"type": "Polygon", "coordinates": [[[-122.34743, 37.51955], [-122.34676, 37.52049], [-122.34572, 37.52008], [-122.34668, 37.51877], [-122.34722, 37.51902], [-122.34701, 37.51936], [-122.34743, 37.51955]]]} | Open Access 1 | 24308 | Highlands Recreation Center | 19949 | 2228 | Highlands Recreation District 1178 | Special District 4 | Recreation/Parks District 4 | http://www.highlandsrec.com/ | Special District 4 | 2228 | Highlands Recreation District 1117 | Special District 4 | Recreation/Parks District 4 | San Mateo 15 | 3.66 | Highlands Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
15845 | 15845 | 15844 | {"type": "MultiPolygon", "coordinates": [[[[-118.37159, 33.76721], [-118.37139, 33.76744], [-118.37081, 33.76795], [-118.37054, 33.76809], [-118.37028, 33.76819], [-118.36988, 33.76826], [-118.36957, 33.76825], [-118.36931, 33.76821], [-118.36905, 33.76812], [-118.36801, 33.7677], [-118.3677, 33.76761], [-118.36738, 33.76756], [-118.36695, 33.76756], [-118.36722, 33.76751], [-118.36745, 33.76751], [-118.36778, 33.76756], [-118.36792, 33.7676], [-118.3693, 33.76817], [-118.36961, 33.76824], [-118.36984, 33.76825], [-118.37, 33.76823], [-118.37022, 33.76817], [-118.37042, 33.76808], [-118.37055, 33.76799], [-118.37068, 33.76788], [-118.37139, 33.76708], [-118.37138, 33.76701], [-118.37159, 33.76714], [-118.37159, 33.76721]]], [[[-118.3718, 33.76638], [-118.3718, 33.76662], [-118.37176, 33.76685], [-118.3717, 33.7669], [-118.37163, 33.76689], [-118.37158, 33.76686], [-118.37168, 33.7667], [-118.37175, 33.76655], [-118.37178, 33.76638], [-118.37178, 33.76628], [-118.3718, 33.76638]]]]} | Open Access 1 | 5926 | Ridgecrest Ranchos Open Space | 24353 | 2120 | Ridgecrest Ranchos Recreation and Park District 1162 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 2120 | Ridgecrest Ranchos Recreation and Park District 1105 | Special District 4 | Recreation/Parks District 4 | Los Angeles 6 | 1.195 | Ridgecrest Ranchos OS | 0 | Local Recreation Area 3 | 4 | ||
15667 | 15667 | 15666 | {"type": "MultiPolygon", "coordinates": [[[[-117.78087, 34.13432], [-117.77956, 34.13623], [-117.77952, 34.13623], [-117.77668, 34.13961], [-117.77672, 34.13656], [-117.77842, 34.13656], [-117.77907, 34.13625], [-117.77907, 34.13623], [-117.77757, 34.13623], [-117.77816, 34.13544], [-117.78087, 34.13432]]], [[[-117.78553, 34.13746], [-117.7855, 34.13899], [-117.78448, 34.1382], [-117.78414, 34.13855], [-117.78324, 34.13797], [-117.78188, 34.13857], [-117.77931, 34.14076], [-117.77831, 34.14213], [-117.7783, 34.14331], [-117.77675, 34.14332], [-117.77677, 34.13975], [-117.77972, 34.13625], [-117.77971, 34.13623], [-117.78, 34.1358], [-117.78077, 34.1347], [-117.78082, 34.13473], [-117.78093, 34.13461], [-117.7812, 34.13438], [-117.78164, 34.13411], [-117.78274, 34.13355], [-117.78304, 34.13334], [-117.78316, 34.13323], [-117.78323, 34.1332], [-117.78327, 34.1332], [-117.78333, 34.13323], [-117.7842, 34.13378], [-117.78317, 34.13427], [-117.78294, 34.13488], [-117.78326, 34.13531], [-117.78441, 34.13592], [-117.78436, 34.13609], [-117.78435, 34.13626], [-117.78438, 34.13643], [-117.78449, 34.13664], [-117.78468, 34.13683], [-117.78553, 34.13746]], [[-117.78214, 34.13578], [-117.78214, 34.13579], [-117.78231, 34.13592], [-117.78253, 34.13571], [-117.78235, 34.13558], [-117.78214, 34.13578]]]]} | Restricted Access 2 | 6754 | San Dimas Canyon Golf Course | 33021 | 2135 | San Dimas-La Verne Recreational Facilities Authority 1160 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 2135 | San Dimas-La Verne Recreational Facilities Authority 1104 | Special District 4 | Recreation/Parks District 4 | Los Angeles 6 | 103.27 | San Dimas Canyon GC | 0 | Local Recreation Area 3 | 4 | ||
15032 | 15032 | 15031 | {"type": "Polygon", "coordinates": [[[-121.1982, 39.20573], [-121.19466, 39.20522], [-121.1857, 39.20366], [-121.18573, 39.20231], [-121.18731, 39.20265], [-121.18791, 39.20104], [-121.19336, 39.20145], [-121.19421, 39.2016], [-121.19591, 39.20205], [-121.19738, 39.2026], [-121.19816, 39.20518], [-121.1982, 39.20573]]]} | Open Access 1 | 45686 | Western Gateway Park | 28498 | 2269 | Western Gateway Recreation and Park District 1136 | Special District 4 | Recreation/Parks District 4 | http://www.westerngatewaypark.com/ | Special District 4 | 2269 | Western Gateway Recreation and Park District 1091 | Special District 4 | Recreation/Parks District 4 | http://www.westerngatewaypark.com/ | Nevada 30 | 85.751 | Western Gateway Park | 0 | Local Park 2 | 4 |
14460 | 14460 | 14459 | {"type": "Polygon", "coordinates": [[[-118.92241, 35.23652], [-118.92241, 35.23775], [-118.92086, 35.23775], [-118.92086, 35.23653], [-118.92241, 35.23652]]]} | Open Access 1 | 48266 | Weedpatch Park | 32818 | 2006 | Bear Mountain Recreation and Park District 1114 | Special District 4 | Recreation/Parks District 4 | http://www.bearmtnprk.com/ | Special District 4 | 2006 | Bear Mountain Recreation and Park District 1069 | Special District 4 | Recreation/Parks District 4 | Kern 36 | 4.736 | Weedpatch Park | 0 | Local Park 2 | 4 | |
16911 | 16911 | 16910 | {"type": "Polygon", "coordinates": [[[-118.92086, 35.26268], [-118.92085, 35.26278], [-118.92079, 35.26281], [-118.92076, 35.26287], [-118.92075, 35.26295], [-118.92079, 35.26302], [-118.9208, 35.26341], [-118.91879, 35.2634], [-118.91879, 35.26218], [-118.91898, 35.26218], [-118.91899, 35.26249], [-118.92076, 35.2625], [-118.92077, 35.26257], [-118.92081, 35.26263], [-118.92086, 35.26268]]]} | Open Access 1 | 15956 | Bear Mountain Park | 15928 | 2006 | Bear Mountain Recreation and Park District 1114 | Special District 4 | Recreation/Parks District 4 | http://www.bearmtnprk.com/ | Special District 4 | 2006 | Bear Mountain Recreation and Park District 1069 | Special District 4 | Recreation/Parks District 4 | Kern 36 | 4.726 | Bear Mtn. Park | 0 | Local Park 2 | 4 | |
14427 | 14427 | 14426 | {"type": "Polygon", "coordinates": [[[-121.73742, 36.48206], [-121.73572, 36.4827], [-121.73546, 36.48248], [-121.73614, 36.48154], [-121.73566, 36.48131], [-121.73587, 36.48102], [-121.7362, 36.4812], [-121.73668, 36.48141], [-121.73694, 36.48155], [-121.7372, 36.48177], [-121.73734, 36.48193], [-121.73742, 36.48206]]]} | Open Access 1 | 44596 | Carmel Valley Park | 16876 | 2337 | Carmel Valley Recreation Park District 1111 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 2337 | Carmel Valley Recreation Park District 1065 | Special District 4 | Recreation/Parks District 4 | Monterey 14 | 3.852 | Carmel Valley Park | 0 | Local Park 2 | 4 | ||
14329 | 14329 | 14328 | {"type": "Polygon", "coordinates": [[[-122.38715, 41.43835], [-122.38702, 41.43886], [-122.38616, 41.43867], [-122.38561, 41.43852], [-122.38556, 41.43846], [-122.38554, 41.43836], [-122.38559, 41.43811], [-122.38715, 41.43835]]]} | Open Access 1 | 48856 | Weed Skate Park | 33576 | 2352 | Weed Recreation and Parks District 1109 | Special District 4 | Recreation/Parks District 4 | http://weedrec.org/?page_id=45 | Special District 4 | 2352 | Weed Recreation and Parks District 1063 | Special District 4 | Recreation/Parks District 4 | https://www.northwestskater.com/weed.html | Siskiyou 28 | 1.645 | Weed Skate Park | 0 | Local Recreation Area 3 | 4 |
15010 | 15010 | 15009 | {"type": "Polygon", "coordinates": [[[-122.37462, 41.42859], [-122.37445, 41.42883], [-122.37449, 41.43002], [-122.37448, 41.43012], [-122.37445, 41.43022], [-122.37434, 41.43039], [-122.37363, 41.43074], [-122.37282, 41.43009], [-122.37198, 41.42915], [-122.37413, 41.42841], [-122.37462, 41.42859]]]} | Open Access 1 | 45662 | Sons Park and Lobis Field | 28478 | 2352 | Weed Recreation and Parks District 1109 | Special District 4 | Recreation/Parks District 4 | http://weedrec.org/?page_id=45 | Special District 4 | 2352 | Weed Recreation and Parks District 1063 | Special District 4 | Recreation/Parks District 4 | http://weedrec.org/?page_id=45 | Siskiyou 28 | 8.3 | Sons Park and Lobis Field | 0 | Local Recreation Area 3 | 4 |
14300 | 14300 | 14299 | {"type": "Polygon", "coordinates": [[[-120.67776, 38.19598], [-120.67773, 38.19625], [-120.6773, 38.1967], [-120.67696, 38.19652], [-120.67709, 38.19637], [-120.67705, 38.19633], [-120.67709, 38.19629], [-120.67679, 38.19615], [-120.67673, 38.19622], [-120.67652, 38.19613], [-120.67628, 38.19594], [-120.67581, 38.19539], [-120.67607, 38.19531], [-120.6771, 38.19587], [-120.67776, 38.19598]]]} | Open Access 1 | 44233 | Gerald Turner Park | 19277 | 2257 | San Andreas Recreation and Park District 1107 | Special District 4 | Recreation/Parks District 4 | http://sanandreasmerchants.com/SARP.htm | Special District 4 | 2257 | San Andreas Recreation and Park District 1061 | Special District 4 | Recreation/Parks District 4 | Calaveras 53 | 2.323 | Gerald Turner Park | 0 | Local Park 2 | 4 | |
14175 | 14175 | 14174 | {"type": "Polygon", "coordinates": [[[-121.96105, 36.96553], [-121.96093, 36.96566], [-121.9605, 36.9653], [-121.96048, 36.96524], [-121.96044, 36.96518], [-121.96044, 36.96515], [-121.96055, 36.96512], [-121.96105, 36.96553]]]} | Open Access 1 | 43079 | Privates Beach Accessway | 28594 | 2103 | Opal Cliffs Recreation District 1099 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 2103 | Opal Cliffs Recreation District 1054 | Special District 4 | Recreation/Parks District 4 | Santa Cruz 5 | 0.289 | Privates Beach Accessway | None 1206 | ||||
13472 | 13472 | 13471 | {"type": "Polygon", "coordinates": [[[-121.80194, 39.64878], [-121.80091, 39.64895], [-121.80036, 39.64752], [-121.80032, 39.64731], [-121.80034, 39.64725], [-121.80107, 39.64708], [-121.80118, 39.64737], [-121.80146, 39.6475], [-121.80194, 39.64878]]]} | Open Access 1 | 35731 | Durham Recreation and Park District 1 | 18313 | 2030 | Durham Recreation and Park District 1060 | Special District 4 | Recreation/Parks District 4 | http://www.durhamrec.com/ | Special District 4 | 2030 | Durham Recreation and Park District 1018 | Special District 4 | Recreation/Parks District 4 | Butte 42 | 4.222 | Durham Rec. and Park District 1 | 0 | Local Recreation Area 3 | 4 | |
13473 | 13473 | 13472 | {"type": "Polygon", "coordinates": [[[-121.77925, 39.64587], [-121.77474, 39.646], [-121.77471, 39.64458], [-121.77478, 39.64455], [-121.77507, 39.64437], [-121.77532, 39.64415], [-121.77556, 39.64373], [-121.77523, 39.64316], [-121.77663, 39.64268], [-121.77925, 39.64587]]]} | Open Access 1 | 35730 | Durham Recreation and Park District 2 | 18314 | 2030 | Durham Recreation and Park District 1060 | Special District 4 | Recreation/Parks District 4 | http://www.durhamrec.com/ | Special District 4 | 2030 | Durham Recreation and Park District 1018 | Special District 4 | Recreation/Parks District 4 | Butte 42 | 21.557 | Durham Rec. and Park District 2 | 0 | Local Recreation Area 3 | 4 | |
16829 | 16829 | 16828 | {"type": "Polygon", "coordinates": [[[-121.76741, 39.55063], [-121.76703, 39.55071], [-121.76672, 39.54986], [-121.76666, 39.54986], [-121.76665, 39.54988], [-121.76696, 39.55072], [-121.76658, 39.55081], [-121.76622, 39.54984], [-121.76705, 39.54966], [-121.76741, 39.55063]]]} | Open Access 1 | 35629 | Durham Recreation and Park District 3 | 18315 | 2030 | Durham Recreation and Park District 1060 | Special District 4 | Recreation/Parks District 4 | http://www.durhamrec.com/ | Special District 4 | 2030 | Durham Recreation and Park District 1018 | Special District 4 | Recreation/Parks District 4 | Butte 42 | 1.89 | Durham Rec. and Park District 3 | 0 | Local Recreation Area 3 | 4 | |
13057 | 13057 | 13056 | {"type": "Polygon", "coordinates": [[[-120.9148, 39.9354], [-120.9148, 39.93622], [-120.9137, 39.93646], [-120.91324, 39.93647], [-120.91323, 39.93607], [-120.91348, 39.93605], [-120.91349, 39.9354], [-120.9148, 39.9354]]]} | Open Access 1 | 34915 | Pioneer Park | 23738 | 2293 | Central Plumas Recreation and Parks District 1041 | Special District 4 | Recreation/Parks District 4 | http://users.psln.com/recdept/ | Special District 4 | 2293 | Central Plumas Recreation and Parks District 1003 | Special District 4 | Recreation/Parks District 4 | Plumas 57 | 3.207 | Pioneer Park | 0 | Local Park 2 | 4 | |
12513 | 12513 | 12512 | {"type": "MultiPolygon", "coordinates": [[[[-122.93343, 40.73163], [-122.9323, 40.73359], [-122.93176, 40.73341], [-122.93176, 40.73338], [-122.93091, 40.7331], [-122.9326, 40.73087], [-122.93343, 40.73163]]], [[[-122.93437, 40.73252], [-122.93407, 40.73292], [-122.93381, 40.73307], [-122.93202, 40.73461], [-122.9336, 40.73179], [-122.93437, 40.73252]]], [[[-122.93533, 40.73097], [-122.93427, 40.73164], [-122.93381, 40.73174], [-122.93267, 40.73065], [-122.93331, 40.72906], [-122.93533, 40.73097]]]]} | Open Access 1 | 28346 | Lowden Park | 21553 | 2291 | Weaverville - Douglas City Recreation District 1029 | Special District 4 | Recreation/Parks District 4 | http://users.snowcrest.net/wb6fzh/wdcrec1.html | Special District 4 | 2291 | Weaverville - Douglas City Recreation District 990 | Special District 4 | Recreation/Parks District 4 | Trinity 46 | 19.77 | Lowden Park | 0 | Local Park 2 | 4 | |
13051 | 13051 | 13050 | {"type": "Polygon", "coordinates": [[[-122.94177, 40.72821], [-122.94151, 40.72819], [-122.94149, 40.7283], [-122.94128, 40.72831], [-122.94131, 40.72874], [-122.94163, 40.72872], [-122.9416, 40.72885], [-122.94116, 40.72888], [-122.94119, 40.72877], [-122.9411, 40.72876], [-122.94092, 40.72921], [-122.9408, 40.72982], [-122.94029, 40.72976], [-122.94021, 40.72913], [-122.94066, 40.72875], [-122.94065, 40.72874], [-122.94056, 40.72876], [-122.94014, 40.72876], [-122.94023, 40.72855], [-122.94015, 40.72816], [-122.94021, 40.72776], [-122.94034, 40.72761], [-122.9404, 40.7271], [-122.94039, 40.7268], [-122.94031, 40.72663], [-122.94038, 40.7264], [-122.94029, 40.72554], [-122.94031, 40.72524], [-122.94067, 40.72524], [-122.94067, 40.72468], [-122.94126, 40.72468], [-122.94127, 40.72583], [-122.94163, 40.72584], [-122.94165, 40.72752], [-122.94177, 40.72821]]]} | Open Access 1 | 34903 | Lee Fong Park | 21132 | 2291 | Weaverville - Douglas City Recreation District 1029 | Special District 4 | Recreation/Parks District 4 | http://users.snowcrest.net/wb6fzh/wdcrec1.html | Special District 4 | 2291 | Weaverville - Douglas City Recreation District 990 | Special District 4 | Recreation/Parks District 4 | Trinity 46 | 12.516 | Lee Fong Park | 0 | Local Park 2 | 4 | |
12353 | 12353 | 12352 | {"type": "MultiPolygon", "coordinates": [[[[-123.01059, 38.48345], [-123.01015, 38.48391], [-123.00931, 38.48364], [-123.00931, 38.48303], [-123.01059, 38.48345]]], [[[-123.01075, 38.48424], [-123.01068, 38.48437], [-123.01059, 38.48435], [-123.01053, 38.48446], [-123.01034, 38.4843], [-123.01049, 38.48402], [-123.01075, 38.48424]]], [[[-123.01166, 38.4834], [-123.01106, 38.48346], [-123.01091, 38.48354], [-123.01092, 38.48356], [-123.01119, 38.48364], [-123.01093, 38.48417], [-123.01056, 38.48386], [-123.01054, 38.48387], [-123.01049, 38.48383], [-123.01078, 38.48354], [-123.01103, 38.48341], [-123.01165, 38.48335], [-123.01166, 38.4834]]]]} | Open Access 1 | 26077 | Vacation Beach Playground | 26752 | 2254 | Russian River Recreation and Park District 1020 | Special District 4 | Recreation/Parks District 4 | http://russianriverrecpark.org/ | Special District 4 | 2254 | Russian River Recreation and Park District 982 | Special District 4 | Recreation/Parks District 4 | Sonoma 16 | 2.431 | Vacation Beach Playground | 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]);