collecting and entering data for nonpoint sources n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Collecting and Entering Data for Nonpoint Sources PowerPoint Presentation
Download Presentation
Collecting and Entering Data for Nonpoint Sources

Loading in 2 Seconds...

play fullscreen
1 / 25

Collecting and Entering Data for Nonpoint Sources - PowerPoint PPT Presentation


  • 118 Views
  • Uploaded on

Collecting and Entering Data for Nonpoint Sources. Melinda Ronca-Battista and Angelique Luedeker ITEP/TAMS Center. 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?. Common Nonpoint Sources.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Collecting and Entering Data for Nonpoint Sources' - hayden


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
collecting and entering data for nonpoint sources

Collecting and Entering Data for Nonpoint Sources

Melinda Ronca-Battista and Angelique Luedeker

ITEP/TAMS Center

homework discussion
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?

common nonpoint sources
Common Nonpoint Sources

Most Reservations Have These Sources

Residential Heating

Commercial Heating

Paved Road Dust

Unpaved Road Dust

Gas Stations

gathering data
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

residential heating data collection step 1
Residential Heating Data Collection-Step 1

Determine what fuels are used

Check with the tribal housing office

Look online at U.S. Census Bureau data: http://factfinder2.census.gov

using u s census bureau factfinder
Using U.S. Census Bureau FactFinder

To find home heating fuel data

In opening screen, select Guided Search, then Get Me Started

u s census bureau factfinder
U.S. Census Bureau FactFinder

Check the “I’m looking for information about housing” radio button, then click Next

u s census bureau factfinder1
U.S. Census Bureau FactFinder

Expand Physical Characteristic entry by clicking on plus sign

Select Heating Fuel by clicking on it

Then click Next

u s census bureau factfinder2
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

u s census bureau factfinder3
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

u s census bureau factfinder results
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

residential heating data collection step 2
Residential Heating Data Collection-Step 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

residential heating data collection step 3
Residential Heating Data Collection-Step 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/index.cfm?view=consumption#fuel-consumption

eia data
EIA Data

Find Fuel Consumption table for your area, click on XLS icon to open it

eia data1
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

example natural gas mostly local data
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

example natural gas calculator
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

example woodstoves some local data
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

example woodstoves calculator
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

example lpg no local data
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

example lpg calculator
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

internet data for other sources
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/index.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

internet data for other sources cont
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

internet data for other sources cont1
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

homework due in 10 days
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