Transcript CollectingEnteringNonpointSources.ppt

Collecting and Entering Data
for Nonpoint Sources
Melinda Ronca-Battista and
Angelique Luedeker
ITEP/TAMS Center
1
Homework Discussion
 Are there any questions on the homework of the list of
nonpoint sources and the data you need to collect for
those sources?
2
Common Nonpoint Sources
 Most Reservations Have These Sources
 Residential Heating
 Commercial Heating
 Paved Road Dust
 Unpaved Road Dust
 Gas Stations
3
Gathering Data
 Local data sources are usually the most accurate
 If you are not able to obtain data from local sources,
there are options of obtaining data from national sources,
such as the U.S. Census Bureau
 Usually, you can find these data online
4
Residential Heating Data Collection-Step 1
1. Determine what fuels are used
 Check with the tribal housing office
 Look online at U.S. Census Bureau data:
http://factfinder2.census.gov
5
Using U.S. Census Bureau FactFinder
 To find home heating fuel data
 In opening screen, select Guided Search, then Get Me
Started
6
U.S. Census Bureau FactFinder
 Check the “I’m looking for information about housing”
radio button, then click Next
7
U.S. Census Bureau FactFinder
 Expand Physical Characteristic entry by clicking on plus
sign
 Select Heating Fuel by clicking on it
 Then click Next
8
U.S. Census Bureau FactFinder
 Click on drop-down arrow of Select
a geographic type field
 Select American Indian Area/Alaska
Native Area/Hawaiian Home Land
 This brings up a list of tribes, click
on your tribe, click on Add To Your
Selections button, then click Next
9
U.S. Census Bureau FactFinder
 In this screen, click on Skip This Step button
 In the next screen, select most recent House Heating Fuel
dataset
10
U.S. Census Bureau FactFinder Results
 The House Heating Fuel table
comes up
 For this location, estimate
emissions for these fuel types:
 Utility gas (natural gas)
 Bottled, tank, or LP gas (LPG)
 Fuel Oil
 Wood
 Electricity does not produce
emissions at residential level
 Coal use is minimal in this area,
estimate of only 2 houses
11
Residential Heating Data Collection-Step 2
2. Look at TEISS calculators to determine what data you
need to collect
Each heating source calculator asks for amount of fuel
used reservation wide, remember to check units
Use the Print Blank option
If not clear on what to enter into a field, check source
documents referenced on opening screen of calculator




It is a good idea to read source documents before using
calculator
12
Residential Heating Data Collection-Step 3
3. Determine quantity of each fuel used reservation wide
 Check with tribal housing office or local fuel suppliers
 Conduct a survey


You might survey a few houses and use average response as
representative of the reservation per household value
Use 2009 Energy Information Administration (EIA) data:
http://www.eia.gov/consumption/residential/data/2009/i
ndex.cfm?view=consumption#fuel-consumption
13
EIA Data
 Find Fuel Consumption table for your area, click on XLS
icon to open it
14
EIA Data
 In spreadsheet
that opens, click
on Physical
Units tab to
open that
worksheet
 This shows
average per
household fuel
use based on
different
categories
15
Example: Natural Gas, Mostly Local Data
 Called local natural gas company and asked several
questions
 Q: In 2011 (inventory year), how much gas was sold to
reservation households?

A: 900,000 cubic feet of gas
 Q: What is the heating value of the gas you sell?



A: 980
Q: Can you specify the units of that value?
A: BTU/ft3
 Q: What is the sulfur content of the gas you sell?

A: I do not know
16
Example: Natural Gas Calculator
 Selected combustor
type of residential
furnaces
 Converted 900,000 ft3
to 0.9 million ft3
 Entered heating value
of 980 BTU/ft3
 No emission controls
for residential
 Left sulfur content
unknown selection
17
Example: Woodstoves, Some Local Data
 Surveyed 100 households on how much wood burned
annually per household, received 50 responses
 Entered responses into spreadsheet to calculate annual
average wood consumption per household of 1.2 cords
 House Heating Fuel table from U.S. Census reports 900
households on the reservation heat with wood
 Calculated reservation wide annual wood consumption
for residential heating as 1080 cords
 900 households x 1.2 cords/household = 1080 cords
18
Example: Woodstoves Calculator
 Selected units of cords
 Selected stove type of
catalytic, phase II based
on discussion with
housing office
 Selected wood type based
on local knowledge
 Entered amount of fuel
burned of 1080 cords
19
Example: LPG , No Local Data
 House Heating Fuel table from U.S. Census reports 335
households on the reservation heat with LPG
 EIA Data
 For this example, the reservation is located in Idaho
 EIA data reports a Q for Idaho LPG household consumption,
meaning data withheld
 Instead use value for Climate Region of Very Cold/Cold of
604 gallons/household
 Calculated reservation wide annual LPG consumption for
residential heating as 202,340 gallons
 335 households x 604 gal/household = 202,340 gallons
20
Example: LPG Calculator
 Selected LPG type of
propane based on local
knowledge
 Selected process of
residential use
 Converted 202,340 gal
to 202.34 thousand gal
 Left sulfur content
unknown selection
21
Internet Data for Other Sources
 Remember, local data is usually more accurate
 Commercial Heating
 The EIA also has commercial data at
http://www.eia.gov/consumption/commercial/data/2003/i
ndex.cfm?view=consumption


Includes energy intensity data for some fuel types, for
example, Table C35 shows average gallons/square foot values
for fuel oil
If you know the square footage of the building, you could
estimate the fuel usage
22
Internet Data for Other Sources (cont.)
 Road Dust
 Check state Department of Transportation or Department
of Motor Vehicles websites for traffic count data


Data for reservation roads might not be available, but might be
able to estimate traffic counts based on roads that are near
Traffic counts usually reported as average daily traffic (ADT)
counts
 Estimate total road lengths from maps
23
Internet Data for Other Sources (cont.)
 Gas Stations
 U.S. Census Bureau FactFinder Table EC0744A1 reports
number of gas stations and total sales value per county


In FactFinder Advanced Search, type in table number and
county
Select an Industry Code of 447
 Calculate an average sales value per gas station
 Divide average sales value by gasoline price per gallon to
estimate how much gasoline is sold per gas station
 This is a rough estimate
24
Homework due in 10 days:
 Collect data for a nonpoint source in your list of sources
to include in your EI
 If you cannot collect local data, estimate data from internet
sources
 Remember, you can always update your data in TEISS if you
can collect local data at some point
 Enter this source into the TEISS project that you started
for your reservation during first training
 Use the appropriate TEISS calculator to estimate
emissions for this source
 Email a TEISS report showing data entered to instructors
25