Project

General

Profile

« Previous | Next » 

Revision 5861

mappings/VegCore-VegBIEN.csv: Remapped latitude/longitude to new coordinates table

View differences:

test.xml.ref
17 17
                        <min>$MinimumElevationInMeter</min>
18 18
                    </_avg>
19 19
                </elevation_m>
20
                <locationcoords>
21
                    <latitude_deg>
22
                        <_nullIf>
23
                            <null>0</null>
24
                            <type>float</type>
25
                            <value>$VerbatimLatitude</value>
26
                        </_nullIf>
27
                    </latitude_deg>
28
                    <longitude_deg>
29
                        <_nullIf>
30
                            <null>0</null>
31
                            <type>float</type>
32
                            <value>$VerbatimLongitude</value>
33
                        </_nullIf>
34
                    </longitude_deg>
35
                </locationcoords>
36 20
                <locationevent>
37 21
                    <taxonoccurrence>
38 22
                        <aggregateoccurrence>
......
258 242
                <locationplace>
259 243
                    <place_id>
260 244
                        <place>
245
                            <coordinates_id>
246
                                <coordinates>
247
                                    <latitude_deg>
248
                                        <_nullIf>
249
                                            <null>0</null>
250
                                            <type>float</type>
251
                                            <value>$VerbatimLatitude</value>
252
                                        </_nullIf>
253
                                    </latitude_deg>
254
                                    <longitude_deg>
255
                                        <_nullIf>
256
                                            <null>0</null>
257
                                            <type>float</type>
258
                                            <value>$VerbatimLongitude</value>
259
                                        </_nullIf>
260
                                    </longitude_deg>
261
                                </coordinates>
262
                            </coordinates_id>
261 263
                            <country>$Country</country>
262 264
                            <county>$County</county>
263 265
                            <stateprovince>$StateProvince</stateprovince>
......
268 270
        </path>
269 271
    </_simplifyPath>
270 272
</VegBIEN>
271
Inserted 43 new rows into database
273
Inserted 41 new rows into database

Also available in: Unified diff