Exports from the Soil Data Mart are delivered in what is referred to as
SSURGO format.
The following documents, diagrams and reports describe the SSURGO standard,
as well as the tools and procedures that are necessary to effectively use this data.
- SSURGO Data Packaging and Use (118K)
This document describes the format of a SSURGO export file, and discusses some of the applications
available for using this data.
- SSURGO Data Model Diagram - Part 1 (31K)
This diagram shows the soil tabular and spatial data tables in the SSURGO standard, and how those
tables are related. Only primary and foreign key columns are included in this diagram. See the
report titled “SSURGO Metadata – Table Columns” for a complete listing of all columns in each table.
The information in this diagram is also available in non-graphical format in the report titled
“SSURGO Metadata – Relationships”.
- SSURGO Data Model Diagram - Part 2 (19K)
This diagram shows the static metadata and Soil Data Viewer related tables in the SSURGO standard,
and how those tables are related. Only primary and foreign key columns are included in this diagram.
See the report titled “SSURGO Metadata – Table Columns” for a complete listing of all columns in each
table. The information in this diagram is also available in non-graphical format in the report titled
“SSURGO Metadata – Relationships”.
- SSURGO Metadata – Tables (71K)
This report provides a narrative description of each table in the SSURGO standard.
- SSURGO Metadata - Table Columns (186K)
This report lists the columns of each table in the SSURGO standard. This is the source for
column name, logical data type, field size, precision, minimum, maximum, units of measure and
associated domain name, if any.
- SSURGO Metadata - Table Column Descriptions (305K)
This report provides a narrative description of every column in every table in the SSURGO standard.
- SSURGO Metadata - Indexes (53K)
This report documents all unique and duplicate indexes defined for tables in the SSURGO standard.
What unique constraints (unique indexes) are defined is of primary interest. In the SSURGO standard,
relatively few business oriented unique constraints are defined. Most of the unique constraints
represent non-business oriented unique constraints (i.e. surrogate keys).
- SSURGO Metadata – Relationships (30K)
This report documents all relationships between tables in the SSURGO standard. This information
is important for understanding the relationship between various soil attributes and entities.
This information is needed in order to be able to effectively query the database. The information
in this report is also available in graphical format in the diagram titled “SSURGO Data Model Diagram”.
- SSURGO Metadata – Domains (664K)
This report documents all domains associated with columns of tables in the SSURGO standard.
If a column is associated with a domain, that relationship will be documented in the report titled
“SSURGO Metadata – Table Columns”. A particular column may be associated with one and only one domain,
but a particular domain may be associated with more than one column. This report displays all possible
members of a domain. For some domain members, an additional narrative description is sometimes
available.
|