STEMCOUNT_ID,aggregateOrganismObservationID,,

taxonImportance_ID,OMIT#taxonImportance_ID,,Omitted because STEMCOUNT_ID is more specific

stemDiameter,diameterBreastHeight_cm,,

STEMLOCATION_ID,stemID,,

STEMLOCATION_ID,individualID,,

stemXPosition,organismX_m,,

stemYPosition,organismY_m,,

*stemdiameteraccuracy

*stemheightaccuracy

*stemtaxonarea

*stemCount_dba_src_ID

*cust_cvs_ddh

*cust_cvs_ddhAccuracy

*cust_cvs_isPlanted

*cust_cvs_subsamplingFactor

*stemCount_entry_herbLineID

*stemCount_entry_treeLineID

*entry_recordCount

*stemCount_entry_sortOrder

*stemhealth

*dba_src_ID

*cust_cvs_stemSource

*cust_cvs_stemComment

*cust_cvs_resprout

*stemLocation_entry_sortOrder

SELECT *

FROM "stemCount"

LEFT JOIN "stemLocation" USING ("STEMCOUNT_ID")

;

STEMCOUNT_ID,taxonImportance_ID,stemDiameter,stemDiameterAccuracy,stemHeight,stemHeightAccuracy,stemCount,stemTaxonArea,stemCount_dba_src_ID,cust_cvs_ddh,cust_cvs_ddhAccuracy,cust_cvs_isPlanted,cust_cvs_subsamplingFactor,stemCount_entry_herbLineID,stemCount_entry_treeLineID,entry_recordCount,stemCount_entry_sortOrder,STEMLOCATION_ID,stemCode,stemXPosition,stemYPosition,stemHealth,dba_src_ID,cust_cvs_stemSource,cust_cvs_stemComment,cust_cvs_resprout,stemLocation_entry_sortOrder

CVS,VegCore,Filter,Comments

STEMCOUNT_ID,aggregateOrganismObservationID,,

taxonImportance_ID,OMIT#taxonImportance_ID,,Omitted because STEMCOUNT_ID is more specific

stemDiameter,diameterBreastHeight_cm,,

stemDiameterAccuracy,*stemdiameteraccuracy,,

stemHeight,height_m,,

stemHeightAccuracy,*stemheightaccuracy,,

stemCount,individualCount,,

stemTaxonArea,*stemtaxonarea,,

stemCount_dba_src_ID,*stemCount_dba_src_ID,,

cust_cvs_ddh,*cust_cvs_ddh,,

cust_cvs_ddhAccuracy,*cust_cvs_ddhAccuracy,,

cust_cvs_isPlanted,*cust_cvs_isPlanted,,

cust_cvs_subsamplingFactor,*cust_cvs_subsamplingFactor,,

stemCount_entry_herbLineID,*stemCount_entry_herbLineID,,

stemCount_entry_treeLineID,*stemCount_entry_treeLineID,,

entry_recordCount,*entry_recordCount,,

stemCount_entry_sortOrder,*stemCount_entry_sortOrder,,

STEMLOCATION_ID,stemID,,

STEMLOCATION_ID,individualID,,

stemCode,authorStemCode,,

stemXPosition,organismX_m,,

stemYPosition,organismY_m,,

stemHealth,*stemhealth,,

dba_src_ID,*dba_src_ID,,

cust_cvs_stemSource,*cust_cvs_stemSource,,

cust_cvs_stemComment,*cust_cvs_stemComment,,

cust_cvs_resprout,*cust_cvs_resprout,,

stemLocation_entry_sortOrder,*stemLocation_entry_sortOrder,,

Put template:

<VegBIEN>

    <_setDefault id="-1">

        <source_id><source><shortname>CVS.new</shortname></source></source_id>

        <path>

            <_simplifyPath>

                <next>parent_id</next>

                <path>

                    <location>

                        <locationevent>

                            <locationevent fkey="parent_id">

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

                        </locationevent>

                    </location>

                </path>

            </_simplifyPath>

        </path>

    </_setDefault>

</VegBIEN>

Inserted 7 new rows into database

CVS,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/locationevent:[@fkey=parent_id]/taxonoccurrence/aggregateoccurrence/count,

STEMLOCATION_ID,/location/locationevent/locationevent:[@fkey=parent_id]/taxonoccurrence/aggregateoccurrence/plantobservation/sourceaccessioncode/_first/2,

stemCode,/location/locationevent/locationevent:[@fkey=parent_id]/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/authorstemcode,

stemDiameter,/location/locationevent/locationevent:[@fkey=parent_id]/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/diameterbreastheight_m/_cm_to_m/value,

stemHeight,/location/locationevent/locationevent:[@fkey=parent_id]/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/height_m,

STEMLOCATION_ID,/location/locationevent/locationevent:[@fkey=parent_id]/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/sourceaccessioncode,

stemXPosition,/location/locationevent/locationevent:[@fkey=parent_id]/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/xposition_m,

stemYPosition,/location/locationevent/locationevent:[@fkey=parent_id]/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/yposition_m,

STEMCOUNT_ID,/location/locationevent/locationevent:[@fkey=parent_id]/taxonoccurrence/aggregateoccurrence/sourceaccessioncode,

STEMLOCATION_ID,"/location/locationevent/locationevent:[@fkey=parent_id]/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/1/_if[@name=""if individual""]/cond/_exists",

STEMLOCATION_ID,"/location/locationevent/locationevent:[@fkey=parent_id]/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",

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

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

cust_cvs_ddh,,** No join mapping for *cust_cvs_ddh ** 

cust_cvs_ddhAccuracy,,** No join mapping for *cust_cvs_ddhAccuracy ** 

cust_cvs_isPlanted,,** No join mapping for *cust_cvs_isPlanted ** 

cust_cvs_resprout,,** No join mapping for *cust_cvs_resprout ** 

cust_cvs_stemComment,,** No join mapping for *cust_cvs_stemComment ** 

cust_cvs_stemSource,,** No join mapping for *cust_cvs_stemSource ** 

cust_cvs_subsamplingFactor,,** No join mapping for *cust_cvs_subsamplingFactor ** 

dba_src_ID,,** No join mapping for *dba_src_ID ** 

entry_recordCount,,** No join mapping for *entry_recordCount ** 

stemCount_dba_src_ID,,** No join mapping for *stemCount_dba_src_ID ** 

stemCount_entry_herbLineID,,** No join mapping for *stemCount_entry_herbLineID ** 

stemCount_entry_sortOrder,,** No join mapping for *stemCount_entry_sortOrder ** 

stemCount_entry_treeLineID,,** No join mapping for *stemCount_entry_treeLineID ** 

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

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

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

stemLocation_entry_sortOrder,,** No join mapping for *stemLocation_entry_sortOrder ** 

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

taxonImportance_ID,,** No non-empty join mapping for OMIT#taxonImportance_ID ** Omitted because STEMCOUNT_ID is more specific

stemLocation_