Project

General

Profile

« Previous | Next » 

Revision 5861

Added by Aaron Marcuse-Kubitza about 12 years ago

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

View differences:

test.xml.ref
22 22 
                        <value>$Elevation</value>
23 23 
                    </_units>
24 24 
                </elevation_m>
25 
                <locationcoords>
26 
                    <coordsaccuracy_deg><_noCV><value>$Accuracy</value></_noCV></coordsaccuracy_deg>
27 
                    <latitude_deg>
28 
                        <_nullIf>
29 
                            <null>0</null>
30 
                            <type>float</type>
31 
                            <value>
32 
                                <_replace>
33 
                                    <\?$></\?$>
34 
                                    <value>$Lat (-=S)</value>
35 
                                </_replace>
36 
                            </value>
37 
                        </_nullIf>
38 
                    </latitude_deg>
39 
                    <longitude_deg>
40 
                        <_nullIf>
41 
                            <null>0</null>
42 
                            <type>float</type>
43 
                            <value>
44 
                                <_replace>
45 
                                    <\?$></\?$>
46 
                                    <value>$Long (-=W)</value>
47 
                                </_replace>
48 
                            </value>
49 
                        </_nullIf>
50 
                    </longitude_deg>
51 
                </locationcoords>
52 25 
                <locationevent>
53 26 
                    <taxonoccurrence>
54 27 
                        <aggregateoccurrence>
......
91 64 
                <locationplace>
92 65 
                    <place_id>
93 66 
                        <place>
67 
                            <coordinates_id>
68 
                                <coordinates>
69 
                                    <coordsaccuracy_deg><_noCV><value>$Accuracy</value></_noCV></coordsaccuracy_deg>
70 
                                    <latitude_deg>
71 
                                        <_nullIf>
72 
                                            <null>0</null>
73 
                                            <type>float</type>
74 
                                            <value>
75 
                                                <_replace>
76 
                                                    <\?$></\?$>
77 
                                                    <value>$Lat (-=S)</value>
78 
                                                </_replace>
79 
                                            </value>
80 
                                        </_nullIf>
81 
                                    </latitude_deg>
82 
                                    <longitude_deg>
83 
                                        <_nullIf>
84 
                                            <null>0</null>
85 
                                            <type>float</type>
86 
                                            <value>
87 
                                                <_replace>
88 
                                                    <\?$></\?$>
89 
                                                    <value>$Long (-=W)</value>
90 
                                                </_replace>
91 
                                            </value>
92 
                                        </_nullIf>
93 
                                    </longitude_deg>
94 
                                </coordinates>
95 
                            </coordinates_id>
94 96 
                            <country>$Country</country>
95 97 
                            <county>$County</county>
96 98 
                            <stateprovince>$State</stateprovince>
......
102 104 
        </path>
103 105 
    </_simplifyPath>
104 106 
</VegBIEN>
105 
Inserted 28 new rows into database
107 
Inserted 26 new rows into database

Also available in: Unified diff