EasyRSEI Online Help
EasyRSEI is an easy-to-use dashboard that provides simplified access to results from EPA's Risk-Screening Environmental Indicators (RSEI) model. With EasyRSEI, you can browse through and customize charts, maps, and tables and select the data you are interested in for, such as specific facilities, locations, chemicals, and years. Screenshots and data can be exported from EasyRSEI. The EasyRSEI Dashboard is easily accessible through any browser and device. The EasyRSEI Dashboard contains the most recent ten years of RSEI data; a separate dashboard with all years (1988 to current) is also available for interested users.
To see information about the pages in the EasyRSEI Dashboard, click on the sections below:
Making Selections
Understanding How to Select Data
By default, the dataset included in the application is the entire dataset. By making a selection on the dataset, you can begin to focus in on a subset of the data and drill down to insights and narratives that might not be as apparent when looking at the entire dataset at once. For example, trends of chemicals in a certain geographical area might not be visible until you begin to narrow the selection of your dataset to a specific state, county, etc.
The dashboard is based on an Qlik® associative model, which means that any selections on the dataset will output the subset of data that is possible based on the selections. Qlik uses color-coding to differentiate between different selection states and possible options for filtering the data.
For example, if you filter your data by selecting "325 Chemicals" and "326 Plastics and Rubber" from the Industry Sector field, the subset of data will be any records where "325 Chemicals" or "326 Plastics and Rubber" is the value in the Industry Sector field - "325 Chemicals" and "326 Plastics and Rubber" are both in the selected state. All other values in the Industry Sector field are alternative states. Within "325 Chemicals" and "326 Plastics and Rubber" are many subsectors that are denoted as possible states because, though not selected, they are possible given the current selection state.
How to Filter Data
Using a Filter Pane
One of the objects used in Qlik applications is the filter pane. Filter panes can be used to provide additional flexibility in how values are selected from a given field. As shown below, filter panes can be used to search directly on all of the values using an open text field. The Selection menu, shown in the far right, allows you to quickly select all values or change to other selection states. In this example, if “Select alternative” were selected in the Industry Subsector pane, all industry subsectors besides “3251 Basic Chemical Manufacturing” would become selected, and “3251 Basic Chemical Manufacturing” would become an alternative state. If you have selections made in the Primary NAICS Code pane, that will restrict your choices in the Industry Subsector and Industry Sector panes, and the "Select alternative" option will only be available in the Primary NAICS Code pane.
Types of Selection Methods
You can interact with any Qlik visualization (chart, map, table, etc.) to make selections.
- Click: Click on at least one value or data point to include them in the current selection. For example, you can click on a pie chart slice to select the dimension associated with that slice.
- Draw/Lasso: Click inside the object and turn on the lasso selection to draw a freehand line and select multiple values or data points at once.
- Label: Click on dimensions labels to select those dimensions.
- Range: Click on a range of values in either the x- or y-axis of a chart to select those values.
Searching for Data
Qlik provides many search options to help you find specific subsets of the data included in a dashboard. After typing in the search string, hit enter to make the selection.
Types of Searches
Qlik allows for several different search methods, described below.
Text search
Text search allows for searching by string(s). Additional options include using quotation marks to combine strings and search for only the entire string rather than individually, or using plus or minus signs to include or exclude certain strings. Wildcards may also be used. For example, "*" can be a placeholder for any number of characters, whereas "?" is a placeholder for a single character.
Fuzzy search
Placing a “~” character at the beginning of search string allows for fuzzy matching, which displays results that are similar to the search string(s) but not necessarily exact matches.
Numeric search
Numeric values can be searched using relational operators to find values greater than, less than, and/or equal to the search string value.
Expression search
An expression search string can also be used to filter values, as shown at the right where an expression search string in the TRIFID field identifies those facilities which reported more than 100,000,000 pounds of releases under the current selection state.
Additional Information
In addition to the full quick start guide , Qlik provides documentation for many of the features included in a searchable webpage format.
General Information
Filters and Options Menu
The filters and options menu is available by clicking on the gears icon at the top right of the screen. Use the RSEI Value Option dropdown to change the values shown in the dashboard objects from RSEI Score to RSEI Modeled Hazard or other types of RSEI results. Additional filters control what subset of data is shown in your current selection. All of the selections made on this menu will affect all of the pages in the dashboard. For example, if you select RSEI Modeled Hazard from the RSEI Value Options menu and then select California from the State filter, all of the objects in the dashboard will show only RSEI Modeled Hazard data from facilities in California. Click anywhere on the dashboard to hide the menu again. The filters in this menu do not reflect all of the possible filters that can be applied to the data, but provide quick and easy access to those that are most likely to be of interest.
Page-Specific Filters
Several pages have additional filters, like the filter on the Summary and Analysis pages to switch from RSEI values for modeled media. These page-specific filters do not influence the selections on other pages.
Selection Toolbar
The selection toolbar shows at the top of every page and indicates which filters are currently active. You can click on any filter in the toolbar to modify or delete that selection. The buttons at the left allow you to step back or forward through the current selection, or clear it entirely.
Pop-Ups
Selection State Information
The selection state information pop-up is available by clicking on the information icon in the top right. This will display any caveats about the data that are pertinent to your current selection state. For example, if the selection includes years after 1997, the pop-up includes a section explaining that additional industry sectors were added to TRI reporting beginning with Reporting Year 1998.
Help
The help pop-up is available by clicking on the question mark icon in the top right. This pop-up includes some general guidance for using the EasyRSEI Dashboard, such as how to toggle individual Qlik objects into a full-screen view or download screenshots of each object.
Navigation Bar
The navigation toolbar along the left-hand side allows your to move through the different pages within the dashboard. Each page is described in further detail below.
Home Page
The first page included in the EasyRSEI Dashboard provides information about the RSEI model and the results that are available in EasyRSEI. Links are provided to the RSEI website, the TRI website and the TRI National Analysis website.
For an easy way to get started with EasyRSEI, you can use the filters at the bottom left to filter the results shown on the bar chart. Your selections will carry through to the other pages in the dashboard. Alternatively you can search for a location on the Location page, or browse through the data on one of the other pages.
Location
The location page shows the currently selected facilities and provides further options for selection and mapping based on geography.
The top of the page shows four key performance indicators (KPIs) based on your current selection: the number of facilities reporting to TRI, the number of TRI reports, the number of reporting years and the total RSEI Score. Below the KPIs, you can use map functions to explore and refine your selections.
The first tab, "Map Current Selection" shows all TRI-reporting facilities in the current selection. If you have a large number of facilities, it may take some time to show them all on the map, and if you are using the All Years dashboard, some selections may exceed the approximately 32,000 limit on the number of facilities that can be mapped at once.
You can make selections on the map by clicking individual facilities or by using the lasso function. To use the lasso, click on the map to activate the tools, then click on the lasso tool icon at the top of the map. Draw a circle around the facilities you want to select, then click the green checkmark in the top right corner of the map to confirm your selection.
On the second tab, "Find TRI Facilities Near You," you can input a location address and click "Search" to see all TRI-reporting facilities in your current selection that are also within a certain distance from that location. The distance is determined by the slider at the bottom of the screen.
The third tab allows you to “Select Facilities Using Filters.” You can refine your current selection by State, County, City, ZIP Code or Tribe. Remember to click the green check mark to confirm each selection.
Summary
The Summary page includes three different views of RSEI data that provide a summary of the results based on the current selection. On this page, the default view is RSEI Values for modeled media (pounds, hazard-based values and risk-related scores for the kinds of releases and transfers that RSEI fully models and for which risk-related scores can be calculated. You can use the toggle to select TRI Values for all media, then select from the drop-down menu to show TRI Pounds, RSEI Hazard, RSEI Cancer Hazard, or RSEI Noncancer Hazard. The charts on all the tabs on this page only will then show the values for all media reported to TRI in Sections 5 or 6 of the TRI Form R.
The "Overview" tab presents different charts and maps of RSEI results. The charts include a bar chart showing the trend of RSEI results by media and year; a map displaying the RSEI results by state; and pie charts which include RSEI results by industry group, location, and chemical.
Both the industry sector and location pie charts drill down into more detailed categories after an initial selection (e.g., if you click on the Region 4 slice in the EPA Region pie chart, the chart will change to Region 4 chart showing the state breakdown). All of these charts show RSEI Score by default, but can be changed to show different RSEI results using the RSEI Value Options dropdown menu.The "Top Facilities" tab lists all facilities included in the current selection. Each facility’s unique TRI facility identification number (TRIFID), name, city and state are listed, along with the selected RSEI Value or TRI Value selected at the top of the page or in the Filter Options menu at right. For comparative purposes, the table also provides “TRI Pounds” which is the total of all pounds released or transferred for that facility (subject to whatever filters are selected). See Understanding RSEI Results for more information).
The "Industry Sectors" tab allows a more focused look at RSEI results for a given industry. If no industries are currently selected, the first pie chart will show the distribution of the selected RSEI Value across industry sector (by 3 or 4 digit North American Industry Classification System (NAICS) code), and the bar graph will show the value for each sector over time.
You can select one or more industry grouping using the three lists at the top of the screen. If you select one or more sectors in the first list, the values in the other lists will change color based on their relationship to what you selected- green means selected, white means currently possible/included, dark gray means excluded, and light grey means alternative, or that it is selectable given your current selections. See “Making Selections” above for more information on selecting data in Qlik. Any selections you make in the lists will be reflected in the charts.
Analysis
The "Overview" tab includes a pivot table, which provides the RSEI or TRI Value calculated for a series of dimensions.
The four dimensions included in the pivot table are Chemical, Media, Facility ID, and Year. In the initial view, values are calculated by chemical (row) and year (column). Use the plus sign buttons to expand the rows to show media- and facility-level calculations as well. Values are sorted in descending order for the most recent year and the highest level dimension in the current selection.On this page, the default view is RSEI Score from the RSEI Values for modeled media (the kinds of releases and transfers that RSEI fully models and for which RSEI calculates risk-related scores. You can use the toggle to select TRI Values for all media, then select from the drop-down menu to show TRI Pounds, RSEI Hazard, RSEI Cancer Hazard, or RSEI Noncancer Hazard. The charts on this page only will then show the values for all media reported to TRI in Sections 5 or 6 of the TRI Form R. Note your selection will affect all of the tabs in this page.
You can reorganize the dimensions by dragging the dimension name into a different order in either the rows or columns.
In addition to the "Overview" tab, the Analysis page also includes three tabs to view results with a specific focus on chemicals, media, and facilities. These tabs include similar charts, but show different dimensions.
Transfers
RSEI only fully models transfers to two kinds of off-site facilities: publicly owned treatment works (POTWs) and off-site incinerators. However, TRI collects information for many other types of waste transfers, and RSEI calculates hazard-based values (toxicity-weighted pounds) for many of them.
Transfers of all types are presented in the Transfers page of the dashboard, unlike the other pages, which only include releases and transfers that are modeled. When you click on the transfers page, you will get a pop-up reminding you that the Transfers page includes more transfers than the other pages in the EasyRSEI dashboard.The Transfers page includes data on pounds transferred, how the chemical waste transferred was managed, and information about the origin and receiving facilities included in your current selection. By default, only states will show in the map. You can click the “Show” button to show the off-site transfers associated with your current selection; the default is to show the 50 largest transfers (by whatever value is selected), but you can change that using the slider at the right.
There are several ways to filter on this page:
- Use the filters and options menu under the layer icon at the top right. Note that the RSEI Value Options dropdown menu will not affect this page, since this page contains more than just modeled releases and transfers (use the dropdown on this page instead). All other filters will work on this page.
- From the dropdown menus at the top, select an origin state(s) (facilities located in this state transferring chemical waste to an off-site facility) and/or receiving state(s) (facilities located in this state receiving chemical waste from a TRI-reporting facility). To view in-state transfers, select the same state from both dropdown menus. Note that in the selection bar at the top of the screen, origin state/territory is labeled “State.”
- Click on a facility on the map, or an arrow to select just that transfer. You can select multiple facilities, arrows or a combination. Remember to click the green check mark when you are done to confirm your selection.
- Click on a state on the map to show transfers into that state, as well as the facilities that make the transfers.
- Waste Treatment Type – this chart separates all transfers into five types: treatment, transfers to POTWs, energy recovery, disposal, or recycling. Your selection will show in the selection bar as “Mtype”.
- Waste Transferred by Chemical – This selects the chemical transferred, and is equivalent to the chemical filter in the filters and options menu.
- Waste Transfers Outside U.S.- This chart shows the destination by region of all transfers that go outside the U.S. and its territories. To see transfers that go to Asia, for example, click on the pink pie slice labeled “Asia.” Your selection will show in the selection bar as “Global Region.”
- Select one or more facilities from the facility lists. The two tables at the bottom of the page list all of the origin facilities and receiving facilities. The icon in the top right corner expands the table so all fields are visible.
Waste Managed
The Waste Managed page includes data from Section 8 of the TRI Form R, where facilities report data elements mandated by section 6607 of the Pollution Prevention Act of 1990.
For more information on these data elements, see the “Waste Management Information in TRI” section of the Factors to Consider When Using Toxics Release Inventory Data document.Most waste management categories are not modeled by RSEI, but hazard-based values are calculated for all chemicals with toxicity weights. Note that some of the waste management categories, such as "Disposed or otherwise released," represent the same waste quantities that are reported in Sections 5 and 6 of TRI Form R, and are shown in the other pages of this dashboard, and cannot be summed with quantities from those sections.
Data Download
On the Data Download page, you can build a table based on your current selections that can be downloaded into an Microsoft Excel spreadsheet. As on other pages in EasyRSEI, you can select RSEI Value Dimensions if you want to look at modeled pounds, modeled hazard-based values or risk-related scores for modeled media; select TRI Value Dimensions for pounds and hazard-based values for all TRI-reported releases and transfers. The default settings for the table will show RSEI Score by reporting year and facility ID, but you can select additional dimensions and metrics in the lists on the left side of the table. When selected, a dimension or measure will show in the list at the top of the table. You can reorder the columns by clicking and dragging the names. To export your data, click the blue "Download Data" button at the top left of the table.
Report
The Report page of the dashboard brings together basic information about your selection into printable reports, including charts and maps from the other pages, along with explanatory text to help you understand the graphics.
Your selection determines which reports are available for viewing. When you click the Report icon, the most relevant report will be opened for you; if there are any other reports available, they will be shown as blue buttons at the top of the page. There are currently four kinds of reports:
Summary of Selected Data
- Trend for Selected Data: RSEI Score by media and year
- Overview of Releases and Transfers: a table of pounds, RSEI Hazard, and RSEI Score by media (includes unmodeled media)
- Top Facilities: RSEI Score for the top 5 facilities, broken down by media
- Top Chemicals: RSEI Score for the top 10 industries, broken down by the top 10 chemicals in each industry
- Facility List: a list of the facilities included in the current selection state
Geographic Report
This report is always available and contains the following features:
- Facility Summary with map
- Top Facilities: RSEI Score for the top 5 facilities, broken down by media
- Overview of Releases and Transfers: a table of pounds, RSEI Hazard, and RSEI Score by media (includes unmodeled media)
- Top Chemicals for Air and Water Releases
- Trends by Media and Year
Facility Report
This report is available when only one facility is in your selection set and contains the following features:
- Facility information: location, contact information, and EPA Program IDs
- RSEI Facility Score: RSEI Score by media and year. Information about chromium and chromium compounds releases will display if the facility reported this metal and/or metal compound category.
- Media-Specific Information: For each possible media type, a description of those releases along with charts displaying the RSEI Score over time and by chemical for the facility will be shown. If the facility did not report releases for a specific media type, no information will be shown.
Off-Site Report
This report is available when one or more off-site facility is in your selection set and contains the following features:
- Key performance indicators (KPIs) describing the number of transfers, the pounds transferred, and the number of receiving and origin facilities.
- Waste Transfers by Method and Year: Pounds of waste by each of five transfer method (Mtype).
- Overview of Off-Site Transfers (All Years Combined): Pounds, RSEI Hazard, and RSEI Score by transfer type.
- Transfers from TRI Reporting Facilities to Off-Site Receiving Facilities: Transfers Map showing pounds transferred.
- Tables listing the origin facilities and receiving facilities in your set.
Each report also lists your current selection at the bottom of the report, to document the universe of releases presented in the report.
Note that the objects in the reports are selectable like they are in the rest of the dashboard. If you click on a bar or pie slice, you can select that parameter by clicking on the green check mark.
Modeling Data
If only one chemical is included in the current selection state, the Chemical Modeling Data tab (shown at right) displays information specific to that chemical. Types of data include identifiers and EPA program flags, as well as toxicity and physicochemical information used for modeling purposes.Similarly, if only one facility is included in the current selection state, the Facility Modeling Data tab displays information specific to that facility. Types of data include identifiers, locational data, water modeling data, air modeling data, and other information about the facility such as contact information.