Project

General

Profile

« Previous | Next » 

Revision 5225

schemas/vegbien.sql: Renamed taxonpath -> taxonconcept as part of taxonomic schema refactoring at <https://projects.nceas.ucsb.edu/nceas/projects/bien/wiki/2012-10-03_conference_call#Taxonomic-schema-refactoring>

View differences:

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
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,species,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=genus]/taxonname",
15
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,species,genus,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=family]/taxonname",
16
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",
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
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/family,
19
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/genus,
14
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,species,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=genus]/taxonname",
15
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,species,genus,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=family]/taxonname",
16
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
17
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
18
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/family,
19
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus,
20 20
locality,/location/locationnarrative/_merge/1,
21 21
continent,/location/locationplace/*_id/placepath/continent,
22 22
basisOfRecord,,** No join mapping for basisOfRecord ** 
inputs/MT/Specimen/test.xml.ref
40 40
                        </isnative>
41 41
                        <sourceaccessioncode>$id</sourceaccessioncode>
42 42
                        <taxondetermination>
43
                            <taxonpath_id>
44
                                <taxonpath>
45
                                    <canon_taxonpath_id>
46
                                        <taxonpath>
43
                            <taxonconcept_id>
44
                                <taxonconcept>
45
                                    <canon_taxonconcept_id>
46
                                        <taxonconcept>
47 47
                                            <datasource_id><party><organizationname>TNRS</organizationname></party></datasource_id>
48 48
                                            <identifyingtaxonomicname>
49 49
                                                <_join_words>
......
51 51
                                                    <2>$genus</2>
52 52
                                                </_join_words>
53 53
                                            </identifyingtaxonomicname>
54
                                        </taxonpath>
55
                                    </canon_taxonpath_id>
54
                                        </taxonconcept>
55
                                    </canon_taxonconcept_id>
56 56
                                    <family>$family</family>
57 57
                                    <genus>$genus</genus>
58
                                </taxonpath>
59
                            </taxonpath_id>
58
                                </taxonconcept>
59
                            </taxonconcept_id>
60 60
                        </taxondetermination>
61 61
                    </taxonoccurrence>
62 62
                </locationevent>
inputs/test_taxonomic_names/Taxon/VegBIEN.csv
1 1
test_taxonomic_names,VegBIEN:/_simplifyPath:[next=parent_id]/path,Comments
2 2
scientificName,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/3",
3
scientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/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",
4
scientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicname,
3
scientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1",
4
scientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonomicname,
5 5
scientificNameID,,** No join mapping for scientificNameID ** 
inputs/test_taxonomic_names/Taxon/test.xml.ref
7 7
                <locationevent>
8 8
                    <taxonoccurrence>
9 9
                        <taxondetermination>
10
                            <taxonpath_id>
11
                                <taxonpath>
12
                                    <canon_taxonpath_id>
13
                                        <taxonpath>
10
                            <taxonconcept_id>
11
                                <taxonconcept>
12
                                    <canon_taxonconcept_id>
13
                                        <taxonconcept>
14 14
                                            <datasource_id><party><organizationname>TNRS</organizationname></party></datasource_id>
15 15
                                            <identifyingtaxonomicname>$scientificName</identifyingtaxonomicname>
16
                                        </taxonpath>
17
                                    </canon_taxonpath_id>
16
                                        </taxonconcept>
17
                                    </canon_taxonconcept_id>
18 18
                                    <taxonomicname>$scientificName</taxonomicname>
19
                                </taxonpath>
20
                            </taxonpath_id>
19
                                </taxonconcept>
20
                            </taxonconcept_id>
21 21
                        </taxondetermination>
22 22
                    </taxonoccurrence>
23 23
                </locationevent>
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:Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=subspecies]/taxonname",
27
darwin:ScientificNameAuthor,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=species]/author_id/party/surname",
28
darwin:Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=species]/taxonname",
29
darwin:Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,species,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=genus]/taxonname",
30
darwin:Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,species,genus,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=family]/taxonname",
31
darwin:Order,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,species,genus,family,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=order]/taxonname",
32
darwin:Class,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,species,genus,family,order,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=class]/taxonname",
33
darwin:Phylum,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,species,genus,family,order,class,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=phylum]/taxonname",
34
darwin:Kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,species,genus,family,order,class,phylum,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=kingdom]/taxonname",
35
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",
36
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",
37
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",
38
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/_join_words/1",
39
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",
40
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",
41
darwin:ScientificNameAuthor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/author,
42
darwin:Class,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/class,
43
darwin:Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/family,
44
darwin:Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/genus,
45
darwin:Kingdom,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/kingdom,
46
darwin:Order,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/order,
47
darwin:Phylum,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/phylum,
48
darwin:Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/species,
49
darwin:Subspecies,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/subspecies/_alt/1,
50
darwin:ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicname,
26
darwin:Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=subspecies]/taxonname",
27
darwin:ScientificNameAuthor,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=species]/author_id/party/surname",
28
darwin:Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=species]/taxonname",
29
darwin:Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,species,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=genus]/taxonname",
30
darwin:Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,species,genus,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=family]/taxonname",
31
darwin:Order,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,species,genus,family,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=order]/taxonname",
32
darwin:Class,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,species,genus,family,order,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=class]/taxonname",
33
darwin:Phylum,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,species,genus,family,order,class,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=phylum]/taxonname",
34
darwin:Kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,species,genus,family,order,class,phylum,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=kingdom]/taxonname",
35
darwin:ScientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1",
36
darwin:Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
37
darwin:Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
38
darwin:Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
39
darwin:Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/4",
40
darwin:ScientificNameAuthor,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/2",
41
darwin:ScientificNameAuthor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/author,
42
darwin:Class,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/class,
43
darwin:Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/family,
44
darwin:Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus,
45
darwin:Kingdom,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/kingdom,
46
darwin:Order,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/order,
47
darwin:Phylum,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/phylum,
48
darwin:Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/species,
49
darwin:Subspecies,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/subspecies/_alt/1,
50
darwin:ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonomicname,
51 51
darwin:DayIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value",
52 52
darwin:MonthIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value",
53 53
darwin:YearIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value",
inputs/TEAM/VL/VegBIEN.csv
20 20
1ha Plot Number,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",
21 21
Tree Number,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/1/_first/2",
22 22
Id,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/3,
23
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=species]/taxonname",
24
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,species,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=genus]/taxonname",
25
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,species,genus,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=family]/taxonname",
26
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",
27
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",
28
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/_join_words/1",
29
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/family,
30
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/genus,
31
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/species,
23
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=species]/taxonname",
24
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,species,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=genus]/taxonname",
25
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,species,genus,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=family]/taxonname",
26
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
27
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
28
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
29
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/family,
30
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus,
31
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/species,
32 32
Names of Collectors,/location/locationevent/taxonoccurrence/verbatimcollectorname,
33 33
Comments,,** No join mapping for *Comments ** 
34 34
Condition Codes,,** No join mapping for *Condition Codes ** 
inputs/U/Specimen/test.xml.ref
72 72
                                    <surname><_namePart><last>$Detby</last></_namePart></surname>
73 73
                                </party>
74 74
                            </party_id>
75
                            <taxonpath_id>
76
                                <taxonpath>
77
                                    <canon_taxonpath_id>
78
                                        <taxonpath>
75
                            <taxonconcept_id>
76
                                <taxonconcept>
77
                                    <canon_taxonconcept_id>
78
                                        <taxonconcept>
79 79
                                            <datasource_id><party><organizationname>TNRS</organizationname></party></datasource_id>
80 80
                                            <identifyingtaxonomicname>
81 81
                                                <_join_words>
......
83 83
                                                    <2>$Genus</2>
84 84
                                                </_join_words>
85 85
                                            </identifyingtaxonomicname>
86
                                        </taxonpath>
87
                                    </canon_taxonpath_id>
86
                                        </taxonconcept>
87
                                    </canon_taxonconcept_id>
88 88
                                    <family>$Family</family>
89 89
                                    <genus>$Genus</genus>
90
                                </taxonpath>
91
                            </taxonpath_id>
90
                                </taxonconcept>
91
                            </taxonconcept_id>
92 92
                            <determinationdate>
93 93
                                <_date>
94 94
                                    <year>
inputs/GBIF/Specimen/VegBIEN.csv
16 16
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/givenname/_namePart/first,
17 17
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/middlename/_namePart/middle,
18 18
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/surname/_namePart/last,
19
InfraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=infraspecies]/taxonname",
20
InfraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=infraspecies]/verbatimrank/_if[@name=""if has infraspecificEpithet""]/cond",
21
AuthorOfScientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=species]/author_id/party/surname",
22
SpecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=species]/taxonname",
23
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,species,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=genus]/taxonname",
24
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,species,genus,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=family]/taxonname",
25
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",
26
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",
27
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",
28
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/_join_words/1",
29
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",
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/2",
31
AuthorOfScientificName,"/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",
32
AuthorOfScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/author,
33
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/family,
34
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/genus,
35
SpecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/species,
36
InfraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/subspecies/_alt/2/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond",
37
InfraspecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/subspecies/_alt/2/_join_words/2,
38
ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicname,
39
ScientificNameOriginal,/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,
40
GBIFFamilyOriginal,/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,
41
GBIFGenusOriginal,/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,
42
GBIFFamilyOriginal,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/family,
43
GBIFGenusOriginal,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/genus,
44
ScientificNameOriginal,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/taxonomicname,
19
InfraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=infraspecies]/taxonname",
20
InfraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=infraspecies]/verbatimrank/_if[@name=""if has infraspecificEpithet""]/cond",
21
AuthorOfScientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=species]/author_id/party/surname",
22
SpecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=species]/taxonname",
23
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,species,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=genus]/taxonname",
24
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,species,genus,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=family]/taxonname",
25
ScientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1",
26
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
27
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
28
SpecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
29
InfraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[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",
30
InfraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2",
31
AuthorOfScientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/2",
32
AuthorOfScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/author,
33
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/family,
34
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus,
35
SpecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/species,
36
InfraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/subspecies/_alt/2/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond",
37
InfraspecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/subspecies/_alt/2/_join_words/2,
38
ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonomicname,
39
ScientificNameOriginal,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/canon_taxonconcept_id/taxonconcept:[datasource_id/party/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1,
40
GBIFFamilyOriginal,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/canon_taxonconcept_id/taxonconcept:[datasource_id/party/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,
41
GBIFGenusOriginal,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/canon_taxonconcept_id/taxonconcept:[datasource_id/party/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2,
42
GBIFFamilyOriginal,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/family,
43
GBIFGenusOriginal,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/genus,
44
ScientificNameOriginal,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/taxonomicname,
45 45
Collector,/location/locationevent/taxonoccurrence/verbatimcollectorname,
46 46
CatalogNO,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then",
47 47
Locality,/location/locationnarrative/_merge/1,
inputs/NCU-NCSC/Specimen/test.xml.ref
64 64
                        <iscultivated>$Cultivated?</iscultivated>
65 65
                        <sourceaccessioncode>$Accession Number</sourceaccessioncode>
66 66
                        <taxondetermination>
67
                            <taxonpath_id>
68
                                <taxonpath>
69
                                    <canon_taxonpath_id>
70
                                        <taxonpath>
67
                            <taxonconcept_id>
68
                                <taxonconcept>
69
                                    <canon_taxonconcept_id>
70
                                        <taxonconcept>
71 71
                                            <datasource_id><party><organizationname>TNRS</organizationname></party></datasource_id>
72 72
                                            <identifyingtaxonomicname>$Full Taxon Name</identifyingtaxonomicname>
73
                                        </taxonpath>
74
                                    </canon_taxonpath_id>
73
                                        </taxonconcept>
74
                                    </canon_taxonconcept_id>
75 75
                                    <taxonomicname>$Full Taxon Name</taxonomicname>
76
                                </taxonpath>
77
                            </taxonpath_id>
76
                                </taxonconcept>
77
                            </taxonconcept_id>
78 78
                        </taxondetermination>
79 79
                    </taxonoccurrence>
80 80
                </locationevent>
inputs/CTFS/TaxonOccurrence/VegBIEN.csv
9 9
CensusID,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",
10 10
PlotID,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",
11 11
SpeciesInvID,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/1,
12
SubSpeciesName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=subspecies]/taxonname",
13
SpeciesName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=species]/taxonname",
14
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,species,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=genus]/taxonname",
15
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,species,genus,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=family]/taxonname",
16
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",
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
SpeciesName,"/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/_join_words/1",
19
SubSpeciesName,"/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",
20
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/family,
21
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/genus,
22
SpeciesName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/species,
23
SubSpeciesName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/subspecies/_alt/1,
12
SubSpeciesName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=subspecies]/taxonname",
13
SpeciesName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=species]/taxonname",
14
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,species,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=genus]/taxonname",
15
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,species,genus,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=family]/taxonname",
16
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
17
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
18
SpeciesName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
19
SubSpeciesName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/4",
20
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/family,
21
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus,
22
SpeciesName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/species,
23
SubSpeciesName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/subspecies/_alt/1,
24 24
Description,,** No join mapping for *Description ** 
25 25
FamilyID,,** No join mapping for *FamilyID ** 
26 26
FieldFamily,,** No join mapping for *FieldFamily ** 
inputs/FIA/Organism/VegBIEN.csv
14 14
TreeTag,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/tag,
15 15
PlotCD,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",
16 16
TreeTag,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/1/_first/2",
17
SpecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=species]/taxonname",
18
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,species,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=genus]/taxonname",
19
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",
20
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/_join_words/1",
21
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/genus,
22
SpecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/species,
17
SpecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=species]/taxonname",
18
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,species,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=genus]/taxonname",
19
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
20
SpecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
21
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus,
22
SpecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/species,
23 23
County,/location/locationplace/*_id/placepath/county,
24 24
StateProvince,/location/locationplace/*_id/placepath/stateprovince,
25 25
HOM,,** No join mapping for *HOM ** 
inputs/SALVIAS/plotObservations/VegBIEN.csv
57 57
tag1,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/1/_first/2/_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
infra_ep_1,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=infraspecies]/taxonname",
61
infra_ep_1,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=infraspecies]/verbatimrank/_if[@name=""if has infraspecificEpithet""]/cond",
62
infra_rank_1,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=infraspecies]/verbatimrank/_if[@name=""if has infraspecificEpithet""]/then",
63
auth,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=species]/author_id/party/surname",Brad: This is the author of the scientificName.
64
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=species]/taxonname",
65
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,species,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=genus]/taxonname",
66
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,species,genus,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=family]/taxonname",
67
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",
68
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",
69
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/_join_words/1",
70
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",
71
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",
72
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",
73
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.
74
auth,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/author,Brad: This is the author of the scientificName.
75
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/family,
76
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/genus,
77
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/species,
78
infra_ep_1,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/subspecies/_alt/2/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond",
79
infra_rank_1,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/subspecies/_alt/2/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then",
80
infra_ep_1,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/subspecies/_alt/2/_join_words/2,
60
infra_ep_1,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=infraspecies]/taxonname",
61
infra_ep_1,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=infraspecies]/verbatimrank/_if[@name=""if has infraspecificEpithet""]/cond",
62
infra_rank_1,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=infraspecies]/verbatimrank/_if[@name=""if has infraspecificEpithet""]/then",
63
auth,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=species]/author_id/party/surname",Brad: This is the author of the scientificName.
64
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=species]/taxonname",
65
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,species,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=genus]/taxonname",
66
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,species,genus,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=family]/taxonname",
67
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
68
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
69
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
70
infra_ep_1,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[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",
71
infra_rank_1,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[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",
72
infra_ep_1,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2",
73
auth,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/2",Brad: This is the author of the scientificName.
74
auth,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/author,Brad: This is the author of the scientificName.
75
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/family,
76
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus,
77
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/species,
78
infra_ep_1,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/subspecies/_alt/2/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond",
79
infra_rank_1,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/subspecies/_alt/2/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then",
80
infra_ep_1,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/subspecies/_alt/2/_join_words/2,
81 81
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."
82
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
83
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,
84
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
85
OrigFamily,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/family,Brad: OMIT
86
OrigGenus,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/genus,
87
OrigSpecies,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/species,Brad: OMIT
82
OrigFamily,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/canon_taxonconcept_id/taxonconcept:[datasource_id/party/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,Brad: OMIT
83
OrigGenus,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/canon_taxonconcept_id/taxonconcept:[datasource_id/party/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2,
84
OrigSpecies,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/canon_taxonconcept_id/taxonconcept:[datasource_id/party/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3,Brad: OMIT
85
OrigFamily,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/family,Brad: OMIT
86
OrigGenus,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/genus,
87
OrigSpecies,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/species,Brad: OMIT
88 88
coll_firstname,/location/locationevent/taxonoccurrence/verbatimcollectorname/_join_words/1,Brad: See comment above
89 89
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."
90 90
DetType,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/cond/_eq:[right=indirect]/left","Brad: A SALVIAS value referring to the relationship between the voucher specimen and the observation. Affect how the identification of the specimen(latin name) is transferred to the observation. 'direct'=voucher specimen was collected from this same tree; they are one and the same individual. 'indirect'=voucher specimen was collected for a different individual, but the original data provider confirmed that this is the same species. 'default'=basically same as 'indirect'. 'uncollected'=no voucher specimen, data provider  asserted that this was the name but was unable to collect. The main different is that with 'direct', 'indirect', and 'default', the scientific name can be updated automatically based on the name attached to the specimen voucher (assuming you have a link to that data, presumably from a herbarium database. Whereas, if det_type='uncollected', the name can never change because there is no specimen."
inputs/.TNRS/tnrs/VegBIEN.csv
1 1
TNRS,VegBIEN:/_simplifyPath:[next=parent_id]/path,Comments
2 2
Name_submitted,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/2",
3 3
Name_matched,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/3",
4
Accepted_name,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/cond/_exists",
5
Infraspecific_epithet_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=infraspecies]/taxonname",
6
Infraspecific_epithet_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=infraspecies]/verbatimrank/_if[@name=""if has infraspecificEpithet""]/cond",
7
Name_matched_rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=infraspecies]/verbatimrank/_if[@name=""if has infraspecificEpithet""]/then",
8
Name_matched_author,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=species]/author_id/party/surname",Contains author based on matched name
9
Specific_epithet_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=species]/taxonname",
10
Genus_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,species,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=genus]/taxonname",
11
Name_matched_accepted_family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,species,genus,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=family]/taxonname",Contains family based on matched name
12
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",
13
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",
14
Name_matched_accepted_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",Contains family based on matched name
15
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",
16
Specific_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/3/_join_words/1",
17
Unmatched_terms,"/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/_join_words/2",
18
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",
19
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",
20
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",
21
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",Contains author based on matched name
22
Accepted_name_author,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_set_canon_taxonpath/canon_taxonpath_id/taxonpath/author,
23
Accepted_name_family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_set_canon_taxonpath/canon_taxonpath_id/taxonpath/family,
24
Accepted_name,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_set_canon_taxonpath/canon_taxonpath_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1,
25
Accepted_name_family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_set_canon_taxonpath/canon_taxonpath_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,
26
Accepted_name_rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_set_canon_taxonpath/canon_taxonpath_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then",
27
Accepted_name_author,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_set_canon_taxonpath/canon_taxonpath_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/2,
28
Accepted_name_rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_set_canon_taxonpath/canon_taxonpath_id/taxonpath/subspecies/_alt/2/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then",
29
Accepted_name,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_set_canon_taxonpath/canon_taxonpath_id/taxonpath/taxonomicname,
30
Name_matched_author,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/author,Contains author based on matched name
31
Name_matched_accepted_family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/family,Contains family based on matched name
32
Genus_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/genus,
33
Unmatched_terms,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/morphospecies,
34
Specific_epithet_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/species,
35
Infraspecific_epithet_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/subspecies/_alt/2/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond",
36
Name_matched_rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/subspecies/_alt/2/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then",
37
Infraspecific_epithet_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/subspecies/_alt/2/_join_words/2,
38
Name_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicname,
39
Name_submitted,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor,
4
Accepted_name,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/cond/_exists",
5
Infraspecific_epithet_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=infraspecies]/taxonname",
6
Infraspecific_epithet_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=infraspecies]/verbatimrank/_if[@name=""if has infraspecificEpithet""]/cond",
7
Name_matched_rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=infraspecies]/verbatimrank/_if[@name=""if has infraspecificEpithet""]/then",
8
Name_matched_author,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=species]/author_id/party/surname",Contains author based on matched name
9
Specific_epithet_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=species]/taxonname",
10
Genus_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,species,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=genus]/taxonname",
11
Name_matched_accepted_family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,species,genus,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=family]/taxonname",Contains family based on matched name
12
Name_submitted,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/1",
13
Name_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1",
14
Name_matched_accepted_family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",Contains family based on matched name
15
Genus_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
16
Specific_epithet_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
17
Unmatched_terms,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/2",
18
Infraspecific_epithet_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[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",
19
Name_matched_rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[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",
20
Infraspecific_epithet_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2",
21
Name_matched_author,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/2",Contains author based on matched name
22
Accepted_name_author,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_set_canon_taxonconcept/canon_taxonconcept_id/taxonconcept/author,
23
Accepted_name_family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_set_canon_taxonconcept/canon_taxonconcept_id/taxonconcept/family,
24
Accepted_name,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_set_canon_taxonconcept/canon_taxonconcept_id/taxonconcept/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1,
25
Accepted_name_family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_set_canon_taxonconcept/canon_taxonconcept_id/taxonconcept/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,
26
Accepted_name_rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_set_canon_taxonconcept/canon_taxonconcept_id/taxonconcept/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then",
27
Accepted_name_author,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_set_canon_taxonconcept/canon_taxonconcept_id/taxonconcept/identifyingtaxonomicname/_alt/2/_join_words/2,
28
Accepted_name_rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_set_canon_taxonconcept/canon_taxonconcept_id/taxonconcept/subspecies/_alt/2/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then",
29
Accepted_name,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_set_canon_taxonconcept/canon_taxonconcept_id/taxonconcept/taxonomicname,
30
Name_matched_author,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/author,Contains author based on matched name
31
Name_matched_accepted_family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/family,Contains family based on matched name
32
Genus_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus,
33
Unmatched_terms,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/morphospecies,
34
Specific_epithet_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/species,
35
Infraspecific_epithet_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/subspecies/_alt/2/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond",
36
Name_matched_rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/subspecies/_alt/2/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then",
37
Infraspecific_epithet_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/subspecies/_alt/2/_join_words/2,
38
Name_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonomicname,
39
Name_submitted,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonomicnamewithauthor,
40 40
Accepted_name_lsid,,** No non-empty join mapping for OMIT ** 
41 41
Accepted_name_species,,** No non-empty join mapping for OMIT ** Also contains genus. Omitted because Accepted_name contains more info.
42 42
Accepted_name_url,,** No non-empty join mapping for OMIT ** 
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
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,species,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=genus]/taxonname",
20
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,species,genus,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=family]/taxonname",
21
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",
22
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",
23
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/family,
24
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/genus,
19
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,species,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=genus]/taxonname",
20
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,species,genus,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=family]/taxonname",
21
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
22
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
23
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/family,
24
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus,
25 25
Detyy,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value",
26 26
cf,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/taxonfit,
27 27
Collector,/location/locationevent/taxonoccurrence/verbatimcollectorname/_join/1,
inputs/ARIZ/Specimen/test.xml.ref
113 113
                                    <surname><_namePart><last>$IdentifiedBy</last></_namePart></surname>
114 114
                                </party>
115 115
                            </party_id>
116
                            <taxonpath_id>
117
                                <taxonpath>
118
                                    <canon_taxonpath_id>
119
                                        <taxonpath>
116
                            <taxonconcept_id>
117
                                <taxonconcept>
118
                                    <canon_taxonconcept_id>
119
                                        <taxonconcept>
120 120
                                            <datasource_id><party><organizationname>TNRS</organizationname></party></datasource_id>
121 121
                                            <identifyingtaxonomicname>
122 122
                                                <_alt>
......
136 136
                                                    </2>
137 137
                                                </_alt>
138 138
                                            </identifyingtaxonomicname>
139
                                        </taxonpath>
140
                                    </canon_taxonpath_id>
139
                                        </taxonconcept>
140
                                    </canon_taxonconcept_id>
141 141
                                    <class>$Class</class>
142 142
                                    <family>$Family</family>
143 143
                                    <genus>$Genus</genus>
......
148 148
                                    <subspecies>$Subspecies</subspecies>
149 149
                                    <taxonomicname>$ScientificName</taxonomicname>
150 150
                                    <taxonomicnamewithauthor>$ScientificNameAuthor</taxonomicnamewithauthor>
151
                                </taxonpath>
152
                            </taxonpath_id>
151
                                </taxonconcept>
152
                            </taxonconcept_id>
153 153
                            <determinationdate>
154 154
                                <_date>
155 155
                                    <day>
inputs/NCU-NCSC/Specimen/VegBIEN.csv
14 14
Full Taxon Name,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_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/_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
Full Taxon Name,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicname,
17
Full Taxon Name,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1",
18
Full Taxon Name,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/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,
21 21
County,/location/locationplace/*_id/placepath/county,
inputs/TEAM/VL/test.xml.ref
42 42
                        <authortaxoncode>$Tree Number</authortaxoncode>
43 43
                        <sourceaccessioncode>$Id</sourceaccessioncode>
44 44
                        <taxondetermination>
45
                            <taxonpath_id>
46
                                <taxonpath>
47
                                    <canon_taxonpath_id>
48
                                        <taxonpath>
45
                            <taxonconcept_id>
46
                                <taxonconcept>
47
                                    <canon_taxonconcept_id>
48
                                        <taxonconcept>
49 49
                                            <datasource_id><party><organizationname>TNRS</organizationname></party></datasource_id>
50 50
                                            <identifyingtaxonomicname>
51 51
                                                <_join_words>
......
54 54
                                                    <3>$Species</3>
55 55
                                                </_join_words>
56 56
                                            </identifyingtaxonomicname>
57
                                        </taxonpath>
58
                                    </canon_taxonpath_id>
57
                                        </taxonconcept>
58
                                    </canon_taxonconcept_id>
59 59
                                    <family>$Family</family>
60 60
                                    <genus>$Genus</genus>
61 61
                                    <species>$Species</species>
62
                                </taxonpath>
63
                            </taxonpath_id>
62
                                </taxonconcept>
63
                            </taxonconcept_id>
64 64
                        </taxondetermination>
65 65
                        <verbatimcollectorname>$Names of Collectors</verbatimcollectorname>
66 66
                    </taxonoccurrence>
inputs/TEAM/VT/VegBIEN.csv
20 20
1ha Plot Number,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",
21 21
Tree Number,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/1/_first/2",
22 22
Id,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/3,
23
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=species]/taxonname",
24
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,species,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=genus]/taxonname",
25
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,species,genus,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=family]/taxonname",
26
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",
27
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",
28
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/_join_words/1",
29
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/family,
30
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/genus,
31
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/species,
23
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=species]/taxonname",
24
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,species,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=genus]/taxonname",
25
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,species,genus,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=family]/taxonname",
26
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
27
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
28
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
29
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/family,
30
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus,
31
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/species,
32 32
Names of Collectors,/location/locationevent/taxonoccurrence/verbatimcollectorname,
33 33
Comments,,** No join mapping for *Comments ** 
34 34
Condition Codes,,** No join mapping for *Condition Codes ** 
inputs/TEAM/VT/test.xml.ref
42 42
                        <authortaxoncode>$Tree Number</authortaxoncode>
43 43
                        <sourceaccessioncode>$Id</sourceaccessioncode>
44 44
                        <taxondetermination>
45
                            <taxonpath_id>
46
                                <taxonpath>
47
                                    <canon_taxonpath_id>
48
                                        <taxonpath>
45
                            <taxonconcept_id>
46
                                <taxonconcept>
47
                                    <canon_taxonconcept_id>
48
                                        <taxonconcept>
49 49
                                            <datasource_id><party><organizationname>TNRS</organizationname></party></datasource_id>
50 50
                                            <identifyingtaxonomicname>
51 51
                                                <_join_words>
......
54 54
                                                    <3>$Species</3>
55 55
                                                </_join_words>
56 56
                                            </identifyingtaxonomicname>
57
                                        </taxonpath>
58
                                    </canon_taxonpath_id>
57
                                        </taxonconcept>
58
                                    </canon_taxonconcept_id>
59 59
                                    <family>$Family</family>
60 60
                                    <genus>$Genus</genus>
61 61
                                    <species>$Species</species>
62
                                </taxonpath>
63
                            </taxonpath_id>
62
                                </taxonconcept>
63
                            </taxonconcept_id>
64 64
                        </taxondetermination>
65 65
                        <verbatimcollectorname>$Names of Collectors</verbatimcollectorname>
66 66
                    </taxonoccurrence>
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
Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=subspecies]/taxonname",
32
ScientificNameAuthor,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=species]/author_id/party/surname",
33
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=species]/taxonname",
34
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,species,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=genus]/taxonname",
35
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,species,genus,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=family]/taxonname",
36
Order,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,species,genus,family,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=order]/taxonname",
37
Class,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,species,genus,family,order,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=class]/taxonname",
38
Phylum,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,species,genus,family,order,class,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=phylum]/taxonname",
39
Kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,species,genus,family,order,class,phylum,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=kingdom]/taxonname",
40
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",
41
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",
42
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",
43
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/_join_words/1",
44
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",
45
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",
46
ScientificNameAuthor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/author,
47
Class,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/class,
48
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/family,
49
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/genus,
50
Kingdom,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/kingdom,
51
Order,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/order,
52
Phylum,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/phylum,
53
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/species,
54
Subspecies,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/subspecies/_alt/1,
55
ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicname,
31
Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=subspecies]/taxonname",
32
ScientificNameAuthor,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=species]/author_id/party/surname",
33
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=species]/taxonname",
34
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,species,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=genus]/taxonname",
35
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,species,genus,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=family]/taxonname",
36
Order,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,species,genus,family,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=order]/taxonname",
37
Class,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,species,genus,family,order,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=class]/taxonname",
38
Phylum,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,species,genus,family,order,class,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=phylum]/taxonname",
39
Kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,species,genus,family,order,class,phylum,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=kingdom]/taxonname",
40
ScientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1",
41
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
42
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
43
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
44
Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/4",
45
ScientificNameAuthor,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/2",
46
ScientificNameAuthor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/author,
47
Class,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/class,
48
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/family,
49
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus,
50
Kingdom,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/kingdom,
51
Order,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/order,
52
Phylum,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/phylum,
53
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/species,
54
Subspecies,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/subspecies/_alt/1,
55
ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonomicname,
56 56
DayIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value",
57 57
MonthIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value",
58 58
YearIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value",
inputs/NY/Specimen/test.xml.ref
113 113
                                    <surname><_namePart><last>$IdentifiedBy</last></_namePart></surname>
114 114
                                </party>
115 115
                            </party_id>
116
                            <taxonpath_id>
117
                                <taxonpath>
118
                                    <canon_taxonpath_id>
119
                                        <taxonpath>
116
                            <taxonconcept_id>
117
                                <taxonconcept>
118
                                    <canon_taxonconcept_id>
119
                                        <taxonconcept>
120 120
                                            <datasource_id><party><organizationname>TNRS</organizationname></party></datasource_id>
121 121
                                            <identifyingtaxonomicname>
122 122
                                                <_join_words>
......
136 136
                                                    <2>$ScientificNameAuthor</2>
137 137
                                                </_join_words>
138 138
                                            </identifyingtaxonomicname>
139
                                        </taxonpath>
140
                                    </canon_taxonpath_id>
139
                                        </taxonconcept>
140
                                    </canon_taxonconcept_id>
141 141
                                    <author>$ScientificNameAuthor</author>
142 142
                                    <class>$Class</class>
143 143
                                    <family>$Family</family>
......
148 148
                                    <species>$Species</species>
149 149
                                    <subspecies>$Subspecies</subspecies>
150 150
                                    <taxonomicname>$ScientificName</taxonomicname>
151
                                </taxonpath>
152
                            </taxonpath_id>
151
                                </taxonconcept>
152
                            </taxonconcept_id>
153 153
                            <determinationdate>
154 154
                                <_date>
155 155
                                    <day>
inputs/Madidi/Organism/VegBIEN.csv
32 32
Determined by,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/givenname/_namePart/first,
33 33
Determined by,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/middlename/_namePart/middle,
34 34
Determined by,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/surname/_namePart/last,
35
Autor (revised),"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=species]/author_id/party/surname",
36
Specific epithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=species]/taxonname",
37
Genera,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,species,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=genus]/taxonname",
38
Family (revised),"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,species,genus,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=family]/taxonname",
39
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",
40
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"""
41
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",
42
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",
43
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/_join_words/1",
44
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",
45
Autor (revised),/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/author,
46
Family (revised),/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/family,
47
Genera,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/genus,
48
Specific epithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/species,
49
Species and morphotypes,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicname,"Contains less than ""Specie+autor"""
50
Specie+autor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor,
35
Autor (revised),"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=species]/author_id/party/surname",
36
Specific epithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=species]/taxonname",
37
Genera,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,species,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=genus]/taxonname",
38
Family (revised),"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,species,genus,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=family]/taxonname",
39
Specie+autor,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/1",
40
Species and morphotypes,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1","Contains less than ""Specie+autor"""
41
Family (revised),"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
42
Genera,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
43
Specific epithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
44
Autor (revised),"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/2",
45
Autor (revised),/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/author,
46
Family (revised),/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/family,
47
Genera,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus,
48
Specific epithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/species,
49
Species and morphotypes,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonomicname,"Contains less than ""Specie+autor"""
50
Specie+autor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonomicnamewithauthor,
51 51
Qualifier,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/taxonfit,
52
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,
53
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
54
Field family,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/family,
55
Field name,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/genus,Often = Genera
52
Field family,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/canon_taxonconcept_id/taxonconcept:[datasource_id/party/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,
53
Field name,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/canon_taxonconcept_id/taxonconcept:[datasource_id/party/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2,Often = Genera
54
Field family,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/family,
55
Field name,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/genus,Often = Genera
56 56
Index collector,/location/locationevent/taxonoccurrence/verbatimcollectorname,
57 57
Specimen,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then",
58 58
Basal area,,"** No join mapping for *Basal area ** Would be basalDiameter, but need formula to translate"
inputs/Madidi/Organism/test.xml.ref
68 68
                                    <surname><_namePart><last>$Determined by</last></_namePart></surname>
69 69
                                </party>
70 70
                            </party_id>
71
                            <taxonpath_id>
72
                                <taxonpath>
73
                                    <canon_taxonpath_id>
74
                                        <taxonpath>
71
                            <taxonconcept_id>
72
                                <taxonconcept>
73
                                    <canon_taxonconcept_id>
74
                                        <taxonconcept>
75 75
                                            <datasource_id><party><organizationname>TNRS</organizationname></party></datasource_id>
76 76
                                            <identifyingtaxonomicname>
77 77
                                                <_alt>
......
95 95
                                                    </2>
96 96
                                                </_alt>
97 97
                                            </identifyingtaxonomicname>
98
                                        </taxonpath>
99
                                    </canon_taxonpath_id>
98
                                        </taxonconcept>
99
                                    </canon_taxonconcept_id>
100 100
                                    <author>$Autor (revised)</author>
101 101
                                    <family>$Family (revised)</family>
102 102
                                    <genus>$Genera</genus>
103 103
                                    <species>$Specific epithet</species>
104 104
                                    <taxonomicname>$Species and morphotypes</taxonomicname>
105 105
                                    <taxonomicnamewithauthor>$Specie+autor</taxonomicnamewithauthor>
106
                                </taxonpath>
107
                            </taxonpath_id>
106
                                </taxonconcept>
107
                            </taxonconcept_id>
108 108
                            <taxonfit>$Qualifier</taxonfit>
109 109
                        </taxondetermination>
110 110
                        <taxondetermination>
111 111
                            <isoriginal>true</isoriginal>
112
                            <taxonpath_id>
113
                                <taxonpath>
114
                                    <canon_taxonpath_id>
115
                                        <taxonpath>
112
                            <taxonconcept_id>
113
                                <taxonconcept>
114
                                    <canon_taxonconcept_id>
115
                                        <taxonconcept>
116 116
                                            <datasource_id><party><organizationname>TNRS</organizationname></party></datasource_id>
117 117
                                            <identifyingtaxonomicname>
118 118
                                                <_join_words>
......
120 120
                                                    <2>$Field name</2>
121 121
                                                </_join_words>
122 122
                                            </identifyingtaxonomicname>
123
                                        </taxonpath>
124
                                    </canon_taxonpath_id>
123
                                        </taxonconcept>
124
                                    </canon_taxonconcept_id>
125 125
                                    <family>$Field family</family>
126 126
                                    <genus>$Field name</genus>
127
                                </taxonpath>
128
                            </taxonpath_id>
127
                                </taxonconcept>
128
                            </taxonconcept_id>
129 129
                        </taxondetermination>
130 130
                        <verbatimcollectorname>$Index collector</verbatimcollectorname>
131 131
                    </taxonoccurrence>
inputs/UNCC/Specimen/VegBIEN.csv
42 42
GROUP BY herbarium, accession
43 43
HAVING count(*) > 1
44 44
-----"
45
infraname,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=infraspecies]/taxonname",
46
infraname,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=infraspecies]/verbatimrank/_if[@name=""if has infraspecificEpithet""]/cond",
47
usdaRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=infraspecies]/verbatimrank/_if[@name=""if has infraspecificEpithet""]/then/_alt/1",
48
infrarank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=infraspecies]/verbatimrank/_if[@name=""if has infraspecificEpithet""]/then/_alt/2",
49
authors,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=species]/author_id/party/surname",
50
species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=species]/taxonname",
51
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,species,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=genus]/taxonname",
52
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,species,genus,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=family]/taxonname",
53
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",
54
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",
55
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",
56
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/_join_words/1",
57
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",
58
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",
59
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",
60
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",
61
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",
62
authors,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/author,
63
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/family,
64
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/genus,
65
species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/species,
66
infraname,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/subspecies/_alt/2/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond",
67
usdaRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/subspecies/_alt/2/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then/_alt/1",
68
infrarank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/subspecies/_alt/2/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then/_alt/2",
69
infraname,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/subspecies/_alt/2/_join_words/2,
70
SciName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicname,
45
infraname,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=infraspecies]/taxonname",
46
infraname,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=infraspecies]/verbatimrank/_if[@name=""if has infraspecificEpithet""]/cond",
47
usdaRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=infraspecies]/verbatimrank/_if[@name=""if has infraspecificEpithet""]/then/_alt/1",
48
infrarank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=infraspecies]/verbatimrank/_if[@name=""if has infraspecificEpithet""]/then/_alt/2",
49
authors,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=species]/author_id/party/surname",
50
species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=species]/taxonname",
51
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,species,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=genus]/taxonname",
52
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,species,genus,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=family]/taxonname",
53
SciName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1",
54
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
55
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
56
species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
57
infraname,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[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",
58
usdaRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[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",
59
infrarank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[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",
60
infraname,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2",
61
authors,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/2",
62
authors,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/author,
63
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/family,
64
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus,
65
species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/species,
66
infraname,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/subspecies/_alt/2/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond",
67
usdaRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/subspecies/_alt/2/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then/_alt/1",
68
infrarank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/subspecies/_alt/2/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then/_alt/2",
69
infraname,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/subspecies/_alt/2/_join_words/2,
70
SciName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonomicname,
71 71
collector,/location/locationevent/taxonoccurrence/verbatimcollectorname/_join/1,
72 72
collector1,/location/locationevent/taxonoccurrence/verbatimcollectorname/_join/2,
73 73
collector2,/location/locationevent/taxonoccurrence/verbatimcollectorname/_join/3,
inputs/UNCC/Specimen/test.xml.ref
70 70
                        <iscultivated>$cultivated</iscultivated>
71 71
                        <sourceaccessioncode>$accession</sourceaccessioncode>
72 72
                        <taxondetermination>
73
                            <taxonpath_id>
74
                                <taxonpath>
75
                                    <canon_taxonpath_id>
76
                                        <taxonpath>
73
                            <taxonconcept_id>
74
                                <taxonconcept>
75
                                    <canon_taxonconcept_id>
76
                                        <taxonconcept>
77 77
                                            <datasource_id><party><organizationname>TNRS</organizationname></party></datasource_id>
78 78
                                            <identifyingtaxonomicname>
79 79
                                                <_join_words>
......
108 108
                                                    <2>$authors</2>
109 109
                                                </_join_words>
110 110
                                            </identifyingtaxonomicname>
111
                                        </taxonpath>
112
                                    </canon_taxonpath_id>
111
                                        </taxonconcept>
112
                                    </canon_taxonconcept_id>
113 113
                                    <author>$authors</author>
114 114
                                    <family>$family</family>
115 115
                                    <genus>$genus</genus>
......
131 131
                                        </_join_words>
132 132
                                    </subspecies>
133 133
                                    <taxonomicname>$SciName</taxonomicname>
134
                                </taxonpath>
135
                            </taxonpath_id>
134
                                </taxonconcept>
135
                            </taxonconcept_id>
136 136
                        </taxondetermination>
137 137
                        <verbatimcollectorname>
138 138
                            <_join>
inputs/ACAD/Specimen/VegBIEN.csv
22 22
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/givenname/_namePart/first,
23 23
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/middlename/_namePart/middle,
24 24
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/surname/_namePart/last,
25
infraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=infraspecies]/taxonname",
26
infraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=infraspecies]/verbatimrank/_if[@name=""if has infraspecificEpithet""]/cond",
27
taxonRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=infraspecies]/verbatimrank/_if[@name=""if has infraspecificEpithet""]/then",
28
scientificNameAuthorship,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=species]/author_id/party/surname",
29
specificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=species]/taxonname",
30
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,species,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=genus]/taxonname",
31
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,species,genus,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=family]/taxonname",
32
order,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,species,genus,family,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=order]/taxonname",
33
class,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,species,genus,family,order,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=class]/taxonname",
34
phylum,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,species,genus,family,order,class,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=phylum]/taxonname",
35
kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,species,genus,family,order,class,phylum,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=kingdom]/taxonname",
36
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",
37
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",
38
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",
39
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/_join_words/1",
40
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",
41
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",
42
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",
43
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",
44
scientificNameAuthorship,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/author,
45
class,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/class,
46
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/family,
47
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/genus,
48
kingdom,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/kingdom,
49
order,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/order,
50
phylum,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/phylum,
51
specificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/species,
52
infraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/subspecies/_alt/2/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond",
53
taxonRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/subspecies/_alt/2/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then",
54
infraspecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/subspecies/_alt/2/_join_words/2,
55
scientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor,
25
infraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=infraspecies]/taxonname",
26
infraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=infraspecies]/verbatimrank/_if[@name=""if has infraspecificEpithet""]/cond",
27
taxonRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=infraspecies]/verbatimrank/_if[@name=""if has infraspecificEpithet""]/then",
28
scientificNameAuthorship,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=species]/author_id/party/surname",
29
specificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=species]/taxonname",
30
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,species,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=genus]/taxonname",
31
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,species,genus,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=family]/taxonname",
32
order,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,species,genus,family,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=order]/taxonname",
33
class,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,species,genus,family,order,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=class]/taxonname",
34
phylum,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,species,genus,family,order,class,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=phylum]/taxonname",
35
kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,species,genus,family,order,class,phylum,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=kingdom]/taxonname",
36
scientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/1",
37
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
38
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
39
specificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
40
infraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[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",
41
taxonRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[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",
42
infraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2",
43
scientificNameAuthorship,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/2",
44
scientificNameAuthorship,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/author,
45
class,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/class,
46
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/family,
47
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus,
48
kingdom,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/kingdom,
49
order,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/order,
50
phylum,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/phylum,
51
specificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/species,
52
infraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/subspecies/_alt/2/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond",
53
taxonRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/subspecies/_alt/2/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then",
54
infraspecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/subspecies/_alt/2/_join_words/2,
55
scientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonomicnamewithauthor,
56 56
dateIdentified,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/1/_*/date/_dateRangeStart/value,
57 57
recordedBy,/location/locationevent/taxonoccurrence/verbatimcollectorname,
58 58
catalogNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then",
inputs/ACAD/Specimen/test.xml.ref
73 73
                                    <surname><_namePart><last>$identifiedBy</last></_namePart></surname>
74 74
                                </party>
75 75
                            </party_id>
76
                            <taxonpath_id>
77
                                <taxonpath>
78
                                    <canon_taxonpath_id>
79
                                        <taxonpath>
76
                            <taxonconcept_id>
77
                                <taxonconcept>
78
                                    <canon_taxonconcept_id>
79
                                        <taxonconcept>
80 80
                                            <datasource_id><party><organizationname>TNRS</organizationname></party></datasource_id>
81 81
                                            <identifyingtaxonomicname>
82 82
                                                <_alt>
......
106 106
                                                    </2>
107 107
                                                </_alt>
108 108
                                            </identifyingtaxonomicname>
109
                                        </taxonpath>
110
                                    </canon_taxonpath_id>
109
                                        </taxonconcept>
110
                                    </canon_taxonconcept_id>
111 111
                                    <author>$scientificNameAuthorship</author>
112 112
                                    <class>$class</class>
113 113
                                    <family>$family</family>
......
128 128
                                        </_join_words>
129 129
                                    </subspecies>
130 130
                                    <taxonomicnamewithauthor>$scientificName</taxonomicnamewithauthor>
131
                                </taxonpath>
132
                            </taxonpath_id>
131
                                </taxonconcept>
132
                            </taxonconcept_id>
133 133
                            <determinationdate><_date><date><_dateRangeStart><value>$dateIdentified</value></_dateRangeStart></date></_date></determinationdate>
134 134
                        </taxondetermination>
135 135
                        <verbatimcollectorname>$recordedBy</verbatimcollectorname>
inputs/SALVIAS-CSV/Organism/VegBIEN.csv
64 64
tag1,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/1/_first/2/_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."
65 65
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>"
66 66
OBSERVATION_ID,"/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."
67
infra_ep_1,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=infraspecies]/taxonname",
68
infra_ep_1,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=infraspecies]/verbatimrank/_if[@name=""if has infraspecificEpithet""]/cond",
69
infra_rank_1,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=infraspecies]/verbatimrank/_if[@name=""if has infraspecificEpithet""]/then",
70
specific_authority,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=species]/author_id/party/surname",Brad: This is the author of the scientificName.
71
specific_epithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=species]/taxonname",
72
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,species,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=genus]/taxonname",
73
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,species,genus,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=family]/taxonname",
74
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",
75
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",
76
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/_join_words/1",
77
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",
78
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",
79
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",
80
specific_authority,"/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.
81
specific_authority,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/author,Brad: This is the author of the scientificName.
82
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/family,
83
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/genus,
84
specific_epithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/species,
85
infra_ep_1,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/subspecies/_alt/2/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond",
86
infra_rank_1,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/subspecies/_alt/2/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then",
87
infra_ep_1,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/subspecies/_alt/2/_join_words/2,
67
infra_ep_1,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=infraspecies]/taxonname",
68
infra_ep_1,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=infraspecies]/verbatimrank/_if[@name=""if has infraspecificEpithet""]/cond",
69
infra_rank_1,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=infraspecies]/verbatimrank/_if[@name=""if has infraspecificEpithet""]/then",
70
specific_authority,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=species]/author_id/party/surname",Brad: This is the author of the scientificName.
71
specific_epithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=species]/taxonname",
72
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,species,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=genus]/taxonname",
73
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,species,genus,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=family]/taxonname",
74
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
75
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
76
specific_epithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
77
infra_ep_1,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[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",
78
infra_rank_1,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[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",
79
infra_ep_1,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2",
80
specific_authority,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/2",Brad: This is the author of the scientificName.
81
specific_authority,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/author,Brad: This is the author of the scientificName.
82
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/family,
83
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus,
84
specific_epithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/species,
85
infra_ep_1,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/subspecies/_alt/2/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond",
86
infra_rank_1,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/subspecies/_alt/2/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then",
87
infra_ep_1,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/subspecies/_alt/2/_join_words/2,
88 88
cf_aff,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/taxonfit,"Brad: Not sure where this goes. Indicator of identification uncertainty. 'cf.'=similar to the species listed, 'aff.'=related to the species list, but not the same. You'll need to check with Bob and with Nick where these go in VegX and VegBank."
89
orig_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,Brad: OMIT
90
orig_species,/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
91
orig_family,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/family,Brad: OMIT
92
orig_species,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/species,Brad: OMIT
89
orig_family,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/canon_taxonconcept_id/taxonconcept:[datasource_id/party/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,Brad: OMIT
90
orig_species,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/canon_taxonconcept_id/taxonconcept:[datasource_id/party/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3,Brad: OMIT
91
orig_family,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/family,Brad: OMIT
92
orig_species,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/species,Brad: OMIT
93 93
coll_firstname,/location/locationevent/taxonoccurrence/verbatimcollectorname/_join_words/1,Brad: See comment above
94 94
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."
95 95
det_type,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/cond/_eq:[right=indirect]/left","Brad: A SALVIAS value referring to the relationship between the voucher specimen and the observation. Affect how the identification of the specimen(latin name) is transferred to the observation. 'direct'=voucher specimen was collected from this same tree; they are one and the same individual. 'indirect'=voucher specimen was collected for a different individual, but the original data provider confirmed that this is the same species. 'default'=basically same as 'indirect'. 'uncollected'=no voucher specimen, data provider  asserted that this was the name but was unable to collect. The main different is that with 'direct', 'indirect', and 'default', the scientific name can be updated automatically based on the name attached to the specimen voucher (assuming you have a link to that data, presumably from a herbarium database. Whereas, if det_type='uncollected', the name can never change because there is no specimen."
inputs/SALVIAS-CSV/Organism/test.xml.ref
145 145
                        </growthform>
146 146
                        <sourceaccessioncode>$OBSERVATION_ID</sourceaccessioncode>
147 147
                        <taxondetermination>
148
                            <taxonpath_id>
149
                                <taxonpath>
150
                                    <canon_taxonpath_id>
151
                                        <taxonpath>
148
                            <taxonconcept_id>
149
                                <taxonconcept>
150
                                    <canon_taxonconcept_id>
151
                                        <taxonconcept>
152 152
                                            <datasource_id><party><organizationname>TNRS</organizationname></party></datasource_id>
153 153
                                            <identifyingtaxonomicname>
154 154
                                                <_join_words>
......
173 173
                                                    <2>$specific_authority</2>
174 174
                                                </_join_words>
175 175
                                            </identifyingtaxonomicname>
176
                                        </taxonpath>
177
                                    </canon_taxonpath_id>
176
                                        </taxonconcept>
177
                                    </canon_taxonconcept_id>
178 178
                                    <author>$specific_authority</author>
179 179
                                    <family>$family</family>
180 180
                                    <genus>$genus</genus>
......
190 190
                                            <2>$infra_ep_1</2>
191 191
                                        </_join_words>
192 192
                                    </subspecies>
193
                                </taxonpath>
194
                            </taxonpath_id>
193
                                </taxonconcept>
194
                            </taxonconcept_id>
195 195
                            <taxonfit>$cf_aff</taxonfit>
196 196
                        </taxondetermination>
197 197
                        <taxondetermination>
198 198
                            <isoriginal>true</isoriginal>
199
                            <taxonpath_id>
200
                                <taxonpath>
201
                                    <canon_taxonpath_id>
202
                                        <taxonpath>
199
                            <taxonconcept_id>
200
                                <taxonconcept>
201
                                    <canon_taxonconcept_id>
202
                                        <taxonconcept>
203 203
                                            <datasource_id><party><organizationname>TNRS</organizationname></party></datasource_id>
204 204
                                            <identifyingtaxonomicname>
205 205
                                                <_join_words>
......
207 207
                                                    <3>$orig_species</3>
208 208
                                                </_join_words>
209 209
                                            </identifyingtaxonomicname>
210
                                        </taxonpath>
211
                                    </canon_taxonpath_id>
210
                                        </taxonconcept>
211
                                    </canon_taxonconcept_id>
212 212
                                    <family>$orig_family</family>
213 213
                                    <species>$orig_species</species>
214
                                </taxonpath>
215
                            </taxonpath_id>
214
                                </taxonconcept>
215
                            </taxonconcept_id>
216 216
                        </taxondetermination>
217 217
                        <verbatimcollectorname>
218 218
                            <_join_words>
inputs/CVS/Organism/VegBIEN.csv
10 10
%cover,/location/locationevent/taxonoccurrence/aggregateoccurrence/cover_fraction/_percent_to_fraction/value,
11 11
authorObsCode,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",
12 12
currentTaxonName sec Weakley 2006,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/3",
13
currentTaxonName sec Weakley 2006,"/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",
14
currentTaxonName sec Weakley 2006,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicname,
13
currentTaxonName sec Weakley 2006,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1",
14
currentTaxonName sec Weakley 2006,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonomicname,
15 15
county,/location/locationplace/*_id/placepath/county,
16 16
state,/location/locationplace/*_id/placepath/stateprovince,
17 17
confidentialityStatus,,** No join mapping for *confidentialityStatus ** 
inputs/CVS/Organism/test.xml.ref
29 29
                        <aggregateoccurrence><cover_fraction><_percent_to_fraction><value>$%cover</value></_percent_to_fraction></cover_fraction></aggregateoccurrence>
30 30
                        <authortaxoncode>$currentTaxonName sec Weakley 2006</authortaxoncode>
31 31
                        <taxondetermination>
32
                            <taxonpath_id>
33
                                <taxonpath>
34
                                    <canon_taxonpath_id>
35
                                        <taxonpath>
32
                            <taxonconcept_id>
33
                                <taxonconcept>
34
                                    <canon_taxonconcept_id>
35
                                        <taxonconcept>
36 36
                                            <datasource_id><party><organizationname>TNRS</organizationname></party></datasource_id>
37 37
                                            <identifyingtaxonomicname>$currentTaxonName sec Weakley 2006</identifyingtaxonomicname>
38
                                        </taxonpath>
39
                                    </canon_taxonpath_id>
38
                                        </taxonconcept>
39
                                    </canon_taxonconcept_id>
40 40
                                    <taxonomicname>$currentTaxonName sec Weakley 2006</taxonomicname>
41
                                </taxonpath>
42
                            </taxonpath_id>
41
                                </taxonconcept>
42
                            </taxonconcept_id>
43 43
                        </taxondetermination>
44 44
                    </taxonoccurrence>
45 45
                </locationevent>
inputs/REMIB/Specimen/VegBIEN.csv
33 33
HAVING count(*) > 1
34 34
-----"
35 35
acronym,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,
36
specificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=species]/taxonname",
37
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,species,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=genus]/taxonname",
38
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,species,genus,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=family]/taxonname",
39
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",
40
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",
41
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/_join_words/1",
42
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/family,
43
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/genus,
44
specificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/species,
36
specificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=species]/taxonname",
37
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,species,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=genus]/taxonname",
38
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,species,genus,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=family]/taxonname",
39
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
40
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
41
specificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
42
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/family,
43
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus,
44
specificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/species,
45 45
collector,/location/locationevent/taxonoccurrence/verbatimcollectorname,
46 46
accession_number,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then","Not globally unique, only (usually) unique within the institution providing the data (""acronym""). Note that there are nevertheless 11,869 rows where an accession_number appears multiple times within the same institution. [1]
47 47

  
inputs/REMIB/Specimen/test.xml.ref
62 62
                            </plantobservation>
63 63
                        </aggregateoccurrence>
64 64
                        <taxondetermination>
65
                            <taxonpath_id>
66
                                <taxonpath>
67
                                    <canon_taxonpath_id>
68
                                        <taxonpath>
65
                            <taxonconcept_id>
66
                                <taxonconcept>
67
                                    <canon_taxonconcept_id>
68
                                        <taxonconcept>
69 69
                                            <datasource_id><party><organizationname>TNRS</organizationname></party></datasource_id>
70 70
                                            <identifyingtaxonomicname>
71 71
                                                <_join_words>
......
74 74
                                                    <3>$specificEpithet</3>
75 75
                                                </_join_words>
76 76
                                            </identifyingtaxonomicname>
77
                                        </taxonpath>
78
                                    </canon_taxonpath_id>
77
                                        </taxonconcept>
78
                                    </canon_taxonconcept_id>
79 79
                                    <family>$family</family>
80 80
                                    <genus>$genus</genus>
81 81
                                    <species>$specificEpithet</species>
82
                                </taxonpath>
83
                            </taxonpath_id>
82
                                </taxonconcept>
83
                            </taxonconcept_id>
84 84
                        </taxondetermination>
85 85
                        <verbatimcollectorname>$collector</verbatimcollectorname>
86 86
                    </taxonoccurrence>
inputs/CTFS/StemObservation/VegBIEN.csv
21 21
StemTag,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/1/_first/2",
22 22
Tag,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/1/_first/2",
23 23
MeasureID,"/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/2/_if[@name=""if organism in AggregateOccurrence""]/else",
24
SubSpeciesName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=subspecies]/taxonname",
25
SpeciesAuthority,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=species]/author_id/party/surname",
26
SpeciesName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=species]/taxonname",
27
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,species,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=genus]/taxonname",
28
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,species,genus,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=family]/taxonname",
29
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",
30
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",
31
SpeciesName,"/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/_join_words/1",
32
SubSpeciesName,"/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",
33
SpeciesAuthority,"/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",
34
SpeciesAuthority,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/author,
35
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/family,
36
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/genus,
37
SpeciesName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/species,
38
SubSpeciesName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/subspecies/_alt/1,
24
SubSpeciesName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=subspecies]/taxonname",
25
SpeciesAuthority,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=species]/author_id/party/surname",
26
SpeciesName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=species]/taxonname",
27
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,species,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=genus]/taxonname",
28
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,species,genus,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=family]/taxonname",
29
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
30
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
31
SpeciesName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
32
SubSpeciesName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/4",
33
SpeciesAuthority,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/2",
34
SpeciesAuthority,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/author,
35
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/family,
36
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus,
37
SpeciesName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/species,
38
SubSpeciesName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/subspecies/_alt/1,
39 39
Description,,** No join mapping for *Description ** 
40 40
ExactDate,,** No join mapping for *ExactDate ** 
41 41
FamilyID,,** No join mapping for *FamilyID ** 
inputs/CTFS/StemObservation/test.xml.ref
39 39
                        </authortaxoncode>
40 40
                        <sourceaccessioncode>$MeasureID</sourceaccessioncode>
41 41
                        <taxondetermination>
42
                            <taxonpath_id>
43
                                <taxonpath>
44
                                    <canon_taxonpath_id>
45
                                        <taxonpath>
42
                            <taxonconcept_id>
43
                                <taxonconcept>
44
                                    <canon_taxonconcept_id>
45
                                        <taxonconcept>
46 46
                                            <datasource_id><party><organizationname>TNRS</organizationname></party></datasource_id>
47 47
                                            <identifyingtaxonomicname>
48 48
                                                <_join_words>
......
57 57
                                                    <2>$SpeciesAuthority</2>
58 58
                                                </_join_words>
59 59
                                            </identifyingtaxonomicname>
60
                                        </taxonpath>
61
                                    </canon_taxonpath_id>
60
                                        </taxonconcept>
61
                                    </canon_taxonconcept_id>
62 62
                                    <author>$SpeciesAuthority</author>
63 63
                                    <family>$Family</family>
64 64
                                    <genus>$Genus</genus>
65 65
                                    <species>$SpeciesName</species>
66 66
                                    <subspecies>$SubSpeciesName</subspecies>
67
                                </taxonpath>
68
                            </taxonpath_id>
67
                                </taxonconcept>
68
                            </taxonconcept_id>
69 69
                        </taxondetermination>
70 70
                    </taxonoccurrence>
71 71
                </locationevent>
inputs/CTFS/TaxonOccurrence/test.xml.ref
10 10
                    <taxonoccurrence>
11 11
                        <sourceaccessioncode>$SpeciesInvID</sourceaccessioncode>
12 12
                        <taxondetermination>
13
                            <taxonpath_id>
14
                                <taxonpath>
15
                                    <canon_taxonpath_id>
16
                                        <taxonpath>
13
                            <taxonconcept_id>
14
                                <taxonconcept>
15
                                    <canon_taxonconcept_id>
16
                                        <taxonconcept>
17 17
                                            <datasource_id><party><organizationname>TNRS</organizationname></party></datasource_id>
18 18
                                            <identifyingtaxonomicname>
19 19
                                                <_join_words>
......
23 23
                                                    <4>$SubSpeciesName</4>
24 24
                                                </_join_words>
25 25
                                            </identifyingtaxonomicname>
26
                                        </taxonpath>
27
                                    </canon_taxonpath_id>
26
                                        </taxonconcept>
27
                                    </canon_taxonconcept_id>
... This diff was truncated because it exceeds the maximum size that can be displayed.

Also available in: Unified diff