Project

General

Profile

« Previous | Next » 

Revision 3907

Added by Aaron Marcuse-Kubitza over 12 years ago

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
58 58 
        <locationevent>
59 59 
            <obsenddate><_date><date><_dateRangeEnd><value><_alt><2>$eventDate</2></_alt></value></_dateRangeEnd></date></_date></obsenddate>
60 60 
            <obsstartdate><_date><date><_dateRangeStart><value><_alt><2>$eventDate</2></_alt></value></_dateRangeStart></date></_date></obsstartdate>
61 
            <specimenreplicate>
62 
                <catalognumber_dwc>$catalogNumber</catalognumber_dwc>
63 
                <collectioncode_dwc>$collectionCode</collectioncode_dwc>
64 
                <collectionnumber>
65 
                    <_alt>
66 
                        <1><_alt><2>$recordNumber</2></_alt></1>
67 
                        <2>$collectionID</2>
68 
                    </_alt>
69 
                </collectionnumber>
70 
                <institution_id><party><organizationname>$institutionCode</organizationname></party></institution_id>
71 
                <sourceaccessioncode>$id</sourceaccessioncode>
61 
            <taxonoccurrence>
62 
                <aggregateoccurrence>
63 
                    <plantobservation>
64 
                        <specimenreplicate>
65 
                            <catalognumber_dwc>$catalogNumber</catalognumber_dwc>
66 
                            <collectioncode_dwc>$collectionCode</collectioncode_dwc>
67 
                            <collectionnumber>
68 
                                <_alt>
69 
                                    <1><_alt><2>$recordNumber</2></_alt></1>
70 
                                    <2>$collectionID</2>
71 
                                </_alt>
72 
                            </collectionnumber>
73 
                            <institution_id><party><organizationname>$institutionCode</organizationname></party></institution_id>
74 
                            <sourceaccessioncode>$id</sourceaccessioncode>
75 
                            <verbatimcollectorname>$recordedBy</verbatimcollectorname>
76 
                        </specimenreplicate>
77 
                    </plantobservation>
78 
                </aggregateoccurrence>
72 79 
                <taxondetermination>
73 80 
                    <role>identifier</role>
74 81 
                    <determinationdate><_date><date><_dateRangeStart><value><_alt><2>$dateIdentified</2></_alt></value></_dateRangeStart></date></_date></determinationdate>
......
152 159 
                        </plantconcept>
153 160 
                    </plantconcept_id>
154 161 
                </taxondetermination>
155 
                <verbatimcollectorname>$recordedBy</verbatimcollectorname>
156 
            </specimenreplicate>
162 
            </taxonoccurrence>
157 163 
        </locationevent>
158 164 
        <locationnarrative>
159 165 
            <_merge>
......
180 186 
        </sourceaccessioncode>
181 187 
    </location>
182 188 
</VegBIEN>
183 
Inserted 32 new rows into database
189 
Inserted 38 new rows into database

Also available in: Unified diff