NVS,VegCore,Filter,Comments

Plot,*Plot,,

Sub Plot,subplot,,

Area,*Area_Ha,,

Area Units,*Area Units,,

Altitude,elevationInMeters,,

Altitude Units,*Altitude Units,,

Aspect,*Aspect,,

Slope,slopeAspect,,

Slope Shape,*Slope Shape,,

Parent Material,*Parent Material,,

Physiography,*Physiography,,

Placement,*Placement,,

Permanence,*Permanence,,

Plot ID,locationID,,

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

Sub Plot,"/location/_if[@name=""if subplot""]/cond/_exists",

Plot ID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/2/_if[@name=""if locationID""]/cond/_exists",

Plot ID,"/location/_if[@name=""if subplot""]/else/sourceaccessioncode/_if[@name=""if geovalidation""]/else",

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

Sub Plot,/location/authorlocationcode,

Altitude,/location/elevation_m/_alt/1,

Sub Plot,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists",

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

Sub Plot,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode/_if[@name=""if subplot""]/cond/_first/2",

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

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

Slope,/location/slopeaspect_deg/_alt/1/_compass/value,

Sub Plot,"/location/sourceaccessioncode/_join/1/_if[@name=""if subplot and unique only within parent""]/cond/_exists",

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

Sub Plot,/location/sourceaccessioncode/_join/2,

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

Area,,** No join mapping for *Area_Ha ** 

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

Aspect,,** No join mapping for *Aspect ** 

Parent Material,,** No join mapping for *Parent Material ** 

Permanence,,** No join mapping for *Permanence ** 

Physiography,,** No join mapping for *Physiography ** 

Placement,,** No join mapping for *Placement ** 

Plot,,** No join mapping for *Plot ** 

Slope Shape,,** No join mapping for *Slope Shape ** 

Put template:

<VegBIEN>

    <_setDefault id="-1">

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

        <path>

            <_simplifyPath>

                <next>parent_id</next>

                <path>

                    <location>

                        <parent_id><location><sourceaccessioncode>$Plot ID</sourceaccessioncode></location></parent_id>

                        <authorlocationcode>$Sub Plot</authorlocationcode>

                        <elevation_m>$Altitude</elevation_m>

                        <slopeaspect_deg><_compass><value>$Slope</value></_compass></slopeaspect_deg>

                        <sourceaccessioncode>

                            <_join>

                                <1>$Plot ID</1>

                                <2>$Sub Plot</2>

                            </_join>

                        </sourceaccessioncode>

                    </location>

                </path>

            </_simplifyPath>

        </path>

    </_setDefault>

</VegBIEN>

Inserted 3 new rows into database

Area,*Area_Ha,,

Altitude,elevationInMeters,,

Slope,slopeAspect,,

*Plot

*Area_Ha

*Area Units

*Altitude Units

*Aspect

*Slope Shape

*Parent Material

*Physiography

*Placement

*Permanence