PROTECT: Puerto Rico Testsite for Exploring Contamination Threats

www.neu.edu/protect

Environmental data mining, analysis & management, and integration into GIS and groundwater modelingC. Butscher, C. Yegen, R. Ghasemizadeh, C. Irizarry, J. Howard, I. Padilla, D. Kaeli, A. Alshawabkeh

This program is supported by Award Number P42ES017198 from the National Institute of Environmental Health Sciences.

}

From data mining to analysis

Data mining• Field collection• Literature research & data bases• Lab analysis

Data dictionary• Data entry in unified format

Data repository• Data cleaning• Data upload• Data storage

Web interface• Queries• Download/Export

Analysis• GIS• Groundwater modeling• Statistics

Centralized repository for effective data sharing between all program projects to support environmental data analysis.Scope:• Unified system for data entry, cleaning and management across the

PROTECT program (environmental & biomedical data)• Allows multi-layered data management inquiries• Provides all data via the Internet• Supports contamination transport modeling and GIS analysesEnvironmental data:• Historical data: groundwater data from approx. 1000 wells and springs,

include water levels & contaminant concentrations• Newly collected field data: 10 wells, 2 springs and 120 water taps. Two

samples per year are analyzed for water quality data (e.g., pH, dissolved oxygen, common ions), CVOCs and phthalates

• NPL superfund sites (21) and RCRA corrective action sites (49)• Continuous records of meteorological, surface water and groundwater

data

Live data in online repository (status):• 865 wells• 34 springs• 124 environmental

samples

Poster presented at the retreat of the PROTECT program in Dorado (PR),Feb. 24-25, 2012

Data structure: Tables and relations of environmental data within the PROTECT online data repository.

Application: Groundwater models and GIS analyses rely on effective access to collected and cleaned environmental data.

The PROTECT online data repository collects environmental data from the field campaigns and lab analyses of the program, as well as historical data provided in reports and data bases by different agencies. Collected data are shared across the PROTECT program via the Internet and are a basic resource for statistical analysis, GIS analysis and groundwater modeling. The PROTECT online data repository also collects biomedical data (e.g., urine, blood, pregnancy tissues, demographic data), which is not shown here.