Project

General

Profile

« Previous | Next » 

Revision 1051

Added by Aaron Marcuse-Kubitza almost 13 years ago

DwC mappings: Mapped specimen description via fieldNotes instead of custom bien.specimenDescription field

View differences:

inputs/NYBG/test/DwC.specimens.xml.ref
28 28 
        <minimumElevationInMeters>350</minimumElevationInMeters>
29 29 
        <maximumElevationInMeters>350</maximumElevationInMeters>
30 30 
        <habitat>Floodplain forest</habitat>
31 
        <bien.specimenDescription>plant fungus: with rough brown bark, almost no buttressing, 1 m diam; fallen fruit and leaves</bien.specimenDescription>
31 
        <fieldNotes>plant fungus: with rough brown bark, almost no buttressing, 1 m diam; fallen fruit and leaves</fieldNotes>
32 32 
        <occurrenceID>816590</occurrenceID>
33 33 
    </list>
34 34 
    <list id="1">
inputs/NYBG/maps/DwC.specimens.csv
49 49 
"PreviousCatalogNumber","previousIdentifications","?"
50 50 
"RelationshipType","relationshipOfResource",
51 51 
"RelatedCatalogItem","relatedResourceID",
52 
"Notes","bien.specimenDescription/_merge/1",
52 
"Notes","fieldNotes/_merge/1",
53 53 
"Habitat","habitat/_merge/1",
54 
"PlantFungusDescription","bien.specimenDescription/_merge/2/_label[label=""plant fungus""]/value",
54 
"PlantFungusDescription","fieldNotes/_merge/2/_label[label=""plant fungus""]/value",
55 55 
"Substrate","bien.substrate",
56 56 
"Vegetation","habitat/_merge/2",
57 57 
"UniqueNYInternalRecordNumber","occurrenceID",
inputs/NYBG-CSV/test/DwC.specimens.xml.ref
28 28 
        <minimumElevationInMeters>350</minimumElevationInMeters>
29 29 
        <maximumElevationInMeters>350</maximumElevationInMeters>
30 30 
        <habitat>Floodplain forest</habitat>
31 
        <bien.specimenDescription>plant fungus: with rough brown bark, almost no buttressing, 1 m diam; fallen fruit and leaves</bien.specimenDescription>
31 
        <fieldNotes>plant fungus: with rough brown bark, almost no buttressing, 1 m diam; fallen fruit and leaves</fieldNotes>
32 32 
        <occurrenceID>816590</occurrenceID>
33 33 
    </list>
34 34 
    <list id="1">
inputs/NYBG-CSV/maps/DwC.specimens.csv
47 47 
"PreviousCatalogNumber","previousIdentifications","?"
48 48 
"RelationshipType","relationshipOfResource",
49 49 
"RelatedCatalogItem","relatedResourceID",
50 
"Notes","bien.specimenDescription/_merge/1",
50 
"Notes","fieldNotes/_merge/1",
51 51 
"Habitat","habitat/_merge/1",
52 
"PlantFungusDescription","bien.specimenDescription/_merge/2/_label[label=""plant fungus""]/value",
52 
"PlantFungusDescription","fieldNotes/_merge/2/_label[label=""plant fungus""]/value",
53 53 
"Substrate","bien.substrate",
54 54 
"Vegetation","habitat/_merge/2",
55 55 
"UniqueNYInternalRecordNumber","occurrenceID",
mappings/for_review/DwC-VegBIEN.specimens.csv
43 43 
phylum,"//taxonoccurrence/taxondetermination[rolecode=identifier,plantlevel=Subkingdom]/*_id/plantconcept/*_id/*/plantname",,143
44 44 
infraspecificEpithet,"//taxonoccurrence/taxondetermination[rolecode=identifier,plantlevel=Subspecies]/*_id/plantconcept/*_id/*/plantname",,150
45 45 
recordedBy,//taxonoccurrence/verbatimcollectorname,,23
46 
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
47 46 
catalogNumber,/catalognumber_dwc,"Brad: Not sure if mapping correct. Nick, is there an element for institutional accession codes in VegX?; Aaron: This can't be used as the accession code (primary key) because some rows don't have a value for it",20
48 47 
recordNumber,/collectionnumber/_alt/1,,22
49 48 
collectionID,/collectionnumber/_alt/2,,9
50 49 
fieldNumber,/collectionnumber/_alt/3,"Brad: Correct for VB, not sure about VX; Nick, is there an element in VX fo Collection Number?",53
51 
bien.specimenDescription,/description,,
52 
bien.specimenDescription/_merge/1,/description/_merge/1,,
53 
"bien.specimenDescription/_merge/2/_label[label=""plant fungus""]/value","/description/_merge/2/_label[label=""plant fungus""]/value",,
50 
fieldNotes,/description,,
51 
fieldNotes/_merge/1,/description/_merge/1,,
52 
"fieldNotes/_merge/2/_label[label=""plant fungus""]/value","/description/_merge/2/_label[label=""plant fungus""]/value",,
54 53 
occurrenceID,/sourceaccessioncode,"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
55 54 
institutionCode,/{museum_id/party/organizationname/_name/first},,11
56 55 
collectionCode,"/{museum_id/party/organizationname/_name/last,collectioncode_dwc}",Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name,12
mappings/DwC-VegBIEN.specimens.csv
43 43 
phylum,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Subkingdom]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,143
44 44 
infraspecificEpithet,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Subspecies]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,150
45 45 
recordedBy,/*_id/taxonoccurrence/verbatimcollectorname,,23
46 
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
47 46 
catalogNumber,:[*_id/reference]/catalognumber_dwc,"Brad: Not sure if mapping correct. Nick, is there an element for institutional accession codes in VegX?; Aaron: This can't be used as the accession code (primary key) because some rows don't have a value for it",20
48 47 
recordNumber,:[*_id/reference]/collectionnumber/_alt/1,,22
49 48 
collectionID,:[*_id/reference]/collectionnumber/_alt/2,,9
50 49 
fieldNumber,:[*_id/reference]/collectionnumber/_alt/3,"Brad: Correct for VB, not sure about VX; Nick, is there an element in VX fo Collection Number?",53
51 
bien.specimenDescription,:[*_id/reference]/description,,
52 
bien.specimenDescription/_merge/1,:[*_id/reference]/description/_merge/1,,
53 
"bien.specimenDescription/_merge/2/_label[label=""plant fungus""]/value",":[*_id/reference]/description/_merge/2/_label[label=""plant fungus""]/value",,
50 
fieldNotes,:[*_id/reference]/description,,
51 
fieldNotes/_merge/1,:[*_id/reference]/description/_merge/1,,
52 
"fieldNotes/_merge/2/_label[label=""plant fungus""]/value",":[*_id/reference]/description/_merge/2/_label[label=""plant fungus""]/value",,
54 53 
occurrenceID,:[*_id/reference]/sourceaccessioncode,"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
55 54 
institutionCode,:[*_id/reference]/{museum_id/party/organizationname/_name/first},,11
56 55 
collectionCode,":[*_id/reference]/{museum_id/party/organizationname/_name/last,collectioncode_dwc}",Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name,12

Also available in: Unified diff