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.

Métricas

File downloads
2,441
Jan 2011Jul 2011Jan 2012Jul 2012Jan 2013Jul 2013Jan 2014Jul 2014Jan 2015Jul 2015Jan 2016Jul 2016Jan 2017Jul 2017Jan 2018Jul 2018Jan 2019Jul 2019Jan 2020Jul 2020Jan 2021Jul 2021Jan 2022Jul 2022Jan 2023Jul 2023Jan 2024Jul 2024Jan 2025Jul 2025Jan 20269
|

Descargas

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.