Project

General

Profile

« Previous | Next » 

Revision 11009

bugfix: inputs/VegBank/stemlocation_/map.csv: remapped stemcount-related fields to OMIT, so that these don't collide with fields of the same name in stemcount_ when they are left-joined together in taxon_observation.** . having the same name causes these to be incorrectly interpreted as shared fkey columns in the NATURAL JOIN (and without the NATURAL JOIN, they would instead be collision errors).

View differences:

test.xml.ref
10 10
                        <locationevent>
11 11
                            <taxonoccurrence>
12 12
                                <aggregateoccurrence>
13
                                    <count>$individualCount</count>
14 13
                                    <plantobservation>
15 14
                                        <sourceaccessioncode>$individualID</sourceaccessioncode>
16
                                        <stemobservation>
17
                                            <diameterbreastheight_m><_cm_to_m><value>$diameterBreastHeight_cm</value></_cm_to_m></diameterbreastheight_m>
18
                                            <height_m>$height_m</height_m>
19
                                            <sourceaccessioncode>$stemID</sourceaccessioncode>
20
                                        </stemobservation>
15
                                        <stemobservation><sourceaccessioncode>$stemID</sourceaccessioncode></stemobservation>
21 16
                                    </plantobservation>
22 17
                                    <sourceaccessioncode>$aggregateOrganismObservationID</sourceaccessioncode>
23 18
                                </aggregateoccurrence>

Also available in: Unified diff