USDA Natural Resources Conservation Service Texas Section IIA, Soils Information, Field Office Technical Guide.

Contents

All Field Office Technical Guide (FOTG) soils information can be accessed in this section and its subsections. Most of the FOTG soils reports can be produced from the soil database downloads available below. Microsoft Access 97 or higher is needed in order to view them. Other reports are downloadable or viewable as Adobe Acrobat Reader (pdf) documents or can be acquired from the local field office in each soil survey area. Reports only available from the field office are mentioned in the subsections for each soil survey area. Internet Explorer 5.x or higher should be used to view these pages and screen resolution be set to 1024 by 768 or you may not see the full screens.

Soil Database Downloads

Getting the Soils Data Files

The Microsoft Access 97 Databases are available only as self extracting executable files from the ftp site:

ftp://ftp-fc.sc.egov.usda.gov/TX/pub/soils/sectionII/downloads/Acess97Databases/.

Depending on your operating system, you can copy to folder and unzip, or left click and then open and unzip to your hard drive, or save the executable file and then unzip by double clicking the executable file. If you set your Internet Explorer option to View List you can select from a vertical list. You can use the soil_d_tx*.mdb file produce soil reports for Field Office Technical Guide soils information in any survey area in the state of Texas. If you have a newer version of Access such as Access 2000, you will have to convert the downloaded file to your version of Access before the reports will work.

File Naming Conventions

Each Access database is in a file named with the prefix "soil_d_" followed by the soil survey area symbol (such as tx027) and the suffix ".mdb". An example of the complete file name is soil_d_tx027.mdb. The tx027 is the soil survey area symbol found in the list at the bottom of this page. Double click the *.mdb file and open it if you have a fast internet connection and run the Access reports, or save it to disk to your hard drive rather than open it. Saving the file to disk insures you have the complete functionality of the Access database. These databases work with Access 97 or can be opened and run with later versions of Microsoft Access.

When you start up the Access 97 database, a screen will come up and you can select one or all, or scattered groups of soil map units. Chose one from the list of reports you want to run, then click "generate report". Using Select Parameters you can run reports on interpretations not listed in the standard set of reports.

Versions of the Access Databases

All reports from the Access Databases have a Distribution Generation Date listed at the bottom of the report that identifies the day the data was created. Only certified datasets are posted to the ftp site. The file list on the ftp server indicates the date and time of certification.

Soil Geospatial Data

Soil Data Viewer is a tool built as an extension to ArcView ® that allows you to easily create soil-based thematic maps. Soil DataViewer shields users and applications from the complexity of the soil database and incorporates rules for appropriate use of soil data. It provides an easy to use tool for geospatial analysis of soil information for resource assessment and management. The requirements to run the Soil Data Viewer are Arc View 3.x, the Soil data Viewer extension download from the Information Technology Center, and SSURGO shape files from NCGC, and the Access 97 database mentioned above: ftp://ftp-fc.sc.egov.usda.gov/TX/pub/soils/sectionII/downloads/Acess97Databases/. Only the shape files from NCGC dated November 2001 or later are compatible with the current version of the Soil Data Viewer and the Access 97 databases.

If you don't have Arc View, you may be able to view shape files using a download of ArcExplorer 2.

File Viewers

Those who do not have Microsoft Office 97 or higher version, or Adobe Acrobat Reader may need to download these file viewers. Most of the contents of the eFOTG soils information is in html format, but some is Microsoft word documents, or pdf format (Adobe Acrobat).

Microsoft Word Viewer Download:

http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q165908&

Microsoft Excel Spreadsheet Viewer Download:

http://office.microsoft.com/downloads/2000/xlviewer.aspx

Adobe Acrobat Reader Download:

http://www.adobe.com/products/acrobat/readstep2.html

Other Links

General and specific soils information links can be found at http://soils.usda.gov/ on the USDA Natural Resources Conservation Service SOILS Web Page.

Soil Survey Area Symbols and Names

Symbol--Survey Area Name

TX001--Anderson County, Texas

TX003--Andrews County, Texas

TX005--Angelina County, Texas

TX009--Archer County, Texas

TX011--Armstrong County, Texas

TX013--Atascosa County, Texas

TX017--Bailey County, Texas

TX019--Bandera County, Texas

TX021--Bastrop County, Texas

TX023--Baylor County, Texas

TX025--Bee County, Texas

TX027--Bell County, Texas

TX029--Bexar County, Texas

TX033--Borden County, Texas

TX035--Bosque County, Texas

TX037--Bowie County, Texas

TX039--Brazoria County, Texas

TX041--Brazos County, Texas

TX045--Briscoe County, Texas

TX047--Brooks County, Texas

TX051--Burleson County, Texas

TX055--Caldwell County, Texas

TX057--Calhoun County, Texas

TX059--Callahan County, Texas

TX061--Cameron County, Texas

TX065--Carson County, Texas

TX069--Castro County, Texas

TX071--Chambers County, Texas

TX073--Cherokee County, Texas

TX075--Childress County, Texas

TX077--Clay County, Texas

TX079--Cochran County, Texas

TX081--Coke County, Texas

TX083--Coleman County, Texas

TX085--Collin County, Texas

TX087--Collingsworth County, Texas

TX089--Colorado County, Texas

TX093--Comanche County, Texas

TX095--Concho County, Texas

TX097--Cooke County, Texas

TX099--Coryell County, Texas

TX101--Cottle County, Texas

TX105--Crockett County, Texas

TX107--Crosby County, Texas

TX109--Culberson County, Texas

TX111--Dallam County, Texas

TX113--Dallas County, Texas

TX115--Dawson County, Texas

TX117--Deaf Smith County, Texas

TX121--Denton County, Texas

TX123--DeWitt County, Texas

TX125--Dickens County, Texas

TX129--Donley County, Texas

TX131--Duval County, Texas

TX133--Eastland County, Texas

TX139--Ellis County, Texas

TX143--Erath County, Texas

TX145--Falls County, Texas

TX147--Fannin County, Texas

TX149--Fayette County, Texas

TX151--Fisher County, Texas

TX153--Floyd County, Texas

TX155--Foard County, Texas

TX157--Fort Bend County, Texas

TX161--Freestone County, Texas

TX163--Frio County, Texas

TX165--Gaines County, Texas

TX167--Galveston County, Texas

TX169--Garza County, Texas

TX171--Gillespie County, Texas

TX173--Glasscock County, Texas

TX175--Goliad County, Texas

TX177--Gonzales County, Texas

TX179--Gray County, Texas

TX181--Grayson County, Texas

TX185--Grimes County, Texas

TX187--Guadalupe County, Texas

TX189--Hale County, Texas

TX191--Hall County, Texas

TX193--Hamilton County, Texas

TX195--Hansford County, Texas

TX197--Hardeman County, Texas

TX199--Hardin County, Texas

TX201--Harris County, Texas

TX203--Harrison County, Texas

TX205--Hartley County, Texas

TX207--Haskell County, Texas

TX211--Hemphill County, Texas

TX213--Henderson County, Texas

TX215--Hidalgo County, Texas

TX217--Hill County, Texas

TX219--Hockley County, Texas

TX225--Houston County, Texas

TX227--Howard County, Texas

TX229--Hudspeth County, Texas

TX231--Hunt County, Texas

TX233--Hutchinson County, Texas

TX235--Irion County, Texas

TX237--Jack County, Texas

TX239--Jackson County, Texas

TX243--Jeff Davis County, Texas

TX247--Jim Hogg County, Texas

TX249--Jim Wells County, Texas

TX251--Johnson County, Texas

TX253--Jones County, Texas

TX255--Karnes County, Texas

TX259--Kendall County, Texas

TX263--Kent County, Texas

TX265--Kerr County, Texas

TX267--Kimble County, Texas

TX269--King County, Texas

TX271--Kinney County, Texas

TX275--Knox County, Texas

TX279--Lamb County, Texas

TX281--Lampasas County, Texas

TX283--La Salle County, Texas

TX285--Lavaca County, Texas

TX287--Lee County, Texas

TX289--Leon County, Texas

TX291--Liberty County, Texas

TX293--Limestone County, Texas

TX295--Lipscomb County, Texas

TX297--Liveoak County, Texas

TX299--Llano County, Texas

TX303--Lubbock County, Texas

TX305--Lynn County, Texas

TX307--McCulloch County, Texas

TX309--McLennan County, Texas

TX311--McMullen County, Texas

TX313--Madison County, Texas

TX317--Martin County, Texas

TX319--Mason County, Texas

TX321--Matagorda County, Texas

TX323--Maverick County, Texas

TX325--Medina County, Texas

TX327--Menard County, Texas

TX329--Midland County, Texas

TX331--Milam County, Texas

TX335--Mitchell County, Texas

TX337--Montague County, Texas

TX339--Montgomery County, Texas

TX341--Moore County, Texas

TX345--Motley County, Texas

TX347--Nacogdoches County, Texas

TX349--Navarro County, Texas

TX353--Nolan County, Texas

TX355--Nueces County, Texas

TX357--Ochiltree County, Texas

TX359--Oldham County, Texas

TX363--Palo Pinto County, Texas

TX365--Panola County, Texas

TX367--Parker County, Texas

TX369--Parmer County, Texas

TX371--Pecos County, Texas

TX375--Potter County, Texas

TX377--Presidio County, Texas

TX381--Randall County, Texas

TX387--Red River County, Texas

TX389--Reeves County, Texas

TX391--Refugio County, Texas

TX393--Roberts County, Texas

TX395--Robertson County, Texas

TX399--Runnels County, Texas

TX401--Rusk County, Texas

TX411--San Saba County, Texas

TX413--Schleicher County, Texas

TX415--Scurry County, Texas

TX417--Shackelford County, Texas

TX419--Shelby County, Texas

TX421--Sherman County, Texas

TX423--Smith County, Texas

TX427--Starr County, Texas

TX429--Stephens County, Texas

TX431--Sterling County, Texas

TX433--Stonewall County, Texas

TX435--Sutton County, Texas

TX437--Swisher County, Texas

TX439--Tarrant County, Texas

TX441--Taylor County, Texas

TX443--Terrell County, Texas

TX445--Terry County, Texas

TX447--Throckmorton County, Texas

TX451--Tom Green County, Texas

TX453--Travis County, Texas

TX455--Trinity County, Texas

TX457--Tyler County, Texas

TX463--Uvalde County, Texas

TX465--Val Verde County, Texas

TX467--Van Zandt County, Texas

TX469--Victoria County, Texas

TX471--Walker County, Texas

TX475--Ward County, Texas

TX477--Washington County, Texas

TX479--Webb County, Texas

TX481--Wharton County, Texas

TX483--Wheeler County, Texas

TX485--Wichita County, Texas

TX487--Wilbarger County, Texas

TX489--Willacy County, Texas

TX491--Williamson County, Texas

TX493--Wilson County, Texas

TX497--Wise County, Texas

TX499--Wood County, Texas

TX501--Yoakum County, Texas

TX503--Young County, Texas

TX505--Zapata County, Texas

TX600--Austin and Waller Counties, Texas

TX601--Blanco and Burnet Counties, Texas

TX602--Brown and Mills Counties, Texas

TX603--Camp, Franklin, Morris, and Titus Counties, Texas

TX604--Comal and Hays Counties, Texas

TX605--Dimmitt and Zavala Counties, Texas

TX606--Ector and Crane Counties, Texas

TX607--Edwards and Real Counties, Texas

TX608--Upshur and Gregg Counties, Texas

TX609--Hood and Somervell Counties, Texas

TX610--Hopkins and Rains Counties, Texas

TX611--Jasper and Newton Counties, Texas

TX612--Kaufman and Rockwall Counties, Texas

TX613--Kenedy and Kleberg Counties, Texas

TX614--Lamar and Delta Counties, Texas

TX615--Loving and Winkler Counties, Texas

TX616--Marion and Cass Counties, Texas

TX617--Polk and San Jacinto Counties, Texas

TX618--Reagan and Upton Counties, Texas

TX619--San Augustine and Sabine Counties, Texas

TX620--San Patricio and Aransas Counties, Texas

TX621--Big Bend National Park Part of Brewster County, Texas

TX622--Brewster County, Texas (Main Part)

TX623--Jefferson and Orange Counties, Texas

TX624-- El Paso County, Texas (Main Part)

NM719--Fort Bliss Military Reservation, New Mexico and Texas