Project

General

Profile

« Previous | Next » 

Revision 79

Added by Aaron Marcuse-Kubitza over 13 years ago

NYBG-VegX.organisms.csv: Changed voucher (primary key) column to be UniqueNYInternalRecordNumber because CatalogNumber contained an empty value

View differences:

mappings/NYBG-VegX.organisms.csv
3 3 
"DateLastModified",
4 4 
"InstitutionCode","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/partyWithRole/*ID->/parties/party/organizationName/_name/firstName"
5 5 
"CollectionCode","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/partyWithRole/*ID->/parties/party/organizationName/_name/lastName"
6 
"CatalogNumber","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/voucher"
6 
"CatalogNumber",
7 7 
"ScientificName","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonName)/Simple"
8 8 
"BasisOfRecord",
9 9 
"Kingdom","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=reg])/Name"
......
52 52 
"PlantFungusDescription","/simpleUserdefined[name=plantFungusDescription]/value"
53 53 
"Substrate","/simpleUserdefined[name=substrate]/value"
54 54 
"Vegetation","/simpleUserdefined[name=vegetation]/value"
55 
"UniqueNYInternalRecordNumber",
55 
"UniqueNYInternalRecordNumber","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/voucher"
mappings/joins/NYBG-VegBank.organisms.csv
1 1 
NYBG,VegBank:/taxonObservation
2 2 
InstitutionCode,/taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/museum_ID/party/OrganizationName/_name/firstName
3 3 
CollectionCode,/taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/museum_ID/party/OrganizationName/_name/lastName
4 
CatalogNumber,"/{taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/museumAccessionNumber,*_ID/observation/*_ID/plot/authorPlotCode}"
5 4 
ScientificName,/taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Species])/*_ID/*/plantName
6 5 
Kingdom,/taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Kingdom])/*_ID/*/plantName
7 6 
Phylum,/taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Subkingdom])/*_ID/*/plantName
......
39 38 
PlantFungusDescription,"/taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=plantFungusDescription]]/definedValue"
40 39 
Substrate,"/taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=substrate]]/definedValue"
41 40 
Vegetation,"/taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=vegetation]]/definedValue"
41 
UniqueNYInternalRecordNumber,"/{taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/museumAccessionNumber,*_ID/observation/*_ID/plot/authorPlotCode}"

Also available in: Unified diff