1 / 6

Data Manipulation Steps

Data Manipulation Steps. EPA’s 1996 U.S. Emissions Data. 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)

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