Drinking Water Program

OELA Spring Workshop

May 15, 2009

Oregon Public Water Systems

3,620 total public water systems

882

346

1471

921

Community (cities, mobilehome parks)

Semi-residential (schools,employers), nontransientnoncommunity

Transient (campgrounds,parks, restaurants, motels)

Very small systems (4-14connections, 10-24 people),ORS 448

91 Regulated Drinking Water Contaminants (2009)

• 7 Microbials (bacteria, viruses, parasites)• 7 Disinfection by-products (trihalomethanes,

haloacetic acids)• 16 Inorganic chemicals (arsenic, nitrate,

lead)• 56 Organic chemicals (solvents, pesticides)• 5 Radiologic contaminants (uranium)

2008 Water Quality Results to DWP: 102,982 total

VOS/SOC/IOC 37,895

Coliform 62,953

DBPs1641

Radionuclides140

Lead and Copper353

102,982

Electronic Reporting

Which results? • Coliform• SOCs, VOCs, IOCs (including Arsenic and Nitrate)

How? • Terminal server

– Rapid data entry screens

• Computer generated file (ASCII*)– Also known as Comma Separated Value (CSV) files

*American Standard Code for Information Interchange

Benefits of Electronic Reporting•Improved tracking of samples/batches

•Faster incorporation of water quality data into SDWIS (Safe Drinking Water Information System)

•Labs have more control of data

•Data Integrity (verification processes built in)

ASCII Process (computer generated file)

Drinking WaterSample Perform Analysis

Submit batch to DWP (text file)

DWP “gatekeeper” verifies dataDWP imports data

Data incorporated into SDWIS

Lab’s LIMS outputs DWP Data

Data Requirements for Water System Compliance: VOC/IOC/SOC

DWP Requirements Example

PWS ID 4100731

Collection Date 05/01/2009

Sample ID 12345

WSF (water system facility) EP-C

Sample Point 1

ORELAP ID* OR100014

Results ND

Analysis Method 4500NO3-D

Reporting Limit (LOQ) 0.1

Analyte code 1040

Unit (mg/L) mg/L

MRL or MDL MRL

*ORELAP ID of lab performing analysis

All NELAC requirements need to be followed

Water System Facility

WSF: Designated sampling location for water system compliance– For VOC/IOC/SOC is “Entry Point to Distribution” (ie EP-A)

http://170.104.63.9/labhelp.php

Note: DWP is encouraging water systems to put their WSF on the lab forms

Sample Point : number assigned to sampling location in SDWIS (“1”)

Analysis Method

• Method reported to DWP in text files need to match method in SDWIS

http://170.104.63.9/labhelp.php

LIMS Output of DWP Data

Sunshine Campground4100684

NitrateWell #1

NDSM 4500 NO3D

Method Analysis Pairings

ASCII Rows

00684,EP-A,1,OR100014,sampleID,04/29/2009,1040,4500NO3-D,MRL,0.1,MG/L,ND

SM 4500 NO3D

4500NO3-D

LIMS:

00731,EP-A,1,OR100014, 20090501,05/01/2009,1040,4500NO3-D,MRL,0.1,MG/L,ND

PWS

WSF

Sample Point

ORELAP ID

Sample ID

Collection Date

Analyte Code

Method

Reporting Limit

Unit

Result

Example of ASCII (text file)

Login to DWP

Contact DWP for username and password

Upload file to DWP

PHP “Gatekeeper” Verifies Data

PHP “Gatekeeper” Found Invalid Data

Fields Verified by PHP “Gatekeeper”

• PWS exists• WSF and sample point (ie EP-B, 2) exists for

PWS• Duplicate • Analysis Method matches SDWIS • Unit is allowable (mg/L)• Other items (contact John Davis)

Enter data via Terminal Server

Close batch

Upload batch into SDWIS

Obtain proof sheet

Terminal Server (TS) Process

Terminal Server: Coliform

Example: Nitrate Report

Terminal Server :Chems

Terminal Server (chems): Edit Screen

Customized Proof Sheet

MCL Exceedences

*Positive Coliform samples and MCL exceedences still need to be faxed

to DWP on dedicated MCL fax line.

Lab Help Page

http://170.104.63.9/labhelp.php

Samples Due (beta status)• A way to identify what samples are needed for a

water system’s monitoring schedule.

Next steps…

• Contact DWP for username and password

• DWP will help labs as much as possible to set up electronic reporting

Contact Info

Michelle Van KleeckData Management Coordinator(971) 673-0471

John A. DavisApplication, Maintenance, Support for Oregon DWP(971) 673-0110