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>$ID</1>
10
                        <2>$Barcode</2>
11
                    </_alt>
12
                </authorlocationcode>
13
                <locationdetermination>
14
                    <latitude>
15
                        <_nullIf>
16
                            <null>0</null>
17
                            <type>float</type>
18
                            <value>$Lat</value>
19
                        </_nullIf>
20
                    </latitude>
21
                    <longitude>
22
                        <_nullIf>
23
                            <null>0</null>
24
                            <type>float</type>
25
                            <value>$Long</value>
26
                        </_nullIf>
27
                    </longitude>
28
                    <namedplace_id>
29 4622 aaronmk
                        <namedplace>
30
                            <rank>county</rank>
31
                            <parent_id>
32 3786 aaronmk
                                <namedplace>
33 4622 aaronmk
                                    <rank>stateProvince</rank>
34 3786 aaronmk
                                    <parent_id>
35
                                        <namedplace>
36 4622 aaronmk
                                            <rank>country</rank>
37
                                            <placename>$Country</placename>
38 3786 aaronmk
                                        </namedplace>
39
                                    </parent_id>
40
                                </namedplace>
41 4622 aaronmk
                            </parent_id>
42
                        </namedplace>
43 4621 aaronmk
                    </namedplace_id>
44
                </locationdetermination>
45
                <locationevent>
46
                    <taxonoccurrence>
47
                        <aggregateoccurrence>
48
                            <collectiondate>
49
                                <_date>
50
                                    <day>
51
                                        <_nullIf>
52
                                            <null>0</null>
53
                                            <type>float</type>
54
                                            <value>$Colldd</value>
55
                                        </_nullIf>
56
                                    </day>
57
                                    <month>
58
                                        <_nullIf>
59
                                            <null>0</null>
60
                                            <type>float</type>
61
                                            <value>$Collmm</value>
62
                                        </_nullIf>
63
                                    </month>
64
                                    <year>
65
                                        <_nullIf>
66
                                            <null>0</null>
67
                                            <type>float</type>
68
                                            <value>$Collyy</value>
69
                                        </_nullIf>
70
                                    </year>
71
                                </_date>
72
                            </collectiondate>
73
                            <notes>$Notes</notes>
74
                            <plantobservation>
75
                                <collectionnumber>$Number</collectionnumber>
76
                                <specimenreplicate>
77
                                    <catalognumber_dwc>$Barcode</catalognumber_dwc>
78
                                    <sourceaccessioncode>$ID</sourceaccessioncode>
79
                                </specimenreplicate>
80
                            </plantobservation>
81
                        </aggregateoccurrence>
82
                        <authortaxoncode>$Number</authortaxoncode>
83
                        <taxondetermination>
84
                            <party_id>
85
                                <party>
86
                                    <givenname><_namePart><first>$Detby</first></_namePart></givenname>
87
                                    <middlename><_namePart><middle>$Detby</middle></_namePart></middlename>
88
                                    <surname><_namePart><last>$Detby</last></_namePart></surname>
89
                                </party>
90
                            </party_id>
91
                            <plantconcept_id>
92
                                <plantconcept>
93
                                    <plantname_id>
94 4622 aaronmk
                                        <plantname>
95
                                            <rank>binomial</rank>
96
                                            <parent_id>
97 3641 aaronmk
                                                <plantname>
98 4622 aaronmk
                                                    <rank>authority</rank>
99 3641 aaronmk
                                                    <parent_id>
100
                                                        <plantname>
101 4622 aaronmk
                                                            <rank>subspecies</rank>
102 3641 aaronmk
                                                            <parent_id>
103
                                                                <plantname>
104 4622 aaronmk
                                                                    <rank>species</rank>
105 3641 aaronmk
                                                                    <parent_id>
106
                                                                        <plantname>
107 4622 aaronmk
                                                                            <rank>genus</rank>
108
                                                                            <plantname>$Genus</plantname>
109 3786 aaronmk
                                                                            <parent_id>
110
                                                                                <plantname>
111 4622 aaronmk
                                                                                    <rank>family</rank>
112
                                                                                    <plantname>$Family</plantname>
113 3786 aaronmk
                                                                                </plantname>
114
                                                                            </parent_id>
115 3641 aaronmk
                                                                        </plantname>
116
                                                                    </parent_id>
117
                                                                </plantname>
118
                                                            </parent_id>
119
                                                        </plantname>
120
                                                    </parent_id>
121
                                                </plantname>
122 4622 aaronmk
                                            </parent_id>
123
                                        </plantname>
124 4621 aaronmk
                                    </plantname_id>
125
                                </plantconcept>
126
                            </plantconcept_id>
127
                            <determinationdate>
128
                                <_date>
129
                                    <year>
130
                                        <_nullIf>
131
                                            <null>0</null>
132
                                            <type>float</type>
133
                                            <value>$Detyy</value>
134
                                        </_nullIf>
135
                                    </year>
136
                                </_date>
137
                            </determinationdate>
138
                            <taxonfit>$cf</taxonfit>
139
                        </taxondetermination>
140
                        <verbatimcollectorname>
141
                            <_merge>
142
                                <1>$Collector</1>
143
                                <2>$Addcoll</2>
144
                            </_merge>
145
                        </verbatimcollectorname>
146
                    </taxonoccurrence>
147
                </locationevent>
148
                <locationnarrative>
149 3934 aaronmk
                    <_merge>
150 4621 aaronmk
                        <2>
151
                            <_merge>
152
                                <1>
153
                                    <_label>
154
                                        <label>gazetteer</label>
155
                                        <value>
156
                                            <_merge>
157
                                                <1>$Gazetteer</1>
158
                                                <2>$Newgazett</2>
159
                                            </_merge>
160
                                        </value>
161
                                    </_label>
162
                                </1>
163
                                <2>$Locnotes</2>
164
                            </_merge>
165
                        </2>
166
                        <3>
167 3786 aaronmk
                            <_label>
168 4621 aaronmk
                                <label>habitat</label>
169
                                <value>$Ecology</value>
170 3786 aaronmk
                            </_label>
171 4621 aaronmk
                        </3>
172 3786 aaronmk
                    </_merge>
173 4621 aaronmk
                </locationnarrative>
174
            </location>
175
        </path>
176
    </_simplifyPath>
177 3641 aaronmk
</VegBIEN>
178 3907 aaronmk
Inserted 26 new rows into database