Project

General

Profile

« Previous | Next » 

Revision 10260

inputs/*/ which do not contain any explicit collisions (wiki.vegpath.org/2013-06-27_conference_call#To-do-for-Aaron > #3.2 > the following datasources ...): switched to new-style import, which adds the staging table column renaming

View differences:

test.xml.ref
7 7
                <next>parent_id</next>
8 8
                <path>
9 9
                    <location>
10
                        <authorlocationcode>$TraitObservationID</authorlocationcode>
10
                        <authorlocationcode>$occurrenceID</authorlocationcode>
11 11
                        <elevation_m>
12 12
                            <_units>
13 13
                                <to>m</to>
14 14
                                <to></to>
15
                                <value>$VerbatimElevation</value>
15
                                <value>$verbatimElevation</value>
16 16
                            </_units>
17 17
                        </elevation_m>
18
                        <iscultivated><_locationnarrative_is_cultivated><locationnarrative>$LocalityDescription</locationnarrative></_locationnarrative_is_cultivated></iscultivated>
18
                        <iscultivated><_locationnarrative_is_cultivated><locationnarrative>$verbatimLocality</locationnarrative></_locationnarrative_is_cultivated></iscultivated>
19 19
                        <locationevent>
20
                            <method_id><method><name>$Method</name></method></method_id>
20
                            <method_id><method><name>$samplingProtocol</name></method></method_id>
21 21
                            <taxonoccurrence>
22
                                <aggregateoccurrence><plantobservation><specimenreplicate><sourceaccessioncode>$TraitObservationID</sourceaccessioncode></specimenreplicate></plantobservation></aggregateoccurrence>
23
                                <growthform>$Habit</growthform>
24
                                <sourceaccessioncode>$TraitObservationID</sourceaccessioncode>
22
                                <aggregateoccurrence><plantobservation><specimenreplicate><sourceaccessioncode>$occurrenceID</sourceaccessioncode></specimenreplicate></plantobservation></aggregateoccurrence>
23
                                <growthform>$growthForm</growthform>
24
                                <sourceaccessioncode>$occurrenceID</sourceaccessioncode>
25 25
                                <taxondetermination>
26 26
                                    <taxonverbatim_id>
27 27
                                        <taxonverbatim>
......
29 29
                                                <taxonlabel>
30 30
                                                    <parent_id>
31 31
                                                        <taxonlabel>
32
                                                            <rank>$InfraspecificRank</rank>
32
                                                            <rank>$taxonRank</rank>
33 33
                                                            <parent_id>
34 34
                                                                <taxonlabel>
35 35
                                                                    <rank>cultivar</rank>
......
45 45
                                                                                            <parent_id>
46 46
                                                                                                <taxonlabel>
47 47
                                                                                                    <rank>species</rank>
48
                                                                                                    <taxonepithet>$SpecificEpithet</taxonepithet>
48
                                                                                                    <taxonepithet>$specificEpithet</taxonepithet>
49 49
                                                                                                    <parent_id>
50 50
                                                                                                        <taxonlabel>
51 51
                                                                                                            <rank>genus</rank>
52
                                                                                                            <taxonepithet>$Genus</taxonepithet>
52
                                                                                                            <taxonepithet>$genus</taxonepithet>
53 53
                                                                                                            <parent_id>
54 54
                                                                                                                <taxonlabel>
55 55
                                                                                                                    <rank>family</rank>
56
                                                                                                                    <taxonepithet>$Family</taxonepithet>
56
                                                                                                                    <taxonepithet>$family</taxonepithet>
57 57
                                                                                                                </taxonlabel>
58 58
                                                                                                            </parent_id>
59 59
                                                                                                        </taxonlabel>
......
68 68
                                                                    </parent_id>
69 69
                                                                </taxonlabel>
70 70
                                                            </parent_id>
71
                                                            <taxonepithet>$InfraspecificEpithet</taxonepithet>
71
                                                            <taxonepithet>$infraspecificEpithet</taxonepithet>
72 72
                                                        </taxonlabel>
73 73
                                                    </parent_id>
74
                                                    <rank>$InfraspecificRank</rank>
74
                                                    <rank>$taxonRank</rank>
75 75
                                                    <taxonomicname>
76 76
                                                        <_merge_prefix>
77
                                                            <prefix><_taxon_family_require_std><family>$Family</family></_taxon_family_require_std></prefix>
77
                                                            <prefix><_taxon_family_require_std><family>$family</family></_taxon_family_require_std></prefix>
78 78
                                                            <value>
79 79
                                                                <_join_words>
80 80
                                                                    <1>
81 81
                                                                        <_alt>
82
                                                                            <1>$Taxon</1>
82
                                                                            <1>$taxonName</1>
83 83
                                                                            <2>
84 84
                                                                                <_join_words>
85
                                                                                    <2><_filter_genus><value>$Genus</value></_filter_genus></2>
86
                                                                                    <3>$SpecificEpithet</3>
85
                                                                                    <2><_filter_genus><value>$genus</value></_filter_genus></2>
86
                                                                                    <3>$specificEpithet</3>
87 87
                                                                                    <5>
88 88
                                                                                        <_join_words>
89 89
                                                                                            <1>
90 90
                                                                                                <_if name="if has infraspecificEpithet">
91
                                                                                                    <cond>$InfraspecificEpithet</cond>
92
                                                                                                    <then>$InfraspecificRank</then>
91
                                                                                                    <cond>$infraspecificEpithet</cond>
92
                                                                                                    <then>$taxonRank</then>
93 93
                                                                                                </_if>
94 94
                                                                                            </1>
95
                                                                                            <2>$InfraspecificEpithet</2>
95
                                                                                            <2>$infraspecificEpithet</2>
96 96
                                                                                        </_join_words>
97 97
                                                                                    </5>
98 98
                                                                                </_join_words>
99 99
                                                                            </2>
100 100
                                                                        </_alt>
101 101
                                                                    </1>
102
                                                                    <2>$AuthorOfScientificName</2>
102
                                                                    <2>$scientificNameAuthorship</2>
103 103
                                                                </_join_words>
104 104
                                                            </value>
105 105
                                                        </_merge_prefix>
106 106
                                                    </taxonomicname>
107 107
                                                </taxonlabel>
108 108
                                            </taxonlabel_id>
109
                                            <author>$AuthorOfScientificName</author>
110
                                            <family>$Family</family>
111
                                            <genus>$Genus</genus>
112
                                            <specific_epithet>$SpecificEpithet</specific_epithet>
113
                                            <taxonname>$Taxon</taxonname>
114
                                            <verbatimrank>$InfraspecificRank</verbatimrank>
109
                                            <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 115
                                        </taxonverbatim>
116 116
                                    </taxonverbatim_id>
117 117
                                </taxondetermination>
118 118
                                <trait>
119
                                    <name>$TraitName</name>
120
                                    <units>$Unit</units>
121
                                    <value>$TraitValue</value>
119
                                    <name>$measurementName</name>
120
                                    <units>$measurementUnit</units>
121
                                    <value>$measurementValue</value>
122 122
                                </trait>
123 123
                            </taxonoccurrence>
124 124
                        </locationevent>
125
                        <locationnarrative>$LocalityDescription</locationnarrative>
125
                        <locationnarrative>$verbatimLocality</locationnarrative>
126 126
                        <locationplace>
127 127
                            <place_id>
128 128
                                <place>
129 129
                                    <coordinates_id>
130 130
                                        <coordinates>
131
                                            <verbatimlatitude>$VerbatimLatitude</verbatimlatitude>
132
                                            <verbatimlongitude>$VerbatimLongitude</verbatimlongitude>
131
                                            <verbatimlatitude>$verbatimLatitude</verbatimlatitude>
132
                                            <verbatimlongitude>$verbatimLongitude</verbatimlongitude>
133 133
                                        </coordinates>
134 134
                                    </coordinates_id>
135
                                    <country>$Country</country>
135
                                    <country>$country</country>
136 136
                                    <matched_place_id>
137 137
                                        <place>
138 138
                                            <source_id><source><shortname>geoscrub</shortname></source></source_id>
139
                                            <country>$Country</country>
140
                                            <stateprovince>$StateProvince</stateprovince>
139
                                            <country>$country</country>
140
                                            <stateprovince>$stateProvince</stateprovince>
141 141
                                        </place>
142 142
                                    </matched_place_id>
143
                                    <stateprovince>$StateProvince</stateprovince>
143
                                    <stateprovince>$stateProvince</stateprovince>
144 144
                                </place>
145 145
                            </place_id>
146 146
                        </locationplace>
147
                        <verbatimelevation>$VerbatimElevation</verbatimelevation>
147
                        <verbatimelevation>$verbatimElevation</verbatimelevation>
148 148
                    </location>
149 149
                </path>
150 150
            </_simplifyPath>

Also available in: Unified diff