![Page 1: Western Regional Air Partnership Emissions Database Management System January 2004 WRAP Technical Summit Phoenix, Arizona E.H. Pechan & Associates, Inc](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e165503460f94b006ab/html5/thumbnails/1.jpg)
Western Regional Air PartnershipEmissions Database Management System
January 2004 WRAP Technical SummitPhoenix, Arizona
E.H. Pechan & Associates, Inc.
![Page 2: Western Regional Air Partnership Emissions Database Management System January 2004 WRAP Technical Summit Phoenix, Arizona E.H. Pechan & Associates, Inc](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e165503460f94b006ab/html5/thumbnails/2.jpg)
E.H. Pechan & Associates, Inc.
Organization
![Page 3: Western Regional Air Partnership Emissions Database Management System January 2004 WRAP Technical Summit Phoenix, Arizona E.H. Pechan & Associates, Inc](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e165503460f94b006ab/html5/thumbnails/3.jpg)
3
E.H. Pechan & Associates, Inc.
Organization
• Purpose
• Team
• Scope
• Schedule
• Communications
• Concepts
![Page 4: Western Regional Air Partnership Emissions Database Management System January 2004 WRAP Technical Summit Phoenix, Arizona E.H. Pechan & Associates, Inc](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e165503460f94b006ab/html5/thumbnails/4.jpg)
E.H. Pechan & Associates, Inc.
Purpose
![Page 5: Western Regional Air Partnership Emissions Database Management System January 2004 WRAP Technical Summit Phoenix, Arizona E.H. Pechan & Associates, Inc](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e165503460f94b006ab/html5/thumbnails/5.jpg)
5
E.H. Pechan & Associates, Inc.
Purpose
• Regional Haze Rule• Implementation• Performance Monitoring
• Region-Wide Emission Inventory
• Analysis of Collected Data
• Emissions Comparisons
• Emissions Trends Analysis
![Page 6: Western Regional Air Partnership Emissions Database Management System January 2004 WRAP Technical Summit Phoenix, Arizona E.H. Pechan & Associates, Inc](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e165503460f94b006ab/html5/thumbnails/6.jpg)
E.H. Pechan & Associates, Inc.
Team
![Page 7: Western Regional Air Partnership Emissions Database Management System January 2004 WRAP Technical Summit Phoenix, Arizona E.H. Pechan & Associates, Inc](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e165503460f94b006ab/html5/thumbnails/7.jpg)
7
E.H. Pechan & Associates, Inc.
Team
• E.H. Pechan & Associates, Inc.
• Computer Science Corporation
• Carolina Environmental Programs
• i2k2 Systems
![Page 8: Western Regional Air Partnership Emissions Database Management System January 2004 WRAP Technical Summit Phoenix, Arizona E.H. Pechan & Associates, Inc](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e165503460f94b006ab/html5/thumbnails/8.jpg)
E.H. Pechan & Associates, Inc.
Scope
![Page 9: Western Regional Air Partnership Emissions Database Management System January 2004 WRAP Technical Summit Phoenix, Arizona E.H. Pechan & Associates, Inc](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e165503460f94b006ab/html5/thumbnails/9.jpg)
9
E.H. Pechan & Associates, Inc.
Scope
• Database Structure
• Web-Based Analysis Interface
• Batch Data Take On
• Outputs/Data Extracts
• Administrative Module/DBA Functions
![Page 10: Western Regional Air Partnership Emissions Database Management System January 2004 WRAP Technical Summit Phoenix, Arizona E.H. Pechan & Associates, Inc](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e165503460f94b006ab/html5/thumbnails/10.jpg)
10
E.H. Pechan & Associates, Inc.
Scope
Database Structure
• All Sectors
• Multiple Years
• Multiple Types
• Data Versioning
![Page 11: Western Regional Air Partnership Emissions Database Management System January 2004 WRAP Technical Summit Phoenix, Arizona E.H. Pechan & Associates, Inc](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e165503460f94b006ab/html5/thumbnails/11.jpg)
11
E.H. Pechan & Associates, Inc.
Scope
Web-Based Analysis Interface
• Public• GIS
• Preformatted Reports
• Preformatted Data Extracts
• Secure• Ad-hoc Reports/Extracts
• Data Import/Export
![Page 12: Western Regional Air Partnership Emissions Database Management System January 2004 WRAP Technical Summit Phoenix, Arizona E.H. Pechan & Associates, Inc](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e165503460f94b006ab/html5/thumbnails/12.jpg)
12
E.H. Pechan & Associates, Inc.
Scope
Batch Data Take On
• NIF Version 3.0
• WRAP EDMS Format
• TEISS
• QA/QC Procedures (QAPP)• Recursive QA/QC• Gap-Filling/Data Adjusting
![Page 13: Western Regional Air Partnership Emissions Database Management System January 2004 WRAP Technical Summit Phoenix, Arizona E.H. Pechan & Associates, Inc](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e165503460f94b006ab/html5/thumbnails/13.jpg)
13
E.H. Pechan & Associates, Inc.
Scope
Outputs/Data Extracts
• NIF Version 3.0
• SMOKE
• To Be Identified
![Page 14: Western Regional Air Partnership Emissions Database Management System January 2004 WRAP Technical Summit Phoenix, Arizona E.H. Pechan & Associates, Inc](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e165503460f94b006ab/html5/thumbnails/14.jpg)
14
E.H. Pechan & Associates, Inc.
Scope
Administrative Module/DBA Functions
• User Management/Security
• LISTSERV
• Ad-Hoc Functions• QA/QC• Report Development• Analysis
![Page 15: Western Regional Air Partnership Emissions Database Management System January 2004 WRAP Technical Summit Phoenix, Arizona E.H. Pechan & Associates, Inc](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e165503460f94b006ab/html5/thumbnails/15.jpg)
15
E.H. Pechan & Associates, Inc.
Scope
Project Attributes
• Nine Tasks
• Multiple Deliverables
• One Year Timeline
![Page 16: Western Regional Air Partnership Emissions Database Management System January 2004 WRAP Technical Summit Phoenix, Arizona E.H. Pechan & Associates, Inc](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e165503460f94b006ab/html5/thumbnails/16.jpg)
16
E.H. Pechan & Associates, Inc.
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
![Page 17: Western Regional Air Partnership Emissions Database Management System January 2004 WRAP Technical Summit Phoenix, Arizona E.H. Pechan & Associates, Inc](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e165503460f94b006ab/html5/thumbnails/17.jpg)
17
E.H. Pechan & Associates, Inc.
Scope
TASK 2. TEST AND REFINE THE EDMS AND ITS FUNCTIONS BEFORE ROUTINE OPERATION BEGINS
DELIVERABLES1. Alpha Version of the EDMS2. Beta Version of the EDMS3. Implementation of the EDMS
![Page 18: Western Regional Air Partnership Emissions Database Management System January 2004 WRAP Technical Summit Phoenix, Arizona E.H. Pechan & Associates, Inc](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e165503460f94b006ab/html5/thumbnails/18.jpg)
18
E.H. Pechan & Associates, Inc.
Scope
TASK 3. PROVIDE HARDWARE NECESSARY TO RUN THE EDMS ON A HOST COMPUTER NETWORK
DELIVERABLES
1. Hardware Invoice
![Page 19: Western Regional Air Partnership Emissions Database Management System January 2004 WRAP Technical Summit Phoenix, Arizona E.H. Pechan & Associates, Inc](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e165503460f94b006ab/html5/thumbnails/19.jpg)
19
E.H. Pechan & Associates, Inc.
Scope
TASK 4. DEVELOP AND IMPLEMENT QUALITY ASSURANCE/CONTROL PROCEDURES AND PROTOCOLS FOR THE ROUTINE USERS AND OPERATORS OF THE EDMS
DELIVERABLES1. Preparation Plan for EDMS Quality Assurance
Project Plan (QAPP)2. Draft EDMS QAPP3. Final approved EDMS QAPP
![Page 20: Western Regional Air Partnership Emissions Database Management System January 2004 WRAP Technical Summit Phoenix, Arizona E.H. Pechan & Associates, Inc](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e165503460f94b006ab/html5/thumbnails/20.jpg)
20
E.H. Pechan & Associates, Inc.
Scope
TASK 5a. CONSTRUCT THE EDMS TO ALLOW INTAKE AND INITIAL PROCESSING OF S/L/T AGENCIES CERR 2002 NEI DATA SUBMITTALS
DELIVERABLES1. Import and processing of initial S/L/T data
![Page 21: Western Regional Air Partnership Emissions Database Management System January 2004 WRAP Technical Summit Phoenix, Arizona E.H. Pechan & Associates, Inc](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e165503460f94b006ab/html5/thumbnails/21.jpg)
21
E.H. Pechan & Associates, Inc.
Scope
TASK 5b. IMPLEMENT AND BEGIN ROUTINE OPERATION OF THE EDMS ON THE HOST COMPUTER NETWORK OPERATING SYSTEM
DELIVERABLES1. Fully functional EDMS based on detailed design
specifications
![Page 22: Western Regional Air Partnership Emissions Database Management System January 2004 WRAP Technical Summit Phoenix, Arizona E.H. Pechan & Associates, Inc](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e165503460f94b006ab/html5/thumbnails/22.jpg)
22
E.H. Pechan & Associates, Inc.
Scope
TASK 5c. MAINTAIN, UPGRADE AND ROUTINELY OPERATE THE EDMS ON THE HOST COMPUTER NETWORK SYSTEM ON AN ONGOING BASIS
DELIVERABLES1. Ongoing operation, support, maintenance and
upgrades
![Page 23: Western Regional Air Partnership Emissions Database Management System January 2004 WRAP Technical Summit Phoenix, Arizona E.H. Pechan & Associates, Inc](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e165503460f94b006ab/html5/thumbnails/23.jpg)
23
E.H. Pechan & Associates, Inc.
Scope
TASK 6. PROVIDE AN ON-LINE USER=S MANUAL FOR THE EDMS
DELIVERABLES1. Initial draft on-line User=s Manual for EDMS2. Gather comments on initial draft User=s Manual3. Final on-line User=s Manual for EDMS4. Update User=s Manual
![Page 24: Western Regional Air Partnership Emissions Database Management System January 2004 WRAP Technical Summit Phoenix, Arizona E.H. Pechan & Associates, Inc](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e165503460f94b006ab/html5/thumbnails/24.jpg)
24
E.H. Pechan & Associates, Inc.
Scope
TASK 7. PROVIDE TRAINING FOR EDMS USERS AND ONGOING SUPPORT
DELIVERABLES1. Syllabi for training sessions2. Budgets and staff for telephone/on-line support3. CERR data submission workshop4. Schedule and syllabi for ongoing EDMS training and
support
![Page 25: Western Regional Air Partnership Emissions Database Management System January 2004 WRAP Technical Summit Phoenix, Arizona E.H. Pechan & Associates, Inc](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e165503460f94b006ab/html5/thumbnails/25.jpg)
25
E.H. Pechan & Associates, Inc.
Scope
TASK 8. PROVIDE A HOME LOCATION FOR THE HOST COMPUTER NETWORK SYSTEM INCLUDING STAFF
DELIVERABLES1. Provide Home Location
![Page 26: Western Regional Air Partnership Emissions Database Management System January 2004 WRAP Technical Summit Phoenix, Arizona E.H. Pechan & Associates, Inc](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e165503460f94b006ab/html5/thumbnails/26.jpg)
26
E.H. Pechan & Associates, Inc.
Scope
TASK 9. PROVIDE EMISSIONS DATA ANALYSIS AND PROCESSING REPORTS AS NEEDED
DELIVERABLES1. Reports as needed
![Page 27: Western Regional Air Partnership Emissions Database Management System January 2004 WRAP Technical Summit Phoenix, Arizona E.H. Pechan & Associates, Inc](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e165503460f94b006ab/html5/thumbnails/27.jpg)
27
E.H. Pechan & Associates, Inc.
Scope/Project FlowSystems Analysis
and DesignQA/QC Processes
Hardware - Home Location
Build and Document
Test and Refine
Initial Data Load
Reports
Routine Operations
Training
Maintenance and Support
![Page 28: Western Regional Air Partnership Emissions Database Management System January 2004 WRAP Technical Summit Phoenix, Arizona E.H. Pechan & Associates, Inc](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e165503460f94b006ab/html5/thumbnails/28.jpg)
E.H. Pechan & Associates, Inc.
Schedule
![Page 29: Western Regional Air Partnership Emissions Database Management System January 2004 WRAP Technical Summit Phoenix, Arizona E.H. Pechan & Associates, Inc](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e165503460f94b006ab/html5/thumbnails/29.jpg)
29
E.H. Pechan & Associates, Inc.
![Page 30: Western Regional Air Partnership Emissions Database Management System January 2004 WRAP Technical Summit Phoenix, Arizona E.H. Pechan & Associates, Inc](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e165503460f94b006ab/html5/thumbnails/30.jpg)
30
E.H. Pechan & Associates, Inc.
![Page 31: Western Regional Air Partnership Emissions Database Management System January 2004 WRAP Technical Summit Phoenix, Arizona E.H. Pechan & Associates, Inc](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e165503460f94b006ab/html5/thumbnails/31.jpg)
31
E.H. Pechan & Associates, Inc.
![Page 32: Western Regional Air Partnership Emissions Database Management System January 2004 WRAP Technical Summit Phoenix, Arizona E.H. Pechan & Associates, Inc](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e165503460f94b006ab/html5/thumbnails/32.jpg)
E.H. Pechan & Associates, Inc.
Communications
![Page 33: Western Regional Air Partnership Emissions Database Management System January 2004 WRAP Technical Summit Phoenix, Arizona E.H. Pechan & Associates, Inc](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e165503460f94b006ab/html5/thumbnails/33.jpg)
33
E.H. Pechan & Associates, Inc.
![Page 34: Western Regional Air Partnership Emissions Database Management System January 2004 WRAP Technical Summit Phoenix, Arizona E.H. Pechan & Associates, Inc](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e165503460f94b006ab/html5/thumbnails/34.jpg)
E.H. Pechan & Associates, Inc.
Concepts
![Page 35: Western Regional Air Partnership Emissions Database Management System January 2004 WRAP Technical Summit Phoenix, Arizona E.H. Pechan & Associates, Inc](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e165503460f94b006ab/html5/thumbnails/35.jpg)
35
E.H. Pechan & Associates, Inc.
Concepts
Data Take On – QA/QC
Import Staging Production
Data
Reporters
QA/QC3 times Gap-Filling
Data Adjusting
![Page 36: Western Regional Air Partnership Emissions Database Management System January 2004 WRAP Technical Summit Phoenix, Arizona E.H. Pechan & Associates, Inc](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e165503460f94b006ab/html5/thumbnails/36.jpg)
36
E.H. Pechan & Associates, Inc.
Concepts
Data Structure
2002
time
Planning
Sensitivity Run
Forecast
Version 2 Version 3 Version 4
2005
Each emissions sector is comprised of a unique set of tables
![Page 37: Western Regional Air Partnership Emissions Database Management System January 2004 WRAP Technical Summit Phoenix, Arizona E.H. Pechan & Associates, Inc](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e165503460f94b006ab/html5/thumbnails/37.jpg)
37
E.H. Pechan & Associates, Inc.
Concepts/GIS Interface
Feature Layers
Map
![Page 38: Western Regional Air Partnership Emissions Database Management System January 2004 WRAP Technical Summit Phoenix, Arizona E.H. Pechan & Associates, Inc](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e165503460f94b006ab/html5/thumbnails/38.jpg)
38
E.H. Pechan & Associates, Inc.
Concepts/GIS Zoom
![Page 39: Western Regional Air Partnership Emissions Database Management System January 2004 WRAP Technical Summit Phoenix, Arizona E.H. Pechan & Associates, Inc](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e165503460f94b006ab/html5/thumbnails/39.jpg)
39
E.H. Pechan & Associates, Inc.
Concepts/GIS Pan
![Page 40: Western Regional Air Partnership Emissions Database Management System January 2004 WRAP Technical Summit Phoenix, Arizona E.H. Pechan & Associates, Inc](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e165503460f94b006ab/html5/thumbnails/40.jpg)
40
E.H. Pechan & Associates, Inc.
Concepts GIS/Layers
![Page 41: Western Regional Air Partnership Emissions Database Management System January 2004 WRAP Technical Summit Phoenix, Arizona E.H. Pechan & Associates, Inc](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e165503460f94b006ab/html5/thumbnails/41.jpg)
41
E.H. Pechan & Associates, Inc.
Concepts GIS/Layers
![Page 42: Western Regional Air Partnership Emissions Database Management System January 2004 WRAP Technical Summit Phoenix, Arizona E.H. Pechan & Associates, Inc](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e165503460f94b006ab/html5/thumbnails/42.jpg)
42
E.H. Pechan & Associates, Inc.
Concepts GIS/Data Retreival
• Draw Polygon
• Select Database
• Select Sector(s)
• Select Sources (SCC, Name, etc…)
• Select Pollutant(s)
![Page 43: Western Regional Air Partnership Emissions Database Management System January 2004 WRAP Technical Summit Phoenix, Arizona E.H. Pechan & Associates, Inc](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e165503460f94b006ab/html5/thumbnails/43.jpg)
43
E.H. Pechan & Associates, Inc.
Concepts GIS/Data Display
![Page 44: Western Regional Air Partnership Emissions Database Management System January 2004 WRAP Technical Summit Phoenix, Arizona E.H. Pechan & Associates, Inc](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e165503460f94b006ab/html5/thumbnails/44.jpg)
E.H. Pechan & Associates, Inc.
End of Presentation