/ - Diff - BIEN 3 - NCEAS Projects

     VegBank:/taxonObservation,VegBIEN:/taxonoccurrence
     //plot/authorPlotCode/_alt/1,//plot/authorPlotCode/_alt/1
     //plot/area,//plot/area
     //plot/dsgpoly,//plot/dsgpoly
     //plot/elevation,//plot/elevation
     //plot/locationAccuracy,//plot/locationAccuracy
     "//*_ID/namedPlace[placeSystem=""area|country|territory""]/placeName","//*_ID/namedPlace[placeSystem=""area|country|territory""]/placeName"
     "//*_ID/namedPlace[placeSystem=""region|state|province""]/placeName","//*_ID/namedPlace[placeSystem=""region|state|province""]/placeName"
     //*_ID/namedPlace[placeSystem=continent]/placeName,//*_ID/namedPlace[placeSystem=continent]/placeName
     //*_ID/namedPlace[placeSystem=county]/placeName,//*_ID/namedPlace[placeSystem=county]/placeName
     //namedPlace/placeDescription,//namedPlace/placeDescription
     //namedPlace/placeDescription,//namedPlace/placeDescription
     //plot/realLatitude,//plot/realLatitude
     //plot/realLongitude,//plot/realLongitude
     //plot/slopeAspect,//plot/slopeAspect
     //plot/slopeGradient,//plot/slopeGradient
     "/*_ID/observation/*_ID/plot/{elevation/_avg/max,elevationRange/_range/to}","/*_ID/plotevent/*_ID/plot/{elevation/_avg/max,elevationRange/_range/to}"
     "/*_ID/observation/*_ID/plot/{elevation/_avg/min,elevationRange/_range/from}","/*_ID/plotevent/*_ID/plot/{elevation/_avg/min,elevationRange/_range/from}"
     //project/projectName,//project/projectName
     //*/commName,//*/commName
     //commConcept/commDescription,//commConcept/commDescription
     "//observation/definedValue[*_ID/userDefined[tableName=observation,userDefinedName=precipitationMm]]/definedValue","//plotevent/definedValue[*_ID/userDefined[tableName=observation,userDefinedName=precipitationMm]]/definedValue"
     "//observation/definedValue[*_ID/userDefined[tableName=observation,userDefinedName=temperatureC]]/definedValue","//plotevent/definedValue[*_ID/userDefined[tableName=observation,userDefinedName=temperatureC]]/definedValue"
     //observation/methodNarrative,//plotevent/methodNarrative
     //observation/obsEndDate,//plotevent/obsEndDate
     //observation/obsEndDate/_date/year,//plotevent/obsEndDate/_date/year
     //observation/obsStartDate,//plotevent/obsStartDate
     //observation/obsStartDate/_date/day,//plotevent/obsStartDate/_date/day
     //observation/obsStartDate/_date/month,//plotevent/obsStartDate/_date/month
     //observation/obsStartDate/_date/year,//plotevent/obsStartDate/_date/year
     "//soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilAcidity]]/definedValue","//soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilAcidity]]/definedValue"
     "//soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilBase]]/definedValue","//soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilBase]]/definedValue"
     "//soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilCalcium]]/definedValue","//soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilCalcium]]/definedValue"
     "//soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilCarbon]]/definedValue","//soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilCarbon]]/definedValue"
     "//soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilCationCap]]/definedValue","//soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilCationCap]]/definedValue"
     "//soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilConductivity]]/definedValue","//soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilConductivity]]/definedValue"
     "//soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilMagnesium]]/definedValue","//soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilMagnesium]]/definedValue"
     "//soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilNitrogen]]/definedValue","//soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilNitrogen]]/definedValue"
     "//soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilPhosphorus]]/definedValue","//soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilPhosphorus]]/definedValue"
     "//soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilPotassium]]/definedValue","//soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilPotassium]]/definedValue"
     "//soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilSodium]]/definedValue","//soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilSodium]]/definedValue"
     //soilObs/soilClay,//soilObs/soilClay
     //soilObs/soilOrganic,//soilObs/soilOrganic
     //soilObs/soilPH,//soilObs/soilPH
     //soilObs/soilSand,//soilObs/soilSand
     //soilObs/soilSilt,//soilObs/soilSilt
     //soilObs/soilTexture,//soilObs/soilTexture
     //waterDepth/max,//waterDepth/max
     //waterDepth/min,//waterDepth/min
     "/*_ID/observation/{*_ID/plot/authorPlotCode/_alt/2,authorObsCode}","/*_ID/plotevent/{*_ID/plot/authorPlotCode/_alt/2,authorObsCode}"
     //*/stemCount,//*/stemCount
     //taxonImportance/cover,//collectiveobs/cover
     "//taxonImportance/definedValue[*_ID/userDefined[tableName=taxonImportance,userDefinedName=interceptCm]]/definedValue","//collectiveobs/definedValue[*_ID/userDefined[tableName=collectiveobs,userDefinedName=interceptCm]]/definedValue"
     //stemCount/stemDiameter,//stemCount/stemDiameter
     //stemCount/stemHeight,//stemCount/stemHeight
     //stemCount/stemHeight,//stemCount/stemHeight
     "//stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=habitat]]/definedValue","//individual/definedValue[*_ID/userDefined[tableName=individual,userDefinedName=habitat]]/definedValue"
     "//stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=heightFirstBranchM]]/definedValue","//individual/definedValue[*_ID/userDefined[tableName=individual,userDefinedName=heightFirstBranchM]]/definedValue"
     "//stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=plantFungusDescription]]/definedValue","//individual/definedValue[*_ID/userDefined[tableName=individual,userDefinedName=plantFungusDescription]]/definedValue"
     "//stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=stemBasalDiameter]]/definedValue","//individual/definedValue[*_ID/userDefined[tableName=individual,userDefinedName=stemBasalDiameter]]/definedValue"
     "//stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=stemCanopyForm]]/definedValue","//individual/definedValue[*_ID/userDefined[tableName=individual,userDefinedName=stemCanopyForm]]/definedValue"
     "//stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=stemCanopyPosition]]/definedValue","//individual/definedValue[*_ID/userDefined[tableName=individual,userDefinedName=stemCanopyPosition]]/definedValue"
     "//stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=stemHeightFirstBranchM]]/definedValue","//individual/definedValue[*_ID/userDefined[tableName=individual,userDefinedName=stemHeightFirstBranchM]]/definedValue"
     "//stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=stemLianaInfestation]]/definedValue","//individual/definedValue[*_ID/userDefined[tableName=individual,userDefinedName=stemLianaInfestation]]/definedValue"
     "//stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=substrate]]/definedValue","//individual/definedValue[*_ID/userDefined[tableName=individual,userDefinedName=substrate]]/definedValue"
     "//stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=vegetation]]/definedValue","//individual/definedValue[*_ID/userDefined[tableName=individual,userDefinedName=vegetation]]/definedValue"
     //stemLocation/stemCode,//individual/stemCode
     //stemLocation/stemXPosition,//individual/stemXPosition
     //stemLocation/stemYPosition,//individual/stemYPosition
     /taxonInterpretation[roleCode=collector]/collectionNumber,/taxondetermination[roleCode=collector]/collectionNumber
     "/taxonInterpretation[roleCode=collector]/collector_ID/party/{givenName/_namePart/first,middleName/_namePart/last}","/taxondetermination[roleCode=collector]/collector_ID/party/{givenName/_namePart/first,middleName/_namePart/last}"
     "/taxonInterpretation[roleCode=collector]/collector_ID/party/{givenName/_namePart/first,middleName/_namePart/middle,surName/_namePart/last}","/taxondetermination[roleCode=collector]/collector_ID/party/{givenName/_namePart/first,middleName/_namePart/middle,surName/_namePart/last}"
     /taxonInterpretation[roleCode=collector]/collector_ID/party/{surName},/taxondetermination[roleCode=collector]/collector_ID/party/{surName}
     "/taxonInterpretation[roleCode=collector]/definedValue[*_ID/userDefined[tableName=taxonInterpretation,userDefinedName=censusNo]]/definedValue","/taxondetermination[roleCode=collector]/definedValue[*_ID/userDefined[tableName=taxondetermination,userDefinedName=censusNo]]/definedValue"
     "/taxonInterpretation[roleCode=collector]/definedValue[*_ID/userDefined[tableName=taxonInterpretation,userDefinedName=cfAff]]/definedValue","/taxondetermination[roleCode=collector]/definedValue[*_ID/userDefined[tableName=taxondetermination,userDefinedName=cfAff]]/definedValue"
     "/taxonInterpretation[roleCode=collector]/definedValue[*_ID/userDefined[tableName=taxonInterpretation,userDefinedName=determinationType]]/definedValue","/taxondetermination[roleCode=collector]/definedValue[*_ID/userDefined[tableName=taxondetermination,userDefinedName=determinationType]]/definedValue"
     "/taxonInterpretation[roleCode=collector]/definedValue[*_ID/userDefined[tableName=taxonInterpretation,userDefinedName=habit]]/definedValue","/taxondetermination[roleCode=collector]/definedValue[*_ID/userDefined[tableName=taxondetermination,userDefinedName=habit]]/definedValue"
     "/taxonInterpretation[roleCode=collector]/definedValue[*_ID/userDefined[tableName=taxonInterpretation,userDefinedName=individualCode]]/definedValue","/taxondetermination[roleCode=collector]/definedValue[*_ID/userDefined[tableName=taxondetermination,userDefinedName=individualCode]]/definedValue"
     "/taxonInterpretation[roleCode=collector]/definedValue[*_ID/userDefined[tableName=taxonInterpretation,userDefinedName=sex]]/definedValue","/taxondetermination[roleCode=collector]/definedValue[*_ID/userDefined[tableName=taxondetermination,userDefinedName=sex]]/definedValue"
     /taxonInterpretation[roleCode=collector]/museum_ID/party/OrganizationName,/taxondetermination[roleCode=collector]/museum_ID/party/OrganizationName
     /taxonInterpretation[roleCode=collector]/museum_ID/party/OrganizationName/_name/first,/taxondetermination[roleCode=collector]/museum_ID/party/OrganizationName/_name/first
     /taxonInterpretation[roleCode=collector]/museum_ID/party/OrganizationName/_name/last,/taxondetermination[roleCode=collector]/museum_ID/party/OrganizationName/_name/last
     /taxonInterpretation[roleCode=collector]/notes,/taxondetermination[roleCode=collector]/notes
     "/taxonInterpretation[roleCode=computer,plantLevel=Family]/*_ID/plantConcept/*_ID/*/plantName","/taxondetermination[roleCode=computer,plantLevel=Family]/*_ID/plantConcept/*_ID/*/plantName"
     "/taxonInterpretation[roleCode=computer,plantLevel=Genus]/*_ID/plantConcept/*_ID/*/plantName","/taxondetermination[roleCode=computer,plantLevel=Genus]/*_ID/plantConcept/*_ID/*/plantName"
     "/taxonInterpretation[roleCode=computer,plantLevel=Species]/*_ID/plantConcept/*_ID/plantName/reference_ID/reference/shortName","/taxondetermination[roleCode=computer,plantLevel=Species]/*_ID/plantConcept/*_ID/plantName/reference_ID/reference/shortName"
     "/taxonInterpretation[roleCode=computer,plantLevel=Species]/*_ID/plantConcept/*_ID/*/plantName","/taxondetermination[roleCode=computer,plantLevel=Species]/*_ID/plantConcept/*_ID/*/plantName"
     "/taxonInterpretation[roleCode=computer,plantLevel=Subspecies]/*_ID/plantConcept/*_ID/*/plantName/_name/first","/taxondetermination[roleCode=computer,plantLevel=Subspecies]/*_ID/plantConcept/*_ID/*/plantName/_name/first"
     "/taxonInterpretation[roleCode=computer,plantLevel=Subspecies]/*_ID/plantConcept/*_ID/*/plantName/_name/last","/taxondetermination[roleCode=computer,plantLevel=Subspecies]/*_ID/plantConcept/*_ID/*/plantName/_name/last"
     /taxonInterpretation[roleCode=identifier]/interpretationDate/_date/day,/taxondetermination[roleCode=identifier]/interpretationDate/_date/day
     /taxonInterpretation[roleCode=identifier]/interpretationDate/_date/month,/taxondetermination[roleCode=identifier]/interpretationDate/_date/month
     /taxonInterpretation[roleCode=identifier]/interpretationDate/_date/year,/taxondetermination[roleCode=identifier]/interpretationDate/_date/year
     "/taxonInterpretation[roleCode=identifier]/*_ID/party/{givenName/_namePart/first,middleName/_namePart/middle,surName/_namePart/last}","/taxondetermination[roleCode=identifier]/*_ID/party/{givenName/_namePart/first,middleName/_namePart/middle,surName/_namePart/last}"
     "/taxonInterpretation[roleCode=identifier,plantLevel=Class]/*_ID/plantConcept/*_ID/*/plantName","/taxondetermination[roleCode=identifier,plantLevel=Class]/*_ID/plantConcept/*_ID/*/plantName"
     "/taxonInterpretation[roleCode=identifier,plantLevel=Family]/*_ID/plantConcept/*_ID/*/plantName","/taxondetermination[roleCode=identifier,plantLevel=Family]/*_ID/plantConcept/*_ID/*/plantName"
     "/taxonInterpretation[roleCode=identifier,plantLevel=Genus]/*_ID/plantConcept/*_ID/*/plantName","/taxondetermination[roleCode=identifier,plantLevel=Genus]/*_ID/plantConcept/*_ID/*/plantName"
     "/taxonInterpretation[roleCode=identifier,plantLevel=Kingdom]/*_ID/plantConcept/*_ID/*/plantName","/taxondetermination[roleCode=identifier,plantLevel=Kingdom]/*_ID/plantConcept/*_ID/*/plantName"
     "/taxonInterpretation[roleCode=identifier,plantLevel=Order]/*_ID/plantConcept/*_ID/*/plantName","/taxondetermination[roleCode=identifier,plantLevel=Order]/*_ID/plantConcept/*_ID/*/plantName"
     "/taxonInterpretation[roleCode=identifier,plantLevel=Species]/*_ID/plantConcept/*_ID/reference/referenceContributor/*_ID/referenceParty/{givenName,surname}","/taxondetermination[roleCode=identifier,plantLevel=Species]/*_ID/plantConcept/*_ID/reference/referenceContributor/*_ID/referenceParty/{givenName,surname}"
     "/taxonInterpretation[roleCode=identifier,plantLevel=Subkingdom]/*_ID/plantConcept/*_ID/*/plantName","/taxondetermination[roleCode=identifier,plantLevel=Subkingdom]/*_ID/plantConcept/*_ID/*/plantName"
     "/taxonInterpretation[roleCode=identifier,plantLevel=Subspecies]/*_ID/plantConcept/*_ID/*/plantName","/taxondetermination[roleCode=identifier,plantLevel=Subspecies]/*_ID/plantConcept/*_ID/*/plantName"
     "/{taxonInterpretation[roleCode=collector]/museumAccessionNumber,*_ID/observation/*_ID/plot/authorPlotCode/_alt/3}","/{taxondetermination[roleCode=collector]/museumAccessionNumber,*_ID/plotevent/*_ID/plot/authorPlotCode/_alt/3}"
     "/{taxonInterpretation[roleCode=identifier]/*_ID/plantConcept/*_ID/*/plantName,taxonInterpretation[roleCode=collector]/*_ID/plantConcept/*_ID/*/plantName/_alt/1}","/{taxondetermination[roleCode=identifier]/*_ID/plantConcept/*_ID/*/plantName,taxondetermination[roleCode=collector]/*_ID/plantConcept/*_ID/*/plantName/_alt/1}"
     "/{taxonInterpretation[roleCode=identifier,plantLevel=Species]/*_ID/plantConcept/*_ID/*/plantName,taxonInterpretation[roleCode=collector]/*_ID/plantConcept/*_ID/*/plantName/_alt/2}","/{taxondetermination[roleCode=identifier,plantLevel=Species]/*_ID/plantConcept/*_ID/*/plantName,taxondetermination[roleCode=collector]/*_ID/plantConcept/*_ID/*/plantName/_alt/2}"

     /*ID->/*s/project/title,/*_ID/project/projectName
     ->/*s/communityDetermination[*ID]/communityConcepts/communityConcept/commonName,/commClass/commInterpretation/*_ID/commConcept/*_ID/*/commName
     ->/*s/communityDetermination[*ID]/communityConcepts/communityConcept/name,/commClass/commInterpretation/*_ID/commConcept/commDescription
     /simpleUserdefined[name=precipMm]/value,"/definedValue[*_ID/userDefined[tableName=observation,userDefinedName=precipitationMm]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
     /temperature,"/definedValue[*_ID/userDefined[tableName=observation,userDefinedName=temperatureC]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
     /simpleUserdefined[name=precipMm]/value,"/definedValue[*_ID/userDefined[tableName=plotevent,userDefinedName=precipitationMm]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
     /temperature,"/definedValue[*_ID/userDefined[tableName=plotevent,userDefinedName=temperatureC]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
     /simpleUserdefined[name=plotMethodology]/value,/methodNarrative
     /obsEndDate,/obsEndDate
     /obsEndDate/_date/year,/obsEndDate/_date/year

     /*ID->/*s/plotObservation/*ID->/*s/project/title,/*_ID/plotevent/*_ID/project/projectName
     /*ID->/*s/plotObservation->/*s/communityDetermination[*ID]/communityConcepts/communityConcept/commonName,/*_ID/plotevent/commClass/commInterpretation/*_ID/commConcept/*_ID/*/commName
     /*ID->/*s/plotObservation->/*s/communityDetermination[*ID]/communityConcepts/communityConcept/name,/*_ID/plotevent/commClass/commInterpretation/*_ID/commConcept/commDescription
     /*ID->/*s/plotObservation/simpleUserdefined[name=precipMm]/value,"/*_ID/plotevent/definedValue[*_ID/userDefined[tableName=observation,userDefinedName=precipitationMm]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
     /*ID->/*s/plotObservation/temperature,"/*_ID/plotevent/definedValue[*_ID/userDefined[tableName=observation,userDefinedName=temperatureC]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
     /*ID->/*s/plotObservation/simpleUserdefined[name=precipMm]/value,"/*_ID/plotevent/definedValue[*_ID/userDefined[tableName=plotevent,userDefinedName=precipitationMm]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
     /*ID->/*s/plotObservation/temperature,"/*_ID/plotevent/definedValue[*_ID/userDefined[tableName=plotevent,userDefinedName=temperatureC]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
     /*ID->/*s/plotObservation/simpleUserdefined[name=plotMethodology]/value,/*_ID/plotevent/methodNarrative
     /*ID->/*s/plotObservation/obsEndDate,/*_ID/plotevent/obsEndDate
     /*ID->/*s/plotObservation/obsEndDate/_date/year,/*_ID/plotevent/obsEndDate/_date/year
-...
     /simpleUserdefined[name=count]/value,/collectiveobs/*/stemCount
     /simpleUserdefined[name=coverPercent]/value,/collectiveobs/cover
     /simpleUserdefined[name=interceptCm]/value,"/collectiveobs/definedValue[*_ID/userDefined[tableName=collectiveobs,userDefinedName=interceptCm]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
     /diameterBaseDistance[baseDistance=1.37]/diameter,/collectiveobs/stemCount/stemDiameter
     /height,/collectiveobs/stemCount/stemHeight
     /simpleUserdefined[name=stemHeightM]/value,/collectiveobs/stemCount/stemHeight
     /simpleUserdefined[name=habitat]/value,"/collectiveobs/stemCount/individual/definedValue[*_ID/userDefined[tableName=individual,userDefinedName=habitat]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
     /simpleUserdefined[name=htFirstBranchM]/value,"/collectiveobs/stemCount/individual/definedValue[*_ID/userDefined[tableName=individual,userDefinedName=heightFirstBranchM]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
     /simpleUserdefined[name=plantFungusDescription]/value,"/collectiveobs/stemCount/individual/definedValue[*_ID/userDefined[tableName=individual,userDefinedName=plantFungusDescription]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
-...
     /*ID->/*s/individualOrganism/identificationLabel,/collectiveobs/stemCount/individual/stemCode
     /simpleUserdefined[name=xPosition]/value,/collectiveobs/stemCount/individual/stemXPosition
     /simpleUserdefined[name=yPosition]/value,/collectiveobs/stemCount/individual/stemYPosition
     /diameterBaseDistance[baseDistance=1.37]/diameter,/collectiveobs/stemCount/stemDiameter
     /height,/collectiveobs/stemCount/stemHeight
     /simpleUserdefined[name=stemHeightM]/value,/collectiveobs/stemCount/stemHeight
     /*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/authorCode,/taxondetermination[ROLE_ID/aux_Role/roleCode=collector]/collectionNumber
     "/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=collector]/partyWithRole/*ID->/parties/party/individualName/givenName","/taxondetermination[ROLE_ID/aux_Role/roleCode=collector]/collector_ID/party/{givenName/_namePart/first,middleName/_namePart/last}"
     "/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=collector]/partyWithRole/*ID->/parties/party/individualName/{givenName/_namePart/{first,middle},surName/_namePart/last}","/taxondetermination[ROLE_ID/aux_Role/roleCode=collector]/collector_ID/party/{givenName/_namePart/first,middleName/_namePart/middle,surName/_namePart/last}"

mappings/VegBank-VegBIEN.csv
	1	"VegBank","VegBIEN"
	2	"observation","plotevent"
	3	"taxonobservation","taxonoccurrence"
	4	"taxoninterpretation","taxondetermination"
	5	"stemlocation","individual"
	6	"taxonimportance","collectiveobs"
	7	"stratum","taxonbin"

     //project/title,//project/projectName
     //*s/communityDetermination/communityConcepts/communityConcept/commonName,//*/commName
     //*s/communityDetermination/communityConcepts/communityConcept/name,//commConcept/commDescription
     /simpleUserdefined[name=precipMm]/value,"/definedValue[*_ID/userDefined[tableName=observation,userDefinedName=precipitationMm]]/definedValue"
     /temperature,"/definedValue[*_ID/userDefined[tableName=observation,userDefinedName=temperatureC]]/definedValue"
     /simpleUserdefined[name=precipMm]/value,"/definedValue[*_ID/userDefined[tableName=plotevent,userDefinedName=precipitationMm]]/definedValue"
     /temperature,"/definedValue[*_ID/userDefined[tableName=plotevent,userDefinedName=temperatureC]]/definedValue"
     /simpleUserdefined[name=plotMethodology]/value,/methodNarrative
     /obsEndDate,/obsEndDate
     /obsEndDate/_date/year,/obsEndDate/_date/year

     //project/title,//project/projectName
     //*s/communityDetermination/communityConcepts/communityConcept/commonName,//*/commName
     //*s/communityDetermination/communityConcepts/communityConcept/name,//commConcept/commDescription
     //plotObservation/simpleUserdefined[name=precipMm]/value,"//plotevent/definedValue[*_ID/userDefined[tableName=observation,userDefinedName=precipitationMm]]/definedValue"
     //plotObservation/temperature,"//plotevent/definedValue[*_ID/userDefined[tableName=observation,userDefinedName=temperatureC]]/definedValue"
     //plotObservation/simpleUserdefined[name=precipMm]/value,"//plotevent/definedValue[*_ID/userDefined[tableName=plotevent,userDefinedName=precipitationMm]]/definedValue"
     //plotObservation/temperature,"//plotevent/definedValue[*_ID/userDefined[tableName=plotevent,userDefinedName=temperatureC]]/definedValue"
     //plotObservation/simpleUserdefined[name=plotMethodology]/value,//plotevent/methodNarrative
     //plotObservation/obsEndDate,//plotevent/obsEndDate
     //plotObservation/obsEndDate/_date/year,//plotevent/obsEndDate/_date/year
-...
     /simpleUserdefined[name=count]/value,//*/stemCount
     /simpleUserdefined[name=coverPercent]/value,//collectiveobs/cover
     /simpleUserdefined[name=interceptCm]/value,"//collectiveobs/definedValue[*_ID/userDefined[tableName=collectiveobs,userDefinedName=interceptCm]]/definedValue"
     /diameterBaseDistance[baseDistance=1.37]/diameter,//stemCount/stemDiameter
     /height,//stemCount/stemHeight
     /simpleUserdefined[name=stemHeightM]/value,//stemCount/stemHeight
     /simpleUserdefined[name=habitat]/value,"//individual/definedValue[*_ID/userDefined[tableName=individual,userDefinedName=habitat]]/definedValue"
     /simpleUserdefined[name=htFirstBranchM]/value,"//individual/definedValue[*_ID/userDefined[tableName=individual,userDefinedName=heightFirstBranchM]]/definedValue"
     /simpleUserdefined[name=plantFungusDescription]/value,"//individual/definedValue[*_ID/userDefined[tableName=individual,userDefinedName=plantFungusDescription]]/definedValue"
-...
     //individualOrganism/identificationLabel,//individual/stemCode
     /simpleUserdefined[name=xPosition]/value,//individual/stemXPosition
     /simpleUserdefined[name=yPosition]/value,//individual/stemYPosition
     /diameterBaseDistance[baseDistance=1.37]/diameter,//stemCount/stemDiameter
     /height,//stemCount/stemHeight
     /simpleUserdefined[name=stemHeightM]/value,//stemCount/stemHeight
     //taxonNameUsageConcept/authorCode,/taxondetermination[roleCode=collector]/collectionNumber
     //individualName/givenName,"/taxondetermination[roleCode=collector]/collector_ID/party/{givenName/_namePart/first,middleName/_namePart/last}"
     "//parties/party/individualName/{givenName/_namePart/{first,middle},surName/_namePart/last}","/taxondetermination[roleCode=collector]/collector_ID/party/{givenName/_namePart/first,middleName/_namePart/middle,surName/_namePart/last}"

     project,//project/projectName,
     life_zone_code,//*/commName,
     holdridge_life_zone,//commConcept/commDescription,
     precip_mm,"/definedValue[*_ID/userDefined[tableName=observation,userDefinedName=precipitationMm]]/definedValue",
     temp_c,"/definedValue[*_ID/userDefined[tableName=observation,userDefinedName=temperatureC]]/definedValue",
     precip_mm,"/definedValue[*_ID/userDefined[tableName=plotevent,userDefinedName=precipitationMm]]/definedValue",
     temp_c,"/definedValue[*_ID/userDefined[tableName=plotevent,userDefinedName=temperatureC]]/definedValue",
     plot_methodology,/methodNarrative,
     date_finish,/obsEndDate/_date/year,
     date_start,/obsStartDate/_date/year,

     project_id,//project/projectName,
     life_zone_code,//*/commName,
     life_zone,//commConcept/commDescription,
     Precip,"/definedValue[*_ID/userDefined[tableName=observation,userDefinedName=precipitationMm]]/definedValue",
     Temp,"/definedValue[*_ID/userDefined[tableName=observation,userDefinedName=temperatureC]]/definedValue",
     Precip,"/definedValue[*_ID/userDefined[tableName=plotevent,userDefinedName=precipitationMm]]/definedValue",
     Temp,"/definedValue[*_ID/userDefined[tableName=plotevent,userDefinedName=temperatureC]]/definedValue",
     PlotMethod,/methodNarrative,
     date_finish,/obsEndDate/_date/year,
     date_start,/obsStartDate/_date/year,

     project,/*_ID/project/projectName,
     life_zone_code,/commClass/commInterpretation/*_ID/commConcept/*_ID/*/commName,
     holdridge_life_zone,/commClass/commInterpretation/*_ID/commConcept/commDescription,
     precip_mm,"/definedValue[*_ID/userDefined[tableName=observation,userDefinedName=precipitationMm]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
     temp_c,"/definedValue[*_ID/userDefined[tableName=observation,userDefinedName=temperatureC]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
     precip_mm,"/definedValue[*_ID/userDefined[tableName=plotevent,userDefinedName=precipitationMm]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
     temp_c,"/definedValue[*_ID/userDefined[tableName=plotevent,userDefinedName=temperatureC]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
     plot_methodology,/methodNarrative,
     date_finish,/obsEndDate/_date/year,
     date_start,/obsStartDate/_date/year,

     project_id,/*_ID/project/projectName,
     life_zone_code,/commClass/commInterpretation/*_ID/commConcept/*_ID/*/commName,
     life_zone,/commClass/commInterpretation/*_ID/commConcept/commDescription,
     Precip,"/definedValue[*_ID/userDefined[tableName=observation,userDefinedName=precipitationMm]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
     Temp,"/definedValue[*_ID/userDefined[tableName=observation,userDefinedName=temperatureC]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
     Precip,"/definedValue[*_ID/userDefined[tableName=plotevent,userDefinedName=precipitationMm]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
     Temp,"/definedValue[*_ID/userDefined[tableName=plotevent,userDefinedName=temperatureC]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
     PlotMethod,/methodNarrative,
     date_finish,/obsEndDate/_date/year,
     date_start,/obsStartDate/_date/year,

Project

General

Profile

Revision 206

Added by Aaron Marcuse-Kubitza about 13 years ago