Project

General

Profile

« Previous | Next » 

Revision 4750

Added by Aaron Marcuse-Kubitza about 12 years ago

inputs/*/*/map.csv: Mapped variants of subspecies directly to new subspecies term

View differences:

inputs/XAL/Specimen/map.csv
12 12 
darwin:Family,family,,
13 13 
darwin:Genus,genus,,
14 14 
darwin:Species,specificEpithet,,
15 
darwin:Subspecies,infraspecificEpithet,,
15 
darwin:Subspecies,subspecies,,
16 16 
darwin:ScientificNameAuthor,scientificNameAuthorship,,
17 17 
darwin:IdentifiedBy,identifiedBy,,
18 18 
darwin:YearIdentified,yearIdentified,,
inputs/XAL/Specimen/VegBIEN.csv
36 36 
darwin:ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/scientificname,
37 37 
darwin:ScientificNameAuthor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/scientificnameauthor,
38 38 
darwin:Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/species,
39 
darwin:Subspecies,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/subspecies/_alt/2/_name/last,
39 
darwin:Subspecies,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/subspecies/_alt/1,
40 40 
darwin:DayIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value",
41 41 
darwin:MonthIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value",
42 42 
darwin:YearIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value",
inputs/NY/Specimen/map.csv
13 13 
Family,family,,
14 14 
Genus,genus,,
15 15 
Species,specificEpithet,,
16 
Subspecies,infraspecificEpithet,,
16 
Subspecies,subspecies,,
17 17 
ScientificNameAuthor,scientificNameAuthorship,,
18 18 
IdentifiedBy,identifiedBy,,
19 19 
YearIdentified,yearIdentified,,
inputs/NY/Specimen/VegBIEN.csv
38 38 
ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/scientificname,
39 39 
ScientificNameAuthor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/scientificnameauthor,
40 40 
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/species,
41 
Subspecies,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/subspecies/_alt/2/_name/last,
41 
Subspecies,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/subspecies/_alt/1,
42 42 
DayIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value",
43 43 
MonthIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value",
44 44 
YearIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value",
inputs/CTFS/StemObservation/map.csv
20 20 
y,organismY,,
21 21 
SubSpeciesCurrentTaxonFlag,SubSpeciesCurrentTaxonFlag,,
22 22 
SubSpeciesObsoleteTaxonFlag,SubSpeciesObsoleteTaxonFlag,,
23 
SubSpeciesName,infraspecificEpithet,,
23 
SubSpeciesName,subspecies,,
24 24 
SubSpeciesMnemonic,SubSpeciesMnemonic,,
25 25 
SubSpeciesAuthority,SubSpeciesAuthority,,
26 26 
InfraSpecificLevel,InfraSpecificLevel,,
inputs/CTFS/StemObservation/VegBIEN.csv
21 21 
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/genus,
22 22 
SpeciesAuthority,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/scientificnameauthor,
23 23 
SpeciesName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/species,
24 
SubSpeciesName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/subspecies/_alt/2/_name/last,
24 
SubSpeciesName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/subspecies/_alt/1,
25 25 
Description,,** No join mapping for Description **
26 26 
ExactDate,,** No join mapping for ExactDate **
27 27 
FamilyID,,** No join mapping for FamilyID **
inputs/CTFS/TaxonOccurrence/map.csv
8 8 
PlotID,locationID,,
9 9 
SubSpeciesCurrentTaxonFlag,SubSpeciesCurrentTaxonFlag,,
10 10 
SubSpeciesObsoleteTaxonFlag,SubSpeciesObsoleteTaxonFlag,,
11 
SubSpeciesName,infraspecificEpithet,,
11 
SubSpeciesName,subspecies,,
12 12 
SubSpeciesMnemonic,SubSpeciesMnemonic,,
13 13 
SubSpeciesAuthority,SubSpeciesAuthority,,
14 14 
InfraSpecificLevel,InfraSpecificLevel,,"Not used, as the following query returns zero:
inputs/CTFS/TaxonOccurrence/VegBIEN.csv
10 10 
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/family,
11 11 
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/genus,
12 12 
SpeciesName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/species,
13 
SubSpeciesName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/subspecies/_alt/2/_name/last,
13 
SubSpeciesName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/subspecies/_alt/1,
14 14 
Description,,** No join mapping for Description **
15 15 
FamilyID,,** No join mapping for FamilyID **
16 16 
FieldFamily,,** No join mapping for FieldFamily **
inputs/ARIZ/Specimen/map.csv
50 50 
Family,family,,
51 51 
Genus,genus,,
52 52 
Species,specificEpithet,,
53 
Subspecies,infraspecificEpithet,,
53 
Subspecies,subspecies,,
54 54 
ScientificNameAuthor,scientificName,/_alt/1,Contains the binomial in addition to the authority
55 55 
IdentifiedBy,identifiedBy,,
56 56 
IdentificationModifier,identificationQualifier,,
inputs/ARIZ/Specimen/VegBIEN.csv
44 44 
ScientificNameAuthor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/scientificname/_alt/1,Contains the binomial in addition to the authority
45 45 
ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/scientificname/_alt/2,
46 46 
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/species,
47 
Subspecies,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/subspecies/_alt/2/_name/last,
47 
Subspecies,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/subspecies/_alt/1,
48 48 
DayIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value",
49 49 
MonthIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value",
50 50 
YearIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value",
inputs/SpeciesLink/Specimen/map.csv
105 105 
conceptual_darwin_2003_1_0_Family,family,,
106 106 
conceptual_darwin_2003_1_0_Genus,genus,,
107 107 
conceptual_darwin_2003_1_0_Species,specificEpithet,,
108 
conceptual_darwin_2003_1_0_Subspecies,infraspecificEpithet,,
108 
conceptual_darwin_2003_1_0_Subspecies,subspecies,,
109 109 
conceptual_darwin_2003_1_0_ScientificNameAuthor,scientificNameAuthorship,/_alt/2,
110 110 
conceptual_darwin_2003_1_0_IdentifiedBy,identifiedBy,,
111 111 
conceptual_darwin_2003_1_0_YearIdentified,yearIdentified,,
inputs/SpeciesLink/Specimen/VegBIEN.csv
134 134 
conceptual_darwin_2003_1_0_Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/species,
135 135 
dwc_dwcore_SpecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/species,
136 136 
dwc_terms_specificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/species,
137 
conceptual_darwin_2003_1_0_Subspecies,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/subspecies/_alt/2/_name/last,
137 
conceptual_darwin_2003_1_0_Subspecies,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/subspecies/_alt/1,
138 138 
dwc_dwcore_InfraspecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/subspecies/_alt/2/_name/last,
139 139 
dwc_terms_infraspecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/subspecies/_alt/2/_name/last,
140 140 
dwc_terms_dateIdentified,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/1/_*/date/_dateRangeStart/value,
inputs/SpeciesLink/Specimen/test.xml.ref
461 461 
                                    </species>
462 462 
                                    <subspecies>
463 463 
                                        <_alt>
464 
                                            <0>$conceptual_darwin_2003_1_0_Subspecies</0>
465 
                                            <1>$dwc_dwcore_InfraspecificEpithet</1>
466 
                                            <2>$dwc_terms_infraspecificEpithet</2>
464 
                                            <1>$conceptual_darwin_2003_1_0_Subspecies</1>
465 
                                            <2>
466 
                                                <_alt>
467 
                                                    <0>$dwc_dwcore_InfraspecificEpithet</0>
468 
                                                    <1>$dwc_terms_infraspecificEpithet</1>
469 
                                                </_alt>
470 
                                            </2>
467 471 
                                        </_alt>
468 472 
                                    </subspecies>
469 473 
                                </taxonpath>
inputs/MO/Specimen/map.csv
9 9 
family,family,,
10 10 
genus,genus,,
11 11 
species,specificEpithet,,
12 
Subspecies,infraspecificEpithet,,
12 
Subspecies,subspecies,,
13 13 
ScientificNameAuthor,scientificNameAuthorship,,
14 14 
IdentifiedBy,identifiedBy,,
15 15 
TypeStatus,TypeStatus,,
inputs/VegBank/taxonobservation_/map.csv
60 60 
Family,family,,
61 61 
Genus,genus,,
62 62 
Species,specificEpithet,,
63 
Subspecies,infraspecificEpithet,,
63 
Subspecies,subspecies,,
64 64 
Variety,variety,,
65 65 
Forma,forma,,
66 66 
row_num,row_num,,

Also available in: Unified diff