Skip to page content. Persons with disabilities who require alternative means for communication of soil survey information should contact the NRCS office at the USDA Service Center that services the county of interest. See also the NRCS Accessibility Statement.
 
United States Department of Agriculture Natural Resources Conservation Service
Skip to page content. Home Query   Query Help Web Service Help Help

Soil Data Access Query Help

This page provides information one needs in order to effectively query the Soil Data Mart database. Query Guide Back to Top
Adobe PDF

Soil Data Access Query Guide (183K)
The Soil Data Access Query Guide is composed of two major sections. The first section describes the general content of the Soil Data Mart database, and the conventions used in that database. The second section describes the capabilities and limitations of the web services and interfaces that allow a person to submit a query to be executed against the Soil Data Mart database.


Metadata Reports and Diagrams Back to Top
Adobe PDF

Domains Report (584K)
A column’s values may be restricted to a fixed set of ASCII values, which we refer to as a domain. All domains for all columns associated with a domain, for all Soil Data Access related tables, are included in this report. The domains in this report are sorted in ascending order on the report field titled “Domain Name”. The value that is actually stored in a column associated with that domain is the value in the report column titled “Choice Value”. The metadata report titled “Tables and Columns” indicates the name of a domain associated with a column, if any.

Adobe PDF

Table Column Descriptions Report (258K)
For each Soil Data Access related table, this report includes a description of each column in that table. The entries in this report are sorted in ascending order on the report field titled “Table Physical Name” and table column sequence, although table column sequence is not displayed in this report.

Adobe PDF

Tables and Columns Report (203K)
For each Soil Data Access related table, this report includes a row for each column in that table. For each table column, the following attributes are displayed:

  • Column Sequence
  • Column Physical Name
  • Column Label
  • Logical Data Type
  • Physical Data Type
  • Not Null?
  • Units of Measure
  • Associated Domain Name
  • Minimum Allowable Value
  • Maximum Allowable Value
  • Field Size
  • Precision
For each table, a description of the purpose of that table is also included. The entries in this report are sorted in ascending order on the report field titled “Table Physical Name” and the report column titled “Seq”.

Adobe PDF

Unique Constraints Report (19K)
This report includes all unique constraints for all Soil Data Access related tables. The rows in this report are sorted ascending on the report column titled “Table Physical Name”, primary key constraint Boolean (not displayed in the report) and the report column titled “Constraint Name”.

Adobe PDF

Table Relationships Diagram (25K)
This diagram shows all the relationships between all Soil Data Access related tables with the exception of tables “AREATYPE”, “AREA”, “STATE”, and “SASTATUSMAP”. The diagram displays the physical column name or names on which any two tables are joined. The diagram also shows the cardinality of each relationship (one to one, one to zero or more, etc.).


Sample Query Documents Back to Top
Each sample query document illustrates a particular concept that may be of interest to anyone who wants to query the Soil Data Mart database. At a minimum, we strongly recommend reading “Fundamental Query”, “Discriminating between SSURGO and STATSGO”, and “Constraining a Query to an Area of Interest” before attempting to submit any queries of your own.

Adobe PDF

Fundamental Query (31K)
Adobe PDF

Discriminating between SSURGO and STATSGO (18K)
Adobe PDF

Constraining a Query to an Area of Interest (33K)
Adobe PDF

Returning Soil Texture Related Attributes (24K)
Adobe PDF

Returning Fuzzy Logic Soil Interpretations (60K)
HTML page opens in new window

Advanced Queries
Adobe PDF Using an ADO Shape Command (24K)


Back to Top