Revision 746
Added by Aaron Marcuse-Kubitza almost 13 years ago
mappings/DwC-VegBIEN.organisms.csv | ||
---|---|---|
25 | 25 |
order,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Order]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,145 |
26 | 26 |
specificEpithet,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Species]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,149 |
27 | 27 |
phylum,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Subkingdom]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,143 |
28 |
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 |
|
28 | 29 |
fieldNumber,:[*_id/reference]/catalognumber_dwc,"Brad: Correct for VB, not sure about VX; Nick, is there an element in VX fo Collection Number?",53 |
29 | 30 |
individualID,:[*_id/reference]/collectornumber_dwc,"Brad: OMIT; db-specific element, not relevant to VB/VX",24 |
30 | 31 |
georeferencedBy,:[*_id/reference]/verbatimcollectorname,Brad: Correct for VB. Nick: is there a way to specifically identify this party as collector of a specimen?,94 |
31 | 32 |
institutionCode,:[*_id/reference]/{museum_id/party/organizationname/_name/first},,11 |
32 | 33 |
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 |
33 |
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 |
|
34 | 34 |
acceptedNameUsage,,,135 |
35 | 35 |
acceptedNameUsageID,,,128 |
36 | 36 |
associatedMedia,,,36 |
mappings/for_review/DwC-VegBIEN.organisms.csv | ||
---|---|---|
25 | 25 |
order,"//taxonoccurrence/taxondetermination[rolecode=identifier,plantlevel=Order]/*_id/plantconcept/*_id/*/plantname",,145 |
26 | 26 |
specificEpithet,"//taxonoccurrence/taxondetermination[rolecode=identifier,plantlevel=Species]/*_id/plantconcept/*_id/*/plantname",,149 |
27 | 27 |
phylum,"//taxonoccurrence/taxondetermination[rolecode=identifier,plantlevel=Subkingdom]/*_id/plantconcept/*_id/*/plantname",,143 |
28 |
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 |
|
28 | 29 |
fieldNumber,/catalognumber_dwc,"Brad: Correct for VB, not sure about VX; Nick, is there an element in VX fo Collection Number?",53 |
29 | 30 |
individualID,/collectornumber_dwc,"Brad: OMIT; db-specific element, not relevant to VB/VX",24 |
30 | 31 |
georeferencedBy,/verbatimcollectorname,Brad: Correct for VB. Nick: is there a way to specifically identify this party as collector of a specimen?,94 |
31 | 32 |
institutionCode,/{museum_id/party/organizationname/_name/first},,11 |
32 | 33 |
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 |
33 |
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 |
|
34 | 34 |
acceptedNameUsage,,,135 |
35 | 35 |
acceptedNameUsageID,,,128 |
36 | 36 |
associatedMedia,,,36 |
Also available in: Unified diff
mappings/DwC-VegBIEN.organisms.csv: Fixed syntax error in a mapping