Finding Facility-Level Information
This tutorial will explain some of the facility-specific features in the RSEI model, including geographic information system (GIS) capabilities.
Step 3.1 Select a Group of Facilities
In this step, you will make a selection based on the county where the releasing facilities are located.
Click on the Select button at the top left of the menu panel. This brings up the Select elements... screen, where you can specify what TRI releases you want to select. Note that if you have performed any selections since installing the RSEI model, your last selection statement will appear on the Select elements... screen. To remove it, simply click on the Clear button. You will see a line of text on the screen, 'Choose records where all of the following apply'. This is a bracket statement that tells the model what to do with the information that comes next. You can change the bracket statement from 'all' to 'any', 'none', or 'not all'. But for now let it remain 'all'. Click on the circle to the left of the text, and select 'Add condition'. The condition statement contains the criteria you use to select your releases.
You will see the following text line:
1. Chemical Flags.Year Chemical Added is equal to
Click on the first part of the text line, and a drop-down menu will appear. This menu contains all of the variables contained in the model that you can use in your selections. They are grouped according to the type of variable. Because we are selecting releases for facilities in a certain place, click on the variable group 'Facility Location'. To the right you will see another menu with all of the variables in this group. Click on 'County'.
The text line will change to '1. Facility Location.County is equal to '. Click on the blank at the end of the statement. In the window that appears, select the county (they are grouped alphabetically by state abbreviation). For this exercise, scroll down and click on 'AL, Montgomery,' which is Montgomery County in Alabama. This is your completed selection statement, as shown below.
Click Submit at the top of the Select elements... screen, and the model will perform the selection. This may take a few minutes to finish.
When the model is done with the selection, the Select elements... screen will disappear. The number of facilities, chemical releases, and elements that are selected in your set will be displayed in the top right corner of the screen. These numbers will remain displayed until you select a new set of scores. If you forget what your selection statement was, click on these numbers, and a window will appear with your original statement.
Now we can look at all of the facilities whose scores you have just selected. Click on the Selected Facilities Browser button in the second line of the menu panel. You will see a screen with three parts. The parts work together to provide detailed information on the facilities you have selected. The top part of the screen lists all the facilities whose scores have been selected. The bottom left is a US map you can use to display your selected facilities and other options. The bottom right of the screen displays information about the current map display and provides the buttons used to navigate the map and control its functions.
The Selected Facilities Browser
Step 3.2 Getting Information About a Facility
Facility Information, Submissions,
Releases and Scores
Double-click on the first facility name in the selected facilities list. You will see two options, 'Submissions' and 'Full Facility Record'. The latter option provides all of the information included in the model about this facility - its address, stack parameters, public contacts, etc. Double-click on 'Full Facility Record' or click on the plus sign to the left of the text to see all of the information. Then click on the minus sign at the far left to collapse it again. Expanding the 'Submission' option shows each chemical release that this facility has submitted to TRI. Double-click on a chemical name, then expand the 'Releases' option, and the model will show you the releases of that chemical - that is, the media that the chemical is being released to, as well as the total pounds released, and the total score. Double-click on the name of the media, and then on 'Scores' and the model will show you the score (the Risk-related Results of the model) for that chemical release to that media. To hide any of these records, simply click on the small minus sign at the beginning of the row. The list works like a directory tree that you can expand and collapse to see different levels.
You can also see where on the map your facility is located. With the facility name, or any part of the facility's submission record highlighted, click on the facility location icon in the lower right portion of your screen. The map will zoom into the state where your facility is located, and show you its exact location with concentric circles.
Step 3.3 Further Analyses
The steps outlined above should give you a good idea about one particular facility. However, the model contains much more information that can show you how that facility has been performing over time, or how it ranks in comparison to all facilities in the country, or facilities in similar geographic areas, or in similar industries.
To do a time trend analysis to see if a facility's risk-related score is getting better or worse over time, first do a selection based just on that facility. The easiest way is to simply use the Facility ID, the first column in the Selected Facilities Browser, then go back to the Select elements... screen, and create a new selection statement with a condition that says 'Facility Identifier.Facility ID is equal to X', where X is the Facility ID from the Selected Facilities Browser (you can copy the Facility ID from the Selected Facilities Browser by right-clicking on the ID, then typing Control-C to copy the ID to the Windows clipboard. You can then paste the ID in the selection statement, or in any other Windows program by typing Control-V). When the model is done with the selection, you can click on the Summary button in the second line of the menu panel, and see preformatted graphs that show total score and pounds by year, and total pounds and total score by media by year.
To see how your facility ranks in relation to other facilities, first select a set that includes your facility and all of the facilities to which you want to compare it, for instance, all facilities nationwide in 2005. Your selection statement in the Select elements... screen would say 'Submission.Year is equal to 2005'. This selects all releases from all facilities in 2005. When the model is done with your selection, click on the Custom Tables button. Follow the directions in Chapter 9 of the User's Manual (or in Creating a New Table in the RSEI on-line Help) to make a crosstab table of your results. If you make a table using 'Facility Name' and 'SIC code' as row and column variables, then you can click on the Sorted Table button to see a ranking of all the facilities in order of highest score (or pounds, depending on what 'Summary' you have selected) to lowest score. If you want to look at the facilities that are in the same industry as yours, then apply the filter to 'SIC Code 1', and select just your facility's SIC Code. Then click back to the Sorted Table, to see a ranking of all the facilities just in that SIC code.