<!--put template-->

<VegBIEN>

    <_setDefault id="-1">

        <source_id><source><shortname>TRT.new</shortname></source></source_id>

        <path>

            <_simplifyPath>

                <next>parent_id</next>

                <path>

                    <location>

                        <authorlocationcode>

                            <_alt>

                                <1>$dataProviderRecordID</1>

                                <2>

                                    <_join>

                                        <1>$specimen_duplicate_institutions</1>

                                        <2>

                                            <_join>

                                                <1>$collection</1>

                                                <2>$collectionURL</2>

                                            </_join>

                                        </2>

                                        <3>$accessionNumber</3>

                                    </_join>

                                </2>

                            </_alt>

                        </authorlocationcode>

                        <accessconditions>$rights</accessconditions>

                        <elevation_m>

                            <_alt>

                                <1>

                                    <_units>

                                        <to>m</to>

                                        <to></to>

                                        <value>$verbatimElevation</value>

                                    </_units>

                                </1>

                                <2>

                                    <_avg>

                                        <1>$minimumElevationInMeters</1>

                                        <2>$maximumElevationInMeters</2>

                                    </_avg>

                                </2>

                            </_alt>

                        </elevation_m>

                        <iscultivated>

                            <_locationnarrative_is_cultivated>

                                <locationnarrative>

                                    <_join>

                                        <1>$locality</1>

                                        <3>$habitat</3>

                                    </_join>

                                </locationnarrative>

                            </_locationnarrative_is_cultivated>

                        </iscultivated>

                        <locationevent>

                            <locationevent fkey="parent_id">

                                <taxonoccurrence>

                                    <aggregateoccurrence>

                                        <collectiondate>$dateCollected</collectiondate>

                                        <notes>$occurrenceRemarks</notes>

                                        <plantobservation>

                                            <authorplantcode>$collectorNumber</authorplantcode>

                                            <definedvalue fkey="tablerecord_id">

                                                <userdefined_id>

                                                    <userdefined>

                                                        <tablename>plantobservation</tablename>

                                                        <userdefinedname>sex</userdefinedname>

                                                    </userdefined>

                                                </userdefined_id>

                                                <definedvalue>$sex</definedvalue>

                                            </definedvalue>

                                            <reproductivecondition>$reproductiveCondition</reproductivecondition>

                                            <specimenreplicate>

                                                <catalognumber_dwc>$accessionNumber</catalognumber_dwc>

                                                <collectioncode_dwc>

                                                    <_alt>

                                                        <1>$collection</1>

                                                        <2>$collectionURL</2>

                                                    </_alt>

                                                </collectioncode_dwc>

                                                <collectionnumber>$collectorNumber</collectionnumber>

                                                <institution_id>

                                                    <sourcelist>

                                                        <name>$specimen_duplicate_institutions</name>

                                                        <sourcename>

                                                            <name>

                                                                <_split>

                                                                    <separator>[,;] *</separator>

                                                                    <value>$specimen_duplicate_institutions</value>

                                                                </_split>

                                                            </name>

                                                        </sourcename>

                                                    </sourcelist>

                                                </institution_id>

                                                <sourceaccessioncode>$dataProviderRecordID</sourceaccessioncode>

                                            </specimenreplicate>

                                        </plantobservation>

                                    </aggregateoccurrence>

                                    <collector_id><party><fullname>$recordedBy</fullname></party></collector_id>

                                    <iscultivated>

                                        <_map>

                                            <cultivated>t</cultivated>

                                            <wild>f</wild>

                                            <*></*>

                                            <value>$establishmentMeans</value>

                                        </_map>

                                    </iscultivated>

                                    <isnative>

                                        <_map>

                                            <native>t</native>

                                            <exotic>f</exotic>

                                            <*></*>

                                            <value>$establishmentMeans</value>

                                        </_map>

                                    </isnative>

                                    <sourceaccessioncode>$dataProviderRecordID</sourceaccessioncode>

                                    <taxondetermination>

                                        <party_id><party><fullname>$identifiedBy</fullname></party></party_id>

                                        <taxonverbatim_id>

                                            <taxonverbatim>

                                                <taxonlabel_id>

                                                    <taxonlabel>

                                                        <parent_id>

                                                            <taxonlabel>

                                                                <rank>$taxonRank</rank>

                                                                <parent_id>

                                                                    <taxonlabel>

                                                                        <rank>cultivar</rank>

                                                                        <parent_id>

                                                                            <taxonlabel>

                                                                                <rank>forma</rank>

                                                                                <parent_id>

                                                                                    <taxonlabel>

                                                                                        <rank>variety</rank>

                                                                                        <parent_id>

                                                                                            <taxonlabel>

                                                                                                <rank>subspecies</rank>

                                                                                                <parent_id>

                                                                                                    <taxonlabel>

                                                                                                        <rank>species</rank>

                                                                                                        <taxonepithet>$specificEpithet</taxonepithet>

                                                                                                        <parent_id>

                                                                                                            <taxonlabel>

                                                                                                                <rank>genus</rank>

                                                                                                                <taxonepithet>$genus</taxonepithet>

                                                                                                                <parent_id>

                                                                                                                    <taxonlabel>

                                                                                                                        <rank>family</rank>

                                                                                                                        <taxonepithet>$family</taxonepithet>

                                                                                                                        <parent_id>

                                                                                                                            <taxonlabel>

                                                                                                                                <rank>order</rank>

                                                                                                                                <parent_id>

                                                                                                                                    <taxonlabel>

                                                                                                                                        <rank>class</rank>

                                                                                                                                        <parent_id>

                                                                                                                                            <taxonlabel>

                                                                                                                                                <rank>phylum</rank>

                                                                                                                                                <parent_id>

                                                                                                                                                    <taxonlabel>

                                                                                                                                                        <rank>kingdom</rank>

                                                                                                                                                        <taxonepithet>$kingdom</taxonepithet>

                                                                                                                                                    </taxonlabel>

                                                                                                                                                </parent_id>

                                                                                                                                            </taxonlabel>

                                                                                                                                        </parent_id>

                                                                                                                                    </taxonlabel>

                                                                                                                                </parent_id>

                                                                                                                            </taxonlabel>

                                                                                                                        </parent_id>

                                                                                                                    </taxonlabel>

                                                                                                                </parent_id>

                                                                                                            </taxonlabel>

                                                                                                        </parent_id>

                                                                                                    </taxonlabel>

                                                                                                </parent_id>

                                                                                            </taxonlabel>

                                                                                        </parent_id>

                                                                                    </taxonlabel>

                                                                                </parent_id>

                                                                            </taxonlabel>

                                                                        </parent_id>

                                                                    </taxonlabel>

                                                                </parent_id>

                                                                <taxonepithet>$infraspecificEpithet</taxonepithet>

                                                            </taxonlabel>

                                                        </parent_id>

                                                        <rank>$taxonRank</rank>

                                                        <taxonomicname>

                                                            <_merge_prefix>

                                                                <prefix><_taxon_family_require_std><family>$family</family></_taxon_family_require_std></prefix>

                                                                <value>

                                                                    <_alt>

                                                                        <1>$scientificName</1>

                                                                        <2>

                                                                            <_join_words>

                                                                                <1>

                                                                                    <_join_words>

                                                                                        <2><_filter_genus><value>$genus</value></_filter_genus></2>

                                                                                        <3>$specificEpithet</3>

                                                                                        <5>

                                                                                            <_join_words>

                                                                                                <1>

                                                                                                    <_if name="if has infraspecificEpithet">

                                                                                                        <cond>$infraspecificEpithet</cond>

                                                                                                        <then>$taxonRank</then>

                                                                                                    </_if>

                                                                                                </1>

                                                                                                <2>$infraspecificEpithet</2>

                                                                                            </_join_words>

                                                                                        </5>

                                                                                    </_join_words>

                                                                                </1>

                                                                                <2>$scientificNameAuthorship</2>

                                                                            </_join_words>

                                                                        </2>

                                                                    </_alt>

                                                                </value>

                                                            </_merge_prefix>

                                                        </taxonomicname>

                                                    </taxonlabel>

                                                </taxonlabel_id>

                                                <author>$scientificNameAuthorship</author>

                                                <family>$family</family>

                                                <genus>$genus</genus>

                                                <specific_epithet>$specificEpithet</specific_epithet>

                                                <taxonomicname>$scientificName</taxonomicname>

                                                <verbatimrank>$taxonRank</verbatimrank>

                                            </taxonverbatim>

                                        </taxonverbatim_id>

                                        <determinationdate><_dateRangeStart><value>$dateIdentified</value></_dateRangeStart></determinationdate>

                                        <taxonfit>$identificationQualifier</taxonfit>

                                    </taxondetermination>

                                </taxonoccurrence>

                            </locationevent>

                        </locationevent>

                        <locationnarrative>

                            <_merge>

                                <1>$locality</1>

                                <3>

                                    <_label>

                                        <label>habitat</label>

                                        <value>$habitat</value>

                                    </_label>

                                </3>

                                <4>$locationRemarks</4>

                            </_merge>

                        </locationnarrative>

                        <locationplace>

                            <place_id>

                                <place>

                                    <coordinates_id>

                                        <coordinates>

                                            <coordsaccuracy_m><_noCV><value>$coordinateUncertaintyInMeters</value></_noCV></coordsaccuracy_m>

                                            <latitude_deg>

                                                <_nullIf>

                                                    <null>0</null>

                                                    <type>float</type>

                                                    <value>$decimalLatitude</value>

                                                </_nullIf>

                                            </latitude_deg>

                                            <longitude_deg>

                                                <_nullIf>

                                                    <null>0</null>

                                                    <type>float</type>

                                                    <value>$decimalLongitude</value>

                                                </_nullIf>

                                            </longitude_deg>

                                            <verbatimcoordinates>$verbatimCoordinates</verbatimcoordinates>

                                            <verbatimlatitude>$verbatimLatitude</verbatimlatitude>

                                            <verbatimlongitude>$verbatimLongitude</verbatimlongitude>

                                        </coordinates>

                                    </coordinates_id>

                                    <placename_id>

                                        <placename>

                                            <rank>municipality</rank>

                                            <placename>$municipality</placename>

                                        </placename>

                                    </placename_id>

                                    <continent>$continent</continent>

                                    <country>$country</country>

                                    <county>$county</county>

                                    <matched_place_id>

                                        <place>

                                            <source_id><source><shortname>geoscrub</shortname></source></source_id>

                                            <coordinates_id>

                                                <coordinates>

                                                    <source_id><source><shortname>geoscrub</shortname></source></source_id>

                                                    <latitude_deg>

                                                        <_nullIf>

                                                            <null>0</null>

                                                            <type>float</type>

                                                            <value>$decimalLatitude</value>

                                                        </_nullIf>

                                                    </latitude_deg>

                                                    <longitude_deg>

                                                        <_nullIf>

                                                            <null>0</null>

                                                            <type>float</type>

                                                            <value>$decimalLongitude</value>

                                                        </_nullIf>

                                                    </longitude_deg>

                                                </coordinates>

                                            </coordinates_id>

                                            <country>$country</country>

                                            <county>$county</county>

                                            <stateprovince>$stateProvince</stateprovince>

                                        </place>

                                    </matched_place_id>

                                    <stateprovince>$stateProvince</stateprovince>

                                </place>

                            </place_id>

                        </locationplace>

                        <verbatimelevation>$verbatimElevation</verbatimelevation>

                    </location>

                </path>

            </_simplifyPath>

        </path>

    </_setDefault>

</VegBIEN>

Inserted 38 new rows into database