Project

General

Profile

« Previous | Next » 

Revision 4753

Added by Aaron Marcuse-Kubitza about 12 years ago

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>$plot_code</authorlocationcode>
8 8 
                <sourceaccessioncode>$PLOT_ID</sourceaccessioncode>
9 
                <area>$plot_area_ha</area>
10 
                <elevation>
9 
                <area_m2>$plot_area_ha</area_m2>
10 
                <elevation_m>
11 11 
                    <_alt>
12 12 
                        <1>
13 13 
                            <_replace>
......
50 50 
                            </_avg>
51 51 
                        </2>
52 52 
                    </_alt>
53 
                </elevation>
54 
                <elevationrange>
53 
                </elevation_m>
54 
                <elevationrange_m>
55 55 
                    <_range>
56 56 
                        <from>
57 57 
                            <_units>
......
98 98 
                            </_units>
99 99 
                        </to>
100 100 
                    </_range>
101 
                </elevationrange>
101 
                </elevationrange_m>
102 102 
                <locationcoords>
103 
                    <latitude>
103 
                    <latitude_deg>
104 104 
                        <_nullIf>
105 105 
                            <null>0</null>
106 106 
                            <type>float</type>
107 107 
                            <value>$lat_decimal</value>
108 108 
                        </_nullIf>
109 
                    </latitude>
110 
                    <longitude>
109 
                    </latitude_deg>
110 
                    <longitude_deg>
111 111 
                        <_nullIf>
112 112 
                            <null>0</null>
113 113 
                            <type>float</type>
114 114 
                            <value>$long_decimal</value>
115 115 
                        </_nullIf>
116 
                    </longitude>
116 
                    </longitude_deg>
117 117 
                </locationcoords>
118 118 
                <locationevent>
119 119 
                    <method_id><method><name>$plot_methodology</name></method></method_id>
......
130 130 
                    </commclass>
131 131 
                    <obsenddate><_date><date>$date_finish</date></_date></obsenddate>
132 132 
                    <obsstartdate><_date><date>$date_start</date></_date></obsstartdate>
133 
                    <precipitation>$precip_mm</precipitation>
133 
                    <precipitation_m>$precip_mm</precipitation_m>
134 134 
                    <soilobs>
135 135 
                        <acidity>
136 136 
                            <_units>
......
240 240 
                        </sodium>
241 241 
                        <texture>$soil_texture</texture>
242 242 
                    </soilobs>
243 
                    <temperature>$temp_c</temperature>
243 
                    <temperature_c>$temp_c</temperature_c>
244 244 
                </locationevent>
245 245 
                <locationnarrative>$locality_description</locationnarrative>
246 246 
                <locationplace>
......
253 253 
                        </placepath>
254 254 
                    </placepath_id>
255 255 
                </locationplace>
256 
                <slopeaspect><_compass><value>$slope_aspect</value></_compass></slopeaspect>
257 
                <slopegradient>$slope_gradient</slopegradient>
256 
                <slopeaspect_deg><_compass><value>$slope_aspect</value></_compass></slopeaspect_deg>
257 
                <slopegradient_frac>$slope_gradient</slopegradient_frac>
258 258 
            </location>
259 259 
        </path>
260 260 
    </_simplifyPath>

Also available in: Unified diff