Soil Survey Laboratory Data Webinar Steve Monteith Rick Nesser Steve Baird Henry Ferguson Please do not put your phone on hold for ANY reason during the teleconference Unless you intend to talk to all of us use 6 or the mute button during the teleconference ID: 736856
Download Presentation The PPT/PDF document "National Soil Survey Center" is the property of its rightful owner. Permission is granted to download and print the materials on this web site for personal, non-commercial use only, and to display it on your personal computer provided you do not modify the materials and that you retain all copyright notices contained in the materials. By downloading content from our website, you accept the terms of this agreement.
Slide1
National Soil Survey CenterSoil Survey Laboratory Data Webinar
Steve MonteithRick NesserSteve BairdHenry Ferguson
Please do not put your phone on hold for ANY reason during the teleconference. Unless you intend to talk to all of us, use *6 or the mute button during the teleconference.
January 12, 2012
1-212-287-1661
Passcode
CFISK
Slide2
Today’s Webinar will address three aspects of SSL data :
Data associated with sample submissionData produced by sample analysisStorage, maintenance and distribution of existing data. Slide3
Soil Survey Lab Data Creation, Maintenance, and Retrieval
There are data from over 49,000 samples in the NCSS database. Without complete and accurate descriptive data (metadata), the analytical data cannot be utilized.
There is an increased demand for data from internal users and from new classes of external users.Metadata elements in the NCSS database are in need of update. This will require input from local soil scientists who have the specific knowledge and skills to do this.New lab data is expensive and time consuming to acquire, but is essential to soil survey projects at whatever the cost. The expense necessitates complete and accurate sample documentation.Slide4
Data associated with Soil Samples
LIMS - Laboratory Information Management It manages:Metadata submitted with samples describes Project, Site, Pedon
, Layer, SamplesAnalytical data created in the SSLOutput of Lab Data with associated metadata: Characterization data, Web site queries, CDsSlide5
Part 1: Information Needed for Soil Sample Submission and Processing
A spreadsheet and checklist for submitting samples will be available on soils technical references web page:http://soils.usda.gov/technical/Slide6
Organization of Metadata in LIMS
Project (associated with all pedons and samples submitted)Site (geographically associated with samples)
Pedon - Description (from NASIS, not Pedon PC)Layer - Sampling zone, usually a horizon. There can be more than one layer per horizon. Sample - Represents a layer. There can be multiple samples from a layer.Slide7Slide8
Project Level Information
Submitter’s (your) contact informationSSL Liaison or project coordinatorContacts to receive lab data and correspondenceProject description: Objective, parent material, setting, topography… (Will be used in selecting needed analyses.)
Date when data is neededList of samples including sample types, horizon nomenclature and depths, fragment content. (SSL Sample Submission Worksheet)Analyses requested for each sampleSlide9Slide10
Site Information
Location: lat – long in degrees, minutes, seconds if possible. Include datum.Area overlap tables - MLRA, soil survey area code, state, countyThis information must be in your NASIS pedon
description.Slide11
Pedon Information
Hard copies of pedon descriptions from NASIS pedon report. (Sample log-in area at SSL does not have NASIS)
Control section upper and lower depth.Series name and / or taxonomic class. Pedon and site naming convention: (from Field Book for Describing and Sampling Soils ver 2.0):Slide12Slide13
User Pedon and User Site ID
Example: S2004WA027009S = Indicates sampled
pedon.2004 = Calendar year sampled. Use four digit format.WA = Two-character (alphabetic) Federal Information Processing Standards (FIPS) code for state where sampled. For non-US samples, use FN. 027 = Three-digit (numeric) FIPS code for county where sampled. It is important that this be the actual county (not the soil survey area) where the samples are taken to ensure compliance with APHIS regulations.
009 = Consecutive
pedon
number for calendar year for county. This should be a three digit number.
A one-character ‘satellite’ code can be used if needed, e.g. S2004WA027009A
Do not use spaces, dashes or hyphens. Use 0 place holders when necessary . Use upper case letters.
Use the same ID for the User
Pedon
ID and User Site ID if possible.
A spreadsheet for submitting samples is available at
http://soils.usda.gov/technical/Slide14Slide15Slide16Slide17Slide18
Pedon / Site information
Include an accurate list of NASIS User Pedon IDs and record IDs for all pedons in the project. The SSL will find these and make a copy of each
pedon and assign that pedon to the “Pedons” group owned by the SSL. In the future, output of lab data will be associated with your NASIS pedon / site information. You will make any needed edits directly to your NASIS pedon. This will replace the SOI-8 process.Slide19
Sample Information
Labels: Soil name Horizon
Pedon number Depth Field (sequence of sampled sampled layers in project)Slide20Slide21
Project Life CycleSlide22
Sample ReceptionSlide23
Sample DetailSlide24
Analysis SelectionSlide25
Sample PreparationSlide26
Analysis SchedulingSlide27
AA 400 (Dithionate Citrate)Slide28
Vertex 70 (Mid-Range Infrared)Slide29Slide30Slide31Slide32Slide33Slide34Slide35Slide36Slide37Slide38Slide39Slide40Slide41Slide42Slide43Slide44Slide45Slide46Slide47Slide48Slide49Slide50Slide51Slide52Slide53
Site Excel Download
Pedon Excel DownloadSlide54Slide55
Questions !!Slide56
Vision for Laboratory Data DistributionSlide57
MLRA SSO Owned
NASIS Pedon ContainingCorrelated Classification
SiteTaxonomic HistoryPedonLayer
NASIS Site
Diagram of the Vision
Laboratory Data in the Data Sheet
Horizon
Classification
Sampled As Pedon
MLRA SSO - Owned
SSL- Owned
Pedon
Description
Depths
Taxonomic History Table
Soil 8Slide58
MLRA SSO Owned
NASIS Pedon ContainingCorrelated Classification
MLRA SSO OwnedNASIS SiteDiagram of the Vision
Narrative/or Tabular
Pedon
Description
DistributedSlide59
MLRA SSO Owned
NASIS Pedon ContainingCorrelated Classification
SSL and MLRA SSO Pedons must be Associated/Linked to one another
Laboratory Data in the Data Sheet
SSL Owned
Sampled As Pedon
Laboratory Sample Number creates the linkSlide60
MLRA SSO Owned Pedons Must be Identified
Populate the Lab
Pedon # in NASISSlide61
MLRA SSO Owned
NASIS Pedon ContainingCorrelated Classification
NASIS SiteUse of a Common Site
Sampled As Pedon
Taxonomic History Table
SSL Owned
MLRA SSO Owned
MLRA SSO OwnedSlide62
Site
NASIS Site
A Single Location (WGS84 STD Decimal Degrees)
Laboratory Data in the Data Sheet
Location
MLRA SSO - Owned
Pedon
Description
Soil 8
SSL- Owned
Location
LocationSlide63
MLRA SSO Owned
NASIS Pedon ContainingCorrelated Classification
Taxonomic History
The Latest Classification Available
Laboratory Data in the Data Sheet
Classification
MLRA SSO - Owned
Pedon
Description
Taxonomic History Table
NASIS 6.2
Soil 8
Classification
ClassificationSlide64
MLRA SSO Owned
NASIS Pedon ContainingCorrelated Classification
Layer
Horizon Designations from MLRA SSO Pedon
Laboratory Data in the Data Sheet
SSL Owned
Sampled As Pedon
MLRA SSO - Owned
Pedon
Description
Horizon
DepthsSlide65
How do We Realize the Vision
Populate the Lab Sample # in the
Pedon Horizon Sample TableSlide66Slide67
Distribution ProductsSlide68
NSSC Pangea ReportsSlide69
Pedon PC Plus is Another Great ToolSlide70
MLRA04_Office ReportsSlide71
Laboratory Data by MLRA Office
https://nrcs.sc.egov.usda.gov/ssra/nssc/ssl/Shared%20Documents/Forms/AllItems.aspxSlide72
A Complete Copy of the National Database is Available
It is 144 MB zipped or about 415 MB unzipped. It must be requested.Contact: NCSSLabData@lin.usda.govSlide73
NCSS Soil Characterization Web SiteSlide74
Documentation for Use of the Products
NSSC Soil Correlation Course.Slide75
Job Aids PageSlide76
Ask NSSC or your local MO for AssistanceSlide77
Questions?Slide78
MLRA SSO Owned
NASIS Pedon ContainingCorrelated Classification
SiteTaxonomic HistoryPedonLayer
NASIS Site
Diagram of the Vision
Laboratory Data in the Data Sheet
Horizon
Classification
Sampled As Pedon
MLRA SSO - Owned
SSL- Owned
Pedon
Description
Depths
Taxonomic History Table
Soil 8