Project

General

Profile

« Previous | Next » 

Revision 5138

Added by Aaron Marcuse-Kubitza over 12 years ago

mappings/VegCore-VegBIEN.csv: non-TNRS taxonpaths: Store the concatenated identifyingtaxonomicname in a separate taxonpath owned by the TNRS datasource, so that it will match up with (and create a link to) the corresponding submitted TNRS name's taxonpath. This in turn is linked to the TNRS-determined accepted name, thus creating a three-level hierarchy of datasource name -> concatenated name -> accepted name.

View differences:

inputs/FIA/Organism/VegBIEN.csv
14 14 
TreeTag,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/tag,
15 15 
PlotCD,"/location/locationevent/taxonoccurrence/authortaxoncode/_first/1/_first/2/_if[@name=""if is organism""]/cond/_exists",
16 16 
TreeTag,"/location/locationevent/taxonoccurrence/authortaxoncode/_first/1/_first/2/_if[@name=""if is organism""]/then",
17 
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
18 
SpecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3",
17 19 
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/genus,
18 
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2,
19 
SpecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3,
20 20 
SpecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/species,
21 21 
County,/location/locationplace/*_id/placepath/county,
22 22 
StateProvince,/location/locationplace/*_id/placepath/stateprovince,
inputs/ARIZ/Specimen/test.xml.ref
116 116 
                            </party_id>
117 117 
                            <taxonpath_id>
118 118 
                                <taxonpath>
119 
                                    <class>$Class</class>
120 
                                    <family>$Family</family>
121 
                                    <genus>$Genus</genus>
122 
                                    <identifyingtaxonomicname>
123 
                                        <_alt>
124 
                                            <1>$ScientificNameAuthor</1>
125 
                                            <2>
119 
                                    <canon_taxonpath_id>
120 
                                        <taxonpath>
121 
                                            <datasource_id><party><organizationname>TNRS</organizationname></party></datasource_id>
122 
                                            <identifyingtaxonomicname>
126 123 
                                                <_alt>
127 
                                                    <1>$ScientificName</1>
124 
                                                    <1>$ScientificNameAuthor</1>
128 125 
                                                    <2>
129 
                                                        <_join_words>
130 
                                                            <1>$Family</1>
131 
                                                            <2>$Genus</2>
132 
                                                            <3>$Species</3>
133 
                                                            <4>$Subspecies</4>
134 
                                                        </_join_words>
126 
                                                        <_alt>
127 
                                                            <1>$ScientificName</1>
128 
                                                            <2>
129 
                                                                <_join_words>
130 
                                                                    <1>$Family</1>
131 
                                                                    <2>$Genus</2>
132 
                                                                    <3>$Species</3>
133 
                                                                    <4>$Subspecies</4>
134 
                                                                </_join_words>
135 
                                                            </2>
136 
                                                        </_alt>
135 137 
                                                    </2>
136 138 
                                                </_alt>
137 
                                            </2>
138 
                                        </_alt>
139 
                                    </identifyingtaxonomicname>
139 
                                            </identifyingtaxonomicname>
140 
                                        </taxonpath>
141 
                                    </canon_taxonpath_id>
142 
                                    <class>$Class</class>
143 
                                    <family>$Family</family>
144 
                                    <genus>$Genus</genus>
140 145 
                                    <kingdom>$Kingdom</kingdom>
141 146 
                                    <order>$Order</order>
142 147 
                                    <phylum>$Phylum</phylum>
......
198 203 
        </path>
199 204 
    </_simplifyPath>
200 205 
</VegBIEN>
201 
Inserted 27 new rows into database
206 
Inserted 30 new rows into database
inputs/NCU-NCSC/Specimen/VegBIEN.csv
14 14 
Full Taxon Name,"/location/locationevent/taxonoccurrence/authortaxoncode/_first/2/_if[@name=""if is taxonpath only""]/else/_first/3",
15 15 
Cultivated?,/location/locationevent/taxonoccurrence/iscultivated/_alt/1,
16 16 
Accession Number,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/3,
17 
Full Taxon Name,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1,
17 
Full Taxon Name,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1",
18 18 
Full Taxon Name,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicname,
19 19 
Barcode,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then",
20 20 
Country,/location/locationplace/*_id/placepath/country,
inputs/SpeciesLink/Specimen/test.xml.ref
272 272 
                            </party_id>
273 273 
                            <taxonpath_id>
274 274 
                                <taxonpath>
275 
                                    <canon_taxonpath_id>
276 
                                        <taxonpath>
277 
                                            <datasource_id><party><organizationname>TNRS</organizationname></party></datasource_id>
278 
                                            <identifyingtaxonomicname>
279 
                                                <_join_words>
280 
                                                    <1>
281 
                                                        <_alt>
282 
                                                            <1>
283 
                                                                <_alt>
284 
                                                                    <0>$conceptual_darwin_2003_1_0_ScientificName</0>
285 
                                                                    <1>$dwc_dwcore_ScientificName</1>
286 
                                                                    <2>$dwc_terms_scientificName</2>
287 
                                                                </_alt>
288 
                                                            </1>
289 
                                                            <2>
290 
                                                                <_join_words>
291 
                                                                    <1>
292 
                                                                        <_alt>
293 
                                                                            <0>$conceptual_darwin_2003_1_0_Family</0>
294 
                                                                            <1>$dwc_dwcore_Family</1>
295 
                                                                            <2>$dwc_terms_family</2>
296 
                                                                        </_alt>
297 
                                                                    </1>
298 
                                                                    <2>
299 
                                                                        <_alt>
300 
                                                                            <0>$conceptual_darwin_2003_1_0_Genus</0>
301 
                                                                            <1>$dwc_dwcore_Genus</1>
302 
                                                                            <2>$dwc_terms_genus</2>
303 
                                                                        </_alt>
304 
                                                                    </2>
305 
                                                                    <3>
306 
                                                                        <_alt>
307 
                                                                            <0>$conceptual_darwin_2003_1_0_Species</0>
308 
                                                                            <1>$dwc_dwcore_SpecificEpithet</1>
309 
                                                                            <2>$dwc_terms_specificEpithet</2>
310 
                                                                        </_alt>
311 
                                                                    </3>
312 
                                                                    <4>$conceptual_darwin_2003_1_0_Subspecies</4>
313 
                                                                    <5>
314 
                                                                        <_alt>
315 
                                                                            <0>$dwc_dwcore_InfraspecificEpithet</0>
316 
                                                                            <1>$dwc_terms_infraspecificEpithet</1>
317 
                                                                        </_alt>
318 
                                                                    </5>
319 
                                                                </_join_words>
320 
                                                            </2>
321 
                                                        </_alt>
322 
                                                    </1>
323 
                                                    <2>
324 
                                                        <_alt>
325 
                                                            <1>$dwc_terms_scientificNameAuthorship</1>
326 
                                                            <2>$conceptual_darwin_2003_1_0_ScientificNameAuthor</2>
327 
                                                            <3>$dwc_dwcore_AuthorYearOfScientificName</3>
328 
                                                        </_alt>
329 
                                                    </2>
330 
                                                </_join_words>
331 
                                            </identifyingtaxonomicname>
332 
                                        </taxonpath>
333 
                                    </canon_taxonpath_id>
275 334 
                                    <author>
276 335 
                                        <_alt>
277 336 
                                            <1>$dwc_terms_scientificNameAuthorship</1>
......
300 359 
                                            <2>$dwc_terms_genus</2>
301 360 
                                        </_alt>
302 361 
                                    </genus>
303 
                                    <identifyingtaxonomicname>
304 
                                        <_join_words>
305 
                                            <1>
306 
                                                <_alt>
307 
                                                    <1>
308 
                                                        <_alt>
309 
                                                            <0>$conceptual_darwin_2003_1_0_ScientificName</0>
310 
                                                            <1>$dwc_dwcore_ScientificName</1>
311 
                                                            <2>$dwc_terms_scientificName</2>
312 
                                                        </_alt>
313 
                                                    </1>
314 
                                                    <2>
315 
                                                        <_join_words>
316 
                                                            <1>
317 
                                                                <_alt>
318 
                                                                    <0>$conceptual_darwin_2003_1_0_Family</0>
319 
                                                                    <1>$dwc_dwcore_Family</1>
320 
                                                                    <2>$dwc_terms_family</2>
321 
                                                                </_alt>
322 
                                                            </1>
323 
                                                            <2>
324 
                                                                <_alt>
325 
                                                                    <0>$conceptual_darwin_2003_1_0_Genus</0>
326 
                                                                    <1>$dwc_dwcore_Genus</1>
327 
                                                                    <2>$dwc_terms_genus</2>
328 
                                                                </_alt>
329 
                                                            </2>
330 
                                                            <3>
331 
                                                                <_alt>
332 
                                                                    <0>$conceptual_darwin_2003_1_0_Species</0>
333 
                                                                    <1>$dwc_dwcore_SpecificEpithet</1>
334 
                                                                    <2>$dwc_terms_specificEpithet</2>
335 
                                                                </_alt>
336 
                                                            </3>
337 
                                                            <4>$conceptual_darwin_2003_1_0_Subspecies</4>
338 
                                                            <5>
339 
                                                                <_alt>
340 
                                                                    <0>$dwc_dwcore_InfraspecificEpithet</0>
341 
                                                                    <1>$dwc_terms_infraspecificEpithet</1>
342 
                                                                </_alt>
343 
                                                            </5>
344 
                                                        </_join_words>
345 
                                                    </2>
346 
                                                </_alt>
347 
                                            </1>
348 
                                            <2>
349 
                                                <_alt>
350 
                                                    <1>$dwc_terms_scientificNameAuthorship</1>
351 
                                                    <2>$conceptual_darwin_2003_1_0_ScientificNameAuthor</2>
352 
                                                    <3>$dwc_dwcore_AuthorYearOfScientificName</3>
353 
                                                </_alt>
354 
                                            </2>
355 
                                        </_join_words>
356 
                                    </identifyingtaxonomicname>
357 362 
                                    <kingdom>
358 363 
                                        <_alt>
359 364 
                                            <0>$conceptual_darwin_2003_1_0_Kingdom</0>
......
506 511 
        </path>
507 512 
    </_simplifyPath>
508 513 
</VegBIEN>
509 
Inserted 29 new rows into database
514 
Inserted 32 new rows into database
inputs/SALVIAS/plotObservations/VegBIEN.csv
57 57 
tag1,"/location/locationevent/taxonoccurrence/authortaxoncode/_first/1/_first/2/_if[@name=""if is organism""]/then/_alt/2","The second tag supercedes the first. Brad: Another type of code, typically a number, used by the original data provider to indicate an individual tree. These are numbers on physical tags attached to the tree. Tag2 Is the same thing, only used if the first tag was lost. Obviously not a good system as it's possible a tree tag could be lost and changed more than once."
58 58 
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","Brad: This is growth form (tree, shrub, herb, etc.). It is an observation of a trait.; According to <http://salvias.net/Documents/salvias_data_dictionary.html#Plot+data.habit>, <https://projects.nceas.ucsb.edu/nceas/projects/bien/wiki/SALVIAS#Habit>"
59 59 
PlotObsID,"/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/2/_if[@name=""if organism in AggregateOccurrence""]/else","Brad: Neither is correct; this is just an internal ID for table plotObservations. However, it has the important property of uniquely identifying an ""observation"", which is an individual tree, in the case of an individual observation, or a records of a species with an associated count of individuals or measurement of percent cover, in the case of aggregate observations. Not sure where to store this. Main point is that it is not part of the original data, but an auto_increment added later."
60 
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
61 
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
62 
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3",
63 
infra_ep_1,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond",
64 
infra_rank_1,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then",
65 
infra_ep_1,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2",
66 
auth,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/2",Brad: This is the author of the scientificName.
60 67 
auth,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/author,Brad: This is the author of the scientificName.
61 68 
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/family,
62 69 
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/genus,
63 
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,
64 
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2,
65 
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3,
66 
infra_ep_1,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond",
67 
infra_rank_1,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then",
68 
infra_ep_1,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2,
69 
auth,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/2,Brad: This is the author of the scientificName.
70 70 
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/species,
71 71 
infra_ep_1,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/subspecies/_alt/2/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond",
72 72 
infra_rank_1,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/subspecies/_alt/2/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then",
73 73 
infra_ep_1,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/subspecies/_alt/2/_join_words/2,
74 74 
cfaff,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/taxonfit,"Brad: Not sure where this goes. Indicator of identification uncertainty. 'cf.'=similar to the species listed, 'aff.'=related to the species list, but not the same. You'll need to check with Bob and with Nick where these go in VegX and VegBank."
75 
OrigFamily,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,Brad: OMIT
76 
OrigGenus,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2,
77 
OrigSpecies,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3,Brad: OMIT
75 78 
OrigFamily,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/family,Brad: OMIT
76 79 
OrigGenus,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/genus,
77 
OrigFamily,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,Brad: OMIT
78 
OrigGenus,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2,
79 
OrigSpecies,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3,Brad: OMIT
80 80 
OrigSpecies,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/species,Brad: OMIT
81 81 
coll_firstname,/location/locationevent/taxonoccurrence/verbatimcollectorname/_join_words/1,Brad: See comment above
82 82 
coll_lastname,/location/locationevent/taxonoccurrence/verbatimcollectorname/_join_words/2,"Brad: This is the collector of a separate specimen which vouchers this tree or species. I worry that vouchers are not properly accommodated in VegX. Again, we need to check with Nick."
inputs/.TNRS/tnrs/VegBIEN.csv
2 2 
Name_submitted,"/location/locationevent/taxonoccurrence/authortaxoncode/_first/2/_if[@name=""if is taxonpath only""]/cond/_exists",
3 3 
Name_submitted,"/location/locationevent/taxonoccurrence/authortaxoncode/_first/2/_if[@name=""if is taxonpath only""]/else/_first/2",
4 4 
Name_matched,"/location/locationevent/taxonoccurrence/authortaxoncode/_first/2/_if[@name=""if is taxonpath only""]/else/_first/3",
5 
Accepted_name,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/cond/_exists",
6 
Name_submitted,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/1",
7 
Name_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1",
8 
Family_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",Contains any family in original string (uncommon)
9 
Genus_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
10 
Infraspecific_epithet_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond",
11 
Infraspecific_rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then",
12 
Name_matched_rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then",
13 
Infraspecific_epithet_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2",
14 
Name_matched_author,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/2",
5 15 
Name_matched_author,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/author,
6 16 
Accepted_name_author,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/canon_taxonpath_id/taxonpath:[canon_taxonpath_id=0]/author,
7 17 
Accepted_name_family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/canon_taxonpath_id/taxonpath:[canon_taxonpath_id=0]/family,
......
13 23 
Accepted_name,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/canon_taxonpath_id/taxonpath:[canon_taxonpath_id=0]/taxonomicname,
14 24 
Family_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/family,Contains any family in original string (uncommon)
15 25 
Genus_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/genus,
16 
Name_submitted,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/1,
17 
Name_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1,
18 
Family_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,Contains any family in original string (uncommon)
19 
Genus_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2,
20 
Infraspecific_epithet_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond",
21 
Infraspecific_rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then",
22 
Name_matched_rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then",
23 
Infraspecific_epithet_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2,
24 
Name_matched_author,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/2,
25 26 
Infraspecific_epithet_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/subspecies/_alt/2/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond",
26 27 
Infraspecific_rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/subspecies/_alt/2/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then",
27 28 
Name_matched_rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/subspecies/_alt/2/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then",
inputs/U/Specimen/VegBIEN.csv
16 16 
Detby,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/givenname/_namePart/first,
17 17 
Detby,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/middlename/_namePart/middle,
18 18 
Detby,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/surname/_namePart/last,
19 
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
20 
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
19 21 
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/family,
20 22 
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/genus,
21 
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,
22 
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2,
23 23 
Detyy,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value",
24 24 
cf,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/taxonfit,
25 25 
Collector,/location/locationevent/taxonoccurrence/verbatimcollectorname/_join/1,
inputs/ARIZ/Specimen/VegBIEN.csv
33 33 
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/givenname/_namePart/first,
34 34 
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/middlename/_namePart/middle,
35 35 
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/surname/_namePart/last,
36 
ScientificNameAuthor,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/1",Contains the binomial in addition to the authority
37 
ScientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1",
38 
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
39 
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
40 
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3",
41 
Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/4",
36 42 
Class,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/class,
37 43 
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/family,
38 44 
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/genus,
39 
ScientificNameAuthor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/1,Contains the binomial in addition to the authority
40 
ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1,
41 
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,
42 
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2,
43 
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3,
44 
Subspecies,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/4,
45 45 
Kingdom,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/kingdom,
46 46 
Order,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/order,
47 47 
Phylum,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/phylum,
inputs/GBIF/Specimen/test.xml.ref
56 56 
                            </party_id>
57 57 
                            <taxonpath_id>
58 58 
                                <taxonpath>
59 
                                    <canon_taxonpath_id>
60 
                                        <taxonpath>
61 
                                            <datasource_id><party><organizationname>TNRS</organizationname></party></datasource_id>
62 
                                            <identifyingtaxonomicname>
63 
                                                <_join_words>
64 
                                                    <1>
65 
                                                        <_alt>
66 
                                                            <1>$ScientificName</1>
67 
                                                            <2>
68 
                                                                <_join_words>
69 
                                                                    <1>$Family</1>
70 
                                                                    <2>$Genus</2>
71 
                                                                    <3>$SpecificEpithet</3>
72 
                                                                    <5>$InfraspecificEpithet</5>
73 
                                                                </_join_words>
74 
                                                            </2>
75 
                                                        </_alt>
76 
                                                    </1>
77 
                                                    <2>$AuthorOfScientificName</2>
78 
                                                </_join_words>
79 
                                            </identifyingtaxonomicname>
80 
                                        </taxonpath>
81 
                                    </canon_taxonpath_id>
59 82 
                                    <author>$AuthorOfScientificName</author>
60 83 
                                    <family>$Family</family>
61 84 
                                    <genus>$Genus</genus>
62 
                                    <identifyingtaxonomicname>
63 
                                        <_join_words>
64 
                                            <1>
65 
                                                <_alt>
66 
                                                    <1>$ScientificName</1>
67 
                                                    <2>
68 
                                                        <_join_words>
69 
                                                            <1>$Family</1>
70 
                                                            <2>$Genus</2>
71 
                                                            <3>$SpecificEpithet</3>
72 
                                                            <5>$InfraspecificEpithet</5>
73 
                                                        </_join_words>
74 
                                                    </2>
75 
                                                </_alt>
76 
                                            </1>
77 
                                            <2>$AuthorOfScientificName</2>
78 
                                        </_join_words>
79 
                                    </identifyingtaxonomicname>
80 85 
                                    <species>$SpecificEpithet</species>
81 86 
                                    <subspecies>$InfraspecificEpithet</subspecies>
82 87 
                                    <taxonomicname>$ScientificName</taxonomicname>
......
87 92 
                            <isoriginal>true</isoriginal>
88 93 
                            <taxonpath_id>
89 94 
                                <taxonpath>
95 
                                    <canon_taxonpath_id>
96 
                                        <taxonpath>
97 
                                            <datasource_id><party><organizationname>TNRS</organizationname></party></datasource_id>
98 
                                            <identifyingtaxonomicname>
99 
                                                <_alt>
100 
                                                    <1>$ScientificNameOriginal</1>
101 
                                                    <2>
102 
                                                        <_join_words>
103 
                                                            <1>$GBIFFamilyOriginal</1>
104 
                                                            <2>$GBIFGenusOriginal</2>
105 
                                                        </_join_words>
106 
                                                    </2>
107 
                                                </_alt>
108 
                                            </identifyingtaxonomicname>
109 
                                        </taxonpath>
110 
                                    </canon_taxonpath_id>
90 111 
                                    <family>$GBIFFamilyOriginal</family>
91 112 
                                    <genus>$GBIFGenusOriginal</genus>
92 
                                    <identifyingtaxonomicname>
93 
                                        <_alt>
94 
                                            <1>$ScientificNameOriginal</1>
95 
                                            <2>
96 
                                                <_join_words>
97 
                                                    <1>$GBIFFamilyOriginal</1>
98 
                                                    <2>$GBIFGenusOriginal</2>
99 
                                                </_join_words>
100 
                                            </2>
101 
                                        </_alt>
102 
                                    </identifyingtaxonomicname>
103 113 
                                    <taxonomicname>$ScientificNameOriginal</taxonomicname>
104 114 
                                </taxonpath>
105 115 
                            </taxonpath_id>
......
121 131 
        </path>
122 132 
    </_simplifyPath>
123 133 
</VegBIEN>
124 
Inserted 28 new rows into database
134 
Inserted 33 new rows into database
inputs/SpeciesLink/Specimen/VegBIEN.csv
102 102 
conceptual_darwin_2003_1_0_IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/surname/_namePart/last,
103 103 
dwc_curatorial_IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/surname/_namePart/last,
104 104 
dwc_terms_identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/surname/_namePart/last,
105 
conceptual_darwin_2003_1_0_ScientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1",
106 
dwc_dwcore_ScientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1",
107 
dwc_terms_scientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1",
108 
conceptual_darwin_2003_1_0_Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
109 
dwc_dwcore_Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
110 
dwc_terms_family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
111 
conceptual_darwin_2003_1_0_Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
112 
dwc_dwcore_Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
113 
dwc_terms_genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
114 
conceptual_darwin_2003_1_0_Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3",
115 
dwc_dwcore_SpecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3",
116 
dwc_terms_specificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3",
117 
conceptual_darwin_2003_1_0_Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/4",
118 
dwc_dwcore_InfraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond",
119 
dwc_terms_infraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond",
120 
dwc_dwcore_InfraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2",
121 
dwc_terms_infraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2",
122 
dwc_terms_scientificNameAuthorship,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/2/_alt/1",
123 
conceptual_darwin_2003_1_0_ScientificNameAuthor,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/2/_alt/2",
124 
dwc_dwcore_AuthorYearOfScientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/2/_alt/3",
105 125 
dwc_terms_scientificNameAuthorship,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/author/_alt/1,
106 126 
conceptual_darwin_2003_1_0_ScientificNameAuthor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/author/_alt/2,
107 127 
dwc_dwcore_AuthorYearOfScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/author/_alt/3,
......
114 134 
conceptual_darwin_2003_1_0_Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/genus,
115 135 
dwc_dwcore_Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/genus,
116 136 
dwc_terms_genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/genus,
117 
conceptual_darwin_2003_1_0_ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1,
118 
dwc_dwcore_ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1,
119 
dwc_terms_scientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1,
120 
conceptual_darwin_2003_1_0_Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,
121 
dwc_dwcore_Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,
122 
dwc_terms_family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,
123 
conceptual_darwin_2003_1_0_Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2,
124 
dwc_dwcore_Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2,
125 
dwc_terms_genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2,
126 
conceptual_darwin_2003_1_0_Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3,
127 
dwc_dwcore_SpecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3,
128 
dwc_terms_specificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3,
129 
conceptual_darwin_2003_1_0_Subspecies,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/4,
130 
dwc_dwcore_InfraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond",
131 
dwc_terms_infraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond",
132 
dwc_dwcore_InfraspecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2,
133 
dwc_terms_infraspecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2,
134 
dwc_terms_scientificNameAuthorship,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/2/_alt/1,
135 
conceptual_darwin_2003_1_0_ScientificNameAuthor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/2/_alt/2,
136 
dwc_dwcore_AuthorYearOfScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/2/_alt/3,
137 137 
conceptual_darwin_2003_1_0_Kingdom,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/kingdom,
138 138 
dwc_dwcore_Kingdom,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/kingdom,
139 139 
dwc_terms_kingdom,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/kingdom,
inputs/VegBank/taxonobservation_/VegBIEN.csv
9 9 
museumaccessionnumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else",
10 10 
authorplantname,"/location/locationevent/taxonoccurrence/authortaxoncode/_first/2/_if[@name=""if is taxonpath only""]/else/_first/1",
11 11 
taxonobservation_id,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/1,
12 
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
13 
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
14 
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3",
15 
Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/4",
16 
Variety,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/6/_join_words:[1=""var. ""]/2",
17 
Forma,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/7/_join_words:[1=""fm. ""]/2",
12 18 
Class,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/class,
13 19 
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/family,
14 20 
Forma,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/forma,
15 21 
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/genus,
16 
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,
17 
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2,
18 
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3,
19 
Subspecies,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/4,
20 
Variety,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/6/_join_words:[1=""var. ""]/2",
21 
Forma,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/7/_join_words:[1=""fm. ""]/2",
22 22 
Kingdom,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/kingdom,
23 23 
Order,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/order,
24 24 
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/species,
......
26 26 
Variety,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/variety,
27 27 
interpretationdate,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/1/_*/date/_dateRangeStart/value,
28 28 
taxonfit,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/taxonfit,
29 
authorplantname,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1,
29 
authorplantname,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1,
30 30 
authorplantname,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/taxonomicname,
31 31 
museumaccessionnumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then",
32 32 
Division,,** No join mapping for *Division **
inputs/MO/Specimen/test.xml.ref
88 88 
                            </party_id>
89 89 
                            <taxonpath_id>
90 90 
                                <taxonpath>
91 
                                    <canon_taxonpath_id>
92 
                                        <taxonpath>
93 
                                            <datasource_id><party><organizationname>TNRS</organizationname></party></datasource_id>
94 
                                            <identifyingtaxonomicname>
95 
                                                <_join_words>
96 
                                                    <1>
97 
                                                        <_alt>
98 
                                                            <1>$ScientificName</1>
99 
                                                            <2>
100 
                                                                <_join_words>
101 
                                                                    <1>$family</1>
102 
                                                                    <2>$genus</2>
103 
                                                                    <3>$species</3>
104 
                                                                    <4>$Subspecies</4>
105 
                                                                </_join_words>
106 
                                                            </2>
107 
                                                        </_alt>
108 
                                                    </1>
109 
                                                    <2>$ScientificNameAuthor</2>
110 
                                                </_join_words>
111 
                                            </identifyingtaxonomicname>
112 
                                        </taxonpath>
113 
                                    </canon_taxonpath_id>
91 114 
                                    <author>$ScientificNameAuthor</author>
92 115 
                                    <family>$family</family>
93 116 
                                    <genus>$genus</genus>
94 
                                    <identifyingtaxonomicname>
95 
                                        <_join_words>
96 
                                            <1>
97 
                                                <_alt>
98 
                                                    <1>$ScientificName</1>
99 
                                                    <2>
100 
                                                        <_join_words>
101 
                                                            <1>$family</1>
102 
                                                            <2>$genus</2>
103 
                                                            <3>$species</3>
104 
                                                            <4>$Subspecies</4>
105 
                                                        </_join_words>
106 
                                                    </2>
107 
                                                </_alt>
108 
                                            </1>
109 
                                            <2>$ScientificNameAuthor</2>
110 
                                        </_join_words>
111 
                                    </identifyingtaxonomicname>
112 117 
                                    <kingdom>$Kingdom</kingdom>
113 118 
                                    <species>$species</species>
114 119 
                                    <subspecies>$Subspecies</subspecies>
......
134 139 
        </path>
135 140 
    </_simplifyPath>
136 141 
</VegBIEN>
137 
Inserted 23 new rows into database
142 
Inserted 26 new rows into database
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/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
15 
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
14 16 
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/family,
15 17 
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/genus,
16 
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,
17 
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2,
18 18 
locality,/location/locationnarrative/_merge/1,
19 19 
continent,/location/locationplace/*_id/placepath/continent,
20 20 
basisOfRecord,,** No join mapping for basisOfRecord **
inputs/MT/Specimen/test.xml.ref
42 42 
                        <taxondetermination>
43 43 
                            <taxonpath_id>
44 44 
                                <taxonpath>
45 
                                    <canon_taxonpath_id>
46 
                                        <taxonpath>
47 
                                            <datasource_id><party><organizationname>TNRS</organizationname></party></datasource_id>
48 
                                            <identifyingtaxonomicname>
49 
                                                <_join_words>
50 
                                                    <1>$family</1>
51 
                                                    <2>$genus</2>
52 
                                                </_join_words>
53 
                                            </identifyingtaxonomicname>
54 
                                        </taxonpath>
55 
                                    </canon_taxonpath_id>
45 56 
                                    <family>$family</family>
46 57 
                                    <genus>$genus</genus>
47 
                                    <identifyingtaxonomicname>
48 
                                        <_join_words>
49 
                                            <1>$family</1>
50 
                                            <2>$genus</2>
51 
                                        </_join_words>
52 
                                    </identifyingtaxonomicname>
53 58 
                                </taxonpath>
54 59 
                            </taxonpath_id>
55 60 
                        </taxondetermination>
......
61 66 
        </path>
62 67 
    </_simplifyPath>
63 68 
</VegBIEN>
64 
Inserted 20 new rows into database
69 
Inserted 22 new rows into database
inputs/XAL/Specimen/VegBIEN.csv
23 23 
darwin:IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/givenname/_namePart/first,
24 24 
darwin:IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/middlename/_namePart/middle,
25 25 
darwin:IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/surname/_namePart/last,
26 
darwin:ScientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1",
27 
darwin:Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
28 
darwin:Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
29 
darwin:Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3",
30 
darwin:Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/4",
31 
darwin:ScientificNameAuthor,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/2",
26 32 
darwin:ScientificNameAuthor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/author,
27 33 
darwin:Class,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/class,
28 34 
darwin:Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/family,
29 35 
darwin:Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/genus,
30 
darwin:ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1,
31 
darwin:Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,
32 
darwin:Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2,
33 
darwin:Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3,
34 
darwin:Subspecies,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/4,
35 
darwin:ScientificNameAuthor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/2,
36 36 
darwin:Kingdom,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/kingdom,
37 37 
darwin:Order,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/order,
38 38 
darwin:Phylum,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/phylum,
inputs/TEAM/VL/VegBIEN.csv
20 20 
1ha Plot Number,"/location/locationevent/taxonoccurrence/authortaxoncode/_first/1/_first/2/_if[@name=""if is organism""]/cond/_exists",
21 21 
Tree Number,"/location/locationevent/taxonoccurrence/authortaxoncode/_first/1/_first/2/_if[@name=""if is organism""]/then",
22 22 
Id,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/3,
23 
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
24 
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
25 
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3",
23 26 
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/family,
24 27 
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/genus,
25 
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,
26 
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2,
27 
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3,
28 28 
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/species,
29 29 
Names of Collectors,/location/locationevent/taxonoccurrence/verbatimcollectorname,
30 30 
Comments,,** No join mapping for *Comments **
inputs/TEAM/VL/test.xml.ref
44 44 
                        <taxondetermination>
45 45 
                            <taxonpath_id>
46 46 
                                <taxonpath>
47 
                                    <canon_taxonpath_id>
48 
                                        <taxonpath>
49 
                                            <datasource_id><party><organizationname>TNRS</organizationname></party></datasource_id>
50 
                                            <identifyingtaxonomicname>
51 
                                                <_join_words>
52 
                                                    <1>$Family</1>
53 
                                                    <2>$Genus</2>
54 
                                                    <3>$Species</3>
55 
                                                </_join_words>
56 
                                            </identifyingtaxonomicname>
57 
                                        </taxonpath>
58 
                                    </canon_taxonpath_id>
47 59 
                                    <family>$Family</family>
48 60 
                                    <genus>$Genus</genus>
49 
                                    <identifyingtaxonomicname>
50 
                                        <_join_words>
51 
                                            <1>$Family</1>
52 
                                            <2>$Genus</2>
53 
                                            <3>$Species</3>
54 
                                        </_join_words>
55 
                                    </identifyingtaxonomicname>
56 61 
                                    <species>$Species</species>
57 62 
                                </taxonpath>
58 63 
                            </taxonpath_id>
......
64 69 
        </path>
65 70 
    </_simplifyPath>
66 71 
</VegBIEN>
67 
Inserted 23 new rows into database
72 
Inserted 26 new rows into database
inputs/TEAM/VT/VegBIEN.csv
20 20 
1ha Plot Number,"/location/locationevent/taxonoccurrence/authortaxoncode/_first/1/_first/2/_if[@name=""if is organism""]/cond/_exists",
21 21 
Tree Number,"/location/locationevent/taxonoccurrence/authortaxoncode/_first/1/_first/2/_if[@name=""if is organism""]/then",
22 22 
Id,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/3,
23 
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
24 
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
25 
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3",
23 26 
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/family,
24 27 
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/genus,
25 
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,
26 
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2,
27 
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3,
28 28 
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/species,
29 29 
Names of Collectors,/location/locationevent/taxonoccurrence/verbatimcollectorname,
30 30 
Comments,,** No join mapping for *Comments **
inputs/TEAM/VT/test.xml.ref
44 44 
                        <taxondetermination>
45 45 
                            <taxonpath_id>
46 46 
                                <taxonpath>
47 
                                    <canon_taxonpath_id>
48 
                                        <taxonpath>
49 
                                            <datasource_id><party><organizationname>TNRS</organizationname></party></datasource_id>
50 
                                            <identifyingtaxonomicname>
51 
                                                <_join_words>
52 
                                                    <1>$Family</1>
53 
                                                    <2>$Genus</2>
54 
                                                    <3>$Species</3>
55 
                                                </_join_words>
56 
                                            </identifyingtaxonomicname>
57 
                                        </taxonpath>
58 
                                    </canon_taxonpath_id>
47 59 
                                    <family>$Family</family>
48 60 
                                    <genus>$Genus</genus>
49 
                                    <identifyingtaxonomicname>
50 
                                        <_join_words>
51 
                                            <1>$Family</1>
52 
                                            <2>$Genus</2>
53 
                                            <3>$Species</3>
54 
                                        </_join_words>
55 
                                    </identifyingtaxonomicname>
56 61 
                                    <species>$Species</species>
57 62 
                                </taxonpath>
58 63 
                            </taxonpath_id>
......
64 69 
        </path>
65 70 
    </_simplifyPath>
66 71 
</VegBIEN>
67 
Inserted 20 new rows into database
72 
Inserted 23 new rows into database
inputs/NY/Specimen/VegBIEN.csv
28 28 
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/givenname/_namePart/first,
29 29 
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/middlename/_namePart/middle,
30 30 
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/surname/_namePart/last,
31 
ScientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1",
32 
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
33 
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
34 
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3",
35 
Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/4",
36 
ScientificNameAuthor,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/2",
31 37 
ScientificNameAuthor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/author,
32 38 
Class,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/class,
33 39 
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/family,
34 40 
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/genus,
35 
ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1,
36 
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,
37 
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2,
38 
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3,
39 
Subspecies,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/4,
40 
ScientificNameAuthor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/2,
41 41 
Kingdom,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/kingdom,
42 42 
Order,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/order,
43 43 
Phylum,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/phylum,
inputs/NY/Specimen/test.xml.ref
116 116 
                            </party_id>
117 117 
                            <taxonpath_id>
118 118 
                                <taxonpath>
119 
                                    <canon_taxonpath_id>
120 
                                        <taxonpath>
121 
                                            <datasource_id><party><organizationname>TNRS</organizationname></party></datasource_id>
122 
                                            <identifyingtaxonomicname>
123 
                                                <_join_words>
124 
                                                    <1>
125 
                                                        <_alt>
126 
                                                            <1>$ScientificName</1>
127 
                                                            <2>
128 
                                                                <_join_words>
129 
                                                                    <1>$Family</1>
130 
                                                                    <2>$Genus</2>
131 
                                                                    <3>$Species</3>
132 
                                                                    <4>$Subspecies</4>
133 
                                                                </_join_words>
134 
                                                            </2>
135 
                                                        </_alt>
136 
                                                    </1>
137 
                                                    <2>$ScientificNameAuthor</2>
138 
                                                </_join_words>
139 
                                            </identifyingtaxonomicname>
140 
                                        </taxonpath>
141 
                                    </canon_taxonpath_id>
119 142 
                                    <author>$ScientificNameAuthor</author>
120 143 
                                    <class>$Class</class>
121 144 
                                    <family>$Family</family>
122 145 
                                    <genus>$Genus</genus>
123 
                                    <identifyingtaxonomicname>
124 
                                        <_join_words>
125 
                                            <1>
126 
                                                <_alt>
127 
                                                    <1>$ScientificName</1>
128 
                                                    <2>
129 
                                                        <_join_words>
130 
                                                            <1>$Family</1>
131 
                                                            <2>$Genus</2>
132 
                                                            <3>$Species</3>
133 
                                                            <4>$Subspecies</4>
134 
                                                        </_join_words>
135 
                                                    </2>
136 
                                                </_alt>
137 
                                            </1>
138 
                                            <2>$ScientificNameAuthor</2>
139 
                                        </_join_words>
140 
                                    </identifyingtaxonomicname>
141 146 
                                    <kingdom>$Kingdom</kingdom>
142 147 
                                    <order>$Order</order>
143 148 
                                    <phylum>$Phylum</phylum>
......
222 227 
        </path>
223 228 
    </_simplifyPath>
224 229 
</VegBIEN>
225 
Inserted 26 new rows into database
230 
Inserted 29 new rows into database
inputs/Madidi/Organism/VegBIEN.csv
33 33 
Determined by,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/givenname/_namePart/first,
34 34 
Determined by,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/middlename/_namePart/middle,
35 35 
Determined by,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/surname/_namePart/last,
36 
Specie+autor,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/1",
37 
Species and morphotypes,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1","Contains less than ""Specie+autor"""
38 
Family (revised),"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
39 
Genera,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
40 
Specific epithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3",
41 
Autor (revised),"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/2",
36 42 
Autor (revised),/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/author,
37 43 
Family (revised),/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/family,
38 44 
Genera,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/genus,
39 
Specie+autor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/1,
40 
Species and morphotypes,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1,"Contains less than ""Specie+autor"""
41 
Family (revised),/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,
42 
Genera,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2,
43 
Specific epithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3,
44 
Autor (revised),/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/2,
45 45 
Specific epithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/species,
46 46 
Species and morphotypes,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicname,"Contains less than ""Specie+autor"""
47 47 
Specie+autor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor,
48 48 
Qualifier,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/taxonfit,
49 
Field family,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,
50 
Field name,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2,Often = Genera
49 51 
Field family,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/family,
50 52 
Field name,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/genus,Often = Genera
51 
Field family,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,
52 
Field name,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2,Often = Genera
53 53 
Index collector,/location/locationevent/taxonoccurrence/verbatimcollectorname,
54 54 
Specimen,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then",
55 55 
Basal area,,"** No join mapping for *Basal area ** Would be basalDiameter, but need formula to translate"
inputs/Madidi/Organism/test.xml.ref
70 70 
                            </party_id>
71 71 
                            <taxonpath_id>
72 72 
                                <taxonpath>
73 
                                    <canon_taxonpath_id>
74 
                                        <taxonpath>
75 
                                            <datasource_id><party><organizationname>TNRS</organizationname></party></datasource_id>
76 
                                            <identifyingtaxonomicname>
77 
                                                <_alt>
78 
                                                    <1>$Specie+autor</1>
79 
                                                    <2>
80 
                                                        <_join_words>
81 
                                                            <1>
82 
                                                                <_alt>
83 
                                                                    <1>$Species and morphotypes</1>
84 
                                                                    <2>
85 
                                                                        <_join_words>
86 
                                                                            <1>$Family (revised)</1>
87 
                                                                            <2>$Genera</2>
88 
                                                                            <3>$Specific epithet</3>
89 
                                                                        </_join_words>
90 
                                                                    </2>
91 
                                                                </_alt>
92 
                                                            </1>
93 
                                                            <2>$Autor (revised)</2>
94 
                                                        </_join_words>
95 
                                                    </2>
96 
                                                </_alt>
97 
                                            </identifyingtaxonomicname>
98 
                                        </taxonpath>
99 
                                    </canon_taxonpath_id>
73 100 
                                    <author>$Autor (revised)</author>
74 101 
                                    <family>$Family (revised)</family>
75 102 
                                    <genus>$Genera</genus>
76 
                                    <identifyingtaxonomicname>
77 
                                        <_alt>
78 
                                            <1>$Specie+autor</1>
79 
                                            <2>
80 
                                                <_join_words>
81 
                                                    <1>
82 
                                                        <_alt>
83 
                                                            <1>$Species and morphotypes</1>
84 
                                                            <2>
85 
                                                                <_join_words>
86 
                                                                    <1>$Family (revised)</1>
87 
                                                                    <2>$Genera</2>
88 
                                                                    <3>$Specific epithet</3>
89 
                                                                </_join_words>
90 
                                                            </2>
91 
                                                        </_alt>
92 
                                                    </1>
93 
                                                    <2>$Autor (revised)</2>
94 
                                                </_join_words>
95 
                                            </2>
96 
                                        </_alt>
97 
                                    </identifyingtaxonomicname>
98 103 
                                    <species>$Specific epithet</species>
99 104 
                                    <taxonomicname>$Species and morphotypes</taxonomicname>
100 105 
                                    <taxonomicnamewithauthor>$Specie+autor</taxonomicnamewithauthor>
......
106 111 
                            <isoriginal>true</isoriginal>
107 112 
                            <taxonpath_id>
108 113 
                                <taxonpath>
114 
                                    <canon_taxonpath_id>
115 
                                        <taxonpath>
116 
                                            <datasource_id><party><organizationname>TNRS</organizationname></party></datasource_id>
117 
                                            <identifyingtaxonomicname>
118 
                                                <_join_words>
119 
                                                    <1>$Field family</1>
120 
                                                    <2>$Field name</2>
121 
                                                </_join_words>
122 
                                            </identifyingtaxonomicname>
123 
                                        </taxonpath>
124 
                                    </canon_taxonpath_id>
109 125 
                                    <family>$Field family</family>
110 126 
                                    <genus>$Field name</genus>
111 
                                    <identifyingtaxonomicname>
112 
                                        <_join_words>
113 
                                            <1>$Field family</1>
114 
                                            <2>$Field name</2>
115 
                                        </_join_words>
116 
                                    </identifyingtaxonomicname>
117 127 
                                </taxonpath>
118 128 
                            </taxonpath_id>
119 129 
                        </taxondetermination>
......
124 134 
        </path>
125 135 
    </_simplifyPath>
126 136 
</VegBIEN>
127 
Inserted 27 new rows into database
137 
Inserted 32 new rows into database
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/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1",
46 
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
47 
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
48 
species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3",
49 
infraname,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/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/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/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/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/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/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2",
53 
authors,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/2",
45 54 
authors,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/author,
46 55 
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/family,
47 56 
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/genus,
48 
SciName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1,
49 
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,
50 
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2,
51 
species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3,
52 
infraname,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond",
53 
usdaRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then/_alt/1",
54 
infrarank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then/_alt/2",
55 
infraname,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2,
56 
authors,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/2,
57 57 
species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/species,
58 58 
infraname,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/subspecies/_alt/2/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond",
59 59 
usdaRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/subspecies/_alt/2/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then/_alt/1",
inputs/VegBank/taxonobservation_/test.xml.ref
18 18 
                        <taxondetermination>
19 19 
                            <taxonpath_id>
20 20 
                                <taxonpath>
21 
                                    <canon_taxonpath_id>
22 
                                        <taxonpath>
23 
                                            <datasource_id><party><organizationname>TNRS</organizationname></party></datasource_id>
24 
                                            <identifyingtaxonomicname>
25 
                                                <_join_words>
26 
                                                    <1>$Family</1>
27 
                                                    <2>$Genus</2>
28 
                                                    <3>$Species</3>
29 
                                                    <4>$Subspecies</4>
30 
                                                    <6>
31 
                                                        <_join_words>
32 
                                                            <1>var. </1>
33 
                                                            <2>$Variety</2>
34 
                                                        </_join_words>
35 
                                                    </6>
36 
                                                    <7>
37 
                                                        <_join_words>
38 
                                                            <1>fm. </1>
39 
                                                            <2>$Forma</2>
40 
                                                        </_join_words>
41 
                                                    </7>
42 
                                                </_join_words>
43 
                                            </identifyingtaxonomicname>
44 
                                        </taxonpath>
45 
                                    </canon_taxonpath_id>
21 46 
                                    <class>$Class</class>
22 47 
                                    <family>$Family</family>
23 48 
                                    <forma>$Forma</forma>
24 49 
                                    <genus>$Genus</genus>
25 
                                    <identifyingtaxonomicname>
26 
                                        <_join_words>
27 
                                            <1>$Family</1>
28 
                                            <2>$Genus</2>
29 
                                            <3>$Species</3>
30 
                                            <4>$Subspecies</4>
31 
                                            <6>
32 
                                                <_join_words>
33 
                                                    <1>var. </1>
34 
                                                    <2>$Variety</2>
35 
                                                </_join_words>
36 
                                            </6>
37 
                                            <7>
38 
                                                <_join_words>
39 
                                                    <1>fm. </1>
40 
                                                    <2>$Forma</2>
41 
                                                </_join_words>
42 
                                            </7>
43 
                                        </_join_words>
44 
                                    </identifyingtaxonomicname>
45 50 
                                    <kingdom>$Kingdom</kingdom>
46 51 
                                    <order>$Order</order>
47 52 
                                    <species>$Species</species>
......
56 61 
                            <isoriginal>true</isoriginal>
57 62 
                            <taxonpath_id>
58 63 
                                <taxonpath>
59 
                                    <identifyingtaxonomicname>$authorplantname</identifyingtaxonomicname>
64 
                                    <canon_taxonpath_id>
65 
                                        <taxonpath>
66 
                                            <datasource_id><party><organizationname>TNRS</organizationname></party></datasource_id>
67 
                                            <identifyingtaxonomicname>$authorplantname</identifyingtaxonomicname>
68 
                                        </taxonpath>
69 
                                    </canon_taxonpath_id>
60 70 
                                    <taxonomicname>$authorplantname</taxonomicname>
61 71 
                                </taxonpath>
62 72 
                            </taxonpath_id>
......
67 77 
        </path>
68 78 
    </_simplifyPath>
69 79 
</VegBIEN>
70 
Inserted 18 new rows into database
80 
Inserted 23 new rows into database
mappings/VegCore-VegBIEN.csv
129 129 
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/givenname/_namePart/first,
130 130 
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/middlename/_namePart/middle,
131 131 
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/surname/_namePart/last,
132 
acceptedScientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/cond/_exists",
133 
acceptedScientificNameWithAuthorship,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/cond/_exists",
134 
scientificNameWithAuthorship,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/1",
135 
scientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1",
136 
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
137 
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
138 
specificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3",
139 
subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/4",
140 
infraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond",
141 
taxonRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then",
142 
infraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2",
143 
variety,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/6/_join_words:[1=""var. ""]/2",
144 
forma,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/7/_join_words:[1=""fm. ""]/2",
145 
cultivar,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/8/_join_words:[1=""cult. ""]/2",
146 
scientificNameAuthorship,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/2",
132 147 
scientificNameAuthorship,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/author,
133 148 
acceptedScientificNameAuthorship,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/canon_taxonpath_id/taxonpath:[canon_taxonpath_id=0]/author,
134 149 
acceptedClass,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/canon_taxonpath_id/taxonpath:[canon_taxonpath_id=0]/class,
......
164 179 
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/family,
165 180 
forma,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/forma,
166 181 
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/genus,
167 
scientificNameWithAuthorship,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/1,
168 
scientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1,
169 
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,
170 
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2,
171 
specificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3,
172 
subspecies,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/4,
173 
infraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond",
174 
taxonRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then",
175 
infraspecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2,
176 
variety,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/6/_join_words:[1=""var. ""]/2",
177 
forma,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/7/_join_words:[1=""fm. ""]/2",
178 
cultivar,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/8/_join_words:[1=""cult. ""]/2",
179 
scientificNameAuthorship,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/2,
180 182 
kingdom,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/kingdom,
181 183 
order,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/order,
182 184 
phylum,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/phylum,
......
195 197 
taxonRemarks,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/notes,
196 198 
identificationQualifier,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/taxonfit,
197 199 
originalScientificNameAuthorship,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/author,
200 
originalScientificNameWithAuthorship,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]/identifyingtaxonomicname/_alt/1,
201 
originalScientificName,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1,
202 
originalFamily,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,
203 
originalGenus,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2,
204 
originalSpecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3,
205 
originalSubspecies,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/4,
206 
originalInfraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond",
207 
originalTaxonRank,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then",
208 
originalInfraspecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2,
209 
originalVariety,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/6/_join_words:[1=""var. ""]/2",
210 
originalForma,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/7/_join_words:[1=""fm. ""]/2",
211 
originalCultivar,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/8/_join_words:[1=""cult. ""]/2",
212 
originalScientificNameAuthorship,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/2,
198 213 
originalClass,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/class,
199 214 
originalCultivar,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/cultivar,
200 215 
originalFamily,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/family,
201 216 
originalForma,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/forma,
202 217 
originalGenus,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/genus,
203 
originalScientificNameWithAuthorship,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/identifyingtaxonomicname/_alt/1,
204 
originalScientificName,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1,
205 
originalFamily,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,
206 
originalGenus,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2,
207 
originalSpecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3,
208 
originalSubspecies,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/4,
209 
originalInfraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond",
210 
originalTaxonRank,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then",
211 
originalInfraspecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2,
212 
originalVariety,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/6/_join_words:[1=""var. ""]/2",
213 
originalForma,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/7/_join_words:[1=""fm. ""]/2",
214 
originalCultivar,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/8/_join_words:[1=""cult. ""]/2",
215 
originalScientificNameAuthorship,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/2,
216 218 
originalKingdom,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/kingdom,
217 219 
originalOrder,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/order,
218 220 
originalPhylum,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/phylum,
inputs/QMOR/Specimen/test.xml.ref
100 100 
                            </party_id>
101 101 
                            <taxonpath_id>
102 102 
                                <taxonpath>
103 
                                    <canon_taxonpath_id>
104 
                                        <taxonpath>
105 
                                            <datasource_id><party><organizationname>TNRS</organizationname></party></datasource_id>
106 
                                            <identifyingtaxonomicname>
107 
                                                <_join_words>
108 
                                                    <1>
109 
                                                        <_alt>
110 
                                                            <1>$scientificName</1>
111 
                                                            <2>
112 
                                                                <_join_words>
113 
                                                                    <1>$family</1>
114 
                                                                    <2>$genus</2>
115 
                                                                    <3>$specificEpithet</3>
116 
                                                                    <5>
117 
                                                                        <_join_words>
118 
                                                                            <1>
119 
                                                                                <_if name="if has infraspecificEpithet">
120 
                                                                                    <cond>$infraspecificEpithet</cond>
121 
                                                                                    <then>$taxonRank</then>
122 
                                                                                </_if>
123 
                                                                            </1>
124 
                                                                            <2>$infraspecificEpithet</2>
125 
                                                                        </_join_words>
126 
                                                                    </5>
127 
                                                                </_join_words>
128 
                                                            </2>
129 
                                                        </_alt>
130 
                                                    </1>
131 
                                                    <2>$scientificNameAuthorship</2>
132 
                                                </_join_words>
133 
                                            </identifyingtaxonomicname>
134 
                                        </taxonpath>
135 
                                    </canon_taxonpath_id>
103 136 
                                    <author>$scientificNameAuthorship</author>
104 137 
                                    <class>$class</class>
105 138 
                                    <family>$family</family>
106 139 
                                    <genus>$genus</genus>
107 
                                    <identifyingtaxonomicname>
108 
                                        <_join_words>
109 
                                            <1>
110 
                                                <_alt>
111 
                                                    <1>$scientificName</1>
112 
                                                    <2>
113 
                                                        <_join_words>
114 
                                                            <1>$family</1>
115 
                                                            <2>$genus</2>
116 
                                                            <3>$specificEpithet</3>
117 
                                                            <5>
118 
                                                                <_join_words>
119 
                                                                    <1>
120 
                                                                        <_if name="if has infraspecificEpithet">
121 
                                                                            <cond>$infraspecificEpithet</cond>
122 
                                                                            <then>$taxonRank</then>
123 
                                                                        </_if>
124 
                                                                    </1>
125 
                                                                    <2>$infraspecificEpithet</2>
126 
                                                                </_join_words>
127 
                                                            </5>
128 
                                                        </_join_words>
129 
                                                    </2>
130 
                                                </_alt>
131 
                                            </1>
132 
                                            <2>$scientificNameAuthorship</2>
133 
                                        </_join_words>
134 
                                    </identifyingtaxonomicname>
135 140 
                                    <kingdom>$kingdom</kingdom>
136 141 
                                    <order>$order</order>
137 142 
                                    <phylum>$phylum</phylum>
......
182 187 
        </path>
183 188 
    </_simplifyPath>
184 189 
</VegBIEN>
185 
Inserted 26 new rows into database
190 
Inserted 28 new rows into database
inputs/UNCC/Specimen/test.xml.ref
73 73 
                        <taxondetermination>
74 74 
                            <taxonpath_id>
75 75 
                                <taxonpath>
76 
                                    <canon_taxonpath_id>
77 
                                        <taxonpath>
78 
                                            <datasource_id><party><organizationname>TNRS</organizationname></party></datasource_id>
79 
                                            <identifyingtaxonomicname>
80 
                                                <_join_words>
81 
                                                    <1>
82 
                                                        <_alt>
83 
                                                            <1>$SciName</1>
84 
                                                            <2>
85 
                                                                <_join_words>
86 
                                                                    <1>$family</1>
87 
                                                                    <2>$genus</2>
88 
                                                                    <3>$species</3>
89 
                                                                    <5>
90 
                                                                        <_join_words>
91 
                                                                            <1>
92 
                                                                                <_if name="if has infraspecificEpithet">
93 
                                                                                    <cond>$infraname</cond>
94 
                                                                                    <then>
95 
                                                                                        <_alt>
96 
                                                                                            <1>$usdaRank</1>
97 
                                                                                            <2>$infrarank</2>
98 
                                                                                        </_alt>
99 
                                                                                    </then>
100 
                                                                                </_if>
101 
                                                                            </1>
102 
                                                                            <2>$infraname</2>
103 
                                                                        </_join_words>
104 
                                                                    </5>
105 
                                                                </_join_words>
106 
                                                            </2>
107 
                                                        </_alt>
108 
                                                    </1>
109 
                                                    <2>$authors</2>
110 
                                                </_join_words>
111 
                                            </identifyingtaxonomicname>
112 
                                        </taxonpath>
113 
                                    </canon_taxonpath_id>
76 114 
                                    <author>$authors</author>
77 115 
                                    <family>$family</family>
78 116 
                                    <genus>$genus</genus>
79 
                                    <identifyingtaxonomicname>
80 
                                        <_join_words>
81 
                                            <1>
82 
                                                <_alt>
83 
                                                    <1>$SciName</1>
84 
                                                    <2>
85 
                                                        <_join_words>
86 
                                                            <1>$family</1>
87 
                                                            <2>$genus</2>
88 
                                                            <3>$species</3>
89 
                                                            <5>
90 
                                                                <_join_words>
91 
                                                                    <1>
92 
                                                                        <_if name="if has infraspecificEpithet">
93 
                                                                            <cond>$infraname</cond>
94 
                                                                            <then>
95 
                                                                                <_alt>
96 
                                                                                    <1>$usdaRank</1>
97 
                                                                                    <2>$infrarank</2>
98 
                                                                                </_alt>
99 
                                                                            </then>
100 
                                                                        </_if>
101 
                                                                    </1>
102 
                                                                    <2>$infraname</2>
103 
                                                                </_join_words>
104 
                                                            </5>
105 
                                                        </_join_words>
106 
                                                    </2>
107 
                                                </_alt>
108 
                                            </1>
109 
                                            <2>$authors</2>
110 
                                        </_join_words>
111 
                                    </identifyingtaxonomicname>
112 117 
                                    <species>$species</species>
113 118 
                                    <subspecies>
114 119 
                                        <_join_words>
......
164 169 
        </path>
165 170 
    </_simplifyPath>
166 171 
</VegBIEN>
167 
Inserted 20 new rows into database
172 
Inserted 22 new rows into database
inputs/ACAD/Specimen/VegBIEN.csv
23 23 
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/givenname/_namePart/first,
24 24 
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/middlename/_namePart/middle,
25 25 
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/surname/_namePart/last,
26 
scientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/1",
27 
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
28 
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
29 
specificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3",
30 
infraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond",
31 
taxonRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then",
32 
infraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2",
33 
scientificNameAuthorship,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/2",
26 34 
scientificNameAuthorship,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/author,
27 35 
class,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/class,
28 36 
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/family,
29 37 
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/genus,
30 
scientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/1,
31 
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,
32 
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2,
33 
specificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3,
34 
infraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond",
35 
taxonRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then",
36 
infraspecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2,
37 
scientificNameAuthorship,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/2,
38 38 
kingdom,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/kingdom,
39 39 
order,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/order,
40 40 
phylum,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/phylum,
inputs/ACAD/Specimen/test.xml.ref
76 76 
                            </party_id>
77 77 
                            <taxonpath_id>
78 78 
                                <taxonpath>
79 
                                    <canon_taxonpath_id>
80 
                                        <taxonpath>
81 
                                            <datasource_id><party><organizationname>TNRS</organizationname></party></datasource_id>
82 
                                            <identifyingtaxonomicname>
83 
                                                <_alt>
84 
                                                    <1>$scientificName</1>
85 
                                                    <2>
86 
                                                        <_join_words>
87 
                                                            <1>
88 
                                                                <_join_words>
89 
                                                                    <1>$family</1>
90 
                                                                    <2>$genus</2>
91 
                                                                    <3>$specificEpithet</3>
92 
                                                                    <5>
93 
                                                                        <_join_words>
94 
                                                                            <1>
95 
                                                                                <_if name="if has infraspecificEpithet">
96 
                                                                                    <cond>$infraspecificEpithet</cond>
97 
                                                                                    <then>$taxonRank</then>
98 
                                                                                </_if>
99 
                                                                            </1>
100 
                                                                            <2>$infraspecificEpithet</2>
101 
                                                                        </_join_words>
102 
                                                                    </5>
103 
                                                                </_join_words>
104 
                                                            </1>
105 
                                                            <2>$scientificNameAuthorship</2>
106 
                                                        </_join_words>
107 
                                                    </2>
108 
                                                </_alt>
109 
                                            </identifyingtaxonomicname>
110 
                                        </taxonpath>
111 
                                    </canon_taxonpath_id>
79 112 
                                    <author>$scientificNameAuthorship</author>
80 113 
                                    <class>$class</class>
81 114 
                                    <family>$family</family>
82 115 
                                    <genus>$genus</genus>
83 
                                    <identifyingtaxonomicname>
84 
                                        <_alt>
85 
                                            <1>$scientificName</1>
86 
                                            <2>
87 
                                                <_join_words>
88 
                                                    <1>
89 
                                                        <_join_words>
90 
                                                            <1>$family</1>
91 
                                                            <2>$genus</2>
92 
                                                            <3>$specificEpithet</3>
93 
                                                            <5>
94 
                                                                <_join_words>
95 
                                                                    <1>
96 
                                                                        <_if name="if has infraspecificEpithet">
97 
                                                                            <cond>$infraspecificEpithet</cond>
98 
                                                                            <then>$taxonRank</then>
99 
                                                                        </_if>
100 
                                                                    </1>
101 
                                                                    <2>$infraspecificEpithet</2>
102 
                                                                </_join_words>
103 
                                                            </5>
104 
                                                        </_join_words>
105 
                                                    </1>
106 
                                                    <2>$scientificNameAuthorship</2>
107 
                                                </_join_words>
108 
                                            </2>
109 
                                        </_alt>
110 
                                    </identifyingtaxonomicname>
111 116 
                                    <kingdom>$kingdom</kingdom>
112 117 
                                    <order>$order</order>
113 118 
                                    <phylum>$phylum</phylum>
......
157 162 
        </path>
158 163 
    </_simplifyPath>
159 164 
</VegBIEN>
160 
Inserted 24 new rows into database
165 
Inserted 27 new rows into database
inputs/SALVIAS-CSV/Organism/VegBIEN.csv
64 64 
tag1,"/location/locationevent/taxonoccurrence/authortaxoncode/_first/1/_first/2/_if[@name=""if is organism""]/then/_alt/2/_alt/2","The second tag supercedes the first. The stem tag supercedes the tree tag. Brad: Another type of code, typically a number, used by the original data provider to indicate an individual tree. These are numbers on physical tags attached to the tree. Tag2 Is the same thing, only used if the first tag was lost. Obviously not a good system as it's possible a tree tag could be lost and changed more than once."
... This diff was truncated because it exceeds the maximum size that can be displayed.

Also available in: Unified diff