Project

General

Profile

1
Put template:
2
<VegBIEN>
3
    <_setDefault id="-1">
4
        <source_id><source><shortname>SALVIAS-CSV</shortname></source></source_id>
5
        <path>
6
            <_simplifyPath>
7
                <next>parent_id</next>
8
                <path>
9
                    <location>
10
                        <authorlocationcode>$plot_code</authorlocationcode>
11
                        <sourceaccessioncode>$PLOT_ID</sourceaccessioncode>
12
                        <area_m2><_ha_to_m2><value>$plot_area_ha</value></_ha_to_m2></area_m2>
13
                        <elevation_m>
14
                            <_alt>
15
                                <1>$elev_m</1>
16
                                <2>
17
                                    <_avg>
18
                                        <1>$elev_min_m</1>
19
                                        <2>$elev_max_m</2>
20
                                    </_avg>
21
                                </2>
22
                            </_alt>
23
                        </elevation_m>
24
                        <iscultivated><_locationnarrative_is_cultivated><locationnarrative>$locality_description</locationnarrative></_locationnarrative_is_cultivated></iscultivated>
25
                        <locationevent>
26
                            <method_id>
27
                                <method>
28
                                    <name>$plot_methodology</name>
29
                                    <observationmeasure>$observation_type</observationmeasure>
30
                                </method>
31
                            </method_id>
32
                            <project_id><project><projectname>$project</projectname></project></project_id>
33
                            <commclass>
34
                                <commdetermination>
35
                                    <commconcept_id>
36
                                        <commconcept>
37
                                            <commname_id><commname><commname>$holdridge_life_zone</commname></commname></commname_id>
38
                                            <commdescription>$life_zone_code</commdescription>
39
                                        </commconcept>
40
                                    </commconcept_id>
41
                                </commdetermination>
42
                            </commclass>
43
                            <obsenddate>$date_finish</obsenddate>
44
                            <obsstartdate>$date_start</obsstartdate>
45
                            <precipitation_m><_mm_to_m><value>$precip_mm</value></_mm_to_m></precipitation_m>
46
                            <soilsample>
47
                                <acidity_fraction>
48
                                    <_percent_to_fraction>
49
                                        <value>
50
                                            <_map>
51
                                                <<0.05>0</<0.05>
52
                                                <*>*</*>
53
                                                <value>$soil_acidity</value>
54
                                            </_map>
55
                                        </value>
56
                                    </_percent_to_fraction>
57
                                </acidity_fraction>
58
                                <basesaturation_fraction><_percent_to_fraction><value>$soil_base</value></_percent_to_fraction></basesaturation_fraction>
59
                                <calcium_fraction><_percent_to_fraction><value>$soil_Ca</value></_percent_to_fraction></calcium_fraction>
60
                                <carbon_fraction><_percent_to_fraction><value>$soil_C</value></_percent_to_fraction></carbon_fraction>
61
                                <cationexchangecapacity_cmol_kg>$soil_cation_cap</cationexchangecapacity_cmol_kg>
62
                                <clay_fraction><_percent_to_fraction><value>$clay_percent</value></_percent_to_fraction></clay_fraction>
63
                                <conductivity>$soil_conductivity</conductivity>
64
                                <magnesium_fraction><_percent_to_fraction><value>$soil_Mg</value></_percent_to_fraction></magnesium_fraction>
65
                                <nitrogen_fraction><_percent_to_fraction><value>$soil_N</value></_percent_to_fraction></nitrogen_fraction>
66
                                <organic_fraction><_percent_to_fraction><value>$organic_percent</value></_percent_to_fraction></organic_fraction>
67
                                <ph>$pH</ph>
68
                                <phosphorus_fraction>
69
                                    <_percent_to_fraction>
70
                                        <value>
71
                                            <_map>
72
                                                <<0.05>0</<0.05>
73
                                                <*>*</*>
74
                                                <value>$soil_P</value>
75
                                            </_map>
76
                                        </value>
77
                                    </_percent_to_fraction>
78
                                </phosphorus_fraction>
79
                                <potassium_fraction><_percent_to_fraction><value>$soil_K</value></_percent_to_fraction></potassium_fraction>
80
                                <sand_fraction><_percent_to_fraction><value>$sand_percent</value></_percent_to_fraction></sand_fraction>
81
                                <silt_fraction><_percent_to_fraction><value>$silt_percent</value></_percent_to_fraction></silt_fraction>
82
                                <sodium_fraction><_percent_to_fraction><value>$soil_Na</value></_percent_to_fraction></sodium_fraction>
83
                                <texture>$soil_texture</texture>
84
                            </soilsample>
85
                            <temperature_c>$temp_c</temperature_c>
86
                        </locationevent>
87
                        <locationnarrative>$locality_description</locationnarrative>
88
                        <locationplace>
89
                            <place_id>
90
                                <place>
91
                                    <coordinates_id>
92
                                        <coordinates>
93
                                            <latitude_deg>
94
                                                <_nullIf>
95
                                                    <null>0</null>
96
                                                    <type>float</type>
97
                                                    <value>$lat_decimal</value>
98
                                                </_nullIf>
99
                                            </latitude_deg>
100
                                            <longitude_deg>
101
                                                <_nullIf>
102
                                                    <null>0</null>
103
                                                    <type>float</type>
104
                                                    <value>$long_decimal</value>
105
                                                </_nullIf>
106
                                            </longitude_deg>
107
                                        </coordinates>
108
                                    </coordinates_id>
109
                                    <continent>$major_geo</continent>
110
                                    <country>$country</country>
111
                                    <county>$pol2</county>
112
                                    <matched_place_id>
113
                                        <place>
114
                                            <source_id><source><shortname>geoscrub</shortname></source></source_id>
115
                                            <coordinates_id>
116
                                                <coordinates>
117
                                                    <source_id><source><shortname>geoscrub</shortname></source></source_id>
118
                                                    <latitude_deg>
119
                                                        <_nullIf>
120
                                                            <null>0</null>
121
                                                            <type>float</type>
122
                                                            <value>$lat_decimal</value>
123
                                                        </_nullIf>
124
                                                    </latitude_deg>
125
                                                    <longitude_deg>
126
                                                        <_nullIf>
127
                                                            <null>0</null>
128
                                                            <type>float</type>
129
                                                            <value>$long_decimal</value>
130
                                                        </_nullIf>
131
                                                    </longitude_deg>
132
                                                </coordinates>
133
                                            </coordinates_id>
134
                                            <country>$country</country>
135
                                            <county>$pol2</county>
136
                                            <stateprovince>$pol1</stateprovince>
137
                                        </place>
138
                                    </matched_place_id>
139
                                    <stateprovince>$pol1</stateprovince>
140
                                </place>
141
                            </place_id>
142
                        </locationplace>
143
                        <slopeaspect_deg><_compass><value>$slope_aspect</value></_compass></slopeaspect_deg>
144
                        <slopegradient_fraction>$slope_gradient</slopegradient_fraction>
145
                    </location>
146
                </path>
147
            </_simplifyPath>
148
        </path>
149
    </_setDefault>
150
</VegBIEN>
151
Inserted 18 new rows into database
(6-6/7)