stemlocation_

stemcount_id,taxonimportance_id,stemdiameter,stemdiameteraccuracy,stemheight,stemheightaccuracy,stemcount,stemtaxonarea,emb_stemcount,stemlocation_id,stemcode,stemxposition,stemyposition,stemhealth,emb_stemlocation

VegBank,VegCore,Filter,Comments

stemcount_id,aggregateOccurrenceID,,

taxonimportance_id,OMIT,,Omitted because stemcount_id is more specific

stemdiameter,diameterBreastHeight_cm,,"""The diameter of the stem in centimeters"" (stemDiameter definition at <http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=stemcount&entity=dba_tabledescription&where=where_tablename>)"

stemdiameteraccuracy,*stemdiameteraccuracy,,

stemheight,height_m,,"""The measured height of the stem in meters"" (stemHeight definition at <http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=stemcount&entity=dba_tabledescription&where=where_tablename>)"

stemheightaccuracy,*stemheightaccuracy,,

stemcount,individualCount,,

stemtaxonarea,*stemtaxonarea,,

emb_stemcount,*emb_stemcount,,

stemlocation_id,stemID,,

stemlocation_id,individualID,,

stemcode,authorStemCode,,

stemxposition,organismX_m,,"""The X-coordinate of the stem position in m"" (stemXPosition definition at <http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=stemlocation&entity=dba_tabledescription&where=where_tablename>)"

stemyposition,organismY_m,,"""The Y-coordinate of the stem position, as above"" (stemYPosition definition at <http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=stemlocation&entity=dba_tabledescription&where=where_tablename>)"

stemhealth,*stemhealth,,

emb_stemlocation,*emb_stemlocation,,

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

stemlocation_id,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",

stemcount,/location/locationevent/taxonoccurrence/aggregateoccurrence/count,

stemlocation_id,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/sourceaccessioncode,

stemcode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/authorstemcode,

stemdiameter,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/diameterbreastheight_m/_cm_to_m/value,"""The diameter of the stem in centimeters"" (stemDiameter definition at <http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=stemcount&entity=dba_tabledescription&where=where_tablename>)"

stemheight,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/height_m,"""The measured height of the stem in meters"" (stemHeight definition at <http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=stemcount&entity=dba_tabledescription&where=where_tablename>)"

stemlocation_id,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/sourceaccessioncode,

stemxposition,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/xposition_m,"""The X-coordinate of the stem position in m"" (stemXPosition definition at <http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=stemlocation&entity=dba_tabledescription&where=where_tablename>)"

stemyposition,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/yposition_m,"""The Y-coordinate of the stem position, as above"" (stemYPosition definition at <http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=stemlocation&entity=dba_tabledescription&where=where_tablename>)"

stemcount_id,/location/locationevent/taxonoccurrence/aggregateoccurrence/sourceaccessioncode,

stemlocation_id,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",

stemcount_id,"/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/2/_if[@name=""if organism in AggregateOccurrence""]/cond/_exists",

stemlocation_id,"/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/2/_if[@name=""if organism in AggregateOccurrence""]/else",

emb_stemcount,,** No join mapping for *emb_stemcount ** 

emb_stemlocation,,** No join mapping for *emb_stemlocation ** 

stemdiameteraccuracy,,** No join mapping for *stemdiameteraccuracy ** 

stemhealth,,** No join mapping for *stemhealth ** 

stemheightaccuracy,,** No join mapping for *stemheightaccuracy ** 

stemtaxonarea,,** No join mapping for *stemtaxonarea ** 

taxonimportance_id,,** No non-empty join mapping for OMIT ** Omitted because stemcount_id is more specific

Put template:

<VegBIEN>

    <_setDefault id="-1">

        <source_id><source><shortname>VegBank</shortname></source></source_id>

        <path>

            <_simplifyPath>

                <next>parent_id</next>

                <path>

                    <location>

                        <locationevent>

                            <taxonoccurrence>

                                <aggregateoccurrence>

                                    <count>$stemcount</count>

                                    <plantobservation>

                                        <sourceaccessioncode>$stemlocation_id</sourceaccessioncode>

                                        <stemobservation>

                                            <authorstemcode>$stemcode</authorstemcode>

                                            <diameterbreastheight_m><_cm_to_m><value>$stemdiameter</value></_cm_to_m></diameterbreastheight_m>

                                            <height_m>$stemheight</height_m>

                                            <sourceaccessioncode>$stemlocation_id</sourceaccessioncode>

                                            <xposition_m>$stemxposition</xposition_m>

                                            <yposition_m>$stemyposition</yposition_m>

                                        </stemobservation>

                                    </plantobservation>

                                    <sourceaccessioncode>$stemcount_id</sourceaccessioncode>

                                </aggregateoccurrence>

                            </taxonoccurrence>

                        </locationevent>

                    </location>

                </path>

            </_simplifyPath>

        </path>

    </_setDefault>

</VegBIEN>

Inserted 7 new rows into database

stemcount_id,aggregateOccurrenceID,,

taxonimportance_id,OMIT,,Omitted because stemcount_id is more specific

stemdiameter,diameterBreastHeight_cm,,"""The diameter of the stem in centimeters"" (stemDiameter definition at <http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=stemcount&entity=dba_tabledescription&where=where_tablename>)"

stemheight,height_m,,"""The measured height of the stem in meters"" (stemHeight definition at <http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=stemcount&entity=dba_tabledescription&where=where_tablename>)"

stemlocation_id,stemID,,

stemlocation_id,individualID,,

stemcode,authorStemCode,,

stemxposition,organismX_m,,"""The X-coordinate of the stem position in m"" (stemXPosition definition at <http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=stemlocation&entity=dba_tabledescription&where=where_tablename>)"

stemyposition,organismY_m,,"""The Y-coordinate of the stem position, as above"" (stemYPosition definition at <http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=stemlocation&entity=dba_tabledescription&where=where_tablename>)"

*stemdiameteraccuracy

*stemheightaccuracy

*stemtaxonarea

*emb_stemcount

*stemhealth

*emb_stemlocation