Project

General

Profile

1 3641 aaronmk
Put template:
2
<VegBIEN>
3 3786 aaronmk
    <location id="-1">
4 4003 aaronmk
        <authorlocationcode>
5 4066 aaronmk
            <_alt>
6
                <3>$Accession Number</3>
7
                <4>
8
                    <_merge>
9
                        <2>$SeriesName</2>
10 4078 aaronmk
                        <3>$Barcode</3>
11 4066 aaronmk
                    </_merge>
12
                </4>
13
            </_alt>
14 4003 aaronmk
        </authorlocationcode>
15 3996 aaronmk
        <elevation>
16 4043 aaronmk
            <_replace>
17
                <\bca\.?></\bca\.?>
18
                <value>$Elevation</value>
19
            </_replace>
20 3996 aaronmk
        </elevation>
21 3786 aaronmk
        <locationdetermination>
22 4043 aaronmk
            <coordsaccuracy><_noCV><value>$Accuracy</value></_noCV></coordsaccuracy>
23 3786 aaronmk
            <latitude>
24 4043 aaronmk
                <_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 3786 aaronmk
            </latitude>
35
            <longitude>
36 4043 aaronmk
                <_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 3786 aaronmk
            </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 3770 aaronmk
                                        <namedplace>
61 3786 aaronmk
                                            <rank>country</rank>
62
                                            <placename>$Country</placename>
63 3770 aaronmk
                                        </namedplace>
64 3786 aaronmk
                                    </parent_id>
65
                                </namedplace>
66
                            </parent_id>
67
                        </namedplace>
68
                    </path>
69
                </_simplifyPath>
70
            </namedplace_id>
71
        </locationdetermination>
72
        <locationevent>
73 4043 aaronmk
            <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 3907 aaronmk
            <taxonoccurrence>
76
                <aggregateoccurrence>
77 4043 aaronmk
                    <collectiondate><_date><date>$Collect Date</date></_date></collectiondate>
78 3907 aaronmk
                    <plantobservation>
79
                        <specimenreplicate>
80 4078 aaronmk
                            <catalognumber_dwc>$Barcode</catalognumber_dwc>
81 4043 aaronmk
                            <collectioncode_dwc>$SeriesName</collectioncode_dwc>
82 3907 aaronmk
                            <sourceaccessioncode>$Accession Number</sourceaccessioncode>
83
                        </specimenreplicate>
84
                    </plantobservation>
85
                </aggregateoccurrence>
86 4079 aaronmk
                <authortaxoncode>$Full Taxon Name</authortaxoncode>
87 3934 aaronmk
                <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 3786 aaronmk
                <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 4079 aaronmk
                <voucher><specimenreplicate_id><specimenreplicate><catalognumber_dwc/></specimenreplicate></specimenreplicate_id></voucher>
136 3907 aaronmk
            </taxonoccurrence>
137 3786 aaronmk
        </locationevent>
138
    </location>
139 3641 aaronmk
</VegBIEN>
140 3907 aaronmk
Inserted 26 new rows into database