Errors in these scripts can be reported to the Soil Data Access technical support staff.
Contact Us
Please submit any scripts that you would like to be posted on this site to the Soil Data Access staff.
Include author, script text, and description of of the query.
Submit Script Here
Index to SQL Soil Data Access Library
This page is an index to information related to SQL queries and Soil Data Access and to examples of SQL queries that can be copied and pasted into the Soil Data Access Query Page. The queries can be modified for different data fields or parameters related to the Area of Interest (AOI).
Information Related to SQL Queries and Soil Data Access
Soil Data Access Home Page
Description: Soil Data Access Home page.
Link:
Soil Data Access Page
Soil Data Access Query Help Page
Description: Soil Data Access help page.
Link:
Soil Data Access Query Help Page
Link to Soil Data Access Query Page
Description: Soil Data Access query page.
Link:
Soil Data Access Query Page
Table Relationship Diagram and Linking Fields
Description: Diagram of all the tables and how they are linked together.
Link:
Table Relationship Diagram
Tables and Column Names in the SSURGO Database
Description: List of all the Table and Column names in the SURRGO database.
Link:
Tables and Column Name Report
YouTube Videos on Soil Data Access Query Construction
Description: Five videos on the basic query structure and development.
Link:
YouTube Videos
Tutorials to Extract Data with R Program
Description: List of tutorials on how to extract data in R program.
Link:
Tutorials To Extract Data With R Program
Tips on Script Construction and Common Errors
Description: Suggested syntax and advice for more efficient queries. It also lists common errors that can occur.
Link:
Tips for More Efficient queries
Example Queries by Category
The example queries are grouped into categories related to the data that will be retrieved.
Link below will open a sub-index that contains additional example queries.
Make sure your browser window Compatibility View Settings are checked to see highlighted text in scripts.
Examples of Query Parts
Description: Link goes to script parts that can be copied and pasted into a query to provide more filtering.
Link:
Example Query Parts with Proper Syntax
Legends and Map Units
Description: Scripts that retrieve data from the legend table and Map Unit tables.
Link:
Examples of Legend and Map Unit Queries
Interpretations
Description: Scripts that retrieve data from the interpretation's Table.
Link:
Interpretations
Productivity and Crop Yields
Description: Scripts that retrieve data for crop yields and productivity indices.
Link:
Examples of Productivity Queries
Ecological Sites
Description: Theses script retrieve data related to ecological sites.
Link:
Examples of Ecological Site Queries
Parent Material
Description: Scripts that retrieve data related to parent material.
Link:
Examples of Parent Material Queries
Water
Description: Scripts that retrieve data related to water features.
Link:
Examples of Water Related Queries
Horizon
Description: Scripts that retrieve data from the horizon table and sub tables.
Link:
Examples of Horizon Data Queries
GIS Linking and Intersection
Description: Scripts that retrieve data that can be linked to the Polygon layer by the MUKEY column, while other scripts use polygon vertices pairs to define a bounding area.
Link:
Examples of GIS and AOI Queries
Programs
Description: Scripts that retrieve data for specific programs, e.g. WEPPS.
Link:
Examples of Specific Queries
Lab Data
Description: Scripts that retrieve data for specific Soil Characterization, e.g. Lab Data.
Link:
Examples of Specific Queries
Helping People Help the Land
USDA is an equal opportunity provider, employer, and lender.