Revision 5608
Added by Aaron Marcuse-Kubitza over 12 years ago
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> |
Also available in: Unified diff
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