130 likes | 221 Vues
An overview of the Beach Data Flow system, covering steps from data consolidation to submission, contacts, and flow patterns. Learn the process, required IDs, and communication methods for effective data management.
E N D
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 UserIDs • 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 UserID’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 • (202) 566-0399 • Kovatch.charles@epamail.epa.gov • CDX Helpdesk & EN Website • (888) 890-1995 • www.exchangenetwork.net • Dennis Murphy - DE DNREC • (302) 739-3490 • Dennis.murphy@state.de.us
Evil! Paper Forms & Flat Files Are