MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset="utf-8"

This page is automatically updated from the Wiki in Microsoft Teams - any changes made here will be overwritten. To edit this page, open it in Microsoft Teams.

Meeting Minutes

2020-12-22 Minutes


Delivery of gridded data + SDA                                                J. Hammerly

Dylan Beaudette has developed a method for obtaining soils information via a web coverage service (WCS)

Global soil map updates                                                           S. Roecker

SPSD systems diagram cleanup                                               J. Hammerly

A new revised diagram might be useful - input from others appreciated:


Connecting to national databases in RStudio                               J. Hammerly

A demo of making a connection to the production national databases in RStudio. Still investigating ways to extract spatial data.

Basic Instructions

2020-10-27 Minutes

Short and Long Term Team Planning                              J. Hammerly
Focus Team Presentation to Leadership
Open Source Data Users                                                   S. Peaslee
Exploring SQLite as a replacement for delivery of soils data may be viable. Anyone with experience using SQLite, which can provide input on its use are encouraged to share with the group and discuss any advantages or disadvantages.
Lab Data Mart                                                                  J. Nemecek, D. Beaudette, A. Diaz
NSSC Updates                                                               K. Stephens

2020-09-22 Minutes

SQL 2016 Advanced Analytics Extensions                                J. Hammerly

This is a feature which can be enabled during the install process and has different names depending on the SQL version. For 2016 it’s called “R Services”.

Some of the documentation here: https://docs.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-2016?view=sql-server-2016#deciding-among--components

Further explanation here: https://docs.microsoft.com/en-us/sql/machine-learning/r/sql-server-r-services?view=sql-server-2016

Specifics on installation here: https://docs.microsoft.com/en-us/sql/machine-learning/install/sql-r-services-windows-install?view=sql-server-2016

It should be explored as something we could test and potentially implement in the future. Some benefits to having the feature, if enabled, would be that it could make some of the NASIS calculations much more simple to write, and could make new calculations achievable, not possible previously.
Database snapshots and backups                                            J. Hammerly
NASIS currently lacks a simple method for local backup or snapshot of data. Adding this feature could enable easier recovery of data due to deletion or modification errors, and could allow generation of new reports on historical data via a snapshot.
Shiny EcoSite Report                                                                J. Hammerly
The report can be viewed here: https://usda.shinyapps.io/eco_report/
This app replicates some of the functionality of the old ES reports available in WSS which were recently removed the uploaded shapefile is processed on shinyapps servers so be aware of PII if using.

2020-08-25 Minutes

Database Focus Team Updates                                                J. Hammerly

Proposed OSD Object in NASIS: Pedon copy vs. links                    D. Beaudette

New soilDB Functions for gNATSGO/gSSURGO                  S. Roecker

2020-07-28 Minutes

Introductions / Roll Call                                                              J. Hammerly

Sub Team Reports                                                                       Team

Mobile Data Collection

  1. Have the Database Team petition the Division to back fill Henry Ferguson’s old position. Henry helped get data into NASIS from various sources (internal and external) as well as helped to clean up data that is currently in NASIS.
  2. Have the Database Team petition the Regional Directors to agree to identify one person from each region to be trained on how to upload pedon data from various Apps outside of NASIS (Apps like collector, Survey123, pedon pc, excel workbooks, etc). There are several options that regions across the division are using for mobile data collection tools. When it comes time to get this data up to NASIS, there are only a few folks that know how to format the data and get it into NASIS (through excel workbooks). This is a bottle neck! No mobile data collection tool will streamline the data collection and entry process until we have folks trained on how to get that data into NASIS. (Kevin Godsey is the POC for this process and train the trainer possibility.
  3. Have the Database Team petition the division to hire or train someone to assist George Teachman with the workload of how to address and handle new data fields (old or obsolete data fields, new data collection requirements, etc. in the NASIS database structure). Currently, George Teachman handles this and he is retiring in December 2020. If data is to continue to upload to NASIS from other means (Excel, Pedon PC, Survey123, etc.), the data will have to be compatible with the NASIS table structures (each external data column, row, cell will have to be cross-referenced with where it’s going in NASIS). The Database Team could possibly help with this workload, but that sounds inefficient as everyone is stretched pretty thin these days.

EDIT Database

SSURGO Refresh


gNATSGO and gSSURGO were recently released in spring of 2020
update of these products with the July 2020 data refresh may not happen, and instead may occur at the next July 2021 release 

Worksheet Upload

SSD Tools Organization


Useful links for laboratory data




Links from Dylan




Links to lab databases and documentation


DMU Data Population Standards

Work continues on data integrity reports in NASIS. Progress on can be viewed within NASIS.

National Updates                                                                        K. Stephens

FPAC NASIS Modernization -- SAFe (Scaled Agile Framework) based structure, will be working closely with developers on this process
ESIS, EDIT to NASIS, and EDIT to WSS -- testing functionality to ensure proper operation

Vegetation Data in NASIS                                                          J. Hammerly