Project

General

Profile

1
Put template:
2
<VegBIEN>
3
    <_simplifyPath id="-1">
4
        <next>parent_id</next>
5
        <path>
6
            <location>
7
                <locationevent>
8
                    <taxonoccurrence>
9
                        <aggregateoccurrence>
10
                            <plantobservation>
11
                                <sourceaccessioncode>$PlotObsID</sourceaccessioncode>
12
                                <stemcount>$NoInd</stemcount>
13
                                <stemobservation>
14
                                    <basaldiameter_m>$basal_diam</basaldiameter_m>
15
                                    <definedvalue fkey="tablerecord_id">
16
                                        <userdefined_id>
17
                                            <userdefined>
18
                                                <tablename>stemobservation</tablename>
19
                                                <userdefinedname>canopyForm</userdefinedname>
20
                                            </userdefined>
21
                                        </userdefined_id>
22
                                        <definedvalue>$stem_canopy_form</definedvalue>
23
                                    </definedvalue>
24
                                    <definedvalue fkey="tablerecord_id">
25
                                        <userdefined_id>
26
                                            <userdefined>
27
                                                <tablename>stemobservation</tablename>
28
                                                <userdefinedname>canopyPosition</userdefinedname>
29
                                            </userdefined>
30
                                        </userdefined_id>
31
                                        <definedvalue>$stem_canopy_position</definedvalue>
32
                                    </definedvalue>
33
                                    <definedvalue fkey="tablerecord_id">
34
                                        <userdefined_id>
35
                                            <userdefined>
36
                                                <tablename>stemobservation</tablename>
37
                                                <userdefinedname>gentryDiameter</userdefinedname>
38
                                            </userdefined>
39
                                        </userdefined_id>
40
                                        <definedvalue>$gentry_dbh</definedvalue>
41
                                    </definedvalue>
42
                                    <definedvalue fkey="tablerecord_id">
43
                                        <userdefined_id>
44
                                            <userdefined>
45
                                                <tablename>stemobservation</tablename>
46
                                                <userdefinedname>lianaInfestation</userdefinedname>
47
                                            </userdefined>
48
                                        </userdefined_id>
49
                                        <definedvalue>$stem_liana_infestation</definedvalue>
50
                                    </definedvalue>
51
                                    <definedvalue fkey="tablerecord_id">
52
                                        <userdefined_id>
53
                                            <userdefined>
54
                                                <tablename>stemobservation</tablename>
55
                                                <userdefinedname>notes</userdefinedname>
56
                                            </userdefined>
57
                                        </userdefined_id>
58
                                        <definedvalue>$stem_notes</definedvalue>
59
                                    </definedvalue>
60
                                    <diameterbreastheight_m><_cm_to_m><value>$stem_dbh</value></_cm_to_m></diameterbreastheight_m>
61
                                    <height_m>$stem_height_m</height_m>
62
                                    <heightfirstbranch_m>$stem_height_first_branch_m</heightfirstbranch_m>
63
                                    <sourceaccessioncode>$stem_id</sourceaccessioncode>
64
                                    <tag>
65
                                        <_alt>
66
                                            <1>$stem_tag2</1>
67
                                            <2>$stem_tag1</2>
68
                                        </_alt>
69
                                    </tag>
70
                                </stemobservation>
71
                            </plantobservation>
72
                        </aggregateoccurrence>
73
                        <sourceaccessioncode>$PlotObsID</sourceaccessioncode>
74
                    </taxonoccurrence>
75
                </locationevent>
76
            </location>
77
        </path>
78
    </_simplifyPath>
79
</VegBIEN>
80
Inserted 24 new rows into database
(6-6/7)