Mast head image

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


Helping People Help the Land

USDA is an equal opportunity provider, employer, and lender.