Project

General

Profile

« Previous | Next » 

Revision 5861

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

View differences:

test.xml.ref
10 10
                        <2>$Barcode</2>
11 11
                    </_alt>
12 12
                </authorlocationcode>
13
                <locationcoords>
14
                    <latitude_deg>
15
                        <_nullIf>
16
                            <null>0</null>
17
                            <type>float</type>
18
                            <value>$Lat</value>
19
                        </_nullIf>
20
                    </latitude_deg>
21
                    <longitude_deg>
22
                        <_nullIf>
23
                            <null>0</null>
24
                            <type>float</type>
25
                            <value>$Long</value>
26
                        </_nullIf>
27
                    </longitude_deg>
28
                </locationcoords>
29 13
                <locationevent>
30 14
                    <taxonoccurrence>
31 15
                        <aggregateoccurrence>
......
203 187
                        </3>
204 188
                    </_merge>
205 189
                </locationnarrative>
206
                <locationplace><place_id><place><country>$Country</country></place></place_id></locationplace>
190
                <locationplace>
191
                    <place_id>
192
                        <place>
193
                            <coordinates_id>
194
                                <coordinates>
195
                                    <latitude_deg>
196
                                        <_nullIf>
197
                                            <null>0</null>
198
                                            <type>float</type>
199
                                            <value>$Lat</value>
200
                                        </_nullIf>
201
                                    </latitude_deg>
202
                                    <longitude_deg>
203
                                        <_nullIf>
204
                                            <null>0</null>
205
                                            <type>float</type>
206
                                            <value>$Long</value>
207
                                        </_nullIf>
208
                                    </longitude_deg>
209
                                </coordinates>
210
                            </coordinates_id>
211
                            <country>$Country</country>
212
                        </place>
213
                    </place_id>
214
                </locationplace>
207 215
            </location>
208 216
        </path>
209 217
    </_simplifyPath>
210 218
</VegBIEN>
211
Inserted 32 new rows into database
219
Inserted 31 new rows into database

Also available in: Unified diff