Project

General

Profile

« Previous | Next » 

Revision 5072

mappings/VegCore-VegBIEN.csv: taxonomic terms: Changed _first to _alt because some datasources have NULL values in scientificNameWithAuthorship or scientificName, so it can't just be used in place of the joined-together taxonomic ranks

View differences:

inputs/GBIF/Specimen/test.xml.ref
64 64
                                    <taxonomicname>$ScientificName</taxonomicname>
65 65
                                    <taxonomicnamewithauthor>
66 66
                                        <_join_words>
67
                                            <1>$ScientificName</1>
67
                                            <1>
68
                                                <_alt>
69
                                                    <1>$ScientificName</1>
70
                                                    <2>
71
                                                        <_join_words>
72
                                                            <1>$Family</1>
73
                                                            <2>$Genus</2>
74
                                                            <3>$SpecificEpithet</3>
75
                                                            <5>$InfraspecificEpithet</5>
76
                                                        </_join_words>
77
                                                    </2>
78
                                                </_alt>
79
                                            </1>
68 80
                                            <2>$AuthorOfScientificName</2>
69 81
                                        </_join_words>
70 82
                                    </taxonomicnamewithauthor>
......
78 90
                                    <family>$GBIFFamilyOriginal</family>
79 91
                                    <genus>$GBIFGenusOriginal</genus>
80 92
                                    <taxonomicname>$ScientificNameOriginal</taxonomicname>
81
                                    <taxonomicnamewithauthor>$ScientificNameOriginal</taxonomicnamewithauthor>
93
                                    <taxonomicnamewithauthor>
94
                                        <_alt>
95
                                            <1>$ScientificNameOriginal</1>
96
                                            <2>
97
                                                <_join_words>
98
                                                    <1>$GBIFFamilyOriginal</1>
99
                                                    <2>$GBIFGenusOriginal</2>
100
                                                </_join_words>
101
                                            </2>
102
                                        </_alt>
103
                                    </taxonomicnamewithauthor>
82 104
                                </taxonpath>
83 105
                            </taxonpath_id>
84 106
                        </taxondetermination>
inputs/SpeciesLink/Specimen/VegBIEN.csv
132 132
conceptual_darwin_2003_1_0_ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicname,
133 133
dwc_dwcore_ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicname,
134 134
dwc_terms_scientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicname,
135
conceptual_darwin_2003_1_0_ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/1,
136
dwc_dwcore_ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/1,
137
dwc_terms_scientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/1,
138
conceptual_darwin_2003_1_0_Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/1,
139
dwc_dwcore_Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/1,
140
dwc_terms_family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/1,
141
conceptual_darwin_2003_1_0_Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/2,
142
dwc_dwcore_Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/2,
143
dwc_terms_genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/2,
144
conceptual_darwin_2003_1_0_Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/3,
145
dwc_dwcore_SpecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/3,
146
dwc_terms_specificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/3,
147
conceptual_darwin_2003_1_0_Subspecies,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/4,
148
dwc_dwcore_InfraspecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/5/_join_words/2,
149
dwc_terms_infraspecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/5/_join_words/2,
150
dwc_terms_scientificNameAuthorship,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/2/_alt/1,
151
conceptual_darwin_2003_1_0_ScientificNameAuthor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/2/_alt/2,
152
dwc_dwcore_AuthorYearOfScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/2/_alt/3,
135
conceptual_darwin_2003_1_0_ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/1,
136
dwc_dwcore_ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/1,
137
dwc_terms_scientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/1,
138
conceptual_darwin_2003_1_0_Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/1,
139
dwc_dwcore_Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/1,
140
dwc_terms_family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/1,
141
conceptual_darwin_2003_1_0_Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/2,
142
dwc_dwcore_Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/2,
143
dwc_terms_genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/2,
144
conceptual_darwin_2003_1_0_Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/3,
145
dwc_dwcore_SpecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/3,
146
dwc_terms_specificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/3,
147
conceptual_darwin_2003_1_0_Subspecies,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/4,
148
dwc_dwcore_InfraspecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2,
149
dwc_terms_infraspecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2,
150
dwc_terms_scientificNameAuthorship,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/2/_alt/1,
151
conceptual_darwin_2003_1_0_ScientificNameAuthor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/2/_alt/2,
152
dwc_dwcore_AuthorYearOfScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/2/_alt/3,
153 153
dwc_terms_dateIdentified,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/1/_*/date/_dateRangeStart/value,
154 154
conceptual_darwin_2003_1_0_DayIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value",
155 155
conceptual_darwin_2003_1_0_MonthIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value",
inputs/MO/Specimen/VegBIEN.csv
29 29
species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/species,
30 30
Subspecies,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/subspecies/_alt/1,
31 31
ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicname,
32
ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/1,
33
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/1,
34
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/2,
35
species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/3,
36
Subspecies,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/4,
37
ScientificNameAuthor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/2,
32
ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/1,
33
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/1,
34
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/2,
35
species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/3,
36
Subspecies,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/4,
37
ScientificNameAuthor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/2,
38 38
Collector,/location/locationevent/taxonoccurrence/verbatimcollectorname,
39 39
CatalogNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then",
40 40
Locality,/location/locationnarrative/_merge/1,
inputs/VegBank/taxonobservation_/VegBIEN.csv
17 17
Order,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/order,
18 18
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/species,
19 19
Subspecies,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/subspecies/_alt/1,
20
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/1,
21
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/2,
22
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/3,
23
Subspecies,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/4,
24
Variety,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/6/_join_words:[1=var.]/2,
25
Forma,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/7/_join_words:[1=fm.]/2,
20
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/1,
21
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/2,
22
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/3,
23
Subspecies,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/4,
24
Variety,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/6/_join_words:[1=var.]/2,
25
Forma,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/7/_join_words:[1=fm.]/2,
26 26
Variety,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/variety,
27 27
interpretationdate,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/1/_*/date/_dateRangeStart/value,
28 28
taxonfit,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/taxonfit,
29 29
authorplantname,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/taxonomicname,
30
authorplantname,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/1,
30
authorplantname,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/1,
31 31
museumaccessionnumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then",
32 32
Division,,** No join mapping for *Division ** 
33 33
Subclass,,** No join mapping for *Subclass ** 
inputs/QMOR/Specimen/test.xml.ref
117 117
                                    <taxonomicname>$scientificName</taxonomicname>
118 118
                                    <taxonomicnamewithauthor>
119 119
                                        <_join_words>
120
                                            <1>$scientificName</1>
120
                                            <1>
121
                                                <_alt>
122
                                                    <1>$scientificName</1>
123
                                                    <2>
124
                                                        <_join_words>
125
                                                            <1>$family</1>
126
                                                            <2>$genus</2>
127
                                                            <3>$specificEpithet</3>
128
                                                            <5>
129
                                                                <_join_words>
130
                                                                    <1>$taxonRank</1>
131
                                                                    <2>$infraspecificEpithet</2>
132
                                                                </_join_words>
133
                                                            </5>
134
                                                        </_join_words>
135
                                                    </2>
136
                                                </_alt>
137
                                            </1>
121 138
                                            <2>$scientificNameAuthorship</2>
122 139
                                        </_join_words>
123 140
                                    </taxonomicnamewithauthor>
mappings/VegCore-VegBIEN.csv
142 142
taxonRank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/subspecies/_alt/2/_join_words/1,
143 143
infraspecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/subspecies/_alt/2/_join_words/2,
144 144
scientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicname,
145
scientificNameWithAuthorship,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/1,
146
scientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/1,
147
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/1,
148
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/2,
149
specificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/3,
150
subspecies,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/4,
151
taxonRank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/5/_join_words/1,
152
infraspecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/5/_join_words/2,
153
variety,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/6/_join_words:[1=var.]/2,
154
forma,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/7/_join_words:[1=fm.]/2,
155
cultivar,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/8/_join_words:[1=cult.]/2,
156
scientificNameAuthorship,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/2,
145
scientificNameWithAuthorship,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/1,
146
scientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/1,
147
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/1,
148
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/2,
149
specificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/3,
150
subspecies,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/4,
151
taxonRank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1,
152
infraspecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2,
153
variety,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/6/_join_words:[1=var.]/2,
154
forma,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/7/_join_words:[1=fm.]/2,
155
cultivar,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/8/_join_words:[1=cult.]/2,
156
scientificNameAuthorship,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/2,
157 157
verbatimScientificNameWithAuthorship,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonpath:[@fkey=canon_taxonpath_id]/taxonomicnamewithauthor,
158 158
variety,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/variety,
159 159
dateIdentified,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/1/_*/date/_dateRangeStart/value,
......
176 176
originalTaxonRank,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/subspecies/_alt/2/_join_words/1,
177 177
originalInfraspecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/subspecies/_alt/2/_join_words/2,
178 178
originalScientificName,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/taxonomicname,
179
originalScientificNameWithAuthorship,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/taxonomicnamewithauthor/_first/1,
180
originalScientificName,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/1,
181
originalFamily,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/1,
182
originalGenus,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/2,
183
originalSpecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/3,
184
originalSubspecies,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/4,
185
originalTaxonRank,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/5/_join_words/1,
186
originalInfraspecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/5/_join_words/2,
187
originalVariety,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/6/_join_words:[1=var.]/2,
188
originalForma,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/7/_join_words:[1=fm.]/2,
189
originalCultivar,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/8/_join_words:[1=cult.]/2,
190
originalScientificNameAuthorship,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/2,
179
originalScientificNameWithAuthorship,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/taxonomicnamewithauthor/_alt/1,
180
originalScientificName,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/1,
181
originalFamily,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/1,
182
originalGenus,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/2,
183
originalSpecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/3,
184
originalSubspecies,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/4,
185
originalTaxonRank,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1,
186
originalInfraspecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2,
187
originalVariety,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/6/_join_words:[1=var.]/2,
188
originalForma,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/7/_join_words:[1=fm.]/2,
189
originalCultivar,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/8/_join_words:[1=cult.]/2,
190
originalScientificNameAuthorship,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/2,
191 191
originalVariety,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/variety,
192 192
originalIdentificationQualifier,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/taxonfit,
193 193
recordedBy,/location/locationevent/taxonoccurrence/verbatimcollectorname,
inputs/MT/Specimen/VegBIEN.csv
13 13
id,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/3,
14 14
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/family,
15 15
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/genus,
16
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/1,
17
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/2,
16
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/1,
17
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/2,
18 18
locality,/location/locationnarrative/_merge/1,
19 19
continent,/location/locationplace/*_id/placepath/continent,
20 20
basisOfRecord,,** No join mapping for basisOfRecord ** 
inputs/XAL/Specimen/VegBIEN.csv
33 33
darwin:Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/species,
34 34
darwin:Subspecies,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/subspecies/_alt/1,
35 35
darwin:ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicname,
36
darwin:ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/1,
37
darwin:Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/1,
38
darwin:Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/2,
39
darwin:Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/3,
40
darwin:Subspecies,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/4,
41
darwin:ScientificNameAuthor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/2,
36
darwin:ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/1,
37
darwin:Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/1,
38
darwin:Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/2,
39
darwin:Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/3,
40
darwin:Subspecies,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/4,
41
darwin:ScientificNameAuthor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/2,
42 42
darwin:DayIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value",
43 43
darwin:MonthIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value",
44 44
darwin:YearIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value",
inputs/TEAM/VL/VegBIEN.csv
23 23
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/family,
24 24
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/genus,
25 25
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/species,
26
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/1,
27
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/2,
28
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/3,
26
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/1,
27
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/2,
28
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/3,
29 29
Names of Collectors,/location/locationevent/taxonoccurrence/verbatimcollectorname,
30 30
Comments,,** No join mapping for *Comments ** 
31 31
Condition Codes,,** No join mapping for *Condition Codes ** 
inputs/TEAM/VT/VegBIEN.csv
23 23
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/family,
24 24
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/genus,
25 25
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/species,
26
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/1,
27
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/2,
28
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/3,
26
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/1,
27
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/2,
28
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/3,
29 29
Names of Collectors,/location/locationevent/taxonoccurrence/verbatimcollectorname,
30 30
Comments,,** No join mapping for *Comments ** 
31 31
Condition Codes,,** No join mapping for *Condition Codes ** 
inputs/NY/Specimen/VegBIEN.csv
38 38
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/species,
39 39
Subspecies,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/subspecies/_alt/1,
40 40
ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicname,
41
ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/1,
42
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/1,
43
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/2,
44
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/3,
45
Subspecies,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/4,
46
ScientificNameAuthor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/2,
41
ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/1,
42
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/1,
43
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/2,
44
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/3,
45
Subspecies,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/4,
46
ScientificNameAuthor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/2,
47 47
DayIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value",
48 48
MonthIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value",
49 49
YearIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value",
inputs/NY/Specimen/test.xml.ref
128 128
                                    <taxonomicname>$ScientificName</taxonomicname>
129 129
                                    <taxonomicnamewithauthor>
130 130
                                        <_join_words>
131
                                            <1>$ScientificName</1>
131
                                            <1>
132
                                                <_alt>
133
                                                    <1>$ScientificName</1>
134
                                                    <2>
135
                                                        <_join_words>
136
                                                            <1>$Family</1>
137
                                                            <2>$Genus</2>
138
                                                            <3>$Species</3>
139
                                                            <4>$Subspecies</4>
140
                                                        </_join_words>
141
                                                    </2>
142
                                                </_alt>
143
                                            </1>
132 144
                                            <2>$ScientificNameAuthor</2>
133 145
                                        </_join_words>
134 146
                                    </taxonomicnamewithauthor>
inputs/Madidi/Organism/VegBIEN.csv
37 37
Genera,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/genus,
38 38
Specific epithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/species,
39 39
Species and morphotypes,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicname,"Contains less than ""Specie+autor"""
40
Specie+autor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/1,
41
Species and morphotypes,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/1,"Contains less than ""Specie+autor"""
42
Family (revised),/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/1,
43
Genera,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/2,
44
Specific epithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/3,
45
Autor (revised),/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/2,
40
Specie+autor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/1,
41
Species and morphotypes,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/1,"Contains less than ""Specie+autor"""
42
Family (revised),/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/1,
43
Genera,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/2,
44
Specific epithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/3,
45
Autor (revised),/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/2,
46 46
Qualifier,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/taxonfit,
47 47
Field family,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/family,
48 48
Field name,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/genus,Often = Genera
49
Field family,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/1,
50
Field name,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/2,Often = Genera
49
Field family,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/1,
50
Field name,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/2,Often = Genera
51 51
Index collector,/location/locationevent/taxonoccurrence/verbatimcollectorname,
52 52
Specimen,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then",
53 53
Basal area,,"** No join mapping for *Basal area ** Would be basalDiameter, but need formula to translate"
inputs/Madidi/Organism/test.xml.ref
75 75
                                    <genus>$Genera</genus>
76 76
                                    <species>$Specific epithet</species>
77 77
                                    <taxonomicname>$Species and morphotypes</taxonomicname>
78
                                    <taxonomicnamewithauthor>$Specie+autor</taxonomicnamewithauthor>
78
                                    <taxonomicnamewithauthor>
79
                                        <_alt>
80
                                            <1>$Specie+autor</1>
81
                                            <2>
82
                                                <_join_words>
83
                                                    <1>
84
                                                        <_alt>
85
                                                            <1>$Species and morphotypes</1>
86
                                                            <2>
87
                                                                <_join_words>
88
                                                                    <1>$Family (revised)</1>
89
                                                                    <2>$Genera</2>
90
                                                                    <3>$Specific epithet</3>
91
                                                                </_join_words>
92
                                                            </2>
93
                                                        </_alt>
94
                                                    </1>
95
                                                    <2>$Autor (revised)</2>
96
                                                </_join_words>
97
                                            </2>
98
                                        </_alt>
99
                                    </taxonomicnamewithauthor>
79 100
                                </taxonpath>
80 101
                            </taxonpath_id>
81 102
                            <taxonfit>$Qualifier</taxonfit>
inputs/UNCC/Specimen/VegBIEN.csv
50 50
infrarank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/subspecies/_alt/2/_join_words/1/_alt/2,
51 51
infraname,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/subspecies/_alt/2/_join_words/2,
52 52
SciName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicname,
53
SciName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/1,
54
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/1,
55
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/2,
56
species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/3,
57
usdaRank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/5/_join_words/1/_alt/1,
58
infrarank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/5/_join_words/1/_alt/2,
59
infraname,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/5/_join_words/2,
60
authors,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/2,
53
SciName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/1,
54
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/1,
55
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/2,
56
species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/3,
57
usdaRank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_alt/1,
58
infrarank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_alt/2,
59
infraname,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2,
60
authors,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/2,
61 61
collector,/location/locationevent/taxonoccurrence/verbatimcollectorname/_join/1,
62 62
collector1,/location/locationevent/taxonoccurrence/verbatimcollectorname/_join/2,
63 63
collector2,/location/locationevent/taxonoccurrence/verbatimcollectorname/_join/3,
inputs/UNCC/Specimen/test.xml.ref
91 91
                                    <taxonomicname>$SciName</taxonomicname>
92 92
                                    <taxonomicnamewithauthor>
93 93
                                        <_join_words>
94
                                            <1>$SciName</1>
94
                                            <1>
95
                                                <_alt>
96
                                                    <1>$SciName</1>
97
                                                    <2>
98
                                                        <_join_words>
99
                                                            <1>$family</1>
100
                                                            <2>$genus</2>
101
                                                            <3>$species</3>
102
                                                            <5>
103
                                                                <_join_words>
104
                                                                    <1>
105
                                                                        <_alt>
106
                                                                            <1>$usdaRank</1>
107
                                                                            <2>$infrarank</2>
108
                                                                        </_alt>
109
                                                                    </1>
110
                                                                    <2>$infraname</2>
111
                                                                </_join_words>
112
                                                            </5>
113
                                                        </_join_words>
114
                                                    </2>
115
                                                </_alt>
116
                                            </1>
95 117
                                            <2>$authors</2>
96 118
                                        </_join_words>
97 119
                                    </taxonomicnamewithauthor>
inputs/ACAD/Specimen/VegBIEN.csv
32 32
specificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/species,
33 33
taxonRank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/subspecies/_alt/2/_join_words/1,
34 34
infraspecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/subspecies/_alt/2/_join_words/2,
35
scientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/1,
36
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/1,
37
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/2,
38
specificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/3,
39
taxonRank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/5/_join_words/1,
40
infraspecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/5/_join_words/2,
41
scientificNameAuthorship,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/2,
35
scientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/1,
36
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/1,
37
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/2,
38
specificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/3,
39
taxonRank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1,
40
infraspecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2,
41
scientificNameAuthorship,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/2,
42 42
dateIdentified,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/1/_*/date/_dateRangeStart/value,
43 43
recordedBy,/location/locationevent/taxonoccurrence/verbatimcollectorname,
44 44
catalogNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then",
inputs/ACAD/Specimen/test.xml.ref
90 90
                                            <2>$infraspecificEpithet</2>
91 91
                                        </_join_words>
92 92
                                    </subspecies>
93
                                    <taxonomicnamewithauthor>$scientificName</taxonomicnamewithauthor>
93
                                    <taxonomicnamewithauthor>
94
                                        <_alt>
95
                                            <1>$scientificName</1>
96
                                            <2>
97
                                                <_join_words>
98
                                                    <1>
99
                                                        <_join_words>
100
                                                            <1>$family</1>
101
                                                            <2>$genus</2>
102
                                                            <3>$specificEpithet</3>
103
                                                            <5>
104
                                                                <_join_words>
105
                                                                    <1>$taxonRank</1>
106
                                                                    <2>$infraspecificEpithet</2>
107
                                                                </_join_words>
108
                                                            </5>
109
                                                        </_join_words>
110
                                                    </1>
111
                                                    <2>$scientificNameAuthorship</2>
112
                                                </_join_words>
113
                                            </2>
114
                                        </_alt>
115
                                    </taxonomicnamewithauthor>
94 116
                                </taxonpath>
95 117
                            </taxonpath_id>
96 118
                            <determinationdate><_date><date><_dateRangeStart><value>$dateIdentified</value></_dateRangeStart></date></_date></determinationdate>
inputs/SALVIAS-CSV/Organism/VegBIEN.csv
70 70
specific_epithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/species,
71 71
infra_rank_1,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/subspecies/_alt/2/_join_words/1,
72 72
infra_ep_1,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/subspecies/_alt/2/_join_words/2,
73
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/1,
74
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/2,
75
specific_epithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/3,
76
infra_rank_1,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/5/_join_words/1,
77
infra_ep_1,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/5/_join_words/2,
78
specific_authority,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/2,Brad: This is the author of the scientificName.
73
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/1,
74
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/2,
75
specific_epithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/3,
76
infra_rank_1,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1,
77
infra_ep_1,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2,
78
specific_authority,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/2,Brad: This is the author of the scientificName.
79 79
cf_aff,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/taxonfit,"Brad: Not sure where this goes. Indicator of identification uncertainty. 'cf.'=similar to the species listed, 'aff.'=related to the species list, but not the same. You'll need to check with Bob and with Nick where these go in VegX and VegBank."
80 80
orig_family,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/family,Brad: OMIT
81 81
orig_species,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/species,Brad: OMIT
82
orig_family,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/1,Brad: OMIT
83
orig_species,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/3,Brad: OMIT
82
orig_family,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/1,Brad: OMIT
83
orig_species,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/3,Brad: OMIT
84 84
coll_firstname,/location/locationevent/taxonoccurrence/verbatimcollectorname/_join_words/1,Brad: See comment above
85 85
coll_lastname,/location/locationevent/taxonoccurrence/verbatimcollectorname/_join_words/2,"Brad: This is the collector of a separate specimen which vouchers this tree or species. I worry that vouchers are not properly accommodated in VegX. Again, we need to check with Nick."
86 86
det_type,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/cond/_eq:[right=indirect]/left","Brad: A SALVIAS value referring to the relationship between the voucher specimen and the observation. Affect how the identification of the specimen(latin name) is transferred to the observation. 'direct'=voucher specimen was collected from this same tree; they are one and the same individual. 'indirect'=voucher specimen was collected for a different individual, but the original data provider confirmed that this is the same species. 'default'=basically same as 'indirect'. 'uncollected'=no voucher specimen, data provider  asserted that this was the name but was unable to collect. The main different is that with 'direct', 'indirect', and 'default', the scientific name can be updated automatically based on the name attached to the specimen voucher (assuming you have a link to that data, presumably from a herbarium database. Whereas, if det_type='uncollected', the name can never change because there is no specimen."
inputs/CVS/Organism/VegBIEN.csv
10 10
%cover,/location/locationevent/taxonoccurrence/aggregateoccurrence/cover_fraction/_percent_to_fraction/value,
11 11
currentTaxonName sec Weakley 2006,/location/locationevent/taxonoccurrence/authortaxoncode/_first/2/_first/3,
12 12
currentTaxonName sec Weakley 2006,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicname,
13
currentTaxonName sec Weakley 2006,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/1,
13
currentTaxonName sec Weakley 2006,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/1,
14 14
county,/location/locationplace/*_id/placepath/county,
15 15
state,/location/locationplace/*_id/placepath/stateprovince,
16 16
confidentialityStatus,,** No join mapping for *confidentialityStatus ** 
inputs/REMIB/Specimen/VegBIEN.csv
36 36
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/family,
37 37
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/genus,
38 38
specificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/species,
39
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/1,
40
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/2,
41
specificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/3,
39
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/1,
40
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/2,
41
specificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/3,
42 42
collector,/location/locationevent/taxonoccurrence/verbatimcollectorname,
43 43
accession_number,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then","Not globally unique, only (usually) unique within the institution providing the data (""acronym""). Note that there are nevertheless 11,869 rows where an accession_number appears multiple times within the same institution. [1]
44 44

  
inputs/CTFS/StemObservation/VegBIEN.csv
25 25
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/genus,
26 26
SpeciesName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/species,
27 27
SubSpeciesName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/subspecies/_alt/1,
28
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/1,
29
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/2,
30
SpeciesName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/3,
31
SubSpeciesName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/4,
32
SpeciesAuthority,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/2,
28
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/1,
29
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/2,
30
SpeciesName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/3,
31
SubSpeciesName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/4,
32
SpeciesAuthority,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/2,
33 33
Description,,** No join mapping for *Description ** 
34 34
ExactDate,,** No join mapping for *ExactDate ** 
35 35
FamilyID,,** No join mapping for *FamilyID ** 
inputs/CTFS/TaxonOccurrence/VegBIEN.csv
12 12
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/genus,
13 13
SpeciesName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/species,
14 14
SubSpeciesName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/subspecies/_alt/1,
15
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/1,
16
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/2,
17
SpeciesName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/3,
18
SubSpeciesName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/4,
15
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/1,
16
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/2,
17
SpeciesName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/3,
18
SubSpeciesName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/4,
19 19
Description,,** No join mapping for *Description ** 
20 20
FamilyID,,** No join mapping for *FamilyID ** 
21 21
FieldFamily,,** No join mapping for *FieldFamily ** 
inputs/FIA/Organism/VegBIEN.csv
16 16
TreeTag,"/location/locationevent/taxonoccurrence/authortaxoncode/_first/1/_first/2/_if[@name=""if is organism""]/then",
17 17
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/genus,
18 18
SpecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/species,
19
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/2,
20
SpecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/3,
19
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/2,
20
SpecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/3,
21 21
County,/location/locationplace/*_id/placepath/county,
22 22
StateProvince,/location/locationplace/*_id/placepath/stateprovince,
23 23
HOM,,** No join mapping for *HOM ** 
inputs/SALVIAS/plotObservations/VegBIEN.csv
63 63
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/species,
64 64
infra_rank_1,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/subspecies/_alt/2/_join_words/1,
65 65
infra_ep_1,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/subspecies/_alt/2/_join_words/2,
66
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/1,
67
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/2,
68
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/3,
69
infra_rank_1,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/5/_join_words/1,
70
infra_ep_1,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/5/_join_words/2,
71
auth,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/2,Brad: This is the author of the scientificName.
66
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/1,
67
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/2,
68
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/3,
69
infra_rank_1,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1,
70
infra_ep_1,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2,
71
auth,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/2,Brad: This is the author of the scientificName.
72 72
cfaff,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/taxonfit,"Brad: Not sure where this goes. Indicator of identification uncertainty. 'cf.'=similar to the species listed, 'aff.'=related to the species list, but not the same. You'll need to check with Bob and with Nick where these go in VegX and VegBank."
73 73
OrigFamily,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/family,Brad: OMIT
74 74
OrigGenus,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/genus,
75 75
OrigSpecies,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/species,Brad: OMIT
76
OrigFamily,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/1,Brad: OMIT
77
OrigGenus,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/2,
78
OrigSpecies,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/3,Brad: OMIT
76
OrigFamily,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/1,Brad: OMIT
77
OrigGenus,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/2,
78
OrigSpecies,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/3,Brad: OMIT
79 79
coll_firstname,/location/locationevent/taxonoccurrence/verbatimcollectorname/_join_words/1,Brad: See comment above
80 80
coll_lastname,/location/locationevent/taxonoccurrence/verbatimcollectorname/_join_words/2,"Brad: This is the collector of a separate specimen which vouchers this tree or species. I worry that vouchers are not properly accommodated in VegX. Again, we need to check with Nick."
81 81
DetType,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/cond/_eq:[right=indirect]/left","Brad: A SALVIAS value referring to the relationship between the voucher specimen and the observation. Affect how the identification of the specimen(latin name) is transferred to the observation. 'direct'=voucher specimen was collected from this same tree; they are one and the same individual. 'indirect'=voucher specimen was collected for a different individual, but the original data provider confirmed that this is the same species. 'default'=basically same as 'indirect'. 'uncollected'=no voucher specimen, data provider  asserted that this was the name but was unable to collect. The main different is that with 'direct', 'indirect', and 'default', the scientific name can be updated automatically based on the name attached to the specimen voucher (assuming you have a link to that data, presumably from a herbarium database. Whereas, if det_type='uncollected', the name can never change because there is no specimen."
inputs/.TNRS/tnrs/VegBIEN.csv
4 4
Accepted_name_family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/family,
5 5
Accepted_name_rank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/subspecies/_alt/2/_join_words/1,
6 6
Accepted_name,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicname,
7
Accepted_name,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/1,
8
Accepted_name_family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/1,
9
Accepted_name_rank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/5/_join_words/1,
10
Accepted_name_author,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/2,
7
Accepted_name,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/1,
8
Accepted_name_family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/1,
9
Accepted_name_rank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1,
10
Accepted_name_author,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/2,
11 11
Name_submitted,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonpath:[@fkey=canon_taxonpath_id]/taxonomicnamewithauthor,
12 12
Accepted_name_lsid,,** No non-empty join mapping for OMIT ** 
13 13
Accepted_name_species,,** No non-empty join mapping for OMIT ** Also contains genus. Omitted because Accepted_name contains more info.
inputs/.TNRS/tnrs/test.xml.ref
16 16
                                    <taxonomicname>$Accepted_name</taxonomicname>
17 17
                                    <taxonomicnamewithauthor>
18 18
                                        <_join_words>
19
                                            <1>$Accepted_name</1>
19
                                            <1>
20
                                                <_alt>
21
                                                    <1>$Accepted_name</1>
22
                                                    <2>
23
                                                        <_join_words>
24
                                                            <1>$Accepted_name_family</1>
25
                                                            <5>$Accepted_name_rank</5>
26
                                                        </_join_words>
27
                                                    </2>
28
                                                </_alt>
29
                                            </1>
20 30
                                            <2>$Accepted_name_author</2>
21 31
                                        </_join_words>
22 32
                                    </taxonomicnamewithauthor>
inputs/U/Specimen/VegBIEN.csv
18 18
Detby,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/surname/_namePart/last,
19 19
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/family,
20 20
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/genus,
21
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/1,
22
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/2,
21
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/1,
22
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/2,
23 23
Detyy,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value",
24 24
cf,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/taxonfit,
25 25
Collector,/location/locationevent/taxonoccurrence/verbatimcollectorname/_join/1,
inputs/ARIZ/Specimen/VegBIEN.csv
41 41
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/species,
42 42
Subspecies,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/subspecies/_alt/1,
43 43
ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicname,
44
ScientificNameAuthor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/1,Contains the binomial in addition to the authority
45
ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/1,
46
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/1,
47
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/2,
48
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/3,
49
Subspecies,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/4,
44
ScientificNameAuthor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/1,Contains the binomial in addition to the authority
45
ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/1,
46
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/1,
47
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/2,
48
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/3,
49
Subspecies,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/4,
50 50
DayIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value",
51 51
MonthIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value",
52 52
YearIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value",
inputs/ARIZ/Specimen/test.xml.ref
125 125
                                    <species>$Species</species>
126 126
                                    <subspecies>$Subspecies</subspecies>
127 127
                                    <taxonomicname>$ScientificName</taxonomicname>
128
                                    <taxonomicnamewithauthor>$ScientificNameAuthor</taxonomicnamewithauthor>
128
                                    <taxonomicnamewithauthor>
129
                                        <_alt>
130
                                            <1>$ScientificNameAuthor</1>
131
                                            <2>
132
                                                <_alt>
133
                                                    <1>$ScientificName</1>
134
                                                    <2>
135
                                                        <_join_words>
136
                                                            <1>$Family</1>
137
                                                            <2>$Genus</2>
138
                                                            <3>$Species</3>
139
                                                            <4>$Subspecies</4>
140
                                                        </_join_words>
141
                                                    </2>
142
                                                </_alt>
143
                                            </2>
144
                                        </_alt>
145
                                    </taxonomicnamewithauthor>
129 146
                                </taxonpath>
130 147
                            </taxonpath_id>
131 148
                            <determinationdate>
inputs/GBIF/Specimen/VegBIEN.csv
22 22
SpecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/species,
23 23
InfraspecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/subspecies/_alt/2/_join_words/2,
24 24
ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicname,
25
ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/1,
26
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/1,
27
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/2,
28
SpecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/3,
29
InfraspecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/5/_join_words/2,
30
AuthorOfScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/2,
25
ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/1,
26
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/1,
27
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/2,
28
SpecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/3,
29
InfraspecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2,
30
AuthorOfScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/2,
31 31
GBIFFamilyOriginal,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/family,
32 32
GBIFGenusOriginal,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/genus,
33 33
ScientificNameOriginal,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/taxonomicname,
34
ScientificNameOriginal,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/1,
35
GBIFFamilyOriginal,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/1,
36
GBIFGenusOriginal,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/2,
34
ScientificNameOriginal,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/1,
35
GBIFFamilyOriginal,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/1,
36
GBIFGenusOriginal,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/2,
37 37
Collector,/location/locationevent/taxonoccurrence/verbatimcollectorname,
38 38
CatalogNO,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then",
39 39
Locality,/location/locationnarrative/_merge/1,
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/taxonpath/taxonomicname,
18
Full Taxon Name,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/1,
18
Full Taxon Name,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/1,
19 19
Barcode,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then",
20 20
Country,/location/locationplace/*_id/placepath/country,
21 21
County,/location/locationplace/*_id/placepath/county,
inputs/SpeciesLink/Specimen/test.xml.ref
350 350
                                        <_join_words>
351 351
                                            <1>
352 352
                                                <_alt>
353
                                                    <0>$conceptual_darwin_2003_1_0_ScientificName</0>
354
                                                    <1>$dwc_dwcore_ScientificName</1>
355
                                                    <2>$dwc_terms_scientificName</2>
353
                                                    <1>
354
                                                        <_alt>
355
                                                            <0>$conceptual_darwin_2003_1_0_ScientificName</0>
356
                                                            <1>$dwc_dwcore_ScientificName</1>
357
                                                            <2>$dwc_terms_scientificName</2>
358
                                                        </_alt>
359
                                                    </1>
360
                                                    <2>
361
                                                        <_join_words>
362
                                                            <1>
363
                                                                <_alt>
364
                                                                    <0>$conceptual_darwin_2003_1_0_Family</0>
365
                                                                    <1>$dwc_dwcore_Family</1>
366
                                                                    <2>$dwc_terms_family</2>
367
                                                                </_alt>
368
                                                            </1>
369
                                                            <2>
370
                                                                <_alt>
371
                                                                    <0>$conceptual_darwin_2003_1_0_Genus</0>
372
                                                                    <1>$dwc_dwcore_Genus</1>
373
                                                                    <2>$dwc_terms_genus</2>
374
                                                                </_alt>
375
                                                            </2>
376
                                                            <3>
377
                                                                <_alt>
378
                                                                    <0>$conceptual_darwin_2003_1_0_Species</0>
379
                                                                    <1>$dwc_dwcore_SpecificEpithet</1>
380
                                                                    <2>$dwc_terms_specificEpithet</2>
381
                                                                </_alt>
382
                                                            </3>
383
                                                            <4>$conceptual_darwin_2003_1_0_Subspecies</4>
384
                                                            <5>
385
                                                                <_alt>
386
                                                                    <0>$dwc_dwcore_InfraspecificEpithet</0>
387
                                                                    <1>$dwc_terms_infraspecificEpithet</1>
388
                                                                </_alt>
389
                                                            </5>
390
                                                        </_join_words>
391
                                                    </2>
356 392
                                                </_alt>
357 393
                                            </1>
358 394
                                            <2>
inputs/MO/Specimen/test.xml.ref
97 97
                                    <taxonomicname>$ScientificName</taxonomicname>
98 98
                                    <taxonomicnamewithauthor>
99 99
                                        <_join_words>
100
                                            <1>$ScientificName</1>
100
                                            <1>
101
                                                <_alt>
102
                                                    <1>$ScientificName</1>
103
                                                    <2>
104
                                                        <_join_words>
105
                                                            <1>$family</1>
106
                                                            <2>$genus</2>
107
                                                            <3>$species</3>
108
                                                            <4>$Subspecies</4>
109
                                                        </_join_words>
110
                                                    </2>
111
                                                </_alt>
112
                                            </1>
101 113
                                            <2>$ScientificNameAuthor</2>
102 114
                                        </_join_words>
103 115
                                    </taxonomicnamewithauthor>
inputs/QMOR/Specimen/VegBIEN.csv
40 40
taxonRank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/subspecies/_alt/2/_join_words/1,
41 41
infraspecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/subspecies/_alt/2/_join_words/2,
42 42
scientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicname,
43
scientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/1,
44
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/1,
45
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/2,
46
specificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/3,
47
taxonRank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/5/_join_words/1,
48
infraspecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/5/_join_words/2,
49
scientificNameAuthorship,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/2,
43
scientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/1,
44
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/1,
45
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/2,
46
specificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/3,
47
taxonRank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1,
48
infraspecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2,
49
scientificNameAuthorship,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_alt/2/_join_words/2,
50 50
dateIdentified,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/1/_*/date/_dateRangeStart/value,
51 51
identificationQualifier,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/taxonfit,
52 52
recordedBy,/location/locationevent/taxonoccurrence/verbatimcollectorname,

Also available in: Unified diff