Point Comparison - Facility Level Report
The Point Comparison - Facility Level Report provides emissions data aggregated to a State/Tribe geographic level in a flat file CSV format. A user can filter by pollutant, geographic area, Facility Source Type, NAICS, regulations, sector or Source Classification Codes.
The following report criteria are required when generating a State/Tribe By Source Classification Report
Report Criteria
- Baseline Dataset (One EPA Dataset plus one or more S/L/T Datasets can be
selected)
- Comparison Dataset (One EPA Dataset plus one or more S/L/T Datasets can be
selected)
- Pollutant
The following filters are available to select from within the accordion style tables: (Filter Name – Table Column Headings)
Available Filters
- Baseline Data Set (Required) - Inventory Year and Data Set Name/Data Set Short Name
- Comparison 1 ( Required)
- Comparison 2
- Comparison 3
- Comparison 4
- Geographic Locations - Type, Code, Geographic Description
- Pollutants (Required)
- Data Categories
- Sectors
- Source Classification
- Facility Type
- NAICS
- Reporting Periods
- Tagged Data Handling - Tagged, Not Tagged
- Emissions Operating Type
The following Columns will always be defaulted and included at a minimum in the report
Defaulted and Included
- State
- FIPS State Code
- Tribal Name
- FIPS Code
- County
- EIS Facility ID
- Program System Code
- Agency Facility ID
- Company Name
- Site Name
- Site Latitude
- Site Longitude
- Reporting Period
- Emissions Operating Type
- Pollutant Code
- Pollutant Description
- Emissions UOM
- Sum of Baseline Emissions
- Sum Comparison 1 Emissions
- Sum Comparison 2 Emissions
- Sum Comparison 3 Emissions
- Sum Comparison 4 Emissions
Columns in the Point Comparison - Facility Level Report
Column Header | Database Definition | Output Sample Value | Defaulted | Required |
---|---|---|---|---|
EPA Region Code | Code that identifies the EPA region. | 4 | No | No |
State | All alphabetic codes assigned by the U.S. Postal Service that represent the states of U.S. and Canada. | “NC” | Yes | No |
FIPS State Code | Numeric codes representing all states, outlying areas of the United States, freely associated states, and trust territories of the United States, as listed in FIPS publication 10-4 | “01” | Yes | No |
Tribal Name | Name of the American Indian or Alaskan Native entity. | “Eastern Band of Cherokee Indians” | Yes | No |
FIPS Code | Numeric codes representing all states, outlying areas of the United States, freely associated states, and trust territories of the United States, as listed in FIPS publication 10-4 | “01001”; “88435” (“88” proceeded by tribal code) | Yes | No |
County | Identifier of a county type | “Alamance” | Yes | No |
EIS Facility ID | Unique identifier of an EIS facility site record. This identifier is assigned by the EIS and is unique within the inventory. | 123411 | Yes | Yes |
Program System Code | The code that identifies the lookup value to be reported. | "NCDAQ" | Yes | No |
Agency Facility ID | A unique sequence identifier assigned by the EIS. This data in this column is not made public. | “12345” | Yes | No |
Affiliation Type | Code that identifies the function that an organization or individual serves, or the relationship between an individual or organization and the facility site. | “OW” | No | No |
Company Name | The name of the legal entity or company that owns or operates the facility. | “ACME Power Plant” | Yes | No |
Site Name | The name assigned to the facility site by the reporting agency. This is the public or commercial name (i.e., the full name that commonly appears on invoices, signs, or other business documents, or as assigned by the state when the name is ambiguous). | “Summerville ACME Power Plant” | Yes | No |
Primary NAICS Code | The NAICS code indicates the industry classification/activity or subdivision of an industry for a facility site. | “326211” | No | No |
Primary NAICS Description | Description of industrial activity (NAICS code) for a facility site. | “Tire manufacturing” | No | No |
Secondary NAICS | A secondary operation performed by the facility described by codes from the North American Industry Classification System (NAICS). | 12345&4566&9234 | No | No |
Tertiary NAICS | A tertiary operation performed by the facility described by codes from the North American Industry Classification System (NAICS). | 2345&3245 | No | No |
Facility Source Type | Description of facility source type code. | “Compressor Station” | No | No |
Site Latitude | The measure of the angular distance on a meridian north or south of the equator. | 40.579 | Yes | No |
Site Longitude | The measure of the angular distance on a meridian east or west of the prime meridian. | -122.82 | Yes | No |
Site Coordinates Protected? | Property restricts users from modifying protected data when enabled. | No | No | No |
Coordinate Comment | Any comments regarding the reported data. | “Sample comment for the coordinates” | No | No |
Address | The address that describes the physical (geographic) location of the front door or main entrance of a facility site, including urban-style street address or rural address. | “123 Maple Lane” | No | No |
City | The name of the city, town, village, or other locality, when identifiable, within whose boundaries the facility site is located. | “Springfield” | No | No |
Zip Code | The combination of the five-digit Zone Improvement Plan (ZIP) code and the four digit extension code assigned by the U.S. Postal Service to a geographic location. | 27519 | No | No |
Postal Abbreviation | All alphabetic codes assigned by the U.S. Postal Service that represent the states of U.S. and Canada. | “NC” | No | No |
Address Comment | Any comments regarding the reported data. | “Sample comment for the address” | No | No |
Facility Comment | Any comments regarding the reported data. | “Shuts Down During the Summer” | No | No |
Facility Status | Code that identifies the operating status of the facility site during the reporting period. | OP | No | No |
Facility Status Year | The year in which a status or code changed or is no longer effective. | 2010 | No | No |
EIS Unit ID | A unique sequence identifier assigned by the EIS. This data in this column is not made public. | 2504613 | Yes | Yes |
Agency Unit ID | A unique sequence identifier assigned by the EIS. This data in this column is not made public. | “ABC12” | Yes | No |
Unit Type | Code that identifies the type of emissions unit. | Kiln | Yes | No |
Unit Description | Description of unit type code. | “wood/coal/finishing material-fired boiler (35 million Btu per hour maximum permit)” | No | No |
Design Capacity | The measure of the size of the unit based on the maximum continuous throughput capacity of the unit. | 1990 | No | No |
Design Capacity UOM | The code that identifies the lookup value to be reported. | HP | No | No |
Unit Comment | Code that identifies the operating status of the unit during the reporting period. | “Second Unit at site” | Yes | No |
Unit Status | The year in which a status or code changed or is no longer effective. | OP | No | No |
Unit Status Year | The year in which a status or code changed or is no longer effective. | 2005 | No | No |
EIS Process ID | A unique sequence identifier assigned by the EIS. This data in this column is not made public. | 4318014 | Yes | Yes |
Agency Process ID | An identifier provided by the S/L/T agency that identifies a process in that agency's local emissions inventory system. | P002 | Yes | No |
AETC | Aircraft Engine Type Code. Identifies the combination of aircraft and engine type for airport emissions. | 200017 | Yes | No |
SCC | Source classification code, which identifies the major industrial classification of a source. | 10200906 | Yes | No |
SCC Level - 1 | Description of first tier of SCC. | “External Combustion Boilers” | No | No |
SCC Level - 2 | Description of second tier of SCC. | Industrial | No | No |
SCC Level - 3 | Description of third tier of SCC. | “Wood/Bark Waste” | No | No |
SCC Level - 4 | Description of fourth tier of SCC. | “Wood-fired Boiler (< 50,000 Lb Steam)” | No | No |
Sector | Stores sector code used for classifying SCCs to groups | “Fuel Comb - Industrial Boilers, ICEs – Biomass” | No | No |
Reg Code | Code that identifies the federal regulatory program or rule. | 59C | No | Yes |
Reg Code Type | Identifies the sub-type of federal regulatory code. | 183(e) | No | No |
Reg Code Description | Description of regulatory code. | Autobody Refinish Coatings (VOC Rule) | No | No |
Process Description | A text description of the emissions process. | “Second Process at Site” | No | No |
Process Comment | Any comments regarding the reported data. | “Comment for Unit_1 Process_1” | No | No |
Process Status | Code that identifies the operating status of the emissions process. | OP | No | No |
Process Status Year | The year in which the process status became applicable. | 2013 | No | No |
Reporting Period | Code that identifies the time frames available for the reported emissions data. | A | Yes | No |
Emissions Operating Type | Code that identifies the operating state for the emissions being reported. | R | Yes | Yes |
Pollutant Code | Unique identifier of an EIS pollutant code record. | PM25-FIL | Yes | Yes |
Pollutant Description | Description of the pollutant for which emissions are reported. | PM2.5 Filterable | Yes | No |
Pollutant Type(s) | Identifies the major grouping of the pollutant code. | HAP | No | No |
HAP Type | The code that identifies the lookup value to be reported. | HAP-VOC | No | No |
Emissions UOM | Unit of measure for reported emissions. | TON (Always expressed in terms of “Standard Unit” for pollutant) | Yes | Yes |
Sum of Baseline Emissions | The aggregate sum of emissions for the selected baseline data set. | 123.45 | Yes | Yes |
Sum Comparison 1 Emissions | The aggregate sum of emissions for the selected comparison 1 data set. | 123.57 | Yes | Yes |
Count Comparison 1 Emissions | The number of emissions values that compose the aggregate sum of emissions for the comparison 1 data set. | 2 | No | No |
Ratio 1 | Sum Comparison 1 Emissions / Sum Baseline Emissions. Sum Comparison 1 Emissions and Sum Baseline Emissions values must both be valued. | 0.99 (rounded to 2 DP) | No | No |
Difference 1 | Sum Comparison 1 Emissions - Sum Baseline Emissions. Sum Comparison 1 Emissions and Sum Baseline Emissions values must both be valued. | -0.12 | No | No |
Absolute Difference 1 | | Sum Comparison 1 Emissions - Sum Baseline Emissions |. Sum Comparison 1 Emissions and Sum Baseline Emissions values must both be valued. | 0.12 | No | No |
Percent Difference 1 | ((Sum Comparison 1 Emissions - Sum Baseline Emissions) / Sum Baseline Emissions) * 100. Sum Comparison 1 Emissions and Sum Baseline Emissions values must both be valued. | 5.3 (rounded to 1 DP) | No | No |
Sum Comparison 2 Emissions | The aggregate sum of emissions for the selected comparison 2 data set. | 123.57 | Yes | Yes |
Count Comparison 2 Emissions | The number of emissions values that compose the aggregate sum of emissions for the comparison 2 data set. | 2 | No | No |
Ratio 2 | Sum Comparison 2 Emissions / Sum Baseline Emissions. Sum Comparison 2 Emissions and Sum Baseline Emissions values must both be valued. | 0.99 (rounded to 2 DP) | No | No |
Difference 2 | Sum Comparison 2 Emissions - Sum Baseline Emissions. Sum Comparison 2 Emissions and Sum Baseline Emissions values must both be valued. | -0.12 | No | No |
Absolute Difference 2 | | Sum Comparison 2 Emissions - Sum Baseline Emissions |. Sum Comparison 2 Emissions and Sum Baseline Emissions values must both be valued. | 0.12 | No | No |
Percent Difference 2 | ((Sum Comparison 2 Emissions - Sum Baseline Emissions) / Sum Baseline Emissions) * 100. Sum Comparison 2 Emissions and Sum Baseline Emissions values must both be valued. | 5.3 (rounded to 1 DP) | No | No |
Sum Comparison 3 Emissions | The aggregate sum of emissions for the selected comparison 3 data set. | 123.57 | Yes | Yes |
Count Comparison 3 Emissions | The number of emissions values that compose the aggregate sum of emissions for the comparison 3 data set. | 2 | No | No |
Ratio 3 | Sum Comparison 3 Emissions / Sum Baseline Emissions. Sum Comparison 3 Emissions and Sum Baseline Emissions values must both be valued. | 0.99 (rounded to 2 DP) | No | No |
Difference 3 | Sum Comparison 3 Emissions - Sum Baseline Emissions. Sum Comparison 3 Emissions and Sum Baseline Emissions values must both be valued. | -0.12 | No | No |
Absolute Difference 3 | | Sum Comparison 3 Emissions - Sum Baseline Emissions |. Sum Comparison 3 Emissions and Sum Baseline Emissions values must both be valued. | 0.12 | No | No |
Percent Difference 3 | ((Sum Comparison 3 Emissions - Sum Baseline Emissions) / Sum Baseline Emissions) * 100. Sum Comparison 3 Emissions and Sum Baseline Emissions values must both be valued. | 5.3 (rounded to 1 DP) | No | No |
Sum Comparison 4 Emissions | The aggregate sum of emissions for the selected comparison 4 data set. | 123.57 | Yes | Yes |
Count Comparison 4 Emissions | The number of emissions values that compose the aggregate sum of emissions for the comparison 4 data set. | 2 | No | No |
Ratio 4 | Sum Comparison 4 Emissions / Sum Baseline Emissions. Sum Comparison 4 Emissions and Sum Baseline Emissions values must both be valued. | 0.99 (rounded to 2 DP) | No | No |
Difference 4 | Sum Comparison 4 Emissions - Sum Baseline Emissions. Sum Comparison 4 Emissions and Sum Baseline Emissions values must both be valued. | -0.12 | No | No |
Absolute Difference 4 | | Sum Comparison 4 Emissions - Sum Baseline Emissions |. Sum Comparison 4 Emissions and Sum Baseline Emissions values must both be valued. | 0.12 | No | No |
Percent Difference 4 | ((Sum Comparison 4 Emissions - Sum Baseline Emissions) / Sum Baseline Emissions) * 100. Sum Comparison 4 Emissions and Sum Baseline Emissions values must both be valued. | 5.3 (rounded to 1 DP) | No | No |