Soil Data Access Query Help
This page provides information one needs in order to effectively query the Soil Data Mart database.
Query Guide
|
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.
|
Soil Data Mart (SDM) Metadata Reports
The main database that Soil Data Access is connected to is called Soil Data Mart (SDM). This database contains the official
soils information for all areas of the United States and Island Jurisdictions. The reports below contain the metadata for SDM.
|
Domains Report (2,713K)
This metadata report provides an overview of the domains used in the Soil Data Mart database. Domains define the set of
allowable values for specific columns (i.e. fields), ensuring consistency in data population by enforcing constraints
on what can be stored. The report includes the domains applied within the database, with values in the "Label Text"
column representing the data as it appears in the respective database fields. Descriptions help clarify the choices
available within each domain. To understand how these domains are associated with database columns, refer to the
Tables and Columns report below.
|
|
Table Column Descriptions Report (1,819K)
This metadata report provides detailed descriptions of each table and column in the Soil Data Mart database. Table
descriptions are located at the bottom.
|
|
Tables and Columns Report (1,989K)
For each Soil Data Mart database table, this report includes a row for each column in that table. For each
table column, the following attributes are displayed:
- Column Sequence
- Column Label
- Column Physical Name
- Column Logical Name
- Logical Data Type
|
- Physical Data Type
- Not Null?
- Field Size
- Precision
|
- Minimum Allowable Value
- Maximum Allowable Value
- Units of Measure
- Associated Domain Name
|
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".
|
|
Unique Constraints Report (718K)
This report includes all unique constraints for all Soil Data Mart database 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".
|
|
Table Relationships Report (721K)
This metadata report shows all the relationships between all tables.
|
Sample Query Documents
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.
|