Project

General

Profile

Download (8.28 KB) Statistics
| Revision:

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

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