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
207 207
                    </date>
208 208
                </_date>
209 209
            </obsstartdate>
210
            <specimenreplicate>
211
                <catalognumber_dwc>$CatalogNumber</catalognumber_dwc>
212
                <collectioncode_dwc>$CollectionCode</collectioncode_dwc>
213
                <collectionnumber>
214
                    <_alt>
215
                        <1><_alt><1>$CollectorNumber</1></_alt></1>
216
                        <3>$FieldNumber</3>
217
                    </_alt>
218
                </collectionnumber>
219
                <definedvalue fkey="tablerecord_id">
220
                    <userdefined_id>
221
                        <userdefined>
222
                            <tablename>specimenreplicate</tablename>
223
                            <userdefinedname>sex</userdefinedname>
224
                        </userdefined>
225
                    </userdefined_id>
226
                    <definedvalue>$Sex</definedvalue>
227
                </definedvalue>
228
                <description><_merge><1>$Notes</1></_merge></description>
229
                <institution_id><party><organizationname>$InstitutionCode</organizationname></party></institution_id>
210
            <taxonoccurrence>
211
                <aggregateoccurrence>
212
                    <plantobservation>
213
                        <specimenreplicate>
214
                            <catalognumber_dwc>$CatalogNumber</catalognumber_dwc>
215
                            <collectioncode_dwc>$CollectionCode</collectioncode_dwc>
216
                            <collectionnumber>
217
                                <_alt>
218
                                    <1><_alt><1>$CollectorNumber</1></_alt></1>
219
                                    <3>$FieldNumber</3>
220
                                </_alt>
221
                            </collectionnumber>
222
                            <definedvalue fkey="tablerecord_id">
223
                                <userdefined_id>
224
                                    <userdefined>
225
                                        <tablename>specimenreplicate</tablename>
226
                                        <userdefinedname>sex</userdefinedname>
227
                                    </userdefined>
228
                                </userdefined_id>
229
                                <definedvalue>$Sex</definedvalue>
230
                            </definedvalue>
231
                            <description><_merge><1>$Notes</1></_merge></description>
232
                            <institution_id><party><organizationname>$InstitutionCode</organizationname></party></institution_id>
233
                            <verbatimcollectorname>$Collector</verbatimcollectorname>
234
                        </specimenreplicate>
235
                    </plantobservation>
236
                </aggregateoccurrence>
230 237
                <taxondetermination>
231 238
                    <role>identifier</role>
232 239
                    <determinationdate>
......
346 353
                        </plantconcept>
347 354
                    </plantconcept_id>
348 355
                </taxondetermination>
349
                <verbatimcollectorname>$Collector</verbatimcollectorname>
350
            </specimenreplicate>
356
            </taxonoccurrence>
351 357
            <waterdepth>
352 358
                <_avg>
353 359
                    <max>
......
383 389
        </sourceaccessioncode>
384 390
    </location>
385 391
</VegBIEN>
386
Inserted 41 new rows into database
392
Inserted 47 new rows into database

Also available in: Unified diff