Project

General

Profile

« Previous | Next » 

Revision 5064

mappings/VegCore-VegBIEN.csv: Mapped verbatimScientificNameWithAuthorship, so that it links a verbatim taxonpath to the scrubbed taxonpath created from the primary taxonomic terms

View differences:

inputs/.TNRS/tnrs/VegBIEN.csv
8 8
Accepted_name_family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/1,
9 9
Accepted_name_rank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/5/_join_words/1,
10 10
Accepted_name_author,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/2,
11
Name_submitted,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonpath:[@fkey=canon_taxonpath_id]/taxonomicnamewithauthor,
11 12
Accepted_name_lsid,,** No non-empty join mapping for OMIT ** 
12 13
Accepted_name_species,,** No non-empty join mapping for OMIT ** Also contains genus. Omitted because Accepted_name contains more info.
13 14
Accepted_name_url,,** No non-empty join mapping for OMIT ** 
......
31 32
Name_matched_url,,** No non-empty join mapping for OMIT ** 
32 33
Name_number,,** No non-empty join mapping for OMIT ** 
33 34
Name_score,,** No non-empty join mapping for OMIT ** 
34
Name_submitted,,** No join mapping for verbatimScientificNameWithAuthorship ** 
35 35
Overall_score,,** No non-empty join mapping for OMIT ** 
36 36
Selected,,** No non-empty join mapping for OMIT ** 
37 37
Source,,** No non-empty join mapping for OMIT ** 
inputs/.TNRS/tnrs/test.xml.ref
20 20
                                            <2>$Accepted_name_author</2>
21 21
                                        </_join_words>
22 22
                                    </taxonomicnamewithauthor>
23
                                    <taxonpath fkey="canon_taxonpath_id"><taxonomicnamewithauthor>$Name_submitted</taxonomicnamewithauthor></taxonpath>
23 24
                                </taxonpath>
24 25
                            </taxonpath_id>
25 26
                        </taxondetermination>
......
29 30
        </path>
30 31
    </_simplifyPath>
31 32
</VegBIEN>
32
Inserted 7 new rows into database
33
Inserted 9 new rows into database
inputs/.TNRS/tnrs/unmapped_terms.csv
1
verbatimScientificNameWithAuthorship
2 1
taxonomicStatus
mappings/VegCore-VegBIEN.csv
154 154
forma,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/7/_join_words:[1=fm.]/2,
155 155
cultivar,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/1/_first/2/_join_words/8/_join_words:[1=cult.]/2,
156 156
scientificNameAuthorship,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor/_first/2/_join_words/2,
157
verbatimScientificNameWithAuthorship,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonpath:[@fkey=canon_taxonpath_id]/taxonomicnamewithauthor,
157 158
variety,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/variety,
158 159
dateIdentified,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/1/_*/date/_dateRangeStart/value,
159 160
dayIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value",
mappings/for_review/VegCore-VegBIEN.csv
154 154
forma,//taxonoccurrence/taxondetermination[]/*_id/taxonpath/taxonomicnamewithauthor,
155 155
cultivar,//taxonoccurrence/taxondetermination[]/*_id/taxonpath/taxonomicnamewithauthor,
156 156
scientificNameAuthorship,//taxonoccurrence/taxondetermination[]/*_id/taxonpath/taxonomicnamewithauthor,
157
verbatimScientificNameWithAuthorship,//taxonoccurrence/taxondetermination[]/*_id/taxonpath/taxonpath/taxonomicnamewithauthor,
157 158
variety,//taxonoccurrence/taxondetermination[]/*_id/taxonpath/variety,
158 159
dateIdentified,//taxonoccurrence/taxondetermination[]/determinationdate/_*/date,
159 160
dayIdentified,//taxonoccurrence/taxondetermination[]/determinationdate,

Also available in: Unified diff