NVS,VegCore,Filter,Comments

Plot Obs ID,*Plot Obs ID,,

Project Abbreviation,projectName,,

Plot,locationName,,

Method,*Method,,

Type,*Type,,

XEast Long,verbatimCoordinates,"/_join/2/_label[label=""x""]/value",

XPrecision,*XPrecision,,

YNorth Lat,verbatimCoordinates,"/_join/3/_label[label=""y""]/value",

Precision,coordinateUncertaintyInMeters,,Units is always m

Units,*Units,,

Datum,verbatimCoordinates,/_join/1,

Map Projection,*Map Projection,,

Map Series,*Map Series,,

Map Sheet,*Map Sheet,,

GPS,*GPS,,

GPSFix,*GPSFix,,

GPSPosition,*GPSPosition,,

NVS,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments

Plot,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/1",

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

Project Abbreviation,/location/locationevent/*_id/project/projectname,

Plot,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/authorlocationcode/_if[@name=""if subplot""]/then",

Plot,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",

Precision,/location/locationplace/*_id/place/*_id/coordinates/coordsaccuracy_m/_noCV/value,Units is always m

Datum,/location/locationplace/*_id/place/*_id/coordinates/verbatimcoordinates/_join/1,

XEast Long,"/location/locationplace/*_id/place/*_id/coordinates/verbatimcoordinates/_join/2/_label[label=""x""]/value",

YNorth Lat,"/location/locationplace/*_id/place/*_id/coordinates/verbatimcoordinates/_join/3/_label[label=""y""]/value",

Plot,"/location/sourceaccessioncode/_join/1/_if[@name=""if subplot and unique only within parent""]/then/_first/2",

GPS,,** No join mapping for *GPS ** 

GPSFix,,** No join mapping for *GPSFix ** 

GPSPosition,,** No join mapping for *GPSPosition ** 

Map Projection,,** No join mapping for *Map Projection ** 

Map Series,,** No join mapping for *Map Series ** 

Map Sheet,,** No join mapping for *Map Sheet ** 

Method,,** No join mapping for *Method ** 

Plot Obs ID,,** No join mapping for *Plot Obs ID ** 

Type,,** No join mapping for *Type ** 

Units,,** No join mapping for *Units ** 

XPrecision,,** No join mapping for *XPrecision ** 

Put template:

<VegBIEN>

    <_setDefault id="-1">

        <source_id><source><shortname>NVS</shortname></source></source_id>

        <path>

            <_simplifyPath>

                <next>parent_id</next>

                <path>

                    <location>

                        <authorlocationcode>$Plot</authorlocationcode>

                        <locationevent><project_id><project><projectname>$Project Abbreviation</projectname></project></project_id></locationevent>

                        <locationplace>

                            <place_id>

                                <place>

                                    <coordinates_id>

                                        <coordinates>

                                            <coordsaccuracy_m><_noCV><value>$Precision</value></_noCV></coordsaccuracy_m>

                                            <verbatimcoordinates>

                                                <_join>

                                                    <1>$Datum</1>

                                                    <2>

                                                        <_label>

                                                            <label>x</label>

                                                            <value>$XEast Long</value>

                                                        </_label>

                                                    </2>

                                                    <3>

                                                        <_label>

                                                            <label>y</label>

                                                            <value>$YNorth Lat</value>

                                                        </_label>

                                                    </3>

                                                </_join>

                                            </verbatimcoordinates>

                                        </coordinates>

                                    </coordinates_id>

                                </place>

                            </place_id>

                        </locationplace>

                    </location>

                </path>

            </_simplifyPath>

        </path>

    </_setDefault>

</VegBIEN>

Inserted 6 new rows into database

Project Abbreviation,projectName,,

Plot,locationName,,

XEast Long,verbatimCoordinates,"/_join/2/_label[label=""x""]/value",

YNorth Lat,verbatimCoordinates,"/_join/3/_label[label=""y""]/value",

Precision,coordinateUncertaintyInMeters,,Units is always m

Datum,verbatimCoordinates,/_join/1,

*Plot Obs ID

*Method

*Type

*XPrecision

*Units

*Map Projection

*Map Series

*Map Sheet

*GPS

*GPSFix

*GPSPosition