You can choose to enter one or many search criteria – WBID, Waterbody Name, or County. Then Click the Search button.

After the search is performed, a list of results is displayed below the search criteria. In the example below Adair County was selected. Only the Streams/Lakes that have data associated with them will show up. The Waterbody Name is a link, select the waterbody name you wish to find data for then click on it. For this example we will select Blackbird Cr.

After clicking on the Waterbody Name we want, we are presented with a second search/results screen. If there are less than 1000 samples then all samples will be displayed, if more than 1000 exist then the search must be further narrowed by: Media Type (Water, Sediment, Tissue), Site Code (if known), and/or a Date Range. (This can also be used to filter search results that return less than 1000) For our example there are only five samples that exist, so all are displayed.

From this screen two options are available:

  • You can view the individual samples by clicking the “View” link,   or
  • You can export all of the samples shown on the screen by clicking on the “Export Sample Data” button.
    • This outputs the data into an XML format. To view this in MS Excel, Open Excel then use Excel to open the file that was just downloaded.
    • You will see three choices for opening the XML file:

    • Select the first option (As an XML list) and click ‘OK’.  You will get another message:
      Screen Shot
    • Click ‘OK’ (you can also choose not to see this message again).  The data will be displayed in Excel.