stemcount_id,taxonimportance_id,stemdiameter,stemdiameteraccuracy,stemheight,stemheightaccuracy,stemcount,stemtaxonarea,emb_stemcount

VegBank,VegCore,Filter,Comments

stemcount_id,individualID,,

taxonimportance_id,taxonOccurrenceID,,

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,,"""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,stemCount,,

stemtaxonarea,stemtaxonarea,,

emb_stemcount,emb_stemcount,,

VegBank,VegBIEN:/_simplifyPath:[next=parent_id]/path,Comments

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

stemcount,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemcount,

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>)"

taxonimportance_id,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/1,

stemcount_id,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/2,

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

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

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

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

Put template:

<VegBIEN>

    <_simplifyPath id="-1">

        <next>parent_id</next>

        <path>

            <location>

                <locationevent>

                    <taxonoccurrence>

                        <aggregateoccurrence>

                            <plantobservation>

                                <sourceaccessioncode>$stemcount_id</sourceaccessioncode>

                                <stemcount>$stemcount</stemcount>

                                <stemobservation>

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

                                    <height_m>$stemheight</height_m>

                                </stemobservation>

                            </plantobservation>

                        </aggregateoccurrence>

                        <sourceaccessioncode>$taxonimportance_id</sourceaccessioncode>

                    </taxonoccurrence>

                </locationevent>

            </location>

        </path>

    </_simplifyPath>

</VegBIEN>

Inserted 5 new rows into database

stemcount_id,individualID,,

taxonimportance_id,taxonOccurrenceID,,

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,,"""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>)"

stemdiameteraccuracy

stemheightaccuracy

stemtaxonarea

emb_stemcount

taxonimportance

stemcount