Project

General

Profile

« Previous | Next » 

Revision 4753

schemas/vegbien.sql: Added units suffix to all core VegBIEN fields that have units. It is the responsibility of the mappings to ensure that all units are properly translated.

View differences:

test.xml.ref
7 7
                <parent_id><location><authorlocationcode>$1haPlotCode</authorlocationcode></location></parent_id>
8 8
                <authorlocationcode>$Subplot</authorlocationcode>
9 9
                <locationcoords>
10
                    <latitude>
10
                    <latitude_deg>
11 11
                        <_nullIf>
12 12
                            <null>0</null>
13 13
                            <type>float</type>
14 14
                            <value>$Latitude</value>
15 15
                        </_nullIf>
16
                    </latitude>
17
                    <longitude>
16
                    </latitude_deg>
17
                    <longitude_deg>
18 18
                        <_nullIf>
19 19
                            <null>0</null>
20 20
                            <type>float</type>
21 21
                            <value>$Longitude</value>
22 22
                        </_nullIf>
23
                    </longitude>
23
                    </longitude_deg>
24 24
                </locationcoords>
25 25
                <locationevent>
26 26
                    <method_id><method><name>$Method</name></method></method_id>
......
32 32
                            <plantobservation>
33 33
                                <specimenreplicate><sourceaccessioncode>$ID</sourceaccessioncode></specimenreplicate>
34 34
                                <stemobservation>
35
                                    <diameterbreastheight>$dbh</diameterbreastheight>
35
                                    <diameterbreastheight_m>$dbh</diameterbreastheight_m>
36 36
                                    <stemtag>
37 37
                                        <iscurrent>true</iscurrent>
38 38
                                        <tag>$TreeNumber</tag>
39 39
                                    </stemtag>
40
                                    <xposition>$X_1haPlot</xposition>
41
                                    <yposition>$Y_1haPlot</yposition>
40
                                    <xposition_m>$X_1haPlot</xposition_m>
41
                                    <yposition_m>$Y_1haPlot</yposition_m>
42 42
                                </stemobservation>
43 43
                            </plantobservation>
44 44
                        </aggregateoccurrence>

Also available in: Unified diff