Project

General

Profile

« Previous | Next » 

Revision 7150

mappings/VegCore-VegBIEN.csv: "if has verbatim name" _if statements that filter something out for TNRS mappings: Also assume true if taxonIsCanonical is specified, because some TNRS tables (eventually such as public.unscrubbed_taxondetermination_view) do not specify a separate "verbatim" taxondetermination but do provide taxonIsCanonical as a flag to turn various mappings on and off

View differences:

inputs/.TNRS/tnrs_accepted/VegBIEN.csv
54 54
Name_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/1,
55 55
Genus_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/2,
56 56
Specific_epithet_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1,
57
:true,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/2/_if[@name=""if has verbatim name""]/cond/_exists",This table contains only accepted names (names that scrub to themselves)
57 58
Name_submitted,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/2/_if[@name=""if has verbatim name""]/cond/_exists",
58 59
Unmatched_terms,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/2/_if[@name=""if has verbatim name""]/else",
59 60
Infraspecific_epithet_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond",
......
64 65
Name_matched_author,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/author,Contains author based on matched name
65 66
Name_matched_accepted_family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/family,Contains family based on matched name
66 67
Genus_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/genus,
68
:true,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/morphospecies/_if[@name=""if has verbatim name""]/cond/_exists",This table contains only accepted names (names that scrub to themselves)
67 69
Name_submitted,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/morphospecies/_if[@name=""if has verbatim name""]/cond/_exists",
68 70
Unmatched_terms,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/morphospecies/_if[@name=""if has verbatim name""]/else",
69 71
Specific_epithet_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/specific_epithet,
mappings/VegCore-VegBIEN.csv
270 270
taxonName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/1,
271 271
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/2,
272 272
specificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1,
273
taxonIsCanonical,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/2/_if[@name=""if has verbatim name""]/cond/_exists",
273 274
verbatimScientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/2/_if[@name=""if has verbatim name""]/cond/_exists",
274 275
morphospecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/2/_if[@name=""if has verbatim name""]/else",
275 276
subspecies,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/4,
......
285 286
scientificNameAuthorship,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/author,
286 287
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/family,
287 288
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/genus,
289
taxonIsCanonical,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/morphospecies/_if[@name=""if has verbatim name""]/cond/_exists",
288 290
verbatimScientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/morphospecies/_if[@name=""if has verbatim name""]/cond/_exists",
289 291
morphospecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/morphospecies/_if[@name=""if has verbatim name""]/else",
290 292
specificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/specific_epithet,
mappings/for_review/VegCore-VegBIEN.csv
270 270
taxonName,//taxonoccurrence/taxondetermination[]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname,
271 271
genus,//taxonoccurrence/taxondetermination[]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname,
272 272
specificEpithet,//taxonoccurrence/taxondetermination[]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname,
273
taxonIsCanonical,"//taxonlabel/taxonomicname/_if[@name=""if has verbatim name""]/cond/_exists",
273 274
verbatimScientificName,"//taxonlabel/taxonomicname/_if[@name=""if has verbatim name""]/cond/_exists",
274 275
morphospecies,"//taxonlabel/taxonomicname/_if[@name=""if has verbatim name""]/else",
275 276
subspecies,//taxonoccurrence/taxondetermination[]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname,
......
285 286
scientificNameAuthorship,//taxonoccurrence/taxondetermination[]/*_id/taxonverbatim/author,
286 287
family,//taxonoccurrence/taxondetermination[]/*_id/taxonverbatim/family,
287 288
genus,//taxonoccurrence/taxondetermination[]/*_id/taxonverbatim/genus,
289
taxonIsCanonical,"//taxonverbatim/morphospecies/_if[@name=""if has verbatim name""]/cond/_exists",
288 290
verbatimScientificName,"//taxonverbatim/morphospecies/_if[@name=""if has verbatim name""]/cond/_exists",
289 291
morphospecies,"//taxonverbatim/morphospecies/_if[@name=""if has verbatim name""]/else",
290 292
specificEpithet,//taxonoccurrence/taxondetermination[]/*_id/taxonverbatim/specific_epithet,

Also available in: Unified diff