Automated Environmental Data Management with ArcGIS and SQL Server
Track: Environmental Management
Authors: Ramon Gallegos, Steve Shaffer
EEC Environmental uses a mix of ArcGIS, SQL Server, and Microsoft Access to automate the import, analysis, QA/QC, and reporting of environmental sampling data for multiple soil and groundwater remediation sites throughout the United States. The solution they’ve developed enables data to get from the lab to figures and tables with no manual processes by leveraging a centralized database and consistent data structure and automating processes with Python, ArcGIS ModelBuilder, and SQL scripts.