An Integrated Open-Source GIS and Object-Oriented Programming Approach for the FC Contamination-free Well Depth and Age Analysis in Butuan City

摘要

This paper describes a method of an integrated Open-source Geographical Information System (GIS), Object-Oriented Programming Language and Multiple Linear Regression (MLR) approach in characterizing groundwater fecal coliform contamination and determination of safe depth and safe age for prospect well sites through an interactive user interface. GIS geospatial analyses and MLR were employed to determine the models that will describe the safe well depth and age of prospect sites considering the percent distributions of built-up and cropland areas within its potential contributing area and of persons using the well was significant factors. Derived models yielded an R2 of 0.727 for safe depth and 0.801 for safe age. The Graphical User Interface (GUI) of the system was created and programmed in Visual Basic 2008 Express Edition implemented in .Net Framework 3.5. The GIS layers were displayed through the use of Map Control from Active X component of Map Window. Hence, the developed GUI provided and easy and fast access of the valuable information that can guide users on the depth and longest duration of a prospect well will be safe from fecal coliform contamination.