Project

General

Profile

« Previous | Next » 

Revision 4908

mappings/VegCore.csv: Soil component measurements: Added default units of percent (cmol_kg for cationExchangeCapacity). This involves translating the names everywhere and adding a _percent_to_fraction conversion in mappings/VegCore-VegBIEN.csv.

View differences:

inputs/Madidi/Plot/map.csv
47 47
Soil sample,Soil sample,,Always empty
48 48
pH acuoso (ISRIC 4–– 1 - 14),ph,,
49 49
Conductividad electrica (ASPT 6–µS/cm– 1 - 10000),conductivity,,
50
Nitrógeno total (ISRIC 6–%–0.0014),nitrogen,,
51
"Carbón Orgánico (WSP S-9,10–%–0.06)",carbon,,
52
"Materia Orgánica (WSP S-9,10–%–0.1)",organic,,
53
Fósforo disponible (ISRIC 14-2–mg/Kg–1.5),phosphorus,,
54
"Sodio intercambiable (WSP S-5,10–cmolc/Kg–0.00083)",sodium,,
55
"Potasio intercambiable (WSP S-5,10–cmolc/Kg–0.0053)",potassium,,
56
"Calcio intercambiable (WSP S-5,10–cmolc/Kg–0.016)",calcium,,
57
"Magnesio intercambiable (WSP S-5,10–cmolc/Kg–0.00083)",magnesium,,
58
Acidez intercambiable (ISRIC 11–cmolc/Kg–0.05),acidity,,
59
CIC (ISRIC 11–cmolc/Kg–0.05),cationExchangeCapacity,,
60
Arena (DIN 18 123–%–2.5),sand,,
61
Limo (DIN 18 123–%–1),silt,,
62
Arcilla (DIN 18 123–%–1),clay,,
50
Nitrógeno total (ISRIC 6–%–0.0014),nitrogen_percent,,
51
"Carbón Orgánico (WSP S-9,10–%–0.06)",carbon_percent,,
52
"Materia Orgánica (WSP S-9,10–%–0.1)",organic_percent,,
53
Fósforo disponible (ISRIC 14-2–mg/Kg–1.5),phosphorus_percent,,
54
"Sodio intercambiable (WSP S-5,10–cmolc/Kg–0.00083)",sodium_percent,,
55
"Potasio intercambiable (WSP S-5,10–cmolc/Kg–0.0053)",potassium_percent,,
56
"Calcio intercambiable (WSP S-5,10–cmolc/Kg–0.016)",calcium_percent,,
57
"Magnesio intercambiable (WSP S-5,10–cmolc/Kg–0.00083)",magnesium_percent,,
58
Acidez intercambiable (ISRIC 11–cmolc/Kg–0.05),acidity_percent,,
59
CIC (ISRIC 11–cmolc/Kg–0.05),cationExchangeCapacity_cmol_kg,,
60
Arena (DIN 18 123–%–2.5),sand_percent,,
61
Limo (DIN 18 123–%–1),silt_percent,,
62
Arcilla (DIN 18 123–%–1),clay_percent,,
63 63
Textural class,texture,,
64 64
Observaciones,plotNotes,,
65 65
Orientación/exposicion,slopeAspect,/_alt/2,Part files provide either this field or Direction
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/_*/date/_alt/2/_dateRangeEnd/value,
71 71
First evaluation,/location/locationevent/obsstartdate/_*/date/_alt/2/_dateRangeStart/value,
72
Acidez intercambiable (ISRIC 11–cmolc/Kg–0.05),/location/locationevent/soilobs/acidity_fraction,
73
"Calcio intercambiable (WSP S-5,10–cmolc/Kg–0.016)",/location/locationevent/soilobs/calcium_fraction,
74
"Carbón Orgánico (WSP S-9,10–%–0.06)",/location/locationevent/soilobs/carbon_fraction,
72
Acidez intercambiable (ISRIC 11–cmolc/Kg–0.05),/location/locationevent/soilobs/acidity_fraction/_percent_to_fraction/value,
73
"Calcio intercambiable (WSP S-5,10–cmolc/Kg–0.016)",/location/locationevent/soilobs/calcium_fraction/_percent_to_fraction/value,
74
"Carbón Orgánico (WSP S-9,10–%–0.06)",/location/locationevent/soilobs/carbon_fraction/_percent_to_fraction/value,
75 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,
76
Arcilla (DIN 18 123–%–1),/location/locationevent/soilobs/clay_fraction/_percent_to_fraction/value,
77 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,
79
Nitrógeno total (ISRIC 6–%–0.0014),/location/locationevent/soilobs/nitrogen_fraction,
80
"Materia Orgánica (WSP S-9,10–%–0.1)",/location/locationevent/soilobs/organic_fraction,
78
"Magnesio intercambiable (WSP S-5,10–cmolc/Kg–0.00083)",/location/locationevent/soilobs/magnesium_fraction/_percent_to_fraction/value,
79
Nitrógeno total (ISRIC 6–%–0.0014),/location/locationevent/soilobs/nitrogen_fraction/_percent_to_fraction/value,
80
"Materia Orgánica (WSP S-9,10–%–0.1)",/location/locationevent/soilobs/organic_fraction/_percent_to_fraction/value,
81 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,
83
"Potasio intercambiable (WSP S-5,10–cmolc/Kg–0.0053)",/location/locationevent/soilobs/potassium_fraction,
84
Arena (DIN 18 123–%–2.5),/location/locationevent/soilobs/sand_fraction,
85
Limo (DIN 18 123–%–1),/location/locationevent/soilobs/silt_fraction,
86
"Sodio intercambiable (WSP S-5,10–cmolc/Kg–0.00083)",/location/locationevent/soilobs/sodium_fraction,
82
Fósforo disponible (ISRIC 14-2–mg/Kg–1.5),/location/locationevent/soilobs/phosphorus_fraction/_percent_to_fraction/value,
83
"Potasio intercambiable (WSP S-5,10–cmolc/Kg–0.0053)",/location/locationevent/soilobs/potassium_fraction/_percent_to_fraction/value,
84
Arena (DIN 18 123–%–2.5),/location/locationevent/soilobs/sand_fraction/_percent_to_fraction/value,
85
Limo (DIN 18 123–%–1),/location/locationevent/soilobs/silt_fraction/_percent_to_fraction/value,
86
"Sodio intercambiable (WSP S-5,10–cmolc/Kg–0.00083)",/location/locationevent/soilobs/sodium_fraction/_percent_to_fraction/value,
87 87
Textural class,/location/locationevent/soilobs/texture,
88 88
Inventory code,"/location/locationevent/taxonoccurrence/authortaxoncode/_first/1/_first/2/_if[@name=""if is organism""]/cond/_exists",
89 89
Inventory name,"/location/locationevent/taxonoccurrence/authortaxoncode/_first/1/_first/2/_if[@name=""if is organism""]/cond/_exists",
inputs/Madidi/Plot/test.xml.ref
63 63
                    <obsenddate><_date><date><_dateRangeEnd><value>$First evaluation</value></_dateRangeEnd></date></_date></obsenddate>
64 64
                    <obsstartdate><_date><date><_dateRangeStart><value>$First evaluation</value></_dateRangeStart></date></_date></obsstartdate>
65 65
                    <soilobs>
66
                        <acidity_fraction>$Acidez intercambiable (ISRIC 11&#8211;cmolc/Kg&#8211;0.05)</acidity_fraction>
67
                        <calcium_fraction>$Calcio intercambiable (WSP S-5,10&#8211;cmolc/Kg&#8211;0.016)</calcium_fraction>
68
                        <carbon_fraction>$Carb&#243;n Org&#225;nico (WSP S-9,10&#8211;%&#8211;0.06)</carbon_fraction>
66
                        <acidity_fraction><_percent_to_fraction><value>$Acidez intercambiable (ISRIC 11&#8211;cmolc/Kg&#8211;0.05)</value></_percent_to_fraction></acidity_fraction>
67
                        <calcium_fraction><_percent_to_fraction><value>$Calcio intercambiable (WSP S-5,10&#8211;cmolc/Kg&#8211;0.016)</value></_percent_to_fraction></calcium_fraction>
68
                        <carbon_fraction><_percent_to_fraction><value>$Carb&#243;n Org&#225;nico (WSP S-9,10&#8211;%&#8211;0.06)</value></_percent_to_fraction></carbon_fraction>
69 69
                        <cationexchangecapacity_cmol_kg>$CIC (ISRIC 11&#8211;cmolc/Kg&#8211;0.05)</cationexchangecapacity_cmol_kg>
70
                        <clay_fraction>$Arcilla (DIN 18 123&#8211;%&#8211;1)</clay_fraction>
70
                        <clay_fraction><_percent_to_fraction><value>$Arcilla (DIN 18 123&#8211;%&#8211;1)</value></_percent_to_fraction></clay_fraction>
71 71
                        <conductivity>$Conductividad electrica (ASPT 6&#8211;&#181;S/cm&#8211; 1 - 10000)</conductivity>
72
                        <magnesium_fraction>$Magnesio intercambiable (WSP S-5,10&#8211;cmolc/Kg&#8211;0.00083)</magnesium_fraction>
73
                        <nitrogen_fraction>$Nitr&#243;geno total (ISRIC 6&#8211;%&#8211;0.0014)</nitrogen_fraction>
74
                        <organic_fraction>$Materia Org&#225;nica (WSP S-9,10&#8211;%&#8211;0.1)</organic_fraction>
72
                        <magnesium_fraction><_percent_to_fraction><value>$Magnesio intercambiable (WSP S-5,10&#8211;cmolc/Kg&#8211;0.00083)</value></_percent_to_fraction></magnesium_fraction>
73
                        <nitrogen_fraction><_percent_to_fraction><value>$Nitr&#243;geno total (ISRIC 6&#8211;%&#8211;0.0014)</value></_percent_to_fraction></nitrogen_fraction>
74
                        <organic_fraction><_percent_to_fraction><value>$Materia Org&#225;nica (WSP S-9,10&#8211;%&#8211;0.1)</value></_percent_to_fraction></organic_fraction>
75 75
                        <ph>$pH acuoso (ISRIC 4&#8211;&#8211; 1 - 14)</ph>
76
                        <phosphorus_fraction>$F&#243;sforo disponible (ISRIC 14-2&#8211;mg/Kg&#8211;1.5)</phosphorus_fraction>
77
                        <potassium_fraction>$Potasio intercambiable (WSP S-5,10&#8211;cmolc/Kg&#8211;0.0053)</potassium_fraction>
78
                        <sand_fraction>$Arena (DIN 18 123&#8211;%&#8211;2.5)</sand_fraction>
79
                        <silt_fraction>$Limo (DIN 18 123&#8211;%&#8211;1)</silt_fraction>
80
                        <sodium_fraction>$Sodio intercambiable (WSP S-5,10&#8211;cmolc/Kg&#8211;0.00083)</sodium_fraction>
76
                        <phosphorus_fraction><_percent_to_fraction><value>$F&#243;sforo disponible (ISRIC 14-2&#8211;mg/Kg&#8211;1.5)</value></_percent_to_fraction></phosphorus_fraction>
77
                        <potassium_fraction><_percent_to_fraction><value>$Potasio intercambiable (WSP S-5,10&#8211;cmolc/Kg&#8211;0.0053)</value></_percent_to_fraction></potassium_fraction>
78
                        <sand_fraction><_percent_to_fraction><value>$Arena (DIN 18 123&#8211;%&#8211;2.5)</value></_percent_to_fraction></sand_fraction>
79
                        <silt_fraction><_percent_to_fraction><value>$Limo (DIN 18 123&#8211;%&#8211;1)</value></_percent_to_fraction></silt_fraction>
80
                        <sodium_fraction><_percent_to_fraction><value>$Sodio intercambiable (WSP S-5,10&#8211;cmolc/Kg&#8211;0.00083)</value></_percent_to_fraction></sodium_fraction>
81 81
                        <texture>$Textural class</texture>
82 82
                    </soilobs>
83 83
                </locationevent>
inputs/Madidi/Plot/new_terms.csv
32 32
Slope,slopeGradient,,
33 33
pH acuoso (ISRIC 4–– 1 - 14),ph,,
34 34
Conductividad electrica (ASPT 6–µS/cm– 1 - 10000),conductivity,,
35
Nitrógeno total (ISRIC 6–%–0.0014),nitrogen,,
36
"Carbón Orgánico (WSP S-9,10–%–0.06)",carbon,,
37
"Materia Orgánica (WSP S-9,10–%–0.1)",organic,,
38
Fósforo disponible (ISRIC 14-2–mg/Kg–1.5),phosphorus,,
39
"Sodio intercambiable (WSP S-5,10–cmolc/Kg–0.00083)",sodium,,
40
"Potasio intercambiable (WSP S-5,10–cmolc/Kg–0.0053)",potassium,,
41
"Calcio intercambiable (WSP S-5,10–cmolc/Kg–0.016)",calcium,,
42
"Magnesio intercambiable (WSP S-5,10–cmolc/Kg–0.00083)",magnesium,,
43
Acidez intercambiable (ISRIC 11–cmolc/Kg–0.05),acidity,,
44
CIC (ISRIC 11–cmolc/Kg–0.05),cationExchangeCapacity,,
45
Arena (DIN 18 123–%–2.5),sand,,
46
Limo (DIN 18 123–%–1),silt,,
47
Arcilla (DIN 18 123–%–1),clay,,
35
Nitrógeno total (ISRIC 6–%–0.0014),nitrogen_percent,,
36
"Carbón Orgánico (WSP S-9,10–%–0.06)",carbon_percent,,
37
"Materia Orgánica (WSP S-9,10–%–0.1)",organic_percent,,
38
Fósforo disponible (ISRIC 14-2–mg/Kg–1.5),phosphorus_percent,,
39
"Sodio intercambiable (WSP S-5,10–cmolc/Kg–0.00083)",sodium_percent,,
40
"Potasio intercambiable (WSP S-5,10–cmolc/Kg–0.0053)",potassium_percent,,
41
"Calcio intercambiable (WSP S-5,10–cmolc/Kg–0.016)",calcium_percent,,
42
"Magnesio intercambiable (WSP S-5,10–cmolc/Kg–0.00083)",magnesium_percent,,
43
Acidez intercambiable (ISRIC 11–cmolc/Kg–0.05),acidity_percent,,
44
CIC (ISRIC 11–cmolc/Kg–0.05),cationExchangeCapacity_cmol_kg,,
45
Arena (DIN 18 123–%–2.5),sand_percent,,
46
Limo (DIN 18 123–%–1),silt_percent,,
47
Arcilla (DIN 18 123–%–1),clay_percent,,
48 48
Textural class,texture,,
49 49
Observaciones,plotNotes,,
50 50
Orientación/exposicion,slopeAspect,/_alt/2,Part files provide either this field or Direction
inputs/SALVIAS-CSV/Plot/map.csv
16 16
precip_mm,precipitation,,
17 17
slope_aspect,slopeAspect,,
18 18
slope_gradient,slopeGradient,,
19
clay_percent,clay,"/_units:[default=""%"",to=]/value",
20
silt_percent,silt,"/_units:[default=""%"",to=]/value",
21
sand_percent,sand,"/_units:[default=""%"",to=]/value",
22
organic_percent,organic,"/_units:[default=""%"",to=]/value",
19
clay_percent,clay_percent,"/_units:[default=""%"",to=]/value",
20
silt_percent,silt_percent,"/_units:[default=""%"",to=]/value",
21
sand_percent,sand_percent,"/_units:[default=""%"",to=]/value",
22
organic_percent,organic_percent,"/_units:[default=""%"",to=]/value",
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,"/_units:[default=""%"",to=]/value",
25
soil_P,phosphorus,"/_units:[default=""%"",to=]/value/_map:[""<1,5""=0,*=*]/value",
26
soil_C,carbon,"/_units:[default=""%"",to=]/value",
27
soil_K,potassium,"/_units:[default=""%"",to=]/value",
28
soil_Mg,magnesium,"/_units:[default=""%"",to=]/value",
29
soil_Ca,calcium,"/_units:[default=""%"",to=]/value",
30
soil_Na,sodium,"/_units:[default=""%"",to=]/value",
31
soil_acidity,acidity,"/_units:[default=""%"",to=]/value/_map:[""<0.05""=0,*=*]/value",
32
soil_base,baseSaturation,"/_units:[default=""%"",to=]/value",
33
soil_cation_cap,cationExchangeCapacity,,
24
soil_N,nitrogen_percent,"/_units:[default=""%"",to=]/value",
25
soil_P,phosphorus_percent,"/_units:[default=""%"",to=]/value/_map:[""<1,5""=0,*=*]/value",
26
soil_C,carbon_percent,"/_units:[default=""%"",to=]/value",
27
soil_K,potassium_percent,"/_units:[default=""%"",to=]/value",
28
soil_Mg,magnesium_percent,"/_units:[default=""%"",to=]/value",
29
soil_Ca,calcium_percent,"/_units:[default=""%"",to=]/value",
30
soil_Na,sodium_percent,"/_units:[default=""%"",to=]/value",
31
soil_acidity,acidity_percent,"/_units:[default=""%"",to=]/value/_map:[""<0.05""=0,*=*]/value",
32
soil_base,baseSaturation_percent,"/_units:[default=""%"",to=]/value",
33
soil_cation_cap,cationExchangeCapacity_cmol_kg,,
34 34
soil_conductivity,conductivity,,
35 35
soil_texture,texture,,
36 36
holdridge_life_zone,communityID,,
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/_units:[default=""%"",to=]/value/_map:[""<0.05""=0,*=*]/value",
23
soil_base,"/location/locationevent/soilobs/basesaturation_fraction/_units:[default=""%"",to=]/value",
24
soil_Ca,"/location/locationevent/soilobs/calcium_fraction/_units:[default=""%"",to=]/value",
25
soil_C,"/location/locationevent/soilobs/carbon_fraction/_units:[default=""%"",to=]/value",
22
soil_acidity,"/location/locationevent/soilobs/acidity_fraction/_percent_to_fraction/value/_units:[default=""%"",to=]/value/_map:[""<0.05""=0,*=*]/value",
23
soil_base,"/location/locationevent/soilobs/basesaturation_fraction/_percent_to_fraction/value/_units:[default=""%"",to=]/value",
24
soil_Ca,"/location/locationevent/soilobs/calcium_fraction/_percent_to_fraction/value/_units:[default=""%"",to=]/value",
25
soil_C,"/location/locationevent/soilobs/carbon_fraction/_percent_to_fraction/value/_units:[default=""%"",to=]/value",
26 26
soil_cation_cap,/location/locationevent/soilobs/cationexchangecapacity_cmol_kg,
27
clay_percent,"/location/locationevent/soilobs/clay_fraction/_units:[default=""%"",to=]/value",
27
clay_percent,"/location/locationevent/soilobs/clay_fraction/_percent_to_fraction/value/_units:[default=""%"",to=]/value",
28 28
soil_conductivity,/location/locationevent/soilobs/conductivity,
29
soil_Mg,"/location/locationevent/soilobs/magnesium_fraction/_units:[default=""%"",to=]/value",
30
soil_N,"/location/locationevent/soilobs/nitrogen_fraction/_units:[default=""%"",to=]/value",
31
organic_percent,"/location/locationevent/soilobs/organic_fraction/_units:[default=""%"",to=]/value",
29
soil_Mg,"/location/locationevent/soilobs/magnesium_fraction/_percent_to_fraction/value/_units:[default=""%"",to=]/value",
30
soil_N,"/location/locationevent/soilobs/nitrogen_fraction/_percent_to_fraction/value/_units:[default=""%"",to=]/value",
31
organic_percent,"/location/locationevent/soilobs/organic_fraction/_percent_to_fraction/value/_units:[default=""%"",to=]/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/_units:[default=""%"",to=]/value/_map:[""<1,5""=0,*=*]/value",
34
soil_K,"/location/locationevent/soilobs/potassium_fraction/_units:[default=""%"",to=]/value",
35
sand_percent,"/location/locationevent/soilobs/sand_fraction/_units:[default=""%"",to=]/value",
36
silt_percent,"/location/locationevent/soilobs/silt_fraction/_units:[default=""%"",to=]/value",
37
soil_Na,"/location/locationevent/soilobs/sodium_fraction/_units:[default=""%"",to=]/value",
33
soil_P,"/location/locationevent/soilobs/phosphorus_fraction/_percent_to_fraction/value/_units:[default=""%"",to=]/value/_map:[""<1,5""=0,*=*]/value",
34
soil_K,"/location/locationevent/soilobs/potassium_fraction/_percent_to_fraction/value/_units:[default=""%"",to=]/value",
35
sand_percent,"/location/locationevent/soilobs/sand_fraction/_percent_to_fraction/value/_units:[default=""%"",to=]/value",
36
silt_percent,"/location/locationevent/soilobs/silt_fraction/_percent_to_fraction/value/_units:[default=""%"",to=]/value",
37
soil_Na,"/location/locationevent/soilobs/sodium_fraction/_percent_to_fraction/value/_units:[default=""%"",to=]/value",
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/test.xml.ref
52 52
                    <precipitation_m>$precip_mm</precipitation_m>
53 53
                    <soilobs>
54 54
                        <acidity_fraction>
55
                            <_units>
56
                                <default>%</default>
57
                                <to></to>
55
                            <_percent_to_fraction>
58 56
                                <value>
59
                                    <_map>
60
                                        <<0.05>0</<0.05>
61
                                        <*>*</*>
62
                                        <value>$soil_acidity</value>
63
                                    </_map>
57
                                    <_units>
58
                                        <default>%</default>
59
                                        <to></to>
60
                                        <value>
61
                                            <_map>
62
                                                <<0.05>0</<0.05>
63
                                                <*>*</*>
64
                                                <value>$soil_acidity</value>
65
                                            </_map>
66
                                        </value>
67
                                    </_units>
64 68
                                </value>
65
                            </_units>
69
                            </_percent_to_fraction>
66 70
                        </acidity_fraction>
67 71
                        <basesaturation_fraction>
68
                            <_units>
69
                                <default>%</default>
70
                                <to></to>
71
                                <value>$soil_base</value>
72
                            </_units>
72
                            <_percent_to_fraction>
73
                                <value>
74
                                    <_units>
75
                                        <default>%</default>
76
                                        <to></to>
77
                                        <value>$soil_base</value>
78
                                    </_units>
79
                                </value>
80
                            </_percent_to_fraction>
73 81
                        </basesaturation_fraction>
74 82
                        <calcium_fraction>
75
                            <_units>
76
                                <default>%</default>
77
                                <to></to>
78
                                <value>$soil_Ca</value>
79
                            </_units>
83
                            <_percent_to_fraction>
84
                                <value>
85
                                    <_units>
86
                                        <default>%</default>
87
                                        <to></to>
88
                                        <value>$soil_Ca</value>
89
                                    </_units>
90
                                </value>
91
                            </_percent_to_fraction>
80 92
                        </calcium_fraction>
81 93
                        <carbon_fraction>
82
                            <_units>
83
                                <default>%</default>
84
                                <to></to>
85
                                <value>$soil_C</value>
86
                            </_units>
94
                            <_percent_to_fraction>
95
                                <value>
96
                                    <_units>
97
                                        <default>%</default>
98
                                        <to></to>
99
                                        <value>$soil_C</value>
100
                                    </_units>
101
                                </value>
102
                            </_percent_to_fraction>
87 103
                        </carbon_fraction>
88 104
                        <cationexchangecapacity_cmol_kg>$soil_cation_cap</cationexchangecapacity_cmol_kg>
89 105
                        <clay_fraction>
90
                            <_units>
91
                                <default>%</default>
92
                                <to></to>
93
                                <value>$clay_percent</value>
94
                            </_units>
106
                            <_percent_to_fraction>
107
                                <value>
108
                                    <_units>
109
                                        <default>%</default>
110
                                        <to></to>
111
                                        <value>$clay_percent</value>
112
                                    </_units>
113
                                </value>
114
                            </_percent_to_fraction>
95 115
                        </clay_fraction>
96 116
                        <conductivity>$soil_conductivity</conductivity>
97 117
                        <magnesium_fraction>
98
                            <_units>
99
                                <default>%</default>
100
                                <to></to>
101
                                <value>$soil_Mg</value>
102
                            </_units>
118
                            <_percent_to_fraction>
119
                                <value>
120
                                    <_units>
121
                                        <default>%</default>
122
                                        <to></to>
123
                                        <value>$soil_Mg</value>
124
                                    </_units>
125
                                </value>
126
                            </_percent_to_fraction>
103 127
                        </magnesium_fraction>
104 128
                        <nitrogen_fraction>
105
                            <_units>
106
                                <default>%</default>
107
                                <to></to>
108
                                <value>$soil_N</value>
109
                            </_units>
129
                            <_percent_to_fraction>
130
                                <value>
131
                                    <_units>
132
                                        <default>%</default>
133
                                        <to></to>
134
                                        <value>$soil_N</value>
135
                                    </_units>
136
                                </value>
137
                            </_percent_to_fraction>
110 138
                        </nitrogen_fraction>
111 139
                        <organic_fraction>
112
                            <_units>
113
                                <default>%</default>
114
                                <to></to>
115
                                <value>$organic_percent</value>
116
                            </_units>
140
                            <_percent_to_fraction>
141
                                <value>
142
                                    <_units>
143
                                        <default>%</default>
144
                                        <to></to>
145
                                        <value>$organic_percent</value>
146
                                    </_units>
147
                                </value>
148
                            </_percent_to_fraction>
117 149
                        </organic_fraction>
118 150
                        <ph>$pH</ph>
119 151
                        <phosphorus_fraction>
120
                            <_units>
121
                                <default>%</default>
122
                                <to></to>
152
                            <_percent_to_fraction>
123 153
                                <value>
124
                                    <_map>
125
                                        <<1,5>0</<1,5>
126
                                        <*>*</*>
127
                                        <value>$soil_P</value>
128
                                    </_map>
154
                                    <_units>
155
                                        <default>%</default>
156
                                        <to></to>
157
                                        <value>
158
                                            <_map>
159
                                                <<1,5>0</<1,5>
160
                                                <*>*</*>
161
                                                <value>$soil_P</value>
162
                                            </_map>
163
                                        </value>
164
                                    </_units>
129 165
                                </value>
130
                            </_units>
166
                            </_percent_to_fraction>
131 167
                        </phosphorus_fraction>
132 168
                        <potassium_fraction>
133
                            <_units>
134
                                <default>%</default>
135
                                <to></to>
136
                                <value>$soil_K</value>
137
                            </_units>
169
                            <_percent_to_fraction>
170
                                <value>
171
                                    <_units>
172
                                        <default>%</default>
173
                                        <to></to>
174
                                        <value>$soil_K</value>
175
                                    </_units>
176
                                </value>
177
                            </_percent_to_fraction>
138 178
                        </potassium_fraction>
139 179
                        <sand_fraction>
140
                            <_units>
141
                                <default>%</default>
142
                                <to></to>
143
                                <value>$sand_percent</value>
144
                            </_units>
180
                            <_percent_to_fraction>
181
                                <value>
182
                                    <_units>
183
                                        <default>%</default>
184
                                        <to></to>
185
                                        <value>$sand_percent</value>
186
                                    </_units>
187
                                </value>
188
                            </_percent_to_fraction>
145 189
                        </sand_fraction>
146 190
                        <silt_fraction>
147
                            <_units>
148
                                <default>%</default>
149
                                <to></to>
150
                                <value>$silt_percent</value>
151
                            </_units>
191
                            <_percent_to_fraction>
192
                                <value>
193
                                    <_units>
194
                                        <default>%</default>
195
                                        <to></to>
196
                                        <value>$silt_percent</value>
197
                                    </_units>
198
                                </value>
199
                            </_percent_to_fraction>
152 200
                        </silt_fraction>
153 201
                        <sodium_fraction>
154
                            <_units>
155
                                <default>%</default>
156
                                <to></to>
157
                                <value>$soil_Na</value>
158
                            </_units>
202
                            <_percent_to_fraction>
203
                                <value>
204
                                    <_units>
205
                                        <default>%</default>
206
                                        <to></to>
207
                                        <value>$soil_Na</value>
208
                                    </_units>
209
                                </value>
210
                            </_percent_to_fraction>
159 211
                        </sodium_fraction>
160 212
                        <texture>$soil_texture</texture>
161 213
                    </soilobs>
inputs/SALVIAS-CSV/Plot/new_terms.csv
11 11
elev_min_m,minimumElevationInMeters,,
12 12
temp_c,temperature,,
13 13
precip_mm,precipitation,,
14
clay_percent,clay,"/_units:[default=""%"",to=]/value",
15
silt_percent,silt,"/_units:[default=""%"",to=]/value",
16
sand_percent,sand,"/_units:[default=""%"",to=]/value",
17
organic_percent,organic,"/_units:[default=""%"",to=]/value",
18
soil_N,nitrogen,"/_units:[default=""%"",to=]/value",
19
soil_P,phosphorus,"/_units:[default=""%"",to=]/value/_map:[""<1,5""=0,*=*]/value",
20
soil_C,carbon,"/_units:[default=""%"",to=]/value",
21
soil_K,potassium,"/_units:[default=""%"",to=]/value",
22
soil_Mg,magnesium,"/_units:[default=""%"",to=]/value",
23
soil_Ca,calcium,"/_units:[default=""%"",to=]/value",
24
soil_Na,sodium,"/_units:[default=""%"",to=]/value",
25
soil_acidity,acidity,"/_units:[default=""%"",to=]/value/_map:[""<0.05""=0,*=*]/value",
26
soil_base,baseSaturation,"/_units:[default=""%"",to=]/value",
27
soil_cation_cap,cationExchangeCapacity,,
14
soil_N,nitrogen_percent,"/_units:[default=""%"",to=]/value",
15
soil_P,phosphorus_percent,"/_units:[default=""%"",to=]/value/_map:[""<1,5""=0,*=*]/value",
16
soil_C,carbon_percent,"/_units:[default=""%"",to=]/value",
17
soil_K,potassium_percent,"/_units:[default=""%"",to=]/value",
18
soil_Mg,magnesium_percent,"/_units:[default=""%"",to=]/value",
19
soil_Ca,calcium_percent,"/_units:[default=""%"",to=]/value",
20
soil_Na,sodium_percent,"/_units:[default=""%"",to=]/value",
21
soil_acidity,acidity_percent,"/_units:[default=""%"",to=]/value/_map:[""<0.05""=0,*=*]/value",
22
soil_base,baseSaturation_percent,"/_units:[default=""%"",to=]/value",
23
soil_cation_cap,cationExchangeCapacity_cmol_kg,,
28 24
soil_conductivity,conductivity,,
29 25
soil_texture,texture,,
30 26
holdridge_life_zone,communityID,,
inputs/SALVIAS/plotMetadata/map.csv
29 29
bearing,bearing,,
30 30
slope_aspect,slopeAspect,,
31 31
slope_gradient,slopeGradient,,
32
clay_percent,clay,"/_units:[default=""%"",to=]/value",
33
silt_percent,silt,"/_units:[default=""%"",to=]/value",
34
sand_percent,sand,"/_units:[default=""%"",to=]/value",
32
clay_percent,clay_percent,"/_units:[default=""%"",to=]/value",
33
silt_percent,silt_percent,"/_units:[default=""%"",to=]/value",
34
sand_percent,sand_percent,"/_units:[default=""%"",to=]/value",
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,"/_units:[default=""%"",to=]/value",
37
soil_P,phosphorus,"/_units:[default=""%"",to=]/value/_map:[""<1,5""=0,*=*]/value",
38
soil_C,carbon,"/_units:[default=""%"",to=]/value",
39
soil_K,potassium,"/_units:[default=""%"",to=]/value",
40
soil_Mg,magnesium,"/_units:[default=""%"",to=]/value",
41
soil_Ca,calcium,"/_units:[default=""%"",to=]/value",
42
soil_Na,sodium,"/_units:[default=""%"",to=]/value",
43
soil_acidity,acidity,"/_units:[default=""%"",to=]/value/_map:[""<0.05""=0,*=*]/value",
44
soil_base,baseSaturation,"/_units:[default=""%"",to=]/value",
45
soil_cation_cap,cationExchangeCapacity,,
36
soil_N,nitrogen_percent,"/_units:[default=""%"",to=]/value",
37
soil_P,phosphorus_percent,"/_units:[default=""%"",to=]/value/_map:[""<1,5""=0,*=*]/value",
38
soil_C,carbon_percent,"/_units:[default=""%"",to=]/value",
39
soil_K,potassium_percent,"/_units:[default=""%"",to=]/value",
40
soil_Mg,magnesium_percent,"/_units:[default=""%"",to=]/value",
41
soil_Ca,calcium_percent,"/_units:[default=""%"",to=]/value",
42
soil_Na,sodium_percent,"/_units:[default=""%"",to=]/value",
43
soil_acidity,acidity_percent,"/_units:[default=""%"",to=]/value/_map:[""<0.05""=0,*=*]/value",
44
soil_base,baseSaturation_percent,"/_units:[default=""%"",to=]/value",
45
soil_cation_cap,cationExchangeCapacity_cmol_kg,,
46 46
soil_conductivity,conductivity,,
47
organic_percent,organic,"/_units:[default=""%"",to=]/value",
47
organic_percent,organic_percent,"/_units:[default=""%"",to=]/value",
48 48
soil_texture,texture,"/_units:[default=""%"",to=]/value",
49 49
RevisionComments,RevisionComments,,
50 50
Locality_Description,locality,,"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"
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/_units:[default=""%"",to=]/value/_map:[""<0.05""=0,*=*]/value",
23
soil_base,"/location/locationevent/soilobs/basesaturation_fraction/_units:[default=""%"",to=]/value",
24
soil_Ca,"/location/locationevent/soilobs/calcium_fraction/_units:[default=""%"",to=]/value",
25
soil_C,"/location/locationevent/soilobs/carbon_fraction/_units:[default=""%"",to=]/value",
22
soil_acidity,"/location/locationevent/soilobs/acidity_fraction/_percent_to_fraction/value/_units:[default=""%"",to=]/value/_map:[""<0.05""=0,*=*]/value",
23
soil_base,"/location/locationevent/soilobs/basesaturation_fraction/_percent_to_fraction/value/_units:[default=""%"",to=]/value",
24
soil_Ca,"/location/locationevent/soilobs/calcium_fraction/_percent_to_fraction/value/_units:[default=""%"",to=]/value",
25
soil_C,"/location/locationevent/soilobs/carbon_fraction/_percent_to_fraction/value/_units:[default=""%"",to=]/value",
26 26
soil_cation_cap,/location/locationevent/soilobs/cationexchangecapacity_cmol_kg,
27
clay_percent,"/location/locationevent/soilobs/clay_fraction/_units:[default=""%"",to=]/value",
27
clay_percent,"/location/locationevent/soilobs/clay_fraction/_percent_to_fraction/value/_units:[default=""%"",to=]/value",
28 28
soil_conductivity,/location/locationevent/soilobs/conductivity,
29
soil_Mg,"/location/locationevent/soilobs/magnesium_fraction/_units:[default=""%"",to=]/value",
30
soil_N,"/location/locationevent/soilobs/nitrogen_fraction/_units:[default=""%"",to=]/value",
31
organic_percent,"/location/locationevent/soilobs/organic_fraction/_units:[default=""%"",to=]/value",
29
soil_Mg,"/location/locationevent/soilobs/magnesium_fraction/_percent_to_fraction/value/_units:[default=""%"",to=]/value",
30
soil_N,"/location/locationevent/soilobs/nitrogen_fraction/_percent_to_fraction/value/_units:[default=""%"",to=]/value",
31
organic_percent,"/location/locationevent/soilobs/organic_fraction/_percent_to_fraction/value/_units:[default=""%"",to=]/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/_units:[default=""%"",to=]/value/_map:[""<1,5""=0,*=*]/value",
34
soil_K,"/location/locationevent/soilobs/potassium_fraction/_units:[default=""%"",to=]/value",
35
sand_percent,"/location/locationevent/soilobs/sand_fraction/_units:[default=""%"",to=]/value",
36
silt_percent,"/location/locationevent/soilobs/silt_fraction/_units:[default=""%"",to=]/value",
37
soil_Na,"/location/locationevent/soilobs/sodium_fraction/_units:[default=""%"",to=]/value",
33
soil_P,"/location/locationevent/soilobs/phosphorus_fraction/_percent_to_fraction/value/_units:[default=""%"",to=]/value/_map:[""<1,5""=0,*=*]/value",
34
soil_K,"/location/locationevent/soilobs/potassium_fraction/_percent_to_fraction/value/_units:[default=""%"",to=]/value",
35
sand_percent,"/location/locationevent/soilobs/sand_fraction/_percent_to_fraction/value/_units:[default=""%"",to=]/value",
36
silt_percent,"/location/locationevent/soilobs/silt_fraction/_percent_to_fraction/value/_units:[default=""%"",to=]/value",
37
soil_Na,"/location/locationevent/soilobs/sodium_fraction/_percent_to_fraction/value/_units:[default=""%"",to=]/value",
38 38
soil_texture,"/location/locationevent/soilobs/texture/_units:[default=""%"",to=]/value",
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/test.xml.ref
52 52
                    <precipitation_m>$Precip</precipitation_m>
53 53
                    <soilobs>
54 54
                        <acidity_fraction>
55
                            <_units>
56
                                <default>%</default>
57
                                <to></to>
55
                            <_percent_to_fraction>
58 56
                                <value>
59
                                    <_map>
60
                                        <<0.05>0</<0.05>
61
                                        <*>*</*>
62
                                        <value>$soil_acidity</value>
63
                                    </_map>
57
                                    <_units>
58
                                        <default>%</default>
59
                                        <to></to>
60
                                        <value>
61
                                            <_map>
62
                                                <<0.05>0</<0.05>
63
                                                <*>*</*>
64
                                                <value>$soil_acidity</value>
65
                                            </_map>
66
                                        </value>
67
                                    </_units>
64 68
                                </value>
65
                            </_units>
69
                            </_percent_to_fraction>
66 70
                        </acidity_fraction>
67 71
                        <basesaturation_fraction>
68
                            <_units>
69
                                <default>%</default>
70
                                <to></to>
71
                                <value>$soil_base</value>
72
                            </_units>
72
                            <_percent_to_fraction>
73
                                <value>
74
                                    <_units>
75
                                        <default>%</default>
76
                                        <to></to>
77
                                        <value>$soil_base</value>
78
                                    </_units>
79
                                </value>
80
                            </_percent_to_fraction>
73 81
                        </basesaturation_fraction>
74 82
                        <calcium_fraction>
75
                            <_units>
76
                                <default>%</default>
77
                                <to></to>
78
                                <value>$soil_Ca</value>
79
                            </_units>
83
                            <_percent_to_fraction>
84
                                <value>
85
                                    <_units>
86
                                        <default>%</default>
87
                                        <to></to>
88
                                        <value>$soil_Ca</value>
89
                                    </_units>
90
                                </value>
91
                            </_percent_to_fraction>
80 92
                        </calcium_fraction>
81 93
                        <carbon_fraction>
82
                            <_units>
83
                                <default>%</default>
84
                                <to></to>
85
                                <value>$soil_C</value>
86
                            </_units>
94
                            <_percent_to_fraction>
95
                                <value>
96
                                    <_units>
97
                                        <default>%</default>
98
                                        <to></to>
99
                                        <value>$soil_C</value>
100
                                    </_units>
101
                                </value>
102
                            </_percent_to_fraction>
87 103
                        </carbon_fraction>
88 104
                        <cationexchangecapacity_cmol_kg>$soil_cation_cap</cationexchangecapacity_cmol_kg>
89 105
                        <clay_fraction>
90
                            <_units>
91
                                <default>%</default>
92
                                <to></to>
93
                                <value>$clay_percent</value>
94
                            </_units>
106
                            <_percent_to_fraction>
107
                                <value>
108
                                    <_units>
109
                                        <default>%</default>
110
                                        <to></to>
111
                                        <value>$clay_percent</value>
112
                                    </_units>
113
                                </value>
114
                            </_percent_to_fraction>
95 115
                        </clay_fraction>
96 116
                        <conductivity>$soil_conductivity</conductivity>
97 117
                        <magnesium_fraction>
98
                            <_units>
99
                                <default>%</default>
100
                                <to></to>
101
                                <value>$soil_Mg</value>
102
                            </_units>
118
                            <_percent_to_fraction>
119
                                <value>
120
                                    <_units>
121
                                        <default>%</default>
122
                                        <to></to>
123
                                        <value>$soil_Mg</value>
124
                                    </_units>
125
                                </value>
126
                            </_percent_to_fraction>
103 127
                        </magnesium_fraction>
104 128
                        <nitrogen_fraction>
105
                            <_units>
106
                                <default>%</default>
107
                                <to></to>
108
                                <value>$soil_N</value>
109
                            </_units>
129
                            <_percent_to_fraction>
130
                                <value>
131
                                    <_units>
132
                                        <default>%</default>
133
                                        <to></to>
134
                                        <value>$soil_N</value>
135
                                    </_units>
136
                                </value>
137
                            </_percent_to_fraction>
110 138
                        </nitrogen_fraction>
111 139
                        <organic_fraction>
112
                            <_units>
113
                                <default>%</default>
114
                                <to></to>
115
                                <value>$organic_percent</value>
116
                            </_units>
140
                            <_percent_to_fraction>
141
                                <value>
142
                                    <_units>
143
                                        <default>%</default>
144
                                        <to></to>
145
                                        <value>$organic_percent</value>
146
                                    </_units>
147
                                </value>
148
                            </_percent_to_fraction>
117 149
                        </organic_fraction>
118 150
                        <ph>$pH</ph>
119 151
                        <phosphorus_fraction>
120
                            <_units>
121
                                <default>%</default>
122
                                <to></to>
152
                            <_percent_to_fraction>
123 153
                                <value>
124
                                    <_map>
125
                                        <<1,5>0</<1,5>
126
                                        <*>*</*>
127
                                        <value>$soil_P</value>
128
                                    </_map>
154
                                    <_units>
155
                                        <default>%</default>
156
                                        <to></to>
157
                                        <value>
158
                                            <_map>
159
                                                <<1,5>0</<1,5>
160
                                                <*>*</*>
161
                                                <value>$soil_P</value>
162
                                            </_map>
163
                                        </value>
164
                                    </_units>
129 165
                                </value>
130
                            </_units>
166
                            </_percent_to_fraction>
131 167
                        </phosphorus_fraction>
132 168
                        <potassium_fraction>
133
                            <_units>
134
                                <default>%</default>
135
                                <to></to>
136
                                <value>$soil_K</value>
137
                            </_units>
169
                            <_percent_to_fraction>
170
                                <value>
171
                                    <_units>
172
                                        <default>%</default>
173
                                        <to></to>
174
                                        <value>$soil_K</value>
175
                                    </_units>
176
                                </value>
177
                            </_percent_to_fraction>
138 178
                        </potassium_fraction>
139 179
                        <sand_fraction>
140
                            <_units>
141
                                <default>%</default>
142
                                <to></to>
143
                                <value>$sand_percent</value>
144
                            </_units>
180
                            <_percent_to_fraction>
181
                                <value>
182
                                    <_units>
183
                                        <default>%</default>
184
                                        <to></to>
185
                                        <value>$sand_percent</value>
186
                                    </_units>
187
                                </value>
188
                            </_percent_to_fraction>
145 189
                        </sand_fraction>
146 190
                        <silt_fraction>
147
                            <_units>
148
                                <default>%</default>
149
                                <to></to>
150
                                <value>$silt_percent</value>
151
                            </_units>
191
                            <_percent_to_fraction>
192
                                <value>
193
                                    <_units>
194
                                        <default>%</default>
195
                                        <to></to>
196
                                        <value>$silt_percent</value>
197
                                    </_units>
198
                                </value>
199
                            </_percent_to_fraction>
152 200
                        </silt_fraction>
153 201
                        <sodium_fraction>
154
                            <_units>
155
                                <default>%</default>
156
                                <to></to>
157
                                <value>$soil_Na</value>
158
                            </_units>
202
                            <_percent_to_fraction>
203
                                <value>
204
                                    <_units>
205
                                        <default>%</default>
206
                                        <to></to>
207
                                        <value>$soil_Na</value>
208
                                    </_units>
209
                                </value>
210
                            </_percent_to_fraction>
159 211
                        </sodium_fraction>
160 212
                        <texture>
161 213
                            <_units>
inputs/SALVIAS/plotMetadata/new_terms.csv
9 9
elev_min_m,minimumElevationInMeters,,
10 10
Precip,precipitation,,
11 11
Temp,temperature,,
12
clay_percent,clay,"/_units:[default=""%"",to=]/value",
13
silt_percent,silt,"/_units:[default=""%"",to=]/value",
14
sand_percent,sand,"/_units:[default=""%"",to=]/value",
15
soil_N,nitrogen,"/_units:[default=""%"",to=]/value",
16
soil_P,phosphorus,"/_units:[default=""%"",to=]/value/_map:[""<1,5""=0,*=*]/value",
17
soil_C,carbon,"/_units:[default=""%"",to=]/value",
18
soil_K,potassium,"/_units:[default=""%"",to=]/value",
19
soil_Mg,magnesium,"/_units:[default=""%"",to=]/value",
20
soil_Ca,calcium,"/_units:[default=""%"",to=]/value",
21
soil_Na,sodium,"/_units:[default=""%"",to=]/value",
22
soil_acidity,acidity,"/_units:[default=""%"",to=]/value/_map:[""<0.05""=0,*=*]/value",
23
soil_base,baseSaturation,"/_units:[default=""%"",to=]/value",
24
soil_cation_cap,cationExchangeCapacity,,
12
soil_N,nitrogen_percent,"/_units:[default=""%"",to=]/value",
13
soil_P,phosphorus_percent,"/_units:[default=""%"",to=]/value/_map:[""<1,5""=0,*=*]/value",
14
soil_C,carbon_percent,"/_units:[default=""%"",to=]/value",
15
soil_K,potassium_percent,"/_units:[default=""%"",to=]/value",
16
soil_Mg,magnesium_percent,"/_units:[default=""%"",to=]/value",
17
soil_Ca,calcium_percent,"/_units:[default=""%"",to=]/value",
18
soil_Na,sodium_percent,"/_units:[default=""%"",to=]/value",
19
soil_acidity,acidity_percent,"/_units:[default=""%"",to=]/value/_map:[""<0.05""=0,*=*]/value",
20
soil_base,baseSaturation_percent,"/_units:[default=""%"",to=]/value",
21
soil_cation_cap,cationExchangeCapacity_cmol_kg,,
25 22
soil_conductivity,conductivity,,
26
organic_percent,organic,"/_units:[default=""%"",to=]/value",
27 23
soil_texture,texture,"/_units:[default=""%"",to=]/value",
28 24
Locality_Description,locality,,"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"
29 25
life_zone_code,communityID,,
inputs/VegBank/observation_/map.csv
102 102
soildepthtop,soildepthtop,,
103 103
soildepthbottom,soildepthbottom,,
104 104
soilcolor,soilcolor,,
105
soilorganic,organic,,
105
soilorganic,organic_percent,,
106 106
soiltexture,texture,,
107
soilsand,sand,,
108
soilsilt,silt,,
109
soilclay,clay,,
107
soilsand,sand_percent,,
108
soilsilt,silt_percent,,
109
soilclay,clay_percent,,
110 110
soilcoarse,soilcoarse,,
111 111
soilph,ph,,
112
exchangecapacity,cationExchangeCapacity,,
113
basesaturation,baseSaturation,,
112
exchangecapacity,cationExchangeCapacity_cmol_kg,,
113
basesaturation,baseSaturation_percent,,
114 114
soildescription,soildescription,,
115 115
emb_soilobs,emb_soilobs,,
116 116
row_num,row_num,,
inputs/VegBank/observation_/VegBIEN.csv
14 14
observation_id,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/sourceaccessioncode",
15 15
obsenddate,/location/locationevent/obsenddate/_*/date/_alt/1,
16 16
obsstartdate,/location/locationevent/obsstartdate/_*/date/_alt/1,
17
basesaturation,/location/locationevent/soilobs/basesaturation_fraction,
17
basesaturation,/location/locationevent/soilobs/basesaturation_fraction/_percent_to_fraction/value,
18 18
exchangecapacity,/location/locationevent/soilobs/cationexchangecapacity_cmol_kg,
19
soilclay,/location/locationevent/soilobs/clay_fraction,
20
soilorganic,/location/locationevent/soilobs/organic_fraction,
19
soilclay,/location/locationevent/soilobs/clay_fraction/_percent_to_fraction/value,
20
soilorganic,/location/locationevent/soilobs/organic_fraction/_percent_to_fraction/value,
21 21
soilph,/location/locationevent/soilobs/ph,
22
soilsand,/location/locationevent/soilobs/sand_fraction,
23
soilsilt,/location/locationevent/soilobs/silt_fraction,
22
soilsand,/location/locationevent/soilobs/sand_fraction/_percent_to_fraction/value,
23
soilsilt,/location/locationevent/soilobs/silt_fraction/_percent_to_fraction/value,
24 24
soiltexture,/location/locationevent/soilobs/texture,
25 25
plot_id,"/location/locationevent/taxonoccurrence/authortaxoncode/_first/1/_first/2/_if[@name=""if is organism""]/cond/_exists",
26 26
accessioncode,,** No join mapping for accessioncode ** 
inputs/VegBank/observation_/test.xml.ref
13 13
                    <obsenddate><_date><date>$obsenddate</date></_date></obsenddate>
14 14
                    <obsstartdate><_date><date>$obsstartdate</date></_date></obsstartdate>
15 15
                    <soilobs>
16
                        <basesaturation_fraction>$basesaturation</basesaturation_fraction>
16
                        <basesaturation_fraction><_percent_to_fraction><value>$basesaturation</value></_percent_to_fraction></basesaturation_fraction>
17 17
                        <cationexchangecapacity_cmol_kg>$exchangecapacity</cationexchangecapacity_cmol_kg>
18
                        <clay_fraction>$soilclay</clay_fraction>
19
                        <organic_fraction>$soilorganic</organic_fraction>
18
                        <clay_fraction><_percent_to_fraction><value>$soilclay</value></_percent_to_fraction></clay_fraction>
19
                        <organic_fraction><_percent_to_fraction><value>$soilorganic</value></_percent_to_fraction></organic_fraction>
20 20
                        <ph>$soilph</ph>
21
                        <sand_fraction>$soilsand</sand_fraction>
22
                        <silt_fraction>$soilsilt</silt_fraction>
21
                        <sand_fraction><_percent_to_fraction><value>$soilsand</value></_percent_to_fraction></sand_fraction>
22
                        <silt_fraction><_percent_to_fraction><value>$soilsilt</value></_percent_to_fraction></silt_fraction>
23 23
                        <texture>$soiltexture</texture>
24 24
                    </soilobs>
25 25
                </locationevent>
inputs/VegBank/observation_/new_terms.csv
2 2
methodnarrative,samplingProtocol,,
3 3
obsstartdate,startDate,,
4 4
obsenddate,endDate,,
5
soilorganic,organic,,
5
soilorganic,organic_percent,,
6 6
soiltexture,texture,,
7
soilsand,sand,,
8
soilsilt,silt,,
9
soilclay,clay,,
7
soilsand,sand_percent,,
8
soilsilt,silt_percent,,
9
soilclay,clay_percent,,
10 10
soilph,ph,,
11
exchangecapacity,cationExchangeCapacity,,
11
exchangecapacity,cationExchangeCapacity_cmol_kg,,
mappings/VegCore-VegBIEN.csv
54 54
startDate,/location/locationevent/obsstartdate/_*/date/_alt/1,
55 55
eventDate,/location/locationevent/obsstartdate/_*/date/_alt/2/_dateRangeStart/value,
56 56
precipitation,/location/locationevent/precipitation_m,
57
acidity,/location/locationevent/soilobs/acidity_fraction,
58
baseSaturation,/location/locationevent/soilobs/basesaturation_fraction,
59
calcium,/location/locationevent/soilobs/calcium_fraction,
60
carbon,/location/locationevent/soilobs/carbon_fraction,
61
cationExchangeCapacity,/location/locationevent/soilobs/cationexchangecapacity_cmol_kg,
62
clay,/location/locationevent/soilobs/clay_fraction,
57
acidity_percent,/location/locationevent/soilobs/acidity_fraction/_percent_to_fraction/value,
58
baseSaturation_percent,/location/locationevent/soilobs/basesaturation_fraction/_percent_to_fraction/value,
59
calcium_percent,/location/locationevent/soilobs/calcium_fraction/_percent_to_fraction/value,
60
carbon_percent,/location/locationevent/soilobs/carbon_fraction/_percent_to_fraction/value,
61
cationExchangeCapacity_cmol_kg,/location/locationevent/soilobs/cationexchangecapacity_cmol_kg,
62
clay_percent,/location/locationevent/soilobs/clay_fraction/_percent_to_fraction/value,
63 63
conductivity,/location/locationevent/soilobs/conductivity,
64
magnesium,/location/locationevent/soilobs/magnesium_fraction,
65
nitrogen,/location/locationevent/soilobs/nitrogen_fraction,
66
organic,/location/locationevent/soilobs/organic_fraction,
64
magnesium_percent,/location/locationevent/soilobs/magnesium_fraction/_percent_to_fraction/value,
65
nitrogen_percent,/location/locationevent/soilobs/nitrogen_fraction/_percent_to_fraction/value,
66
organic_percent,/location/locationevent/soilobs/organic_fraction/_percent_to_fraction/value,
67 67
ph,/location/locationevent/soilobs/ph,
68
phosphorus,/location/locationevent/soilobs/phosphorus_fraction,
69
potassium,/location/locationevent/soilobs/potassium_fraction,
70
sand,/location/locationevent/soilobs/sand_fraction,
71
silt,/location/locationevent/soilobs/silt_fraction,
72
sodium,/location/locationevent/soilobs/sodium_fraction,
68
phosphorus_percent,/location/locationevent/soilobs/phosphorus_fraction/_percent_to_fraction/value,
69
potassium_percent,/location/locationevent/soilobs/potassium_fraction/_percent_to_fraction/value,
70
sand_percent,/location/locationevent/soilobs/sand_fraction/_percent_to_fraction/value,
71
silt_percent,/location/locationevent/soilobs/silt_fraction/_percent_to_fraction/value,
72
sodium_percent,/location/locationevent/soilobs/sodium_fraction/_percent_to_fraction/value,
73 73
texture,/location/locationevent/soilobs/texture,
74 74
dateCollected,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/1/_*/date,
75 75
dayCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value",
mappings/VegCore.csv
7 7
monthIdentified,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/MonthIdentified,54
8 8
yearCollected,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/YearCollected,9
9 9
yearIdentified,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/YearIdentified,53
10
carbon,Expanded for clarity,http://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=salvias_plots&table=plotMetadata&target=tbl_structure.php#soil_C,37
11
calcium,Expanded for clarity,http://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=salvias_plots&table=plotMetadata&target=tbl_structure.php#soil_Ca,40
12
sodium,Expanded for clarity,http://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=salvias_plots&table=plotMetadata&target=tbl_structure.php#soil_Na,41
13
acidity,,http://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=salvias_plots&table=plotMetadata&target=tbl_structure.php#soil_acidity,42
10
carbon_percent,Expanded for clarity. Added units.,http://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=salvias_plots&table=plotMetadata&target=tbl_structure.php#soil_C,37
11
calcium_percent,Expanded for clarity. Added units.,http://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=salvias_plots&table=plotMetadata&target=tbl_structure.php#soil_Ca,40
12
sodium_percent,Expanded for clarity. Added units.,http://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=salvias_plots&table=plotMetadata&target=tbl_structure.php#soil_Na,41
13
acidity_percent,Added units,http://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=salvias_plots&table=plotMetadata&target=tbl_structure.php#soil_acidity,42
14 14
conductivity,,http://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=salvias_plots&table=plotMetadata&target=tbl_structure.php#soil_conductivity,45
15 15
diameterBreastHeightGentry,Expanded for clarity,http://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=salvias_plots&table=stems&target=tbl_structure.php#gentry_dbh,7
16 16
stemID,,http://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=salvias_plots&table=stems&target=tbl_structure.php#stem_id,1
......
240 240
maxSlopeGradient,,http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=plot&entity=dba_tabledescription&where=where_tablename#maxSlopeGradient ,
241 241
minSlopeAspect,,http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=plot&entity=dba_tabledescription&where=where_tablename#minSlopeAspect ,
242 242
minSlopeGradient,,http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=plot&entity=dba_tabledescription&where=where_tablename#minSlopeGradient ,
243
baseSaturation,,http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=soilObs&entity=dba_tabledescription&where=where_tablename#baseSaturation,14
244
cationExchangeCapacity,Expanded for clarity,"http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=soilObs&entity=dba_tabledescription&where=where_tablename#exchangeCapacity, http://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=salvias_plots&table=plotMetadata&target=tbl_structure.php#soil_cation_cap","13, 44"
245
clay,,http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=soilObs&entity=dba_tabledescription&where=where_tablename#soilClay,10
246
organic,,http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=soilObs&entity=dba_tabledescription&where=where_tablename#soilOrganic,6
247
sand,,http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=soilObs&entity=dba_tabledescription&where=where_tablename#soilSand,8
248
silt,,http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=soilObs&entity=dba_tabledescription&where=where_tablename#soilSilt,9
243
baseSaturation_percent,Added units,http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=soilObs&entity=dba_tabledescription&where=where_tablename#baseSaturation,14
244
cationExchangeCapacity_cmol_kg,Expanded for clarity,"http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=soilObs&entity=dba_tabledescription&where=where_tablename#exchangeCapacity, http://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=salvias_plots&table=plotMetadata&target=tbl_structure.php#soil_cation_cap","13, 44"
245
clay_percent,Added units,http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=soilObs&entity=dba_tabledescription&where=where_tablename#soilClay,10
246
organic_percent,Added units,http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=soilObs&entity=dba_tabledescription&where=where_tablename#soilOrganic,6
247
sand_percent,Added units,http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=soilObs&entity=dba_tabledescription&where=where_tablename#soilSand,8
248
silt_percent,Added units,http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=soilObs&entity=dba_tabledescription&where=where_tablename#soilSilt,9
249 249
texture,,http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=soilObs&entity=dba_tabledescription&where=where_tablename#soilTexture,7
250 250
stemCount,,http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=stemcount&entity=dba_tabledescription&where=where_tablename#stemCount,6
251 251
taxonOccurrenceID,,"http://vegbiendev.nceas.ucsb.edu/phppgadmin/tblproperties.php?subject=table&table=taxonoccurrence&server=localhost%3A5432%3Aallow&database=vegbien&schema=public, http://rs.tdwg.org/dwc/terms/#occurrenceID",", 0"
......
253 253
variety,,"http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/tcsv101.xsd#/TaxonomicRankBelowSubspeciesEnum/var, http://en.wikipedia.org/wiki/Taxonomic_rank#Ranks_in_botany",
254 254
cultivar,,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/tcsv101.xsd#/TaxonomicRankCultivatedPlants/cv,
255 255
subspecies,,"http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/tcsv101.xsd#/TaxonomicRankSpeciesGroupEnum/ssp, http://en.wikipedia.org/wiki/Taxonomic_rank#Ranks_in_botany",
256
magnesium,,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/abioticObservations/abioticObservation/magnesium,4
257
nitrogen,,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/abioticObservations/abioticObservation/nitrogen,5
256
magnesium_percent,Added units,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/abioticObservations/abioticObservation/magnesium,4
257
nitrogen_percent,Added units,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/abioticObservations/abioticObservation/nitrogen,5
258 258
ph,,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/abioticObservations/abioticObservation/ph,6
259
phosphorus,,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/abioticObservations/abioticObservation/phosphorus,2
260
potassium,Spelling corrected,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/abioticObservations/abioticObservation/pottasium,3
259
phosphorus_percent,Added units,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/abioticObservations/abioticObservation/phosphorus,2
260
potassium_percent,Spelling corrected. Added units.,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/abioticObservations/abioticObservation/pottasium,3
261 261
coverPercent,,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/attributes/attribute/ordinal/coverPercent,0
262 262
communityID,Table shortened for standardization,"http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/communityDeterminations/communityDetermination/communityConcepts/communityConcept, http://rs.tdwg.org/dwc/terms/#occurrenceID",", 0"
263 263
communityName,Table shortened for standardization,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/communityDeterminations/communityDetermination/communityConcepts/communityConcept/name,0
mappings/for_review/VegCore-VegBIEN.csv
54 54
startDate,//locationevent/obsstartdate/_*/date,
55 55
eventDate,//locationevent/obsstartdate/_*/date,
56 56
precipitation,//locationevent/precipitation_m,
57
acidity,//soilobs/acidity_fraction,
58
baseSaturation,//soilobs/basesaturation_fraction,
59
calcium,//soilobs/calcium_fraction,
60
carbon,//soilobs/carbon_fraction,
61
cationExchangeCapacity,//soilobs/cationexchangecapacity_cmol_kg,
62
clay,//soilobs/clay_fraction,
57
acidity_percent,//soilobs/acidity_fraction/_percent_to_fraction/value,
58
baseSaturation_percent,//soilobs/basesaturation_fraction/_percent_to_fraction/value,
59
calcium_percent,//soilobs/calcium_fraction/_percent_to_fraction/value,
60
carbon_percent,//soilobs/carbon_fraction/_percent_to_fraction/value,
61
cationExchangeCapacity_cmol_kg,//soilobs/cationexchangecapacity_cmol_kg,
62
clay_percent,//soilobs/clay_fraction/_percent_to_fraction/value,
63 63
conductivity,//soilobs/conductivity,
64
magnesium,//soilobs/magnesium_fraction,
65
nitrogen,//soilobs/nitrogen_fraction,
66
organic,//soilobs/organic_fraction,
64
magnesium_percent,//soilobs/magnesium_fraction/_percent_to_fraction/value,
65
nitrogen_percent,//soilobs/nitrogen_fraction/_percent_to_fraction/value,
66
organic_percent,//soilobs/organic_fraction/_percent_to_fraction/value,
67 67
ph,//soilobs/ph,
68
phosphorus,//soilobs/phosphorus_fraction,
69
potassium,//soilobs/potassium_fraction,
70
sand,//soilobs/sand_fraction,
71
silt,//soilobs/silt_fraction,
72
sodium,//soilobs/sodium_fraction,
68
phosphorus_percent,//soilobs/phosphorus_fraction/_percent_to_fraction/value,
69
potassium_percent,//soilobs/potassium_fraction/_percent_to_fraction/value,
70
sand_percent,//soilobs/sand_fraction/_percent_to_fraction/value,
71
silt_percent,//soilobs/silt_fraction/_percent_to_fraction/value,
72
sodium_percent,//soilobs/sodium_fraction/_percent_to_fraction/value,
73 73
texture,//soilobs/texture,
74 74
dateCollected,//aggregateoccurrence/collectiondate/_*/date,
75 75
dayCollected,//aggregateoccurrence/collectiondate,

Also available in: Unified diff