Risk-Screening Environmental Indicators (RSEI) Model

RSEI Data Dictionary: Off-site 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 Off-site table contains the condensed list of quasi-unique off-site facilities to which TRI reporters transfer waste. Only incinerators and POTWs are modeled by RSEI, so verification of addresses and locations are focused on those off-site facilities. 

Off-site Data

Variable Description

OffsiteID

Unique internal identifier for each off-site facility.

FacilityNumber

Unique internal identifier for each off-site facility. [Note this is different from the FacilityNumber field in the Facility table]

NewNumber

This variable is not yet active.

POTW_Incin

Identifies off-site facilities for which releases are modeled: 1= POTW; 2=Incinerator; 3=POTW and Incinerator.

DataSource

This variable is not yet active.

TRIFID TRI identifier, if applicable, for facility. Note this ID is not necessarily unique in this table, because there may be more than one record per facility (FacilityID is unique in the Facility table).

Name

Best submitted name for off-site facility.

Street

Best submitted street address for off-site facility.

City

Best submitted city for off-site facility.

State

Best submitted state for off-site facility.

ZIPCode

Best submitted ZIP code for offsite facility.

ZIP9

This variable is not yet implemented.

Latitude

Geocoded latitude in decimal degrees for off-site facility.

Longitude

Geocoded longitude in decimal degrees for off-site facility.

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.

Radial Distance

Distance from approximate center point of grid.

StackHeight

Default stack height used for off-site facilities.

StackVelocity

Default stack velocity used for off-site facilities.

StackDiameter

Default stack diameter used for off-site facilities.

TempField

This variable is not implemented.

FRSID

EPA’s Federal Registry System ID for off-site facility.

NPDESPermit

Permit number issued by US EPA for facilities discharging to water.

RCRANumber

Number assigned by EPA to facilities handling hazardous waste under the Resource Conservation and Recovery Act.

HEM3ID

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

DistanceToHEM3

The distance between a facility and the nearest observation station.

WaterReleases

Not currently updated.

OutfallLongitude

Latitude associated with end of the pipe used for off-site facility’s discharge to water.

OutfallLatitude

Longitude associated with end of the pipe used for off-site facility’s discharge to water.

NearReach

14-digit NHDPlus reach identifier associated with the reach that is nearest to off-site facility.

NearComID

ComID from NHDPlus dataset that uniquely identifies reach segment nearest facility.

DistanceToReach

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

AssignedReach

14-digit NHDPlus reach identifier associated with reach assigned by EPA or determined through QA.

AssignedComID

ComID from NHDPlus dataset that uniquely identifies reach segment for assigned reach.

StreamSource

Data source linking stream reach to facility.

LocationType

Type of geocoded match.

LatLongSource

Source used to determine off-site facility coordinates.

LatLongYear Year lat/long was last updated.

Quality

Rank from 1 to 9 describing quality of geocoded match (1 is best).

Freq

Number of TRI transfers sent to this off-site facility.

NearStream

USGS Reach Identifier from RF1 stream network (not currently used).

DistanceToStream

The distance between the facility and its RF1 stream reach (m) (not currently used).

WBANID

The ID assigned to the Weather Bureau/Army/Navy WeatherStation nearest to the facility.

DistanceToWBAN

The distance between a facility and the nearest WBAN weather station (m).

Notes on Coordinates

Notes on how off-site facility coordinates were derived.