31 |
31 |
TAXONOBSERVATION_ID,/location/locationevent/locationevent:[@fkey=parent_id]/taxonoccurrence/sourceaccessioncode/_first/1,
|
32 |
32 |
taxonLevel,"/location/locationevent/locationevent:[@fkey=parent_id]/taxonoccurrence/taxondetermination[!isoriginal=true]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/rank",
|
33 |
33 |
denorm_species,"/location/locationevent/locationevent:[@fkey=parent_id]/taxonoccurrence/taxondetermination[!isoriginal=true]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=species]/taxonepithet","unlike VegBank, this is in fact the epithet, not the full name"
|
34 |
|
denorm_genus,"/location/locationevent/locationevent:[@fkey=parent_id]/taxonoccurrence/taxondetermination[!isoriginal=true]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/taxonepithet/_alt/1",must be _alt-ed with genus because this is missing in 1 row that has genus
|
35 |
|
genus,"/location/locationevent/locationevent:[@fkey=parent_id]/taxonoccurrence/taxondetermination[!isoriginal=true]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/taxonepithet/_alt/2","unlike VegBank, does *not* include genus author"
|
|
34 |
genus,"/location/locationevent/locationevent:[@fkey=parent_id]/taxonoccurrence/taxondetermination[!isoriginal=true]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/taxonepithet",
|
36 |
35 |
denorm_family,"/location/locationevent/locationevent:[@fkey=parent_id]/taxonoccurrence/taxondetermination[!isoriginal=true]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=family]/taxonepithet",
|
37 |
36 |
Order,"/location/locationevent/locationevent:[@fkey=parent_id]/taxonoccurrence/taxondetermination[!isoriginal=true]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=order]/taxonepithet",
|
38 |
37 |
Class,"/location/locationevent/locationevent:[@fkey=parent_id]/taxonoccurrence/taxondetermination[!isoriginal=true]/*_id/taxonverbatim/*_id/taxonlabel/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",
|
... | ... | |
43 |
42 |
denorm_family,/location/locationevent/locationevent:[@fkey=parent_id]/taxonoccurrence/taxondetermination[!isoriginal=true]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/prefix/_taxon_family_require_std/family,
|
44 |
43 |
plantNameWithAuthority,/location/locationevent/locationevent:[@fkey=parent_id]/taxonoccurrence/taxondetermination[!isoriginal=true]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/1,
|
45 |
44 |
plantname,/location/locationevent/locationevent:[@fkey=parent_id]/taxonoccurrence/taxondetermination[!isoriginal=true]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/1,
|
46 |
|
denorm_genus,/location/locationevent/locationevent:[@fkey=parent_id]/taxonoccurrence/taxondetermination[!isoriginal=true]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/2/_filter_genus/value/_alt/1,must be _alt-ed with genus because this is missing in 1 row that has genus
|
47 |
|
genus,/location/locationevent/locationevent:[@fkey=parent_id]/taxonoccurrence/taxondetermination[!isoriginal=true]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/2/_filter_genus/value/_alt/2,"unlike VegBank, does *not* include genus author"
|
|
45 |
genus,/location/locationevent/locationevent:[@fkey=parent_id]/taxonoccurrence/taxondetermination[!isoriginal=true]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/2/_filter_genus/value,
|
48 |
46 |
denorm_species,/location/locationevent/locationevent:[@fkey=parent_id]/taxonoccurrence/taxondetermination[!isoriginal=true]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1,"unlike VegBank, this is in fact the epithet, not the full name"
|
49 |
47 |
denorm_triName,"/location/locationevent/locationevent:[@fkey=parent_id]/taxonoccurrence/taxondetermination[!isoriginal=true]/*_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",
|
50 |
48 |
taxonLevel,"/location/locationevent/locationevent:[@fkey=parent_id]/taxonoccurrence/taxondetermination[!isoriginal=true]/*_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""]/then",
|
51 |
49 |
denorm_triName,/location/locationevent/locationevent:[@fkey=parent_id]/taxonoccurrence/taxondetermination[!isoriginal=true]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2,
|
52 |
50 |
denorm_family,/location/locationevent/locationevent:[@fkey=parent_id]/taxonoccurrence/taxondetermination[!isoriginal=true]/*_id/taxonverbatim/family,
|
53 |
|
denorm_genus,/location/locationevent/locationevent:[@fkey=parent_id]/taxonoccurrence/taxondetermination[!isoriginal=true]/*_id/taxonverbatim/genus/_alt/1,must be _alt-ed with genus because this is missing in 1 row that has genus
|
54 |
|
genus,/location/locationevent/locationevent:[@fkey=parent_id]/taxonoccurrence/taxondetermination[!isoriginal=true]/*_id/taxonverbatim/genus/_alt/2,"unlike VegBank, does *not* include genus author"
|
|
51 |
genus,/location/locationevent/locationevent:[@fkey=parent_id]/taxonoccurrence/taxondetermination[!isoriginal=true]/*_id/taxonverbatim/genus,
|
55 |
52 |
denorm_species,/location/locationevent/locationevent:[@fkey=parent_id]/taxonoccurrence/taxondetermination[!isoriginal=true]/*_id/taxonverbatim/specific_epithet,"unlike VegBank, this is in fact the epithet, not the full name"
|
56 |
53 |
plantname,/location/locationevent/locationevent:[@fkey=parent_id]/taxonoccurrence/taxondetermination[!isoriginal=true]/*_id/taxonverbatim/taxonname,
|
57 |
54 |
plantNameWithAuthority,/location/locationevent/locationevent:[@fkey=parent_id]/taxonoccurrence/taxondetermination[!isoriginal=true]/*_id/taxonverbatim/taxonomicname,
|
... | ... | |
65 |
62 |
authorPlantName,/location/locationevent/locationevent:[@fkey=parent_id]/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/taxonname,
|
66 |
63 |
museumAccessionNumber,"/location/locationevent/locationevent:[@fkey=parent_id]/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then",
|
67 |
64 |
collectionNumber,"/location/locationevent/locationevent:[@fkey=parent_id]/taxonoccurrence/voucher/*_id/specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/then",
|
68 |
|
Division,,** No join mapping for *division/_alt/2 **
|
|
65 |
Division,,** No join mapping for division_normalized/_alt/2 **
|
69 |
66 |
Kingdom,,** No non-empty join mapping for DUPLICATE#of:denorm_kingdom#Kingdom **
|
70 |
67 |
PLANTCONCEPT_ID,,** No join mapping for *PLANTCONCEPT_ID **
|
71 |
68 |
PLANTNAME_ID,,** No join mapping for *PLANTNAME_ID **
|
... | ... | |
92 |
89 |
dba_src_ID,,** No join mapping for *dba_src_ID **
|
93 |
90 |
dba_unsure,,** No join mapping for *dba_unsure **
|
94 |
91 |
denorm_category,,** No join mapping for *category **
|
95 |
|
denorm_division,,"** No join mapping for *division/_alt/1 ** must be _alt-ed with Division because this is missing in 2 rows that have Division, and different from Division in 1 row"
|
|
92 |
denorm_division,,"** No join mapping for division_main/_alt/1 ** must be _alt-ed with Division because this is missing in 2 rows that have Division, and different from Division in 1 row"
|
|
93 |
denorm_genus,,** No join mapping for genus_main/_alt/1 ** must be _alt-ed with genus because this is missing in 1 row that has genus
|
96 |
94 |
denorm_hybridX,,** No join mapping for *hybridX **
|
97 |
95 |
denorm_quadAbbr,,** No join mapping for infraspecificRank2 ** sometimes misparsed as the last + sign in the plantNameWithAuthority
|
98 |
96 |
denorm_quadName,,** No join mapping for infraspecificEpithet2 ** sometimes misparsed as the part after the last + sign in the plantNameWithAuthority
|
99 |
97 |
denorm_triAbbr,,** No join mapping for infraspecificRank **
|
|
98 |
division,,** No join mapping for *division **
|
100 |
99 |
entry_herbLineID,,** No join mapping for *entry_herbLineID **
|
101 |
100 |
entry_sortOrder,,** No join mapping for *entry_sortOrder **
|
102 |
101 |
entry_treeLineID,,** No join mapping for *entry_treeLineID **
|
103 |
102 |
entry_unknownSp,,** No join mapping for *entry_unknownSp **
|
104 |
103 |
exotic,,** No join mapping for *exotic **
|
105 |
104 |
family,,** No non-empty join mapping for DUPLICATE#of:denorm_family#family **
|
|
105 |
genus,,"** No join mapping for genus_normalized/_alt/2 ** unlike VegBank, does *not* include genus author"
|
106 |
106 |
groupType,,** No join mapping for *groupType **
|
107 |
107 |
growthForm_short,,** No join mapping for *growthForm_short **
|
108 |
108 |
lowestChildRank,,** No join mapping for *lowestChildRank **
|
... | ... | |
121 |
121 |
reference_ID,,** No join mapping for *reference_ID **
|
122 |
122 |
revisions,,** No join mapping for *revisions **
|
123 |
123 |
section,,** No join mapping for *section **
|
|
124 |
sensitiveSpeciesFuzzPlot,,** No join mapping for *sensitiveSpeciesFuzzPlot **
|
124 |
125 |
species,,** No join mapping for speciesBinomial ** full taxonomic name at that rank
|
125 |
126 |
subgenus,,** No join mapping for subgenus **
|
126 |
127 |
subspecies,,** No non-empty join mapping for EQUIV#to:species#subspecies ** full taxonomic name at that rank
|
fix: inputs/CVS/taxonObservation_/header.csv, map.csv: updated for CVS refresh and addition of plantConcept_ derived columns