Revision 1226
Added by Aaron Marcuse-Kubitza almost 13 years ago
| inputs/SALVIAS/maps/VegX.plots.csv | ||
|---|---|---|
| 29 | 29 |
"bearing",, |
| 30 | 30 |
"slope_aspect","/*UniqueIdentifierID->/*s/plot/slopeAspect", |
| 31 | 31 |
"slope_gradient","/*UniqueIdentifierID->/*s/plot/slopeGradient", |
| 32 |
"clay_percent","->/*s/abioticObservation[*ID]/simpleUserdefined[name=clayPercent]/value", |
|
| 33 |
"silt_percent","->/*s/abioticObservation[*ID]/simpleUserdefined[name=siltPercent]/value", |
|
| 34 |
"sand_percent","->/*s/abioticObservation[*ID]/simpleUserdefined[name=sandPercent]/value", |
|
| 32 |
"clay_percent","->/*s/abioticObservation[*ID]/simpleUserdefined[name=clayPercent]/value/_units:[units=""%""]/value",
|
|
| 33 |
"silt_percent","->/*s/abioticObservation[*ID]/simpleUserdefined[name=siltPercent]/value/_units:[units=""%""]/value",
|
|
| 34 |
"sand_percent","->/*s/abioticObservation[*ID]/simpleUserdefined[name=sandPercent]/value/_units:[units=""%""]/value",
|
|
| 35 | 35 |
"pH","->/*s/abioticObservation[*ID]/ph","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." |
| 36 |
"soil_N","->/*s/abioticObservation[*ID]/nitrogen", |
|
| 37 |
"soil_P","->/*s/abioticObservation[*ID]/phosphorus", |
|
| 38 |
"soil_C","->/*s/abioticObservation[*ID]/simpleUserdefined[name=carbon]/value", |
|
| 39 |
"soil_K","->/*s/abioticObservation[*ID]/pottasium", |
|
| 40 |
"soil_Mg","->/*s/abioticObservation[*ID]/magnesium", |
|
| 41 |
"soil_Ca","->/*s/abioticObservation[*ID]/simpleUserdefined[name=calcium]/value", |
|
| 42 |
"soil_Na","->/*s/abioticObservation[*ID]/simpleUserdefined[name=sodium]/value", |
|
| 43 |
"soil_acidity","->/*s/abioticObservation[*ID]/simpleUserdefined[name=acidity]/value", |
|
| 44 |
"soil_base","->/*s/abioticObservation[*ID]/simpleUserdefined[name=base]/value", |
|
| 36 |
"soil_N","->/*s/abioticObservation[*ID]/nitrogen/_units:[units=""%""]/value",
|
|
| 37 |
"soil_P","->/*s/abioticObservation[*ID]/phosphorus/_map:[""<1,5""=0]/value/_units:[units=""%""]/value",
|
|
| 38 |
"soil_C","->/*s/abioticObservation[*ID]/simpleUserdefined[name=carbon]/value/_units:[units=""%""]/value",
|
|
| 39 |
"soil_K","->/*s/abioticObservation[*ID]/pottasium/_units:[units=""%""]/value",
|
|
| 40 |
"soil_Mg","->/*s/abioticObservation[*ID]/magnesium/_units:[units=""%""]/value",
|
|
| 41 |
"soil_Ca","->/*s/abioticObservation[*ID]/simpleUserdefined[name=calcium]/value/_units:[units=""%""]/value",
|
|
| 42 |
"soil_Na","->/*s/abioticObservation[*ID]/simpleUserdefined[name=sodium]/value/_units:[units=""%""]/value",
|
|
| 43 |
"soil_acidity","->/*s/abioticObservation[*ID]/simpleUserdefined[name=acidity]/value/_map:[""<0.05""=0]/value/_units:[units=""%""]/value",
|
|
| 44 |
"soil_base","->/*s/abioticObservation[*ID]/simpleUserdefined[name=base]/value/_units:[units=""%""]/value",
|
|
| 45 | 45 |
"soil_cation_cap","->/*s/abioticObservation[*ID]/simpleUserdefined[name=cationCap]/value", |
| 46 | 46 |
"soil_conductivity","->/*s/abioticObservation[*ID]/simpleUserdefined[name=conductivity]/value", |
| 47 |
"organic_percent","->/*s/abioticObservation[*ID]/simpleUserdefined[name=organicPercent]/value", |
|
| 48 |
"soil_texture","->/*s/abioticObservation[*ID]/simpleUserdefined[name=texture]/value", |
|
| 47 |
"organic_percent","->/*s/abioticObservation[*ID]/simpleUserdefined[name=organicPercent]/value/_units:[units=""%""]/value",
|
|
| 48 |
"soil_texture","->/*s/abioticObservation[*ID]/simpleUserdefined[name=texture]/value/_units:[units=""%""]/value",
|
|
| 49 | 49 |
"RevisionComments",, |
| 50 | 50 |
"Locality_Description","/*UniqueIdentifierID->/*s/plot/simpleUserdefined[name=localityDescription]/value","Brad: No; this is free text description of locality where plot was situated, same as for DwC. Not a description of vegetation. Most likely='namedPlace.placeDescription' in VB; not sure about VX, again need to ask Nick where locality descriptions live in VX" |
| 51 | 51 |
"topography_desc",, |
| inputs/SALVIAS/maps/VegX.plots.full.csv | ||
|---|---|---|
| 29 | 29 |
"bearing",, |
| 30 | 30 |
"slope_aspect","/*UniqueIdentifierID->/*s/plot/slopeAspect", |
| 31 | 31 |
"slope_gradient","/*UniqueIdentifierID->/*s/plot/slopeGradient", |
| 32 |
"clay_percent","->/*s/abioticObservation[*ID]/simpleUserdefined[name=clayPercent]/value", |
|
| 33 |
"silt_percent","->/*s/abioticObservation[*ID]/simpleUserdefined[name=siltPercent]/value", |
|
| 34 |
"sand_percent","->/*s/abioticObservation[*ID]/simpleUserdefined[name=sandPercent]/value", |
|
| 32 |
"clay_percent","->/*s/abioticObservation[*ID]/simpleUserdefined[name=clayPercent]/value/_units:[units=""%""]/value",
|
|
| 33 |
"silt_percent","->/*s/abioticObservation[*ID]/simpleUserdefined[name=siltPercent]/value/_units:[units=""%""]/value",
|
|
| 34 |
"sand_percent","->/*s/abioticObservation[*ID]/simpleUserdefined[name=sandPercent]/value/_units:[units=""%""]/value",
|
|
| 35 | 35 |
"pH","->/*s/abioticObservation[*ID]/ph","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." |
| 36 |
"soil_N","->/*s/abioticObservation[*ID]/nitrogen", |
|
| 37 |
"soil_P","->/*s/abioticObservation[*ID]/phosphorus", |
|
| 38 |
"soil_C","->/*s/abioticObservation[*ID]/simpleUserdefined[name=carbon]/value", |
|
| 39 |
"soil_K","->/*s/abioticObservation[*ID]/pottasium", |
|
| 40 |
"soil_Mg","->/*s/abioticObservation[*ID]/magnesium", |
|
| 41 |
"soil_Ca","->/*s/abioticObservation[*ID]/simpleUserdefined[name=calcium]/value", |
|
| 42 |
"soil_Na","->/*s/abioticObservation[*ID]/simpleUserdefined[name=sodium]/value", |
|
| 43 |
"soil_acidity","->/*s/abioticObservation[*ID]/simpleUserdefined[name=acidity]/value", |
|
| 44 |
"soil_base","->/*s/abioticObservation[*ID]/simpleUserdefined[name=base]/value", |
|
| 36 |
"soil_N","->/*s/abioticObservation[*ID]/nitrogen/_units:[units=""%""]/value",
|
|
| 37 |
"soil_P","->/*s/abioticObservation[*ID]/phosphorus/_map:[""<1,5""=0]/value/_units:[units=""%""]/value",
|
|
| 38 |
"soil_C","->/*s/abioticObservation[*ID]/simpleUserdefined[name=carbon]/value/_units:[units=""%""]/value",
|
|
| 39 |
"soil_K","->/*s/abioticObservation[*ID]/pottasium/_units:[units=""%""]/value",
|
|
| 40 |
"soil_Mg","->/*s/abioticObservation[*ID]/magnesium/_units:[units=""%""]/value",
|
|
| 41 |
"soil_Ca","->/*s/abioticObservation[*ID]/simpleUserdefined[name=calcium]/value/_units:[units=""%""]/value",
|
|
| 42 |
"soil_Na","->/*s/abioticObservation[*ID]/simpleUserdefined[name=sodium]/value/_units:[units=""%""]/value",
|
|
| 43 |
"soil_acidity","->/*s/abioticObservation[*ID]/simpleUserdefined[name=acidity]/value/_map:[""<0.05""=0]/value/_units:[units=""%""]/value",
|
|
| 44 |
"soil_base","->/*s/abioticObservation[*ID]/simpleUserdefined[name=base]/value/_units:[units=""%""]/value",
|
|
| 45 | 45 |
"soil_cation_cap","->/*s/abioticObservation[*ID]/simpleUserdefined[name=cationCap]/value", |
| 46 | 46 |
"soil_conductivity","->/*s/abioticObservation[*ID]/simpleUserdefined[name=conductivity]/value", |
| 47 |
"organic_percent","->/*s/abioticObservation[*ID]/simpleUserdefined[name=organicPercent]/value", |
|
| 48 |
"soil_texture","->/*s/abioticObservation[*ID]/simpleUserdefined[name=texture]/value", |
|
| 47 |
"organic_percent","->/*s/abioticObservation[*ID]/simpleUserdefined[name=organicPercent]/value/_units:[units=""%""]/value",
|
|
| 48 |
"soil_texture","->/*s/abioticObservation[*ID]/simpleUserdefined[name=texture]/value/_units:[units=""%""]/value",
|
|
| 49 | 49 |
"RevisionComments",, |
| 50 | 50 |
"Locality_Description","/*UniqueIdentifierID->/*s/plot/simpleUserdefined[name=localityDescription]/value","Brad: No; this is free text description of locality where plot was situated, same as for DwC. Not a description of vegetation. Most likely='namedPlace.placeDescription' in VB; not sure about VX, again need to ask Nick where locality descriptions live in VX" |
| 51 | 51 |
"topography_desc",, |
| inputs/SALVIAS/maps/VegBIEN.plots.csv | ||
|---|---|---|
| 19 | 19 |
date_finish,/obsenddate/_*/date, |
| 20 | 20 |
date_start,/obsstartdate/_*/date, |
| 21 | 21 |
Precip,/precipitation, |
| 22 |
soil_acidity,"/soilobs:[soilhorizon=unknown]/definedvalue[*_id/userdefined[tablename=soilObs,userdefinedname=soilAcidity]]:[@fkey=tablerecord_id]/definedvalue", |
|
| 23 |
soil_base,"/soilobs:[soilhorizon=unknown]/definedvalue[*_id/userdefined[tablename=soilObs,userdefinedname=soilBase]]:[@fkey=tablerecord_id]/definedvalue", |
|
| 24 |
soil_Ca,"/soilobs:[soilhorizon=unknown]/definedvalue[*_id/userdefined[tablename=soilObs,userdefinedname=soilCalcium]]:[@fkey=tablerecord_id]/definedvalue", |
|
| 25 |
soil_C,"/soilobs:[soilhorizon=unknown]/definedvalue[*_id/userdefined[tablename=soilObs,userdefinedname=soilCarbon]]:[@fkey=tablerecord_id]/definedvalue", |
|
| 22 |
soil_acidity,"/soilobs:[soilhorizon=unknown]/definedvalue[*_id/userdefined[tablename=soilObs,userdefinedname=soilAcidity]]:[@fkey=tablerecord_id]/definedvalue/_map:[""<0.05""=0]/value/_units:[units=""%""]/value",
|
|
| 23 |
soil_base,"/soilobs:[soilhorizon=unknown]/definedvalue[*_id/userdefined[tablename=soilObs,userdefinedname=soilBase]]:[@fkey=tablerecord_id]/definedvalue/_units:[units=""%""]/value",
|
|
| 24 |
soil_Ca,"/soilobs:[soilhorizon=unknown]/definedvalue[*_id/userdefined[tablename=soilObs,userdefinedname=soilCalcium]]:[@fkey=tablerecord_id]/definedvalue/_units:[units=""%""]/value",
|
|
| 25 |
soil_C,"/soilobs:[soilhorizon=unknown]/definedvalue[*_id/userdefined[tablename=soilObs,userdefinedname=soilCarbon]]:[@fkey=tablerecord_id]/definedvalue/_units:[units=""%""]/value",
|
|
| 26 | 26 |
soil_cation_cap,"/soilobs:[soilhorizon=unknown]/definedvalue[*_id/userdefined[tablename=soilObs,userdefinedname=soilCationCap]]:[@fkey=tablerecord_id]/definedvalue", |
| 27 | 27 |
soil_conductivity,"/soilobs:[soilhorizon=unknown]/definedvalue[*_id/userdefined[tablename=soilObs,userdefinedname=soilConductivity]]:[@fkey=tablerecord_id]/definedvalue", |
| 28 |
soil_Mg,"/soilobs:[soilhorizon=unknown]/definedvalue[*_id/userdefined[tablename=soilObs,userdefinedname=soilMagnesium]]:[@fkey=tablerecord_id]/definedvalue", |
|
| 29 |
soil_N,"/soilobs:[soilhorizon=unknown]/definedvalue[*_id/userdefined[tablename=soilObs,userdefinedname=soilNitrogen]]:[@fkey=tablerecord_id]/definedvalue", |
|
| 30 |
soil_P,"/soilobs:[soilhorizon=unknown]/definedvalue[*_id/userdefined[tablename=soilObs,userdefinedname=soilPhosphorus]]:[@fkey=tablerecord_id]/definedvalue", |
|
| 31 |
soil_K,"/soilobs:[soilhorizon=unknown]/definedvalue[*_id/userdefined[tablename=soilObs,userdefinedname=soilPotassium]]:[@fkey=tablerecord_id]/definedvalue", |
|
| 32 |
soil_Na,"/soilobs:[soilhorizon=unknown]/definedvalue[*_id/userdefined[tablename=soilObs,userdefinedname=soilSodium]]:[@fkey=tablerecord_id]/definedvalue", |
|
| 33 |
clay_percent,/soilobs:[soilhorizon=unknown]/soilclay,
|
|
| 34 |
organic_percent,/soilobs:[soilhorizon=unknown]/soilorganic,
|
|
| 28 |
soil_Mg,"/soilobs:[soilhorizon=unknown]/definedvalue[*_id/userdefined[tablename=soilObs,userdefinedname=soilMagnesium]]:[@fkey=tablerecord_id]/definedvalue/_units:[units=""%""]/value",
|
|
| 29 |
soil_N,"/soilobs:[soilhorizon=unknown]/definedvalue[*_id/userdefined[tablename=soilObs,userdefinedname=soilNitrogen]]:[@fkey=tablerecord_id]/definedvalue/_units:[units=""%""]/value",
|
|
| 30 |
soil_P,"/soilobs:[soilhorizon=unknown]/definedvalue[*_id/userdefined[tablename=soilObs,userdefinedname=soilPhosphorus]]:[@fkey=tablerecord_id]/definedvalue/_map:[""<1,5""=0]/value/_units:[units=""%""]/value",
|
|
| 31 |
soil_K,"/soilobs:[soilhorizon=unknown]/definedvalue[*_id/userdefined[tablename=soilObs,userdefinedname=soilPotassium]]:[@fkey=tablerecord_id]/definedvalue/_units:[units=""%""]/value",
|
|
| 32 |
soil_Na,"/soilobs:[soilhorizon=unknown]/definedvalue[*_id/userdefined[tablename=soilObs,userdefinedname=soilSodium]]:[@fkey=tablerecord_id]/definedvalue/_units:[units=""%""]/value",
|
|
| 33 |
clay_percent,"/soilobs:[soilhorizon=unknown]/soilclay/_units:[units=""%""]/value",
|
|
| 34 |
organic_percent,"/soilobs:[soilhorizon=unknown]/soilorganic/_units:[units=""%""]/value",
|
|
| 35 | 35 |
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." |
| 36 |
sand_percent,/soilobs:[soilhorizon=unknown]/soilsand,
|
|
| 37 |
silt_percent,/soilobs:[soilhorizon=unknown]/soilsilt,
|
|
| 38 |
soil_texture,/soilobs:[soilhorizon=unknown]/soiltexture,
|
|
| 36 |
sand_percent,"/soilobs:[soilhorizon=unknown]/soilsand/_units:[units=""%""]/value",
|
|
| 37 |
silt_percent,"/soilobs:[soilhorizon=unknown]/soilsilt/_units:[units=""%""]/value",
|
|
| 38 |
soil_texture,"/soilobs:[soilhorizon=unknown]/soiltexture/_units:[units=""%""]/value",
|
|
| 39 | 39 |
Temp,/temperature, |
| 40 | 40 |
SiteCode,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/authorlocationcode,Brad: plotCode is as-assigned by data provider; guranteed to be unique only within dataset (=project) |
| 41 | 41 |
PlotID,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/sourceaccessioncode,"Brad: This is artificial internal database ID; a unique identifier within SALVIAS DB to each plot, within the table plotMetadata." |
| inputs/SALVIAS-CSV/maps/VegX.plots.csv | ||
|---|---|---|
| 16 | 16 |
"precip_mm","/simpleUserdefined[name=precipMm]/value", |
| 17 | 17 |
"slope_aspect","/*UniqueIdentifierID->/*s/plot/slopeAspect", |
| 18 | 18 |
"slope_gradient","/*UniqueIdentifierID->/*s/plot/slopeGradient", |
| 19 |
"clay_percent","->/*s/abioticObservation[*ID]/simpleUserdefined[name=clayPercent]/value", |
|
| 20 |
"silt_percent","->/*s/abioticObservation[*ID]/simpleUserdefined[name=siltPercent]/value", |
|
| 21 |
"sand_percent","->/*s/abioticObservation[*ID]/simpleUserdefined[name=sandPercent]/value", |
|
| 22 |
"organic_percent","->/*s/abioticObservation[*ID]/simpleUserdefined[name=organicPercent]/value", |
|
| 19 |
"clay_percent","->/*s/abioticObservation[*ID]/simpleUserdefined[name=clayPercent]/value/_units:[units=""%""]/value",
|
|
| 20 |
"silt_percent","->/*s/abioticObservation[*ID]/simpleUserdefined[name=siltPercent]/value/_units:[units=""%""]/value",
|
|
| 21 |
"sand_percent","->/*s/abioticObservation[*ID]/simpleUserdefined[name=sandPercent]/value/_units:[units=""%""]/value",
|
|
| 22 |
"organic_percent","->/*s/abioticObservation[*ID]/simpleUserdefined[name=organicPercent]/value/_units:[units=""%""]/value",
|
|
| 23 | 23 |
"pH","->/*s/abioticObservation[*ID]/ph","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." |
| 24 |
"soil_N","->/*s/abioticObservation[*ID]/nitrogen", |
|
| 25 |
"soil_P","->/*s/abioticObservation[*ID]/phosphorus", |
|
| 26 |
"soil_C","->/*s/abioticObservation[*ID]/simpleUserdefined[name=carbon]/value", |
|
| 27 |
"soil_K","->/*s/abioticObservation[*ID]/pottasium", |
|
| 28 |
"soil_Mg","->/*s/abioticObservation[*ID]/magnesium", |
|
| 29 |
"soil_Ca","->/*s/abioticObservation[*ID]/simpleUserdefined[name=calcium]/value", |
|
| 30 |
"soil_Na","->/*s/abioticObservation[*ID]/simpleUserdefined[name=sodium]/value", |
|
| 31 |
"soil_acidity","->/*s/abioticObservation[*ID]/simpleUserdefined[name=acidity]/value", |
|
| 32 |
"soil_base","->/*s/abioticObservation[*ID]/simpleUserdefined[name=base]/value", |
|
| 24 |
"soil_N","->/*s/abioticObservation[*ID]/nitrogen/_units:[units=""%""]/value",
|
|
| 25 |
"soil_P","->/*s/abioticObservation[*ID]/phosphorus/_map:[""<1,5""=0]/value/_units:[units=""%""]/value",
|
|
| 26 |
"soil_C","->/*s/abioticObservation[*ID]/simpleUserdefined[name=carbon]/value/_units:[units=""%""]/value",
|
|
| 27 |
"soil_K","->/*s/abioticObservation[*ID]/pottasium/_units:[units=""%""]/value",
|
|
| 28 |
"soil_Mg","->/*s/abioticObservation[*ID]/magnesium/_units:[units=""%""]/value",
|
|
| 29 |
"soil_Ca","->/*s/abioticObservation[*ID]/simpleUserdefined[name=calcium]/value/_units:[units=""%""]/value",
|
|
| 30 |
"soil_Na","->/*s/abioticObservation[*ID]/simpleUserdefined[name=sodium]/value/_units:[units=""%""]/value",
|
|
| 31 |
"soil_acidity","->/*s/abioticObservation[*ID]/simpleUserdefined[name=acidity]/value/_map:[""<0.05""=0]/value/_units:[units=""%""]/value",
|
|
| 32 |
"soil_base","->/*s/abioticObservation[*ID]/simpleUserdefined[name=base]/value/_units:[units=""%""]/value",
|
|
| 33 | 33 |
"soil_cation_cap","->/*s/abioticObservation[*ID]/simpleUserdefined[name=cationCap]/value", |
| 34 | 34 |
"soil_conductivity","->/*s/abioticObservation[*ID]/simpleUserdefined[name=conductivity]/value", |
| 35 | 35 |
"soil_texture","->/*s/abioticObservation[*ID]/simpleUserdefined[name=texture]/value", |
| inputs/SALVIAS-CSV/maps/VegX.plots.full.csv | ||
|---|---|---|
| 16 | 16 |
"precip_mm","/simpleUserdefined[name=precipMm]/value", |
| 17 | 17 |
"slope_aspect","/*UniqueIdentifierID->/*s/plot/slopeAspect", |
| 18 | 18 |
"slope_gradient","/*UniqueIdentifierID->/*s/plot/slopeGradient", |
| 19 |
"clay_percent","->/*s/abioticObservation[*ID]/simpleUserdefined[name=clayPercent]/value", |
|
| 20 |
"silt_percent","->/*s/abioticObservation[*ID]/simpleUserdefined[name=siltPercent]/value", |
|
| 21 |
"sand_percent","->/*s/abioticObservation[*ID]/simpleUserdefined[name=sandPercent]/value", |
|
| 22 |
"organic_percent","->/*s/abioticObservation[*ID]/simpleUserdefined[name=organicPercent]/value", |
|
| 19 |
"clay_percent","->/*s/abioticObservation[*ID]/simpleUserdefined[name=clayPercent]/value/_units:[units=""%""]/value",
|
|
| 20 |
"silt_percent","->/*s/abioticObservation[*ID]/simpleUserdefined[name=siltPercent]/value/_units:[units=""%""]/value",
|
|
| 21 |
"sand_percent","->/*s/abioticObservation[*ID]/simpleUserdefined[name=sandPercent]/value/_units:[units=""%""]/value",
|
|
| 22 |
"organic_percent","->/*s/abioticObservation[*ID]/simpleUserdefined[name=organicPercent]/value/_units:[units=""%""]/value",
|
|
| 23 | 23 |
"pH","->/*s/abioticObservation[*ID]/ph","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." |
| 24 |
"soil_N","->/*s/abioticObservation[*ID]/nitrogen", |
|
| 25 |
"soil_P","->/*s/abioticObservation[*ID]/phosphorus", |
|
| 26 |
"soil_C","->/*s/abioticObservation[*ID]/simpleUserdefined[name=carbon]/value", |
|
| 27 |
"soil_K","->/*s/abioticObservation[*ID]/pottasium", |
|
| 28 |
"soil_Mg","->/*s/abioticObservation[*ID]/magnesium", |
|
| 29 |
"soil_Ca","->/*s/abioticObservation[*ID]/simpleUserdefined[name=calcium]/value", |
|
| 30 |
"soil_Na","->/*s/abioticObservation[*ID]/simpleUserdefined[name=sodium]/value", |
|
| 31 |
"soil_acidity","->/*s/abioticObservation[*ID]/simpleUserdefined[name=acidity]/value", |
|
| 32 |
"soil_base","->/*s/abioticObservation[*ID]/simpleUserdefined[name=base]/value", |
|
| 24 |
"soil_N","->/*s/abioticObservation[*ID]/nitrogen/_units:[units=""%""]/value",
|
|
| 25 |
"soil_P","->/*s/abioticObservation[*ID]/phosphorus/_map:[""<1,5""=0]/value/_units:[units=""%""]/value",
|
|
| 26 |
"soil_C","->/*s/abioticObservation[*ID]/simpleUserdefined[name=carbon]/value/_units:[units=""%""]/value",
|
|
| 27 |
"soil_K","->/*s/abioticObservation[*ID]/pottasium/_units:[units=""%""]/value",
|
|
| 28 |
"soil_Mg","->/*s/abioticObservation[*ID]/magnesium/_units:[units=""%""]/value",
|
|
| 29 |
"soil_Ca","->/*s/abioticObservation[*ID]/simpleUserdefined[name=calcium]/value/_units:[units=""%""]/value",
|
|
| 30 |
"soil_Na","->/*s/abioticObservation[*ID]/simpleUserdefined[name=sodium]/value/_units:[units=""%""]/value",
|
|
| 31 |
"soil_acidity","->/*s/abioticObservation[*ID]/simpleUserdefined[name=acidity]/value/_map:[""<0.05""=0]/value/_units:[units=""%""]/value",
|
|
| 32 |
"soil_base","->/*s/abioticObservation[*ID]/simpleUserdefined[name=base]/value/_units:[units=""%""]/value",
|
|
| 33 | 33 |
"soil_cation_cap","->/*s/abioticObservation[*ID]/simpleUserdefined[name=cationCap]/value", |
| 34 | 34 |
"soil_conductivity","->/*s/abioticObservation[*ID]/simpleUserdefined[name=conductivity]/value", |
| 35 | 35 |
"soil_texture","->/*s/abioticObservation[*ID]/simpleUserdefined[name=texture]/value", |
| inputs/SALVIAS-CSV/maps/VegBIEN.plots.csv | ||
|---|---|---|
| 19 | 19 |
date_finish,/obsenddate/_*/date, |
| 20 | 20 |
date_start,/obsstartdate/_*/date, |
| 21 | 21 |
precip_mm,/precipitation, |
| 22 |
soil_acidity,"/soilobs:[soilhorizon=unknown]/definedvalue[*_id/userdefined[tablename=soilObs,userdefinedname=soilAcidity]]:[@fkey=tablerecord_id]/definedvalue", |
|
| 23 |
soil_base,"/soilobs:[soilhorizon=unknown]/definedvalue[*_id/userdefined[tablename=soilObs,userdefinedname=soilBase]]:[@fkey=tablerecord_id]/definedvalue", |
|
| 24 |
soil_Ca,"/soilobs:[soilhorizon=unknown]/definedvalue[*_id/userdefined[tablename=soilObs,userdefinedname=soilCalcium]]:[@fkey=tablerecord_id]/definedvalue", |
|
| 25 |
soil_C,"/soilobs:[soilhorizon=unknown]/definedvalue[*_id/userdefined[tablename=soilObs,userdefinedname=soilCarbon]]:[@fkey=tablerecord_id]/definedvalue", |
|
| 22 |
soil_acidity,"/soilobs:[soilhorizon=unknown]/definedvalue[*_id/userdefined[tablename=soilObs,userdefinedname=soilAcidity]]:[@fkey=tablerecord_id]/definedvalue/_map:[""<0.05""=0]/value/_units:[units=""%""]/value",
|
|
| 23 |
soil_base,"/soilobs:[soilhorizon=unknown]/definedvalue[*_id/userdefined[tablename=soilObs,userdefinedname=soilBase]]:[@fkey=tablerecord_id]/definedvalue/_units:[units=""%""]/value",
|
|
| 24 |
soil_Ca,"/soilobs:[soilhorizon=unknown]/definedvalue[*_id/userdefined[tablename=soilObs,userdefinedname=soilCalcium]]:[@fkey=tablerecord_id]/definedvalue/_units:[units=""%""]/value",
|
|
| 25 |
soil_C,"/soilobs:[soilhorizon=unknown]/definedvalue[*_id/userdefined[tablename=soilObs,userdefinedname=soilCarbon]]:[@fkey=tablerecord_id]/definedvalue/_units:[units=""%""]/value",
|
|
| 26 | 26 |
soil_cation_cap,"/soilobs:[soilhorizon=unknown]/definedvalue[*_id/userdefined[tablename=soilObs,userdefinedname=soilCationCap]]:[@fkey=tablerecord_id]/definedvalue", |
| 27 | 27 |
soil_conductivity,"/soilobs:[soilhorizon=unknown]/definedvalue[*_id/userdefined[tablename=soilObs,userdefinedname=soilConductivity]]:[@fkey=tablerecord_id]/definedvalue", |
| 28 |
soil_Mg,"/soilobs:[soilhorizon=unknown]/definedvalue[*_id/userdefined[tablename=soilObs,userdefinedname=soilMagnesium]]:[@fkey=tablerecord_id]/definedvalue", |
|
| 29 |
soil_N,"/soilobs:[soilhorizon=unknown]/definedvalue[*_id/userdefined[tablename=soilObs,userdefinedname=soilNitrogen]]:[@fkey=tablerecord_id]/definedvalue", |
|
| 30 |
soil_P,"/soilobs:[soilhorizon=unknown]/definedvalue[*_id/userdefined[tablename=soilObs,userdefinedname=soilPhosphorus]]:[@fkey=tablerecord_id]/definedvalue", |
|
| 31 |
soil_K,"/soilobs:[soilhorizon=unknown]/definedvalue[*_id/userdefined[tablename=soilObs,userdefinedname=soilPotassium]]:[@fkey=tablerecord_id]/definedvalue", |
|
| 32 |
soil_Na,"/soilobs:[soilhorizon=unknown]/definedvalue[*_id/userdefined[tablename=soilObs,userdefinedname=soilSodium]]:[@fkey=tablerecord_id]/definedvalue", |
|
| 33 |
clay_percent,/soilobs:[soilhorizon=unknown]/soilclay,
|
|
| 34 |
organic_percent,/soilobs:[soilhorizon=unknown]/soilorganic,
|
|
| 28 |
soil_Mg,"/soilobs:[soilhorizon=unknown]/definedvalue[*_id/userdefined[tablename=soilObs,userdefinedname=soilMagnesium]]:[@fkey=tablerecord_id]/definedvalue/_units:[units=""%""]/value",
|
|
| 29 |
soil_N,"/soilobs:[soilhorizon=unknown]/definedvalue[*_id/userdefined[tablename=soilObs,userdefinedname=soilNitrogen]]:[@fkey=tablerecord_id]/definedvalue/_units:[units=""%""]/value",
|
|
| 30 |
soil_P,"/soilobs:[soilhorizon=unknown]/definedvalue[*_id/userdefined[tablename=soilObs,userdefinedname=soilPhosphorus]]:[@fkey=tablerecord_id]/definedvalue/_map:[""<1,5""=0]/value/_units:[units=""%""]/value",
|
|
| 31 |
soil_K,"/soilobs:[soilhorizon=unknown]/definedvalue[*_id/userdefined[tablename=soilObs,userdefinedname=soilPotassium]]:[@fkey=tablerecord_id]/definedvalue/_units:[units=""%""]/value",
|
|
| 32 |
soil_Na,"/soilobs:[soilhorizon=unknown]/definedvalue[*_id/userdefined[tablename=soilObs,userdefinedname=soilSodium]]:[@fkey=tablerecord_id]/definedvalue/_units:[units=""%""]/value",
|
|
| 33 |
clay_percent,"/soilobs:[soilhorizon=unknown]/soilclay/_units:[units=""%""]/value",
|
|
| 34 |
organic_percent,"/soilobs:[soilhorizon=unknown]/soilorganic/_units:[units=""%""]/value",
|
|
| 35 | 35 |
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." |
| 36 |
sand_percent,/soilobs:[soilhorizon=unknown]/soilsand,
|
|
| 37 |
silt_percent,/soilobs:[soilhorizon=unknown]/soilsilt,
|
|
| 36 |
sand_percent,"/soilobs:[soilhorizon=unknown]/soilsand/_units:[units=""%""]/value",
|
|
| 37 |
silt_percent,"/soilobs:[soilhorizon=unknown]/soilsilt/_units:[units=""%""]/value",
|
|
| 38 | 38 |
soil_texture,/soilobs:[soilhorizon=unknown]/soiltexture, |
| 39 | 39 |
temp_c,/temperature, |
| 40 | 40 |
plot_code,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/authorlocationcode,Brad: plotCode is as-assigned by data provider; guranteed to be unique only within dataset (=project) |
Also available in: Unified diff
SALVIAS inputs: Use new _units:[units="%"] on soil fields that are percents. Replace "<..." values with 0.