Package: soilDB 2.9.2

Introduction | Setup | Grid Selection | gSSURGO | gNATSGO | Raster Soil Survey | STATSGO | Thematic Mapping | Caveats / Limitations | Web Coverage Service Requests Using Bounding Boxes | Manual Creation of Bounding Boxes | Map Unit Key Grids | SSURGO Polygons from SDA | Grid Resolution Specification | Raster Soil Survey Data | Hawaii SSURGO | Puerto Rico SSURGO | Map Unit Aggregate Values | Interpretations for Soil Suitability / Limitation | Component-level Properties | Several Horizon-level Soil Properties | Sand, Silt, and Clay at a Soil Survey Area Boundary

Introduction to Soil Data Access (SDA) | What is SDA? | SSURGO and STATSGO2 Data | When to Use SDA vs. Local SSURGO | Package Requirements | Basic SDA_query() Function | Core Syntax | Handling Errors | Understanding SDA SQL | Basic Table Joins | Understanding LEFT JOIN vs INNER JOIN | When Data are Complete: INNER JOIN | When Data May Be Missing: LEFT JOIN | Summary: When to Use Each Join Type | Aggregation Functions | Data Filters | Filtering SSURGO vs. STATSGO2 | Filtering Horizon Data | Filtering Strategy | Soil Materials | Rock Fragment Data | Basic Rock Fragment Query | Aggregating Rock Fragments by Horizon | Rock Fragment Properties via get_SDA_property() | SDA Query Limits and Strategies | SDA Query Limitations | Strategies for Large Queries | SQL Dialect Handling | T-SQL Syntax Specifics | NULL Handling | Type Casting | String Operations | Query Chunking for Large Datasets | Why "Chunking"? | Using makeChunks() | Example Chunked Property Query | Recommended Chunk Sizes | Spatial Queries | Converting sf Objects to WKT | High-level Functions | Spatial Queries: The Two-Step Pattern | SDA Spatial Helper Functions | Spatial and Tabular Property Integration | get_SDA_property(): Component and Horizon Properties | Available Properties | Method: Dominant Component (Category) | Method: Dominant Component (Numeric) | Method: Weighted Average | Method: Min/Max | Method: Dominant Condition | Method: None | Inspecting Generated Queries | get_SDA_interpretation(): Soil Interpretations | Available Interpretations | Method: Dominant Component | Understanding Output Columns | get_SDA_hydric(): Hydric Soil Classifications | Method: MAPUNIT (Default) | Method: DOMINANT COMPONENT | Method: DOMINANT CONDITION | Method: NONE | get_SDA_muaggatt(): Map Unit Aggregate Attributes | Filtering Results | get_SDA_pmgroupname(): Parent Material Groups | Simplify Parameter | get_SDA_coecoclass(): Component Ecological Classes | Method: NONE (Default) | Method: ALL | get_SDA_cosurfmorph(): Component Surface Morphometry | Available Tables | Example: 3D Geomorphic Classification | Example: Hillslope Position by Area | Example: Surface Shape | Example: Microrelief | fetchSDA(): Get Soil Profile Collection | Basic Usage | Handling Duplicates | fetchLDM(): Get Laboratory Data | Querying by Taxon Name | Advanced Usage: Specific Tables | Integration Examples: Combining Multiple Functions | Example 1: Multi-Method Property Comparison | Example 2: Properties and Interpretations for Land Use Planning | Example 3: Hydric Status and Interpretations | Example 4: Aggregating Across Multiple Areas | Example 5: Component-Level Analysis | Summary and Best Practices | Key Takeaways | Recommended Workflow | SDA Resources | Appendix: Common SDA Tables and Columns | Core Tables | Common Columns

Overview | Remote vs. Local Access | Download SSURGO Data | Create a Local SSURGO Database | Load and Explore the Database | View Table Structure | Basic Queries | Join Tables | Load Spatial Data | Visualizing Soil Properties | Load Tabular Data | Example 1: Dominant Component Percentage (comppct_r) | Example 2: Hydrologic Group (hydgrp) and Drainage Class (drainagecl) | Thematic Maps | Query and Aggregation Functions | Alternative Tools

Summary | Primary Data Sources | soilDB Functions | Functions with Questionable Future | Related Web Applications | Relevant Tutorials | SoilWeb Curated Data Sources | SC and OSD Derivatives | SSURGO Derivatives | MLRA | Geomorphic Summaries | Siblings | Other | Parent Material Summaries | Series and Taxa Extent | Web Coverage Services | Climate Data and Derivatives | Frost-Free Period | Frost-Free Days | Design Freeze Index | Growing Degree Days (C) | Effective Precipitation | Fraction of Precipitation as Rain | DEM Derivatives | Geomorphons

Overview | Prerequisites | Load SSURGO Spatial Data | Using Soil Data Access | Option 1: Use SDA_spatialQuery() to get mukey polygons for an AOI | Option 2: Use fetchSDA_spatial() | fetchSDA_spatial() geometry sources | SDA_spatialQuery() vs. fetchSDA_spatial() | Local Data Sources | Query SDA for Dominant Ecological Site Info | Extract Unique Map Unit Keys | Use get_SDA_coecoclass() | Using method="dominant component" | Using method="dominant condition" | Join Tabular and Spatial Data | Visualize the Result | Export Spatial File | References | SSURGO Data and Tools | soilDB functions | Spatial Analysis in R