Hagen Hodgkins
Home Resume Professional Statement Research Links

Implementation of an interactive database interface utilizing HTML, PHP, JavaScript, and MySQL in support of water quality assessments in the Northeastern North Carolina Pasquotank Watershed
ECSU / 2015

The Center of Excellence in Remote Sensing Education and Research (CERSER) has implemented three research projects during the summer Research Experience for Undergraduates (REU) program gathering water quality data for local waterways. The data has been compiled manually utilizing pen and paper and then entered into a spreadsheet. With the spread of electronic devices capable of interacting with databases, the development of an electronic method of entering and manipulating the water quality data was pursued during this project.

This project focused on the development of an interactive database to gather, display, and analyze data collected from local waterways. The database and entry form was built in MySQL on a PHP server allowing participants to enter data from anywhere Internet access is available. This project then researched applying this data to the Google Maps site to provide labeling and information to users. The NIA server at is used to host the application for download and for storage of the databases.

This project was built on water quality data gathered by the Summer Research Experience for Undergraduate teams during the summers of 2014, 2013, and 2011.

Quantifying Sargassum Boundaries on Eastern and Western Walls of the Gulf Stream Protruding Near Cape Hatteras into Sargasso Sea Bermuda/Azores
ECSU / 2016

The Sargasso Sea has been a ocean life habitat for millions of years, yet accurate assessment of the boundary area and detection of these relatively small sea surface features using Landsat series and Moderate resolution Imaging Spectroradiometer (MODIS) instruments have been found to have difficulty or even impossible due to lack of spatial resolution, coverage, recurring observance,and algorithm limitations to Identify pelagic species of Sargassum. Sargassum rafts tend to be elongated, curved in the upwind direction and warmer than the surrounding ocean surface. Long weed 'trails' extending upwind from the rafts are evidence of plants dropping out and being left behind. Satellite data Utilizing a simple ocean color indexes such as the floating algae Index and Normalized Differential Vegetation Index (NDVI) have been established to detect floating algae in open environments using MODIS instruments. Floating Algae Index (FAI) has shown advantages over the traditional NDVI and Enhanced Vegetation Index (EVI) because FAI is less sensitive to changes in environmental and observing conditions (aerosol type and thickness, solar/viewing geometry, and sun glint) and can see through thin clouds. The baseline subtraction method provides a simple yet effective means for atmospheric correction. The algorithms assisted in identifying the boundary area of the Sargasso sea and the path of this floating algae past cape hatteras into the Atlantic ocean. Due to the fact that similar spectral bands are available on many existing and planned satellite sensors such as Landsat series observations satellites, the NDVI and FIA concept was extendable to establish a long-term record of these ecologically biological dependent ocean plants.