Project

General

Profile

1
Put template:
2
<VegBIEN>
3
    <_setDefault id="-1">
4
        <source_id><source><shortname>SALVIAS.new</shortname></source></source_id>
5
        <path>
6
            <_simplifyPath>
7
                <next>parent_id</next>
8
                <path>
9
                    <location>
10
                        <authorlocationcode>$SiteCode</authorlocationcode>
11
                        <sourceaccessioncode>$PlotID</sourceaccessioncode>
12
                        <accesslevel>
13
                            <_map>
14
                                <1>private</1>
15
                                <2>metadata only</2>
16
                                <3>public</3>
17
                                <value>$AccessCode</value>
18
                            </_map>
19
                        </accesslevel>
20
                        <area_m2><_ha_to_m2><value>$plot_area_ha</value></_ha_to_m2></area_m2>
21
                        <elevation_m>
22
                            <_alt>
23
                                <1>$Elev</1>
24
                                <2>
25
                                    <_avg>
26
                                        <1>$elev_min_m</1>
27
                                        <2>$elev_max_m</2>
28
                                    </_avg>
29
                                </2>
30
                            </_alt>
31
                        </elevation_m>
32
                        <iscultivated>
33
                            <_locationnarrative_is_cultivated>
34
                                <locationnarrative>
35
                                    <_join>
36
                                        <1>$Locality_Description</1>
37
                                        <3>$Habitat</3>
38
                                    </_join>
39
                                </locationnarrative>
40
                            </_locationnarrative_is_cultivated>
41
                        </iscultivated>
42
                        <landform>$topography_desc</landform>
43
                        <locationevent>
44
                            <method_id>
45
                                <method>
46
                                    <name>$PlotMethod</name>
47
                                    <observationmeasure>$lookup_MethodCode_Description</observationmeasure>
48
                                </method>
49
                            </method_id>
50
                            <project_id><project><sourceaccessioncode>$project_id</sourceaccessioncode></project></project_id>
51
                            <commclass>
52
                                <commdetermination>
53
                                    <commconcept_id>
54
                                        <commconcept>
55
                                            <commname_id>
56
                                                <commname>
57
                                                    <commname>
58
                                                        <_alt>
59
                                                            <1>$vegetation_2</1>
60
                                                            <2>$vegetation_1</2>
61
                                                            <3>$life_zone</3>
62
                                                            <4>$life_zone_code</4>
63
                                                        </_alt>
64
                                                    </commname>
65
                                                </commname>
66
                                            </commname_id>
67
                                        </commconcept>
68
                                    </commconcept_id>
69
                                </commdetermination>
70
                            </commclass>
71
                            <obsenddate>$date_finish</obsenddate>
72
                            <obsstartdate>$date_start</obsstartdate>
73
                            <precipitation_m><_mm_to_m><value>$Precip</value></_mm_to_m></precipitation_m>
74
                            <soilsample>
75
                                <acidity_fraction>
76
                                    <_percent_to_fraction>
77
                                        <value>
78
                                            <_map>
79
                                                <<0.05>0</<0.05>
80
                                                <*>*</*>
81
                                                <value>$soil_acidity</value>
82
                                            </_map>
83
                                        </value>
84
                                    </_percent_to_fraction>
85
                                </acidity_fraction>
86
                                <basesaturation_fraction><_percent_to_fraction><value>$soil_base</value></_percent_to_fraction></basesaturation_fraction>
87
                                <calcium_fraction><_percent_to_fraction><value>$soil_Ca</value></_percent_to_fraction></calcium_fraction>
88
                                <carbon_fraction><_percent_to_fraction><value>$soil_C</value></_percent_to_fraction></carbon_fraction>
89
                                <cationexchangecapacity_cmol_kg>$soil_cation_cap</cationexchangecapacity_cmol_kg>
90
                                <clay_fraction><_percent_to_fraction><value>$clay_percent</value></_percent_to_fraction></clay_fraction>
91
                                <conductivity>$soil_conductivity</conductivity>
92
                                <magnesium_fraction><_percent_to_fraction><value>$soil_Mg</value></_percent_to_fraction></magnesium_fraction>
93
                                <nitrogen_fraction><_percent_to_fraction><value>$soil_N</value></_percent_to_fraction></nitrogen_fraction>
94
                                <organic_fraction><_percent_to_fraction><value>$organic_percent</value></_percent_to_fraction></organic_fraction>
95
                                <ph>$pH</ph>
96
                                <phosphorus_fraction>
97
                                    <_percent_to_fraction>
98
                                        <value>
99
                                            <_map>
100
                                                <<1,5>0</<1,5>
101
                                                <*>*</*>
102
                                                <value>$soil_P</value>
103
                                            </_map>
104
                                        </value>
105
                                    </_percent_to_fraction>
106
                                </phosphorus_fraction>
107
                                <potassium_fraction><_percent_to_fraction><value>$soil_K</value></_percent_to_fraction></potassium_fraction>
108
                                <sand_fraction><_percent_to_fraction><value>$sand_percent</value></_percent_to_fraction></sand_fraction>
109
                                <silt_fraction><_percent_to_fraction><value>$silt_percent</value></_percent_to_fraction></silt_fraction>
110
                                <sodium_fraction><_percent_to_fraction><value>$soil_Na</value></_percent_to_fraction></sodium_fraction>
111
                                <texture>$soil_texture</texture>
112
                            </soilsample>
113
                            <temperature_c>$Temp</temperature_c>
114
                        </locationevent>
115
                        <locationnarrative>
116
                            <_merge>
117
                                <1>$Locality_Description</1>
118
                                <3>
119
                                    <_label>
120
                                        <label>habitat</label>
121
                                        <value>$Habitat</value>
122
                                    </_label>
123
                                </3>
124
                                <4>$plot_notes</4>
125
                            </_merge>
126
                        </locationnarrative>
127
                        <locationplace>
128
                            <place_id>
129
                                <place>
130
                                    <coordinates_id>
131
                                        <coordinates>
132
                                            <latitude_deg>
133
                                                <_nullIf>
134
                                                    <null>0</null>
135
                                                    <type>float</type>
136
                                                    <value>$LatDec</value>
137
                                                </_nullIf>
138
                                            </latitude_deg>
139
                                            <longitude_deg>
140
                                                <_nullIf>
141
                                                    <null>0</null>
142
                                                    <type>float</type>
143
                                                    <value>$LongDec</value>
144
                                                </_nullIf>
145
                                            </longitude_deg>
146
                                            <verbatimlatitude>$lat_string</verbatimlatitude>
147
                                            <verbatimlongitude>$long_string</verbatimlongitude>
148
                                        </coordinates>
149
                                    </coordinates_id>
150
                                    <continent>$MajorGeo</continent>
151
                                    <country>$Country</country>
152
                                    <county>$pol2</county>
153
                                    <matched_place_id>
154
                                        <place>
155
                                            <source_id><source><shortname>geoscrub</shortname></source></source_id>
156
                                            <coordinates_id>
157
                                                <coordinates>
158
                                                    <source_id><source><shortname>geoscrub</shortname></source></source_id>
159
                                                    <latitude_deg>
160
                                                        <_nullIf>
161
                                                            <null>0</null>
162
                                                            <type>float</type>
163
                                                            <value>$LatDec</value>
164
                                                        </_nullIf>
165
                                                    </latitude_deg>
166
                                                    <longitude_deg>
167
                                                        <_nullIf>
168
                                                            <null>0</null>
169
                                                            <type>float</type>
170
                                                            <value>$LongDec</value>
171
                                                        </_nullIf>
172
                                                    </longitude_deg>
173
                                                </coordinates>
174
                                            </coordinates_id>
175
                                            <country>$Country</country>
176
                                            <county>$pol2</county>
177
                                            <stateprovince>$PolDiv1</stateprovince>
178
                                        </place>
179
                                    </matched_place_id>
180
                                    <stateprovince>$PolDiv1</stateprovince>
181
                                </place>
182
                            </place_id>
183
                        </locationplace>
184
                        <slopeaspect_deg><_compass><value>$slope_aspect</value></_compass></slopeaspect_deg>
185
                        <slopegradient_fraction>$slope_gradient</slopegradient_fraction>
186
                    </location>
187
                </path>
188
            </_simplifyPath>
189
        </path>
190
    </_setDefault>
191
</VegBIEN>
192
Inserted 28 new rows into database
(7-7/8)