Transcript Customizing EQuIS to Manage Soil Vapor Intrusion Data

Customizing EQuIS to
Manage Soil Vapor
Intrusion Data
Chris Mickle
ICEDM Conference – Portland Oregon
May 14, 2013
NYS Department of Environmental Conservation
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
NYS Department of Environmental Conservation
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).
NYS Department of Environmental Conservation
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
NYS Department of Environmental Conservation
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
NYS Department of Environmental Conservation
Soil Vapor Sampling Equipment
• Flow regulator
• SUMMA Canister
• Low flow pumps for purging soil vapor
ports and tubing
NYS Department of Environmental Conservation
Soil Vapor Sampling QA/QC
• Collect field duplicates every 20 samples
• Helium Tracer Tests
NYS Department of Environmental Conservation
Sampling Area Observations
• Penetrations on floors
• Stains from chemical spills
• Chemical containing products
NYS Department of Environmental Conservation
Best Practices for Customizing
EQuIS
•
•
•
•
Review subject matter documentation
Interview system users
Review field data collection forms
Define requirements
NYS Department of Environmental Conservation
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
NYS Department of Environmental Conservation
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
NYS Department of Environmental Conservation
Database and EDD Changes
• One outdoor sample for more than one
building.
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).
NYS Department of Environmental Conservation
EDD Modifications
Before
After
NYS Department of Environmental Conservation
SVI Form Workflow
Check in EDP
Complete in field
Return paper copy
to office
E-mail NYENVDATA
Save PDF
Include in reports and
eDocs submission
Complete form in
office
NYS Department of Environmental Conservation
SVI Form Demo
NYS Department of Environmental Conservation
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
NYS Department of Environmental Conservation
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
NYS Department of Environmental Conservation
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
NYS Department of Environmental Conservation
Questions and Thank You!
NYS Department of Environmental Conservation