Project

General

Profile

1 4529 aaronmk
Put template:
2
<VegBIEN>
3 6403 aaronmk
    <_setDefault id="-1">
4 10866 aaronmk
        <source_id><source><shortname>VegBank.new</shortname></source></source_id>
5 4621 aaronmk
        <path>
6 6403 aaronmk
            <_simplifyPath>
7
                <next>parent_id</next>
8
                <path>
9
                    <location>
10 10943 aaronmk
                        <authorlocationcode>
11
                            <_if name="if plot">
12
                                <cond>
13
                                    <_eq>
14
                                        <right>plot</right>
15
                                        <left>$observationGranularity</left>
16
                                    </_eq>
17
                                </cond>
18
                                <else>$accessionNumber</else>
19
                            </_if>
20
                        </authorlocationcode>
21 6403 aaronmk
                        <locationevent>
22 10943 aaronmk
                            <sourceaccessioncode>$eventID</sourceaccessioncode>
23 6403 aaronmk
                            <taxonoccurrence>
24
                                <aggregateoccurrence>
25 10943 aaronmk
                                    <collectiondate>$dateCollected</collectiondate>
26
                                    <notes>$occurrenceRemarks</notes>
27 7527 aaronmk
                                    <plantobservation>
28 10943 aaronmk
                                        <authorplantcode>$collectorNumber</authorplantcode>
29 7527 aaronmk
                                        <specimenreplicate>
30 10943 aaronmk
                                            <catalognumber_dwc>$accessionNumber</catalognumber_dwc>
31
                                            <collectionnumber>$collectorNumber</collectionnumber>
32 7527 aaronmk
                                        </specimenreplicate>
33
                                    </plantobservation>
34 6403 aaronmk
                                </aggregateoccurrence>
35 10943 aaronmk
                                <authortaxoncode>$collectorNumber</authortaxoncode>
36
                                <sourceaccessioncode>$taxonOccurrenceID</sourceaccessioncode>
37 6403 aaronmk
                                <taxondetermination>
38
                                    <taxonverbatim_id>
39
                                        <taxonverbatim>
40
                                            <taxonlabel_id>
41 5657 aaronmk
                                                <taxonlabel>
42 5294 aaronmk
                                                    <parent_id>
43 5608 aaronmk
                                                        <taxonlabel>
44 5294 aaronmk
                                                            <parent_id>
45 5608 aaronmk
                                                                <taxonlabel>
46 6403 aaronmk
                                                                    <rank>cultivar</rank>
47 5294 aaronmk
                                                                    <parent_id>
48 5608 aaronmk
                                                                        <taxonlabel>
49 6403 aaronmk
                                                                            <rank>forma</rank>
50 5294 aaronmk
                                                                            <parent_id>
51 5608 aaronmk
                                                                                <taxonlabel>
52 6403 aaronmk
                                                                                    <rank>variety</rank>
53 5294 aaronmk
                                                                                    <parent_id>
54 5608 aaronmk
                                                                                        <taxonlabel>
55 6403 aaronmk
                                                                                            <rank>subspecies</rank>
56 5294 aaronmk
                                                                                            <parent_id>
57 5608 aaronmk
                                                                                                <taxonlabel>
58 6403 aaronmk
                                                                                                    <rank>species</rank>
59 5294 aaronmk
                                                                                                    <parent_id>
60 5608 aaronmk
                                                                                                        <taxonlabel>
61 6403 aaronmk
                                                                                                            <rank>genus</rank>
62 10943 aaronmk
                                                                                                            <taxonepithet>$genus</taxonepithet>
63 5294 aaronmk
                                                                                                            <parent_id>
64 5608 aaronmk
                                                                                                                <taxonlabel>
65 6403 aaronmk
                                                                                                                    <rank>family</rank>
66 10943 aaronmk
                                                                                                                    <taxonepithet>$family</taxonepithet>
67 5294 aaronmk
                                                                                                                    <parent_id>
68 5608 aaronmk
                                                                                                                        <taxonlabel>
69 6403 aaronmk
                                                                                                                            <rank>order</rank>
70 10943 aaronmk
                                                                                                                            <taxonepithet>$order</taxonepithet>
71 5306 aaronmk
                                                                                                                            <parent_id>
72 5608 aaronmk
                                                                                                                                <taxonlabel>
73 6403 aaronmk
                                                                                                                                    <rank>class</rank>
74 10943 aaronmk
                                                                                                                                    <taxonepithet>$class</taxonepithet>
75 5657 aaronmk
                                                                                                                                    <parent_id>
76
                                                                                                                                        <taxonlabel>
77 6403 aaronmk
                                                                                                                                            <rank>phylum</rank>
78
                                                                                                                                            <parent_id>
79
                                                                                                                                                <taxonlabel>
80
                                                                                                                                                    <rank>kingdom</rank>
81 10943 aaronmk
                                                                                                                                                    <taxonepithet>$kingdom</taxonepithet>
82 6403 aaronmk
                                                                                                                                                </taxonlabel>
83
                                                                                                                                            </parent_id>
84 5657 aaronmk
                                                                                                                                        </taxonlabel>
85
                                                                                                                                    </parent_id>
86 5608 aaronmk
                                                                                                                                </taxonlabel>
87 5306 aaronmk
                                                                                                                            </parent_id>
88 5608 aaronmk
                                                                                                                        </taxonlabel>
89 5294 aaronmk
                                                                                                                    </parent_id>
90 5608 aaronmk
                                                                                                                </taxonlabel>
91 5294 aaronmk
                                                                                                            </parent_id>
92 5608 aaronmk
                                                                                                        </taxonlabel>
93 5294 aaronmk
                                                                                                    </parent_id>
94 5608 aaronmk
                                                                                                </taxonlabel>
95 5294 aaronmk
                                                                                            </parent_id>
96 5608 aaronmk
                                                                                        </taxonlabel>
97 5294 aaronmk
                                                                                    </parent_id>
98 5608 aaronmk
                                                                                </taxonlabel>
99 5294 aaronmk
                                                                            </parent_id>
100 5608 aaronmk
                                                                        </taxonlabel>
101 5294 aaronmk
                                                                    </parent_id>
102 5608 aaronmk
                                                                </taxonlabel>
103 5294 aaronmk
                                                            </parent_id>
104 5608 aaronmk
                                                        </taxonlabel>
105 5294 aaronmk
                                                    </parent_id>
106 6403 aaronmk
                                                    <taxonomicname>
107 7142 aaronmk
                                                        <_merge_prefix>
108 10943 aaronmk
                                                            <prefix><_taxon_family_require_std><family>$family</family></_taxon_family_require_std></prefix>
109 7142 aaronmk
                                                            <value>
110 10678 aaronmk
                                                                <_alt>
111 10931 aaronmk
                                                                    <1>$scientificName</1>
112 10678 aaronmk
                                                                    <2>
113
                                                                        <_alt>
114 10943 aaronmk
                                                                            <1>$taxonName</1>
115
                                                                            <2><_filter_genus><value>$genus</value></_filter_genus></2>
116 10678 aaronmk
                                                                        </_alt>
117
                                                                    </2>
118
                                                                </_alt>
119 7142 aaronmk
                                                            </value>
120
                                                        </_merge_prefix>
121 6403 aaronmk
                                                    </taxonomicname>
122
                                                </taxonlabel>
123
                                            </taxonlabel_id>
124 10943 aaronmk
                                            <family>$family</family>
125
                                            <genus>$genus</genus>
126
                                            <taxonname>$taxonName</taxonname>
127 10931 aaronmk
                                            <taxonomicname>$scientificName</taxonomicname>
128 6403 aaronmk
                                        </taxonverbatim>
129
                                    </taxonverbatim_id>
130 10943 aaronmk
                                    <determinationdate><_dateRangeStart><value>$dateIdentified</value></_dateRangeStart></determinationdate>
131
                                    <determinationtype>$identificationType</determinationtype>
132
                                    <taxonfit>$identificationQualifier</taxonfit>
133 6403 aaronmk
                                </taxondetermination>
134
                                <taxondetermination>
135
                                    <isoriginal>true</isoriginal>
136 10678 aaronmk
                                    <taxonverbatim_id>
137
                                        <taxonverbatim>
138 10943 aaronmk
                                            <taxonname>$originalTaxonName</taxonname>
139
                                            <taxonomicname>$originalScientificName</taxonomicname>
140 10678 aaronmk
                                        </taxonverbatim>
141
                                    </taxonverbatim_id>
142 6403 aaronmk
                                </taxondetermination>
143
                            </taxonoccurrence>
144
                        </locationevent>
145
                    </location>
146
                </path>
147
            </_simplifyPath>
148 4621 aaronmk
        </path>
149 6403 aaronmk
    </_setDefault>
150 4529 aaronmk
</VegBIEN>
151 10685 aaronmk
Inserted 16 new rows into database