1 / 15

How to Use the Water Quality Results Viewer Application

How to Use the Water Quality Results Viewer Application. Kentucky Division of Mine Permits Watershed Characterization Data. After downloading the Watershed Characterization .ZIP file from the DMP Website….

akiko
Download Presentation

How to Use the Water Quality Results Viewer Application

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. How to Use the Water Quality Results Viewer Application Kentucky Division of Mine Permits Watershed Characterization Data

  2. After downloading the Watershed Characterization .ZIP file from the DMP Website… • Unzip the compressed ZIP file using the compression software application of your choice. This is usually done by just double clicking on the .ZIP file and following the prompts. • Locate the water quality results viewer Microsoft Access application – Ex. BCF_WQ_Results.MDB (the first three letters will be different depending on which watershed package you downloaded). • Make sure that you have Microsoft Access 2003 or higher installed on your computer. • Double click on the water quality viewer .MDB file to start it.

  3. You should see this form appear. It will be empty of data because there are up to four different tables of results data you can select from for most watersheds (some have fewer tables)

  4. Select your data table here This area shows statistics and status of your data records This section has buttons that control the list of data that you see. Remove 0 and negative values, restore records that you removed using a double click, make a graph or export the records to Excel. Also, reset the list to include all records. This is the list area where your data records are displayed. This area lets you filter out records you don’t want see, either by analyte, station or date range. This area lets you sort the list in ten different ways.

  5. First - Select Your Data Table Here

  6. This is the form after the SMIS Surface Water results has been selected. All results data is specific to this watershed only. Notice the presence of negative values for Acid. This data is probably not correct and should be removed. You can do this with the touch of a button.

  7. If you just want to see records for dissolved iron and dissolved manganese, just click on them to highlight and click the “GO” button next to the Analyte list. Use the same procedure for particular station IDs and dates. You can combine them anyway you need to. Remember to see all the records again in the list just click here. If you highlight something by accident, click this button to clear the selection.

  8. You can remove individual records or groups of records by highlighting (selecting) them and double clicking. These records are never deleted, just filtered out. And even if you close the form and look at it later, the data will appear exactly as you left it with any filters or sorts you might have applied to it.

  9. Here is the data with those highlighted 0.02 values removed.

  10. To restore those 0.02 values you removed by double clicking, just click on the undo button. This will restore the last set of records you removed.

  11. Click this button to make a graph automatically. Just make sure that your units are the same for all your current records in the list.

  12. Click this button to export whatever records are in the viewer’s list to an Excel spreadsheet.

  13. This area reports minimum and maximum ranges of the current list, the average, also the total count of current records and the number of sampling stations. This button will filter out result values of “0” so that you don’t have to use them in graphs, etc.

  14. You can filter the contents of the list by clicking on one or more analytes, stations, and/or date ranges and clicking the “GO” button. You can sort the list 10 different ways by clicking these buttons Watch the filter on/off (green/red) button to see if you are looking at all of the data available or have filtered some of it out. Remember that the filters you set remain set even if you close the application.

  15. The best way to get familiar with the Results Viewer is just to jump in and start pushing buttons. You can’t break anything, so have fun with it. Some important things to remember - • You can always restore all of the records by clicking the Restore to All Records button • The green/red filter status light on the left will tell you if you are looking at all the data, or just a subset of it • Any filters/sorts that you have set remain in effect until you click the restore button, even if you close the application. • When using graphs, you are able to modify/change the look of the graph by right clicking on certain parts of the graph itself. You can graph up to four analytes but they must all have the same units. • If you need help using the viewer, call (502) 564-2320 and ask for Jeffrey Laird

More Related