Project

General

Profile

1 7657 aaronmk
Put template:
2
<VegBIEN>
3
    <_setDefault id="-1">
4 10866 aaronmk
        <source_id><source><shortname>TEX.new</shortname></source></source_id>
5 7657 aaronmk
        <path>
6
            <_simplifyPath>
7
                <next>parent_id</next>
8
                <path>
9
                    <location>
10
                        <authorlocationcode>
11
                            <_join>
12 10625 aaronmk
                                <2>$collection</2>
13
                                <3>$accessionNumber</3>
14 7657 aaronmk
                            </_join>
15
                        </authorlocationcode>
16
                        <elevation_m>
17
                            <_units>
18
                                <to>m</to>
19
                                <to></to>
20 10625 aaronmk
                                <value>$verbatimElevation</value>
21 7657 aaronmk
                            </_units>
22
                        </elevation_m>
23
                        <iscultivated>
24
                            <_locationnarrative_is_cultivated>
25
                                <locationnarrative>
26
                                    <_join>
27 10625 aaronmk
                                        <1>$locality</1>
28
                                        <3>$habitat</3>
29 7657 aaronmk
                                    </_join>
30
                                </locationnarrative>
31
                            </_locationnarrative_is_cultivated>
32
                        </iscultivated>
33
                        <locationevent>
34
                            <taxonoccurrence>
35
                                <aggregateoccurrence>
36 10620 aaronmk
                                    <collectiondate>$dateCollected</collectiondate>
37 10625 aaronmk
                                    <notes>$occurrenceRemarks</notes>
38 7657 aaronmk
                                    <plantobservation>
39 10625 aaronmk
                                        <authorplantcode>$collectorNumber</authorplantcode>
40
                                        <reproductivecondition>$reproductiveCondition</reproductivecondition>
41 7657 aaronmk
                                        <specimenreplicate>
42 10625 aaronmk
                                            <catalognumber_dwc>$accessionNumber</catalognumber_dwc>
43
                                            <collectioncode_dwc>$collection</collectioncode_dwc>
44
                                            <collectionnumber>$collectorNumber</collectionnumber>
45 7657 aaronmk
                                        </specimenreplicate>
46
                                    </plantobservation>
47
                                </aggregateoccurrence>
48 10625 aaronmk
                                <collector_id><party><fullname>$recordedBy</fullname></party></collector_id>
49 7657 aaronmk
                                <iscultivated>
50
                                    <_map>
51
                                        <cultivated>t</cultivated>
52
                                        <wild>f</wild>
53
                                        <*></*>
54 10625 aaronmk
                                        <value>$establishmentMeans</value>
55 7657 aaronmk
                                    </_map>
56
                                </iscultivated>
57
                                <isnative>
58
                                    <_map>
59
                                        <native>t</native>
60
                                        <exotic>f</exotic>
61
                                        <*></*>
62 10625 aaronmk
                                        <value>$establishmentMeans</value>
63 7657 aaronmk
                                    </_map>
64
                                </isnative>
65
                                <taxondetermination>
66 10625 aaronmk
                                    <party_id><party><fullname>$identifiedBy</fullname></party></party_id>
67 7657 aaronmk
                                    <taxonverbatim_id>
68
                                        <taxonverbatim>
69
                                            <taxonlabel_id>
70
                                                <taxonlabel>
71
                                                    <parent_id>
72
                                                        <taxonlabel>
73
                                                            <parent_id>
74
                                                                <taxonlabel>
75
                                                                    <rank>cultivar</rank>
76
                                                                    <parent_id>
77
                                                                        <taxonlabel>
78
                                                                            <rank>forma</rank>
79
                                                                            <parent_id>
80
                                                                                <taxonlabel>
81
                                                                                    <rank>variety</rank>
82
                                                                                    <parent_id>
83
                                                                                        <taxonlabel>
84
                                                                                            <rank>subspecies</rank>
85
                                                                                            <parent_id>
86
                                                                                                <taxonlabel>
87
                                                                                                    <rank>species</rank>
88 10625 aaronmk
                                                                                                    <taxonepithet>$specificEpithet</taxonepithet>
89 7657 aaronmk
                                                                                                    <parent_id>
90
                                                                                                        <taxonlabel>
91
                                                                                                            <rank>genus</rank>
92 10625 aaronmk
                                                                                                            <taxonepithet>$genus</taxonepithet>
93 7657 aaronmk
                                                                                                            <parent_id>
94
                                                                                                                <taxonlabel>
95
                                                                                                                    <rank>family</rank>
96 10625 aaronmk
                                                                                                                    <taxonepithet>$family</taxonepithet>
97 7657 aaronmk
                                                                                                                </taxonlabel>
98
                                                                                                            </parent_id>
99
                                                                                                        </taxonlabel>
100
                                                                                                    </parent_id>
101
                                                                                                </taxonlabel>
102
                                                                                            </parent_id>
103
                                                                                        </taxonlabel>
104
                                                                                    </parent_id>
105
                                                                                </taxonlabel>
106
                                                                            </parent_id>
107
                                                                        </taxonlabel>
108
                                                                    </parent_id>
109
                                                                </taxonlabel>
110
                                                            </parent_id>
111 10625 aaronmk
                                                            <taxonepithet>$infraspecificEpithet</taxonepithet>
112 7657 aaronmk
                                                        </taxonlabel>
113
                                                    </parent_id>
114
                                                    <taxonomicname>
115
                                                        <_merge_prefix>
116 10625 aaronmk
                                                            <prefix><_taxon_family_require_std><family>$family</family></_taxon_family_require_std></prefix>
117 7657 aaronmk
                                                            <value>
118
                                                                <_join_words>
119
                                                                    <1>
120
                                                                        <_join_words>
121 10625 aaronmk
                                                                            <2><_filter_genus><value>$genus</value></_filter_genus></2>
122
                                                                            <3>$specificEpithet</3>
123
                                                                            <5>$infraspecificEpithet</5>
124 7657 aaronmk
                                                                        </_join_words>
125
                                                                    </1>
126 10625 aaronmk
                                                                    <2>$scientificNameAuthorship</2>
127 7657 aaronmk
                                                                </_join_words>
128
                                                            </value>
129
                                                        </_merge_prefix>
130
                                                    </taxonomicname>
131
                                                </taxonlabel>
132
                                            </taxonlabel_id>
133 10625 aaronmk
                                            <author>$scientificNameAuthorship</author>
134
                                            <family>$family</family>
135
                                            <genus>$genus</genus>
136
                                            <specific_epithet>$specificEpithet</specific_epithet>
137 7657 aaronmk
                                        </taxonverbatim>
138
                                    </taxonverbatim_id>
139
                                </taxondetermination>
140
                            </taxonoccurrence>
141
                        </locationevent>
142
                        <locationnarrative>
143
                            <_merge>
144 10625 aaronmk
                                <1>$locality</1>
145 7657 aaronmk
                                <3>
146
                                    <_label>
147
                                        <label>habitat</label>
148 10625 aaronmk
                                        <value>$habitat</value>
149 7657 aaronmk
                                    </_label>
150
                                </3>
151
                            </_merge>
152
                        </locationnarrative>
153
                        <locationplace>
154
                            <place_id>
155
                                <place>
156
                                    <coordinates_id>
157
                                        <coordinates>
158
                                            <latitude_deg>
159 7670 aaronmk
                                                <_dms_to_dd>
160 10625 aaronmk
                                                    <deg>$latitude_deg</deg>
161
                                                    <min>$latitude_min</min>
162
                                                    <sec>$latitude_sec</sec>
163 7670 aaronmk
                                                </_dms_to_dd>
164 7657 aaronmk
                                            </latitude_deg>
165
                                            <longitude_deg>
166 7670 aaronmk
                                                <_dms_to_dd>
167 10625 aaronmk
                                                    <deg>$longitude_deg</deg>
168
                                                    <min>$longitude_min</min>
169
                                                    <sec>$longitude_sec</sec>
170 7670 aaronmk
                                                </_dms_to_dd>
171 7657 aaronmk
                                            </longitude_deg>
172
                                        </coordinates>
173
                                    </coordinates_id>
174 10625 aaronmk
                                    <county>$county</county>
175 7657 aaronmk
                                    <matched_place_id>
176
                                        <place>
177
                                            <source_id><source><shortname>geoscrub</shortname></source></source_id>
178
                                            <coordinates_id>
179
                                                <coordinates>
180
                                                    <source_id><source><shortname>geoscrub</shortname></source></source_id>
181
                                                    <latitude_deg>
182 7670 aaronmk
                                                        <_dms_to_dd>
183 10625 aaronmk
                                                            <deg>$latitude_deg</deg>
184
                                                            <min>$latitude_min</min>
185
                                                            <sec>$latitude_sec</sec>
186 7670 aaronmk
                                                        </_dms_to_dd>
187 7657 aaronmk
                                                    </latitude_deg>
188
                                                    <longitude_deg>
189 7670 aaronmk
                                                        <_dms_to_dd>
190 10625 aaronmk
                                                            <deg>$longitude_deg</deg>
191
                                                            <min>$longitude_min</min>
192
                                                            <sec>$longitude_sec</sec>
193 7670 aaronmk
                                                        </_dms_to_dd>
194 7657 aaronmk
                                                    </longitude_deg>
195
                                                </coordinates>
196
                                            </coordinates_id>
197 10625 aaronmk
                                            <county>$county</county>
198
                                            <stateprovince>$stateProvince</stateprovince>
199 7657 aaronmk
                                        </place>
200
                                    </matched_place_id>
201 10625 aaronmk
                                    <stateprovince>$stateProvince</stateprovince>
202 7657 aaronmk
                                </place>
203
                            </place_id>
204
                        </locationplace>
205 10625 aaronmk
                        <verbatimelevation>$verbatimElevation</verbatimelevation>
206 7657 aaronmk
                    </location>
207
                </path>
208
            </_simplifyPath>
209
        </path>
210
    </_setDefault>
211
</VegBIEN>
212
Inserted 38 new rows into database