Soil Database The soil data for WEPS is derived from the Soil Survey Geographical (SSURGO) database -developed and maintained by the USDA-NRCS. Below is a list of the data elements which are obtained from SSURGO and a brief description of each.

Downloading Soil Data

This section describes how to download soil data from the NRCS Soil Data Mart and how to extract it for use within WEPS. A Microsoft Access database is available for importing the data in the export file. You must have Microsoft Access 97 or later installed on your PC.

Soil data for NRCS and most other users in the US, is currently available for download from the NRCS Soil Data Mart at: http://soildatamart.nrcs.usda.gov/ . Soil survey data that is exported from the Soil Data Mart is in what is referred to as "SSURGO" (Soil Survey Geographic) format. To obtain soil data for a Soil Survey Area of interest, go to the Soil Data Mart and click 全elect State' at the top of the Soil Data Mart screen. Select the desired state then click 全elect Survey Area' or 全elect County'. Select the soil survey area, then click 船ownload Data'. On the download screen select 禅abular Data Only', select the version of Microsoft Access on your computer, and enter your e-mail address, then click 全ubmit Request'. You will see a message stating "Your request has been logged. At a later time you will receive an e-mail with a link to download the export file. The format of an export file name is: soil_ssasymbol.zip, where ssasymbol is the soil survey symbol of the corresponding soil survey area.

After the export file has been copied to your PC, it must be unzipped using either WinZip or a similar program. For additional information, please see the file named README.txt in the root directory that is created by unzipping the export file. For additional soil survey areas, each zip file should be copied and unzipped into individual directories. When an export file is unzipped, the following directory hierarchy is produced in the directory to which the export file was unzipped:

spatial
tabular

The top level directory contains the following files:

soil_metadata_ssasymbol.txt - Federal Geographic Data Committee (FGDC) metadata in plain ASCII format.

soil_metadata_ssasymbol.xml - the same FGDC metadata in XML format.

readme.txt - a text file containing additional information.

The root directory will also contain a zipped, empty MS Access SSURGO template database, if one was requested as part of the download. The non-extension part of the zipped template database file name varies, but if one was included, it will be the only file in the top level directory with an extension of "zip". This file should be unzipped as well.

The directory "tabular" contains any tabular data that was requested. The directory "spatial" contains any spatial data that was requested. Note that spatial data is not required or recommended (due to file size) for WEPS. It is possible to request tabular data from the Soil Data Mart, without including the corresponding spatial data, and vice versa.

Tabular data is provided as a set of ASCII delimited files. Each file corresponds to a table in the SSURGO 2.1 data model. The tabular data isn't particularly useful until it has been imported into the MS Access SSURGO template database. Current Soil Data Mart downloads include a template database. If a template database was not included in the export file, you can download one from the following URL:

http://soildatamart.nrcs.usda.gov/templates.aspx

Load the template file into MS Access. A 全SURGO Import' screen will display asking for the full path to the tabular data directory. Type the full path of the tabular directory and click 前K'. A list of database tables will appear and a folder will be created in the top level directory (with the non-extension part of the template name). At the same time, an MS Access database file (*.mdb) which contains the data required for WEPS, will be created in the template folder. To import more than one soil survey area into a single MS Access database, run the Import macro specifying the full path to the directory the SSURGO data was uncompressed into. Repeat the Import macro for each area desired. When done, save the template database with the imported data to a new name (*.mdb).

Using SSURGO Data With WEPS

Within WEPS, open the "Configuration" window, then click the "Directories" tab. Fill out the full path and SSURGO soil database file name (*.mdb) for "Soil DB" and close the configuration window. Selecting the Soil Template folder at the bottom of the main WEPS screen will display the list of soil survey areas to choose from. Select the desired soil survey area and select the soil map unit and component for the simulation run. If the SSURGO database is not populated with data required by WEPS you will get an error message when selecting that soil. More detailed information on selecting soils, see the "Interface Reference: Choosing a Soil" section of the WEPS User Manual.