Project

General

Profile

1
Put template:
2
<VegBIEN>
3
    <_setDefault id="-1">
4
        <source_id><source><shortname>Madidi</shortname></source></source_id>
5
        <path>
6
            <_simplifyPath>
7
                <next>parent_id</next>
8
                <path>
9
                    <location>
10
                        <authorlocationcode>$Plot Name</authorlocationcode>
11
                        <sourceaccessioncode>$PlotName</sourceaccessioncode>
12
                        <iscultivated><_locationnarrative_is_cultivated><locationnarrative>$Locality</locationnarrative></_locationnarrative_is_cultivated></iscultivated>
13
                        <locationevent>
14
                            <project_id>
15
                                <project>
16
                                    <projectname>$Expedition Name</projectname>
17
                                    <sourceaccessioncode>$Expedition Number</sourceaccessioncode>
18
                                </project>
19
                            </project_id>
20
                            <authoreventcode>$PlotInventoryName</authoreventcode>
21
                            <commclass><commdetermination><commconcept_id><commconcept><commname_id><commname><commname>$Vegetation Type</commname></commname></commname_id></commconcept></commconcept_id></commdetermination></commclass>
22
                            <soilsample>
23
                                <acidity_fraction><_percent_to_fraction><value>$Interchangeable Acidity</value></_percent_to_fraction></acidity_fraction>
24
                                <calcium_fraction><_percent_to_fraction><value>$Interchangable Calcium</value></_percent_to_fraction></calcium_fraction>
25
                                <carbon_fraction><_percent_to_fraction><value>$Organic Carbon</value></_percent_to_fraction></carbon_fraction>
26
                                <cationexchangecapacity_cmol_kg>$CIC</cationexchangecapacity_cmol_kg>
27
                                <clay_fraction><_percent_to_fraction><value>$Clay</value></_percent_to_fraction></clay_fraction>
28
                                <conductivity>$Electric conductivity</conductivity>
29
                                <magnesium_fraction><_percent_to_fraction><value>$Interchangeable Magnesium</value></_percent_to_fraction></magnesium_fraction>
30
                                <nitrogen_fraction><_percent_to_fraction><value>$Total Nitrogen</value></_percent_to_fraction></nitrogen_fraction>
31
                                <organic_fraction><_percent_to_fraction><value>$Organic material</value></_percent_to_fraction></organic_fraction>
32
                                <ph>$pH disolved</ph>
33
                                <phosphorus_fraction><_percent_to_fraction><value>$Available Phosphor</value></_percent_to_fraction></phosphorus_fraction>
34
                                <potassium_fraction><_percent_to_fraction><value>$Interchangeable Potassium</value></_percent_to_fraction></potassium_fraction>
35
                                <sand_fraction><_percent_to_fraction><value>$Sand</value></_percent_to_fraction></sand_fraction>
36
                                <silt_fraction><_percent_to_fraction><value>$Silt</value></_percent_to_fraction></silt_fraction>
37
                                <sodium_fraction><_percent_to_fraction><value>$Interchangeable Sodium</value></_percent_to_fraction></sodium_fraction>
38
                                <texture>$Textural Class</texture>
39
                            </soilsample>
40
                        </locationevent>
41
                        <locationnarrative>
42
                            <_merge>
43
                                <1>$Locality</1>
44
                                <4>
45
                                    <_alt>
46
                                        <0>$Notes</0>
47
                                        <1>$Notes 2</1>
48
                                    </_alt>
49
                                </4>
50
                            </_merge>
51
                        </locationnarrative>
52
                        <locationplace>
53
                            <place_id>
54
                                <place>
55
                                    <coordinates_id>
56
                                        <coordinates>
57
                                            <latitude_deg>
58
                                                <_nullIf>
59
                                                    <null>0</null>
60
                                                    <type>float</type>
61
                                                    <value>$LatitudeDecDeg</value>
62
                                                </_nullIf>
63
                                            </latitude_deg>
64
                                            <longitude_deg>
65
                                                <_nullIf>
66
                                                    <null>0</null>
67
                                                    <type>float</type>
68
                                                    <value>$LongitudeDecDeg</value>
69
                                                </_nullIf>
70
                                            </longitude_deg>
71
                                        </coordinates>
72
                                    </coordinates_id>
73
                                    <matched_place_id>
74
                                        <place>
75
                                            <source_id><source><shortname>geoscrub</shortname></source></source_id>
76
                                            <coordinates_id>
77
                                                <coordinates>
78
                                                    <source_id><source><shortname>geoscrub</shortname></source></source_id>
79
                                                    <latitude_deg>
80
                                                        <_nullIf>
81
                                                            <null>0</null>
82
                                                            <type>float</type>
83
                                                            <value>$LatitudeDecDeg</value>
84
                                                        </_nullIf>
85
                                                    </latitude_deg>
86
                                                    <longitude_deg>
87
                                                        <_nullIf>
88
                                                            <null>0</null>
89
                                                            <type>float</type>
90
                                                            <value>$LongitudeDecDeg</value>
91
                                                        </_nullIf>
92
                                                    </longitude_deg>
93
                                                </coordinates>
94
                                            </coordinates_id>
95
                                        </place>
96
                                    </matched_place_id>
97
                                </place>
98
                            </place_id>
99
                        </locationplace>
100
                        <slopegradient_fraction>$Slope</slopegradient_fraction>
101
                    </location>
102
                </path>
103
            </_simplifyPath>
104
        </path>
105
    </_setDefault>
106
</VegBIEN>
107
Inserted 28 new rows into database
(6-6/7)