Point and Area Source Pivot Tables for Regional Haze Planning Emissions Scenarios
|| PRP 18b
|| Plan 02d (01/14/08) Point Source Emissions-Pivot Table ZIP (13.6 MB)
||PRP18b (10/16/09) Point Source Emissions-Pivot Table ZIP (13 MB)
||Plan 02d (03/20/08 revision) Area Source Emissions-Pivot Table XLS (1.7 MB)
||PRP18b (07/23/09) Area Source Emissions-Pivot Table XLS (1.7 MB)
|| Base 18b
|| Plan 02c (12/21/05) Point Source Emissions (Version 1)-Pivot Table ZIP (12.3 MB)
||Base 18b (12/21/05) Point Source Emissions (Version 1)-Pivot Table ZIP (15.1 MB)
|| Plan 02c (12/21/05) Area Source Emissions (Version 1)-Pivot Table XLS (1.6 MB)
||Base 18b (12/21/05) Area Source Emissions (Version 1)-Pivot Table XLS (1.6 MB)
Older 2018 Preliminary Reasonable Progress PRP18a Files (for historical reference only)
|PRP 18a (Point)
|| PRP 18a (Area)
|PRP18a (Revised 11/14/07) Point Source Emissions-Pivot Table ZIP (15.6 MB)
||PRP18a (Revised 11/14/07) Area Source Emissions-Pivot Table XLS (1.3 MB)
These “Pivot Table” spreadsheets allow the user to "drill down" into various versions of the WRAP stationary point and area source Emission Inventories for more detail on specific state, pollutant, and source category emission totals (point source pivot table allows the user to drill down to the plant level). See the README worksheets in each spreadsheet for more information.
It should be noted that these Pivot Tables are based on Source Classification Codes (SCC’s) designations, and for Point Sources, there may be more than one SCC assigned to any particular facility. Thus to obtain total emissions for any particular facility, it is necessary to sum emissions from all applicable SCC codes at that facility.
DESCRIPTIONS OF PIVOT TABLE INVENTORIES
(In Chronological Order of Inventory Development)
Original VERSION 1 - 2002 “Plan 02c” Point and Area Source Pivot Tables (12/21/05)
The original VERSION 1 pivot tables contain summaries of the 2002 and 2018 stationary point and area source emission inventories developed by Eastern Research Group, Inc. (ERG) in 2005. These inventories evolved from States’ actual emissions data submitted to the EPA for the 2002 National Emission Inventory (‘02 NEI). The WRAP compiled and checked the NEI data several times (Plan 02a, Plan 02b, Plan 02c), solicited review from individual States and then corrected errors noted in State responses. In 2005 the WRAP also coordinated the first ever Oil & Gas field operations area source inventory through ENVIRON International (ENVIRON), and these O&G area source emissions are incorporated into the Plan 02c Pivot Tables, as well. PDF (1/27/06 ERG Technical Memo)
The “Plan” designation comes from the fact that a five year average Fire total is included in the inventories to ameliorate the bias effects of 2002 year specific meteorology and fire incidents (2002 was a hot, fire prone year). However these Pivot Tables do not include fire data, and thus represent actual 2002 emissions data for point and area sources only.
Original VERSION 1 - 2018 “Base 18b” Point and Area Source Pivot Tables (12/21/05)
The Base 18b original VERSION 1 pivot tables contain summaries of 2018 stationary point and area source emission inventories projected from the Plan 02c inventory. PDF (1/25/06 ERG Technical Memo)
The projection methodology included the following steps:
- Emissions for new facilities that have come on-line since 2002
- Corrections for facilities that retired in 2003 or 2004 and will not return to operation in the future
- Other (i.e., ratios to correct certain PM10 and PM2.5 emission factors/SCC’s for combustion of natural gas)
- Control Factors: Emission reductions due to known (i.e., on-the-books) controls, consent decrees reductions, SIP control measures, and other relevant regulations that have gone into effect since 2002, or will go into effect before the end of 2018. These controls do not include impacts from any future control scenarios that have yet to be determined.
- Growth Factors: SCC-specific growth factors developed from the EGAS projection factor model; special analysis of EGU growth relative to unit capacity threshold.
- Retirement & Replacement Rates: Effects of retirement estimated using annual retirement rates based on expected equipment lifetimes. Retired equipment replaced by lower-emitting new equipment. Unit lifetimes examined for natural gas-fired EGU’s. No retirements assumed for coal-fired EGU’s.
- Permit Limits: Used in the cases where the projected emissions may have inadvertently exceeded an enforceable emission limit (i.e., emissions were adjusted downward to the permit limit, as applicable).
- Section §309 Flags: Point sources in the Grand Canyon Visibility Transport States (i.e., AZ, CA, CO, ID, NV, NM, OR, UT, and WY) whose 2002 facility-level SO2 emissions are at least 100 tons/year.)
2018 “PRP 18a” Point and Area Source Pivot Tables (11/14/07)
The objective of this project was to provide the technical basis for making preliminary evaluations of reasonable progress toward individual Class I area visibility goals by the Western Regional Air Partnership (WRAP). This was done by updating the WRAP region 2018 point and area sources emission inventory projections from the 2018 Base Case Version 1 project, completed by ERG in January 2006 (the PRP 18a update was done using conference calls with individual state air agencies to establish the most representative source-specific emissions projections data as the basis for preparing regional haze plans). The resulting emissions inventory is the WRAP region Preliminary Reasonable Progress emissions inventory for 2018 (PRP 18a). PDF (06/18/07 ERG Technical Memo)
The PRP 18a inventory revisions included the following elements:
- Addressed State/Local Agency comments on the Base 18b inventory (ie/ fixed missing SCC’s, changed facility names, added new sources, removed inactive sources, etc.)
- Corrected EGU Facility ID’s for those EGU’s reporting to EPA’s Clean Air Markets Division (CAMD) acid rain database, and added missing EGU source records
- Revised EGU projections of future coal fired EGU construction (used EIA projections of 2018 energy requirements - determined existing WRAP region capacity to identify total new requirements - added existing State/Local agency EGU permits - added 11 new “Model” 500MW EGU units operating at BACT levels)
- Applied NOx & SO2 BART emission limits to “Subject to BART” coal fired where known (very limited universe of permits completed at the time)
- Applied “presumptive” SO2 BART requirements to coal fired EGU’s determined to be “BART-eligible” or “Subject to BART”.
- No BART assumptions incorporated for the Non-EGU universe of “BART-eligible” or “Subject to BART” sources.
- Incorporated 2007 ENVIRON revisions to WRAP Region Oil & Gas point and area source emissions
- Incorporated 2006 Pechan and Associates updates to 2018 SO2 emission projections for Non-Utility Point Sources
Revised 2002 “Plan 02d” Point and Area Source Pivot Tables (01/14/08 & 03/20/08)
The objective of this project was to make final revisions to the 2002 WRAP emissions inventory for regional haze planning and modeling purposes. This revision is referred to as the Plan 02d emissions inventory. PDF (01/10/08)
The focus was to address specific changes in these areas:
- Address any remaining 2002 issues that were deferred from the WRAP 2018 Preliminary Reasonable Progress Emissions Inventory (PRP18) conducted in May 2007;
- Update the current status of point sources related to the Best Available Retrofit Technology (BART) requirements under the regional haze rule; and
- Correct erroneous or missing Standard Industrial Classification (SIC) and/or source classification code (SCC) codes.
2018 “PRP 18b” Point and Area Source Pivot Tables (10/16/09 revised*)
* Revised final memorandum includes revised emissions estimates for the Otter Tail Power Company – Big Stone I and Big Stone II facilities located in South Dakota. Tables 8c, 8e and 8f, and the table on Page A1-20 were affected.
The objective of this project was to make a second revision to the 2018 emissions inventory projections for point and area sources in the WRAP region to provide a more current assessment of the reasonable progress toward visibility goals by the WRAP. The focus of this project was to address specific changes that have occurred since completion of the PRP 18a inventory in 2007. The resulting product is the second version of the WRAP region Preliminary Reasonable Progress emissions inventory for 2018, known as PRP 18b. PDF (10/16/09 ERG Technical Memo).
The PRP 18b inventory revisions included the following elements:
- Included all updated BART information available:
- Incorporated all available formal BART determinations;
- Made and incorporated estimates of expected BART control levels where BART determinations had not been finalized (BART estimates made for both SO2 and NOx);
- Addressed all “BART-eligible” or “Subject to BART” sources, both for EGU’s and for the Non-EGU universe;
- Revised projections of “future” fossil-fuel plants needed to meet federal electrical generation demand forecasts in 2018 (used updated EIA projections of 2018 energy requirements – for the first time incorporated Renewable Energy Portfolios where available - determined that existing WRAP region electric generating capacity, when added to existing State/Local agency EGU permits, was sufficient to meet 2018 demand without addition of any new future EGU units);
- Incorporated all new rulemaking, permit limits, and consent decrees instituted since 2007; and
- Corrected other outstanding issues that were identified by the federal, state, or local agencies within the WRAP domain as needing to be revised/updated:
- Modification of various inventory data to be consistent with the Plan 02d emissions inventory (name changes, updated stack parameters, new or removed sources, etc.)
- Revision of a limited number of area source categories (i.e., fuel combustion emissions in South Dakota and California, gasoline distribution emissions in Idaho, residential wood combustion emissions in Washington, construction dust in [Clark County] Nevada).
- Revision of facility information (e.g., facility IDs, facility names, unit IDs, process IDs, SCCs, SICs, etc.) based upon agency input.
- Revision of stack parameters based upon agency input.
- Addition of WRAP Phase II oil and gas project emissions to PRP 18a Area Source Emission Summaries in order to provide relevant comparisons to the emission totals in PRP 18b which also contained O&G emission totals.