Revision 4913
Added by Aaron Marcuse-Kubitza about 12 years ago
| inputs/SALVIAS-CSV/Plot/map.csv | ||
|---|---|---|
| 21 | 21 |
sand_percent,sand_percent,, |
| 22 | 22 |
organic_percent,organic_percent,, |
| 23 | 23 |
pH,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,nitrogen_percent,, |
|
| 25 |
soil_P,phosphorus_percent,"/_map:[""<0.05""=0,*=*]/value", |
|
| 26 |
soil_C,carbon_percent,, |
|
| 27 |
soil_K,potassium_percent,, |
|
| 28 |
soil_Mg,magnesium_percent,, |
|
| 29 |
soil_Ca,calcium_percent,, |
|
| 30 |
soil_Na,sodium_percent,, |
|
| 31 |
soil_acidity,acidity_percent,"/_map:[""<0.05""=0,*=*]/value", |
|
| 32 |
soil_base,baseSaturation_percent,, |
|
| 24 |
soil_N,nitrogen_percent,,Assuming units are % based on the range of values
|
|
| 25 |
soil_P,phosphorus_percent,"/_map:[""<0.05""=0,*=*]/value",Assuming units are % based on the range of values
|
|
| 26 |
soil_C,carbon_percent,,Assuming units are % based on the range of values
|
|
| 27 |
soil_K,potassium_percent,,Assuming units are % based on the range of values
|
|
| 28 |
soil_Mg,magnesium_percent,,Assuming units are % based on the range of values
|
|
| 29 |
soil_Ca,calcium_percent,,Assuming units are % based on the range of values
|
|
| 30 |
soil_Na,sodium_percent,,Assuming units are % based on the range of values
|
|
| 31 |
soil_acidity,acidity_percent,"/_map:[""<0.05""=0,*=*]/value",Assuming units are % based on the range of values
|
|
| 32 |
soil_base,baseSaturation_percent,,Assuming units are % based on the range of values
|
|
| 33 | 33 |
soil_cation_cap,cationExchangeCapacity_cmol_kg,, |
| 34 | 34 |
soil_conductivity,conductivity,, |
| 35 | 35 |
soil_texture,texture,, |
| inputs/SALVIAS-CSV/Plot/VegBIEN.csv | ||
|---|---|---|
| 19 | 19 |
date_finish,/location/locationevent/obsenddate/_*/date/_alt/1, |
| 20 | 20 |
date_start,/location/locationevent/obsstartdate/_*/date/_alt/1, |
| 21 | 21 |
precip_mm,/location/locationevent/precipitation_m, |
| 22 |
soil_acidity,"/location/locationevent/soilobs/acidity_fraction/_percent_to_fraction/value/_map:[""<0.05""=0,*=*]/value", |
|
| 23 |
soil_base,/location/locationevent/soilobs/basesaturation_fraction/_percent_to_fraction/value, |
|
| 24 |
soil_Ca,/location/locationevent/soilobs/calcium_fraction/_percent_to_fraction/value, |
|
| 25 |
soil_C,/location/locationevent/soilobs/carbon_fraction/_percent_to_fraction/value, |
|
| 22 |
soil_acidity,"/location/locationevent/soilobs/acidity_fraction/_percent_to_fraction/value/_map:[""<0.05""=0,*=*]/value",Assuming units are % based on the range of values
|
|
| 23 |
soil_base,/location/locationevent/soilobs/basesaturation_fraction/_percent_to_fraction/value,Assuming units are % based on the range of values
|
|
| 24 |
soil_Ca,/location/locationevent/soilobs/calcium_fraction/_percent_to_fraction/value,Assuming units are % based on the range of values
|
|
| 25 |
soil_C,/location/locationevent/soilobs/carbon_fraction/_percent_to_fraction/value,Assuming units are % based on the range of values
|
|
| 26 | 26 |
soil_cation_cap,/location/locationevent/soilobs/cationexchangecapacity_cmol_kg, |
| 27 | 27 |
clay_percent,/location/locationevent/soilobs/clay_fraction/_percent_to_fraction/value, |
| 28 | 28 |
soil_conductivity,/location/locationevent/soilobs/conductivity, |
| 29 |
soil_Mg,/location/locationevent/soilobs/magnesium_fraction/_percent_to_fraction/value, |
|
| 30 |
soil_N,/location/locationevent/soilobs/nitrogen_fraction/_percent_to_fraction/value, |
|
| 29 |
soil_Mg,/location/locationevent/soilobs/magnesium_fraction/_percent_to_fraction/value,Assuming units are % based on the range of values
|
|
| 30 |
soil_N,/location/locationevent/soilobs/nitrogen_fraction/_percent_to_fraction/value,Assuming units are % based on the range of values
|
|
| 31 | 31 |
organic_percent,/location/locationevent/soilobs/organic_fraction/_percent_to_fraction/value, |
| 32 | 32 |
pH,/location/locationevent/soilobs/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." |
| 33 |
soil_P,"/location/locationevent/soilobs/phosphorus_fraction/_percent_to_fraction/value/_map:[""<0.05""=0,*=*]/value", |
|
| 34 |
soil_K,/location/locationevent/soilobs/potassium_fraction/_percent_to_fraction/value, |
|
| 33 |
soil_P,"/location/locationevent/soilobs/phosphorus_fraction/_percent_to_fraction/value/_map:[""<0.05""=0,*=*]/value",Assuming units are % based on the range of values
|
|
| 34 |
soil_K,/location/locationevent/soilobs/potassium_fraction/_percent_to_fraction/value,Assuming units are % based on the range of values
|
|
| 35 | 35 |
sand_percent,/location/locationevent/soilobs/sand_fraction/_percent_to_fraction/value, |
| 36 | 36 |
silt_percent,/location/locationevent/soilobs/silt_fraction/_percent_to_fraction/value, |
| 37 |
soil_Na,/location/locationevent/soilobs/sodium_fraction/_percent_to_fraction/value, |
|
| 37 |
soil_Na,/location/locationevent/soilobs/sodium_fraction/_percent_to_fraction/value,Assuming units are % based on the range of values
|
|
| 38 | 38 |
soil_texture,/location/locationevent/soilobs/texture, |
| 39 | 39 |
PLOT_ID,"/location/locationevent/taxonoccurrence/authortaxoncode/_first/1/_first/2/_if[@name=""if is organism""]/cond/_exists","Brad: This is artificial internal database ID; a unique identifier within SALVIAS DB to each plot, within the table plotMetadata." |
| 40 | 40 |
plot_code,"/location/locationevent/taxonoccurrence/authortaxoncode/_first/1/_first/2/_if[@name=""if is organism""]/cond/_exists",Brad: plotCode is as-assigned by data provider; guranteed to be unique only within dataset (=project) |
| inputs/SALVIAS-CSV/Plot/new_terms.csv | ||
|---|---|---|
| 11 | 11 |
elev_min_m,minimumElevationInMeters,, |
| 12 | 12 |
temp_c,temperature,, |
| 13 | 13 |
precip_mm,precipitation,, |
| 14 |
soil_N,nitrogen_percent,, |
|
| 15 |
soil_P,phosphorus_percent,"/_map:[""<0.05""=0,*=*]/value", |
|
| 16 |
soil_C,carbon_percent,, |
|
| 17 |
soil_K,potassium_percent,, |
|
| 18 |
soil_Mg,magnesium_percent,, |
|
| 19 |
soil_Ca,calcium_percent,, |
|
| 20 |
soil_Na,sodium_percent,, |
|
| 21 |
soil_acidity,acidity_percent,"/_map:[""<0.05""=0,*=*]/value", |
|
| 22 |
soil_base,baseSaturation_percent,, |
|
| 14 |
soil_N,nitrogen_percent,,Assuming units are % based on the range of values
|
|
| 15 |
soil_P,phosphorus_percent,"/_map:[""<0.05""=0,*=*]/value",Assuming units are % based on the range of values
|
|
| 16 |
soil_C,carbon_percent,,Assuming units are % based on the range of values
|
|
| 17 |
soil_K,potassium_percent,,Assuming units are % based on the range of values
|
|
| 18 |
soil_Mg,magnesium_percent,,Assuming units are % based on the range of values
|
|
| 19 |
soil_Ca,calcium_percent,,Assuming units are % based on the range of values
|
|
| 20 |
soil_Na,sodium_percent,,Assuming units are % based on the range of values
|
|
| 21 |
soil_acidity,acidity_percent,"/_map:[""<0.05""=0,*=*]/value",Assuming units are % based on the range of values
|
|
| 22 |
soil_base,baseSaturation_percent,,Assuming units are % based on the range of values
|
|
| 23 | 23 |
soil_cation_cap,cationExchangeCapacity_cmol_kg,, |
| 24 | 24 |
soil_conductivity,conductivity,, |
| 25 | 25 |
soil_texture,texture,, |
| inputs/SALVIAS/plotMetadata/map.csv | ||
|---|---|---|
| 33 | 33 |
silt_percent,silt_percent,, |
| 34 | 34 |
sand_percent,sand_percent,, |
| 35 | 35 |
pH,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,nitrogen_percent,, |
|
| 37 |
soil_P,phosphorus_percent,"/_map:[""<1,5""=0,*=*]/value", |
|
| 38 |
soil_C,carbon_percent,, |
|
| 39 |
soil_K,potassium_percent,, |
|
| 40 |
soil_Mg,magnesium_percent,, |
|
| 41 |
soil_Ca,calcium_percent,, |
|
| 42 |
soil_Na,sodium_percent,, |
|
| 43 |
soil_acidity,acidity_percent,"/_map:[""<0.05""=0,*=*]/value", |
|
| 44 |
soil_base,baseSaturation_percent,, |
|
| 36 |
soil_N,nitrogen_percent,,Assuming units are % based on the range of values
|
|
| 37 |
soil_P,phosphorus_percent,"/_map:[""<1,5""=0,*=*]/value",Assuming units are % based on the range of values
|
|
| 38 |
soil_C,carbon_percent,,Assuming units are % based on the range of values
|
|
| 39 |
soil_K,potassium_percent,,Assuming units are % based on the range of values
|
|
| 40 |
soil_Mg,magnesium_percent,,Assuming units are % based on the range of values
|
|
| 41 |
soil_Ca,calcium_percent,,Assuming units are % based on the range of values
|
|
| 42 |
soil_Na,sodium_percent,,Assuming units are % based on the range of values
|
|
| 43 |
soil_acidity,acidity_percent,"/_map:[""<0.05""=0,*=*]/value",Assuming units are % based on the range of values
|
|
| 44 |
soil_base,baseSaturation_percent,,Assuming units are % based on the range of values
|
|
| 45 | 45 |
soil_cation_cap,cationExchangeCapacity_cmol_kg,, |
| 46 | 46 |
soil_conductivity,conductivity,, |
| 47 | 47 |
organic_percent,organic_percent,, |
| inputs/SALVIAS/plotMetadata/VegBIEN.csv | ||
|---|---|---|
| 19 | 19 |
date_finish,/location/locationevent/obsenddate/_*/date/_alt/1, |
| 20 | 20 |
date_start,/location/locationevent/obsstartdate/_*/date/_alt/1, |
| 21 | 21 |
Precip,/location/locationevent/precipitation_m, |
| 22 |
soil_acidity,"/location/locationevent/soilobs/acidity_fraction/_percent_to_fraction/value/_map:[""<0.05""=0,*=*]/value", |
|
| 23 |
soil_base,/location/locationevent/soilobs/basesaturation_fraction/_percent_to_fraction/value, |
|
| 24 |
soil_Ca,/location/locationevent/soilobs/calcium_fraction/_percent_to_fraction/value, |
|
| 25 |
soil_C,/location/locationevent/soilobs/carbon_fraction/_percent_to_fraction/value, |
|
| 22 |
soil_acidity,"/location/locationevent/soilobs/acidity_fraction/_percent_to_fraction/value/_map:[""<0.05""=0,*=*]/value",Assuming units are % based on the range of values
|
|
| 23 |
soil_base,/location/locationevent/soilobs/basesaturation_fraction/_percent_to_fraction/value,Assuming units are % based on the range of values
|
|
| 24 |
soil_Ca,/location/locationevent/soilobs/calcium_fraction/_percent_to_fraction/value,Assuming units are % based on the range of values
|
|
| 25 |
soil_C,/location/locationevent/soilobs/carbon_fraction/_percent_to_fraction/value,Assuming units are % based on the range of values
|
|
| 26 | 26 |
soil_cation_cap,/location/locationevent/soilobs/cationexchangecapacity_cmol_kg, |
| 27 | 27 |
clay_percent,/location/locationevent/soilobs/clay_fraction/_percent_to_fraction/value, |
| 28 | 28 |
soil_conductivity,/location/locationevent/soilobs/conductivity, |
| 29 |
soil_Mg,/location/locationevent/soilobs/magnesium_fraction/_percent_to_fraction/value, |
|
| 30 |
soil_N,/location/locationevent/soilobs/nitrogen_fraction/_percent_to_fraction/value, |
|
| 29 |
soil_Mg,/location/locationevent/soilobs/magnesium_fraction/_percent_to_fraction/value,Assuming units are % based on the range of values
|
|
| 30 |
soil_N,/location/locationevent/soilobs/nitrogen_fraction/_percent_to_fraction/value,Assuming units are % based on the range of values
|
|
| 31 | 31 |
organic_percent,/location/locationevent/soilobs/organic_fraction/_percent_to_fraction/value, |
| 32 | 32 |
pH,/location/locationevent/soilobs/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." |
| 33 |
soil_P,"/location/locationevent/soilobs/phosphorus_fraction/_percent_to_fraction/value/_map:[""<1,5""=0,*=*]/value", |
|
| 34 |
soil_K,/location/locationevent/soilobs/potassium_fraction/_percent_to_fraction/value, |
|
| 33 |
soil_P,"/location/locationevent/soilobs/phosphorus_fraction/_percent_to_fraction/value/_map:[""<1,5""=0,*=*]/value",Assuming units are % based on the range of values
|
|
| 34 |
soil_K,/location/locationevent/soilobs/potassium_fraction/_percent_to_fraction/value,Assuming units are % based on the range of values
|
|
| 35 | 35 |
sand_percent,/location/locationevent/soilobs/sand_fraction/_percent_to_fraction/value, |
| 36 | 36 |
silt_percent,/location/locationevent/soilobs/silt_fraction/_percent_to_fraction/value, |
| 37 |
soil_Na,/location/locationevent/soilobs/sodium_fraction/_percent_to_fraction/value, |
|
| 37 |
soil_Na,/location/locationevent/soilobs/sodium_fraction/_percent_to_fraction/value,Assuming units are % based on the range of values
|
|
| 38 | 38 |
soil_texture,/location/locationevent/soilobs/texture, |
| 39 | 39 |
PlotID,"/location/locationevent/taxonoccurrence/authortaxoncode/_first/1/_first/2/_if[@name=""if is organism""]/cond/_exists","Brad: This is artificial internal database ID; a unique identifier within SALVIAS DB to each plot, within the table plotMetadata." |
| 40 | 40 |
SiteCode,"/location/locationevent/taxonoccurrence/authortaxoncode/_first/1/_first/2/_if[@name=""if is organism""]/cond/_exists",Brad: plotCode is as-assigned by data provider; guranteed to be unique only within dataset (=project) |
| inputs/SALVIAS/plotMetadata/new_terms.csv | ||
|---|---|---|
| 9 | 9 |
elev_min_m,minimumElevationInMeters,, |
| 10 | 10 |
Precip,precipitation,, |
| 11 | 11 |
Temp,temperature,, |
| 12 |
soil_N,nitrogen_percent,, |
|
| 13 |
soil_P,phosphorus_percent,"/_map:[""<1,5""=0,*=*]/value", |
|
| 14 |
soil_C,carbon_percent,, |
|
| 15 |
soil_K,potassium_percent,, |
|
| 16 |
soil_Mg,magnesium_percent,, |
|
| 17 |
soil_Ca,calcium_percent,, |
|
| 18 |
soil_Na,sodium_percent,, |
|
| 19 |
soil_acidity,acidity_percent,"/_map:[""<0.05""=0,*=*]/value", |
|
| 20 |
soil_base,baseSaturation_percent,, |
|
| 12 |
soil_N,nitrogen_percent,,Assuming units are % based on the range of values
|
|
| 13 |
soil_P,phosphorus_percent,"/_map:[""<1,5""=0,*=*]/value",Assuming units are % based on the range of values
|
|
| 14 |
soil_C,carbon_percent,,Assuming units are % based on the range of values
|
|
| 15 |
soil_K,potassium_percent,,Assuming units are % based on the range of values
|
|
| 16 |
soil_Mg,magnesium_percent,,Assuming units are % based on the range of values
|
|
| 17 |
soil_Ca,calcium_percent,,Assuming units are % based on the range of values
|
|
| 18 |
soil_Na,sodium_percent,,Assuming units are % based on the range of values
|
|
| 19 |
soil_acidity,acidity_percent,"/_map:[""<0.05""=0,*=*]/value",Assuming units are % based on the range of values
|
|
| 20 |
soil_base,baseSaturation_percent,,Assuming units are % based on the range of values
|
|
| 21 | 21 |
soil_cation_cap,cationExchangeCapacity_cmol_kg,, |
| 22 | 22 |
soil_conductivity,conductivity,, |
| 23 | 23 |
soil_texture,texture,, |
Also available in: Unified diff
inputs/SALVIAS/plotMetadata/map.csv, inputs/SALVIAS-CSV/Plot/map.csv: Soil component measurements: Documented that units are assumed to be % based on the range of values