Project

General

Profile

1 3641 aaronmk
Put template:
2
<VegBIEN>
3 4621 aaronmk
    <_simplifyPath id="-1">
4
        <next>parent_id</next>
5
        <path>
6
            <location>
7
                <authorlocationcode>$plot_code</authorlocationcode>
8
                <sourceaccessioncode>$PLOT_ID</sourceaccessioncode>
9 4767 aaronmk
                <area_m2><_ha_to_m2><value>$plot_area_ha</value></_ha_to_m2></area_m2>
10 4753 aaronmk
                <elevation_m>
11 4621 aaronmk
                    <_alt>
12 4809 aaronmk
                        <1>$elev_m</1>
13 4621 aaronmk
                        <2>
14
                            <_avg>
15
                                <max>
16
                                    <_units>
17
                                        <default>m</default>
18
                                        <to>m</to>
19
                                        <to></to>
20
                                        <value>
21
                                            <_replace>
22
                                                <\bca\.?></\bca\.?>
23
                                                <value>$elev_max_m</value>
24
                                            </_replace>
25
                                        </value>
26
                                    </_units>
27
                                </max>
28
                                <min>
29
                                    <_units>
30
                                        <default>m</default>
31
                                        <to>m</to>
32
                                        <to></to>
33
                                        <value>
34
                                            <_rangeStart>
35
                                                <value>
36
                                                    <_replace>
37
                                                        <\bca\.?></\bca\.?>
38
                                                        <value>$elev_min_m</value>
39
                                                    </_replace>
40
                                                </value>
41
                                            </_rangeStart>
42
                                        </value>
43
                                    </_units>
44
                                </min>
45
                            </_avg>
46
                        </2>
47
                    </_alt>
48 4753 aaronmk
                </elevation_m>
49
                <elevationrange_m>
50 4621 aaronmk
                    <_range>
51
                        <from>
52 3782 aaronmk
                            <_units>
53
                                <default>m</default>
54
                                <to>m</to>
55
                                <to></to>
56 3984 aaronmk
                                <value>
57
                                    <_rangeStart>
58
                                        <value>
59
                                            <_replace>
60
                                                <\bca\.?></\bca\.?>
61
                                                <value>$elev_min_m</value>
62
                                            </_replace>
63
                                        </value>
64
                                    </_rangeStart>
65
                                </value>
66 3782 aaronmk
                            </_units>
67 4621 aaronmk
                        </from>
68
                        <to>
69
                            <_units>
70
                                <default>m</default>
71
                                <to>m</to>
72
                                <to></to>
73 3984 aaronmk
                                <value>
74 4621 aaronmk
                                    <_alt>
75
                                        <1>
76 3985 aaronmk
                                            <_replace>
77
                                                <\bca\.?></\bca\.?>
78 4621 aaronmk
                                                <value>$elev_max_m</value>
79 3985 aaronmk
                                            </_replace>
80 4621 aaronmk
                                        </1>
81
                                        <2>
82
                                            <_rangeEnd>
83
                                                <value>
84
                                                    <_replace>
85
                                                        <\bca\.?></\bca\.?>
86
                                                        <value>$elev_min_m</value>
87
                                                    </_replace>
88
                                                </value>
89
                                            </_rangeEnd>
90
                                        </2>
91
                                    </_alt>
92
                                </value>
93
                            </_units>
94
                        </to>
95
                    </_range>
96 4753 aaronmk
                </elevationrange_m>
97 4726 aaronmk
                <locationcoords>
98 4753 aaronmk
                    <latitude_deg>
99 4621 aaronmk
                        <_nullIf>
100
                            <null>0</null>
101
                            <type>float</type>
102
                            <value>$lat_decimal</value>
103
                        </_nullIf>
104 4753 aaronmk
                    </latitude_deg>
105
                    <longitude_deg>
106 4621 aaronmk
                        <_nullIf>
107
                            <null>0</null>
108
                            <type>float</type>
109
                            <value>$long_decimal</value>
110
                        </_nullIf>
111 4753 aaronmk
                    </longitude_deg>
112 4726 aaronmk
                </locationcoords>
113 4621 aaronmk
                <locationevent>
114
                    <method_id><method><name>$plot_methodology</name></method></method_id>
115
                    <project_id><project><projectname>$project</projectname></project></project_id>
116
                    <commclass>
117
                        <commdetermination>
118
                            <commconcept_id>
119
                                <commconcept>
120
                                    <commname_id><commname><commname>$holdridge_life_zone</commname></commname></commname_id>
121
                                    <commdescription>$life_zone_code</commdescription>
122
                                </commconcept>
123
                            </commconcept_id>
124
                        </commdetermination>
125
                    </commclass>
126
                    <obsenddate><_date><date>$date_finish</date></_date></obsenddate>
127
                    <obsstartdate><_date><date>$date_start</date></_date></obsstartdate>
128 4753 aaronmk
                    <precipitation_m>$precip_mm</precipitation_m>
129 4621 aaronmk
                    <soilobs>
130 4786 aaronmk
                        <acidity_fraction>
131 4621 aaronmk
                            <_units>
132
                                <default>%</default>
133
                                <to></to>
134
                                <value>
135
                                    <_map>
136
                                        <<0.05>0</<0.05>
137
                                        <*>*</*>
138
                                        <value>$soil_acidity</value>
139
                                    </_map>
140
                                </value>
141
                            </_units>
142 4786 aaronmk
                        </acidity_fraction>
143
                        <basesaturation_fraction>
144 4621 aaronmk
                            <_units>
145
                                <default>%</default>
146
                                <to></to>
147
                                <value>$soil_base</value>
148
                            </_units>
149 4786 aaronmk
                        </basesaturation_fraction>
150
                        <calcium_fraction>
151 4621 aaronmk
                            <_units>
152
                                <default>%</default>
153
                                <to></to>
154
                                <value>$soil_Ca</value>
155
                            </_units>
156 4786 aaronmk
                        </calcium_fraction>
157
                        <carbon_fraction>
158 4621 aaronmk
                            <_units>
159
                                <default>%</default>
160
                                <to></to>
161
                                <value>$soil_C</value>
162
                            </_units>
163 4786 aaronmk
                        </carbon_fraction>
164 4754 aaronmk
                        <cationexchangecapacity_cmol_kg>$soil_cation_cap</cationexchangecapacity_cmol_kg>
165 4786 aaronmk
                        <clay_fraction>
166 4621 aaronmk
                            <_units>
167
                                <default>%</default>
168
                                <to></to>
169
                                <value>$clay_percent</value>
170
                            </_units>
171 4786 aaronmk
                        </clay_fraction>
172 4621 aaronmk
                        <conductivity>$soil_conductivity</conductivity>
173 4786 aaronmk
                        <magnesium_fraction>
174 4621 aaronmk
                            <_units>
175
                                <default>%</default>
176
                                <to></to>
177
                                <value>$soil_Mg</value>
178
                            </_units>
179 4786 aaronmk
                        </magnesium_fraction>
180
                        <nitrogen_fraction>
181 4621 aaronmk
                            <_units>
182
                                <default>%</default>
183
                                <to></to>
184
                                <value>$soil_N</value>
185
                            </_units>
186 4786 aaronmk
                        </nitrogen_fraction>
187
                        <organic_fraction>
188 4621 aaronmk
                            <_units>
189
                                <default>%</default>
190
                                <to></to>
191
                                <value>$organic_percent</value>
192
                            </_units>
193 4786 aaronmk
                        </organic_fraction>
194 4621 aaronmk
                        <ph>$pH</ph>
195 4786 aaronmk
                        <phosphorus_fraction>
196 4621 aaronmk
                            <_units>
197
                                <default>%</default>
198
                                <to></to>
199
                                <value>
200
                                    <_map>
201
                                        <<1,5>0</<1,5>
202
                                        <*>*</*>
203
                                        <value>$soil_P</value>
204
                                    </_map>
205
                                </value>
206
                            </_units>
207 4786 aaronmk
                        </phosphorus_fraction>
208
                        <potassium_fraction>
209 4621 aaronmk
                            <_units>
210
                                <default>%</default>
211
                                <to></to>
212
                                <value>$soil_K</value>
213
                            </_units>
214 4786 aaronmk
                        </potassium_fraction>
215
                        <sand_fraction>
216 4621 aaronmk
                            <_units>
217
                                <default>%</default>
218
                                <to></to>
219
                                <value>$sand_percent</value>
220
                            </_units>
221 4786 aaronmk
                        </sand_fraction>
222
                        <silt_fraction>
223 4621 aaronmk
                            <_units>
224
                                <default>%</default>
225
                                <to></to>
226
                                <value>$silt_percent</value>
227
                            </_units>
228 4786 aaronmk
                        </silt_fraction>
229
                        <sodium_fraction>
230 4621 aaronmk
                            <_units>
231
                                <default>%</default>
232
                                <to></to>
233
                                <value>$soil_Na</value>
234
                            </_units>
235 4786 aaronmk
                        </sodium_fraction>
236 4621 aaronmk
                        <texture>$soil_texture</texture>
237
                    </soilobs>
238 4753 aaronmk
                    <temperature_c>$temp_c</temperature_c>
239 4621 aaronmk
                </locationevent>
240
                <locationnarrative>$locality_description</locationnarrative>
241 4726 aaronmk
                <locationplace>
242 4727 aaronmk
                    <placepath_id>
243
                        <placepath>
244
                            <continent>$major_geo</continent>
245
                            <country>$country</country>
246
                            <county>$pol2</county>
247
                            <stateprovince>$pol1</stateprovince>
248
                        </placepath>
249
                    </placepath_id>
250 4726 aaronmk
                </locationplace>
251 4753 aaronmk
                <slopeaspect_deg><_compass><value>$slope_aspect</value></_compass></slopeaspect_deg>
252 4786 aaronmk
                <slopegradient_fraction>$slope_gradient</slopegradient_fraction>
253 4621 aaronmk
            </location>
254
        </path>
255
    </_simplifyPath>
256 3641 aaronmk
</VegBIEN>
257 4727 aaronmk
Inserted 16 new rows into database