Revision 6482
Added by Aaron Marcuse-Kubitza about 12 years ago
| inputs/SALVIAS/plotMetadata_/VegBIEN.csv | ||
|---|---|---|
| 28 | 28 |
date_finish,/location/locationevent/obsenddate/_alt/1, |
| 29 | 29 |
date_start,/location/locationevent/obsstartdate/_alt/1, |
| 30 | 30 |
Precip,/location/locationevent/precipitation_m, |
| 31 |
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
|
|
| 32 |
soil_base,/location/locationevent/soilobs/basesaturation_fraction/_percent_to_fraction/value,Assuming units are % based on the range of values
|
|
| 33 |
soil_Ca,/location/locationevent/soilobs/calcium_fraction/_percent_to_fraction/value,Assuming units are % based on the range of values
|
|
| 34 |
soil_C,/location/locationevent/soilobs/carbon_fraction/_percent_to_fraction/value,Assuming units are % based on the range of values
|
|
| 35 |
soil_cation_cap,/location/locationevent/soilobs/cationexchangecapacity_cmol_kg,
|
|
| 36 |
clay_percent,/location/locationevent/soilobs/clay_fraction/_percent_to_fraction/value,
|
|
| 37 |
soil_conductivity,/location/locationevent/soilobs/conductivity,
|
|
| 38 |
soil_Mg,/location/locationevent/soilobs/magnesium_fraction/_percent_to_fraction/value,Assuming units are % based on the range of values
|
|
| 39 |
soil_N,/location/locationevent/soilobs/nitrogen_fraction/_percent_to_fraction/value,Assuming units are % based on the range of values
|
|
| 40 |
organic_percent,/location/locationevent/soilobs/organic_fraction/_percent_to_fraction/value,
|
|
| 41 |
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."
|
|
| 42 |
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
|
|
| 43 |
soil_K,/location/locationevent/soilobs/potassium_fraction/_percent_to_fraction/value,Assuming units are % based on the range of values
|
|
| 44 |
sand_percent,/location/locationevent/soilobs/sand_fraction/_percent_to_fraction/value,
|
|
| 45 |
silt_percent,/location/locationevent/soilobs/silt_fraction/_percent_to_fraction/value,
|
|
| 46 |
soil_Na,/location/locationevent/soilobs/sodium_fraction/_percent_to_fraction/value,Assuming units are % based on the range of values
|
|
| 47 |
soil_texture,/location/locationevent/soilobs/texture,
|
|
| 31 |
soil_acidity,"/location/locationevent/soilsample/acidity_fraction/_percent_to_fraction/value/_map:[""<0.05""=0,*=*]/value",Assuming units are % based on the range of values
|
|
| 32 |
soil_base,/location/locationevent/soilsample/basesaturation_fraction/_percent_to_fraction/value,Assuming units are % based on the range of values
|
|
| 33 |
soil_Ca,/location/locationevent/soilsample/calcium_fraction/_percent_to_fraction/value,Assuming units are % based on the range of values
|
|
| 34 |
soil_C,/location/locationevent/soilsample/carbon_fraction/_percent_to_fraction/value,Assuming units are % based on the range of values
|
|
| 35 |
soil_cation_cap,/location/locationevent/soilsample/cationexchangecapacity_cmol_kg,
|
|
| 36 |
clay_percent,/location/locationevent/soilsample/clay_fraction/_percent_to_fraction/value,
|
|
| 37 |
soil_conductivity,/location/locationevent/soilsample/conductivity,
|
|
| 38 |
soil_Mg,/location/locationevent/soilsample/magnesium_fraction/_percent_to_fraction/value,Assuming units are % based on the range of values
|
|
| 39 |
soil_N,/location/locationevent/soilsample/nitrogen_fraction/_percent_to_fraction/value,Assuming units are % based on the range of values
|
|
| 40 |
organic_percent,/location/locationevent/soilsample/organic_fraction/_percent_to_fraction/value,
|
|
| 41 |
pH,/location/locationevent/soilsample/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."
|
|
| 42 |
soil_P,"/location/locationevent/soilsample/phosphorus_fraction/_percent_to_fraction/value/_map:[""<1,5""=0,*=*]/value",Assuming units are % based on the range of values
|
|
| 43 |
soil_K,/location/locationevent/soilsample/potassium_fraction/_percent_to_fraction/value,Assuming units are % based on the range of values
|
|
| 44 |
sand_percent,/location/locationevent/soilsample/sand_fraction/_percent_to_fraction/value,
|
|
| 45 |
silt_percent,/location/locationevent/soilsample/silt_fraction/_percent_to_fraction/value,
|
|
| 46 |
soil_Na,/location/locationevent/soilsample/sodium_fraction/_percent_to_fraction/value,Assuming units are % based on the range of values
|
|
| 47 |
soil_texture,/location/locationevent/soilsample/texture,
|
|
| 48 | 48 |
PlotID,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists","Brad: This is artificial internal database ID; a unique identifier within SALVIAS DB to each plot, within the table plotMetadata." |
| 49 | 49 |
SiteCode,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",Brad: plotCode is as-assigned by data provider; guranteed to be unique only within dataset (=project) |
| 50 | 50 |
Temp,/location/locationevent/temperature_c, |
| inputs/SALVIAS/plotMetadata_/test.xml.ref | ||
|---|---|---|
| 71 | 71 |
<obsenddate>$date_finish</obsenddate> |
| 72 | 72 |
<obsstartdate>$date_start</obsstartdate> |
| 73 | 73 |
<precipitation_m>$Precip</precipitation_m> |
| 74 |
<soilobs>
|
|
| 74 |
<soilsample>
|
|
| 75 | 75 |
<acidity_fraction> |
| 76 | 76 |
<_percent_to_fraction> |
| 77 | 77 |
<value> |
| ... | ... | |
| 109 | 109 |
<silt_fraction><_percent_to_fraction><value>$silt_percent</value></_percent_to_fraction></silt_fraction> |
| 110 | 110 |
<sodium_fraction><_percent_to_fraction><value>$soil_Na</value></_percent_to_fraction></sodium_fraction> |
| 111 | 111 |
<texture>$soil_texture</texture> |
| 112 |
</soilobs>
|
|
| 112 |
</soilsample>
|
|
| 113 | 113 |
<temperature_c>$Temp</temperature_c> |
| 114 | 114 |
</locationevent> |
| 115 | 115 |
<locationnarrative> |
| inputs/Madidi/Plot/VegBIEN.csv | ||
|---|---|---|
| 69 | 69 |
Locality description,/location/locationevent/commclass/commdetermination/*_id/commconcept/commdescription,Often begins with the text in Vegetation type |
| 70 | 70 |
First evaluation,/location/locationevent/obsenddate/_alt/2/_dateRangeEnd/value, |
| 71 | 71 |
First evaluation,/location/locationevent/obsstartdate/_alt/2/_dateRangeStart/value, |
| 72 |
Acidez intercambiable (ISRIC 11–cmolc/Kg–0.05),/location/locationevent/soilobs/acidity_fraction/_percent_to_fraction/value,Assuming units are % based on the range of values
|
|
| 73 |
"Calcio intercambiable (WSP S-5,10–cmolc/Kg–0.016)",/location/locationevent/soilobs/calcium_fraction/_percent_to_fraction/value,Assuming units are % based on the range of values
|
|
| 74 |
"Carbón Orgánico (WSP S-9,10–%–0.06)",/location/locationevent/soilobs/carbon_fraction/_percent_to_fraction/value,Assuming units are % based on the range of values
|
|
| 75 |
CIC (ISRIC 11–cmolc/Kg–0.05),/location/locationevent/soilobs/cationexchangecapacity_cmol_kg,
|
|
| 76 |
Arcilla (DIN 18 123–%–1),/location/locationevent/soilobs/clay_fraction/_percent_to_fraction/value,Assuming units are % based on the range of values
|
|
| 77 |
Conductividad electrica (ASPT 6–µS/cm– 1 - 10000),/location/locationevent/soilobs/conductivity,
|
|
| 78 |
"Magnesio intercambiable (WSP S-5,10–cmolc/Kg–0.00083)",/location/locationevent/soilobs/magnesium_fraction/_percent_to_fraction/value,Assuming units are % based on the range of values
|
|
| 79 |
Nitrógeno total (ISRIC 6–%–0.0014),/location/locationevent/soilobs/nitrogen_fraction/_percent_to_fraction/value,Assuming units are % based on the range of values
|
|
| 80 |
"Materia Orgánica (WSP S-9,10–%–0.1)",/location/locationevent/soilobs/organic_fraction/_percent_to_fraction/value,Assuming units are % based on the range of values
|
|
| 81 |
pH acuoso (ISRIC 4–– 1 - 14),/location/locationevent/soilobs/ph,
|
|
| 82 |
Fósforo disponible (ISRIC 14-2–mg/Kg–1.5),/location/locationevent/soilobs/phosphorus_fraction/_percent_to_fraction/value,Assuming units are % based on the range of values
|
|
| 83 |
"Potasio intercambiable (WSP S-5,10–cmolc/Kg–0.0053)",/location/locationevent/soilobs/potassium_fraction/_percent_to_fraction/value,Assuming units are % based on the range of values
|
|
| 84 |
Arena (DIN 18 123–%–2.5),/location/locationevent/soilobs/sand_fraction/_percent_to_fraction/value,Assuming units are % based on the range of values
|
|
| 85 |
Limo (DIN 18 123–%–1),/location/locationevent/soilobs/silt_fraction/_percent_to_fraction/value,Assuming units are % based on the range of values
|
|
| 86 |
"Sodio intercambiable (WSP S-5,10–cmolc/Kg–0.00083)",/location/locationevent/soilobs/sodium_fraction/_percent_to_fraction/value,Assuming units are % based on the range of values
|
|
| 87 |
Textural class,/location/locationevent/soilobs/texture,
|
|
| 72 |
Acidez intercambiable (ISRIC 11–cmolc/Kg–0.05),/location/locationevent/soilsample/acidity_fraction/_percent_to_fraction/value,Assuming units are % based on the range of values
|
|
| 73 |
"Calcio intercambiable (WSP S-5,10–cmolc/Kg–0.016)",/location/locationevent/soilsample/calcium_fraction/_percent_to_fraction/value,Assuming units are % based on the range of values
|
|
| 74 |
"Carbón Orgánico (WSP S-9,10–%–0.06)",/location/locationevent/soilsample/carbon_fraction/_percent_to_fraction/value,Assuming units are % based on the range of values
|
|
| 75 |
CIC (ISRIC 11–cmolc/Kg–0.05),/location/locationevent/soilsample/cationexchangecapacity_cmol_kg,
|
|
| 76 |
Arcilla (DIN 18 123–%–1),/location/locationevent/soilsample/clay_fraction/_percent_to_fraction/value,Assuming units are % based on the range of values
|
|
| 77 |
Conductividad electrica (ASPT 6–µS/cm– 1 - 10000),/location/locationevent/soilsample/conductivity,
|
|
| 78 |
"Magnesio intercambiable (WSP S-5,10–cmolc/Kg–0.00083)",/location/locationevent/soilsample/magnesium_fraction/_percent_to_fraction/value,Assuming units are % based on the range of values
|
|
| 79 |
Nitrógeno total (ISRIC 6–%–0.0014),/location/locationevent/soilsample/nitrogen_fraction/_percent_to_fraction/value,Assuming units are % based on the range of values
|
|
| 80 |
"Materia Orgánica (WSP S-9,10–%–0.1)",/location/locationevent/soilsample/organic_fraction/_percent_to_fraction/value,Assuming units are % based on the range of values
|
|
| 81 |
pH acuoso (ISRIC 4–– 1 - 14),/location/locationevent/soilsample/ph,
|
|
| 82 |
Fósforo disponible (ISRIC 14-2–mg/Kg–1.5),/location/locationevent/soilsample/phosphorus_fraction/_percent_to_fraction/value,Assuming units are % based on the range of values
|
|
| 83 |
"Potasio intercambiable (WSP S-5,10–cmolc/Kg–0.0053)",/location/locationevent/soilsample/potassium_fraction/_percent_to_fraction/value,Assuming units are % based on the range of values
|
|
| 84 |
Arena (DIN 18 123–%–2.5),/location/locationevent/soilsample/sand_fraction/_percent_to_fraction/value,Assuming units are % based on the range of values
|
|
| 85 |
Limo (DIN 18 123–%–1),/location/locationevent/soilsample/silt_fraction/_percent_to_fraction/value,Assuming units are % based on the range of values
|
|
| 86 |
"Sodio intercambiable (WSP S-5,10–cmolc/Kg–0.00083)",/location/locationevent/soilsample/sodium_fraction/_percent_to_fraction/value,Assuming units are % based on the range of values
|
|
| 87 |
Textural class,/location/locationevent/soilsample/texture,
|
|
| 88 | 88 |
Inventory code,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists", |
| 89 | 89 |
Inventory name,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists", |
| 90 | 90 |
Locality,/location/locationnarrative/_merge/1, |
| inputs/Madidi/Plot/test.xml.ref | ||
|---|---|---|
| 48 | 48 |
</commclass> |
| 49 | 49 |
<obsenddate><_dateRangeEnd><value>$First evaluation</value></_dateRangeEnd></obsenddate> |
| 50 | 50 |
<obsstartdate><_dateRangeStart><value>$First evaluation</value></_dateRangeStart></obsstartdate> |
| 51 |
<soilobs>
|
|
| 51 |
<soilsample>
|
|
| 52 | 52 |
<acidity_fraction><_percent_to_fraction><value>$Acidez intercambiable (ISRIC 11–cmolc/Kg–0.05)</value></_percent_to_fraction></acidity_fraction> |
| 53 | 53 |
<calcium_fraction><_percent_to_fraction><value>$Calcio intercambiable (WSP S-5,10–cmolc/Kg–0.016)</value></_percent_to_fraction></calcium_fraction> |
| 54 | 54 |
<carbon_fraction><_percent_to_fraction><value>$Carbón Orgánico (WSP S-9,10–%–0.06)</value></_percent_to_fraction></carbon_fraction> |
| ... | ... | |
| 65 | 65 |
<silt_fraction><_percent_to_fraction><value>$Limo (DIN 18 123–%–1)</value></_percent_to_fraction></silt_fraction> |
| 66 | 66 |
<sodium_fraction><_percent_to_fraction><value>$Sodio intercambiable (WSP S-5,10–cmolc/Kg–0.00083)</value></_percent_to_fraction></sodium_fraction> |
| 67 | 67 |
<texture>$Textural class</texture> |
| 68 |
</soilobs>
|
|
| 68 |
</soilsample>
|
|
| 69 | 69 |
</locationevent> |
| 70 | 70 |
<locationnarrative>$Locality</locationnarrative> |
| 71 | 71 |
<locationplace> |
| inputs/SALVIAS-CSV/Plot/VegBIEN.csv | ||
|---|---|---|
| 22 | 22 |
date_finish,/location/locationevent/obsenddate/_alt/1, |
| 23 | 23 |
date_start,/location/locationevent/obsstartdate/_alt/1, |
| 24 | 24 |
precip_mm,/location/locationevent/precipitation_m, |
| 25 |
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
|
|
| 26 |
soil_base,/location/locationevent/soilobs/basesaturation_fraction/_percent_to_fraction/value,Assuming units are % based on the range of values
|
|
| 27 |
soil_Ca,/location/locationevent/soilobs/calcium_fraction/_percent_to_fraction/value,Assuming units are % based on the range of values
|
|
| 28 |
soil_C,/location/locationevent/soilobs/carbon_fraction/_percent_to_fraction/value,Assuming units are % based on the range of values
|
|
| 29 |
soil_cation_cap,/location/locationevent/soilobs/cationexchangecapacity_cmol_kg,
|
|
| 30 |
clay_percent,/location/locationevent/soilobs/clay_fraction/_percent_to_fraction/value,
|
|
| 31 |
soil_conductivity,/location/locationevent/soilobs/conductivity,
|
|
| 32 |
soil_Mg,/location/locationevent/soilobs/magnesium_fraction/_percent_to_fraction/value,Assuming units are % based on the range of values
|
|
| 33 |
soil_N,/location/locationevent/soilobs/nitrogen_fraction/_percent_to_fraction/value,Assuming units are % based on the range of values
|
|
| 34 |
organic_percent,/location/locationevent/soilobs/organic_fraction/_percent_to_fraction/value,
|
|
| 35 |
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."
|
|
| 36 |
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
|
|
| 37 |
soil_K,/location/locationevent/soilobs/potassium_fraction/_percent_to_fraction/value,Assuming units are % based on the range of values
|
|
| 38 |
sand_percent,/location/locationevent/soilobs/sand_fraction/_percent_to_fraction/value,
|
|
| 39 |
silt_percent,/location/locationevent/soilobs/silt_fraction/_percent_to_fraction/value,
|
|
| 40 |
soil_Na,/location/locationevent/soilobs/sodium_fraction/_percent_to_fraction/value,Assuming units are % based on the range of values
|
|
| 41 |
soil_texture,/location/locationevent/soilobs/texture,
|
|
| 25 |
soil_acidity,"/location/locationevent/soilsample/acidity_fraction/_percent_to_fraction/value/_map:[""<0.05""=0,*=*]/value",Assuming units are % based on the range of values
|
|
| 26 |
soil_base,/location/locationevent/soilsample/basesaturation_fraction/_percent_to_fraction/value,Assuming units are % based on the range of values
|
|
| 27 |
soil_Ca,/location/locationevent/soilsample/calcium_fraction/_percent_to_fraction/value,Assuming units are % based on the range of values
|
|
| 28 |
soil_C,/location/locationevent/soilsample/carbon_fraction/_percent_to_fraction/value,Assuming units are % based on the range of values
|
|
| 29 |
soil_cation_cap,/location/locationevent/soilsample/cationexchangecapacity_cmol_kg,
|
|
| 30 |
clay_percent,/location/locationevent/soilsample/clay_fraction/_percent_to_fraction/value,
|
|
| 31 |
soil_conductivity,/location/locationevent/soilsample/conductivity,
|
|
| 32 |
soil_Mg,/location/locationevent/soilsample/magnesium_fraction/_percent_to_fraction/value,Assuming units are % based on the range of values
|
|
| 33 |
soil_N,/location/locationevent/soilsample/nitrogen_fraction/_percent_to_fraction/value,Assuming units are % based on the range of values
|
|
| 34 |
organic_percent,/location/locationevent/soilsample/organic_fraction/_percent_to_fraction/value,
|
|
| 35 |
pH,/location/locationevent/soilsample/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_P,"/location/locationevent/soilsample/phosphorus_fraction/_percent_to_fraction/value/_map:[""<0.05""=0,*=*]/value",Assuming units are % based on the range of values
|
|
| 37 |
soil_K,/location/locationevent/soilsample/potassium_fraction/_percent_to_fraction/value,Assuming units are % based on the range of values
|
|
| 38 |
sand_percent,/location/locationevent/soilsample/sand_fraction/_percent_to_fraction/value,
|
|
| 39 |
silt_percent,/location/locationevent/soilsample/silt_fraction/_percent_to_fraction/value,
|
|
| 40 |
soil_Na,/location/locationevent/soilsample/sodium_fraction/_percent_to_fraction/value,Assuming units are % based on the range of values
|
|
| 41 |
soil_texture,/location/locationevent/soilsample/texture,
|
|
| 42 | 42 |
PLOT_ID,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists","Brad: This is artificial internal database ID; a unique identifier within SALVIAS DB to each plot, within the table plotMetadata." |
| 43 | 43 |
plot_code,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",Brad: plotCode is as-assigned by data provider; guranteed to be unique only within dataset (=project) |
| 44 | 44 |
temp_c,/location/locationevent/temperature_c, |
| inputs/SALVIAS-CSV/Plot/test.xml.ref | ||
|---|---|---|
| 38 | 38 |
<obsenddate>$date_finish</obsenddate> |
| 39 | 39 |
<obsstartdate>$date_start</obsstartdate> |
| 40 | 40 |
<precipitation_m>$precip_mm</precipitation_m> |
| 41 |
<soilobs>
|
|
| 41 |
<soilsample>
|
|
| 42 | 42 |
<acidity_fraction> |
| 43 | 43 |
<_percent_to_fraction> |
| 44 | 44 |
<value> |
| ... | ... | |
| 76 | 76 |
<silt_fraction><_percent_to_fraction><value>$silt_percent</value></_percent_to_fraction></silt_fraction> |
| 77 | 77 |
<sodium_fraction><_percent_to_fraction><value>$soil_Na</value></_percent_to_fraction></sodium_fraction> |
| 78 | 78 |
<texture>$soil_texture</texture> |
| 79 |
</soilobs>
|
|
| 79 |
</soilsample>
|
|
| 80 | 80 |
<temperature_c>$temp_c</temperature_c> |
| 81 | 81 |
</locationevent> |
| 82 | 82 |
<locationnarrative>$locality_description</locationnarrative> |
| inputs/VegBank/observation_/VegBIEN.csv | ||
|---|---|---|
| 18 | 18 |
observation_id,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/sourceaccessioncode", |
| 19 | 19 |
obsenddate,/location/locationevent/obsenddate/_alt/1, |
| 20 | 20 |
obsstartdate,/location/locationevent/obsstartdate/_alt/1, |
| 21 |
basesaturation,/location/locationevent/soilobs/basesaturation_fraction/_percent_to_fraction/value,"""Percent base saturation"" (baseSaturation definition at <http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=soilobs&entity=dba_tabledescription&where=where_tablename>)"
|
|
| 22 |
exchangecapacity,/location/locationevent/soilobs/cationexchangecapacity_cmol_kg,
|
|
| 23 |
soilclay,/location/locationevent/soilobs/clay_fraction/_percent_to_fraction/value,"""Percent clay in the soil horizon"" (soilClay definition at <http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=soilobs&entity=dba_tabledescription&where=where_tablename>)"
|
|
| 24 |
soilorganic,/location/locationevent/soilobs/organic_fraction/_percent_to_fraction/value,"""Percent organic content of the soil"" (soilOrganic definition at <http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=soilobs&entity=dba_tabledescription&where=where_tablename>)"
|
|
| 25 |
soilph,/location/locationevent/soilobs/ph,
|
|
| 26 |
soilsand,/location/locationevent/soilobs/sand_fraction/_percent_to_fraction/value,"""Percent sand in the soil horizon"" (soilSand definition at <http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=soilobs&entity=dba_tabledescription&where=where_tablename>)"
|
|
| 27 |
soilsilt,/location/locationevent/soilobs/silt_fraction/_percent_to_fraction/value,"""Percent silt in the soil horizon"" (soilSilt definition at <http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=soilobs&entity=dba_tabledescription&where=where_tablename>)"
|
|
| 28 |
soiltexture,/location/locationevent/soilobs/texture,
|
|
| 21 |
basesaturation,/location/locationevent/soilsample/basesaturation_fraction/_percent_to_fraction/value,"""Percent base saturation"" (baseSaturation definition at <http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=soilobs&entity=dba_tabledescription&where=where_tablename>)"
|
|
| 22 |
exchangecapacity,/location/locationevent/soilsample/cationexchangecapacity_cmol_kg,
|
|
| 23 |
soilclay,/location/locationevent/soilsample/clay_fraction/_percent_to_fraction/value,"""Percent clay in the soil horizon"" (soilClay definition at <http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=soilobs&entity=dba_tabledescription&where=where_tablename>)"
|
|
| 24 |
soilorganic,/location/locationevent/soilsample/organic_fraction/_percent_to_fraction/value,"""Percent organic content of the soil"" (soilOrganic definition at <http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=soilobs&entity=dba_tabledescription&where=where_tablename>)"
|
|
| 25 |
soilph,/location/locationevent/soilsample/ph,
|
|
| 26 |
soilsand,/location/locationevent/soilsample/sand_fraction/_percent_to_fraction/value,"""Percent sand in the soil horizon"" (soilSand definition at <http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=soilobs&entity=dba_tabledescription&where=where_tablename>)"
|
|
| 27 |
soilsilt,/location/locationevent/soilsample/silt_fraction/_percent_to_fraction/value,"""Percent silt in the soil horizon"" (soilSilt definition at <http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=soilobs&entity=dba_tabledescription&where=where_tablename>)"
|
|
| 28 |
soiltexture,/location/locationevent/soilsample/texture,
|
|
| 29 | 29 |
authorobscode,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists", |
| 30 | 30 |
observation_id,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists", |
| 31 | 31 |
plot_id,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists", |
| inputs/VegBank/observation_/test.xml.ref | ||
|---|---|---|
| 15 | 15 |
<sourceaccessioncode>$observation_id</sourceaccessioncode> |
| 16 | 16 |
<obsenddate>$obsenddate</obsenddate> |
| 17 | 17 |
<obsstartdate>$obsstartdate</obsstartdate> |
| 18 |
<soilobs>
|
|
| 18 |
<soilsample>
|
|
| 19 | 19 |
<basesaturation_fraction><_percent_to_fraction><value>$basesaturation</value></_percent_to_fraction></basesaturation_fraction> |
| 20 | 20 |
<cationexchangecapacity_cmol_kg>$exchangecapacity</cationexchangecapacity_cmol_kg> |
| 21 | 21 |
<clay_fraction><_percent_to_fraction><value>$soilclay</value></_percent_to_fraction></clay_fraction> |
| ... | ... | |
| 24 | 24 |
<sand_fraction><_percent_to_fraction><value>$soilsand</value></_percent_to_fraction></sand_fraction> |
| 25 | 25 |
<silt_fraction><_percent_to_fraction><value>$soilsilt</value></_percent_to_fraction></silt_fraction> |
| 26 | 26 |
<texture>$soiltexture</texture> |
| 27 |
</soilobs>
|
|
| 27 |
</soilsample>
|
|
| 28 | 28 |
</locationevent> |
| 29 | 29 |
</location> |
| 30 | 30 |
</path> |
| schemas/vegbien.my.sql | ||
|---|---|---|
| 584 | 584 |
|
| 585 | 585 |
|
| 586 | 586 |
-- |
| 587 |
-- Name: analytical_aggregate; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 588 |
-- |
|
| 589 |
|
|
| 590 |
CREATE TABLE analytical_aggregate ( |
|
| 591 |
`institutionCode` varchar(255) NOT NULL, |
|
| 592 |
country varchar(255), |
|
| 593 |
`stateProvince` varchar(255), |
|
| 594 |
county varchar(255), |
|
| 595 |
`decimalLatitude` double precision, |
|
| 596 |
`decimalLongitude` double precision, |
|
| 597 |
`coordinateUncertaintyInMeters` double precision, |
|
| 598 |
geovalid int(1), |
|
| 599 |
`isNewWorld` int(1), |
|
| 600 |
`distanceToCountry_km` double precision, |
|
| 601 |
`distanceToStateProvince_km` double precision, |
|
| 602 |
`plotName` varchar(255) NOT NULL, |
|
| 603 |
`elevationInMeters` double precision, |
|
| 604 |
`plotArea_ha` double precision, |
|
| 605 |
`samplingProtocol` varchar(255), |
|
| 606 |
`dateCollected` date NOT NULL, |
|
| 607 |
`higherPlantGroup` varchar(255), |
|
| 608 |
family varchar(255), |
|
| 609 |
genus varchar(255), |
|
| 610 |
`speciesBinomial` varchar(255), |
|
| 611 |
`scientificName` varchar(255), |
|
| 612 |
`scientificNameAuthorship` varchar(255), |
|
| 613 |
`scientificNameWithMorphospecies` varchar(255), |
|
| 614 |
threatened int(1), |
|
| 615 |
`identifiedBy` varchar(255), |
|
| 616 |
`growthForm` varchar(255), |
|
| 617 |
cultivated int(1), |
|
| 618 |
`cultivatedBasis` varchar(255), |
|
| 619 |
`coverPercent` double precision, |
|
| 620 |
`individualCount` varchar(255), |
|
| 621 |
`individualCount_1cm_or_more` varchar(255), |
|
| 622 |
`individualCount_2_5cm_or_more` varchar(255), |
|
| 623 |
`individualCount_10cm_or_more` varchar(255) |
|
| 624 |
); |
|
| 625 |
|
|
| 626 |
|
|
| 627 |
-- |
|
| 628 |
-- Name: analytical_stem; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 629 |
-- |
|
| 630 |
|
|
| 631 |
CREATE TABLE analytical_stem ( |
|
| 632 |
`institutionCode` varchar(255) NOT NULL, |
|
| 633 |
country varchar(255), |
|
| 634 |
`stateProvince` varchar(255), |
|
| 635 |
county varchar(255), |
|
| 636 |
`decimalLatitude` double precision, |
|
| 637 |
`decimalLongitude` double precision, |
|
| 638 |
`coordinateUncertaintyInMeters` double precision, |
|
| 639 |
geovalid int(1), |
|
| 640 |
`isNewWorld` int(1), |
|
| 641 |
`distanceToCountry_km` double precision, |
|
| 642 |
`distanceToStateProvince_km` double precision, |
|
| 643 |
`plotName` varchar(255) NOT NULL, |
|
| 644 |
`elevationInMeters` double precision, |
|
| 645 |
`plotArea_ha` double precision, |
|
| 646 |
`samplingProtocol` varchar(255), |
|
| 647 |
`dateCollected` date NOT NULL, |
|
| 648 |
`higherPlantGroup` varchar(255), |
|
| 649 |
family varchar(255), |
|
| 650 |
genus varchar(255), |
|
| 651 |
`speciesBinomial` varchar(255), |
|
| 652 |
`scientificName` varchar(255), |
|
| 653 |
`scientificNameAuthorship` varchar(255), |
|
| 654 |
`scientificNameWithMorphospecies` varchar(255), |
|
| 655 |
threatened int(1), |
|
| 656 |
`identifiedBy` varchar(255), |
|
| 657 |
`growthForm` varchar(255), |
|
| 658 |
cultivated int(1), |
|
| 659 |
`cultivatedBasis` varchar(255), |
|
| 660 |
`coverPercent` double precision, |
|
| 661 |
`diameterBreastHeight_cm` double precision, |
|
| 662 |
height_m double precision, |
|
| 663 |
tag varchar(255), |
|
| 664 |
`organismX_m` double precision, |
|
| 665 |
`organismY_m` double precision, |
|
| 666 |
`recordedBy` varchar(255), |
|
| 667 |
`recordNumber` varchar(255) |
|
| 668 |
); |
|
| 669 |
|
|
| 670 |
|
|
| 671 |
-- |
|
| 672 | 587 |
-- Name: address; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 673 | 588 |
-- |
| 674 | 589 |
|
| ... | ... | |
| 776 | 691 |
|
| 777 | 692 |
|
| 778 | 693 |
-- |
| 694 |
-- Name: analytical_aggregate; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 695 |
-- |
|
| 696 |
|
|
| 697 |
CREATE TABLE analytical_aggregate ( |
|
| 698 |
`institutionCode` varchar(255) NOT NULL, |
|
| 699 |
country varchar(255), |
|
| 700 |
`stateProvince` varchar(255), |
|
| 701 |
county varchar(255), |
|
| 702 |
`decimalLatitude` double precision, |
|
| 703 |
`decimalLongitude` double precision, |
|
| 704 |
`coordinateUncertaintyInMeters` double precision, |
|
| 705 |
geovalid int(1), |
|
| 706 |
`isNewWorld` int(1), |
|
| 707 |
`distanceToCountry_km` double precision, |
|
| 708 |
`distanceToStateProvince_km` double precision, |
|
| 709 |
`plotName` varchar(255) NOT NULL, |
|
| 710 |
`elevationInMeters` double precision, |
|
| 711 |
`plotArea_ha` double precision, |
|
| 712 |
`samplingProtocol` varchar(255), |
|
| 713 |
`dateCollected` date NOT NULL, |
|
| 714 |
`higherPlantGroup` varchar(255), |
|
| 715 |
family varchar(255), |
|
| 716 |
genus varchar(255), |
|
| 717 |
`speciesBinomial` varchar(255), |
|
| 718 |
`scientificName` varchar(255), |
|
| 719 |
`scientificNameAuthorship` varchar(255), |
|
| 720 |
`scientificNameWithMorphospecies` varchar(255), |
|
| 721 |
threatened int(1), |
|
| 722 |
`identifiedBy` varchar(255), |
|
| 723 |
`growthForm` varchar(255), |
|
| 724 |
cultivated int(1), |
|
| 725 |
`cultivatedBasis` varchar(255), |
|
| 726 |
`coverPercent` double precision, |
|
| 727 |
`individualCount` varchar(255), |
|
| 728 |
`individualCount_1cm_or_more` varchar(255), |
|
| 729 |
`individualCount_2_5cm_or_more` varchar(255), |
|
| 730 |
`individualCount_10cm_or_more` varchar(255) |
|
| 731 |
); |
|
| 732 |
|
|
| 733 |
|
|
| 734 |
-- |
|
| 735 |
-- Name: analytical_stem; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 736 |
-- |
|
| 737 |
|
|
| 738 |
CREATE TABLE analytical_stem ( |
|
| 739 |
`institutionCode` varchar(255) NOT NULL, |
|
| 740 |
country varchar(255), |
|
| 741 |
`stateProvince` varchar(255), |
|
| 742 |
county varchar(255), |
|
| 743 |
`decimalLatitude` double precision, |
|
| 744 |
`decimalLongitude` double precision, |
|
| 745 |
`coordinateUncertaintyInMeters` double precision, |
|
| 746 |
geovalid int(1), |
|
| 747 |
`isNewWorld` int(1), |
|
| 748 |
`distanceToCountry_km` double precision, |
|
| 749 |
`distanceToStateProvince_km` double precision, |
|
| 750 |
`plotName` varchar(255) NOT NULL, |
|
| 751 |
`elevationInMeters` double precision, |
|
| 752 |
`plotArea_ha` double precision, |
|
| 753 |
`samplingProtocol` varchar(255), |
|
| 754 |
`dateCollected` date NOT NULL, |
|
| 755 |
`higherPlantGroup` varchar(255), |
|
| 756 |
family varchar(255), |
|
| 757 |
genus varchar(255), |
|
| 758 |
`speciesBinomial` varchar(255), |
|
| 759 |
`scientificName` varchar(255), |
|
| 760 |
`scientificNameAuthorship` varchar(255), |
|
| 761 |
`scientificNameWithMorphospecies` varchar(255), |
|
| 762 |
threatened int(1), |
|
| 763 |
`identifiedBy` varchar(255), |
|
| 764 |
`growthForm` varchar(255), |
|
| 765 |
cultivated int(1), |
|
| 766 |
`cultivatedBasis` varchar(255), |
|
| 767 |
`coverPercent` double precision, |
|
| 768 |
`diameterBreastHeight_cm` double precision, |
|
| 769 |
height_m double precision, |
|
| 770 |
tag varchar(255), |
|
| 771 |
`organismX_m` double precision, |
|
| 772 |
`organismY_m` double precision, |
|
| 773 |
`recordedBy` varchar(255), |
|
| 774 |
`recordNumber` varchar(255) |
|
| 775 |
); |
|
| 776 |
|
|
| 777 |
|
|
| 778 |
-- |
|
| 779 | 779 |
-- Name: analytical_aggregate_view; Type: VIEW; Schema: public; Owner: - |
| 780 | 780 |
-- |
| 781 | 781 |
|
| ... | ... | |
| 2628 | 2628 |
|
| 2629 | 2629 |
|
| 2630 | 2630 |
-- |
| 2631 |
-- Name: soilobs; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 2631 |
-- Name: soilsample; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 2632 | 2632 |
-- |
| 2633 | 2633 |
|
| 2634 |
CREATE TABLE soilobs (
|
|
| 2635 |
soilobs_id int(11) NOT NULL,
|
|
| 2634 |
CREATE TABLE soilsample (
|
|
| 2635 |
soilsample_id int(11) NOT NULL,
|
|
| 2636 | 2636 |
locationevent_id int(11) NOT NULL, |
| 2637 | 2637 |
horizon varchar(255) DEFAULT 'unknown' NOT NULL, |
| 2638 | 2638 |
description varchar(255), |
| ... | ... | |
| 2661 | 2661 |
|
| 2662 | 2662 |
|
| 2663 | 2663 |
-- |
| 2664 |
-- Name: soilobs_soilobs_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
|
| 2664 |
-- Name: soilsample_soilsample_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
|
| 2665 | 2665 |
-- |
| 2666 | 2666 |
|
| 2667 | 2667 |
|
| 2668 | 2668 |
|
| 2669 | 2669 |
|
| 2670 | 2670 |
-- |
| 2671 |
-- Name: soilobs_soilobs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 2671 |
-- Name: soilsample_soilsample_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 2672 | 2672 |
-- |
| 2673 | 2673 |
|
| 2674 | 2674 |
|
| 2675 | 2675 |
|
| 2676 | 2676 |
|
| 2677 | 2677 |
-- |
| 2678 |
-- Name: soilobs_soilobs_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
|
|
| 2678 |
-- Name: soilsample_soilsample_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
|
|
| 2679 | 2679 |
-- |
| 2680 | 2680 |
|
| 2681 | 2681 |
|
| ... | ... | |
| 3633 | 3633 |
|
| 3634 | 3634 |
|
| 3635 | 3635 |
-- |
| 3636 |
-- Name: soilobs_id; Type: DEFAULT; Schema: public; Owner: -
|
|
| 3636 |
-- Name: soilsample_id; Type: DEFAULT; Schema: public; Owner: -
|
|
| 3637 | 3637 |
-- |
| 3638 | 3638 |
|
| 3639 | 3639 |
|
| ... | ... | |
| 4111 | 4111 |
|
| 4112 | 4112 |
|
| 4113 | 4113 |
-- |
| 4114 |
-- Data for Name: soilobs; Type: TABLE DATA; Schema: public; Owner: -
|
|
| 4114 |
-- Data for Name: soilsample; Type: TABLE DATA; Schema: public; Owner: -
|
|
| 4115 | 4115 |
-- |
| 4116 | 4116 |
|
| 4117 | 4117 |
|
| ... | ... | |
| 4623 | 4623 |
|
| 4624 | 4624 |
|
| 4625 | 4625 |
-- |
| 4626 |
-- Name: soilobs_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
|
|
| 4626 |
-- Name: soilsample_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
|
|
| 4627 | 4627 |
-- |
| 4628 | 4628 |
|
| 4629 |
ALTER TABLE soilobs
|
|
| 4630 |
ADD CONSTRAINT soilobs_pkey PRIMARY KEY (soilobs_id);
|
|
| 4629 |
ALTER TABLE soilsample
|
|
| 4630 |
ADD CONSTRAINT soilsample_pkey PRIMARY KEY (soilsample_id);
|
|
| 4631 | 4631 |
|
| 4632 | 4632 |
|
| 4633 | 4633 |
-- |
| 4634 |
-- Name: soilobs_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
|
|
| 4634 |
-- Name: soilsample_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
|
|
| 4635 | 4635 |
-- |
| 4636 | 4636 |
|
| 4637 |
ALTER TABLE soilobs
|
|
| 4638 |
ADD CONSTRAINT soilobs_unique UNIQUE (locationevent_id);
|
|
| 4637 |
ALTER TABLE soilsample
|
|
| 4638 |
ADD CONSTRAINT soilsample_unique UNIQUE (locationevent_id);
|
|
| 4639 | 4639 |
|
| 4640 | 4640 |
|
| 4641 | 4641 |
-- |
| ... | ... | |
| 6047 | 6047 |
|
| 6048 | 6048 |
|
| 6049 | 6049 |
-- |
| 6050 |
-- Name: soilobs_locationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 6050 |
-- Name: soilsample_locationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 6051 | 6051 |
-- |
| 6052 | 6052 |
|
| 6053 |
ALTER TABLE soilobs
|
|
| 6054 |
ADD CONSTRAINT soilobs_locationevent_id_fkey FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
|
|
| 6053 |
ALTER TABLE soilsample
|
|
| 6054 |
ADD CONSTRAINT soilsample_locationevent_id_fkey FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
|
|
| 6055 | 6055 |
|
| 6056 | 6056 |
|
| 6057 | 6057 |
-- |
| ... | ... | |
| 6429 | 6429 |
|
| 6430 | 6430 |
|
| 6431 | 6431 |
-- |
| 6432 |
-- Name: analytical_stem; Type: ACL; Schema: public; Owner: -
|
|
| 6432 |
-- Name: address; Type: ACL; Schema: public; Owner: -
|
|
| 6433 | 6433 |
-- |
| 6434 | 6434 |
|
| 6435 | 6435 |
|
| ... | ... | |
| 6439 | 6439 |
|
| 6440 | 6440 |
|
| 6441 | 6441 |
-- |
| 6442 |
-- Name: address; Type: ACL; Schema: public; Owner: -
|
|
| 6442 |
-- Name: aggregateoccurrence; Type: ACL; Schema: public; Owner: -
|
|
| 6443 | 6443 |
-- |
| 6444 | 6444 |
|
| 6445 | 6445 |
|
| ... | ... | |
| 6449 | 6449 |
|
| 6450 | 6450 |
|
| 6451 | 6451 |
-- |
| 6452 |
-- Name: aggregateoccurrence; Type: ACL; Schema: public; Owner: -
|
|
| 6452 |
-- Name: analytical_stem; Type: ACL; Schema: public; Owner: -
|
|
| 6453 | 6453 |
-- |
| 6454 | 6454 |
|
| 6455 | 6455 |
|
| ... | ... | |
| 6929 | 6929 |
|
| 6930 | 6930 |
|
| 6931 | 6931 |
-- |
| 6932 |
-- Name: soilobs; Type: ACL; Schema: public; Owner: -
|
|
| 6932 |
-- Name: soilsample; Type: ACL; Schema: public; Owner: -
|
|
| 6933 | 6933 |
-- |
| 6934 | 6934 |
|
| 6935 | 6935 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 1294 | 1294 |
|
| 1295 | 1295 |
|
| 1296 | 1296 |
-- |
| 1297 |
-- Name: analytical_aggregate; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 1298 |
-- |
|
| 1299 |
|
|
| 1300 |
CREATE TABLE analytical_aggregate ( |
|
| 1301 |
"institutionCode" text NOT NULL, |
|
| 1302 |
country text, |
|
| 1303 |
"stateProvince" text, |
|
| 1304 |
county text, |
|
| 1305 |
"decimalLatitude" double precision, |
|
| 1306 |
"decimalLongitude" double precision, |
|
| 1307 |
"coordinateUncertaintyInMeters" double precision, |
|
| 1308 |
geovalid boolean, |
|
| 1309 |
"isNewWorld" boolean, |
|
| 1310 |
"distanceToCountry_km" double precision, |
|
| 1311 |
"distanceToStateProvince_km" double precision, |
|
| 1312 |
"plotName" text NOT NULL, |
|
| 1313 |
"elevationInMeters" double precision, |
|
| 1314 |
"plotArea_ha" double precision, |
|
| 1315 |
"samplingProtocol" text, |
|
| 1316 |
"dateCollected" date NOT NULL, |
|
| 1317 |
"higherPlantGroup" higher_plant_group, |
|
| 1318 |
family text, |
|
| 1319 |
genus text, |
|
| 1320 |
"speciesBinomial" text, |
|
| 1321 |
"scientificName" text, |
|
| 1322 |
"scientificNameAuthorship" text, |
|
| 1323 |
"scientificNameWithMorphospecies" text, |
|
| 1324 |
threatened boolean, |
|
| 1325 |
"identifiedBy" text, |
|
| 1326 |
"growthForm" growthform, |
|
| 1327 |
cultivated boolean, |
|
| 1328 |
"cultivatedBasis" text, |
|
| 1329 |
"coverPercent" double precision, |
|
| 1330 |
"individualCount" bigint, |
|
| 1331 |
"individualCount_1cm_or_more" bigint, |
|
| 1332 |
"individualCount_2_5cm_or_more" bigint, |
|
| 1333 |
"individualCount_10cm_or_more" bigint |
|
| 1334 |
); |
|
| 1335 |
|
|
| 1336 |
|
|
| 1337 |
-- |
|
| 1338 |
-- Name: analytical_stem; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 1339 |
-- |
|
| 1340 |
|
|
| 1341 |
CREATE TABLE analytical_stem ( |
|
| 1342 |
"institutionCode" text NOT NULL, |
|
| 1343 |
country text, |
|
| 1344 |
"stateProvince" text, |
|
| 1345 |
county text, |
|
| 1346 |
"decimalLatitude" double precision, |
|
| 1347 |
"decimalLongitude" double precision, |
|
| 1348 |
"coordinateUncertaintyInMeters" double precision, |
|
| 1349 |
geovalid boolean, |
|
| 1350 |
"isNewWorld" boolean, |
|
| 1351 |
"distanceToCountry_km" double precision, |
|
| 1352 |
"distanceToStateProvince_km" double precision, |
|
| 1353 |
"plotName" text NOT NULL, |
|
| 1354 |
"elevationInMeters" double precision, |
|
| 1355 |
"plotArea_ha" double precision, |
|
| 1356 |
"samplingProtocol" text, |
|
| 1357 |
"dateCollected" date NOT NULL, |
|
| 1358 |
"higherPlantGroup" higher_plant_group, |
|
| 1359 |
family text, |
|
| 1360 |
genus text, |
|
| 1361 |
"speciesBinomial" text, |
|
| 1362 |
"scientificName" text, |
|
| 1363 |
"scientificNameAuthorship" text, |
|
| 1364 |
"scientificNameWithMorphospecies" text, |
|
| 1365 |
threatened boolean, |
|
| 1366 |
"identifiedBy" text, |
|
| 1367 |
"growthForm" growthform, |
|
| 1368 |
cultivated boolean, |
|
| 1369 |
"cultivatedBasis" text, |
|
| 1370 |
"coverPercent" double precision, |
|
| 1371 |
"diameterBreastHeight_cm" double precision, |
|
| 1372 |
height_m double precision, |
|
| 1373 |
tag text, |
|
| 1374 |
"organismX_m" double precision, |
|
| 1375 |
"organismY_m" double precision, |
|
| 1376 |
"recordedBy" text, |
|
| 1377 |
"recordNumber" text |
|
| 1378 |
); |
|
| 1379 |
|
|
| 1380 |
|
|
| 1381 |
-- |
|
| 1382 | 1297 |
-- Name: address; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 1383 | 1298 |
-- |
| 1384 | 1299 |
|
| ... | ... | |
| 1497 | 1412 |
|
| 1498 | 1413 |
|
| 1499 | 1414 |
-- |
| 1415 |
-- Name: analytical_aggregate; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 1416 |
-- |
|
| 1417 |
|
|
| 1418 |
CREATE TABLE analytical_aggregate ( |
|
| 1419 |
"institutionCode" text NOT NULL, |
|
| 1420 |
country text, |
|
| 1421 |
"stateProvince" text, |
|
| 1422 |
county text, |
|
| 1423 |
"decimalLatitude" double precision, |
|
| 1424 |
"decimalLongitude" double precision, |
|
| 1425 |
"coordinateUncertaintyInMeters" double precision, |
|
| 1426 |
geovalid boolean, |
|
| 1427 |
"isNewWorld" boolean, |
|
| 1428 |
"distanceToCountry_km" double precision, |
|
| 1429 |
"distanceToStateProvince_km" double precision, |
|
| 1430 |
"plotName" text NOT NULL, |
|
| 1431 |
"elevationInMeters" double precision, |
|
| 1432 |
"plotArea_ha" double precision, |
|
| 1433 |
"samplingProtocol" text, |
|
| 1434 |
"dateCollected" date NOT NULL, |
|
| 1435 |
"higherPlantGroup" higher_plant_group, |
|
| 1436 |
family text, |
|
| 1437 |
genus text, |
|
| 1438 |
"speciesBinomial" text, |
|
| 1439 |
"scientificName" text, |
|
| 1440 |
"scientificNameAuthorship" text, |
|
| 1441 |
"scientificNameWithMorphospecies" text, |
|
| 1442 |
threatened boolean, |
|
| 1443 |
"identifiedBy" text, |
|
| 1444 |
"growthForm" growthform, |
|
| 1445 |
cultivated boolean, |
|
| 1446 |
"cultivatedBasis" text, |
|
| 1447 |
"coverPercent" double precision, |
|
| 1448 |
"individualCount" bigint, |
|
| 1449 |
"individualCount_1cm_or_more" bigint, |
|
| 1450 |
"individualCount_2_5cm_or_more" bigint, |
|
| 1451 |
"individualCount_10cm_or_more" bigint |
|
| 1452 |
); |
|
| 1453 |
|
|
| 1454 |
|
|
| 1455 |
-- |
|
| 1456 |
-- Name: analytical_stem; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 1457 |
-- |
|
| 1458 |
|
|
| 1459 |
CREATE TABLE analytical_stem ( |
|
| 1460 |
"institutionCode" text NOT NULL, |
|
| 1461 |
country text, |
|
| 1462 |
"stateProvince" text, |
|
| 1463 |
county text, |
|
| 1464 |
"decimalLatitude" double precision, |
|
| 1465 |
"decimalLongitude" double precision, |
|
| 1466 |
"coordinateUncertaintyInMeters" double precision, |
|
| 1467 |
geovalid boolean, |
|
| 1468 |
"isNewWorld" boolean, |
|
| 1469 |
"distanceToCountry_km" double precision, |
|
| 1470 |
"distanceToStateProvince_km" double precision, |
|
| 1471 |
"plotName" text NOT NULL, |
|
| 1472 |
"elevationInMeters" double precision, |
|
| 1473 |
"plotArea_ha" double precision, |
|
| 1474 |
"samplingProtocol" text, |
|
| 1475 |
"dateCollected" date NOT NULL, |
|
| 1476 |
"higherPlantGroup" higher_plant_group, |
|
| 1477 |
family text, |
|
| 1478 |
genus text, |
|
| 1479 |
"speciesBinomial" text, |
|
| 1480 |
"scientificName" text, |
|
| 1481 |
"scientificNameAuthorship" text, |
|
| 1482 |
"scientificNameWithMorphospecies" text, |
|
| 1483 |
threatened boolean, |
|
| 1484 |
"identifiedBy" text, |
|
| 1485 |
"growthForm" growthform, |
|
| 1486 |
cultivated boolean, |
|
| 1487 |
"cultivatedBasis" text, |
|
| 1488 |
"coverPercent" double precision, |
|
| 1489 |
"diameterBreastHeight_cm" double precision, |
|
| 1490 |
height_m double precision, |
|
| 1491 |
tag text, |
|
| 1492 |
"organismX_m" double precision, |
|
| 1493 |
"organismY_m" double precision, |
|
| 1494 |
"recordedBy" text, |
|
| 1495 |
"recordNumber" text |
|
| 1496 |
); |
|
| 1497 |
|
|
| 1498 |
|
|
| 1499 |
-- |
|
| 1500 | 1500 |
-- Name: analytical_aggregate_view; Type: VIEW; Schema: public; Owner: - |
| 1501 | 1501 |
-- |
| 1502 | 1502 |
|
| ... | ... | |
| 3564 | 3564 |
|
| 3565 | 3565 |
|
| 3566 | 3566 |
-- |
| 3567 |
-- Name: soilobs; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 3567 |
-- Name: soilsample; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 3568 | 3568 |
-- |
| 3569 | 3569 |
|
| 3570 |
CREATE TABLE soilobs (
|
|
| 3571 |
soilobs_id integer NOT NULL,
|
|
| 3570 |
CREATE TABLE soilsample (
|
|
| 3571 |
soilsample_id integer NOT NULL,
|
|
| 3572 | 3572 |
locationevent_id integer NOT NULL, |
| 3573 | 3573 |
horizon text DEFAULT 'unknown'::text NOT NULL, |
| 3574 | 3574 |
description text, |
| ... | ... | |
| 3597 | 3597 |
|
| 3598 | 3598 |
|
| 3599 | 3599 |
-- |
| 3600 |
-- Name: soilobs_soilobs_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
|
| 3600 |
-- Name: soilsample_soilsample_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
|
| 3601 | 3601 |
-- |
| 3602 | 3602 |
|
| 3603 |
CREATE SEQUENCE soilobs_soilobs_id_seq
|
|
| 3603 |
CREATE SEQUENCE soilsample_soilsample_id_seq
|
|
| 3604 | 3604 |
START WITH 1 |
| 3605 | 3605 |
INCREMENT BY 1 |
| 3606 | 3606 |
NO MINVALUE |
| ... | ... | |
| 3609 | 3609 |
|
| 3610 | 3610 |
|
| 3611 | 3611 |
-- |
| 3612 |
-- Name: soilobs_soilobs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 3612 |
-- Name: soilsample_soilsample_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 3613 | 3613 |
-- |
| 3614 | 3614 |
|
| 3615 |
ALTER SEQUENCE soilobs_soilobs_id_seq OWNED BY soilobs.soilobs_id;
|
|
| 3615 |
ALTER SEQUENCE soilsample_soilsample_id_seq OWNED BY soilsample.soilsample_id;
|
|
| 3616 | 3616 |
|
| 3617 | 3617 |
|
| 3618 | 3618 |
-- |
| 3619 |
-- Name: soilobs_soilobs_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
|
|
| 3619 |
-- Name: soilsample_soilsample_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
|
|
| 3620 | 3620 |
-- |
| 3621 | 3621 |
|
| 3622 | 3622 |
|
| ... | ... | |
| 4684 | 4684 |
|
| 4685 | 4685 |
|
| 4686 | 4686 |
-- |
| 4687 |
-- Name: soilobs_id; Type: DEFAULT; Schema: public; Owner: -
|
|
| 4687 |
-- Name: soilsample_id; Type: DEFAULT; Schema: public; Owner: -
|
|
| 4688 | 4688 |
-- |
| 4689 | 4689 |
|
| 4690 |
ALTER TABLE ONLY soilobs ALTER COLUMN soilobs_id SET DEFAULT nextval('soilobs_soilobs_id_seq'::regclass);
|
|
| 4690 |
ALTER TABLE ONLY soilsample ALTER COLUMN soilsample_id SET DEFAULT nextval('soilsample_soilsample_id_seq'::regclass);
|
|
| 4691 | 4691 |
|
| 4692 | 4692 |
|
| 4693 | 4693 |
-- |
| ... | ... | |
| 5162 | 5162 |
|
| 5163 | 5163 |
|
| 5164 | 5164 |
-- |
| 5165 |
-- Data for Name: soilobs; Type: TABLE DATA; Schema: public; Owner: -
|
|
| 5165 |
-- Data for Name: soilsample; Type: TABLE DATA; Schema: public; Owner: -
|
|
| 5166 | 5166 |
-- |
| 5167 | 5167 |
|
| 5168 | 5168 |
|
| ... | ... | |
| 5674 | 5674 |
|
| 5675 | 5675 |
|
| 5676 | 5676 |
-- |
| 5677 |
-- Name: soilobs_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
|
|
| 5677 |
-- Name: soilsample_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
|
|
| 5678 | 5678 |
-- |
| 5679 | 5679 |
|
| 5680 |
ALTER TABLE ONLY soilobs
|
|
| 5681 |
ADD CONSTRAINT soilobs_pkey PRIMARY KEY (soilobs_id);
|
|
| 5680 |
ALTER TABLE ONLY soilsample
|
|
| 5681 |
ADD CONSTRAINT soilsample_pkey PRIMARY KEY (soilsample_id);
|
|
| 5682 | 5682 |
|
| 5683 | 5683 |
|
| 5684 | 5684 |
-- |
| 5685 |
-- Name: soilobs_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
|
|
| 5685 |
-- Name: soilsample_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
|
|
| 5686 | 5686 |
-- |
| 5687 | 5687 |
|
| 5688 |
ALTER TABLE ONLY soilobs
|
|
| 5689 |
ADD CONSTRAINT soilobs_unique UNIQUE (locationevent_id);
|
|
| 5688 |
ALTER TABLE ONLY soilsample
|
|
| 5689 |
ADD CONSTRAINT soilsample_unique UNIQUE (locationevent_id);
|
|
| 5690 | 5690 |
|
| 5691 | 5691 |
|
| 5692 | 5692 |
-- |
| ... | ... | |
| 7128 | 7128 |
|
| 7129 | 7129 |
|
| 7130 | 7130 |
-- |
| 7131 |
-- Name: soilobs_locationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 7131 |
-- Name: soilsample_locationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 7132 | 7132 |
-- |
| 7133 | 7133 |
|
| 7134 |
ALTER TABLE ONLY soilobs
|
|
| 7135 |
ADD CONSTRAINT soilobs_locationevent_id_fkey FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
|
|
| 7134 |
ALTER TABLE ONLY soilsample
|
|
| 7135 |
ADD CONSTRAINT soilsample_locationevent_id_fkey FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
|
|
| 7136 | 7136 |
|
| 7137 | 7137 |
|
| 7138 | 7138 |
-- |
| ... | ... | |
| 7526 | 7526 |
|
| 7527 | 7527 |
|
| 7528 | 7528 |
-- |
| 7529 |
-- Name: analytical_stem; Type: ACL; Schema: public; Owner: - |
|
| 7530 |
-- |
|
| 7531 |
|
|
| 7532 |
REVOKE ALL ON TABLE analytical_stem FROM PUBLIC; |
|
| 7533 |
REVOKE ALL ON TABLE analytical_stem FROM bien; |
|
| 7534 |
GRANT ALL ON TABLE analytical_stem TO bien; |
|
| 7535 |
GRANT SELECT ON TABLE analytical_stem TO bien_read; |
|
| 7536 |
|
|
| 7537 |
|
|
| 7538 |
-- |
|
| 7539 | 7529 |
-- Name: address; Type: ACL; Schema: public; Owner: - |
| 7540 | 7530 |
-- |
| 7541 | 7531 |
|
| ... | ... | |
| 7556 | 7546 |
|
| 7557 | 7547 |
|
| 7558 | 7548 |
-- |
| 7549 |
-- Name: analytical_stem; Type: ACL; Schema: public; Owner: - |
|
| 7550 |
-- |
|
| 7551 |
|
|
| 7552 |
REVOKE ALL ON TABLE analytical_stem FROM PUBLIC; |
|
| 7553 |
REVOKE ALL ON TABLE analytical_stem FROM bien; |
|
| 7554 |
GRANT ALL ON TABLE analytical_stem TO bien; |
|
| 7555 |
GRANT SELECT ON TABLE analytical_stem TO bien_read; |
|
| 7556 |
|
|
| 7557 |
|
|
| 7558 |
-- |
|
| 7559 | 7559 |
-- Name: analytical_aggregate_view; Type: ACL; Schema: public; Owner: - |
| 7560 | 7560 |
-- |
| 7561 | 7561 |
|
| ... | ... | |
| 8026 | 8026 |
|
| 8027 | 8027 |
|
| 8028 | 8028 |
-- |
| 8029 |
-- Name: soilobs; Type: ACL; Schema: public; Owner: -
|
|
| 8029 |
-- Name: soilsample; Type: ACL; Schema: public; Owner: -
|
|
| 8030 | 8030 |
-- |
| 8031 | 8031 |
|
| 8032 |
REVOKE ALL ON TABLE soilobs FROM PUBLIC;
|
|
| 8033 |
REVOKE ALL ON TABLE soilobs FROM bien;
|
|
| 8034 |
GRANT ALL ON TABLE soilobs TO bien;
|
|
| 8035 |
GRANT SELECT ON TABLE soilobs TO bien_read;
|
|
| 8032 |
REVOKE ALL ON TABLE soilsample FROM PUBLIC;
|
|
| 8033 |
REVOKE ALL ON TABLE soilsample FROM bien;
|
|
| 8034 |
GRANT ALL ON TABLE soilsample TO bien;
|
|
| 8035 |
GRANT SELECT ON TABLE soilsample TO bien_read;
|
|
| 8036 | 8036 |
|
| 8037 | 8037 |
|
| 8038 | 8038 |
-- |
| mappings/VegCore-VegBIEN.csv | ||
|---|---|---|
| 76 | 76 |
startDate,/location/locationevent/obsstartdate/_alt/1, |
| 77 | 77 |
eventDate,/location/locationevent/obsstartdate/_alt/2/_dateRangeStart/value, |
| 78 | 78 |
precipitation,/location/locationevent/precipitation_m, |
| 79 |
acidity_percent,/location/locationevent/soilobs/acidity_fraction/_percent_to_fraction/value,
|
|
| 80 |
baseSaturation_percent,/location/locationevent/soilobs/basesaturation_fraction/_percent_to_fraction/value,
|
|
| 81 |
calcium_percent,/location/locationevent/soilobs/calcium_fraction/_percent_to_fraction/value,
|
|
| 82 |
carbon_percent,/location/locationevent/soilobs/carbon_fraction/_percent_to_fraction/value,
|
|
| 83 |
cationExchangeCapacity_cmol_kg,/location/locationevent/soilobs/cationexchangecapacity_cmol_kg,
|
|
| 84 |
clay_percent,/location/locationevent/soilobs/clay_fraction/_percent_to_fraction/value,
|
|
| 85 |
conductivity,/location/locationevent/soilobs/conductivity,
|
|
| 86 |
magnesium_percent,/location/locationevent/soilobs/magnesium_fraction/_percent_to_fraction/value,
|
|
| 87 |
nitrogen_percent,/location/locationevent/soilobs/nitrogen_fraction/_percent_to_fraction/value,
|
|
| 88 |
organic_percent,/location/locationevent/soilobs/organic_fraction/_percent_to_fraction/value,
|
|
| 89 |
ph,/location/locationevent/soilobs/ph,
|
|
| 90 |
phosphorus_percent,/location/locationevent/soilobs/phosphorus_fraction/_percent_to_fraction/value,
|
|
| 91 |
potassium_percent,/location/locationevent/soilobs/potassium_fraction/_percent_to_fraction/value,
|
|
| 92 |
sand_percent,/location/locationevent/soilobs/sand_fraction/_percent_to_fraction/value,
|
|
| 93 |
silt_percent,/location/locationevent/soilobs/silt_fraction/_percent_to_fraction/value,
|
|
| 94 |
sodium_percent,/location/locationevent/soilobs/sodium_fraction/_percent_to_fraction/value,
|
|
| 95 |
texture,/location/locationevent/soilobs/texture,
|
|
| 79 |
acidity_percent,/location/locationevent/soilsample/acidity_fraction/_percent_to_fraction/value,
|
|
| 80 |
baseSaturation_percent,/location/locationevent/soilsample/basesaturation_fraction/_percent_to_fraction/value,
|
|
| 81 |
calcium_percent,/location/locationevent/soilsample/calcium_fraction/_percent_to_fraction/value,
|
|
| 82 |
carbon_percent,/location/locationevent/soilsample/carbon_fraction/_percent_to_fraction/value,
|
|
| 83 |
cationExchangeCapacity_cmol_kg,/location/locationevent/soilsample/cationexchangecapacity_cmol_kg,
|
|
| 84 |
clay_percent,/location/locationevent/soilsample/clay_fraction/_percent_to_fraction/value,
|
|
| 85 |
conductivity,/location/locationevent/soilsample/conductivity,
|
|
| 86 |
magnesium_percent,/location/locationevent/soilsample/magnesium_fraction/_percent_to_fraction/value,
|
|
| 87 |
nitrogen_percent,/location/locationevent/soilsample/nitrogen_fraction/_percent_to_fraction/value,
|
|
| 88 |
organic_percent,/location/locationevent/soilsample/organic_fraction/_percent_to_fraction/value,
|
|
| 89 |
ph,/location/locationevent/soilsample/ph,
|
|
| 90 |
phosphorus_percent,/location/locationevent/soilsample/phosphorus_fraction/_percent_to_fraction/value,
|
|
| 91 |
potassium_percent,/location/locationevent/soilsample/potassium_fraction/_percent_to_fraction/value,
|
|
| 92 |
sand_percent,/location/locationevent/soilsample/sand_fraction/_percent_to_fraction/value,
|
|
| 93 |
silt_percent,/location/locationevent/soilsample/silt_fraction/_percent_to_fraction/value,
|
|
| 94 |
sodium_percent,/location/locationevent/soilsample/sodium_fraction/_percent_to_fraction/value,
|
|
| 95 |
texture,/location/locationevent/soilsample/texture,
|
|
| 96 | 96 |
dateCollected,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/1, |
| 97 | 97 |
dayCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value", |
| 98 | 98 |
monthCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value", |
| mappings/for_review/VegCore-VegBIEN.csv | ||
|---|---|---|
| 76 | 76 |
startDate,//locationevent/obsstartdate, |
| 77 | 77 |
eventDate,//locationevent/obsstartdate, |
| 78 | 78 |
precipitation,//locationevent/precipitation_m, |
| 79 |
acidity_percent,//soilobs/acidity_fraction/_percent_to_fraction/value,
|
|
| 80 |
baseSaturation_percent,//soilobs/basesaturation_fraction/_percent_to_fraction/value,
|
|
| 81 |
calcium_percent,//soilobs/calcium_fraction/_percent_to_fraction/value,
|
|
| 82 |
carbon_percent,//soilobs/carbon_fraction/_percent_to_fraction/value,
|
|
| 83 |
cationExchangeCapacity_cmol_kg,//soilobs/cationexchangecapacity_cmol_kg,
|
|
| 84 |
clay_percent,//soilobs/clay_fraction/_percent_to_fraction/value,
|
|
| 85 |
conductivity,//soilobs/conductivity,
|
|
| 86 |
magnesium_percent,//soilobs/magnesium_fraction/_percent_to_fraction/value,
|
|
| 87 |
nitrogen_percent,//soilobs/nitrogen_fraction/_percent_to_fraction/value,
|
|
| 88 |
organic_percent,//soilobs/organic_fraction/_percent_to_fraction/value,
|
|
| 89 |
ph,//soilobs/ph,
|
|
| 90 |
phosphorus_percent,//soilobs/phosphorus_fraction/_percent_to_fraction/value,
|
|
| 91 |
potassium_percent,//soilobs/potassium_fraction/_percent_to_fraction/value,
|
|
| 92 |
sand_percent,//soilobs/sand_fraction/_percent_to_fraction/value,
|
|
| 93 |
silt_percent,//soilobs/silt_fraction/_percent_to_fraction/value,
|
|
| 94 |
sodium_percent,//soilobs/sodium_fraction/_percent_to_fraction/value,
|
|
| 95 |
texture,//soilobs/texture,
|
|
| 79 |
acidity_percent,//soilsample/acidity_fraction/_percent_to_fraction/value,
|
|
| 80 |
baseSaturation_percent,//soilsample/basesaturation_fraction/_percent_to_fraction/value,
|
|
| 81 |
calcium_percent,//soilsample/calcium_fraction/_percent_to_fraction/value,
|
|
| 82 |
carbon_percent,//soilsample/carbon_fraction/_percent_to_fraction/value,
|
|
| 83 |
cationExchangeCapacity_cmol_kg,//soilsample/cationexchangecapacity_cmol_kg,
|
|
| 84 |
clay_percent,//soilsample/clay_fraction/_percent_to_fraction/value,
|
|
| 85 |
conductivity,//soilsample/conductivity,
|
|
| 86 |
magnesium_percent,//soilsample/magnesium_fraction/_percent_to_fraction/value,
|
|
| 87 |
nitrogen_percent,//soilsample/nitrogen_fraction/_percent_to_fraction/value,
|
|
| 88 |
organic_percent,//soilsample/organic_fraction/_percent_to_fraction/value,
|
|
| 89 |
ph,//soilsample/ph,
|
|
| 90 |
phosphorus_percent,//soilsample/phosphorus_fraction/_percent_to_fraction/value,
|
|
| 91 |
potassium_percent,//soilsample/potassium_fraction/_percent_to_fraction/value,
|
|
| 92 |
sand_percent,//soilsample/sand_fraction/_percent_to_fraction/value,
|
|
| 93 |
silt_percent,//soilsample/silt_fraction/_percent_to_fraction/value,
|
|
| 94 |
sodium_percent,//soilsample/sodium_fraction/_percent_to_fraction/value,
|
|
| 95 |
texture,//soilsample/texture,
|
|
| 96 | 96 |
dateCollected,//aggregateoccurrence/collectiondate, |
| 97 | 97 |
dayCollected,//aggregateoccurrence/collectiondate, |
| 98 | 98 |
monthCollected,//aggregateoccurrence/collectiondate, |
Also available in: Unified diff
schemas/vegbien.sql: Renamed soilobs to soilsample per working group discussion