Beaches Data Flow Getting Notification Data Into PRAWNS

Beaches Data Flow Getting Notification Data Into PRAWNS Dennis Murphy Delaware DNREC (302) 739 -3490 Dennis. murphy@state. de. us

Beach Data Flow Types • Notifications & Advisories – Feeds PRAWNS – Supports Node Submission & XML • Water Quality Monitoring – Feeds STORET – Supports XML file uploads but not Node submissions – Requires Post Processing

Beach Data Flow Steps to Production • Consolidate Beach Data • Get Flow Working in Test – Get Test User. IDs – Prepare EPA Test Database – Produce XML Document – Submit XML to CDX – Check Log For Errors – Debug • Move into Production – Repeat above steps

Beach Data Flow Consolidate Data • Develop procedures for consolidating all data in one database

Beach Data Flow Get User. ID’s • ID’s Needed For – NAAS – CDX – STORET • Each ID needs appropriate permissions • Key Contacts – CDX Help Desk – Charles Kovatch

Beach Data Flow Prepare EPA Databases • Get Agency ID from EPA • Verify that all stations are registered with STORET – Add with Web Registration application if needed – Beaches must be in both Test & Production STORET

Beach Data Flow Produce XML Document • Get Schema From EN website www. exchangenetwork. net click on Network Registry button • Map data to schema • Generate XML Instance Document • Validate versus schema

Beach Data Flow Get Data To CDX - Flow Patterns • Passive (EPA come and get it) – Uses Solicit method – Needs CDX to set up program to request data on periodic basis • Active (EPA here it comes) – Uses Submit Method – Submitter controls timing of submissions

Beach Data Flow Active Flow Patterns - Flavors • Automatic – Data submitted “as it is entered” • User Controlled – User selects what data and when to do submittal

Beach Data Flow Active Flow Patterns - Automatic • Data entered into Production DB behind Agency firewall • Data Replicated to DMZ DB • Watcher Program (Node client) on DMZ Node server polls DMZ DB for new data • When found Watcher – Generates XML – Does submittal to CDX

Beach Data Flow Active Flow Patterns - User Controlled • • • Data entered into Production DB behind Agency firewall User selects what data & when to submit XML file generated & saved to text field in DMZ DB Watcher Program (Node client) on Node server polls DMZ DB for new files When found Watcher submits to CDX

Beach Data Flow Useful Contacts • Charles Kovatch - EPA – – • CDX Helpdesk & EN Website – – • (202) 566 -0399 Kovatch. charles@epamail. epa. gov (888) 890 -1995 www. exchangenetwork. net Dennis Murphy - DE DNREC – – (302) 739 -3490 Dennis. murphy@state. de. us

Paper Forms & Flat Files Are Evil!