Project

General

Profile

« Previous | Next » 

Revision 4161

Added by Aaron Marcuse-Kubitza about 12 years ago

inputs/SpeciesLink/src/specimens/map.csv: Added explicit _alt suffix when multiple terms map to the same place

View differences:

inputs/SpeciesLink/src/specimens/map.csv
1 1 
"SpeciesLink[Veg+,dwc_dwcore_,dwc_curatorial_,dwc_geospatial_,http__purl_org_,dwc_terms_,conceptual_darwin_2003_1_0_]",Veg+,Comments
2 
AuthorYearOfScientificName,ScientificNameAuthor,
3 
ScientificNameAuthor,ScientificNameAuthor,`union` would otherwise remove this input name because it's been mapped to (renamed) above
4 
DayOfYear,JulianDay,
5 
JulianDay,JulianDay,`union` would otherwise remove this input name because it's been mapped to (renamed) above
2 
AuthorYearOfScientificName,ScientificNameAuthor/_alt/2,
3 
ScientificNameAuthor,ScientificNameAuthor/_alt/1,
4 
DayOfYear,JulianDay/_alt/2,
5 
JulianDay,JulianDay/_alt/1,
6 6 
FieldNumber,recordNumber/_alt/2,"Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
7 7 
-----
8 8 
SELECT count(*) FROM ""SpeciesLink"".specimens
9 9 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
10 10 
-----"
11 
recordNumber,recordNumber/_alt/1,`union` would otherwise remove this input name because it's been mapped to (renamed) above
11 
recordNumber,recordNumber/_alt/1,
12 12 
fieldNumber,recordNumber/_alt/2,"Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
13 13 
-----
14 14 
SELECT count(*) FROM ""SpeciesLink"".specimens
inputs/SpeciesLink/src/specimens/map.full.csv
23 23 
IndividualCount,IndividualCount
24 24 
InfraspecificEpithet,InfraspecificEpithet
25 25 
InstitutionCode,InstitutionCode
26 
DayOfYear,JulianDay,
27 
JulianDay,JulianDay,`union` would otherwise remove this input name because it's been mapped to (renamed) above
26 
JulianDay,JulianDay/_alt/1,
27 
DayOfYear,JulianDay/_alt/2,
28 28 
Kingdom,Kingdom
29 29 
Latitude,Latitude
30 30 
Locality,Locality
......
48 48 
RelationshipType,RelationshipType
49 49 
Remarks,Remarks
50 50 
ScientificName,ScientificName
51 
AuthorYearOfScientificName,ScientificNameAuthor,
52 
ScientificNameAuthor,ScientificNameAuthor,`union` would otherwise remove this input name because it's been mapped to (renamed) above
51 
ScientificNameAuthor,ScientificNameAuthor/_alt/1,
52 
AuthorYearOfScientificName,ScientificNameAuthor/_alt/2,
53 53 
Sex,Sex
54 54 
Species,Species
55 55 
SpecificEpithet,SpecificEpithet
......
95 95 
otherCatalogNumbers,otherCatalogNumbers
96 96 
phylum,phylum
97 97 
preparations,preparations
98 
recordNumber,recordNumber/_alt/1,`union` would otherwise remove this input name because it's been mapped to (renamed) above
98 
recordNumber,recordNumber/_alt/1,
99 99 
FieldNumber,recordNumber/_alt/2,"Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
100 100 
-----
101 101 
SELECT count(*) FROM ""SpeciesLink"".specimens
inputs/SpeciesLink/src/specimens/VegBIEN.csv
57 57 
individualCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/count,
58 58 
Notes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,
59 59 
CollectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber/_alt/1,
60 
recordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber/_alt/2/_alt/1,`union` would otherwise remove this input name because it's been mapped to (renamed) above
60 
recordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber/_alt/2/_alt/1,
61 61 
FieldNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber/_alt/2/_alt/2,"Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
62 62 
-----
63 63 
SELECT count(*) FROM ""SpeciesLink"".specimens
......
79 79 
institutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,
80 80 
GlobalUniqueIdentifier,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
81 81 
CollectorNumber,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/1,
82 
recordNumber,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/2/_alt/1,`union` would otherwise remove this input name because it's been mapped to (renamed) above
82 
recordNumber,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/2/_alt/1,
83 83 
FieldNumber,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/2/_alt/2,"Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
84 84 
-----
85 85 
SELECT count(*) FROM ""SpeciesLink"".specimens
......
101 101 
ScientificName,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[],do=""plantname[rank=_val]/parent_id""]/plantname[rank=binomial]/plantname",
102 102 
scientificName,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[],do=""plantname[rank=_val]/parent_id""]/plantname[rank=binomial]/plantname",
103 103 
scientificNameAuthorship,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/plantname/_alt/1",
104 
AuthorYearOfScientificName,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/plantname/_alt/2",
105 
ScientificNameAuthor,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/plantname/_alt/2",`union` would otherwise remove this input name because it's been mapped to (renamed) above
104 
ScientificNameAuthor,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/plantname/_alt/2/_alt/1",
105 
AuthorYearOfScientificName,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/plantname/_alt/2/_alt/2",
106 106 
InfraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname",
107 107 
Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname",
108 108 
infraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname",
......
140 140 
locality,/location/locationnarrative/_merge/1,
141 141 
BasisOfRecord,,** No non-empty join mapping for BasisOfRecord **
142 142 
DateLastModified,,** No non-empty join mapping for DateLastModified **
143 
DayOfYear,,** No non-empty join mapping for JulianDay **
144 
JulianDay,,** No non-empty join mapping for JulianDay ** `union` would otherwise remove this input name because it's been mapped to (renamed) above
143 
DayOfYear,,** No non-empty join mapping for JulianDay/_alt/2 **
144 
JulianDay,,** No non-empty join mapping for JulianDay/_alt/1 **
145 145 
PreparationType,,** No non-empty join mapping for PreparationType **
146 146 
PreviousCatalogNumber,,** No non-empty join mapping for PreviousCatalogNumber **
147 147 
RelatedCatalogItem,,** No non-empty join mapping for RelatedCatalogItem **
inputs/SpeciesLink/src/specimens/test.xml.ref
549 549 
                                                            <1>$dwc_terms_scientificNameAuthorship</1>
550 550 
                                                            <2>
551 551 
                                                                <_alt>
552 
                                                                    <0>$dwc_dwcore_AuthorYearOfScientificName</0>
553 552 
                                                                    <1>$conceptual_darwin_2003_1_0_ScientificNameAuthor</1>
553 
                                                                    <2>$dwc_dwcore_AuthorYearOfScientificName</2>
554 554 
                                                                </_alt>
555 555 
                                                            </2>
556 556 
                                                        </_alt>

Also available in: Unified diff