Project

General

Profile

« Previous | Next » 

Revision 6403

mappings/VegCore-VegBIEN.csv: Set the source_id col_default to the datasource name using the new _setDefault() built-in function and _env()

View differences:

inputs/CTFS/Plot/test.xml.ref
1 1
Put template:
2 2
<VegBIEN>
3
    <_simplifyPath id="-1">
4
        <next>parent_id</next>
3
    <_setDefault id="-1">
4
        <col>source_id</col>
5
        <value><source><shortname>CTFS</shortname></source></value>
5 6
        <path>
6
            <location>
7
                <authorlocationcode>$PlotName</authorlocationcode>
8
                <sourceaccessioncode>$PlotID</sourceaccessioncode>
9
                <area_m2><_ha_to_m2><value>$SizeOfSite</value></_ha_to_m2></area_m2>
10
                <elevation_m>$Elevation</elevation_m>
11
                <locationnarrative>
12
                    <_alt>
13
                        <0>$DescriptionOfSite</0>
14
                        <1>$LocationName</1>
15
                    </_alt>
16
                </locationnarrative>
17
                <locationplace>
18
                    <place_id>
19
                        <place>
20
                            <coordinates_id>
21
                                <coordinates>
22
                                    <footprintgeometry_dwc>$ShapeOfSite</footprintgeometry_dwc>
23
                                    <latitude_deg>
24
                                        <_nullIf>
25
                                            <null>0</null>
26
                                            <type>float</type>
27
                                            <value>$Latitude</value>
28
                                        </_nullIf>
29
                                    </latitude_deg>
30
                                    <longitude_deg>
31
                                        <_nullIf>
32
                                            <null>0</null>
33
                                            <type>float</type>
34
                                            <value>$Longitude</value>
35
                                        </_nullIf>
36
                                    </longitude_deg>
37
                                </coordinates>
38
                            </coordinates_id>
39
                            <country>$CountryName</country>
40
                            <matched_place_id>
7
            <_simplifyPath>
8
                <next>parent_id</next>
9
                <path>
10
                    <location>
11
                        <authorlocationcode>$PlotName</authorlocationcode>
12
                        <sourceaccessioncode>$PlotID</sourceaccessioncode>
13
                        <area_m2><_ha_to_m2><value>$SizeOfSite</value></_ha_to_m2></area_m2>
14
                        <elevation_m>$Elevation</elevation_m>
15
                        <locationnarrative>
16
                            <_alt>
17
                                <0>$DescriptionOfSite</0>
18
                                <1>$LocationName</1>
19
                            </_alt>
20
                        </locationnarrative>
21
                        <locationplace>
22
                            <place_id>
41 23
                                <place>
42
                                    <source_id><source><shortname>geoscrub</shortname></source></source_id>
43 24
                                    <coordinates_id>
44 25
                                        <coordinates>
45
                                            <source_id><source><shortname>geoscrub</shortname></source></source_id>
26
                                            <footprintgeometry_dwc>$ShapeOfSite</footprintgeometry_dwc>
46 27
                                            <latitude_deg>
47 28
                                                <_nullIf>
48 29
                                                    <null>0</null>
......
60 41
                                        </coordinates>
61 42
                                    </coordinates_id>
62 43
                                    <country>$CountryName</country>
44
                                    <matched_place_id>
45
                                        <place>
46
                                            <source_id><source><shortname>geoscrub</shortname></source></source_id>
47
                                            <coordinates_id>
48
                                                <coordinates>
49
                                                    <source_id><source><shortname>geoscrub</shortname></source></source_id>
50
                                                    <latitude_deg>
51
                                                        <_nullIf>
52
                                                            <null>0</null>
53
                                                            <type>float</type>
54
                                                            <value>$Latitude</value>
55
                                                        </_nullIf>
56
                                                    </latitude_deg>
57
                                                    <longitude_deg>
58
                                                        <_nullIf>
59
                                                            <null>0</null>
60
                                                            <type>float</type>
61
                                                            <value>$Longitude</value>
62
                                                        </_nullIf>
63
                                                    </longitude_deg>
64
                                                </coordinates>
65
                                            </coordinates_id>
66
                                            <country>$CountryName</country>
67
                                        </place>
68
                                    </matched_place_id>
63 69
                                </place>
64
                            </matched_place_id>
65
                        </place>
66
                    </place_id>
67
                </locationplace>
68
            </location>
70
                            </place_id>
71
                        </locationplace>
72
                    </location>
73
                </path>
74
            </_simplifyPath>
69 75
        </path>
70
    </_simplifyPath>
76
    </_setDefault>
71 77
</VegBIEN>
72 78
Inserted 14 new rows into database
inputs/SALVIAS/projects/VegBIEN.csv
1
SALVIAS,VegBIEN:/_simplifyPath:[next=parent_id]/path,Comments
1
SALVIAS,"VegBIEN:/_setDefault:[col=source_id,value/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path",Comments
2 2
project_name,/location/locationevent/*_id/project/projectname,
3 3
project_id,/location/locationevent/*_id/project/sourceaccessioncode,
4 4
allow_download_all,,** No join mapping for *allow_download_all ** 
inputs/SALVIAS/stems/test.xml.ref
1 1
Put template:
2 2
<VegBIEN>
3
    <_simplifyPath id="-1">
4
        <next>parent_id</next>
3
    <_setDefault id="-1">
4
        <col>source_id</col>
5
        <value><source><shortname>SALVIAS</shortname></source></value>
5 6
        <path>
6
            <location>
7
                <locationevent>
8
                    <taxonoccurrence>
9
                        <aggregateoccurrence>
10
                            <plantobservation>
7
            <_simplifyPath>
8
                <next>parent_id</next>
9
                <path>
10
                    <location>
11
                        <locationevent>
12
                            <taxonoccurrence>
13
                                <aggregateoccurrence>
14
                                    <plantobservation>
15
                                        <sourceaccessioncode>$PlotObsID</sourceaccessioncode>
16
                                        <stemcount>$NoInd</stemcount>
17
                                        <stemobservation>
18
                                            <basaldiameter_m>$basal_diam</basaldiameter_m>
19
                                            <definedvalue fkey="tablerecord_id">
20
                                                <userdefined_id>
21
                                                    <userdefined>
22
                                                        <tablename>stemobservation</tablename>
23
                                                        <userdefinedname>canopyForm</userdefinedname>
24
                                                    </userdefined>
25
                                                </userdefined_id>
26
                                                <definedvalue>$stem_canopy_form</definedvalue>
27
                                            </definedvalue>
28
                                            <definedvalue fkey="tablerecord_id">
29
                                                <userdefined_id>
30
                                                    <userdefined>
31
                                                        <tablename>stemobservation</tablename>
32
                                                        <userdefinedname>canopyPosition</userdefinedname>
33
                                                    </userdefined>
34
                                                </userdefined_id>
35
                                                <definedvalue>$stem_canopy_position</definedvalue>
36
                                            </definedvalue>
37
                                            <definedvalue fkey="tablerecord_id">
38
                                                <userdefined_id>
39
                                                    <userdefined>
40
                                                        <tablename>stemobservation</tablename>
41
                                                        <userdefinedname>gentryDiameter</userdefinedname>
42
                                                    </userdefined>
43
                                                </userdefined_id>
44
                                                <definedvalue>$gentry_dbh</definedvalue>
45
                                            </definedvalue>
46
                                            <definedvalue fkey="tablerecord_id">
47
                                                <userdefined_id>
48
                                                    <userdefined>
49
                                                        <tablename>stemobservation</tablename>
50
                                                        <userdefinedname>lianaInfestation</userdefinedname>
51
                                                    </userdefined>
52
                                                </userdefined_id>
53
                                                <definedvalue>$stem_liana_infestation</definedvalue>
54
                                            </definedvalue>
55
                                            <definedvalue fkey="tablerecord_id">
56
                                                <userdefined_id>
57
                                                    <userdefined>
58
                                                        <tablename>stemobservation</tablename>
59
                                                        <userdefinedname>notes</userdefinedname>
60
                                                    </userdefined>
61
                                                </userdefined_id>
62
                                                <definedvalue>$stem_notes</definedvalue>
63
                                            </definedvalue>
64
                                            <diameterbreastheight_m><_cm_to_m><value>$stem_dbh</value></_cm_to_m></diameterbreastheight_m>
65
                                            <height_m>$stem_height_m</height_m>
66
                                            <heightfirstbranch_m>$stem_height_first_branch_m</heightfirstbranch_m>
67
                                            <sourceaccessioncode>$stem_id</sourceaccessioncode>
68
                                            <tag>
69
                                                <_alt>
70
                                                    <1>$stem_tag2</1>
71
                                                    <2>$stem_tag1</2>
72
                                                </_alt>
73
                                            </tag>
74
                                        </stemobservation>
75
                                    </plantobservation>
76
                                </aggregateoccurrence>
11 77
                                <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>
78
                            </taxonoccurrence>
79
                        </locationevent>
80
                    </location>
81
                </path>
82
            </_simplifyPath>
77 83
        </path>
78
    </_simplifyPath>
84
    </_setDefault>
79 85
</VegBIEN>
80 86
Inserted 24 new rows into database
inputs/SALVIAS/plotMetadata_/VegBIEN.csv
1
SALVIAS,VegBIEN:/_simplifyPath:[next=parent_id]/path,Comments
1
SALVIAS,"VegBIEN:/_setDefault:[col=source_id,value/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path",Comments
2 2
SiteCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/1",Brad: plotCode is as-assigned by data provider; guranteed to be unique only within dataset (=project)
3 3
PlotID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/2/_if[@name=""if locationID""]/cond/_exists","Brad: This is artificial internal database ID; a unique identifier within SALVIAS DB to each plot, within the table plotMetadata."
4 4
PlotID,"/location/_if[@name=""if subplot""]/else/sourceaccessioncode/_if[@name=""if geovalidation""]/else","Brad: This is artificial internal database ID; a unique identifier within SALVIAS DB to each plot, within the table plotMetadata."
inputs/CTFS/PlotObservation/VegBIEN.csv
1
CTFS,VegBIEN:/_simplifyPath:[next=parent_id]/path,Comments
1
CTFS,"VegBIEN:/_setDefault:[col=source_id,value/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path",Comments
2 2
PlotID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/2/_if[@name=""if locationID""]/cond/_exists",
3 3
PlotCensusNumber,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/2/_if[@name=""if locationID""]/else",
4 4
PlotID,"/location/_if[@name=""if subplot""]/else/sourceaccessioncode/_if[@name=""if geovalidation""]/else",
inputs/CTFS/Source/VegBIEN.csv
1
CTFS,VegBIEN:/_simplifyPath:[next=parent_id]/path,Comments
1
CTFS,"VegBIEN:/_setDefault:[col=source_id,value/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path",Comments
2 2
:primary database,/source/sourcetype,
inputs/CTFS/TaxonOccurrence/VegBIEN.csv
1
CTFS,VegBIEN:/_simplifyPath:[next=parent_id]/path,Comments
1
CTFS,"VegBIEN:/_setDefault:[col=source_id,value/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path",Comments
2 2
PlotID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/2/_if[@name=""if locationID""]/cond/_exists",
3 3
PlotID,"/location/_if[@name=""if subplot""]/else/sourceaccessioncode/_if[@name=""if geovalidation""]/else",
4 4
PlotID,"/location/_if[@name=""if subplot""]/then/parent_id/location/sourceaccessioncode",
inputs/CTFS/SubplotObservation/VegBIEN.csv
1
CTFS,VegBIEN:/_simplifyPath:[next=parent_id]/path,Comments
1
CTFS,"VegBIEN:/_setDefault:[col=source_id,value/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path",Comments
2 2
QuadratID,"/location/_if[@name=""if subplot""]/cond/_exists",Not globally unique; unique only within Site
3 3
PlotID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/2/_if[@name=""if locationID""]/cond/_exists",
4 4
PlotID,"/location/_if[@name=""if subplot""]/else/sourceaccessioncode/_if[@name=""if geovalidation""]/else",
inputs/CTFS/Plot/VegBIEN.csv
1
CTFS,VegBIEN:/_simplifyPath:[next=parent_id]/path,Comments
1
CTFS,"VegBIEN:/_setDefault:[col=source_id,value/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path",Comments
2 2
PlotName,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/1",
3 3
PlotID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/2/_if[@name=""if locationID""]/cond/_exists",
4 4
PlotID,"/location/_if[@name=""if subplot""]/else/sourceaccessioncode/_if[@name=""if geovalidation""]/else",
inputs/SALVIAS/Source/test.xml.ref
1 1
Put template:
2 2
<VegBIEN>
3
    <_simplifyPath id="-1">
4
        <next>parent_id</next>
5
        <path><source><sourcetype>aggregator</sourcetype></source></path>
6
    </_simplifyPath>
3
    <_setDefault id="-1">
4
        <col>source_id</col>
5
        <value><source><shortname>SALVIAS</shortname></source></value>
6
        <path>
7
            <_simplifyPath>
8
                <next>parent_id</next>
9
                <path><source><sourcetype>aggregator</sourcetype></source></path>
10
            </_simplifyPath>
11
        </path>
12
    </_setDefault>
7 13
</VegBIEN>
8
Inserted 1 new rows into database
14
Inserted 0 new rows into database
inputs/SALVIAS/stems/VegBIEN.csv
1
SALVIAS,VegBIEN:/_simplifyPath:[next=parent_id]/path,Comments
1
SALVIAS,"VegBIEN:/_setDefault:[col=source_id,value/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path",Comments
2 2
PlotObsID,"/location/iscultivated/_if[@name=""if TaxonOccurrence""]/cond/_exists",
3 3
PlotObsID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/sourceaccessioncode,
4 4
NoInd,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemcount,
inputs/SALVIAS/plotObservations/test.xml.ref
1 1
Put template:
2 2
<VegBIEN>
3
    <_simplifyPath id="-1">
4
        <next>parent_id</next>
3
    <_setDefault id="-1">
4
        <col>source_id</col>
5
        <value><source><shortname>SALVIAS</shortname></source></value>
5 6
        <path>
6
            <location>
7
                <parent_id>
7
            <_simplifyPath>
8
                <next>parent_id</next>
9
                <path>
8 10
                    <location>
9
                        <authorlocationcode>$PlotCode</authorlocationcode>
10
                        <sourceaccessioncode>$PlotID</sourceaccessioncode>
11
                    </location>
12
                </parent_id>
13
                <authorlocationcode>$Line</authorlocationcode>
14
                <locationevent>
15
                    <parent_id>
11
                        <parent_id>
12
                            <location>
13
                                <authorlocationcode>$PlotCode</authorlocationcode>
14
                                <sourceaccessioncode>$PlotID</sourceaccessioncode>
15
                            </location>
16
                        </parent_id>
17
                        <authorlocationcode>$Line</authorlocationcode>
16 18
                        <locationevent>
17
                            <location_id>
18
                                <location>
19
                                    <authorlocationcode>
20
                                        <_if name="if subplot">
21
                                            <cond>$Line</cond>
22
                                            <then>$PlotCode</then>
23
                                        </_if>
24
                                    </authorlocationcode>
25
                                    <sourceaccessioncode>
26
                                        <_if name="if subplot">
27
                                            <cond>$Line</cond>
28
                                            <then>$PlotID</then>
29
                                        </_if>
30
                                    </sourceaccessioncode>
31
                                </location>
32
                            </location_id>
19
                            <parent_id>
20
                                <locationevent>
21
                                    <location_id>
22
                                        <location>
23
                                            <authorlocationcode>
24
                                                <_if name="if subplot">
25
                                                    <cond>$Line</cond>
26
                                                    <then>$PlotCode</then>
27
                                                </_if>
28
                                            </authorlocationcode>
29
                                            <sourceaccessioncode>
30
                                                <_if name="if subplot">
31
                                                    <cond>$Line</cond>
32
                                                    <then>$PlotID</then>
33
                                                </_if>
34
                                            </sourceaccessioncode>
35
                                        </location>
36
                                    </location_id>
37
                                    <obsenddate><_dateRangeEnd><value>$census_date</value></_dateRangeEnd></obsenddate>
38
                                    <obsstartdate><_dateRangeStart><value>$census_date</value></_dateRangeStart></obsstartdate>
39
                                </locationevent>
40
                            </parent_id>
33 41
                            <obsenddate><_dateRangeEnd><value>$census_date</value></_dateRangeEnd></obsenddate>
34 42
                            <obsstartdate><_dateRangeStart><value>$census_date</value></_dateRangeStart></obsstartdate>
35
                        </locationevent>
36
                    </parent_id>
37
                    <obsenddate><_dateRangeEnd><value>$census_date</value></_dateRangeEnd></obsenddate>
38
                    <obsstartdate><_dateRangeStart><value>$census_date</value></_dateRangeStart></obsstartdate>
39
                    <taxonoccurrence>
40
                        <aggregateoccurrence>
41
                            <count>$NoInd</count>
42
                            <cover_fraction><_percent_to_fraction><value>$cover_percent</value></_percent_to_fraction></cover_fraction>
43
                            <definedvalue fkey="tablerecord_id">
44
                                <userdefined_id>
45
                                    <userdefined>
46
                                        <tablename>aggregateoccurrence</tablename>
47
                                        <userdefinedname>censusNo</userdefinedname>
48
                                    </userdefined>
49
                                </userdefined_id>
50
                                <definedvalue>$census_no</definedvalue>
51
                            </definedvalue>
52
                            <linecover_m><_cm_to_m><value>$intercept_cm</value></_cm_to_m></linecover_m>
53
                            <notes>$Notes</notes>
54
                            <plantobservation>
55
                                <collectionnumber>$Ind</collectionnumber>
56
                                <sourceaccessioncode>$PlotObsID</sourceaccessioncode>
57
                                <specimenreplicate>
58
                                    <catalognumber_dwc>
59
                                        <_if name="if indirect voucher">
60
                                            <cond>
61
                                                <_eq>
62
                                                    <right>indirect</right>
63
                                                    <left>$DetType</left>
64
                                                </_eq>
65
                                            </cond>
66
                                            <else>
67
                                                <_alt>
68
                                                    <1>$coll_number</1>
69
                                                    <2>$SourceVoucher</2>
70
                                                </_alt>
71
                                            </else>
72
                                        </_if>
73
                                    </catalognumber_dwc>
74
                                </specimenreplicate>
75
                                <stemobservation>
43
                            <taxonoccurrence>
44
                                <aggregateoccurrence>
45
                                    <count>$NoInd</count>
46
                                    <cover_fraction><_percent_to_fraction><value>$cover_percent</value></_percent_to_fraction></cover_fraction>
76 47
                                    <definedvalue fkey="tablerecord_id">
77 48
                                        <userdefined_id>
78 49
                                            <userdefined>
79
                                                <tablename>stemobservation</tablename>
80
                                                <userdefinedname>canopyForm</userdefinedname>
50
                                                <tablename>aggregateoccurrence</tablename>
51
                                                <userdefinedname>censusNo</userdefinedname>
81 52
                                            </userdefined>
82 53
                                        </userdefined_id>
83
                                        <definedvalue>$canopy_form</definedvalue>
54
                                        <definedvalue>$census_no</definedvalue>
84 55
                                    </definedvalue>
85
                                    <definedvalue fkey="tablerecord_id">
86
                                        <userdefined_id>
87
                                            <userdefined>
88
                                                <tablename>stemobservation</tablename>
89
                                                <userdefinedname>canopyPosition</userdefinedname>
90
                                            </userdefined>
91
                                        </userdefined_id>
92
                                        <definedvalue>$canopy_position</definedvalue>
93
                                    </definedvalue>
94
                                    <definedvalue fkey="tablerecord_id">
95
                                        <userdefined_id>
96
                                            <userdefined>
97
                                                <tablename>stemobservation</tablename>
98
                                                <userdefinedname>lianaInfestation</userdefinedname>
99
                                            </userdefined>
100
                                        </userdefined_id>
101
                                        <definedvalue>$liana_infestation</definedvalue>
102
                                    </definedvalue>
103
                                    <diameterbreastheight_m><_cm_to_m><value>$temp_dbh</value></_cm_to_m></diameterbreastheight_m>
104
                                    <height_m>$height_m</height_m>
105
                                    <heightfirstbranch_m>$ht_first_branch_m</heightfirstbranch_m>
106
                                    <tag>
107
                                        <_alt>
108
                                            <1>$tag2</1>
109
                                            <2>$tag1</2>
110
                                        </_alt>
111
                                    </tag>
112
                                    <xposition_m>$x_position</xposition_m>
113
                                    <yposition_m>$y_position</yposition_m>
114
                                </stemobservation>
115
                            </plantobservation>
116
                        </aggregateoccurrence>
117
                        <authortaxoncode>$Ind</authortaxoncode>
118
                        <collector_id>
119
                            <party>
120
                                <fullname>
121
                                    <_join_words>
122
                                        <1>$coll_firstname</1>
123
                                        <2>$coll_lastname</2>
124
                                    </_join_words>
125
                                </fullname>
126
                            </party>
127
                        </collector_id>
128
                        <growthform>
129
                            <_map>
130
                                <T>tree</T>
131
                                <Arbol>tree</Arbol>
132
                                <palm>tree</palm>
133
                                <H>hemiepiphyte</H>
134
                                <Hemiepífito>hemiepiphyte</Hemiepífito>
135
                                <L>liana</L>
136
                                <l>liana</l>
137
                                <L?>liana</L?>
138
                                <Liana>liana</Liana>
139
                                <E>epiphyte</E>
140
                                <S>shrub</S>
141
                                <Hb>herb</Hb>
142
                                <vine-herbaceous>vine</vine-herbaceous>
143
                                <graminoid>grass</graminoid>
144
                                <rosette>forb</rosette>
145
                                <*>*</*>
146
                                <value>$Habit</value>
147
                            </_map>
148
                        </growthform>
149
                        <sourceaccessioncode>$PlotObsID</sourceaccessioncode>
150
                        <taxondetermination>
151
                            <party_id><party><fullname>$det_by</fullname></party></party_id>
152
                            <taxonverbatim_id>
153
                                <taxonverbatim>
154
                                    <taxonlabel_id>
155
                                        <taxonlabel>
156
                                            <matched_label_id>
56
                                    <linecover_m><_cm_to_m><value>$intercept_cm</value></_cm_to_m></linecover_m>
57
                                    <notes>$Notes</notes>
58
                                    <plantobservation>
59
                                        <collectionnumber>$Ind</collectionnumber>
60
                                        <sourceaccessioncode>$PlotObsID</sourceaccessioncode>
61
                                        <specimenreplicate>
62
                                            <catalognumber_dwc>
63
                                                <_if name="if indirect voucher">
64
                                                    <cond>
65
                                                        <_eq>
66
                                                            <right>indirect</right>
67
                                                            <left>$DetType</left>
68
                                                        </_eq>
69
                                                    </cond>
70
                                                    <else>
71
                                                        <_alt>
72
                                                            <1>$coll_number</1>
73
                                                            <2>$SourceVoucher</2>
74
                                                        </_alt>
75
                                                    </else>
76
                                                </_if>
77
                                            </catalognumber_dwc>
78
                                        </specimenreplicate>
79
                                        <stemobservation>
80
                                            <definedvalue fkey="tablerecord_id">
81
                                                <userdefined_id>
82
                                                    <userdefined>
83
                                                        <tablename>stemobservation</tablename>
84
                                                        <userdefinedname>canopyForm</userdefinedname>
85
                                                    </userdefined>
86
                                                </userdefined_id>
87
                                                <definedvalue>$canopy_form</definedvalue>
88
                                            </definedvalue>
89
                                            <definedvalue fkey="tablerecord_id">
90
                                                <userdefined_id>
91
                                                    <userdefined>
92
                                                        <tablename>stemobservation</tablename>
93
                                                        <userdefinedname>canopyPosition</userdefinedname>
94
                                                    </userdefined>
95
                                                </userdefined_id>
96
                                                <definedvalue>$canopy_position</definedvalue>
97
                                            </definedvalue>
98
                                            <definedvalue fkey="tablerecord_id">
99
                                                <userdefined_id>
100
                                                    <userdefined>
101
                                                        <tablename>stemobservation</tablename>
102
                                                        <userdefinedname>lianaInfestation</userdefinedname>
103
                                                    </userdefined>
104
                                                </userdefined_id>
105
                                                <definedvalue>$liana_infestation</definedvalue>
106
                                            </definedvalue>
107
                                            <diameterbreastheight_m><_cm_to_m><value>$temp_dbh</value></_cm_to_m></diameterbreastheight_m>
108
                                            <height_m>$height_m</height_m>
109
                                            <heightfirstbranch_m>$ht_first_branch_m</heightfirstbranch_m>
110
                                            <tag>
111
                                                <_alt>
112
                                                    <1>$tag2</1>
113
                                                    <2>$tag1</2>
114
                                                </_alt>
115
                                            </tag>
116
                                            <xposition_m>$x_position</xposition_m>
117
                                            <yposition_m>$y_position</yposition_m>
118
                                        </stemobservation>
119
                                    </plantobservation>
120
                                </aggregateoccurrence>
121
                                <authortaxoncode>$Ind</authortaxoncode>
122
                                <collector_id>
123
                                    <party>
124
                                        <fullname>
125
                                            <_join_words>
126
                                                <1>$coll_firstname</1>
127
                                                <2>$coll_lastname</2>
128
                                            </_join_words>
129
                                        </fullname>
130
                                    </party>
131
                                </collector_id>
132
                                <growthform>
133
                                    <_map>
134
                                        <T>tree</T>
135
                                        <Arbol>tree</Arbol>
136
                                        <palm>tree</palm>
137
                                        <H>hemiepiphyte</H>
138
                                        <Hemiepífito>hemiepiphyte</Hemiepífito>
139
                                        <L>liana</L>
140
                                        <l>liana</l>
141
                                        <L?>liana</L?>
142
                                        <Liana>liana</Liana>
143
                                        <E>epiphyte</E>
144
                                        <S>shrub</S>
145
                                        <Hb>herb</Hb>
146
                                        <vine-herbaceous>vine</vine-herbaceous>
147
                                        <graminoid>grass</graminoid>
148
                                        <rosette>forb</rosette>
149
                                        <*>*</*>
150
                                        <value>$Habit</value>
151
                                    </_map>
152
                                </growthform>
153
                                <sourceaccessioncode>$PlotObsID</sourceaccessioncode>
154
                                <taxondetermination>
155
                                    <party_id><party><fullname>$det_by</fullname></party></party_id>
156
                                    <taxonverbatim_id>
157
                                        <taxonverbatim>
158
                                            <taxonlabel_id>
157 159
                                                <taxonlabel>
158
                                                    <source_id><source><shortname>TNRS</shortname></source></source_id>
159
                                                    <taxonomicname>
160
                                                        <_join_words>
161
                                                            <1><_taxon_family_require_std><family>$Family</family></_taxon_family_require_std></1>
162
                                                            <2>
160
                                                    <matched_label_id>
161
                                                        <taxonlabel>
162
                                                            <source_id><source><shortname>TNRS</shortname></source></source_id>
163
                                                            <taxonomicname>
163 164
                                                                <_join_words>
164
                                                                    <1>
165
                                                                    <1><_taxon_family_require_std><family>$Family</family></_taxon_family_require_std></1>
166
                                                                    <2>
165 167
                                                                        <_join_words>
166
                                                                            <2>$Genus</2>
167
                                                                            <3>$Species</3>
168
                                                                            <5>
168
                                                                            <1>
169 169
                                                                                <_join_words>
170
                                                                                    <1>
171
                                                                                        <_if name="if has infraspecificEpithet">
172
                                                                                            <cond>$infra_ep_1</cond>
173
                                                                                            <then>$infra_rank_1</then>
174
                                                                                        </_if>
175
                                                                                    </1>
176
                                                                                    <2>$infra_ep_1</2>
170
                                                                                    <2>$Genus</2>
171
                                                                                    <3>$Species</3>
172
                                                                                    <5>
173
                                                                                        <_join_words>
174
                                                                                            <1>
175
                                                                                                <_if name="if has infraspecificEpithet">
176
                                                                                                    <cond>$infra_ep_1</cond>
177
                                                                                                    <then>$infra_rank_1</then>
178
                                                                                                </_if>
179
                                                                                            </1>
180
                                                                                            <2>$infra_ep_1</2>
181
                                                                                        </_join_words>
182
                                                                                    </5>
177 183
                                                                                </_join_words>
178
                                                                            </5>
184
                                                                            </1>
185
                                                                            <2>$auth</2>
179 186
                                                                        </_join_words>
180
                                                                    </1>
181
                                                                    <2>$auth</2>
187
                                                                    </2>
182 188
                                                                </_join_words>
183
                                                            </2>
184
                                                        </_join_words>
185
                                                    </taxonomicname>
186
                                                </taxonlabel>
187
                                            </matched_label_id>
188
                                            <parent_id>
189
                                                <taxonlabel>
190
                                                    <rank>$infra_rank_1</rank>
191
                                                    <taxonverbatim><verbatimrank>$infra_rank_1</verbatimrank></taxonverbatim>
189
                                                            </taxonomicname>
190
                                                        </taxonlabel>
191
                                                    </matched_label_id>
192 192
                                                    <parent_id>
193 193
                                                        <taxonlabel>
194
                                                            <rank>cultivar</rank>
194
                                                            <rank>$infra_rank_1</rank>
195
                                                            <taxonverbatim><verbatimrank>$infra_rank_1</verbatimrank></taxonverbatim>
195 196
                                                            <parent_id>
196 197
                                                                <taxonlabel>
197
                                                                    <rank>forma</rank>
198
                                                                    <rank>cultivar</rank>
198 199
                                                                    <parent_id>
199 200
                                                                        <taxonlabel>
200
                                                                            <rank>variety</rank>
201
                                                                            <rank>forma</rank>
201 202
                                                                            <parent_id>
202 203
                                                                                <taxonlabel>
203
                                                                                    <rank>subspecies</rank>
204
                                                                                    <rank>variety</rank>
204 205
                                                                                    <parent_id>
205 206
                                                                                        <taxonlabel>
206
                                                                                            <rank>species</rank>
207
                                                                                            <taxonepithet>$Species</taxonepithet>
207
                                                                                            <rank>subspecies</rank>
208 208
                                                                                            <parent_id>
209 209
                                                                                                <taxonlabel>
210
                                                                                                    <rank>genus</rank>
211
                                                                                                    <taxonepithet>$Genus</taxonepithet>
210
                                                                                                    <rank>species</rank>
211
                                                                                                    <taxonepithet>$Species</taxonepithet>
212 212
                                                                                                    <parent_id>
213 213
                                                                                                        <taxonlabel>
214
                                                                                                            <rank>family</rank>
215
                                                                                                            <taxonepithet>$Family</taxonepithet>
214
                                                                                                            <rank>genus</rank>
215
                                                                                                            <taxonepithet>$Genus</taxonepithet>
216
                                                                                                            <parent_id>
217
                                                                                                                <taxonlabel>
218
                                                                                                                    <rank>family</rank>
219
                                                                                                                    <taxonepithet>$Family</taxonepithet>
220
                                                                                                                </taxonlabel>
221
                                                                                                            </parent_id>
216 222
                                                                                                        </taxonlabel>
217 223
                                                                                                    </parent_id>
218 224
                                                                                                </taxonlabel>
......
225 231
                                                                    </parent_id>
226 232
                                                                </taxonlabel>
227 233
                                                            </parent_id>
234
                                                            <taxonepithet>$infra_ep_1</taxonepithet>
228 235
                                                        </taxonlabel>
229 236
                                                    </parent_id>
230
                                                    <taxonepithet>$infra_ep_1</taxonepithet>
231
                                                </taxonlabel>
232
                                            </parent_id>
233
                                            <rank>$infra_rank_1</rank>
234
                                            <taxonomicname>
235
                                                <_join_words>
236
                                                    <1><_taxon_family_require_std><family>$Family</family></_taxon_family_require_std></1>
237
                                                    <2>
237
                                                    <rank>$infra_rank_1</rank>
238
                                                    <taxonomicname>
238 239
                                                        <_join_words>
239
                                                            <1>
240
                                                            <1><_taxon_family_require_std><family>$Family</family></_taxon_family_require_std></1>
241
                                                            <2>
240 242
                                                                <_join_words>
241
                                                                    <2>$Genus</2>
242
                                                                    <3>$Species</3>
243
                                                                    <5>
243
                                                                    <1>
244 244
                                                                        <_join_words>
245
                                                                            <1>
246
                                                                                <_if name="if has infraspecificEpithet">
247
                                                                                    <cond>$infra_ep_1</cond>
248
                                                                                    <then>$infra_rank_1</then>
249
                                                                                </_if>
250
                                                                            </1>
251
                                                                            <2>$infra_ep_1</2>
245
                                                                            <2>$Genus</2>
246
                                                                            <3>$Species</3>
247
                                                                            <5>
248
                                                                                <_join_words>
249
                                                                                    <1>
250
                                                                                        <_if name="if has infraspecificEpithet">
251
                                                                                            <cond>$infra_ep_1</cond>
252
                                                                                            <then>$infra_rank_1</then>
253
                                                                                        </_if>
254
                                                                                    </1>
255
                                                                                    <2>$infra_ep_1</2>
256
                                                                                </_join_words>
257
                                                                            </5>
252 258
                                                                        </_join_words>
253
                                                                    </5>
259
                                                                    </1>
260
                                                                    <2>$auth</2>
254 261
                                                                </_join_words>
255
                                                            </1>
256
                                                            <2>$auth</2>
257
                                                        </_join_words>
258
                                                    </2>
259
                                                </_join_words>
260
                                            </taxonomicname>
261
                                        </taxonlabel>
262
                                    </taxonlabel_id>
263
                                    <author>$auth</author>
264
                                    <family>$Family</family>
265
                                    <genus>$Genus</genus>
266
                                    <specific_epithet>$Species</specific_epithet>
267
                                    <verbatimrank>$infra_rank_1</verbatimrank>
268
                                </taxonverbatim>
269
                            </taxonverbatim_id>
270
                            <taxonfit>$cfaff</taxonfit>
271
                        </taxondetermination>
272
                        <taxondetermination>
273
                            <isoriginal>true</isoriginal>
274
                            <taxonverbatim_id>
275
                                <taxonverbatim>
276
                                    <taxonlabel_id>
277
                                        <taxonlabel>
278
                                            <matched_label_id>
279
                                                <taxonlabel>
280
                                                    <source_id><source><shortname>TNRS</shortname></source></source_id>
281
                                                    <taxonomicname>
282
                                                        <_join_words>
283
                                                            <1><_taxon_family_require_std><family>$OrigFamily</family></_taxon_family_require_std></1>
284
                                                            <2>
285
                                                                <_join_words>
286
                                                                    <2>$OrigGenus</2>
287
                                                                    <3>$OrigSpecies</3>
288
                                                                </_join_words>
289 262
                                                            </2>
290 263
                                                        </_join_words>
291 264
                                                    </taxonomicname>
292 265
                                                </taxonlabel>
293
                                            </matched_label_id>
294
                                            <parent_id>
266
                                            </taxonlabel_id>
267
                                            <author>$auth</author>
268
                                            <family>$Family</family>
269
                                            <genus>$Genus</genus>
270
                                            <specific_epithet>$Species</specific_epithet>
271
                                            <verbatimrank>$infra_rank_1</verbatimrank>
272
                                        </taxonverbatim>
273
                                    </taxonverbatim_id>
274
                                    <taxonfit>$cfaff</taxonfit>
275
                                </taxondetermination>
276
                                <taxondetermination>
277
                                    <isoriginal>true</isoriginal>
278
                                    <taxonverbatim_id>
279
                                        <taxonverbatim>
280
                                            <taxonlabel_id>
295 281
                                                <taxonlabel>
282
                                                    <matched_label_id>
283
                                                        <taxonlabel>
284
                                                            <source_id><source><shortname>TNRS</shortname></source></source_id>
285
                                                            <taxonomicname>
286
                                                                <_join_words>
287
                                                                    <1><_taxon_family_require_std><family>$OrigFamily</family></_taxon_family_require_std></1>
288
                                                                    <2>
289
                                                                        <_join_words>
290
                                                                            <2>$OrigGenus</2>
291
                                                                            <3>$OrigSpecies</3>
292
                                                                        </_join_words>
293
                                                                    </2>
294
                                                                </_join_words>
295
                                                            </taxonomicname>
296
                                                        </taxonlabel>
297
                                                    </matched_label_id>
296 298
                                                    <parent_id>
297 299
                                                        <taxonlabel>
298
                                                            <rank>cultivar</rank>
299 300
                                                            <parent_id>
300 301
                                                                <taxonlabel>
301
                                                                    <rank>forma</rank>
302
                                                                    <rank>cultivar</rank>
302 303
                                                                    <parent_id>
303 304
                                                                        <taxonlabel>
304
                                                                            <rank>variety</rank>
305
                                                                            <rank>forma</rank>
305 306
                                                                            <parent_id>
306 307
                                                                                <taxonlabel>
307
                                                                                    <rank>subspecies</rank>
308
                                                                                    <rank>variety</rank>
308 309
                                                                                    <parent_id>
309 310
                                                                                        <taxonlabel>
310
                                                                                            <rank>species</rank>
311
                                                                                            <taxonepithet>$OrigSpecies</taxonepithet>
311
                                                                                            <rank>subspecies</rank>
312 312
                                                                                            <parent_id>
313 313
                                                                                                <taxonlabel>
314
                                                                                                    <rank>genus</rank>
315
                                                                                                    <taxonepithet>$OrigGenus</taxonepithet>
314
                                                                                                    <rank>species</rank>
315
                                                                                                    <taxonepithet>$OrigSpecies</taxonepithet>
316 316
                                                                                                    <parent_id>
317 317
                                                                                                        <taxonlabel>
318
                                                                                                            <rank>family</rank>
319
                                                                                                            <taxonepithet>$OrigFamily</taxonepithet>
318
                                                                                                            <rank>genus</rank>
319
                                                                                                            <taxonepithet>$OrigGenus</taxonepithet>
320
                                                                                                            <parent_id>
321
                                                                                                                <taxonlabel>
322
                                                                                                                    <rank>family</rank>
323
                                                                                                                    <taxonepithet>$OrigFamily</taxonepithet>
324
                                                                                                                </taxonlabel>
325
                                                                                                            </parent_id>
320 326
                                                                                                        </taxonlabel>
321 327
                                                                                                    </parent_id>
322 328
                                                                                                </taxonlabel>
......
331 337
                                                            </parent_id>
332 338
                                                        </taxonlabel>
333 339
                                                    </parent_id>
334
                                                </taxonlabel>
335
                                            </parent_id>
336
                                            <taxonomicname>
337
                                                <_join_words>
338
                                                    <1><_taxon_family_require_std><family>$OrigFamily</family></_taxon_family_require_std></1>
339
                                                    <2>
340
                                                    <taxonomicname>
340 341
                                                        <_join_words>
341
                                                            <2>$OrigGenus</2>
342
                                                            <3>$OrigSpecies</3>
342
                                                            <1><_taxon_family_require_std><family>$OrigFamily</family></_taxon_family_require_std></1>
343
                                                            <2>
344
                                                                <_join_words>
345
                                                                    <2>$OrigGenus</2>
346
                                                                    <3>$OrigSpecies</3>
347
                                                                </_join_words>
348
                                                            </2>
343 349
                                                        </_join_words>
344
                                                    </2>
345
                                                </_join_words>
346
                                            </taxonomicname>
347
                                        </taxonlabel>
348
                                    </taxonlabel_id>
349
                                    <family>$OrigFamily</family>
350
                                    <genus>$OrigGenus</genus>
351
                                    <specific_epithet>$OrigSpecies</specific_epithet>
352
                                </taxonverbatim>
353
                            </taxonverbatim_id>
354
                        </taxondetermination>
355
                        <voucher>
356
                            <specimenreplicate_id>
357
                                <specimenreplicate>
358
                                    <catalognumber_dwc>
359
                                        <_if name="if indirect voucher">
360
                                            <cond>
361
                                                <_eq>
362
                                                    <right>indirect</right>
363
                                                    <left>$DetType</left>
364
                                                </_eq>
365
                                            </cond>
366
                                            <then>
367
                                                <_alt>
368
                                                    <1>$coll_number</1>
369
                                                    <2>$SourceVoucher</2>
370
                                                </_alt>
371
                                            </then>
372
                                        </_if>
373
                                    </catalognumber_dwc>
374
                                </specimenreplicate>
375
                            </specimenreplicate_id>
376
                        </voucher>
377
                    </taxonoccurrence>
378
                </locationevent>
379
                <sourceaccessioncode>
380
                    <_join>
381
                        <1>$PlotID</1>
382
                        <2>$Line</2>
383
                    </_join>
384
                </sourceaccessioncode>
385
            </location>
350
                                                    </taxonomicname>
351
                                                </taxonlabel>
352
                                            </taxonlabel_id>
353
                                            <family>$OrigFamily</family>
354
                                            <genus>$OrigGenus</genus>
355
                                            <specific_epithet>$OrigSpecies</specific_epithet>
356
                                        </taxonverbatim>
357
                                    </taxonverbatim_id>
358
                                </taxondetermination>
359
                                <voucher>
360
                                    <specimenreplicate_id>
361
                                        <specimenreplicate>
362
                                            <catalognumber_dwc>
363
                                                <_if name="if indirect voucher">
364
                                                    <cond>
365
                                                        <_eq>
366
                                                            <right>indirect</right>
367
                                                            <left>$DetType</left>
368
                                                        </_eq>
369
                                                    </cond>
370
                                                    <then>
371
                                                        <_alt>
372
                                                            <1>$coll_number</1>
373
                                                            <2>$SourceVoucher</2>
374
                                                        </_alt>
375
                                                    </then>
376
                                                </_if>
377
                                            </catalognumber_dwc>
378
                                        </specimenreplicate>
379
                                    </specimenreplicate_id>
380
                                </voucher>
381
                            </taxonoccurrence>
382
                        </locationevent>
383
                        <sourceaccessioncode>
384
                            <_join>
385
                                <1>$PlotID</1>
386
                                <2>$Line</2>
387
                            </_join>
388
                        </sourceaccessioncode>
389
                    </location>
390
                </path>
391
            </_simplifyPath>
386 392
        </path>
387
    </_simplifyPath>
393
    </_setDefault>
388 394
</VegBIEN>
389 395
Inserted 52 new rows into database
inputs/U/Specimen/VegBIEN.csv
1
U,VegBIEN:/_simplifyPath:[next=parent_id]/path,Comments
1
U,"VegBIEN:/_setDefault:[col=source_id,value/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path",Comments
2 2
ID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/1",
3 3
Barcode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_if[@name=""if catalogNumber""]/cond/_exists",
4 4
Barcode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_if[@name=""if catalogNumber""]/then/_join/1/_if[@name=""if specimen""]/cond/_exists",
inputs/U/Specimen/test.xml.ref
1 1
Put template:
2 2
<VegBIEN>
3
    <_simplifyPath id="-1">
4
        <next>parent_id</next>
3
    <_setDefault id="-1">
4
        <col>source_id</col>
5
        <value><source><shortname>U</shortname></source></value>
5 6
        <path>
6
            <location>
7
                <authorlocationcode>
8
                    <_alt>
9
                        <1>$ID</1>
10
                        <2>$Barcode</2>
11
                    </_alt>
12
                </authorlocationcode>
13
                <locationevent>
14
                    <taxonoccurrence>
15
                        <aggregateoccurrence>
16
                            <collectiondate>
17
                                <_date>
18
                                    <day>
19
                                        <_nullIf>
20
                                            <null>0</null>
21
                                            <type>float</type>
22
                                            <value>$Colldd</value>
23
                                        </_nullIf>
24
                                    </day>
25
                                    <month>
26
                                        <_nullIf>
27
                                            <null>0</null>
28
                                            <type>float</type>
29
                                            <value>$Collmm</value>
30
                                        </_nullIf>
31
                                    </month>
32
                                    <year>
33
                                        <_nullIf>
34
                                            <null>0</null>
35
                                            <type>float</type>
36
                                            <value>$Collyy</value>
37
                                        </_nullIf>
38
                                    </year>
39
                                </_date>
40
                            </collectiondate>
41
                            <notes>$Notes</notes>
42
                            <plantobservation>
43
                                <collectionnumber>$Number</collectionnumber>
44
                                <specimenreplicate>
45
                                    <catalognumber_dwc>$Barcode</catalognumber_dwc>
46
                                    <sourceaccessioncode>$ID</sourceaccessioncode>
47
                                </specimenreplicate>
48
                            </plantobservation>
49
                        </aggregateoccurrence>
50
                        <collector_id>
51
                            <party>
52
                                <fullname>
53
                                    <_join>
54
                                        <1>$Collector</1>
55
                                        <2>$Addcoll</2>
56
                                    </_join>
57
                                </fullname>
58
                            </party>
59
                        </collector_id>
60
                        <sourceaccessioncode>$ID</sourceaccessioncode>
61
                        <taxondetermination>
62
                            <party_id><party><fullname>$Detby</fullname></party></party_id>
63
                            <taxonverbatim_id>
64
                                <taxonverbatim>
65
                                    <taxonlabel_id>
66
                                        <taxonlabel>
67
                                            <matched_label_id>
7
            <_simplifyPath>
8
                <next>parent_id</next>
9
                <path>
10
                    <location>
11
                        <authorlocationcode>
12
                            <_alt>
13
                                <1>$ID</1>
14
                                <2>$Barcode</2>
15
                            </_alt>
16
                        </authorlocationcode>
17
                        <locationevent>
18
                            <taxonoccurrence>
19
                                <aggregateoccurrence>
20
                                    <collectiondate>
21
                                        <_date>
22
                                            <day>
23
                                                <_nullIf>
24
                                                    <null>0</null>
25
                                                    <type>float</type>
26
                                                    <value>$Colldd</value>
27
                                                </_nullIf>
28
                                            </day>
29
                                            <month>
30
                                                <_nullIf>
31
                                                    <null>0</null>
32
                                                    <type>float</type>
33
                                                    <value>$Collmm</value>
34
                                                </_nullIf>
35
                                            </month>
36
                                            <year>
37
                                                <_nullIf>
38
                                                    <null>0</null>
39
                                                    <type>float</type>
40
                                                    <value>$Collyy</value>
41
                                                </_nullIf>
42
                                            </year>
43
                                        </_date>
44
                                    </collectiondate>
45
                                    <notes>$Notes</notes>
46
                                    <plantobservation>
47
                                        <collectionnumber>$Number</collectionnumber>
48
                                        <specimenreplicate>
49
                                            <catalognumber_dwc>$Barcode</catalognumber_dwc>
50
                                            <sourceaccessioncode>$ID</sourceaccessioncode>
51
                                        </specimenreplicate>
52
                                    </plantobservation>
53
                                </aggregateoccurrence>
54
                                <collector_id>
55
                                    <party>
56
                                        <fullname>
57
                                            <_join>
58
                                                <1>$Collector</1>
59
                                                <2>$Addcoll</2>
60
                                            </_join>
61
                                        </fullname>
62
                                    </party>
63
                                </collector_id>
64
                                <sourceaccessioncode>$ID</sourceaccessioncode>
65
                                <taxondetermination>
66
                                    <party_id><party><fullname>$Detby</fullname></party></party_id>
67
                                    <taxonverbatim_id>
68
                                        <taxonverbatim>
69
                                            <taxonlabel_id>
68 70
                                                <taxonlabel>
69
                                                    <source_id><source><shortname>TNRS</shortname></source></source_id>
70
                                                    <taxonomicname>
71
                                                        <_join_words>
72
                                                            <1><_taxon_family_require_std><family>$Family</family></_taxon_family_require_std></1>
73
                                                            <2>$Genus</2>
74
                                                        </_join_words>
75
                                                    </taxonomicname>
76
                                                </taxonlabel>
77
                                            </matched_label_id>
78
                                            <creationdate>
79
                                                <_date>
80
                                                    <year>
81
                                                        <_nullIf>
82
                                                            <null>0</null>
83
                                                            <type>float</type>
84
                                                            <value>$Detyy</value>
85
                                                        </_nullIf>
86
                                                    </year>
87
                                                </_date>
88
                                            </creationdate>
89
                                            <parent_id>
90
                                                <taxonlabel>
71
                                                    <matched_label_id>
72
                                                        <taxonlabel>
73
                                                            <source_id><source><shortname>TNRS</shortname></source></source_id>
74
                                                            <taxonomicname>
75
                                                                <_join_words>
76
                                                                    <1><_taxon_family_require_std><family>$Family</family></_taxon_family_require_std></1>
77
                                                                    <2>$Genus</2>
78
                                                                </_join_words>
79
                                                            </taxonomicname>
80
                                                        </taxonlabel>
81
                                                    </matched_label_id>
82
                                                    <creationdate>
83
                                                        <_date>
84
                                                            <year>
85
                                                                <_nullIf>
86
                                                                    <null>0</null>
87
                                                                    <type>float</type>
88
                                                                    <value>$Detyy</value>
89
                                                                </_nullIf>
90
                                                            </year>
91
                                                        </_date>
92
                                                    </creationdate>
91 93
                                                    <parent_id>
92 94
                                                        <taxonlabel>
93
                                                            <rank>cultivar</rank>
94 95
                                                            <parent_id>
95 96
                                                                <taxonlabel>
96
                                                                    <rank>forma</rank>
97
                                                                    <rank>cultivar</rank>
97 98
                                                                    <parent_id>
98 99
                                                                        <taxonlabel>
99
                                                                            <rank>variety</rank>
100
                                                                            <rank>forma</rank>
100 101
                                                                            <parent_id>
101 102
                                                                                <taxonlabel>
102
                                                                                    <rank>subspecies</rank>
103
                                                                                    <rank>variety</rank>
103 104
                                                                                    <parent_id>
104 105
                                                                                        <taxonlabel>
105
                                                                                            <rank>species</rank>
106
                                                                                            <rank>subspecies</rank>
106 107
                                                                                            <parent_id>
107 108
                                                                                                <taxonlabel>
108
                                                                                                    <rank>genus</rank>
109
                                                                                                    <taxonepithet>$Genus</taxonepithet>
109
                                                                                                    <rank>species</rank>
110 110
                                                                                                    <parent_id>
111 111
                                                                                                        <taxonlabel>
112
                                                                                                            <rank>family</rank>
113
                                                                                                            <taxonepithet>$Family</taxonepithet>
112
                                                                                                            <rank>genus</rank>
113
                                                                                                            <taxonepithet>$Genus</taxonepithet>
114
                                                                                                            <parent_id>
115
                                                                                                                <taxonlabel>
116
                                                                                                                    <rank>family</rank>
117
                                                                                                                    <taxonepithet>$Family</taxonepithet>
118
                                                                                                                </taxonlabel>
119
                                                                                                            </parent_id>
114 120
                                                                                                        </taxonlabel>
115 121
                                                                                                    </parent_id>
116 122
                                                                                                </taxonlabel>
......
125 131
                                                            </parent_id>
126 132
                                                        </taxonlabel>
127 133
                                                    </parent_id>
134
                                                    <taxonomicname>
135
                                                        <_join_words>
136
                                                            <1><_taxon_family_require_std><family>$Family</family></_taxon_family_require_std></1>
137
                                                            <2>$Genus</2>
138
                                                        </_join_words>
139
                                                    </taxonomicname>
128 140
                                                </taxonlabel>
129
                                            </parent_id>
130
                                            <taxonomicname>
131
                                                <_join_words>
132
                                                    <1><_taxon_family_require_std><family>$Family</family></_taxon_family_require_std></1>
133
                                                    <2>$Genus</2>
134
                                                </_join_words>
135
                                            </taxonomicname>
136
                                        </taxonlabel>
137
                                    </taxonlabel_id>
138
                                    <family>$Family</family>
139
                                    <genus>$Genus</genus>
140
                                </taxonverbatim>
141
                            </taxonverbatim_id>
142
                            <determinationdate>
143
                                <_date>
144
                                    <year>
145
                                        <_nullIf>
146
                                            <null>0</null>
147
                                            <type>float</type>
148
                                            <value>$Detyy</value>
149
                                        </_nullIf>
150
                                    </year>
151
                                </_date>
152
                            </determinationdate>
153
                            <taxonfit>$cf</taxonfit>
154
                        </taxondetermination>
155
                    </taxonoccurrence>
156
                </locationevent>
157
                <locationnarrative>
158
                    <_merge>
159
                        <2>
160
                            <_join>
161
                                <1>
141
                                            </taxonlabel_id>
142
                                            <family>$Family</family>
143
                                            <genus>$Genus</genus>
144
                                        </taxonverbatim>
145
                                    </taxonverbatim_id>
146
                                    <determinationdate>
147
                                        <_date>
148
                                            <year>
149
                                                <_nullIf>
150
                                                    <null>0</null>
151
                                                    <type>float</type>
152
                                                    <value>$Detyy</value>
153
                                                </_nullIf>
154
                                            </year>
155
                                        </_date>
156
                                    </determinationdate>
157
                                    <taxonfit>$cf</taxonfit>
158
                                </taxondetermination>
159
                            </taxonoccurrence>
160
                        </locationevent>
161
                        <locationnarrative>
162
                            <_merge>
163
                                <2>
164
                                    <_join>
165
                                        <1>
166
                                            <_label>
167
                                                <label>gazetteer</label>
168
                                                <value>
169
                                                    <_join>
170
                                                        <1>$Gazetteer</1>
171
                                                        <2>$Newgazett</2>
172
                                                    </_join>
173
                                                </value>
174
                                            </_label>
175
                                        </1>
176
                                        <2>$Locnotes</2>
177
                                    </_join>
178
                                </2>
179
                                <3>
162 180
                                    <_label>
163
                                        <label>gazetteer</label>
164
                                        <value>
165
                                            <_join>
166
                                                <1>$Gazetteer</1>
167
                                                <2>$Newgazett</2>
168
                                            </_join>
169
                                        </value>
181
                                        <label>habitat</label>
182
                                        <value>$Ecology</value>
170 183
                                    </_label>
171
                                </1>
172
                                <2>$Locnotes</2>
173
                            </_join>
174
                        </2>
175
                        <3>
176
                            <_label>
177
                                <label>habitat</label>
178
                                <value>$Ecology</value>
179
                            </_label>
180
                        </3>
181
                    </_merge>
182
                </locationnarrative>
183
                <locationplace>
184
                    <place_id>
185
                        <place>
186
                            <coordinates_id>
187
                                <coordinates>
188
                                    <latitude_deg>
189
                                        <_nullIf>
190
                                            <null>0</null>
191
                                            <type>float</type>
192
                                            <value>$Lat</value>
193
                                        </_nullIf>
194
                                    </latitude_deg>
195
                                    <longitude_deg>
196
                                        <_nullIf>
197
                                            <null>0</null>
198
                                            <type>float</type>
199
                                            <value>$Long</value>
200
                                        </_nullIf>
201
                                    </longitude_deg>
202
                                </coordinates>
203
                            </coordinates_id>
204
                            <country>$Country</country>
205
                            <matched_place_id>
184
                                </3>
185
                            </_merge>
186
                        </locationnarrative>
187
                        <locationplace>
188
                            <place_id>
206 189
                                <place>
207
                                    <source_id><source><shortname>geoscrub</shortname></source></source_id>
208 190
                                    <coordinates_id>
209 191
                                        <coordinates>
210
                                            <source_id><source><shortname>geoscrub</shortname></source></source_id>
211 192
                                            <latitude_deg>
212 193
                                                <_nullIf>
213 194
                                                    <null>0</null>
......
225 206
                                        </coordinates>
226 207
                                    </coordinates_id>
227 208
                                    <country>$Country</country>
209
                                    <matched_place_id>
210
                                        <place>
211
                                            <source_id><source><shortname>geoscrub</shortname></source></source_id>
212
                                            <coordinates_id>
213
                                                <coordinates>
214
                                                    <source_id><source><shortname>geoscrub</shortname></source></source_id>
215
                                                    <latitude_deg>
216
                                                        <_nullIf>
217
                                                            <null>0</null>
218
                                                            <type>float</type>
219
                                                            <value>$Lat</value>
220
                                                        </_nullIf>
221
                                                    </latitude_deg>
222
                                                    <longitude_deg>
223
                                                        <_nullIf>
224
                                                            <null>0</null>
225
                                                            <type>float</type>
226
                                                            <value>$Long</value>
227
                                                        </_nullIf>
228
                                                    </longitude_deg>
229
                                                </coordinates>
230
                                            </coordinates_id>
231
                                            <country>$Country</country>
232
                                        </place>
233
                                    </matched_place_id>
228 234
                                </place>
229
                            </matched_place_id>
230
                        </place>
231
                    </place_id>
232
                </locationplace>
233
            </location>
235
                            </place_id>
236
                        </locationplace>
237
                    </location>
238
                </path>
239
            </_simplifyPath>
234 240
        </path>
235
    </_simplifyPath>
241
    </_setDefault>
236 242
</VegBIEN>
237 243
Inserted 35 new rows into database
inputs/GBIF/Source/test.xml.ref
1 1
Put template:
2 2
<VegBIEN>
3
    <_simplifyPath id="-1">
4
        <next>parent_id</next>
5
        <path><source><sourcetype>aggregator</sourcetype></source></path>
6
    </_simplifyPath>
3
    <_setDefault id="-1">
... This diff was truncated because it exceeds the maximum size that can be displayed.

Also available in: Unified diff