Project

General

Profile

« Previous | Next » 

Revision 5861

Added by Aaron Marcuse-Kubitza over 12 years ago

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

View differences:

test.xml.ref
6 6 
            <location>
7 7 
                <parent_id><location><authorlocationcode>$1ha Plot Number</authorlocationcode></location></parent_id>
8 8 
                <authorlocationcode>$Subplot Number</authorlocationcode>
9 
                <locationcoords>
10 
                    <latitude_deg>
11 
                        <_nullIf>
12 
                            <null>0</null>
13 
                            <type>float</type>
14 
                            <value>$Latitude</value>
15 
                        </_nullIf>
16 
                    </latitude_deg>
17 
                    <longitude_deg>
18 
                        <_nullIf>
19 
                            <null>0</null>
20 
                            <type>float</type>
21 
                            <value>$Longitude</value>
22 
                        </_nullIf>
23 
                    </longitude_deg>
24 
                </locationcoords>
25 9 
                <locationevent>
26 10 
                    <method_id><method><name>$Method</name></method></method_id>
27 11 
                    <project_id><project><projectname>$Site Name</projectname></project></project_id>
......
131 115 
                        <verbatimcollectorname>$Names of Collectors</verbatimcollectorname>
132 116 
                    </taxonoccurrence>
133 117 
                </locationevent>
118 
                <locationplace>
119 
                    <place_id>
120 
                        <place>
121 
                            <coordinates_id>
122 
                                <coordinates>
123 
                                    <latitude_deg>
124 
                                        <_nullIf>
125 
                                            <null>0</null>
126 
                                            <type>float</type>
127 
                                            <value>$Latitude</value>
128 
                                        </_nullIf>
129 
                                    </latitude_deg>
130 
                                    <longitude_deg>
131 
                                        <_nullIf>
132 
                                            <null>0</null>
133 
                                            <type>float</type>
134 
                                            <value>$Longitude</value>
135 
                                        </_nullIf>
136 
                                    </longitude_deg>
137 
                                </coordinates>
138 
                            </coordinates_id>
139 
                        </place>
140 
                    </place_id>
141 
                </locationplace>
134 142 
                <sourceaccessioncode>
135 143 
                    <_join>
136 144 
                        <1>$1ha Plot Number</1>
......
141 149 
        </path>
142 150 
    </_simplifyPath>
143 151 
</VegBIEN>
144 
Inserted 34 new rows into database
152 
Inserted 32 new rows into database

Also available in: Unified diff