Project

General

Profile

« Previous | Next » 

Revision 914

Added by Aaron Marcuse-Kubitza over 12 years ago

DwC mappings: Mapped infraspecificEpithet to/from Subspecies

View differences:

inputs/NYBG/maps/DwC.specimens.csv
13 13 
"Family","family",
14 14 
"Genus","genus",
15 15 
"Species","specificEpithet",
16 
"Subspecies",,
16 
"Subspecies","infraspecificEpithet",
17 17 
"ScientificNameAuthor","scientificNameAuthorship",
18 18 
"IdentifiedBy","identifiedBy",
19 19 
"YearIdentified","dateIdentified/_alt/2/_date/year",
inputs/NYBG/maps/VegBIEN.specimens.csv
30 30 
Order,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Order]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,145
31 31 
Species,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Species]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,149
32 32 
Phylum,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Subkingdom]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,143
33 
Subspecies,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Subspecies]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,150
33 34 
Notes,"/definedvalue[*_id/userdefined[tablename=specimenreplicate,userdefinedname=notes]]:[@fkey=tableRecord_ID]/definedvalue","Brad: mapping OK; NY appears to be using this field for almost anything, but mostly internal collections notes",54
34 35 
UniqueNYInternalRecordNumber,"/{:[*_id/reference]/sourceaccessioncode,*_id/taxonoccurrence/aggregateoccurrence/*_id/plantobservation/authorplantcode}","Brad: OMIT; Aaron: We need this field because it is the only ID column with an entry in every row; Brad: OK, use this as primary key",19
35 36 
FieldNumber,:[*_id/reference]/catalognumber_dwc,"Brad: Correct for VB, not sure about VX; Nick, is there an element in VX fo Collection Number?",53
......
49 50 
PreviousCatalogNumber,,?; Brad: OMIT,35
50 51 
RelatedCatalogItem,,Brad: OMIT,161
51 52 
RelationshipType,,Brad: OMIT,162
52 
Subspecies,,
53 53 
Substrate,,
54 54 
TimeOfDay,,Brad: OMIT,45
55 55 
TypeStatus,,Brad: OMIT (?). Indicates whether this specimen served as type for taxon name. Probably not relevant for BIEN,125
mappings/for_review/DwC-VegBIEN.specimens.csv
36 36 
order,"//taxonoccurrence/taxondetermination[rolecode=identifier,plantlevel=Order]/*_id/plantconcept/*_id/*/plantname",,145
37 37 
specificEpithet,"//taxonoccurrence/taxondetermination[rolecode=identifier,plantlevel=Species]/*_id/plantconcept/*_id/*/plantname",,149
38 38 
phylum,"//taxonoccurrence/taxondetermination[rolecode=identifier,plantlevel=Subkingdom]/*_id/plantconcept/*_id/*/plantname",,143
39 
infraspecificEpithet,"//taxonoccurrence/taxondetermination[rolecode=identifier,plantlevel=Subspecies]/*_id/plantconcept/*_id/*/plantname",,150
39 40 
fieldNotes,"/definedvalue[*_id/userdefined[tablename=specimenreplicate,userdefinedname=notes]]/definedvalue","Brad: mapping OK; NY appears to be using this field for almost anything, but mostly internal collections notes",54
40 41 
occurrenceID,"/{/sourceaccessioncode,*_id/taxonoccurrence/aggregateoccurrence/*_id/plantobservation/authorplantcode}","Brad: OMIT; Aaron: We need this field because it is the only ID column with an entry in every row; Brad: OK, use this as primary key",19
41 42 
fieldNumber,/catalognumber_dwc,"Brad: Correct for VB, not sure about VX; Nick, is there an element in VX fo Collection Number?",53
......
105 106 
identificationVerificationStatus,,,122
106 107 
individualCount,,Brad: OMIT; not relevant for DwC plant specimen data.,25
107 108 
informationWithheld,,,16
108 
infraspecificEpithet,,,150
109 109 
institutionID,,,8
110 110 
island,,,62
111 111 
islandGroup,,,61
mappings/DwC-VegBIEN.specimens.csv
36 36 
order,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Order]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,145
37 37 
specificEpithet,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Species]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,149
38 38 
phylum,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Subkingdom]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,143
39 
infraspecificEpithet,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Subspecies]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,150
39 40 
fieldNotes,"/definedvalue[*_id/userdefined[tablename=specimenreplicate,userdefinedname=notes]]:[@fkey=tableRecord_ID]/definedvalue","Brad: mapping OK; NY appears to be using this field for almost anything, but mostly internal collections notes",54
40 41 
occurrenceID,"/{:[*_id/reference]/sourceaccessioncode,*_id/taxonoccurrence/aggregateoccurrence/*_id/plantobservation/authorplantcode}","Brad: OMIT; Aaron: We need this field because it is the only ID column with an entry in every row; Brad: OK, use this as primary key",19
41 42 
fieldNumber,:[*_id/reference]/catalognumber_dwc,"Brad: Correct for VB, not sure about VX; Nick, is there an element in VX fo Collection Number?",53
......
105 106 
identificationVerificationStatus,,,122
106 107 
individualCount,,Brad: OMIT; not relevant for DwC plant specimen data.,25
107 108 
informationWithheld,,,16
108 
infraspecificEpithet,,,150
109 109 
institutionID,,,8
110 110 
island,,,62
111 111 
islandGroup,,,61

Also available in: Unified diff