Revision 101
Added by Aaron Marcuse-Kubitza almost 13 years ago
| mappings/VegX-VegBank.organisms.csv | ||
|---|---|---|
| 1 | 1 |
"VegX:/*s/individualOrganismObservation","VegBank:/taxonObservation" |
| 2 | 2 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=TaxonomicRankBelowSubspeciesEnum])/Name","/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=computer,*_ID/plantConcept/plantStatus/plantLevel=Subspecies]:[interpretationType=""Computer (automated)"",originalInterpretation=false,currentInterpretation=true,interpretationDate=epoch,*_ID/party]/*_ID/plantConcept:[plantStatus:[plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference]/*_ID/*/plantName/_name/last" |
| 3 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=collector]/groupType","/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/definedValue[userDefined[tableName=taxonInterpretation,userDefinedName=determinationType]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 3 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=collector]/groupType","/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/definedValue[*_ID/userDefined[tableName=taxonInterpretation,userDefinedName=determinationType]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 4 | 4 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=collector]/partyWithRole/*ID->/parties/party/individualName/givenName","/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/collector_ID/party/givenName" |
| 5 | 5 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=collector]/partyWithRole/*ID->/parties/party/individualName/surName","/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/collector_ID/party/surName" |
| 6 | 6 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=fam])/Name","/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=computer,*_ID/plantConcept/plantStatus/plantLevel=Family]:[interpretationType=""Computer (automated)"",originalInterpretation=false,currentInterpretation=true,interpretationDate=epoch,*_ID/party]/*_ID/plantConcept:[plantStatus:[plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference]/*_ID/*/plantName" |
| ... | ... | |
| 8 | 8 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=sp])/AccordingTo/Simple","/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=computer,*_ID/plantConcept/plantStatus/plantLevel=Species]/*_ID/plantConcept/*_ID/plantName/reference_ID/reference/shortName" |
| 9 | 9 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=sp])/Name","/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=computer,*_ID/plantConcept/plantStatus/plantLevel=Species]:[interpretationType=""Computer (automated)"",originalInterpretation=false,currentInterpretation=true,interpretationDate=epoch,*_ID/party]/*_ID/plantConcept:[plantStatus:[plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference]/*_ID/*/plantName" |
| 10 | 10 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=TaxonomicRankBelowSubspeciesEnum])/Rank","/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=computer,*_ID/plantConcept/plantStatus/plantLevel=Subspecies]/*_ID/plantConcept:[plantStatus:[plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference]/*_ID/*/plantName/_name/first" |
| 11 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/note","/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/definedValue[userDefined[tableName=taxonInterpretation,userDefinedName=cfAff]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 11 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/note","/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/definedValue[*_ID/userDefined[tableName=taxonInterpretation,userDefinedName=cfAff]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 12 | 12 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=cl])/Name","/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=identifier,*_ID/plantConcept/plantStatus/plantLevel=Class]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=true,interpretationDate=epoch,*_ID/party]/*_ID/plantConcept:[plantStatus:[plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference]/*_ID/*/plantName" |
| 13 | 13 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=fam])/Name","/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=identifier,*_ID/plantConcept/plantStatus/plantLevel=Family]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=true,interpretationDate=epoch,*_ID/party]/*_ID/plantConcept:[plantStatus:[plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference]/*_ID/*/plantName" |
| 14 | 14 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=gen])/Name","/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=identifier,*_ID/plantConcept/plantStatus/plantLevel=Genus]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=true,interpretationDate=epoch,*_ID/party]/*_ID/plantConcept:[plantStatus:[plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference]/*_ID/*/plantName" |
| ... | ... | |
| 18 | 18 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=sp])/AccordingTo/Simple","/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=identifier,*_ID/plantConcept/plantStatus/plantLevel=Species]/*_ID/plantConcept/*_ID/reference/referenceContributor/*_ID/referenceParty/{givenName,surname}"
|
| 19 | 19 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=sp])/Name","/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=identifier,*_ID/plantConcept/plantStatus/plantLevel=Species]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=true,interpretationDate=epoch,*_ID/party]/*_ID/plantConcept:[plantStatus:[plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference]/*_ID/*/plantName" |
| 20 | 20 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=ssp])/Name","/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=identifier,*_ID/plantConcept/plantStatus/plantLevel=Subspecies]/*_ID/plantConcept:[plantStatus:[plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference]/*_ID/*/plantName" |
| 21 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonName)/Simple","/taxonImportance/stemCount/stemLocation/{taxonInterpretation[ROLE_ID/aux_Role/roleCode=identifier,!*_ID/plantConcept/plantStatus]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=true,interpretationDate=epoch,*_ID/party]/*_ID/plantConcept/*_ID/*/plantName,taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/*_ID/plantConcept/*_ID/*/plantName}"
|
|
| 21 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonName)/Simple","/taxonImportance/stemCount/stemLocation/{taxonInterpretation[ROLE_ID/aux_Role/roleCode=identifier,!*_ID/plantConcept/plantStatus]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=true,interpretationDate=epoch,*_ID/party]/*_ID/plantConcept:[*_ID/reference]/*_ID/*/plantName,taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/*_ID/plantConcept:[*_ID/reference]/*_ID/*/plantName}"
|
|
| 22 | 22 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/date/_date/day","/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=identifier,!*_ID/plantConcept/plantStatus]/interpretationDate/_date/day" |
| 23 | 23 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/date/_date/month","/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=identifier,!*_ID/plantConcept/plantStatus]/interpretationDate/_date/month" |
| 24 | 24 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/date/_date/year","/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=identifier,!*_ID/plantConcept/plantStatus]/interpretationDate/_date/year" |
| ... | ... | |
| 30 | 30 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/partyWithRole/*ID->/parties/party/organizationName/_name/last","/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/museum_ID/party/OrganizationName/_name/last" |
| 31 | 31 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/voucher","/{taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=false,interpretationDate=epoch,*_ID/plantConcept,*_ID/party]/museumAccessionNumber,*_ID/observation/*_ID/plot:[confidentialityStatus=0]/authorPlotCode}"
|
| 32 | 32 |
"/*ID->/*s/individualOrganism/identificationLabel","/taxonImportance/stemCount/stemLocation/stemCode" |
| 33 |
"/*ID->/*s/individualOrganism/simpleUserdefined[name=sex]/value","/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/definedValue[userDefined[tableName=taxonInterpretation,userDefinedName=sex]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 34 |
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/magnesium","/*_ID/observation/soilObs/definedValue[userDefined[tableName=soilObs,userDefinedName=soilMagnesium]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 35 |
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/nitrogen","/*_ID/observation/soilObs/definedValue[userDefined[tableName=soilObs,userDefinedName=soilNitrogen]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 33 |
"/*ID->/*s/individualOrganism/simpleUserdefined[name=sex]/value","/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/definedValue[*_ID/userDefined[tableName=taxonInterpretation,userDefinedName=sex]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 34 |
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/magnesium","/*_ID/observation/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilMagnesium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 35 |
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/nitrogen","/*_ID/observation/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilNitrogen]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 36 | 36 |
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/ph","/*_ID/observation/soilObs/soilPH" |
| 37 |
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/phosphorus","/*_ID/observation/soilObs/definedValue[userDefined[tableName=soilObs,userDefinedName=soilPhosphorus]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 38 |
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/pottasium","/*_ID/observation/soilObs/definedValue[userDefined[tableName=soilObs,userDefinedName=soilPotassium]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 39 |
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=acidity]/value","/*_ID/observation/soilObs/definedValue[userDefined[tableName=soilObs,userDefinedName=soilAcidity]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 40 |
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=base]/value","/*_ID/observation/soilObs/definedValue[userDefined[tableName=soilObs,userDefinedName=soilBase]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 41 |
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=calcium]/value","/*_ID/observation/soilObs/definedValue[userDefined[tableName=soilObs,userDefinedName=soilCalcium]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 42 |
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=carbon]/value","/*_ID/observation/soilObs/definedValue[userDefined[tableName=soilObs,userDefinedName=soilCarbon]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 43 |
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=cationCap]/value","/*_ID/observation/soilObs/definedValue[userDefined[tableName=soilObs,userDefinedName=soilCationCap]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 37 |
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/phosphorus","/*_ID/observation/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilPhosphorus]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 38 |
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/pottasium","/*_ID/observation/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilPotassium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 39 |
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=acidity]/value","/*_ID/observation/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilAcidity]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 40 |
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=base]/value","/*_ID/observation/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilBase]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 41 |
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=calcium]/value","/*_ID/observation/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilCalcium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 42 |
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=carbon]/value","/*_ID/observation/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilCarbon]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 43 |
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=cationCap]/value","/*_ID/observation/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilCationCap]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 44 | 44 |
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=clayPercent]/value","/*_ID/observation/soilObs/soilClay" |
| 45 |
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=conductivity]/value","/*_ID/observation/soilObs/definedValue[userDefined[tableName=soilObs,userDefinedName=soilConductivity]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 45 |
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=conductivity]/value","/*_ID/observation/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilConductivity]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 46 | 46 |
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=organicPercent]/value","/*_ID/observation/soilObs/soilOrganic" |
| 47 | 47 |
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=sandPercent]/value","/*_ID/observation/soilObs/soilSand" |
| 48 | 48 |
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=siltPercent]/value","/*_ID/observation/soilObs/soilSilt" |
| 49 |
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=sodium]/value","/*_ID/observation/soilObs/definedValue[userDefined[tableName=soilObs,userDefinedName=soilSodium]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 49 |
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=sodium]/value","/*_ID/observation/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilSodium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 50 | 50 |
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=texture]/value","/*_ID/observation/soilObs/soilTexture" |
| 51 | 51 |
"/*ID->/*s/plotObservation->/*s/communityDetermination[*ID]/communityConcepts/communityConcept/commonName","/*_ID/observation/commClass/commInterpretation/commconcept_ID/*_ID/observation/commClass/commInterpretation/*_ID/commConcept/*_ID/*/commName" |
| 52 | 52 |
"/*ID->/*s/plotObservation->/*s/communityDetermination[*ID]/communityConcepts/communityConcept/name","/*_ID/observation/commClass/commInterpretation/*_ID/commConcept/commDescription" |
| ... | ... | |
| 79 | 79 |
"/*ID->/*s/plotObservation/obsStartDate/_date/month","/*_ID/observation/obsStartDate/_date/month" |
| 80 | 80 |
"/*ID->/*s/plotObservation/obsStartDate/_date/year","/*_ID/observation/obsStartDate/_date/year" |
| 81 | 81 |
"/*ID->/*s/plotObservation/simpleUserdefined[name=plotMethodology]/value","/*_ID/observation/methodNarrative" |
| 82 |
"/*ID->/*s/plotObservation/simpleUserdefined[name=precipMm]/value","/*_ID/observation/definedValue[userDefined[tableName=observation,userDefinedName=precipitationMm]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 83 |
"/*ID->/*s/plotObservation/temperature","/*_ID/observation/definedValue[userDefined[tableName=observation,userDefinedName=temperatureC]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 84 |
"/diameterBaseDistance[baseDistance=0]/diameter","/taxonImportance/stemCount/stemLocation/definedValue[userDefined[tableName=stemLocation,userDefinedName=stemBasalDiameter]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 82 |
"/*ID->/*s/plotObservation/simpleUserdefined[name=precipMm]/value","/*_ID/observation/definedValue[*_ID/userDefined[tableName=observation,userDefinedName=precipitationMm]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 83 |
"/*ID->/*s/plotObservation/temperature","/*_ID/observation/definedValue[*_ID/userDefined[tableName=observation,userDefinedName=temperatureC]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 84 |
"/diameterBaseDistance[baseDistance=0]/diameter","/taxonImportance/stemCount/stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=stemBasalDiameter]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 85 | 85 |
"/diameterBaseDistance[baseDistance=1.37]/diameter","/taxonImportance/stemCount/stemDiameter" |
| 86 | 86 |
"/height","/taxonImportance/stemCount/stemHeight" |
| 87 |
"/simpleUserdefined[name=censusNo]/value","/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/definedValue[userDefined[tableName=taxonInterpretation,userDefinedName=censusNo]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 87 |
"/simpleUserdefined[name=censusNo]/value","/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/definedValue[*_ID/userDefined[tableName=taxonInterpretation,userDefinedName=censusNo]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 88 | 88 |
"/simpleUserdefined[name=count]/value","/taxonImportance/*/stemCount" |
| 89 | 89 |
"/simpleUserdefined[name=coverPercent]/value","/taxonImportance/cover" |
| 90 |
"/simpleUserdefined[name=habit]/value","/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/definedValue[userDefined[tableName=taxonInterpretation,userDefinedName=habit]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 91 |
"/simpleUserdefined[name=habitat]/value","/taxonImportance/stemCount/stemLocation/definedValue[userDefined[tableName=stemLocation,userDefinedName=habitat]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 92 |
"/simpleUserdefined[name=htFirstBranchM]/value","/taxonImportance/stemCount/stemLocation/definedValue[userDefined[tableName=stemLocation,userDefinedName=heightFirstBranchM]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 93 |
"/simpleUserdefined[name=individualCode]/value","/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/definedValue[userDefined[tableName=taxonInterpretation,userDefinedName=individualCode]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 94 |
"/simpleUserdefined[name=interceptCm]/value","/taxonImportance/definedValue[userDefined[tableName=taxonImportance,userDefinedName=interceptCm]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 95 |
"/simpleUserdefined[name=plantFungusDescription]/value","/taxonImportance/stemCount/stemLocation/definedValue[userDefined[tableName=stemLocation,userDefinedName=plantFungusDescription]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 96 |
"/simpleUserdefined[name=stemCanopyForm]/value","/taxonImportance/stemCount/stemLocation/definedValue[userDefined[tableName=stemLocation,userDefinedName=stemCanopyForm]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 97 |
"/simpleUserdefined[name=stemCanopyPosition]/value","/taxonImportance/stemCount/stemLocation/definedValue[userDefined[tableName=stemLocation,userDefinedName=stemCanopyPosition]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 98 |
"/simpleUserdefined[name=stemHeightFirstBranchM]/value","/taxonImportance/stemCount/stemLocation/definedValue[userDefined[tableName=stemLocation,userDefinedName=stemHeightFirstBranchM]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 90 |
"/simpleUserdefined[name=habit]/value","/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/definedValue[*_ID/userDefined[tableName=taxonInterpretation,userDefinedName=habit]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 91 |
"/simpleUserdefined[name=habitat]/value","/taxonImportance/stemCount/stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=habitat]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 92 |
"/simpleUserdefined[name=htFirstBranchM]/value","/taxonImportance/stemCount/stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=heightFirstBranchM]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 93 |
"/simpleUserdefined[name=individualCode]/value","/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/definedValue[*_ID/userDefined[tableName=taxonInterpretation,userDefinedName=individualCode]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 94 |
"/simpleUserdefined[name=interceptCm]/value","/taxonImportance/definedValue[*_ID/userDefined[tableName=taxonImportance,userDefinedName=interceptCm]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 95 |
"/simpleUserdefined[name=plantFungusDescription]/value","/taxonImportance/stemCount/stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=plantFungusDescription]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 96 |
"/simpleUserdefined[name=stemCanopyForm]/value","/taxonImportance/stemCount/stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=stemCanopyForm]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 97 |
"/simpleUserdefined[name=stemCanopyPosition]/value","/taxonImportance/stemCount/stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=stemCanopyPosition]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 98 |
"/simpleUserdefined[name=stemHeightFirstBranchM]/value","/taxonImportance/stemCount/stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=stemHeightFirstBranchM]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 99 | 99 |
"/simpleUserdefined[name=stemHeightM]/value","/taxonImportance/stemCount/stemHeight" |
| 100 |
"/simpleUserdefined[name=stemLianaInfestation]/value","/taxonImportance/stemCount/stemLocation/definedValue[userDefined[tableName=stemLocation,userDefinedName=stemLianaInfestation]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 101 |
"/simpleUserdefined[name=substrate]/value","/taxonImportance/stemCount/stemLocation/definedValue[userDefined[tableName=stemLocation,userDefinedName=substrate]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 102 |
"/simpleUserdefined[name=vegetation]/value","/taxonImportance/stemCount/stemLocation/definedValue[userDefined[tableName=stemLocation,userDefinedName=vegetation]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 100 |
"/simpleUserdefined[name=stemLianaInfestation]/value","/taxonImportance/stemCount/stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=stemLianaInfestation]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 101 |
"/simpleUserdefined[name=substrate]/value","/taxonImportance/stemCount/stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=substrate]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 102 |
"/simpleUserdefined[name=vegetation]/value","/taxonImportance/stemCount/stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=vegetation]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 103 | 103 |
"/simpleUserdefined[name=xPosition]/value","/taxonImportance/stemCount/stemLocation/stemXPosition" |
| 104 | 104 |
"/simpleUserdefined[name=yPosition]/value","/taxonImportance/stemCount/stemLocation/stemYPosition" |
| mappings/joins/NYBG-VegBank.organisms.csv | ||
|---|---|---|
| 2 | 2 |
:1,/taxonImportance/*/stemCount |
| 3 | 3 |
InstitutionCode,/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/museum_ID/party/OrganizationName/_name/first |
| 4 | 4 |
CollectionCode,/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/museum_ID/party/OrganizationName/_name/last |
| 5 |
ScientificName,"/taxonImportance/stemCount/stemLocation/{taxonInterpretation[ROLE_ID/aux_Role/roleCode=identifier,!*_ID/plantConcept/plantStatus]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=true,interpretationDate=epoch,*_ID/party]/*_ID/plantConcept/*_ID/*/plantName,taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/*_ID/plantConcept/*_ID/*/plantName}"
|
|
| 5 |
ScientificName,"/taxonImportance/stemCount/stemLocation/{taxonInterpretation[ROLE_ID/aux_Role/roleCode=identifier,!*_ID/plantConcept/plantStatus]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=true,interpretationDate=epoch,*_ID/party]/*_ID/plantConcept:[*_ID/reference]/*_ID/*/plantName,taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/*_ID/plantConcept:[*_ID/reference]/*_ID/*/plantName}"
|
|
| 6 | 6 |
Kingdom,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=identifier,*_ID/plantConcept/plantStatus/plantLevel=Kingdom]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=true,interpretationDate=epoch,*_ID/party]/*_ID/plantConcept:[plantStatus:[plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference]/*_ID/*/plantName" |
| 7 | 7 |
Phylum,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=identifier,*_ID/plantConcept/plantStatus/plantLevel=Subkingdom]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=true,interpretationDate=epoch,*_ID/party]/*_ID/plantConcept:[plantStatus:[plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference]/*_ID/*/plantName" |
| 8 | 8 |
Class,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=identifier,*_ID/plantConcept/plantStatus/plantLevel=Class]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=true,interpretationDate=epoch,*_ID/party]/*_ID/plantConcept:[plantStatus:[plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference]/*_ID/*/plantName" |
| ... | ... | |
| 33 | 33 |
MaximumElevation,"/*_ID/observation/*_ID/plot/{elevation/_avg/max,elevationRange/_range/to}"
|
| 34 | 34 |
MinimumDepth,/*_ID/observation/waterDepth/min |
| 35 | 35 |
MaximumDepth,/*_ID/observation/waterDepth/max |
| 36 |
Sex,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/definedValue[userDefined[tableName=taxonInterpretation,userDefinedName=sex]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 36 |
Sex,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/definedValue[*_ID/userDefined[tableName=taxonInterpretation,userDefinedName=sex]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 37 | 37 |
Notes,/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/notes |
| 38 |
Habitat,"/taxonImportance/stemCount/stemLocation/definedValue[userDefined[tableName=stemLocation,userDefinedName=habitat]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 39 |
PlantFungusDescription,"/taxonImportance/stemCount/stemLocation/definedValue[userDefined[tableName=stemLocation,userDefinedName=plantFungusDescription]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 40 |
Substrate,"/taxonImportance/stemCount/stemLocation/definedValue[userDefined[tableName=stemLocation,userDefinedName=substrate]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 41 |
Vegetation,"/taxonImportance/stemCount/stemLocation/definedValue[userDefined[tableName=stemLocation,userDefinedName=vegetation]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 38 |
Habitat,"/taxonImportance/stemCount/stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=habitat]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 39 |
PlantFungusDescription,"/taxonImportance/stemCount/stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=plantFungusDescription]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 40 |
Substrate,"/taxonImportance/stemCount/stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=substrate]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 41 |
Vegetation,"/taxonImportance/stemCount/stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=vegetation]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 42 | 42 |
UniqueNYInternalRecordNumber,"/{taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=false,interpretationDate=epoch,*_ID/plantConcept,*_ID/party]/museumAccessionNumber,*_ID/observation/*_ID/plot:[confidentialityStatus=0]/authorPlotCode}"
|
| mappings/joins/SALVIAS-VegBank.plots.csv | ||
|---|---|---|
| 11 | 11 |
elev_m,/*_ID/plot/elevation |
| 12 | 12 |
elev_max_m,"/*_ID/plot/{elevation/_avg/max,elevationRange/_range/to}"
|
| 13 | 13 |
elev_min_m,"/*_ID/plot/{elevation/_avg/min,elevationRange/_range/from}"
|
| 14 |
temp_c,"/definedValue[userDefined[tableName=observation,userDefinedName=temperatureC]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 15 |
precip_mm,"/definedValue[userDefined[tableName=observation,userDefinedName=precipitationMm]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 14 |
temp_c,"/definedValue[*_ID/userDefined[tableName=observation,userDefinedName=temperatureC]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 15 |
precip_mm,"/definedValue[*_ID/userDefined[tableName=observation,userDefinedName=precipitationMm]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 16 | 16 |
slope_aspect,/*_ID/plot/slopeAspect |
| 17 | 17 |
slope_gradient,/*_ID/plot/slopeGradient |
| 18 | 18 |
clay_percent,/soilObs/soilClay |
| ... | ... | |
| 20 | 20 |
sand_percent,/soilObs/soilSand |
| 21 | 21 |
organic_percent,/soilObs/soilOrganic |
| 22 | 22 |
pH,/soilObs/soilPH |
| 23 |
soil_N,"/soilObs/definedValue[userDefined[tableName=soilObs,userDefinedName=soilNitrogen]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 24 |
soil_P,"/soilObs/definedValue[userDefined[tableName=soilObs,userDefinedName=soilPhosphorus]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 25 |
soil_C,"/soilObs/definedValue[userDefined[tableName=soilObs,userDefinedName=soilCarbon]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 26 |
soil_K,"/soilObs/definedValue[userDefined[tableName=soilObs,userDefinedName=soilPotassium]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 27 |
soil_Mg,"/soilObs/definedValue[userDefined[tableName=soilObs,userDefinedName=soilMagnesium]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 28 |
soil_Ca,"/soilObs/definedValue[userDefined[tableName=soilObs,userDefinedName=soilCalcium]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 29 |
soil_Na,"/soilObs/definedValue[userDefined[tableName=soilObs,userDefinedName=soilSodium]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 30 |
soil_acidity,"/soilObs/definedValue[userDefined[tableName=soilObs,userDefinedName=soilAcidity]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 31 |
soil_base,"/soilObs/definedValue[userDefined[tableName=soilObs,userDefinedName=soilBase]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 32 |
soil_cation_cap,"/soilObs/definedValue[userDefined[tableName=soilObs,userDefinedName=soilCationCap]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 33 |
soil_conductivity,"/soilObs/definedValue[userDefined[tableName=soilObs,userDefinedName=soilConductivity]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 23 |
soil_N,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilNitrogen]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 24 |
soil_P,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilPhosphorus]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 25 |
soil_C,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilCarbon]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 26 |
soil_K,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilPotassium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 27 |
soil_Mg,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilMagnesium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 28 |
soil_Ca,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilCalcium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 29 |
soil_Na,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilSodium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 30 |
soil_acidity,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilAcidity]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 31 |
soil_base,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilBase]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 32 |
soil_cation_cap,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilCationCap]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 33 |
soil_conductivity,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilConductivity]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 34 | 34 |
soil_texture,/soilObs/soilTexture |
| 35 | 35 |
holdridge_life_zone,/commClass/commInterpretation/*_ID/commConcept/commDescription |
| 36 | 36 |
life_zone_code,/commClass/commInterpretation/commconcept_ID/*_ID/observation/commClass/commInterpretation/*_ID/commConcept/*_ID/*/commName |
| mappings/joins/SALVIAS-VegBank.organisms.csv | ||
|---|---|---|
| 1 | 1 |
SALVIAS,VegBank:/taxonObservation |
| 2 | 2 |
OBSERVATION_ID,"/{taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=false,interpretationDate=epoch,*_ID/plantConcept,*_ID/party]/museumAccessionNumber,*_ID/observation/*_ID/plot:[confidentialityStatus=0]/authorPlotCode}"
|
| 3 | 3 |
plot_code,/*_ID/observation/*_ID/plot/PARENT_ID/plot:[confidentialityStatus=0]/authorPlotCode |
| 4 |
census_no,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/definedValue[userDefined[tableName=taxonInterpretation,userDefinedName=censusNo]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 4 |
census_no,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/definedValue[*_ID/userDefined[tableName=taxonInterpretation,userDefinedName=censusNo]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 5 | 5 |
census_date,/*_ID/observation/obsStartDate |
| 6 | 6 |
subplot,"/*_ID/observation/{*_ID/plot:[confidentialityStatus=0]/authorPlotCode,authorObsCode}"
|
| 7 |
individual_code,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/definedValue[userDefined[tableName=taxonInterpretation,userDefinedName=individualCode]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 7 |
individual_code,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/definedValue[*_ID/userDefined[tableName=taxonInterpretation,userDefinedName=individualCode]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 8 | 8 |
tag1,/taxonImportance/stemCount/stemLocation/stemCode |
| 9 | 9 |
tag2,/taxonImportance/stemCount/stemLocation/stemCode |
| 10 | 10 |
x_position,/taxonImportance/stemCount/stemLocation/stemXPosition |
| ... | ... | |
| 12 | 12 |
coll_number,/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/collectionNumber |
| 13 | 13 |
coll_lastname,/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/collector_ID/party/surName |
| 14 | 14 |
coll_firstname,/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/collector_ID/party/givenName |
| 15 |
det_type,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/definedValue[userDefined[tableName=taxonInterpretation,userDefinedName=determinationType]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 15 |
det_type,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/definedValue[*_ID/userDefined[tableName=taxonInterpretation,userDefinedName=determinationType]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 16 | 16 |
family,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=computer,*_ID/plantConcept/plantStatus/plantLevel=Family]:[interpretationType=""Computer (automated)"",originalInterpretation=false,currentInterpretation=true,interpretationDate=epoch,*_ID/party]/*_ID/plantConcept:[plantStatus:[plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference]/*_ID/*/plantName" |
| 17 | 17 |
genus,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=computer,*_ID/plantConcept/plantStatus/plantLevel=Genus]:[interpretationType=""Computer (automated)"",originalInterpretation=false,currentInterpretation=true,interpretationDate=epoch,*_ID/party]/*_ID/plantConcept:[plantStatus:[plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference]/*_ID/*/plantName" |
| 18 | 18 |
specific_epithet,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=computer,*_ID/plantConcept/plantStatus/plantLevel=Species]:[interpretationType=""Computer (automated)"",originalInterpretation=false,currentInterpretation=true,interpretationDate=epoch,*_ID/party]/*_ID/plantConcept:[plantStatus:[plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference]/*_ID/*/plantName" |
| 19 | 19 |
specific_authority,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=computer,*_ID/plantConcept/plantStatus/plantLevel=Species]/*_ID/plantConcept/*_ID/plantName/reference_ID/reference/shortName" |
| 20 | 20 |
infra_rank_1,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=computer,*_ID/plantConcept/plantStatus/plantLevel=Subspecies]/*_ID/plantConcept:[plantStatus:[plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference]/*_ID/*/plantName/_name/first" |
| 21 | 21 |
infra_ep_1,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=computer,*_ID/plantConcept/plantStatus/plantLevel=Subspecies]:[interpretationType=""Computer (automated)"",originalInterpretation=false,currentInterpretation=true,interpretationDate=epoch,*_ID/party]/*_ID/plantConcept:[plantStatus:[plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference]/*_ID/*/plantName/_name/last" |
| 22 |
cf_aff,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/definedValue[userDefined[tableName=taxonInterpretation,userDefinedName=cfAff]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 23 |
habit,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/definedValue[userDefined[tableName=taxonInterpretation,userDefinedName=habit]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 22 |
cf_aff,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/definedValue[*_ID/userDefined[tableName=taxonInterpretation,userDefinedName=cfAff]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 23 |
habit,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/definedValue[*_ID/userDefined[tableName=taxonInterpretation,userDefinedName=habit]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 24 | 24 |
no_of_individuals,/taxonImportance/*/stemCount |
| 25 | 25 |
cover_percent,/taxonImportance/cover |
| 26 |
intercept_cm,"/taxonImportance/definedValue[userDefined[tableName=taxonImportance,userDefinedName=interceptCm]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 26 |
intercept_cm,"/taxonImportance/definedValue[*_ID/userDefined[tableName=taxonImportance,userDefinedName=interceptCm]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 27 | 27 |
height_m,/taxonImportance/stemCount/stemHeight |
| 28 |
ht_first_branch_m,"/taxonImportance/stemCount/stemLocation/definedValue[userDefined[tableName=stemLocation,userDefinedName=heightFirstBranchM]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 28 |
ht_first_branch_m,"/taxonImportance/stemCount/stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=heightFirstBranchM]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 29 | 29 |
stem_tag1,/taxonImportance/stemCount/stemLocation/stemCode |
| 30 | 30 |
stem_tag2,/taxonImportance/stemCount/stemLocation/stemCode |
| 31 | 31 |
stem_dbh,/taxonImportance/stemCount/stemDiameter |
| 32 |
basal_diam,"/taxonImportance/stemCount/stemLocation/definedValue[userDefined[tableName=stemLocation,userDefinedName=stemBasalDiameter]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 32 |
basal_diam,"/taxonImportance/stemCount/stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=stemBasalDiameter]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 33 | 33 |
stem_height_m,/taxonImportance/stemCount/stemHeight |
| 34 |
stem_height_first_branch_m,"/taxonImportance/stemCount/stemLocation/definedValue[userDefined[tableName=stemLocation,userDefinedName=stemHeightFirstBranchM]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 35 |
stem_canopy_form,"/taxonImportance/stemCount/stemLocation/definedValue[userDefined[tableName=stemLocation,userDefinedName=stemCanopyForm]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 36 |
stem_canopy_position,"/taxonImportance/stemCount/stemLocation/definedValue[userDefined[tableName=stemLocation,userDefinedName=stemCanopyPosition]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 37 |
stem_liana_infestation,"/taxonImportance/stemCount/stemLocation/definedValue[userDefined[tableName=stemLocation,userDefinedName=stemLianaInfestation]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 34 |
stem_height_first_branch_m,"/taxonImportance/stemCount/stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=stemHeightFirstBranchM]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 35 |
stem_canopy_form,"/taxonImportance/stemCount/stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=stemCanopyForm]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 36 |
stem_canopy_position,"/taxonImportance/stemCount/stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=stemCanopyPosition]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 37 |
stem_liana_infestation,"/taxonImportance/stemCount/stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=stemLianaInfestation]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 38 | 38 |
notes,/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/notes |
| 39 | 39 |
orig_family,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=identifier,*_ID/plantConcept/plantStatus/plantLevel=Family]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=true,interpretationDate=epoch,*_ID/party]/*_ID/plantConcept:[plantStatus:[plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference]/*_ID/*/plantName" |
| 40 | 40 |
orig_species,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=identifier,*_ID/plantConcept/plantStatus/plantLevel=Species]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=true,interpretationDate=epoch,*_ID/party]/*_ID/plantConcept:[plantStatus:[plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference]/*_ID/*/plantName" |
| mappings/VegX-VegBank.plots.csv | ||
|---|---|---|
| 1 | 1 |
VegX:/*s/plotObservation,VegBank:/observation |
| 2 |
->/*s/abioticObservation[*ID]/magnesium,"/soilObs/definedValue[userDefined[tableName=soilObs,userDefinedName=soilMagnesium]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 3 |
->/*s/abioticObservation[*ID]/nitrogen,"/soilObs/definedValue[userDefined[tableName=soilObs,userDefinedName=soilNitrogen]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 2 |
->/*s/abioticObservation[*ID]/magnesium,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilMagnesium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 3 |
->/*s/abioticObservation[*ID]/nitrogen,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilNitrogen]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 4 | 4 |
->/*s/abioticObservation[*ID]/ph,/soilObs/soilPH |
| 5 |
->/*s/abioticObservation[*ID]/phosphorus,"/soilObs/definedValue[userDefined[tableName=soilObs,userDefinedName=soilPhosphorus]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 6 |
->/*s/abioticObservation[*ID]/pottasium,"/soilObs/definedValue[userDefined[tableName=soilObs,userDefinedName=soilPotassium]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 7 |
->/*s/abioticObservation[*ID]/simpleUserdefined[name=acidity]/value,"/soilObs/definedValue[userDefined[tableName=soilObs,userDefinedName=soilAcidity]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 8 |
->/*s/abioticObservation[*ID]/simpleUserdefined[name=base]/value,"/soilObs/definedValue[userDefined[tableName=soilObs,userDefinedName=soilBase]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 9 |
->/*s/abioticObservation[*ID]/simpleUserdefined[name=calcium]/value,"/soilObs/definedValue[userDefined[tableName=soilObs,userDefinedName=soilCalcium]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 10 |
->/*s/abioticObservation[*ID]/simpleUserdefined[name=carbon]/value,"/soilObs/definedValue[userDefined[tableName=soilObs,userDefinedName=soilCarbon]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 11 |
->/*s/abioticObservation[*ID]/simpleUserdefined[name=cationCap]/value,"/soilObs/definedValue[userDefined[tableName=soilObs,userDefinedName=soilCationCap]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 5 |
->/*s/abioticObservation[*ID]/phosphorus,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilPhosphorus]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 6 |
->/*s/abioticObservation[*ID]/pottasium,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilPotassium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 7 |
->/*s/abioticObservation[*ID]/simpleUserdefined[name=acidity]/value,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilAcidity]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 8 |
->/*s/abioticObservation[*ID]/simpleUserdefined[name=base]/value,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilBase]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 9 |
->/*s/abioticObservation[*ID]/simpleUserdefined[name=calcium]/value,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilCalcium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 10 |
->/*s/abioticObservation[*ID]/simpleUserdefined[name=carbon]/value,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilCarbon]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 11 |
->/*s/abioticObservation[*ID]/simpleUserdefined[name=cationCap]/value,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilCationCap]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 12 | 12 |
->/*s/abioticObservation[*ID]/simpleUserdefined[name=clayPercent]/value,/soilObs/soilClay |
| 13 |
->/*s/abioticObservation[*ID]/simpleUserdefined[name=conductivity]/value,"/soilObs/definedValue[userDefined[tableName=soilObs,userDefinedName=soilConductivity]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 13 |
->/*s/abioticObservation[*ID]/simpleUserdefined[name=conductivity]/value,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilConductivity]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 14 | 14 |
->/*s/abioticObservation[*ID]/simpleUserdefined[name=organicPercent]/value,/soilObs/soilOrganic |
| 15 | 15 |
->/*s/abioticObservation[*ID]/simpleUserdefined[name=sandPercent]/value,/soilObs/soilSand |
| 16 | 16 |
->/*s/abioticObservation[*ID]/simpleUserdefined[name=siltPercent]/value,/soilObs/soilSilt |
| 17 |
->/*s/abioticObservation[*ID]/simpleUserdefined[name=sodium]/value,"/soilObs/definedValue[userDefined[tableName=soilObs,userDefinedName=soilSodium]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 17 |
->/*s/abioticObservation[*ID]/simpleUserdefined[name=sodium]/value,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilSodium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
|
|
| 18 | 18 |
->/*s/abioticObservation[*ID]/simpleUserdefined[name=texture]/value,/soilObs/soilTexture |
| 19 | 19 |
->/*s/communityDetermination[*ID]/communityConcepts/communityConcept/commonName,/commClass/commInterpretation/commconcept_ID/*_ID/observation/commClass/commInterpretation/*_ID/commConcept/*_ID/*/commName |
| 20 | 20 |
->/*s/communityDetermination[*ID]/communityConcepts/communityConcept/name,/commClass/commInterpretation/*_ID/commConcept/commDescription |
| ... | ... | |
| 47 | 47 |
/obsStartDate/_date/month,/obsStartDate/_date/month |
| 48 | 48 |
/obsStartDate/_date/year,/obsStartDate/_date/year |
| 49 | 49 |
/simpleUserdefined[name=plotMethodology]/value,/methodNarrative |
| 50 |
/simpleUserdefined[name=precipMm]/value,"/definedValue[userDefined[tableName=observation,userDefinedName=precipitationMm]]:[@fkey=tableRecord_ID]/definedValue" |
|
| 51 |
/temperature,"/definedValue[userDefined[tableName=observation,userDefinedName=temperatureC]]:[@fkey=tableRecord_ID]/definedValue" |
|
| 50 |
/simpleUserdefined[name=precipMm]/value,"/definedValue[*_ID/userDefined[tableName=observation,userDefinedName=precipitationMm]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue" |
|
| 51 |
/temperature,"/definedValue[*_ID/userDefined[tableName=observation,userDefinedName=temperatureC]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue" |
|
Also available in: Unified diff
Finished NYBG mapping to VegBank\!