Technical Note: Using QGIS to Detect Georeferencing Errors in an Online MySQL Database


ABSTRACT The Guam Coconut Rhinoceros Beetle Eradication Project uses an online MySQL database to keep track of trapping data and observations. Point locations for traps and observations are stored as decimal degrees in fields for latitude and longitude. This note describes use of QGIS, an open source geographical information system, to find points which do not lie within Guam's shoreline. A QGIS plugin named eVis is used to connect to the online MySQL database to download and visualize georef-rerenced trap and observation data. A QGIS project and associated data which demonstrate the methods can be downloaded from

To read more, see the attached PDF.


georefErrors.zip448.63 KB
GeorefErrors.pdf154.5 KB