130 likes | 215 Views
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
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