Project

General

Profile

« Previous | Next » 

Revision 188

Added basic VegX-VegBIEN mapping

View differences:

mappings/VegX-VegBIEN.plots.csv
1
VegX:/*s/plotObservation,VegBIEN:/plotevent
2
/*UniqueIdentifierID->/*s/plot/relatedSpatialItem/relatedItem[relationshipType=parentPlot]/relatedItemID->/*s/plot/plotUniqueIdentifier,/*_ID/plot/PARENT_ID/plot:[confidentialityStatus=0]/authorPlotCode/_alt/1
3
/*UniqueIdentifierID->/*s/plot/area,/*_ID/plot/area
4
/*UniqueIdentifierID->/*s/plot/geospatial/FootprintWKT,/*_ID/plot/dsgpoly
5
/*UniqueIdentifierID->/*s/plot/geospatial/verbatimElevation,/*_ID/plot/elevation
6
/*UniqueIdentifierID->/*s/plot/geospatial/CoordinateUncertaintyInMeters,/*_ID/plot/locationAccuracy
7
/*UniqueIdentifierID->/*s/plot/country,"/*_ID/plot/place(/*_ID/namedPlace[placeSystem=""area|country|territory""])/placeName"
8
/*UniqueIdentifierID->/*s/plot/state,"/*_ID/plot/place(/*_ID/namedPlace[placeSystem=""region|state|province""])/placeName"
9
/*UniqueIdentifierID->/*s/plot/simpleUserdefined[name=majorGeo]/value,/*_ID/plot/place(/*_ID/namedPlace[placeSystem=continent])/placeName
10
/*UniqueIdentifierID->/*s/plot/county,/*_ID/plot/place(/*_ID/namedPlace[placeSystem=county])/placeName
11
/*UniqueIdentifierID->/*s/plot/simpleUserdefined[name=localityDescription]/value,/*_ID/plot/place/*_ID/namedPlace/placeDescription
12
/*UniqueIdentifierID->/*s/plot/simpleUserdefined[name=locality]/value,/*_ID/plot/place/*_ID/namedPlace/placeDescription
13
/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLatitude,/*_ID/plot/realLatitude
14
/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLongitude,/*_ID/plot/realLongitude
15
/*UniqueIdentifierID->/*s/plot/slopeAspect,/*_ID/plot/slopeAspect
16
/*UniqueIdentifierID->/*s/plot/slopeGradient,/*_ID/plot/slopeGradient
17
/*UniqueIdentifierID->/*s/plot/geospatial/maximumElevationInMeters,"/*_ID/plot/{elevation/_avg/max,elevationRange/_range/to}"
18
/*UniqueIdentifierID->/*s/plot/geospatial/minimumElevationInMeters,"/*_ID/plot/{elevation/_avg/min,elevationRange/_range/from}"
19
/*ID->/*s/project/title,/*_ID/project/projectName
20
->/*s/communityDetermination[*ID]/communityConcepts/communityConcept/commonName,/commClass/commInterpretation/*_ID/commConcept/*_ID/*/commName
21
->/*s/communityDetermination[*ID]/communityConcepts/communityConcept/name,/commClass/commInterpretation/*_ID/commConcept/commDescription
22
/simpleUserdefined[name=precipMm]/value,"/definedValue[*_ID/userDefined[tableName=observation,userDefinedName=precipitationMm]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
23
/temperature,"/definedValue[*_ID/userDefined[tableName=observation,userDefinedName=temperatureC]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
24
/simpleUserdefined[name=plotMethodology]/value,/methodNarrative
25
/obsEndDate,/obsEndDate
26
/obsEndDate/_date/year,/obsEndDate/_date/year
27
/obsStartDate,/obsStartDate
28
/obsStartDate/_date/day,/obsStartDate/_date/day
29
/obsStartDate/_date/month,/obsStartDate/_date/month
30
/obsStartDate/_date/year,/obsStartDate/_date/year
31
->/*s/abioticObservation[*ID]/simpleUserdefined[name=acidity]/value,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilAcidity]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
32
->/*s/abioticObservation[*ID]/simpleUserdefined[name=base]/value,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilBase]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
33
->/*s/abioticObservation[*ID]/simpleUserdefined[name=calcium]/value,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilCalcium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
34
->/*s/abioticObservation[*ID]/simpleUserdefined[name=carbon]/value,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilCarbon]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
35
->/*s/abioticObservation[*ID]/simpleUserdefined[name=cationCap]/value,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilCationCap]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
36
->/*s/abioticObservation[*ID]/simpleUserdefined[name=conductivity]/value,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilConductivity]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
37
->/*s/abioticObservation[*ID]/magnesium,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilMagnesium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
38
->/*s/abioticObservation[*ID]/nitrogen,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilNitrogen]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
39
->/*s/abioticObservation[*ID]/phosphorus,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilPhosphorus]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
40
->/*s/abioticObservation[*ID]/pottasium,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilPotassium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
41
->/*s/abioticObservation[*ID]/simpleUserdefined[name=sodium]/value,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilSodium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
42
->/*s/abioticObservation[*ID]/simpleUserdefined[name=clayPercent]/value,/soilObs/soilClay
43
->/*s/abioticObservation[*ID]/simpleUserdefined[name=organicPercent]/value,/soilObs/soilOrganic
44
->/*s/abioticObservation[*ID]/ph,/soilObs/soilPH
45
->/*s/abioticObservation[*ID]/simpleUserdefined[name=sandPercent]/value,/soilObs/soilSand
46
->/*s/abioticObservation[*ID]/simpleUserdefined[name=siltPercent]/value,/soilObs/soilSilt
47
->/*s/abioticObservation[*ID]/simpleUserdefined[name=texture]/value,/soilObs/soilTexture
48
/*UniqueIdentifierID->/*s/plot/geospatial/maximumDepthInMeters,/waterDepth/max
49
/*UniqueIdentifierID->/*s/plot/geospatial/minimumDepthInMeters,/waterDepth/min
50
/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,"/{*_ID/plot:[confidentialityStatus=0]/authorPlotCode/_alt/2,authorObsCode}"
mappings/VegX-VegBIEN.organisms.csv
1
VegX:/*s/individualOrganismObservation,VegBIEN:/taxonObservation
2
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/relatedSpatialItem/relatedItem[relationshipType=parentPlot]/relatedItemID->/*s/plot/plotUniqueIdentifier,/*_ID/plotevent/*_ID/plot/PARENT_ID/plot:[confidentialityStatus=0]/authorPlotCode/_alt/1
3
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/area,/*_ID/plotevent/*_ID/plot/area
4
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/FootprintWKT,/*_ID/plotevent/*_ID/plot/dsgpoly
5
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/verbatimElevation,/*_ID/plotevent/*_ID/plot/elevation
6
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/CoordinateUncertaintyInMeters,/*_ID/plotevent/*_ID/plot/locationAccuracy
7
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/country,"/*_ID/plotevent/*_ID/plot/place(/*_ID/namedPlace[placeSystem=""area|country|territory""])/placeName"
8
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/state,"/*_ID/plotevent/*_ID/plot/place(/*_ID/namedPlace[placeSystem=""region|state|province""])/placeName"
9
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/simpleUserdefined[name=majorGeo]/value,/*_ID/plotevent/*_ID/plot/place(/*_ID/namedPlace[placeSystem=continent])/placeName
10
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/county,/*_ID/plotevent/*_ID/plot/place(/*_ID/namedPlace[placeSystem=county])/placeName
11
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/simpleUserdefined[name=localityDescription]/value,/*_ID/plotevent/*_ID/plot/place/*_ID/namedPlace/placeDescription
12
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/simpleUserdefined[name=locality]/value,/*_ID/plotevent/*_ID/plot/place/*_ID/namedPlace/placeDescription
13
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLatitude,/*_ID/plotevent/*_ID/plot/realLatitude
14
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLongitude,/*_ID/plotevent/*_ID/plot/realLongitude
15
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/slopeAspect,/*_ID/plotevent/*_ID/plot/slopeAspect
16
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/slopeGradient,/*_ID/plotevent/*_ID/plot/slopeGradient
17
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/maximumElevationInMeters,"/*_ID/plotevent/*_ID/plot/{elevation/_avg/max,elevationRange/_range/to}"
18
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/minimumElevationInMeters,"/*_ID/plotevent/*_ID/plot/{elevation/_avg/min,elevationRange/_range/from}"
19
/*ID->/*s/plotObservation/*ID->/*s/project/title,/*_ID/plotevent/*_ID/project/projectName
20
/*ID->/*s/plotObservation->/*s/communityDetermination[*ID]/communityConcepts/communityConcept/commonName,/*_ID/plotevent/commClass/commInterpretation/*_ID/commConcept/*_ID/*/commName
21
/*ID->/*s/plotObservation->/*s/communityDetermination[*ID]/communityConcepts/communityConcept/name,/*_ID/plotevent/commClass/commInterpretation/*_ID/commConcept/commDescription
22
/*ID->/*s/plotObservation/simpleUserdefined[name=precipMm]/value,"/*_ID/plotevent/definedValue[*_ID/userDefined[tableName=observation,userDefinedName=precipitationMm]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
23
/*ID->/*s/plotObservation/temperature,"/*_ID/plotevent/definedValue[*_ID/userDefined[tableName=observation,userDefinedName=temperatureC]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
24
/*ID->/*s/plotObservation/simpleUserdefined[name=plotMethodology]/value,/*_ID/plotevent/methodNarrative
25
/*ID->/*s/plotObservation/obsEndDate,/*_ID/plotevent/obsEndDate
26
/*ID->/*s/plotObservation/obsEndDate/_date/year,/*_ID/plotevent/obsEndDate/_date/year
27
/*ID->/*s/plotObservation/obsStartDate,/*_ID/plotevent/obsStartDate
28
/*ID->/*s/plotObservation/obsStartDate/_date/day,/*_ID/plotevent/obsStartDate/_date/day
29
/*ID->/*s/plotObservation/obsStartDate/_date/month,/*_ID/plotevent/obsStartDate/_date/month
30
/*ID->/*s/plotObservation/obsStartDate/_date/year,/*_ID/plotevent/obsStartDate/_date/year
31
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=acidity]/value,"/*_ID/plotevent/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilAcidity]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
32
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=base]/value,"/*_ID/plotevent/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilBase]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
33
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=calcium]/value,"/*_ID/plotevent/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilCalcium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
34
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=carbon]/value,"/*_ID/plotevent/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilCarbon]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
35
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=cationCap]/value,"/*_ID/plotevent/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilCationCap]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
36
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=conductivity]/value,"/*_ID/plotevent/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilConductivity]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
37
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/magnesium,"/*_ID/plotevent/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilMagnesium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
38
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/nitrogen,"/*_ID/plotevent/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilNitrogen]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
39
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/phosphorus,"/*_ID/plotevent/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilPhosphorus]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
40
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/pottasium,"/*_ID/plotevent/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilPotassium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
41
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=sodium]/value,"/*_ID/plotevent/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilSodium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
42
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=clayPercent]/value,/*_ID/plotevent/soilObs/soilClay
43
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=organicPercent]/value,/*_ID/plotevent/soilObs/soilOrganic
44
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/ph,/*_ID/plotevent/soilObs/soilPH
45
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=sandPercent]/value,/*_ID/plotevent/soilObs/soilSand
46
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=siltPercent]/value,/*_ID/plotevent/soilObs/soilSilt
47
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=texture]/value,/*_ID/plotevent/soilObs/soilTexture
48
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/maximumDepthInMeters,/*_ID/plotevent/waterDepth/max
49
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/minimumDepthInMeters,/*_ID/plotevent/waterDepth/min
50
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,"/*_ID/plotevent/{*_ID/plot:[confidentialityStatus=0]/authorPlotCode/_alt/2,authorObsCode}"
51
/simpleUserdefined[name=count]/value,/taxonImportance/*/stemCount
52
/simpleUserdefined[name=coverPercent]/value,/taxonImportance/cover
53
/simpleUserdefined[name=interceptCm]/value,"/taxonImportance/definedValue[*_ID/userDefined[tableName=taxonImportance,userDefinedName=interceptCm]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
54
/diameterBaseDistance[baseDistance=1.37]/diameter,/taxonImportance/stemCount/stemDiameter
55
/height,/taxonImportance/stemCount/stemHeight
56
/simpleUserdefined[name=stemHeightM]/value,/taxonImportance/stemCount/stemHeight
57
/simpleUserdefined[name=habitat]/value,"/taxonImportance/stemCount/stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=habitat]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
58
/simpleUserdefined[name=htFirstBranchM]/value,"/taxonImportance/stemCount/stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=heightFirstBranchM]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
59
/simpleUserdefined[name=plantFungusDescription]/value,"/taxonImportance/stemCount/stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=plantFungusDescription]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
60
/diameterBaseDistance[baseDistance=0]/diameter,"/taxonImportance/stemCount/stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=stemBasalDiameter]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
61
/simpleUserdefined[name=stemCanopyForm]/value,"/taxonImportance/stemCount/stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=stemCanopyForm]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
62
/simpleUserdefined[name=stemCanopyPosition]/value,"/taxonImportance/stemCount/stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=stemCanopyPosition]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
63
/simpleUserdefined[name=stemHeightFirstBranchM]/value,"/taxonImportance/stemCount/stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=stemHeightFirstBranchM]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
64
/simpleUserdefined[name=stemLianaInfestation]/value,"/taxonImportance/stemCount/stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=stemLianaInfestation]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
65
/simpleUserdefined[name=substrate]/value,"/taxonImportance/stemCount/stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=substrate]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
66
/simpleUserdefined[name=vegetation]/value,"/taxonImportance/stemCount/stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=vegetation]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
67
/*ID->/*s/individualOrganism/identificationLabel,/taxonImportance/stemCount/stemLocation/stemCode
68
/simpleUserdefined[name=xPosition]/value,/taxonImportance/stemCount/stemLocation/stemXPosition
69
/simpleUserdefined[name=yPosition]/value,/taxonImportance/stemCount/stemLocation/stemYPosition
70
/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/authorCode,/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/collectionNumber
71
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=collector]/partyWithRole/*ID->/parties/party/individualName/givenName","/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/collector_ID/party/{givenName/_namePart/first,middleName/_namePart/last}"
72
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=collector]/partyWithRole/*ID->/parties/party/individualName/{givenName/_namePart/{first,middle},surName/_namePart/last}","/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/collector_ID/party/{givenName/_namePart/first,middleName/_namePart/middle,surName/_namePart/last}"
73
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=collector]/partyWithRole/*ID->/parties/party/individualName/surName",/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/collector_ID/party/{surName}
74
/simpleUserdefined[name=censusNo]/value,"/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/definedValue[*_ID/userDefined[tableName=taxonInterpretation,userDefinedName=censusNo]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
75
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/note","/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/definedValue[*_ID/userDefined[tableName=taxonInterpretation,userDefinedName=cfAff]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
76
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=collector]/groupType","/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/definedValue[*_ID/userDefined[tableName=taxonInterpretation,userDefinedName=determinationType]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
77
/simpleUserdefined[name=habit]/value,"/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/definedValue[*_ID/userDefined[tableName=taxonInterpretation,userDefinedName=habit]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
78
/simpleUserdefined[name=individualCode]/value,"/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/definedValue[*_ID/userDefined[tableName=taxonInterpretation,userDefinedName=individualCode]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
79
/*ID->/*s/individualOrganism/simpleUserdefined[name=sex]/value,"/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/definedValue[*_ID/userDefined[tableName=taxonInterpretation,userDefinedName=sex]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
80
/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/partyWithRole/*ID->/parties/party/organizationName,/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/museum_ID/party/OrganizationName
81
/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/partyWithRole/*ID->/parties/party/organizationName/_name/first,/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/museum_ID/party/OrganizationName/_name/first
82
/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/partyWithRole/*ID->/parties/party/organizationName/_name/last,/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/museum_ID/party/OrganizationName/_name/last
83
/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/note/text,/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/notes
84
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=fam])/Name","/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"
85
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=gen])/Name","/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"
86
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=sp])/AccordingTo/Simple","/taxonInterpretation[ROLE_ID/aux_Role/roleCode=computer,*_ID/plantConcept/plantStatus/plantLevel=Species]/*_ID/plantConcept/*_ID/plantName/reference_ID/reference/shortName"
87
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=sp])/Name","/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"
88
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=TaxonomicRankBelowSubspeciesEnum])/Rank","/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"
89
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=TaxonomicRankBelowSubspeciesEnum])/Name","/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"
90
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/date/_date/day","/taxonInterpretation[ROLE_ID/aux_Role/roleCode=identifier,!*_ID/plantConcept/plantStatus]/interpretationDate/_date/day"
91
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/date/_date/month","/taxonInterpretation[ROLE_ID/aux_Role/roleCode=identifier,!*_ID/plantConcept/plantStatus]/interpretationDate/_date/month"
92
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/date/_date/year","/taxonInterpretation[ROLE_ID/aux_Role/roleCode=identifier,!*_ID/plantConcept/plantStatus]/interpretationDate/_date/year"
93
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/partyWithRole/*ID->/parties/party/individualName/{givenName/_namePart/{first,middle},surName/_namePart/last}","/taxonInterpretation[ROLE_ID/aux_Role/roleCode=identifier,!*_ID/plantConcept/plantStatus]:[interpretationType=Author,originalInterpretation=false,currentInterpretation=true]/*_ID/party/{givenName/_namePart/first,middleName/_namePart/middle,surName/_namePart/last}"
94
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=cl])/Name","/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"
95
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=fam])/Name","/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"
96
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=gen])/Name","/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"
97
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=reg])/Name","/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"
98
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=ord])/Name","/taxonInterpretation[ROLE_ID/aux_Role/roleCode=identifier,*_ID/plantConcept/plantStatus/plantLevel=Order]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=true,interpretationDate=epoch,*_ID/party]/*_ID/plantConcept:[plantStatus:[plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference]/*_ID/*/plantName"
99
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=sp])/AccordingTo/Simple","/taxonInterpretation[ROLE_ID/aux_Role/roleCode=identifier,*_ID/plantConcept/plantStatus/plantLevel=Species]/*_ID/plantConcept/*_ID/reference/referenceContributor/*_ID/referenceParty/{givenName,surname}"
100
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=phyl_div])/Name","/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"
101
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=ssp])/Name","/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"
102
/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/voucher,"/{taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=false,interpretationDate=epoch,*_ID/plantConcept:[*_ID/reference],*_ID/party]/museumAccessionNumber,*_ID/plotevent/*_ID/plot:[confidentialityStatus=0]/authorPlotCode/_alt/3}"
103
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonName)/Simple","/{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/_alt/1}"
104
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=sp])/Name","/{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,taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/*_ID/plantConcept/*_ID/*/plantName/_alt/2}"
mappings/VegBank-VegBIEN.organisms.csv
1
"VegBank:/taxonObservation","VegBIEN:/taxonObservation"
2
"/*_ID/observation/*_ID/plot/PARENT_ID/plot:[confidentialityStatus=0]/authorPlotCode/_alt/1","/*_ID/plotevent/*_ID/plot/PARENT_ID/plot:[confidentialityStatus=0]/authorPlotCode/_alt/1"
3
"/*_ID/observation/*_ID/plot/area","/*_ID/plotevent/*_ID/plot/area"
4
"/*_ID/observation/*_ID/plot/dsgpoly","/*_ID/plotevent/*_ID/plot/dsgpoly"
5
"/*_ID/observation/*_ID/plot/elevation","/*_ID/plotevent/*_ID/plot/elevation"
6
"/*_ID/observation/*_ID/plot/locationAccuracy","/*_ID/plotevent/*_ID/plot/locationAccuracy"
7
"/*_ID/observation/*_ID/plot/place(/*_ID/namedPlace[placeSystem=""area|country|territory""])/placeName","/*_ID/plotevent/*_ID/plot/place(/*_ID/namedPlace[placeSystem=""area|country|territory""])/placeName"
8
"/*_ID/observation/*_ID/plot/place(/*_ID/namedPlace[placeSystem=""region|state|province""])/placeName","/*_ID/plotevent/*_ID/plot/place(/*_ID/namedPlace[placeSystem=""region|state|province""])/placeName"
9
"/*_ID/observation/*_ID/plot/place(/*_ID/namedPlace[placeSystem=continent])/placeName","/*_ID/plotevent/*_ID/plot/place(/*_ID/namedPlace[placeSystem=continent])/placeName"
10
"/*_ID/observation/*_ID/plot/place(/*_ID/namedPlace[placeSystem=county])/placeName","/*_ID/plotevent/*_ID/plot/place(/*_ID/namedPlace[placeSystem=county])/placeName"
11
"/*_ID/observation/*_ID/plot/place/*_ID/namedPlace/placeDescription","/*_ID/plotevent/*_ID/plot/place/*_ID/namedPlace/placeDescription"
12
"/*_ID/observation/*_ID/plot/place/*_ID/namedPlace/placeDescription","/*_ID/plotevent/*_ID/plot/place/*_ID/namedPlace/placeDescription"
13
"/*_ID/observation/*_ID/plot/realLatitude","/*_ID/plotevent/*_ID/plot/realLatitude"
14
"/*_ID/observation/*_ID/plot/realLongitude","/*_ID/plotevent/*_ID/plot/realLongitude"
15
"/*_ID/observation/*_ID/plot/slopeAspect","/*_ID/plotevent/*_ID/plot/slopeAspect"
16
"/*_ID/observation/*_ID/plot/slopeGradient","/*_ID/plotevent/*_ID/plot/slopeGradient"
17
"/*_ID/observation/*_ID/plot/{elevation/_avg/max,elevationRange/_range/to}","/*_ID/plotevent/*_ID/plot/{elevation/_avg/max,elevationRange/_range/to}"
18
"/*_ID/observation/*_ID/plot/{elevation/_avg/min,elevationRange/_range/from}","/*_ID/plotevent/*_ID/plot/{elevation/_avg/min,elevationRange/_range/from}"
19
"/*_ID/observation/*_ID/project/projectName","/*_ID/plotevent/*_ID/project/projectName"
20
"/*_ID/observation/commClass/commInterpretation/*_ID/commConcept/*_ID/*/commName","/*_ID/plotevent/commClass/commInterpretation/*_ID/commConcept/*_ID/*/commName"
21
"/*_ID/observation/commClass/commInterpretation/*_ID/commConcept/commDescription","/*_ID/plotevent/commClass/commInterpretation/*_ID/commConcept/commDescription"
22
"/*_ID/observation/definedValue[*_ID/userDefined[tableName=observation,userDefinedName=precipitationMm]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue","/*_ID/plotevent/definedValue[*_ID/userDefined[tableName=observation,userDefinedName=precipitationMm]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
23
"/*_ID/observation/definedValue[*_ID/userDefined[tableName=observation,userDefinedName=temperatureC]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue","/*_ID/plotevent/definedValue[*_ID/userDefined[tableName=observation,userDefinedName=temperatureC]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
24
"/*_ID/observation/methodNarrative","/*_ID/plotevent/methodNarrative"
25
"/*_ID/observation/obsEndDate","/*_ID/plotevent/obsEndDate"
26
"/*_ID/observation/obsEndDate/_date/year","/*_ID/plotevent/obsEndDate/_date/year"
27
"/*_ID/observation/obsStartDate","/*_ID/plotevent/obsStartDate"
28
"/*_ID/observation/obsStartDate/_date/day","/*_ID/plotevent/obsStartDate/_date/day"
29
"/*_ID/observation/obsStartDate/_date/month","/*_ID/plotevent/obsStartDate/_date/month"
30
"/*_ID/observation/obsStartDate/_date/year","/*_ID/plotevent/obsStartDate/_date/year"
31
"/*_ID/observation/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilAcidity]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue","/*_ID/plotevent/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilAcidity]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
32
"/*_ID/observation/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilBase]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue","/*_ID/plotevent/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilBase]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
33
"/*_ID/observation/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilCalcium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue","/*_ID/plotevent/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilCalcium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
34
"/*_ID/observation/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilCarbon]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue","/*_ID/plotevent/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilCarbon]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
35
"/*_ID/observation/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilCationCap]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue","/*_ID/plotevent/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilCationCap]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
36
"/*_ID/observation/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilConductivity]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue","/*_ID/plotevent/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilConductivity]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
37
"/*_ID/observation/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilMagnesium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue","/*_ID/plotevent/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilMagnesium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
38
"/*_ID/observation/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilNitrogen]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue","/*_ID/plotevent/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilNitrogen]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
39
"/*_ID/observation/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilPhosphorus]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue","/*_ID/plotevent/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilPhosphorus]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
40
"/*_ID/observation/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilPotassium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue","/*_ID/plotevent/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilPotassium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
41
"/*_ID/observation/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilSodium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue","/*_ID/plotevent/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilSodium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
42
"/*_ID/observation/soilObs/soilClay","/*_ID/plotevent/soilObs/soilClay"
43
"/*_ID/observation/soilObs/soilOrganic","/*_ID/plotevent/soilObs/soilOrganic"
44
"/*_ID/observation/soilObs/soilPH","/*_ID/plotevent/soilObs/soilPH"
45
"/*_ID/observation/soilObs/soilSand","/*_ID/plotevent/soilObs/soilSand"
46
"/*_ID/observation/soilObs/soilSilt","/*_ID/plotevent/soilObs/soilSilt"
47
"/*_ID/observation/soilObs/soilTexture","/*_ID/plotevent/soilObs/soilTexture"
48
"/*_ID/observation/waterDepth/max","/*_ID/plotevent/waterDepth/max"
49
"/*_ID/observation/waterDepth/min","/*_ID/plotevent/waterDepth/min"
50
"/*_ID/observation/{*_ID/plot:[confidentialityStatus=0]/authorPlotCode/_alt/2,authorObsCode}","/*_ID/plotevent/{*_ID/plot:[confidentialityStatus=0]/authorPlotCode/_alt/2,authorObsCode}"
51
"/taxonImportance/*/stemCount","/taxonImportance/*/stemCount"
52
"/taxonImportance/cover","/taxonImportance/cover"
53
"/taxonImportance/definedValue[*_ID/userDefined[tableName=taxonImportance,userDefinedName=interceptCm]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue","/taxonImportance/definedValue[*_ID/userDefined[tableName=taxonImportance,userDefinedName=interceptCm]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
54
"/taxonImportance/stemCount/stemDiameter","/taxonImportance/stemCount/stemDiameter"
55
"/taxonImportance/stemCount/stemHeight","/taxonImportance/stemCount/stemHeight"
56
"/taxonImportance/stemCount/stemHeight","/taxonImportance/stemCount/stemHeight"
57
"/taxonImportance/stemCount/stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=habitat]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue","/taxonImportance/stemCount/stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=habitat]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
58
"/taxonImportance/stemCount/stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=heightFirstBranchM]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue","/taxonImportance/stemCount/stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=heightFirstBranchM]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
59
"/taxonImportance/stemCount/stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=plantFungusDescription]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue","/taxonImportance/stemCount/stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=plantFungusDescription]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
60
"/taxonImportance/stemCount/stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=stemBasalDiameter]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue","/taxonImportance/stemCount/stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=stemBasalDiameter]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
61
"/taxonImportance/stemCount/stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=stemCanopyForm]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue","/taxonImportance/stemCount/stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=stemCanopyForm]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
62
"/taxonImportance/stemCount/stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=stemCanopyPosition]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue","/taxonImportance/stemCount/stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=stemCanopyPosition]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
63
"/taxonImportance/stemCount/stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=stemHeightFirstBranchM]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue","/taxonImportance/stemCount/stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=stemHeightFirstBranchM]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
64
"/taxonImportance/stemCount/stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=stemLianaInfestation]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue","/taxonImportance/stemCount/stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=stemLianaInfestation]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
65
"/taxonImportance/stemCount/stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=substrate]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue","/taxonImportance/stemCount/stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=substrate]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
66
"/taxonImportance/stemCount/stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=vegetation]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue","/taxonImportance/stemCount/stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=vegetation]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
67
"/taxonImportance/stemCount/stemLocation/stemCode","/taxonImportance/stemCount/stemLocation/stemCode"
68
"/taxonImportance/stemCount/stemLocation/stemXPosition","/taxonImportance/stemCount/stemLocation/stemXPosition"
69
"/taxonImportance/stemCount/stemLocation/stemYPosition","/taxonImportance/stemCount/stemLocation/stemYPosition"
70
"/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/collectionNumber","/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/collectionNumber"
71
"/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/collector_ID/party/{givenName/_namePart/first,middleName/_namePart/last}","/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/collector_ID/party/{givenName/_namePart/first,middleName/_namePart/last}"
72
"/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/collector_ID/party/{givenName/_namePart/first,middleName/_namePart/middle,surName/_namePart/last}","/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/collector_ID/party/{givenName/_namePart/first,middleName/_namePart/middle,surName/_namePart/last}"
73
"/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/collector_ID/party/{surName}","/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/collector_ID/party/{surName}"
74
"/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/definedValue[*_ID/userDefined[tableName=taxonInterpretation,userDefinedName=censusNo]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue","/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/definedValue[*_ID/userDefined[tableName=taxonInterpretation,userDefinedName=censusNo]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
75
"/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/definedValue[*_ID/userDefined[tableName=taxonInterpretation,userDefinedName=cfAff]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue","/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/definedValue[*_ID/userDefined[tableName=taxonInterpretation,userDefinedName=cfAff]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
76
"/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/definedValue[*_ID/userDefined[tableName=taxonInterpretation,userDefinedName=determinationType]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue","/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/definedValue[*_ID/userDefined[tableName=taxonInterpretation,userDefinedName=determinationType]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
77
"/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/definedValue[*_ID/userDefined[tableName=taxonInterpretation,userDefinedName=habit]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue","/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/definedValue[*_ID/userDefined[tableName=taxonInterpretation,userDefinedName=habit]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
78
"/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/definedValue[*_ID/userDefined[tableName=taxonInterpretation,userDefinedName=individualCode]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue","/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/definedValue[*_ID/userDefined[tableName=taxonInterpretation,userDefinedName=individualCode]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
79
"/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/definedValue[*_ID/userDefined[tableName=taxonInterpretation,userDefinedName=sex]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue","/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/definedValue[*_ID/userDefined[tableName=taxonInterpretation,userDefinedName=sex]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
80
"/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/museum_ID/party/OrganizationName","/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/museum_ID/party/OrganizationName"
81
"/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/museum_ID/party/OrganizationName/_name/first","/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/museum_ID/party/OrganizationName/_name/first"
82
"/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/museum_ID/party/OrganizationName/_name/last","/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/museum_ID/party/OrganizationName/_name/last"
83
"/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/notes","/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/notes"
84
"/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","/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"
85
"/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","/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"
86
"/taxonInterpretation[ROLE_ID/aux_Role/roleCode=computer,*_ID/plantConcept/plantStatus/plantLevel=Species]/*_ID/plantConcept/*_ID/plantName/reference_ID/reference/shortName","/taxonInterpretation[ROLE_ID/aux_Role/roleCode=computer,*_ID/plantConcept/plantStatus/plantLevel=Species]/*_ID/plantConcept/*_ID/plantName/reference_ID/reference/shortName"
87
"/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","/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"
88
"/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","/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"
89
"/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","/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"
90
"/taxonInterpretation[ROLE_ID/aux_Role/roleCode=identifier,!*_ID/plantConcept/plantStatus]/interpretationDate/_date/day","/taxonInterpretation[ROLE_ID/aux_Role/roleCode=identifier,!*_ID/plantConcept/plantStatus]/interpretationDate/_date/day"
91
"/taxonInterpretation[ROLE_ID/aux_Role/roleCode=identifier,!*_ID/plantConcept/plantStatus]/interpretationDate/_date/month","/taxonInterpretation[ROLE_ID/aux_Role/roleCode=identifier,!*_ID/plantConcept/plantStatus]/interpretationDate/_date/month"
92
"/taxonInterpretation[ROLE_ID/aux_Role/roleCode=identifier,!*_ID/plantConcept/plantStatus]/interpretationDate/_date/year","/taxonInterpretation[ROLE_ID/aux_Role/roleCode=identifier,!*_ID/plantConcept/plantStatus]/interpretationDate/_date/year"
93
"/taxonInterpretation[ROLE_ID/aux_Role/roleCode=identifier,!*_ID/plantConcept/plantStatus]:[interpretationType=Author,originalInterpretation=false,currentInterpretation=true]/*_ID/party/{givenName/_namePart/first,middleName/_namePart/middle,surName/_namePart/last}","/taxonInterpretation[ROLE_ID/aux_Role/roleCode=identifier,!*_ID/plantConcept/plantStatus]:[interpretationType=Author,originalInterpretation=false,currentInterpretation=true]/*_ID/party/{givenName/_namePart/first,middleName/_namePart/middle,surName/_namePart/last}"
94
"/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","/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"
95
"/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","/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"
96
"/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","/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"
97
"/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","/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"
98
"/taxonInterpretation[ROLE_ID/aux_Role/roleCode=identifier,*_ID/plantConcept/plantStatus/plantLevel=Order]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=true,interpretationDate=epoch,*_ID/party]/*_ID/plantConcept:[plantStatus:[plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference]/*_ID/*/plantName","/taxonInterpretation[ROLE_ID/aux_Role/roleCode=identifier,*_ID/plantConcept/plantStatus/plantLevel=Order]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=true,interpretationDate=epoch,*_ID/party]/*_ID/plantConcept:[plantStatus:[plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference]/*_ID/*/plantName"
99
"/taxonInterpretation[ROLE_ID/aux_Role/roleCode=identifier,*_ID/plantConcept/plantStatus/plantLevel=Species]/*_ID/plantConcept/*_ID/reference/referenceContributor/*_ID/referenceParty/{givenName,surname}","/taxonInterpretation[ROLE_ID/aux_Role/roleCode=identifier,*_ID/plantConcept/plantStatus/plantLevel=Species]/*_ID/plantConcept/*_ID/reference/referenceContributor/*_ID/referenceParty/{givenName,surname}"
100
"/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","/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"
101
"/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","/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"
102
"/{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}","/{taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=false,interpretationDate=epoch,*_ID/plantConcept:[*_ID/reference],*_ID/party]/museumAccessionNumber,*_ID/plotevent/*_ID/plot:[confidentialityStatus=0]/authorPlotCode/_alt/3}"
103
"/{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/_alt/1}","/{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/_alt/1}"
104
"/{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,taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/*_ID/plantConcept/*_ID/*/plantName/_alt/2}","/{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,taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/*_ID/plantConcept/*_ID/*/plantName/_alt/2}"
mappings/for_review/VegX-VegBIEN.plots.csv
1
VegX:/*s/plotObservation,VegBIEN:/plotevent
2
//plot/plotUniqueIdentifier,//plot/authorPlotCode/_alt/1
3
//plot/area,//plot/area
4
//geospatial/FootprintWKT,//plot/dsgpoly
5
//geospatial/verbatimElevation,//plot/elevation
6
//geospatial/CoordinateUncertaintyInMeters,//plot/locationAccuracy
7
//plot/country,"//*_ID/namedPlace[placeSystem=""area|country|territory""]/placeName"
8
//plot/state,"//*_ID/namedPlace[placeSystem=""region|state|province""]/placeName"
9
//plot/simpleUserdefined[name=majorGeo]/value,//*_ID/namedPlace[placeSystem=continent]/placeName
10
//plot/county,//*_ID/namedPlace[placeSystem=county]/placeName
11
//plot/simpleUserdefined[name=localityDescription]/value,//namedPlace/placeDescription
12
//plot/simpleUserdefined[name=locality]/value,//namedPlace/placeDescription
13
//geospatial/DecimalLatitude,//plot/realLatitude
14
//geospatial/DecimalLongitude,//plot/realLongitude
15
//plot/slopeAspect,//plot/slopeAspect
16
//plot/slopeGradient,//plot/slopeGradient
17
//geospatial/maximumElevationInMeters,"/*_ID/plot/{elevation/_avg/max,elevationRange/_range/to}"
18
//geospatial/minimumElevationInMeters,"/*_ID/plot/{elevation/_avg/min,elevationRange/_range/from}"
19
//project/title,//project/projectName
20
//*s/communityDetermination/communityConcepts/communityConcept/commonName,//*/commName
21
//*s/communityDetermination/communityConcepts/communityConcept/name,//commConcept/commDescription
22
/simpleUserdefined[name=precipMm]/value,"/definedValue[*_ID/userDefined[tableName=observation,userDefinedName=precipitationMm]]/definedValue"
23
/temperature,"/definedValue[*_ID/userDefined[tableName=observation,userDefinedName=temperatureC]]/definedValue"
24
/simpleUserdefined[name=plotMethodology]/value,/methodNarrative
25
/obsEndDate,/obsEndDate
26
/obsEndDate/_date/year,/obsEndDate/_date/year
27
/obsStartDate,/obsStartDate
28
/obsStartDate/_date/day,/obsStartDate/_date/day
29
/obsStartDate/_date/month,/obsStartDate/_date/month
30
/obsStartDate/_date/year,/obsStartDate/_date/year
31
//*s/abioticObservation/simpleUserdefined[name=acidity]/value,"//soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilAcidity]]/definedValue"
32
//*s/abioticObservation/simpleUserdefined[name=base]/value,"//soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilBase]]/definedValue"
33
//*s/abioticObservation/simpleUserdefined[name=calcium]/value,"//soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilCalcium]]/definedValue"
34
//*s/abioticObservation/simpleUserdefined[name=carbon]/value,"//soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilCarbon]]/definedValue"
35
//*s/abioticObservation/simpleUserdefined[name=cationCap]/value,"//soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilCationCap]]/definedValue"
36
//*s/abioticObservation/simpleUserdefined[name=conductivity]/value,"//soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilConductivity]]/definedValue"
37
//*s/abioticObservation/magnesium,"//soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilMagnesium]]/definedValue"
38
//*s/abioticObservation/nitrogen,"//soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilNitrogen]]/definedValue"
39
//*s/abioticObservation/phosphorus,"//soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilPhosphorus]]/definedValue"
40
//*s/abioticObservation/pottasium,"//soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilPotassium]]/definedValue"
41
//*s/abioticObservation/simpleUserdefined[name=sodium]/value,"//soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilSodium]]/definedValue"
42
//*s/abioticObservation/simpleUserdefined[name=clayPercent]/value,//soilObs/soilClay
43
//*s/abioticObservation/simpleUserdefined[name=organicPercent]/value,//soilObs/soilOrganic
44
//*s/abioticObservation/ph,//soilObs/soilPH
45
//*s/abioticObservation/simpleUserdefined[name=sandPercent]/value,//soilObs/soilSand
46
//*s/abioticObservation/simpleUserdefined[name=siltPercent]/value,//soilObs/soilSilt
47
//*s/abioticObservation/simpleUserdefined[name=texture]/value,//soilObs/soilTexture
48
//geospatial/maximumDepthInMeters,//waterDepth/max
49
//geospatial/minimumDepthInMeters,//waterDepth/min
50
//plot/plotUniqueIdentifier,"/{*_ID/plot/authorPlotCode/_alt/2,authorObsCode}"
mappings/for_review/VegX-VegBIEN.organisms.csv
1
VegX:/*s/individualOrganismObservation,VegBIEN:/taxonObservation
2
//plot/plotUniqueIdentifier,//plot/authorPlotCode/_alt/1
3
//plot/area,//plot/area
4
//geospatial/FootprintWKT,//plot/dsgpoly
5
//geospatial/verbatimElevation,//plot/elevation
6
//geospatial/CoordinateUncertaintyInMeters,//plot/locationAccuracy
7
//plot/country,"//*_ID/namedPlace[placeSystem=""area|country|territory""]/placeName"
8
//plot/state,"//*_ID/namedPlace[placeSystem=""region|state|province""]/placeName"
9
//plot/simpleUserdefined[name=majorGeo]/value,//*_ID/namedPlace[placeSystem=continent]/placeName
10
//plot/county,//*_ID/namedPlace[placeSystem=county]/placeName
11
//plot/simpleUserdefined[name=localityDescription]/value,//namedPlace/placeDescription
12
//plot/simpleUserdefined[name=locality]/value,//namedPlace/placeDescription
13
//geospatial/DecimalLatitude,//plot/realLatitude
14
//geospatial/DecimalLongitude,//plot/realLongitude
15
//plot/slopeAspect,//plot/slopeAspect
16
//plot/slopeGradient,//plot/slopeGradient
17
//geospatial/maximumElevationInMeters,"/*_ID/plotevent/*_ID/plot/{elevation/_avg/max,elevationRange/_range/to}"
18
//geospatial/minimumElevationInMeters,"/*_ID/plotevent/*_ID/plot/{elevation/_avg/min,elevationRange/_range/from}"
19
//project/title,//project/projectName
20
//*s/communityDetermination/communityConcepts/communityConcept/commonName,//*/commName
21
//*s/communityDetermination/communityConcepts/communityConcept/name,//commConcept/commDescription
22
//plotObservation/simpleUserdefined[name=precipMm]/value,"//plotevent/definedValue[*_ID/userDefined[tableName=observation,userDefinedName=precipitationMm]]/definedValue"
23
//plotObservation/temperature,"//plotevent/definedValue[*_ID/userDefined[tableName=observation,userDefinedName=temperatureC]]/definedValue"
24
//plotObservation/simpleUserdefined[name=plotMethodology]/value,//plotevent/methodNarrative
25
//plotObservation/obsEndDate,//plotevent/obsEndDate
26
//plotObservation/obsEndDate/_date/year,//plotevent/obsEndDate/_date/year
27
//plotObservation/obsStartDate,//plotevent/obsStartDate
28
//plotObservation/obsStartDate/_date/day,//plotevent/obsStartDate/_date/day
29
//plotObservation/obsStartDate/_date/month,//plotevent/obsStartDate/_date/month
30
//plotObservation/obsStartDate/_date/year,//plotevent/obsStartDate/_date/year
31
//*s/abioticObservation/simpleUserdefined[name=acidity]/value,"//soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilAcidity]]/definedValue"
32
//*s/abioticObservation/simpleUserdefined[name=base]/value,"//soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilBase]]/definedValue"
33
//*s/abioticObservation/simpleUserdefined[name=calcium]/value,"//soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilCalcium]]/definedValue"
34
//*s/abioticObservation/simpleUserdefined[name=carbon]/value,"//soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilCarbon]]/definedValue"
35
//*s/abioticObservation/simpleUserdefined[name=cationCap]/value,"//soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilCationCap]]/definedValue"
36
//*s/abioticObservation/simpleUserdefined[name=conductivity]/value,"//soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilConductivity]]/definedValue"
37
//*s/abioticObservation/magnesium,"//soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilMagnesium]]/definedValue"
38
//*s/abioticObservation/nitrogen,"//soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilNitrogen]]/definedValue"
39
//*s/abioticObservation/phosphorus,"//soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilPhosphorus]]/definedValue"
40
//*s/abioticObservation/pottasium,"//soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilPotassium]]/definedValue"
41
//*s/abioticObservation/simpleUserdefined[name=sodium]/value,"//soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilSodium]]/definedValue"
42
//*s/abioticObservation/simpleUserdefined[name=clayPercent]/value,//soilObs/soilClay
43
//*s/abioticObservation/simpleUserdefined[name=organicPercent]/value,//soilObs/soilOrganic
44
//*s/abioticObservation/ph,//soilObs/soilPH
45
//*s/abioticObservation/simpleUserdefined[name=sandPercent]/value,//soilObs/soilSand
46
//*s/abioticObservation/simpleUserdefined[name=siltPercent]/value,//soilObs/soilSilt
47
//*s/abioticObservation/simpleUserdefined[name=texture]/value,//soilObs/soilTexture
48
//geospatial/maximumDepthInMeters,//waterDepth/max
49
//geospatial/minimumDepthInMeters,//waterDepth/min
50
//plot/plotUniqueIdentifier,"/*_ID/plotevent/{*_ID/plot/authorPlotCode/_alt/2,authorObsCode}"
51
/simpleUserdefined[name=count]/value,//*/stemCount
52
/simpleUserdefined[name=coverPercent]/value,//taxonImportance/cover
53
/simpleUserdefined[name=interceptCm]/value,"//taxonImportance/definedValue[*_ID/userDefined[tableName=taxonImportance,userDefinedName=interceptCm]]/definedValue"
54
/diameterBaseDistance[baseDistance=1.37]/diameter,//stemCount/stemDiameter
55
/height,//stemCount/stemHeight
56
/simpleUserdefined[name=stemHeightM]/value,//stemCount/stemHeight
57
/simpleUserdefined[name=habitat]/value,"//stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=habitat]]/definedValue"
58
/simpleUserdefined[name=htFirstBranchM]/value,"//stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=heightFirstBranchM]]/definedValue"
59
/simpleUserdefined[name=plantFungusDescription]/value,"//stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=plantFungusDescription]]/definedValue"
60
/diameterBaseDistance[baseDistance=0]/diameter,"//stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=stemBasalDiameter]]/definedValue"
61
/simpleUserdefined[name=stemCanopyForm]/value,"//stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=stemCanopyForm]]/definedValue"
62
/simpleUserdefined[name=stemCanopyPosition]/value,"//stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=stemCanopyPosition]]/definedValue"
63
/simpleUserdefined[name=stemHeightFirstBranchM]/value,"//stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=stemHeightFirstBranchM]]/definedValue"
64
/simpleUserdefined[name=stemLianaInfestation]/value,"//stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=stemLianaInfestation]]/definedValue"
65
/simpleUserdefined[name=substrate]/value,"//stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=substrate]]/definedValue"
66
/simpleUserdefined[name=vegetation]/value,"//stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=vegetation]]/definedValue"
67
//individualOrganism/identificationLabel,//stemLocation/stemCode
68
/simpleUserdefined[name=xPosition]/value,//stemLocation/stemXPosition
69
/simpleUserdefined[name=yPosition]/value,//stemLocation/stemYPosition
70
//taxonNameUsageConcept/authorCode,/taxonInterpretation[roleCode=collector]/collectionNumber
71
//individualName/givenName,"/taxonInterpretation[roleCode=collector]/collector_ID/party/{givenName/_namePart/first,middleName/_namePart/last}"
72
"//parties/party/individualName/{givenName/_namePart/{first,middle},surName/_namePart/last}","/taxonInterpretation[roleCode=collector]/collector_ID/party/{givenName/_namePart/first,middleName/_namePart/middle,surName/_namePart/last}"
73
//individualName/surName,/taxonInterpretation[roleCode=collector]/collector_ID/party/{surName}
74
/simpleUserdefined[name=censusNo]/value,"/taxonInterpretation[roleCode=collector]/definedValue[*_ID/userDefined[tableName=taxonInterpretation,userDefinedName=censusNo]]/definedValue"
75
//*s/taxonDetermination[role=computer]/note,"/taxonInterpretation[roleCode=collector]/definedValue[*_ID/userDefined[tableName=taxonInterpretation,userDefinedName=cfAff]]/definedValue"
76
//*s/taxonDetermination[role=collector]/groupType,"/taxonInterpretation[roleCode=collector]/definedValue[*_ID/userDefined[tableName=taxonInterpretation,userDefinedName=determinationType]]/definedValue"
77
/simpleUserdefined[name=habit]/value,"/taxonInterpretation[roleCode=collector]/definedValue[*_ID/userDefined[tableName=taxonInterpretation,userDefinedName=habit]]/definedValue"
78
/simpleUserdefined[name=individualCode]/value,"/taxonInterpretation[roleCode=collector]/definedValue[*_ID/userDefined[tableName=taxonInterpretation,userDefinedName=individualCode]]/definedValue"
79
//individualOrganism/simpleUserdefined[name=sex]/value,"/taxonInterpretation[roleCode=collector]/definedValue[*_ID/userDefined[tableName=taxonInterpretation,userDefinedName=sex]]/definedValue"
80
//party/organizationName,/taxonInterpretation[roleCode=collector]/museum_ID/party/OrganizationName
81
//party/organizationName/_name/first,/taxonInterpretation[roleCode=collector]/museum_ID/party/OrganizationName/_name/first
82
//party/organizationName/_name/last,/taxonInterpretation[roleCode=collector]/museum_ID/party/OrganizationName/_name/last
83
//note/text,/taxonInterpretation[roleCode=collector]/notes
84
//*s/taxonConcept[@code=fam]/Name,"/taxonInterpretation[roleCode=computer,plantLevel=Family]/*_ID/plantConcept/*_ID/*/plantName"
85
//*s/taxonConcept[@code=gen]/Name,"/taxonInterpretation[roleCode=computer,plantLevel=Genus]/*_ID/plantConcept/*_ID/*/plantName"
86
//*s/taxonConcept[@code=sp]/AccordingTo/Simple,"/taxonInterpretation[roleCode=computer,plantLevel=Species]/*_ID/plantConcept/*_ID/plantName/reference_ID/reference/shortName"
87
//*s/taxonConcept[@code=sp]/Name,"/taxonInterpretation[roleCode=computer,plantLevel=Species]/*_ID/plantConcept/*_ID/*/plantName"
88
//*s/taxonConcept[@code=TaxonomicRankBelowSubspeciesEnum]/Rank,"/taxonInterpretation[roleCode=computer,plantLevel=Subspecies]/*_ID/plantConcept/*_ID/*/plantName/_name/first"
89
//*s/taxonConcept[@code=TaxonomicRankBelowSubspeciesEnum]/Name,"/taxonInterpretation[roleCode=computer,plantLevel=Subspecies]/*_ID/plantConcept/*_ID/*/plantName/_name/last"
90
//*s/taxonDetermination[role=identifier]/date/_date/day,/taxonInterpretation[roleCode=identifier]/interpretationDate/_date/day
91
//*s/taxonDetermination[role=identifier]/date/_date/month,/taxonInterpretation[roleCode=identifier]/interpretationDate/_date/month
92
//*s/taxonDetermination[role=identifier]/date/_date/year,/taxonInterpretation[roleCode=identifier]/interpretationDate/_date/year
93
"//parties/party/individualName/{givenName/_namePart/{first,middle},surName/_namePart/last}","/taxonInterpretation[roleCode=identifier]/*_ID/party/{givenName/_namePart/first,middleName/_namePart/middle,surName/_namePart/last}"
94
//*s/taxonConcept[@code=cl]/Name,"/taxonInterpretation[roleCode=identifier,plantLevel=Class]/*_ID/plantConcept/*_ID/*/plantName"
95
//*s/taxonConcept[@code=fam]/Name,"/taxonInterpretation[roleCode=identifier,plantLevel=Family]/*_ID/plantConcept/*_ID/*/plantName"
96
//*s/taxonConcept[@code=gen]/Name,"/taxonInterpretation[roleCode=identifier,plantLevel=Genus]/*_ID/plantConcept/*_ID/*/plantName"
97
//*s/taxonConcept[@code=reg]/Name,"/taxonInterpretation[roleCode=identifier,plantLevel=Kingdom]/*_ID/plantConcept/*_ID/*/plantName"
98
//*s/taxonConcept[@code=ord]/Name,"/taxonInterpretation[roleCode=identifier,plantLevel=Order]/*_ID/plantConcept/*_ID/*/plantName"
99
//*s/taxonConcept[@code=sp]/AccordingTo/Simple,"/taxonInterpretation[roleCode=identifier,plantLevel=Species]/*_ID/plantConcept/*_ID/reference/referenceContributor/*_ID/referenceParty/{givenName,surname}"
100
//*s/taxonConcept[@code=phyl_div]/Name,"/taxonInterpretation[roleCode=identifier,plantLevel=Subkingdom]/*_ID/plantConcept/*_ID/*/plantName"
101
//*s/taxonConcept[@code=ssp]/Name,"/taxonInterpretation[roleCode=identifier,plantLevel=Subspecies]/*_ID/plantConcept/*_ID/*/plantName"
102
//taxonNameUsageConcept/voucher,"/{taxonInterpretation[roleCode=collector]/museumAccessionNumber,*_ID/plotevent/*_ID/plot/authorPlotCode/_alt/3}"
103
//taxonName/Simple,"/{taxonInterpretation[roleCode=identifier]/*_ID/plantConcept/*_ID/*/plantName,taxonInterpretation[roleCode=collector]/*_ID/plantConcept/*_ID/*/plantName/_alt/1}"
104
//*s/taxonConcept[@code=sp]/Name,"/{taxonInterpretation[roleCode=identifier,plantLevel=Species]/*_ID/plantConcept/*_ID/*/plantName,taxonInterpretation[roleCode=collector]/*_ID/plantConcept/*_ID/*/plantName/_alt/2}"
mappings/for_review/VegBank-VegBIEN.organisms.csv
1
VegBank:/taxonObservation,VegBIEN:/taxonObservation
2
//plot/authorPlotCode/_alt/1,//plot/authorPlotCode/_alt/1
3
//plot/area,//plot/area
4
//plot/dsgpoly,//plot/dsgpoly
5
//plot/elevation,//plot/elevation
6
//plot/locationAccuracy,//plot/locationAccuracy
7
"//*_ID/namedPlace[placeSystem=""area|country|territory""]/placeName","//*_ID/namedPlace[placeSystem=""area|country|territory""]/placeName"
8
"//*_ID/namedPlace[placeSystem=""region|state|province""]/placeName","//*_ID/namedPlace[placeSystem=""region|state|province""]/placeName"
9
//*_ID/namedPlace[placeSystem=continent]/placeName,//*_ID/namedPlace[placeSystem=continent]/placeName
10
//*_ID/namedPlace[placeSystem=county]/placeName,//*_ID/namedPlace[placeSystem=county]/placeName
11
//namedPlace/placeDescription,//namedPlace/placeDescription
12
//namedPlace/placeDescription,//namedPlace/placeDescription
13
//plot/realLatitude,//plot/realLatitude
14
//plot/realLongitude,//plot/realLongitude
15
//plot/slopeAspect,//plot/slopeAspect
16
//plot/slopeGradient,//plot/slopeGradient
17
"/*_ID/observation/*_ID/plot/{elevation/_avg/max,elevationRange/_range/to}","/*_ID/plotevent/*_ID/plot/{elevation/_avg/max,elevationRange/_range/to}"
18
"/*_ID/observation/*_ID/plot/{elevation/_avg/min,elevationRange/_range/from}","/*_ID/plotevent/*_ID/plot/{elevation/_avg/min,elevationRange/_range/from}"
19
//project/projectName,//project/projectName
20
//*/commName,//*/commName
21
//commConcept/commDescription,//commConcept/commDescription
22
"//observation/definedValue[*_ID/userDefined[tableName=observation,userDefinedName=precipitationMm]]/definedValue","//plotevent/definedValue[*_ID/userDefined[tableName=observation,userDefinedName=precipitationMm]]/definedValue"
23
"//observation/definedValue[*_ID/userDefined[tableName=observation,userDefinedName=temperatureC]]/definedValue","//plotevent/definedValue[*_ID/userDefined[tableName=observation,userDefinedName=temperatureC]]/definedValue"
24
//observation/methodNarrative,//plotevent/methodNarrative
25
//observation/obsEndDate,//plotevent/obsEndDate
26
//observation/obsEndDate/_date/year,//plotevent/obsEndDate/_date/year
27
//observation/obsStartDate,//plotevent/obsStartDate
28
//observation/obsStartDate/_date/day,//plotevent/obsStartDate/_date/day
29
//observation/obsStartDate/_date/month,//plotevent/obsStartDate/_date/month
30
//observation/obsStartDate/_date/year,//plotevent/obsStartDate/_date/year
31
"//soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilAcidity]]/definedValue","//soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilAcidity]]/definedValue"
32
"//soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilBase]]/definedValue","//soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilBase]]/definedValue"
33
"//soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilCalcium]]/definedValue","//soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilCalcium]]/definedValue"
34
"//soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilCarbon]]/definedValue","//soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilCarbon]]/definedValue"
35
"//soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilCationCap]]/definedValue","//soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilCationCap]]/definedValue"
36
"//soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilConductivity]]/definedValue","//soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilConductivity]]/definedValue"
37
"//soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilMagnesium]]/definedValue","//soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilMagnesium]]/definedValue"
38
"//soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilNitrogen]]/definedValue","//soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilNitrogen]]/definedValue"
39
"//soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilPhosphorus]]/definedValue","//soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilPhosphorus]]/definedValue"
40
"//soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilPotassium]]/definedValue","//soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilPotassium]]/definedValue"
41
"//soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilSodium]]/definedValue","//soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilSodium]]/definedValue"
42
//soilObs/soilClay,//soilObs/soilClay
43
//soilObs/soilOrganic,//soilObs/soilOrganic
44
//soilObs/soilPH,//soilObs/soilPH
45
//soilObs/soilSand,//soilObs/soilSand
46
//soilObs/soilSilt,//soilObs/soilSilt
47
//soilObs/soilTexture,//soilObs/soilTexture
48
//waterDepth/max,//waterDepth/max
49
//waterDepth/min,//waterDepth/min
50
"/*_ID/observation/{*_ID/plot/authorPlotCode/_alt/2,authorObsCode}","/*_ID/plotevent/{*_ID/plot/authorPlotCode/_alt/2,authorObsCode}"
51
//*/stemCount,//*/stemCount
52
//taxonImportance/cover,//taxonImportance/cover
53
"//taxonImportance/definedValue[*_ID/userDefined[tableName=taxonImportance,userDefinedName=interceptCm]]/definedValue","//taxonImportance/definedValue[*_ID/userDefined[tableName=taxonImportance,userDefinedName=interceptCm]]/definedValue"
54
//stemCount/stemDiameter,//stemCount/stemDiameter
55
//stemCount/stemHeight,//stemCount/stemHeight
56
//stemCount/stemHeight,//stemCount/stemHeight
57
"//stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=habitat]]/definedValue","//stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=habitat]]/definedValue"
58
"//stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=heightFirstBranchM]]/definedValue","//stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=heightFirstBranchM]]/definedValue"
59
"//stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=plantFungusDescription]]/definedValue","//stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=plantFungusDescription]]/definedValue"
60
"//stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=stemBasalDiameter]]/definedValue","//stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=stemBasalDiameter]]/definedValue"
61
"//stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=stemCanopyForm]]/definedValue","//stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=stemCanopyForm]]/definedValue"
62
"//stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=stemCanopyPosition]]/definedValue","//stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=stemCanopyPosition]]/definedValue"
63
"//stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=stemHeightFirstBranchM]]/definedValue","//stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=stemHeightFirstBranchM]]/definedValue"
64
"//stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=stemLianaInfestation]]/definedValue","//stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=stemLianaInfestation]]/definedValue"
65
"//stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=substrate]]/definedValue","//stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=substrate]]/definedValue"
66
"//stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=vegetation]]/definedValue","//stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=vegetation]]/definedValue"
67
//stemLocation/stemCode,//stemLocation/stemCode
68
//stemLocation/stemXPosition,//stemLocation/stemXPosition
69
//stemLocation/stemYPosition,//stemLocation/stemYPosition
70
/taxonInterpretation[roleCode=collector]/collectionNumber,/taxonInterpretation[roleCode=collector]/collectionNumber
71
"/taxonInterpretation[roleCode=collector]/collector_ID/party/{givenName/_namePart/first,middleName/_namePart/last}","/taxonInterpretation[roleCode=collector]/collector_ID/party/{givenName/_namePart/first,middleName/_namePart/last}"
72
"/taxonInterpretation[roleCode=collector]/collector_ID/party/{givenName/_namePart/first,middleName/_namePart/middle,surName/_namePart/last}","/taxonInterpretation[roleCode=collector]/collector_ID/party/{givenName/_namePart/first,middleName/_namePart/middle,surName/_namePart/last}"
73
/taxonInterpretation[roleCode=collector]/collector_ID/party/{surName},/taxonInterpretation[roleCode=collector]/collector_ID/party/{surName}
74
"/taxonInterpretation[roleCode=collector]/definedValue[*_ID/userDefined[tableName=taxonInterpretation,userDefinedName=censusNo]]/definedValue","/taxonInterpretation[roleCode=collector]/definedValue[*_ID/userDefined[tableName=taxonInterpretation,userDefinedName=censusNo]]/definedValue"
75
"/taxonInterpretation[roleCode=collector]/definedValue[*_ID/userDefined[tableName=taxonInterpretation,userDefinedName=cfAff]]/definedValue","/taxonInterpretation[roleCode=collector]/definedValue[*_ID/userDefined[tableName=taxonInterpretation,userDefinedName=cfAff]]/definedValue"
76
"/taxonInterpretation[roleCode=collector]/definedValue[*_ID/userDefined[tableName=taxonInterpretation,userDefinedName=determinationType]]/definedValue","/taxonInterpretation[roleCode=collector]/definedValue[*_ID/userDefined[tableName=taxonInterpretation,userDefinedName=determinationType]]/definedValue"
77
"/taxonInterpretation[roleCode=collector]/definedValue[*_ID/userDefined[tableName=taxonInterpretation,userDefinedName=habit]]/definedValue","/taxonInterpretation[roleCode=collector]/definedValue[*_ID/userDefined[tableName=taxonInterpretation,userDefinedName=habit]]/definedValue"
78
"/taxonInterpretation[roleCode=collector]/definedValue[*_ID/userDefined[tableName=taxonInterpretation,userDefinedName=individualCode]]/definedValue","/taxonInterpretation[roleCode=collector]/definedValue[*_ID/userDefined[tableName=taxonInterpretation,userDefinedName=individualCode]]/definedValue"
79
"/taxonInterpretation[roleCode=collector]/definedValue[*_ID/userDefined[tableName=taxonInterpretation,userDefinedName=sex]]/definedValue","/taxonInterpretation[roleCode=collector]/definedValue[*_ID/userDefined[tableName=taxonInterpretation,userDefinedName=sex]]/definedValue"
80
/taxonInterpretation[roleCode=collector]/museum_ID/party/OrganizationName,/taxonInterpretation[roleCode=collector]/museum_ID/party/OrganizationName
81
/taxonInterpretation[roleCode=collector]/museum_ID/party/OrganizationName/_name/first,/taxonInterpretation[roleCode=collector]/museum_ID/party/OrganizationName/_name/first
82
/taxonInterpretation[roleCode=collector]/museum_ID/party/OrganizationName/_name/last,/taxonInterpretation[roleCode=collector]/museum_ID/party/OrganizationName/_name/last
83
/taxonInterpretation[roleCode=collector]/notes,/taxonInterpretation[roleCode=collector]/notes
84
"/taxonInterpretation[roleCode=computer,plantLevel=Family]/*_ID/plantConcept/*_ID/*/plantName","/taxonInterpretation[roleCode=computer,plantLevel=Family]/*_ID/plantConcept/*_ID/*/plantName"
85
"/taxonInterpretation[roleCode=computer,plantLevel=Genus]/*_ID/plantConcept/*_ID/*/plantName","/taxonInterpretation[roleCode=computer,plantLevel=Genus]/*_ID/plantConcept/*_ID/*/plantName"
86
"/taxonInterpretation[roleCode=computer,plantLevel=Species]/*_ID/plantConcept/*_ID/plantName/reference_ID/reference/shortName","/taxonInterpretation[roleCode=computer,plantLevel=Species]/*_ID/plantConcept/*_ID/plantName/reference_ID/reference/shortName"
87
"/taxonInterpretation[roleCode=computer,plantLevel=Species]/*_ID/plantConcept/*_ID/*/plantName","/taxonInterpretation[roleCode=computer,plantLevel=Species]/*_ID/plantConcept/*_ID/*/plantName"
88
"/taxonInterpretation[roleCode=computer,plantLevel=Subspecies]/*_ID/plantConcept/*_ID/*/plantName/_name/first","/taxonInterpretation[roleCode=computer,plantLevel=Subspecies]/*_ID/plantConcept/*_ID/*/plantName/_name/first"
89
"/taxonInterpretation[roleCode=computer,plantLevel=Subspecies]/*_ID/plantConcept/*_ID/*/plantName/_name/last","/taxonInterpretation[roleCode=computer,plantLevel=Subspecies]/*_ID/plantConcept/*_ID/*/plantName/_name/last"
90
/taxonInterpretation[roleCode=identifier]/interpretationDate/_date/day,/taxonInterpretation[roleCode=identifier]/interpretationDate/_date/day
91
/taxonInterpretation[roleCode=identifier]/interpretationDate/_date/month,/taxonInterpretation[roleCode=identifier]/interpretationDate/_date/month
92
/taxonInterpretation[roleCode=identifier]/interpretationDate/_date/year,/taxonInterpretation[roleCode=identifier]/interpretationDate/_date/year
93
"/taxonInterpretation[roleCode=identifier]/*_ID/party/{givenName/_namePart/first,middleName/_namePart/middle,surName/_namePart/last}","/taxonInterpretation[roleCode=identifier]/*_ID/party/{givenName/_namePart/first,middleName/_namePart/middle,surName/_namePart/last}"
94
"/taxonInterpretation[roleCode=identifier,plantLevel=Class]/*_ID/plantConcept/*_ID/*/plantName","/taxonInterpretation[roleCode=identifier,plantLevel=Class]/*_ID/plantConcept/*_ID/*/plantName"
95
"/taxonInterpretation[roleCode=identifier,plantLevel=Family]/*_ID/plantConcept/*_ID/*/plantName","/taxonInterpretation[roleCode=identifier,plantLevel=Family]/*_ID/plantConcept/*_ID/*/plantName"
96
"/taxonInterpretation[roleCode=identifier,plantLevel=Genus]/*_ID/plantConcept/*_ID/*/plantName","/taxonInterpretation[roleCode=identifier,plantLevel=Genus]/*_ID/plantConcept/*_ID/*/plantName"
97
"/taxonInterpretation[roleCode=identifier,plantLevel=Kingdom]/*_ID/plantConcept/*_ID/*/plantName","/taxonInterpretation[roleCode=identifier,plantLevel=Kingdom]/*_ID/plantConcept/*_ID/*/plantName"
98
"/taxonInterpretation[roleCode=identifier,plantLevel=Order]/*_ID/plantConcept/*_ID/*/plantName","/taxonInterpretation[roleCode=identifier,plantLevel=Order]/*_ID/plantConcept/*_ID/*/plantName"
99
"/taxonInterpretation[roleCode=identifier,plantLevel=Species]/*_ID/plantConcept/*_ID/reference/referenceContributor/*_ID/referenceParty/{givenName,surname}","/taxonInterpretation[roleCode=identifier,plantLevel=Species]/*_ID/plantConcept/*_ID/reference/referenceContributor/*_ID/referenceParty/{givenName,surname}"
100
"/taxonInterpretation[roleCode=identifier,plantLevel=Subkingdom]/*_ID/plantConcept/*_ID/*/plantName","/taxonInterpretation[roleCode=identifier,plantLevel=Subkingdom]/*_ID/plantConcept/*_ID/*/plantName"
101
"/taxonInterpretation[roleCode=identifier,plantLevel=Subspecies]/*_ID/plantConcept/*_ID/*/plantName","/taxonInterpretation[roleCode=identifier,plantLevel=Subspecies]/*_ID/plantConcept/*_ID/*/plantName"
102
"/{taxonInterpretation[roleCode=collector]/museumAccessionNumber,*_ID/observation/*_ID/plot/authorPlotCode/_alt/3}","/{taxonInterpretation[roleCode=collector]/museumAccessionNumber,*_ID/plotevent/*_ID/plot/authorPlotCode/_alt/3}"
103
"/{taxonInterpretation[roleCode=identifier]/*_ID/plantConcept/*_ID/*/plantName,taxonInterpretation[roleCode=collector]/*_ID/plantConcept/*_ID/*/plantName/_alt/1}","/{taxonInterpretation[roleCode=identifier]/*_ID/plantConcept/*_ID/*/plantName,taxonInterpretation[roleCode=collector]/*_ID/plantConcept/*_ID/*/plantName/_alt/1}"
104
"/{taxonInterpretation[roleCode=identifier,plantLevel=Species]/*_ID/plantConcept/*_ID/*/plantName,taxonInterpretation[roleCode=collector]/*_ID/plantConcept/*_ID/*/plantName/_alt/2}","/{taxonInterpretation[roleCode=identifier,plantLevel=Species]/*_ID/plantConcept/*_ID/*/plantName,taxonInterpretation[roleCode=collector]/*_ID/plantConcept/*_ID/*/plantName/_alt/2}"
mappings/Makefile
1
all: FORCE
2
	./extract_plot_map
1
# Dynamically-generated organisms maps
2
genOrganisms = VegX-VegBIEN.organisms.csv
3

  
4
all = $(genOrganisms) \
5
$(subst .organisms.,.plots.,$(genOrganisms) $(wildcard VegX-*.organisms.csv))
6

  
7
all: FORCE $(all)
3 8
	./join_all_vegbank
4 9
	./format_all_for_review
5 10

  
6 11
FORCE:
12

  
13
clean: FORCE
14
	rm $(foreach item,$(sort $(all)),$(wildcard $(item)))
15

  
16
VegX-VegBIEN.organisms.csv: \
17
VegX-VegBank.organisms.csv \
18
VegBank-VegBIEN.organisms.csv
19
	../scripts/util/join_passthru $+|../scripts/util/sort 1 >$@
20

  
21
chRoot = ../scripts/util/ch_root <$< >$@
22

  
23
chRoot2PlotsLeftVegx =\
24
	env \
25
	left_in_root='/*s/individualOrganismObservation/*ID->/*s/plotObservation' \
26
	left_out_root='/*s/plotObservation' \
27
	$(chRoot)
28

  
29
VegX-VegBank.plots.csv: VegX-VegBank.organisms.csv
30
	$(chRoot2PlotsVegxVegbank)
31
chRoot2PlotsVegxVegbank =\
32
	env \
33
	right_in_root='/taxonObservation/*_ID/observation' \
34
	right_out_root='/observation' \
35
	$(chRoot2PlotsLeftVegx)
36

  
37
VegX-VegBIEN.plots.csv: VegX-VegBIEN.organisms.csv
38
	$(chRoot2PlotsVegxVegbien)
39
chRoot2PlotsVegxVegbien =\
40
	env \
41
	right_in_root='/taxonObservation/*_ID/plotevent' \
42
	right_out_root='/plotevent' \
43
	$(chRoot2PlotsLeftVegx)

Also available in: Unified diff