SlideServe
Télécharger Obtenir Pro
Menu
Accueil Pro
Préférences
ApparenceLight Aide et commentaires
© SlideServe · v2026

Drinking Water Program

reese avatar
reese
28 diapositives · 340 Views · Nov 26, 2013

This program offers a detailed guide on managing drinking water systems, covering contaminants, electronic reporting, sample analysis, lab data integration, compliance requirements, and more. Learn about benefits, data integrity, ASCII processing, reporting methods, and system compliance for better water quality tracking and SDWIS incorporation. Register for the May 15, 2009 workshop in Oregon, and discover how electronic reporting can streamline your monitoring processes.

#monitor #trough #scuttlebutt #water glass #water hole #mineral water #branch water #soda water
Drinking Water Program - slide 1
01 / 28Drinking Water Program
1 / 17

Télécharger la présentation

Drinking Water Program
Une image / un lien ci-dessous est fourni (tel quel) pour télécharger la présentation

Politique de téléchargement : le contenu du site vous est fourni TEL QUEL pour votre information et votre usage personnel ; il ne peut être vendu, concédé sous licence ni partagé sur d’autres sites sans l’accord de son auteur.Le contenu vous est fourni TEL QUEL, pour votre information et votre usage personnel uniquement. Téléchargez la présentation en cliquant sur ce lien. Lors du téléchargement, si vous ne parvenez pas à télécharger une présentation, l’éditeur a peut-être supprimé le fichier de son serveur.Pendant le téléchargement, si vous ne parvenez pas à obtenir une présentation, le fichier a peut-être été supprimé par l’éditeur.

F I N

Plus de contenu associé

Transcription de la présentation

  1. Drinking Water Program OELA Spring Workshop May 15, 2009

  2. Oregon Public Water Systems

  3. 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)

  4. 102,982

  5. 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

  6. 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)

  7. ASCII Process (computer generated file) Drinking Water Sample Perform Analysis Lab’s LIMS outputs DWP Data Submit batch to DWP (text file) DWP “gatekeeper” verifies data Data incorporated into SDWIS DWP imports data

  8. Data Requirements for Water System Compliance: VOC/IOC/SOC • DWP RequirementsExample • 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

  9. Water System Facility WSF: Designated sampling location for water system compliance • For VOC/IOC/SOC is “Entry Point to Distribution” (ie EP-A) • Sample Point : number assigned to sampling location in SDWIS (“1”) http://170.104.63.9/labhelp.php Note: DWP is encouraging water systems to put their WSF on the lab forms

  10. Analysis Method • Method reported to DWP in text files need to match method in SDWIS http://170.104.63.9/labhelp.php

  11. LIMS Output of DWP Data Sunshine Campground 4100684 Nitrate Well #1 ND SM 4500 NO3D LIMS: SM 4500 NO3D Method Analysis Pairings 4500NO3-D ASCII Rows 00684,EP-A,1,OR100014,sampleID,04/29/2009,1040,4500NO3-D,MRL,0.1,MG/L,ND

  12. Example of ASCII (text file) Reporting Limit Sample Point Analyte Code Sample ID Result PWS 00731,EP-A,1,OR100014, 20090501,05/01/2009,1040,4500NO3-D,MRL,0.1,MG/L,ND Method WSF ORELAP ID Collection Date Unit

  13. Login to DWP Contact DWP for username and password

  14. Upload file to DWP

  15. PHP “Gatekeeper” Verifies Data

  16. PHP “Gatekeeper” Found Invalid Data

  17. 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)

  18. Terminal Server (TS) Process Enter data via Terminal Server Close batch Obtain proof sheet Upload batch into SDWIS

  19. Terminal Server: Coliform

  20. Example: Nitrate Report

  21. Terminal Server :Chems

  22. Terminal Server (chems): Edit Screen

  23. Customized Proof Sheet

  24. MCL Exceedences *Positive Coliform samples and MCL exceedences still need to be faxed to DWP on dedicated MCL fax line.

  25. Lab Help Page http://170.104.63.9/labhelp.php

  26. Samples Due (beta status) • A way to identify what samples are needed for a water system’s monitoring schedule.

  27. Next steps… • Contact DWP for username and password • DWP will help labs as much as possible to set up electronic reporting

  28. Contact Info Michelle Van Kleeck Data Management Coordinator (971) 673-0471 • John A. Davis • Application, Maintenance, Support for • Oregon DWP • (971) 673-0110