Project

General

Profile

« Previous | Next » 

Revision 5915

Added by Aaron Marcuse-Kubitza over 12 years ago

inputs/.TNRS/: Split tnrs table into tnrs_accepted and tnrs_other, with tnrs_accepted imported first. This will eventually allow TNRS data to be imported without needing to use _taxonlabel_set_matched_label_id(), which is extremely slow due to an unknown bug in PostgreSQL's handling of UPDATEs on large tables (possibly limited to UPDATEs inside functions).

View differences:

inputs/.TNRS/tnrs/new_terms.csv
1 
Name_number,OMIT,,Identifies name only within one TNRS batch. Omitted because not globally unique.
2 
Name_submitted,verbatimScientificName,,
3 
Overall_score,matchedTaxonFit_fraction,,Assuming is a fraction based on the range of values
4 
Name_matched,verbatimBinomial,,
5 
Name_matched,binomial,,
6 
Name_matched_rank,taxonRank,,
7 
Name_matched_author,scientificNameAuthorship,,Contains author based on matched name
8 
Name_matched_url,scientificNameID,,
9 
Author_matched,verbatimScientificNameAuthorship,,Contains author in original string
10 
Family_matched,verbatimFamily,,Contains family in original string (uncommon)
11 
Family_score,matchedFamilyFit_fraction,,
12 
Name_matched_accepted_family,family,,Contains family based on matched name
13 
Genus_matched,verbatimGenus,,
14 
Genus_matched,genus,,
15 
Genus_score,matchedGenusFit_fraction,,
16 
Specific_epithet_matched,verbatimSpecificEpithet,,
17 
Specific_epithet_matched,specificEpithet,,
18 
Specific_epithet_score,matchedSpeciesFit_fraction,,
19 
Infraspecific_rank,verbatimTaxonRank,,
20 
Infraspecific_epithet_matched,verbatimInfraspecificEpithet,,
21 
Infraspecific_epithet_matched,infraspecificEpithet,,
22 
Infraspecific_rank_2,UNUSED,,
23 
Infraspecific_epithet_2_matched,UNUSED,,
24 
Infraspecific_epithet_2_score,UNUSED,,
25 
Unmatched_terms,morphospecies,,
26 
Accepted_name,acceptedBinomial,,
27 
Accepted_name_author,acceptedScientificNameAuthorship,,
28 
Accepted_name_rank,acceptedTaxonRank,,
29 
Accepted_name_family,acceptedFamily,/_nullIf:[null=Unknown]/value,
inputs/.TNRS/tnrs/map.csv
1 
TNRS,VegCore,Filter,Comments
2 
Time_submitted,*Time_submitted,,
3 
Name_number,OMIT,,Identifies name only within one TNRS batch. Omitted because not globally unique.
4 
Name_submitted,verbatimScientificName,,
5 
Overall_score,matchedTaxonFit_fraction,,Assuming is a fraction based on the range of values
6 
Name_matched,verbatimBinomial,,
7 
Name_matched,binomial,,
8 
Name_matched_rank,taxonRank,,
9 
Name_score,*Name_score,,
10 
Name_matched_author,scientificNameAuthorship,,Contains author based on matched name
11 
Name_matched_url,scientificNameID,,
12 
Author_matched,verbatimScientificNameAuthorship,,Contains author in original string
13 
Author_score,*Author_score,,
14 
Family_matched,verbatimFamily,,Contains family in original string (uncommon)
15 
Family_score,matchedFamilyFit_fraction,,
16 
Name_matched_accepted_family,family,,Contains family based on matched name
17 
Genus_matched,verbatimGenus,,
18 
Genus_matched,genus,,
19 
Genus_score,matchedGenusFit_fraction,,
20 
Specific_epithet_matched,verbatimSpecificEpithet,,
21 
Specific_epithet_matched,specificEpithet,,
22 
Specific_epithet_score,matchedSpeciesFit_fraction,,
23 
Infraspecific_rank,verbatimTaxonRank,,
24 
Infraspecific_epithet_matched,verbatimInfraspecificEpithet,,
25 
Infraspecific_epithet_matched,infraspecificEpithet,,
26 
Infraspecific_epithet_score,*Infraspecific_epithet_score,,
27 
Infraspecific_rank_2,UNUSED,,
28 
Infraspecific_epithet_2_matched,UNUSED,,
29 
Infraspecific_epithet_2_score,UNUSED,,
30 
Annotations,*Annotations,,
31 
Unmatched_terms,morphospecies,,
32 
Taxonomic_status,taxonomicStatus,,
33 
Accepted_name,acceptedBinomial,,
34 
Accepted_name_author,acceptedScientificNameAuthorship,,
35 
Accepted_name_rank,acceptedTaxonRank,,
36 
Accepted_name_url,*Accepted_name_url,,
37 
Accepted_name_species,*Accepted_name_species,,Also contains genus. Omitted because Accepted_name contains more info.
38 
Accepted_name_family,acceptedFamily,/_nullIf:[null=Unknown]/value,
39 
Selected,*Selected,,
40 
Source,*Source,,
41 
Warnings,*Warnings,,
42 
Accepted_name_lsid,*Accepted_name_lsid,,
inputs/.TNRS/tnrs/test.xml.ref
1 
Put template:
2 
<VegBIEN>
3 
    <_simplifyPath id="-1">
4 
        <next>parent_id</next>
5 
        <path>
6 
            <location>
7 
                <locationevent>
8 
                    <taxonoccurrence>
9 
                        <taxondetermination>
10 
                            <taxonverbatim_id>
11 
                                <taxonverbatim>
12 
                                    <taxonlabel_id>
13 
                                        <taxonlabel>
14 
                                            <_taxonlabel_set_matched_label_id>
15 
                                                <matched_label_id>
16 
                                                    <taxonlabel>
17 
                                                        <rank>$Accepted_name_rank</rank>
18 
                                                        <taxonomicname>
19 
                                                            <_join_words>
20 
                                                                <1>
21 
                                                                    <_taxon_family_require_std>
22 
                                                                        <family>
23 
                                                                            <_nullIf>
24 
                                                                                <null>Unknown</null>
25 
                                                                                <value>$Accepted_name_family</value>
26 
                                                                            </_nullIf>
27 
                                                                        </family>
28 
                                                                    </_taxon_family_require_std>
29 
                                                                </1>
30 
                                                                <2>
31 
                                                                    <_join_words>
32 
                                                                        <1>$Accepted_name</1>
33 
                                                                        <2>$Accepted_name_author</2>
34 
                                                                    </_join_words>
35 
                                                                </2>
36 
                                                            </_join_words>
37 
                                                        </taxonomicname>
38 
                                                        <taxonverbatim>
39 
                                                            <author>$Accepted_name_author</author>
40 
                                                            <binomial>$Accepted_name</binomial>
41 
                                                            <family>
42 
                                                                <_nullIf>
43 
                                                                    <null>Unknown</null>
44 
                                                                    <value>$Accepted_name_family</value>
45 
                                                                </_nullIf>
46 
                                                            </family>
47 
                                                            <verbatimrank>$Accepted_name_rank</verbatimrank>
48 
                                                        </taxonverbatim>
49 
                                                    </taxonlabel>
50 
                                                </matched_label_id>
51 
                                            </_taxonlabel_set_matched_label_id>
52 
                                            <parent_id>
53 
                                                <taxonlabel>
54 
                                                    <rank>$Name_matched_rank</rank>
55 
                                                    <taxonverbatim><verbatimrank>$Name_matched_rank</verbatimrank></taxonverbatim>
56 
                                                    <parent_id>
57 
                                                        <taxonlabel>
58 
                                                            <rank>cultivar</rank>
59 
                                                            <parent_id>
60 
                                                                <taxonlabel>
61 
                                                                    <rank>forma</rank>
62 
                                                                    <parent_id>
63 
                                                                        <taxonlabel>
64 
                                                                            <rank>variety</rank>
65 
                                                                            <parent_id>
66 
                                                                                <taxonlabel>
67 
                                                                                    <rank>subspecies</rank>
68 
                                                                                    <parent_id>
69 
                                                                                        <taxonlabel>
70 
                                                                                            <rank>species</rank>
71 
                                                                                            <taxonepithet>$Specific_epithet_matched</taxonepithet>
72 
                                                                                            <parent_id>
73 
                                                                                                <taxonlabel>
74 
                                                                                                    <rank>genus</rank>
75 
                                                                                                    <matched_label_id>
76 
                                                                                                        <taxonlabel>
77 
                                                                                                            <creator_id>
78 
                                                                                                                <party>
79 
                                                                                                                    <creator_id>0</creator_id>
80 
                                                                                                                    <organizationname>NCBI</organizationname>
81 
                                                                                                                </party>
82 
                                                                                                            </creator_id>
83 
                                                                                                            <taxonomicname>$Genus_matched</taxonomicname>
84 
                                                                                                        </taxonlabel>
85 
                                                                                                    </matched_label_id>
86 
                                                                                                    <taxonepithet>$Genus_matched</taxonepithet>
87 
                                                                                                    <parent_id>
88 
                                                                                                        <taxonlabel>
89 
                                                                                                            <rank>family</rank>
90 
                                                                                                            <matched_label_id>
91 
                                                                                                                <taxonlabel>
92 
                                                                                                                    <creator_id>
93 
                                                                                                                        <party>
94 
                                                                                                                            <creator_id>0</creator_id>
95 
                                                                                                                            <organizationname>NCBI</organizationname>
96 
                                                                                                                        </party>
97 
                                                                                                                    </creator_id>
98 
                                                                                                                    <taxonomicname>$Name_matched_accepted_family</taxonomicname>
99 
                                                                                                                </taxonlabel>
100 
                                                                                                            </matched_label_id>
101 
                                                                                                            <taxonepithet>$Name_matched_accepted_family</taxonepithet>
102 
                                                                                                        </taxonlabel>
103 
                                                                                                    </parent_id>
104 
                                                                                                </taxonlabel>
105 
                                                                                            </parent_id>
106 
                                                                                        </taxonlabel>
107 
                                                                                    </parent_id>
108 
                                                                                </taxonlabel>
109 
                                                                            </parent_id>
110 
                                                                        </taxonlabel>
111 
                                                                    </parent_id>
112 
                                                                </taxonlabel>
113 
                                                            </parent_id>
114 
                                                        </taxonlabel>
115 
                                                    </parent_id>
116 
                                                    <taxonepithet>$Infraspecific_epithet_matched</taxonepithet>
117 
                                                </taxonlabel>
118 
                                            </parent_id>
119 
                                            <rank>$Name_matched_rank</rank>
120 
                                            <sourceaccessioncode>$Name_matched_url</sourceaccessioncode>
121 
                                            <taxonlabel fkey="matched_label_id">
122 
                                                <matched_label_fit_fraction>
123 
                                                    <_max>
124 
                                                        <1>$Family_score</1>
125 
                                                        <2>$Genus_score</2>
126 
                                                        <3>$Specific_epithet_score</3>
127 
                                                        <4>$Overall_score</4>
128 
                                                    </_max>
129 
                                                </matched_label_fit_fraction>
130 
                                                <taxonepithet>$Unmatched_terms</taxonepithet>
131 
                                                <taxonomicname>$Name_submitted</taxonomicname>
132 
                                                <taxonverbatim>
133 
                                                    <author>$Author_matched</author>
134 
                                                    <binomial>$Name_matched</binomial>
135 
                                                    <family>$Family_matched</family>
136 
                                                    <genus>$Genus_matched</genus>
137 
                                                    <morphospecies>$Unmatched_terms</morphospecies>
138 
                                                    <specific_epithet>$Specific_epithet_matched</specific_epithet>
139 
                                                    <verbatimrank>$Infraspecific_rank</verbatimrank>
140 
                                                </taxonverbatim>
141 
                                            </taxonlabel>
142 
                                            <taxonomicname>
143 
                                                <_join_words>
144 
                                                    <1><_taxon_family_require_std><family>$Name_matched_accepted_family</family></_taxon_family_require_std></1>
145 
                                                    <2>
146 
                                                        <_join_words>
147 
                                                            <1>
148 
                                                                <_alt>
149 
                                                                    <1>$Name_matched</1>
150 
                                                                    <2>
151 
                                                                        <_join_words>
152 
                                                                            <2>$Genus_matched</2>
153 
                                                                            <3>$Specific_epithet_matched</3>
154 
                                                                            <5>
155 
                                                                                <_join_words>
156 
                                                                                    <1>
157 
                                                                                        <_if name="if has infraspecificEpithet">
158 
                                                                                            <cond>$Infraspecific_epithet_matched</cond>
159 
                                                                                            <then>$Name_matched_rank</then>
160 
                                                                                        </_if>
161 
                                                                                    </1>
162 
                                                                                    <2>$Infraspecific_epithet_matched</2>
163 
                                                                                </_join_words>
164 
                                                                            </5>
165 
                                                                        </_join_words>
166 
                                                                    </2>
167 
                                                                </_alt>
168 
                                                            </1>
169 
                                                            <2>$Name_matched_author</2>
170 
                                                        </_join_words>
171 
                                                    </2>
172 
                                                </_join_words>
173 
                                            </taxonomicname>
174 
                                            <taxonstatus>$Taxonomic_status</taxonstatus>
175 
                                        </taxonlabel>
176 
                                    </taxonlabel_id>
177 
                                    <author>$Name_matched_author</author>
178 
                                    <binomial>$Name_matched</binomial>
179 
                                    <family>$Name_matched_accepted_family</family>
180 
                                    <genus>$Genus_matched</genus>
181 
                                    <specific_epithet>$Specific_epithet_matched</specific_epithet>
182 
                                    <verbatimrank>$Name_matched_rank</verbatimrank>
183 
                                </taxonverbatim>
184 
                            </taxonverbatim_id>
185 
                        </taxondetermination>
186 
                    </taxonoccurrence>
187 
                </locationevent>
188 
            </location>
189 
        </path>
190 
    </_simplifyPath>
191 
</VegBIEN>
192 
Inserted 16 new rows into database
inputs/.TNRS/tnrs/VegBIEN.csv
1 
TNRS,VegBIEN:/_simplifyPath:[next=parent_id]/path,Comments
2 
Name_matched,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/3",
3 
Name_submitted,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/cond/_exists",
4 
Name_matched_accepted_family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_join_words/1/_taxon_family_require_std/family",Contains family based on matched name
5 
Name_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/1",
6 
Genus_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/2",
7 
Specific_epithet_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
8 
Unmatched_terms,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/2",
9 
Infraspecific_epithet_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond",
10 
Name_matched_rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then",
11 
Infraspecific_epithet_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2",
12 
Name_matched_author,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_join_words/2/_alt/2/_join_words/2",Contains author based on matched name
13 
Accepted_name_rank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/rank,
14 
Accepted_name_family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/taxonomicname/_join_words/1/_taxon_family_require_std/family/_nullIf:[null=Unknown]/value,
15 
Accepted_name,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/1,
16 
Accepted_name_rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then",
17 
Accepted_name_author,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/2,
18 
Accepted_name_author,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/taxonverbatim/author,
19 
Accepted_name,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/taxonverbatim/binomial,
20 
Accepted_name_family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/taxonverbatim/family/_nullIf:[null=Unknown]/value,
21 
Accepted_name_rank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/taxonverbatim/verbatimrank,
22 
Name_matched_rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/rank",
23 
Name_matched_rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/taxonverbatim/verbatimrank",
24 
Specific_epithet_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=species]/taxonepithet",
25 
Name_submitted,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/_if[@name=""if has verbatim name""]/cond/_exists",
26 
Genus_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/_if[@name=""if has verbatim name""]/then/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=NCBI]/taxonomicname",
27 
Genus_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/taxonepithet",
28 
Name_submitted,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=family]/_if[@name=""if has verbatim name""]/cond/_exists",
29 
Name_matched_accepted_family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=family]/_if[@name=""if has verbatim name""]/then/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=NCBI]/taxonomicname",Contains family based on matched name
30 
Name_matched_accepted_family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_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",Contains family based on matched name
31 
Infraspecific_epithet_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/taxonepithet,
32 
Name_matched_rank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/rank,
33 
Name_matched_url,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/sourceaccessioncode,
34 
Name_matched_rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonepithet/_if[@name=""if taxonomic name is epithet""]/cond/_alt:[2=true]/1/_taxonomic_name_is_epithet/rank",
35 
Family_score,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/matched_label_fit_fraction/_max/1,
36 
Genus_score,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/matched_label_fit_fraction/_max/2,
37 
Specific_epithet_score,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/matched_label_fit_fraction/_max/3,
38 
Overall_score,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/matched_label_fit_fraction/_max/4,Assuming is a fraction based on the range of values
39 
Unmatched_terms,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/taxonepithet,
40 
Name_submitted,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/taxonomicname,
41 
Author_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/taxonverbatim/author,Contains author in original string
42 
Name_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/taxonverbatim/binomial,
43 
Family_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/taxonverbatim/family,Contains family in original string (uncommon)
44 
Genus_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/taxonverbatim/genus,
45 
Name_submitted,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/taxonverbatim/morphospecies/_if[@name=""if has verbatim name""]/cond/_exists",
46 
Unmatched_terms,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/taxonverbatim/morphospecies/_if[@name=""if has verbatim name""]/then",
47 
Specific_epithet_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/taxonverbatim/specific_epithet,
48 
Infraspecific_rank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/taxonverbatim/verbatimrank,
49 
Name_matched_accepted_family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/1/_taxon_family_require_std/family,Contains family based on matched name
50 
Name_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/1,
51 
Genus_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/2,
52 
Specific_epithet_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1,
53 
Name_submitted,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/2/_if[@name=""if has verbatim name""]/cond/_exists",
54 
Unmatched_terms,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/2/_if[@name=""if has verbatim name""]/else",
55 
Infraspecific_epithet_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond",
56 
Name_matched_rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then",
57 
Infraspecific_epithet_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2,
58 
Name_matched_author,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/2,Contains author based on matched name
59 
Name_matched_rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/2/_alt/3/_if[@name=""if has taxonomic name""]/cond/_has_taxonomic_name/rank",
60 
Taxonomic_status,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonstatus,
61 
Name_matched_author,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/author,Contains author based on matched name
62 
Name_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/binomial,
63 
Name_matched_accepted_family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/family,Contains family based on matched name
64 
Genus_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/genus,
65 
Name_submitted,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/morphospecies/_if[@name=""if has verbatim name""]/cond/_exists",
66 
Unmatched_terms,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/morphospecies/_if[@name=""if has verbatim name""]/else",
67 
Specific_epithet_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/specific_epithet,
68 
Name_matched_rank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/verbatimrank,
69 
Accepted_name_lsid,,** No join mapping for *Accepted_name_lsid **
70 
Accepted_name_species,,** No join mapping for *Accepted_name_species ** Also contains genus. Omitted because Accepted_name contains more info.
71 
Accepted_name_url,,** No join mapping for *Accepted_name_url **
72 
Annotations,,** No join mapping for *Annotations **
73 
Author_score,,** No join mapping for *Author_score **
74 
Infraspecific_epithet_2_matched,,** No non-empty join mapping for UNUSED **
75 
Infraspecific_epithet_2_score,,** No non-empty join mapping for UNUSED **
76 
Infraspecific_epithet_matched,,** No join mapping for verbatimInfraspecificEpithet **
77 
Infraspecific_epithet_score,,** No join mapping for *Infraspecific_epithet_score **
78 
Infraspecific_rank_2,,** No non-empty join mapping for UNUSED **
79 
Name_number,,** No non-empty join mapping for OMIT ** Identifies name only within one TNRS batch. Omitted because not globally unique.
80 
Name_score,,** No join mapping for *Name_score **
81 
Selected,,** No join mapping for *Selected **
82 
Source,,** No join mapping for *Source **
83 
Time_submitted,,** No join mapping for *Time_submitted **
84 
Warnings,,** No join mapping for *Warnings **
inputs/.TNRS/tnrs/cleanup.sql
1 
CLUSTER :table USING tnrs_accepted_names;
inputs/.TNRS/tnrs/unmapped_terms.csv
1 
*Time_submitted
2 
*Name_score
3 
*Author_score
4 
verbatimInfraspecificEpithet
5 
*Infraspecific_epithet_score
6 
*Annotations
7 
*Accepted_name_url
8 
*Accepted_name_species
9 
*Selected
10 
*Source
11 
*Warnings
12 
*Accepted_name_lsid
inputs/.TNRS/tnrs/header.csv
1 
Time_submitted,Name_number,Name_submitted,Overall_score,Name_matched,Name_matched_rank,Name_score,Name_matched_author,Name_matched_url,Author_matched,Author_score,Family_matched,Family_score,Name_matched_accepted_family,Genus_matched,Genus_score,Specific_epithet_matched,Specific_epithet_score,Infraspecific_rank,Infraspecific_epithet_matched,Infraspecific_epithet_score,Infraspecific_rank_2,Infraspecific_epithet_2_matched,Infraspecific_epithet_2_score,Annotations,Unmatched_terms,Taxonomic_status,Accepted_name,Accepted_name_author,Accepted_name_rank,Accepted_name_url,Accepted_name_species,Accepted_name_family,Selected,Source,Warnings,Accepted_name_lsid
inputs/.TNRS/import_order.txt
1 
tnrs_accepted
2 
tnrs_other
inputs/.TNRS/tnrs_other/create.sql
1 
SELECT *
2 
FROM tnrs
3 
WHERE NOT
4 
"Name_submitted" = NULLIF(:schema.array_to_string(ARRAY[
5 
    NULLIF("Accepted_name_family", 'Unknown')
6 
    , "Accepted_name"
7 
    , "Accepted_name_author"
8 
], ' '), '')
9 
ORDER BY "Name_submitted"
10 
;
11 

  		




  
  12
  
    
ALTER TABLE :table ADD PRIMARY KEY ("Name_submitted");


  		












  

    
      inputs/.TNRS/tnrs_other/header.csv
    
  





  
  1
  
    
Time_submitted,Name_number,Name_submitted,Overall_score,Name_matched,Name_matched_rank,Name_score,Name_matched_author,Name_matched_url,Author_matched,Author_score,Family_matched,Family_score,Name_matched_accepted_family,Genus_matched,Genus_score,Specific_epithet_matched,Specific_epithet_score,Infraspecific_rank,Infraspecific_epithet_matched,Infraspecific_epithet_score,Infraspecific_rank_2,Infraspecific_epithet_2_matched,Infraspecific_epithet_2_score,Annotations,Unmatched_terms,Taxonomic_status,Accepted_name,Accepted_name_author,Accepted_name_rank,Accepted_name_url,Accepted_name_species,Accepted_name_family,Selected,Source,Warnings,Accepted_name_lsid


  		












  

    
      inputs/.TNRS/tnrs_other/map.csv
    
  





  
  1
  
    
TNRS,VegCore,Filter,Comments


  		




  
  2
  
    
Time_submitted,*Time_submitted,,


  		




  
  3
  
    
Name_number,OMIT,,Identifies name only within one TNRS batch. Omitted because not globally unique.


  		




  
  4
  
    
Name_submitted,verbatimScientificName,,


  		




  
  5
  
    
Overall_score,matchedTaxonFit_fraction,,Assuming is a fraction based on the range of values


  		




  
  6
  
    
Name_matched,verbatimBinomial,,


  		




  
  7
  
    
Name_matched,binomial,,


  		




  
  8
  
    
Name_matched_rank,taxonRank,,


  		




  
  9
  
    
Name_score,*Name_score,,


  		




  
  10
  
    
Name_matched_author,scientificNameAuthorship,,Contains author based on matched name


  		




  
  11
  
    
Name_matched_url,scientificNameID,,


  		




  
  12
  
    
Author_matched,verbatimScientificNameAuthorship,,Contains author in original string


  		




  
  13
  
    
Author_score,*Author_score,,


  		




  
  14
  
    
Family_matched,verbatimFamily,,Contains family in original string (uncommon)


  		




  
  15
  
    
Family_score,matchedFamilyFit_fraction,,


  		




  
  16
  
    
Name_matched_accepted_family,family,,Contains family based on matched name


  		




  
  17
  
    
Genus_matched,verbatimGenus,,


  		




  
  18
  
    
Genus_matched,genus,,


  		




  
  19
  
    
Genus_score,matchedGenusFit_fraction,,


  		




  
  20
  
    
Specific_epithet_matched,verbatimSpecificEpithet,,


  		




  
  21
  
    
Specific_epithet_matched,specificEpithet,,


  		




  
  22
  
    
Specific_epithet_score,matchedSpeciesFit_fraction,,


  		




  
  23
  
    
Infraspecific_rank,verbatimTaxonRank,,


  		




  
  24
  
    
Infraspecific_epithet_matched,verbatimInfraspecificEpithet,,


  		




  
  25
  
    
Infraspecific_epithet_matched,infraspecificEpithet,,


  		




  
  26
  
    
Infraspecific_epithet_score,*Infraspecific_epithet_score,,


  		




  
  27
  
    
Infraspecific_rank_2,UNUSED,,


  		




  
  28
  
    
Infraspecific_epithet_2_matched,UNUSED,,


  		




  
  29
  
    
Infraspecific_epithet_2_score,UNUSED,,


  		




  
  30
  
    
Annotations,*Annotations,,


  		




  
  31
  
    
Unmatched_terms,morphospecies,,


  		




  
  32
  
    
Taxonomic_status,taxonomicStatus,,


  		




  
  33
  
    
Accepted_name,acceptedBinomial,,


  		




  
  34
  
    
Accepted_name_author,acceptedScientificNameAuthorship,,


  		




  
  35
  
    
Accepted_name_rank,acceptedTaxonRank,,


  		




  
  36
  
    
Accepted_name_url,*Accepted_name_url,,


  		




  
  37
  
    
Accepted_name_species,*Accepted_name_species,,Also contains genus. Omitted because Accepted_name contains more info.


  		




  
  38
  
    
Accepted_name_family,acceptedFamily,/_nullIf:[null=Unknown]/value,


  		




  
  39
  
    
Selected,*Selected,,


  		




  
  40
  
    
Source,*Source,,


  		




  
  41
  
    
Warnings,*Warnings,,


  		




  
  42
  
    
Accepted_name_lsid,*Accepted_name_lsid,,


  		












  

    
      inputs/.TNRS/tnrs_other/test.xml.ref
    
  





  
  1
  
    
Put template:


  		




  
  2
  
    
<VegBIEN>


  		




  
  3
  
    
    <_simplifyPath id="-1">


  		




  
  4
  
    
        <next>parent_id</next>


  		




  
  5
  
    
        <path>


  		




  
  6
  
    
            <location>


  		




  
  7
  
    
                <locationevent>


  		




  
  8
  
    
                    <taxonoccurrence>


  		




  
  9
  
    
                        <taxondetermination>


  		




  
  10
  
    
                            <taxonverbatim_id>


  		




  
  11
  
    
                                <taxonverbatim>


  		




  
  12
  
    
                                    <taxonlabel_id>


  		




  
  13
  
    
                                        <taxonlabel>


  		




  
  14
  
    
                                            <_taxonlabel_set_matched_label_id>


  		




  
  15
  
    
                                                <matched_label_id>


  		




  
  16
  
    
                                                    <taxonlabel>


  		




  
  17
  
    
                                                        <rank>$Accepted_name_rank</rank>


  		




  
  18
  
    
                                                        <taxonomicname>


  		




  
  19
  
    
                                                            <_join_words>


  		




  
  20
  
    
                                                                <1>


  		




  
  21
  
    
                                                                    <_taxon_family_require_std>


  		




  
  22
  
    
                                                                        <family>


  		




  
  23
  
    
                                                                            <_nullIf>


  		




  
  24
  
    
                                                                                <null>Unknown</null>


  		




  
  25
  
    
                                                                                <value>$Accepted_name_family</value>


  		




  
  26
  
    
                                                                            </_nullIf>


  		




  
  27
  
    
                                                                        </family>


  		




  
  28
  
    
                                                                    </_taxon_family_require_std>


  		




  
  29
  
    
                                                                </1>


  		




  
  30
  
    
                                                                <2>


  		




  
  31
  
    
                                                                    <_join_words>


  		




  
  32
  
    
                                                                        <1>$Accepted_name</1>


  		




  
  33
  
    
                                                                        <2>$Accepted_name_author</2>


  		




  
  34
  
    
                                                                    </_join_words>


  		




  
  35
  
    
                                                                </2>


  		




  
  36
  
    
                                                            </_join_words>


  		




  
  37
  
    
                                                        </taxonomicname>


  		




  
  38
  
    
                                                        <taxonverbatim>


  		




  
  39
  
    
                                                            <author>$Accepted_name_author</author>


  		




  
  40
  
    
                                                            <binomial>$Accepted_name</binomial>


  		




  
  41
  
    
                                                            <family>


  		




  
  42
  
    
                                                                <_nullIf>


  		




  
  43
  
    
                                                                    <null>Unknown</null>


  		




  
  44
  
    
                                                                    <value>$Accepted_name_family</value>


  		




  
  45
  
    
                                                                </_nullIf>


  		




  
  46
  
    
                                                            </family>


  		




  
  47
  
    
                                                            <verbatimrank>$Accepted_name_rank</verbatimrank>


  		




  
  48
  
    
                                                        </taxonverbatim>


  		




  
  49
  
    
                                                    </taxonlabel>


  		




  
  50
  
    
                                                </matched_label_id>


  		




  
  51
  
    
                                            </_taxonlabel_set_matched_label_id>


  		




  
  52
  
    
                                            <parent_id>


  		




  
  53
  
    
                                                <taxonlabel>


  		




  
  54
  
    
                                                    <rank>$Name_matched_rank</rank>


  		




  
  55
  
    
                                                    <taxonverbatim><verbatimrank>$Name_matched_rank</verbatimrank></taxonverbatim>


  		




  
  56
  
    
                                                    <parent_id>


  		




  
  57
  
    
                                                        <taxonlabel>


  		




  
  58
  
    
                                                            <rank>cultivar</rank>


  		




  
  59
  
    
                                                            <parent_id>


  		




  
  60
  
    
                                                                <taxonlabel>


  		




  
  61
  
    
                                                                    <rank>forma</rank>


  		




  
  62
  
    
                                                                    <parent_id>


  		




  
  63
  
    
                                                                        <taxonlabel>


  		




  
  64
  
    
                                                                            <rank>variety</rank>


  		




  
  65
  
    
                                                                            <parent_id>


  		




  
  66
  
    
                                                                                <taxonlabel>


  		




  
  67
  
    
                                                                                    <rank>subspecies</rank>


  		




  
  68
  
    
                                                                                    <parent_id>


  		




  
  69
  
    
                                                                                        <taxonlabel>


  		




  
  70
  
    
                                                                                            <rank>species</rank>


  		




  
  71
  
    
                                                                                            <taxonepithet>$Specific_epithet_matched</taxonepithet>


  		




  
  72
  
    
                                                                                            <parent_id>


  		




  
  73
  
    
                                                                                                <taxonlabel>


  		




  
  74
  
    
                                                                                                    <rank>genus</rank>


  		




  
  75
  
    
                                                                                                    <matched_label_id>


  		




  
  76
  
    
                                                                                                        <taxonlabel>


  		




  
  77
  
    
                                                                                                            <creator_id>


  		




  
  78
  
    
                                                                                                                <party>


  		




  
  79
  
    
                                                                                                                    <creator_id>0</creator_id>


  		




  
  80
  
    
                                                                                                                    <organizationname>NCBI</organizationname>


  		




  
  81
  
    
                                                                                                                </party>


  		




  
  82
  
    
                                                                                                            </creator_id>


  		




  
  83
  
    
                                                                                                            <taxonomicname>$Genus_matched</taxonomicname>


  		




  
  84
  
    
                                                                                                        </taxonlabel>


  		




  
  85
  
    
                                                                                                    </matched_label_id>


  		




  
  86
  
    
                                                                                                    <taxonepithet>$Genus_matched</taxonepithet>


  		




  
  87
  
    
                                                                                                    <parent_id>


  		




  
  88
  
    
                                                                                                        <taxonlabel>


  		




  
  89
  
    
                                                                                                            <rank>family</rank>


  		




  
  90
  
    
                                                                                                            <matched_label_id>


  		




  
  91
  
    
                                                                                                                <taxonlabel>


  		




  
  92
  
    
                                                                                                                    <creator_id>


  		




  
  93
  
    
                                                                                                                        <party>


  		




  
  94
  
    
                                                                                                                            <creator_id>0</creator_id>


  		




  
  95
  
    
                                                                                                                            <organizationname>NCBI</organizationname>


  		




  
  96
  
    
                                                                                                                        </party>


  		




  
  97
  
    
                                                                                                                    </creator_id>


  		




  
  98
  
    
                                                                                                                    <taxonomicname>$Name_matched_accepted_family</taxonomicname>


  		




  
  99
  
    
                                                                                                                </taxonlabel>


  		




  
  100
  
    
                                                                                                            </matched_label_id>


  		




  
  101
  
    
                                                                                                            <taxonepithet>$Name_matched_accepted_family</taxonepithet>


  		




  
  102
  
    
                                                                                                        </taxonlabel>


  		




  
  103
  
    
                                                                                                    </parent_id>


  		




  
  104
  
    
                                                                                                </taxonlabel>


  		




  
  105
  
    
                                                                                            </parent_id>


  		




  
  106
  
    
                                                                                        </taxonlabel>


  		




  
  107
  
    
                                                                                    </parent_id>


  		




  
  108
  
    
                                                                                </taxonlabel>


  		




  
  109
  
    
                                                                            </parent_id>


  		




  
  110
  
    
                                                                        </taxonlabel>


  		




  
  111
  
    
                                                                    </parent_id>


  		




  
  112
  
    
                                                                </taxonlabel>


  		




  
  113
  
    
                                                            </parent_id>


  		




  
  114
  
    
                                                        </taxonlabel>


  		




  
  115
  
    
                                                    </parent_id>


  		




  
  116
  
    
                                                    <taxonepithet>$Infraspecific_epithet_matched</taxonepithet>


  		




  
  117
  
    
                                                </taxonlabel>


  		




  
  118
  
    
                                            </parent_id>


  		




  
  119
  
    
                                            <rank>$Name_matched_rank</rank>


  		




  
  120
  
    
                                            <sourceaccessioncode>$Name_matched_url</sourceaccessioncode>


  		




  
  121
  
    
                                            <taxonlabel fkey="matched_label_id">


  		




  
  122
  
    
                                                <matched_label_fit_fraction>


  		




  
  123
  
    
                                                    <_max>


  		




  
  124
  
    
                                                        <1>$Family_score</1>


  		




  
  125
  
    
                                                        <2>$Genus_score</2>


  		




  
  126
  
    
                                                        <3>$Specific_epithet_score</3>


  		




  
  127
  
    
                                                        <4>$Overall_score</4>


  		




  
  128
  
    
                                                    </_max>


  		




  
  129
  
    
                                                </matched_label_fit_fraction>


  		




  
  130
  
    
                                                <taxonepithet>$Unmatched_terms</taxonepithet>


  		




  
  131
  
    
                                                <taxonomicname>$Name_submitted</taxonomicname>


  		




  
  132
  
    
                                                <taxonverbatim>


  		




  
  133
  
    
                                                    <author>$Author_matched</author>


  		




  
  134
  
    
                                                    <binomial>$Name_matched</binomial>


  		




  
  135
  
    
                                                    <family>$Family_matched</family>


  		




  
  136
  
    
                                                    <genus>$Genus_matched</genus>


  		




  
  137
  
    
                                                    <morphospecies>$Unmatched_terms</morphospecies>


  		




  
  138
  
    
                                                    <specific_epithet>$Specific_epithet_matched</specific_epithet>


  		




  
  139
  
    
                                                    <verbatimrank>$Infraspecific_rank</verbatimrank>


  		




  
  140
  
    
                                                </taxonverbatim>


  		




  
  141
  
    
                                            </taxonlabel>


  		




  
  142
  
    
                                            <taxonomicname>


  		




  
  143
  
    
                                                <_join_words>


  		




  
  144
  
    
                                                    <1><_taxon_family_require_std><family>$Name_matched_accepted_family</family></_taxon_family_require_std></1>


  		




  
  145
  
    
                                                    <2>


  		




  
  146
  
    
                                                        <_join_words>


  		




  
  147
  
    
                                                            <1>


  		




  
  148
  
    
                                                                <_alt>


  		




  
  149
  
    
                                                                    <1>$Name_matched</1>


  		




  
  150
  
    
                                                                    <2>


  		




  
  151
  
    
                                                                        <_join_words>


  		




  
  152
  
    
                                                                            <2>$Genus_matched</2>


  		




  
  153
  
    
                                                                            <3>$Specific_epithet_matched</3>


  		




  
  154
  
    
                                                                            <5>


  		




  
  155
  
    
                                                                                <_join_words>


  		




  
  156
  
    
                                                                                    <1>


  		




  
  157
  
    
                                                                                        <_if name="if has infraspecificEpithet">


  		




  
  158
  
    
                                                                                            <cond>$Infraspecific_epithet_matched</cond>


  		




  
  159
  
    
                                                                                            <then>$Name_matched_rank</then>


  		




  
  160
  
    
                                                                                        </_if>


  		




  
  161
  
    
                                                                                    </1>


  		




  
  162
  
    
                                                                                    <2>$Infraspecific_epithet_matched</2>


  		




  
  163
  
    
                                                                                </_join_words>


  		




  
  164
  
    
                                                                            </5>


  		




  
  165
  
    
                                                                        </_join_words>


  		




  
  166
  
    
                                                                    </2>


  		




  
  167
  
    
                                                                </_alt>


  		




  
  168
  
    
                                                            </1>


  		




  
  169
  
    
                                                            <2>$Name_matched_author</2>


  		




  
  170
  
    
                                                        </_join_words>


  		




  
  171
  
    
                                                    </2>


  		




  
  172
  
    
                                                </_join_words>


  		




  
  173
  
    
                                            </taxonomicname>


  		




  
  174
  
    
                                            <taxonstatus>$Taxonomic_status</taxonstatus>


  		




  
  175
  
    
                                        </taxonlabel>


  		




  
  176
  
    
                                    </taxonlabel_id>


  		




  
  177
  
    
                                    <author>$Name_matched_author</author>


  		




  
  178
  
    
                                    <binomial>$Name_matched</binomial>


  		




  
  179
  
    
                                    <family>$Name_matched_accepted_family</family>


  		




  
  180
  
    
                                    <genus>$Genus_matched</genus>


  		




  
  181
  
    
                                    <specific_epithet>$Specific_epithet_matched</specific_epithet>


  		




  
  182
  
    
                                    <verbatimrank>$Name_matched_rank</verbatimrank>


  		




  
  183
  
    
                                </taxonverbatim>


  		




  
  184
  
    
                            </taxonverbatim_id>


  		




  
  185
  
    
                        </taxondetermination>


  		




  
  186
  
    
                    </taxonoccurrence>


  		




  
  187
  
    
                </locationevent>


  		




  
  188
  
    
            </location>


  		




  
  189
  
    
        </path>


  		




  
  190
  
    
    </_simplifyPath>


  		




  
  191
  
    
</VegBIEN>


  		




  
  192
  
    
Inserted 18 new rows into database


  		












  

    
      inputs/.TNRS/tnrs_other/VegBIEN.csv
    
  





  
  1
  
    
TNRS,VegBIEN:/_simplifyPath:[next=parent_id]/path,Comments


  		




  
  2
  
    
Name_matched,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/3",


  		




  
  3
  
    
Name_submitted,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/cond/_exists",


  		




  
  4
  
    
Name_matched_accepted_family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_join_words/1/_taxon_family_require_std/family",Contains family based on matched name


  		




  
  5
  
    
Name_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/1",


  		




  
  6
  
    
Genus_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/2",


  		




  
  7
  
    
Specific_epithet_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",


  		




  
  8
  
    
Unmatched_terms,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/2",


  		




  
  9
  
    
Infraspecific_epithet_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond",


  		




  
  10
  
    
Name_matched_rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then",


  		




  
  11
  
    
Infraspecific_epithet_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2",


  		




  
  12
  
    
Name_matched_author,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_join_words/2/_alt/2/_join_words/2",Contains author based on matched name


  		




  
  13
  
    
Accepted_name_rank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/rank,


  		




  
  14
  
    
Accepted_name_family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/taxonomicname/_join_words/1/_taxon_family_require_std/family/_nullIf:[null=Unknown]/value,


  		




  
  15
  
    
Accepted_name,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/1,


  		




  
  16
  
    
Accepted_name_rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then",


  		




  
  17
  
    
Accepted_name_author,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/2,


  		




  
  18
  
    
Accepted_name_author,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/taxonverbatim/author,


  		




  
  19
  
    
Accepted_name,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/taxonverbatim/binomial,


  		




  
  20
  
    
Accepted_name_family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/taxonverbatim/family/_nullIf:[null=Unknown]/value,


  		




  
  21
  
    
Accepted_name_rank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/taxonverbatim/verbatimrank,


  		




  
  22
  
    
Name_matched_rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/rank",


  		




  
  23
  
    
Name_matched_rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/taxonverbatim/verbatimrank",


  		




  
  24
  
    
Specific_epithet_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=species]/taxonepithet",


  		




  
  25
  
    
Name_submitted,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/_if[@name=""if has verbatim name""]/cond/_exists",


  		




  
  26
  
    
Genus_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/_if[@name=""if has verbatim name""]/then/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=NCBI]/taxonomicname",


  		




  
  27
  
    
Genus_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/taxonepithet",


  		




  
  28
  
    
Name_submitted,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=family]/_if[@name=""if has verbatim name""]/cond/_exists",


  		




  
  29
  
    
Name_matched_accepted_family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=family]/_if[@name=""if has verbatim name""]/then/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=NCBI]/taxonomicname",Contains family based on matched name


  		




  
  30
  
    
Name_matched_accepted_family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_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",Contains family based on matched name


  		




  
  31
  
    
Infraspecific_epithet_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/taxonepithet,


  		




  
  32
  
    
Name_matched_rank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/rank,


  		




  
  33
  
    
Name_matched_url,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/sourceaccessioncode,


  		




  
  34
  
    
Name_matched_rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonepithet/_if[@name=""if taxonomic name is epithet""]/cond/_alt:[2=true]/1/_taxonomic_name_is_epithet/rank",


  		




  
  35
  
    
Family_score,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/matched_label_fit_fraction/_max/1,


  		




  
  36
  
    
Genus_score,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/matched_label_fit_fraction/_max/2,


  		




  
  37
  
    
Specific_epithet_score,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/matched_label_fit_fraction/_max/3,


  		




  
  38
  
    
Overall_score,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/matched_label_fit_fraction/_max/4,Assuming is a fraction based on the range of values


  		




  
  39
  
    
Unmatched_terms,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/taxonepithet,


  		




  
  40
  
    
Name_submitted,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/taxonomicname,


  		




  
  41
  
    
Author_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/taxonverbatim/author,Contains author in original string


  		




  
  42
  
    
Name_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/taxonverbatim/binomial,


  		




  
  43
  
    
Family_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/taxonverbatim/family,Contains family in original string (uncommon)


  		




  
  44
  
    
Genus_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/taxonverbatim/genus,


  		




  
  45
  
    
Name_submitted,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/taxonverbatim/morphospecies/_if[@name=""if has verbatim name""]/cond/_exists",


  		




  
  46
  
    
Unmatched_terms,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/taxonverbatim/morphospecies/_if[@name=""if has verbatim name""]/then",


  		




  
  47
  
    
Specific_epithet_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/taxonverbatim/specific_epithet,


  		




  
  48
  
    
Infraspecific_rank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/taxonverbatim/verbatimrank,


  		




  
  49
  
    
Name_matched_accepted_family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/1/_taxon_family_require_std/family,Contains family based on matched name


  		




  
  50
  
    
Name_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/1,


  		




  
  51
  
    
Genus_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/2,


  		




  
  52
  
    
Specific_epithet_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1,


  		




  
  53
  
    
Name_submitted,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/2/_if[@name=""if has verbatim name""]/cond/_exists",


  		




  
  54
  
    
Unmatched_terms,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/2/_if[@name=""if has verbatim name""]/else",


  		




  
  55
  
    
Infraspecific_epithet_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond",


  		




  
  56
  
    
Name_matched_rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then",


  		




  
  57
  
    
Infraspecific_epithet_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2,


  		




  
  58
  
    
Name_matched_author,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/2,Contains author based on matched name


  		




  
  59
  
    
Name_matched_rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/2/_alt/3/_if[@name=""if has taxonomic name""]/cond/_has_taxonomic_name/rank",


  		




  
  60
  
    
Taxonomic_status,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonstatus,


  		




  
  61
  
    
Name_matched_author,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/author,Contains author based on matched name


  		




  
  62
  
    
Name_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/binomial,


  		




  
  63
  
    
Name_matched_accepted_family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/family,Contains family based on matched name


  		




  
  64
  
    
Genus_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/genus,


  		




  
  65
  
    
Name_submitted,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/morphospecies/_if[@name=""if has verbatim name""]/cond/_exists",


  		




  
  66
  
    
Unmatched_terms,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/morphospecies/_if[@name=""if has verbatim name""]/else",


  		




  
  67
  
    
Specific_epithet_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/specific_epithet,


  		




  
  68
  
    
Name_matched_rank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/verbatimrank,


  		




  
  69
  
    
Accepted_name_lsid,,** No join mapping for *Accepted_name_lsid ** 


  		




  
  70
  
    
Accepted_name_species,,** No join mapping for *Accepted_name_species ** Also contains genus. Omitted because Accepted_name contains more info.


  		




  
  71
  
    
Accepted_name_url,,** No join mapping for *Accepted_name_url ** 


  		




  
  72
  
    
Annotations,,** No join mapping for *Annotations ** 


  		




  
  73
  
    
Author_score,,** No join mapping for *Author_score ** 


  		




  
  74
  
    
Infraspecific_epithet_2_matched,,** No non-empty join mapping for UNUSED ** 


  		




  
  75
  
    
Infraspecific_epithet_2_score,,** No non-empty join mapping for UNUSED ** 


  		




  
  76
  
    
Infraspecific_epithet_matched,,** No join mapping for verbatimInfraspecificEpithet ** 


  		




  
  77
  
    
Infraspecific_epithet_score,,** No join mapping for *Infraspecific_epithet_score ** 


  		




  
  78
  
    
Infraspecific_rank_2,,** No non-empty join mapping for UNUSED ** 


  		




  
  79
  
    
Name_number,,** No non-empty join mapping for OMIT ** Identifies name only within one TNRS batch. Omitted because not globally unique.


  		




  
  80
  
    
Name_score,,** No join mapping for *Name_score ** 


  		




  
  81
  
    
Selected,,** No join mapping for *Selected ** 


  		




  
  82
  
    
Source,,** No join mapping for *Source ** 


  		




  
  83
  
    
Time_submitted,,** No join mapping for *Time_submitted ** 


  		




  
  84
  
    
Warnings,,** No join mapping for *Warnings ** 


  		












  

    
      inputs/.TNRS/tnrs_other/new_terms.csv
    
  





  
  1
  
    
Name_number,OMIT,,Identifies name only within one TNRS batch. Omitted because not globally unique.


  		




  
  2
  
    
Name_submitted,verbatimScientificName,,


  		




  
  3
  
    
Overall_score,matchedTaxonFit_fraction,,Assuming is a fraction based on the range of values


  		




  
  4
  
    
Name_matched,verbatimBinomial,,


  		




  
  5
  
    
Name_matched,binomial,,


  		




  
  6
  
    
Name_matched_rank,taxonRank,,


  		




  
  7
  
    
Name_matched_author,scientificNameAuthorship,,Contains author based on matched name


  		




  
  8
  
    
Name_matched_url,scientificNameID,,


  		




  
  9
  
    
Author_matched,verbatimScientificNameAuthorship,,Contains author in original string


  		




  
  10
  
    
Family_matched,verbatimFamily,,Contains family in original string (uncommon)


  		




  
  11
  
    
Family_score,matchedFamilyFit_fraction,,


  		




  
  12
  
    
Name_matched_accepted_family,family,,Contains family based on matched name


  		




  
  13
  
    
Genus_matched,verbatimGenus,,


  		




  
  14
  
    
Genus_matched,genus,,


  		




  
  15
  
    
Genus_score,matchedGenusFit_fraction,,


  		




  
  16
  
    
Specific_epithet_matched,verbatimSpecificEpithet,,


  		




  
  17
  
    
Specific_epithet_matched,specificEpithet,,


  		




  
  18
  
    
Specific_epithet_score,matchedSpeciesFit_fraction,,


  		




  
  19
  
    
Infraspecific_rank,verbatimTaxonRank,,


  		




  
  20
  
    
Infraspecific_epithet_matched,verbatimInfraspecificEpithet,,


  		




  
  21
  
    
Infraspecific_epithet_matched,infraspecificEpithet,,


  		




  
  22
  
    
Infraspecific_rank_2,UNUSED,,


  		




  
  23
  
    
Infraspecific_epithet_2_matched,UNUSED,,


  		




  
  24
  
    
Infraspecific_epithet_2_score,UNUSED,,


  		




  
  25
  
    
Unmatched_terms,morphospecies,,


  		




  
  26
  
    
Accepted_name,acceptedBinomial,,


  		




  
  27
  
    
Accepted_name_author,acceptedScientificNameAuthorship,,


  		




  
  28
  
    
Accepted_name_rank,acceptedTaxonRank,,


  		




  
  29
  
    
Accepted_name_family,acceptedFamily,/_nullIf:[null=Unknown]/value,


  		












  

    
      inputs/.TNRS/tnrs_other/unmapped_terms.csv
    
  





  
  1
  
    
*Time_submitted


  		




  
  2
  
    
*Name_score


  		




  
  3
  
    
*Author_score


  		




  
  4
  
    
verbatimInfraspecificEpithet


  		




  
  5
  
    
*Infraspecific_epithet_score


  		




  
  6
  
    
*Annotations


  		




  
  7
  
    
*Accepted_name_url


  		




  
  8
  
    
*Accepted_name_species


  		




  
  9
  
    
*Selected


  		




  
  10
  
    
*Source


  		




  
  11
  
    
*Warnings


  		




  
  12
  
    
*Accepted_name_lsid


  		












  

    
      inputs/.TNRS/tnrs_accepted/create.sql
    
  





  
  1
  
    
SELECT *


  		




  
  2
  
    
FROM tnrs


  		




  
  3
  
    
WHERE


  		




  
  4
  
    
"Name_submitted" = NULLIF(:schema.array_to_string(ARRAY[


  		




  
  5
  
    
    NULLIF("Accepted_name_family", 'Unknown')


  		




  
  6
  
    
    , "Accepted_name"


  		




  
  7
  
    
    , "Accepted_name_author"


  		




  
  8
  
    
], ' '), '')


  		




  
  9
  
    
ORDER BY "Name_submitted"


  		




  
  10
  
    
;


  		




  
  11
  
    

  		




  
  12
  
    
ALTER TABLE :table ADD PRIMARY KEY ("Name_submitted");


  		












  

    
      inputs/.TNRS/tnrs_accepted/header.csv
    
  





  
  1
  
    
Time_submitted,Name_number,Name_submitted,Overall_score,Name_matched,Name_matched_rank,Name_score,Name_matched_author,Name_matched_url,Author_matched,Author_score,Family_matched,Family_score,Name_matched_accepted_family,Genus_matched,Genus_score,Specific_epithet_matched,Specific_epithet_score,Infraspecific_rank,Infraspecific_epithet_matched,Infraspecific_epithet_score,Infraspecific_rank_2,Infraspecific_epithet_2_matched,Infraspecific_epithet_2_score,Annotations,Unmatched_terms,Taxonomic_status,Accepted_name,Accepted_name_author,Accepted_name_rank,Accepted_name_url,Accepted_name_species,Accepted_name_family,Selected,Source,Warnings,Accepted_name_lsid


  		












  

    
      inputs/.TNRS/tnrs_accepted/map.csv
    
  





  
  1
  
    
TNRS,VegCore,Filter,Comments


  		




  
  2
  
    
Time_submitted,*Time_submitted,,


  		




  
  3
  
    
Name_number,OMIT,,Identifies name only within one TNRS batch. Omitted because not globally unique.


  		




  
  4
  
    
Name_submitted,verbatimScientificName,,


  		




  
  5
  
    
Overall_score,matchedTaxonFit_fraction,,Assuming is a fraction based on the range of values


  		




  
  6
  
    
Name_matched,verbatimBinomial,,


  		




  
  7
  
    
Name_matched,binomial,,


  		




  
  8
  
    
Name_matched_rank,taxonRank,,


  		




  
  9
  
    
Name_score,*Name_score,,


  		




  
  10
  
    
Name_matched_author,scientificNameAuthorship,,Contains author based on matched name


  		




  
  11
  
    
Name_matched_url,scientificNameID,,


  		




  
  12
  
    
Author_matched,verbatimScientificNameAuthorship,,Contains author in original string


  		




  
  13
  
    
Author_score,*Author_score,,


  		




  
  14
  
    
Family_matched,verbatimFamily,,Contains family in original string (uncommon)


  		




  
  15
  
    
Family_score,matchedFamilyFit_fraction,,


  		




  
  16
  
    
Name_matched_accepted_family,family,,Contains family based on matched name


  		




  
  17
  
    
Genus_matched,verbatimGenus,,


  		




  
  18
  
    
Genus_matched,genus,,


  		




  
  19
  
    
Genus_score,matchedGenusFit_fraction,,


  		




  
  20
  
    
Specific_epithet_matched,verbatimSpecificEpithet,,


  		




  
  21
  
    
Specific_epithet_matched,specificEpithet,,


  		




  
  22
  
    
Specific_epithet_score,matchedSpeciesFit_fraction,,


  		




  
  23
  
    
Infraspecific_rank,verbatimTaxonRank,,


  		




  
  24
  
    
Infraspecific_epithet_matched,verbatimInfraspecificEpithet,,


  		




  
  25
  
    
Infraspecific_epithet_matched,infraspecificEpithet,,


  		




  
  26
  
    
Infraspecific_epithet_score,*Infraspecific_epithet_score,,


  		




  
  27
  
    
Infraspecific_rank_2,UNUSED,,


  		




  
  28
  
    
Infraspecific_epithet_2_matched,UNUSED,,


  		




  
  29
  
    
Infraspecific_epithet_2_score,UNUSED,,


  		




  
  30
  
    
Annotations,*Annotations,,


  		




  
  31
  
    
Unmatched_terms,morphospecies,,


  		




  
  32
  
    
Taxonomic_status,taxonomicStatus,,


  		




  
  33
  
    
Accepted_name,acceptedBinomial,,


  		




  
  34
  
    
Accepted_name_author,acceptedScientificNameAuthorship,,


  		




  
  35
  
    
Accepted_name_rank,acceptedTaxonRank,,


  		




  
  36
  
    
Accepted_name_url,*Accepted_name_url,,


  		




  
  37
  
    
Accepted_name_species,*Accepted_name_species,,Also contains genus. Omitted because Accepted_name contains more info.


  		




  
  38
  
    
Accepted_name_family,acceptedFamily,/_nullIf:[null=Unknown]/value,


  		




  
  39
  
    
Selected,*Selected,,


  		




  
  40
  
    
Source,*Source,,


  		




  
  41
  
    
Warnings,*Warnings,,


  		




  
  42
  
    
Accepted_name_lsid,*Accepted_name_lsid,,


  		












  

    
      inputs/.TNRS/tnrs_accepted/VegBIEN.csv
    
  





  
  1
  
    
TNRS,VegBIEN:/_simplifyPath:[next=parent_id]/path,Comments


  		




  
  2
  
    
Name_matched,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/3",


  		




  
  3
  
    
Name_submitted,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/cond/_exists",


  		




  
  4
  
    
Name_matched_accepted_family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_join_words/1/_taxon_family_require_std/family",Contains family based on matched name


  		




  
  5
  
    
Name_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/1",


  		




  
  6
  
    
Genus_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/2",


  		




  
  7
  
    
Specific_epithet_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",


  		




  
  8
  
    
Unmatched_terms,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/2",


  		




  
  9
  
    
Infraspecific_epithet_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond",


  		




  
  10
  
    
Name_matched_rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then",


  		




  
  11
  
    
Infraspecific_epithet_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2",


  		




  
  12
  
    
Name_matched_author,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_join_words/2/_alt/2/_join_words/2",Contains author based on matched name


  		




  
  13
  
    
Accepted_name_rank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/rank,


  		




  
  14
  
    
Accepted_name_family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/taxonomicname/_join_words/1/_taxon_family_require_std/family/_nullIf:[null=Unknown]/value,


  		




  
  15
  
    
Accepted_name,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/1,


  		




  
  16
  
    
Accepted_name_rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then",


  		




  
  17
  
    
Accepted_name_author,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/2,


  		




  
  18
  
    
Accepted_name_author,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/taxonverbatim/author,


  		




  
  19
  
    
Accepted_name,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/taxonverbatim/binomial,


  		




  
  20
  
    
Accepted_name_family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/taxonverbatim/family/_nullIf:[null=Unknown]/value,


  		




  
  21
  
    
Accepted_name_rank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/taxonverbatim/verbatimrank,


  		




  
  22
  
    
Name_matched_rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/rank",


  		




  
  23
  
    
Name_matched_rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/taxonverbatim/verbatimrank",


  		




  
  24
  
    
Specific_epithet_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=species]/taxonepithet",


  		




  
  25
  
    
Name_submitted,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/_if[@name=""if has verbatim name""]/cond/_exists",


  		




  
  26
  
    
Genus_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/_if[@name=""if has verbatim name""]/then/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=NCBI]/taxonomicname",


  		




  
  27
  
    
Genus_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/taxonepithet",


  		




  
  28
  
    
Name_submitted,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=family]/_if[@name=""if has verbatim name""]/cond/_exists",


  		




  
  29
  
    
Name_matched_accepted_family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=family]/_if[@name=""if has verbatim name""]/then/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=NCBI]/taxonomicname",Contains family based on matched name


  		




  
  30
  
    
Name_matched_accepted_family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_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",Contains family based on matched name


  		




  
  31
  
    
Infraspecific_epithet_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/taxonepithet,


  		




  
  32
  
    
Name_matched_rank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/rank,


  		




  
  33
  
    
Name_matched_url,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/sourceaccessioncode,


  		




  
  34
  
    
Name_matched_rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonepithet/_if[@name=""if taxonomic name is epithet""]/cond/_alt:[2=true]/1/_taxonomic_name_is_epithet/rank",


  		




  
  35
  
    
Family_score,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/matched_label_fit_fraction/_max/1,


  		




  
  36
  
    
Genus_score,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/matched_label_fit_fraction/_max/2,


  		




  
  37
  
    
Specific_epithet_score,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/matched_label_fit_fraction/_max/3,


  		




  
  38
  
    
Overall_score,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/matched_label_fit_fraction/_max/4,Assuming is a fraction based on the range of values


  		




  
  39
  
    
Unmatched_terms,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/taxonepithet,


  		




  
  40
  
    
Name_submitted,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/taxonomicname,


  		




  
  41
  
    
Author_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/taxonverbatim/author,Contains author in original string


  		




  
  42
  
    
Name_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/taxonverbatim/binomial,


  		




  
  43
  
    
Family_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/taxonverbatim/family,Contains family in original string (uncommon)


  		




  
  44
  
    
Genus_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/taxonverbatim/genus,


  		




  
  45
  
    
Name_submitted,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/taxonverbatim/morphospecies/_if[@name=""if has verbatim name""]/cond/_exists",


  		




  
  46
  
    
Unmatched_terms,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/taxonverbatim/morphospecies/_if[@name=""if has verbatim name""]/then",


  		




  
  47
  
    
Specific_epithet_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/taxonverbatim/specific_epithet,


  		




  
  48
  
    
Infraspecific_rank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/taxonverbatim/verbatimrank,


  		




  
  49
  
    
Name_matched_accepted_family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/1/_taxon_family_require_std/family,Contains family based on matched name


  		




  
  50
  
    
Name_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/1,


  		




  
  51
  
    
Genus_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/2,


  		




  
  52
  
    
Specific_epithet_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1,


  		




  
  53
  
    
Name_submitted,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/2/_if[@name=""if has verbatim name""]/cond/_exists",


  		




  
  54
  
    
Unmatched_terms,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/2/_if[@name=""if has verbatim name""]/else",


  		




  
  55
  
    
Infraspecific_epithet_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond",


  		




  
  56
  
    
Name_matched_rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then",


  		




  
  57
  
    
Infraspecific_epithet_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2,


  		




  
  58
  
    
Name_matched_author,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/2,Contains author based on matched name


  		




  
  59
  
    
Name_matched_rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/2/_alt/3/_if[@name=""if has taxonomic name""]/cond/_has_taxonomic_name/rank",


  		




  
  60
  
    
Taxonomic_status,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonstatus,


  		




  
  61
  
    
Name_matched_author,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/author,Contains author based on matched name


  		




  
  62
  
    
Name_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/binomial,


  		




  
  63
  
    
Name_matched_accepted_family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/family,Contains family based on matched name


  		




  
  64
  
    
Genus_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/genus,


  		




  
  65
  
    
Name_submitted,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/morphospecies/_if[@name=""if has verbatim name""]/cond/_exists",


  		




  
  66
  
    
Unmatched_terms,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/morphospecies/_if[@name=""if has verbatim name""]/else",


  		




  
  67
  
    
Specific_epithet_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/specific_epithet,


  		




  
  68
  
    
Name_matched_rank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/verbatimrank,


  		




  
  69
  
    
Accepted_name_lsid,,** No join mapping for *Accepted_name_lsid ** 


  		




  
  70
  
    
Accepted_name_species,,** No join mapping for *Accepted_name_species ** Also contains genus. Omitted because Accepted_name contains more info.


  		




  
  71
  
    
Accepted_name_url,,** No join mapping for *Accepted_name_url ** 


  		




  
  72
  
    
Annotations,,** No join mapping for *Annotations ** 


  		




  
  73
  
    
Author_score,,** No join mapping for *Author_score ** 


  		




  
  74
  
    
Infraspecific_epithet_2_matched,,** No non-empty join mapping for UNUSED ** 


  		




  
  75
  
    
Infraspecific_epithet_2_score,,** No non-empty join mapping for UNUSED ** 


  		




  
  76
  
    
Infraspecific_epithet_matched,,** No join mapping for verbatimInfraspecificEpithet ** 


  		




  
  77
  
    
Infraspecific_epithet_score,,** No join mapping for *Infraspecific_epithet_score ** 


  		




  
  78
  
    
Infraspecific_rank_2,,** No non-empty join mapping for UNUSED ** 


  		




  
  79
  
    
Name_number,,** No non-empty join mapping for OMIT ** Identifies name only within one TNRS batch. Omitted because not globally unique.


  		




  
  80
  
    
Name_score,,** No join mapping for *Name_score ** 


  		




  
  81
  
    
Selected,,** No join mapping for *Selected ** 


  		




  
  82
  
    
Source,,** No join mapping for *Source ** 


  		




  
  83
  
    
Time_submitted,,** No join mapping for *Time_submitted ** 


  		




  
  84
  
    
Warnings,,** No join mapping for *Warnings ** 


  		












  

    
      inputs/.TNRS/tnrs_accepted/test.xml.ref
    
  





  
  1
  
    
Put template:


  		




  
  2
  
    
<VegBIEN>


  		




  
  3
  
    
    <_simplifyPath id="-1">


  		




  
  4
  
    
        <next>parent_id</next>


  		




  
  5
  
    
        <path>


  		




  
  6
  
    
            <location>


  		




  
  7
  
    
                <locationevent>


  		




  
  8
  
    
                    <taxonoccurrence>


  		




  
  9
  
    
                        <taxondetermination>


  		




  
  10
  
    
                            <taxonverbatim_id>


  		




  
  11
  
    
                                <taxonverbatim>


  		




  
  12
  
    
                                    <taxonlabel_id>


  		




  
  13
  
    
                                        <taxonlabel>


  		




  
  14
  
    
                                            <_taxonlabel_set_matched_label_id>


  		




  
  15
  
    
                                                <matched_label_id>


  		




  
  16
  
    
                                                    <taxonlabel>


  		




  
  17
  
    
                                                        <rank>$Accepted_name_rank</rank>


  		




  
  18
  
    
                                                        <taxonomicname>


  		




  
  19
  
    
                                                            <_join_words>


  		




  
  20
  
    
                                                                <1>


  		




  
  21
  
    
                                                                    <_taxon_family_require_std>


  		




  
  22
  
    
                                                                        <family>


  		




  
  23
  
    
                                                                            <_nullIf>


  		




  
  24
  
    
                                                                                <null>Unknown</null>


  		




  
  25
  
    
                                                                                <value>$Accepted_name_family</value>


  		




  
  26
  
    
                                                                            </_nullIf>


  		




  
  27
  
    
                                                                        </family>


  		




  
  28
  
    
                                                                    </_taxon_family_require_std>


  		




  
  29
  
    
                                                                </1>


  		




  
  30
  
    
                                                                <2>


  		




  
  31
  
    
                                                                    <_join_words>


  		




  
  32
  
    
                                                                        <1>$Accepted_name</1>


  		




  
  33
  
    
                                                                        <2>$Accepted_name_author</2>


  		




  
  34
  
    
                                                                    </_join_words>


  		




  
  35
  
    
                                                                </2>


  		




  
  36
  
    
                                                            </_join_words>


  		




  
  37
  
    
                                                        </taxonomicname>


  		




  
  38
  
    
                                                        <taxonverbatim>


  		




  
  39
  
    
                                                            <author>$Accepted_name_author</author>


  		




  
  40
  
    
                                                            <binomial>$Accepted_name</binomial>


  		




  
  41
  
    
                                                            <family>


  		




  
  42
  
    
                                                                <_nullIf>


  		




  
  43
  
    
                                                                    <null>Unknown</null>


  		




  
  44
  
    
                                                                    <value>$Accepted_name_family</value>


  		




  
  45
  
    
                                                                </_nullIf>


  		




  
  46
  
    
                                                            </family>


  		




  
  47
  
    
                                                            <verbatimrank>$Accepted_name_rank</verbatimrank>


  		




  
  48
  
    
                                                        </taxonverbatim>


  		




  
  49
  
    
                                                    </taxonlabel>


  		




  
  50
  
    
                                                </matched_label_id>


  		




  
  51
  
    
                                            </_taxonlabel_set_matched_label_id>


  		




  
  52
  
    
                                            <parent_id>


  		




  
  53
  
    
                                                <taxonlabel>


  		




  
  54
  
    
                                                    <rank>$Name_matched_rank</rank>


  		




  
  55
  
    
                                                    <taxonverbatim><verbatimrank>$Name_matched_rank</verbatimrank></taxonverbatim>


  		




  
  56
  
    
                                                    <parent_id>


  		




  
  57
  
    
                                                        <taxonlabel>


  		




  
  58
  
    
                                                            <rank>cultivar</rank>


  		




  
  59
  
    
                                                            <parent_id>


  		




  
  60
  
    
                                                                <taxonlabel>


  		




  
  61
  
    
                                                                    <rank>forma</rank>


  		




  
  62
  
    
                                                                    <parent_id>


  		




  
  63
  
    
                                                                        <taxonlabel>


  		




  
  64
  
    
                                                                            <rank>variety</rank>


  		




  
  65
  
    
                                                                            <parent_id>


  		




  
  66
  
    
                                                                                <taxonlabel>


  		




  
  67
  
    
                                                                                    <rank>subspecies</rank>


  		




  
  68
  
    
                                                                                    <parent_id>


  		




  
  69
  
    
                                                                                        <taxonlabel>


  		




  
  70
  
    
                                                                                            <rank>species</rank>


  		




  
  71
  
    
                                                                                            <taxonepithet>$Specific_epithet_matched</taxonepithet>


  		




  
  72
  
    
                                                                                            <parent_id>


  		




  
  73
  
    
                                                                                                <taxonlabel>


  		




  
  74
  
    
                                                                                                    <rank>genus</rank>


  		




  
  75
  
    
                                                                                                    <matched_label_id>


  		




  
  76
  
    
                                                                                                        <taxonlabel>


  		




  
  77
  
    
                                                                                                            <creator_id>


  		




  
  78
  
    
                                                                                                                <party>


  		




  
  79
  
    
                                                                                                                    <creator_id>0</creator_id>


  		




  
  80
  
    
                                                                                                                    <organizationname>NCBI</organizationname>


  		




  
  81
  
    
                                                                                                                </party>


  		




  
  82
  
    
                                                                                                            </creator_id>


  		




  
  83
  
    
                                                                                                            <taxonomicname>$Genus_matched</taxonomicname>


  		




  
  84
  
    
                                                                                                        </taxonlabel>


  		




  
  85
  
    
                                                                                                    </matched_label_id>


  		




  
  86
  
    
                                                                                                    <taxonepithet>$Genus_matched</taxonepithet>


  		




  
  87
  
    
                                                                                                    <parent_id>


  		




  
  88
  
    
                                                                                                        <taxonlabel>


  		




  
  89
  
    
                                                                                                            <rank>family</rank>


  		




  
  90
  
    
                                                                                                            <matched_label_id>


  		




  
  91
  
    
                                                                                                                <taxonlabel>


  		




  
  92
  
    
                                                                                                                    <creator_id>


  		




  
  93
  
    
                                                                                                                        <party>


  		




  
  94
  
    
                                                                                                                            <creator_id>0</creator_id>


  		




  
  95
  
    
                                                                                                                            <organizationname>NCBI</organizationname>


  		




  
  96
  
    
                                                                                                                        </party>


  		




  
  97
  
    
                                                                                                                    </creator_id>


  		




  
  98
  
    
                                                                                                                    <taxonomicname>$Name_matched_accepted_family</taxonomicname>


  		




  
  99
  
    
                                                                                                                </taxonlabel>


  		




  
  100
  
    
                                                                                                            </matched_label_id>


  		




  
  101
  
    
                                                                                                            <taxonepithet>$Name_matched_accepted_family</taxonepithet>


  		




  
  102
  
    
                                                                                                        </taxonlabel>


  		




  
  103
  
    
                                                                                                    </parent_id>


  		




  
  104
  
    
                                                                                                </taxonlabel>


  		




  
  105
  
    
                                                                                            </parent_id>


  		




  
  106
  
    
                                                                                        </taxonlabel>


  		




  
  107
  
    
                                                                                    </parent_id>


  		




  
  108
  
    
                                                                                </taxonlabel>


  		




  
  109
  
    
                                                                            </parent_id>


  		




  
  110
  
    
                                                                        </taxonlabel>


  		




  
  111
  
    
                                                                    </parent_id>


  		




  
  112
  
    
                                                                </taxonlabel>


  		




  
  113
  
    
                                                            </parent_id>


  		




  
  114
  
    
                                                        </taxonlabel>


  		




  
  115
  
    
                                                    </parent_id>


  		




  
  116
  
    
                                                    <taxonepithet>$Infraspecific_epithet_matched</taxonepithet>


  		




  
  117
  
    
                                                </taxonlabel>


  		




  
  118
  
    
                                            </parent_id>


  		




  
  119
  
    
                                            <rank>$Name_matched_rank</rank>


  		




  
  120
  
    
                                            <sourceaccessioncode>$Name_matched_url</sourceaccessioncode>


  		




  
  121
  
    
                                            <taxonlabel fkey="matched_label_id">


  		




  
  122
  
    
                                                <matched_label_fit_fraction>


  		




  
  123
  
    
                                                    <_max>


  		




  
  124
  
    
                                                        <1>$Family_score</1>


  		




  
  125
  
    
                                                        <2>$Genus_score</2>


  		




  
  126
  
    
                                                        <3>$Specific_epithet_score</3>


  		




  
  127
  
    
                                                        <4>$Overall_score</4>


  		




  
  128
  
    
                                                    </_max>


  		




  
  129
  
    
                                                </matched_label_fit_fraction>


  		




  
  130
  
    
                                                <taxonepithet>$Unmatched_terms</taxonepithet>


  		




  
  131
  
    
                                                <taxonomicname>$Name_submitted</taxonomicname>


  		




  
  132
  
    
                                                <taxonverbatim>


  		




  
  133
  
    
                                                    <author>$Author_matched</author>


  		




  
  134
  
    
                                                    <binomial>$Name_matched</binomial>


  		




  
  135
  
    
                                                    <family>$Family_matched</family>


  		




  
  136
  
    
                                                    <genus>$Genus_matched</genus>


  		




  
  137
  
    
                                                    <morphospecies>$Unmatched_terms</morphospecies>


  		




  
  138
  
    
                                                    <specific_epithet>$Specific_epithet_matched</specific_epithet>


  		




  
  139
  
    
                                                    <verbatimrank>$Infraspecific_rank</verbatimrank>


  		




  
  140
  
    
                                                </taxonverbatim>


  		




  
  141
  
    
                                            </taxonlabel>


  		




  
  142
  
    
                                            <taxonomicname>


  		




  
  143
  
    
                                                <_join_words>


  		




  
  144
  
    
                                                    <1><_taxon_family_require_std><family>$Name_matched_accepted_family</family></_taxon_family_require_std></1>


  		




  
  145
  
    
                                                    <2>


  		




  
  146
  
    
                                                        <_join_words>


  		




  
  147
  
    
                                                            <1>


  		




  
  148
  
    
                                                                <_alt>


  		




  
  149
  
    
                                                                    <1>$Name_matched</1>


  		




  
  150
  
    
                                                                    <2>


  		




  
  151
  
    
                                                                        <_join_words>


  		




  
  152
  
    
                                                                            <2>$Genus_matched</2>


  		




  
  153
  
    
                                                                            <3>$Specific_epithet_matched</3>


  		




  
  154
  
    
                                                                            <5>


  		




  
  155
  
    
                                                                                <_join_words>


  		




  
  156
  
    
                                                                                    <1>


  		




  
  157
  
    
                                                                                        <_if name="if has infraspecificEpithet">


  		




  
  158
  
    
                                                                                            <cond>$Infraspecific_epithet_matched</cond>


  		




  
  159
  
    
                                                                                            <then>$Name_matched_rank</then>


  		




  
  160
  
    
                                                                                        </_if>


  		




  
  161
  
    
                                                                                    </1>


  		




  
  162
  
    
                                                                                    <2>$Infraspecific_epithet_matched</2>


  		




  
  163
  
    
                                                                                </_join_words>


  		




  
  164
  
    
                                                                            </5>


  		




  
  165
  
    
                                                                        </_join_words>


  		




  
  166
  
    
                                                                    </2>


  		




  
  167
  
    
                                                                </_alt>


  		




  
  168
  
    
                                                            </1>


  		




  
  169
  
    
                                                            <2>$Name_matched_author</2>


  		




  
  170
  
    
                                                        </_join_words>


  		




  
  171
  
    
                                                    </2>


  		




  
  172
  
    
                                                </_join_words>


  		




  
  173
  
    
                                            </taxonomicname>


  		




  
  174
  
    
                                            <taxonstatus>$Taxonomic_status</taxonstatus>


  		




  
  175
  
    
                                        </taxonlabel>


  		




  
  176
  
    
                                    </taxonlabel_id>


  		




  
  177
  
    
                                    <author>$Name_matched_author</author>


  		




  
  178
  
    
                                    <binomial>$Name_matched</binomial>


  		




  
  179
  
    
                                    <family>$Name_matched_accepted_family</family>


  		




  
  180
  
    
                                    <genus>$Genus_matched</genus>


  		




  
  181
  
    
                                    <specific_epithet>$Specific_epithet_matched</specific_epithet>


  		




  
  182
  
    
                                    <verbatimrank>$Name_matched_rank</verbatimrank>


  		




  
  183
  
    
                                </taxonverbatim>


  		




  
  184
  
    
                            </taxonverbatim_id>


  		




  
  185
  
    
                        </taxondetermination>


  		




  
  186
  
    
                    </taxonoccurrence>


  		




  
  187
  
    
                </locationevent>


  		




  
  188
  
    
            </location>


  		




  
  189
  
    
        </path>


  		




  
  190
  
    
    </_simplifyPath>


  		




  
  191
  
    
</VegBIEN>


  		




  
  192
  
    
Inserted 16 new rows into database


  		












  

    
      inputs/.TNRS/tnrs_accepted/unmapped_terms.csv
    
  





  
  1
  
    
*Time_submitted


  		




  
  2
  
    
*Name_score


  		




  
  3
  
    
*Author_score


  		




  
  4
  
    
verbatimInfraspecificEpithet


  		




  
  5
  
    
*Infraspecific_epithet_score


  		




  
  6
  
    
*Annotations


  		




  
  7
  
    
*Accepted_name_url


  		




  
  8
  
    
*Accepted_name_species


  		




  
  9
  
    
*Selected


  		




  
  10
  
    
*Source


  		




  
  11
  
    
*Warnings


  		




  
  12
  
    
*Accepted_name_lsid


  		












  

    
      inputs/.TNRS/tnrs_accepted/new_terms.csv
    
  





  
  1
  
    
Name_number,OMIT,,Identifies name only within one TNRS batch. Omitted because not globally unique.


  		




  
  2
  
    
Name_submitted,verbatimScientificName,,


  		




  
  3
  
    
Overall_score,matchedTaxonFit_fraction,,Assuming is a fraction based on the range of values


  		




  
  4
  
    
Name_matched,verbatimBinomial,,


  		




  
  5
  
    
Name_matched,binomial,,


  		




  
  6
  
    
Name_matched_rank,taxonRank,,


  		




  
  7
  
    
Name_matched_author,scientificNameAuthorship,,Contains author based on matched name


  		




  
  8
  
    
Name_matched_url,scientificNameID,,


  		




  
  9
  
    
Author_matched,verbatimScientificNameAuthorship,,Contains author in original string


  		




  
  10
  
    
Family_matched,verbatimFamily,,Contains family in original string (uncommon)


  		




  
  11
  
    
Family_score,matchedFamilyFit_fraction,,


  		




  
  12
  
    
Name_matched_accepted_family,family,,Contains family based on matched name


  		




  
  13
  
    
Genus_matched,verbatimGenus,,


  		




  
  14
  
    
Genus_matched,genus,,


  		




  
  15
  
    
Genus_score,matchedGenusFit_fraction,,


  		




  
  16
  
    
Specific_epithet_matched,verbatimSpecificEpithet,,


  		




  
  17
  
    
Specific_epithet_matched,specificEpithet,,


  		




  
  18
  
    
Specific_epithet_score,matchedSpeciesFit_fraction,,


  		




  
  19
  
    
Infraspecific_rank,verbatimTaxonRank,,


  		




  
  20
  
    
Infraspecific_epithet_matched,verbatimInfraspecificEpithet,,


  		




  
  21
  
    
Infraspecific_epithet_matched,infraspecificEpithet,,


  		




  
  22
  
    
Infraspecific_rank_2,UNUSED,,


  		




  
  23
  
    
Infraspecific_epithet_2_matched,UNUSED,,


  		




  
  24
  
    
Infraspecific_epithet_2_score,UNUSED,,


  		




  
  25
  
    
Unmatched_terms,morphospecies,,


  		




  
  26
  
    
Accepted_name,acceptedBinomial,,


  		




  
  27
  
    
Accepted_name_author,acceptedScientificNameAuthorship,,


  		




  
  28
  
    
Accepted_name_rank,acceptedTaxonRank,,


  		




  
  29
  
    
Accepted_name_family,acceptedFamily,/_nullIf:[null=Unknown]/value,


  		












Also available in:  Unified diff