CTFS[Veg+],Veg+,Comments

CountryID,,

PlotID,,

PlotName,,

LocationName,,

Latitude,,

Longitude,,

Elevation,,

ReferenceX,,

ReferenceY,,

SizeOfSite,,

ShapeOfSite,,

DescriptionOfSite,,

CountryName,,

row_num,,

CountryID,PlotID,PlotName,LocationName,Latitude,Longitude,Elevation,ReferenceX,ReferenceY,SizeOfSite,ShapeOfSite,DescriptionOfSite,CountryName,row_num

CTFS[Veg+],Veg+,Comments

CountryID,,

ReferenceX,,Rarely used

ReferenceY,,Rarely used

row_num,,

CTFS[Veg+],Veg+,Comments

CountryName,CountryName

DescriptionOfSite,DescriptionOfSite

Elevation,Elevation

Latitude,Latitude

LocationName,LocationName

Longitude,Longitude

PlotID,PlotID

PlotName,PlotName

ShapeOfSite,ShapeOfSite

SizeOfSite,SizeOfSite

CTFS[Veg+],VegBIEN:,Comments

SizeOfSite,/location/area,

PlotName,"/location/authorlocationcode/_alt/1/_if[@name=""if subplot""]/else",

Elevation,"/location/elevation/_alt/1/_replace:[""\bca\.?""=]/value",

ShapeOfSite,/location/locationdetermination/footprintgeometry_dwc,

Latitude,"/location/locationdetermination/latitude/_alt/2/_nullIf:[null=0,type=float]/value",

Longitude,"/location/locationdetermination/longitude/_alt/2/_nullIf:[null=0,type=float]/value",

CountryName,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",

DescriptionOfSite,/location/locationnarrative/_merge/1,

LocationName,/location/locationnarrative/_merge/1,

PlotName,"/location/parent_id/location/authorlocationcode/_if[@name=""if subplot""]/then",

PlotID,"/location/parent_id/location/sourceaccessioncode/_if[@name=""if subplot""]/then",

PlotID,"/location/sourceaccessioncode/_if[@name=""if subplot""]/else",

Put template:

<VegBIEN>

    <location id="-1">

        <area>$SizeOfSite</area>

        <authorlocationcode>$PlotName</authorlocationcode>

        <elevation>

            <_replace>

                <\bca\.?></\bca\.?>

                <value>$Elevation</value>

            </_replace>

        </elevation>

        <locationdetermination>

            <footprintgeometry_dwc>$ShapeOfSite</footprintgeometry_dwc>

            <latitude>

                <_nullIf>

                    <null>0</null>

                    <type>float</type>

                    <value>$Latitude</value>

                </_nullIf>

            </latitude>

            <longitude>

                <_nullIf>

                    <null>0</null>

                    <type>float</type>

                    <value>$Longitude</value>

                </_nullIf>

            </longitude>

            <namedplace_id>

                <_simplifyPath>

                    <next>parent_id/namedplace</next>

                    <require>placename</require>

                    <path>

                        <namedplace>

                            <rank>county</rank>

                            <parent_id>

                                <namedplace>

                                    <rank>stateProvince</rank>

                                    <parent_id>

                                        <namedplace>

                                            <rank>country</rank>

                                            <placename>$CountryName</placename>

                                        </namedplace>

                                    </parent_id>

                                </namedplace>

                            </parent_id>

                        </namedplace>

                    </path>

                </_simplifyPath>

            </namedplace_id>

        </locationdetermination>

        <locationnarrative>

            <_alt>

                <0>$DescriptionOfSite</0>

                <1>$LocationName</1>

            </_alt>

        </locationnarrative>

        <sourceaccessioncode>$PlotID</sourceaccessioncode>

    </location>

</VegBIEN>

Inserted 6 new rows into database