Project

General

Profile

« Previous | Next » 

Revision 5656

schemas/vegbien.sql: taxonlabel: Renamed identifyingtaxonomicname to taxonomicname because the taxonomicname provided by the datasource is now in taxonverbatim, so there is no name collision. Note that both of these fields store the same type of information, but taxonlabel's is autogenerated while taxonverbatim's is verbatim (and is only set if provided by the datasource).

View differences:

inputs/MT/Specimen/VegBIEN.csv
11 11
establishmentMeans,"/location/locationevent/taxonoccurrence/iscultivated/_alt/2/_map:[cultivated=t,wild=f,*=]/value",
12 12
establishmentMeans,"/location/locationevent/taxonoccurrence/isnative/_map:[native=t,exotic=f,*=]/value",
13 13
id,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/3,
14
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
15
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
16
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,
17
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2,
14
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
15
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
18 16
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/taxonepithet",
19 17
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=family]/taxonepithet",
18
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,
19
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2,
20 20
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/family,
21 21
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/genus,
22 22
locality,/location/locationnarrative/_merge/1,
inputs/MT/Specimen/test.xml.ref
50 50
                                                    <organizationname>TNRS</organizationname>
51 51
                                                </party>
52 52
                                            </creator_id>
53
                                            <identifyingtaxonomicname>
53
                                            <taxonomicname>
54 54
                                                <_join_words>
55 55
                                                    <1>$family</1>
56 56
                                                    <2>$genus</2>
57 57
                                                </_join_words>
58
                                            </identifyingtaxonomicname>
58
                                            </taxonomicname>
59 59
                                        </taxonlabel>
60 60
                                    </matched_label_id>
61
                                    <identifyingtaxonomicname>
62
                                        <_join_words>
63
                                            <1>$family</1>
64
                                            <2>$genus</2>
65
                                        </_join_words>
66
                                    </identifyingtaxonomicname>
67 61
                                    <parent_id>
68 62
                                        <taxonlabel>
69 63
                                            <parent_id>
......
105 99
                                            </parent_id>
106 100
                                        </taxonlabel>
107 101
                                    </parent_id>
102
                                    <taxonomicname>
103
                                        <_join_words>
104
                                            <1>$family</1>
105
                                            <2>$genus</2>
106
                                        </_join_words>
107
                                    </taxonomicname>
108 108
                                    <taxonverbatim>
109 109
                                        <family>$family</family>
110 110
                                        <genus>$genus</genus>
inputs/test_taxonomic_names/Taxon/VegBIEN.csv
1 1
test_taxonomic_names,VegBIEN:/_simplifyPath:[next=parent_id]/path,Comments
2 2
scientificName,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/3",
3
scientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1",
4
scientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1,
3
scientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_alt/2/_join_words/1/_alt/1",
5 4
scientificNameID,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/sourceaccessioncode,
5
scientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonomicname/_alt/2/_join_words/1/_alt/1,
6 6
scientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/binomial,
inputs/test_taxonomic_names/Taxon/test.xml.ref
17 17
                                                    <organizationname>TNRS</organizationname>
18 18
                                                </party>
19 19
                                            </creator_id>
20
                                            <identifyingtaxonomicname>$scientificName</identifyingtaxonomicname>
20
                                            <taxonomicname>$scientificName</taxonomicname>
21 21
                                        </taxonlabel>
22 22
                                    </matched_label_id>
23
                                    <identifyingtaxonomicname>$scientificName</identifyingtaxonomicname>
24 23
                                    <sourceaccessioncode>$scientificNameID</sourceaccessioncode>
24
                                    <taxonomicname>$scientificName</taxonomicname>
25 25
                                    <taxonverbatim><binomial>$scientificName</binomial></taxonverbatim>
26 26
                                </taxonlabel>
27 27
                            </taxonlabel_id>
inputs/XAL/Specimen/VegBIEN.csv
21 21
darwin:CollectorNumber,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/1/_first/1",
22 22
darwin:ScientificName,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/3",
23 23
darwin:IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/fullname,
24
darwin:ScientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1",
25
darwin:Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
26
darwin:Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
27
darwin:Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
28
darwin:Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/4",
29
darwin:ScientificNameAuthor,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/2",
24
darwin:ScientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_alt/2/_join_words/1/_alt/1",
25
darwin:Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
26
darwin:Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
27
darwin:Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
28
darwin:Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/4",
29
darwin:ScientificNameAuthor,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_alt/2/_join_words/2",
30 30
darwin:DayIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/creationdate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value",
31 31
darwin:MonthIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/creationdate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value",
32 32
darwin:YearIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/creationdate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value",
33 33
darwin:IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/creator_id/_simplifyPath:[next=creator_id]/path/party/fullname/_alt/2,
34
darwin:ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1,
35
darwin:Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,
36
darwin:Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2,
37
darwin:Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1,
38
darwin:Subspecies,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/4,
39
darwin:ScientificNameAuthor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/2,
40 34
darwin:Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=subspecies]/taxonepithet",
41 35
darwin:Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=species]/taxonepithet",
42 36
darwin:Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/taxonepithet",
......
45 39
darwin:Class,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=class]/taxonepithet",
46 40
darwin:Phylum,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=phylum]/taxonepithet",
47 41
darwin:Kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,phylum,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=kingdom]/taxonepithet",
42
darwin:ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonomicname/_alt/2/_join_words/1/_alt/1,
43
darwin:Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,
44
darwin:Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2,
45
darwin:Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1,
46
darwin:Subspecies,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/4,
47
darwin:ScientificNameAuthor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonomicname/_alt/2/_join_words/2,
48 48
darwin:ScientificNameAuthor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/author,
49 49
darwin:ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/binomial,
50 50
darwin:Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/family,
inputs/TEAM/VL/VegBIEN.csv
20 20
1ha Plot Number,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",
21 21
Tree Number,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/1/_first/2",
22 22
Id,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/3,
23
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
24
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
25
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
26
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,
27
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2,
28
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1,
23
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
24
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
25
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
29 26
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=species]/taxonepithet",
30 27
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/taxonepithet",
31 28
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=family]/taxonepithet",
29
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,
30
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2,
31
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1,
32 32
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/family,
33 33
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/genus,
34 34
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/species,
inputs/TEAM/VL/test.xml.ref
52 52
                                                    <organizationname>TNRS</organizationname>
53 53
                                                </party>
54 54
                                            </creator_id>
55
                                            <identifyingtaxonomicname>
55
                                            <taxonomicname>
56 56
                                                <_join_words>
57 57
                                                    <1>$Family</1>
58 58
                                                    <2>$Genus</2>
59 59
                                                    <3>$Species</3>
60 60
                                                </_join_words>
61
                                            </identifyingtaxonomicname>
61
                                            </taxonomicname>
62 62
                                        </taxonlabel>
63 63
                                    </matched_label_id>
64
                                    <identifyingtaxonomicname>
65
                                        <_join_words>
66
                                            <1>$Family</1>
67
                                            <2>$Genus</2>
68
                                            <3>$Species</3>
69
                                        </_join_words>
70
                                    </identifyingtaxonomicname>
71 64
                                    <parent_id>
72 65
                                        <taxonlabel>
73 66
                                            <parent_id>
......
110 103
                                            </parent_id>
111 104
                                        </taxonlabel>
112 105
                                    </parent_id>
106
                                    <taxonomicname>
107
                                        <_join_words>
108
                                            <1>$Family</1>
109
                                            <2>$Genus</2>
110
                                            <3>$Species</3>
111
                                        </_join_words>
112
                                    </taxonomicname>
113 113
                                    <taxonverbatim>
114 114
                                        <family>$Family</family>
115 115
                                        <genus>$Genus</genus>
inputs/TEAM/VT/VegBIEN.csv
20 20
1ha Plot Number,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",
21 21
Tree Number,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/1/_first/2",
22 22
Id,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/3,
23
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
24
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
25
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
26
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,
27
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2,
28
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1,
23
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
24
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
25
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
29 26
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=species]/taxonepithet",
30 27
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/taxonepithet",
31 28
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=family]/taxonepithet",
29
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,
30
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2,
31
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1,
32 32
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/family,
33 33
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/genus,
34 34
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/species,
inputs/TEAM/VT/test.xml.ref
52 52
                                                    <organizationname>TNRS</organizationname>
53 53
                                                </party>
54 54
                                            </creator_id>
55
                                            <identifyingtaxonomicname>
55
                                            <taxonomicname>
56 56
                                                <_join_words>
57 57
                                                    <1>$Family</1>
58 58
                                                    <2>$Genus</2>
59 59
                                                    <3>$Species</3>
60 60
                                                </_join_words>
61
                                            </identifyingtaxonomicname>
61
                                            </taxonomicname>
62 62
                                        </taxonlabel>
63 63
                                    </matched_label_id>
64
                                    <identifyingtaxonomicname>
65
                                        <_join_words>
66
                                            <1>$Family</1>
67
                                            <2>$Genus</2>
68
                                            <3>$Species</3>
69
                                        </_join_words>
70
                                    </identifyingtaxonomicname>
71 64
                                    <parent_id>
72 65
                                        <taxonlabel>
73 66
                                            <parent_id>
......
110 103
                                            </parent_id>
111 104
                                        </taxonlabel>
112 105
                                    </parent_id>
106
                                    <taxonomicname>
107
                                        <_join_words>
108
                                            <1>$Family</1>
109
                                            <2>$Genus</2>
110
                                            <3>$Species</3>
111
                                        </_join_words>
112
                                    </taxonomicname>
113 113
                                    <taxonverbatim>
114 114
                                        <family>$Family</family>
115 115
                                        <genus>$Genus</genus>
inputs/NY/Specimen/VegBIEN.csv
26 26
ScientificName,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/3",
27 27
UniqueNYInternalRecordNumber,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/3,
28 28
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/fullname,
29
ScientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1",
30
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
31
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
32
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
33
Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/4",
34
ScientificNameAuthor,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/2",
29
ScientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_alt/2/_join_words/1/_alt/1",
30
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
31
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
32
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
33
Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/4",
34
ScientificNameAuthor,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_alt/2/_join_words/2",
35 35
DayIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/creationdate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value",
36 36
MonthIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/creationdate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value",
37 37
YearIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/creationdate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value",
38 38
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/creator_id/_simplifyPath:[next=creator_id]/path/party/fullname/_alt/2,
39
ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1,
40
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,
41
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2,
42
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1,
43
Subspecies,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/4,
44
ScientificNameAuthor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/2,
45 39
Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=subspecies]/taxonepithet",
46 40
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=species]/taxonepithet",
47 41
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/taxonepithet",
......
50 44
Class,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=class]/taxonepithet",
51 45
Phylum,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=phylum]/taxonepithet",
52 46
Kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,phylum,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=kingdom]/taxonepithet",
47
ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonomicname/_alt/2/_join_words/1/_alt/1,
48
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,
49
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2,
50
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1,
51
Subspecies,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/4,
52
ScientificNameAuthor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonomicname/_alt/2/_join_words/2,
53 53
ScientificNameAuthor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/author,
54 54
ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/binomial,
55 55
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/family,
inputs/NY/Specimen/test.xml.ref
117 117
                                                    <organizationname>TNRS</organizationname>
118 118
                                                </party>
119 119
                                            </creator_id>
120
                                            <identifyingtaxonomicname>
120
                                            <taxonomicname>
121 121
                                                <_join_words>
122 122
                                                    <1>
123 123
                                                        <_alt>
......
134 134
                                                    </1>
135 135
                                                    <2>$ScientificNameAuthor</2>
136 136
                                                </_join_words>
137
                                            </identifyingtaxonomicname>
137
                                            </taxonomicname>
138 138
                                        </taxonlabel>
139 139
                                    </matched_label_id>
140 140
                                    <creationdate>
......
168 168
                                            <path><party><fullname>$IdentifiedBy</fullname></party></path>
169 169
                                        </_simplifyPath>
170 170
                                    </creator_id>
171
                                    <identifyingtaxonomicname>
172
                                        <_join_words>
173
                                            <1>
174
                                                <_alt>
175
                                                    <1>$ScientificName</1>
176
                                                    <2>
177
                                                        <_join_words>
178
                                                            <1>$Family</1>
179
                                                            <2>$Genus</2>
180
                                                            <3>$Species</3>
181
                                                            <4>$Subspecies</4>
182
                                                        </_join_words>
183
                                                    </2>
184
                                                </_alt>
185
                                            </1>
186
                                            <2>$ScientificNameAuthor</2>
187
                                        </_join_words>
188
                                    </identifyingtaxonomicname>
189 171
                                    <parent_id>
190 172
                                        <taxonlabel>
191 173
                                            <parent_id>
......
253 235
                                            </parent_id>
254 236
                                        </taxonlabel>
255 237
                                    </parent_id>
238
                                    <taxonomicname>
239
                                        <_join_words>
240
                                            <1>
241
                                                <_alt>
242
                                                    <1>$ScientificName</1>
243
                                                    <2>
244
                                                        <_join_words>
245
                                                            <1>$Family</1>
246
                                                            <2>$Genus</2>
247
                                                            <3>$Species</3>
248
                                                            <4>$Subspecies</4>
249
                                                        </_join_words>
250
                                                    </2>
251
                                                </_alt>
252
                                            </1>
253
                                            <2>$ScientificNameAuthor</2>
254
                                        </_join_words>
255
                                    </taxonomicname>
256 256
                                    <taxonverbatim>
257 257
                                        <author>$ScientificNameAuthor</author>
258 258
                                        <binomial>$ScientificName</binomial>
inputs/Madidi/Organism/VegBIEN.csv
30 30
Species and morphotypes,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/3","Contains less than ""Specie+autor"""
31 31
Habit,"/location/locationevent/taxonoccurrence/growthform/_map:[./{T,Arbol,palm}=tree,./{H,""Hemiepífito""}=hemiepiphyte,./{L,l,""L?"",Liana}=liana,E=epiphyte,S=shrub,Hb=herb,""vine-herbaceous""=vine,graminoid=grass,rosette=forb,*=*]/value","According to <http://salvias.net/Documents/salvias_data_dictionary.html#Plot+data.habit>, <https://projects.nceas.ucsb.edu/nceas/projects/bien/wiki/SALVIAS#Habit>"
32 32
Determined by,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/fullname,
33
Specie+autor,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/1",
34
Species and morphotypes,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1","Contains less than ""Specie+autor"""
35
Family (revised),"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
36
Genera,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
37
Specific epithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
38
Autor (revised),"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/2",
33
Specie+autor,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_alt/1",
34
Species and morphotypes,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_alt/2/_join_words/1/_alt/1","Contains less than ""Specie+autor"""
35
Family (revised),"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
36
Genera,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
37
Specific epithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
38
Autor (revised),"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_alt/2/_join_words/2",
39 39
Determined by,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/creator_id/_simplifyPath:[next=creator_id]/path/party/fullname/_alt/2,
40
Specie+autor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/1,
41
Species and morphotypes,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1,"Contains less than ""Specie+autor"""
42
Family (revised),/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,
43
Genera,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2,
44
Specific epithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1,
45
Autor (revised),/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/2,
46 40
Specific epithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=species]/taxonepithet",
47 41
Genera,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/taxonepithet",
48 42
Family (revised),"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=family]/taxonepithet",
43
Specie+autor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonomicname/_alt/1,
44
Species and morphotypes,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonomicname/_alt/2/_join_words/1/_alt/1,"Contains less than ""Specie+autor"""
45
Family (revised),/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,
46
Genera,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2,
47
Specific epithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1,
48
Autor (revised),/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonomicname/_alt/2/_join_words/2,
49 49
Autor (revised),/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/author,
50 50
Species and morphotypes,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/binomial,"Contains less than ""Specie+autor"""
51 51
Family (revised),/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/family,
......
53 53
Specific epithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/species,
54 54
Specie+autor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/taxonomicname,
55 55
Qualifier,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/taxonfit,
56
Field family,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,
57
Field name,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2,Often = Genera
58
Field family,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,
59
Field name,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2,Often = Genera
56
Field family,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,
57
Field name,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2,Often = Genera
60 58
Field name,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/taxonepithet",Often = Genera
61 59
Field family,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=family]/taxonepithet",
60
Field family,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,
61
Field name,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2,Often = Genera
62 62
Field family,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/taxonverbatim/family,
63 63
Field name,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/taxonverbatim/genus,Often = Genera
64 64
Index collector,/location/locationevent/taxonoccurrence/verbatimcollectorname,
inputs/Madidi/Organism/test.xml.ref
72 72
                                                    <organizationname>TNRS</organizationname>
73 73
                                                </party>
74 74
                                            </creator_id>
75
                                            <identifyingtaxonomicname>
75
                                            <taxonomicname>
76 76
                                                <_alt>
77 77
                                                    <1>$Specie+autor</1>
78 78
                                                    <2>
......
93 93
                                                        </_join_words>
94 94
                                                    </2>
95 95
                                                </_alt>
96
                                            </identifyingtaxonomicname>
96
                                            </taxonomicname>
97 97
                                        </taxonlabel>
98 98
                                    </matched_label_id>
99 99
                                    <creator_id>
......
102 102
                                            <path><party><fullname>$Determined by</fullname></party></path>
103 103
                                        </_simplifyPath>
104 104
                                    </creator_id>
105
                                    <identifyingtaxonomicname>
106
                                        <_alt>
107
                                            <1>$Specie+autor</1>
108
                                            <2>
109
                                                <_join_words>
110
                                                    <1>
111
                                                        <_alt>
112
                                                            <1>$Species and morphotypes</1>
113
                                                            <2>
114
                                                                <_join_words>
115
                                                                    <1>$Family (revised)</1>
116
                                                                    <2>$Genera</2>
117
                                                                    <3>$Specific epithet</3>
118
                                                                </_join_words>
119
                                                            </2>
120
                                                        </_alt>
121
                                                    </1>
122
                                                    <2>$Autor (revised)</2>
123
                                                </_join_words>
124
                                            </2>
125
                                        </_alt>
126
                                    </identifyingtaxonomicname>
127 105
                                    <parent_id>
128 106
                                        <taxonlabel>
129 107
                                            <parent_id>
......
166 144
                                            </parent_id>
167 145
                                        </taxonlabel>
168 146
                                    </parent_id>
147
                                    <taxonomicname>
148
                                        <_alt>
149
                                            <1>$Specie+autor</1>
150
                                            <2>
151
                                                <_join_words>
152
                                                    <1>
153
                                                        <_alt>
154
                                                            <1>$Species and morphotypes</1>
155
                                                            <2>
156
                                                                <_join_words>
157
                                                                    <1>$Family (revised)</1>
158
                                                                    <2>$Genera</2>
159
                                                                    <3>$Specific epithet</3>
160
                                                                </_join_words>
161
                                                            </2>
162
                                                        </_alt>
163
                                                    </1>
164
                                                    <2>$Autor (revised)</2>
165
                                                </_join_words>
166
                                            </2>
167
                                        </_alt>
168
                                    </taxonomicname>
169 169
                                    <taxonverbatim>
170 170
                                        <author>$Autor (revised)</author>
171 171
                                        <binomial>$Species and morphotypes</binomial>
......
182 182
                            <isoriginal>true</isoriginal>
183 183
                            <taxonlabel_id>
184 184
                                <taxonlabel>
185
                                    <identifyingtaxonomicname>
186
                                        <_join_words>
187
                                            <1>$Field family</1>
188
                                            <2>$Field name</2>
189
                                        </_join_words>
190
                                    </identifyingtaxonomicname>
191 185
                                    <matched_label_id>
192 186
                                        <taxonlabel>
193 187
                                            <creator_id>
......
196 190
                                                    <organizationname>TNRS</organizationname>
197 191
                                                </party>
198 192
                                            </creator_id>
199
                                            <identifyingtaxonomicname>
193
                                            <taxonomicname>
200 194
                                                <_join_words>
201 195
                                                    <1>$Field family</1>
202 196
                                                    <2>$Field name</2>
203 197
                                                </_join_words>
204
                                            </identifyingtaxonomicname>
198
                                            </taxonomicname>
205 199
                                        </taxonlabel>
206 200
                                    </matched_label_id>
207 201
                                    <parent_id>
......
245 239
                                            </parent_id>
246 240
                                        </taxonlabel>
247 241
                                    </parent_id>
242
                                    <taxonomicname>
243
                                        <_join_words>
244
                                            <1>$Field family</1>
245
                                            <2>$Field name</2>
246
                                        </_join_words>
247
                                    </taxonomicname>
248 248
                                    <taxonverbatim>
249 249
                                        <family>$Field family</family>
250 250
                                        <genus>$Field name</genus>
inputs/UNCC/Specimen/VegBIEN.csv
42 42
GROUP BY herbarium, accession
43 43
HAVING count(*) > 1
44 44
-----"
45
SciName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1",
46
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
47
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
48
species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
49
infraname,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond",
50
usdaRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then/_alt/1",
51
infrarank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then/_alt/2",
52
infraname,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2",
53
authors,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/2",
54
SciName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1,
55
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,
56
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2,
57
species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1,
58
infraname,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond",
59
usdaRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then/_alt/1",
60
infrarank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then/_alt/2",
61
infraname,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2,
62
authors,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/2,
45
SciName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_alt/2/_join_words/1/_alt/1",
46
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
47
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
48
species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
49
infraname,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond",
50
usdaRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then/_alt/1",
51
infrarank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then/_alt/2",
52
infraname,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2",
53
authors,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_alt/2/_join_words/2",
63 54
usdaRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/rank/_alt/1",
64 55
infrarank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/rank/_alt/2",
65 56
usdaRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/taxonverbatim/verbatimrank/_alt/1",
......
70 61
infraname,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/taxonepithet,
71 62
usdaRank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/rank/_alt/1,
72 63
infrarank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/rank/_alt/2,
64
SciName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonomicname/_alt/2/_join_words/1/_alt/1,
65
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,
66
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2,
67
species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1,
68
infraname,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond",
69
usdaRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then/_alt/1",
70
infrarank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then/_alt/2",
71
infraname,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2,
72
authors,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonomicname/_alt/2/_join_words/2,
73 73
authors,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/author,
74 74
SciName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/binomial,
75 75
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/family,
inputs/UNCC/Specimen/test.xml.ref
80 80
                                                    <organizationname>TNRS</organizationname>
81 81
                                                </party>
82 82
                                            </creator_id>
83
                                            <identifyingtaxonomicname>
83
                                            <taxonomicname>
84 84
                                                <_join_words>
85 85
                                                    <1>
86 86
                                                        <_alt>
......
112 112
                                                    </1>
113 113
                                                    <2>$authors</2>
114 114
                                                </_join_words>
115
                                            </identifyingtaxonomicname>
115
                                            </taxonomicname>
116 116
                                        </taxonlabel>
117 117
                                    </matched_label_id>
118
                                    <identifyingtaxonomicname>
119
                                        <_join_words>
120
                                            <1>
121
                                                <_alt>
122
                                                    <1>$SciName</1>
123
                                                    <2>
124
                                                        <_join_words>
125
                                                            <1>$family</1>
126
                                                            <2>$genus</2>
127
                                                            <3>$species</3>
128
                                                            <5>
129
                                                                <_join_words>
130
                                                                    <1>
131
                                                                        <_if name="if has infraspecificEpithet">
132
                                                                            <cond>$infraname</cond>
133
                                                                            <then>
134
                                                                                <_alt>
135
                                                                                    <1>$usdaRank</1>
136
                                                                                    <2>$infrarank</2>
137
                                                                                </_alt>
138
                                                                            </then>
139
                                                                        </_if>
140
                                                                    </1>
141
                                                                    <2>$infraname</2>
142
                                                                </_join_words>
143
                                                            </5>
144
                                                        </_join_words>
145
                                                    </2>
146
                                                </_alt>
147
                                            </1>
148
                                            <2>$authors</2>
149
                                        </_join_words>
150
                                    </identifyingtaxonomicname>
151 118
                                    <parent_id>
152 119
                                        <taxonlabel>
153 120
                                            <rank>
......
211 178
                                            <2>$infrarank</2>
212 179
                                        </_alt>
213 180
                                    </rank>
181
                                    <taxonomicname>
182
                                        <_join_words>
183
                                            <1>
184
                                                <_alt>
185
                                                    <1>$SciName</1>
186
                                                    <2>
187
                                                        <_join_words>
188
                                                            <1>$family</1>
189
                                                            <2>$genus</2>
190
                                                            <3>$species</3>
191
                                                            <5>
192
                                                                <_join_words>
193
                                                                    <1>
194
                                                                        <_if name="if has infraspecificEpithet">
195
                                                                            <cond>$infraname</cond>
196
                                                                            <then>
197
                                                                                <_alt>
198
                                                                                    <1>$usdaRank</1>
199
                                                                                    <2>$infrarank</2>
200
                                                                                </_alt>
201
                                                                            </then>
202
                                                                        </_if>
203
                                                                    </1>
204
                                                                    <2>$infraname</2>
205
                                                                </_join_words>
206
                                                            </5>
207
                                                        </_join_words>
208
                                                    </2>
209
                                                </_alt>
210
                                            </1>
211
                                            <2>$authors</2>
212
                                        </_join_words>
213
                                    </taxonomicname>
214 214
                                    <taxonverbatim>
215 215
                                        <author>$authors</author>
216 216
                                        <binomial>$SciName</binomial>
inputs/ACAD/Specimen/VegBIEN.csv
20 20
scientificName,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/2",
21 21
id,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/3,
22 22
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/fullname,
23
scientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/1",
24
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
25
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
26
specificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
27
infraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond",
28
taxonRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then",
29
infraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2",
30
scientificNameAuthorship,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/2",
23
scientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_alt/1",
24
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
25
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
26
specificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
27
infraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond",
28
taxonRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then",
29
infraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2",
30
scientificNameAuthorship,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_alt/2/_join_words/2",
31 31
dateIdentified,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/creationdate/_alt/1/_*/date/_dateRangeStart/value,
32 32
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/creator_id/_simplifyPath:[next=creator_id]/path/party/fullname/_alt/2,
33
scientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/1,
34
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,
35
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2,
36
specificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1,
37
infraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond",
38
taxonRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then",
39
infraspecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2,
40
scientificNameAuthorship,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/2,
41 33
taxonRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/rank",
42 34
taxonRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/taxonverbatim/verbatimrank",
43 35
specificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=species]/taxonepithet",
......
49 41
kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,phylum,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=kingdom]/taxonepithet",
50 42
infraspecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/taxonepithet,
51 43
taxonRank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/rank,
44
scientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonomicname/_alt/1,
45
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,
46
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2,
47
specificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1,
48
infraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond",
49
taxonRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then",
50
infraspecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2,
51
scientificNameAuthorship,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonomicname/_alt/2/_join_words/2,
52 52
scientificNameAuthorship,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/author,
53 53
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/family,
54 54
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/genus,
inputs/ACAD/Specimen/test.xml.ref
77 77
                                                    <organizationname>TNRS</organizationname>
78 78
                                                </party>
79 79
                                            </creator_id>
80
                                            <identifyingtaxonomicname>
80
                                            <taxonomicname>
81 81
                                                <_alt>
82 82
                                                    <1>$scientificName</1>
83 83
                                                    <2>
......
104 104
                                                        </_join_words>
105 105
                                                    </2>
106 106
                                                </_alt>
107
                                            </identifyingtaxonomicname>
107
                                            </taxonomicname>
108 108
                                        </taxonlabel>
109 109
                                    </matched_label_id>
110 110
                                    <creationdate><_date><date><_dateRangeStart><value>$dateIdentified</value></_dateRangeStart></date></_date></creationdate>
......
114 114
                                            <path><party><fullname>$identifiedBy</fullname></party></path>
115 115
                                        </_simplifyPath>
116 116
                                    </creator_id>
117
                                    <identifyingtaxonomicname>
118
                                        <_alt>
119
                                            <1>$scientificName</1>
120
                                            <2>
121
                                                <_join_words>
122
                                                    <1>
123
                                                        <_join_words>
124
                                                            <1>$family</1>
125
                                                            <2>$genus</2>
126
                                                            <3>$specificEpithet</3>
127
                                                            <5>
128
                                                                <_join_words>
129
                                                                    <1>
130
                                                                        <_if name="if has infraspecificEpithet">
131
                                                                            <cond>$infraspecificEpithet</cond>
132
                                                                            <then>$taxonRank</then>
133
                                                                        </_if>
134
                                                                    </1>
135
                                                                    <2>$infraspecificEpithet</2>
136
                                                                </_join_words>
137
                                                            </5>
138
                                                        </_join_words>
139
                                                    </1>
140
                                                    <2>$scientificNameAuthorship</2>
141
                                                </_join_words>
142
                                            </2>
143
                                        </_alt>
144
                                    </identifyingtaxonomicname>
145 117
                                    <parent_id>
146 118
                                        <taxonlabel>
147 119
                                            <rank>$taxonRank</rank>
......
212 184
                                        </taxonlabel>
213 185
                                    </parent_id>
214 186
                                    <rank>$taxonRank</rank>
187
                                    <taxonomicname>
188
                                        <_alt>
189
                                            <1>$scientificName</1>
190
                                            <2>
191
                                                <_join_words>
192
                                                    <1>
193
                                                        <_join_words>
194
                                                            <1>$family</1>
195
                                                            <2>$genus</2>
196
                                                            <3>$specificEpithet</3>
197
                                                            <5>
198
                                                                <_join_words>
199
                                                                    <1>
200
                                                                        <_if name="if has infraspecificEpithet">
201
                                                                            <cond>$infraspecificEpithet</cond>
202
                                                                            <then>$taxonRank</then>
203
                                                                        </_if>
204
                                                                    </1>
205
                                                                    <2>$infraspecificEpithet</2>
206
                                                                </_join_words>
207
                                                            </5>
208
                                                        </_join_words>
209
                                                    </1>
210
                                                    <2>$scientificNameAuthorship</2>
211
                                                </_join_words>
212
                                            </2>
213
                                        </_alt>
214
                                    </taxonomicname>
215 215
                                    <taxonverbatim>
216 216
                                        <author>$scientificNameAuthorship</author>
217 217
                                        <family>$family</family>
inputs/.NCBI/higher_taxa/VegBIEN.csv
1 1
NCBI,VegBIEN:/_simplifyPath:[next=parent_id]/path,Comments
2
rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then",
3
name_txt,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/6",
2
rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then",
3
name_txt,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/6",
4 4
parent tax_id,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_taxonlabel_set_parent_id/parent_id/taxonlabel/sourceaccessioncode,
5
rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then",
6
name_txt,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/6,
7 5
parent tax_id,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/cond/_exists",
8 6
rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/rank",
9 7
rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/taxonverbatim/verbatimrank",
10 8
rank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/rank,
11 9
tax_id,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/sourceaccessioncode,
12 10
name_txt,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonepithet,
11
rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then",
12
name_txt,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/6,
13 13
rank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/verbatimrank,
14 14
4,,** No join mapping for *4 ** 
15 15
5,,** No join mapping for *5 ** 
inputs/.NCBI/higher_taxa/test.xml.ref
17 17
                                                    <organizationname>TNRS</organizationname>
18 18
                                                </party>
19 19
                                            </creator_id>
20
                                            <identifyingtaxonomicname>$name_txt</identifyingtaxonomicname>
20
                                            <taxonomicname>$name_txt</taxonomicname>
21 21
                                        </taxonlabel>
22 22
                                    </matched_label_id>
23 23
                                    <_taxonlabel_set_parent_id><parent_id><taxonlabel><sourceaccessioncode>$parent tax_id</sourceaccessioncode></taxonlabel></parent_id></_taxonlabel_set_parent_id>
24
                                    <identifyingtaxonomicname>$name_txt</identifyingtaxonomicname>
25 24
                                    <rank>$rank</rank>
26 25
                                    <sourceaccessioncode>$tax_id</sourceaccessioncode>
27 26
                                    <taxonepithet>$name_txt</taxonepithet>
27
                                    <taxonomicname>$name_txt</taxonomicname>
28 28
                                    <taxonverbatim><verbatimrank>$rank</verbatimrank></taxonverbatim>
29 29
                                </taxonlabel>
30 30
                            </taxonlabel_id>
inputs/SALVIAS-CSV/Organism/VegBIEN.csv
64 64
tag1,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/1/_first/2/_alt/2/_alt/2","The second tag supercedes the first. The stem tag supercedes the tree tag. Brad: Another type of code, typically a number, used by the original data provider to indicate an individual tree. These are numbers on physical tags attached to the tree. Tag2 Is the same thing, only used if the first tag was lost. Obviously not a good system as it's possible a tree tag could be lost and changed more than once."
65 65
habit,"/location/locationevent/taxonoccurrence/growthform/_map:[./{T,Arbol,palm}=tree,./{H,""Hemiepífito""}=hemiepiphyte,./{L,l,""L?"",Liana}=liana,E=epiphyte,S=shrub,Hb=herb,""vine-herbaceous""=vine,graminoid=grass,rosette=forb,*=*]/value","Brad: This is growth form (tree, shrub, herb, etc.). It is an observation of a trait.; According to <http://salvias.net/Documents/salvias_data_dictionary.html#Plot+data.habit>, <https://projects.nceas.ucsb.edu/nceas/projects/bien/wiki/SALVIAS#Habit>"
66 66
OBSERVATION_ID,"/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/2/_if[@name=""if organism in AggregateOccurrence""]/else","Brad: Neither is correct; this is just an internal ID for table plotObservations. However, it has the important property of uniquely identifying an ""observation"", which is an individual tree, in the case of an individual observation, or a records of a species with an associated count of individuals or measurement of percent cover, in the case of aggregate observations. Not sure where to store this. Main point is that it is not part of the original data, but an auto_increment added later."
67
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
68
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
69
specific_epithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
70
infra_ep_1,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond",
71
infra_rank_1,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then",
72
infra_ep_1,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2",
73
specific_authority,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/2",Brad: This is the author of the scientificName.
74
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,
75
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2,
76
specific_epithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1,
77
infra_ep_1,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond",
78
infra_rank_1,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then",
79
infra_ep_1,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2,
80
specific_authority,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/2,Brad: This is the author of the scientificName.
67
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
68
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
69
specific_epithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
70
infra_ep_1,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond",
71
infra_rank_1,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then",
72
infra_ep_1,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2",
73
specific_authority,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_alt/2/_join_words/2",Brad: This is the author of the scientificName.
81 74
infra_rank_1,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/rank",
82 75
infra_rank_1,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/taxonverbatim/verbatimrank",
83 76
specific_epithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=species]/taxonepithet",
......
85 78
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=family]/taxonepithet",
86 79
infra_ep_1,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/taxonepithet,
87 80
infra_rank_1,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/rank,
81
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,
82
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2,
83
specific_epithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1,
84
infra_ep_1,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond",
85
infra_rank_1,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then",
86
infra_ep_1,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2,
87
specific_authority,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonomicname/_alt/2/_join_words/2,Brad: This is the author of the scientificName.
88 88
specific_authority,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/author,Brad: This is the author of the scientificName.
89 89
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/family,
90 90
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/genus,
91 91
specific_epithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/species,
92 92
infra_rank_1,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/verbatimrank,
93 93
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."
94
orig_family,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,Brad: OMIT
95
orig_species,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3,Brad: OMIT
96
orig_family,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,Brad: OMIT
97
orig_species,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3,Brad: OMIT
94
orig_family,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,Brad: OMIT
95
orig_species,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3,Brad: OMIT
98 96
orig_species,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=species]/taxonepithet",Brad: OMIT
99 97
orig_family,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=family]/taxonepithet",Brad: OMIT
98
orig_family,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,Brad: OMIT
99
orig_species,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3,Brad: OMIT
100 100
orig_family,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/taxonverbatim/family,Brad: OMIT
101 101
orig_species,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/taxonverbatim/species,Brad: OMIT
102 102
coll_firstname,/location/locationevent/taxonoccurrence/verbatimcollectorname/_join_words/1,Brad: See comment above
inputs/SALVIAS-CSV/Organism/test.xml.ref
155 155
                                                    <organizationname>TNRS</organizationname>
156 156
                                                </party>
157 157
                                            </creator_id>
158
                                            <identifyingtaxonomicname>
158
                                            <taxonomicname>
159 159
                                                <_join_words>
160 160
                                                    <1>
161 161
                                                        <_join_words>
......
177 177
                                                    </1>
178 178
                                                    <2>$specific_authority</2>
179 179
                                                </_join_words>
180
                                            </identifyingtaxonomicname>
180
                                            </taxonomicname>
181 181
                                        </taxonlabel>
182 182
                                    </matched_label_id>
183
                                    <identifyingtaxonomicname>
184
                                        <_join_words>
185
                                            <1>
186
                                                <_join_words>
187
                                                    <1>$family</1>
188
                                                    <2>$genus</2>
189
                                                    <3>$specific_epithet</3>
190
                                                    <5>
191
                                                        <_join_words>
192
                                                            <1>
193
                                                                <_if name="if has infraspecificEpithet">
194
                                                                    <cond>$infra_ep_1</cond>
195
                                                                    <then>$infra_rank_1</then>
196
                                                                </_if>
197
                                                            </1>
198
                                                            <2>$infra_ep_1</2>
199
                                                        </_join_words>
200
                                                    </5>
201
                                                </_join_words>
202
                                            </1>
203
                                            <2>$specific_authority</2>
204
                                        </_join_words>
205
                                    </identifyingtaxonomicname>
206 183
                                    <parent_id>
207 184
                                        <taxonlabel>
208 185
                                            <rank>$infra_rank_1</rank>
......
249 226
                                        </taxonlabel>
250 227
                                    </parent_id>
251 228
                                    <rank>$infra_rank_1</rank>
229
                                    <taxonomicname>
230
                                        <_join_words>
231
                                            <1>
232
                                                <_join_words>
233
                                                    <1>$family</1>
234
                                                    <2>$genus</2>
235
                                                    <3>$specific_epithet</3>
236
                                                    <5>
237
                                                        <_join_words>
238
                                                            <1>
239
                                                                <_if name="if has infraspecificEpithet">
240
                                                                    <cond>$infra_ep_1</cond>
241
                                                                    <then>$infra_rank_1</then>
242
                                                                </_if>
243
                                                            </1>
244
                                                            <2>$infra_ep_1</2>
245
                                                        </_join_words>
246
                                                    </5>
247
                                                </_join_words>
248
                                            </1>
249
                                            <2>$specific_authority</2>
250
                                        </_join_words>
251
                                    </taxonomicname>
252 252
                                    <taxonverbatim>
253 253
                                        <author>$specific_authority</author>
254 254
                                        <family>$family</family>
......
264 264
                            <isoriginal>true</isoriginal>
265 265
                            <taxonlabel_id>
266 266
                                <taxonlabel>
267
                                    <identifyingtaxonomicname>
268
                                        <_join_words>
269
                                            <1>$orig_family</1>
270
                                            <3>$orig_species</3>
271
                                        </_join_words>
272
                                    </identifyingtaxonomicname>
273 267
                                    <matched_label_id>
274 268
                                        <taxonlabel>
275 269
                                            <creator_id>
......
278 272
                                                    <organizationname>TNRS</organizationname>
279 273
                                                </party>
280 274
                                            </creator_id>
281
                                            <identifyingtaxonomicname>
275
                                            <taxonomicname>
282 276
                                                <_join_words>
283 277
                                                    <1>$orig_family</1>
284 278
                                                    <3>$orig_species</3>
285 279
                                                </_join_words>
286
                                            </identifyingtaxonomicname>
280
                                            </taxonomicname>
287 281
                                        </taxonlabel>
288 282
                                    </matched_label_id>
289 283
                                    <parent_id>
......
327 321
                                            </parent_id>
328 322
                                        </taxonlabel>
329 323
                                    </parent_id>
324
                                    <taxonomicname>
325
                                        <_join_words>
326
                                            <1>$orig_family</1>
327
                                            <3>$orig_species</3>
328
                                        </_join_words>
329
                                    </taxonomicname>
330 330
                                    <taxonverbatim>
331 331
                                        <family>$orig_family</family>
332 332
                                        <species>$orig_species</species>
inputs/CVS/Organism/VegBIEN.csv
10 10
%cover,/location/locationevent/taxonoccurrence/aggregateoccurrence/cover_fraction/_percent_to_fraction/value,
11 11
authorObsCode,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",
12 12
currentTaxonName sec Weakley 2006,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/3",
13
currentTaxonName sec Weakley 2006,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1",
14
currentTaxonName sec Weakley 2006,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1,
13
currentTaxonName sec Weakley 2006,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_alt/2/_join_words/1/_alt/1",
14
currentTaxonName sec Weakley 2006,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonomicname/_alt/2/_join_words/1/_alt/1,
15 15
currentTaxonName sec Weakley 2006,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/binomial,
16 16
county,/location/locationplace/*_id/placepath/county,
17 17
state,/location/locationplace/*_id/placepath/stateprovince,
inputs/CVS/Organism/test.xml.ref
39 39
                                                    <organizationname>TNRS</organizationname>
40 40
                                                </party>
41 41
                                            </creator_id>
42
                                            <identifyingtaxonomicname>$currentTaxonName sec Weakley 2006</identifyingtaxonomicname>
42
                                            <taxonomicname>$currentTaxonName sec Weakley 2006</taxonomicname>
43 43
                                        </taxonlabel>
44 44
                                    </matched_label_id>
45
                                    <identifyingtaxonomicname>$currentTaxonName sec Weakley 2006</identifyingtaxonomicname>
45
                                    <taxonomicname>$currentTaxonName sec Weakley 2006</taxonomicname>
46 46
                                    <taxonverbatim><binomial>$currentTaxonName sec Weakley 2006</binomial></taxonverbatim>
47 47
                                </taxonlabel>
48 48
                            </taxonlabel_id>
inputs/REMIB/Specimen/VegBIEN.csv
33 33
HAVING count(*) > 1
34 34
-----"
35 35
acronym,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,
36
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
37
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
38
specificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
39
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,
40
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2,
41
specificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1,
36
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
37
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
38
specificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
42 39
specificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=species]/taxonepithet",
43 40
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/taxonepithet",
44 41
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=family]/taxonepithet",
42
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,
43
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2,
44
specificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1,
45 45
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/family,
46 46
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/genus,
47 47
specificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/species,
inputs/REMIB/Specimen/test.xml.ref
72 72
                                                    <organizationname>TNRS</organizationname>
73 73
                                                </party>
74 74
                                            </creator_id>
75
                                            <identifyingtaxonomicname>
75
                                            <taxonomicname>
76 76
                                                <_join_words>
77 77
                                                    <1>$family</1>
78 78
                                                    <2>$genus</2>
79 79
                                                    <3>$specificEpithet</3>
80 80
                                                </_join_words>
81
                                            </identifyingtaxonomicname>
81
                                            </taxonomicname>
82 82
                                        </taxonlabel>
83 83
                                    </matched_label_id>
84
                                    <identifyingtaxonomicname>
85
                                        <_join_words>
86
                                            <1>$family</1>
87
                                            <2>$genus</2>
88
                                            <3>$specificEpithet</3>
89
                                        </_join_words>
90
                                    </identifyingtaxonomicname>
91 84
                                    <parent_id>
92 85
                                        <taxonlabel>
93 86
                                            <parent_id>
......
130 123
                                            </parent_id>
131 124
                                        </taxonlabel>
132 125
                                    </parent_id>
126
                                    <taxonomicname>
127
                                        <_join_words>
128
                                            <1>$family</1>
129
                                            <2>$genus</2>
130
                                            <3>$specificEpithet</3>
131
                                        </_join_words>
132
                                    </taxonomicname>
133 133
                                    <taxonverbatim>
134 134
                                        <family>$family</family>
135 135
                                        <genus>$genus</genus>
inputs/CTFS/StemObservation/test.xml.ref
49 49
                                                    <organizationname>TNRS</organizationname>
50 50
                                                </party>
51 51
                                            </creator_id>
52
                                            <identifyingtaxonomicname>
52
                                            <taxonomicname>
53 53
                                                <_join_words>
54 54
                                                    <1>
55 55
                                                        <_join_words>
......
61 61
                                                    </1>
62 62
                                                    <2>$SpeciesAuthority</2>
63 63
                                                </_join_words>
64
                                            </identifyingtaxonomicname>
64
                                            </taxonomicname>
65 65
                                        </taxonlabel>
66 66
                                    </matched_label_id>
67
                                    <identifyingtaxonomicname>
68
                                        <_join_words>
69
                                            <1>
70
                                                <_join_words>
71
                                                    <1>$Family</1>
72
                                                    <2>$Genus</2>
73
                                                    <3>$SpeciesName</3>
74
                                                    <4>$SubSpeciesName</4>
75
                                                </_join_words>
76
                                            </1>
77
                                            <2>$SpeciesAuthority</2>
78
                                        </_join_words>
79
                                    </identifyingtaxonomicname>
80 67
                                    <parent_id>
81 68
                                        <taxonlabel>
82 69
                                            <parent_id>
......
120 107
                                            </parent_id>
121 108
                                        </taxonlabel>
122 109
                                    </parent_id>
110
                                    <taxonomicname>
111
                                        <_join_words>
112
                                            <1>
113
                                                <_join_words>
114
                                                    <1>$Family</1>
115
                                                    <2>$Genus</2>
116
                                                    <3>$SpeciesName</3>
117
                                                    <4>$SubSpeciesName</4>
118
                                                </_join_words>
119
                                            </1>
120
                                            <2>$SpeciesAuthority</2>
121
                                        </_join_words>
122
                                    </taxonomicname>
123 123
                                    <taxonverbatim>
124 124
                                        <author>$SpeciesAuthority</author>
125 125
                                        <family>$Family</family>
inputs/CTFS/TaxonOccurrence/test.xml.ref
20 20
                                                    <organizationname>TNRS</organizationname>
21 21
                                                </party>
22 22
                                            </creator_id>
23
                                            <identifyingtaxonomicname>
23
                                            <taxonomicname>
24 24
                                                <_join_words>
25 25
                                                    <1>$Family</1>
26 26
                                                    <2>$Genus</2>
27 27
                                                    <3>$SpeciesName</3>
28 28
                                                    <4>$SubSpeciesName</4>
29 29
                                                </_join_words>
30
                                            </identifyingtaxonomicname>
30
                                            </taxonomicname>
31 31
                                        </taxonlabel>
32 32
                                    </matched_label_id>
33
                                    <identifyingtaxonomicname>
34
                                        <_join_words>
35
                                            <1>$Family</1>
36
                                            <2>$Genus</2>
37
                                            <3>$SpeciesName</3>
38
                                            <4>$SubSpeciesName</4>
39
                                        </_join_words>
40
                                    </identifyingtaxonomicname>
41 33
                                    <parent_id>
42 34
                                        <taxonlabel>
43 35
                                            <parent_id>
......
81 73
                                            </parent_id>
82 74
                                        </taxonlabel>
83 75
                                    </parent_id>
76
                                    <taxonomicname>
77
                                        <_join_words>
78
                                            <1>$Family</1>
79
                                            <2>$Genus</2>
80
                                            <3>$SpeciesName</3>
81
                                            <4>$SubSpeciesName</4>
82
                                        </_join_words>
83
                                    </taxonomicname>
84 84
                                    <taxonverbatim>
85 85
                                        <family>$Family</family>
86 86
                                        <genus>$Genus</genus>
inputs/FIA/Organism/test.xml.ref
70 70
                                                    <organizationname>TNRS</organizationname>
71 71
                                                </party>
72 72
                                            </creator_id>
73
                                            <identifyingtaxonomicname>
73
                                            <taxonomicname>
74 74
                                                <_join_words>
75 75
                                                    <2>$Genus</2>
76 76
                                                    <3>$SpecificEpithet</3>
77 77
                                                </_join_words>
78
                                            </identifyingtaxonomicname>
78
                                            </taxonomicname>
79 79
                                        </taxonlabel>
80 80
                                    </matched_label_id>
81
                                    <identifyingtaxonomicname>
82
                                        <_join_words>
83
                                            <2>$Genus</2>
84
                                            <3>$SpecificEpithet</3>
85
                                        </_join_words>
86
                                    </identifyingtaxonomicname>
87 81
                                    <parent_id>
88 82
                                        <taxonlabel>
89 83
                                            <parent_id>
......
120 114
                                            </parent_id>
121 115
                                        </taxonlabel>
122 116
                                    </parent_id>
117
                                    <taxonomicname>
118
                                        <_join_words>
119
                                            <2>$Genus</2>
120
                                            <3>$SpecificEpithet</3>
121
                                        </_join_words>
122
                                    </taxonomicname>
123 123
                                    <taxonverbatim>
124 124
                                        <genus>$Genus</genus>
125 125
                                        <species>$SpecificEpithet</species>
inputs/SALVIAS/plotObservations/test.xml.ref
126 126
                                                    <organizationname>TNRS</organizationname>
127 127
                                                </party>
128 128
                                            </creator_id>
129
                                            <identifyingtaxonomicname>
129
                                            <taxonomicname>
130 130
                                                <_join_words>
131 131
                                                    <1>
132 132
                                                        <_join_words>
......
148 148
                                                    </1>
149 149
                                                    <2>$auth</2>
150 150
                                                </_join_words>
151
                                            </identifyingtaxonomicname>
151
                                            </taxonomicname>
152 152
                                        </taxonlabel>
153 153
                                    </matched_label_id>
154
                                    <identifyingtaxonomicname>
155
                                        <_join_words>
156
                                            <1>
157
                                                <_join_words>
158
                                                    <1>$Family</1>
159
                                                    <2>$Genus</2>
160
                                                    <3>$Species</3>
161
                                                    <5>
162
                                                        <_join_words>
163
                                                            <1>
164
                                                                <_if name="if has infraspecificEpithet">
165
                                                                    <cond>$infra_ep_1</cond>
166
                                                                    <then>$infra_rank_1</then>
167
                                                                </_if>
168
                                                            </1>
169
                                                            <2>$infra_ep_1</2>
170
                                                        </_join_words>
171
                                                    </5>
172
                                                </_join_words>
173
                                            </1>
174
                                            <2>$auth</2>
175
                                        </_join_words>
176
                                    </identifyingtaxonomicname>
177 154
                                    <parent_id>
178 155
                                        <taxonlabel>
179 156
                                            <rank>$infra_rank_1</rank>
......
220 197
                                        </taxonlabel>
221 198
                                    </parent_id>
222 199
                                    <rank>$infra_rank_1</rank>
200
                                    <taxonomicname>
201
                                        <_join_words>
202
                                            <1>
203
                                                <_join_words>
204
                                                    <1>$Family</1>
205
                                                    <2>$Genus</2>
206
                                                    <3>$Species</3>
207
                                                    <5>
208
                                                        <_join_words>
209
                                                            <1>
210
                                                                <_if name="if has infraspecificEpithet">
211
                                                                    <cond>$infra_ep_1</cond>
212
                                                                    <then>$infra_rank_1</then>
213
                                                                </_if>
214
                                                            </1>
215
                                                            <2>$infra_ep_1</2>
216
                                                        </_join_words>
217
                                                    </5>
218
                                                </_join_words>
219
                                            </1>
220
                                            <2>$auth</2>
221
                                        </_join_words>
222
                                    </taxonomicname>
223 223
                                    <taxonverbatim>
224 224
                                        <author>$auth</author>
225 225
                                        <family>$Family</family>
......
235 235
                            <isoriginal>true</isoriginal>
236 236
                            <taxonlabel_id>
237 237
                                <taxonlabel>
238
                                    <identifyingtaxonomicname>
239
                                        <_join_words>
240
                                            <1>$OrigFamily</1>
241
                                            <2>$OrigGenus</2>
242
                                            <3>$OrigSpecies</3>
243
                                        </_join_words>
244
                                    </identifyingtaxonomicname>
245 238
                                    <matched_label_id>
246 239
                                        <taxonlabel>
247 240
                                            <creator_id>
......
250 243
                                                    <organizationname>TNRS</organizationname>
251 244
                                                </party>
252 245
                                            </creator_id>
253
                                            <identifyingtaxonomicname>
246
                                            <taxonomicname>
254 247
                                                <_join_words>
255 248
                                                    <1>$OrigFamily</1>
256 249
                                                    <2>$OrigGenus</2>
257 250
                                                    <3>$OrigSpecies</3>
258 251
                                                </_join_words>
259
                                            </identifyingtaxonomicname>
252
                                            </taxonomicname>
260 253
                                        </taxonlabel>
261 254
                                    </matched_label_id>
262 255
                                    <parent_id>
......
301 294
                                            </parent_id>
302 295
                                        </taxonlabel>
303 296
                                    </parent_id>
297
                                    <taxonomicname>
298
                                        <_join_words>
299
                                            <1>$OrigFamily</1>
300
                                            <2>$OrigGenus</2>
301
                                            <3>$OrigSpecies</3>
302
                                        </_join_words>
303
                                    </taxonomicname>
304 304
                                    <taxonverbatim>
305 305
                                        <family>$OrigFamily</family>
306 306
                                        <genus>$OrigGenus</genus>
inputs/U/Specimen/VegBIEN.csv
14 14
Number,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/1/_first/1",
15 15
ID,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/3,
16 16
Detby,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/fullname,
17
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
18
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
17
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
18
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
19 19
Detyy,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/creationdate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value",
20 20
Detby,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/creator_id/_simplifyPath:[next=creator_id]/path/party/fullname/_alt/2,
21
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,
22
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2,
23 21
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/taxonepithet",
24 22
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=family]/taxonepithet",
23
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,
24
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2,
25 25
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/family,
26 26
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/genus,
27 27
Detyy,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value",
inputs/ARIZ/Specimen/test.xml.ref
117 117
                                                    <organizationname>TNRS</organizationname>
118 118
                                                </party>
119 119
                                            </creator_id>
120
                                            <identifyingtaxonomicname>
120
                                            <taxonomicname>
121 121
                                                <_alt>
122 122
                                                    <1>$ScientificNameAuthor</1>
123 123
                                                    <2>
......
134 134
                                                        </_alt>
135 135
                                                    </2>
136 136
                                                </_alt>
137
                                            </identifyingtaxonomicname>
137
                                            </taxonomicname>
... This diff was truncated because it exceeds the maximum size that can be displayed.

Also available in: Unified diff