Revision 122
Added by Aaron Marcuse-Kubitza about 13 years ago
mappings/VegX-VegBank.organisms.csv | ||
---|---|---|
71 | 71 |
"/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/simpleUserdefined[name=majorGeo]/value","/*_ID/observation/*_ID/plot/place(/*_ID/namedPlace[placeSystem=continent])/placeName" |
72 | 72 |
"/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/slopeAspect","/*_ID/observation/*_ID/plot/slopeAspect" |
73 | 73 |
"/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/slopeGradient","/*_ID/observation/*_ID/plot/slopeGradient" |
74 |
"/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/state","/*_ID/observation/*_ID/plot/place(/*_ID/namedPlace[placeSystem=""Geographic Name""])/placeName" |
|
75 | 74 |
"/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/state","/*_ID/observation/*_ID/plot/place(/*_ID/namedPlace[placeSystem=""region|state|province""])/placeName" |
76 | 75 |
"/*ID->/*s/plotObservation/obsEndDate/_date/year","/*_ID/observation/obsEndDate/_date/year" |
77 | 76 |
"/*ID->/*s/plotObservation/obsStartDate/_date/day","/*_ID/observation/obsStartDate/_date/day" |
mappings/NYBG-VegBank.organisms.csv | ||
---|---|---|
39 | 39 |
PlantFungusDescription,"/taxonImportance/stemCount/stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=plantFungusDescription]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue","Brad: Incorrect mapping to VB, also possibly to VX; this is the specimenDescription field, as used by this institution (NOT a standard DwC element). Very important! Bob, Nick, where would this go in VB and VX?" |
40 | 40 |
Substrate,"/taxonImportance/stemCount/stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=substrate]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue","Brad: Incorrect mapping to VB and VX; refers to geological substrate or soils where specimen collected. Often concatenated with habitat, or included with specimen description. Bob, Nick, is there an element for this in VB/VX, or shall we just use userDefined?" |
41 | 41 |
Vegetation,"/taxonImportance/stemCount/stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=vegetation]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Habitat'. Bob, Nick: keep as user defined or create special element?" |
42 |
UniqueNYInternalRecordNumber,"/{taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=false,interpretationDate=epoch,*_ID/plantConcept:[*_ID/reference],*_ID/party]/museumAccessionNumber,*_ID/observation/*_ID/plot:[confidentialityStatus=0]/authorPlotCode/_alt/3}",Brad: OMIT; Aaron: We need this field because it is the only ID column with an entry in every row |
|
42 |
UniqueNYInternalRecordNumber,"/{taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=false,interpretationDate=epoch,*_ID/plantConcept:[*_ID/reference],*_ID/party]/museumAccessionNumber,*_ID/observation/*_ID/plot:[confidentialityStatus=0]/authorPlotCode/_alt/3}","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" |
mappings/VegX-VegBank.plots.csv | ||
---|---|---|
39 | 39 |
/*UniqueIdentifierID->/*s/plot/simpleUserdefined[name=majorGeo]/value,/*_ID/plot/place(/*_ID/namedPlace[placeSystem=continent])/placeName |
40 | 40 |
/*UniqueIdentifierID->/*s/plot/slopeAspect,/*_ID/plot/slopeAspect |
41 | 41 |
/*UniqueIdentifierID->/*s/plot/slopeGradient,/*_ID/plot/slopeGradient |
42 |
/*UniqueIdentifierID->/*s/plot/state,"/*_ID/plot/place(/*_ID/namedPlace[placeSystem=""Geographic Name""])/placeName" |
|
43 | 42 |
/*UniqueIdentifierID->/*s/plot/state,"/*_ID/plot/place(/*_ID/namedPlace[placeSystem=""region|state|province""])/placeName" |
44 | 43 |
/obsEndDate/_date/year,/obsEndDate/_date/year |
45 | 44 |
/obsStartDate/_date/day,/obsStartDate/_date/day |
Also available in: Unified diff
VegX-VegBank mapping: Removed a duplicated mapping