Spatial Pattern of US Criteria Pollutant Emissions:

1
Spatial Pattern of US Criteria Pollutant
Emissions

• EPAs 1996 U.S. Emissions Data

2
Part 1 BackgroundData Manipulation Steps
3
Get, File, and Interpret Data

• Find data EPA website 3 relevant files for
  criteria pollutants http//www.epa.gov/ttn/chief/n
  et/index.html
• MS Access (final size 2GB)
• Metadata 1996 NATIONAL EMISSION TRENDS (NET) PC
  INVENTORY FILE FORMAT
• Source Classification Code - Divisions
• County Location

4
1996 NATIONAL EMISSION TRENDS (NET) PC INVENTORY
FILE FORMAT
POINT SOURCE Example
etc.
5
Organizing Data

• Relationships
• continually designing build on queries
• one-to-many
• Append Data
• Reduce Data
• Make Table

6
List of Queries (MS Access 2000)
7
List of Tables (MS Access 2000)
8
Reducing Data

• Sum Pollutant by County, SCC-division
• First Group By location FIPSST FIPSCNTY
• Then Group By SCC_DIV
• Take Sum SO2_ANN

9
Make Table Query
10
ArcView

• Joined Data Tables with ArcViews County Files
• location code (connected to data) FIPS code
  (connected to shape file or pictorial
  representation of county)
• Mapped Pollutants (emission tons per unit area of
  county

11
Part 2 ResultsUnderstanding Spatial Variation
12
Maps

• Pollutants
• SO2, VOC, NOx, PM-10
• Categories
• Total, Fuel Combustion, Industrial Processes,
  Transportation
• Emission Unit
• Annual Tons/Sq.Mile by County

13
(No Transcript)
14
(No Transcript)
15
(No Transcript)
16
Total Annual Emissions
17
(No Transcript)
18
(No Transcript)
19
(No Transcript)
20
(No Transcript)
21
(No Transcript)
22
Fuel Combustion
23
(No Transcript)
24
(No Transcript)
25
Industrial Processes
26
(No Transcript)
27
(No Transcript)
28
Transportation
29
(No Transcript)
30
(No Transcript)
31
Industrial Emission Summary

• identified major contributors to criteria
  pollutants
• determined factors important in emissions
  estimates
• showed spatial distribution of pollutants based
  on source category

32
Future Analysis

• Connecting sources to US location to develop a
  better story
• Compare 1980 spatial distribution to 1996
  suggest CAUSALITIES
• Look at time trends for annual emissions
  comparison by source category, pollutant 1970-1998

33
(No Transcript)