Project

General

Profile

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