1 / 44

Western Regional Air Partnership Emissions Database Management System

This system provides a web-based interface for regional haze rule implementation, emissions monitoring, and analysis, with features such as data import/export, preformatted reports, and GIS capabilities.

vickismith
Download Presentation

Western Regional Air Partnership Emissions Database Management System

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Western Regional Air PartnershipEmissions Database Management SystemJanuary 2004 WRAP Technical SummitPhoenix, Arizona E.H. Pechan & Associates, Inc.

  2. Organization

  3. Organization • Purpose • Team • Scope • Schedule • Communications • Concepts

  4. Purpose

  5. Purpose • Regional Haze Rule • Implementation • Performance Monitoring • Region-Wide Emission Inventory • Analysis of Collected Data • Emissions Comparisons • Emissions Trends Analysis

  6. Team

  7. Team • E.H. Pechan & Associates, Inc. • Computer Science Corporation • Carolina Environmental Programs • i2k2 Systems

  8. Scope

  9. Scope • Database Structure • Web-Based Analysis Interface • Batch Data Take On • Outputs/Data Extracts • Administrative Module/DBA Functions

  10. Scope Database Structure • All Sectors • Multiple Years • Multiple Types • Data Versioning

  11. Scope Web-Based Analysis Interface • Public • GIS • Preformatted Reports • Preformatted Data Extracts • Secure • Ad-hoc Reports/Extracts • Data Import/Export

  12. Scope Batch Data Take On • NIF Version 3.0 • WRAP EDMS Format • TEISS • QA/QC Procedures (QAPP) • Recursive QA/QC • Gap-Filling/Data Adjusting

  13. Scope Outputs/Data Extracts • NIF Version 3.0 • SMOKE • To Be Identified

  14. Scope Administrative Module/DBA Functions • User Management/Security • LISTSERV • Ad-Hoc Functions • QA/QC • Report Development • Analysis

  15. Scope Project Attributes • Nine Tasks • Multiple Deliverables • One Year Timeline

  16. Scope TASK 1. DESIGN, DEVELOP, WRITE THE COMPUTER CODE AND PROVIDE SUPPORT SOFTWARE AS NEEDED FOR THE EDMS DELIVERABLES 1. Initial Draft Software and Hardware Development Plan 2. Final Draft Software and Hardware Development Plan 3. Final Software and Hardware Development Plan

  17. Scope TASK 2. TEST AND REFINE THE EDMS AND ITS FUNCTIONS BEFORE ROUTINE OPERATION BEGINS DELIVERABLES 1. Alpha Version of the EDMS 2. Beta Version of the EDMS 3. Implementation of the EDMS

  18. Scope TASK 3. PROVIDE HARDWARE NECESSARY TO RUN THE EDMS ON A HOST COMPUTER NETWORK DELIVERABLES 1. Hardware Invoice

  19. Scope TASK 4. DEVELOP AND IMPLEMENT QUALITY ASSURANCE/CONTROL PROCEDURES AND PROTOCOLS FOR THE ROUTINE USERS AND OPERATORS OF THE EDMS DELIVERABLES 1. Preparation Plan for EDMS Quality Assurance Project Plan (QAPP) 2. Draft EDMS QAPP 3. Final approved EDMS QAPP

  20. Scope TASK 5a. CONSTRUCT THE EDMS TO ALLOW INTAKE AND INITIAL PROCESSING OF S/L/T AGENCIES CERR 2002 NEI DATA SUBMITTALS DELIVERABLES 1. Import and processing of initial S/L/T data

  21. Scope TASK 5b. IMPLEMENT AND BEGIN ROUTINE OPERATION OF THE EDMS ON THE HOST COMPUTER NETWORK OPERATING SYSTEM DELIVERABLES 1.Fully functional EDMS based on detailed design specifications

  22. Scope TASK 5c. MAINTAIN, UPGRADE AND ROUTINELY OPERATE THE EDMS ON THE HOST COMPUTER NETWORK SYSTEM ON AN ONGOING BASIS DELIVERABLES 1. Ongoing operation, support, maintenance and upgrades

  23. Scope TASK 6. PROVIDE AN ON-LINE USER=S MANUAL FOR THE EDMS DELIVERABLES 1. Initial draft on-line User=s Manual for EDMS 2. Gather comments on initial draft User=s Manual 3. Final on-line User=s Manual for EDMS 4. Update User=s Manual

  24. Scope TASK 7. PROVIDE TRAINING FOR EDMS USERS AND ONGOING SUPPORT DELIVERABLES 1. Syllabi for training sessions 2. Budgets and staff for telephone/on-line support 3. CERR data submission workshop 4. Schedule and syllabi for ongoing EDMS training and support

  25. Scope TASK 8. PROVIDE A HOME LOCATION FOR THE HOST COMPUTER NETWORK SYSTEM INCLUDING STAFF DELIVERABLES 1. Provide Home Location

  26. Scope TASK 9. PROVIDE EMISSIONS DATA ANALYSIS AND PROCESSING REPORTS AS NEEDED DELIVERABLES 1.Reports as needed

  27. Scope/Project Flow Systems Analysis and Design QA/QC Processes Reports Hardware - Home Location Routine Operations Training Build and Document Maintenance and Support Test and Refine Initial Data Load

  28. Schedule

  29. Communications

  30. Concepts

  31. Concepts Data Take On – QA/QC Gap-Filling Data Adjusting 3 times QA/QC Data Reporters Import Production Staging

  32. Each emissions sector is comprised of a unique set of tables Concepts Data Structure Version 2 Version 3 Version 4 2002 Planning Sensitivity Run Forecast 2005 time

  33. Concepts/GIS Interface Feature Layers Map

  34. Concepts/GIS Zoom

  35. Concepts/GIS Pan

  36. Concepts GIS/Layers

  37. Concepts GIS/Layers

  38. Concepts GIS/Data Retreival • Draw Polygon • Select Database • Select Sector(s) • Select Sources (SCC, Name, etc…) • Select Pollutant(s)

  39. Concepts GIS/Data Display

  40. End of Presentation

More Related