Project

General

Profile

1 3641 aaronmk
Put template:
2
<VegBIEN>
3 4621 aaronmk
    <_simplifyPath id="-1">
4
        <next>parent_id</next>
5
        <path>
6
            <location>
7
                <authorlocationcode>
8
                    <_join>
9
                        <1>$InstitutionCD</1>
10
                        <2>$CollectionCD</2>
11
                        <3>$CatalogNO</3>
12
                    </_join>
13
                </authorlocationcode>
14
                <elevation>
15
                    <_avg>
16
                        <max>
17
                            <_units>
18
                                <default>m</default>
19
                                <to>m</to>
20
                                <to></to>
21 3984 aaronmk
                                <value>
22
                                    <_replace>
23
                                        <\bca\.?></\bca\.?>
24 4621 aaronmk
                                        <value>$MaximumElevationInMeter</value>
25 3984 aaronmk
                                    </_replace>
26
                                </value>
27 4621 aaronmk
                            </_units>
28
                        </max>
29
                        <min>
30
                            <_units>
31
                                <default>m</default>
32
                                <to>m</to>
33
                                <to></to>
34 3786 aaronmk
                                <value>
35 4621 aaronmk
                                    <_rangeStart>
36
                                        <value>
37
                                            <_replace>
38
                                                <\bca\.?></\bca\.?>
39
                                                <value>$MinimumElevationInMeter</value>
40
                                            </_replace>
41
                                        </value>
42
                                    </_rangeStart>
43 3786 aaronmk
                                </value>
44 4621 aaronmk
                            </_units>
45
                        </min>
46
                    </_avg>
47
                </elevation>
48
                <elevationrange>
49
                    <_range>
50
                        <from>
51
                            <_units>
52
                                <default>m</default>
53
                                <to>m</to>
54
                                <to></to>
55
                                <value>
56
                                    <_rangeStart>
57 3786 aaronmk
                                        <value>
58
                                            <_replace>
59
                                                <\bca\.?></\bca\.?>
60
                                                <value>$MinimumElevationInMeter</value>
61
                                            </_replace>
62
                                        </value>
63 4621 aaronmk
                                    </_rangeStart>
64
                                </value>
65
                            </_units>
66
                        </from>
67
                        <to>
68
                            <_units>
69
                                <default>m</default>
70
                                <to>m</to>
71
                                <to></to>
72
                                <value>
73
                                    <_alt>
74
                                        <1>
75
                                            <_replace>
76
                                                <\bca\.?></\bca\.?>
77
                                                <value>$MaximumElevationInMeter</value>
78
                                            </_replace>
79
                                        </1>
80
                                        <2>
81
                                            <_rangeEnd>
82
                                                <value>
83
                                                    <_replace>
84
                                                        <\bca\.?></\bca\.?>
85
                                                        <value>$MinimumElevationInMeter</value>
86
                                                    </_replace>
87
                                                </value>
88
                                            </_rangeEnd>
89
                                        </2>
90
                                    </_alt>
91
                                </value>
92
                            </_units>
93
                        </to>
94
                    </_range>
95
                </elevationrange>
96
                <locationdetermination>
97
                    <latitude>
98
                        <_alt>
99
                            <1>
100
                                <_nullIf>
101
                                    <null>0</null>
102
                                    <type>float</type>
103
                                    <value>$DecimalLatitude</value>
104
                                </_nullIf>
105
                            </1>
106
                            <2>
107
                                <_nullIf>
108
                                    <null>0</null>
109
                                    <type>float</type>
110
                                    <value>$VerbatimLatitude</value>
111
                                </_nullIf>
112
                            </2>
113
                        </_alt>
114
                    </latitude>
115
                    <longitude>
116
                        <_alt>
117
                            <1>
118
                                <_nullIf>
119
                                    <null>0</null>
120
                                    <type>float</type>
121
                                    <value>$DecimalLongitude</value>
122
                                </_nullIf>
123
                            </1>
124
                            <2>
125
                                <_nullIf>
126
                                    <null>0</null>
127
                                    <type>float</type>
128
                                    <value>$VerbatimLongitude</value>
129
                                </_nullIf>
130
                            </2>
131
                        </_alt>
132
                    </longitude>
133
                    <namedplace_id>
134 4622 aaronmk
                        <namedplace>
135
                            <rank>county</rank>
136
                            <placename>$County</placename>
137
                            <parent_id>
138 3786 aaronmk
                                <namedplace>
139 4622 aaronmk
                                    <rank>stateProvince</rank>
140
                                    <placename>$StateProvince</placename>
141 3786 aaronmk
                                    <parent_id>
142
                                        <namedplace>
143 4622 aaronmk
                                            <rank>country</rank>
144
                                            <placename>$Country</placename>
145 3786 aaronmk
                                        </namedplace>
146
                                    </parent_id>
147
                                </namedplace>
148 4622 aaronmk
                            </parent_id>
149
                        </namedplace>
150 4621 aaronmk
                    </namedplace_id>
151
                </locationdetermination>
152
                <locationevent>
153
                    <taxonoccurrence>
154
                        <aggregateoccurrence>
155
                            <collectiondate><_date><date>$LatestDateCollected</date></_date></collectiondate>
156
                            <plantobservation>
157
                                <specimenreplicate>
158
                                    <catalognumber_dwc>$CatalogNO</catalognumber_dwc>
159
                                    <collectioncode_dwc>$CollectionCD</collectioncode_dwc>
160
                                    <institution_id><party><organizationname>$InstitutionCD</organizationname></party></institution_id>
161
                                </specimenreplicate>
162
                            </plantobservation>
163
                        </aggregateoccurrence>
164
                        <authortaxoncode>
165
                            <_alt>
166
                                <1>$ScientificNameOriginal</1>
167 4707 aaronmk
                                <3>$ScientificName</3>
168 4621 aaronmk
                            </_alt>
169
                        </authortaxoncode>
170
                        <taxondetermination>
171
                            <party_id>
172
                                <party>
173
                                    <givenname><_namePart><first>$IdentifiedBy</first></_namePart></givenname>
174
                                    <middlename><_namePart><middle>$IdentifiedBy</middle></_namePart></middlename>
175
                                    <surname><_namePart><last>$IdentifiedBy</last></_namePart></surname>
176
                                </party>
177
                            </party_id>
178 4718 aaronmk
                            <taxonpath_id>
179
                                <taxonpath>
180 4703 aaronmk
                                    <family>$Family</family>
181
                                    <genus>$Genus</genus>
182
                                    <scientificname>$ScientificName</scientificname>
183
                                    <scientificnameauthor>$AuthorOfScientificName</scientificnameauthor>
184
                                    <species>$SpecificEpithet</species>
185
                                    <subspecies>$InfraspecificEpithet</subspecies>
186 4718 aaronmk
                                </taxonpath>
187
                            </taxonpath_id>
188 4621 aaronmk
                        </taxondetermination>
189
                        <taxondetermination>
190
                            <isoriginal>true</isoriginal>
191 4718 aaronmk
                            <taxonpath_id>
192
                                <taxonpath>
193 4703 aaronmk
                                    <family>$GBIFFamilyOriginal</family>
194
                                    <genus>$GBIFGenusOriginal</genus>
195
                                    <scientificname>$ScientificNameOriginal</scientificname>
196 4718 aaronmk
                                </taxonpath>
197
                            </taxonpath_id>
198 4621 aaronmk
                        </taxondetermination>
199
                        <verbatimcollectorname>$Collector</verbatimcollectorname>
200
                    </taxonoccurrence>
201
                </locationevent>
202
                <locationnarrative>$Locality</locationnarrative>
203
            </location>
204
        </path>
205
    </_simplifyPath>
206 3641 aaronmk
</VegBIEN>
207 4703 aaronmk
Inserted 27 new rows into database