United States Forest Service Logo

Summary

The USDA USFS Missoula Laboratory and Boise Spatial Streams Group RMRS labs have been working on a joint project called the Aquatic eDNAtlas (eDNA Atlas) for several years. The database represents a collaboration between two laboratories. Also, they planned to build a Geodatabase hosted in the FS VDC. It would input the sample results, query data, and export results for the Geodatabase. The core of the work involved creating the database and assisting in designing the data entry procedures and export options. The existing database table structure was used as a basis, the linkages are designed and require validation. 

Problem and Solution

To build this geodatabase, a variety of tasks needed to be performed. First, a geospatial data model needed to be built in PostgreSQL. Then, ensure that the PostgreSQL database met several requirements of the FS Geospatial Services, as well as all USDA and FS security requirements. Also, import historic geospatial data into the PostgreSQL database. Furthermore, document the database schema, data model, operations, and geodatabase implementation. This includes all logical relationships, domains, indices.

After the planning stage and undergoing access requirement validation, Xentity worked to design a database table for a database migration to VDC. We also provided data layer scope creation. Furthermore, Xentity provided an iterative database, tools, and data load development process to validate any limitations. Also, Xentity provided field linkage updates and trimming to maintain a data dictionary and schema. Finally, Xentity imported existing data from the current sample sheets to the new database. We used an Agile method to  track data loads.

Outcome and Benefit

All this resulted in a geodatabase in the FS VDC ESRI AGOL environment. Upon completion of the design for the database table, Xentity uploaded data and files to the T-Drive for storage, backup, and access. And with the data from the current sample sheets of existing data imported, the new, final database was filled with the appropriate data.