Project

General

Profile

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