Revision 7150
Added by Aaron Marcuse-Kubitza almost 12 years ago
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
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