Project

General

Profile

1 6881 aaronmk
Put template:
2
<VegBIEN>
3
    <_setDefault id="-1">
4
        <source_id><source><shortname>bien2_traits</shortname></source></source_id>
5
        <path>
6
            <_simplifyPath>
7
                <next>parent_id</next>
8
                <path>
9
                    <location>
10 10260 aaronmk
                        <authorlocationcode>$occurrenceID</authorlocationcode>
11 6881 aaronmk
                        <elevation_m>
12
                            <_units>
13
                                <to>m</to>
14
                                <to></to>
15 10260 aaronmk
                                <value>$verbatimElevation</value>
16 6881 aaronmk
                            </_units>
17
                        </elevation_m>
18 10260 aaronmk
                        <iscultivated><_locationnarrative_is_cultivated><locationnarrative>$verbatimLocality</locationnarrative></_locationnarrative_is_cultivated></iscultivated>
19 6881 aaronmk
                        <locationevent>
20 10260 aaronmk
                            <method_id><method><name>$samplingProtocol</name></method></method_id>
21 6881 aaronmk
                            <taxonoccurrence>
22 10260 aaronmk
                                <aggregateoccurrence><plantobservation><specimenreplicate><sourceaccessioncode>$occurrenceID</sourceaccessioncode></specimenreplicate></plantobservation></aggregateoccurrence>
23
                                <growthform>$growthForm</growthform>
24
                                <sourceaccessioncode>$occurrenceID</sourceaccessioncode>
25 6881 aaronmk
                                <taxondetermination>
26
                                    <taxonverbatim_id>
27
                                        <taxonverbatim>
28
                                            <taxonlabel_id>
29
                                                <taxonlabel>
30
                                                    <parent_id>
31
                                                        <taxonlabel>
32 10260 aaronmk
                                                            <rank>$taxonRank</rank>
33 6881 aaronmk
                                                            <parent_id>
34
                                                                <taxonlabel>
35
                                                                    <rank>cultivar</rank>
36
                                                                    <parent_id>
37
                                                                        <taxonlabel>
38
                                                                            <rank>forma</rank>
39
                                                                            <parent_id>
40
                                                                                <taxonlabel>
41
                                                                                    <rank>variety</rank>
42
                                                                                    <parent_id>
43
                                                                                        <taxonlabel>
44
                                                                                            <rank>subspecies</rank>
45
                                                                                            <parent_id>
46
                                                                                                <taxonlabel>
47
                                                                                                    <rank>species</rank>
48 10260 aaronmk
                                                                                                    <taxonepithet>$specificEpithet</taxonepithet>
49 6881 aaronmk
                                                                                                    <parent_id>
50
                                                                                                        <taxonlabel>
51
                                                                                                            <rank>genus</rank>
52 10260 aaronmk
                                                                                                            <taxonepithet>$genus</taxonepithet>
53 6881 aaronmk
                                                                                                            <parent_id>
54
                                                                                                                <taxonlabel>
55
                                                                                                                    <rank>family</rank>
56 10260 aaronmk
                                                                                                                    <taxonepithet>$family</taxonepithet>
57 6881 aaronmk
                                                                                                                </taxonlabel>
58
                                                                                                            </parent_id>
59
                                                                                                        </taxonlabel>
60
                                                                                                    </parent_id>
61
                                                                                                </taxonlabel>
62
                                                                                            </parent_id>
63
                                                                                        </taxonlabel>
64
                                                                                    </parent_id>
65
                                                                                </taxonlabel>
66
                                                                            </parent_id>
67
                                                                        </taxonlabel>
68
                                                                    </parent_id>
69
                                                                </taxonlabel>
70
                                                            </parent_id>
71 10260 aaronmk
                                                            <taxonepithet>$infraspecificEpithet</taxonepithet>
72 6881 aaronmk
                                                        </taxonlabel>
73
                                                    </parent_id>
74 10260 aaronmk
                                                    <rank>$taxonRank</rank>
75 6881 aaronmk
                                                    <taxonomicname>
76 7142 aaronmk
                                                        <_merge_prefix>
77 10260 aaronmk
                                                            <prefix><_taxon_family_require_std><family>$family</family></_taxon_family_require_std></prefix>
78 7142 aaronmk
                                                            <value>
79 6881 aaronmk
                                                                <_join_words>
80
                                                                    <1>
81
                                                                        <_alt>
82 10260 aaronmk
                                                                            <1>$taxonName</1>
83 6881 aaronmk
                                                                            <2>
84
                                                                                <_join_words>
85 10260 aaronmk
                                                                                    <2><_filter_genus><value>$genus</value></_filter_genus></2>
86
                                                                                    <3>$specificEpithet</3>
87 6881 aaronmk
                                                                                    <5>
88
                                                                                        <_join_words>
89
                                                                                            <1>
90
                                                                                                <_if name="if has infraspecificEpithet">
91 10260 aaronmk
                                                                                                    <cond>$infraspecificEpithet</cond>
92
                                                                                                    <then>$taxonRank</then>
93 6881 aaronmk
                                                                                                </_if>
94
                                                                                            </1>
95 10260 aaronmk
                                                                                            <2>$infraspecificEpithet</2>
96 6881 aaronmk
                                                                                        </_join_words>
97
                                                                                    </5>
98
                                                                                </_join_words>
99
                                                                            </2>
100
                                                                        </_alt>
101
                                                                    </1>
102 10260 aaronmk
                                                                    <2>$scientificNameAuthorship</2>
103 6881 aaronmk
                                                                </_join_words>
104 7142 aaronmk
                                                            </value>
105
                                                        </_merge_prefix>
106 6881 aaronmk
                                                    </taxonomicname>
107
                                                </taxonlabel>
108
                                            </taxonlabel_id>
109 10260 aaronmk
                                            <author>$scientificNameAuthorship</author>
110
                                            <family>$family</family>
111
                                            <genus>$genus</genus>
112
                                            <specific_epithet>$specificEpithet</specific_epithet>
113
                                            <taxonname>$taxonName</taxonname>
114
                                            <verbatimrank>$taxonRank</verbatimrank>
115 6881 aaronmk
                                        </taxonverbatim>
116
                                    </taxonverbatim_id>
117
                                </taxondetermination>
118 6882 aaronmk
                                <trait>
119 10260 aaronmk
                                    <name>$measurementName</name>
120
                                    <units>$measurementUnit</units>
121
                                    <value>$measurementValue</value>
122 6882 aaronmk
                                </trait>
123 6881 aaronmk
                            </taxonoccurrence>
124
                        </locationevent>
125 10260 aaronmk
                        <locationnarrative>$verbatimLocality</locationnarrative>
126 6881 aaronmk
                        <locationplace>
127
                            <place_id>
128
                                <place>
129
                                    <coordinates_id>
130
                                        <coordinates>
131 10260 aaronmk
                                            <verbatimlatitude>$verbatimLatitude</verbatimlatitude>
132
                                            <verbatimlongitude>$verbatimLongitude</verbatimlongitude>
133 6881 aaronmk
                                        </coordinates>
134
                                    </coordinates_id>
135 10260 aaronmk
                                    <country>$country</country>
136 6881 aaronmk
                                    <matched_place_id>
137
                                        <place>
138
                                            <source_id><source><shortname>geoscrub</shortname></source></source_id>
139 10260 aaronmk
                                            <country>$country</country>
140
                                            <stateprovince>$stateProvince</stateprovince>
141 6881 aaronmk
                                        </place>
142
                                    </matched_place_id>
143 10260 aaronmk
                                    <stateprovince>$stateProvince</stateprovince>
144 6881 aaronmk
                                </place>
145
                            </place_id>
146
                        </locationplace>
147 10260 aaronmk
                        <verbatimelevation>$verbatimElevation</verbatimelevation>
148 6881 aaronmk
                    </location>
149
                </path>
150
            </_simplifyPath>
151
        </path>
152
    </_setDefault>
153
</VegBIEN>
154 7469 aaronmk
Inserted 31 new rows into database