Summary

The USFS MGM program stores paleontological information in a national geospatial database for over 10 years in a GDB and ArcGIS 10.x add-in called PaleoEx. PaleoEx has 500 FS land localities mostly from R1 and R2 which is a fraction of the likely 10,000+ definable areas. Efficiencies are sources, such as server-based, within USFS GeoData Environment at the FS VDC as an SDE GDB or within EDW, bulk data load, and several over re-tooling efforts. This includes supporting several dozen museums, universities and external agencies with similar Paloe mandata requirements (e.g. DOI Bureaus at BLM, BOR, FWS, NPS, etc.) requiring legacy upload integration with sources including spreadsheets, shapefiles, and data tables from specific software (e. g. Specify). Ultimately, data (non-IT) workflow efficiencies will allow for improved sharing, and lower data entry burdensome tasks. This could include new Field Collections, bulk upload, accessibility tools, improved documentation and training, data converters, etc.

Problem and Solution

Efficiencies are sources, such as server-based, within USFS GeoData Environment at the FS VDC as an SDE GDB or within EDW, bulk data load, and several over re-tooling efforts. This includes supporting several dozen museums, universities and external agencies with similar Paleo mandate requirements (e.g. DOI Bureaus at BLM, BOR, FWS, NPS, etc.) requiring legacy upload integration with sources including spreadsheets, shapefiles, and data tables from specific software (e. g. Specify). Ultimately, data (non-IT) workflow efficiencies must allow for improved sharing, and lower data entry burdensome tasks. This could include new Field Collections, bulk upload, accessibility tools, improved documentation and training, data converters, etc.

Xentity worked with the CIO to make PaleoEx function in the USFS corporate geospatial data environment. Also, they ensured PaleoEx functions within ESRI’s ArcGIS Pro 3.2+. Furthermore, they made PaleoEx accessible for data entry to non-federal partners (permit holders) through ArcGIS Online (AGOL) tools and data services. Afterwards, Xentity created functionality to bulk crosswalk/upload legacy data from non-federal partners and online sources. Then, they retooled the GPS data uploader to be functional with an array of mobile smart devices and applications.

Next, Xentity incorporated the BLM PFYC (Potential Fossil Yield Classification) layer into baseline geopolitical layers and reporting. Also, Xentity trimmed many unnecessary data fields and refocus tool functionality. Afterwards, they created updated documentation for workflow and tools (how to guide). Then, Xentity provided training for MGM Paleontology Program Staff to implement revised databases and associated processes. Finally, Xentity provided Operational and Maintenance Support of the Database and Processes. To add, crosswalk and upload legacy information from numerous partners, was provided by MGM staff.

Outcome and Benefit

PaleoEx was functionable within the USFS’s corporate geospatial data environment. Also, it could indeed function within ArcGIS Pro’s 3.2 version and onwards. Non-Federal partners could access PaleoEx for data entry. Also, the GPS data uploader was functional with an array of smart devices and apps. Furthermore, all unnecessary data fields were trimmed. Finally, the revised database and associated processes were implemented.