Data User Corner
This webpage contains updated instruction for data submission after 10/01/2008.
Under the BEACH Act Grant Program states are required to submit their beach monitoring (water quality), notification (advisory and closing), and beach location data to us. This site was established to provide an easily accessible location for state beach program managers and IT staff to obtain beach data updates and other reference materials. You can download these files directly from this site by clicking on the relevant item below.
If you are responsible for submitting beach data, and you have not been registered to use the EPA systems identified below, please contact Bill Kramer (kramer.bill@epa.gov); 202-566-0385. To see how submitted data is presented to the public by EPA, see our seasonal reports.
You can also download a zip file with all active materials 3.6 MB, Requires archiving software).
You will need Adobe Reader to view some of the files on this page. See EPA's PDF page to learn more.
Overview
-
Central Data Exchange (CDX) (this graphic comes from the eBEACHES Data Flow Diagram (PDF))
- Submission Method Selection Instructions (PDF) (4 pp., 37 K; Changes from the previous version include: how to add WQX webservices to Node Client Lite (see file in "c." below), and how to find updated domain values.) Contains general instructions on how to select either a State Node, Node Client, or EPA Central Data Exchange (CDX) as the starting point for submitting monitoring and notification data. If you do not have a Beach Program Organization ID from EPA, prior to submitting data, contact Bill Kramer (kramer.bill@epa.gov); 202-566-0385.
- WQX Services File (189 K) These services provide a way to check what data a user has submitted or a way to access domain values, this is helpful when responding to error messages. For Beach Program users, although the file below is v2.0, the v1.0 domain value and transaction ID services are still supported, and this file works with both.
Locational Data (Beach Location—PRAWN, RAD)
-
NHD-RIT to RAD (this graphic comes from the eBEACHES Data Flow Diagram (PDF))
- Reach Indexing Tool (RIT) Part of the NHD Toolkit, the National Hydrography Dataset Reach Indexing Tool (NHD-RIT) is an interactive GIS application that allows users to georeference surface water data using the National Hydrography Dataset (NHD). The process of identifying and assigning attributes to portions of the NHD is referred to as Reach Indexing.
Monitoring Data (WQX/STORET, includes station location)
WQX to STORET (this graphic comes from the eBEACHES Data Flow Diagram (PDF))
ResultStatusIdentifier
data element to explain using the valueFinal
.) Contains descriptions of all required beach water quality data fields to be reported in XML file format and how to input XML files from WQX.- Water Quality Exchange XML Training Manual for BEACH Monitoring Data (PDF) (24 pp, 635 K; Changes from the previous version include: Pg 1: removed "overview of beach data submission process" section, removed table 1; Pg 12: new screen capture for figure 14; and provision of example XML files; Update of Trip Blank Activity Section to indicate the need for the Sample Collection Method (because it is a type of sample). Updated Figure 14 to show that Sample Collection Method block is included. Updated Figures 10, 11, 13 for incorrect unit format to "MPN/100ml", instead of the incorrect "MPN/100 ml" (and Beaches/WQX Crosswalk [MS-Excel] [43 K]) For states not using the Monitoring Data Access Database (d, below), explains how to configure a local state database to produce WQX compliant XML submission files.
- WQX_BEACH_Demotest.xml (12 K)
- WQX_BEACH_Demotest_Delete.xml (1 K)
- WQX Homepage, see particularly, Submitting Data to EPA Using WQX: Steps for an organization to take in order to begin submitting data.
- Monitoring Data Access Database Quick Reference (PDF) (1 pp, 18 K) Provides steps to install the Monitoring Data Access Database (next item).
- WQX Monitoring Data Access Database v2.1.2 (.mdb) (5.9 MB, Requires MS-Access) A state can choose to use this database to store all required beach water quality data fields, input XML files from WQX, and generate an XML file for data submission to WQX. Zipped file of this database (.zip) (986 K, Requires archiving software)
- Monitoring Database Update Instructions (v2.1.1 to v2.1.2) (PDF) (1 pp., 11 K) Use these instructions to update your Monitoring Access DB with new WQX domain values
- Downloading & Using Data from the STORET Warehouse (PDF) (12 pp, 98 K) An Exercise for the BEACH Program to QA IDs
Notification Data (PRAWN)
PRAWN (this graphic comes from the eBEACHES Data Flow Diagram (PDF))
- PRAWN Notification Submission Corrections User Guide v2.1 (October 01, 2008) (PDF) (18 pp, 68 K) Details the process of modifying incorrect, but already submitted, information usually as a result of annual QA review.
- PRAWN Beach Notification Data Schema and Development Documents v2.1
Contains all required beach advisory and closing data fields to be reported to PRAWN. (Particularly for States not using the following Access DB for notification data.)
- PRAWN Notification Data Access Database Quick Reference (PDF) (1 pp, 18 K) Provides steps to install the Notification Data Access Database (next item).
- PRAWN Notification Data Access Database v2.1 (.mdb) (1.8 MB, Requires MS-Access) A state can choose to use this database to store all required beach advisory and closing data fields and generate an XML file for data submission to PRAWN. Zipped file of this database (.zip) (367 K, Requires archiving software)
Support
- CDX User Support: Provide support on CDX access and all eBeaches passwords, CDX Support (epacdx@csc.com); 888-890-1995
- Node User Support: Provide support on Node access alternatives - Node Support (nodehelpdesk@csc.com); 888-890-1995, option 2
- Locational Data Support: Provide support on Beach location data - OW Support (owsupport@rti.org); 800-844-0638
- Monitoring Data Support: Provide support on Monitoring XML schema validation, WQX, and STORET - OW Support (owsupport@rti.org); 800-844-0638
- Notification Data Support: Provide support on Notification XML schema validation and PRAWN - Beaches Support (ebeaches@cgifederal.com); 276-889-7441
- eBEACHES User Registration and General Support: Sponsor users for User IDs to access EPA systems, and provide support on eBeaches questions - Bill Kramer (kramer.bill@epa.gov); 202-566-0385
- BEACON Users Support: Provide support on BEACON questions - Lars Wilcut (wilcut.lars@epa.gov); 202-566-0447
Historical Files
Note: EPA no longer updates this information, but it may be useful as a reference or resource.
Current Year (2008)
Previous versions of the files for the current year.
- eBEACHES Location Data SOP
- WQX Beach Monitoring Data User Guide (PDF) (66 pp, 476 K)
- PRAWN Beach Notification Data User Guide v2.0 (PDF) (77 pp., 436 K)
- PRAWN Notification Data Access Database v2.0.2 (.zip) (377 K, Requires archiving software)
- PRAWN Notification Submission Corrections User Guide v2.0 (November 09, 2007) (PDF) (17 pp, 59 K)
- Submission Method Selection Instructions (PDF) (4 pp., 120 K)
- Water Quality Exchange XML Training Manual for BEACH Monitoring Data (PDF) (24 pp, 624 K)