Project

General

Profile

1 4368 aaronmk
Put template:
2
<VegBIEN>
3 6403 aaronmk
    <_setDefault id="-1">
4
        <col>source_id</col>
5
        <value><source><shortname>CTFS</shortname></source></value>
6 4621 aaronmk
        <path>
7 6403 aaronmk
            <_simplifyPath>
8
                <next>parent_id</next>
9
                <path>
10
                    <location>
11
                        <sourceaccessioncode>$PlotID</sourceaccessioncode>
12
                        <locationevent>
13
                            <sourceaccessioncode>$CensusID</sourceaccessioncode>
14
                            <taxonoccurrence>
15
                                <sourceaccessioncode>$SpeciesInvID</sourceaccessioncode>
16
                                <taxondetermination>
17
                                    <taxonverbatim_id>
18
                                        <taxonverbatim>
19
                                            <taxonlabel_id>
20 5657 aaronmk
                                                <taxonlabel>
21 6403 aaronmk
                                                    <matched_label_id>
22
                                                        <taxonlabel>
23
                                                            <source_id><source><shortname>TNRS</shortname></source></source_id>
24
                                                            <taxonomicname>
25 5788 aaronmk
                                                                <_join_words>
26 6403 aaronmk
                                                                    <1><_taxon_family_require_std><family>$Family</family></_taxon_family_require_std></1>
27
                                                                    <2>
28
                                                                        <_join_words>
29
                                                                            <2>$Genus</2>
30
                                                                            <3>$SpeciesName</3>
31
                                                                            <4>$SubSpeciesName</4>
32
                                                                        </_join_words>
33
                                                                    </2>
34 5788 aaronmk
                                                                </_join_words>
35 6403 aaronmk
                                                            </taxonomicname>
36
                                                        </taxonlabel>
37
                                                    </matched_label_id>
38 5294 aaronmk
                                                    <parent_id>
39 5608 aaronmk
                                                        <taxonlabel>
40 5294 aaronmk
                                                            <parent_id>
41 5608 aaronmk
                                                                <taxonlabel>
42 6403 aaronmk
                                                                    <rank>cultivar</rank>
43 5294 aaronmk
                                                                    <parent_id>
44 5608 aaronmk
                                                                        <taxonlabel>
45 6403 aaronmk
                                                                            <rank>forma</rank>
46 5294 aaronmk
                                                                            <parent_id>
47 5608 aaronmk
                                                                                <taxonlabel>
48 6403 aaronmk
                                                                                    <rank>variety</rank>
49 5294 aaronmk
                                                                                    <parent_id>
50 5608 aaronmk
                                                                                        <taxonlabel>
51 6403 aaronmk
                                                                                            <rank>subspecies</rank>
52
                                                                                            <taxonepithet>$SubSpeciesName</taxonepithet>
53 5306 aaronmk
                                                                                            <parent_id>
54 5608 aaronmk
                                                                                                <taxonlabel>
55 6403 aaronmk
                                                                                                    <rank>species</rank>
56
                                                                                                    <taxonepithet>$SpeciesName</taxonepithet>
57 5657 aaronmk
                                                                                                    <parent_id>
58
                                                                                                        <taxonlabel>
59 6403 aaronmk
                                                                                                            <rank>genus</rank>
60
                                                                                                            <taxonepithet>$Genus</taxonepithet>
61
                                                                                                            <parent_id>
62
                                                                                                                <taxonlabel>
63
                                                                                                                    <rank>family</rank>
64
                                                                                                                    <taxonepithet>$Family</taxonepithet>
65
                                                                                                                </taxonlabel>
66
                                                                                                            </parent_id>
67 5657 aaronmk
                                                                                                        </taxonlabel>
68
                                                                                                    </parent_id>
69 5608 aaronmk
                                                                                                </taxonlabel>
70 5306 aaronmk
                                                                                            </parent_id>
71 5608 aaronmk
                                                                                        </taxonlabel>
72 5294 aaronmk
                                                                                    </parent_id>
73 5608 aaronmk
                                                                                </taxonlabel>
74 5294 aaronmk
                                                                            </parent_id>
75 5608 aaronmk
                                                                        </taxonlabel>
76 5294 aaronmk
                                                                    </parent_id>
77 5608 aaronmk
                                                                </taxonlabel>
78 5294 aaronmk
                                                            </parent_id>
79 5608 aaronmk
                                                        </taxonlabel>
80 5294 aaronmk
                                                    </parent_id>
81 6403 aaronmk
                                                    <taxonomicname>
82 5788 aaronmk
                                                        <_join_words>
83 6403 aaronmk
                                                            <1><_taxon_family_require_std><family>$Family</family></_taxon_family_require_std></1>
84
                                                            <2>
85
                                                                <_join_words>
86
                                                                    <2>$Genus</2>
87
                                                                    <3>$SpeciesName</3>
88
                                                                    <4>$SubSpeciesName</4>
89
                                                                </_join_words>
90
                                                            </2>
91 5788 aaronmk
                                                        </_join_words>
92 6403 aaronmk
                                                    </taxonomicname>
93
                                                </taxonlabel>
94
                                            </taxonlabel_id>
95
                                            <family>$Family</family>
96
                                            <genus>$Genus</genus>
97
                                            <specific_epithet>$SpeciesName</specific_epithet>
98
                                        </taxonverbatim>
99
                                    </taxonverbatim_id>
100
                                </taxondetermination>
101
                            </taxonoccurrence>
102
                        </locationevent>
103
                    </location>
104
                </path>
105
            </_simplifyPath>
106 4621 aaronmk
        </path>
107 6403 aaronmk
    </_setDefault>
108 4368 aaronmk
</VegBIEN>
109 5655 aaronmk
Inserted 20 new rows into database