State/Tribe - Sector Comparison Report
The State/Tribe - Sector Comparison Report provides emissions data aggregated to a State/Tribe Sector level in a flat file CSV format. A user can filter by pollutant, geographic area, data category, sector or reporting period.
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
- Comparison 2
- Comparison 3
- Comparison 4
- Geographic Locations - Type, Code, Geographic Description
- Pollutants
- Data Categories
- Sectors
- 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
- Data Category
- Emissions Type Code
- Sector
- 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
- Comparison 4 Emissions Data Set
Columns in the State/Tribe - Sector Comparison 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 | Yes |
| 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 | Yes |
| Data Category | Code that for the various categories of emissions inventory data, i.e., Point, Nonpoint, Onroad, Nonroad, Event, Biogenic, Facility Inventory, and ALM. | Point | Yes | Yes |
| Emissions Type Code | Code that defines the type of emissions produced by Onroad and Nonroad sources. | X | Yes | Yes |
| Sector | Code that identifies the sector. | Industrial Processes- Mining | Yes | Yes |
| Reporting Period | Code that identifies the time frames available for the reported emissions data. | A | Yes | Yes |
| 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. | “CAP”, “GHG”, “OTH” | No | No |
| HAP Type | Code designating the Hazardous Air Pollutant categorization of the site. | HAP-VOC | No | No |
| Emissions UOM | Unit of measure for reported emissions. | TON | 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 |