Project

General

Profile

Download (10.4 KB) Statistics
| Revision:

root/inputs/REMIB/test/import.specimens.xml.ref @ 4064

1 3641 aaronmk 
Put template:
2 
<VegBIEN>
3 3786 aaronmk 
    <location id="-1">
4 4043 aaronmk 
        <authorlocationcode>$acronym</authorlocationcode>
5 3786 aaronmk 
        <locationdetermination>
6 
            <latitude>
7 4043 aaronmk 
                <_nullIf>
8 
                    <null>0</null>
9 
                    <type>float</type>
10 
                    <value>$lat_deg</value>
11 
                </_nullIf>
12 3786 aaronmk 
            </latitude>
13 
            <longitude>
14 4043 aaronmk 
                <_nullIf>
15 
                    <null>0</null>
16 
                    <type>float</type>
17 
                    <value>$long_deg</value>
18 
                </_nullIf>
19 3786 aaronmk 
            </longitude>
20 
            <namedplace_id>
21 
                <_simplifyPath>
22 
                    <next>parent_id/namedplace</next>
23 
                    <require>placename</require>
24 
                    <path>
25 
                        <namedplace>
26 
                            <rank>county</rank>
27 
                            <placename>$county</placename>
28 
                            <parent_id>
29 
                                <namedplace>
30 
                                    <rank>stateProvince</rank>
31 
                                    <placename>$state</placename>
32 
                                    <parent_id>
33 
                                        <namedplace>
34 
                                            <rank>country</rank>
35 
                                            <placename>$country</placename>
36 
                                        </namedplace>
37 
                                    </parent_id>
38 
                                </namedplace>
39 
                            </parent_id>
40 
                        </namedplace>
41 
                    </path>
42 
                </_simplifyPath>
43 
            </namedplace_id>
44 
        </locationdetermination>
45 
        <locationevent>
46 4021 aaronmk 
            <obsenddate>
47 
                <_date>
48 
                    <date>
49 
                        <_dateRangeEnd>
50 
                            <value>
51 4043 aaronmk 
                                <_date>
52 
                                    <day>
53 
                                        <_nullIf>
54 
                                            <null>0</null>
55 
                                            <type>float</type>
56 
                                            <value>$coll_day</value>
57 
                                        </_nullIf>
58 
                                    </day>
59 
                                    <month>
60 
                                        <_nullIf>
61 
                                            <null>0</null>
62 
                                            <type>float</type>
63 
                                            <value>$coll_month</value>
64 
                                        </_nullIf>
65 
                                    </month>
66 
                                    <year>
67 
                                        <_nullIf>
68 
                                            <null>0</null>
69 
                                            <type>float</type>
70 
                                            <value>$coll_year</value>
71 
                                        </_nullIf>
72 
                                    </year>
73 
                                </_date>
74 4021 aaronmk 
                            </value>
75 
                        </_dateRangeEnd>
76 
                    </date>
77 
                </_date>
78 
            </obsenddate>
79 
            <obsstartdate>
80 
                <_date>
81 
                    <date>
82 
                        <_dateRangeStart>
83 
                            <value>
84 4043 aaronmk 
                                <_date>
85 
                                    <day>
86 
                                        <_nullIf>
87 
                                            <null>0</null>
88 
                                            <type>float</type>
89 
                                            <value>$coll_day</value>
90 
                                        </_nullIf>
91 
                                    </day>
92 
                                    <month>
93 
                                        <_nullIf>
94 
                                            <null>0</null>
95 
                                            <type>float</type>
96 
                                            <value>$coll_month</value>
97 
                                        </_nullIf>
98 
                                    </month>
99 
                                    <year>
100 
                                        <_nullIf>
101 
                                            <null>0</null>
102 
                                            <type>float</type>
103 
                                            <value>$coll_year</value>
104 
                                        </_nullIf>
105 
                                    </year>
106 
                                </_date>
107 4021 aaronmk 
                            </value>
108 
                        </_dateRangeStart>
109 
                    </date>
110 
                </_date>
111 
            </obsstartdate>
112 3915 aaronmk 
            <taxonoccurrence>
113 
                <aggregateoccurrence>
114 
                    <collectiondate>
115 
                        <_date>
116 
                            <date>
117 4043 aaronmk 
                                <_date>
118 
                                    <day>
119 
                                        <_nullIf>
120 
                                            <null>0</null>
121 
                                            <type>float</type>
122 
                                            <value>$coll_day</value>
123 
                                        </_nullIf>
124 
                                    </day>
125 
                                    <month>
126 
                                        <_nullIf>
127 
                                            <null>0</null>
128 
                                            <type>float</type>
129 
                                            <value>$coll_month</value>
130 
                                        </_nullIf>
131 
                                    </month>
132 
                                    <year>
133 
                                        <_nullIf>
134 
                                            <null>0</null>
135 
                                            <type>float</type>
136 
                                            <value>$coll_year</value>
137 
                                        </_nullIf>
138 
                                    </year>
139 
                                </_date>
140 3915 aaronmk 
                            </date>
141 
                        </_date>
142 
                    </collectiondate>
143 3907 aaronmk 
                    <plantobservation>
144 4006 aaronmk 
                        <sourceaccessioncode>$accession_number</sourceaccessioncode>
145 3907 aaronmk 
                        <specimenreplicate>
146 4043 aaronmk 
                            <collectioncode_dwc>$acronym</collectioncode_dwc>
147 3907 aaronmk 
                            <sourceaccessioncode>$accession_number</sourceaccessioncode>
148 
                        </specimenreplicate>
149 
                    </plantobservation>
150 
                </aggregateoccurrence>
151 4043 aaronmk 
                <sourceaccessioncode>$accession_number</sourceaccessioncode>
152 3786 aaronmk 
                <taxondetermination>
153 
                    <isoriginal>true</isoriginal>
154 
                    <role>identifier</role>
155 
                    <plantconcept_id>
156 
                        <plantconcept>
157 
                            <plantname_id>
158 3641 aaronmk 
                                <_simplifyPath>
159 3786 aaronmk 
                                    <next>parent_id/plantname</next>
160 
                                    <require>plantname</require>
161 3641 aaronmk 
                                    <path>
162 
                                        <plantname>
163 3786 aaronmk 
                                            <rank>binomial</rank>
164 3641 aaronmk 
                                            <parent_id>
165 
                                                <plantname>
166 3786 aaronmk 
                                                    <rank>authority</rank>
167 3641 aaronmk 
                                                    <parent_id>
168 
                                                        <plantname>
169 3786 aaronmk 
                                                            <rank>subspecies</rank>
170 3641 aaronmk 
                                                            <parent_id>
171 
                                                                <plantname>
172 3786 aaronmk 
                                                                    <rank>species</rank>
173 
                                                                    <plantname>$specificEpithet</plantname>
174 3641 aaronmk 
                                                                    <parent_id>
175 
                                                                        <plantname>
176 3786 aaronmk 
                                                                            <rank>genus</rank>
177 
                                                                            <plantname>$genus</plantname>
178 
                                                                            <parent_id>
179 
                                                                                <plantname>
180 
                                                                                    <rank>family</rank>
181 
                                                                                    <plantname>$family</plantname>
182 
                                                                                </plantname>
183 
                                                                            </parent_id>
184 3641 aaronmk 
                                                                        </plantname>
185 
                                                                    </parent_id>
186 
                                                                </plantname>
187 
                                                            </parent_id>
188 
                                                        </plantname>
189 
                                                    </parent_id>
190 
                                                </plantname>
191 
                                            </parent_id>
192 
                                        </plantname>
193 3786 aaronmk 
                                    </path>
194 
                                </_simplifyPath>
195 
                            </plantname_id>
196 
                        </plantconcept>
197 
                    </plantconcept_id>
198 
                </taxondetermination>
199 3934 aaronmk 
                <verbatimcollectorname>$collector</verbatimcollectorname>
200 3907 aaronmk 
            </taxonoccurrence>
201 3786 aaronmk 
        </locationevent>
202 
        <locationnarrative>
203 
            <_merge>
204 
                <1>$locality</1>
205 
                <3>
206 
                    <_label>
207 
                        <label>habitat</label>
208 
                        <value>$habitat</value>
209 
                    </_label>
210 
                </3>
211 
            </_merge>
212 
        </locationnarrative>
213 4043 aaronmk 
        <sourceaccessioncode>$accession_number</sourceaccessioncode>
214 3786 aaronmk 
    </location>
215 3641 aaronmk 
</VegBIEN>
216 3907 aaronmk 
Inserted 26 new rows into database