Skip common site navigation and headers
United States Environmental Protection Agency
Information Management Branch Update
Begin Hierarchical Links EPA Home > Water > Ground Water & Drinking Water > Data & Databases > Information Management Branch Update > March/April/May/June 2002 End Hierarchical Links

 

March/April/May/June 2002

Meeting Your Information Needs
Vol. 6 No. 3
March/April/May/June 2002
EPA 816-N-02-001c
Office of Ground Water and Drinking Water
(OGWDW) (4606)
1200 Pennsylvania Ave. NW, Washington, DC 20460
     
In This Issue...  
     
  Data Sharing Committee  
  CROMERRR Updates  
  Management Status Report Through FY 2002 2nd Qtr  
  IMB Update Publication Information  
     
 
Data Sharing Committee
 

Contact: Robert Burns
(404) 562-9456

The Data Sharing Committee recently met and came to conclusion on several issues, and is further refining another issue that came before the committee. The Data Sharing Committee wrapped up its work on defining how analytical results and violations should be structured in SDWIS or its successor system. Subjects covered in this issue paper include: 1) whether Group Contaminant Codes should be allowed as a data entry method; 2) whether additional information on Monitoring Frequencies, Waivers, Grandfathering was necessary in the Federal data system; 3) whether States which have chosen to adopt more stringent regulations must report those violations; 4) whether EPA should continue to allow states to report Phase I, II, IIB, and V violations by either system or entry point; 5) if there was a universal approach to reporting health-based standards violations available that could enhance the usefulness of such data to the stakeholders; and, 6) if there is a consistent approach to reporting monitoring and reporting violations to SDWIS/FED that will eliminate some inconsistencies in determining the period of actual violation. The issue paper was sent on to the Data Management Steering Committee for their consideration at their Albuquerque meeting in May.

The Committee also took up an issue regarding the Regional Data Management Coordinators’ wish that we reexamine if the seasonal begin and end dates should be made mandatory reporting again. In 1998, they were dropped from the Core Data Set because the Committee felt that the data was too variable, had a tendency to be volatile, leading to its being unreliable in general. Because of a decision made to operate TCR/SWTR automatic addressing of SNC noncommunity water systems differently, the Coordinators stated a need for accurate season begin and end date. After discussion, the Committee held to its prior position that the data is volatile, changeable and sketchy. Different States update that information at different frequencies, and it was felt that Regions and other agencies needed to contact States when they had a real-time need for the data. The decision was made to retain the optional status of the season begin and end date. The issue paper was sent to the Coordinators and DWPD/Infrastructure Branch management.

Finally, the Committee took up the issue of fixed identifiers for Water System Facilities (sources, plants and entry points.) This issue mainly has to do with those States that generate treatments off of the source, instead of creating separate treatment plant records, then linking sources to those treatment plants. After discussing the pros and cons of fixed identifiers, as well as the forces within EPA that were moving us in that direction, we began to discuss the difficulty of implementing fixed identifiers prior to the next release of the SDWIS/FED software. Instead of issuing a recommendation at this time, the Committee is going to work on the implementation aspects, exploring with the SDWIS/FED team what options we could utilize. We will take the issue up again at our meeting in Albuquerque.

The Committee continues to look for Regional members with either Enforcement or Implementation perspectives. Please contact Jeff Bryan at (202) 564-3942 if you are interested in this very-part-time assignment.

   
   
 
CROMERRR Updates
 

Jeffrey Bryan
(202) 564-3942

At the last meeting, the full workgroup was informed of a briefing made by OEI, OECA and OGC to Kim Nelson recommending going forward with a simple rule with national guidance. Simple means 1) tweaking the current language on E-reporting, 2) developing state primacy reg revisions (-define where states would need EPA approval, -provide for a streamlined approval process, and -set "performance" criteria for state E-reporting and state E-Recordkeeping with guidance that is more specific on suggested system performance requirements), and 3) decouple E-recordkeeping for regulated entities from CROMERRR. By July 10, 2002, each program office is supposed to report back with AA-level office positions on the OEI/OECA proposal to proceed with CROMERRR "lite."

OECA is continuing to pursue an electronic recordkeeping rule that would be more "general performance standard" based. OECA is preparing a draft work plan to accomplish a "risk" analysis, a "technology" analysis and a "economic" analysis for additional reg controls on E-recordkeeping beyond general performance standards. Currently, there is no real plan in place to accomplish this but the draft workplan is intended to keep the topic on the front burner.

OGWDW will be reviewing the proposed changes to the electronic reporting language and other draft documents with appropriate staff when they become available over the summer. and will report our conclusions to you.

The proposed milestones for the final language on the revised CROMERRR includes informal Agency and State review by mid-August 2002; Final Agency Review/Workgroup Closure by late October 2002, and Final Rule Published in FR by April 2003.

   
Grant Update
 

Jeffrey Bryan
(202) 564-3942

List of State proposals for IT grant dollars

At the annual Data Manager User Conference in New Mexico this year, we learned that not everyone was aware of the availability of several kinds of grants (Readiness grants, Challenge grants, etc.) that could be used to advance state information technology activities. Additionally, many states did not know if their state had applied for such grants. I spoke with Lyn Berger at EPA’s Office of Environmental information and she provided the following information to help states track if their states are submitting proposals to do IT work and whether they have received funding for those proposals.

A listing of all proposals received is currently posted on the NEIEN grant web site. We plan to use this site as a tool for keeping all stakeholders informed about the Network Grant Activities. We don't have points of contact (POCs) for each proposal, however, we will be updating the web site to reflect the final award decisions, as well as including a short summary of each of the projects. At your suggestion, we will add POCs for each project. We also plan to post quarterly updates on each project .

Please check out the web site at http://www.epa.gov/neengprg/new.html. Let me know if you need additional information

   
 
Management Status Report Through FY 2002 2nd Qtr (4/3/2002, rev.4/24p.m.):
 

PWS Intake/Wellhead Latitude/Longitude Task Group
Carl B. Reeverts
(202) 564-4632

We are ready to start using the lat/long data in SDWIS/Fed in several GIS applications:

  1. OW will release in May an intranet version of OW Enviromapper with a new drinking water data layer, displaying intake locations indexed to NHD stream reaches. Access will be for EPA employees only through a password.
  1. OPP will be using the intake location data indexed to stream reaches in a GIS model to project pesticide usage in intake contributing watersheds, to meet requirements under the 1996 Food Quality Projection Act.
  1. OGWDW will access all the well and intake data to continue development and testing of its drinking water GIS application.

Although we have a wealth of data to offer (location of 6,500 intakes and 102,958 wells for 39,068 CWS), we still have some data gaps and we have not completed the Q/A of all the data. But based on the Q/A efforts to date for both the well and intake data, we believe these data problems are few and far between.

Our overall goal continues to be: to populate SDWIS/Fed with complete and valid lat/long data ready for use in GIS applications. Progress toward filling the remaining data gaps has slowed dramatically! The March 31, 2002 SDWIS/Fed report, in fact, shows several states with a lower percentage of CWS with complete lat/long data than last quarter.

o We still are close to meeting our first objective (i.e., to get the data into SDWIS/Fed), but the remaining data gaps have increased over the last quarter. As of April 3, 2002::

84% (or 39,068) of the CWS have complete lat/long data for their source facilities, with 6,500 intakes (86%) and 102,958 wells (89%) with complete data. This is down from a high in February of 89% of the CWS. The CWS’s with complete data fell dramatically for PR, LA, NM, TX, and ID for a variety of reasons.

39 States, D.C., and 5 Regional Tribal programs have data for greater than 80% of their CWS, down from a high of 42 states last quarter

The data gaps still remain. One State (DE), Puerto Rico and the Virgin Islands, the four Region 9 Territories, and the Region 1 and 9 Tribal programs continue to show zero percent lat/long data in SDWIS/Fed.

o We continue to progress toward meeting our second objective (i.e., to validate the data). As of April 3:

– For the intakes, we’ve completed (with USGS’s help) our Q/A reviews for 23 States (or about 3,123 of the 6,545 intakes with complete lat/long) and resolved all data exceptions through conference calls with the States. Scheduling additional State Q/A reviews is on hold because of workload priorities at USGS, but we expect the reviews to start up in May on the 27 remaining States and the Tribal programs and Territories.

– For wells, we completed the initial Q/A screen of the well data (well point-to-CWS State polygon) and were pleasantly surprised that there were very few outlier values: less than 50 of the 100, 000 wells were outside the expected state boundary! We are in the process of completing the second round (well point-to-CWS zip code polygon). This Q/A review should be completed in May and we will work with the Regions and individual States to resolve exceptions identified from this analysis.

o Finally, we are moving aggressively toward reaching our third objective (i.e., to make the data ready for use):

– For intakes, Oak Ridge National Laboratory (ORNL), under a grant from OPP, is completing the indexing of the SDWIS/Fed lat/long point data to NHD stream reaches. We expect to generate the Reach Address Database (RAD) in May containing over 5,000 of the 7,558 intakes indexed to NHD reaches. The remaining intakes will be indexed by the end of FY 2002. We are allowing access to the indexed intake data from the RAD available to internal users immediately.

– For wells, we expect to make available the well point data from SDWIS/Fed to internal EPA users immediately, with outlier data discovered in the Q/A review identified. We continue to discuss whether and how the well point data should be "indexed" to other geographic features (e.g., USGS HUC codes). For external users, we are still working through the information security issues and options to providing locational data outside EPA.

Following is a progress report summary of Region and state progress toward reaching the first objective:

Lat/Long Management Status Report (4/3/2002) (rev.4/23p.m.)

Objective 1: Finish Collecting the Data and Entering It in SDWIS Fed

[Initial Deadline: June 30, 2001; Revised deadline: Dec 31, 2001;Final deadline: ?]

[data from 1Q2002 SDWIS/Fed frozen data base (4/3/2002)

% of CWS with complete lat/long in SDWIS/Fed, incl. MAD codes (not including CWS who purchase water)

# of States with the LL data essentially complete (greater than 80% of CWS with complete lat/long)

# of States, Tribes, Territories with a lot of missing data (< 80% compl)

TARGET STATES...Still Not at >80% by 4/3/2002!

84% of CWS

(39,068 of 46,381)

6,500 of 7,558 intakes(86%)

102,958 of 115,971

wells (89%)

Range by Region:

Reg 3 (93%) Reg 10(84%)

Reg 4 (92%) Reg 9 (81%)

Reg 1 (92%) Reg 7 (81%)

Reg 8 (91%) Reg 2 (76%)

Reg 5 (88%) Reg 6 (73%)

24 States, 2 Tribes, D.C. have 95%-100%!: CT, NH; NY; DC, PA, VA, WV; FL, KY, NC, TN; IL, MN, OH; AR, OK; IA, MO, NE; ND,UT; AZ,CA; AK, WA; Tribes: Reg 4,5

15 States, 3 Tribes

>80%:

MA,ME,VT, MD, AL, GA, MS, SC; IN, WI; CO, MT, SD, WY; HI; Tribes: Reg 6,7,8

6 States >50%

RI (67%); NJ (76%); MI(59%); LA (74%), TX (71%); OR (76%)

4 States, 2 Tribes Greater than 0%:

KS (15%); NV(46%); NM (38%); ID (4%); Tribe: Reg2 (25%),Reg 10(10%)

1 States, 2 Tribes, 6 Terr. with 0 %!!!!! DE; Tribes: Reg 1, 9; Reg 2 Terr (PR,VI); 4 Terr in Reg 9

Reg 1: RI, Tribes

Reg 2: NJ,PR,VI,

Tribes

Reg 3: DE

Reg 5: MI

Reg 6: LA,NM,TX

Reg 7 : KS

Reg 9: NV, Trbes, GU,AS, MP, PW

Reg 10: ID,OR, Tribes

-----------------------

 

   
 
IMB Update Publication Information
 

Phill C. Scearce
202-564-4634

This month's update is being delivered on OGWDW's website; the update is also being emailed out as an Adobe™ PDF file. (To use a PDF document, a reader program must be installed on your computer to display, print, and navigate. The Adobe™ Acrobat™ reader is available for downloading at no cost from Adobe's Web site at http://www.adobe.com.) For those who wish to read the newsletter online, simply enter this url into your browser: (http://www.epa.gov/safewater/imb_update/index2.html). If you need to print out the update, there is a print link at the top of the web page so all you have to do is click the link and it will take you to a printable version of the update.

If you have any questions or issues with the new format, please feel free to contact me at (202) 654-4634 or by email at scearce.phill@epa.gov, and I will assist you with the new changes, as well as subscription additions and/or changes.

   
You will need Adobe Acrobat Reader to view the Adobe PDF files on this page. See EPA's PDF page for more information about getting and using the free Acrobat Reader.

 

Safewater Home | About Our Office | Publications | Calendar | Links | Office of Water | En Español

 
Begin Site Footer

EPA Home | Privacy and Security Notice | Contact Us