Project

General

Profile

« Previous | Next » 

Revision 6403

mappings/VegCore-VegBIEN.csv: Set the source_id col_default to the datasource name using the new _setDefault() built-in function and _env()

View differences:

test.xml.ref
1 1
Put template:
2 2
<VegBIEN>
3
    <_simplifyPath id="-1">
4
        <next>parent_id</next>
3
    <_setDefault id="-1">
4
        <col>source_id</col>
5
        <value><source><shortname>Madidi</shortname></source></value>
5 6
        <path>
6
            <location>
7
                <authorlocationcode>$Inventory name</authorlocationcode>
8
                <sourceaccessioncode>$Inventory code</sourceaccessioncode>
9
                <area_m2><_ha_to_m2><value>$Area</value></_ha_to_m2></area_m2>
10
                <elevation_m>
11
                    <_alt>
12
                        <1>$Altitude</1>
13
                        <2>
14
                            <_avg>
15
                                <max><_rangeEnd><value>$Minimum altitude</value></_rangeEnd></max>
16
                                <min><_rangeStart><value>$Minimum altitude</value></_rangeStart></min>
17
                            </_avg>
18
                        </2>
19
                    </_alt>
20
                </elevation_m>
21
                <elevationrange_m>
22
                    <_range>
23
                        <from><_rangeStart><value>$Minimum altitude</value></_rangeStart></from>
24
                        <to><_rangeEnd><value>$Minimum altitude</value></_rangeEnd></to>
25
                    </_range>
26
                </elevationrange_m>
27
                <landform>$Topographical situation</landform>
28
                <locationevent>
29
                    <project_id>
30
                        <project>
31
                            <projectname>$Expedition name</projectname>
32
                            <sourceaccessioncode>$Expedition number</sourceaccessioncode>
33
                        </project>
34
                    </project_id>
35
                    <commclass>
36
                        <commdetermination>
37
                            <commconcept_id>
38
                                <commconcept>
39
                                    <commname_id><commname><commname>$Vegetation type</commname></commname></commname_id>
40
                                    <commdescription>$Locality description</commdescription>
41
                                </commconcept>
42
                            </commconcept_id>
43
                        </commdetermination>
44
                    </commclass>
45
                    <obsenddate><_dateRangeEnd><value>$First evaluation</value></_dateRangeEnd></obsenddate>
46
                    <obsstartdate><_dateRangeStart><value>$First evaluation</value></_dateRangeStart></obsstartdate>
47
                    <soilobs>
48
                        <acidity_fraction><_percent_to_fraction><value>$Acidez intercambiable (ISRIC 11&#8211;cmolc/Kg&#8211;0.05)</value></_percent_to_fraction></acidity_fraction>
49
                        <calcium_fraction><_percent_to_fraction><value>$Calcio intercambiable (WSP S-5,10&#8211;cmolc/Kg&#8211;0.016)</value></_percent_to_fraction></calcium_fraction>
50
                        <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>
51
                        <cationexchangecapacity_cmol_kg>$CIC (ISRIC 11&#8211;cmolc/Kg&#8211;0.05)</cationexchangecapacity_cmol_kg>
52
                        <clay_fraction><_percent_to_fraction><value>$Arcilla (DIN 18 123&#8211;%&#8211;1)</value></_percent_to_fraction></clay_fraction>
53
                        <conductivity>$Conductividad electrica (ASPT 6&#8211;&#181;S/cm&#8211; 1 - 10000)</conductivity>
54
                        <magnesium_fraction><_percent_to_fraction><value>$Magnesio intercambiable (WSP S-5,10&#8211;cmolc/Kg&#8211;0.00083)</value></_percent_to_fraction></magnesium_fraction>
55
                        <nitrogen_fraction><_percent_to_fraction><value>$Nitr&#243;geno total (ISRIC 6&#8211;%&#8211;0.0014)</value></_percent_to_fraction></nitrogen_fraction>
56
                        <organic_fraction><_percent_to_fraction><value>$Materia Org&#225;nica (WSP S-9,10&#8211;%&#8211;0.1)</value></_percent_to_fraction></organic_fraction>
57
                        <ph>$pH acuoso (ISRIC 4&#8211;&#8211; 1 - 14)</ph>
58
                        <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>
59
                        <potassium_fraction><_percent_to_fraction><value>$Potasio intercambiable (WSP S-5,10&#8211;cmolc/Kg&#8211;0.0053)</value></_percent_to_fraction></potassium_fraction>
60
                        <sand_fraction><_percent_to_fraction><value>$Arena (DIN 18 123&#8211;%&#8211;2.5)</value></_percent_to_fraction></sand_fraction>
61
                        <silt_fraction><_percent_to_fraction><value>$Limo (DIN 18 123&#8211;%&#8211;1)</value></_percent_to_fraction></silt_fraction>
62
                        <sodium_fraction><_percent_to_fraction><value>$Sodio intercambiable (WSP S-5,10&#8211;cmolc/Kg&#8211;0.00083)</value></_percent_to_fraction></sodium_fraction>
63
                        <texture>$Textural class</texture>
64
                    </soilobs>
65
                </locationevent>
66
                <locationnarrative>$Locality</locationnarrative>
67
                <locationplace>
68
                    <place_id>
69
                        <place>
70
                            <coordinates_id>
71
                                <coordinates>
72
                                    <latitude_deg>
73
                                        <_nullIf>
74
                                            <null>0</null>
75
                                            <type>float</type>
76
                                            <value>$Latitude</value>
77
                                        </_nullIf>
78
                                    </latitude_deg>
79
                                    <longitude_deg>
80
                                        <_nullIf>
81
                                            <null>0</null>
82
                                            <type>float</type>
83
                                            <value>$Longitude</value>
84
                                        </_nullIf>
85
                                    </longitude_deg>
86
                                    <verbatimlatitude>$Latitude (DMS)</verbatimlatitude>
87
                                    <verbatimlongitude>$Longitude (DMS)</verbatimlongitude>
88
                                </coordinates>
89
                            </coordinates_id>
90
                            <matched_place_id>
7
            <_simplifyPath>
8
                <next>parent_id</next>
9
                <path>
10
                    <location>
11
                        <authorlocationcode>$Inventory name</authorlocationcode>
12
                        <sourceaccessioncode>$Inventory code</sourceaccessioncode>
13
                        <area_m2><_ha_to_m2><value>$Area</value></_ha_to_m2></area_m2>
14
                        <elevation_m>
15
                            <_alt>
16
                                <1>$Altitude</1>
17
                                <2>
18
                                    <_avg>
19
                                        <max><_rangeEnd><value>$Minimum altitude</value></_rangeEnd></max>
20
                                        <min><_rangeStart><value>$Minimum altitude</value></_rangeStart></min>
21
                                    </_avg>
22
                                </2>
23
                            </_alt>
24
                        </elevation_m>
25
                        <elevationrange_m>
26
                            <_range>
27
                                <from><_rangeStart><value>$Minimum altitude</value></_rangeStart></from>
28
                                <to><_rangeEnd><value>$Minimum altitude</value></_rangeEnd></to>
29
                            </_range>
30
                        </elevationrange_m>
31
                        <landform>$Topographical situation</landform>
32
                        <locationevent>
33
                            <project_id>
34
                                <project>
35
                                    <projectname>$Expedition name</projectname>
36
                                    <sourceaccessioncode>$Expedition number</sourceaccessioncode>
37
                                </project>
38
                            </project_id>
39
                            <commclass>
40
                                <commdetermination>
41
                                    <commconcept_id>
42
                                        <commconcept>
43
                                            <commname_id><commname><commname>$Vegetation type</commname></commname></commname_id>
44
                                            <commdescription>$Locality description</commdescription>
45
                                        </commconcept>
46
                                    </commconcept_id>
47
                                </commdetermination>
48
                            </commclass>
49
                            <obsenddate><_dateRangeEnd><value>$First evaluation</value></_dateRangeEnd></obsenddate>
50
                            <obsstartdate><_dateRangeStart><value>$First evaluation</value></_dateRangeStart></obsstartdate>
51
                            <soilobs>
52
                                <acidity_fraction><_percent_to_fraction><value>$Acidez intercambiable (ISRIC 11&#8211;cmolc/Kg&#8211;0.05)</value></_percent_to_fraction></acidity_fraction>
53
                                <calcium_fraction><_percent_to_fraction><value>$Calcio intercambiable (WSP S-5,10&#8211;cmolc/Kg&#8211;0.016)</value></_percent_to_fraction></calcium_fraction>
54
                                <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>
55
                                <cationexchangecapacity_cmol_kg>$CIC (ISRIC 11&#8211;cmolc/Kg&#8211;0.05)</cationexchangecapacity_cmol_kg>
56
                                <clay_fraction><_percent_to_fraction><value>$Arcilla (DIN 18 123&#8211;%&#8211;1)</value></_percent_to_fraction></clay_fraction>
57
                                <conductivity>$Conductividad electrica (ASPT 6&#8211;&#181;S/cm&#8211; 1 - 10000)</conductivity>
58
                                <magnesium_fraction><_percent_to_fraction><value>$Magnesio intercambiable (WSP S-5,10&#8211;cmolc/Kg&#8211;0.00083)</value></_percent_to_fraction></magnesium_fraction>
59
                                <nitrogen_fraction><_percent_to_fraction><value>$Nitr&#243;geno total (ISRIC 6&#8211;%&#8211;0.0014)</value></_percent_to_fraction></nitrogen_fraction>
60
                                <organic_fraction><_percent_to_fraction><value>$Materia Org&#225;nica (WSP S-9,10&#8211;%&#8211;0.1)</value></_percent_to_fraction></organic_fraction>
61
                                <ph>$pH acuoso (ISRIC 4&#8211;&#8211; 1 - 14)</ph>
62
                                <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>
63
                                <potassium_fraction><_percent_to_fraction><value>$Potasio intercambiable (WSP S-5,10&#8211;cmolc/Kg&#8211;0.0053)</value></_percent_to_fraction></potassium_fraction>
64
                                <sand_fraction><_percent_to_fraction><value>$Arena (DIN 18 123&#8211;%&#8211;2.5)</value></_percent_to_fraction></sand_fraction>
65
                                <silt_fraction><_percent_to_fraction><value>$Limo (DIN 18 123&#8211;%&#8211;1)</value></_percent_to_fraction></silt_fraction>
66
                                <sodium_fraction><_percent_to_fraction><value>$Sodio intercambiable (WSP S-5,10&#8211;cmolc/Kg&#8211;0.00083)</value></_percent_to_fraction></sodium_fraction>
67
                                <texture>$Textural class</texture>
68
                            </soilobs>
69
                        </locationevent>
70
                        <locationnarrative>$Locality</locationnarrative>
71
                        <locationplace>
72
                            <place_id>
91 73
                                <place>
92
                                    <source_id><source><shortname>geoscrub</shortname></source></source_id>
93 74
                                    <coordinates_id>
94 75
                                        <coordinates>
95
                                            <source_id><source><shortname>geoscrub</shortname></source></source_id>
96 76
                                            <latitude_deg>
97 77
                                                <_nullIf>
98 78
                                                    <null>0</null>
......
107 87
                                                    <value>$Longitude</value>
108 88
                                                </_nullIf>
109 89
                                            </longitude_deg>
90
                                            <verbatimlatitude>$Latitude (DMS)</verbatimlatitude>
91
                                            <verbatimlongitude>$Longitude (DMS)</verbatimlongitude>
110 92
                                        </coordinates>
111 93
                                    </coordinates_id>
94
                                    <matched_place_id>
95
                                        <place>
96
                                            <source_id><source><shortname>geoscrub</shortname></source></source_id>
97
                                            <coordinates_id>
98
                                                <coordinates>
99
                                                    <source_id><source><shortname>geoscrub</shortname></source></source_id>
100
                                                    <latitude_deg>
101
                                                        <_nullIf>
102
                                                            <null>0</null>
103
                                                            <type>float</type>
104
                                                            <value>$Latitude</value>
105
                                                        </_nullIf>
106
                                                    </latitude_deg>
107
                                                    <longitude_deg>
108
                                                        <_nullIf>
109
                                                            <null>0</null>
110
                                                            <type>float</type>
111
                                                            <value>$Longitude</value>
112
                                                        </_nullIf>
113
                                                    </longitude_deg>
114
                                                </coordinates>
115
                                            </coordinates_id>
116
                                        </place>
117
                                    </matched_place_id>
112 118
                                </place>
113
                            </matched_place_id>
114
                        </place>
115
                    </place_id>
116
                </locationplace>
117
                <notespublic>$Observaciones</notespublic>
118
                <slopeaspect_deg>
119
                    <_compass>
120
                        <value>
121
                            <_alt>
122
                                <1>$Direction</1>
123
                                <2>$Orientaci&#243;n/exposicion</2>
124
                            </_alt>
125
                        </value>
126
                    </_compass>
127
                </slopeaspect_deg>
128
                <slopegradient_fraction>$Slope</slopegradient_fraction>
129
                <verbatimelevation>$Minimum altitude</verbatimelevation>
130
            </location>
119
                            </place_id>
120
                        </locationplace>
121
                        <notespublic>$Observaciones</notespublic>
122
                        <slopeaspect_deg>
123
                            <_compass>
124
                                <value>
125
                                    <_alt>
126
                                        <1>$Direction</1>
127
                                        <2>$Orientaci&#243;n/exposicion</2>
128
                                    </_alt>
129
                                </value>
130
                            </_compass>
131
                        </slopeaspect_deg>
132
                        <slopegradient_fraction>$Slope</slopegradient_fraction>
133
                        <verbatimelevation>$Minimum altitude</verbatimelevation>
134
                    </location>
135
                </path>
136
            </_simplifyPath>
131 137
        </path>
132
    </_simplifyPath>
138
    </_setDefault>
133 139
</VegBIEN>
134 140
Inserted 28 new rows into database

Also available in: Unified diff