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
16 16
                        </2>
17 17
                    </_alt>
18 18
                </authorlocationcode>
19
                <elevation>
19
                <elevation_m>
20 20
                    <_avg>
21 21
                        <max>
22 22
                            <_units>
......
54 54
                            </_units>
55 55
                        </min>
56 56
                    </_avg>
57
                </elevation>
58
                <elevationrange>
57
                </elevation_m>
58
                <elevationrange_m>
59 59
                    <_range>
60 60
                        <from>
61 61
                            <_units>
......
112 112
                            </_units>
113 113
                        </to>
114 114
                    </_range>
115
                </elevationrange>
115
                </elevationrange_m>
116 116
                <locationcoords>
117
                    <coordsaccuracy><_noCV><value>$CoordinatePrecision</value></_noCV></coordsaccuracy>
117
                    <coordsaccuracy_deg><_noCV><value>$CoordinatePrecision</value></_noCV></coordsaccuracy_deg>
118 118
                    <footprintgeometry_dwc>$BoundingBox</footprintgeometry_dwc>
119
                    <latitude>
119
                    <latitude_deg>
120 120
                        <_nullIf>
121 121
                            <null>0</null>
122 122
                            <type>float</type>
123 123
                            <value>$Latitude</value>
124 124
                        </_nullIf>
125
                    </latitude>
126
                    <longitude>
125
                    </latitude_deg>
126
                    <longitude_deg>
127 127
                        <_nullIf>
128 128
                            <null>0</null>
129 129
                            <type>float</type>
130 130
                            <value>$Longitude</value>
131 131
                        </_nullIf>
132
                    </longitude>
132
                    </longitude_deg>
133 133
                </locationcoords>
134 134
                <locationevent>
135 135
                    <taxonoccurrence>
......
246 246
                        </taxondetermination>
247 247
                        <verbatimcollectorname>$Collector</verbatimcollectorname>
248 248
                    </taxonoccurrence>
249
                    <waterdepth>
249
                    <waterdepth_m>
250 250
                        <_avg>
251 251
                            <max>
252 252
                                <_units>
......
275 275
                                </_units>
276 276
                            </min>
277 277
                        </_avg>
278
                    </waterdepth>
278
                    </waterdepth_m>
279 279
                </locationevent>
280 280
                <locationnarrative>
281 281
                    <_merge>

Also available in: Unified diff