1 / 29

Exploring your geospatial data

Exploring your geospatial data. It’s all about Relationships!. Download the SSURGO Template for your MMA. Two Important Points!. This is Not DIFFICULT! The technology is not NEW! What is new is our ability to look at these enormous databases in totally new ways.

wilmer
Download Presentation

Exploring your geospatial data

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. Exploring your geospatial data

  2. It’s all about Relationships!

  3. Download the SSURGO Template for your MMA

  4. Two Important Points! • This is Not DIFFICULT! • The technology is not NEW! • What is new is our • ability to look at these • enormous databases • in totally new ways.

  5. Identifying slope inconsistencies in terrace soils Construct a Make Table query in Access using the cogeomordesc, component, and mapunit tables Make MUKEY the first column in the output table

  6. Output Access table In ArcMap, join to the SSURGO attribute table using the MUKEY field

  7. Select for all polygons that are terraces Export the polygons to a feature class called terrace_soils

  8. Open the SSURGO attribute table, and add a long integer field called objid Double click on OBJECTID field to calculate objid = [OBJECTID]

  9. Choose Zonal Statistics from the Spatial Analyst dropdown • The Zone dataset will be terrace_soils • The Zone field will be objid • The Value raster will be the slope grid • Check the box to Join output table to zone layer • Save the output table if you want • Click OK

  10. X the chart out • Look the table over, then close or minimize it

  11. Using mukey for the Zone field aggregates statistics by the mukey

  12. Construct a SQL query to select polygons in which the representative slope value is more than 2 standard deviations greater or less than the mean slope within the polygon

  13. Scale 1:35,114

  14. Yeah! Then you relate it to the component table, using the cokey field! So, you start with the cogeomordesc table here, see. Then the mukey ties it all together!

  15. Series extent, distribution and overlap Join the SSURGO template mapunit table to the SSURGO attribute table using the MUKEY field

  16. Select polygons LIKE ‘%Craig%’ The % sign is Arc’s wild card to match any characters that come before or after the character string ‘Craig’

  17. Export the selected set to its own feature class

  18. Tabulated areas are the number of 30 meter grid cells in each MMA. This table can be exported to .dbf, imported into Access or Excel, and acreages can be calculated.

  19. Find SSURGO mapunits with lacustrine parent materials Make MUKEY the first column in the output table

  20. New Age – New Toys (Tools) “You young pups with all your fancy play toys and whatnot…. “Back when I was a pup, all we had to play with was an old cat’s head”

  21. Any questions?

  22. Suggestions • Use the help screens in Arc • Use relationships for all kinds of queries • Use all the tools available—Access, ArcGIS, ArcCatalog, Excel • Step away from the machine • Resources: • Access user guides at http://soils.usda.gov/technical/access/

More Related