Project

General

Profile

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