units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
45 rows where MNG_AG_TYP = 20 sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, MNG_AG_ID, YR_EST, GAP_STS
MNG_AGENCY 37
- San Francisco Parks Alliance 5
- Odd Fellows Sierra Recreation Association 3
- Santa Barbara Trust for Historic Preservation 2
- Nonprofit Organization - Unknown 2
- Sierra Historic Sites Association 1
- Tulare County Historical Society 1
- Boys and Girls Clubs of South County 1
- Redlands Conservancy 1
- The Collaborative Eagle Rock Beautiful 1
- Heal the Bay 1
- Mare Island Historic Park Foundation 1
- Mendocino Woodlands Camp Association 1
- San Diego Humane Society and SPCA 1
- Forestville Park Development District 1
- Kingsburg Historical Society 1
- Kare Youth League 1
- Montalvo Association 1
- San Jacinto Mountain Community Center 1
- Glendora Community Conservancy 1
- Huntington Library and Botanical Gardens 1
- Foundation for Preservation of Mt. Helix Nature Theatre 1
- San Diego Zoo Global 1
- La Verne Heritage Foundation 1
- Independent Order of Odd Fellows 1
- Mission Santa Ines 1
- Silver Dollar BMX 1
- Willits Kids Club 1
- Central Valley Community Sports Foundation 1
- Murrieta Valley PONY Baseball, Inc 1
- Lao Family Community Development, Inc. 1
- City Slicker Farms 1
- Los Angeles Neighborhood Initiative 1
- Watts Labor Community Action Committee 1
- Boy Scouts of America 1
- YMCA of Southeast - Rio Vista 1
- Rancho Santa Fe Community Foundation 1
- National Trust for Historic Preservation 1
DES_TP 20
- Private Recreation or Education 13
- Private Conservation 12
- Private Agricultural 2
- Private Other or Unknown 2
- State Park 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
- None 1
- None 1
- None 1
COUNTY 19 ✖
- Los Angeles 10
- San Diego 7
- San Francisco 6
- Santa Barbara 3
- Fresno 2
- Riverside 2
- Mendocino 2
- Calaveras 2
- Monterey 1
- San Mateo 1
- Sonoma 1
- Alameda 1
- Santa Clara 1
- Tuolumne 1
- San Bernardino 1
- Solano 1
- Tulare 1
- Butte 1
- Madera 1
ACCESS_TYP 4
MNG_AG_TYP 1
- Non Profit - Other · 45 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16986 | 16986 | 16985 | {"type": "Polygon", "coordinates": [[[-122.33796, 37.45405], [-122.33784, 37.45482], [-122.3369, 37.45579], [-122.33616, 37.45669], [-122.33589, 37.45776], [-122.33615, 37.45885], [-122.33668, 37.45965], [-122.31809, 37.47368], [-122.31807, 37.47367], [-122.3133, 37.47728], [-122.30701, 37.47208], [-122.30873, 37.47076], [-122.30803, 37.46999], [-122.30845, 37.46868], [-122.30961, 37.46678], [-122.31148, 37.46868], [-122.31435, 37.46651], [-122.3146, 37.46658], [-122.31482, 37.46659], [-122.31543, 37.46654], [-122.3156, 37.46558], [-122.33576, 37.45033], [-122.33575, 37.45149], [-122.33668, 37.45179], [-122.33796, 37.45405]]]} | Restricted Access 2 | 16413 | Filoli Center | 18900 | 3047 | National Trust for Historic Preservation 1184 | Non Profit 6 | Non Profit - Other 22 | http://www.preservationnation.org/ | Non Governmental Organization 10 | 3047 | National Trust for Historic Preservation 1122 | Non Profit 6 | Non Profit - Other 20 | San Mateo 15 | 657.331 | Filoli Ctr. | 1975 | Private Conservation 16 | 2 | |
16450 | 16450 | 16449 | {"type": "Polygon", "coordinates": [[[-120.54486, 38.22673], [-120.54487, 38.22707], [-120.54477, 38.22764], [-120.54471, 38.22788], [-120.54459, 38.22809], [-120.54345, 38.22879], [-120.54334, 38.22869], [-120.5434, 38.22789], [-120.54309, 38.22772], [-120.54359, 38.22728], [-120.54486, 38.22673]]]} | Open Access 1 | 26533 | Mountain Ranch Community Park | 22546 | 3050 | Odd Fellows Sierra Recreation Association 821 | Non Profit 6 | Non Profit - Other 22 | http://ofsraparkmgt.wix.com/home | Non Governmental Organization 10 | 3050 | Odd Fellows Sierra Recreation Association 799 | Non Profit 6 | Non Profit - Other 20 | Calaveras 53 | 4.68 | Mtn. Ranch Community Park | 0 | Private Recreation or Education 65 | 4 | |
15558 | 15558 | 15557 | {"type": "MultiPolygon", "coordinates": [[[[-117.23623, 33.03472], [-117.23609, 33.03514], [-117.23477, 33.03601], [-117.23459, 33.03653], [-117.23385, 33.03634], [-117.23455, 33.03424], [-117.23623, 33.03472]]], [[[-117.23374, 33.03631], [-117.23309, 33.03834], [-117.23296, 33.03831], [-117.23292, 33.03841], [-117.23201, 33.03818], [-117.23209, 33.03792], [-117.23191, 33.03787], [-117.23251, 33.03599], [-117.23374, 33.03631]]]]} | Open Access 1 | 1247 | San Elijo Lagoon Ecological Reserve | 24880 | 3058 | Rancho Santa Fe Community Foundation 1159 | Non Profit 6 | Non Profit - Other 22 | http://www.rsffoundation.org/ | Non Governmental Organization 10 | 3058 | Rancho Santa Fe Community Foundation 1101 | Non Profit 6 | Non Profit - Other 20 | https://www.sanelijo.org/home | San Diego 4 | 14.074 | San Elijo Lagoon ER | 1983 | Private Conservation 16 | 2 |
15309 | 15309 | 15308 | {"type": "Polygon", "coordinates": [[[-118.1787, 33.98749], [-118.1785, 33.98885], [-118.17811, 33.98882], [-118.17817, 33.98838], [-118.17812, 33.98837], [-118.17792, 33.98851], [-118.17774, 33.98834], [-118.17784, 33.98769], [-118.17797, 33.98769], [-118.178, 33.98742], [-118.1787, 33.98749]]]} | Open Access 1 | 46464 | Maywood Activity Center | 29736 | 1200 | Maywood, City of 260 | City 2 | City Agency 2 | http://www.cityofmaywood.com/index.php?option=com_content&view=article&id=162&Itemid=69 | City 2 | 3366 | YMCA of Southeast - Rio Vista 1098 | Non Profit 6 | Non Profit - Other 20 | http://www.cityofmaywood.com/index.php?option=com_content&view=article&id=162&Itemid=69 | Los Angeles 6 | 2.399 | Maywood Activity Ctr. | None 1354 | ||
15133 | 15133 | 15132 | {"type": "Polygon", "coordinates": [[[-117.98619, 34.17245], [-117.98605, 34.1798], [-117.9775, 34.17979], [-117.97751, 34.17245], [-117.98619, 34.17245]]]} | Open Access 1 | 45953 | Canyon Park, Boy Scouts of America | 29062 | 3360 | Boy Scouts of America 1137 | Non Profit 6 | Non Profit - Other 22 | http://www.scouting.org/ | Non Governmental Organization 10 | 3360 | Boy Scouts of America 1092 | Non Profit 6 | Non Profit - Other 20 | Los Angeles 6 | 159.848 | Canyon Park, Boy Scouts of America | 0 | Private Conservation 16 | 2 | |
14746 | 14746 | 14745 | {"type": "Polygon", "coordinates": [[[-118.23664, 33.94324], [-118.23665, 33.94382], [-118.23662, 33.94385], [-118.23513, 33.94385], [-118.23512, 33.94321], [-118.2366, 33.94322], [-118.23664, 33.94324]]]} | Open Access 1 | 45090 | MudTown Farms | 28055 | 3351 | Watts Labor Community Action Committee 1122 | Non Profit 6 | Non Profit - Other 22 | http://www.wlcac.org/ | Non Governmental Organization 10 | 3351 | Watts Labor Community Action Committee 1077 | Non Profit 6 | Non Profit - Other 20 | Los Angeles 6 | 2.45 | MudTown Farms | 0 | Private Agricultural 354 | 4 | |
14706 | 14706 | 14705 | {"type": "MultiPolygon", "coordinates": [[[[-118.30836, 33.98193], [-118.30825, 33.98197], [-118.30786, 33.98212], [-118.30786, 33.98191], [-118.30833, 33.98191], [-118.30836, 33.98193]]], [[[-118.30883, 33.98208], [-118.30883, 33.98228], [-118.30824, 33.98228], [-118.3082, 33.98226], [-118.30822, 33.98223], [-118.30862, 33.98208], [-118.30883, 33.98208]]], [[[-118.30873, 33.9818], [-118.30853, 33.98187], [-118.30843, 33.98187], [-118.30843, 33.9818], [-118.30873, 33.9818]]]]} | Open Access 1 | 45061 | Western Gage Park | 32566 | 3269 | Los Angeles Neighborhood Land Trust 564 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.lanlt.org/ | Non Governmental Organization 10 | 3368 | Los Angeles Neighborhood Initiative 1074 | Non Profit 6 | Non Profit - Other 20 | Los Angeles 6 | 0.428 | Western Gage Park | 0 | Private Recreation or Education 65 | 4 | |
13918 | 13918 | 13917 | {"type": "Polygon", "coordinates": [[[-122.47779, 37.71752], [-122.47794, 37.71754], [-122.47824, 37.71766], [-122.47842, 37.71779], [-122.47855, 37.71794], [-122.47864, 37.71809], [-122.47866, 37.71822], [-122.47864, 37.7183], [-122.4786, 37.71838], [-122.47849, 37.71848], [-122.47836, 37.71855], [-122.47824, 37.71859], [-122.4781, 37.71859], [-122.47795, 37.71857], [-122.47777, 37.71849], [-122.47759, 37.71838], [-122.47748, 37.71829], [-122.47737, 37.71816], [-122.47731, 37.71806], [-122.47729, 37.71796], [-122.47729, 37.71787], [-122.47733, 37.71778], [-122.47742, 37.71767], [-122.47753, 37.71758], [-122.47763, 37.71754], [-122.47779, 37.71752]]]} | Open Access 1 | 48836 | Robert Pender Park | 33555 | 6134 | Parkmerced Owner LLC 1068 | Private 7 | Home Owners Association 16 | https://www.parkmerced.com/ | Private 14 | 3308 | San Francisco Parks Alliance 521 | Non Profit 6 | Non Profit - Other 20 | https://www.sfparksalliance.org/our-parks/parks/robert-pender-park | San Francisco 13 | 2.548 | Robert Pender Park | 0 | Private Recreation or Education 65 | 4 |
13784 | 13784 | 13783 | {"type": "Polygon", "coordinates": [[[-122.39106, 37.77842], [-122.38914, 37.77988], [-122.38862, 37.78032], [-122.38843, 37.78055], [-122.38828, 37.78079], [-122.38819, 37.78101], [-122.38806, 37.78144], [-122.388, 37.78149], [-122.38791, 37.78151], [-122.38783, 37.7815], [-122.38776, 37.78145], [-122.38774, 37.78141], [-122.38768, 37.7806], [-122.38752, 37.77914], [-122.38746, 37.77826], [-122.38762, 37.77821], [-122.38757, 37.77824], [-122.38779, 37.78026], [-122.38849, 37.78024], [-122.38856, 37.78029], [-122.391, 37.77836], [-122.39106, 37.77842]]]} | Open Access 1 | 48834 | South Beach Park | 33553 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 3308 | San Francisco Parks Alliance 521 | Non Profit 6 | Non Profit - Other 20 | https://www.sfparksalliance.org/our-parks/parks/south-beach-park | San Francisco 13 | 2.826 | South Beach Park | None 1186 | ||
13138 | 13138 | 13137 | {"type": "Polygon", "coordinates": [[[-122.28644, 37.82262], [-122.286, 37.82271], [-122.28597, 37.82264], [-122.28553, 37.82273], [-122.28539, 37.82229], [-122.28607, 37.82144], [-122.28644, 37.82262]]]} | Open Access 1 | 45086 | West Oakland Park and Urban Farm | 28126 | 3350 | City Slicker Farms 1044 | Non Profit 6 | Non Profit - Other 22 | http://www.cityslickerfarms.org | Non Governmental Organization 10 | 3350 | City Slicker Farms 1005 | Non Profit 6 | Non Profit - Other 20 | Alameda 17 | 1.868 | West Oakland Park and Urban Farm | 2016 | Private Agricultural 354 | 4 | |
13049 | 13049 | 13048 | {"type": "Polygon", "coordinates": [[[-122.40341, 37.78499], [-122.40282, 37.78546], [-122.40271, 37.78538], [-122.40252, 37.7855], [-122.40177, 37.78492], [-122.40254, 37.78429], [-122.40265, 37.78437], [-122.40289, 37.78441], [-122.403, 37.78445], [-122.40309, 37.78451], [-122.40319, 37.78463], [-122.40321, 37.78473], [-122.40321, 37.78483], [-122.40341, 37.78499]]]} | Open Access 1 | 34902 | Yerba Buena Gardens | 27769 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 6095 | Lao Family Community Development, Inc. 1001 | Non Profit 6 | Non Profit - Other 20 | San Francisco 13 | 2.694 | Yerba Buena Gardens | None 1130 | |||
12592 | 12592 | 12591 | {"type": "Polygon", "coordinates": [[[-122.39117, 37.78541], [-122.39071, 37.78573], [-122.39028, 37.78609], [-122.39017, 37.78649], [-122.38985, 37.78623], [-122.39103, 37.78533], [-122.39117, 37.78541]]]} | Open Access 1 | 48777 | Rincon Hill Dog Park | 33503 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 3308 | San Francisco Parks Alliance 521 | Non Profit 6 | Non Profit - Other 20 | https://www.rinconhilldogpark.org/about | San Francisco 13 | 0.621 | Rincon Hill Dog Park | 2007 | None 1091 | |
12587 | 12587 | 12586 | {"type": "Polygon", "coordinates": [[[-117.18941, 33.5381], [-117.18772, 33.53937], [-117.1867, 33.53844], [-117.18884, 33.53681], [-117.1892, 33.53738], [-117.18941, 33.5381]]]} | Restricted Access 2 | 48772 | Murrieta Valley Pony Baseball | 33498 | 3397 | Murrieta Valley PONY Baseball, Inc 1031 | Non Profit 6 | Non Profit - Other 22 | https://www.mvpb.org/ | Non Governmental Organization 10 | 3397 | Murrieta Valley PONY Baseball, Inc 992 | Non Profit 6 | Non Profit - Other 20 | https://www.mvpb.org/ | Riverside 10 | 8.519 | Murrieta Valley Pony Baseball | 0 | Private Conservation 16 | 2 |
12389 | 12389 | 12388 | {"type": "Polygon", "coordinates": [[[-120.68035, 38.19748], [-120.68032, 38.19764], [-120.68019, 38.19787], [-120.68018, 38.19785], [-120.67998, 38.1978], [-120.68001, 38.19774], [-120.67974, 38.19755], [-120.67987, 38.19743], [-120.6797, 38.19732], [-120.67974, 38.19727], [-120.67949, 38.1971], [-120.67965, 38.19699], [-120.67991, 38.19725], [-120.68002, 38.19734], [-120.68035, 38.19748]]]} | Open Access 1 | 26534 | Neilsen Park | 22689 | 3050 | Odd Fellows Sierra Recreation Association 821 | Non Profit 6 | Non Profit - Other 22 | http://ofsraparkmgt.wix.com/home | Non Governmental Organization 10 | 3050 | Odd Fellows Sierra Recreation Association 799 | Non Profit 6 | Non Profit - Other 20 | Calaveras 53 | 0.651 | Neilsen Park | 0 | Private Recreation or Education 65 | 4 | |
11525 | 11525 | 11524 | {"type": "Polygon", "coordinates": [[[-119.75209, 36.7914], [-119.75208, 36.79222], [-119.74984, 36.79221], [-119.74986, 36.79015], [-119.74979, 36.79014], [-119.74979, 36.78996], [-119.74993, 36.78995], [-119.74995, 36.78796], [-119.75026, 36.78784], [-119.75059, 36.78776], [-119.75151, 36.78761], [-119.7515, 36.78918], [-119.75146, 36.78919], [-119.75145, 36.79076], [-119.75161, 36.79077], [-119.75161, 36.79139], [-119.75209, 36.7914]]]} | Open Access 1 | 48727 | Granite Park Sports Complex | 33452 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 3396 | Central Valley Community Sports Foundation 947 | Non Profit 6 | Non Profit - Other 20 | https://www.graniteparkfresno.com/about-us | Fresno 9 | 18.769 | Granite Park Sports Complex | None 1028 | ||
11427 | 11427 | 11426 | {"type": "Polygon", "coordinates": [[[-123.35819, 39.40016], [-123.35815, 39.40029], [-123.35808, 39.40029], [-123.35808, 39.40035], [-123.35769, 39.40035], [-123.35769, 39.40074], [-123.35748, 39.40075], [-123.35748, 39.40086], [-123.35711, 39.40086], [-123.35709, 39.40016], [-123.35819, 39.40016]]]} | Open Access 1 | 48094 | Willits Kids Club Discovery Park and Playground | 32597 | 3383 | Willits Kids Club 977 | Non Profit 6 | Non Profit - Other 22 | http://www.willitskidsclub.org/about | Non Governmental Organization 10 | 3383 | Willits Kids Club 941 | Non Profit 6 | Non Profit - Other 20 | Mendocino 24 | 1.119 | Willits Kids Club Discovery Park and Playground | 0 | Private Conservation 16 | 2 | |
10925 | 10925 | 10924 | {"type": "Polygon", "coordinates": [[[-121.81078, 39.71922], [-121.81078, 39.71922], [-121.8073, 39.71927], [-121.80736, 39.71921], [-121.80879, 39.71919], [-121.80878, 39.71845], [-121.81077, 39.71844], [-121.81078, 39.71922]]]} | Restricted Access 2 | 48675 | Silver Dollar BMX | 33416 | 1052 | Chico, City of 430 | City 2 | City Agency 2 | http://www.chico.ca.us/general_services_department/park_division/home_page.asp | City 2 | 3395 | Silver Dollar BMX 929 | Non Profit 6 | Non Profit - Other 20 | https://www.usabmx.com/tracks/1344/about | Butte 42 | 3.937 | Silver Dollar BMX | None 953 | ||
9727 | 9727 | 9726 | {"type": "MultiPolygon", "coordinates": [[[[-120.13806, 34.5955], [-120.13783, 34.59587], [-120.13748, 34.59587], [-120.13774, 34.59539], [-120.13806, 34.5955]]], [[[-120.13298, 34.59524], [-120.13303, 34.59238], [-120.13834, 34.59241], [-120.13774, 34.5938], [-120.13801, 34.59389], [-120.13736, 34.59525], [-120.13714, 34.59519], [-120.13684, 34.59587], [-120.13426, 34.59587], [-120.13419, 34.59581], [-120.13387, 34.59591], [-120.13351, 34.5959], [-120.13344, 34.59597], [-120.13299, 34.59595], [-120.13298, 34.59524]], [[-120.13784, 34.59336], [-120.13783, 34.59334], [-120.13691, 34.59307], [-120.13667, 34.59363], [-120.13759, 34.59391], [-120.13784, 34.59336]]]]} | Open Access 1 | 17867 | Mission Santa Inés | 22311 | 3040 | Mission Santa Ines 924 | Non Profit 6 | Non Profit - Other 22 | http://www.missionsantaines.org/ | Non Governmental Organization 10 | 3040 | Mission Santa Ines 897 | Non Profit 6 | Non Profit - Other 20 | Santa Barbara 7 | 40.168 | Mission Santa Inés | 0 | Private Conservation 16 | 2 | |
9703 | 9703 | 9702 | {"type": "Polygon", "coordinates": [[[-121.6411, 36.65494], [-121.64106, 36.65632], [-121.641, 36.65661], [-121.6406, 36.65768], [-121.64034, 36.65762], [-121.63984, 36.65855], [-121.63922, 36.65869], [-121.638, 36.65816], [-121.63756, 36.65787], [-121.63698, 36.65755], [-121.63948, 36.65383], [-121.64101, 36.65449], [-121.64084, 36.65478], [-121.64082, 36.65492], [-121.6411, 36.65494]]]} | Unknown Access 4 | 16402 | Garden of Memories Memorial Park | 19198 | 3031 | Independent Order of Odd Fellows 921 | Non Profit 6 | Non Profit - Other 22 | http://www.ioof.org/ | Non Governmental Organization 10 | 3031 | Independent Order of Odd Fellows 894 | Non Profit 6 | Non Profit - Other 20 | Monterey 14 | 29.526 | Garden of Memories Memorial Park | 0 | Private Recreation or Education 65 | 4 | |
9507 | 9507 | 9506 | {"type": "Polygon", "coordinates": [[[-117.77532, 34.12952], [-117.77504, 34.12945], [-117.77433, 34.1294], [-117.77405, 34.12932], [-117.77412, 34.12916], [-117.77405, 34.12898], [-117.77414, 34.12894], [-117.77431, 34.1287], [-117.77434, 34.12868], [-117.77432, 34.1286], [-117.7742, 34.12857], [-117.77402, 34.12834], [-117.77396, 34.12824], [-117.77394, 34.12812], [-117.77421, 34.12799], [-117.77383, 34.12742], [-117.774, 34.1274], [-117.77418, 34.12741], [-117.77492, 34.12751], [-117.77483, 34.12784], [-117.77483, 34.12796], [-117.77491, 34.12831], [-117.77504, 34.12875], [-117.77512, 34.12876], [-117.77516, 34.12873], [-117.77532, 34.12952]]]} | Restricted Access 2 | 47831 | La Verne Heritage Foundation | 31773 | 1162 | La Verne, City of 305 | City 2 | City Agency 2 | http://www.ci.la-verne.ca.us/index.php/residents/parks | City 2 | 3382 | La Verne Heritage Foundation 888 | Non Profit 6 | Non Profit - Other 20 | Los Angeles 6 | 4.634 | La Verne Heritage Foundation | None 788 |
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]);