Project

General

Profile

Download (8.44 KB) Statistics
| Revision:

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

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