1 / 33

Spatial Patterns of US Criteria Pollutant Emissions: Analyzing EPA's 1996 Data

Explore EPA's 1996 emissions data, organize and reduce data in MS Access, analyze pollutant emissions by county, and map pollutants using ArcView for spatial variation understanding and future analysis.

mathilde-martinez
Télécharger la présentation

Spatial Patterns of US Criteria Pollutant Emissions: Analyzing EPA's 1996 Data

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Spatial Pattern of US Criteria Pollutant Emissions: EPA’s 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/net/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 ArcView’s 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. Total Annual Emissions

  14. Fuel Combustion

  15. Industrial Processes

  16. Transportation

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

  18. 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

More Related