units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
103 rows where COUNTY = 27 sorted by AGNCY_WEB
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, MNG_AG_ID, MNG_AG_LEV, PARK_URL, YR_EST, GAP_STS
DES_TP 28
- Local Park 52
- Local Recreation Area 8
- State Conservation Area 5
- State Park 5
- State Resource Management Area 5
- National Forest 4
- State Recreation Area 3
- National Public Lands 1
- Local Conservation Area 1
- Local Other or Unknown 1
- Private Conservation 1
- National Park 1
- National Recreation Area 1
- Private Recreation or Education 1
- Federal Other or Unknown 1
- State Other or Unknown 1
- State Historic or Cultural Area 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
MNG_AGENCY 17
- Redding, City of 57
- California Department of Fish and Wildlife 11
- Shasta Lake, City of 7
- California Department of Parks and Recreation 6
- United States Forest Service 4
- Anderson, City of 3
- United States National Park Service 2
- California State Lands Commission 2
- United States Bureau of Reclamation 2
- Burney Co Water District 2
- United States Bureau of Land Management 1
- The Nature Conservancy 1
- California Department of Forestry and Fire Protection 1
- Shasta, County of 1
- McCloud River Railroad Company 1
- Palo Cerdo Community Park Association 1
- Mountain Gate Community Special District 1
MNG_AG_TYP 9
ACCESS_TYP 3
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6348 | 6348 | 6347 | {"type": "Polygon", "coordinates": [[[-121.64234, 40.90249], [-121.64234, 40.90302], [-121.64222, 40.9032], [-121.64211, 40.90343], [-121.64205, 40.90359], [-121.642, 40.90384], [-121.6419, 40.90495], [-121.64126, 40.91384], [-121.64039, 40.92841], [-121.63919, 40.94285], [-121.63818, 40.95738], [-121.63789, 40.9619], [-121.63785, 40.96211], [-121.63777, 40.96232], [-121.63766, 40.96253], [-121.63751, 40.96271], [-121.63734, 40.96289], [-121.63713, 40.96304], [-121.6369, 40.96317], [-121.63665, 40.96328], [-121.63639, 40.96336], [-121.63126, 40.96458], [-121.62637, 40.96562], [-121.62295, 40.96631], [-121.62263, 40.9664], [-121.62232, 40.96651], [-121.62203, 40.96665], [-121.62176, 40.96681], [-121.62151, 40.96699], [-121.62119, 40.96729], [-121.62101, 40.96751], [-121.62087, 40.96775], [-121.62075, 40.96799], [-121.62062, 40.9684], [-121.62048, 40.96866], [-121.62031, 40.9689], [-121.62, 40.96925], [-121.61975, 40.96945], [-121.61948, 40.96964], [-121.61908, 40.96985], [-121.61037, 40.9739], [-121.61011, 40.97404], [-121.60977, 40.9743], [-121.60958, 40.9745], [-121.60934, 40.97482], [-121.60918, 40.97517], [-121.60911, 40.97541], [-121.60908, 40.97565], [-121.6091, 40.97602], [-121.6092, 40.97638], [-121.60931, 40.97661], [-121.61156, 40.97944], [-121.61184, 40.97985], [-121.61204, 40.98028], [-121.61217, 40.98073], [-121.61222, 40.98119], [-121.61219, 40.98166], [-121.61208, 40.98211], [-121.61188, 40.98257], [-121.61081, 40.98616], [-121.60833, 40.99341], [-121.60466, 41.00428], [-121.60456, 41.00452], [-121.60452, 41.00472], [-121.60451, 41.00493], [-121.60454, 41.00514], [-121.60461, 41.00534], [-121.60471, 41.00553], [-121.60484, 41.00571], [-121.605, 41.00587], [-121.6052, 41.00602], [-121.60541, 41.00615], [-121.60565, 41.00625], [-121.60603, 41.00636], [-121.60644, 41.0064], [-121.60668, 41.00638], [-121.60718, 41.00628], [-121.60748, 41.00623], [-121.60778, 41.00622], [-121.60808, 41.00624], [-121.60837, 41.00628], [-121.60866, 41.00635], [-121.60893, 41.00644], [-121.60931, 41.00663], [-121.60953, 41.00679], [-121.60981, 41.00705], [-121.60996, 41.00725], [-121.61012, 41.00757], [-121.61018, 41.00779], [-121.61021, 41.00802], [-121.60983, 41.00801], [-121.6098, 41.0078], [-121.60974, 41.00759], [-121.60964, 41.0074], [-121.6095, 41.00722], [-121.60934, 41.00705], [-121.60914, 41.0069], [-121.60892, 41.00677], [-121.60868, 41.00667], [-121.60829, 41.00657], [-121.60788, 41.00652], [-121.60747, 41.00655], [-121.60695, 41.00665], [-121.60669, 41.00668], [-121.60614, 41.00667], [-121.60585, 41.00662], [-121.60558, 41.00655], [-121.60532, 41.00646], [-121.60507, 41.00634], [-121.60485, 41.0062], [-121.60465, 41.00604], [-121.6044, 41.00576], [-121.60428, 41.00557], [-121.60418, 41.00536], [-121.60413, 41.00514], [-121.6041, 41.00492], [-121.60412, 41.0047], [-121.60417, 41.00448], [-121.60425, 41.00427], [-121.60545, 41.0007], [-121.61034, 40.98615], [-121.61144, 40.98256], [-121.61163, 40.98211], [-121.61172, 40.98166], [-121.61175, 40.9812], [-121.61169, 40.98074], [-121.61156, 40.98029], [-121.61137, 40.97988], [-121.61121, 40.97961], [-121.60896, 40.97672], [-121.60883, 40.97647], [-121.60875, 40.97622], [-121.60869, 40.97597], [-121.60868, 40.97558], [-121.60872, 40.97532], [-121.60879, 40.97506], [-121.60896, 40.9747], [-121.60921, 40.97435], [-121.60952, 40.97404], [-121.60976, 40.97386], [-121.61017, 40.97362], [-121.61884, 40.9696], [-121.61909, 40.96947], [-121.61933, 40.96932], [-121.61968, 40.96905], [-121.61988, 40.96885], [-121.62006, 40.96863], [-121.62026, 40.96828], [-121.62039, 40.96792], [-121.62051, 40.96766], [-121.62067, 40.96741], [-121.62086, 40.96718], [-121.62108, 40.96696], [-121.62145, 40.96666], [-121.62173, 40.96649], [-121.62204, 40.96634], [-121.62252, 40.96616], [-121.62286, 40.96607], [-121.63126, 40.96431], [-121.63632, 40.96311], [-121.63667, 40.96297], [-121.63688, 40.96285], [-121.63707, 40.96271], [-121.63729, 40.96247], [-121.6374, 40.96229], [-121.63748, 40.9621], [-121.63752, 40.9619], [-121.63883, 40.94286], [-121.64003, 40.92841], [-121.6409, 40.91383], [-121.64155, 40.9053], [-121.64163, 40.90404], [-121.64165, 40.90381], [-121.6417, 40.90356], [-121.6418, 40.90327], [-121.64193, 40.90302], [-121.64204, 40.90286], [-121.64234, 40.90249]]]} | Open Access 1 | 48358 | Great Shasta Rail Trail | 32924 | 7027 | McCloud River Railroad Company 747 | Private 7 | Commercial 20 | Private 14 | 7027 | McCloud River Railroad Company 733 | Private 7 | Commercial 18 | https://www.greatshastarailtrail.org/ | Shasta 27 | 107.596 | Great Shasta Rail Trail | 2015 | None 512 | ||
14168 | 14168 | 14167 | {"type": "Polygon", "coordinates": [[[-122.33651, 40.70968], [-122.33649, 40.71002], [-122.33604, 40.7099], [-122.33608, 40.70968], [-122.33651, 40.70968]]]} | Open Access 1 | 43063 | Mountain Gate Community Special District 1 | 22539 | 2292 | Mountain Gate Community Special District 1093 | Special District 4 | Community Services District 19 | http://mountaingatecsd.com/ | Special District 4 | 2292 | Mountain Gate Community Special District 1048 | Special District 4 | Community Services District 17 | Shasta 27 | 0.286 | Mtn. Gate Community Spec. Dist. 1 | None 1205 | |||
1651 | 1651 | 1650 | {"type": "Polygon", "coordinates": [[[-122.32758, 40.5533], [-122.32754, 40.55568], [-122.32646, 40.55569], [-122.32648, 40.55333], [-122.32654, 40.55329], [-122.32758, 40.5533]]]} | Open Access 1 | 14206 | Alta Mesa park | 15417 | 1268 | Redding, City of 403 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | Shasta 27 | 6.04 | Alta Mesa park | None 134 | |||
1653 | 1653 | 1652 | {"type": "Polygon", "coordinates": [[[-122.41127, 40.59631], [-122.41084, 40.59628], [-122.41083, 40.59563], [-122.41093, 40.59566], [-122.41107, 40.59573], [-122.41114, 40.59579], [-122.41123, 40.59589], [-122.41129, 40.59605], [-122.41127, 40.59631]]]} | Open Access 1 | 14233 | Amethyst Park | 15458 | 1268 | Redding, City of 403 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | Shasta 27 | 0.562 | Amethyst Park | 0 | Local Park 2 | 4 | |
1656 | 1656 | 1655 | {"type": "Polygon", "coordinates": [[[-122.40194, 40.63015], [-122.40192, 40.63181], [-122.3996, 40.63185], [-122.39961, 40.63061], [-122.40016, 40.63016], [-122.40194, 40.63015]]]} | Open Access 1 | 14278 | Buckeye Park | 16472 | 1268 | Redding, City of 403 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | Shasta 27 | 8.741 | Buckeye Park | 0 | Local Park 2 | 4 | |
1714 | 1714 | 1713 | {"type": "Polygon", "coordinates": [[[-122.38468, 40.57295], [-122.3842, 40.57397], [-122.3827, 40.57341], [-122.38331, 40.57245], [-122.38468, 40.57295]]]} | Open Access 1 | 14849 | Softball Park | 25591 | 1268 | Redding, City of 403 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | Shasta 27 | 3.987 | Softball Park | 0 | Local Park 2 | 4 | |
1721 | 1721 | 1720 | {"type": "Polygon", "coordinates": [[[-122.38761, 40.57401], [-122.38715, 40.57505], [-122.38708, 40.57504], [-122.38665, 40.57598], [-122.38658, 40.57606], [-122.38647, 40.57612], [-122.38622, 40.57617], [-122.38602, 40.57616], [-122.38584, 40.57613], [-122.38372, 40.57537], [-122.38484, 40.57301], [-122.38761, 40.57401]]]} | Open Access 1 | 14879 | South City Park | 25641 | 1268 | Redding, City of 403 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | Shasta 27 | 17.504 | South City Park | 0 | Local Park 2 | 4 | |
1726 | 1726 | 1725 | {"type": "Polygon", "coordinates": [[[-122.3923, 40.58278], [-122.39221, 40.5828], [-122.39188, 40.58203], [-122.39209, 40.58198], [-122.3923, 40.58278]]]} | Open Access 1 | 14916 | Library Park | 21220 | 1268 | Redding, City of 403 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | Shasta 27 | 0.299 | Library Park | 0 | Local Park 2 | 4 | |
1743 | 1743 | 1742 | {"type": "Polygon", "coordinates": [[[-122.3268, 40.54679], [-122.32658, 40.54734], [-122.32639, 40.54734], [-122.32571, 40.54716], [-122.32576, 40.54637], [-122.32627, 40.54648], [-122.32654, 40.54669], [-122.3268, 40.54679]]]} | Open Access 1 | 14979 | Western Oaks Park | 27393 | 1268 | Redding, City of 403 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | Shasta 27 | 1.712 | Western Oaks Park | 0 | Local Park 2 | 4 | |
1785 | 1785 | 1784 | {"type": "Polygon", "coordinates": [[[-122.36741, 40.61555], [-122.36628, 40.61593], [-122.36601, 40.61551], [-122.36645, 40.6155], [-122.36637, 40.61519], [-122.3674, 40.61519], [-122.36741, 40.61555]]]} | Open Access 1 | 15399 | Valley Ridge Park | 26800 | 1268 | Redding, City of 403 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | Shasta 27 | 1.473 | Valley Ridge Park | 0 | Local Park 2 | 4 | |
1883 | 1883 | 1882 | {"type": "Polygon", "coordinates": [[[-122.42367, 40.58814], [-122.42324, 40.58806], [-122.4231, 40.58816], [-122.4227, 40.58823], [-122.42208, 40.58818], [-122.4219, 40.58782], [-122.42166, 40.58768], [-122.42139, 40.58764], [-122.42107, 40.58769], [-122.42085, 40.58785], [-122.42076, 40.58806], [-122.42077, 40.58821], [-122.42035, 40.58833], [-122.42017, 40.5884], [-122.41991, 40.58785], [-122.41936, 40.58776], [-122.41866, 40.58774], [-122.4184, 40.58811], [-122.41847, 40.58853], [-122.41903, 40.58862], [-122.41911, 40.58872], [-122.41787, 40.58898], [-122.41596, 40.58981], [-122.41541, 40.58993], [-122.41497, 40.59016], [-122.41374, 40.59111], [-122.41363, 40.59116], [-122.41335, 40.59096], [-122.41369, 40.59073], [-122.41383, 40.59057], [-122.41414, 40.59014], [-122.4143, 40.58983], [-122.41437, 40.58962], [-122.41457, 40.58932], [-122.4147, 40.58922], [-122.41522, 40.58888], [-122.41533, 40.58907], [-122.41599, 40.58904], [-122.4165, 40.58898], [-122.41689, 40.58885], [-122.41696, 40.58886], [-122.41698, 40.58848], [-122.4167, 40.58804], [-122.41691, 40.58775], [-122.41695, 40.58777], [-122.41706, 40.58761], [-122.41844, 40.58753], [-122.41862, 40.58718], [-122.41827, 40.58675], [-122.41825, 40.58655], [-122.41805, 40.58656], [-122.41782, 40.5862], [-122.41752, 40.58613], [-122.4164, 40.58622], [-122.4164, 40.58616], [-122.41701, 40.58612], [-122.417, 40.58599], [-122.41793, 40.58591], [-122.41794, 40.58588], [-122.41831, 40.58585], [-122.41832, 40.58586], [-122.41848, 40.58585], [-122.42041, 40.58554], [-122.42178, 40.58517], [-122.42193, 40.58549], [-122.42136, 40.58548], [-122.42086, 40.5856], [-122.42026, 40.5858], [-122.41887, 40.5861], [-122.41861, 40.58659], [-122.41884, 40.587], [-122.41941, 40.58726], [-122.4195, 40.58738], [-122.4204, 40.58725], [-122.42096, 40.58722], [-122.42094, 40.58676], [-122.42191, 40.58661], [-122.42199, 40.58685], [-122.42211, 40.58703], [-122.42298, 40.58715], [-122.42338, 40.58681], [-122.42339, 40.58644], [-122.42361, 40.58647], [-122.42383, 40.58716], [-122.42384, 40.58731], [-122.42367, 40.58814]]]} | Open Access 1 | 14436 | T. R. Woods Memorial Park | 26156 | 1268 | Redding, City of 403 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | Shasta 27 | 27.847 | T. R. Woods Memorial Park | 0 | Local Park 2 | 4 | |
1900 | 1900 | 1899 | {"type": "Polygon", "coordinates": [[[-122.29578, 40.56031], [-122.29578, 40.56147], [-122.29483, 40.56147], [-122.29482, 40.56112], [-122.29503, 40.56099], [-122.29514, 40.56089], [-122.29523, 40.56078], [-122.29532, 40.56059], [-122.29533, 40.56031], [-122.29578, 40.56031]]]} | Open Access 1 | 14660 | Stillwater Heights Park | 25852 | 1268 | Redding, City of 403 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | Shasta 27 | 1.872 | Stillwater Heights Park | 0 | Local Park 2 | 4 | |
1903 | 1903 | 1902 | {"type": "Polygon", "coordinates": [[[-122.33749, 40.59585], [-122.33659, 40.59638], [-122.3362, 40.59601], [-122.33626, 40.59604], [-122.33632, 40.59606], [-122.33639, 40.59606], [-122.33646, 40.59603], [-122.33651, 40.59599], [-122.33653, 40.59593], [-122.33652, 40.59587], [-122.33649, 40.59584], [-122.3371, 40.59547], [-122.33749, 40.59585]]]} | Open Access 1 | 14692 | Minder Park | 22259 | 1268 | Redding, City of 403 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | Shasta 27 | 1.176 | Minder Park | 0 | Local Park 2 | 4 | |
1994 | 1994 | 1993 | {"type": "Polygon", "coordinates": [[[-122.3536, 40.56334], [-122.35329, 40.56334], [-122.35329, 40.56307], [-122.35359, 40.56308], [-122.3536, 40.56334]]]} | Open Access 1 | 15282 | Graham Park | 19415 | 1268 | Redding, City of 403 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | Shasta 27 | 0.194 | Graham Park | 0 | Local Park 2 | 4 | |
2000 | 2000 | 1999 | {"type": "Polygon", "coordinates": [[[-122.34472, 40.56826], [-122.34472, 40.56885], [-122.34406, 40.56885], [-122.34406, 40.5686], [-122.34441, 40.5686], [-122.34443, 40.56839], [-122.34453, 40.56835], [-122.34458, 40.5683], [-122.34459, 40.56825], [-122.34472, 40.56826]]]} | Open Access 1 | 15313 | Foxtail Park | 19038 | 1268 | Redding, City of 403 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | Shasta 27 | 0.593 | Foxtail Park | 0 | Local Park 2 | 4 | |
3172 | 3172 | 3171 | {"type": "Polygon", "coordinates": [[[-122.40587, 40.59649], [-122.40539, 40.59649], [-122.40538, 40.59603], [-122.40569, 40.59604], [-122.40588, 40.5961], [-122.4059, 40.59614], [-122.40588, 40.59625], [-122.40587, 40.59649]]]} | Open Access 1 | 22035 | Camelian Park | 16756 | 1268 | Redding, City of 403 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | Shasta 27 | 0.509 | Camelian Park | 0 | Local Park 2 | 4 | |
3179 | 3179 | 3178 | {"type": "Polygon", "coordinates": [[[-122.34442, 40.56839], [-122.34442, 40.56861], [-122.34406, 40.5686], [-122.34407, 40.56832], [-122.34426, 40.56832], [-122.34434, 40.56837], [-122.34442, 40.56839]]]} | Open Access 1 | 22034 | Foxtail Park | 19038 | 1268 | Redding, City of 403 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | Shasta 27 | 0.216 | Foxtail Park | 0 | Local Park 2 | 4 | |
3227 | 3227 | 3226 | {"type": "Polygon", "coordinates": [[[-122.41204, 40.58349], [-122.41177, 40.5837], [-122.41148, 40.58396], [-122.41121, 40.58411], [-122.41076, 40.58299], [-122.41174, 40.58275], [-122.41204, 40.58349]]]} | Open Access 1 | 22286 | Foothill Park | 18978 | 1268 | Redding, City of 403 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | Shasta 27 | 2.385 | Foothill Park | 0 | Local Park 2 | 4 | |
3349 | 3349 | 3348 | {"type": "Polygon", "coordinates": [[[-122.3076, 40.57465], [-122.30296, 40.57463], [-122.30287, 40.5745], [-122.30289, 40.57104], [-122.3076, 40.57103], [-122.3076, 40.57465]]]} | Open Access 1 | 24175 | Redding Soccer Park | 24234 | 1268 | Redding, City of 403 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | Shasta 27 | 39.524 | Redding Soccer Park | 0 | Local Recreation Area 3 | 4 | |
3350 | 3350 | 3349 | {"type": "Polygon", "coordinates": [[[-122.34575, 40.54282], [-122.34573, 40.54285], [-122.34569, 40.54286], [-122.34439, 40.54287], [-122.34439, 40.54227], [-122.34449, 40.54203], [-122.34575, 40.54202], [-122.34575, 40.54282]]]} | Open Access 1 | 24178 | East Oak Park | 18378 | 1268 | Redding, City of 403 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | Shasta 27 | 2.637 | East Oak 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]);