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
63 63 
        <locationevent>
64 64 
            <obsenddate><_date><date><_dateRangeEnd><value><_alt><3>$Collect Date</3></_alt></value></_dateRangeEnd></date></_date></obsenddate>
65 65 
            <obsstartdate><_date><date><_dateRangeStart><value><_alt><3>$Collect Date</3></_alt></value></_dateRangeStart></date></_date></obsstartdate>
66 
            <specimenreplicate>
67 
                <catalognumber_dwc>$Barcode</catalognumber_dwc>
68 
                <collectioncode_dwc>$SeriesName</collectioncode_dwc>
69 
                <growthform>
70 
                    <_map>
71 
                        <tree>*</tree>
72 
                        <shrub>*</shrub>
73 
                        <liana>*</liana>
74 
                        <vine>*</vine>
75 
                        <herb>*</herb>
76 
                        <hemiepiphyte>*</hemiepiphyte>
77 
                        <epiphyte>*</epiphyte>
78 
                        <grass>*</grass>
79 
                        <forb>*</forb>
80 
                        <moss>*</moss>
81 
                        <lichen>*</lichen>
82 
                        <fungus>*</fungus>
83 
                        <floating aquatic>*</floating aquatic>
84 
                        <submerged aquatic>*</submerged aquatic>
85 
                        <*></*>
86 
                        <value>
87 
                            <_map>
88 
                                <Yes>cultivated</Yes>
89 
                                <No>wild</No>
90 
                                <value>$Cultivated?</value>
91 
                            </_map>
92 
                        </value>
93 
                    </_map>
94 
                </growthform>
95 
                <iscultivated>
96 
                    <_map>
97 
                        <cultivated>t</cultivated>
98 
                        <wild>f</wild>
99 
                        <*></*>
100 
                        <value>
101 
                            <_map>
102 
                                <Yes>cultivated</Yes>
103 
                                <No>wild</No>
104 
                                <value>$Cultivated?</value>
105 
                            </_map>
106 
                        </value>
107 
                    </_map>
108 
                </iscultivated>
109 
                <isnative>
110 
                    <_map>
111 
                        <native>t</native>
112 
                        <exotic>f</exotic>
113 
                        <*></*>
114 
                        <value>
115 
                            <_map>
116 
                                <Yes>cultivated</Yes>
117 
                                <No>wild</No>
118 
                                <value>$Cultivated?</value>
119 
                            </_map>
120 
                        </value>
121 
                    </_map>
122 
                </isnative>
123 
                <sourceaccessioncode>$Accession Number</sourceaccessioncode>
66 
            <taxonoccurrence>
67 
                <aggregateoccurrence>
68 
                    <plantobservation>
69 
                        <specimenreplicate>
70 
                            <catalognumber_dwc>$Barcode</catalognumber_dwc>
71 
                            <collectioncode_dwc>$SeriesName</collectioncode_dwc>
72 
                            <growthform>
73 
                                <_map>
74 
                                    <tree>*</tree>
75 
                                    <shrub>*</shrub>
76 
                                    <liana>*</liana>
77 
                                    <vine>*</vine>
78 
                                    <herb>*</herb>
79 
                                    <hemiepiphyte>*</hemiepiphyte>
80 
                                    <epiphyte>*</epiphyte>
81 
                                    <grass>*</grass>
82 
                                    <forb>*</forb>
83 
                                    <moss>*</moss>
84 
                                    <lichen>*</lichen>
85 
                                    <fungus>*</fungus>
86 
                                    <floating aquatic>*</floating aquatic>
87 
                                    <submerged aquatic>*</submerged aquatic>
88 
                                    <*></*>
89 
                                    <value>
90 
                                        <_map>
91 
                                            <Yes>cultivated</Yes>
92 
                                            <No>wild</No>
93 
                                            <value>$Cultivated?</value>
94 
                                        </_map>
95 
                                    </value>
96 
                                </_map>
97 
                            </growthform>
98 
                            <iscultivated>
99 
                                <_map>
100 
                                    <cultivated>t</cultivated>
101 
                                    <wild>f</wild>
102 
                                    <*></*>
103 
                                    <value>
104 
                                        <_map>
105 
                                            <Yes>cultivated</Yes>
106 
                                            <No>wild</No>
107 
                                            <value>$Cultivated?</value>
108 
                                        </_map>
109 
                                    </value>
110 
                                </_map>
111 
                            </iscultivated>
112 
                            <isnative>
113 
                                <_map>
114 
                                    <native>t</native>
115 
                                    <exotic>f</exotic>
116 
                                    <*></*>
117 
                                    <value>
118 
                                        <_map>
119 
                                            <Yes>cultivated</Yes>
120 
                                            <No>wild</No>
121 
                                            <value>$Cultivated?</value>
122 
                                        </_map>
123 
                                    </value>
124 
                                </_map>
125 
                            </isnative>
126 
                            <sourceaccessioncode>$Accession Number</sourceaccessioncode>
127 
                        </specimenreplicate>
128 
                    </plantobservation>
129 
                </aggregateoccurrence>
124 130 
                <taxondetermination>
125 131 
                    <isoriginal>true</isoriginal>
126 132 
                    <iscurrent>true</iscurrent>
......
142 148 
                        </plantconcept>
143 149 
                    </plantconcept_id>
144 150 
                </taxondetermination>
145 
            </specimenreplicate>
151 
            </taxonoccurrence>
146 152 
        </locationevent>
147 153 
        <sourceaccessioncode>
148 154 
            <_alt>
......
157 163 
        </sourceaccessioncode>
158 164 
    </location>
159 165 
</VegBIEN>
160 
Inserted 20 new rows into database
166 
Inserted 26 new rows into database

Also available in: Unified diff