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.
|
Metadata Reports and Diagrams
|
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.
|
|
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.
|
|
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”.
|
|
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”.
|
|
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
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.
|