440 likes | 533 Views
Western Regional Air Partnership Emissions Database Management System January 2004 WRAP Technical Summit Phoenix, Arizona. E.H. Pechan & Associates, Inc. Organization. Organization. Purpose Team Scope Schedule Communications Concepts. Purpose. Purpose. Regional Haze Rule
E N D
Western Regional Air PartnershipEmissions Database Management SystemJanuary 2004 WRAP Technical SummitPhoenix, Arizona E.H. Pechan & Associates, Inc.
Organization • Purpose • Team • Scope • Schedule • Communications • Concepts
Purpose • Regional Haze Rule • Implementation • Performance Monitoring • Region-Wide Emission Inventory • Analysis of Collected Data • Emissions Comparisons • Emissions Trends Analysis
Team • E.H. Pechan & Associates, Inc. • Computer Science Corporation • Carolina Environmental Programs • i2k2 Systems
Scope • Database Structure • Web-Based Analysis Interface • Batch Data Take On • Outputs/Data Extracts • Administrative Module/DBA Functions
Scope Database Structure • All Sectors • Multiple Years • Multiple Types • Data Versioning
Scope Web-Based Analysis Interface • Public • GIS • Preformatted Reports • Preformatted Data Extracts • Secure • Ad-hoc Reports/Extracts • Data Import/Export
Scope Batch Data Take On • NIF Version 3.0 • WRAP EDMS Format • TEISS • QA/QC Procedures (QAPP) • Recursive QA/QC • Gap-Filling/Data Adjusting
Scope Outputs/Data Extracts • NIF Version 3.0 • SMOKE • To Be Identified
Scope Administrative Module/DBA Functions • User Management/Security • LISTSERV • Ad-Hoc Functions • QA/QC • Report Development • Analysis
Scope Project Attributes • Nine Tasks • Multiple Deliverables • One Year Timeline
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
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
Scope TASK 3. PROVIDE HARDWARE NECESSARY TO RUN THE EDMS ON A HOST COMPUTER NETWORK DELIVERABLES 1. Hardware Invoice
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
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
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
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
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
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
Scope TASK 8. PROVIDE A HOME LOCATION FOR THE HOST COMPUTER NETWORK SYSTEM INCLUDING STAFF DELIVERABLES 1. Provide Home Location
Scope TASK 9. PROVIDE EMISSIONS DATA ANALYSIS AND PROCESSING REPORTS AS NEEDED DELIVERABLES 1.Reports as needed
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
Concepts Data Take On – QA/QC Gap-Filling Data Adjusting 3 times QA/QC Data Reporters Import Production Staging
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
Concepts/GIS Interface Feature Layers Map
Concepts GIS/Data Retreival • Draw Polygon • Select Database • Select Sector(s) • Select Sources (SCC, Name, etc…) • Select Pollutant(s)