Revision 1230
Added by Aaron Marcuse-Kubitza almost 13 years ago
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]/acidity/_map:[""<0.05""=0]/value/_units:[units=""%""]/value",
|
|
23 |
soil_base,"/soilobs:[soilhorizon=unknown]/basesaturation/_units:[units=""%""]/value",
|
|
24 |
soil_Ca,"/soilobs:[soilhorizon=unknown]/calcium/_units:[units=""%""]/value",
|
|
25 |
soil_C,"/soilobs:[soilhorizon=unknown]/carbon/_units:[units=""%""]/value",
|
|
26 |
soil_cation_cap,/soilobs:[soilhorizon=unknown]/cationexchangecapacity,
|
|
27 |
clay_percent,"/soilobs:[soilhorizon=unknown]/clay/_units:[units=""%""]/value",
|
|
28 |
soil_conductivity,/soilobs:[soilhorizon=unknown]/conductivity,
|
|
29 |
soil_Mg,"/soilobs:[soilhorizon=unknown]/magnesium/_units:[units=""%""]/value",
|
|
30 |
soil_N,"/soilobs:[soilhorizon=unknown]/nitrogen/_units:[units=""%""]/value",
|
|
31 |
organic_percent,"/soilobs:[soilhorizon=unknown]/organic/_units:[units=""%""]/value",
|
|
32 |
pH,/soilobs:[soilhorizon=unknown]/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,"/soilobs:[soilhorizon=unknown]/phosphorus/_map:[""<1,5""=0]/value/_units:[units=""%""]/value",
|
|
34 |
soil_K,"/soilobs:[soilhorizon=unknown]/potassium/_units:[units=""%""]/value",
|
|
35 |
sand_percent,"/soilobs:[soilhorizon=unknown]/sand/_units:[units=""%""]/value",
|
|
36 |
silt_percent,"/soilobs:[soilhorizon=unknown]/silt/_units:[units=""%""]/value",
|
|
37 |
soil_Na,"/soilobs:[soilhorizon=unknown]/sodium/_units:[units=""%""]/value",
|
|
38 |
soil_texture,"/soilobs:[soilhorizon=unknown]/texture/_units:[units=""%""]/value",
|
|
22 |
soil_acidity,"/soilobs/acidity/_map:[""<0.05""=0]/value/_units:[units=""%""]/value", |
|
23 |
soil_base,"/soilobs/basesaturation/_units:[units=""%""]/value", |
|
24 |
soil_Ca,"/soilobs/calcium/_units:[units=""%""]/value", |
|
25 |
soil_C,"/soilobs/carbon/_units:[units=""%""]/value", |
|
26 |
soil_cation_cap,/soilobs/cationexchangecapacity, |
|
27 |
clay_percent,"/soilobs/clay/_units:[units=""%""]/value", |
|
28 |
soil_conductivity,/soilobs/conductivity, |
|
29 |
soil_Mg,"/soilobs/magnesium/_units:[units=""%""]/value", |
|
30 |
soil_N,"/soilobs/nitrogen/_units:[units=""%""]/value", |
|
31 |
organic_percent,"/soilobs/organic/_units:[units=""%""]/value", |
|
32 |
pH,/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,"/soilobs/phosphorus/_map:[""<1,5""=0]/value/_units:[units=""%""]/value", |
|
34 |
soil_K,"/soilobs/potassium/_units:[units=""%""]/value", |
|
35 |
sand_percent,"/soilobs/sand/_units:[units=""%""]/value", |
|
36 |
silt_percent,"/soilobs/silt/_units:[units=""%""]/value", |
|
37 |
soil_Na,"/soilobs/sodium/_units:[units=""%""]/value", |
|
38 |
soil_texture,"/soilobs/texture/_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/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]/acidity/_map:[""<0.05""=0]/value/_units:[units=""%""]/value",
|
|
23 |
soil_base,"/soilobs:[soilhorizon=unknown]/basesaturation/_units:[units=""%""]/value",
|
|
24 |
soil_Ca,"/soilobs:[soilhorizon=unknown]/calcium/_units:[units=""%""]/value",
|
|
25 |
soil_C,"/soilobs:[soilhorizon=unknown]/carbon/_units:[units=""%""]/value",
|
|
26 |
soil_cation_cap,/soilobs:[soilhorizon=unknown]/cationexchangecapacity,
|
|
27 |
clay_percent,"/soilobs:[soilhorizon=unknown]/clay/_units:[units=""%""]/value",
|
|
28 |
soil_conductivity,/soilobs:[soilhorizon=unknown]/conductivity,
|
|
29 |
soil_Mg,"/soilobs:[soilhorizon=unknown]/magnesium/_units:[units=""%""]/value",
|
|
30 |
soil_N,"/soilobs:[soilhorizon=unknown]/nitrogen/_units:[units=""%""]/value",
|
|
31 |
organic_percent,"/soilobs:[soilhorizon=unknown]/organic/_units:[units=""%""]/value",
|
|
32 |
pH,/soilobs:[soilhorizon=unknown]/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,"/soilobs:[soilhorizon=unknown]/phosphorus/_map:[""<1,5""=0]/value/_units:[units=""%""]/value",
|
|
34 |
soil_K,"/soilobs:[soilhorizon=unknown]/potassium/_units:[units=""%""]/value",
|
|
35 |
sand_percent,"/soilobs:[soilhorizon=unknown]/sand/_units:[units=""%""]/value",
|
|
36 |
silt_percent,"/soilobs:[soilhorizon=unknown]/silt/_units:[units=""%""]/value",
|
|
37 |
soil_Na,"/soilobs:[soilhorizon=unknown]/sodium/_units:[units=""%""]/value",
|
|
38 |
soil_texture,/soilobs:[soilhorizon=unknown]/texture,
|
|
22 |
soil_acidity,"/soilobs/acidity/_map:[""<0.05""=0]/value/_units:[units=""%""]/value", |
|
23 |
soil_base,"/soilobs/basesaturation/_units:[units=""%""]/value", |
|
24 |
soil_Ca,"/soilobs/calcium/_units:[units=""%""]/value", |
|
25 |
soil_C,"/soilobs/carbon/_units:[units=""%""]/value", |
|
26 |
soil_cation_cap,/soilobs/cationexchangecapacity, |
|
27 |
clay_percent,"/soilobs/clay/_units:[units=""%""]/value", |
|
28 |
soil_conductivity,/soilobs/conductivity, |
|
29 |
soil_Mg,"/soilobs/magnesium/_units:[units=""%""]/value", |
|
30 |
soil_N,"/soilobs/nitrogen/_units:[units=""%""]/value", |
|
31 |
organic_percent,"/soilobs/organic/_units:[units=""%""]/value", |
|
32 |
pH,/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,"/soilobs/phosphorus/_map:[""<1,5""=0]/value/_units:[units=""%""]/value", |
|
34 |
soil_K,"/soilobs/potassium/_units:[units=""%""]/value", |
|
35 |
sand_percent,"/soilobs/sand/_units:[units=""%""]/value", |
|
36 |
silt_percent,"/soilobs/silt/_units:[units=""%""]/value", |
|
37 |
soil_Na,"/soilobs/sodium/_units:[units=""%""]/value", |
|
38 |
soil_texture,/soilobs/texture, |
|
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) |
41 | 41 |
PLOT_ID,:[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." |
schemas/vegbien.sql | ||
---|---|---|
2186 | 2186 |
CREATE TABLE soilobs ( |
2187 | 2187 |
soilobs_id integer NOT NULL, |
2188 | 2188 |
locationevent_id integer NOT NULL, |
2189 |
horizon text NOT NULL, |
|
2189 |
horizon text DEFAULT 'unknown'::text NOT NULL,
|
|
2190 | 2190 |
description text, |
2191 | 2191 |
depthtop double precision, |
2192 | 2192 |
depthbottom double precision, |
mappings/VegX-VegBIEN.plots.csv | ||
---|---|---|
25 | 25 |
/simpleUserdefined[name=parent]/value->/*s/plotObservation/partyWithRole/*ID->/parties/party/organizationName,/parent_id/locationevent:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/datasource_id/party/organizationname/_alt/1, |
26 | 26 |
/simpleUserdefined[name=parent]/value->/*s/plotObservation:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/simpleUserdefined[name=sourceaccessioncode]/value,/parent_id/locationevent:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/sourceaccessioncode, |
27 | 27 |
/simpleUserdefined[name=precipMm]/value,/precipitation, |
28 |
->/*s/abioticObservation[*ID]/simpleUserdefined[name=acidity]/value,/soilobs:[soilhorizon=unknown]/acidity,
|
|
29 |
->/*s/abioticObservation[*ID]/simpleUserdefined[name=base]/value,/soilobs:[soilhorizon=unknown]/basesaturation,
|
|
30 |
->/*s/abioticObservation[*ID]/simpleUserdefined[name=calcium]/value,/soilobs:[soilhorizon=unknown]/calcium,
|
|
31 |
->/*s/abioticObservation[*ID]/simpleUserdefined[name=carbon]/value,/soilobs:[soilhorizon=unknown]/carbon,
|
|
32 |
->/*s/abioticObservation[*ID]/simpleUserdefined[name=cationCap]/value,/soilobs:[soilhorizon=unknown]/cationexchangecapacity,
|
|
33 |
->/*s/abioticObservation[*ID]/simpleUserdefined[name=clayPercent]/value,/soilobs:[soilhorizon=unknown]/clay,
|
|
34 |
->/*s/abioticObservation[*ID]/simpleUserdefined[name=conductivity]/value,/soilobs:[soilhorizon=unknown]/conductivity,
|
|
35 |
->/*s/abioticObservation[*ID]/magnesium,/soilobs:[soilhorizon=unknown]/magnesium,
|
|
36 |
->/*s/abioticObservation[*ID]/nitrogen,/soilobs:[soilhorizon=unknown]/nitrogen,
|
|
37 |
->/*s/abioticObservation[*ID]/simpleUserdefined[name=organicPercent]/value,/soilobs:[soilhorizon=unknown]/organic,
|
|
38 |
->/*s/abioticObservation[*ID]/ph,/soilobs:[soilhorizon=unknown]/ph,
|
|
39 |
->/*s/abioticObservation[*ID]/phosphorus,/soilobs:[soilhorizon=unknown]/phosphorus,
|
|
40 |
->/*s/abioticObservation[*ID]/pottasium,/soilobs:[soilhorizon=unknown]/potassium,
|
|
41 |
->/*s/abioticObservation[*ID]/simpleUserdefined[name=sandPercent]/value,/soilobs:[soilhorizon=unknown]/sand,
|
|
42 |
->/*s/abioticObservation[*ID]/simpleUserdefined[name=siltPercent]/value,/soilobs:[soilhorizon=unknown]/silt,
|
|
43 |
->/*s/abioticObservation[*ID]/simpleUserdefined[name=sodium]/value,/soilobs:[soilhorizon=unknown]/sodium,
|
|
44 |
->/*s/abioticObservation[*ID]/simpleUserdefined[name=texture]/value,/soilobs:[soilhorizon=unknown]/texture,
|
|
28 |
->/*s/abioticObservation[*ID]/simpleUserdefined[name=acidity]/value,/soilobs/acidity, |
|
29 |
->/*s/abioticObservation[*ID]/simpleUserdefined[name=base]/value,/soilobs/basesaturation, |
|
30 |
->/*s/abioticObservation[*ID]/simpleUserdefined[name=calcium]/value,/soilobs/calcium, |
|
31 |
->/*s/abioticObservation[*ID]/simpleUserdefined[name=carbon]/value,/soilobs/carbon, |
|
32 |
->/*s/abioticObservation[*ID]/simpleUserdefined[name=cationCap]/value,/soilobs/cationexchangecapacity, |
|
33 |
->/*s/abioticObservation[*ID]/simpleUserdefined[name=clayPercent]/value,/soilobs/clay, |
|
34 |
->/*s/abioticObservation[*ID]/simpleUserdefined[name=conductivity]/value,/soilobs/conductivity, |
|
35 |
->/*s/abioticObservation[*ID]/magnesium,/soilobs/magnesium, |
|
36 |
->/*s/abioticObservation[*ID]/nitrogen,/soilobs/nitrogen, |
|
37 |
->/*s/abioticObservation[*ID]/simpleUserdefined[name=organicPercent]/value,/soilobs/organic, |
|
38 |
->/*s/abioticObservation[*ID]/ph,/soilobs/ph, |
|
39 |
->/*s/abioticObservation[*ID]/phosphorus,/soilobs/phosphorus, |
|
40 |
->/*s/abioticObservation[*ID]/pottasium,/soilobs/potassium, |
|
41 |
->/*s/abioticObservation[*ID]/simpleUserdefined[name=sandPercent]/value,/soilobs/sand, |
|
42 |
->/*s/abioticObservation[*ID]/simpleUserdefined[name=siltPercent]/value,/soilobs/silt, |
|
43 |
->/*s/abioticObservation[*ID]/simpleUserdefined[name=sodium]/value,/soilobs/sodium, |
|
44 |
->/*s/abioticObservation[*ID]/simpleUserdefined[name=texture]/value,/soilobs/texture, |
|
45 | 45 |
/temperature,/temperature, |
46 | 46 |
/*UniqueIdentifierID->/*s/plot/geospatial/maximumDepthInMeters,/waterdepth/max, |
47 | 47 |
/*UniqueIdentifierID->/*s/plot/geospatial/minimumDepthInMeters,/waterdepth/min, |
mappings/VegX-VegBIEN.organisms.csv | ||
---|---|---|
25 | 25 |
/*ID->/*s/plotObservation/simpleUserdefined[name=parent]/value->/*s/plotObservation/partyWithRole/*ID->/parties/party/organizationName,/*_id/locationevent/parent_id/locationevent:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/datasource_id/party/organizationname/_alt/1, |
26 | 26 |
/*ID->/*s/plotObservation/simpleUserdefined[name=parent]/value->/*s/plotObservation:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/simpleUserdefined[name=sourceaccessioncode]/value,/*_id/locationevent/parent_id/locationevent:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/sourceaccessioncode, |
27 | 27 |
/*ID->/*s/plotObservation/simpleUserdefined[name=precipMm]/value,/*_id/locationevent/precipitation, |
28 |
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=acidity]/value,/*_id/locationevent/soilobs:[soilhorizon=unknown]/acidity,
|
|
29 |
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=base]/value,/*_id/locationevent/soilobs:[soilhorizon=unknown]/basesaturation,
|
|
30 |
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=calcium]/value,/*_id/locationevent/soilobs:[soilhorizon=unknown]/calcium,
|
|
31 |
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=carbon]/value,/*_id/locationevent/soilobs:[soilhorizon=unknown]/carbon,
|
|
32 |
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=cationCap]/value,/*_id/locationevent/soilobs:[soilhorizon=unknown]/cationexchangecapacity,
|
|
33 |
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=clayPercent]/value,/*_id/locationevent/soilobs:[soilhorizon=unknown]/clay,
|
|
34 |
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=conductivity]/value,/*_id/locationevent/soilobs:[soilhorizon=unknown]/conductivity,
|
|
35 |
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/magnesium,/*_id/locationevent/soilobs:[soilhorizon=unknown]/magnesium,
|
|
36 |
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/nitrogen,/*_id/locationevent/soilobs:[soilhorizon=unknown]/nitrogen,
|
|
37 |
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=organicPercent]/value,/*_id/locationevent/soilobs:[soilhorizon=unknown]/organic,
|
|
38 |
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/ph,/*_id/locationevent/soilobs:[soilhorizon=unknown]/ph,
|
|
39 |
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/phosphorus,/*_id/locationevent/soilobs:[soilhorizon=unknown]/phosphorus,
|
|
40 |
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/pottasium,/*_id/locationevent/soilobs:[soilhorizon=unknown]/potassium,
|
|
41 |
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=sandPercent]/value,/*_id/locationevent/soilobs:[soilhorizon=unknown]/sand,
|
|
42 |
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=siltPercent]/value,/*_id/locationevent/soilobs:[soilhorizon=unknown]/silt,
|
|
43 |
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=sodium]/value,/*_id/locationevent/soilobs:[soilhorizon=unknown]/sodium,
|
|
44 |
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=texture]/value,/*_id/locationevent/soilobs:[soilhorizon=unknown]/texture,
|
|
28 |
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=acidity]/value,/*_id/locationevent/soilobs/acidity, |
|
29 |
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=base]/value,/*_id/locationevent/soilobs/basesaturation, |
|
30 |
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=calcium]/value,/*_id/locationevent/soilobs/calcium, |
|
31 |
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=carbon]/value,/*_id/locationevent/soilobs/carbon, |
|
32 |
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=cationCap]/value,/*_id/locationevent/soilobs/cationexchangecapacity, |
|
33 |
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=clayPercent]/value,/*_id/locationevent/soilobs/clay, |
|
34 |
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=conductivity]/value,/*_id/locationevent/soilobs/conductivity, |
|
35 |
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/magnesium,/*_id/locationevent/soilobs/magnesium, |
|
36 |
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/nitrogen,/*_id/locationevent/soilobs/nitrogen, |
|
37 |
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=organicPercent]/value,/*_id/locationevent/soilobs/organic, |
|
38 |
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/ph,/*_id/locationevent/soilobs/ph, |
|
39 |
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/phosphorus,/*_id/locationevent/soilobs/phosphorus, |
|
40 |
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/pottasium,/*_id/locationevent/soilobs/potassium, |
|
41 |
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=sandPercent]/value,/*_id/locationevent/soilobs/sand, |
|
42 |
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=siltPercent]/value,/*_id/locationevent/soilobs/silt, |
|
43 |
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=sodium]/value,/*_id/locationevent/soilobs/sodium, |
|
44 |
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=texture]/value,/*_id/locationevent/soilobs/texture, |
|
45 | 45 |
/*ID->/*s/plotObservation/temperature,/*_id/locationevent/temperature, |
46 | 46 |
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/maximumDepthInMeters,/*_id/locationevent/waterdepth/max, |
47 | 47 |
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/minimumDepthInMeters,/*_id/locationevent/waterdepth/min, |
Also available in: Unified diff
VegBIEN: soilobs: Added default value for horizon. Adjusted mappings to remove now-unecessary horizon value.