Project

General

Profile

« Previous | Next » 

Revision 6808

Added by Aaron Marcuse-Kubitza almost 12 years ago

inputs/CVS/taxonObservation_/map.csv: Use denorm_* denormalized taxonomic ranks in place of the normalized ranks when both are provided

View differences:

inputs/CVS/taxonObservation_/map.csv
71 71 
plantConcept_entry_sppID,*plantConcept_entry_sppID,,
72 72 
USDAPlantsCode,*USDAPlantsCode,,
73 73 
VascularPlant,*VascularPlant,,
74 
denorm_kingdom,*denorm_kingdom,,
75 
denorm_division,*denorm_division,,
76 
denorm_category,*denorm_category,,
77 
denorm_family,*denorm_family,,
78 
denorm_genus,*denorm_genus,,
79 
denorm_species,*denorm_species,,
80 
denorm_triAbbr,*denorm_triAbbr,,
81 
denorm_triName,*denorm_triName,,
82 
denorm_quadAbbr,*denorm_quadAbbr,,
83 
denorm_quadName,*denorm_quadName,,
84 
denorm_hybridX,*denorm_hybridX,,
74 
denorm_kingdom,kingdom,/_alt/1,
75 
denorm_division,*division,/_alt/1,
76 
denorm_category,*category,/_alt/1,
77 
denorm_family,family,/_alt/1,
78 
denorm_genus,genus,/_alt/1,
79 
denorm_species,specificEpithet,/_alt/1,
80 
denorm_triAbbr,*triAbbr,/_alt/1,
81 
denorm_triName,*triName,/_alt/1,
82 
denorm_quadAbbr,*quadAbbr,/_alt/1,
83 
denorm_quadName,*quadName,/_alt/1,
84 
denorm_hybridX,*hybridX,/_alt/1,
85 85 
taxonLevel,taxonRank,,
86 86 
taxonRank,OMIT,,Omitted because taxonLevel contains this information in text form
87 87 
lowestParentName,*lowestParentName,,
......
93 93 
exotic,*exotic,,
94 94 
usda_code,*usda_code,,
95 95 
usda_growthForm,*usda_growthForm,,
96 
Kingdom,kingdom,,
97 
Subkingdom,*Subkingdom,,
98 
Superdivision,*Superdivision,,
99 
Division,*Division,,
100 
Subdivision,*Subdivision,,
101 
Class,class,,
102 
Subclass,*Subclass,,
103 
Order,order,,
104 
Family,family,,
105 
Genus,genus,,
106 
Species,specificEpithet,,
107 
Subspecies,subspecies,,
108 
Variety,variety,,
109 
Forma,forma,,
96 
Kingdom,kingdom,/_alt/2,
97 
Subkingdom,*Subkingdom,/_alt/2,
98 
Superdivision,*Superdivision,/_alt/2,
99 
Division,*Division,/_alt/2,
100 
Subdivision,*Subdivision,/_alt/2,
101 
Class,class,/_alt/2,
102 
Subclass,*Subclass,/_alt/2,
103 
Order,order,/_alt/2,
104 
Family,family,/_alt/2,
105 
Genus,genus,/_alt/2,
106 
Species,specificEpithet,/_alt/2,
107 
Subspecies,subspecies,/_alt/2,
108 
Variety,variety,/_alt/2,
109 
Forma,forma,/_alt/2,
110 110 
:plot,observationType,,
inputs/CVS/taxonObservation_/VegBIEN.csv
20 20 
surName,/location/locationevent/taxonoccurrence/collector_id/party/fullname/_join_words/2,
21 21 
TAXONOBSERVATION_ID,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",
22 22 
TAXONOBSERVATION_ID,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/1,
23 
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[source_id/source/shortname=TNRS]/taxonomicname/_join_words/1/_taxon_family_require_std/family/_nullIf/value",
24 
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[source_id/source/shortname=TNRS]/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/2",
25 
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[source_id/source/shortname=TNRS]/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
26 
Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[source_id/source/shortname=TNRS]/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/4",
23 
denorm_family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[source_id/source/shortname=TNRS]/taxonomicname/_join_words/1/_taxon_family_require_std/family/_nullIf/value/_alt/1",
24 
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[source_id/source/shortname=TNRS]/taxonomicname/_join_words/1/_taxon_family_require_std/family/_nullIf/value/_alt/2",
25 
denorm_genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[source_id/source/shortname=TNRS]/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/2/_alt/1",
26 
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[source_id/source/shortname=TNRS]/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/2/_alt/2",
27 
denorm_species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[source_id/source/shortname=TNRS]/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1/_alt/1",
28 
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[source_id/source/shortname=TNRS]/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1/_alt/2",
29 
Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[source_id/source/shortname=TNRS]/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/4/_alt/2",
27 30 
taxonLevel,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[source_id/source/shortname=TNRS]/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then",
28 
Variety,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[source_id/source/shortname=TNRS]/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/7/_join_words:[1=""var. ""]/2",
29 
Forma,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[source_id/source/shortname=TNRS]/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/8/_join_words:[1=""fm. ""]/2",
31 
Variety,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[source_id/source/shortname=TNRS]/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/7/_join_words:[1=""var. ""]/2/_alt/2",
32 
Forma,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[source_id/source/shortname=TNRS]/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/8/_join_words:[1=""fm. ""]/2/_alt/2",
30 33 
interpretationDate,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/creationdate/_alt/1/_dateRangeStart/value,
31 34 
taxonLevel,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/rank",
32 35 
taxonLevel,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/taxonverbatim/verbatimrank",
33 
Forma,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=forma]/taxonepithet",
34 
Variety,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=variety]/taxonepithet",
35 
Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=subspecies]/taxonepithet",
36 
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_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",
37 
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_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]/_if[@name=""if is canonical name""]/then/matched_label_id/taxonlabel:[source_id/source/shortname=NCBI]/taxonomicname",
38 
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_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",
39 
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_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]/_if[@name=""if is canonical name""]/then/matched_label_id/taxonlabel:[source_id/source/shortname=NCBI]/taxonomicname",
40 
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_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",
41 
Order,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_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",
42 
Class,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_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 
Kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/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",
36 
Forma,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=forma]/taxonepithet/_alt/2",
37 
Variety,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=variety]/taxonepithet/_alt/2",
38 
Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=subspecies]/taxonepithet/_alt/2",
39 
denorm_species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_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/_alt/1",
40 
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_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/_alt/2",
41 
denorm_genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_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]/_if[@name=""if is canonical name""]/then/matched_label_id/taxonlabel:[source_id/source/shortname=NCBI]/taxonomicname/_alt/1",
42 
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_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]/_if[@name=""if is canonical name""]/then/matched_label_id/taxonlabel:[source_id/source/shortname=NCBI]/taxonomicname/_alt/2",
43 
denorm_genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_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",
44 
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_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",
45 
denorm_family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_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]/_if[@name=""if is canonical name""]/then/matched_label_id/taxonlabel:[source_id/source/shortname=NCBI]/taxonomicname/_alt/1",
46 
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_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]/_if[@name=""if is canonical name""]/then/matched_label_id/taxonlabel:[source_id/source/shortname=NCBI]/taxonomicname/_alt/2",
47 
denorm_family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_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/_alt/1",
48 
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_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/_alt/2",
49 
Order,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_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/_alt/2",
50 
Class,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_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/_alt/2",
51 
denorm_kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/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/_alt/1",
52 
Kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/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/_alt/2",
44 53 
taxonLevel,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/rank,
45 54 
taxonLevel,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonepithet/_if[@name=""if taxonomic name is epithet""]/cond/_alt:[2=true]/1/_taxonomic_name_is_epithet/rank",
46 
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/1/_taxon_family_require_std/family/_nullIf/value,
47 
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/2,
48 
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1,
49 
Subspecies,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/4,
55 
denorm_family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/1/_taxon_family_require_std/family/_nullIf/value/_alt/1,
56 
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/1/_taxon_family_require_std/family/_nullIf/value/_alt/2,
57 
denorm_genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/2/_alt/1,
58 
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/2/_alt/2,
59 
denorm_species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1/_alt/1,
60 
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1/_alt/2,
61 
Subspecies,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/4/_alt/2,
50 62 
taxonLevel,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then",
51 
Variety,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/6/_join_words:[1=""var. ""]/2",
52 
Forma,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/7/_join_words:[1=""fm. ""]/2",
53 
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/family,
54 
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/genus,
55 
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/specific_epithet,
63 
Variety,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/6/_join_words:[1=""var. ""]/2/_alt/2",
64 
Forma,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/7/_join_words:[1=""fm. ""]/2/_alt/2",
65 
denorm_family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/family/_alt/1,
66 
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/family/_alt/2,
67 
denorm_genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/genus/_alt/1,
68 
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/genus/_alt/2,
69 
denorm_species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/specific_epithet/_alt/1,
70 
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/specific_epithet/_alt/2,
56 71 
taxonLevel,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/verbatimrank,
57 72 
interpretationDate,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/1/_dateRangeStart/value,
58 73 
taxonFit,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/taxonfit,
......
62 77 
authorPlantName,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/1,
63 78 
authorPlantName,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/taxonname,
64 79 
museumAccessionNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then",
65 
Division,,** No join mapping for *Division **
80 
Division,,** No join mapping for *Division/_alt/2 **
66 81 
PARTY_ID,,** No join mapping for *PARTY_ID **
67 82 
PLANTCONCEPT_ID,,** No join mapping for *PLANTCONCEPT_ID **
68 83 
PLANTNAME_ID,,** No join mapping for *PLANTNAME_ID **
69 84 
ROLE_ID,,** No join mapping for *ROLE_ID **
70 
Subclass,,** No join mapping for *Subclass **
71 
Subdivision,,** No join mapping for *Subdivision **
72 
Subkingdom,,** No join mapping for *Subkingdom **
73 
Superdivision,,** No join mapping for *Superdivision **
85 
Subclass,,** No join mapping for *Subclass/_alt/2 **
86 
Subdivision,,** No join mapping for *Subdivision/_alt/2 **
87 
Subkingdom,,** No join mapping for *Subkingdom/_alt/2 **
88 
Superdivision,,** No join mapping for *Superdivision/_alt/2 **
74 89 
TAXONINTERPRETATION_ID,,** No join mapping for *TAXONINTERPRETATION_ID **
75 90 
USDAPlantsCode,,** No join mapping for *USDAPlantsCode **
76 91 
VascularPlant,,** No join mapping for *VascularPlant **
......
90 105 
cust_cvs_corner5Presence,,** No join mapping for *cust_cvs_corner5Presence **
91 106 
dba_src_ID,,** No join mapping for *dba_src_ID **
92 107 
dba_unsure,,** No join mapping for *dba_unsure **
93 
denorm_category,,** No join mapping for *denorm_category **
94 
denorm_division,,** No join mapping for *denorm_division **
95 
denorm_family,,** No join mapping for *denorm_family **
96 
denorm_genus,,** No join mapping for *denorm_genus **
97 
denorm_hybridX,,** No join mapping for *denorm_hybridX **
98 
denorm_kingdom,,** No join mapping for *denorm_kingdom **
99 
denorm_quadAbbr,,** No join mapping for *denorm_quadAbbr **
100 
denorm_quadName,,** No join mapping for *denorm_quadName **
101 
denorm_species,,** No join mapping for *denorm_species **
102 
denorm_triAbbr,,** No join mapping for *denorm_triAbbr **
103 
denorm_triName,,** No join mapping for *denorm_triName **
108 
denorm_category,,** No join mapping for *category/_alt/1 **
109 
denorm_division,,** No join mapping for *division/_alt/1 **
110 
denorm_hybridX,,** No join mapping for *hybridX/_alt/1 **
111 
denorm_quadAbbr,,** No join mapping for *quadAbbr/_alt/1 **
112 
denorm_quadName,,** No join mapping for *quadName/_alt/1 **
113 
denorm_triAbbr,,** No join mapping for *triAbbr/_alt/1 **
114 
denorm_triName,,** No join mapping for *triName/_alt/1 **
104 115 
email,,** No join mapping for *email **
105 116 
entry_herbLineID,,** No join mapping for *entry_herbLineID **
106 117 
entry_sortOrder,,** No join mapping for *entry_sortOrder **
inputs/CVS/taxonObservation_/test.xml.ref
40 40 
                                                            <source_id><source><shortname>TNRS</shortname></source></source_id>
41 41 
                                                            <taxonomicname>
42 42 
                                                                <_join_words>
43 
                                                                    <1><_taxon_family_require_std><family>$Family</family></_taxon_family_require_std></1>
43 
                                                                    <1>
44 
                                                                        <_taxon_family_require_std>
45 
                                                                            <family>
46 
                                                                                <_alt>
47 
                                                                                    <1>$denorm_family</1>
48 
                                                                                    <2>$Family</2>
49 
                                                                                </_alt>
50 
                                                                            </family>
51 
                                                                        </_taxon_family_require_std>
52 
                                                                    </1>
44 53 
                                                                    <2>
45 54 
                                                                        <_join_words>
46 
                                                                            <2>$Genus</2>
47 
                                                                            <3>$Species</3>
55 
                                                                            <2>
56 
                                                                                <_alt>
57 
                                                                                    <1>$denorm_genus</1>
58 
                                                                                    <2>$Genus</2>
59 
                                                                                </_alt>
60 
                                                                            </2>
61 
                                                                            <3>
62 
                                                                                <_alt>
63 
                                                                                    <1>$denorm_species</1>
64 
                                                                                    <2>$Species</2>
65 
                                                                                </_alt>
66 
                                                                            </3>
48 67 
                                                                            <4>$Subspecies</4>
49 68 
                                                                            <7>
50 69 
                                                                                <_join_words>
......
87 106 
                                                                                            <parent_id>
88 107 
                                                                                                <taxonlabel>
89 108 
                                                                                                    <rank>species</rank>
90 
                                                                                                    <taxonepithet>$Species</taxonepithet>
109 
                                                                                                    <taxonepithet>
110 
                                                                                                        <_alt>
111 
                                                                                                            <1>$denorm_species</1>
112 
                                                                                                            <2>$Species</2>
113 
                                                                                                        </_alt>
114 
                                                                                                    </taxonepithet>
91 115 
                                                                                                    <parent_id>
92 116 
                                                                                                        <taxonlabel>
93 117 
                                                                                                            <rank>genus</rank>
94 
                                                                                                            <taxonepithet>$Genus</taxonepithet>
118 
                                                                                                            <taxonepithet>
119 
                                                                                                                <_alt>
120 
                                                                                                                    <1>$denorm_genus</1>
121 
                                                                                                                    <2>$Genus</2>
122 
                                                                                                                </_alt>
123 
                                                                                                            </taxonepithet>
95 124 
                                                                                                            <parent_id>
96 125 
                                                                                                                <taxonlabel>
97 126 
                                                                                                                    <rank>family</rank>
98 
                                                                                                                    <taxonepithet>$Family</taxonepithet>
127 
                                                                                                                    <taxonepithet>
128 
                                                                                                                        <_alt>
129 
                                                                                                                            <1>$denorm_family</1>
130 
                                                                                                                            <2>$Family</2>
131 
                                                                                                                        </_alt>
132 
                                                                                                                    </taxonepithet>
99 133 
                                                                                                                    <parent_id>
100 134 
                                                                                                                        <taxonlabel>
101 135 
                                                                                                                            <rank>order</rank>
......
110 144 
                                                                                                                                            <parent_id>
111 145 
                                                                                                                                                <taxonlabel>
112 146 
                                                                                                                                                    <rank>kingdom</rank>
113 
                                                                                                                                                    <taxonepithet>$Kingdom</taxonepithet>
147 
                                                                                                                                                    <taxonepithet>
148 
                                                                                                                                                        <_alt>
149 
                                                                                                                                                            <1>$denorm_kingdom</1>
150 
                                                                                                                                                            <2>$Kingdom</2>
151 
                                                                                                                                                        </_alt>
152 
                                                                                                                                                    </taxonepithet>
114 153 
                                                                                                                                                </taxonlabel>
115 154 
                                                                                                                                            </parent_id>
116 155 
                                                                                                                                        </taxonlabel>
......
138 177 
                                                    <rank>$taxonLevel</rank>
139 178 
                                                    <taxonomicname>
140 179 
                                                        <_join_words>
141 
                                                            <1><_taxon_family_require_std><family>$Family</family></_taxon_family_require_std></1>
180 
                                                            <1>
181 
                                                                <_taxon_family_require_std>
182 
                                                                    <family>
183 
                                                                        <_alt>
184 
                                                                            <1>$denorm_family</1>
185 
                                                                            <2>$Family</2>
186 
                                                                        </_alt>
187 
                                                                    </family>
188 
                                                                </_taxon_family_require_std>
189 
                                                            </1>
142 190 
                                                            <2>
143 191 
                                                                <_join_words>
144 
                                                                    <2>$Genus</2>
145 
                                                                    <3>$Species</3>
192 
                                                                    <2>
193 
                                                                        <_alt>
194 
                                                                            <1>$denorm_genus</1>
195 
                                                                            <2>$Genus</2>
196 
                                                                        </_alt>
197 
                                                                    </2>
198 
                                                                    <3>
199 
                                                                        <_alt>
200 
                                                                            <1>$denorm_species</1>
201 
                                                                            <2>$Species</2>
202 
                                                                        </_alt>
203 
                                                                    </3>
146 204 
                                                                    <4>$Subspecies</4>
147 205 
                                                                    <6>
148 206 
                                                                        <_join_words>
......
162 220 
                                                    </taxonomicname>
163 221 
                                                </taxonlabel>
164 222 
                                            </taxonlabel_id>
165 
                                            <family>$Family</family>
166 
                                            <genus>$Genus</genus>
167 
                                            <specific_epithet>$Species</specific_epithet>
223 
                                            <family>
224 
                                                <_alt>
225 
                                                    <1>$denorm_family</1>
226 
                                                    <2>$Family</2>
227 
                                                </_alt>
228 
                                            </family>
229 
                                            <genus>
230 
                                                <_alt>
231 
                                                    <1>$denorm_genus</1>
232 
                                                    <2>$Genus</2>
233 
                                                </_alt>
234 
                                            </genus>
235 
                                            <specific_epithet>
236 
                                                <_alt>
237 
                                                    <1>$denorm_species</1>
238 
                                                    <2>$Species</2>
239 
                                                </_alt>
240 
                                            </specific_epithet>
168 241 
                                            <verbatimrank>$taxonLevel</verbatimrank>
169 242 
                                        </taxonverbatim>
170 243 
                                    </taxonverbatim_id>
......
198 271 
        </path>
199 272 
    </_setDefault>
200 273 
</VegBIEN>
201 
Inserted 24 new rows into database
274 
Inserted 29 new rows into database
inputs/CVS/taxonObservation_/new_terms.csv
7 7 
museumAccessionNumber,catalogNumber,,
8 8 
givenName,recordedBy.givenName,,
9 9 
surName,recordedBy.surName,,
10 
denorm_kingdom,kingdom,/_alt/1,
11 
denorm_family,family,/_alt/1,
12 
denorm_genus,genus,/_alt/1,
13 
denorm_species,specificEpithet,/_alt/1,
10 14 
taxonLevel,taxonRank,,
inputs/CVS/taxonObservation_/unmapped_terms.csv
59 59 
*plantConcept_entry_sppID
60 60 
*USDAPlantsCode
61 61 
*VascularPlant
62 
*denorm_kingdom
63 
*denorm_division
64 
*denorm_category
65 
*denorm_family
66 
*denorm_genus
67 
*denorm_species
68 
*denorm_triAbbr
69 
*denorm_triName
70 
*denorm_quadAbbr
71 
*denorm_quadName
72 
*denorm_hybridX
62 
*division
63 
*category
64 
*triAbbr
65 
*triName
66 
*quadAbbr
67 
*quadName
68 
*hybridX
73 69 
*lowestParentName
74 70 
*lowestParentConcept_ID
75 71 
*lowestChildRank

Also available in: Unified diff