Extracting Duplicate Georeferences from Herbarium Specimen Data

New version! The March 2021 (2.0) version includes a more informative georeferenceRemarks field in the output table, as well as other improvements. The code documentation has been updated accordingly.

This code was developed to rapidly georeference herbarium specimens by importing georeference data that already exist for duplicate specimens. The code looks through each record in a provided dataset and determines whether that record is found in the omoccurduplicatelink table (i.e., a duplicate has been linked to that record in your Symbiota portal). If a georeferenced duplicate is found, the code will add these data into a new output file (newMycoll) such that the unique identifier (occid), catalog number, other catalog number, collector, and collector number corresponds to those fields from the input dataset, and the georeference data is copied from the duplicate record. The user must then clean the output file so it results in one row per specimen record.