Project

General

Profile

1 3641 aaronmk
Put template:
2
<VegBIEN>
3 4621 aaronmk
    <_simplifyPath id="-1">
4
        <next>parent_id</next>
5
        <path>
6
            <location>
7
                <authorlocationcode>
8
                    <_alt>
9
                        <1>$Accession Number</1>
10
                        <2>
11
                            <_join>
12
                                <2>$SeriesName</2>
13
                                <3>$Barcode</3>
14
                            </_join>
15
                        </2>
16
                    </_alt>
17
                </authorlocationcode>
18 4753 aaronmk
                <elevation_m>
19 4818 aaronmk
                    <_units>
20
                        <to>m</to>
21
                        <to></to>
22 4621 aaronmk
                        <value>$Elevation</value>
23 4818 aaronmk
                    </_units>
24 4753 aaronmk
                </elevation_m>
25 4726 aaronmk
                <locationevent>
26
                    <taxonoccurrence>
27
                        <aggregateoccurrence>
28
                            <collectiondate><_date><date>$Collect Date</date></_date></collectiondate>
29
                            <plantobservation>
30
                                <specimenreplicate>
31
                                    <catalognumber_dwc>$Barcode</catalognumber_dwc>
32
                                    <collectioncode_dwc>$SeriesName</collectioncode_dwc>
33
                                    <sourceaccessioncode>$Accession Number</sourceaccessioncode>
34
                                </specimenreplicate>
35
                            </plantobservation>
36
                        </aggregateoccurrence>
37
                        <iscultivated>$Cultivated?</iscultivated>
38 4834 aaronmk
                        <sourceaccessioncode>$Accession Number</sourceaccessioncode>
39 5012 aaronmk
                        <taxondetermination>
40 5657 aaronmk
                            <taxonverbatim_id>
41
                                <taxonverbatim>
42
                                    <taxonlabel_id>
43 5608 aaronmk
                                        <taxonlabel>
44 5657 aaronmk
                                            <matched_label_id>
45
                                                <taxonlabel>
46
                                                    <creator_id>
47
                                                        <party>
48
                                                            <creator_id>0</creator_id>
49
                                                            <organizationname>TNRS</organizationname>
50
                                                        </party>
51
                                                    </creator_id>
52
                                                    <taxonomicname>$Full Taxon Name</taxonomicname>
53
                                                </taxonlabel>
54
                                            </matched_label_id>
55 5656 aaronmk
                                            <taxonomicname>$Full Taxon Name</taxonomicname>
56 5608 aaronmk
                                        </taxonlabel>
57 5657 aaronmk
                                    </taxonlabel_id>
58
                                    <binomial>$Full Taxon Name</binomial>
59
                                </taxonverbatim>
60
                            </taxonverbatim_id>
61 5012 aaronmk
                        </taxondetermination>
62 4726 aaronmk
                    </taxonoccurrence>
63
                </locationevent>
64
                <locationplace>
65 5855 aaronmk
                    <place_id>
66
                        <place>
67 5861 aaronmk
                            <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>
96 4727 aaronmk
                            <country>$Country</country>
97
                            <county>$County</county>
98
                            <stateprovince>$State</stateprovince>
99 5855 aaronmk
                        </place>
100
                    </place_id>
101 4726 aaronmk
                </locationplace>
102 4818 aaronmk
                <verbatimelevation>$Elevation</verbatimelevation>
103 4621 aaronmk
            </location>
104
        </path>
105
    </_simplifyPath>
106 3641 aaronmk
</VegBIEN>
107 5861 aaronmk
Inserted 26 new rows into database