Projects > Monitoring Pesticides
Application for Viewing and Statistical Analysis
As part of this project, it was necessary to develop an interactive application that would allow users to (1) view the results of chemical analyses in conjunction with relevant GIS data layers and (2) conduct statistical analyses. The application was developed using Visual Basic and ESRI's MapObjects by Alex Zlotin, Indiana Geological Survey.
Chemical Data Viewer
The Visual Basic application was created for viewing chemical data using GIS data layers (in the form of shapefiles) and a Microsoft Access database. This page illustrates how the application will operate, once a complete set of actual data become available.
constructed (one of locations of monitoring sites and another of chemical parameters). The figures below briefly illustrate the functionality of the chemical data viewer, using this fictitious data.
The data initially will be entered into the Pestnet Database (created by Robert Hamilton), and subsequently, imported into the specially designed Access database from which the application reads its data. Thorough testing by IGS personnel, using a complete set of actual data, will be used to modify and refine the application.
The application combines a viewer for GIS data layers and sampling results, and a statistical routine. The map on the left includes statewide data layers which can be turned on or off by checking corresponding checkboxes in the "Show layer" list. Individual features of either of these layers may be queried, once a layer to be queried is selected, by checking a checkbox in the "ID LAYER" list, and the identify tool button is pressed on the toolbar. Besides the "Identify" tool, the toolbar contains the map navigation buttons ("Zoom in" and "Zoom out," "Pan," and "Full Extent"), which allow the user to focus on a region of interest. |
|
 |
The query results are displayed in a separate window. If the layer containing sampling wells is queried, the identify tool displays additionally the results of chemical analyses for the season specified in the "Set 1 - Season" drop-down list. The chemistry data are read from the linked Access database. |
The application allows the user to plot values of a chemical parameter in a specified season at a certain hydrogeologic setting, with indication of whether the values exceed maximum allowable concentrations for this chemical parameter. Season, setting, and chemical parameter should be selected from the first set of drop-down lists ("Set 1"). Once the button "Plot values" is pressed, chemical values will be plotted in the map with square symbols. The size of each box is proportional to the concentration of the chemical component. If the concentration is below maximum allowable concentration, the square symbol is blue, and red otherwise. At full extent, actual concentration values are not visible in the map; they are displayed at greater scale to avoid cluttering of the map. The "Clear" button clears the chemical parameter selection from the map. |
|
 |
The statistical routine is launched by pressing the "Statistics" button. Before that, data to be compared must be specified from the two sets of drop-down lists ("Set 1" and "Set 2"). After computation is completed, a window with results is displayed. The results can be saved to a text file by pressing the "Save" button. |
Back to FRONT PAGE
Geology | GIS/Maps | About Us | Bookstore | Interactive Maps | Licensing
IGSInfo@indiana.edu / 812-855-7636
Accessibility Information
Copyright, Map Disclaimer, and Limitation of Warranties and Liability