Extracting Duplicate Georeferences from Herbarium Specimen Data

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 duplicate is found, it determines whether the duplicate is georeferenced. If none of the duplicates are georeferenced, the code moves to the next specimen in the provided dataset. If a georeferenced duplicate is found, the code will add these data into a new output file (newMycoll) such that the unique identifier (occid) corresponds to the occid in 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 occid/specimen record).