Project

General

Profile

« Previous | Next » 

Revision 6817

Added by Aaron Marcuse-Kubitza almost 12 years ago

inputs/CVS/taxonObservation_/map.csv: Mapped plantname, plantNameWithAuthority

View differences:

inputs/CVS/taxonObservation_/map.csv
62 62 
dba_unsure,*dba_unsure,,
63 63 
PLANTNAME_ID,*PLANTNAME_ID,,
64 64 
plantConcept_reference_ID,*plantConcept_reference_ID,,
65 
plantname,*plantname,,
66 
plantNameWithAuthority,*plantNameWithAuthority,,
65 
plantname,taxonName,,
66 
plantNameWithAuthority,scientificName,,
67 67 
plantCode,*plantCode,,
68 68 
plantDescription,*plantDescription,,
69 69 
plantConcept_accessionCode,*plantConcept_accessionCode,,
inputs/CVS/taxonObservation_/VegBIEN.csv
16 16 
stemLocation_ID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/sourceaccessioncode,
17 17 
OBSERVATION_ID,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",
18 18 
authorPlantName,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/1",
19 
plantNameWithAuthority,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/2",
20 
plantname,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/3",
19 21 
givenName,/location/locationevent/taxonoccurrence/collector_id/party/fullname/_join_words/1,
20 22 
surName,/location/locationevent/taxonoccurrence/collector_id/party/fullname/_join_words/2,
21 23 
TAXONOBSERVATION_ID,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",
22 24 
TAXONOBSERVATION_ID,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/1,
25 
plantname,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[source_id/source/shortname=TNRS]/taxonomicname/_join_words/1/_taxon_family_require_std/family/_nullIf/null/_first/1",
26 
plantNameWithAuthority,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[source_id/source/shortname=TNRS]/taxonomicname/_join_words/1/_taxon_family_require_std/family/_nullIf/null/_first/2",
23 27 
denorm_family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[source_id/source/shortname=TNRS]/taxonomicname/_join_words/1/_taxon_family_require_std/family/_nullIf/value/_alt/1",
24 28 
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[source_id/source/shortname=TNRS]/taxonomicname/_join_words/1/_taxon_family_require_std/family/_nullIf/value/_alt/2",
29 
plantNameWithAuthority,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[source_id/source/shortname=TNRS]/taxonomicname/_join_words/2/_alt/1",
30 
plantname,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[source_id/source/shortname=TNRS]/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/1",
25 31 
denorm_genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[source_id/source/shortname=TNRS]/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/2/_alt/1",
26 32 
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[source_id/source/shortname=TNRS]/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/2/_alt/2",
27 33 
denorm_species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[source_id/source/shortname=TNRS]/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1/_alt/1",
......
50 56 
Kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,phylum,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=kingdom]/taxonepithet/_alt/2",
51 57 
taxonLevel,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/rank,
52 58 
taxonLevel,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonepithet/_if[@name=""if taxonomic name is epithet""]/cond/_alt:[2=true]/1/_taxonomic_name_is_epithet/rank",
59 
plantname,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/1/_taxon_family_require_std/family/_nullIf/null/_first/1,
60 
plantNameWithAuthority,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/1/_taxon_family_require_std/family/_nullIf/null/_first/2,
53 61 
denorm_family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/1/_taxon_family_require_std/family/_nullIf/value/_alt/1,
54 62 
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/1/_taxon_family_require_std/family/_nullIf/value/_alt/2,
63 
plantNameWithAuthority,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/2/_alt/1,
64 
plantname,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/1,
55 65 
denorm_genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/2/_alt/1,
56 66 
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/2/_alt/2,
57 67 
denorm_species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1/_alt/1,
......
65 75 
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/genus/_alt/2,
66 76 
denorm_species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/specific_epithet/_alt/1,
67 77 
species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/specific_epithet/_alt/2,
78 
plantname,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/taxonname,
79 
plantNameWithAuthority,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/taxonomicname,
68 80 
taxonLevel,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/verbatimrank,
69 81 
interpretationDate,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/1/_dateRangeStart/value,
70 82 
taxonFit,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/taxonfit,
......
137 149 
plantConcept_entry_sppID,,** No join mapping for *plantConcept_entry_sppID **
138 150 
plantConcept_reference_ID,,** No join mapping for *plantConcept_reference_ID **
139 151 
plantDescription,,** No join mapping for *plantDescription **
140 
plantNameWithAuthority,,** No join mapping for *plantNameWithAuthority **
141 
plantname,,** No join mapping for *plantname **
142 152 
reference_ID,,** No join mapping for *reference_ID **
143 153 
revisions,,** No join mapping for *revisions **
144 154 
salutation,,** No join mapping for *salutation **
inputs/CVS/taxonObservation_/test.xml.ref
43 43 
                                                                    <1>
44 44 
                                                                        <_taxon_family_require_std>
45 45 
                                                                            <family>
46 
                                                                                <_alt>
47 
                                                                                    <1>$denorm_family</1>
48 
                                                                                    <2>$family</2>
49 
                                                                                </_alt>
46 
                                                                                <_nullIf>
47 
                                                                                    <null>$plantname</null>
48 
                                                                                    <value>
49 
                                                                                        <_alt>
50 
                                                                                            <1>$denorm_family</1>
51 
                                                                                            <2>$family</2>
52 
                                                                                        </_alt>
53 
                                                                                    </value>
54 
                                                                                </_nullIf>
50 55 
                                                                            </family>
51 56 
                                                                        </_taxon_family_require_std>
52 57 
                                                                    </1>
53 58 
                                                                    <2>
54 
                                                                        <_join_words>
59 
                                                                        <_alt>
60 
                                                                            <1>$plantNameWithAuthority</1>
55 61 
                                                                            <2>
56 62 
                                                                                <_alt>
57 
                                                                                    <1>$denorm_genus</1>
58 
                                                                                    <2>$genus</2>
63 
                                                                                    <1>$plantname</1>
64 
                                                                                    <2>
65 
                                                                                        <_join_words>
66 
                                                                                            <2>
67 
                                                                                                <_alt>
68 
                                                                                                    <1>$denorm_genus</1>
69 
                                                                                                    <2>$genus</2>
70 
                                                                                                </_alt>
71 
                                                                                            </2>
72 
                                                                                            <3>
73 
                                                                                                <_alt>
74 
                                                                                                    <1>$denorm_species</1>
75 
                                                                                                    <2>$species</2>
76 
                                                                                                </_alt>
77 
                                                                                            </3>
78 
                                                                                            <4>$subspecies</4>
79 
                                                                                            <7>
80 
                                                                                                <_join_words>
81 
                                                                                                    <1>var. </1>
82 
                                                                                                    <2>$variety</2>
83 
                                                                                                </_join_words>
84 
                                                                                            </7>
85 
                                                                                        </_join_words>
86 
                                                                                    </2>
59 87 
                                                                                </_alt>
60 88 
                                                                            </2>
61 
                                                                            <3>
62 
                                                                                <_alt>
63 
                                                                                    <1>$denorm_species</1>
64 
                                                                                    <2>$species</2>
65 
                                                                                </_alt>
66 
                                                                            </3>
67 
                                                                            <4>$subspecies</4>
68 
                                                                            <7>
69 
                                                                                <_join_words>
70 
                                                                                    <1>var. </1>
71 
                                                                                    <2>$variety</2>
72 
                                                                                </_join_words>
73 
                                                                            </7>
74 
                                                                        </_join_words>
89 
                                                                        </_alt>
75 90 
                                                                    </2>
76 91 
                                                                </_join_words>
77 92 
                                                            </taxonomicname>
......
173 188 
                                                            <1>
174 189 
                                                                <_taxon_family_require_std>
175 190 
                                                                    <family>
176 
                                                                        <_alt>
177 
                                                                            <1>$denorm_family</1>
178 
                                                                            <2>$family</2>
179 
                                                                        </_alt>
191 
                                                                        <_nullIf>
192 
                                                                            <null>$plantname</null>
193 
                                                                            <value>
194 
                                                                                <_alt>
195 
                                                                                    <1>$denorm_family</1>
196 
                                                                                    <2>$family</2>
197 
                                                                                </_alt>
198 
                                                                            </value>
199 
                                                                        </_nullIf>
180 200 
                                                                    </family>
181 201 
                                                                </_taxon_family_require_std>
182 202 
                                                            </1>
183 203 
                                                            <2>
184 
                                                                <_join_words>
204 
                                                                <_alt>
205 
                                                                    <1>$plantNameWithAuthority</1>
185 206 
                                                                    <2>
186 207 
                                                                        <_alt>
187 
                                                                            <1>$denorm_genus</1>
188 
                                                                            <2>$genus</2>
208 
                                                                            <1>$plantname</1>
209 
                                                                            <2>
210 
                                                                                <_join_words>
211 
                                                                                    <2>
212 
                                                                                        <_alt>
213 
                                                                                            <1>$denorm_genus</1>
214 
                                                                                            <2>$genus</2>
215 
                                                                                        </_alt>
216 
                                                                                    </2>
217 
                                                                                    <3>
218 
                                                                                        <_alt>
219 
                                                                                            <1>$denorm_species</1>
220 
                                                                                            <2>$species</2>
221 
                                                                                        </_alt>
222 
                                                                                    </3>
223 
                                                                                    <4>$subspecies</4>
224 
                                                                                    <6>
225 
                                                                                        <_join_words>
226 
                                                                                            <1>var. </1>
227 
                                                                                            <2>$variety</2>
228 
                                                                                        </_join_words>
229 
                                                                                    </6>
230 
                                                                                </_join_words>
231 
                                                                            </2>
189 232 
                                                                        </_alt>
190 233 
                                                                    </2>
191 
                                                                    <3>
192 
                                                                        <_alt>
193 
                                                                            <1>$denorm_species</1>
194 
                                                                            <2>$species</2>
195 
                                                                        </_alt>
196 
                                                                    </3>
197 
                                                                    <4>$subspecies</4>
198 
                                                                    <6>
199 
                                                                        <_join_words>
200 
                                                                            <1>var. </1>
201 
                                                                            <2>$variety</2>
202 
                                                                        </_join_words>
203 
                                                                    </6>
204 
                                                                </_join_words>
234 
                                                                </_alt>
205 235 
                                                            </2>
206 236 
                                                        </_join_words>
207 237 
                                                    </taxonomicname>
......
225 255 
                                                    <2>$species</2>
226 256 
                                                </_alt>
227 257 
                                            </specific_epithet>
258 
                                            <taxonname>$plantname</taxonname>
259 
                                            <taxonomicname>$plantNameWithAuthority</taxonomicname>
228 260 
                                            <verbatimrank>$taxonLevel</verbatimrank>
229 261 
                                        </taxonverbatim>
230 262 
                                    </taxonverbatim_id>
inputs/CVS/taxonObservation_/new_terms.csv
7 7 
museumAccessionNumber,catalogNumber,,
8 8 
givenName,recordedBy.givenName,,
9 9 
surName,recordedBy.surName,,
10 
plantname,taxonName,,
11 
plantNameWithAuthority,scientificName,,
10 12 
denorm_kingdom,kingdom,/_alt/1,
11 13 
denorm_family,family,/_alt/1,
12 14 
denorm_genus,genus,/_alt/1,
inputs/CVS/taxonObservation_/unmapped_terms.csv
50 50 
*dba_unsure
51 51 
*PLANTNAME_ID
52 52 
*plantConcept_reference_ID
53 
*plantname
54 
*plantNameWithAuthority
55 53 
*plantCode
56 54 
*plantDescription
57 55 
*plantConcept_accessionCode

Also available in: Unified diff