The Reports button provides tabular access to your data, based on your selected
parameters. When you select a report, it will be displayed on screen to view. You
can print it by selecting the printer icon. By Advisory, the other Search menu
option, displays an alphabetical, incrementally searchable list of all advisories.
You can search through this list by typing the first few characters of the advisory
name. After selecting advisories, you can view the data or map them.
Options controls the map display, including the Map Type to display (advisory traces or
counts). You can choose to Draw all or just the selected advisories, show or
don't show Fish Tissue Data when an advisory is selected or a query is done,
display map coordinates (latitude/longitude), overlay Geographic Layers such
as U.S. cities on the maps and select what Colors to use on the maps and
whether or not to show the status bar at the bottom of the screen. Simply point
and click on your desired choices.
Maps generates color maps on the screen. You can select the entire U.S., an EPA
Region, or a specific state/province map. These maps will include all of the
advisories for the selected geographic unit. Search can then be used to overlay
selected advisories on these maps if you desire. The Options settings control
what initially displays on the map. The map window consists of a viewing area
and a speedbar. On the map area, the left mouse button can be used to select
an individual advisory; you may have to try a couple of times to highlight the
advisory, especially for smaller traces. When you have successfully clicked the
advisory, the data for that advisory will appear. For Canadian advisories, you will
need to use the large arrow icons on the speedbar to highlight the advisories
and retrieve data. This is because these advisories are point, rather than trace,
referenced. The right mouse button places a "zoom" box on the screen,
centered on the mouse cursor. The speedbar buttons can be used to Zoom in,
Zoom out, Zoom box smaller, Zoom box larger, select Next or Previous
advisory, Note selection criteria, Draw the overlay map, Draw the Canadian
rivers Layer (new for 1996), Print the visible map, and Close the map window.
Note that the "zoom" features will not work if there is more than one map
window open in your Listing session.
Window is used when you have more than one map open in a session. You can select
which map to view when more than one map has been created by selecting its
name from the drop down menu.
Help is available from the menu and is also context-sensitive. This means that you can
get help from wherever you are in the program by pressing F1, and the help will
be related to your current activity. The Help menu is divided into Contents;
Search for Help On, which displays an incrementally searchable list of keywords;
Help on Help, which provides help for whatever Windows version is installed on
your machine; and About the Listing, which provides brief information on the
system, including points of contact, available system resources remaining, the
EXE file creation date, and the version number of the program.
For more information, contact:
Jeffrey Bigler (202)-260-1305
(FAX 202-260-9830)
e-mail: Bigler.Jeff@epamail.epa.gov
United States
Environmental Protection
Agency
Office of Water
4305
EPA-823-F-98-010
April 1998
Help Card
Listing of Fish and Wildlife Consumption Advisories
The 1997 Listing of Fish and Wildlife Advisories (LFWA) includes advisories issued in the
states and in the Canadian provinces. The extensive reporting and mapping capabilities
of the listing include:
• Flexible searches and queries. You can select advisories by any combination
of State or Province, EPA Region (or Canada), Advisory Type, Pollutant,
Species, Affected Population, Status (active or rescinded), and Issuer. An
example would be "all PCB advisories in EPA Region 5 issued by the Federal
Government." By default, all active advisories are selected unless otherwise
specified. You can also view fish tissue data by checking the appropriate box,
Show Fish Tissue Data.
• A variety of reports, listing all advisories or just the advisories that meet your
search criteria. These reports include a summary report, reports of the
percentage of the size of each state's lakes and rivers under advisory and
assessed for advisory, and the relative increase or decrease from the previous
year in the numbers and sizes of advisories by state. A report listing the
method used to establish an advisory, the advisory contact, and phone
number by state is also included.
• On-screen maps showing the traces or counts of all advisories or only your
selected advisories. These maps can be produced on an international, national,
EPA Regional, or state or province-wide basis. You can zoom down to
particular areas, click on individual advisories to get detailed information, and
even overlay different searches in color. The maps can be printed to a file or to
your printer with your own titles. Note that about 9% of active advisories in
North America have not been georeferenced due to lack of locational
information. No locational data are available for advisories in British Columbia,
Alberta, or the Yukon Territory.
Installation
The LFWA requires a PC running Microsoft Windows 3.1 or later, a minimum of 16 MB
of RAM, and approximately 30 MB of disk space.
To Install the Program under Windows 3.1 (from floppy diskettes):
1. Place the diskette labeled Diskl -Setup in drive A: (or B:).
2. Start Microsoft Windows 3.1.
3. In the Program Manager, click on File, and then Run.
4. Type A:setup97 (or B:setup97) in the command box.
5. Click the OK button and follow the instructions on the screen.
-------
To install under Windows 95 or Windows NT 4.0 or later:
1. Click the Start button, then Run,
2. Type A:setup97 in the Open edit box, and then dick OK,
3. Follow the instructions on the screen.
Once the installation process is complete, you are ready to run the program:
1. Start Microsoft Windows 3.1 or later (not necessary in Windows 95),
2. Double click on the LFWA97 icon (select from Start/Programs in Windows 95),
3. That's it! You are now in the LFWA.
Printer Hints
The Listing uses the Windows printer drivers for printing maps and reports. The maps can be
printed in color if you have a color printer set up in your Windows Print Manager, You may
also select map orientation using the Print Manager.
Quick Tutorial
To get a feel for the Listing, try the following sequence. We will examine active (as of Decem-
ber 1997) mercury advisories in the U .S. The results of this quick tutorial will be maps showing
the location of mercury advisories and counts of mercury advisories by state and a full report
of the associated data.
Step 1: Querying
On the main menu, click Search and then By Parameter. This brings up all of the
search criteria available. Under Select Pollutant, use the scroll bars to locate
mercury. Click mercury with the left mouse button. Mercury should now be
highlighted. (By default, only active mercury advisories will be selected. Click
Rescinded in the Status box to select rescinded advisories.) At the bottom of the
window, click the View Data button. The first 250 records for all active mercury
advisories in the U.S will appear in spreadsheet format. Scroll through the list, both
up and down and sideways, to see the available information. Then click More to see
additional data. Close this window to return to the Search window.
To view fish tissue data, again click Search/By Parameter. Check the box
labeled Show Fish Tissue Data instead of Advisory Data. The tissue data list
box will be enabled. Select a state and press View Data.
Step 2: Reporting
Leave mercury highlighted in the Select Pollutant box. Now Click the Reports
button. The buttons will change to show all of the types of available reports. Click
the Summary button; the full report for mercury advisories will now be on the
screen. The directional buttons let you move back and forth through the report,
view the full page (by clicking the "magnifying glass" icon), and send the report to
the printer. Close the report window. You may want to limit records to a particular
state. In the Search window, click on a state of interest and then the Reports and
Summary buttons to view. Close the report window.
Step 3: Map of Advisories
With the Select window still open, make sure that mercury is still highlighted. Now
click on the Map Advisories button. This action will close the Select window and
prepare the system for mapping the selected mercury advisories. Since mercury
advisories span both the U.S, and Canada, the combined map will appear with the
selected advisories in red (by default). At this point, you may choose to display
information about each advisory, one at a time, by clicking on the trace of your
choice. You may also scroll through the advisories using the arrow icons on the
speed bar.
Step 4: Map Overlays
You may wish to add, for example, PCB advisories to your map of mercury adviso-
ries. You can do this by selecting the Search/By Parameter option from the main
menu again and highlighting PCBs from the pollutant list. Now click the Map
Overlay button. Then select Options/Colors/Selected Advisories from the menu
and change the color from red to green (or any available color other than red).
Then, click the Pencil icon on the speedbar. This will map the nationwide PCB
advisories, in green, on top of your mercury advisories. Note that any mercury and
PCB advisories that overlap will be green.
Step 5: Map of Advisory Counts
To make a map showing counts of active mercury advisories by state, select Search/
By Parameter from the main menu. Highlight mercury from the pollutant list as
before. Click on the Map Counts button, and a new map showing counts by state
will be drawn. You can move back and forth between your maps by selecting
Window, then the name of the window to view, or by just clicking on the window,
This completes our brief tutorial. To exit the Listing, select File/Exit or double click the "slash"
in the upper left corner of the window button (the Listing icon in the upper left corner or the
X icon in the upper right corner in Windows 95).
Main Menu
The Listing follows standard Windows protocols for user interfaces. The entire system is run
using mouse "point and click" options.
File
has one option, Exit. Exit will immediately end your Listing session.
Search opens the mapping and reporting capabilities of the Listing. There are two options:
search By Parameter or By Advisory Name. For example, if you want to examine
mercury advisories for Minnesota, select Search/By Parameter. When the Search
window appears, go down the list and select MN. Then click on mercury from the
pollutant list. Your selection is highlighted on the screen. To deselect something, just
click on it again. You can click on more than one item in a list. For instance you may
want to group the pollutants ODD, DDE, and DDT in one query; simply click on all
three pollutants. If you do not click anything, all advisories will be selected. You may
also select parameters in any combination from the other lists. Click on View Data
to display all advisories meeting your criteria. Map Advisories prepares a map of
selected advisories in red by default. Map Counts will show the number of adviso-
ries meeting the criteria by state and province. Graph Counts is used to graph
trends over time; it should be used with the 1993 through 1997 version only. Map
Overlay is useful when you want to show the results of more than one query on a
map, such as mercury and PCB advisories nationwide.
------- |