Project

General

Profile

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