Abstract

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.