Transcript MngEIData.ppt

Elements of EI Data
Management
Melinda Ronca-Battista
ITEP/TAMS Center
1
Data management
is keeping track of
information used to
estimate emissions
2
The “answer”
you get from an EI is...
Sources of air pollution
Amount of air pollution from each source
3
The “answer” you get... (cont.)
Example
Residential woodstoves is a source of
emissions
10 tons per year of CO
50 tons per year of PM10
…and so on for other criteria pollutants
4
Data Management
Data management is describing
how you got those numbers
“Road map” to how you got answer
5
Data Management – How?
1. Keep information in notes, logbook
2. Include information in EI report
3. Store in spreadsheet or database, such as
TEISS
Use all three for complete Data Management
6
Calculators: Printing Blank Forms
Print and use as data collection sheets
Keep paper data collection forms on file!!
7
Data Management – Why?
Proves quality of your emission estimates
Helps when updating EI
Don’t have to redo/refigure everything
8
You start with...
Collected Data
For example, amount of wood burned for
residential heating (i.e., number of cords)
Types of stoves people are using
TEISS Tools
Emission factors
Equation that puts all these numbers
together to calculate your emissions estimate
9
Data Management: Records
How did you estimate #
cords burned for residential
heating?
Guessed based on personal
knowledge of your reservation
Used population and estimate of
percent of homes burning wood
Did survey to count woodstove
types and amount of wood burned
Data Quality
Least reliable

Most reliable
10
Data Management: Records (cont.)
Example formula
E = EF x (W x H x % x D)
Activity Data
E = emission rate
EF = emission factor for given pollutant
W = volume of wood burned annually for one
home
H = number of tribe households
% = percent houses heating with wood
D = Dry density of wood
11
Data Management: Records (cont.)
For each variable, identify source of variable
in notes, TEISS project, and EI, for
example:
EFs from EPA AP-42, fifth edition
If using TEISS calculators, look at opening screen of
TEISS calculator to find source of EFs
W from tribal housing office estimate
H and % from tribal housing office
D from EPA AP-42, Fifth edition
12
Data Management Report Example
Read the DataManagementReportEx
document
This document shows an example of
how to present data in an EI report
13
Data Management Spreadsheet
Example
Onscreen demonstration of the
spreadsheet associated with the report
example
14
Crucial Data
Collect the mandatory data elements, at
a minimum, for every source you
inventory
Having these data allows your tribal
sources to be included in
National Emission Inventory (NEI)
Regional air quality modeling
15
Data from Point Sources
Record the following information AT
MINIMUM
Name of facility
North American Industry Classification System
code (NAICS code)
Complete street address
Lat/long or UTM coordinates (with datum)
Start and end date of emission process
16
Data from Point Sources (cont.)
Source Classification Code (SCC)
Estimated emission for each inventoried
pollutant
Period of emission estimate (annual, weekly,
daily, etc.)
Specify units of emission estimate (tons/year,
lbs/month, etc.)
17
Point Source – Process Level
Best if broken down to process level because
it increases accuracy and usefulness of data
Example
Site: ABC Gravel Company
Units: Screening operation, excavating
operation
Processes: Loading, screening, output
Release points: stacks, vents, fugitive
Control devices and their efficiency
18
Processes Example:
Sand and Gravel Pit
Excavating
Operation
Emission
Units
Screening
Operation
Output
Screening
Loading
Emission
Processes
Release
Points
Control
Devices
Release
Points
Control
Devices
Release
Points
Control
Devices
19
Nonpoint and Mobile Sources
Record the following information AT MINIMUM
SCC
Period of emission estimate (usually annual)
Estimated emission for each inventoried pollutant
Specify units of emission estimate (tons/year,
lbs/month, etc.)
20
Data Management Summary
Describe in notes, TEISS project, and EI
WHAT you are calculating
HOW you calculated emissions estimate
WHERE you got data
WHEN you collected data
WHO you got your data from
Include mandatory data for NEI
21
TEISS QA/QC Tools
Place to document
data sources
Can automatically list
frequently entered names
Documents QA checks
22
QA/QC Report
• If multiple users established,
can show who modified data
• Add users from File,
Administration, Define
Groups/Users
23
Homework due in 5 days:
Read the Bishop Paiute Tribe EI to get a sense of what
is included in a Level 1, 2, or 3 EI.
Answer the questions in the
Homework_DataManagement document.
Email your answers to the instructors.
24