Data Manipulation Steps

1
Data Manipulation Steps

• EPAs 1996 U.S. Emissions Data

2
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

3
Organizing Data

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

4
Reducing Data

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

5
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

6
Future Analysis

• major contributors to criteria pollutants
• factors important in emissions estimates
• annual emissions comparison by source category,
  pollutant 1970-1998 http//www.epa.gov/ttn/chief/
  trends/trends98/tr98appa.xls
• understanding spatial trends