SRP Naphthalene COMPASS GW Site Summary in New Jersey
收藏资源简介:
This GIS layer is based on a SQL query of the groundwater HAZSITE data that resides in COMPASS for each active Site Remediation case. Once the raw groundwater HAZSITE data is extracted from COMPASS, it is summarized such that a maximum concentration for the contaminant is derived for the year preceeding the last sampling event (samp_last_max_conc) and a maximum concentration is also generated for all sampling events (all_max_conc) . Each active Site Remediation case is included in the GIS layer. The GIS layer symbology is based on the the maximum concentration for the year preceeding the last sampling event for that contaminant as summarized in the evaluation field and further categorized in the s_value field. Symbology is represented as follows: no data submitted, not sampled, non-detect (ND), detected below standard, reporting limit > standard, 1 - 10 times the standard, 10 - 100 times the standard, 100 - 1000 times the standard and greater than 1000 times the standard. The standard is the NJDEP Ground Water Quality Standard and/or MCL for this contaminant. For the HAZSITE data, there are a number of considerations that need to be taken into account when using this GIS layer for decision making purposes:- Not all SRP cases have provided HAZSITE data to the Department or HAZSITE data that has been provided to the Department may be incomplete;- Additional sampling may have been conducted since the last round of HAZSITE data was submitted that has not yet been provided as HAZSITE data is only required with key document submittals;- HAZSITE data that was submitted may not have been provided in the correct format and therefore could not be uploaded into the COMPASS data repository and would therefore not be returned via the COMPASS SQL query.
本地理信息系统(GIS)图层基于针对存储于COMPASS系统内的地下水HAZSITE数据所执行的结构化查询语言(SQL)查询,覆盖所有活跃场地修复案例。从COMPASS系统中提取原始地下水HAZSITE数据后,将对其进行汇总处理:分别推导得到上次采样事件前一年的污染物最大浓度(samp_last_max_conc),以及所有采样事件中的污染物最大浓度(all_max_conc)。所有活跃场地修复案例均已纳入该GIS图层。该GIS图层的符号系统依据评估字段(evaluation field)中汇总的对应污染物上次采样事件前一年的最大浓度,并通过s_value字段完成进一步分类。符号系统具体划分如下:未提交数据、未采样、未检出(ND)、低于标准检出、报告限值大于标准、标准1~10倍、标准10~100倍、标准100~1000倍以及大于标准1000倍。此处所指标准为该污染物的新泽西州环境保护部(NJDEP)地下水水质标准及/或最大污染物水平(Maximum Contaminant Level, MCL)。在将该GIS图层用于决策制定时,需注意以下多项HAZSITE数据相关事项:其一,并非所有场地修复项目(Site Remediation Program, SRP)案例均已向主管部门提交HAZSITE数据,且已提交的数据可能存在不完整情况;其二,自上一轮HAZSITE数据提交以来,可能已开展额外采样工作,但此类数据尚未提交——因HAZSITE数据仅需随关键文件提交时一并提供;其三,已提交的HAZSITE数据可能未采用正确格式,因此无法上传至COMPASS数据仓库,进而无法通过COMPASS的SQL查询获取。



