1 / 6

Data Manipulation Steps

This guide outlines the steps for accessing and interpreting the 1996 U.S. emissions data from the EPA. It involves retrieving relevant files for criteria pollutants from the EPA website and utilizing MS Access for data manipulation. Key processes include organizing data by county and source classification codes, conducting queries, appending and reducing data, and grouping results by location and pollutant category. The integration of ArcView for mapping emissions and understanding spatial trends provides useful insights. This analysis contributes to recognizing major contributors to air pollution.

illana-christensen
Download Presentation

Data Manipulation Steps

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. Data Manipulation Steps EPA’s 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/net/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 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

  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

More Related