Risk-Screening Environmental Indicators (RSEI) Model

RSEI Data Dictionary: Facility Data

                            Tables in the RSEI Data Dictionary  
  Facility Chemical Submission Category Block Group Microdata Population Data  
  Offsite MCL Release Disaggregated Microdata Water Microdata Shapefiles  
  NAICS Media Elements Aggregated Microdata Census Crosswalks    

The facility table contains data for reporting facilities, including location, stack parameters and discharge reach, and is also available in EasyRSEI. Note that, with Version 2.3.5, SIC codes and some facility identifiers (RCRA ID, NPDES ID) are no longer maintained. Users interested in these fields can find them in EPA’s FRS (Facility Registry Service) system, identifying the facility with the FRS ID listed in the facility table.

Facility Data

Variable Name Description

FacilityID

Unique TRI identifier for facility (TRI Facility ID).

FacilityNumber

Internal identifier unique to each facility.

Latitude

Final latitude of the facility in decimal degrees used for modeling.

Longitude

Final longitude of the facility in decimal degrees used for modeling.

GridCode

Number that identifies the model grid within which the cell is located.

X

Assigned grid value based on latitude.

Y

Assigned grid value based on longitude.

RadialDistance

Distance from approximate center point of grid.

StackHeight

Height of facility stack that is emitting the pollutant (m).

StackVelocity

Rate at which the pollutant exits the stack (m/s).

StackDiameter

Diameter of facility stack that is emitting the pollutant (m).

StackHeightSource

Source of information on stack height.

StackVelocitySource

Source of information on stack velocity.

StackDiameterSource

Source of information on stack diameter.

NEIYear National Emissions Inventory (NEI) version year, if NEI data were used for stack parameters.

FacilityName

TRI facility name.

Street

Street address of facility.

City

City where the TRI facility is located.

County

County where the TRI facility is located.

State

State in which the facility is located.

FIPS

FIPS (Federal Information Processing Standard) code which identifies the county associated with the facility.

STFIPS

FIPS (Federal Information Processing Standard) code which identifies the state associated with the facility.

ZIPCODE

Five-digit facility ZIP code.

ZIP9

Nine-digit facility ZIP code, if reported.

DUNS

The 9-digit number assigned by Dun & Bradstreet for the facility or establishment within the facility.

REGION

EPA region where facility is located.

FederalFacilityFlag

Code describing federal status for purposes of Executive Order 12856.

FederalAgencyName

Name of federal agency of which the federal facility is a part.

ParentName

Name of the corporation or other business entity located in the U.S. that directly owns at least 50 percent of the voting stock of the facility.

ParentDUNS

The 9-digit number assigned by Dun & Bradstreet for the US parent company.

PublicContactName

Name submitted by TRI facility as public contact.

PublicContactPhone

Phone number submitted by TRI facility for public contact.

PCT_CH6

Percent of chromium released that is assumed to be hexavalent (the remainder is assumed to be trivalent with negligible toxicity and not modeled.

ChromHexPercent

Percent of chromium released that is assumed to be hexavalent (the remainder is assumed to be trivalent with negligible toxicity and not modeled (same as PCT_CH6).

ChromSource Source for PCT_CH6/ChromHexPercent.
ModChromReleases True if facility has released or transferred chromium or chromium compounds to modeled media (fugitive/stack air releases, direct water, POTWs or off-site incineration).

NewIndustryFlag

True if the facility is in an industry first required to report with the TRI industry expansion in reporting year 1998.

NAICS1

Facility’s 6-digit NAICS code designated as “primary” by facility on Form R. If no primary NAICS is designated, the field displays “NR.”

NAICS2

Facility’s most frequently reported non-primary 6-digit NAICS code.

NAICS3

Facility’s second most frequently reported non-primary 6-digit NAICS code.

NAICS4

Facility’s third most frequently reported non-primary 6-digit NAICS code.

NAICS5

Facility’s fourth most frequently reported non-primary 6-digit NAICS code.

NAICS6

Facility’s fifth most frequently reported non-primary 6-digit NAICS code.

NAICSCode3Digit

First 3 digits of facility’s primary NAICS code.

NAICSCode4Digit

First 4 digits of facility’s primary NAICS code.

NAICSCode5Digit First 5 digits of facility’s primary NAICS code.

FRSID

EPA’s Facility Registry System ID.

AssignedReach

NHDPlus reach identifier for final facility discharge reach.

AssignedCOMID

NHDPlus segment identifier for final facility discharge reach.

ReachSource

Source for final discharge assignment.

OutfallLatitude

Latitude for outfall.

OutfallLongitude

Longitude for outfall.

OutfallSource

Source for outfall coordinates.

NearReach

NHDPlus reach identifier for nearest discharge reach.

NearCOMID

NHDPlus segment identifier for nearest discharge reach.

NPDESYear

Year of ICIS-NPDES data used.

DistanceToReach

The distance between an off-site facility discharging to water and the reach of the receiving water body (m).

HEM3ID

The ID assigned to the nearest National Weather Service (NWS) observation station.

DistanceToHEM3

The distance between a facility and the nearest observation station.

LatLongSource

Source of final lat/long found in ‘Latitude’ and ‘Longitude’ fields.

LLYear

Year of lat/long data.

LLNotes

Notes for facility location.

DistanceToTribalLand

Distance to nearest Tribal Land within ten miles (miles).

TribalLandName

Name of nearest Tribal Land within ten miles, if any.

WaterReleases

True if facility reported direct water releases for any year 1988-2015.