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. |