A SPREADSHEET MAPPING APPROACH FOR ERROR CHECKING AND SHARING COLLECTION POINT DATA

Authors

  • Desmond Foley Division of Entomology, Walter Reed Army Institute of Research

DOI:

https://doi.org/10.17161/bi.v7i3.3986

Keywords:

Map, Excel, Chart, Scatter plot, georeference, collection data

Abstract

The ready availability of online maps of plant and animal collection locations has drawn attention to the need for georeference accuracy. Many obvious georeference errors, for example, that map land animals over sea, the wrong hemisphere, or the wrong country, may be avoided if collectors and data providers could easily map their data points prior to publication. Various tools are available for quality control of georeference data, but many involve an investment of time to learn the software involved. This paper presents a method for the rapid map display of longitude and latitude data using the chart function in Microsoft Office Excel®, arguably the most ubiquitous spreadsheet software. Advantages of this method include: immediate visual feedback to assess data point accuracy; and results that can be easily shared with others. Methods for making custom Excel chart maps are given, and we provide free charts for the world and a selection of countries at http://www.vectormap.org/resources.htm.

Metrics

Metrics Loading ...

Downloads

Download data is not yet available.

Author Biography

  • Desmond Foley, Division of Entomology, Walter Reed Army Institute of Research
    Walter Reed Biosystematics Unit Research Entomologist

Downloads

Published

2010-11-04

Issue

Section

Articles (peer-reviewed)

How to Cite

Foley, Desmond. 2010. “A SPREADSHEET MAPPING APPROACH FOR ERROR CHECKING AND SHARING COLLECTION POINT DATA”. Biodiversity Informatics 7 (3). https://doi.org/10.17161/bi.v7i3.3986.