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
6 6
            <location>
7 7
                <authorlocationcode>$PlotName</authorlocationcode>
8 8
                <sourceaccessioncode>$PlotID</sourceaccessioncode>
9
                <area>$SizeOfSite</area>
10
                <elevation>
9
                <area_m2>$SizeOfSite</area_m2>
10
                <elevation_m>
11 11
                    <_replace>
12 12
                        <\bca\.?></\bca\.?>
13 13
                        <value>$Elevation</value>
14 14
                    </_replace>
15
                </elevation>
15
                </elevation_m>
16 16
                <locationcoords>
17 17
                    <footprintgeometry_dwc>$ShapeOfSite</footprintgeometry_dwc>
18
                    <latitude>
18
                    <latitude_deg>
19 19
                        <_nullIf>
20 20
                            <null>0</null>
21 21
                            <type>float</type>
22 22
                            <value>$Latitude</value>
23 23
                        </_nullIf>
24
                    </latitude>
25
                    <longitude>
24
                    </latitude_deg>
25
                    <longitude_deg>
26 26
                        <_nullIf>
27 27
                            <null>0</null>
28 28
                            <type>float</type>
29 29
                            <value>$Longitude</value>
30 30
                        </_nullIf>
31
                    </longitude>
31
                    </longitude_deg>
32 32
                </locationcoords>
33 33
                <locationnarrative>
34 34
                    <_alt>

Also available in: Unified diff