Project

General

Profile

« Previous | Next » 

Revision 11268

Added by Aaron Marcuse-Kubitza about 11 years ago

inputs/CVS/taxonObservation_/map.csv: removed unnecessary alts for terms that don't have a duplicate denorm* or hierarchical field

View differences:

inputs/CVS/taxonObservation_/map.csv
73 73 
VascularPlant,*VascularPlant,,
74 74 
denorm_kingdom,kingdom,/_alt/1,
75 75 
denorm_division,*division,/_alt/1,
76 
denorm_category,*category,/_alt/1,
76 
denorm_category,*category,,
77 77 
denorm_family,family,/_alt/1,
78 78 
denorm_genus,genus,/_alt/1,
79 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,
80 
denorm_triAbbr,*triAbbr,,
81 
denorm_triName,*triName,,
82 
denorm_quadAbbr,*quadAbbr,,
83 
denorm_quadName,*quadName,,
84 
denorm_hybridX,*hybridX,,
85 85 
taxonLevel,taxonRank,,
86 86 
taxonRank,OMIT#taxonRank,,Omitted because taxonLevel contains this information in text form
87 87 
lowestParentName,*lowestParentName,,
......
94 94 
usda_code,*usda_code,,
95 95 
usda_growthForm,*usda_growthForm,,
96 96 
Kingdom,kingdom,/_alt/2,
97 
Subkingdom,*Subkingdom,/_alt/2,
97 
Subkingdom,*Subkingdom,,
98 98 
Division,*Division,/_alt/2,
99 
Class,class,/_alt/2,
100 
Subclass,*Subclass,/_alt/2,
101 
Order,order,/_alt/2,
102 
composite family,*composite family,/_alt/2,
99 
Class,class,,
100 
Subclass,*Subclass,,
101 
Order,order,,
102 
composite family,*composite family,,
103 103 
family,family,/_alt/2,
104 
tribe,*tribe,/_alt/2,
105 
composite genus,*composite genus,/_alt/2,
104 
tribe,*tribe,,
105 
composite genus,*composite genus,,
106 106 
genus,genus,/_alt/2,
107 
subgenus,subgenus,/_alt/2,
108 
section,*section,/_alt/2,
109 
composite species,*composite species,/_alt/2,
107 
subgenus,subgenus,,
108 
section,*section,,
109 
composite species,*composite species,,
110 110 
species,specificEpithet,/_alt/2,
111 
subspecies,subspecies,/_alt/2,
112 
composite variety,*composite variety,/_alt/2,
111 
subspecies,subspecies,,
112 
composite variety,*composite variety,,
113 113 
variety,variety,,
114 114 
:plot,observationGranularity,,
inputs/CVS/taxonObservation_/VegBIEN.csv
33 33 
TAXONOBSERVATION_ID,/location/locationevent/locationevent:[@fkey=parent_id]/taxonoccurrence/sourceaccessioncode/_first/1,
34 34 
taxonLevel,"/location/locationevent/locationevent:[@fkey=parent_id]/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/rank",
35 35 
variety,"/location/locationevent/locationevent:[@fkey=parent_id]/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",
36 
subspecies,"/location/locationevent/locationevent:[@fkey=parent_id]/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",
36 
subspecies,"/location/locationevent/locationevent:[@fkey=parent_id]/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",
37 37 
denorm_species,"/location/locationevent/locationevent:[@fkey=parent_id]/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",
38 38 
species,"/location/locationevent/locationevent:[@fkey=parent_id]/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",
39 39 
denorm_genus,"/location/locationevent/locationevent:[@fkey=parent_id]/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",
40 40 
genus,"/location/locationevent/locationevent:[@fkey=parent_id]/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",
41 41 
denorm_family,"/location/locationevent/locationevent:[@fkey=parent_id]/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",
42 42 
family,"/location/locationevent/locationevent:[@fkey=parent_id]/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",
43 
Order,"/location/locationevent/locationevent:[@fkey=parent_id]/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",
44 
Class,"/location/locationevent/locationevent:[@fkey=parent_id]/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",
43 
Order,"/location/locationevent/locationevent:[@fkey=parent_id]/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",
44 
Class,"/location/locationevent/locationevent:[@fkey=parent_id]/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",
45 45 
denorm_kingdom,"/location/locationevent/locationevent:[@fkey=parent_id]/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",
46 46 
Kingdom,"/location/locationevent/locationevent:[@fkey=parent_id]/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",
47 47 
taxonLevel,/location/locationevent/locationevent:[@fkey=parent_id]/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/rank,
......
54 54 
genus,/location/locationevent/locationevent:[@fkey=parent_id]/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/2/_filter_genus/value/_alt/2,
55 55 
denorm_species,/location/locationevent/locationevent:[@fkey=parent_id]/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1/_alt/1,
56 56 
species,/location/locationevent/locationevent:[@fkey=parent_id]/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1/_alt/2,
57 
subspecies,/location/locationevent/locationevent:[@fkey=parent_id]/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/4/_alt/2,
57 
subspecies,/location/locationevent/locationevent:[@fkey=parent_id]/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/4,
58 58 
taxonLevel,"/location/locationevent/locationevent:[@fkey=parent_id]/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""]/then",
59 59 
variety,"/location/locationevent/locationevent:[@fkey=parent_id]/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/6/_join_words:[1=""var. ""]/2",
60 60 
denorm_family,/location/locationevent/locationevent:[@fkey=parent_id]/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/family/_alt/1,
......
78 78 
PLANTCONCEPT_ID,,** No join mapping for *PLANTCONCEPT_ID **
79 79 
PLANTNAME_ID,,** No join mapping for *PLANTNAME_ID **
80 80 
ROLE_ID,,** No join mapping for *ROLE_ID **
81 
Subclass,,** No join mapping for *Subclass/_alt/2 **
82 
Subkingdom,,** No join mapping for *Subkingdom/_alt/2 **
81 
Subclass,,** No join mapping for *Subclass **
82 
Subkingdom,,** No join mapping for *Subkingdom **
83 83 
TAXONINTERPRETATION_ID,,** No join mapping for *TAXONINTERPRETATION_ID **
84 84 
USDAPlantsCode,,** No join mapping for *USDAPlantsCode **
85 85 
VascularPlant,,** No join mapping for *VascularPlant **
86 86 
accessionCode,,** No join mapping for *accessionCode **
87 87 
collector_ID,,** No join mapping for *collector_ID **
88 88 
commonName,,** No join mapping for vernacularName **
89 
composite family,,** No join mapping for *composite family/_alt/2 **
90 
composite genus,,** No join mapping for *composite genus/_alt/2 **
91 
composite species,,** No join mapping for *composite species/_alt/2 **
92 
composite variety,,** No join mapping for *composite variety/_alt/2 **
89 
composite family,,** No join mapping for *composite family **
90 
composite genus,,** No join mapping for *composite genus **
91 
composite species,,** No join mapping for *composite species **
92 
composite variety,,** No join mapping for *composite variety **
93 93 
contactInstructions,,** No join mapping for *contactInstructions **
94 94 
currentInterpretation,,** No join mapping for *currentInterpretation **
95 95 
currentName_ID,,** No join mapping for *currentName_ID **
......
102 102 
cust_cvs_corner5Presence,,** No join mapping for *cust_cvs_corner5Presence **
103 103 
dba_src_ID,,** No join mapping for *dba_src_ID **
104 104 
dba_unsure,,** No join mapping for *dba_unsure **
105 
denorm_category,,** No join mapping for *category/_alt/1 **
105 
denorm_category,,** No join mapping for *category **
106 106 
denorm_division,,** No join mapping for *division/_alt/1 **
107 
denorm_hybridX,,** No join mapping for *hybridX/_alt/1 **
108 
denorm_quadAbbr,,** No join mapping for *quadAbbr/_alt/1 **
109 
denorm_quadName,,** No join mapping for *quadName/_alt/1 **
110 
denorm_triAbbr,,** No join mapping for *triAbbr/_alt/1 **
111 
denorm_triName,,** No join mapping for *triName/_alt/1 **
107 
denorm_hybridX,,** No join mapping for *hybridX **
108 
denorm_quadAbbr,,** No join mapping for *quadAbbr **
109 
denorm_quadName,,** No join mapping for *quadName **
110 
denorm_triAbbr,,** No join mapping for *triAbbr **
111 
denorm_triName,,** No join mapping for *triName **
112 112 
email,,** No join mapping for *email **
113 113 
entry_herbLineID,,** No join mapping for *entry_herbLineID **
114 114 
entry_sortOrder,,** No join mapping for *entry_sortOrder **
......
137 137 
reference_ID,,** No join mapping for *reference_ID **
138 138 
revisions,,** No join mapping for *revisions **
139 139 
salutation,,** No join mapping for *salutation **
140 
section,,** No join mapping for *section/_alt/2 **
141 
subgenus,,** No join mapping for subgenus/_alt/2 **
140 
section,,** No join mapping for *section **
141 
subgenus,,** No join mapping for subgenus **
142 142 
suffix,,** No join mapping for *suffix **
143 143 
taxonConfidence,,** No join mapping for identificationVerificationStatus **
144 144 
taxonInferenceArea,,** No join mapping for *taxonInferenceArea **
......
153 153 
taxonObservation_reference_ID,,** No join mapping for *taxonObservation_reference_ID **
154 154 
taxonRank,,** No non-empty join mapping for OMIT#taxonRank ** Omitted because taxonLevel contains this information in text form
155 155 
temp_taxonUpToDate,,** No join mapping for *temp_taxonUpToDate **
156 
tribe,,** No join mapping for *tribe/_alt/2 **
156 
tribe,,** No join mapping for *tribe **
157 157 
usda_code,,** No join mapping for *usda_code **
158 158 
usda_growthForm,,** No join mapping for *usda_growthForm **
159 159 
woody,,** No join mapping for *woody **
inputs/CVS/taxonObservation_/new_terms.csv
8 8 
plantNameWithAuthority,scientificName,,
9 9 
denorm_kingdom,kingdom,/_alt/1,
10 10 
denorm_division,*division,/_alt/1,
11 
denorm_category,*category,/_alt/1,
11 
denorm_category,*category,,
12 12 
denorm_family,family,/_alt/1,
13 13 
denorm_genus,genus,/_alt/1,
14 14 
denorm_species,specificEpithet,/_alt/1,
15 
denorm_triAbbr,*triAbbr,/_alt/1,
16 
denorm_triName,*triName,/_alt/1,
17 
denorm_quadAbbr,*quadAbbr,/_alt/1,
18 
denorm_quadName,*quadName,/_alt/1,
19 
denorm_hybridX,*hybridX,/_alt/1,
15 
denorm_triAbbr,*triAbbr,,
16 
denorm_triName,*triName,,
17 
denorm_quadAbbr,*quadAbbr,,
18 
denorm_quadName,*quadName,,
19 
denorm_hybridX,*hybridX,,
20 20 
taxonLevel,taxonRank,,

Also available in: Unified diff