Project

General

Profile

1
Put template:
2
<VegBIEN>
3
    <location id="-1">
4
        <authorlocationcode>
5
            <_alt>
6
                <3>$Accession Number</3>
7
                <4>
8
                    <_merge>
9
                        <2>$SeriesName</2>
10
                        <3>$Barcode</3>
11
                    </_merge>
12
                </4>
13
            </_alt>
14
        </authorlocationcode>
15
        <elevation>
16
            <_replace>
17
                <\bca\.?></\bca\.?>
18
                <value>$Elevation</value>
19
            </_replace>
20
        </elevation>
21
        <locationdetermination>
22
            <coordsaccuracy><_noCV><value>$Accuracy</value></_noCV></coordsaccuracy>
23
            <latitude>
24
                <_nullIf>
25
                    <null>0</null>
26
                    <type>float</type>
27
                    <value>
28
                        <_replace>
29
                            <\?$></\?$>
30
                            <value>$Lat (-=S)</value>
31
                        </_replace>
32
                    </value>
33
                </_nullIf>
34
            </latitude>
35
            <longitude>
36
                <_nullIf>
37
                    <null>0</null>
38
                    <type>float</type>
39
                    <value>
40
                        <_replace>
41
                            <\?$></\?$>
42
                            <value>$Long (-=W)</value>
43
                        </_replace>
44
                    </value>
45
                </_nullIf>
46
            </longitude>
47
            <namedplace_id>
48
                <_simplifyPath>
49
                    <next>parent_id/namedplace</next>
50
                    <require>placename</require>
51
                    <path>
52
                        <namedplace>
53
                            <rank>county</rank>
54
                            <placename>$County</placename>
55
                            <parent_id>
56
                                <namedplace>
57
                                    <rank>stateProvince</rank>
58
                                    <placename>$State</placename>
59
                                    <parent_id>
60
                                        <namedplace>
61
                                            <rank>country</rank>
62
                                            <placename>$Country</placename>
63
                                        </namedplace>
64
                                    </parent_id>
65
                                </namedplace>
66
                            </parent_id>
67
                        </namedplace>
68
                    </path>
69
                </_simplifyPath>
70
            </namedplace_id>
71
        </locationdetermination>
72
        <locationevent>
73
            <obsenddate><_date><date><_dateRangeEnd><value>$Collect Date</value></_dateRangeEnd></date></_date></obsenddate>
74
            <obsstartdate><_date><date><_dateRangeStart><value>$Collect Date</value></_dateRangeStart></date></_date></obsstartdate>
75
            <taxonoccurrence>
76
                <aggregateoccurrence>
77
                    <collectiondate><_date><date>$Collect Date</date></_date></collectiondate>
78
                    <plantobservation>
79
                        <specimenreplicate>
80
                            <catalognumber_dwc>$Barcode</catalognumber_dwc>
81
                            <collectioncode_dwc>$SeriesName</collectioncode_dwc>
82
                            <sourceaccessioncode>$Accession Number</sourceaccessioncode>
83
                        </specimenreplicate>
84
                    </plantobservation>
85
                </aggregateoccurrence>
86
                <authortaxoncode>$Full Taxon Name</authortaxoncode>
87
                <iscultivated>
88
                    <_map>
89
                        <cultivated>t</cultivated>
90
                        <wild>f</wild>
91
                        <*></*>
92
                        <value>
93
                            <_map>
94
                                <Yes>cultivated</Yes>
95
                                <No>wild</No>
96
                                <value>$Cultivated?</value>
97
                            </_map>
98
                        </value>
99
                    </_map>
100
                </iscultivated>
101
                <isnative>
102
                    <_map>
103
                        <native>t</native>
104
                        <exotic>f</exotic>
105
                        <*></*>
106
                        <value>
107
                            <_map>
108
                                <Yes>cultivated</Yes>
109
                                <No>wild</No>
110
                                <value>$Cultivated?</value>
111
                            </_map>
112
                        </value>
113
                    </_map>
114
                </isnative>
115
                <taxondetermination>
116
                    <isoriginal>true</isoriginal>
117
                    <role>identifier</role>
118
                    <plantconcept_id>
119
                        <plantconcept>
120
                            <plantname_id>
121
                                <_simplifyPath>
122
                                    <next>parent_id/plantname</next>
123
                                    <require>plantname</require>
124
                                    <path>
125
                                        <plantname>
126
                                            <rank>binomial</rank>
127
                                            <plantname>$Full Taxon Name</plantname>
128
                                        </plantname>
129
                                    </path>
130
                                </_simplifyPath>
131
                            </plantname_id>
132
                        </plantconcept>
133
                    </plantconcept_id>
134
                </taxondetermination>
135
                <voucher><specimenreplicate_id><specimenreplicate><catalognumber_dwc/></specimenreplicate></specimenreplicate_id></voucher>
136
            </taxonoccurrence>
137
        </locationevent>
138
    </location>
139
</VegBIEN>
140
Inserted 26 new rows into database
(7-7/7)