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
287 287
                    </date>
288 288
                </_date>
289 289
            </obsstartdate>
290
            <specimenreplicate>
291
                <catalognumber_dwc>
292
                    <_alt>
293
                        <0>$dwc_dwcore_CatalogNumber</0>
294
                        <1>$conceptual_darwin_2003_1_0_CatalogNumber</1>
295
                        <2>$dwc_terms_catalogNumber</2>
296
                    </_alt>
297
                </catalognumber_dwc>
298
                <collectioncode_dwc>
299
                    <_alt>
300
                        <0>$dwc_dwcore_CollectionCode</0>
301
                        <1>$conceptual_darwin_2003_1_0_CollectionCode</1>
302
                        <2>$dwc_terms_collectionCode</2>
303
                    </_alt>
304
                </collectioncode_dwc>
305
                <collectionnumber>
306
                    <_alt>
307
                        <1>
308
                            <_alt>
309
                                <1>
290
            <taxonoccurrence>
291
                <aggregateoccurrence>
292
                    <plantobservation>
293
                        <specimenreplicate>
294
                            <catalognumber_dwc>
295
                                <_alt>
296
                                    <0>$dwc_dwcore_CatalogNumber</0>
297
                                    <1>$conceptual_darwin_2003_1_0_CatalogNumber</1>
298
                                    <2>$dwc_terms_catalogNumber</2>
299
                                </_alt>
300
                            </catalognumber_dwc>
301
                            <collectioncode_dwc>
302
                                <_alt>
303
                                    <0>$dwc_dwcore_CollectionCode</0>
304
                                    <1>$conceptual_darwin_2003_1_0_CollectionCode</1>
305
                                    <2>$dwc_terms_collectionCode</2>
306
                                </_alt>
307
                            </collectioncode_dwc>
308
                            <collectionnumber>
309
                                <_alt>
310
                                    <1>
311
                                        <_alt>
312
                                            <1>
313
                                                <_alt>
314
                                                    <0>$dwc_curatorial_CollectorNumber</0>
315
                                                    <1>$conceptual_darwin_2003_1_0_CollectorNumber</1>
316
                                                </_alt>
317
                                            </1>
318
                                            <2>$dwc_terms_recordNumber</2>
319
                                        </_alt>
320
                                    </1>
321
                                    <2>$dwc_terms_collectionID</2>
322
                                    <3>
323
                                        <_alt>
324
                                            <0>$dwc_curatorial_FieldNumber</0>
325
                                            <1>$conceptual_darwin_2003_1_0_FieldNumber</1>
326
                                            <2>$dwc_terms_fieldNumber</2>
327
                                        </_alt>
328
                                    </3>
329
                                </_alt>
330
                            </collectionnumber>
331
                            <definedvalue fkey="tablerecord_id">
332
                                <userdefined_id>
333
                                    <userdefined>
334
                                        <tablename>specimenreplicate</tablename>
335
                                        <userdefinedname>sex</userdefinedname>
336
                                    </userdefined>
337
                                </userdefined_id>
338
                                <definedvalue>
310 339
                                    <_alt>
311
                                        <0>$dwc_curatorial_CollectorNumber</0>
312
                                        <1>$conceptual_darwin_2003_1_0_CollectorNumber</1>
340
                                        <0>$dwc_dwcore_Sex</0>
341
                                        <1>$conceptual_darwin_2003_1_0_Sex</1>
342
                                        <2>$dwc_terms_sex</2>
313 343
                                    </_alt>
314
                                </1>
315
                                <2>$dwc_terms_recordNumber</2>
316
                            </_alt>
317
                        </1>
318
                        <2>$dwc_terms_collectionID</2>
319
                        <3>
320
                            <_alt>
321
                                <0>$dwc_curatorial_FieldNumber</0>
322
                                <1>$conceptual_darwin_2003_1_0_FieldNumber</1>
323
                                <2>$dwc_terms_fieldNumber</2>
324
                            </_alt>
325
                        </3>
326
                    </_alt>
327
                </collectionnumber>
328
                <definedvalue fkey="tablerecord_id">
329
                    <userdefined_id>
330
                        <userdefined>
331
                            <tablename>specimenreplicate</tablename>
332
                            <userdefinedname>sex</userdefinedname>
333
                        </userdefined>
334
                    </userdefined_id>
335
                    <definedvalue>
336
                        <_alt>
337
                            <0>$dwc_dwcore_Sex</0>
338
                            <1>$conceptual_darwin_2003_1_0_Sex</1>
339
                            <2>$dwc_terms_sex</2>
340
                        </_alt>
341
                    </definedvalue>
342
                </definedvalue>
343
                <description>
344
                    <_merge>
345
                        <1>$conceptual_darwin_2003_1_0_Notes</1>
346
                        <2>$dwc_dwcore_Remarks</2>
347
                    </_merge>
348
                </description>
349
                <institution_id>
350
                    <party>
351
                        <organizationname>
352
                            <_alt>
353
                                <0>$dwc_dwcore_InstitutionCode</0>
354
                                <1>$conceptual_darwin_2003_1_0_InstitutionCode</1>
355
                                <2>$dwc_terms_institutionCode</2>
356
                            </_alt>
357
                        </organizationname>
358
                    </party>
359
                </institution_id>
360
                <sourceaccessioncode>$dwc_dwcore_GlobalUniqueIdentifier</sourceaccessioncode>
344
                                </definedvalue>
345
                            </definedvalue>
346
                            <description>
347
                                <_merge>
348
                                    <1>$conceptual_darwin_2003_1_0_Notes</1>
349
                                    <2>$dwc_dwcore_Remarks</2>
350
                                </_merge>
351
                            </description>
352
                            <institution_id>
353
                                <party>
354
                                    <organizationname>
355
                                        <_alt>
356
                                            <0>$dwc_dwcore_InstitutionCode</0>
357
                                            <1>$conceptual_darwin_2003_1_0_InstitutionCode</1>
358
                                            <2>$dwc_terms_institutionCode</2>
359
                                        </_alt>
360
                                    </organizationname>
361
                                </party>
362
                            </institution_id>
363
                            <sourceaccessioncode>$dwc_dwcore_GlobalUniqueIdentifier</sourceaccessioncode>
364
                            <verbatimcollectorname>
365
                                <_alt>
366
                                    <0>$dwc_dwcore_Collector</0>
367
                                    <1>$conceptual_darwin_2003_1_0_Collector</1>
368
                                    <2>$dwc_terms_recordedBy</2>
369
                                </_alt>
370
                            </verbatimcollectorname>
371
                        </specimenreplicate>
372
                    </plantobservation>
373
                </aggregateoccurrence>
361 374
                <taxondetermination>
362 375
                    <role>identifier</role>
363 376
                    <determinationdate>
......
568 581
                        </plantconcept>
569 582
                    </plantconcept_id>
570 583
                </taxondetermination>
571
                <verbatimcollectorname>
572
                    <_alt>
573
                        <0>$dwc_dwcore_Collector</0>
574
                        <1>$conceptual_darwin_2003_1_0_Collector</1>
575
                        <2>$dwc_terms_recordedBy</2>
576
                    </_alt>
577
                </verbatimcollectorname>
578
            </specimenreplicate>
584
            </taxonoccurrence>
579 585
            <waterdepth>
580 586
                <_avg>
581 587
                    <max>
......
652 658
        </sourceaccessioncode>
653 659
    </location>
654 660
</VegBIEN>
655
Inserted 34 new rows into database
661
Inserted 40 new rows into database

Also available in: Unified diff