Project

General

Profile

« Previous | Next » 

Revision 7307

mappings/VegCore-VegBIEN.csv: Mapped accepted* taxonomic name, now to separate accepted taxondetermination

View differences:

inputs/.TNRS/public.unscrubbed_taxondetermination_view/VegBIEN.csv
1 1
TNRS,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments
2 2
:0,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",Enables the taxonoccurrence CHECK constraint to pass
3
:true,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/*_id/taxonlabel:[taxonstatus=Accepted]/matched_label_id/_if[@name=""if is canonical name""]:[then=0]/cond","This table contains only canonicalized names. (Not all names are accepted, but those that aren’t don’t (yet) have an accepted match.)"
4
:true,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/*_id/taxonlabel:[taxonstatus=Accepted]/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/_if[@name=""if is canonical name""]/cond/_exists","This table contains only canonicalized names. (Not all names are accepted, but those that aren’t don’t (yet) have an accepted match.)"
5
:true,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/*_id/taxonlabel:[taxonstatus=Accepted]/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=family]/_if[@name=""if is canonical name""]/cond/_exists","This table contains only canonicalized names. (Not all names are accepted, but those that aren’t don’t (yet) have an accepted match.)"
6
:_,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/determinationdate/_alt/1/_dateRangeStart/value/_now",
7
Family_score,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/taxonfit/_max/1",
8
Genus_score,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/taxonfit/_max/2",
9
Specific_epithet_score,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/taxonfit/_max/3",
10
Overall_score,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/taxonfit/_max/4",Assuming is a fraction based on the range of values
3 11
Name_matched,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/3/_first/3",
4 12
:0,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",Enables the taxonoccurrence CHECK constraint to pass
5 13
:0,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/1,Enables the taxonoccurrence CHECK constraint to pass
mappings/VegCore-VegBIEN.csv
99 99
silt_percent,/location/locationevent/soilsample/silt_fraction/_percent_to_fraction/value,
100 100
sodium_percent,/location/locationevent/soilsample/sodium_fraction/_percent_to_fraction/value,
101 101
texture,/location/locationevent/soilsample/texture,
102
acceptedScientificName,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/cond/_exists",
103
acceptedTaxonName,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/cond/_exists",
104
taxonIsCanonical,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/*_id/taxonlabel:[taxonstatus=Accepted]/matched_label_id/_if[@name=""if is canonical name""]:[then=0]/cond",
105
acceptedCultivar,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/*_id/taxonlabel:[taxonstatus=Accepted]/parent_id/taxonlabel/parent_id/_forEach:[in:[],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=cultivar]/taxonepithet",
106
acceptedForma,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/*_id/taxonlabel:[taxonstatus=Accepted]/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=forma]/taxonepithet",
107
acceptedVariety,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/*_id/taxonlabel:[taxonstatus=Accepted]/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=variety]/taxonepithet",
108
acceptedSubspecies,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/*_id/taxonlabel:[taxonstatus=Accepted]/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=subspecies]/taxonepithet",
109
acceptedSpecificEpithet,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/*_id/taxonlabel:[taxonstatus=Accepted]/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=species]/taxonepithet",
110
taxonIsCanonical,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/*_id/taxonlabel:[taxonstatus=Accepted]/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/_if[@name=""if is canonical name""]/cond/_exists",
111
acceptedGenus,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/*_id/taxonlabel:[taxonstatus=Accepted]/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/_if[@name=""if is canonical name""]/then/matched_label_id/taxonlabel:[source_id/source/shortname=NCBI]/taxonomicname",
112
acceptedGenus,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/*_id/taxonlabel:[taxonstatus=Accepted]/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/taxonepithet",
113
taxonIsCanonical,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/*_id/taxonlabel:[taxonstatus=Accepted]/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=family]/_if[@name=""if is canonical name""]/cond/_exists",
114
acceptedFamily,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/*_id/taxonlabel:[taxonstatus=Accepted]/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=family]/_if[@name=""if is canonical name""]/then/matched_label_id/taxonlabel:[source_id/source/shortname=NCBI]/taxonomicname",
115
acceptedFamily,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/*_id/taxonlabel:[taxonstatus=Accepted]/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=family]/taxonepithet",
116
acceptedOrder,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/*_id/taxonlabel:[taxonstatus=Accepted]/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=order]/taxonepithet",
117
acceptedClass,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/*_id/taxonlabel:[taxonstatus=Accepted]/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=class]/taxonepithet",
118
acceptedPhylum,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/*_id/taxonlabel:[taxonstatus=Accepted]/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=phylum]/taxonepithet",
119
acceptedKingdom,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/*_id/taxonlabel:[taxonstatus=Accepted]/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",
120
acceptedTaxonRank,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/*_id/taxonlabel:[taxonstatus=Accepted]/parent_id/taxonlabel/rank",
121
acceptedInfraspecificEpithet,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/*_id/taxonlabel:[taxonstatus=Accepted]/parent_id/taxonlabel/taxonepithet",
122
acceptedTaxonRank,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/*_id/taxonlabel:[taxonstatus=Accepted]/rank",
123
acceptedScientificNameID,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/*_id/taxonlabel:[taxonstatus=Accepted]/sourceaccessioncode",
124
acceptedFamily,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/*_id/taxonlabel:[taxonstatus=Accepted]/taxonomicname/_merge_prefix/prefix/_taxon_family_require_std/family",
125
acceptedScientificName,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/*_id/taxonlabel:[taxonstatus=Accepted]/taxonomicname/_merge_prefix/value/_alt/1",
126
acceptedTaxonName,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/*_id/taxonlabel:[taxonstatus=Accepted]/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/1",
127
acceptedGenus,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/*_id/taxonlabel:[taxonstatus=Accepted]/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/2",
128
acceptedSpecificEpithet,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/*_id/taxonlabel:[taxonstatus=Accepted]/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
129
acceptedSubspecies,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/*_id/taxonlabel:[taxonstatus=Accepted]/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/4",
130
acceptedInfraspecificEpithet,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/*_id/taxonlabel:[taxonstatus=Accepted]/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond",
131
acceptedTaxonRank,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/*_id/taxonlabel:[taxonstatus=Accepted]/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then",
132
acceptedInfraspecificEpithet,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/*_id/taxonlabel:[taxonstatus=Accepted]/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2",
133
acceptedVariety,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/*_id/taxonlabel:[taxonstatus=Accepted]/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/6/_join_words:[1=""var. ""]/2",
134
acceptedForma,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/*_id/taxonlabel:[taxonstatus=Accepted]/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/7/_join_words:[1=""fm. ""]/2",
135
acceptedCultivar,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/*_id/taxonlabel:[taxonstatus=Accepted]/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/8/_join_words:[1=""cult. ""]/2",
136
acceptedScientificNameAuthorship,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/*_id/taxonlabel:[taxonstatus=Accepted]/taxonomicname/_merge_prefix/value/_alt/2/_join_words/2",
137
acceptedScientificNameAuthorship,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/author",
138
acceptedFamily,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/family",
139
acceptedGenus,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/genus",
140
acceptedSpecificEpithet,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/specific_epithet",
141
acceptedTaxonName,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/taxonname",
142
acceptedScientificName,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/taxonomicname",
143
acceptedTaxonRank,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/verbatimrank",
144
dateIdentified,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/determinationdate/_alt/1/_dateRangeStart/value",
145
dayIdentified,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/determinationdate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value",
146
monthIdentified,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/determinationdate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value",
147
yearIdentified,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/determinationdate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value",
148
taxonRemarks,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/notes",
149
identificationQualifier,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/taxonfit",
150
matchedFamilyFit_fraction,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/taxonfit/_max/1",
151
matchedGenusFit_fraction,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/taxonfit/_max/2",
152
matchedSpeciesFit_fraction,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/taxonfit/_max/3",
153
matchedTaxonFit_fraction,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/taxonfit/_max/4",
102 154
dateCollected,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/1,
103 155
dayCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value",
104 156
monthCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value",
mappings/for_review/VegCore-VegBIEN.csv
99 99
silt_percent,//soilsample/silt_fraction/_percent_to_fraction/value,
100 100
sodium_percent,//soilsample/sodium_fraction/_percent_to_fraction/value,
101 101
texture,//soilsample/texture,
102
acceptedScientificName,"//locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/cond/_exists",
103
acceptedTaxonName,"//locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/cond/_exists",
104
taxonIsCanonical,"//locationevent/taxonoccurrence/taxondetermination/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/cond",
105
acceptedCultivar,//locationevent/taxonoccurrence/taxondetermination/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id[rank=cultivar]/taxonepithet,
106
acceptedForma,//locationevent/taxonoccurrence/taxondetermination/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id[rank=forma]/taxonepithet,
107
acceptedVariety,//locationevent/taxonoccurrence/taxondetermination/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id[rank=variety]/taxonepithet,
108
acceptedSubspecies,//locationevent/taxonoccurrence/taxondetermination/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id[rank=subspecies]/taxonepithet,
109
acceptedSpecificEpithet,//locationevent/taxonoccurrence/taxondetermination/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id[rank=species]/taxonepithet,
110
taxonIsCanonical,"//locationevent/taxonoccurrence/taxondetermination/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_if[@name=""if is canonical name""]/cond/_exists",
111
acceptedGenus,"//locationevent/taxonoccurrence/taxondetermination/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_if[@name=""if is canonical name""]/then/matched_label_id/taxonlabel/taxonomicname",
112
acceptedGenus,//locationevent/taxonoccurrence/taxondetermination/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id[rank=genus]/taxonepithet,
113
taxonIsCanonical,"//locationevent/taxonoccurrence/taxondetermination/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_if[@name=""if is canonical name""]/cond/_exists",
114
acceptedFamily,"//locationevent/taxonoccurrence/taxondetermination/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_if[@name=""if is canonical name""]/then/matched_label_id/taxonlabel/taxonomicname",
115
acceptedFamily,//locationevent/taxonoccurrence/taxondetermination/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id[rank=family]/taxonepithet,
116
acceptedOrder,//locationevent/taxonoccurrence/taxondetermination/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id[rank=order]/taxonepithet,
117
acceptedClass,//locationevent/taxonoccurrence/taxondetermination/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id[rank=class]/taxonepithet,
118
acceptedPhylum,//locationevent/taxonoccurrence/taxondetermination/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id[rank=phylum]/taxonepithet,
119
acceptedKingdom,//locationevent/taxonoccurrence/taxondetermination/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id[rank=kingdom]/taxonepithet,
120
acceptedTaxonRank,"//locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/rank",
121
acceptedInfraspecificEpithet,"//locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/taxonepithet",
122
acceptedTaxonRank,"//locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination/*_id/taxonverbatim/*_id/taxonlabel/rank",
123
acceptedScientificNameID,"//locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination/*_id/taxonverbatim/*_id/taxonlabel/sourceaccessioncode",
124
acceptedFamily,"//locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname",
125
acceptedScientificName,"//locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname",
126
acceptedTaxonName,"//locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname",
127
acceptedGenus,"//locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname",
128
acceptedSpecificEpithet,"//locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname",
129
acceptedSubspecies,"//locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname",
130
acceptedInfraspecificEpithet,"//locationevent/taxonoccurrence/taxondetermination/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_if[@name=""if has infraspecificEpithet""]/cond",
131
acceptedTaxonRank,"//locationevent/taxonoccurrence/taxondetermination/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_if[@name=""if has infraspecificEpithet""]/then",
132
acceptedInfraspecificEpithet,"//locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname",
133
acceptedVariety,"//locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname",
134
acceptedForma,"//locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname",
135
acceptedCultivar,"//locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname",
136
acceptedScientificNameAuthorship,"//locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname",
137
acceptedScientificNameAuthorship,"//locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination/*_id/taxonverbatim/author",
138
acceptedFamily,"//locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination/*_id/taxonverbatim/family",
139
acceptedGenus,"//locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination/*_id/taxonverbatim/genus",
140
acceptedSpecificEpithet,"//locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination/*_id/taxonverbatim/specific_epithet",
141
acceptedTaxonName,"//locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination/*_id/taxonverbatim/taxonname",
142
acceptedScientificName,"//locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination/*_id/taxonverbatim/taxonomicname",
143
acceptedTaxonRank,"//locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination/*_id/taxonverbatim/verbatimrank",
144
dateIdentified,"//locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination/determinationdate",
145
dayIdentified,"//locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination/determinationdate",
146
monthIdentified,"//locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination/determinationdate",
147
yearIdentified,"//locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination/determinationdate",
148
taxonRemarks,"//locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination/notes",
149
identificationQualifier,"//locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination/taxonfit",
150
matchedFamilyFit_fraction,"//locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination/taxonfit",
151
matchedGenusFit_fraction,"//locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination/taxonfit",
152
matchedSpeciesFit_fraction,"//locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination/taxonfit",
153
matchedTaxonFit_fraction,"//locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination/taxonfit",
102 154
dateCollected,//aggregateoccurrence/collectiondate,
103 155
dayCollected,//aggregateoccurrence/collectiondate,
104 156
monthCollected,//aggregateoccurrence/collectiondate,

Also available in: Unified diff