Project

General

Profile

1
Put template:
2
<VegBIEN>
3
    <location id="-1">
4
        <locationdetermination>
5
            <latitude>
6
                <_alt>
7
                    <1>
8
                        <_nullIf>
9
                            <null>0</null>
10
                            <type>float</type>
11
                            <value>$decimalLatitude</value>
12
                        </_nullIf>
13
                    </1>
14
                </_alt>
15
            </latitude>
16
            <longitude>
17
                <_alt>
18
                    <1>
19
                        <_nullIf>
20
                            <null>0</null>
21
                            <type>float</type>
22
                            <value>$decimalLongitude</value>
23
                        </_nullIf>
24
                    </1>
25
                </_alt>
26
            </longitude>
27
            <namedplace_id>
28
                <_simplifyPath>
29
                    <next>parent_id/namedplace</next>
30
                    <require>placename</require>
31
                    <path>
32
                        <namedplace>
33
                            <rank>county</rank>
34
                            <placename>$county</placename>
35
                            <parent_id>
36
                                <namedplace>
37
                                    <rank>stateProvince</rank>
38
                                    <placename>$stateProvince</placename>
39
                                    <parent_id>
40
                                        <namedplace>
41
                                            <rank>country</rank>
42
                                            <placename>$country</placename>
43
                                            <parent_id>
44
                                                <namedplace>
45
                                                    <rank>continent</rank>
46
                                                    <placename>$continent</placename>
47
                                                </namedplace>
48
                                            </parent_id>
49
                                        </namedplace>
50
                                    </parent_id>
51
                                </namedplace>
52
                            </parent_id>
53
                        </namedplace>
54
                    </path>
55
                </_simplifyPath>
56
            </namedplace_id>
57
        </locationdetermination>
58
        <locationevent>
59
            <taxonoccurrence>
60
                <aggregateoccurrence>
61
                    <collectiondate><_date><date><_dateRangeStart><value><_alt><2>$eventDate</2></_alt></value></_dateRangeStart></date></_date></collectiondate>
62
                    <plantobservation>
63
                        <specimenreplicate>
64
                            <_if name="if indirect voucher"><else><catalognumber_dwc>$catalogNumber</catalognumber_dwc></else></_if>
65
                            <collectioncode_dwc>
66
                                <_alt>
67
                                    <1>$collectionCode</1>
68
                                    <2>$collectionID</2>
69
                                </_alt>
70
                            </collectioncode_dwc>
71
                            <collectionnumber><_alt><1><_alt><2>$recordNumber</2></_alt></1></_alt></collectionnumber>
72
                            <institution_id><party><organizationname>$institutionCode</organizationname></party></institution_id>
73
                            <sourceaccessioncode>$id</sourceaccessioncode>
74
                        </specimenreplicate>
75
                    </plantobservation>
76
                </aggregateoccurrence>
77
                <taxondetermination>
78
                    <role>identifier</role>
79
                    <determinationdate><_date><date><_dateRangeStart><value><_alt><2>$dateIdentified</2></_alt></value></_dateRangeStart></date></_date></determinationdate>
80
                    <iscurrent>true</iscurrent>
81
                    <party_id>
82
                        <party>
83
                            <givenname><_namePart><first>$identifiedBy</first></_namePart></givenname>
84
                            <middlename><_namePart><middle>$identifiedBy</middle></_namePart></middlename>
85
                            <surname><_namePart><last>$identifiedBy</last></_namePart></surname>
86
                        </party>
87
                    </party_id>
88
                    <isoriginal>true</isoriginal>
89
                    <plantconcept_id>
90
                        <plantconcept>
91
                            <plantname_id>
92
                                <_simplifyPath>
93
                                    <next>parent_id/plantname</next>
94
                                    <require>plantname</require>
95
                                    <path>
96
                                        <plantname>
97
                                            <rank>binomial</rank>
98
                                            <plantname>$scientificName</plantname>
99
                                            <parent_id>
100
                                                <plantname>
101
                                                    <rank>authority</rank>
102
                                                    <plantname>$scientificNameAuthorship</plantname>
103
                                                    <parent_id>
104
                                                        <plantname>
105
                                                            <rank>subspecies</rank>
106
                                                            <plantname>$infraspecificEpithet</plantname>
107
                                                            <parent_id>
108
                                                                <plantname>
109
                                                                    <rank>species</rank>
110
                                                                    <plantname>$specificEpithet</plantname>
111
                                                                    <parent_id>
112
                                                                        <plantname>
113
                                                                            <rank>genus</rank>
114
                                                                            <plantname>$genus</plantname>
115
                                                                            <parent_id>
116
                                                                                <plantname>
117
                                                                                    <rank>family</rank>
118
                                                                                    <plantname>$family</plantname>
119
                                                                                    <parent_id>
120
                                                                                        <plantname>
121
                                                                                            <rank>order</rank>
122
                                                                                            <plantname>$order</plantname>
123
                                                                                            <parent_id>
124
                                                                                                <plantname>
125
                                                                                                    <rank>class</rank>
126
                                                                                                    <plantname>$class</plantname>
127
                                                                                                    <parent_id>
128
                                                                                                        <plantname>
129
                                                                                                            <rank>subkingdom</rank>
130
                                                                                                            <plantname>$phylum</plantname>
131
                                                                                                            <parent_id>
132
                                                                                                                <plantname>
133
                                                                                                                    <rank>kingdom</rank>
134
                                                                                                                    <plantname>$kingdom</plantname>
135
                                                                                                                </plantname>
136
                                                                                                            </parent_id>
137
                                                                                                        </plantname>
138
                                                                                                    </parent_id>
139
                                                                                                </plantname>
140
                                                                                            </parent_id>
141
                                                                                        </plantname>
142
                                                                                    </parent_id>
143
                                                                                </plantname>
144
                                                                            </parent_id>
145
                                                                        </plantname>
146
                                                                    </parent_id>
147
                                                                </plantname>
148
                                                            </parent_id>
149
                                                        </plantname>
150
                                                    </parent_id>
151
                                                </plantname>
152
                                            </parent_id>
153
                                        </plantname>
154
                                    </path>
155
                                </_simplifyPath>
156
                            </plantname_id>
157
                        </plantconcept>
158
                    </plantconcept_id>
159
                </taxondetermination>
160
                <verbatimcollectorname>$recordedBy</verbatimcollectorname>
161
            </taxonoccurrence>
162
        </locationevent>
163
        <locationnarrative>
164
            <_merge>
165
                <1>$locality</1>
166
                <3>
167
                    <_label>
168
                        <label>habitat</label>
169
                        <value>$habitat</value>
170
                    </_label>
171
                </3>
172
            </_merge>
173
        </locationnarrative>
174
        <sourceaccessioncode>
175
            <_alt>
176
                <1>$id</1>
177
                <2>
178
                    <_merge>
179
                        <1>$institutionCode</1>
180
                        <2>$collectionCode</2>
181
                        <3>$catalogNumber</3>
182
                    </_merge>
183
                </2>
184
            </_alt>
185
        </sourceaccessioncode>
186
    </location>
187
</VegBIEN>
188
Inserted 38 new rows into database
    (1-1/1)