Project

General

Profile

« Previous | Next » 

Revision 5306

mappings/VegCore-VegBIEN.csv: taxonconcept: Moved infraspecific taxonconcept to its own level, rather than combining it with the level that contains the full taxonomic name and author (as well as any morphospecies), for consistency with the storage of other ranked taxonomic name components, which each get their own taxonconcept. The infraspecific taxon concept is general to all parties making idenfitications (within a datasource), while the concatenated name and author and any morphospecies are specific to the person who defined the taxonconcept used by a taxondetermination.

View differences:

inputs/MT/Specimen/VegBIEN.csv
15 15
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
16 16
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/family,
17 17
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus,
18
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname",
19
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname",
18
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname",
19
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname",
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
62 62
                                    <genus>$genus</genus>
63 63
                                    <parent_id>
64 64
                                        <taxonconcept>
65
                                            <rank>cultivar</rank>
66 65
                                            <parent_id>
67 66
                                                <taxonconcept>
68
                                                    <rank>forma</rank>
67
                                                    <rank>cultivar</rank>
69 68
                                                    <parent_id>
70 69
                                                        <taxonconcept>
71
                                                            <rank>variety</rank>
70
                                                            <rank>forma</rank>
72 71
                                                            <parent_id>
73 72
                                                                <taxonconcept>
74
                                                                    <rank>subspecies</rank>
73
                                                                    <rank>variety</rank>
75 74
                                                                    <parent_id>
76 75
                                                                        <taxonconcept>
77
                                                                            <rank>species</rank>
76
                                                                            <rank>subspecies</rank>
78 77
                                                                            <parent_id>
79 78
                                                                                <taxonconcept>
80
                                                                                    <rank>genus</rank>
81
                                                                                    <taxonname>$genus</taxonname>
79
                                                                                    <rank>species</rank>
82 80
                                                                                    <parent_id>
83 81
                                                                                        <taxonconcept>
84
                                                                                            <rank>family</rank>
85
                                                                                            <taxonname>$family</taxonname>
82
                                                                                            <rank>genus</rank>
83
                                                                                            <taxonname>$genus</taxonname>
84
                                                                                            <parent_id>
85
                                                                                                <taxonconcept>
86
                                                                                                    <rank>family</rank>
87
                                                                                                    <taxonname>$family</taxonname>
88
                                                                                                </taxonconcept>
89
                                                                                            </parent_id>
86 90
                                                                                        </taxonconcept>
87 91
                                                                                    </parent_id>
88 92
                                                                                </taxonconcept>
inputs/XAL/Specimen/VegBIEN.csv
35 35
darwin:IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/creator_id/_simplifyPath:[next=creator_id]/path/party/surname/_namePart/last,
36 36
darwin:Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/family,
37 37
darwin:Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus,
38
darwin:Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=subspecies]/taxonname",
39
darwin:Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonname",
40
darwin:Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname",
41
darwin:Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname",
42
darwin:Order,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=order]/taxonname",
43
darwin:Class,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=class]/taxonname",
44
darwin:Phylum,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=phylum]/taxonname",
45
darwin:Kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,phylum,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=kingdom]/taxonname",
38
darwin:Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=subspecies]/taxonname",
39
darwin:Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonname",
40
darwin:Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname",
41
darwin:Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname",
42
darwin:Order,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=order]/taxonname",
43
darwin:Class,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=class]/taxonname",
44
darwin:Phylum,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=phylum]/taxonname",
45
darwin:Kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,phylum,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=kingdom]/taxonname",
46 46
darwin:Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/species,
47 47
darwin:ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonomicname,
48 48
darwin:DayIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value",
inputs/TEAM/VL/VegBIEN.csv
25 25
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
26 26
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/family,
27 27
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus,
28
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonname",
29
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname",
30
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname",
28
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonname",
29
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname",
30
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname",
31 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 ** 
inputs/TEAM/VL/test.xml.ref
65 65
                                    <genus>$Genus</genus>
66 66
                                    <parent_id>
67 67
                                        <taxonconcept>
68
                                            <rank>cultivar</rank>
69 68
                                            <parent_id>
70 69
                                                <taxonconcept>
71
                                                    <rank>forma</rank>
70
                                                    <rank>cultivar</rank>
72 71
                                                    <parent_id>
73 72
                                                        <taxonconcept>
74
                                                            <rank>variety</rank>
73
                                                            <rank>forma</rank>
75 74
                                                            <parent_id>
76 75
                                                                <taxonconcept>
77
                                                                    <rank>subspecies</rank>
76
                                                                    <rank>variety</rank>
78 77
                                                                    <parent_id>
79 78
                                                                        <taxonconcept>
80
                                                                            <rank>species</rank>
81
                                                                            <taxonname>$Species</taxonname>
79
                                                                            <rank>subspecies</rank>
82 80
                                                                            <parent_id>
83 81
                                                                                <taxonconcept>
84
                                                                                    <rank>genus</rank>
85
                                                                                    <taxonname>$Genus</taxonname>
82
                                                                                    <rank>species</rank>
83
                                                                                    <taxonname>$Species</taxonname>
86 84
                                                                                    <parent_id>
87 85
                                                                                        <taxonconcept>
88
                                                                                            <rank>family</rank>
89
                                                                                            <taxonname>$Family</taxonname>
86
                                                                                            <rank>genus</rank>
87
                                                                                            <taxonname>$Genus</taxonname>
88
                                                                                            <parent_id>
89
                                                                                                <taxonconcept>
90
                                                                                                    <rank>family</rank>
91
                                                                                                    <taxonname>$Family</taxonname>
92
                                                                                                </taxonconcept>
93
                                                                                            </parent_id>
90 94
                                                                                        </taxonconcept>
91 95
                                                                                    </parent_id>
92 96
                                                                                </taxonconcept>
inputs/TEAM/VT/VegBIEN.csv
25 25
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
26 26
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/family,
27 27
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus,
28
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonname",
29
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname",
30
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname",
28
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonname",
29
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname",
30
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname",
31 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 ** 
inputs/TEAM/VT/test.xml.ref
65 65
                                    <genus>$Genus</genus>
66 66
                                    <parent_id>
67 67
                                        <taxonconcept>
68
                                            <rank>cultivar</rank>
69 68
                                            <parent_id>
70 69
                                                <taxonconcept>
71
                                                    <rank>forma</rank>
70
                                                    <rank>cultivar</rank>
72 71
                                                    <parent_id>
73 72
                                                        <taxonconcept>
74
                                                            <rank>variety</rank>
73
                                                            <rank>forma</rank>
75 74
                                                            <parent_id>
76 75
                                                                <taxonconcept>
77
                                                                    <rank>subspecies</rank>
76
                                                                    <rank>variety</rank>
78 77
                                                                    <parent_id>
79 78
                                                                        <taxonconcept>
80
                                                                            <rank>species</rank>
81
                                                                            <taxonname>$Species</taxonname>
79
                                                                            <rank>subspecies</rank>
82 80
                                                                            <parent_id>
83 81
                                                                                <taxonconcept>
84
                                                                                    <rank>genus</rank>
85
                                                                                    <taxonname>$Genus</taxonname>
82
                                                                                    <rank>species</rank>
83
                                                                                    <taxonname>$Species</taxonname>
86 84
                                                                                    <parent_id>
87 85
                                                                                        <taxonconcept>
88
                                                                                            <rank>family</rank>
89
                                                                                            <taxonname>$Family</taxonname>
86
                                                                                            <rank>genus</rank>
87
                                                                                            <taxonname>$Genus</taxonname>
88
                                                                                            <parent_id>
89
                                                                                                <taxonconcept>
90
                                                                                                    <rank>family</rank>
91
                                                                                                    <taxonname>$Family</taxonname>
92
                                                                                                </taxonconcept>
93
                                                                                            </parent_id>
90 94
                                                                                        </taxonconcept>
91 95
                                                                                    </parent_id>
92 96
                                                                                </taxonconcept>
inputs/NY/Specimen/VegBIEN.csv
40 40
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/creator_id/_simplifyPath:[next=creator_id]/path/party/surname/_namePart/last,
41 41
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/family,
42 42
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus,
43
Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=subspecies]/taxonname",
44
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonname",
45
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname",
46
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname",
47
Order,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=order]/taxonname",
48
Class,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=class]/taxonname",
49
Phylum,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=phylum]/taxonname",
50
Kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,phylum,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=kingdom]/taxonname",
43
Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=subspecies]/taxonname",
44
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonname",
45
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname",
46
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname",
47
Order,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=order]/taxonname",
48
Class,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=class]/taxonname",
49
Phylum,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=phylum]/taxonname",
50
Kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,phylum,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=kingdom]/taxonname",
51 51
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/species,
52 52
ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonomicname,
53 53
DayIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value",
inputs/NY/Specimen/test.xml.ref
160 160
                                    <genus>$Genus</genus>
161 161
                                    <parent_id>
162 162
                                        <taxonconcept>
163
                                            <rank>cultivar</rank>
164 163
                                            <parent_id>
165 164
                                                <taxonconcept>
166
                                                    <rank>forma</rank>
165
                                                    <rank>cultivar</rank>
167 166
                                                    <parent_id>
168 167
                                                        <taxonconcept>
169
                                                            <rank>variety</rank>
168
                                                            <rank>forma</rank>
170 169
                                                            <parent_id>
171 170
                                                                <taxonconcept>
172
                                                                    <rank>subspecies</rank>
173
                                                                    <taxonname>$Subspecies</taxonname>
171
                                                                    <rank>variety</rank>
174 172
                                                                    <parent_id>
175 173
                                                                        <taxonconcept>
176
                                                                            <rank>species</rank>
177
                                                                            <taxonname>$Species</taxonname>
174
                                                                            <rank>subspecies</rank>
175
                                                                            <taxonname>$Subspecies</taxonname>
178 176
                                                                            <parent_id>
179 177
                                                                                <taxonconcept>
180
                                                                                    <rank>genus</rank>
181
                                                                                    <taxonname>$Genus</taxonname>
178
                                                                                    <rank>species</rank>
179
                                                                                    <taxonname>$Species</taxonname>
182 180
                                                                                    <parent_id>
183 181
                                                                                        <taxonconcept>
184
                                                                                            <rank>family</rank>
185
                                                                                            <taxonname>$Family</taxonname>
182
                                                                                            <rank>genus</rank>
183
                                                                                            <taxonname>$Genus</taxonname>
186 184
                                                                                            <parent_id>
187 185
                                                                                                <taxonconcept>
188
                                                                                                    <rank>order</rank>
189
                                                                                                    <taxonname>$Order</taxonname>
186
                                                                                                    <rank>family</rank>
187
                                                                                                    <taxonname>$Family</taxonname>
190 188
                                                                                                    <parent_id>
191 189
                                                                                                        <taxonconcept>
192
                                                                                                            <rank>class</rank>
193
                                                                                                            <taxonname>$Class</taxonname>
190
                                                                                                            <rank>order</rank>
191
                                                                                                            <taxonname>$Order</taxonname>
194 192
                                                                                                            <parent_id>
195 193
                                                                                                                <taxonconcept>
196
                                                                                                                    <rank>phylum</rank>
197
                                                                                                                    <taxonname>$Phylum</taxonname>
194
                                                                                                                    <rank>class</rank>
195
                                                                                                                    <taxonname>$Class</taxonname>
198 196
                                                                                                                    <parent_id>
199 197
                                                                                                                        <taxonconcept>
200
                                                                                                                            <rank>kingdom</rank>
201
                                                                                                                            <taxonname>$Kingdom</taxonname>
198
                                                                                                                            <rank>phylum</rank>
199
                                                                                                                            <taxonname>$Phylum</taxonname>
200
                                                                                                                            <parent_id>
201
                                                                                                                                <taxonconcept>
202
                                                                                                                                    <rank>kingdom</rank>
203
                                                                                                                                    <taxonname>$Kingdom</taxonname>
204
                                                                                                                                </taxonconcept>
205
                                                                                                                            </parent_id>
202 206
                                                                                                                        </taxonconcept>
203 207
                                                                                                                    </parent_id>
204 208
                                                                                                                </taxonconcept>
inputs/Madidi/Organism/VegBIEN.csv
44 44
Determined by,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/creator_id/_simplifyPath:[next=creator_id]/path/party/surname/_namePart/last,
45 45
Family (revised),/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/family,
46 46
Genera,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus,
47
Specific epithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonname",
48
Genera,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname",
49
Family (revised),"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname",
47
Specific epithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonname",
48
Genera,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname",
49
Family (revised),"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname",
50 50
Specific epithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/species,
51 51
Species and morphotypes,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonomicname,"Contains less than ""Specie+autor"""
52 52
Specie+autor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonomicnamewithauthor,
......
55 55
Field name,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/canon_taxonconcept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2,Often = Genera
56 56
Field family,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/family,
57 57
Field name,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/genus,Often = Genera
58
Field name,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname",Often = Genera
59
Field family,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname",
58
Field name,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname",Often = Genera
59
Field family,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname",
60 60
Index collector,/location/locationevent/taxonoccurrence/verbatimcollectorname,
61 61
Specimen,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then",
62 62
Basal area,,"** No join mapping for *Basal area ** Would be basalDiameter, but need formula to translate"
inputs/Madidi/Organism/test.xml.ref
119 119
                                    <genus>$Genera</genus>
120 120
                                    <parent_id>
121 121
                                        <taxonconcept>
122
                                            <rank>cultivar</rank>
123 122
                                            <parent_id>
124 123
                                                <taxonconcept>
125
                                                    <rank>forma</rank>
124
                                                    <rank>cultivar</rank>
126 125
                                                    <parent_id>
127 126
                                                        <taxonconcept>
128
                                                            <rank>variety</rank>
127
                                                            <rank>forma</rank>
129 128
                                                            <parent_id>
130 129
                                                                <taxonconcept>
131
                                                                    <rank>subspecies</rank>
130
                                                                    <rank>variety</rank>
132 131
                                                                    <parent_id>
133 132
                                                                        <taxonconcept>
134
                                                                            <rank>species</rank>
135
                                                                            <taxonname>$Specific epithet</taxonname>
133
                                                                            <rank>subspecies</rank>
136 134
                                                                            <parent_id>
137 135
                                                                                <taxonconcept>
138
                                                                                    <rank>genus</rank>
139
                                                                                    <taxonname>$Genera</taxonname>
136
                                                                                    <rank>species</rank>
137
                                                                                    <taxonname>$Specific epithet</taxonname>
140 138
                                                                                    <parent_id>
141 139
                                                                                        <taxonconcept>
142
                                                                                            <rank>family</rank>
143
                                                                                            <taxonname>$Family (revised)</taxonname>
140
                                                                                            <rank>genus</rank>
141
                                                                                            <taxonname>$Genera</taxonname>
142
                                                                                            <parent_id>
143
                                                                                                <taxonconcept>
144
                                                                                                    <rank>family</rank>
145
                                                                                                    <taxonname>$Family (revised)</taxonname>
146
                                                                                                </taxonconcept>
147
                                                                                            </parent_id>
144 148
                                                                                        </taxonconcept>
145 149
                                                                                    </parent_id>
146 150
                                                                                </taxonconcept>
......
186 190
                                    <genus>$Field name</genus>
187 191
                                    <parent_id>
188 192
                                        <taxonconcept>
189
                                            <rank>cultivar</rank>
190 193
                                            <parent_id>
191 194
                                                <taxonconcept>
192
                                                    <rank>forma</rank>
195
                                                    <rank>cultivar</rank>
193 196
                                                    <parent_id>
194 197
                                                        <taxonconcept>
195
                                                            <rank>variety</rank>
198
                                                            <rank>forma</rank>
196 199
                                                            <parent_id>
197 200
                                                                <taxonconcept>
198
                                                                    <rank>subspecies</rank>
201
                                                                    <rank>variety</rank>
199 202
                                                                    <parent_id>
200 203
                                                                        <taxonconcept>
201
                                                                            <rank>species</rank>
204
                                                                            <rank>subspecies</rank>
202 205
                                                                            <parent_id>
203 206
                                                                                <taxonconcept>
204
                                                                                    <rank>genus</rank>
205
                                                                                    <taxonname>$Field name</taxonname>
207
                                                                                    <rank>species</rank>
206 208
                                                                                    <parent_id>
207 209
                                                                                        <taxonconcept>
208
                                                                                            <rank>family</rank>
209
                                                                                            <taxonname>$Field family</taxonname>
210
                                                                                            <rank>genus</rank>
211
                                                                                            <taxonname>$Field name</taxonname>
212
                                                                                            <parent_id>
213
                                                                                                <taxonconcept>
214
                                                                                                    <rank>family</rank>
215
                                                                                                    <taxonname>$Field family</taxonname>
216
                                                                                                </taxonconcept>
217
                                                                                            </parent_id>
210 218
                                                                                        </taxonconcept>
211 219
                                                                                    </parent_id>
212 220
                                                                                </taxonconcept>
inputs/UNCC/Specimen/VegBIEN.csv
54 54
authors,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/author,
55 55
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/family,
56 56
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus,
57
species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonname",
58
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname",
59
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname",
57
species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonname",
58
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname",
59
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname",
60
usdaRank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/rank/_alt/1,
61
infrarank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/rank/_alt/2,
62
infraname,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/taxonname,
63
usdaRank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/verbatimrank/_alt/1,
64
infrarank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/verbatimrank/_alt/2,
60 65
usdaRank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/rank/_alt/1,
61 66
infrarank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/rank/_alt/2,
62 67
species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/species,
63
infraname,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonname/_alt/1,
64 68
SciName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonomicname,
65 69
usdaRank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/verbatimrank/_alt/1,
66 70
infrarank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/verbatimrank/_alt/2,
inputs/UNCC/Specimen/test.xml.ref
120 120
                                    <genus>$genus</genus>
121 121
                                    <parent_id>
122 122
                                        <taxonconcept>
123
                                            <rank>cultivar</rank>
124 123
                                            <parent_id>
125 124
                                                <taxonconcept>
126
                                                    <rank>forma</rank>
125
                                                    <rank>cultivar</rank>
127 126
                                                    <parent_id>
128 127
                                                        <taxonconcept>
129
                                                            <rank>variety</rank>
128
                                                            <rank>forma</rank>
130 129
                                                            <parent_id>
131 130
                                                                <taxonconcept>
132
                                                                    <rank>subspecies</rank>
131
                                                                    <rank>variety</rank>
133 132
                                                                    <parent_id>
134 133
                                                                        <taxonconcept>
135
                                                                            <rank>species</rank>
136
                                                                            <taxonname>$species</taxonname>
134
                                                                            <rank>subspecies</rank>
137 135
                                                                            <parent_id>
138 136
                                                                                <taxonconcept>
139
                                                                                    <rank>genus</rank>
140
                                                                                    <taxonname>$genus</taxonname>
137
                                                                                    <rank>species</rank>
138
                                                                                    <taxonname>$species</taxonname>
141 139
                                                                                    <parent_id>
142 140
                                                                                        <taxonconcept>
143
                                                                                            <rank>family</rank>
144
                                                                                            <taxonname>$family</taxonname>
141
                                                                                            <rank>genus</rank>
142
                                                                                            <taxonname>$genus</taxonname>
143
                                                                                            <parent_id>
144
                                                                                                <taxonconcept>
145
                                                                                                    <rank>family</rank>
146
                                                                                                    <taxonname>$family</taxonname>
147
                                                                                                </taxonconcept>
148
                                                                                            </parent_id>
145 149
                                                                                        </taxonconcept>
146 150
                                                                                    </parent_id>
147 151
                                                                                </taxonconcept>
......
154 158
                                                    </parent_id>
155 159
                                                </taxonconcept>
156 160
                                            </parent_id>
161
                                            <rank>
162
                                                <_alt>
163
                                                    <1>$usdaRank</1>
164
                                                    <2>$infrarank</2>
165
                                                </_alt>
166
                                            </rank>
167
                                            <taxonname>$infraname</taxonname>
168
                                            <verbatimrank>
169
                                                <_alt>
170
                                                    <1>$usdaRank</1>
171
                                                    <2>$infrarank</2>
172
                                                </_alt>
173
                                            </verbatimrank>
157 174
                                        </taxonconcept>
158 175
                                    </parent_id>
159 176
                                    <rank>
......
163 180
                                        </_alt>
164 181
                                    </rank>
165 182
                                    <species>$species</species>
166
                                    <taxonname>$infraname</taxonname>
167 183
                                    <taxonomicname>$SciName</taxonomicname>
168 184
                                    <verbatimrank>
169 185
                                        <_alt>
inputs/GBIF/Specimen/test.xml.ref
100 100
                                    <genus>$Genus</genus>
101 101
                                    <parent_id>
102 102
                                        <taxonconcept>
103
                                            <rank>cultivar</rank>
104 103
                                            <parent_id>
105 104
                                                <taxonconcept>
106
                                                    <rank>forma</rank>
105
                                                    <rank>cultivar</rank>
107 106
                                                    <parent_id>
108 107
                                                        <taxonconcept>
109
                                                            <rank>variety</rank>
108
                                                            <rank>forma</rank>
110 109
                                                            <parent_id>
111 110
                                                                <taxonconcept>
112
                                                                    <rank>subspecies</rank>
111
                                                                    <rank>variety</rank>
113 112
                                                                    <parent_id>
114 113
                                                                        <taxonconcept>
115
                                                                            <rank>species</rank>
116
                                                                            <taxonname>$SpecificEpithet</taxonname>
114
                                                                            <rank>subspecies</rank>
117 115
                                                                            <parent_id>
118 116
                                                                                <taxonconcept>
119
                                                                                    <rank>genus</rank>
120
                                                                                    <taxonname>$Genus</taxonname>
117
                                                                                    <rank>species</rank>
118
                                                                                    <taxonname>$SpecificEpithet</taxonname>
121 119
                                                                                    <parent_id>
122 120
                                                                                        <taxonconcept>
123
                                                                                            <rank>family</rank>
124
                                                                                            <taxonname>$Family</taxonname>
121
                                                                                            <rank>genus</rank>
122
                                                                                            <taxonname>$Genus</taxonname>
123
                                                                                            <parent_id>
124
                                                                                                <taxonconcept>
125
                                                                                                    <rank>family</rank>
126
                                                                                                    <taxonname>$Family</taxonname>
127
                                                                                                </taxonconcept>
128
                                                                                            </parent_id>
125 129
                                                                                        </taxonconcept>
126 130
                                                                                    </parent_id>
127 131
                                                                                </taxonconcept>
......
134 138
                                                    </parent_id>
135 139
                                                </taxonconcept>
136 140
                                            </parent_id>
141
                                            <taxonname>$InfraspecificEpithet</taxonname>
137 142
                                        </taxonconcept>
138 143
                                    </parent_id>
139 144
                                    <species>$SpecificEpithet</species>
140
                                    <taxonname>$InfraspecificEpithet</taxonname>
141 145
                                    <taxonomicname>$ScientificName</taxonomicname>
142 146
                                </taxonconcept>
143 147
                            </taxonconcept_id>
......
171 175
                                    <genus>$GBIFGenusOriginal</genus>
172 176
                                    <parent_id>
173 177
                                        <taxonconcept>
174
                                            <rank>cultivar</rank>
175 178
                                            <parent_id>
176 179
                                                <taxonconcept>
177
                                                    <rank>forma</rank>
180
                                                    <rank>cultivar</rank>
178 181
                                                    <parent_id>
179 182
                                                        <taxonconcept>
180
                                                            <rank>variety</rank>
183
                                                            <rank>forma</rank>
181 184
                                                            <parent_id>
182 185
                                                                <taxonconcept>
183
                                                                    <rank>subspecies</rank>
186
                                                                    <rank>variety</rank>
184 187
                                                                    <parent_id>
185 188
                                                                        <taxonconcept>
186
                                                                            <rank>species</rank>
189
                                                                            <rank>subspecies</rank>
187 190
                                                                            <parent_id>
188 191
                                                                                <taxonconcept>
189
                                                                                    <rank>genus</rank>
190
                                                                                    <taxonname>$GBIFGenusOriginal</taxonname>
192
                                                                                    <rank>species</rank>
191 193
                                                                                    <parent_id>
192 194
                                                                                        <taxonconcept>
193
                                                                                            <rank>family</rank>
194
                                                                                            <taxonname>$GBIFFamilyOriginal</taxonname>
195
                                                                                            <rank>genus</rank>
196
                                                                                            <taxonname>$GBIFGenusOriginal</taxonname>
197
                                                                                            <parent_id>
198
                                                                                                <taxonconcept>
199
                                                                                                    <rank>family</rank>
200
                                                                                                    <taxonname>$GBIFFamilyOriginal</taxonname>
201
                                                                                                </taxonconcept>
202
                                                                                            </parent_id>
195 203
                                                                                        </taxonconcept>
196 204
                                                                                    </parent_id>
197 205
                                                                                </taxonconcept>
......
227 235
        </path>
228 236
    </_simplifyPath>
229 237
</VegBIEN>
230
Inserted 37 new rows into database
238
Inserted 39 new rows into database
inputs/MO/Specimen/VegBIEN.csv
34 34
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/creator_id/_simplifyPath:[next=creator_id]/path/party/surname/_namePart/last,
35 35
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/family,
36 36
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus,
37
Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=subspecies]/taxonname",
38
species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonname",
39
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname",
40
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname",
41
Kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,phylum,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=kingdom]/taxonname",
37
Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=subspecies]/taxonname",
38
species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonname",
39
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname",
40
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname",
41
Kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,phylum,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=kingdom]/taxonname",
42 42
species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/species,
43 43
ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonomicname,
44 44
Collector,/location/locationevent/taxonoccurrence/verbatimcollectorname,
inputs/VegBank/taxonobservation_/test.xml.ref
52 52
                                    <genus>$Genus</genus>
53 53
                                    <parent_id>
54 54
                                        <taxonconcept>
55
                                            <rank>cultivar</rank>
56 55
                                            <parent_id>
57 56
                                                <taxonconcept>
58
                                                    <rank>forma</rank>
59
                                                    <taxonname>$Forma</taxonname>
57
                                                    <rank>cultivar</rank>
60 58
                                                    <parent_id>
61 59
                                                        <taxonconcept>
62
                                                            <rank>variety</rank>
63
                                                            <taxonname>$Variety</taxonname>
60
                                                            <rank>forma</rank>
61
                                                            <taxonname>$Forma</taxonname>
64 62
                                                            <parent_id>
65 63
                                                                <taxonconcept>
66
                                                                    <rank>subspecies</rank>
67
                                                                    <taxonname>$Subspecies</taxonname>
64
                                                                    <rank>variety</rank>
65
                                                                    <taxonname>$Variety</taxonname>
68 66
                                                                    <parent_id>
69 67
                                                                        <taxonconcept>
70
                                                                            <rank>species</rank>
71
                                                                            <taxonname>$Species</taxonname>
68
                                                                            <rank>subspecies</rank>
69
                                                                            <taxonname>$Subspecies</taxonname>
72 70
                                                                            <parent_id>
73 71
                                                                                <taxonconcept>
74
                                                                                    <rank>genus</rank>
75
                                                                                    <taxonname>$Genus</taxonname>
72
                                                                                    <rank>species</rank>
73
                                                                                    <taxonname>$Species</taxonname>
76 74
                                                                                    <parent_id>
77 75
                                                                                        <taxonconcept>
78
                                                                                            <rank>family</rank>
79
                                                                                            <taxonname>$Family</taxonname>
76
                                                                                            <rank>genus</rank>
77
                                                                                            <taxonname>$Genus</taxonname>
80 78
                                                                                            <parent_id>
81 79
                                                                                                <taxonconcept>
82
                                                                                                    <rank>order</rank>
83
                                                                                                    <taxonname>$Order</taxonname>
80
                                                                                                    <rank>family</rank>
81
                                                                                                    <taxonname>$Family</taxonname>
84 82
                                                                                                    <parent_id>
85 83
                                                                                                        <taxonconcept>
86
                                                                                                            <rank>class</rank>
87
                                                                                                            <taxonname>$Class</taxonname>
84
                                                                                                            <rank>order</rank>
85
                                                                                                            <taxonname>$Order</taxonname>
88 86
                                                                                                            <parent_id>
89 87
                                                                                                                <taxonconcept>
90
                                                                                                                    <rank>phylum</rank>
88
                                                                                                                    <rank>class</rank>
89
                                                                                                                    <taxonname>$Class</taxonname>
91 90
                                                                                                                    <parent_id>
92 91
                                                                                                                        <taxonconcept>
93
                                                                                                                            <rank>kingdom</rank>
94
                                                                                                                            <taxonname>$Kingdom</taxonname>
92
                                                                                                                            <rank>phylum</rank>
93
                                                                                                                            <parent_id>
94
                                                                                                                                <taxonconcept>
95
                                                                                                                                    <rank>kingdom</rank>
96
                                                                                                                                    <taxonname>$Kingdom</taxonname>
97
                                                                                                                                </taxonconcept>
98
                                                                                                                            </parent_id>
95 99
                                                                                                                        </taxonconcept>
96 100
                                                                                                                    </parent_id>
97 101
                                                                                                                </taxonconcept>
inputs/SALVIAS/plotObservations/VegBIEN.csv
67 67
auth,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/author,Brad: This is the author of the scientificName.
68 68
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/family,
69 69
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus,
70
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonname",
71
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname",
72
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname",
70
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonname",
71
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname",
72
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname",
73
infra_rank_1,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/rank,
74
infra_ep_1,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/taxonname,
75
infra_rank_1,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/verbatimrank,
73 76
infra_rank_1,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/rank,
74 77
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/species,
75
infra_ep_1,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonname/_alt/1,
76 78
infra_rank_1,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/verbatimrank,
77 79
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."
78 80
OrigFamily,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/canon_taxonconcept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,Brad: OMIT
......
80 82
OrigSpecies,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/canon_taxonconcept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3,Brad: OMIT
81 83
OrigFamily,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/family,Brad: OMIT
82 84
OrigGenus,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/genus,
83
OrigSpecies,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonname",Brad: OMIT
84
OrigGenus,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname",
85
OrigFamily,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname",Brad: OMIT
85
OrigSpecies,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonname",Brad: OMIT
86
OrigGenus,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname",
87
OrigFamily,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname",Brad: OMIT
86 88
OrigSpecies,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/species,Brad: OMIT
87 89
coll_firstname,/location/locationevent/taxonoccurrence/verbatimcollectorname/_join_words/1,Brad: See comment above
88 90
coll_lastname,/location/locationevent/taxonoccurrence/verbatimcollectorname/_join_words/2,"Brad: This is the collector of a separate specimen which vouchers this tree or species. I worry that vouchers are not properly accommodated in VegX. Again, we need to check with Nick."
inputs/.TNRS/tnrs/VegBIEN.csv
16 16
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,
17 17
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",
18 18
Accepted_name_author,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_set_canon_taxonconcept/canon_taxonconcept_id/taxonconcept/identifyingtaxonomicname/_alt/2/_join_words/2,
19
Accepted_name_family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_set_canon_taxonconcept/canon_taxonconcept_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname",
19
Accepted_name_family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_set_canon_taxonconcept/canon_taxonconcept_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname",
20
Accepted_name_rank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_set_canon_taxonconcept/canon_taxonconcept_id/taxonconcept/parent_id/taxonconcept/rank,
21
Accepted_name_rank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_set_canon_taxonconcept/canon_taxonconcept_id/taxonconcept/parent_id/taxonconcept/verbatimrank,
20 22
Accepted_name_rank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_set_canon_taxonconcept/canon_taxonconcept_id/taxonconcept/rank,
21 23
Accepted_name,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_set_canon_taxonconcept/canon_taxonconcept_id/taxonconcept/taxonomicname,
22 24
Accepted_name_rank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_set_canon_taxonconcept/canon_taxonconcept_id/taxonconcept/verbatimrank,
23 25
Name_matched_author,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/author,Contains author based on matched name
24 26
Name_matched_accepted_family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/family,Contains family based on matched name
25 27
Genus_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus,
26
Specific_epithet_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonname",
27
Genus_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname",
28
Name_matched_accepted_family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname",Contains family based on matched name
28
Specific_epithet_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonname",
29
Genus_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname",
30
Name_matched_accepted_family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname",Contains family based on matched name
31
Name_matched_rank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/rank,
32
Infraspecific_epithet_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/taxonname,
33
Name_matched_rank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/verbatimrank,
29 34
Name_matched_rank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/rank,
30 35
Specific_epithet_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/species,
31 36
Author_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonconcept:[@fkey=canon_taxonconcept_id]/author,Contains author in original string
32 37
Family_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonconcept:[@fkey=canon_taxonconcept_id]/family,Contains family in original string (uncommon)
33 38
Genus_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonconcept:[@fkey=canon_taxonconcept_id]/genus,
34 39
Name_submitted,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonconcept:[@fkey=canon_taxonconcept_id]/identifyingtaxonomicname,
35
Specific_epithet_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonconcept:[@fkey=canon_taxonconcept_id]/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonname",
36
Genus_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonconcept:[@fkey=canon_taxonconcept_id]/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname",
37
Family_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonconcept:[@fkey=canon_taxonconcept_id]/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname",Contains family in original string (uncommon)
40
Specific_epithet_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonconcept:[@fkey=canon_taxonconcept_id]/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonname",
41
Genus_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonconcept:[@fkey=canon_taxonconcept_id]/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname",
42
Family_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonconcept:[@fkey=canon_taxonconcept_id]/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname",Contains family in original string (uncommon)
43
Infraspecific_epithet_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonconcept:[@fkey=canon_taxonconcept_id]/parent_id/taxonconcept/taxonname,
44
Infraspecific_rank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonconcept:[@fkey=canon_taxonconcept_id]/parent_id/taxonconcept/verbatimrank,
38 45
Specific_epithet_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonconcept:[@fkey=canon_taxonconcept_id]/species,
39
Infraspecific_epithet_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonconcept:[@fkey=canon_taxonconcept_id]/taxonname/_alt/1,
40
Name_submitted,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonconcept:[@fkey=canon_taxonconcept_id]/taxonname/_alt/2/_if[@name=""if has verbatim name""]/cond/_exists",
41
Unmatched_terms,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonconcept:[@fkey=canon_taxonconcept_id]/taxonname/_alt/2/_if[@name=""if has verbatim name""]/then",
46
Name_submitted,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonconcept:[@fkey=canon_taxonconcept_id]/taxonname/_if[@name=""if has verbatim name""]/cond/_exists",
47
Unmatched_terms,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonconcept:[@fkey=canon_taxonconcept_id]/taxonname/_if[@name=""if has verbatim name""]/then",
42 48
Name_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonconcept:[@fkey=canon_taxonconcept_id]/taxonomicname,
43 49
Name_submitted,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonconcept:[@fkey=canon_taxonconcept_id]/taxonomicnamewithauthor,
44 50
Infraspecific_rank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonconcept:[@fkey=canon_taxonconcept_id]/verbatimrank,
45
Infraspecific_epithet_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonname/_alt/1,
46
Name_submitted,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonname/_alt/2/_if[@name=""if has verbatim name""]/cond/_exists",
47
Unmatched_terms,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonname/_alt/2/_if[@name=""if has verbatim name""]/else",
51
Name_submitted,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonname/_if[@name=""if has verbatim name""]/cond/_exists",
52
Unmatched_terms,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonname/_if[@name=""if has verbatim name""]/else",
48 53
Name_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonomicname,
49 54
Name_matched_rank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/verbatimrank,
50 55
Accepted_name_lsid,,** No non-empty join mapping for OMIT ** 
inputs/U/Specimen/VegBIEN.csv
23 23
Detby,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/creator_id/_simplifyPath:[next=creator_id]/path/party/surname/_namePart/last,
24 24
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/family,
25 25
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus,
26
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname",
27
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname",
26
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname",
27
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname",
28 28
Detyy,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value",
29 29
cf,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/taxonfit,
30 30
Collector,/location/locationevent/taxonoccurrence/verbatimcollectorname/_join/1,
inputs/ARIZ/Specimen/VegBIEN.csv
43 43
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/creator_id/_simplifyPath:[next=creator_id]/path/party/surname/_namePart/last,
44 44
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/family,
45 45
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus,
46
Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=subspecies]/taxonname",
47
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonname",
48
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname",
49
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname",
50
Order,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=order]/taxonname",
51
Class,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=class]/taxonname",
52
Phylum,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=phylum]/taxonname",
53
Kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,phylum,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=kingdom]/taxonname",
46
Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=subspecies]/taxonname",
47
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonname",
48
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname",
49
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname",
50
Order,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=order]/taxonname",
51
Class,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=class]/taxonname",
52
Phylum,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=phylum]/taxonname",
53
Kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,phylum,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=kingdom]/taxonname",
54 54
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/species,
55 55
ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonomicname,
56 56
ScientificNameAuthor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonomicnamewithauthor,Contains the binomial in addition to the authority
inputs/GBIF/Specimen/VegBIEN.csv
29 29
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/creator_id/_simplifyPath:[next=creator_id]/path/party/surname/_namePart/last,
30 30
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/family,
31 31
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus,
32
SpecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonname",
33
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname",
34
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname",
32
SpecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonname",
33
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname",
34
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname",
35
InfraspecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/taxonname,
35 36
SpecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/species,
36
InfraspecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonname/_alt/1,
37 37
ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonomicname,
38 38
ScientificNameOriginal,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/canon_taxonconcept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1,
39 39
GBIFFamilyOriginal,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/canon_taxonconcept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,
40 40
GBIFGenusOriginal,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/canon_taxonconcept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2,
41 41
GBIFFamilyOriginal,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/family,
42 42
GBIFGenusOriginal,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/genus,
43
GBIFGenusOriginal,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname",
44
GBIFFamilyOriginal,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname",
43
GBIFGenusOriginal,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname",
44
GBIFFamilyOriginal,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname",
45 45
ScientificNameOriginal,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/taxonomicname,
46 46
Collector,/location/locationevent/taxonoccurrence/verbatimcollectorname,
47 47
CatalogNO,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then",
inputs/SpeciesLink/Specimen/test.xml.ref
383 383
                                    </genus>
384 384
                                    <parent_id>
385 385
                                        <taxonconcept>
386
                                            <rank>cultivar</rank>
387 386
                                            <parent_id>
388 387
                                                <taxonconcept>
389
                                                    <rank>forma</rank>
388
                                                    <rank>cultivar</rank>
390 389
                                                    <parent_id>
391 390
                                                        <taxonconcept>
392
                                                            <rank>variety</rank>
391
                                                            <rank>forma</rank>
393 392
                                                            <parent_id>
394 393
                                                                <taxonconcept>
395
                                                                    <rank>subspecies</rank>
396
                                                                    <taxonname>$conceptual_darwin_2003_1_0_Subspecies</taxonname>
394
                                                                    <rank>variety</rank>
397 395
                                                                    <parent_id>
398 396
                                                                        <taxonconcept>
399
                                                                            <rank>species</rank>
400
                                                                            <taxonname>
401
                                                                                <_alt>
402
                                                                                    <0>$conceptual_darwin_2003_1_0_Species</0>
403
                                                                                    <1>$dwc_dwcore_SpecificEpithet</1>
404
                                                                                    <2>$dwc_terms_specificEpithet</2>
405
                                                                                </_alt>
406
                                                                            </taxonname>
397
                                                                            <rank>subspecies</rank>
398
                                                                            <taxonname>$conceptual_darwin_2003_1_0_Subspecies</taxonname>
407 399
                                                                            <parent_id>
408 400
                                                                                <taxonconcept>
409
                                                                                    <rank>genus</rank>
401
                                                                                    <rank>species</rank>
410 402
                                                                                    <taxonname>
411 403
                                                                                        <_alt>
412
                                                                                            <0>$conceptual_darwin_2003_1_0_Genus</0>
413
                                                                                            <1>$dwc_dwcore_Genus</1>
414
                                                                                            <2>$dwc_terms_genus</2>
404
                                                                                            <0>$conceptual_darwin_2003_1_0_Species</0>
405
                                                                                            <1>$dwc_dwcore_SpecificEpithet</1>
406
                                                                                            <2>$dwc_terms_specificEpithet</2>
415 407
                                                                                        </_alt>
416 408
                                                                                    </taxonname>
417 409
                                                                                    <parent_id>
418 410
                                                                                        <taxonconcept>
419
                                                                                            <rank>family</rank>
411
                                                                                            <rank>genus</rank>
420 412
                                                                                            <taxonname>
421 413
                                                                                                <_alt>
422
                                                                                                    <0>$conceptual_darwin_2003_1_0_Family</0>
423
                                                                                                    <1>$dwc_dwcore_Family</1>
424
                                                                                                    <2>$dwc_terms_family</2>
414
                                                                                                    <0>$conceptual_darwin_2003_1_0_Genus</0>
415
                                                                                                    <1>$dwc_dwcore_Genus</1>
416
                                                                                                    <2>$dwc_terms_genus</2>
425 417
                                                                                                </_alt>
426 418
                                                                                            </taxonname>
427 419
                                                                                            <parent_id>
428 420
                                                                                                <taxonconcept>
429
                                                                                                    <rank>order</rank>
421
                                                                                                    <rank>family</rank>
430 422
                                                                                                    <taxonname>
431 423
                                                                                                        <_alt>
432
                                                                                                            <0>$conceptual_darwin_2003_1_0_Order</0>
433
                                                                                                            <1>$dwc_dwcore_Order</1>
434
                                                                                                            <2>$dwc_terms_order</2>
424
                                                                                                            <0>$conceptual_darwin_2003_1_0_Family</0>
425
                                                                                                            <1>$dwc_dwcore_Family</1>
426
                                                                                                            <2>$dwc_terms_family</2>
435 427
                                                                                                        </_alt>
436 428
                                                                                                    </taxonname>
437 429
                                                                                                    <parent_id>
438 430
                                                                                                        <taxonconcept>
439
                                                                                                            <rank>class</rank>
431
                                                                                                            <rank>order</rank>
440 432
                                                                                                            <taxonname>
441 433
                                                                                                                <_alt>
442
                                                                                                                    <0>$conceptual_darwin_2003_1_0_Class</0>
443
                                                                                                                    <1>$dwc_dwcore_Class</1>
444
                                                                                                                    <2>$dwc_terms_class</2>
434
                                                                                                                    <0>$conceptual_darwin_2003_1_0_Order</0>
435
                                                                                                                    <1>$dwc_dwcore_Order</1>
436
                                                                                                                    <2>$dwc_terms_order</2>
445 437
                                                                                                                </_alt>
446 438
                                                                                                            </taxonname>
447 439
                                                                                                            <parent_id>
448 440
                                                                                                                <taxonconcept>
449
                                                                                                                    <rank>phylum</rank>
441
                                                                                                                    <rank>class</rank>
450 442
                                                                                                                    <taxonname>
451 443
                                                                                                                        <_alt>
452
                                                                                                                            <0>$conceptual_darwin_2003_1_0_Phylum</0>
453
                                                                                                                            <1>$dwc_dwcore_Phylum</1>
454
                                                                                                                            <2>$dwc_terms_phylum</2>
444
                                                                                                                            <0>$conceptual_darwin_2003_1_0_Class</0>
445
                                                                                                                            <1>$dwc_dwcore_Class</1>
446
                                                                                                                            <2>$dwc_terms_class</2>
455 447
                                                                                                                        </_alt>
456 448
                                                                                                                    </taxonname>
457 449
                                                                                                                    <parent_id>
458 450
                                                                                                                        <taxonconcept>
459
                                                                                                                            <rank>kingdom</rank>
451
                                                                                                                            <rank>phylum</rank>
460 452
                                                                                                                            <taxonname>
461 453
                                                                                                                                <_alt>
462
                                                                                                                                    <0>$conceptual_darwin_2003_1_0_Kingdom</0>
463
                                                                                                                                    <1>$dwc_dwcore_Kingdom</1>
464
                                                                                                                                    <2>$dwc_terms_kingdom</2>
454
                                                                                                                                    <0>$conceptual_darwin_2003_1_0_Phylum</0>
455
                                                                                                                                    <1>$dwc_dwcore_Phylum</1>
456
                                                                                                                                    <2>$dwc_terms_phylum</2>
465 457
                                                                                                                                </_alt>
466 458
                                                                                                                            </taxonname>
459
                                                                                                                            <parent_id>
460
                                                                                                                                <taxonconcept>
461
                                                                                                                                    <rank>kingdom</rank>
462
                                                                                                                                    <taxonname>
463
                                                                                                                                        <_alt>
464
                                                                                                                                            <0>$conceptual_darwin_2003_1_0_Kingdom</0>
465
                                                                                                                                            <1>$dwc_dwcore_Kingdom</1>
466
                                                                                                                                            <2>$dwc_terms_kingdom</2>
467
                                                                                                                                        </_alt>
468
                                                                                                                                    </taxonname>
469
                                                                                                                                </taxonconcept>
470
                                                                                                                            </parent_id>
467 471
                                                                                                                        </taxonconcept>
468 472
                                                                                                                    </parent_id>
469 473
                                                                                                                </taxonconcept>
......
484 488
                                                    </parent_id>
485 489
                                                </taxonconcept>
486 490
                                            </parent_id>
491
                                            <taxonname>
492
                                                <_alt>
493
                                                    <0>$dwc_dwcore_InfraspecificEpithet</0>
494
                                                    <1>$dwc_terms_infraspecificEpithet</1>
495
                                                </_alt>
496
                                            </taxonname>
487 497
                                        </taxonconcept>
488 498
                                    </parent_id>
489 499
                                    <species>
......
493 503
                                            <2>$dwc_terms_specificEpithet</2>
494 504
                                        </_alt>
495 505
                                    </species>
496
                                    <taxonname>
497
                                        <_alt>
498
                                            <0>$dwc_dwcore_InfraspecificEpithet</0>
499
                                            <1>$dwc_terms_infraspecificEpithet</1>
500
                                        </_alt>
501
                                    </taxonname>
502 506
                                    <taxonomicname>
503 507
                                        <_alt>
504 508
                                            <0>$conceptual_darwin_2003_1_0_ScientificName</0>
inputs/VegBank/taxonobservation_/VegBIEN.csv
18 18
Forma,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/7/_join_words:[1=""fm. ""]/2",
19 19
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/family,
20 20
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus,
21
Forma,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=forma]/taxonname",
22
Variety,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=variety]/taxonname",
23
Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=subspecies]/taxonname",
24
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonname",
25
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname",
26
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname",
27
Order,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=order]/taxonname",
28
Class,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=class]/taxonname",
29
Kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,phylum,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=kingdom]/taxonname",
21
Forma,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=forma]/taxonname",
22
Variety,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=variety]/taxonname",
23
Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=subspecies]/taxonname",
24
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonname",
25
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname",
26
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname",
27
Order,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=order]/taxonname",
28
Class,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=class]/taxonname",
29
Kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,phylum,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=kingdom]/taxonname",
30 30
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/species,
31 31
interpretationdate,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/1/_*/date/_dateRangeStart/value,
32 32
taxonfit,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/taxonfit,
inputs/ACAD/Specimen/VegBIEN.csv
36 36
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/creator_id/_simplifyPath:[next=creator_id]/path/party/surname/_namePart/last,
37 37
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/family,
38 38
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus,
39
specificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonname",
40
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname",
41
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname",
42
order,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=order]/taxonname",
43
class,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=class]/taxonname",
44
phylum,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=phylum]/taxonname",
45
kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,phylum,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=kingdom]/taxonname",
39
specificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonname",
40
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname",
41
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname",
42
order,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=order]/taxonname",
43
class,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=class]/taxonname",
44
phylum,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=phylum]/taxonname",
45
kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,phylum,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=kingdom]/taxonname",
46
taxonRank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/rank,
47
infraspecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/taxonname,
48
taxonRank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/verbatimrank,
46 49
taxonRank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/rank,
47 50
specificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/species,
48
infraspecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonname/_alt/1,
49 51
scientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonomicnamewithauthor,
50 52
taxonRank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/verbatimrank,
51 53
dateIdentified,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/1/_*/date/_dateRangeStart/value,
inputs/ACAD/Specimen/test.xml.ref
130 130
                                    <genus>$genus</genus>
131 131
                                    <parent_id>
132 132
                                        <taxonconcept>
133
                                            <rank>cultivar</rank>
134 133
                                            <parent_id>
135 134
                                                <taxonconcept>
136
                                                    <rank>forma</rank>
135
                                                    <rank>cultivar</rank>
137 136
                                                    <parent_id>
138 137
                                                        <taxonconcept>
139
                                                            <rank>variety</rank>
138
                                                            <rank>forma</rank>
140 139
                                                            <parent_id>
141 140
                                                                <taxonconcept>
142
                                                                    <rank>subspecies</rank>
141
                                                                    <rank>variety</rank>
143 142
                                                                    <parent_id>
144 143
                                                                        <taxonconcept>
145
                                                                            <rank>species</rank>
146
                                                                            <taxonname>$specificEpithet</taxonname>
144
                                                                            <rank>subspecies</rank>
147 145
                                                                            <parent_id>
148 146
                                                                                <taxonconcept>
149
                                                                                    <rank>genus</rank>
150
                                                                                    <taxonname>$genus</taxonname>
147
                                                                                    <rank>species</rank>
148
                                                                                    <taxonname>$specificEpithet</taxonname>
151 149
                                                                                    <parent_id>
152 150
                                                                                        <taxonconcept>
153
                                                                                            <rank>family</rank>
154
                                                                                            <taxonname>$family</taxonname>
151
                                                                                            <rank>genus</rank>
152
                                                                                            <taxonname>$genus</taxonname>
155 153
                                                                                            <parent_id>
156 154
                                                                                                <taxonconcept>
157
                                                                                                    <rank>order</rank>
158
                                                                                                    <taxonname>$order</taxonname>
155
                                                                                                    <rank>family</rank>
156
                                                                                                    <taxonname>$family</taxonname>
159 157
                                                                                                    <parent_id>
160 158
                                                                                                        <taxonconcept>
161
                                                                                                            <rank>class</rank>
162
                                                                                                            <taxonname>$class</taxonname>
159
                                                                                                            <rank>order</rank>
160
                                                                                                            <taxonname>$order</taxonname>
163 161
                                                                                                            <parent_id>
164 162
                                                                                                                <taxonconcept>
165
                                                                                                                    <rank>phylum</rank>
166
                                                                                                                    <taxonname>$phylum</taxonname>
163
                                                                                                                    <rank>class</rank>
164
                                                                                                                    <taxonname>$class</taxonname>
167 165
                                                                                                                    <parent_id>
168 166
                                                                                                                        <taxonconcept>
169
                                                                                                                            <rank>kingdom</rank>
170
                                                                                                                            <taxonname>$kingdom</taxonname>
167
                                                                                                                            <rank>phylum</rank>
168
                                                                                                                            <taxonname>$phylum</taxonname>
169
                                                                                                                            <parent_id>
170
                                                                                                                                <taxonconcept>
171
                                                                                                                                    <rank>kingdom</rank>
172
                                                                                                                                    <taxonname>$kingdom</taxonname>
173
                                                                                                                                </taxonconcept>
174
                                                                                                                            </parent_id>
171 175
                                                                                                                        </taxonconcept>
172 176
                                                                                                                    </parent_id>
173 177
                                                                                                                </taxonconcept>
......
188 192
                                                    </parent_id>
189 193
                                                </taxonconcept>
190 194
                                            </parent_id>
195
                                            <rank>$taxonRank</rank>
196
                                            <taxonname>$infraspecificEpithet</taxonname>
197
                                            <verbatimrank>$taxonRank</verbatimrank>
191 198
                                        </taxonconcept>
192 199
                                    </parent_id>
193 200
                                    <rank>$taxonRank</rank>
194 201
                                    <species>$specificEpithet</species>
195
                                    <taxonname>$infraspecificEpithet</taxonname>
196 202
                                    <taxonomicnamewithauthor>$scientificName</taxonomicnamewithauthor>
197 203
                                    <verbatimrank>$taxonRank</verbatimrank>
198 204
                                </taxonconcept>
......
228 234
        </path>
229 235
    </_simplifyPath>
230 236
</VegBIEN>
231
Inserted 34 new rows into database
237
Inserted 35 new rows into database
inputs/SALVIAS-CSV/Organism/VegBIEN.csv
74 74
specific_authority,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/author,Brad: This is the author of the scientificName.
75 75
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/family,
76 76
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus,
77
specific_epithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonname",
78
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname",
79
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname",
77
specific_epithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonname",
78
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname",
79
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname",
80
infra_rank_1,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/rank,
81
infra_ep_1,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/taxonname,
82
infra_rank_1,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/verbatimrank,
80 83
infra_rank_1,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/rank,
81 84
specific_epithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/species,
82
infra_ep_1,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonname/_alt/1,
83 85
infra_rank_1,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/verbatimrank,
84 86
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."
85 87
orig_family,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/canon_taxonconcept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,Brad: OMIT
86 88
orig_species,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/canon_taxonconcept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3,Brad: OMIT
87 89
orig_family,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/family,Brad: OMIT
88
orig_species,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonname",Brad: OMIT
89
orig_family,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname",Brad: OMIT
90
orig_species,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonname",Brad: OMIT
91
orig_family,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname",Brad: OMIT
90 92
orig_species,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/species,Brad: OMIT
91 93
coll_firstname,/location/locationevent/taxonoccurrence/verbatimcollectorname/_join_words/1,Brad: See comment above
92 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."
inputs/SALVIAS-CSV/Organism/test.xml.ref
185 185
                                    <genus>$genus</genus>
186 186
                                    <parent_id>
187 187
                                        <taxonconcept>
188
                                            <rank>cultivar</rank>
189 188
                                            <parent_id>
190 189
                                                <taxonconcept>
191
                                                    <rank>forma</rank>
190
                                                    <rank>cultivar</rank>
192 191
                                                    <parent_id>
193 192
                                                        <taxonconcept>
194
                                                            <rank>variety</rank>
193
                                                            <rank>forma</rank>
195 194
                                                            <parent_id>
196 195
                                                                <taxonconcept>
197
                                                                    <rank>subspecies</rank>
196
                                                                    <rank>variety</rank>
198 197
                                                                    <parent_id>
199 198
                                                                        <taxonconcept>
200
                                                                            <rank>species</rank>
201
                                                                            <taxonname>$specific_epithet</taxonname>
199
                                                                            <rank>subspecies</rank>
202 200
                                                                            <parent_id>
203 201
                                                                                <taxonconcept>
204
                                                                                    <rank>genus</rank>
205
                                                                                    <taxonname>$genus</taxonname>
202
                                                                                    <rank>species</rank>
203
                                                                                    <taxonname>$specific_epithet</taxonname>
206 204
                                                                                    <parent_id>
207 205
                                                                                        <taxonconcept>
208
                                                                                            <rank>family</rank>
209
                                                                                            <taxonname>$family</taxonname>
206
                                                                                            <rank>genus</rank>
207
                                                                                            <taxonname>$genus</taxonname>
208
                                                                                            <parent_id>
209
                                                                                                <taxonconcept>
210
                                                                                                    <rank>family</rank>
211
                                                                                                    <taxonname>$family</taxonname>
212
                                                                                                </taxonconcept>
213
                                                                                            </parent_id>
210 214
                                                                                        </taxonconcept>
211 215
                                                                                    </parent_id>
212 216
                                                                                </taxonconcept>
......
219 223
                                                    </parent_id>
220 224
                                                </taxonconcept>
221 225
                                            </parent_id>
226
                                            <rank>$infra_rank_1</rank>
227
                                            <taxonname>$infra_ep_1</taxonname>
228
                                            <verbatimrank>$infra_rank_1</verbatimrank>
222 229
                                        </taxonconcept>
223 230
                                    </parent_id>
224 231
                                    <rank>$infra_rank_1</rank>
225 232
                                    <species>$specific_epithet</species>
226
                                    <taxonname>$infra_ep_1</taxonname>
227 233
                                    <verbatimrank>$infra_rank_1</verbatimrank>
228 234
                                </taxonconcept>
229 235
                            </taxonconcept_id>
......
252 258
                                    <family>$orig_family</family>
253 259
                                    <parent_id>
254 260
                                        <taxonconcept>
255
                                            <rank>cultivar</rank>
256 261
                                            <parent_id>
257 262
                                                <taxonconcept>
258
                                                    <rank>forma</rank>
263
                                                    <rank>cultivar</rank>
259 264
                                                    <parent_id>
260 265
                                                        <taxonconcept>
261
                                                            <rank>variety</rank>
266
                                                            <rank>forma</rank>
262 267
                                                            <parent_id>
263 268
                                                                <taxonconcept>
264
                                                                    <rank>subspecies</rank>
269
                                                                    <rank>variety</rank>
265 270
                                                                    <parent_id>
266 271
                                                                        <taxonconcept>
267
                                                                            <rank>species</rank>
268
                                                                            <taxonname>$orig_species</taxonname>
272
                                                                            <rank>subspecies</rank>
269 273
                                                                            <parent_id>
270 274
                                                                                <taxonconcept>
271
                                                                                    <rank>genus</rank>
275
                                                                                    <rank>species</rank>
276
                                                                                    <taxonname>$orig_species</taxonname>
272 277
                                                                                    <parent_id>
273 278
                                                                                        <taxonconcept>
274
                                                                                            <rank>family</rank>
275
                                                                                            <taxonname>$orig_family</taxonname>
279
                                                                                            <rank>genus</rank>
280
                                                                                            <parent_id>
281
                                                                                                <taxonconcept>
282
                                                                                                    <rank>family</rank>
283
                                                                                                    <taxonname>$orig_family</taxonname>
284
                                                                                                </taxonconcept>
285
                                                                                            </parent_id>
276 286
                                                                                        </taxonconcept>
277 287
                                                                                    </parent_id>
278 288
                                                                                </taxonconcept>
inputs/REMIB/Specimen/VegBIEN.csv
38 38
specificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
39 39
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/family,
40 40
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus,
41
specificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonname",
42
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname",
43
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname",
41
specificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonname",
42
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname",
43
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname",
44 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]
inputs/REMIB/Specimen/test.xml.ref
85 85
                                    <genus>$genus</genus>
86 86
                                    <parent_id>
87 87
                                        <taxonconcept>
88
                                            <rank>cultivar</rank>
89 88
                                            <parent_id>
90 89
                                                <taxonconcept>
91
                                                    <rank>forma</rank>
90
                                                    <rank>cultivar</rank>
92 91
                                                    <parent_id>
93 92
                                                        <taxonconcept>
94
                                                            <rank>variety</rank>
93
                                                            <rank>forma</rank>
95 94
                                                            <parent_id>
96 95
                                                                <taxonconcept>
97
                                                                    <rank>subspecies</rank>
96
                                                                    <rank>variety</rank>
98 97
                                                                    <parent_id>
99 98
                                                                        <taxonconcept>
100
                                                                            <rank>species</rank>
101
                                                                            <taxonname>$specificEpithet</taxonname>
99
                                                                            <rank>subspecies</rank>
102 100
                                                                            <parent_id>
103 101
                                                                                <taxonconcept>
104
                                                                                    <rank>genus</rank>
105
                                                                                    <taxonname>$genus</taxonname>
102
                                                                                    <rank>species</rank>
103
                                                                                    <taxonname>$specificEpithet</taxonname>
106 104
                                                                                    <parent_id>
107 105
                                                                                        <taxonconcept>
108
                                                                                            <rank>family</rank>
109
                                                                                            <taxonname>$family</taxonname>
106
                                                                                            <rank>genus</rank>
107
                                                                                            <taxonname>$genus</taxonname>
108
                                                                                            <parent_id>
109
                                                                                                <taxonconcept>
110
                                                                                                    <rank>family</rank>
111
                                                                                                    <taxonname>$family</taxonname>
112
                                                                                                </taxonconcept>
113
                                                                                            </parent_id>
110 114
                                                                                        </taxonconcept>
111 115
                                                                                    </parent_id>
112 116
                                                                                </taxonconcept>
inputs/CTFS/StemObservation/VegBIEN.csv
29 29
SpeciesAuthority,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/author,
30 30
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/family,
31 31
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus,
32
SubSpeciesName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=subspecies]/taxonname",
33
SpeciesName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonname",
34
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname",
35
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname",
32
SubSpeciesName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=subspecies]/taxonname",
33
SpeciesName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonname",
34
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname",
35
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname",
36 36
SpeciesName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/species,
37 37
Description,,** No join mapping for *Description ** 
38 38
ExactDate,,** No join mapping for *ExactDate ** 
inputs/CTFS/StemObservation/test.xml.ref
69 69
                                    <genus>$Genus</genus>
70 70
                                    <parent_id>
71 71
                                        <taxonconcept>
72
                                            <rank>cultivar</rank>
73 72
                                            <parent_id>
74 73
                                                <taxonconcept>
75
                                                    <rank>forma</rank>
74
                                                    <rank>cultivar</rank>
76 75
                                                    <parent_id>
77 76
                                                        <taxonconcept>
78
                                                            <rank>variety</rank>
77
                                                            <rank>forma</rank>
79 78
                                                            <parent_id>
80 79
                                                                <taxonconcept>
81
                                                                    <rank>subspecies</rank>
82
                                                                    <taxonname>$SubSpeciesName</taxonname>
80
                                                                    <rank>variety</rank>
83 81
                                                                    <parent_id>
84 82
                                                                        <taxonconcept>
85
                                                                            <rank>species</rank>
86
                                                                            <taxonname>$SpeciesName</taxonname>
83
                                                                            <rank>subspecies</rank>
84
                                                                            <taxonname>$SubSpeciesName</taxonname>
87 85
                                                                            <parent_id>
88 86
                                                                                <taxonconcept>
89
                                                                                    <rank>genus</rank>
90
                                                                                    <taxonname>$Genus</taxonname>
87
                                                                                    <rank>species</rank>
88
                                                                                    <taxonname>$SpeciesName</taxonname>
91 89
                                                                                    <parent_id>
92 90
                                                                                        <taxonconcept>
93
                                                                                            <rank>family</rank>
94
                                                                                            <taxonname>$Family</taxonname>
91
                                                                                            <rank>genus</rank>
92
                                                                                            <taxonname>$Genus</taxonname>
93
                                                                                            <parent_id>
94
                                                                                                <taxonconcept>
95
                                                                                                    <rank>family</rank>
96
                                                                                                    <taxonname>$Family</taxonname>
97
                                                                                                </taxonconcept>
98
                                                                                            </parent_id>
95 99
                                                                                        </taxonconcept>
96 100
                                                                                    </parent_id>
97 101
                                                                                </taxonconcept>
inputs/CTFS/TaxonOccurrence/VegBIEN.csv
15 15
SubSpeciesName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/4",
16 16
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/family,
17 17
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus,
18
SubSpeciesName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=subspecies]/taxonname",
19
SpeciesName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonname",
20
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname",
21
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname",
18
SubSpeciesName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=subspecies]/taxonname",
19
SpeciesName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonname",
20
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname",
21
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname",
22 22
SpeciesName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/species,
23 23
Description,,** No join mapping for *Description ** 
24 24
FamilyID,,** No join mapping for *FamilyID ** 
... This diff was truncated because it exceeds the maximum size that can be displayed.

Also available in: Unified diff