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

Autores/as

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

DOI:

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

Palabras clave:

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

Resumen

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.

Descargas

Los datos de descarga aún no están disponibles.

Biografía del autor/a

  • Desmond Foley, Division of Entomology, Walter Reed Army Institute of Research
    Walter Reed Biosystematics Unit Research Entomologist
Be sure to read Vol. 7 No. 2 (2010) available in the archives.

Descargas

Publicado

2010-11-04

Número

Vol. 7 Núm. 3 (2011)

Sección

Articles (peer-reviewed)

Licencia

Copyright for articles published in this journal is retained by the authors, with first publication rights granted to the journal. All articles are licensed under a Creative Commons Attribution Non-Commercial license.

Competing Interests: The authors have declared that no competing interests exist.

Cómo citar

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.