Project

General

Profile

1
Put template:
2
<VegBIEN>
3
    <_setDefault id="-1">
4
        <col>source_id</col>
5
        <value><source><shortname>TNRS</shortname></source></value>
6
        <path>
7
            <_simplifyPath>
8
                <next>parent_id</next>
9
                <path>
10
                    <location>
11
                        <locationevent>
12
                            <taxonoccurrence>
13
                                <taxondetermination>
14
                                    <taxonverbatim_id>
15
                                        <taxonverbatim>
16
                                            <taxonlabel_id>
17
                                                <taxonlabel>
18
                                                    <matched_label_id>
19
                                                        <taxonlabel>
20
                                                            <rank>$Accepted_name_rank</rank>
21
                                                            <taxonomicname>
22
                                                                <_join_words>
23
                                                                    <1>
24
                                                                        <_taxon_family_require_std>
25
                                                                            <family>
26
                                                                                <_nullIf>
27
                                                                                    <null>$Accepted_name</null>
28
                                                                                    <value>
29
                                                                                        <_nullIf>
30
                                                                                            <null>Unknown</null>
31
                                                                                            <value>$Accepted_name_family</value>
32
                                                                                        </_nullIf>
33
                                                                                    </value>
34
                                                                                </_nullIf>
35
                                                                            </family>
36
                                                                        </_taxon_family_require_std>
37
                                                                    </1>
38
                                                                    <2>
39
                                                                        <_join_words>
40
                                                                            <1>$Accepted_name</1>
41
                                                                            <2>$Accepted_name_author</2>
42
                                                                        </_join_words>
43
                                                                    </2>
44
                                                                </_join_words>
45
                                                            </taxonomicname>
46
                                                            <taxonverbatim>
47
                                                                <author>$Accepted_name_author</author>
48
                                                                <family>
49
                                                                    <_nullIf>
50
                                                                        <null>Unknown</null>
51
                                                                        <value>$Accepted_name_family</value>
52
                                                                    </_nullIf>
53
                                                                </family>
54
                                                                <taxonname>$Accepted_name</taxonname>
55
                                                                <verbatimrank>$Accepted_name_rank</verbatimrank>
56
                                                            </taxonverbatim>
57
                                                        </taxonlabel>
58
                                                    </matched_label_id>
59
                                                    <parent_id>
60
                                                        <taxonlabel>
61
                                                            <rank>$Name_matched_rank</rank>
62
                                                            <taxonverbatim><verbatimrank>$Name_matched_rank</verbatimrank></taxonverbatim>
63
                                                            <parent_id>
64
                                                                <taxonlabel>
65
                                                                    <rank>cultivar</rank>
66
                                                                    <parent_id>
67
                                                                        <taxonlabel>
68
                                                                            <rank>forma</rank>
69
                                                                            <parent_id>
70
                                                                                <taxonlabel>
71
                                                                                    <rank>variety</rank>
72
                                                                                    <parent_id>
73
                                                                                        <taxonlabel>
74
                                                                                            <rank>subspecies</rank>
75
                                                                                            <parent_id>
76
                                                                                                <taxonlabel>
77
                                                                                                    <rank>species</rank>
78
                                                                                                    <taxonepithet>$Specific_epithet_matched</taxonepithet>
79
                                                                                                    <parent_id>
80
                                                                                                        <taxonlabel>
81
                                                                                                            <rank>genus</rank>
82
                                                                                                            <taxonepithet>$Genus_matched</taxonepithet>
83
                                                                                                            <parent_id>
84
                                                                                                                <taxonlabel>
85
                                                                                                                    <rank>family</rank>
86
                                                                                                                    <taxonepithet>$Name_matched_accepted_family</taxonepithet>
87
                                                                                                                </taxonlabel>
88
                                                                                                            </parent_id>
89
                                                                                                        </taxonlabel>
90
                                                                                                    </parent_id>
91
                                                                                                </taxonlabel>
92
                                                                                            </parent_id>
93
                                                                                        </taxonlabel>
94
                                                                                    </parent_id>
95
                                                                                </taxonlabel>
96
                                                                            </parent_id>
97
                                                                        </taxonlabel>
98
                                                                    </parent_id>
99
                                                                </taxonlabel>
100
                                                            </parent_id>
101
                                                            <taxonepithet>$Infraspecific_epithet_matched</taxonepithet>
102
                                                        </taxonlabel>
103
                                                    </parent_id>
104
                                                    <rank>$Name_matched_rank</rank>
105
                                                    <sourceaccessioncode>$Name_matched_url</sourceaccessioncode>
106
                                                    <taxonlabel fkey="matched_label_id">
107
                                                        <matched_label_fit_fraction>
108
                                                            <_max>
109
                                                                <1>$Family_score</1>
110
                                                                <2>$Genus_score</2>
111
                                                                <3>$Specific_epithet_score</3>
112
                                                                <4>$Overall_score</4>
113
                                                            </_max>
114
                                                        </matched_label_fit_fraction>
115
                                                        <taxonepithet>$Unmatched_terms</taxonepithet>
116
                                                        <taxonomicname>$Name_submitted</taxonomicname>
117
                                                        <taxonverbatim>
118
                                                            <author>$Author_matched</author>
119
                                                            <family>$Family_matched</family>
120
                                                            <genus>$Genus_matched</genus>
121
                                                            <morphospecies>$Unmatched_terms</morphospecies>
122
                                                            <specific_epithet>$Specific_epithet_matched</specific_epithet>
123
                                                            <taxonname>$Name_matched</taxonname>
124
                                                            <verbatimrank>$Infraspecific_rank</verbatimrank>
125
                                                        </taxonverbatim>
126
                                                    </taxonlabel>
127
                                                    <taxonomicname>
128
                                                        <_join_words>
129
                                                            <1>
130
                                                                <_taxon_family_require_std>
131
                                                                    <family>
132
                                                                        <_nullIf>
133
                                                                            <null>$Name_matched</null>
134
                                                                            <value>$Name_matched_accepted_family</value>
135
                                                                        </_nullIf>
136
                                                                    </family>
137
                                                                </_taxon_family_require_std>
138
                                                            </1>
139
                                                            <2>
140
                                                                <_join_words>
141
                                                                    <1>
142
                                                                        <_alt>
143
                                                                            <1>$Name_matched</1>
144
                                                                            <2>
145
                                                                                <_join_words>
146
                                                                                    <2>$Genus_matched</2>
147
                                                                                    <3>$Specific_epithet_matched</3>
148
                                                                                    <5>
149
                                                                                        <_join_words>
150
                                                                                            <1>
151
                                                                                                <_if name="if has infraspecificEpithet">
152
                                                                                                    <cond>$Infraspecific_epithet_matched</cond>
153
                                                                                                    <then>$Name_matched_rank</then>
154
                                                                                                </_if>
155
                                                                                            </1>
156
                                                                                            <2>$Infraspecific_epithet_matched</2>
157
                                                                                        </_join_words>
158
                                                                                    </5>
159
                                                                                </_join_words>
160
                                                                            </2>
161
                                                                        </_alt>
162
                                                                    </1>
163
                                                                    <2>$Name_matched_author</2>
164
                                                                </_join_words>
165
                                                            </2>
166
                                                        </_join_words>
167
                                                    </taxonomicname>
168
                                                    <taxonstatus>$Taxonomic_status</taxonstatus>
169
                                                </taxonlabel>
170
                                            </taxonlabel_id>
171
                                            <author>$Name_matched_author</author>
172
                                            <family>$Name_matched_accepted_family</family>
173
                                            <genus>$Genus_matched</genus>
174
                                            <specific_epithet>$Specific_epithet_matched</specific_epithet>
175
                                            <taxonname>$Name_matched</taxonname>
176
                                            <verbatimrank>$Name_matched_rank</verbatimrank>
177
                                        </taxonverbatim>
178
                                    </taxonverbatim_id>
179
                                </taxondetermination>
180
                            </taxonoccurrence>
181
                        </locationevent>
182
                    </location>
183
                </path>
184
            </_simplifyPath>
185
        </path>
186
    </_setDefault>
187
</VegBIEN>
188
Inserted 15 new rows into database
(7-7/8)