SPPD RTR Modeling File Data Retrieval Report
A new report has been requested by SPPD to create a report that is consistent with their Risk and Technology Review (RTR) modeling file. The report will only be based on point data and will only include data with a Reporting Period code of “ANNUAL” and an emissions operation type of “ROUTINE”.
The following report criteria are required when generating a SPPD RTR Modeling File Report
Report Criteria
-
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
-
Data Set (required) - Inventory Year and Data Set Name
- Geographic Locations - Type, Code, Geographic Description
- Pollutants (required)
- NAICS - NAICS Code, NAICS Description
- EIS Facility Identifiers - Upload CSV file with Facility IDs. The file must be a CSV
with one column labeled "EIS Facility ID" followed by any EIS Facility IDs that you want
your report filtered by. There is a limit of 10,000 EIS Facility ID records that may be
uploaded per file. Click here for additional details on the EIS Facility Identifier Filter
- Columns – No columns displayed in accordion filter or option to select. Report will default to display all available Facility attributes in all XML files
The following Columns will always be defaulted and included at a minimum in the report
Defaulted and Included
- REGION
- TRIBAL_CODE
- TRIBAL_NAME_LONG
- STATE_ABBR
- COUNTY_NAME
- STATE_COUNTY_FIPS
- FACILITY_REGISTRY_IDENTIFIER
- SPPD_FACILITY_IDENTIFIER
- FACILITY NAME
- Site Latitude
- Site Longitude
- Design Capacity Protected?
- PROCESS_ID
- PROCESS_DESCRIPTION
- SCC
- EMISSION_RELEASE_POINT_ID
- EMISSION_RELEASE_POINT_TYPE
- START_DATE
- END_DATE
- POLLUTANT_CODE
- POLLUTANT_DESCRITION
- HAP_CATEGORY_NAME
- ACTUAL_EMISSIONS_TPY
- EMISSION_CALC_METHOD_CODE
- CONTROL_STATUS
- CONTROL_MEASURE_CODE_1
- CONTROL_MEASURE_CODE_2
- CONTROL_MEASURE_CODE_3
- CONTROL_MEASURE_CODE_4
- CONTROL_MEASURE_CODE_5
- REGULATORY_CODE
- FACILITY_CATEGORY
- LOCATION_ADDRESS
- CITY
- ZIPCODE
- DATA_SOURCE
- EXIT_GAS_TEMPERATURE (F)
- STACK_HEIGHT (FT)
- STACK_DIAMETER (FT)
- EXIT_GAS_VELOCITY (FT/SEC)
- EXIT_GAS_FLOW_RATE (CU FT/SEC)
- FUGITIVE_LENGTH_SIGMAX_FT
- FUGITIVE_WIDTH_SIGMAY_FT
- FUGITIVE_ANGLE_DEGREES
- FUG_2D_MIDPT1_X_CO
- FUG_2D_MIDPT1_Y_CO
- FUG_2D_MIDPT2_X_CO
- FUG_2D_MIDPT2_Y_CO
- FUG_2D_MIDPT2_Y_CO
- X_COORDINATE
- Y_COORDINATE
- LOCATION_DEFAULT_FLAG
- NORTH_AMERICAN_DATUM
- CLOSED_YEAR
- HOURS_PER_YEAR
- HOURS_PER_DAY
- DAYS_PER_WEEK
- WEEKS_PER_YEAR
Columns in the RTR Modeling File Data Retrieval Report
The following Columns will always be defaulted and included at a minimum in the report : EIS Facility ID; EIS Unit ID, Reporting Period; Emissions Operating Type; Pollutant Code; Total Emissions; and Emissions UOM.
| Column Header | Database Definition | Output Sample Value | Defaulted | Required |
|---|---|---|---|---|
| REGION | Code that identifies the EPA region. | 01, 02, 03 | Yes | Yes |
| TRIBAL_CODE | Yes | Yes | ||
| TRIBAL_NAME_LONG | Name of the American Indian or Alaskan Native entity | “Red Cliff Band of Lake Superior Chippewa Indians of Wisconsin | Yes | Yes |
| STATE_ABBR | The abbreviation of the US state | NH | Yes | Yes |
| COUNTY_NAME | The name of the US County | Wake | Yes | Yes |
| STATE_COUNTY_FIPS | 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 | Yes |
| FACILITY_REGISTRY_IDENTIFIER | Yes | Yes | ||
| SPPD_FACILITY_IDENTIFIER | Yes | Yes | ||
| FACILITY 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 | Yes |
| AGENCY_PROGRAM_SYSTEM_CODE | No | No | ||
| AGENCY_FACILITY_ID | A unique sequence identifier assigned by the EIS. This data in this column is not made public. | “12345” | No | No |
| FACILITY_SITE_DESCRIPTION | No | No | ||
| FACILITY_SOURCE_TYPE_CODE | Description of facility source type code. | “Compressor Station” | No | 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 |
| Primary NAICS Protected? | Property restricts users from modifying protected data when enabled | Yes/No | No | No |
| Secondary NAICS | A secondary operation performed by the facility described by codes from the North American Industry Classification System (NAICS). | “Natural Gas Manufacturing” | No | No |
| Tertiary NAICS | A tertiary operation performed by the facility described by codes from the North American Industry Classification System (NAICS). | “Oil and Gas Extraction” | No | No |
| FACILITY_SOURCE_TYPE_CODE | 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 |
| FACILITY_SITE_STATUS_CODE | Code that identifies the operating status of the facility site during the reporting period. | OP | No | No |
| FACILITY_SITE_STATUS_CODE_YEAR | The year in which a status or code changed or is no longer effective. | 2010 | No | No |
| FACILITY_SITE_COMMENT | Any comments regarding the reported data. | “Shuts Down During the Summer” | No | No |
| NAICS_PRIMARY | A unique sequence identifier assigned by the EIS. This data in this column is not made public. | 2504613 | Yes | No |
| EMISSION_UNIT_ID | The NAICS code indicates the industry classification/activity or subdivision of an industry for a facility site. | “326211” | Yes | No |
| AGENCY_UNIT_ID | A unique sequence identifier assigned by the EIS. This data in this column is not made public. | “ABC12” | Yes | No |
| EMISSION_UNIT_DESCRIPTION | Description of unit type code. | “wood/coal/finishing material-fired boiler (35 million Btu per hour maximum permit)” | Yes | No |
| UNIT_TYPE_CODE | Code that identifies the type of emissions unit. | Kiln | Yes | No |
| City | 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. | “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 |
| UNIT_DESIGN_CAPACITY | The measure of the size of the unit based on the maximum continuous throughput capacity of the unit. | 1990 | No | No |
| UNIT_DESIGN_CAPACITY_UOM | The code that identifies the lookup value to be reported. | HP | No | No |
| Design Capacity Protected? | Any comments regarding the reported data. | No | Yes | No |
| UNIT_COMMENT | Code that identifies the operating status of the unit during the reporting period. | “Second Unit at site” | No | No |
| PROCESS_ID | A unique sequence identifier assigned by the EIS. This data in this column is not made public. | 4318014 | Yes | No |
| 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 | No | No |
| PROCESS_DESCRIPTION | A text description of the emissions process | “Second Process at Site” | Yes | Yes |
| PROCESS_COMMENT | No | No | ||
| PROCESS_STATUS_YEAR | The year in which the process status became applicable. | 2020 | No | No |
| SCC | Source classification code, which identifies the major industrial classification of a source. | 10200906 | Yes | Yes |
| SCC_DESCRIPTION | Description of first tier of SCC. | “External Combustion Boilers” | No | No |
| EMISSION_RELEASE_POINT_ID | Yes | Yes | ||
| AGENCY_RELEASE_POINT_ID | No | No | ||
| EMISSION_RELEASE_POINT_TYPE | A code that defines the type of release point being reported | 1 | Yes | Yes |
| RELEASE_POINT_DESCRIPTION_ | Text description of emissions release point type code. | “Fugitive 3-Dimensional” | No | No |
| RELEASE_POINT_COMMENT | Any comments regarding the reported data | “comment about the release point” | No | No |
| START_DATE | The representative beginning date for the reported data | 1/1/2021 | Yes | Yes |
| END_DATE | The representative ending date for the reported data | 12/31/2021 | Yes | Yes |
| POLLUTANT_CODE | Unique identifier of an EIS pollutant code record. | PM25-FIL | Yes | Yes |
| POLLUTANT_DESCRITION | Description of the pollutant for which emissions are reported. | PM2.5 Filterable | Yes | Yes |
| HAP_CATEGORY_NAME | The code that identifies the lookup value to be reported. | HAP-VOC | Yes | Yes |
| ACTUAL_EMISSIONS_TPY | Total calculated or estimated amount of the pollutant expressed in Tons per Year | "325.25" | Yes | Yes |
| EMISSION_FACTOR | The Emission factor used for the emissions value if a calculated value was populated | 1.35 | No | No |
| EMISSION_FACTOR_NUM_UOM | The unit of meaure used in the numerator for the emission factor | "BTU" | No | No |
| EMISSION_FACTOR_DEN_UOM | The unit of measure used in the denominator for the emission factor | "TON" | No | No |
| EMISSION_FACTOR_TEXT | Explanation for the emission factor. | "This is how the emission factor was derived" | No | No |
| EMISSION_CALC_METHOD_CODE | Code that defines the method for how the emissions value was calculated | "8" | Yes | Yes |
| EMISSIONS_COMMENT | Any comments supplied for the emissions value. | "Reported by the facility" | No | No |
| CONTROL_STATUS | The status of the site path referenced by the process - release point | "OP" | Yes | Yes |
| CONTROL_MEASURE_CODE_1 | The first instance of a control device used by the process - release point | "338" | Yes | Yes |
| CONTROL_MEASURE_CODE_2 | The second instance of a control device used by the process - release point | "339" | Yes | Yes |
| CONTROL_MEASURE_CODE_3 | The third instance of a control device used by the process - release point | "340" | Yes | Yes |
| CONTROL_MEASURE_CODE_4 | The fourth instance of a control device used by the process - release point | "145" | Yes | Yes |
| CONTROL_MEASURE_CODE_5 | The fifth instance of a control device used by the process - release point | "148" | Yes | Yes |
| CONTROL_APPROACH_DESCRIPTION | General description of the control system used | "Dust Collector #1" | No | No |
| CONTROL_APPROACH_COMMENT | General description of the control system used | "Dust Collector #1" | No | No |
| REGULATORY_CODE | Code that defines the federal or state regulatory program or rule | "MACT" | Yes | Yes |
| FACILITY_CATEGORY | Code that defines the federal classification of the facility | "HAP" | Yes | Yes |
| LOCATION_ADDRESS | The address that describes the physical (geographic) location of the front door or mainentrance of a facility site, including urban-style street address or rural address. | “123 Maple Lane” | Yes | Yes |
| CITY | The name of the city, town, village, or other locality, when identifiable, within whose boundaries the facility site is located. | “Springfield” | Yes | Yes |
| ZIPCODE | 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 | Yes | Yes |
| DATA_SOURCE | The name of the data set where the data were acquired | Yes | Yes | |
| EXIT_GAS_TEMPERATURE (F) | The temperature of the exit gas stream, measured in degrees Fahrenheit. | Yes | Yes | |
| STACK_HEIGHT (FT) | The height of the stack from the ground, measured in feet | 15 | Yes | Yes |
| STACK_DIAMETER (FT) | The diameter of the stack measured in feet | 4.2 | Yes | Yes |
| EXIT_GAS_VELOCITY (FT/SEC) | The velocity of the exit gas stream measured in Feet per Second | 22.6 | Yes | Yes |
| EXIT_GAS_FLOW_RATE (CU FT/SEC) | The stack gas flow rate (in actual cubic feet per second) | 42.5 | Yes | Yes |
| FUGITIVE_LENGTH_SIGMAX_FT | The length (measured in feet) of the release in the north-south direction as if the angle is zero degrees. | 15 | Yes | Yes |
| FUGITIVE_WIDTH_SIGMAY_FT | The width (measured in feet) of the release in the east-west direction as if the angle is zero degrees. | 10 | Yes | Yes |
| FUGITIVE_ANGLE_DEGREES | The orientation angle for the area in degrees from North, measured positive in the clockwise direction. | 220 | Yes | Yes |
| FUG_2D_MIDPT1_X_CO | The 1st measure of the angular distance on a meridian north or south of the equator. Used only for 2D Fugitive Sources. | 36.8976 | Yes | Yes |
| FUG_2D_MIDPT1_Y_CO | The 1st measure of the angular distance on a meridian east or west of the prime meridian. Used only for 2D Fugitive Sources. | -82.0045 | Yes | Yes |
| FUG_2D_MIDPT2_X_CO | The 2nd measure of the angular distance on a meridian north or south of the equator. Used only for 2D Fugitive Sources. | 36.8976 | Yes | Yes |
| FUG_2D_MIDPT2_Y_CO | The 2nd measure of the angular distance on a meridian east or west of the prime meridian. Used only for 2D Fugitive Sources. | -82.0045 | Yes | Yes |
| X_COORDINATE | The measure of the angular distance on a meridian north or south of the equator. | 36.8976 | Yes | Yes |
| Y_COORDINATE | The measure of the angular distance on a meridian east or west of the prime meridian. | -82.0045 | Yes | Yes |
| COORDINATE SOURCE | Coordinants can represent the Facility or Release Point | "Facility" | Yes | No |
| COORDINATE_COMMENT | Any comments regarding the reported data. | “Sample comment for the coordinates” | No | No |
| LOCATION_DEFAULT_FLAG | Boilerplate value of "EIS" | "EIS" | Yes | Yes |
| NORTH_AMERICAN_DATUM | Description of the Horizontal datum used by the facility | "002" | Yes | Yes |
| CLOSED_YEAR | The year in which the release point was last used | 2010 | Yes | Yes |
| HOURS_PER_YEAR | The number of hours per year the release point - process were operating | 2006 | Yes | Yes |
| HOURS_PER_DAY | Yes | Yes | ||
| DAYS_PER_WEEK | The average number of days per week the release point - process were operating | 5.2 | Yes | Yes |
| WEEKS_PER_YEAR | The average number of weeks per year the release point - process were operating | 45 | Yes | Yes |
| CALC_PARAMETER_TYPE_CODE | Code that defines the method for how the emissions value was calculated | I | No | No |
| CALC_PARAMETER_VALUE | The value used in the calculation method | 123.456 | No | No |
| CALC_PARAMETER_UOM | The unit of measure for the calculation parameter value | "E3GAL" | No | No |
| CALC_PARAMETER_MATERIAL_CODE | A code that defines the type of material used in the calculation method | "Drum" | No | No |