Project

General

Profile

« Previous | Next » 

Revision 325

Added by Aaron Marcuse-Kubitza almost 13 years ago

VegX-VegBank mapping: Added default soilObs.soilHorizon value

View differences:

inputs/SALVIAS/map.VegBIEN.plots.csv
20 20 
PlotMethod,/methodNarrative,
21 21 
date_finish,/obsEndDate/_date/date,
22 22 
date_start,/obsStartDate/_date/date,
23 
soil_acidity,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilAcidity]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
24 
soil_base,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilBase]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
25 
soil_Ca,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilCalcium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
26 
soil_C,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilCarbon]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
27 
soil_cation_cap,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilCationCap]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
28 
soil_conductivity,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilConductivity]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
29 
soil_Mg,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilMagnesium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
30 
soil_N,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilNitrogen]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
31 
soil_P,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilPhosphorus]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
32 
soil_K,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilPotassium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
33 
soil_Na,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilSodium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
34 
clay_percent,/soilObs/soilClay,
35 
organic_percent,/soilObs/soilOrganic,
36 
pH,/soilObs/soilPH,"Brad: For all these soil variables, how do we store information on method, units. Seems like an ontological structure would be more appropriate (measurementName, measurementValue, measurementUnits, measurementMethod). Same as BIEN traits table. Something to discuss."
37 
sand_percent,/soilObs/soilSand,
38 
silt_percent,/soilObs/soilSilt,
39 
soil_texture,/soilObs/soilTexture,
23 
soil_acidity,"/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilAcidity]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
24 
soil_base,"/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilBase]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
25 
soil_Ca,"/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilCalcium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
26 
soil_C,"/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilCarbon]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
27 
soil_cation_cap,"/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilCationCap]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
28 
soil_conductivity,"/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilConductivity]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
29 
soil_Mg,"/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilMagnesium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
30 
soil_N,"/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilNitrogen]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
31 
soil_P,"/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilPhosphorus]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
32 
soil_K,"/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilPotassium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
33 
soil_Na,"/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilSodium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
34 
clay_percent,/soilObs:[soilHorizon=unknown]/soilClay,
35 
organic_percent,/soilObs:[soilHorizon=unknown]/soilOrganic,
36 
pH,/soilObs:[soilHorizon=unknown]/soilPH,"Brad: For all these soil variables, how do we store information on method, units. Seems like an ontological structure would be more appropriate (measurementName, measurementValue, measurementUnits, measurementMethod). Same as BIEN traits table. Something to discuss."
37 
sand_percent,/soilObs:[soilHorizon=unknown]/soilSand,
38 
silt_percent,/soilObs:[soilHorizon=unknown]/soilSilt,
39 
soil_texture,/soilObs:[soilHorizon=unknown]/soilTexture,
40 40 
SiteCode,"/{*_ID/plot:[confidentialityStatus=0]/authorPlotCode/_alt/2,authorObsCode}",Brad: plotCode is as-assigned by data provider; guranteed to be unique only within dataset (=project)
inputs/SALVIAS/map.VegBIEN.organisms.csv
5 5 
cover_percent,/collectiveobs/cover,
6 6 
intercept_cm,"/collectiveobs/definedValue[*_ID/userDefined[tableName=collectiveobs,userDefinedName=interceptCm]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue","Brad: Incorrect for VegBank This is an aggregate observation. Used in line-intercept methodology only, describes the point along centerline at which an individual intercepts the center line of the plot. Used to determin relative abundance."
7 7 
ht_first_branch_m,"/collectiveobs/stemCount/individual/definedValue[*_ID/userDefined[tableName=individual,userDefinedName=heightFirstBranchM]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",Brad: Incorrect for VegBank. This is a measurement applied to a single tree. Check with Bob
8 
tag1,/collectiveobs/stemCount/individual/stemCode,"Brad: Another type of code, typically a number, used by the original data provider to indicate an individual tree. These are numbers on physical tags attached to the tree. Tag2 Is the same thing, only used if the first tag was lost. Obviously not a good system as it's possible a tree tag could be lost and changed more than once."
9 
tag2,/collectiveobs/stemCount/individual/stemCode,"Brad: See commend for tag1. Your mapping for tag2 looks correct. Probably both values would go here, only nested, with one superceding the other."
8 
tag2,/collectiveobs/stemCount/individual/stemCode/_alt/1,"Brad: See commend for tag1. Your mapping for tag2 looks correct. Probably both values would go here, only nested, with one superceding the other."
9 
tag1,/collectiveobs/stemCount/individual/stemCode/_alt/2,"Brad: Another type of code, typically a number, used by the original data provider to indicate an individual tree. These are numbers on physical tags attached to the tree. Tag2 Is the same thing, only used if the first tag was lost. Obviously not a good system as it's possible a tree tag could be lost and changed more than once."
10 10 
x_position,/collectiveobs/stemCount/individual/stemXPosition,"Brad: Correct for VegBank. I'm not so sure for VegX. Let's ask Nick about this. These are important, fundamental values of many tree plots, and should be accommodated within VegX."
11 11 
y_position,/collectiveobs/stemCount/individual/stemYPosition,Brad: See comment above for x_position
12 12 
temp_dbh,/collectiveobs/stemCount/stemDiameter,
mappings/VegX-VegBank.organisms.csv
29 29 
"/*ID->/*s/plotObservation/obsStartDate/_date/day","/*_ID/observation/obsStartDate/_date/day"
30 30 
"/*ID->/*s/plotObservation/obsStartDate/_date/month","/*_ID/observation/obsStartDate/_date/month"
31 31 
"/*ID->/*s/plotObservation/obsStartDate/_date/year","/*_ID/observation/obsStartDate/_date/year"
32 
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=acidity]/value","/*_ID/observation/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilAcidity]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
33 
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=base]/value","/*_ID/observation/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilBase]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
34 
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=calcium]/value","/*_ID/observation/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilCalcium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
35 
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=carbon]/value","/*_ID/observation/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilCarbon]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
36 
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=cationCap]/value","/*_ID/observation/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilCationCap]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
37 
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=conductivity]/value","/*_ID/observation/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilConductivity]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
38 
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/magnesium","/*_ID/observation/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilMagnesium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
39 
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/nitrogen","/*_ID/observation/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilNitrogen]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
40 
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/phosphorus","/*_ID/observation/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilPhosphorus]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
41 
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/pottasium","/*_ID/observation/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilPotassium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
42 
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=sodium]/value","/*_ID/observation/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilSodium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
43 
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=clayPercent]/value","/*_ID/observation/soilObs/soilClay"
44 
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=organicPercent]/value","/*_ID/observation/soilObs/soilOrganic"
45 
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/ph","/*_ID/observation/soilObs/soilPH"
46 
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=sandPercent]/value","/*_ID/observation/soilObs/soilSand"
47 
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=siltPercent]/value","/*_ID/observation/soilObs/soilSilt"
48 
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=texture]/value","/*_ID/observation/soilObs/soilTexture"
32 
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=acidity]/value","/*_ID/observation/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilAcidity]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
33 
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=base]/value","/*_ID/observation/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilBase]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
34 
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=calcium]/value","/*_ID/observation/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilCalcium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
35 
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=carbon]/value","/*_ID/observation/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilCarbon]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
36 
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=cationCap]/value","/*_ID/observation/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilCationCap]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
37 
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=conductivity]/value","/*_ID/observation/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilConductivity]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
38 
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/magnesium","/*_ID/observation/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilMagnesium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
39 
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/nitrogen","/*_ID/observation/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilNitrogen]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
40 
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/phosphorus","/*_ID/observation/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilPhosphorus]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
41 
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/pottasium","/*_ID/observation/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilPotassium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
42 
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=sodium]/value","/*_ID/observation/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilSodium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
43 
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=clayPercent]/value","/*_ID/observation/soilObs:[soilHorizon=unknown]/soilClay"
44 
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=organicPercent]/value","/*_ID/observation/soilObs:[soilHorizon=unknown]/soilOrganic"
45 
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/ph","/*_ID/observation/soilObs:[soilHorizon=unknown]/soilPH"
46 
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=sandPercent]/value","/*_ID/observation/soilObs:[soilHorizon=unknown]/soilSand"
47 
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=siltPercent]/value","/*_ID/observation/soilObs:[soilHorizon=unknown]/soilSilt"
48 
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=texture]/value","/*_ID/observation/soilObs:[soilHorizon=unknown]/soilTexture"
49 49 
"/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/maximumDepthInMeters","/*_ID/observation/waterDepth/max"
50 50 
"/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/minimumDepthInMeters","/*_ID/observation/waterDepth/min"
51 51 
"/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier","/*_ID/observation/{*_ID/plot:[confidentialityStatus=0]/authorPlotCode/_alt/2,authorObsCode}"
mappings/VegX-VegBIEN.plots.csv
29 29 
/obsStartDate/_date/day,/obsStartDate/_date/day
30 30 
/obsStartDate/_date/month,/obsStartDate/_date/month
31 31 
/obsStartDate/_date/year,/obsStartDate/_date/year
32 
->/*s/abioticObservation[*ID]/simpleUserdefined[name=acidity]/value,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilAcidity]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
33 
->/*s/abioticObservation[*ID]/simpleUserdefined[name=base]/value,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilBase]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
34 
->/*s/abioticObservation[*ID]/simpleUserdefined[name=calcium]/value,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilCalcium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
35 
->/*s/abioticObservation[*ID]/simpleUserdefined[name=carbon]/value,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilCarbon]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
36 
->/*s/abioticObservation[*ID]/simpleUserdefined[name=cationCap]/value,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilCationCap]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
37 
->/*s/abioticObservation[*ID]/simpleUserdefined[name=conductivity]/value,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilConductivity]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
38 
->/*s/abioticObservation[*ID]/magnesium,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilMagnesium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
39 
->/*s/abioticObservation[*ID]/nitrogen,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilNitrogen]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
40 
->/*s/abioticObservation[*ID]/phosphorus,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilPhosphorus]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
41 
->/*s/abioticObservation[*ID]/pottasium,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilPotassium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
42 
->/*s/abioticObservation[*ID]/simpleUserdefined[name=sodium]/value,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilSodium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
43 
->/*s/abioticObservation[*ID]/simpleUserdefined[name=clayPercent]/value,/soilObs/soilClay
44 
->/*s/abioticObservation[*ID]/simpleUserdefined[name=organicPercent]/value,/soilObs/soilOrganic
45 
->/*s/abioticObservation[*ID]/ph,/soilObs/soilPH
46 
->/*s/abioticObservation[*ID]/simpleUserdefined[name=sandPercent]/value,/soilObs/soilSand
47 
->/*s/abioticObservation[*ID]/simpleUserdefined[name=siltPercent]/value,/soilObs/soilSilt
48 
->/*s/abioticObservation[*ID]/simpleUserdefined[name=texture]/value,/soilObs/soilTexture
32 
->/*s/abioticObservation[*ID]/simpleUserdefined[name=acidity]/value,"/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilAcidity]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
33 
->/*s/abioticObservation[*ID]/simpleUserdefined[name=base]/value,"/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilBase]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
34 
->/*s/abioticObservation[*ID]/simpleUserdefined[name=calcium]/value,"/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilCalcium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
35 
->/*s/abioticObservation[*ID]/simpleUserdefined[name=carbon]/value,"/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilCarbon]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
36 
->/*s/abioticObservation[*ID]/simpleUserdefined[name=cationCap]/value,"/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilCationCap]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
37 
->/*s/abioticObservation[*ID]/simpleUserdefined[name=conductivity]/value,"/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilConductivity]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
38 
->/*s/abioticObservation[*ID]/magnesium,"/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilMagnesium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
39 
->/*s/abioticObservation[*ID]/nitrogen,"/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilNitrogen]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
40 
->/*s/abioticObservation[*ID]/phosphorus,"/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilPhosphorus]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
41 
->/*s/abioticObservation[*ID]/pottasium,"/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilPotassium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
42 
->/*s/abioticObservation[*ID]/simpleUserdefined[name=sodium]/value,"/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilSodium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
43 
->/*s/abioticObservation[*ID]/simpleUserdefined[name=clayPercent]/value,/soilObs:[soilHorizon=unknown]/soilClay
44 
->/*s/abioticObservation[*ID]/simpleUserdefined[name=organicPercent]/value,/soilObs:[soilHorizon=unknown]/soilOrganic
45 
->/*s/abioticObservation[*ID]/ph,/soilObs:[soilHorizon=unknown]/soilPH
46 
->/*s/abioticObservation[*ID]/simpleUserdefined[name=sandPercent]/value,/soilObs:[soilHorizon=unknown]/soilSand
47 
->/*s/abioticObservation[*ID]/simpleUserdefined[name=siltPercent]/value,/soilObs:[soilHorizon=unknown]/soilSilt
48 
->/*s/abioticObservation[*ID]/simpleUserdefined[name=texture]/value,/soilObs:[soilHorizon=unknown]/soilTexture
49 49 
/*UniqueIdentifierID->/*s/plot/geospatial/maximumDepthInMeters,/waterDepth/max
50 50 
/*UniqueIdentifierID->/*s/plot/geospatial/minimumDepthInMeters,/waterDepth/min
51 51 
/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,"/{*_ID/plot:[confidentialityStatus=0]/authorPlotCode/_alt/2,authorObsCode}"
mappings/VegX-VegBIEN.organisms.csv
29 29 
/*ID->/*s/plotObservation/obsStartDate/_date/day,/*_ID/plotevent/obsStartDate/_date/day
30 30 
/*ID->/*s/plotObservation/obsStartDate/_date/month,/*_ID/plotevent/obsStartDate/_date/month
31 31 
/*ID->/*s/plotObservation/obsStartDate/_date/year,/*_ID/plotevent/obsStartDate/_date/year
32 
/*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"
33 
/*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"
34 
/*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"
35 
/*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"
36 
/*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"
37 
/*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"
38 
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/magnesium,"/*_ID/plotevent/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilMagnesium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
39 
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/nitrogen,"/*_ID/plotevent/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilNitrogen]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
40 
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/phosphorus,"/*_ID/plotevent/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilPhosphorus]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
41 
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/pottasium,"/*_ID/plotevent/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilPotassium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
42 
/*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"
43 
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=clayPercent]/value,/*_ID/plotevent/soilObs/soilClay
44 
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=organicPercent]/value,/*_ID/plotevent/soilObs/soilOrganic
45 
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/ph,/*_ID/plotevent/soilObs/soilPH
46 
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=sandPercent]/value,/*_ID/plotevent/soilObs/soilSand
47 
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=siltPercent]/value,/*_ID/plotevent/soilObs/soilSilt
48 
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=texture]/value,/*_ID/plotevent/soilObs/soilTexture
32 
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=acidity]/value,"/*_ID/plotevent/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilAcidity]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
33 
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=base]/value,"/*_ID/plotevent/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilBase]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
34 
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=calcium]/value,"/*_ID/plotevent/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilCalcium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
35 
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=carbon]/value,"/*_ID/plotevent/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilCarbon]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
36 
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=cationCap]/value,"/*_ID/plotevent/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilCationCap]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
37 
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=conductivity]/value,"/*_ID/plotevent/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilConductivity]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
38 
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/magnesium,"/*_ID/plotevent/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilMagnesium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
39 
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/nitrogen,"/*_ID/plotevent/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilNitrogen]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
40 
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/phosphorus,"/*_ID/plotevent/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilPhosphorus]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
41 
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/pottasium,"/*_ID/plotevent/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilPotassium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
42 
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=sodium]/value,"/*_ID/plotevent/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilSodium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
43 
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=clayPercent]/value,/*_ID/plotevent/soilObs:[soilHorizon=unknown]/soilClay
44 
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=organicPercent]/value,/*_ID/plotevent/soilObs:[soilHorizon=unknown]/soilOrganic
45 
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/ph,/*_ID/plotevent/soilObs:[soilHorizon=unknown]/soilPH
46 
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=sandPercent]/value,/*_ID/plotevent/soilObs:[soilHorizon=unknown]/soilSand
47 
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=siltPercent]/value,/*_ID/plotevent/soilObs:[soilHorizon=unknown]/soilSilt
48 
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=texture]/value,/*_ID/plotevent/soilObs:[soilHorizon=unknown]/soilTexture
49 49 
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/maximumDepthInMeters,/*_ID/plotevent/waterDepth/max
50 50 
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/minimumDepthInMeters,/*_ID/plotevent/waterDepth/min
51 51 
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,"/*_ID/plotevent/{*_ID/plot:[confidentialityStatus=0]/authorPlotCode/_alt/2,authorObsCode}"
mappings/SALVIAS-VegBank.plots.csv
20 20 
plot_methodology,/methodNarrative,
21 21 
date_finish,/obsEndDate/_date/date,
22 22 
date_start,/obsStartDate/_date/date,
23 
soil_acidity,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilAcidity]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
24 
soil_base,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilBase]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
25 
soil_Ca,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilCalcium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
26 
soil_C,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilCarbon]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
27 
soil_cation_cap,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilCationCap]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
28 
soil_conductivity,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilConductivity]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
29 
soil_Mg,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilMagnesium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
30 
soil_N,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilNitrogen]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
31 
soil_P,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilPhosphorus]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
32 
soil_K,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilPotassium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
33 
soil_Na,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilSodium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
34 
clay_percent,/soilObs/soilClay,
35 
organic_percent,/soilObs/soilOrganic,
36 
pH,/soilObs/soilPH,"Brad: For all these soil variables, how do we store information on method, units. Seems like an ontological structure would be more appropriate (measurementName, measurementValue, measurementUnits, measurementMethod). Same as BIEN traits table. Something to discuss."
37 
sand_percent,/soilObs/soilSand,
38 
silt_percent,/soilObs/soilSilt,
39 
soil_texture,/soilObs/soilTexture,
23 
soil_acidity,"/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilAcidity]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
24 
soil_base,"/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilBase]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
25 
soil_Ca,"/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilCalcium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
26 
soil_C,"/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilCarbon]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
27 
soil_cation_cap,"/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilCationCap]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
28 
soil_conductivity,"/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilConductivity]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
29 
soil_Mg,"/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilMagnesium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
30 
soil_N,"/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilNitrogen]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
31 
soil_P,"/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilPhosphorus]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
32 
soil_K,"/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilPotassium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
33 
soil_Na,"/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilSodium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
34 
clay_percent,/soilObs:[soilHorizon=unknown]/soilClay,
35 
organic_percent,/soilObs:[soilHorizon=unknown]/soilOrganic,
36 
pH,/soilObs:[soilHorizon=unknown]/soilPH,"Brad: For all these soil variables, how do we store information on method, units. Seems like an ontological structure would be more appropriate (measurementName, measurementValue, measurementUnits, measurementMethod). Same as BIEN traits table. Something to discuss."
37 
sand_percent,/soilObs:[soilHorizon=unknown]/soilSand,
38 
silt_percent,/soilObs:[soilHorizon=unknown]/soilSilt,
39 
soil_texture,/soilObs:[soilHorizon=unknown]/soilTexture,
40 40 
plot_code,"/{*_ID/plot:[confidentialityStatus=0]/authorPlotCode/_alt/2,authorObsCode}",Brad: plotCode is as-assigned by data provider; guranteed to be unique only within dataset (=project)
mappings/SALVIAS-VegBIEN.plots.csv
20 20 
plot_methodology,/methodNarrative,
21 21 
date_finish,/obsEndDate/_date/date,
22 22 
date_start,/obsStartDate/_date/date,
23 
soil_acidity,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilAcidity]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
24 
soil_base,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilBase]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
25 
soil_Ca,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilCalcium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
26 
soil_C,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilCarbon]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
27 
soil_cation_cap,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilCationCap]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
28 
soil_conductivity,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilConductivity]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
29 
soil_Mg,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilMagnesium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
30 
soil_N,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilNitrogen]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
31 
soil_P,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilPhosphorus]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
32 
soil_K,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilPotassium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
33 
soil_Na,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilSodium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
34 
clay_percent,/soilObs/soilClay,
35 
organic_percent,/soilObs/soilOrganic,
36 
pH,/soilObs/soilPH,"Brad: For all these soil variables, how do we store information on method, units. Seems like an ontological structure would be more appropriate (measurementName, measurementValue, measurementUnits, measurementMethod). Same as BIEN traits table. Something to discuss."
37 
sand_percent,/soilObs/soilSand,
38 
silt_percent,/soilObs/soilSilt,
39 
soil_texture,/soilObs/soilTexture,
23 
soil_acidity,"/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilAcidity]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
24 
soil_base,"/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilBase]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
25 
soil_Ca,"/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilCalcium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
26 
soil_C,"/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilCarbon]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
27 
soil_cation_cap,"/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilCationCap]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
28 
soil_conductivity,"/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilConductivity]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
29 
soil_Mg,"/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilMagnesium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
30 
soil_N,"/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilNitrogen]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
31 
soil_P,"/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilPhosphorus]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
32 
soil_K,"/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilPotassium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
33 
soil_Na,"/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilSodium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
34 
clay_percent,/soilObs:[soilHorizon=unknown]/soilClay,
35 
organic_percent,/soilObs:[soilHorizon=unknown]/soilOrganic,
36 
pH,/soilObs:[soilHorizon=unknown]/soilPH,"Brad: For all these soil variables, how do we store information on method, units. Seems like an ontological structure would be more appropriate (measurementName, measurementValue, measurementUnits, measurementMethod). Same as BIEN traits table. Something to discuss."
37 
sand_percent,/soilObs:[soilHorizon=unknown]/soilSand,
38 
silt_percent,/soilObs:[soilHorizon=unknown]/soilSilt,
39 
soil_texture,/soilObs:[soilHorizon=unknown]/soilTexture,
40 40 
plot_code,"/{*_ID/plot:[confidentialityStatus=0]/authorPlotCode/_alt/2,authorObsCode}",Brad: plotCode is as-assigned by data provider; guranteed to be unique only within dataset (=project)
mappings/SALVIAS_db-VegBank.plots.csv
20 20 
PlotMethod,/methodNarrative,
21 21 
date_finish,/obsEndDate/_date/date,
22 22 
date_start,/obsStartDate/_date/date,
23 
soil_acidity,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilAcidity]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
24 
soil_base,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilBase]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
25 
soil_Ca,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilCalcium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
26 
soil_C,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilCarbon]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
27 
soil_cation_cap,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilCationCap]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
28 
soil_conductivity,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilConductivity]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
29 
soil_Mg,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilMagnesium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
30 
soil_N,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilNitrogen]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
31 
soil_P,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilPhosphorus]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
32 
soil_K,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilPotassium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
33 
soil_Na,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilSodium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
34 
clay_percent,/soilObs/soilClay,
35 
organic_percent,/soilObs/soilOrganic,
36 
pH,/soilObs/soilPH,"Brad: For all these soil variables, how do we store information on method, units. Seems like an ontological structure would be more appropriate (measurementName, measurementValue, measurementUnits, measurementMethod). Same as BIEN traits table. Something to discuss."
37 
sand_percent,/soilObs/soilSand,
38 
silt_percent,/soilObs/soilSilt,
39 
soil_texture,/soilObs/soilTexture,
23 
soil_acidity,"/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilAcidity]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
24 
soil_base,"/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilBase]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
25 
soil_Ca,"/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilCalcium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
26 
soil_C,"/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilCarbon]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
27 
soil_cation_cap,"/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilCationCap]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
28 
soil_conductivity,"/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilConductivity]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
29 
soil_Mg,"/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilMagnesium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
30 
soil_N,"/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilNitrogen]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
31 
soil_P,"/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilPhosphorus]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
32 
soil_K,"/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilPotassium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
33 
soil_Na,"/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilSodium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
34 
clay_percent,/soilObs:[soilHorizon=unknown]/soilClay,
35 
organic_percent,/soilObs:[soilHorizon=unknown]/soilOrganic,
36 
pH,/soilObs:[soilHorizon=unknown]/soilPH,"Brad: For all these soil variables, how do we store information on method, units. Seems like an ontological structure would be more appropriate (measurementName, measurementValue, measurementUnits, measurementMethod). Same as BIEN traits table. Something to discuss."
37 
sand_percent,/soilObs:[soilHorizon=unknown]/soilSand,
38 
silt_percent,/soilObs:[soilHorizon=unknown]/soilSilt,
39 
soil_texture,/soilObs:[soilHorizon=unknown]/soilTexture,
40 40 
SiteCode,"/{*_ID/plot:[confidentialityStatus=0]/authorPlotCode/_alt/2,authorObsCode}",Brad: plotCode is as-assigned by data provider; guranteed to be unique only within dataset (=project)
mappings/SALVIAS_db-VegBIEN.plots.csv
20 20 
PlotMethod,/methodNarrative,
21 21 
date_finish,/obsEndDate/_date/date,
22 22 
date_start,/obsStartDate/_date/date,
23 
soil_acidity,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilAcidity]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
24 
soil_base,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilBase]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
25 
soil_Ca,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilCalcium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
26 
soil_C,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilCarbon]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
27 
soil_cation_cap,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilCationCap]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
28 
soil_conductivity,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilConductivity]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
29 
soil_Mg,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilMagnesium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
30 
soil_N,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilNitrogen]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
31 
soil_P,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilPhosphorus]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
32 
soil_K,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilPotassium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
33 
soil_Na,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilSodium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
34 
clay_percent,/soilObs/soilClay,
35 
organic_percent,/soilObs/soilOrganic,
36 
pH,/soilObs/soilPH,"Brad: For all these soil variables, how do we store information on method, units. Seems like an ontological structure would be more appropriate (measurementName, measurementValue, measurementUnits, measurementMethod). Same as BIEN traits table. Something to discuss."
37 
sand_percent,/soilObs/soilSand,
38 
silt_percent,/soilObs/soilSilt,
39 
soil_texture,/soilObs/soilTexture,
23 
soil_acidity,"/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilAcidity]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
24 
soil_base,"/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilBase]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
25 
soil_Ca,"/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilCalcium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
26 
soil_C,"/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilCarbon]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
27 
soil_cation_cap,"/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilCationCap]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
28 
soil_conductivity,"/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilConductivity]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
29 
soil_Mg,"/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilMagnesium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
30 
soil_N,"/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilNitrogen]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
31 
soil_P,"/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilPhosphorus]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
32 
soil_K,"/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilPotassium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
33 
soil_Na,"/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilSodium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",
34 
clay_percent,/soilObs:[soilHorizon=unknown]/soilClay,
35 
organic_percent,/soilObs:[soilHorizon=unknown]/soilOrganic,
36 
pH,/soilObs:[soilHorizon=unknown]/soilPH,"Brad: For all these soil variables, how do we store information on method, units. Seems like an ontological structure would be more appropriate (measurementName, measurementValue, measurementUnits, measurementMethod). Same as BIEN traits table. Something to discuss."
37 
sand_percent,/soilObs:[soilHorizon=unknown]/soilSand,
38 
silt_percent,/soilObs:[soilHorizon=unknown]/soilSilt,
39 
soil_texture,/soilObs:[soilHorizon=unknown]/soilTexture,
40 40 
SiteCode,"/{*_ID/plot:[confidentialityStatus=0]/authorPlotCode/_alt/2,authorObsCode}",Brad: plotCode is as-assigned by data provider; guranteed to be unique only within dataset (=project)
mappings/VegX-VegBank.plots.csv
29 29 
/obsStartDate/_date/day,/obsStartDate/_date/day
30 30 
/obsStartDate/_date/month,/obsStartDate/_date/month
31 31 
/obsStartDate/_date/year,/obsStartDate/_date/year
32 
->/*s/abioticObservation[*ID]/simpleUserdefined[name=acidity]/value,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilAcidity]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
33 
->/*s/abioticObservation[*ID]/simpleUserdefined[name=base]/value,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilBase]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
34 
->/*s/abioticObservation[*ID]/simpleUserdefined[name=calcium]/value,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilCalcium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
35 
->/*s/abioticObservation[*ID]/simpleUserdefined[name=carbon]/value,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilCarbon]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
36 
->/*s/abioticObservation[*ID]/simpleUserdefined[name=cationCap]/value,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilCationCap]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
37 
->/*s/abioticObservation[*ID]/simpleUserdefined[name=conductivity]/value,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilConductivity]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
38 
->/*s/abioticObservation[*ID]/magnesium,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilMagnesium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
39 
->/*s/abioticObservation[*ID]/nitrogen,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilNitrogen]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
40 
->/*s/abioticObservation[*ID]/phosphorus,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilPhosphorus]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
41 
->/*s/abioticObservation[*ID]/pottasium,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilPotassium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
42 
->/*s/abioticObservation[*ID]/simpleUserdefined[name=sodium]/value,"/soilObs/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilSodium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
43 
->/*s/abioticObservation[*ID]/simpleUserdefined[name=clayPercent]/value,/soilObs/soilClay
44 
->/*s/abioticObservation[*ID]/simpleUserdefined[name=organicPercent]/value,/soilObs/soilOrganic
45 
->/*s/abioticObservation[*ID]/ph,/soilObs/soilPH
46 
->/*s/abioticObservation[*ID]/simpleUserdefined[name=sandPercent]/value,/soilObs/soilSand
47 
->/*s/abioticObservation[*ID]/simpleUserdefined[name=siltPercent]/value,/soilObs/soilSilt
48 
->/*s/abioticObservation[*ID]/simpleUserdefined[name=texture]/value,/soilObs/soilTexture
32 
->/*s/abioticObservation[*ID]/simpleUserdefined[name=acidity]/value,"/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilAcidity]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
33 
->/*s/abioticObservation[*ID]/simpleUserdefined[name=base]/value,"/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilBase]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
34 
->/*s/abioticObservation[*ID]/simpleUserdefined[name=calcium]/value,"/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilCalcium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
35 
->/*s/abioticObservation[*ID]/simpleUserdefined[name=carbon]/value,"/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilCarbon]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
36 
->/*s/abioticObservation[*ID]/simpleUserdefined[name=cationCap]/value,"/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilCationCap]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
37 
->/*s/abioticObservation[*ID]/simpleUserdefined[name=conductivity]/value,"/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilConductivity]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
38 
->/*s/abioticObservation[*ID]/magnesium,"/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilMagnesium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
39 
->/*s/abioticObservation[*ID]/nitrogen,"/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilNitrogen]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
40 
->/*s/abioticObservation[*ID]/phosphorus,"/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilPhosphorus]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
41 
->/*s/abioticObservation[*ID]/pottasium,"/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilPotassium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
42 
->/*s/abioticObservation[*ID]/simpleUserdefined[name=sodium]/value,"/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilSodium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
43 
->/*s/abioticObservation[*ID]/simpleUserdefined[name=clayPercent]/value,/soilObs:[soilHorizon=unknown]/soilClay
44 
->/*s/abioticObservation[*ID]/simpleUserdefined[name=organicPercent]/value,/soilObs:[soilHorizon=unknown]/soilOrganic
45 
->/*s/abioticObservation[*ID]/ph,/soilObs:[soilHorizon=unknown]/soilPH
46 
->/*s/abioticObservation[*ID]/simpleUserdefined[name=sandPercent]/value,/soilObs:[soilHorizon=unknown]/soilSand
47 
->/*s/abioticObservation[*ID]/simpleUserdefined[name=siltPercent]/value,/soilObs:[soilHorizon=unknown]/soilSilt
48 
->/*s/abioticObservation[*ID]/simpleUserdefined[name=texture]/value,/soilObs:[soilHorizon=unknown]/soilTexture
49 49 
/*UniqueIdentifierID->/*s/plot/geospatial/maximumDepthInMeters,/waterDepth/max
50 50 
/*UniqueIdentifierID->/*s/plot/geospatial/minimumDepthInMeters,/waterDepth/min
51 51 
/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,"/{*_ID/plot:[confidentialityStatus=0]/authorPlotCode/_alt/2,authorObsCode}"

Also available in: Unified diff