Technical Information for Soil Scientists

Technical information on this site is intended primarily for the project soil scientist mapping soils in the field.  The NASIS Excel spreadsheets listed below are designed to record and develop basic soils data in preparation for input into NASIS. Contact Steve Campbell if you have questions or to make suggestions for improvement. 

ArcGIS 8.3 for MO-1 Soil Scientists Technical References

Technical Notes - MO-1 Technical Notes in pdf format

The following documents require Adobe Acrobat or Microsoft Excel.

Pedon Thunderbook (1.1 MB) Guide for entering NASIS Pedon and Site data
 __________________________________________________________________

NASIS Entry Excel Spreadsheet - Version 7d (Updated January 23, 2008) (880 KB) 
Version 7d is identical to the previous version 7 except for a correction made to the rock fragment volume to weight conversion for horizons that contain both cobbles and stones.  It uses the MO-1 NASIS guides that were in the original 2003 version of MO-1 Technical Note 40.

NASIS Entry Excel Spreadsheet Instructions - Version 7d  (Updated January 23, 2008) (32 KB)
  __________________________________________________________________

NASIS Entry Excel Spreadsheet - Version 8c (Updated January 23, 2008) (680 KB) 
Version 8c contains updated calculations for liquid limit, plasticity index, linear extensibility percent, and available water capacity, based on extensive analyses of laboratory data for Pacific Northwest soils.  These updated calculations are included in the MO-1 NASIS Guides for these data elements in MO-1 Technical Note 40 dated August 9, 2007.

NASIS Entry Excel Spreadsheet Instructions - Version 8  (Updated August 9, 2007)  (32 KB)
______________________________________________________________

Pedon Description Form (45 KB)

Conventional and Special Symbols Legend (SOI-37A)  (4.5 MB)

NASIS Worksheets (310 KB)  This spreadsheet contains worksheets for many NASIS tables.  The worksheets are similar to those issued in the original MO-1 NASIS Thunderbook.

National Soil Survey Laboratory (NSSL) Data for the Pacific Northwest

Documents in this section require a compression utility that can read .zip files. These documents have a compression symbol at the beginning of the document name.

NSSL Data for the Pacific Northwest - this file contains a Microsoft Access database of laboratory data for all pedons sampled for NSSL  analyses in Idaho, Oregon, and Washington through March 2008 (9.9 MB).  Tables within the database contain the data dictionary.  Please contact Steve Campbell if you have any questions about using the database, or would like assistance in writing queries to extract particular data.

NSSL Lab Pedon Location Shapefile - this file contains a point shapefile in the Geographic Coordinate System (NAD83) of NSSL pedon locations in Idaho, Oregon, and Washington through March 2008 (171 KB).

Official Series Descriptions Typical Pedon Location Shapefile - this file contains a point shapefile in the Geographic Coordinate System (NAD83) of Official Series Descriptions (OSD) typical pedon locations in the areas of Idaho, Oregon, and Washington administered by MO-1 (200 KB).
 

Soil Scientist's Guide to Microsoft Access

Prepared by Paul Finnell, National Data Management Specialist

The following documents require Microsoft Word

  Table of Contents  (204 KB)

  Chapter 1 - SSURGO Template  (943 KB)

  Chapter 2 - Basic Access  (6.2 MB)
 
  Chapter 3 - Advanced Techniques  (1.8 MB)

  Chapter 4 - Pedon Access Techniques (2.4 MB)

  Chapter 5 - ArcMap and the SSURGO Template (2.0 MB)
 

Last Modified:  04/14/2008

<Back to About Pacific Northwest Soils