Project

General

Profile

« Previous | Next » 

Revision 5608

schemas/vegbien.sql: Renamed taxonconcept to taxonlabel per today's conference call, where it was decided that taxonconcept contained too many unrelated fields to be purely a taxon concept

View differences:

inputs/.TNRS/tnrs/test.xml.ref
7 7
                <locationevent>
8 8
                    <taxonoccurrence>
9 9
                        <taxondetermination>
10
                            <taxonconcept_id>
11
                                <taxonconcept>
10
                            <taxonlabel_id>
11
                                <taxonlabel>
12 12
                                    <identifyingtaxonomicname>
13 13
                                        <_join_words>
14 14
                                            <1>
......
37 37
                                            <2>$Name_matched_author</2>
38 38
                                        </_join_words>
39 39
                                    </identifyingtaxonomicname>
40
                                    <_taxonconcept_set_matched_concept_id>
41
                                        <matched_concept_id>
42
                                            <taxonconcept>
40
                                    <_taxonlabel_set_matched_label_id>
41
                                        <matched_label_id>
42
                                            <taxonlabel>
43 43
                                                <author>$Accepted_name_author</author>
44 44
                                                <family>$Accepted_name_family</family>
45 45
                                                <identifyingtaxonomicname>
......
54 54
                                                    </_join_words>
55 55
                                                </identifyingtaxonomicname>
56 56
                                                <parent_id>
57
                                                    <taxonconcept>
57
                                                    <taxonlabel>
58 58
                                                        <parent_id>
59
                                                            <taxonconcept>
59
                                                            <taxonlabel>
60 60
                                                                <rank>cultivar</rank>
61 61
                                                                <parent_id>
62
                                                                    <taxonconcept>
62
                                                                    <taxonlabel>
63 63
                                                                        <rank>forma</rank>
64 64
                                                                        <parent_id>
65
                                                                            <taxonconcept>
65
                                                                            <taxonlabel>
66 66
                                                                                <rank>variety</rank>
67 67
                                                                                <parent_id>
68
                                                                                    <taxonconcept>
68
                                                                                    <taxonlabel>
69 69
                                                                                        <rank>subspecies</rank>
70 70
                                                                                        <parent_id>
71
                                                                                            <taxonconcept>
71
                                                                                            <taxonlabel>
72 72
                                                                                                <rank>species</rank>
73 73
                                                                                                <parent_id>
74
                                                                                                    <taxonconcept>
74
                                                                                                    <taxonlabel>
75 75
                                                                                                        <rank>genus</rank>
76 76
                                                                                                        <parent_id>
77
                                                                                                            <taxonconcept>
77
                                                                                                            <taxonlabel>
78 78
                                                                                                                <rank>family</rank>
79
                                                                                                                <matched_concept_id>
80
                                                                                                                    <taxonconcept>
79
                                                                                                                <matched_label_id>
80
                                                                                                                    <taxonlabel>
81 81
                                                                                                                        <creator_id>
82 82
                                                                                                                            <party>
83 83
                                                                                                                                <creator_id>0</creator_id>
......
86 86
                                                                                                                        </creator_id>
87 87
                                                                                                                        <rank>family</rank>
88 88
                                                                                                                        <taxonepithet>$Accepted_name_family</taxonepithet>
89
                                                                                                                    </taxonconcept>
90
                                                                                                                </matched_concept_id>
89
                                                                                                                    </taxonlabel>
90
                                                                                                                </matched_label_id>
91 91
                                                                                                                <taxonepithet>$Accepted_name_family</taxonepithet>
92
                                                                                                            </taxonconcept>
92
                                                                                                            </taxonlabel>
93 93
                                                                                                        </parent_id>
94
                                                                                                    </taxonconcept>
94
                                                                                                    </taxonlabel>
95 95
                                                                                                </parent_id>
96
                                                                                            </taxonconcept>
96
                                                                                            </taxonlabel>
97 97
                                                                                        </parent_id>
98
                                                                                    </taxonconcept>
98
                                                                                    </taxonlabel>
99 99
                                                                                </parent_id>
100
                                                                            </taxonconcept>
100
                                                                            </taxonlabel>
101 101
                                                                        </parent_id>
102
                                                                    </taxonconcept>
102
                                                                    </taxonlabel>
103 103
                                                                </parent_id>
104
                                                            </taxonconcept>
104
                                                            </taxonlabel>
105 105
                                                        </parent_id>
106 106
                                                        <rank>$Accepted_name_rank</rank>
107 107
                                                        <verbatimrank>$Accepted_name_rank</verbatimrank>
108
                                                    </taxonconcept>
108
                                                    </taxonlabel>
109 109
                                                </parent_id>
110 110
                                                <rank>$Accepted_name_rank</rank>
111 111
                                                <taxonomicname>$Accepted_name</taxonomicname>
112 112
                                                <verbatimrank>$Accepted_name_rank</verbatimrank>
113
                                            </taxonconcept>
114
                                        </matched_concept_id>
115
                                    </_taxonconcept_set_matched_concept_id>
113
                                            </taxonlabel>
114
                                        </matched_label_id>
115
                                    </_taxonlabel_set_matched_label_id>
116 116
                                    <author>$Name_matched_author</author>
117 117
                                    <family>$Name_matched_accepted_family</family>
118 118
                                    <genus>$Genus_matched</genus>
119 119
                                    <parent_id>
120
                                        <taxonconcept>
120
                                        <taxonlabel>
121 121
                                            <rank>$Name_matched_rank</rank>
122 122
                                            <verbatimrank>$Name_matched_rank</verbatimrank>
123 123
                                            <parent_id>
124
                                                <taxonconcept>
124
                                                <taxonlabel>
125 125
                                                    <rank>cultivar</rank>
126 126
                                                    <parent_id>
127
                                                        <taxonconcept>
127
                                                        <taxonlabel>
128 128
                                                            <rank>forma</rank>
129 129
                                                            <parent_id>
130
                                                                <taxonconcept>
130
                                                                <taxonlabel>
131 131
                                                                    <rank>variety</rank>
132 132
                                                                    <parent_id>
133
                                                                        <taxonconcept>
133
                                                                        <taxonlabel>
134 134
                                                                            <rank>subspecies</rank>
135 135
                                                                            <parent_id>
136
                                                                                <taxonconcept>
136
                                                                                <taxonlabel>
137 137
                                                                                    <rank>species</rank>
138 138
                                                                                    <taxonepithet>$Specific_epithet_matched</taxonepithet>
139 139
                                                                                    <parent_id>
140
                                                                                        <taxonconcept>
140
                                                                                        <taxonlabel>
141 141
                                                                                            <rank>genus</rank>
142 142
                                                                                            <taxonepithet>$Genus_matched</taxonepithet>
143 143
                                                                                            <parent_id>
144
                                                                                                <taxonconcept>
144
                                                                                                <taxonlabel>
145 145
                                                                                                    <rank>family</rank>
146 146
                                                                                                    <taxonepithet>$Name_matched_accepted_family</taxonepithet>
147
                                                                                                </taxonconcept>
147
                                                                                                </taxonlabel>
148 148
                                                                                            </parent_id>
149
                                                                                        </taxonconcept>
149
                                                                                        </taxonlabel>
150 150
                                                                                    </parent_id>
151
                                                                                </taxonconcept>
151
                                                                                </taxonlabel>
152 152
                                                                            </parent_id>
153
                                                                        </taxonconcept>
153
                                                                        </taxonlabel>
154 154
                                                                    </parent_id>
155
                                                                </taxonconcept>
155
                                                                </taxonlabel>
156 156
                                                            </parent_id>
157
                                                        </taxonconcept>
157
                                                        </taxonlabel>
158 158
                                                    </parent_id>
159
                                                </taxonconcept>
159
                                                </taxonlabel>
160 160
                                            </parent_id>
161 161
                                            <taxonepithet>$Infraspecific_epithet_matched</taxonepithet>
162
                                        </taxonconcept>
162
                                        </taxonlabel>
163 163
                                    </parent_id>
164 164
                                    <rank>$Name_matched_rank</rank>
165 165
                                    <sourceaccessioncode>$Name_matched_url</sourceaccessioncode>
166 166
                                    <species>$Specific_epithet_matched</species>
167
                                    <taxonconcept fkey="matched_concept_id">
167
                                    <taxonlabel fkey="matched_label_id">
168 168
                                        <author>$Author_matched</author>
169 169
                                        <family>$Family_matched</family>
170 170
                                        <genus>$Genus_matched</genus>
171 171
                                        <identifyingtaxonomicname>$Name_submitted</identifyingtaxonomicname>
172
                                        <matched_concept_fit_fraction>
172
                                        <matched_label_fit_fraction>
173 173
                                            <_max>
174 174
                                                <1>$Family_score</1>
175 175
                                                <2>$Genus_score</2>
176 176
                                                <3>$Specific_epithet_score</3>
177 177
                                                <4>$Overall_score</4>
178 178
                                            </_max>
179
                                        </matched_concept_fit_fraction>
179
                                        </matched_label_fit_fraction>
180 180
                                        <species>$Specific_epithet_matched</species>
181 181
                                        <taxonepithet>$Unmatched_terms</taxonepithet>
182 182
                                        <taxonomicname>$Name_matched</taxonomicname>
183 183
                                        <verbatimrank>$Infraspecific_rank</verbatimrank>
184
                                    </taxonconcept>
184
                                    </taxonlabel>
185 185
                                    <taxonomicname>$Name_matched</taxonomicname>
186 186
                                    <verbatimrank>$Name_matched_rank</verbatimrank>
187
                                </taxonconcept>
188
                            </taxonconcept_id>
187
                                </taxonlabel>
188
                            </taxonlabel_id>
189 189
                        </taxondetermination>
190 190
                    </taxonoccurrence>
191 191
                </locationevent>
......
193 193
        </path>
194 194
    </_simplifyPath>
195 195
</VegBIEN>
196
Inserted 11 new rows into database
196
Inserted 12 new rows into database
inputs/ARIZ/Specimen/VegBIEN.csv
30 30
ScientificName,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/3",
31 31
GlobalUniqueIdentifier,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/3,
32 32
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/fullname,
33
ScientificNameAuthor,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_concept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/1",Contains the binomial in addition to the authority
34
ScientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_concept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1",
35
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_concept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
36
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_concept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
37
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_concept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
38
Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_concept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/4",
39
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/creator_id/_simplifyPath:[next=creator_id]/path/party/fullname/_alt/2,
40
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/family,
41
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus,
42
Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=subspecies]/taxonepithet",
43
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonepithet",
44
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonepithet",
45
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonepithet",
46
Order,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=order]/taxonepithet",
47
Class,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=class]/taxonepithet",
48
Phylum,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=phylum]/taxonepithet",
49
Kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,phylum,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=kingdom]/taxonepithet",
50
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/species,
51
ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonomicname,
52
ScientificNameAuthor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonomicnamewithauthor,Contains the binomial in addition to the authority
33
ScientificNameAuthor,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/1",Contains the binomial in addition to the authority
34
ScientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1",
35
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
36
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
37
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
38
Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/4",
39
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/creator_id/_simplifyPath:[next=creator_id]/path/party/fullname/_alt/2,
40
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/family,
41
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/genus,
42
Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=subspecies]/taxonepithet",
43
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=species]/taxonepithet",
44
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/taxonepithet",
45
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=family]/taxonepithet",
46
Order,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=order]/taxonepithet",
47
Class,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=class]/taxonepithet",
48
Phylum,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=phylum]/taxonepithet",
49
Kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,phylum,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=kingdom]/taxonepithet",
50
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/species,
51
ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonomicname,
52
ScientificNameAuthor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonomicnamewithauthor,Contains the binomial in addition to the authority
53 53
Remarks,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/notes,
54 54
IdentificationModifier,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/taxonfit,
55
DayIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/{determinationdate,*_id/taxonconcept/creationdate}/_alt/2/_date/day/_nullIf:[null=0,type=float]/value",
56
MonthIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/{determinationdate,*_id/taxonconcept/creationdate}/_alt/2/_date/month/_nullIf:[null=0,type=float]/value",
57
YearIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/{determinationdate,*_id/taxonconcept/creationdate}/_alt/2/_date/year/_nullIf:[null=0,type=float]/value",
55
DayIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/{determinationdate,*_id/taxonlabel/creationdate}/_alt/2/_date/day/_nullIf:[null=0,type=float]/value",
56
MonthIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/{determinationdate,*_id/taxonlabel/creationdate}/_alt/2/_date/month/_nullIf:[null=0,type=float]/value",
57
YearIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/{determinationdate,*_id/taxonlabel/creationdate}/_alt/2/_date/year/_nullIf:[null=0,type=float]/value",
58 58
Collector,/location/locationevent/taxonoccurrence/verbatimcollectorname,
59 59
CatalogNumberNumeric,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then/_alt/1",
60 60
CatalogNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then/_alt/2",Don't overwrite CatalogNumberNumeric
inputs/GBIF/Specimen/test.xml.ref
47 47
                        </aggregateoccurrence>
48 48
                        <taxondetermination>
49 49
                            <party_id><party><fullname>$IdentifiedBy</fullname></party></party_id>
50
                            <taxonconcept_id>
51
                                <taxonconcept>
52
                                    <matched_concept_id>
53
                                        <taxonconcept>
50
                            <taxonlabel_id>
51
                                <taxonlabel>
52
                                    <matched_label_id>
53
                                        <taxonlabel>
54 54
                                            <creator_id>
55 55
                                                <party>
56 56
                                                    <creator_id>0</creator_id>
......
75 75
                                                    <2>$AuthorOfScientificName</2>
76 76
                                                </_join_words>
77 77
                                            </identifyingtaxonomicname>
78
                                        </taxonconcept>
79
                                    </matched_concept_id>
78
                                        </taxonlabel>
79
                                    </matched_label_id>
80 80
                                    <author>$AuthorOfScientificName</author>
81 81
                                    <creator_id>
82 82
                                        <_simplifyPath>
......
87 87
                                    <family>$Family</family>
88 88
                                    <genus>$Genus</genus>
89 89
                                    <parent_id>
90
                                        <taxonconcept>
90
                                        <taxonlabel>
91 91
                                            <parent_id>
92
                                                <taxonconcept>
92
                                                <taxonlabel>
93 93
                                                    <rank>cultivar</rank>
94 94
                                                    <parent_id>
95
                                                        <taxonconcept>
95
                                                        <taxonlabel>
96 96
                                                            <rank>forma</rank>
97 97
                                                            <parent_id>
98
                                                                <taxonconcept>
98
                                                                <taxonlabel>
99 99
                                                                    <rank>variety</rank>
100 100
                                                                    <parent_id>
101
                                                                        <taxonconcept>
101
                                                                        <taxonlabel>
102 102
                                                                            <rank>subspecies</rank>
103 103
                                                                            <parent_id>
104
                                                                                <taxonconcept>
104
                                                                                <taxonlabel>
105 105
                                                                                    <rank>species</rank>
106 106
                                                                                    <taxonepithet>$SpecificEpithet</taxonepithet>
107 107
                                                                                    <parent_id>
108
                                                                                        <taxonconcept>
108
                                                                                        <taxonlabel>
109 109
                                                                                            <rank>genus</rank>
110 110
                                                                                            <taxonepithet>$Genus</taxonepithet>
111 111
                                                                                            <parent_id>
112
                                                                                                <taxonconcept>
112
                                                                                                <taxonlabel>
113 113
                                                                                                    <rank>family</rank>
114 114
                                                                                                    <taxonepithet>$Family</taxonepithet>
115
                                                                                                </taxonconcept>
115
                                                                                                </taxonlabel>
116 116
                                                                                            </parent_id>
117
                                                                                        </taxonconcept>
117
                                                                                        </taxonlabel>
118 118
                                                                                    </parent_id>
119
                                                                                </taxonconcept>
119
                                                                                </taxonlabel>
120 120
                                                                            </parent_id>
121
                                                                        </taxonconcept>
121
                                                                        </taxonlabel>
122 122
                                                                    </parent_id>
123
                                                                </taxonconcept>
123
                                                                </taxonlabel>
124 124
                                                            </parent_id>
125
                                                        </taxonconcept>
125
                                                        </taxonlabel>
126 126
                                                    </parent_id>
127
                                                </taxonconcept>
127
                                                </taxonlabel>
128 128
                                            </parent_id>
129 129
                                            <taxonepithet>$InfraspecificEpithet</taxonepithet>
130
                                        </taxonconcept>
130
                                        </taxonlabel>
131 131
                                    </parent_id>
132 132
                                    <species>$SpecificEpithet</species>
133 133
                                    <taxonomicname>$ScientificName</taxonomicname>
134
                                </taxonconcept>
135
                            </taxonconcept_id>
134
                                </taxonlabel>
135
                            </taxonlabel_id>
136 136
                        </taxondetermination>
137 137
                        <taxondetermination>
138 138
                            <isoriginal>true</isoriginal>
139
                            <taxonconcept_id>
140
                                <taxonconcept>
139
                            <taxonlabel_id>
140
                                <taxonlabel>
141 141
                                    <family>$GBIFFamilyOriginal</family>
142 142
                                    <genus>$GBIFGenusOriginal</genus>
143
                                    <matched_concept_id>
144
                                        <taxonconcept>
143
                                    <matched_label_id>
144
                                        <taxonlabel>
145 145
                                            <creator_id>
146 146
                                                <party>
147 147
                                                    <creator_id>0</creator_id>
......
159 159
                                                    </2>
160 160
                                                </_alt>
161 161
                                            </identifyingtaxonomicname>
162
                                        </taxonconcept>
163
                                    </matched_concept_id>
162
                                        </taxonlabel>
163
                                    </matched_label_id>
164 164
                                    <parent_id>
165
                                        <taxonconcept>
165
                                        <taxonlabel>
166 166
                                            <parent_id>
167
                                                <taxonconcept>
167
                                                <taxonlabel>
168 168
                                                    <rank>cultivar</rank>
169 169
                                                    <parent_id>
170
                                                        <taxonconcept>
170
                                                        <taxonlabel>
171 171
                                                            <rank>forma</rank>
172 172
                                                            <parent_id>
173
                                                                <taxonconcept>
173
                                                                <taxonlabel>
174 174
                                                                    <rank>variety</rank>
175 175
                                                                    <parent_id>
176
                                                                        <taxonconcept>
176
                                                                        <taxonlabel>
177 177
                                                                            <rank>subspecies</rank>
178 178
                                                                            <parent_id>
179
                                                                                <taxonconcept>
179
                                                                                <taxonlabel>
180 180
                                                                                    <rank>species</rank>
181 181
                                                                                    <parent_id>
182
                                                                                        <taxonconcept>
182
                                                                                        <taxonlabel>
183 183
                                                                                            <rank>genus</rank>
184 184
                                                                                            <taxonepithet>$GBIFGenusOriginal</taxonepithet>
185 185
                                                                                            <parent_id>
186
                                                                                                <taxonconcept>
186
                                                                                                <taxonlabel>
187 187
                                                                                                    <rank>family</rank>
188 188
                                                                                                    <taxonepithet>$GBIFFamilyOriginal</taxonepithet>
189
                                                                                                </taxonconcept>
189
                                                                                                </taxonlabel>
190 190
                                                                                            </parent_id>
191
                                                                                        </taxonconcept>
191
                                                                                        </taxonlabel>
192 192
                                                                                    </parent_id>
193
                                                                                </taxonconcept>
193
                                                                                </taxonlabel>
194 194
                                                                            </parent_id>
195
                                                                        </taxonconcept>
195
                                                                        </taxonlabel>
196 196
                                                                    </parent_id>
197
                                                                </taxonconcept>
197
                                                                </taxonlabel>
198 198
                                                            </parent_id>
199
                                                        </taxonconcept>
199
                                                        </taxonlabel>
200 200
                                                    </parent_id>
201
                                                </taxonconcept>
201
                                                </taxonlabel>
202 202
                                            </parent_id>
203
                                        </taxonconcept>
203
                                        </taxonlabel>
204 204
                                    </parent_id>
205 205
                                    <taxonomicname>$ScientificNameOriginal</taxonomicname>
206
                                </taxonconcept>
207
                            </taxonconcept_id>
206
                                </taxonlabel>
207
                            </taxonlabel_id>
208 208
                        </taxondetermination>
209 209
                        <verbatimcollectorname>$Collector</verbatimcollectorname>
210 210
                    </taxonoccurrence>
inputs/MT/Specimen/VegBIEN.csv
11 11
establishmentMeans,"/location/locationevent/taxonoccurrence/iscultivated/_alt/2/_map:[cultivated=t,wild=f,*=]/value",
12 12
establishmentMeans,"/location/locationevent/taxonoccurrence/isnative/_map:[native=t,exotic=f,*=]/value",
13 13
id,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/3,
14
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_concept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
15
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_concept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
16
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/family,
17
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus,
18
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonepithet",
19
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonepithet",
14
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
15
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
16
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/family,
17
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/genus,
18
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/taxonepithet",
19
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=family]/taxonepithet",
20 20
locality,/location/locationnarrative/_merge/1,
21 21
continent,/location/locationplace/*_id/placepath/continent,
22 22
basisOfRecord,,** No join mapping for basisOfRecord ** 
inputs/MT/Specimen/test.xml.ref
40 40
                        </isnative>
41 41
                        <sourceaccessioncode>$id</sourceaccessioncode>
42 42
                        <taxondetermination>
43
                            <taxonconcept_id>
44
                                <taxonconcept>
45
                                    <matched_concept_id>
46
                                        <taxonconcept>
43
                            <taxonlabel_id>
44
                                <taxonlabel>
45
                                    <matched_label_id>
46
                                        <taxonlabel>
47 47
                                            <creator_id>
48 48
                                                <party>
49 49
                                                    <creator_id>0</creator_id>
......
56 56
                                                    <2>$genus</2>
57 57
                                                </_join_words>
58 58
                                            </identifyingtaxonomicname>
59
                                        </taxonconcept>
60
                                    </matched_concept_id>
59
                                        </taxonlabel>
60
                                    </matched_label_id>
61 61
                                    <family>$family</family>
62 62
                                    <genus>$genus</genus>
63 63
                                    <parent_id>
64
                                        <taxonconcept>
64
                                        <taxonlabel>
65 65
                                            <parent_id>
66
                                                <taxonconcept>
66
                                                <taxonlabel>
67 67
                                                    <rank>cultivar</rank>
68 68
                                                    <parent_id>
69
                                                        <taxonconcept>
69
                                                        <taxonlabel>
70 70
                                                            <rank>forma</rank>
71 71
                                                            <parent_id>
72
                                                                <taxonconcept>
72
                                                                <taxonlabel>
73 73
                                                                    <rank>variety</rank>
74 74
                                                                    <parent_id>
75
                                                                        <taxonconcept>
75
                                                                        <taxonlabel>
76 76
                                                                            <rank>subspecies</rank>
77 77
                                                                            <parent_id>
78
                                                                                <taxonconcept>
78
                                                                                <taxonlabel>
79 79
                                                                                    <rank>species</rank>
80 80
                                                                                    <parent_id>
81
                                                                                        <taxonconcept>
81
                                                                                        <taxonlabel>
82 82
                                                                                            <rank>genus</rank>
83 83
                                                                                            <taxonepithet>$genus</taxonepithet>
84 84
                                                                                            <parent_id>
85
                                                                                                <taxonconcept>
85
                                                                                                <taxonlabel>
86 86
                                                                                                    <rank>family</rank>
87 87
                                                                                                    <taxonepithet>$family</taxonepithet>
88
                                                                                                </taxonconcept>
88
                                                                                                </taxonlabel>
89 89
                                                                                            </parent_id>
90
                                                                                        </taxonconcept>
90
                                                                                        </taxonlabel>
91 91
                                                                                    </parent_id>
92
                                                                                </taxonconcept>
92
                                                                                </taxonlabel>
93 93
                                                                            </parent_id>
94
                                                                        </taxonconcept>
94
                                                                        </taxonlabel>
95 95
                                                                    </parent_id>
96
                                                                </taxonconcept>
96
                                                                </taxonlabel>
97 97
                                                            </parent_id>
98
                                                        </taxonconcept>
98
                                                        </taxonlabel>
99 99
                                                    </parent_id>
100
                                                </taxonconcept>
100
                                                </taxonlabel>
101 101
                                            </parent_id>
102
                                        </taxonconcept>
102
                                        </taxonlabel>
103 103
                                    </parent_id>
104
                                </taxonconcept>
105
                            </taxonconcept_id>
104
                                </taxonlabel>
105
                            </taxonlabel_id>
106 106
                        </taxondetermination>
107 107
                    </taxonoccurrence>
108 108
                </locationevent>
inputs/test_taxonomic_names/Taxon/VegBIEN.csv
1 1
test_taxonomic_names,VegBIEN:/_simplifyPath:[next=parent_id]/path,Comments
2 2
scientificName,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/3",
3
scientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_concept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1",
4
scientificNameID,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/sourceaccessioncode,
5
scientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonomicname,
3
scientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1",
4
scientificNameID,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/sourceaccessioncode,
5
scientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonomicname,
inputs/test_taxonomic_names/Taxon/test.xml.ref
7 7
                <locationevent>
8 8
                    <taxonoccurrence>
9 9
                        <taxondetermination>
10
                            <taxonconcept_id>
11
                                <taxonconcept>
12
                                    <matched_concept_id>
13
                                        <taxonconcept>
10
                            <taxonlabel_id>
11
                                <taxonlabel>
12
                                    <matched_label_id>
13
                                        <taxonlabel>
14 14
                                            <creator_id>
15 15
                                                <party>
16 16
                                                    <creator_id>0</creator_id>
......
18 18
                                                </party>
19 19
                                            </creator_id>
20 20
                                            <identifyingtaxonomicname>$scientificName</identifyingtaxonomicname>
21
                                        </taxonconcept>
22
                                    </matched_concept_id>
21
                                        </taxonlabel>
22
                                    </matched_label_id>
23 23
                                    <sourceaccessioncode>$scientificNameID</sourceaccessioncode>
24 24
                                    <taxonomicname>$scientificName</taxonomicname>
25
                                </taxonconcept>
26
                            </taxonconcept_id>
25
                                </taxonlabel>
26
                            </taxonlabel_id>
27 27
                        </taxondetermination>
28 28
                    </taxonoccurrence>
29 29
                </locationevent>
inputs/XAL/Specimen/VegBIEN.csv
21 21
darwin:CollectorNumber,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/1/_first/1",
22 22
darwin:ScientificName,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/3",
23 23
darwin:IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/fullname,
24
darwin:ScientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_concept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1",
25
darwin:Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_concept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
26
darwin:Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_concept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
27
darwin:Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_concept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
28
darwin:Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_concept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/4",
29
darwin:ScientificNameAuthor,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_concept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/2",
30
darwin:ScientificNameAuthor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/author,
31
darwin:IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/creator_id/_simplifyPath:[next=creator_id]/path/party/fullname/_alt/2,
32
darwin:Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/family,
33
darwin:Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus,
34
darwin:Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=subspecies]/taxonepithet",
35
darwin:Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonepithet",
36
darwin:Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonepithet",
37
darwin:Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonepithet",
38
darwin:Order,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=order]/taxonepithet",
39
darwin:Class,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=class]/taxonepithet",
40
darwin:Phylum,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=phylum]/taxonepithet",
41
darwin:Kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,phylum,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=kingdom]/taxonepithet",
42
darwin:Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/species,
43
darwin:ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonomicname,
44
darwin:DayIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/{determinationdate,*_id/taxonconcept/creationdate}/_alt/2/_date/day/_nullIf:[null=0,type=float]/value",
45
darwin:MonthIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/{determinationdate,*_id/taxonconcept/creationdate}/_alt/2/_date/month/_nullIf:[null=0,type=float]/value",
46
darwin:YearIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/{determinationdate,*_id/taxonconcept/creationdate}/_alt/2/_date/year/_nullIf:[null=0,type=float]/value",
24
darwin:ScientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1",
25
darwin:Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
26
darwin:Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
27
darwin:Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
28
darwin:Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/4",
29
darwin:ScientificNameAuthor,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/2",
30
darwin:ScientificNameAuthor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/author,
31
darwin:IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/creator_id/_simplifyPath:[next=creator_id]/path/party/fullname/_alt/2,
32
darwin:Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/family,
33
darwin:Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/genus,
34
darwin:Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=subspecies]/taxonepithet",
35
darwin:Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=species]/taxonepithet",
36
darwin:Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/taxonepithet",
37
darwin:Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=family]/taxonepithet",
38
darwin:Order,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=order]/taxonepithet",
39
darwin:Class,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=class]/taxonepithet",
40
darwin:Phylum,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=phylum]/taxonepithet",
41
darwin:Kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,phylum,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=kingdom]/taxonepithet",
42
darwin:Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/species,
43
darwin:ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonomicname,
44
darwin:DayIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/{determinationdate,*_id/taxonlabel/creationdate}/_alt/2/_date/day/_nullIf:[null=0,type=float]/value",
45
darwin:MonthIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/{determinationdate,*_id/taxonlabel/creationdate}/_alt/2/_date/month/_nullIf:[null=0,type=float]/value",
46
darwin:YearIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/{determinationdate,*_id/taxonlabel/creationdate}/_alt/2/_date/year/_nullIf:[null=0,type=float]/value",
47 47
darwin:Collector,/location/locationevent/taxonoccurrence/verbatimcollectorname,
48 48
darwin:CatalogNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then",
49 49
darwin:MaximumDepth,/location/locationevent/waterdepth_m/_avg/max,
inputs/TEAM/VL/VegBIEN.csv
20 20
1ha Plot Number,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",
21 21
Tree Number,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/1/_first/2",
22 22
Id,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/3,
23
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_concept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
24
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_concept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
25
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_concept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
26
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/family,
27
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus,
28
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonepithet",
29
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonepithet",
30
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonepithet",
31
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/species,
23
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
24
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
25
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
26
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/family,
27
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/genus,
28
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=species]/taxonepithet",
29
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/taxonepithet",
30
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=family]/taxonepithet",
31
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/species,
32 32
Names of Collectors,/location/locationevent/taxonoccurrence/verbatimcollectorname,
33 33
Comments,,** No join mapping for *Comments ** 
34 34
Condition Codes,,** No join mapping for *Condition Codes ** 
inputs/TEAM/VL/test.xml.ref
42 42
                        <authortaxoncode>$Tree Number</authortaxoncode>
43 43
                        <sourceaccessioncode>$Id</sourceaccessioncode>
44 44
                        <taxondetermination>
45
                            <taxonconcept_id>
46
                                <taxonconcept>
47
                                    <matched_concept_id>
48
                                        <taxonconcept>
45
                            <taxonlabel_id>
46
                                <taxonlabel>
47
                                    <matched_label_id>
48
                                        <taxonlabel>
49 49
                                            <creator_id>
50 50
                                                <party>
51 51
                                                    <creator_id>0</creator_id>
......
59 59
                                                    <3>$Species</3>
60 60
                                                </_join_words>
61 61
                                            </identifyingtaxonomicname>
62
                                        </taxonconcept>
63
                                    </matched_concept_id>
62
                                        </taxonlabel>
63
                                    </matched_label_id>
64 64
                                    <family>$Family</family>
65 65
                                    <genus>$Genus</genus>
66 66
                                    <parent_id>
67
                                        <taxonconcept>
67
                                        <taxonlabel>
68 68
                                            <parent_id>
69
                                                <taxonconcept>
69
                                                <taxonlabel>
70 70
                                                    <rank>cultivar</rank>
71 71
                                                    <parent_id>
72
                                                        <taxonconcept>
72
                                                        <taxonlabel>
73 73
                                                            <rank>forma</rank>
74 74
                                                            <parent_id>
75
                                                                <taxonconcept>
75
                                                                <taxonlabel>
76 76
                                                                    <rank>variety</rank>
77 77
                                                                    <parent_id>
78
                                                                        <taxonconcept>
78
                                                                        <taxonlabel>
79 79
                                                                            <rank>subspecies</rank>
80 80
                                                                            <parent_id>
81
                                                                                <taxonconcept>
81
                                                                                <taxonlabel>
82 82
                                                                                    <rank>species</rank>
83 83
                                                                                    <taxonepithet>$Species</taxonepithet>
84 84
                                                                                    <parent_id>
85
                                                                                        <taxonconcept>
85
                                                                                        <taxonlabel>
86 86
                                                                                            <rank>genus</rank>
87 87
                                                                                            <taxonepithet>$Genus</taxonepithet>
88 88
                                                                                            <parent_id>
89
                                                                                                <taxonconcept>
89
                                                                                                <taxonlabel>
90 90
                                                                                                    <rank>family</rank>
91 91
                                                                                                    <taxonepithet>$Family</taxonepithet>
92
                                                                                                </taxonconcept>
92
                                                                                                </taxonlabel>
93 93
                                                                                            </parent_id>
94
                                                                                        </taxonconcept>
94
                                                                                        </taxonlabel>
95 95
                                                                                    </parent_id>
96
                                                                                </taxonconcept>
96
                                                                                </taxonlabel>
97 97
                                                                            </parent_id>
98
                                                                        </taxonconcept>
98
                                                                        </taxonlabel>
99 99
                                                                    </parent_id>
100
                                                                </taxonconcept>
100
                                                                </taxonlabel>
101 101
                                                            </parent_id>
102
                                                        </taxonconcept>
102
                                                        </taxonlabel>
103 103
                                                    </parent_id>
104
                                                </taxonconcept>
104
                                                </taxonlabel>
105 105
                                            </parent_id>
106
                                        </taxonconcept>
106
                                        </taxonlabel>
107 107
                                    </parent_id>
108 108
                                    <species>$Species</species>
109
                                </taxonconcept>
110
                            </taxonconcept_id>
109
                                </taxonlabel>
110
                            </taxonlabel_id>
111 111
                        </taxondetermination>
112 112
                        <verbatimcollectorname>$Names of Collectors</verbatimcollectorname>
113 113
                    </taxonoccurrence>
inputs/TEAM/VT/VegBIEN.csv
20 20
1ha Plot Number,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",
21 21
Tree Number,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/1/_first/2",
22 22
Id,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/3,
23
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_concept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
24
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_concept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
25
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_concept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
26
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/family,
27
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus,
28
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonepithet",
29
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonepithet",
30
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonepithet",
31
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/species,
23
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
24
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
25
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
26
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/family,
27
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/genus,
28
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=species]/taxonepithet",
29
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/taxonepithet",
30
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=family]/taxonepithet",
31
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/species,
32 32
Names of Collectors,/location/locationevent/taxonoccurrence/verbatimcollectorname,
33 33
Comments,,** No join mapping for *Comments ** 
34 34
Condition Codes,,** No join mapping for *Condition Codes ** 
inputs/TEAM/VT/test.xml.ref
42 42
                        <authortaxoncode>$Tree Number</authortaxoncode>
43 43
                        <sourceaccessioncode>$Id</sourceaccessioncode>
44 44
                        <taxondetermination>
45
                            <taxonconcept_id>
46
                                <taxonconcept>
47
                                    <matched_concept_id>
48
                                        <taxonconcept>
45
                            <taxonlabel_id>
46
                                <taxonlabel>
47
                                    <matched_label_id>
48
                                        <taxonlabel>
49 49
                                            <creator_id>
50 50
                                                <party>
51 51
                                                    <creator_id>0</creator_id>
......
59 59
                                                    <3>$Species</3>
60 60
                                                </_join_words>
61 61
                                            </identifyingtaxonomicname>
62
                                        </taxonconcept>
63
                                    </matched_concept_id>
62
                                        </taxonlabel>
63
                                    </matched_label_id>
64 64
                                    <family>$Family</family>
65 65
                                    <genus>$Genus</genus>
66 66
                                    <parent_id>
67
                                        <taxonconcept>
67
                                        <taxonlabel>
68 68
                                            <parent_id>
69
                                                <taxonconcept>
69
                                                <taxonlabel>
70 70
                                                    <rank>cultivar</rank>
71 71
                                                    <parent_id>
72
                                                        <taxonconcept>
72
                                                        <taxonlabel>
73 73
                                                            <rank>forma</rank>
74 74
                                                            <parent_id>
75
                                                                <taxonconcept>
75
                                                                <taxonlabel>
76 76
                                                                    <rank>variety</rank>
77 77
                                                                    <parent_id>
78
                                                                        <taxonconcept>
78
                                                                        <taxonlabel>
79 79
                                                                            <rank>subspecies</rank>
80 80
                                                                            <parent_id>
81
                                                                                <taxonconcept>
81
                                                                                <taxonlabel>
82 82
                                                                                    <rank>species</rank>
83 83
                                                                                    <taxonepithet>$Species</taxonepithet>
84 84
                                                                                    <parent_id>
85
                                                                                        <taxonconcept>
85
                                                                                        <taxonlabel>
86 86
                                                                                            <rank>genus</rank>
87 87
                                                                                            <taxonepithet>$Genus</taxonepithet>
88 88
                                                                                            <parent_id>
89
                                                                                                <taxonconcept>
89
                                                                                                <taxonlabel>
90 90
                                                                                                    <rank>family</rank>
91 91
                                                                                                    <taxonepithet>$Family</taxonepithet>
92
                                                                                                </taxonconcept>
92
                                                                                                </taxonlabel>
93 93
                                                                                            </parent_id>
94
                                                                                        </taxonconcept>
94
                                                                                        </taxonlabel>
95 95
                                                                                    </parent_id>
96
                                                                                </taxonconcept>
96
                                                                                </taxonlabel>
97 97
                                                                            </parent_id>
98
                                                                        </taxonconcept>
98
                                                                        </taxonlabel>
99 99
                                                                    </parent_id>
100
                                                                </taxonconcept>
100
                                                                </taxonlabel>
101 101
                                                            </parent_id>
102
                                                        </taxonconcept>
102
                                                        </taxonlabel>
103 103
                                                    </parent_id>
104
                                                </taxonconcept>
104
                                                </taxonlabel>
105 105
                                            </parent_id>
106
                                        </taxonconcept>
106
                                        </taxonlabel>
107 107
                                    </parent_id>
108 108
                                    <species>$Species</species>
109
                                </taxonconcept>
110
                            </taxonconcept_id>
109
                                </taxonlabel>
110
                            </taxonlabel_id>
111 111
                        </taxondetermination>
112 112
                        <verbatimcollectorname>$Names of Collectors</verbatimcollectorname>
113 113
                    </taxonoccurrence>
inputs/NY/Specimen/VegBIEN.csv
26 26
ScientificName,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/3",
27 27
UniqueNYInternalRecordNumber,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/3,
28 28
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/fullname,
29
ScientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_concept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1",
30
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_concept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
31
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_concept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
32
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_concept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
33
Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_concept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/4",
34
ScientificNameAuthor,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_concept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/2",
35
ScientificNameAuthor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/author,
36
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/creator_id/_simplifyPath:[next=creator_id]/path/party/fullname/_alt/2,
37
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/family,
38
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus,
39
Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=subspecies]/taxonepithet",
40
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonepithet",
41
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonepithet",
42
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonepithet",
43
Order,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=order]/taxonepithet",
44
Class,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=class]/taxonepithet",
45
Phylum,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=phylum]/taxonepithet",
46
Kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,phylum,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=kingdom]/taxonepithet",
47
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/species,
48
ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonomicname,
49
DayIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/{determinationdate,*_id/taxonconcept/creationdate}/_alt/2/_date/day/_nullIf:[null=0,type=float]/value",
50
MonthIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/{determinationdate,*_id/taxonconcept/creationdate}/_alt/2/_date/month/_nullIf:[null=0,type=float]/value",
51
YearIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/{determinationdate,*_id/taxonconcept/creationdate}/_alt/2/_date/year/_nullIf:[null=0,type=float]/value",
29
ScientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1",
30
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
31
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
32
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
33
Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/4",
34
ScientificNameAuthor,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/2",
35
ScientificNameAuthor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/author,
36
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/creator_id/_simplifyPath:[next=creator_id]/path/party/fullname/_alt/2,
37
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/family,
38
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/genus,
39
Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=subspecies]/taxonepithet",
40
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=species]/taxonepithet",
41
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/taxonepithet",
42
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=family]/taxonepithet",
43
Order,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=order]/taxonepithet",
44
Class,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=class]/taxonepithet",
45
Phylum,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=phylum]/taxonepithet",
46
Kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,phylum,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=kingdom]/taxonepithet",
47
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/species,
48
ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonomicname,
49
DayIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/{determinationdate,*_id/taxonlabel/creationdate}/_alt/2/_date/day/_nullIf:[null=0,type=float]/value",
50
MonthIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/{determinationdate,*_id/taxonlabel/creationdate}/_alt/2/_date/month/_nullIf:[null=0,type=float]/value",
51
YearIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/{determinationdate,*_id/taxonlabel/creationdate}/_alt/2/_date/year/_nullIf:[null=0,type=float]/value",
52 52
Collector,/location/locationevent/taxonoccurrence/verbatimcollectorname,
53 53
CatalogNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then",
54 54
MaximumDepth,/location/locationevent/waterdepth_m/_avg/max,
inputs/NY/Specimen/test.xml.ref
107 107
                        <sourceaccessioncode>$UniqueNYInternalRecordNumber</sourceaccessioncode>
108 108
                        <taxondetermination>
109 109
                            <party_id><party><fullname>$IdentifiedBy</fullname></party></party_id>
110
                            <taxonconcept_id>
111
                                <taxonconcept>
112
                                    <matched_concept_id>
113
                                        <taxonconcept>
110
                            <taxonlabel_id>
111
                                <taxonlabel>
112
                                    <matched_label_id>
113
                                        <taxonlabel>
114 114
                                            <creator_id>
115 115
                                                <party>
116 116
                                                    <creator_id>0</creator_id>
......
135 135
                                                    <2>$ScientificNameAuthor</2>
136 136
                                                </_join_words>
137 137
                                            </identifyingtaxonomicname>
138
                                        </taxonconcept>
139
                                    </matched_concept_id>
138
                                        </taxonlabel>
139
                                    </matched_label_id>
140 140
                                    <author>$ScientificNameAuthor</author>
141 141
                                    <creator_id>
142 142
                                        <_simplifyPath>
......
147 147
                                    <family>$Family</family>
148 148
                                    <genus>$Genus</genus>
149 149
                                    <parent_id>
150
                                        <taxonconcept>
150
                                        <taxonlabel>
151 151
                                            <parent_id>
152
                                                <taxonconcept>
152
                                                <taxonlabel>
153 153
                                                    <rank>cultivar</rank>
154 154
                                                    <parent_id>
155
                                                        <taxonconcept>
155
                                                        <taxonlabel>
156 156
                                                            <rank>forma</rank>
157 157
                                                            <parent_id>
158
                                                                <taxonconcept>
158
                                                                <taxonlabel>
159 159
                                                                    <rank>variety</rank>
160 160
                                                                    <parent_id>
161
                                                                        <taxonconcept>
161
                                                                        <taxonlabel>
162 162
                                                                            <rank>subspecies</rank>
163 163
                                                                            <taxonepithet>$Subspecies</taxonepithet>
164 164
                                                                            <parent_id>
165
                                                                                <taxonconcept>
165
                                                                                <taxonlabel>
166 166
                                                                                    <rank>species</rank>
167 167
                                                                                    <taxonepithet>$Species</taxonepithet>
168 168
                                                                                    <parent_id>
169
                                                                                        <taxonconcept>
169
                                                                                        <taxonlabel>
170 170
                                                                                            <rank>genus</rank>
171 171
                                                                                            <taxonepithet>$Genus</taxonepithet>
172 172
                                                                                            <parent_id>
173
                                                                                                <taxonconcept>
173
                                                                                                <taxonlabel>
174 174
                                                                                                    <rank>family</rank>
175 175
                                                                                                    <taxonepithet>$Family</taxonepithet>
176 176
                                                                                                    <parent_id>
177
                                                                                                        <taxonconcept>
177
                                                                                                        <taxonlabel>
178 178
                                                                                                            <rank>order</rank>
179 179
                                                                                                            <taxonepithet>$Order</taxonepithet>
180 180
                                                                                                            <parent_id>
181
                                                                                                                <taxonconcept>
181
                                                                                                                <taxonlabel>
182 182
                                                                                                                    <rank>class</rank>
183 183
                                                                                                                    <taxonepithet>$Class</taxonepithet>
184 184
                                                                                                                    <parent_id>
185
                                                                                                                        <taxonconcept>
185
                                                                                                                        <taxonlabel>
186 186
                                                                                                                            <rank>phylum</rank>
187 187
                                                                                                                            <taxonepithet>$Phylum</taxonepithet>
188 188
                                                                                                                            <parent_id>
189
                                                                                                                                <taxonconcept>
189
                                                                                                                                <taxonlabel>
190 190
                                                                                                                                    <rank>kingdom</rank>
191 191
                                                                                                                                    <taxonepithet>$Kingdom</taxonepithet>
192
                                                                                                                                </taxonconcept>
192
                                                                                                                                </taxonlabel>
193 193
                                                                                                                            </parent_id>
194
                                                                                                                        </taxonconcept>
194
                                                                                                                        </taxonlabel>
195 195
                                                                                                                    </parent_id>
196
                                                                                                                </taxonconcept>
196
                                                                                                                </taxonlabel>
197 197
                                                                                                            </parent_id>
198
                                                                                                        </taxonconcept>
198
                                                                                                        </taxonlabel>
199 199
                                                                                                    </parent_id>
200
                                                                                                </taxonconcept>
200
                                                                                                </taxonlabel>
201 201
                                                                                            </parent_id>
202
                                                                                        </taxonconcept>
202
                                                                                        </taxonlabel>
203 203
                                                                                    </parent_id>
204
                                                                                </taxonconcept>
204
                                                                                </taxonlabel>
205 205
                                                                            </parent_id>
206
                                                                        </taxonconcept>
206
                                                                        </taxonlabel>
207 207
                                                                    </parent_id>
208
                                                                </taxonconcept>
208
                                                                </taxonlabel>
209 209
                                                            </parent_id>
210
                                                        </taxonconcept>
210
                                                        </taxonlabel>
211 211
                                                    </parent_id>
212
                                                </taxonconcept>
212
                                                </taxonlabel>
213 213
                                            </parent_id>
214
                                        </taxonconcept>
214
                                        </taxonlabel>
215 215
                                    </parent_id>
216 216
                                    <species>$Species</species>
217 217
                                    <taxonomicname>$ScientificName</taxonomicname>
......
240 240
                                            </year>
241 241
                                        </_date>
242 242
                                    </creationdate>
243
                                </taxonconcept>
244
                            </taxonconcept_id>
243
                                </taxonlabel>
244
                            </taxonlabel_id>
245 245
                            <determinationdate>
246 246
                                <_date>
247 247
                                    <day>
inputs/Madidi/Organism/VegBIEN.csv
30 30
Species and morphotypes,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/3","Contains less than ""Specie+autor"""
31 31
Habit,"/location/locationevent/taxonoccurrence/growthform/_map:[./{T,Arbol,palm}=tree,./{H,""Hemiepífito""}=hemiepiphyte,./{L,l,""L?"",Liana}=liana,E=epiphyte,S=shrub,Hb=herb,""vine-herbaceous""=vine,graminoid=grass,rosette=forb,*=*]/value","According to <http://salvias.net/Documents/salvias_data_dictionary.html#Plot+data.habit>, <https://projects.nceas.ucsb.edu/nceas/projects/bien/wiki/SALVIAS#Habit>"
32 32
Determined by,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/fullname,
33
Specie+autor,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_concept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/1",
34
Species and morphotypes,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_concept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1","Contains less than ""Specie+autor"""
35
Family (revised),"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_concept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
36
Genera,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_concept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
37
Specific epithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_concept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
38
Autor (revised),"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_concept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/2",
39
Autor (revised),/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/author,
40
Determined by,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/creator_id/_simplifyPath:[next=creator_id]/path/party/fullname/_alt/2,
41
Family (revised),/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/family,
42
Genera,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus,
43
Specific epithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonepithet",
44
Genera,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonepithet",
45
Family (revised),"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonepithet",
46
Specific epithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/species,
47
Species and morphotypes,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonomicname,"Contains less than ""Specie+autor"""
48
Specie+autor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonomicnamewithauthor,
33
Specie+autor,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/1",
34
Species and morphotypes,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1","Contains less than ""Specie+autor"""
35
Family (revised),"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
36
Genera,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
37
Specific epithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
38
Autor (revised),"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/2",
39
Autor (revised),/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/author,
40
Determined by,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/creator_id/_simplifyPath:[next=creator_id]/path/party/fullname/_alt/2,
41
Family (revised),/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/family,
42
Genera,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/genus,
43
Specific epithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=species]/taxonepithet",
44
Genera,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/taxonepithet",
45
Family (revised),"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=family]/taxonepithet",
46
Specific epithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/species,
47
Species and morphotypes,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonomicname,"Contains less than ""Specie+autor"""
48
Specie+autor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonomicnamewithauthor,
49 49
Qualifier,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/taxonfit,
50
Field family,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/family,
51
Field name,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/genus,Often = Genera
52
Field family,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/matched_concept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,
53
Field name,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/matched_concept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2,Often = Genera
54
Field name,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonepithet",Often = Genera
55
Field family,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonepithet",
50
Field family,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/family,
51
Field name,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/genus,Often = Genera
52
Field family,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,
53
Field name,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2,Often = Genera
54
Field name,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/taxonepithet",Often = Genera
55
Field family,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=family]/taxonepithet",
56 56
Index collector,/location/locationevent/taxonoccurrence/verbatimcollectorname,
57 57
Specimen,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then",
58 58
Basal area,,"** No join mapping for *Basal area ** Would be basalDiameter, but need formula to translate"
inputs/Madidi/Organism/test.xml.ref
62 62
                        </growthform>
63 63
                        <taxondetermination>
64 64
                            <party_id><party><fullname>$Determined by</fullname></party></party_id>
65
                            <taxonconcept_id>
66
                                <taxonconcept>
67
                                    <matched_concept_id>
68
                                        <taxonconcept>
65
                            <taxonlabel_id>
66
                                <taxonlabel>
67
                                    <matched_label_id>
68
                                        <taxonlabel>
69 69
                                            <creator_id>
70 70
                                                <party>
71 71
                                                    <creator_id>0</creator_id>
......
94 94
                                                    </2>
95 95
                                                </_alt>
96 96
                                            </identifyingtaxonomicname>
97
                                        </taxonconcept>
98
                                    </matched_concept_id>
97
                                        </taxonlabel>
98
                                    </matched_label_id>
99 99
                                    <author>$Autor (revised)</author>
100 100
                                    <creator_id>
101 101
                                        <_simplifyPath>
......
106 106
                                    <family>$Family (revised)</family>
107 107
                                    <genus>$Genera</genus>
108 108
                                    <parent_id>
109
                                        <taxonconcept>
109
                                        <taxonlabel>
110 110
                                            <parent_id>
111
                                                <taxonconcept>
111
                                                <taxonlabel>
112 112
                                                    <rank>cultivar</rank>
113 113
                                                    <parent_id>
114
                                                        <taxonconcept>
114
                                                        <taxonlabel>
115 115
                                                            <rank>forma</rank>
116 116
                                                            <parent_id>
117
                                                                <taxonconcept>
117
                                                                <taxonlabel>
118 118
                                                                    <rank>variety</rank>
119 119
                                                                    <parent_id>
120
                                                                        <taxonconcept>
120
                                                                        <taxonlabel>
121 121
                                                                            <rank>subspecies</rank>
122 122
                                                                            <parent_id>
123
                                                                                <taxonconcept>
123
                                                                                <taxonlabel>
124 124
                                                                                    <rank>species</rank>
125 125
                                                                                    <taxonepithet>$Specific epithet</taxonepithet>
126 126
                                                                                    <parent_id>
127
                                                                                        <taxonconcept>
127
                                                                                        <taxonlabel>
128 128
                                                                                            <rank>genus</rank>
129 129
                                                                                            <taxonepithet>$Genera</taxonepithet>
130 130
                                                                                            <parent_id>
131
                                                                                                <taxonconcept>
131
                                                                                                <taxonlabel>
132 132
                                                                                                    <rank>family</rank>
133 133
                                                                                                    <taxonepithet>$Family (revised)</taxonepithet>
134
                                                                                                </taxonconcept>
134
                                                                                                </taxonlabel>
135 135
                                                                                            </parent_id>
136
                                                                                        </taxonconcept>
136
                                                                                        </taxonlabel>
137 137
                                                                                    </parent_id>
138
                                                                                </taxonconcept>
138
                                                                                </taxonlabel>
139 139
                                                                            </parent_id>
140
                                                                        </taxonconcept>
140
                                                                        </taxonlabel>
141 141
                                                                    </parent_id>
142
                                                                </taxonconcept>
142
                                                                </taxonlabel>
143 143
                                                            </parent_id>
144
                                                        </taxonconcept>
144
                                                        </taxonlabel>
145 145
                                                    </parent_id>
146
                                                </taxonconcept>
146
                                                </taxonlabel>
147 147
                                            </parent_id>
148
                                        </taxonconcept>
148
                                        </taxonlabel>
149 149
                                    </parent_id>
150 150
                                    <species>$Specific epithet</species>
151 151
                                    <taxonomicname>$Species and morphotypes</taxonomicname>
152 152
                                    <taxonomicnamewithauthor>$Specie+autor</taxonomicnamewithauthor>
153
                                </taxonconcept>
154
                            </taxonconcept_id>
153
                                </taxonlabel>
154
                            </taxonlabel_id>
155 155
                            <taxonfit>$Qualifier</taxonfit>
156 156
                        </taxondetermination>
157 157
                        <taxondetermination>
158 158
                            <isoriginal>true</isoriginal>
159
                            <taxonconcept_id>
160
                                <taxonconcept>
159
                            <taxonlabel_id>
160
                                <taxonlabel>
161 161
                                    <family>$Field family</family>
162 162
                                    <genus>$Field name</genus>
163
                                    <matched_concept_id>
164
                                        <taxonconcept>
163
                                    <matched_label_id>
164
                                        <taxonlabel>
165 165
                                            <creator_id>
166 166
                                                <party>
167 167
                                                    <creator_id>0</creator_id>
......
174 174
                                                    <2>$Field name</2>
175 175
                                                </_join_words>
176 176
                                            </identifyingtaxonomicname>
177
                                        </taxonconcept>
178
                                    </matched_concept_id>
177
                                        </taxonlabel>
178
                                    </matched_label_id>
179 179
                                    <parent_id>
180
                                        <taxonconcept>
180
                                        <taxonlabel>
181 181
                                            <parent_id>
182
                                                <taxonconcept>
182
                                                <taxonlabel>
183 183
                                                    <rank>cultivar</rank>
184 184
                                                    <parent_id>
185
                                                        <taxonconcept>
185
                                                        <taxonlabel>
186 186
                                                            <rank>forma</rank>
187 187
                                                            <parent_id>
188
                                                                <taxonconcept>
188
                                                                <taxonlabel>
189 189
                                                                    <rank>variety</rank>
190 190
                                                                    <parent_id>
191
                                                                        <taxonconcept>
191
                                                                        <taxonlabel>
192 192
                                                                            <rank>subspecies</rank>
193 193
                                                                            <parent_id>
194
                                                                                <taxonconcept>
194
                                                                                <taxonlabel>
195 195
                                                                                    <rank>species</rank>
196 196
                                                                                    <parent_id>
197
                                                                                        <taxonconcept>
197
                                                                                        <taxonlabel>
198 198
                                                                                            <rank>genus</rank>
199 199
                                                                                            <taxonepithet>$Field name</taxonepithet>
200 200
                                                                                            <parent_id>
201
                                                                                                <taxonconcept>
201
                                                                                                <taxonlabel>
202 202
                                                                                                    <rank>family</rank>
203 203
                                                                                                    <taxonepithet>$Field family</taxonepithet>
204
                                                                                                </taxonconcept>
204
                                                                                                </taxonlabel>
205 205
                                                                                            </parent_id>
206
                                                                                        </taxonconcept>
206
                                                                                        </taxonlabel>
207 207
                                                                                    </parent_id>
208
                                                                                </taxonconcept>
208
                                                                                </taxonlabel>
209 209
                                                                            </parent_id>
210
                                                                        </taxonconcept>
210
                                                                        </taxonlabel>
211 211
                                                                    </parent_id>
212
                                                                </taxonconcept>
212
                                                                </taxonlabel>
213 213
                                                            </parent_id>
214
                                                        </taxonconcept>
214
                                                        </taxonlabel>
215 215
                                                    </parent_id>
216
                                                </taxonconcept>
216
                                                </taxonlabel>
217 217
                                            </parent_id>
218
                                        </taxonconcept>
218
                                        </taxonlabel>
219 219
                                    </parent_id>
220
                                </taxonconcept>
221
                            </taxonconcept_id>
220
                                </taxonlabel>
221
                            </taxonlabel_id>
222 222
                        </taxondetermination>
223 223
                        <verbatimcollectorname>$Index collector</verbatimcollectorname>
224 224
                    </taxonoccurrence>
inputs/UNCC/Specimen/VegBIEN.csv
42 42
GROUP BY herbarium, accession
43 43
HAVING count(*) > 1
44 44
-----"
45
SciName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_concept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1",
46
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_concept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
47
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_concept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
48
species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_concept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
49
infraname,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_concept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond",
50
usdaRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_concept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then/_alt/1",
51
infrarank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_concept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then/_alt/2",
52
infraname,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_concept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2",
53
authors,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_concept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/2",
54
authors,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/author,
55
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/family,
56
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus,
57
usdaRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/_if[@name=""if has explicit parent""]/else/rank/_alt/1",
58
infrarank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/_if[@name=""if has explicit parent""]/else/rank/_alt/2",
59
usdaRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/_if[@name=""if has explicit parent""]/else/verbatimrank/_alt/1",
60
infrarank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/_if[@name=""if has explicit parent""]/else/verbatimrank/_alt/2",
61
species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonepithet",
62
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonepithet",
63
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonepithet",
64
infraname,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/taxonepithet,
65
usdaRank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/rank/_alt/1,
66
infrarank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/rank/_alt/2,
67
species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/species,
68
SciName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonomicname,
69
usdaRank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/verbatimrank/_alt/1,
70
infrarank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/verbatimrank/_alt/2,
45
SciName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1",
46
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
47
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
48
species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
49
infraname,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond",
50
usdaRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then/_alt/1",
51
infrarank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then/_alt/2",
52
infraname,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2",
53
authors,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/2",
54
authors,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/author,
55
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/family,
56
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/genus,
57
usdaRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/rank/_alt/1",
58
infrarank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/rank/_alt/2",
59
usdaRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/verbatimrank/_alt/1",
60
infrarank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/verbatimrank/_alt/2",
61
species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=species]/taxonepithet",
62
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/taxonepithet",
63
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=family]/taxonepithet",
64
infraname,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/taxonepithet,
65
usdaRank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/rank/_alt/1,
66
infrarank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/rank/_alt/2,
67
species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/species,
68
SciName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonomicname,
69
usdaRank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/verbatimrank/_alt/1,
70
infrarank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/verbatimrank/_alt/2,
71 71
collector,/location/locationevent/taxonoccurrence/verbatimcollectorname/_join/1,
72 72
collector1,/location/locationevent/taxonoccurrence/verbatimcollectorname/_join/2,
73 73
collector2,/location/locationevent/taxonoccurrence/verbatimcollectorname/_join/3,
inputs/UNCC/Specimen/test.xml.ref
70 70
                        <iscultivated>$cultivated</iscultivated>
71 71
                        <sourceaccessioncode>$accession</sourceaccessioncode>
72 72
                        <taxondetermination>
73
                            <taxonconcept_id>
74
                                <taxonconcept>
75
                                    <matched_concept_id>
76
                                        <taxonconcept>
73
                            <taxonlabel_id>
74
                                <taxonlabel>
75
                                    <matched_label_id>
76
                                        <taxonlabel>
77 77
                                            <creator_id>
78 78
                                                <party>
79 79
                                                    <creator_id>0</creator_id>
......
113 113
                                                    <2>$authors</2>
114 114
                                                </_join_words>
115 115
                                            </identifyingtaxonomicname>
116
                                        </taxonconcept>
117
                                    </matched_concept_id>
116
                                        </taxonlabel>
117
                                    </matched_label_id>
118 118
                                    <author>$authors</author>
119 119
                                    <family>$family</family>
120 120
                                    <genus>$genus</genus>
121 121
                                    <parent_id>
122
                                        <taxonconcept>
122
                                        <taxonlabel>
123 123
                                            <rank>
124 124
                                                <_alt>
125 125
                                                    <1>$usdaRank</1>
......
133 133
                                                </_alt>
134 134
                                            </verbatimrank>
135 135
                                            <parent_id>
136
                                                <taxonconcept>
136
                                                <taxonlabel>
137 137
                                                    <rank>cultivar</rank>
138 138
                                                    <parent_id>
139
                                                        <taxonconcept>
139
                                                        <taxonlabel>
140 140
                                                            <rank>forma</rank>
141 141
                                                            <parent_id>
142
                                                                <taxonconcept>
142
                                                                <taxonlabel>
143 143
                                                                    <rank>variety</rank>
144 144
                                                                    <parent_id>
145
                                                                        <taxonconcept>
145
                                                                        <taxonlabel>
146 146
                                                                            <rank>subspecies</rank>
147 147
                                                                            <parent_id>
148
                                                                                <taxonconcept>
148
                                                                                <taxonlabel>
149 149
                                                                                    <rank>species</rank>
150 150
                                                                                    <taxonepithet>$species</taxonepithet>
151 151
                                                                                    <parent_id>
152
                                                                                        <taxonconcept>
152
                                                                                        <taxonlabel>
153 153
                                                                                            <rank>genus</rank>
154 154
                                                                                            <taxonepithet>$genus</taxonepithet>
155 155
                                                                                            <parent_id>
156
                                                                                                <taxonconcept>
... This diff was truncated because it exceeds the maximum size that can be displayed.

Also available in: Unified diff