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
Contact Whityn Owen if you
have questions or to make suggestions for improvement.
The following documents require Adobe
Acrobat or Microsoft
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.
Entry Excel Spreadsheet Instructions
- Version 7d (Updated January 23, 2008) (PDF, 32 KB)
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
Technical Note 40 dated August 9, 2007.
Entry Excel Spreadsheet Instructions - Version 8 (Updated
August 9, 2007) (PDF, 32 KB)
Description Form (XLS, 45 KB)
and Special Symbols Legend (SOI-37A) (XLS, 4.5 MB)
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.
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.
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.
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).
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).
<Back to Pacific Northwest Soils Home