Project

General

Profile

« Previous | Next » 

Revision 3907

mappings/DwC2-VegBIEN.specimens.csv: Mapped specimenreplicate via plantobservation for consistency with plots data. (This change is required for VegCSV table merging to work properly.) This is also a more accurate way of representing the data, because a specimen in fact comes from a plant, and it's natural to place the plant-related data (measurements, etc.) in the plantobservation table.

View differences:

import.specimens.xml.ref
102 102
                    </date>
103 103
                </_date>
104 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
                            <_merge>
112
                                <1>$comment1</1>
113
                                <2>$comment2</2>
114
                                <3>$comment3</3>
115
                                <4>$comment4</4>
116
                                <5>
117
                                    <_label>
118
                                        <label>campus</label>
119
                                        <value>$campus</value>
120
                                    </_label>
121
                                </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
                            </_merge>
135
                        </1>
136
                    </_merge>
137
                </description>
138
                <growthform>
139
                    <_map>
140
                        <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
                        <*></*>
155
                        <value>
156
                            <_map>
157
                                <Y>cultivated</Y>
158
                                <N>wild</N>
159
                                <*></*>
160
                                <value>$cultivated</value>
161
                            </_map>
162
                        </value>
163
                    </_map>
164
                </growthform>
165
                <iscultivated>
166
                    <_map>
167
                        <cultivated>t</cultivated>
168
                        <wild>f</wild>
169
                        <*></*>
170
                        <value>
171
                            <_map>
172
                                <Y>cultivated</Y>
173
                                <N>wild</N>
174
                                <*></*>
175
                                <value>$cultivated</value>
176
                            </_map>
177
                        </value>
178
                    </_map>
179
                </iscultivated>
180
                <isnative>
181
                    <_map>
182
                        <native>t</native>
183
                        <exotic>f</exotic>
184
                        <*></*>
185
                        <value>
186
                            <_map>
187
                                <Y>cultivated</Y>
188
                                <N>wild</N>
189
                                <*></*>
190
                                <value>$cultivated</value>
191
                            </_map>
192
                        </value>
193
                    </_map>
194
                </isnative>
195
                <sourceaccessioncode>$accession</sourceaccessioncode>
105
            <taxonoccurrence>
106
                <aggregateoccurrence>
107
                    <plantobservation>
108
                        <specimenreplicate>
109
                            <collectioncode_dwc>$herbarium</collectioncode_dwc>
110
                            <collectionnumber><_alt><1><_alt><1>$collectno</1></_alt></1></_alt></collectionnumber>
111
                            <description>
112
                                <_merge>
113
                                    <1>
114
                                        <_merge>
115
                                            <1>$comment1</1>
116
                                            <2>$comment2</2>
117
                                            <3>$comment3</3>
118
                                            <4>$comment4</4>
119
                                            <5>
120
                                                <_label>
121
                                                    <label>campus</label>
122
                                                    <value>$campus</value>
123
                                                </_label>
124
                                            </5>
125
                                            <6>
126
                                                <_label>
127
                                                    <label>loaned to</label>
128
                                                    <value>$loanto</value>
129
                                                </_label>
130
                                            </6>
131
                                            <7>
132
                                                <_label>
133
                                                    <label>in or out</label>
134
                                                    <value>$inorout</value>
135
                                                </_label>
136
                                            </7>
137
                                        </_merge>
138
                                    </1>
139
                                </_merge>
140
                            </description>
141
                            <growthform>
142
                                <_map>
143
                                    <tree>*</tree>
144
                                    <shrub>*</shrub>
145
                                    <liana>*</liana>
146
                                    <vine>*</vine>
147
                                    <herb>*</herb>
148
                                    <hemiepiphyte>*</hemiepiphyte>
149
                                    <epiphyte>*</epiphyte>
150
                                    <grass>*</grass>
151
                                    <forb>*</forb>
152
                                    <moss>*</moss>
153
                                    <lichen>*</lichen>
154
                                    <fungus>*</fungus>
155
                                    <floating aquatic>*</floating aquatic>
156
                                    <submerged aquatic>*</submerged aquatic>
157
                                    <*></*>
158
                                    <value>
159
                                        <_map>
160
                                            <Y>cultivated</Y>
161
                                            <N>wild</N>
162
                                            <*></*>
163
                                            <value>$cultivated</value>
164
                                        </_map>
165
                                    </value>
166
                                </_map>
167
                            </growthform>
168
                            <iscultivated>
169
                                <_map>
170
                                    <cultivated>t</cultivated>
171
                                    <wild>f</wild>
172
                                    <*></*>
173
                                    <value>
174
                                        <_map>
175
                                            <Y>cultivated</Y>
176
                                            <N>wild</N>
177
                                            <*></*>
178
                                            <value>$cultivated</value>
179
                                        </_map>
180
                                    </value>
181
                                </_map>
182
                            </iscultivated>
183
                            <isnative>
184
                                <_map>
185
                                    <native>t</native>
186
                                    <exotic>f</exotic>
187
                                    <*></*>
188
                                    <value>
189
                                        <_map>
190
                                            <Y>cultivated</Y>
191
                                            <N>wild</N>
192
                                            <*></*>
193
                                            <value>$cultivated</value>
194
                                        </_map>
195
                                    </value>
196
                                </_map>
197
                            </isnative>
198
                            <sourceaccessioncode>$accession</sourceaccessioncode>
199
                            <verbatimcollectorname>
200
                                <_merge>
201
                                    <1>$collector</1>
202
                                    <2>$collector1</2>
203
                                    <3>$collector2</3>
204
                                    <4>$collector3</4>
205
                                </_merge>
206
                            </verbatimcollectorname>
207
                        </specimenreplicate>
208
                    </plantobservation>
209
                </aggregateoccurrence>
196 210
                <taxondetermination>
197 211
                    <isoriginal>true</isoriginal>
198 212
                    <iscurrent>true</iscurrent>
......
244 258
                        </plantconcept>
245 259
                    </plantconcept_id>
246 260
                </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>
261
            </taxonoccurrence>
256 262
        </locationevent>
257 263
        <locationnarrative>
258 264
            <_merge>
......
273 279
        </sourceaccessioncode>
274 280
    </location>
275 281
</VegBIEN>
276
Inserted 15 new rows into database
282
Inserted 21 new rows into database

Also available in: Unified diff