EasyRSEI Online Help
EasyRSEI is an easy-to-use dashboard that provides simplified access to 29 years of 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 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 by using the Qlik Sense® platform. EasyRSEI contains the most recent eleven years of RSEI data; a separate dashboard with all years (1988 to current) is available for interested users.
To see information about using a Qlik Sense® dashboard, click on the sections below:
- Making Selections
Understanding How to Select Data
By default, the dataset included in a Qlik Sense® 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 in chemical releases in a certain geographical area might not be visible until you begin to narrow the selection of your dataset to a specific country, state, county, etc.
Qlik Sense® is based on an associative model, which means that any selections on the dataset will output the subset of data that is possible based on the selections. Qlik Sense® 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.
If you then select "325510 Paint and Coating Manufacturing" in the Subsector field, then those other subsectors in "325 Chemicals" and "326 Plastics and Rubber" become alternative states. Industry sectors besides "325 Chemicals" and the subsectors in those groups now become excluded states because they are not possible given the selection on both "325 Chemicals" and "325510 Paint and Coating Manufacturing." Note that, since "326 Plastics and Rubber" is still a selected industry sector, but it is not a possible value given the selection of "325510 Paint and Coating Manufacturing," it is denoted as a selected excluded state.
- How to Filter Data
Using a Filter Pane
One of the objects used in Qlik Sense® 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, all subsectors besides “325510 Paint and Coating Manufacturing” would become selected, and “325510 Paint and Coating Manufacturing” would become an alternative state.
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 Sense® 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 Sense ® allows for several different search methods, described below.
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.
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 values can be searched using relational operators to find values greater than, less than, and/or equal to the search string value.
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
To find more information about each of the pages in the EasyRSEI Dashboard, click on the sections below
Filters and Options
The filters and options menu is available by clicking on the gears icon in the top right. The RSEI Value Option dropdown menu lets you change the values shown in the dashboard objects from RSEI Score to RSEI Hazard. There are also filters that control what subsect of the data is shown in your current selection. All of the selections made on this menu will affect all of the pages in the dashboard (except for the National Trend page). For example, if you select 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 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.
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.
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.
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.
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.
The first page included in the EasyRSEI Dashboard provides an overview of the national trends for both RSEI Hazard and RSEI Score. The two bar charts on this page are intended to provide a direct comparison to the national trend charts included in the TRI National Analysis. These two charts are restricted from responding to any selections in the dashboard, and will always display the national trend for RSEI Hazard and RSEI Score for 2005 through 2015. Both charts also include the quantity of pounds reported to TRI and modeled by RSEI.
Important: The National Trend page is the only page in the dashboard that does not respond to filter or value option selections.
The top of the page includes a series of four key performance indicators (KPIs). The KPIs provide a quick view of how facilities, individual reports, and reporting years are included in the current selection, as well as the total RSEI Score associated with the selection.
Below the KPIs is a map which displays the geographical coordinates of each facility included in the current selection. Note that the map will only display approximately 32,000 facilities at once; selections which include more facilities than that will not render on the map.
Next to the map is a blue button which allows you to “Select your location using filters.” Click this button to expand four separate location filters, which include fields for State/Territory, County, City, and ZIP Code. Use these filters to quickly change the geographical extent of the current selection.
In addition to using the location filters, you can also select individual facilities from the map by clicking one at least one point. To select many facilities at once, toggle the Lasso selection tool by clicking on the map and then clicking on the icon. After using the Lasso tool to select the facilities, click the green check mark to confirm the inclusion of those facilities in the current selection state.→
The Summary page includes two different views of RSEI data that provide a summary of the results based on the current selection.
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 group 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 the RSEI Score by default, but can be changed to show different RSEI Value options using the RSEI Value Options dropdown menu.
The second view is an overview of the facilities included in the current selection. Description information, as well as the facility’s RSEI Value and reported TRI releases (Sections 5 and 6 of the Form R) are shown, along with a link to that facility’s RSEI report in Envirofacts.
The Overview tab includes a pivot table, which provides the RSEI Score 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, RSEI Scores 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. RSEI Values are sorted in descending order for the most recent year and the highest level dimension in the current selection.
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.
Although only off-site transfers to publicly-owned treatment works (POTWs) and to off-site incineration are modeled in RSEI, the EasyRSEI Dashboard includes additional information about all off-site transfers from the TRI dataset to provide a fuller view of off-site transfers of chemicals.
The Transfers page includes data on pounds transferred, how the waste transferred was managed, and information about the origin and receiving facilities.
The Report page of the dashboard includes selected views of the data in different visualizations interspersed with descriptive text to provide context for the results.
If only one facility is included in the current selection state, then a report specific for that facility will display in the Report page.
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
- 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 indudstry
- Facility List: a list of the facilities included in the current selection state
- Facility information: location, contact information, and EPA Program IDs
- RSEI Facility Score: RSEI Score my media and year. Information about chromium and chromium compounds releases will display if the facility reported this metal and/or metal compounds.
- 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.
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.