units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
214 rows where DES_TP = 14 and MNG_AG_TYP = 3 sorted by UNIT_NAME descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_WEB, COUNTY, YR_EST
MNG_AGENCY 23
- Butte, County of 52
- Santa Barbara, County of 39
- Lake, County of 36
- Orange, County of 21
- Monterey, County of 18
- Los Angeles, County of 11
- Sacramento, County of 6
- Ventura, County of 5
- Santa Cruz, County of 4
- San Diego, County of 4
- Tulare, County of 3
- Riverside, County of 3
- Merced, County of 2
- Placer, County of 1
- Imperial, County of 1
- San Bernardino, County of 1
- Napa, County of 1
- Yolo, County of 1
- Humboldt, County of 1
- Tehama, County of 1
- Trinity, County of 1
- Marin, County of 1
- Solano, County of 1
ACCESS_TYP 4
MNG_AG_TYP 1
- County Agency · 214 ✖
DES_TP 1
- Local Other or Unknown · 214 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13013 | 13013 | 13012 | {"type": "MultiPolygon", "coordinates": [[[[-121.91526, 38.26143], [-121.91525, 38.26144], [-121.91516, 38.26502], [-121.90682, 38.27189], [-121.89801, 38.2782], [-121.89805, 38.27195], [-121.89805, 38.26472], [-121.87929, 38.26469], [-121.87927, 38.27171], [-121.87387, 38.27167], [-121.87397, 38.27128], [-121.87929, 38.26469], [-121.89614, 38.24998], [-121.89617, 38.24991], [-121.89819, 38.24991], [-121.89826, 38.24289], [-121.91522, 38.24301], [-121.91521, 38.25733], [-121.91525, 38.26116], [-121.91523, 38.26117], [-121.91526, 38.26143]]], [[[-121.91491, 38.27353], [-121.91447, 38.28644], [-121.90677, 38.28644], [-121.89698, 38.28637], [-121.90575, 38.28009], [-121.90633, 38.27971], [-121.91491, 38.27353]]]]} | No Public Access 3 | 31205 | Wilcox Ranch | 27494 | 344 | Solano, County of 1037 | County 3 | County Agency 3 | http://www.co.solano.ca.us/depts/rm/countypark/homepage.asp | County 3 | 344 | Solano, County of 999 | County 3 | County Agency 3 | Solano 26 | 1870.595 | Wilcox Ranch | 0 | Local Other or Unknown 14 | 4 | |
12733 | 12733 | 12732 | {"type": "MultiPolygon", "coordinates": [[[[-122.50606, 38.01702], [-122.50538, 38.01773], [-122.50389, 38.0179], [-122.5039, 38.01851], [-122.4971, 38.01865], [-122.48, 38.02023], [-122.47926, 38.02067], [-122.47925, 38.02058], [-122.47924, 38.02057], [-122.46957, 38.02491], [-122.46829, 38.02814], [-122.46444, 38.03432], [-122.45826, 38.01394], [-122.45798, 38.00928], [-122.45797, 38.00928], [-122.45718, 38.01038], [-122.45356, 37.99846], [-122.46201, 38.00454], [-122.47026, 38.00744], [-122.47894, 38.01033], [-122.48622, 38.01267], [-122.48627, 38.01271], [-122.48923, 38.01368], [-122.49539, 38.01456], [-122.50181, 38.01539], [-122.50328, 38.01578], [-122.50332, 38.0158], [-122.50338, 38.01576], [-122.50344, 38.01707], [-122.50606, 38.01702]]], [[[-122.49754, 38.02919], [-122.49296, 38.02924], [-122.49287, 38.02566], [-122.49743, 38.02564], [-122.49754, 38.02919]]]]} | Open Access 1 | 29763 | Water Lots | 27293 | 353 | Marin, County of 1034 | County 3 | County Agency 3 | http://www.marincounty.org/recreation/parks-in-marin | County 3 | 353 | Marin, County of 996 | County 3 | County Agency 3 | Marin 23 | 1356.794 | Water Lots | 1976 | Local Other or Unknown 14 | 4 | |
4585 | 4585 | 4584 | {"type": "Polygon", "coordinates": [[[-119.02666, 34.17663], [-119.02303, 34.17889], [-119.02303, 34.17889], [-119.0227, 34.17654], [-119.0266, 34.17657], [-119.02666, 34.17663]]]} | Open Access 1 | 35461 | Unnamed site - Ventura, County of | 28674 | 331 | Ventura, County of 202 | County 3 | County Agency 3 | http://www.ventura.org/general-services-agency/parks-department | County 3 | 331 | Ventura, County of 198 | County 3 | County Agency 3 | Ventura 8 | 12.065 | 0 | Local Other or Unknown 14 | 4 | ||
4612 | 4612 | 4611 | {"type": "Polygon", "coordinates": [[[-119.01933, 34.18141], [-119.01855, 34.18199], [-119.01765, 34.18222], [-119.01703, 34.18076], [-119.01778, 34.1799], [-119.01782, 34.18047], [-119.01889, 34.18048], [-119.01925, 34.18102], [-119.01933, 34.18141]]]} | Open Access 1 | 35758 | Unnamed site - Ventura, County of | 28674 | 331 | Ventura, County of 202 | County 3 | County Agency 3 | http://www.ventura.org/general-services-agency/parks-department | County 3 | 331 | Ventura, County of 198 | County 3 | County Agency 3 | Ventura 8 | 7.641 | 0 | Local Other or Unknown 14 | 4 | ||
4657 | 4657 | 4656 | {"type": "Polygon", "coordinates": [[[-118.65926, 34.28468], [-118.65925, 34.28475], [-118.65918, 34.28484], [-118.65918, 34.28491], [-118.65916, 34.28495], [-118.65909, 34.28501], [-118.65903, 34.28503], [-118.65866, 34.28502], [-118.65824, 34.28486], [-118.65827, 34.28481], [-118.65866, 34.28496], [-118.659, 34.28498], [-118.65901, 34.28497], [-118.65901, 34.28485], [-118.65893, 34.28478], [-118.6589, 34.28472], [-118.6589, 34.28466], [-118.65893, 34.28461], [-118.65902, 34.28455], [-118.65913, 34.28455], [-118.65922, 34.28459], [-118.65926, 34.28468]]]} | Open Access 1 | 36586 | Unnamed site - Ventura, County of | 28674 | 331 | Ventura, County of 202 | County 3 | County Agency 3 | http://www.ventura.org/general-services-agency/parks-department | County 3 | 331 | Ventura, County of 198 | County 3 | County Agency 3 | Ventura 8 | 0.389 | 0 | Local Other or Unknown 14 | 4 | ||
4658 | 4658 | 4657 | {"type": "Polygon", "coordinates": [[[-119.02661, 34.17427], [-119.0266, 34.17657], [-119.0227, 34.17653], [-119.02268, 34.17641], [-119.02661, 34.17427]]]} | Open Access 1 | 36587 | Unnamed site - Ventura, County of | 28674 | 331 | Ventura, County of 202 | County 3 | County Agency 3 | http://www.ventura.org/general-services-agency/parks-department | County 3 | 331 | Ventura, County of 198 | County 3 | County Agency 3 | Ventura 8 | 11.961 | 0 | Local Other or Unknown 14 | 4 | ||
4659 | 4659 | 4658 | {"type": "Polygon", "coordinates": [[[-119.03011, 34.17448], [-119.02666, 34.17663], [-119.0266, 34.17657], [-119.02661, 34.17427], [-119.02686, 34.17414], [-119.03011, 34.17448]]]} | Open Access 1 | 36588 | Unnamed site - Ventura, County of | 28674 | 331 | Ventura, County of 202 | County 3 | County Agency 3 | http://www.ventura.org/general-services-agency/parks-department | County 3 | 331 | Ventura, County of 198 | County 3 | County Agency 3 | Ventura 8 | 11.275 | 0 | Local Other or Unknown 14 | 4 | ||
4473 | 4473 | 4472 | {"type": "MultiPolygon", "coordinates": [[[[-121.97217, 36.95571], [-121.97161, 36.95571], [-121.97067, 36.95684], [-121.96972, 36.95745], [-121.96972, 36.9572], [-121.96985, 36.95709], [-121.97002, 36.95701], [-121.97017, 36.95688], [-121.97046, 36.95667], [-121.97057, 36.95657], [-121.97068, 36.9564], [-121.97079, 36.9563], [-121.9709, 36.95613], [-121.97105, 36.95599], [-121.9711, 36.95587], [-121.97115, 36.95582], [-121.97122, 36.95566], [-121.97128, 36.95558], [-121.9715, 36.95551], [-121.97151, 36.95549], [-121.97172, 36.95544], [-121.97193, 36.95527], [-121.97196, 36.9553], [-121.97173, 36.9555], [-121.97217, 36.9556], [-121.97217, 36.95571]]], [[[-121.97325, 36.95473], [-121.97294, 36.95463], [-121.97273, 36.95464], [-121.97267, 36.95471], [-121.97265, 36.95471], [-121.97264, 36.95469], [-121.97275, 36.95462], [-121.97288, 36.95459], [-121.97305, 36.95462], [-121.97324, 36.95471], [-121.97325, 36.95473]]]]} | Open Access 1 | 1619 | Unnamed site - Santa Cruz, County of | 28666 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 1.964 | 0 | Local Other or Unknown 14 | 4 | ||
15469 | 15469 | 15468 | {"type": "Polygon", "coordinates": [[[-121.98479, 36.95999], [-121.98474, 36.96002], [-121.98461, 36.96034], [-121.98443, 36.96068], [-121.98393, 36.96052], [-121.98353, 36.96036], [-121.98386, 36.96002], [-121.98431, 36.95983], [-121.98479, 36.95999]]]} | Open Access 1 | 36562 | Unnamed site - Santa Cruz, County of | 28666 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 1.486 | 0 | Local Other or Unknown 14 | 4 | ||
4567 | 4567 | 4566 | {"type": "Polygon", "coordinates": [[[-119.71084, 34.46312], [-119.71071, 34.46336], [-119.70994, 34.46337], [-119.70995, 34.46314], [-119.71084, 34.46312]]]} | Open Access 1 | 35211 | Unnamed site - Santa Barbara, County of | 28662 | 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.489 | 0 | Local Other or Unknown 14 | 4 | ||
4568 | 4568 | 4567 | {"type": "Polygon", "coordinates": [[[-119.62321, 34.44984], [-119.62318, 34.45014], [-119.62286, 34.45046], [-119.62231, 34.45075], [-119.62214, 34.45112], [-119.62197, 34.45112], [-119.62196, 34.45078], [-119.6221, 34.45066], [-119.62217, 34.45053], [-119.62231, 34.44987], [-119.62232, 34.44975], [-119.6223, 34.44957], [-119.62216, 34.44918], [-119.62211, 34.44896], [-119.6221, 34.44883], [-119.62209, 34.44827], [-119.62239, 34.44829], [-119.62238, 34.44846], [-119.62223, 34.44862], [-119.62265, 34.44905], [-119.62283, 34.44907], [-119.62296, 34.44939], [-119.62321, 34.44984]]]} | Open Access 1 | 35212 | Unnamed site - Santa Barbara, County of | 28662 | 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 | 4.011 | 0 | Local Other or Unknown 14 | 4 | ||
4574 | 4574 | 4573 | {"type": "Polygon", "coordinates": [[[-120.41847, 34.87892], [-120.41847, 34.87914], [-120.41845, 34.87917], [-120.41794, 34.87923], [-120.41794, 34.87885], [-120.418, 34.87884], [-120.41807, 34.8788], [-120.41847, 34.87892]]]} | No Public Access 3 | 35227 | Unnamed site - Santa Barbara, County of | 28691 | 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.465 | 0 | Local Other or Unknown 14 | 4 | ||
4575 | 4575 | 4574 | {"type": "Polygon", "coordinates": [[[-120.41196, 34.87233], [-120.40988, 34.87235], [-120.40988, 34.87167], [-120.41063, 34.87167], [-120.41063, 34.87165], [-120.41048, 34.87139], [-120.41055, 34.87137], [-120.41071, 34.87164], [-120.41102, 34.87133], [-120.4118, 34.87166], [-120.41179, 34.87207], [-120.41196, 34.87233]]]} | Open Access 1 | 35235 | Unnamed site - Santa Barbara, County of | 28662 | 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 | 3.807 | 0 | Local Other or Unknown 14 | 4 | ||
4578 | 4578 | 4577 | {"type": "MultiPolygon", "coordinates": [[[[-120.44975, 34.81145], [-120.44876, 34.81144], [-120.44421, 34.8026], [-120.44368, 34.79916], [-120.44429, 34.80052], [-120.44421, 34.80147], [-120.44538, 34.80388], [-120.44649, 34.80641], [-120.44778, 34.80894], [-120.449, 34.81041], [-120.44975, 34.81145]]], [[[-120.44694, 34.81143], [-120.44555, 34.81141], [-120.44464, 34.80544], [-120.44694, 34.81143], [-120.44694, 34.81143]]]]} | Open Access 1 | 35242 | Unnamed site - Santa Barbara, County of | 28662 | 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 | 23.418 | 0 | Local Other or Unknown 14 | 4 | ||
4582 | 4582 | 4581 | {"type": "MultiPolygon", "coordinates": [[[[-120.1849, 34.61028], [-120.18435, 34.61053], [-120.18425, 34.61045], [-120.18475, 34.61022], [-120.1849, 34.61028]]], [[[-120.43144, 34.69015], [-120.43034, 34.69026], [-120.42984, 34.68952], [-120.42983, 34.68933], [-120.42996, 34.68929], [-120.43006, 34.68941], [-120.43087, 34.68899], [-120.431, 34.6891], [-120.43087, 34.68918], [-120.43142, 34.68999], [-120.43144, 34.69015]]], [[[-120.43408, 34.69307], [-120.43387, 34.69201], [-120.43382, 34.69192], [-120.43375, 34.69184], [-120.43334, 34.69167], [-120.43349, 34.69141], [-120.43336, 34.69134], [-120.43351, 34.69111], [-120.43387, 34.69156], [-120.43425, 34.69197], [-120.43457, 34.69241], [-120.43471, 34.6924], [-120.43477, 34.69296], [-120.43518, 34.69386], [-120.43496, 34.69483], [-120.43531, 34.6949], [-120.43529, 34.69518], [-120.43495, 34.69675], [-120.43496, 34.69681], [-120.43501, 34.69687], [-120.43512, 34.69694], [-120.43507, 34.69714], [-120.4354, 34.69765], [-120.43556, 34.69768], [-120.43551, 34.69795], [-120.43488, 34.69786], [-120.43487, 34.69849], [-120.43399, 34.69839], [-120.43398, 34.6992], [-120.43343, 34.69918], [-120.43315, 34.69904], [-120.43413, 34.69775], [-120.43424, 34.69755], [-120.43434, 34.69733], [-120.43442, 34.69709], [-120.43452, 34.69664], [-120.43454, 34.6964], [-120.43451, 34.69514], [-120.43449, 34.69491], [-120.43408, 34.69307]]], [[[-120.43252, 34.69557], [-120.43253, 34.69645], [-120.43246, 34.69677], [-120.43236, 34.69696], [-120.43231, 34.69705], [-120.43203, 34.69738], [-120.43134, 34.69773], [-120.43098, 34.69821], [-120.43081, 34.69823], [-120.43103, 34.69795], [-120.43093, 34.69789], [-120.43065, 34.69796], [-120.42978, 34.69811], [-120.42957, 34.69812], [-120.42893, 34.69812], [-120.42865, 34.69814], [-120.42745, 34.69836], [-120.42721, 34.69845], [-120.42693, 34.69863], [-120.42593, 34.69941], [-120.42581, 34.69954], [-120.42571, 34.69968], [-120.42562, 34.69992], [-120.42542, 34.69992], [-120.42552, 34.69964], [-120.42563, 34.69948], [-120.42572, 34.69937], [-120.42686, 34.69845], [-120.42713, 34.6983], [-120.42726, 34.69825], [-120.42752, 34.69818], [-120.42859, 34.69798], [-120.42877, 34.69796], [-120.42958, 34.69796], [-120.42979, 34.69794], [-120.43069, 34.69778], [-120.43096, 34.69768], [-120.43174, 34.6973], [-120.43198, 34.69712], [-120.43217, 34.69687], [-120.43225, 34.69669], [-120.43232, 34.69639], [-120.43229, 34.69589], [-120.4322, 34.69557], [-120.4319, 34.69507], [-120.43179, 34.69478], [-120.43118, 34.69181], [-120.43106, 34.69134], [-120.43091, 34.69104], [-120.43064, 34.69067], [-120.43086, 34.69056], [-120.43119, 34.69103], [-120.43132, 34.69128], [-120.43207, 34.6948], [-120.43214, 34.69499], [-120.43219, 34.69508], [-120.43252, 34.69553], [-120.43252, 34.69557]]], [[[-120.43087, 34.69835], [-120.43, 34.69953], [-120.4299, 34.69972], [-120.42983, 34.69997], [-120.42966, 34.69994], [-120.42973, 34.69968], [-120.42985, 34.69945], [-120.43064, 34.69839], [-120.43087, 34.69835]]]]} | Open Access 1 | 35355 | Unnamed site - Santa Barbara, County of | 28662 | 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 | 26.157 | 0 | Local Other or Unknown 14 | 4 | ||
4642 | 4642 | 4641 | {"type": "Polygon", "coordinates": [[[-119.78178, 34.43221], [-119.78161, 34.43233], [-119.78143, 34.43249], [-119.78137, 34.43253], [-119.78129, 34.43254], [-119.78124, 34.43252], [-119.78118, 34.43247], [-119.78115, 34.43241], [-119.78114, 34.43234], [-119.78116, 34.43228], [-119.7812, 34.43223], [-119.78127, 34.4322], [-119.78176, 34.43218], [-119.78178, 34.43221]]]} | Open Access 1 | 36491 | Unnamed site - Santa Barbara, County of | 28662 | 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.349 | 0 | Local Other or Unknown 14 | 4 | ||
4643 | 4643 | 4642 | {"type": "Polygon", "coordinates": [[[-119.80253, 34.43606], [-119.80222, 34.43595], [-119.80231, 34.43586], [-119.80236, 34.43578], [-119.8024, 34.43562], [-119.8024, 34.43546], [-119.80231, 34.43516], [-119.80231, 34.43506], [-119.80235, 34.43503], [-119.80253, 34.43503], [-119.80253, 34.43606]]]} | Open Access 1 | 36492 | Unnamed site - Santa Barbara, County of | 28662 | 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.462 | 0 | Local Other or Unknown 14 | 4 | ||
4644 | 4644 | 4643 | {"type": "Polygon", "coordinates": [[[-120.42602, 34.86014], [-120.42568, 34.86014], [-120.42519, 34.85941], [-120.42519, 34.85919], [-120.4253, 34.85927], [-120.42583, 34.85995], [-120.42602, 34.86014]]]} | Open Access 1 | 36495 | Unnamed site - Santa Barbara, County of | 28662 | 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.558 | 0 | Local Other or Unknown 14 | 4 | ||
4645 | 4645 | 4644 | {"type": "Polygon", "coordinates": [[[-120.43198, 34.86241], [-120.43198, 34.86322], [-120.4285, 34.86322], [-120.42752, 34.86223], [-120.42776, 34.86205], [-120.42838, 34.8625], [-120.42864, 34.86265], [-120.42893, 34.86274], [-120.43007, 34.86289], [-120.4306, 34.86289], [-120.43156, 34.86279], [-120.43198, 34.86241]]]} | Open Access 1 | 36496 | Unnamed site - Santa Barbara, County of | 28662 | 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 | 4.83 | 0 | Local Other or Unknown 14 | 4 | ||
4646 | 4646 | 4645 | {"type": "Polygon", "coordinates": [[[-119.89022, 34.44448], [-119.88862, 34.44371], [-119.88866, 34.44361], [-119.88926, 34.44355], [-119.88954, 34.44276], [-119.89019, 34.44276], [-119.89019, 34.44417], [-119.89022, 34.44448]]]} | Open Access 1 | 36501 | Unnamed site - Santa Barbara, County of | 28662 | 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 | 3.642 | 0 | Local Other or Unknown 14 | 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]);