190 likes | 415 Views
Customizing EQuIS to Manage Soil Vapor Intrusion Data Chris Mickle ICEDM Conference – Portland Oregon May 14, 2013. Topics. Introduction to Soil Vapor Intrusion Best Practices for Customizing EQuIS Database and EDD Changes SVI Data Workflow SVI Data Collection Form Demo
E N D
Customizing EQuIS to Manage Soil Vapor Intrusion Data Chris Mickle ICEDM Conference – Portland Oregon May 14, 2013
Topics • Introduction to Soil Vapor Intrusion • Best Practices for Customizing EQuIS • Database and EDD Changes • SVI Data Workflow • SVI Data Collection Form Demo • Documentation and Acknowledgements
Introduction to Soil Vapor Intrusion Data New York State Department of Health (NYSDOH) - Center for Environmental Health, Bureau of Environmental Exposure Investigation. "Guidance for Evaluating Soil Vapor Intrusion in the State of New York" (NYSDOH – October 2006).
Soil Vapor Port Installation Geoprobe drilling Insert Teflon-lined tubing Fill borehole with at least six inches of sand surrounding the vapor sampling implant Seal remaining depth of the borehole with Bentonite The Bentonite seal must set for at least 24 hours before soil gas sampling can occur
Soil Vapor Port Installation Permanent Soil Gas Ports Well mount and swage lock Temporary Soil Gas Ports Excess tubing is plugged Sub slab vapor port installations
Soil Vapor Sampling Equipment Flow regulator SUMMA Canister Low flow pumps for purging soil vapor ports and tubing
Soil Vapor Sampling QA/QC Collect field duplicates every 20 samples Helium Tracer Tests
Sampling Area Observations Penetrations on floors Stains from chemical spills Chemical containing products
Best Practices for Customizing EQuIS Review subject matter documentation Interview system users Review field data collection forms Define requirements
Best Practices for Customizing EQuIS Use staff knowledgeable in the EQuIS database schema Prepare entity relationship diagrams and object models to reflect current and proposed database structure Work with EarthSoft to implement database changes
Database and EDD Changes New tables replaced existing building and task parameter tables to meet these needs Buildings can have multiple inspections on different dates Parameter codes are associated with buildings (subfacilities) Subfacilities can contain many buildings An outdoor sample can be assigned to multiple buildings
Database and EDD Changes New York State Department of Health (NYSDOH) - Center for Environmental Health, Bureau of Environmental Exposure Investigation. "Guidance for Evaluating Soil Vapor Intrusion in the State of New York" (NYSDOH – October 2006). One outdoor sample for more than one building.
EDD Modifications After Before
SVI Form Workflow Check in EDP Complete in field Return paper copy to office E-mail NYENVDATA Include in reports and eDocs submission Save PDF Complete form in office
Documentation NYSDEC Soil Vapor Intrusion Guidance: http://www.dec.ny.gov/regulations/2588.html NYSDOH Soil Vapor Intrusion Guidance: http://www.health.ny.gov/environmental/indoors/vapor_intrusion/ NYSDEC EDD Manual and SVI Form: http://www.dec.ny.gov/chemical/62440.html
Acknowledgements NYSDEC Elaine Zuk – New York State Information Technology Services (ITS) Chief Environmental Information Management Section Lead Andrea Greco – ITS Project Manager and Chair of EQuIS Steering Committee Gerard Burke – Division of Environmental Remediation (DER) Bureau E, Section A Leader Daniel Eaton – DER Project Manager for Environmental Information Management System (EIMS) EQuIS Implementation Project Heidi Dudek – Former DER Project Manager for (EIMS) EQuIS Implementation Project Eric Hausamann – DER Project Manager – Soil Vapor Intrusion
Acknowledgements EarthSoft Janet Magurn – President of EarthSoft Kristin Garboski – NYSDEC Client Service Manager Mat Weaver – EarthSoft Chief Technical Officer and Principal Developer and Database Architect The CDM Smith Environmental Data Management Group and Soil Vapor Intrusion Project Team