Project

General

Profile

1 3641 aaronmk
Put template:
2
<VegBIEN>
3 3786 aaronmk
    <location id="-1">
4
        <locationdetermination>
5
            <namedplace_id>
6
                <_simplifyPath>
7
                    <next>parent_id/namedplace</next>
8
                    <require>placename</require>
9
                    <path>
10
                        <namedplace>
11
                            <rank>county</rank>
12
                            <placename>$county</placename>
13
                            <parent_id>
14
                                <namedplace>
15
                                    <rank>stateProvince</rank>
16
                                    <placename>$state</placename>
17
                                    <parent_id>
18 3641 aaronmk
                                        <namedplace>
19 3786 aaronmk
                                            <rank>country</rank>
20
                                            <placename>$country</placename>
21 3641 aaronmk
                                        </namedplace>
22 3786 aaronmk
                                    </parent_id>
23
                                </namedplace>
24
                            </parent_id>
25
                        </namedplace>
26
                    </path>
27
                </_simplifyPath>
28
            </namedplace_id>
29
        </locationdetermination>
30
        <locationevent>
31
            <obsenddate>
32
                <_date>
33
                    <date>
34
                        <_dateRangeEnd>
35
                            <value>
36
                                <_alt>
37
                                    <1>
38
                                        <_date>
39
                                            <day>
40
                                                <_nullIf>
41
                                                    <null>0</null>
42
                                                    <type>float</type>
43
                                                    <value>$collday</value>
44
                                                </_nullIf>
45
                                            </day>
46
                                            <month>
47
                                                <_nullIf>
48
                                                    <null>0</null>
49
                                                    <type>float</type>
50
                                                    <value>$collmonth</value>
51
                                                </_nullIf>
52
                                            </month>
53
                                            <year>
54
                                                <_nullIf>
55
                                                    <null>0</null>
56
                                                    <type>float</type>
57
                                                    <value>$collyear</value>
58
                                                </_nullIf>
59
                                            </year>
60
                                        </_date>
61
                                    </1>
62
                                </_alt>
63
                            </value>
64
                        </_dateRangeEnd>
65
                    </date>
66
                </_date>
67
            </obsenddate>
68
            <obsstartdate>
69
                <_date>
70
                    <date>
71
                        <_dateRangeStart>
72
                            <value>
73
                                <_alt>
74
                                    <1>
75
                                        <_date>
76
                                            <day>
77
                                                <_nullIf>
78
                                                    <null>0</null>
79
                                                    <type>float</type>
80
                                                    <value>$collday</value>
81
                                                </_nullIf>
82
                                            </day>
83
                                            <month>
84
                                                <_nullIf>
85
                                                    <null>0</null>
86
                                                    <type>float</type>
87
                                                    <value>$collmonth</value>
88
                                                </_nullIf>
89
                                            </month>
90
                                            <year>
91
                                                <_nullIf>
92
                                                    <null>0</null>
93
                                                    <type>float</type>
94
                                                    <value>$collyear</value>
95
                                                </_nullIf>
96
                                            </year>
97
                                        </_date>
98
                                    </1>
99
                                </_alt>
100
                            </value>
101
                        </_dateRangeStart>
102
                    </date>
103
                </_date>
104
            </obsstartdate>
105
            <specimenreplicate>
106
                <collectioncode_dwc>$herbarium</collectioncode_dwc>
107
                <collectionnumber><_alt><1><_alt><1>$collectno</1></_alt></1></_alt></collectionnumber>
108
                <description>
109
                    <_merge>
110
                        <1>
111 3641 aaronmk
                            <_merge>
112 3786 aaronmk
                                <1>$comment1</1>
113
                                <2>$comment2</2>
114
                                <3>$comment3</3>
115
                                <4>$comment4</4>
116
                                <5>
117 3641 aaronmk
                                    <_label>
118 3786 aaronmk
                                        <label>campus</label>
119
                                        <value>$campus</value>
120 3641 aaronmk
                                    </_label>
121 3786 aaronmk
                                </5>
122
                                <6>
123
                                    <_label>
124
                                        <label>loaned to</label>
125
                                        <value>$loanto</value>
126
                                    </_label>
127
                                </6>
128
                                <7>
129
                                    <_label>
130
                                        <label>in or out</label>
131
                                        <value>$inorout</value>
132
                                    </_label>
133
                                </7>
134 3641 aaronmk
                            </_merge>
135 3786 aaronmk
                        </1>
136 3641 aaronmk
                    </_merge>
137 3786 aaronmk
                </description>
138
                <growthform>
139 3780 aaronmk
                    <_map>
140 3786 aaronmk
                        <tree>*</tree>
141
                        <shrub>*</shrub>
142
                        <liana>*</liana>
143
                        <vine>*</vine>
144
                        <herb>*</herb>
145
                        <hemiepiphyte>*</hemiepiphyte>
146
                        <epiphyte>*</epiphyte>
147
                        <grass>*</grass>
148
                        <forb>*</forb>
149
                        <moss>*</moss>
150
                        <lichen>*</lichen>
151
                        <fungus>*</fungus>
152
                        <floating aquatic>*</floating aquatic>
153
                        <submerged aquatic>*</submerged aquatic>
154 3780 aaronmk
                        <*></*>
155 3786 aaronmk
                        <value>
156
                            <_map>
157
                                <Y>cultivated</Y>
158
                                <N>wild</N>
159
                                <*></*>
160
                                <value>$cultivated</value>
161
                            </_map>
162
                        </value>
163 3780 aaronmk
                    </_map>
164 3786 aaronmk
                </growthform>
165
                <iscultivated>
166 3780 aaronmk
                    <_map>
167 3786 aaronmk
                        <cultivated>t</cultivated>
168
                        <wild>f</wild>
169 3780 aaronmk
                        <*></*>
170 3786 aaronmk
                        <value>
171
                            <_map>
172
                                <Y>cultivated</Y>
173
                                <N>wild</N>
174
                                <*></*>
175
                                <value>$cultivated</value>
176
                            </_map>
177
                        </value>
178 3780 aaronmk
                    </_map>
179 3786 aaronmk
                </iscultivated>
180
                <isnative>
181 3780 aaronmk
                    <_map>
182 3786 aaronmk
                        <native>t</native>
183
                        <exotic>f</exotic>
184 3780 aaronmk
                        <*></*>
185 3786 aaronmk
                        <value>
186
                            <_map>
187
                                <Y>cultivated</Y>
188
                                <N>wild</N>
189
                                <*></*>
190
                                <value>$cultivated</value>
191
                            </_map>
192
                        </value>
193 3780 aaronmk
                    </_map>
194 3786 aaronmk
                </isnative>
195
                <sourceaccessioncode>$accession</sourceaccessioncode>
196
                <taxondetermination>
197
                    <isoriginal>true</isoriginal>
198
                    <iscurrent>true</iscurrent>
199
                    <role>identifier</role>
200
                    <plantconcept_id>
201
                        <plantconcept>
202
                            <plantname_id>
203
                                <_simplifyPath>
204
                                    <next>parent_id/plantname</next>
205
                                    <require>plantname</require>
206
                                    <path>
207 3641 aaronmk
                                        <plantname>
208 3786 aaronmk
                                            <rank>binomial</rank>
209
                                            <plantname>$SciName</plantname>
210 3641 aaronmk
                                            <parent_id>
211
                                                <plantname>
212 3786 aaronmk
                                                    <rank>authority</rank>
213
                                                    <plantname>$authors</plantname>
214 3641 aaronmk
                                                    <parent_id>
215
                                                        <plantname>
216 3786 aaronmk
                                                            <rank>subspecies</rank>
217
                                                            <plantname>$infraname</plantname>
218 3641 aaronmk
                                                            <parent_id>
219
                                                                <plantname>
220 3786 aaronmk
                                                                    <rank>species</rank>
221
                                                                    <plantname>$species</plantname>
222 3641 aaronmk
                                                                    <parent_id>
223
                                                                        <plantname>
224 3786 aaronmk
                                                                            <rank>genus</rank>
225
                                                                            <plantname>$genus</plantname>
226
                                                                            <parent_id>
227
                                                                                <plantname>
228
                                                                                    <rank>family</rank>
229
                                                                                    <plantname>$family</plantname>
230
                                                                                </plantname>
231
                                                                            </parent_id>
232 3641 aaronmk
                                                                        </plantname>
233
                                                                    </parent_id>
234
                                                                </plantname>
235
                                                            </parent_id>
236
                                                        </plantname>
237
                                                    </parent_id>
238
                                                </plantname>
239
                                            </parent_id>
240
                                        </plantname>
241 3786 aaronmk
                                    </path>
242
                                </_simplifyPath>
243
                            </plantname_id>
244
                        </plantconcept>
245
                    </plantconcept_id>
246
                </taxondetermination>
247
                <verbatimcollectorname>
248
                    <_merge>
249
                        <1>$collector</1>
250
                        <2>$collector1</2>
251
                        <3>$collector2</3>
252
                        <4>$collector3</4>
253
                    </_merge>
254
                </verbatimcollectorname>
255
            </specimenreplicate>
256
        </locationevent>
257
        <locationnarrative>
258 3641 aaronmk
            <_merge>
259 3786 aaronmk
                <1>$locality</1>
260
                <3>
261
                    <_label>
262
                        <label>habitat</label>
263
                        <value>$habitat</value>
264
                    </_label>
265
                </3>
266 3641 aaronmk
            </_merge>
267 3786 aaronmk
        </locationnarrative>
268
        <sourceaccessioncode>
269
            <_alt>
270
                <1>$accession</1>
271
                <2><_merge><2>$herbarium</2></_merge></2>
272
            </_alt>
273
        </sourceaccessioncode>
274
    </location>
275 3641 aaronmk
</VegBIEN>
276 3199 aaronmk
Inserted 15 new rows into database