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.
A RECORDING OF THIS MEETING IS AVAILABLE: RECORDING
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.
Short and Long Term Team Planning J. Hammerly
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
SQL 2016 Advanced Analytics Extensions J. Hammerly
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
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.
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
Introductions / Roll Call J. Hammerly
Sub Team Reports Team
Mobile Data Collection
- 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.
- 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.
- 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.
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
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