1 / 15

Putting SSURGO to work

2005 Users Conference. Putting SSURGO to work. Developing meaningful Soil Data with ArcGIS & Microsoft Access. Understanding the SSURGO Database. Structure of the SSURGO Database. Simple Joins & Relates in ArcGIS. Developing Queries in Access.

gil
Download Presentation

Putting SSURGO to work

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. 2005 Users Conference Putting SSURGO to work Developing meaningful Soil Data with ArcGIS & Microsoft Access

  2. Understanding the SSURGO Database Structure of the SSURGO Database Simple Joins & Relates in ArcGIS Developing Queries in Access The New Soil Data Viewer

  3. The SSURGO Database • Access Database 1997- 2002 • Template with Customized Tables, Queries, Reports & Forms • Soil Property Data • Soil Interpretive Reports Generated from Property Data • Product of the National Soil Information System (NASIS)

  4. Database Structure Series of Related Tables Related by Columns in Table legend Legend Key mapunit mu#### Mapunit Key component co#### Component Key chorizon ch#### Chorizon Key chtexturegrp Chorizon Texture Group Key chtexture Chorizon Texture Key chtexturemod

  5. Database Structure

  6. Simple Joins & Relates in ArcGIS Adding Mapunit Attributes to Soil Polygon Shapefile Start: SSURGO Download with Completed Database Imported & Empty Personal Geodatabase • Add soil polygons (soil_nd###\spatial\soilmu_a_nd###.shp) to an Arc Map Session • Add mapunit aggregate attributes table (soil_nd###\tabular\soil_d_nd###.mdb\mapunit) • Right-click on soilmu_a_nd###.shp  Joins and Relates  Join 1. Join will be based on MUKEY 2. Table to join to muaggatt 3. Field to base the join on mukey. Click OK • Right-click on soilmu_a_nd###.shp  Open Attribute Table • Several Columns to represent Soil Properties (To Understand See SSURGO Metadata Table Columns Report & Description in .mdb) • Right-click on soilmu_a_nd###.shp  Data  Export Data • Export: All Features  PGsoil_nd###.mdb ( a geodatabase previously created) End: Personal Geodatabase Feature Class with Soil Polygons and Aggregated Mapunit Attributes (Some Basic Property & Interpretive Values) DEMO

  7. Simple Joins & Relates in ArcGIS Relating Component & Horizon Data to Soils Polygons Start: SSURGO Download, Soil Polygons in Personal Geodatabase Feature Class • In ArcCatalog navigate to the tables within the Access Database (soil_nd###\tabular\soil_d_nd###.mdb). Highlight both files. Right Click  Copy • Find PGsoil_nd###.mdbin ArcCatalog. Right Click  Paste • In ArcMap add your soil polygon feature class and tables from your personal geodatabase • Right-click on soilmu_a_nd###.shp  Joins and Relates  Relate 1. Relate will be based on MUKEY 2. Table to relate to component 3. Field to base the relate on mukey. Name relate mu to comp. Click OK • Right-click on component table  Joins and Relates  Relate 1. Relate will be based on COKEY 2. Table to relate to component 3. Field to base the relate on cokey. Name relate comp to chorizon. Click OK End: Two one-to-many relates relating Soil Polygons to Component Table to Horizon (chorizon) Table More

  8. Simple Joins & Relates in ArcGIS Querying for Soils Properties & Relating to Polygons Task: Find areas of high alkalinity in the rooting zone. Query for Soil Mapunits where a major component has a pH of greater than to 8.0 in the top 40 cm. • In ArcMap open chorizon table. Options  Select by Attributes  Create New Selection WHERE [hzdept_r] <= 40 AND [ph1to1h2o_h] >= 8.5 • Options  Related Tables  comp to chorizon • In component table. Options  Select by Attributes  Select from Current Selection WHERE [majorcompflag] = “Yes” • Options  Related Tables  mu to comp • Soil Polygons Meeting this criteria will now be selected • Right Click on soil_mu_a_nd###  Data  Export Data  Selected Features  PGsoil_nd###.mdb Result: Personal Geodatabase Feature Class indicating soils where high alkalinity may occur regularly DEMO

  9. mukey ascending comppct_r descending Datasheet View = highest percent composition in mapunit Query Can be Exported into DBIV file and joined with Shapefile or Personal Geodatabase Creating Custom Tables in Access Querying for Datasets of Interest Query Component Table to ensure Components are in correct order Using Highest Percent Composition for Mapunit Level Component Data Design View

  10. organic matter hzdept_r = 0 for surface 0 centimeters deep pH highest percent composition in mapunit Datasheet View Query Can be also be exported into DBIV Creating Custom Tables in Access Querying for Datasets of Interest Query Specific Soil Properties that occur at or near the soil surface Design View Design View

  11. October 17, 2005 – NRCS releases Soil Data Viewer 5.0 • Aggregation of Soil Property Data • Aggregation of Property Data into Interpretive Values • Analyze Data • Create Thematic Maps

  12. For use with ArcGIS 8.3-9.0 (9.1 TBA) or standalone • Compute a single value for a map unit and display results, • No need to query the database and join to the spatial data. • Basic Mode - Interpretations Only (eg. Paths, Trails & Golf Fairways) • Advanced Mode - Interpretations & Properties (Cation Exchange Capacity, Salinity)

  13. Steps required to use Soil Data Viewer • Go to http:\\soildataviewer.nrcs.usda.gov and download Soil Data Viewer • Complete a new SSURGO download (v. 32 Access Database) • Follow steps to extract tabular data into access database • Add a soil polygon shapefile into ArcMap session (no coverages or geodatabases) • Tools  Customize  Toolbars: Check On - Soil Data Viewer • Click SDV Button in ArcMap • Returns Temporary Shapefiles

  14. Basic Mode - Default Aggregation Minimal Criteria Set Advanced Mode Define Aggregation As Many as 15 Categories 56 Interpretive Classes

  15. SDV Demonstration Questions, Comments, Assistance & Ideas Contact: USDA-NRCS North Dakota Soils Staff (701) 530-2017

More Related