Projects often involve translating and merging client’s legacy data into modern data storage environments or extracting, transforming, and loading (ETL) data from our custom field collection apps to a final database for reporting or integration into a client’s existing system. We do this through platforms like project-tailored and cloud-based databases, Access, MySQL, PostGres, SharePoint, and other formats, using tools such as R or Python for higher-level data manipulation and analysis.
Beyond traditional geospatial databases, AECOM’s cultural resource teams are involved in the creation and management of large research and collections datasets, as well as project tracking databases for field-intensive projects, such as gas and oil pipelines.
With the explosion of data-centric projects and increasing legislation around high-quality and digital deliverables, we lead the industry with 15+ years of experience.
Database Design
Project Lifetime Data Management
Digital Client Deliverables
Workflow Automation
Big Data Management
Data Accuracy & Reliability
Custom Coding & Queries (SQL, R, Python)
Legacy Data Translation
Data Pipelines/ETL
Cloud-Based Storage Solutions
Elisabeth LaVigne, RPA
Senior Geoarchaeologist
liz.lavigne@aecom.com
267.559.6220
609.331.1703