Project

General

Profile

« Previous | Next » 

Revision 5646

Added by Aaron Marcuse-Kubitza over 11 years ago

mappings/VegCore-VegBIEN.csv: Also create the identifyingtaxonomicname on the verbatim taxonlabel supplied by the datasource, in addition to on the TNRS input taxonlabel that the verbatim taxonlabel is matched up with

View differences:

inputs/CTFS/StemObservation/VegBIEN.csv
26 26 
SpeciesName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
27 27 
SubSpeciesName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/4",
28 28 
SpeciesAuthority,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/2",
29 
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
30 
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
31 
SpeciesName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
32 
SubSpeciesName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/4",
33 
SpeciesAuthority,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/2",
34 29 
SpeciesAuthority,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/author,
35 30 
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/family,
36 31 
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/genus,
32 
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,
33 
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2,
34 
SpeciesName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1,
35 
SubSpeciesName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/4,
36 
SpeciesAuthority,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/2,
37 37 
SubSpeciesName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=subspecies]/taxonepithet",
38 38 
SpeciesName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=species]/taxonepithet",
39 39 
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/taxonepithet",
inputs/CTFS/TaxonOccurrence/VegBIEN.csv
13 13 
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
14 14 
SpeciesName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
15 15 
SubSpeciesName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/4",
16 
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
17 
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
18 
SpeciesName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
19 
SubSpeciesName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/4",
20 16 
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/family,
21 17 
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/genus,
18 
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,
19 
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2,
20 
SpeciesName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1,
21 
SubSpeciesName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/4,
22 22 
SubSpeciesName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=subspecies]/taxonepithet",
23 23 
SpeciesName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=species]/taxonepithet",
24 24 
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/taxonepithet",
inputs/FIA/Organism/VegBIEN.csv
18 18 
TreeTag,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/1/_first/2",
19 19 
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
20 20 
SpecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
21 
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
22 
SpecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
23 21 
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/genus,
22 
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2,
23 
SpecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1,
24 24 
SpecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=species]/taxonepithet",
25 25 
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/taxonepithet",
26 26 
SpecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/species,
inputs/SALVIAS/plotObservations/VegBIEN.csv
64 64 
infra_rank_1,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then",
65 65 
infra_ep_1,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2",
66 66 
auth,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/2",Brad: This is the author of the scientificName.
67 
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
68 
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
69 
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
70 
infra_ep_1,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond",
71 
infra_rank_1,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then",
72 
infra_ep_1,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2",
73 
auth,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/2",Brad: This is the author of the scientificName.
74 67 
auth,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/author,Brad: This is the author of the scientificName.
75 68 
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/family,
76 69 
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/genus,
70 
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,
71 
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2,
72 
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1,
73 
infra_ep_1,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond",
74 
infra_rank_1,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then",
75 
infra_ep_1,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2,
76 
auth,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/2,Brad: This is the author of the scientificName.
77 77 
infra_rank_1,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/rank",
78 78 
infra_rank_1,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/verbatimrank",
79 79 
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=species]/taxonepithet",
inputs/.TNRS/tnrs/VegBIEN.csv
10 10 
Name_matched_rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then",
11 11 
Infraspecific_epithet_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2",
12 12 
Name_matched_author,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/2",Contains author based on matched name
13 
Name_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1",
14 
Name_matched_accepted_family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",Contains family based on matched name
15 
Genus_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
16 
Specific_epithet_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
17 
Infraspecific_epithet_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond",
18 
Name_matched_rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then",
19 
Infraspecific_epithet_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2",
20 
Name_matched_author,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/2",Contains author based on matched name
21 13 
Accepted_name_author,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/author,
22 14 
Accepted_name,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/binomial,
23 15 
Accepted_name_family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/family,
......
35 27 
Name_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/binomial,
36 28 
Name_matched_accepted_family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/family,Contains family based on matched name
37 29 
Genus_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/genus,
30 
Name_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1,
31 
Name_matched_accepted_family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,Contains family based on matched name
32 
Genus_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2,
33 
Specific_epithet_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1,
34 
Infraspecific_epithet_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond",
35 
Name_matched_rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then",
36 
Infraspecific_epithet_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2,
37 
Name_matched_author,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/2,Contains author based on matched name
38 38 
Name_submitted,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/morphospecies/_if[@name=""if has verbatim name""]/cond/_exists",
39 39 
Unmatched_terms,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/morphospecies/_if[@name=""if has verbatim name""]/else",
40 40 
Name_matched_rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/rank",
......
55 55 
Genus_score,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/matched_label_fit_fraction/_max/2,
56 56 
Specific_epithet_score,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/matched_label_fit_fraction/_max/3,
57 57 
Overall_score,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/matched_label_fit_fraction/_max/4,Assuming is a fraction based on the range of values
58 
Unmatched_terms,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/morphospecies,
58 59 
Name_submitted,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/morphospecies/_if[@name=""if has verbatim name""]/cond/_exists",
59 
Unmatched_terms,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/morphospecies/_if[@name=""if has verbatim name""]/then",
60 60 
Specific_epithet_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/species,
61 61 
Infraspecific_rank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/verbatimrank,
62 62 
Taxonomic_status,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonstatus,
inputs/U/Specimen/test.xml.ref
103 103 
                                    </creator_id>
104 104 
                                    <family>$Family</family>
105 105 
                                    <genus>$Genus</genus>
106 
                                    <identifyingtaxonomicname>
107 
                                        <_join_words>
108 
                                            <1>$Family</1>
109 
                                            <2>$Genus</2>
110 
                                        </_join_words>
111 
                                    </identifyingtaxonomicname>
106 112 
                                    <parent_id>
107 113 
                                        <taxonlabel>
108 114 
                                            <parent_id>
......
198 204 
        </path>
199 205 
    </_simplifyPath>
200 206 
</VegBIEN>
201 
Inserted 29 new rows into database
207 
Inserted 30 new rows into database
inputs/GBIF/Specimen/VegBIEN.csv
21 21 
InfraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond",
22 22 
InfraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2",
23 23 
AuthorOfScientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/2",
24 
ScientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1",
25 
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
26 
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
27 
SpecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
28 
InfraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond",
29 
InfraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2",
30 
AuthorOfScientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/2",
31 24 
AuthorOfScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/author,
32 25 
ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/binomial,
33 26 
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/creator_id/_simplifyPath:[next=creator_id]/path/party/fullname/_alt/2,
34 27 
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/family,
35 28 
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/genus,
29 
ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1,
30 
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,
31 
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2,
32 
SpecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1,
33 
InfraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond",
34 
InfraspecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2,
35 
AuthorOfScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/2,
36 36 
SpecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=species]/taxonepithet",
37 37 
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/taxonepithet",
38 38 
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=family]/taxonepithet",
inputs/MT/Specimen/VegBIEN.csv
13 13 
id,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/3,
14 14 
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
15 15 
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
16 
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
17 
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
18 16 
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/family,
19 17 
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/genus,
18 
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,
19 
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2,
20 20 
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/taxonepithet",
21 21 
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=family]/taxonepithet",
22 22 
locality,/location/locationnarrative/_merge/1,
inputs/MT/Specimen/test.xml.ref
60 60 
                                    </matched_label_id>
61 61 
                                    <family>$family</family>
62 62 
                                    <genus>$genus</genus>
63 
                                    <identifyingtaxonomicname>
64 
                                        <_join_words>
65 
                                            <1>$family</1>
66 
                                            <2>$genus</2>
67 
                                        </_join_words>
68 
                                    </identifyingtaxonomicname>
63 69 
                                    <parent_id>
64 70 
                                        <taxonlabel>
65 71 
                                            <parent_id>
......
112 118 
        </path>
113 119 
    </_simplifyPath>
114 120 
</VegBIEN>
115 
Inserted 23 new rows into database
121 
Inserted 24 new rows into database
inputs/test_taxonomic_names/Taxon/VegBIEN.csv
1 1 
test_taxonomic_names,VegBIEN:/_simplifyPath:[next=parent_id]/path,Comments
2 2 
scientificName,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/3",
3 3 
scientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1",
4 
scientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1",
5 4 
scientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/binomial,
5 
scientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1,
6 6 
scientificNameID,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/sourceaccessioncode,
inputs/test_taxonomic_names/Taxon/test.xml.ref
21 21 
                                        </taxonlabel>
22 22 
                                    </matched_label_id>
23 23 
                                    <binomial>$scientificName</binomial>
24 
                                    <identifyingtaxonomicname>$scientificName</identifyingtaxonomicname>
24 25 
                                    <sourceaccessioncode>$scientificNameID</sourceaccessioncode>
25 26 
                                </taxonlabel>
26 27 
                            </taxonlabel_id>
inputs/XAL/Specimen/VegBIEN.csv
27 27 
darwin:Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
28 28 
darwin:Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/4",
29 29 
darwin:ScientificNameAuthor,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/2",
30 
darwin:ScientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1",
31 
darwin:Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
32 
darwin:Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
33 
darwin:Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
34 
darwin:Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/4",
35 
darwin:ScientificNameAuthor,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/2",
36 30 
darwin:ScientificNameAuthor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/author,
37 31 
darwin:ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/binomial,
38 32 
darwin:DayIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/creationdate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value",
......
41 35 
darwin:IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/creator_id/_simplifyPath:[next=creator_id]/path/party/fullname/_alt/2,
42 36 
darwin:Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/family,
43 37 
darwin:Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/genus,
38 
darwin:ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1,
39 
darwin:Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,
40 
darwin:Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2,
41 
darwin:Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1,
42 
darwin:Subspecies,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/4,
43 
darwin:ScientificNameAuthor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/2,
44 44 
darwin:Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=subspecies]/taxonepithet",
45 45 
darwin:Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=species]/taxonepithet",
46 46 
darwin:Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/taxonepithet",
inputs/TEAM/VL/VegBIEN.csv
23 23 
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
24 24 
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
25 25 
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
26 
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
27 
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
28 
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
29 26 
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/family,
30 27 
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/genus,
28 
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,
29 
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2,
30 
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1,
31 31 
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=species]/taxonepithet",
32 32 
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/taxonepithet",
33 33 
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=family]/taxonepithet",
inputs/TEAM/VL/test.xml.ref
63 63 
                                    </matched_label_id>
64 64 
                                    <family>$Family</family>
65 65 
                                    <genus>$Genus</genus>
66 
                                    <identifyingtaxonomicname>
67 
                                        <_join_words>
68 
                                            <1>$Family</1>
69 
                                            <2>$Genus</2>
70 
                                            <3>$Species</3>
71 
                                        </_join_words>
72 
                                    </identifyingtaxonomicname>
66 73 
                                    <parent_id>
67 74 
                                        <taxonlabel>
68 75 
                                            <parent_id>
......
116 123 
        </path>
117 124 
    </_simplifyPath>
118 125 
</VegBIEN>
119 
Inserted 30 new rows into database
126 
Inserted 32 new rows into database
inputs/TEAM/VT/VegBIEN.csv
23 23 
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
24 24 
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
25 25 
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
26 
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
27 
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
28 
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
29 26 
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/family,
30 27 
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/genus,
28 
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,
29 
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2,
30 
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1,
31 31 
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=species]/taxonepithet",
32 32 
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/taxonepithet",
33 33 
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=family]/taxonepithet",
inputs/TEAM/VT/test.xml.ref
63 63 
                                    </matched_label_id>
64 64 
                                    <family>$Family</family>
65 65 
                                    <genus>$Genus</genus>
66 
                                    <identifyingtaxonomicname>
67 
                                        <_join_words>
68 
                                            <1>$Family</1>
69 
                                            <2>$Genus</2>
70 
                                            <3>$Species</3>
71 
                                        </_join_words>
72 
                                    </identifyingtaxonomicname>
66 73 
                                    <parent_id>
67 74 
                                        <taxonlabel>
68 75 
                                            <parent_id>
......
116 123 
        </path>
117 124 
    </_simplifyPath>
118 125 
</VegBIEN>
119 
Inserted 27 new rows into database
126 
Inserted 29 new rows into database
inputs/NY/Specimen/VegBIEN.csv
32 32 
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
33 33 
Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/4",
34 34 
ScientificNameAuthor,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/2",
35 
ScientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1",
36 
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
37 
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
38 
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
39 
Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/4",
40 
ScientificNameAuthor,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/2",
41 35 
ScientificNameAuthor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/author,
42 36 
ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/binomial,
43 37 
DayIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/creationdate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value",
......
46 40 
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/creator_id/_simplifyPath:[next=creator_id]/path/party/fullname/_alt/2,
47 41 
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/family,
48 42 
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/genus,
43 
ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1,
44 
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,
45 
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2,
46 
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1,
47 
Subspecies,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/4,
48 
ScientificNameAuthor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/2,
49 49 
Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=subspecies]/taxonepithet",
50 50 
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=species]/taxonepithet",
51 51 
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/taxonepithet",
inputs/NY/Specimen/test.xml.ref
172 172 
                                    </creator_id>
173 173 
                                    <family>$Family</family>
174 174 
                                    <genus>$Genus</genus>
175 
                                    <identifyingtaxonomicname>
176 
                                        <_join_words>
177 
                                            <1>
178 
                                                <_alt>
179 
                                                    <1>$ScientificName</1>
180 
                                                    <2>
181 
                                                        <_join_words>
182 
                                                            <1>$Family</1>
183 
                                                            <2>$Genus</2>
184 
                                                            <3>$Species</3>
185 
                                                            <4>$Subspecies</4>
186 
                                                        </_join_words>
187 
                                                    </2>
188 
                                                </_alt>
189 
                                            </1>
190 
                                            <2>$ScientificNameAuthor</2>
191 
                                        </_join_words>
192 
                                    </identifyingtaxonomicname>
175 193 
                                    <parent_id>
176 194 
                                        <taxonlabel>
177 195 
                                            <parent_id>
inputs/Madidi/Organism/VegBIEN.csv
36 36 
Genera,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
37 37 
Specific epithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
38 38 
Autor (revised),"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/2",
39 
Specie+autor,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/1",
40 
Species and morphotypes,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1","Contains less than ""Specie+autor"""
41 
Family (revised),"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
42 
Genera,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
43 
Specific epithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
44 
Autor (revised),"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/2",
45 39 
Autor (revised),/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/author,
46 40 
Species and morphotypes,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/binomial,"Contains less than ""Specie+autor"""
47 41 
Determined by,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/creator_id/_simplifyPath:[next=creator_id]/path/party/fullname/_alt/2,
48 42 
Family (revised),/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/family,
49 43 
Genera,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/genus,
44 
Specie+autor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/1,
45 
Species and morphotypes,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1,"Contains less than ""Specie+autor"""
46 
Family (revised),/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,
47 
Genera,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2,
48 
Specific epithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1,
49 
Autor (revised),/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/2,
50 50 
Specific epithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=species]/taxonepithet",
51 51 
Genera,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/taxonepithet",
52 52 
Family (revised),"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=family]/taxonepithet",
inputs/Madidi/Organism/test.xml.ref
106 106 
                                    </creator_id>
107 107 
                                    <family>$Family (revised)</family>
108 108 
                                    <genus>$Genera</genus>
109 
                                    <identifyingtaxonomicname>
110 
                                        <_alt>
111 
                                            <1>$Specie+autor</1>
112 
                                            <2>
113 
                                                <_join_words>
114 
                                                    <1>
115 
                                                        <_alt>
116 
                                                            <1>$Species and morphotypes</1>
117 
                                                            <2>
118 
                                                                <_join_words>
119 
                                                                    <1>$Family (revised)</1>
120 
                                                                    <2>$Genera</2>
121 
                                                                    <3>$Specific epithet</3>
122 
                                                                </_join_words>
123 
                                                            </2>
124 
                                                        </_alt>
125 
                                                    </1>
126 
                                                    <2>$Autor (revised)</2>
127 
                                                </_join_words>
128 
                                            </2>
129 
                                        </_alt>
130 
                                    </identifyingtaxonomicname>
109 131 
                                    <parent_id>
110 132 
                                        <taxonlabel>
111 133 
                                            <parent_id>
inputs/UNCC/Specimen/VegBIEN.csv
51 51 
infrarank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then/_alt/2",
52 52 
infraname,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2",
53 53 
authors,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/2",
54 
SciName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1",
55 
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
56 
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
57 
species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
58 
infraname,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond",
59 
usdaRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then/_alt/1",
60 
infrarank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then/_alt/2",
61 
infraname,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2",
62 
authors,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/2",
63 54 
authors,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/author,
64 55 
SciName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/binomial,
65 56 
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/family,
66 57 
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/genus,
58 
SciName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1,
59 
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,
60 
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2,
61 
species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1,
62 
infraname,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond",
63 
usdaRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then/_alt/1",
64 
infrarank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then/_alt/2",
65 
infraname,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2,
66 
authors,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/2,
67 67 
usdaRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/rank/_alt/1",
68 68 
infrarank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/rank/_alt/2",
69 69 
usdaRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/verbatimrank/_alt/1",
inputs/UNCC/Specimen/test.xml.ref
119 119 
                                    <binomial>$SciName</binomial>
120 120 
                                    <family>$family</family>
121 121 
                                    <genus>$genus</genus>
122 
                                    <identifyingtaxonomicname>
123 
                                        <_join_words>
124 
                                            <1>
125 
                                                <_alt>
126 
                                                    <1>$SciName</1>
127 
                                                    <2>
128 
                                                        <_join_words>
129 
                                                            <1>$family</1>
130 
                                                            <2>$genus</2>
131 
                                                            <3>$species</3>
132 
                                                            <5>
133 
                                                                <_join_words>
134 
                                                                    <1>
135 
                                                                        <_if name="if has infraspecificEpithet">
136 
                                                                            <cond>$infraname</cond>
137 
                                                                            <then>
138 
                                                                                <_alt>
139 
                                                                                    <1>$usdaRank</1>
140 
                                                                                    <2>$infrarank</2>
141 
                                                                                </_alt>
142 
                                                                            </then>
143 
                                                                        </_if>
144 
                                                                    </1>
145 
                                                                    <2>$infraname</2>
146 
                                                                </_join_words>
147 
                                                            </5>
148 
                                                        </_join_words>
149 
                                                    </2>
150 
                                                </_alt>
151 
                                            </1>
152 
                                            <2>$authors</2>
153 
                                        </_join_words>
154 
                                    </identifyingtaxonomicname>
122 155 
                                    <parent_id>
123 156 
                                        <taxonlabel>
124 157 
                                            <rank>
......
224 257 
        </path>
225 258 
    </_simplifyPath>
226 259 
</VegBIEN>
227 
Inserted 22 new rows into database
260 
Inserted 23 new rows into database
inputs/ACAD/Specimen/VegBIEN.csv
28 28 
taxonRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then",
29 29 
infraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2",
30 30 
scientificNameAuthorship,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/2",
31 
scientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/1",
32 
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
33 
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
34 
specificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
35 
infraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond",
36 
taxonRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then",
37 
infraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2",
38 
scientificNameAuthorship,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/2",
39 31 
scientificNameAuthorship,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/author,
40 32 
dateIdentified,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/creationdate/_alt/1/_*/date/_dateRangeStart/value,
41 33 
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/creator_id/_simplifyPath:[next=creator_id]/path/party/fullname/_alt/2,
42 34 
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/family,
43 35 
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/genus,
36 
scientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/1,
37 
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,
38 
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2,
39 
specificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1,
40 
infraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond",
41 
taxonRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then",
42 
infraspecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2,
43 
scientificNameAuthorship,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/2,
44 44 
taxonRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/rank",
45 45 
taxonRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/verbatimrank",
46 46 
specificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=species]/taxonepithet",
inputs/ACAD/Specimen/test.xml.ref
117 117 
                                    </creator_id>
118 118 
                                    <family>$family</family>
119 119 
                                    <genus>$genus</genus>
120 
                                    <identifyingtaxonomicname>
121 
                                        <_alt>
122 
                                            <1>$scientificName</1>
123 
                                            <2>
124 
                                                <_join_words>
125 
                                                    <1>
126 
                                                        <_join_words>
127 
                                                            <1>$family</1>
128 
                                                            <2>$genus</2>
129 
                                                            <3>$specificEpithet</3>
130 
                                                            <5>
131 
                                                                <_join_words>
132 
                                                                    <1>
133 
                                                                        <_if name="if has infraspecificEpithet">
134 
                                                                            <cond>$infraspecificEpithet</cond>
135 
                                                                            <then>$taxonRank</then>
136 
                                                                        </_if>
137 
                                                                    </1>
138 
                                                                    <2>$infraspecificEpithet</2>
139 
                                                                </_join_words>
140 
                                                            </5>
141 
                                                        </_join_words>
142 
                                                    </1>
143 
                                                    <2>$scientificNameAuthorship</2>
144 
                                                </_join_words>
145 
                                            </2>
146 
                                        </_alt>
147 
                                    </identifyingtaxonomicname>
120 148 
                                    <parent_id>
121 149 
                                        <taxonlabel>
122 150 
                                            <rank>$taxonRank</rank>
inputs/.NCBI/higher_taxa/VegBIEN.csv
1 1 
NCBI,VegBIEN:/_simplifyPath:[next=parent_id]/path,Comments
2 2 
rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then",
3 3 
name_txt,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/6",
4 
rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then",
5 
name_txt,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/6",
6 4 
parent tax_id,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_taxonlabel_set_parent_id/parent_id/taxonlabel/sourceaccessioncode,
5 
rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then",
6 
name_txt,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/6,
7 7 
parent tax_id,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/cond/_exists",
8 8 
rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/rank",
9 9 
rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/verbatimrank",
inputs/.NCBI/higher_taxa/test.xml.ref
21 21 
                                        </taxonlabel>
22 22 
                                    </matched_label_id>
23 23 
                                    <_taxonlabel_set_parent_id><parent_id><taxonlabel><sourceaccessioncode>$parent tax_id</sourceaccessioncode></taxonlabel></parent_id></_taxonlabel_set_parent_id>
24 
                                    <identifyingtaxonomicname>$name_txt</identifyingtaxonomicname>
24 25 
                                    <rank>$rank</rank>
25 26 
                                    <sourceaccessioncode>$tax_id</sourceaccessioncode>
26 27 
                                    <taxonepithet>$name_txt</taxonepithet>
inputs/SALVIAS-CSV/Organism/VegBIEN.csv
71 71 
infra_rank_1,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then",
72 72 
infra_ep_1,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2",
73 73 
specific_authority,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/2",Brad: This is the author of the scientificName.
74 
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
75 
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
76 
specific_epithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
77 
infra_ep_1,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond",
78 
infra_rank_1,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then",
79 
infra_ep_1,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2",
80 
specific_authority,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/2",Brad: This is the author of the scientificName.
81 74 
specific_authority,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/author,Brad: This is the author of the scientificName.
82 75 
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/family,
83 76 
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/genus,
77 
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,
78 
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2,
79 
specific_epithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1,
80 
infra_ep_1,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond",
81 
infra_rank_1,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then",
82 
infra_ep_1,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2,
83 
specific_authority,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/2,Brad: This is the author of the scientificName.
84 84 
infra_rank_1,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/rank",
85 85 
infra_rank_1,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/verbatimrank",
86 86 
specific_epithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=species]/taxonepithet",
inputs/SALVIAS-CSV/Organism/test.xml.ref
183 183 
                                    <author>$specific_authority</author>
184 184 
                                    <family>$family</family>
185 185 
                                    <genus>$genus</genus>
186 
                                    <identifyingtaxonomicname>
187 
                                        <_join_words>
188 
                                            <1>
189 
                                                <_join_words>
190 
                                                    <1>$family</1>
191 
                                                    <2>$genus</2>
192 
                                                    <3>$specific_epithet</3>
193 
                                                    <5>
194 
                                                        <_join_words>
195 
                                                            <1>
196 
                                                                <_if name="if has infraspecificEpithet">
197 
                                                                    <cond>$infra_ep_1</cond>
198 
                                                                    <then>$infra_rank_1</then>
199 
                                                                </_if>
200 
                                                            </1>
201 
                                                            <2>$infra_ep_1</2>
202 
                                                        </_join_words>
203 
                                                    </5>
204 
                                                </_join_words>
205 
                                            </1>
206 
                                            <2>$specific_authority</2>
207 
                                        </_join_words>
208 
                                    </identifyingtaxonomicname>
186 209 
                                    <parent_id>
187 210 
                                        <taxonlabel>
188 211 
                                            <rank>$infra_rank_1</rank>
......
335 358 
        </path>
336 359 
    </_simplifyPath>
337 360 
</VegBIEN>
338 
Inserted 46 new rows into database
361 
Inserted 48 new rows into database
inputs/CVS/Organism/VegBIEN.csv
11 11 
authorObsCode,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",
12 12 
currentTaxonName sec Weakley 2006,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/3",
13 13 
currentTaxonName sec Weakley 2006,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1",
14 
currentTaxonName sec Weakley 2006,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1",
15 14 
currentTaxonName sec Weakley 2006,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/binomial,
15 
currentTaxonName sec Weakley 2006,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1,
16 16 
county,/location/locationplace/*_id/placepath/county,
17 17 
state,/location/locationplace/*_id/placepath/stateprovince,
18 18 
confidentialityStatus,,** No join mapping for *confidentialityStatus **
inputs/CVS/Organism/test.xml.ref
43 43 
                                        </taxonlabel>
44 44 
                                    </matched_label_id>
45 45 
                                    <binomial>$currentTaxonName sec Weakley 2006</binomial>
46 
                                    <identifyingtaxonomicname>$currentTaxonName sec Weakley 2006</identifyingtaxonomicname>
46 47 
                                </taxonlabel>
47 48 
                            </taxonlabel_id>
48 49 
                        </taxondetermination>
inputs/REMIB/Specimen/VegBIEN.csv
36 36 
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
37 37 
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
38 38 
specificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
39 
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
40 
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
41 
specificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
42 39 
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/family,
43 40 
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/genus,
41 
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,
42 
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2,
43 
specificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1,
44 44 
specificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=species]/taxonepithet",
45 45 
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/taxonepithet",
46 46 
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=family]/taxonepithet",
inputs/REMIB/Specimen/test.xml.ref
83 83 
                                    </matched_label_id>
84 84 
                                    <family>$family</family>
85 85 
                                    <genus>$genus</genus>
86 
                                    <identifyingtaxonomicname>
87 
                                        <_join_words>
88 
                                            <1>$family</1>
89 
                                            <2>$genus</2>
90 
                                            <3>$specificEpithet</3>
91 
                                        </_join_words>
92 
                                    </identifyingtaxonomicname>
86 93 
                                    <parent_id>
87 94 
                                        <taxonlabel>
88 95 
                                            <parent_id>
......
156 163 
        </path>
157 164 
    </_simplifyPath>
158 165 
</VegBIEN>
159 
Inserted 25 new rows into database
166 
Inserted 26 new rows into database
inputs/CTFS/StemObservation/test.xml.ref
67 67 
                                    <author>$SpeciesAuthority</author>
68 68 
                                    <family>$Family</family>
69 69 
                                    <genus>$Genus</genus>
70 
                                    <identifyingtaxonomicname>
71 
                                        <_join_words>
72 
                                            <1>
73 
                                                <_join_words>
74 
                                                    <1>$Family</1>
75 
                                                    <2>$Genus</2>
76 
                                                    <3>$SpeciesName</3>
77 
                                                    <4>$SubSpeciesName</4>
78 
                                                </_join_words>
79 
                                            </1>
80 
                                            <2>$SpeciesAuthority</2>
81 
                                        </_join_words>
82 
                                    </identifyingtaxonomicname>
70 83 
                                    <parent_id>
71 84 
                                        <taxonlabel>
72 85 
                                            <parent_id>
inputs/CTFS/TaxonOccurrence/test.xml.ref
32 32 
                                    </matched_label_id>
33 33 
                                    <family>$Family</family>
34 34 
                                    <genus>$Genus</genus>
35 
                                    <identifyingtaxonomicname>
36 
                                        <_join_words>
37 
                                            <1>$Family</1>
38 
                                            <2>$Genus</2>
39 
                                            <3>$SpeciesName</3>
40 
                                            <4>$SubSpeciesName</4>
41 
                                        </_join_words>
42 
                                    </identifyingtaxonomicname>
35 43 
                                    <parent_id>
36 44 
                                        <taxonlabel>
37 45 
                                            <parent_id>
......
85 93 
        </path>
86 94 
    </_simplifyPath>
87 95 
</VegBIEN>
88 
Inserted 16 new rows into database
96 
Inserted 18 new rows into database
inputs/FIA/Organism/test.xml.ref
79 79 
                                        </taxonlabel>
80 80 
                                    </matched_label_id>
81 81 
                                    <genus>$Genus</genus>
82 
                                    <identifyingtaxonomicname>
83 
                                        <_join_words>
84 
                                            <2>$Genus</2>
85 
                                            <3>$SpecificEpithet</3>
86 
                                        </_join_words>
87 
                                    </identifyingtaxonomicname>
82 88 
                                    <parent_id>
83 89 
                                        <taxonlabel>
84 90 
                                            <parent_id>
......
133 139 
        </path>
134 140 
    </_simplifyPath>
135 141 
</VegBIEN>
136 
Inserted 23 new rows into database
142 
Inserted 25 new rows into database
inputs/SALVIAS/plotObservations/test.xml.ref
154 154 
                                    <author>$auth</author>
155 155 
                                    <family>$Family</family>
156 156 
                                    <genus>$Genus</genus>
157 
                                    <identifyingtaxonomicname>
158 
                                        <_join_words>
159 
                                            <1>
160 
                                                <_join_words>
161 
                                                    <1>$Family</1>
162 
                                                    <2>$Genus</2>
163 
                                                    <3>$Species</3>
164 
                                                    <5>
165 
                                                        <_join_words>
166 
                                                            <1>
167 
                                                                <_if name="if has infraspecificEpithet">
168 
                                                                    <cond>$infra_ep_1</cond>
169 
                                                                    <then>$infra_rank_1</then>
170 
                                                                </_if>
171 
                                                            </1>
172 
                                                            <2>$infra_ep_1</2>
173 
                                                        </_join_words>
174 
                                                    </5>
175 
                                                </_join_words>
176 
                                            </1>
177 
                                            <2>$auth</2>
178 
                                        </_join_words>
179 
                                    </identifyingtaxonomicname>
157 180 
                                    <parent_id>
158 181 
                                        <taxonlabel>
159 182 
                                            <rank>$infra_rank_1</rank>
inputs/U/Specimen/VegBIEN.csv
16 16 
Detby,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/fullname,
17 17 
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
18 18 
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
19 
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
20 
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
21 19 
Detyy,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/creationdate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value",
22 20 
Detby,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/creator_id/_simplifyPath:[next=creator_id]/path/party/fullname/_alt/2,
23 21 
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/family,
24 22 
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/genus,
23 
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,
24 
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2,
25 25 
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/taxonepithet",
26 26 
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=family]/taxonepithet",
27 27 
Detyy,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value",
inputs/ARIZ/Specimen/test.xml.ref
171 171 
                                    </creator_id>
172 172 
                                    <family>$Family</family>
173 173 
                                    <genus>$Genus</genus>
174 
                                    <identifyingtaxonomicname>
175 
                                        <_alt>
176 
                                            <1>$ScientificNameAuthor</1>
177 
                                            <2>
178 
                                                <_alt>
179 
                                                    <1>$ScientificName</1>
180 
                                                    <2>
181 
                                                        <_join_words>
182 
                                                            <1>$Family</1>
183 
                                                            <2>$Genus</2>
184 
                                                            <3>$Species</3>
185 
                                                            <4>$Subspecies</4>
186 
                                                        </_join_words>
187 
                                                    </2>
188 
                                                </_alt>
189 
                                            </2>
190 
                                        </_alt>
191 
                                    </identifyingtaxonomicname>
174 192 
                                    <parent_id>
175 193 
                                        <taxonlabel>
176 194 
                                            <parent_id>
inputs/NCU-NCSC/Specimen/VegBIEN.csv
15 15 
Cultivated?,/location/locationevent/taxonoccurrence/iscultivated/_alt/1,
16 16 
Accession Number,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/3,
17 17 
Full Taxon Name,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1",
18 
Full Taxon Name,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1",
19 18 
Full Taxon Name,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/binomial,
19 
Full Taxon Name,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1,
20 20 
Barcode,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then",
21 21 
Country,/location/locationplace/*_id/placepath/country,
22 22 
County,/location/locationplace/*_id/placepath/county,
inputs/.TNRS/tnrs/test.xml.ref
9 9 
                        <taxondetermination>
10 10 
                            <taxonlabel_id>
11 11 
                                <taxonlabel>
12 
                                    <identifyingtaxonomicname>
13 
                                        <_join_words>
14 
                                            <1>
15 
                                                <_alt>
16 
                                                    <1>$Name_matched</1>
17 
                                                    <2>
18 
                                                        <_join_words>
19 
                                                            <1>$Name_matched_accepted_family</1>
20 
                                                            <2>$Genus_matched</2>
21 
                                                            <3>$Specific_epithet_matched</3>
22 
                                                            <5>
23 
                                                                <_join_words>
24 
                                                                    <1>
25 
                                                                        <_if name="if has infraspecificEpithet">
26 
                                                                            <cond>$Infraspecific_epithet_matched</cond>
27 
                                                                            <then>$Name_matched_rank</then>
28 
                                                                        </_if>
29 
                                                                    </1>
30 
                                                                    <2>$Infraspecific_epithet_matched</2>
31 
                                                                </_join_words>
32 
                                                            </5>
33 
                                                        </_join_words>
34 
                                                    </2>
35 
                                                </_alt>
36 
                                            </1>
37 
                                            <2>$Name_matched_author</2>
38 
                                        </_join_words>
39 
                                    </identifyingtaxonomicname>
40 12 
                                    <_taxonlabel_set_matched_label_id>
41 13 
                                        <matched_label_id>
42 14 
                                            <taxonlabel>
......
117 89 
                                    <binomial>$Name_matched</binomial>
118 90 
                                    <family>$Name_matched_accepted_family</family>
119 91 
                                    <genus>$Genus_matched</genus>
92 
                                    <identifyingtaxonomicname>
93 
                                        <_join_words>
94 
                                            <1>
95 
                                                <_alt>
96 
                                                    <1>$Name_matched</1>
97 
                                                    <2>
98 
                                                        <_join_words>
99 
                                                            <1>$Name_matched_accepted_family</1>
100 
                                                            <2>$Genus_matched</2>
101 
                                                            <3>$Specific_epithet_matched</3>
102 
                                                            <5>
103 
                                                                <_join_words>
104 
                                                                    <1>
105 
                                                                        <_if name="if has infraspecificEpithet">
106 
                                                                            <cond>$Infraspecific_epithet_matched</cond>
107 
                                                                            <then>$Name_matched_rank</then>
108 
                                                                        </_if>
109 
                                                                    </1>
110 
                                                                    <2>$Infraspecific_epithet_matched</2>
111 
                                                                </_join_words>
112 
                                                            </5>
113 
                                                        </_join_words>
114 
                                                    </2>
115 
                                                </_alt>
116 
                                            </1>
117 
                                            <2>$Name_matched_author</2>
118 
                                        </_join_words>
119 
                                    </identifyingtaxonomicname>
120 120 
                                    <parent_id>
121 121 
                                        <taxonlabel>
122 122 
                                            <rank>$Name_matched_rank</rank>
inputs/ARIZ/Specimen/VegBIEN.csv
36 36 
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
37 37 
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
38 38 
Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/4",
39 
ScientificNameAuthor,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/1",Contains the binomial in addition to the authority
40 
ScientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1",
41 
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
42 
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
43 
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
44 
Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/4",
45 39 
ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/binomial,
46 40 
DayIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/creationdate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value",
47 41 
MonthIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/creationdate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value",
......
49 43 
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/creator_id/_simplifyPath:[next=creator_id]/path/party/fullname/_alt/2,
50 44 
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/family,
51 45 
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/genus,
46 
ScientificNameAuthor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/1,Contains the binomial in addition to the authority
47 
ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1,
48 
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,
49 
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2,
50 
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1,
51 
Subspecies,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/4,
52 52 
Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=subspecies]/taxonepithet",
53 53 
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=species]/taxonepithet",
54 54 
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/taxonepithet",
inputs/GBIF/Specimen/test.xml.ref
87 87 
                                    </creator_id>
88 88 
                                    <family>$Family</family>
89 89 
                                    <genus>$Genus</genus>
90 
                                    <identifyingtaxonomicname>
91 
                                        <_join_words>
92 
                                            <1>
93 
                                                <_alt>
94 
                                                    <1>$ScientificName</1>
95 
                                                    <2>
96 
                                                        <_join_words>
97 
                                                            <1>$Family</1>
98 
                                                            <2>$Genus</2>
99 
                                                            <3>$SpecificEpithet</3>
100 
                                                            <5>$InfraspecificEpithet</5>
101 
                                                        </_join_words>
102 
                                                    </2>
103 
                                                </_alt>
104 
                                            </1>
105 
                                            <2>$AuthorOfScientificName</2>
106 
                                        </_join_words>
107 
                                    </identifyingtaxonomicname>
90 108 
                                    <parent_id>
91 109 
                                        <taxonlabel>
92 110 
                                            <parent_id>
inputs/NCU-NCSC/Specimen/test.xml.ref
78 78 
                                        </taxonlabel>
79 79 
                                    </matched_label_id>
80 80 
                                    <binomial>$Full Taxon Name</binomial>
81 
                                    <identifyingtaxonomicname>$Full Taxon Name</identifyingtaxonomicname>
81 82 
                                </taxonlabel>
82 83 
                            </taxonlabel_id>
83 84 
                        </taxondetermination>
inputs/MO/Specimen/test.xml.ref
119 119 
                                    </creator_id>
120 120 
                                    <family>$family</family>
121 121 
                                    <genus>$genus</genus>
122 
                                    <identifyingtaxonomicname>
123 
                                        <_join_words>
124 
                                            <1>
125 
                                                <_alt>
126 
                                                    <1>$ScientificName</1>
127 
                                                    <2>
128 
                                                        <_join_words>
129 
                                                            <1>$family</1>
130 
                                                            <2>$genus</2>
131 
                                                            <3>$species</3>
132 
                                                            <4>$Subspecies</4>
133 
                                                        </_join_words>
134 
                                                    </2>
135 
                                                </_alt>
136 
                                            </1>
137 
                                            <2>$ScientificNameAuthor</2>
138 
                                        </_join_words>
139 
                                    </identifyingtaxonomicname>
122 140 
                                    <parent_id>
123 141 
                                        <taxonlabel>
124 142 
                                            <parent_id>
inputs/QMOR/Specimen/test.xml.ref
142 142 
                                    </creator_id>
143 143 
                                    <family>$family</family>
144 144 
                                    <genus>$genus</genus>
145 
                                    <identifyingtaxonomicname>
146 
                                        <_join_words>
147 
                                            <1>
148 
                                                <_alt>
149 
                                                    <1>$scientificName</1>
150 
                                                    <2>
151 
                                                        <_join_words>
152 
                                                            <1>$family</1>
153 
                                                            <2>$genus</2>
154 
                                                            <3>$specificEpithet</3>
155 
                                                            <5>
156 
                                                                <_join_words>
157 
                                                                    <1>
158 
                                                                        <_if name="if has infraspecificEpithet">
159 
                                                                            <cond>$infraspecificEpithet</cond>
160 
                                                                            <then>$taxonRank</then>
161 
                                                                        </_if>
162 
                                                                    </1>
163 
                                                                    <2>$infraspecificEpithet</2>
164 
                                                                </_join_words>
165 
                                                            </5>
166 
                                                        </_join_words>
167 
                                                    </2>
168 
                                                </_alt>
169 
                                            </1>
170 
                                            <2>$scientificNameAuthorship</2>
171 
                                        </_join_words>
172 
                                    </identifyingtaxonomicname>
145 173 
                                    <parent_id>
146 174 
                                        <taxonlabel>
147 175 
                                            <rank>$taxonRank</rank>
inputs/SpeciesLink/Specimen/test.xml.ref
366 366 
                                            <2>$dwc_terms_genus</2>
367 367 
                                        </_alt>
368 368 
                                    </genus>
369 
                                    <identifyingtaxonomicname>
370 
                                        <_join_words>
371 
                                            <1>
372 
                                                <_alt>
373 
                                                    <1>
374 
                                                        <_alt>
375 
                                                            <0>$conceptual_darwin_2003_1_0_ScientificName</0>
376 
                                                            <1>$dwc_dwcore_ScientificName</1>
377 
                                                            <2>$dwc_terms_scientificName</2>
378 
                                                        </_alt>
379 
                                                    </1>
380 
                                                    <2>
381 
                                                        <_join_words>
382 
                                                            <1>
383 
                                                                <_alt>
384 
                                                                    <0>$conceptual_darwin_2003_1_0_Family</0>
385 
                                                                    <1>$dwc_dwcore_Family</1>
386 
                                                                    <2>$dwc_terms_family</2>
387 
                                                                </_alt>
388 
                                                            </1>
389 
                                                            <2>
390 
                                                                <_alt>
391 
                                                                    <0>$conceptual_darwin_2003_1_0_Genus</0>
392 
                                                                    <1>$dwc_dwcore_Genus</1>
393 
                                                                    <2>$dwc_terms_genus</2>
394 
                                                                </_alt>
395 
                                                            </2>
396 
                                                            <3>
397 
                                                                <_alt>
398 
                                                                    <0>$conceptual_darwin_2003_1_0_Species</0>
399 
                                                                    <1>$dwc_dwcore_SpecificEpithet</1>
400 
                                                                    <2>$dwc_terms_specificEpithet</2>
401 
                                                                </_alt>
402 
                                                            </3>
403 
                                                            <4>$conceptual_darwin_2003_1_0_Subspecies</4>
404 
                                                            <5>
405 
                                                                <_alt>
406 
                                                                    <0>$dwc_dwcore_InfraspecificEpithet</0>
407 
                                                                    <1>$dwc_terms_infraspecificEpithet</1>
408 
                                                                </_alt>
409 
                                                            </5>
410 
                                                        </_join_words>
411 
                                                    </2>
412 
                                                </_alt>
413 
                                            </1>
414 
                                            <2>
415 
                                                <_alt>
416 
                                                    <1>$dwc_terms_scientificNameAuthorship</1>
417 
                                                    <2>$conceptual_darwin_2003_1_0_ScientificNameAuthor</2>
418 
                                                    <3>$dwc_dwcore_AuthorYearOfScientificName</3>
419 
                                                </_alt>
420 
                                            </2>
421 
                                        </_join_words>
422 
                                    </identifyingtaxonomicname>
369 423 
                                    <parent_id>
370 424 
                                        <taxonlabel>
371 425 
                                            <parent_id>
inputs/VegBank/taxonobservation_/test.xml.ref
51 51 
                                    <creationdate><_date><date><_dateRangeStart><value>$interpretationdate</value></_dateRangeStart></date></_date></creationdate>
52 52 
                                    <family>$Family</family>
53 53 
                                    <genus>$Genus</genus>
54 
                                    <identifyingtaxonomicname>
55 
                                        <_join_words>
56 
                                            <1>$Family</1>
57 
                                            <2>$Genus</2>
58 
                                            <3>$Species</3>
59 
                                            <4>$Subspecies</4>
60 
                                            <7>
61 
                                                <_join_words>
62 
                                                    <1>var. </1>
63 
                                                    <2>$Variety</2>
64 
                                                </_join_words>
65 
                                            </7>
66 
                                            <8>
67 
                                                <_join_words>
68 
                                                    <1>fm. </1>
69 
                                                    <2>$Forma</2>
70 
                                                </_join_words>
71 
                                            </8>
72 
                                        </_join_words>
73 
                                    </identifyingtaxonomicname>
54 74 
                                    <parent_id>
55 75 
                                        <taxonlabel>
56 76 
                                            <parent_id>
......
150 170 
        </path>
151 171 
    </_simplifyPath>
152 172 
</VegBIEN>
153 
Inserted 21 new rows into database
173 
Inserted 22 new rows into database
mappings/for_review/VegCore-VegBIEN.csv
145 145 
forma,"//*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel/identifyingtaxonomicname",
146 146 
cultivar,"//*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel/identifyingtaxonomicname",
147 147 
scientificNameAuthorship,"//*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel/identifyingtaxonomicname",
148 
scientificName,"//*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname",
149 
binomial,"//*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname",
150 
family,"//*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname",
151 
genus,"//*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname",
152 
specificEpithet,"//*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname",
153 
subspecies,"//*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname",
154 
infraspecificEpithet,"//*_id/taxonlabel/identifyingtaxonomicname/_if[@name=""if has infraspecificEpithet""]/cond",
155 
taxonRank,"//*_id/taxonlabel/identifyingtaxonomicname/_if[@name=""if has infraspecificEpithet""]/then",
156 
infraspecificEpithet,"//*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname",
157 
taxonName,"//*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname",
158 
variety,"//*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname",
159 
forma,"//*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname",
160 
cultivar,"//*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname",
161 
scientificNameAuthorship,"//*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname",
162 148 
acceptedScientificNameAuthorship,//taxonoccurrence/taxondetermination[]/*_id/taxonlabel/taxonlabel/author,
163 149 
acceptedBinomial,//taxonoccurrence/taxondetermination[]/*_id/taxonlabel/taxonlabel/binomial,
164 150 
acceptedFamily,//taxonoccurrence/taxondetermination[]/*_id/taxonlabel/taxonlabel/family,
......
207 193 
identifiedBy,//taxonoccurrence/taxondetermination[]/*_id/taxonlabel/creator_id/party/fullname,
208 194 
family,//taxonoccurrence/taxondetermination[]/*_id/taxonlabel/family,
209 195 
genus,//taxonoccurrence/taxondetermination[]/*_id/taxonlabel/genus,
196 
scientificName,//taxonoccurrence/taxondetermination[]/*_id/taxonlabel/identifyingtaxonomicname,
197 
binomial,//taxonoccurrence/taxondetermination[]/*_id/taxonlabel/identifyingtaxonomicname,
198 
family,//taxonoccurrence/taxondetermination[]/*_id/taxonlabel/identifyingtaxonomicname,
199 
genus,//taxonoccurrence/taxondetermination[]/*_id/taxonlabel/identifyingtaxonomicname,
200 
specificEpithet,//taxonoccurrence/taxondetermination[]/*_id/taxonlabel/identifyingtaxonomicname,
201 
subspecies,//taxonoccurrence/taxondetermination[]/*_id/taxonlabel/identifyingtaxonomicname,
202 
infraspecificEpithet,"//taxonlabel/identifyingtaxonomicname/_if[@name=""if has infraspecificEpithet""]/cond",
203 
taxonRank,"//taxonlabel/identifyingtaxonomicname/_if[@name=""if has infraspecificEpithet""]/then",
204 
infraspecificEpithet,//taxonoccurrence/taxondetermination[]/*_id/taxonlabel/identifyingtaxonomicname,
205 
taxonName,//taxonoccurrence/taxondetermination[]/*_id/taxonlabel/identifyingtaxonomicname,
206 
variety,//taxonoccurrence/taxondetermination[]/*_id/taxonlabel/identifyingtaxonomicname,
207 
forma,//taxonoccurrence/taxondetermination[]/*_id/taxonlabel/identifyingtaxonomicname,
208 
cultivar,//taxonoccurrence/taxondetermination[]/*_id/taxonlabel/identifyingtaxonomicname,
209 
scientificNameAuthorship,//taxonoccurrence/taxondetermination[]/*_id/taxonlabel/identifyingtaxonomicname,
210 210 
verbatimScientificName,"//taxonlabel/morphospecies/_if[@name=""if has verbatim name""]/cond/_exists",
211 211 
morphospecies,"//taxonlabel/morphospecies/_if[@name=""if has verbatim name""]/else",
212 212 
parentScientificNameID,"//parent_id/taxonlabel/_if[@name=""if has explicit parent""]/cond/_exists",
......
241 241 
matchedGenusFit_fraction,//taxonoccurrence/taxondetermination[]/*_id/taxonlabel/taxonlabel/matched_label_fit_fraction,
242 242 
matchedSpeciesFit_fraction,//taxonoccurrence/taxondetermination[]/*_id/taxonlabel/taxonlabel/matched_label_fit_fraction,
243 243 
matchedTaxonFit_fraction,//taxonoccurrence/taxondetermination[]/*_id/taxonlabel/taxonlabel/matched_label_fit_fraction,
244 
morphospecies,//taxonoccurrence/taxondetermination[]/*_id/taxonlabel/taxonlabel/morphospecies,
244 245 
verbatimScientificName,"//taxonlabel/morphospecies/_if[@name=""if has verbatim name""]/cond/_exists",
245 
morphospecies,"//taxonlabel/morphospecies/_if[@name=""if has verbatim name""]/then",
246 246 
verbatimSpecificEpithet,//taxonoccurrence/taxondetermination[]/*_id/taxonlabel/taxonlabel/species,
247 247 
verbatimTaxonRank,//taxonoccurrence/taxondetermination[]/*_id/taxonlabel/taxonlabel/verbatimrank,
248 248 
scientificName,//taxonoccurrence/taxondetermination[]/*_id/taxonlabel/taxonomicname,
inputs/SpeciesLink/Specimen/VegBIEN.csv
116 116 
dwc_terms_scientificNameAuthorship,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/2/_alt/1",
117 117 
conceptual_darwin_2003_1_0_ScientificNameAuthor,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/2/_alt/2",
118 118 
dwc_dwcore_AuthorYearOfScientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/2/_alt/3",
119 
conceptual_darwin_2003_1_0_ScientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1",
120 
dwc_dwcore_ScientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1",
121 
dwc_terms_scientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1",
122 
conceptual_darwin_2003_1_0_Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
123 
dwc_dwcore_Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
124 
dwc_terms_family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
125 
conceptual_darwin_2003_1_0_Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
126 
dwc_dwcore_Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
127 
dwc_terms_genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
128 
conceptual_darwin_2003_1_0_Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
129 
dwc_dwcore_SpecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
130 
dwc_terms_specificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
131 
conceptual_darwin_2003_1_0_Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/4",
132 
dwc_dwcore_InfraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond",
133 
dwc_terms_infraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond",
134 
dwc_dwcore_InfraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2",
135 
dwc_terms_infraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2",
136 
dwc_terms_scientificNameAuthorship,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/2/_alt/1",
137 
conceptual_darwin_2003_1_0_ScientificNameAuthor,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/2/_alt/2",
138 
dwc_dwcore_AuthorYearOfScientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/2/_alt/3",
139 119 
dwc_terms_scientificNameAuthorship,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/author/_alt/1,
140 120 
conceptual_darwin_2003_1_0_ScientificNameAuthor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/author/_alt/2,
141 121 
dwc_dwcore_AuthorYearOfScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/author/_alt/3,
......
155 135 
conceptual_darwin_2003_1_0_Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/genus,
156 136 
dwc_dwcore_Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/genus,
157 137 
dwc_terms_genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/genus,
138 
conceptual_darwin_2003_1_0_ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1,
139 
dwc_dwcore_ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1,
140 
dwc_terms_scientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1,
141 
conceptual_darwin_2003_1_0_Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,
142 
dwc_dwcore_Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,
143 
dwc_terms_family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,
144 
conceptual_darwin_2003_1_0_Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2,
145 
dwc_dwcore_Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2,
146 
dwc_terms_genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2,
147 
conceptual_darwin_2003_1_0_Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1,
148 
dwc_dwcore_SpecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1,
149 
dwc_terms_specificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1,
150 
conceptual_darwin_2003_1_0_Subspecies,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/4,
151 
dwc_dwcore_InfraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond",
152 
dwc_terms_infraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond",
153 
dwc_dwcore_InfraspecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2,
154 
dwc_terms_infraspecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2,
155 
dwc_terms_scientificNameAuthorship,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/2/_alt/1,
156 
conceptual_darwin_2003_1_0_ScientificNameAuthor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/2/_alt/2,
157 
dwc_dwcore_AuthorYearOfScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/2/_alt/3,
158 158 
conceptual_darwin_2003_1_0_Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=subspecies]/taxonepithet",
159 159 
conceptual_darwin_2003_1_0_Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=species]/taxonepithet",
160 160 
dwc_dwcore_SpecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=species]/taxonepithet",
inputs/VegBank/taxonobservation_/VegBIEN.csv
16 16 
Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/4",
17 17 
Variety,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/7/_join_words:[1=""var. ""]/2",
18 18 
Forma,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/8/_join_words:[1=""fm. ""]/2",
19 
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
20 
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
21 
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
22 
Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/4",
23 
Variety,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/7/_join_words:[1=""var. ""]/2",
24 
Forma,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/8/_join_words:[1=""fm. ""]/2",
25 19 
interpretationdate,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/creationdate/_alt/1/_*/date/_dateRangeStart/value,
26 20 
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/family,
27 21 
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/genus,
22 
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,
23 
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2,
24 
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1,
25 
Subspecies,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/4,
26 
Variety,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/7/_join_words:[1=""var. ""]/2",
27 
Forma,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/8/_join_words:[1=""fm. ""]/2",
28 28 
Forma,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=forma]/taxonepithet",
29 29 
Variety,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=variety]/taxonepithet",
30 30 
Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=subspecies]/taxonepithet",
mappings/VegCore-VegBIEN.csv
145 145 
forma,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/8/_join_words:[1=""fm. ""]/2",
146 146 
cultivar,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/9/_join_words:[1=""cult. ""]/2",
147 147 
scientificNameAuthorship,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/2",
148 
scientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/1",
149 
binomial,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1",
150 
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
151 
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
152 
specificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
153 
subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/4",
154 
infraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond",
155 
taxonRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then",
156 
infraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2",
157 
taxonName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/6",
158 
variety,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/7/_join_words:[1=""var. ""]/2",
159 
forma,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/8/_join_words:[1=""fm. ""]/2",
160 
cultivar,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/9/_join_words:[1=""cult. ""]/2",
161 
scientificNameAuthorship,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/2",
162 148 
acceptedScientificNameAuthorship,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/author,
163 149 
acceptedBinomial,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/binomial,
164 150 
acceptedFamily,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/family,
......
207 193 
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/creator_id/_simplifyPath:[next=creator_id]/path/party/fullname/_alt/2,
208 194 
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/family,
209 195 
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/genus,
196 
scientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/1,
197 
binomial,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1,
198 
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,
199 
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2,
200 
specificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1,
201 
subspecies,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/4,
202 
infraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond",
203 
taxonRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then",
204 
infraspecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2,
205 
taxonName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/6,
206 
variety,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/7/_join_words:[1=""var. ""]/2",
207 
forma,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/8/_join_words:[1=""fm. ""]/2",
208 
cultivar,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/9/_join_words:[1=""cult. ""]/2",
209 
scientificNameAuthorship,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/2,
210 210 
verbatimScientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/morphospecies/_if[@name=""if has verbatim name""]/cond/_exists",
211 211 
morphospecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/morphospecies/_if[@name=""if has verbatim name""]/else",
212 212 
parentScientificNameID,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/cond/_exists",
......
241 241 
matchedGenusFit_fraction,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/matched_label_fit_fraction/_max/2,
242 242 
matchedSpeciesFit_fraction,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/matched_label_fit_fraction/_max/3,
243 243 
matchedTaxonFit_fraction,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/matched_label_fit_fraction/_max/4,
244 
morphospecies,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/morphospecies,
244 245 
verbatimScientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/morphospecies/_if[@name=""if has verbatim name""]/cond/_exists",
245 
morphospecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/morphospecies/_if[@name=""if has verbatim name""]/then",
246 246 
verbatimSpecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/species,
247 247 
verbatimTaxonRank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/verbatimrank,
248 248 
scientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonomicname,
inputs/MO/Specimen/VegBIEN.csv
26 26 
species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
27 27 
Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/4",
28 28 
ScientificNameAuthor,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/2",
29 
ScientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1",
30 
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
31 
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
32 
species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
33 
Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/4",
34 
ScientificNameAuthor,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/then/identifyingtaxonomicname/_alt/2/_join_words/2",
35 29 
ScientificNameAuthor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/author,
36 30 
ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/binomial,
37 31 
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/creator_id/_simplifyPath:[next=creator_id]/path/party/fullname/_alt/2,
... This diff was truncated because it exceeds the maximum size that can be displayed.

Also available in: Unified diff