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
                        <3>$accession_number</3>
11 11
                    </_join>
12 12
                </authorlocationcode>
13
                <locationcoords>
14
                    <latitude_deg>
15
                        <_nullIf>
16
                            <null>0</null>
17
                            <type>float</type>
18
                            <value>$lat_deg</value>
19
                        </_nullIf>
20
                    </latitude_deg>
21
                    <longitude_deg>
22
                        <_nullIf>
23
                            <null>0</null>
24
                            <type>float</type>
25
                            <value>$long_deg</value>
26
                        </_nullIf>
27
                    </longitude_deg>
28
                </locationcoords>
29 13
                <locationevent>
30 14
                    <taxonoccurrence>
31 15
                        <aggregateoccurrence>
......
165 149
                <locationplace>
166 150
                    <place_id>
167 151
                        <place>
152
                            <coordinates_id>
153
                                <coordinates>
154
                                    <latitude_deg>
155
                                        <_nullIf>
156
                                            <null>0</null>
157
                                            <type>float</type>
158
                                            <value>$lat_deg</value>
159
                                        </_nullIf>
160
                                    </latitude_deg>
161
                                    <longitude_deg>
162
                                        <_nullIf>
163
                                            <null>0</null>
164
                                            <type>float</type>
165
                                            <value>$long_deg</value>
166
                                        </_nullIf>
167
                                    </longitude_deg>
168
                                </coordinates>
169
                            </coordinates_id>
168 170
                            <country>$country</country>
169 171
                            <county>$county</county>
170 172
                            <stateprovince>$state</stateprovince>
......
175 177
        </path>
176 178
    </_simplifyPath>
177 179
</VegBIEN>
178
Inserted 27 new rows into database
180
Inserted 26 new rows into database

Also available in: Unified diff