Project

General

Profile

« Previous | Next » 

Revision 5861

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

View differences:

test.xml.ref
5 5
        <path>
6 6
            <location>
7 7
                <authorlocationcode>$Name</authorlocationcode>
8
                <locationcoords>
9
                    <latitude_deg>
10
                        <_nullIf>
11
                            <null>0</null>
12
                            <type>float</type>
13
                            <value>$Latitude</value>
14
                        </_nullIf>
15
                    </latitude_deg>
16
                    <longitude_deg>
17
                        <_nullIf>
18
                            <null>0</null>
19
                            <type>float</type>
20
                            <value>$Longitude</value>
21
                        </_nullIf>
22
                    </longitude_deg>
23
                </locationcoords>
24 8
                <locationevent>
25 9
                    <project_id><project><projectname>$Site Name</projectname></project></project_id>
26 10
                    <obsenddate><_date><date><_dateRangeEnd><value>$CollectionDate</value></_dateRangeEnd></date></_date></obsenddate>
27 11
                    <obsstartdate><_date><date><_dateRangeStart><value>$CollectionDate</value></_dateRangeStart></date></_date></obsstartdate>
28 12
                </locationevent>
13
                <locationplace>
14
                    <place_id>
15
                        <place>
16
                            <coordinates_id>
17
                                <coordinates>
18
                                    <latitude_deg>
19
                                        <_nullIf>
20
                                            <null>0</null>
21
                                            <type>float</type>
22
                                            <value>$Latitude</value>
23
                                        </_nullIf>
24
                                    </latitude_deg>
25
                                    <longitude_deg>
26
                                        <_nullIf>
27
                                            <null>0</null>
28
                                            <type>float</type>
29
                                            <value>$Longitude</value>
30
                                        </_nullIf>
31
                                    </longitude_deg>
32
                                </coordinates>
33
                            </coordinates_id>
34
                        </place>
35
                    </place_id>
36
                </locationplace>
29 37
            </location>
30 38
        </path>
31 39
    </_simplifyPath>
32 40
</VegBIEN>
33
Inserted 8 new rows into database
41
Inserted 12 new rows into database

Also available in: Unified diff