README.md

Soil Data Access SQL Script Library

Soil Data Access is the name of a suite of web services and applications whose purpose is to meet requirements for requesting and delivering soil survey spatial and tabular data that are not being met by the current Web Soil Survey and Geospatial Data Gateway websites.

sda-lib

GitHub sda-lib Wiki Home

Soil Data Access Query Page

1. Submitting a Query Submit your own SQL or SQL Data Shaping query to retrieve data from the Soil Data Mart.

2. Using Soil Data Access web services Help Soil Data Access Web Service Help.

3. Creating my own custom database queries Help Soil Data Access Query Help. This page provides information one needs in order to effectively query Soil Data Access. Documents and other guides.

4. Using the Soil Data Access website Help Soil Data Access Help. The purpose of this page is to provide you with general information about this site and to help you resolve some common issues that may be experienced whilst browsing.

5. Citing Soil Data Access as a source of soils data.

6. Advanced Queries Soil Data Access provides two advanced features for querying spatial data:

   • Tabular Functions act as "virtual" tables that can be used in the "FROM" clause of a query.
   • Macros are condensed statements that SDA expands into full SQL statements.

   Soil Data Access Script Examples with Explanation

list:

• Soil Organic Carbon Stocks by Map Unit
• Geometry Intersect by Map Unit Acres
• Query by Map Unit Name or Map Unit Symbol
• Lab Chemical Properties
• WV Crop Yields
• Web Soil Survey Metrics Report by a State
• Aggregate Stability by a State