Project

General

Profile

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