Soil Data Access
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 GuideBack 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 DiagramsBack to Top

Adobe PDF

Domains Report (3,523K)
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 (741K)
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 (1,808K)
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 (83K)
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".

HTML page opens in new window

Table Relationships
This page shows all the relationships between all Soil Data Access related tables with the exception of tables "AREATYPE", "AREA", "STATE", and "SASTATUSMAP". This page displays the key column on which any two tables are joined.

Sample Query DocumentsBack 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. SSURGO is an acronym for Soil Survey Geographic Database and STATSGO is an acronym for State Soil Geographic Database. For details on SSURGO or STATSGO, consult the following web page: SSURGO and STATSGO. ADO is an acronym for Active X Data Objects. For details on ADO, consult the following web page: Active X Data Objects.

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