MO1 Technical for Soil Scientists | PNW Soils
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 Whityn Owen if you have questions or to make suggestions for improvement.
The following documents require Adobe Acrobat or Microsoft Excel.
NASIS Entry Excel Spreadsheet - Version 7d (Updated January 23, 2008) (XLS, 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) (PDF, 32 KB)
NASIS Entry Excel Spreadsheet - Version 8d (Updated November 26, 2008) (XLS, 680 KB)
Version 8d 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) (PDF, 32 KB)
Pedon Description Form (XLS, 45 KB)
Conventional and Special Symbols Legend (SOI-37A) (XLS, 4.5 MB)
NASIS Worksheets (XLS, 310 KB) This spreadsheet contains worksheets for many NASIS tables. The worksheets are similar to those issued in the original MO-1 NASIS Thunderbook.
Pedon PC Support Data for the Pacific Northwest
area.zip - (ZIP) this file contains the Geographic Areas lookup data such as soil survey areas, counties, etc.
Kellogg Soil Survey Laboratory (KSSL) and Official Series Description Data for the Pacific Northwest
Documents in this section require a compression utility that can read .zip files.
KSSL Data for the Pacific Northwest - this file contains a Microsoft Access database of laboratory data for all pedons sampled for KSSL analyses in Idaho, Oregon, and Washington through March 2008 (ZIP, 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.
KSSL Lab Pedon Location Geodatabase - this file contains a point feature class in a personal geodatabase (UTM NAD 83 Zone 11 projection) of National Soil Survey Laboratory pedon locations in Idaho, Oregon, and Washington through February 2009 (ZIP, 405 KB).
Official Series Descriptions Typical Pedon Location Geodatabase - this file contains a point feature class in a personal geodatabase (UTM NAD 83 Zone 11 projection) of Official Series Descriptions (OSD) typical pedon locations in Idaho, Oregon, and Washington through February 2009 (ZIP, 442 KB).
Last Modified: 11/19/2012