format.txt

occurrenceCount,

// verbatim fields in records
v_kingdom,
v_phylum,
v_class,
v_order,
v_family,
v_genus,
v_scientificName,
v_taxonRank,
v_verbatimTaxonRank,
v_specificEpithet,
v_infraSpecificEpithet,
v_scientificNameAuthorship,

// existing classification (i.e. what is in production)
kingdom,
phylum,
class,
order,
family,
genus,
species,
scientificName,
acceptedScientificName,
status


kingdomId,
phylumId,
classId,
orderId,
familyId,
genusId,
speciesId,
taxonId,
acceptedTaxonId,

// new versions
new_kingdom,
new_phylum,
new_class,
new_order,
new_family,
new_genus,
new_species,
new_scientificName,
new_acceptedScientificName,
new_status


new_kingdomId,
new_phylumId,
new_classId,
new_orderId,
new_familyId,
new_genusId,
new_speciesId,
new_taxonId,
new_acceptedTaxonId

Suggestions:

• nubID -> taxonId
• add status (accepted, syn, etc) to both old and new
• add acceptedName to both in case of synonyms

a default sorting by scientificName or new_scientificName should be good

Thanks. Sorting would happen post production using e.g. linux sort
The rest look good