Electricity generation is the dominant industrial source of air emissions in the United States today. Whenever you switch on an electrical appliance, chances are you are contributing to air pollution and greenhouse gas emissions. By documenting the environmental attributes of electric power generation, eGRID can help consumers to better understand the relationship between electricity and the environment. In the United States, electricity is generated in many different ways, with a wide variation in environmental impacts. In many states, power companies are required to disclose the environmental attributes of their retail electricity products. Many consumers now have a choice regarding the source of their electricity, and some seek cleaner sources, such as wind and solar power. Data from eGRID underlies EPA's Power Profiler application, which enables individual consumers to identify the environmental impacts of their own electricity usage. Power Profiler will soon be updated with the most current eGRID data.
For policymakers, eGRID data can be used to support the following activities:
* Greenhouse gas registries and inventories, * Consumer information disclosure, * Renewable portfolio standards, * Development of emissions inventories and emission standards, * Analysis of changing power markets, and * Estimation of avoided emissions.
UPDATE: (October 16, 2008): eGRID2007 Version 1.0 is released.
The Emissions & Generation Resource Integrated Database (eGRID) is a comprehensive inventory of environmental attributes of electric power systems. The preeminent source of air emissions data for the electric power sector, eGRID is based on available plant-specific data for all U.S. electricity generating plants that provide power to the electric grid and report data to the U.S. government. eGRID contains air emissions data for nitrogen oxides (NOx), sulfur dioxide (SO2), carbon dioxide (CO2), mercury (Hg), and new this year, methane (CH4) and nitrous oxide (N2O).
eGRID2007 Version 1.0
eGRID2007 Version 1.0 (ZIP) (17.0 MB) contains the complete release of year 2005 data, as well as year 2004 data contained in eGRID2006 Version 2.1 that was released in Spring 2007. The year 2005 data are organized to reflect the operator, parent company, owner, and electric grid configuration as of December 31, 2007. The year 2004 data are unchanged.
For year 2005 data, the first Microsoft Excel workbook, Plant, contains boiler, generator, and plant spreadsheets. The information includes fuel consumption, emissions and emission rates, and generation and resource mix; along with plant identification, location, and structural information for nearly all electric generators in the United States.
The second Microsoft Excel workbook, Aggregation, contains aggregated data by state, electric generating company, parent company, power control area, eGRID subregion, NERC region, and U.S. total levels. Total emissions and emission rates, and total generation and resource mix are displayed for each of these levels.
The third Microsoft Excel workbook, ImportExport, contains state import-export data as well as U.S. generation and Consumption data for both 2004 and 2005; similar files were in eGRID2002, but not in eGRID2006.
The three Microsoft Excel workbooks can be downloaded in the ZIP file below. Full documentation, summary data, an eGRID subregion representational map, and a NERC region representational map, are also released in this edition.
eGRID2007 Version 1.0 contains the eGRID data in three Microsoft Excel workbooks, the Technical Support Document in one Adobe PDF file, and Summary Tables in a second Adobe PDF file. The Technical Support Document describes the sources and uses of data, the methodologies used for estimating emissions, changes from previous editions, all the data files and data elements (in the file structure), and other information.
In early 2009, a new data interface for eGRID will be launched that will make it easier to view eGRID data.
EPA welcomes comments on this version of eGRID. If you have any general comments or wish to express the value of this information to you, please use the eGRID feedback form.
The fourth edition, eGRID2002 Version 2.01, containing year 1996 through 2000 data is located on the eGRID Archive page.
For questions about eGRID, contact Art Diem at 202-343-9340, or provide us your feedback on eGRID.
Year 1996-2000 data can be downloaded from the eGRID Archive page.
The Emissions & Generation Resource Integrated Database (eGRID) is a comprehensive inventory of environmental attributes of electric power systems. The preeminent source of emissions data for the electric power sector, eGRID is based on available plant-specific data for all U.S. electricity generating plants that provide power to the electric grid and report data to the U.S. government. Data reported include generation in megawatt-hour (MWh); resource mix (for renewable and nonrenewable generation); emissions in tons for nitrogen oxides (NOx,), sulfur dioxide (SO2), and carbon dioxide (CO2); emissions in pounds for mercury (Hg); emission rates for CO2, NOx, and SO2 (in both pounds per megawatt-hour [lb/MWh]) and pounds per million British thermal unit [lb/MMBtu]) and for mercury (in pounds per gigawatt-hour [lb/GWh] and pounds per billion Btu [lb/BBtu]); heat input in MMBtu; and nameplate capacity in megawatts (MW). eGRID reports this information on an annual basis (as well as by ozone season for NOx emissions, generation, and heat input) at different levels of aggregation (boiler, generator, plant, companies, and grid regions of the country).
eGRID2007 Version 1.0 contains the eGRID data in three Microsoft Excel workbooks, the Technical Support Document in one Adobe PDF file, and Summary Tables in a second Adobe PDF file. The Technical Support Document describes the sources and uses of data, the methodologies used for estimating emissions, changes from previous editions, all the data files and data elements (in the file structure), and other information.
<http://www.epa.gov/cleanenergy/energy-resources/egrid/index.html>
For more information on eGRID please see the following US EPA documentation: eGRID2007TechnicalSupportDocument.pdf
There are 158 variables in PLNT05. Some data may be outliers and should be viewed with caution.
The newest and sixth edition of eGRID, eGRID2007 Version 1.0, was released in September 2008, published in October 2008, and includes three Excel workbooks with year 2005 data. The year 2004 data are the same as those included in eGRID2006. The three workbooks consist of 12 year 2005 data files -- boiler, generator, plant, State, EGC location (operator)- and owner-based, parent company location (operator)- and owner-based, power control area, eGRID subregion, and NERC region as well as the State Import-Export files years 2004 and 2005 and a U.S. generation and consumption file for years 2004 and 2005. A web-based eGRID user friendly application is planned for release in 2009. eGRID2007s date in the name represents the year that the industry data are adjusted to. eGRID2007s year 2005 data have been reconfigured to reflect the industrys current structure as was known by December 31, 2007, including plant ownership and operators, parent company affiliations, company mergers, and grid configurations.
Although eGRID is based on more than existing Federal data sources, its development required substantial attention to quality control. Accurate matching of entities from different databases required great care, even where identification codes were available. Inconsistencies between data sources, missing data, and ambiguous data necessitated adjustments to values of individual data elements, especially identification data. In general, however, questionable data have not been altered, except with regard to the relationship of plants to the power grid.
The 12 eGRID2007 aggregation files are: BLR (boiler), with 4,866 year 2005 records; GEN (generator), with 16,306 year 2005 records; PLNT (plant), with 4,998 year 2005 records with non-zero generation and/or heat input; ST (State), with 51 year 2005 records; EGCL and EGCO (electric generating company), with 1,667 year 2005 records for the location (operator)-based file and 1,898 year 2005 records for the owner-based file, respectively; PRCL and PRCO (parent company), with 97 year 2005 records in the location (operator)-based file and 101 year 2005 records in the owner-based file, respectively; PCAL (power control area), with 112 year 2005 records in the location (operator)-based file; SRL (eGRID subregion), with 26 eGRID subregion year 2005 records in the location (operator)- based file; NRL (NERC region), with 10 NERC region year 2005 records in the location (operator)-based file; and US, with 1 year 2005 U.S. totals record.
The number of variables in each of the 12 aggregation files varies, with 34 in BLR, 15 in GEN, 158 in PLNT, 109 in ST, 111 in EGCL and EGCO, 109 in PRCL and PRCO, 109 in PCAL, 110 in SRL, 109 in NRL, and 107 in US. The first variable in each file is a unique sequence number for that file. The boiler file is sorted by State postal code abbreviation, plant name, plant code, and boiler ID. The generator file is sorted by State postal code abbreviation, plant name, plant code, and generator ID. The plant file is sorted by State postal code abbreviation, plant name, and plant code. The State file is sorted by State postal code abbreviation. The two electric generating company files are sorted by electric generating company name, the two parent company files are sorted by parent company name, the power control area file is sorted by power control area name, the eGRID subregion file is sorted by eGRID subregion name, and the NERC region file is sorted by NERC region acronym.
In this edition of eGRID, Import-Export Files for years 2004 and 2005 and the Generation and Consumption file for the U.S have been included in a third workbook; similar files were in eGRID2002, but not in eGRID2006.
The file structure for all the year 2005 files is included in Appendix A. The file structure also includes a description of the variables and the original data sources. The file structure indicates which variables in year 2005 are new or different from those in year 2004.
Next GeoPlan imported the eGRID2007 Version 1 - eGRID2007V1_0_year05_plant.xls - PLNT05 excel workbook sheet into ArcMap.
The PLNT05 excel workbook sheet contains electricity generation plants, with 4,998 year 2005 records with non-zero generation and/or heat input for the entire country.
The PLNT05 excel workbook sheet was then exported from ArcMap as a Database table.
Next the newly created PLNT05.DBF was spatially mapped using the LAT and LONG fields containing decimal degrees to 4 decimal places spatial information.
Next the newly created PLNT05.SHP's projection was defined as GCS_WGS_1984, and then it was reprojected to the FGDL Albers NAD 83 HARN projection.
Next a selection was performed on the State FIPS ID field where as it was equal to 12 (i.e. the State of Florida). Several other power plants that skirted the Florida border were also included.
Next the selection was exported to a new shapefile called EPAEGRID_DEC07.SHP
Next all of the field information was Upper Cased, fields containing no information were deleted, and six fields were added; - NOTES - NUCLEAR - FL_USNG_1K - DESCRIPT based on PNAME. - FGDLAQDATE based on the date the data was downloaded from the Source.
Furthermore, the GIS data available in the FGDL are provided 'as is'. The University of Florida GeoPlan Center makes no warranties, guaranties or representations as to the truth, accuracy or completeness of the data provided by the data sources. The University of Florida GeoPlan Center makes no representations or warranties about the quality or suitability of the materials, either expressly or implied, including but not limited to any implied warranties of merchantability, fitness for a particular purpose, or non-infringement. The University of Florida GeoPlan Center shall not be liable for any damages suffered as a result of using, modifying, contributing or distributing the materials.
A note about data scale:
Scale is an important factor in data usage. Certain scale datasets are not suitable for some project, analysis, or modeling purposes. Please be sure you are using the best available data.
1:24000 scale datasets are recommended for projects that are at the county level. 1:24000 data should NOT be used for high accuracy base mapping such as property parcel boundaries. 1:100000 scale datasets are recommended for projects that are at the multi-county or regional level. 1:125000 scale datasets are recommended for projects that are at the regional or state level or larger.
Vector datasets with no defined scale or accuracy should be considered suspect. Make sure you are familiar with your data before using it for projects or analysis. Every effort has been made to supply the user with data documentation. For additional information, see the References section and the Data Source Contact section of this documentation. For more information regarding scale and accuracy, see our webpage at: <http://geoplan.ufl.edu/education.html>