SELECT

DISTINCT ON ("PLT_CN")

*

FROM "FIA_COND"

;

ALTER TABLE :table ADD PRIMARY KEY ("PLT_CN");

--ALTER TABLE :table ADD COLUMN oldgrowth boolean;

ALTER TABLE :table ALTER COLUMN oldgrowth TYPE boolean

USING

(

"STDAGE">80 

AND ("TRTCD1"='0' OR "TRTCD1" IS NULL)

AND (("DSTRBCD1"<>'30' AND "DSTRBCD1"<>'31' AND "DSTRBCD1"<>'32' AND "DSTRBCD1"<>'80') OR "DSTRBCD1" IS NULL)

AND ("STUMP_CD_PNWRS"='N' OR "STUMP_CD_PNWRS" IS NULL)

AND "HARVEST_TYPE1_SRS" IS NULL

AND "PRESNFCD" IS NULL

AND ("STDORGCD"=0 OR "STDORGCD" IS NULL)

)

OR "STND_COND_CD_PNWRS"='7'

;

CN,PLT_CN,INVYR,STATECD,UNITCD,COUNTYCD,PLOT,CONDID,COND_STATUS_CD,COND_NONSAMPLE_REASN_CD,RESERVCD,OWNCD,OWNGRPCD,FORINDCD,ADFORCD,FORTYPCD,FLDTYPCD,MAPDEN,STDAGE,STDSZCD,FLDSZCD,SITECLCD,SICOND,SIBASE,SISP,STDORGCD,STDORGSP,PROP_BASIS,CONDPROP_UNADJ,MICRPROP_UNADJ,SUBPPROP_UNADJ,MACRPROP_UNADJ,SLOPE,ASPECT,PHYSCLCD,GSSTKCD,ALSTKCD,DSTRBCD1,DSTRBYR1,DSTRBCD2,DSTRBYR2,DSTRBCD3,DSTRBYR3,TRTCD1,TRTYR1,TRTCD2,TRTYR2,TRTCD3,TRTYR3,PRESNFCD,BALIVE,FLDAGE,ALSTK,GSSTK,FORTYPCDCALC,HABTYPCD1,HABTYPCD1_PUB_CD,HABTYPCD1_DESCR_PUB_CD,HABTYPCD2,HABTYPCD2_PUB_CD,HABTYPCD2_DESCR_PUB_CD,MIXEDCONFCD,VOL_LOC_GRP,SITECLCDEST,SITETREE_TREE,SITECL_METHOD,CARBON_DOWN_DEAD,CARBON_LITTER,CARBON_SOIL_ORG,CARBON_STANDING_DEAD,CARBON_UNDERSTORY_AG,CARBON_UNDERSTORY_BG,CREATED_BY,CREATED_DATE,CREATED_IN_INSTANCE,MODIFIED_BY,MODIFIED_DATE,MODIFIED_IN_INSTANCE,CYCLE,SUBCYCLE,SOIL_ROOTING_DEPTH_PNW,GROUND_LAND_CLASS_PNW,PLANT_STOCKABILITY_FACTOR_PNW,STND_COND_CD_PNWRS,STND_STRUC_CD_PNWRS,STUMP_CD_PNWRS,FIRE_SRS,GRAZING_SRS,HARVEST_TYPE1_SRS,HARVEST_TYPE2_SRS,HARVEST_TYPE3_SRS,LAND_USE_SRS,OPERABILITY_SRS,STAND_STRUCTURE_SRS,oldgrowth,Index_CN_index,Index_PLT_CN_index,Index_4_index,Index_5_index,Index_6_index,Index_7_index,Index_oldgrowth_index

FIA,VegCore,Filter,Comments

CN,*CN,,

PLT_CN,locationID,,

INVYR,*INVYR,,

STATECD,*STATECD,,

UNITCD,*UNITCD,,

COUNTYCD,*COUNTYCD,,

PLOT,locationName,,

CONDID,authorEventCode,,

COND_STATUS_CD,*COND_STATUS_CD,,

COND_NONSAMPLE_REASN_CD,*COND_NONSAMPLE_REASN_CD,,

RESERVCD,*RESERVCD,,

OWNCD,*OWNCD,,

OWNGRPCD,*OWNGRPCD,,

FORINDCD,*FORINDCD,,

ADFORCD,*ADFORCD,,

FORTYPCD,*FORTYPCD,,

FLDTYPCD,*FLDTYPCD,,

MAPDEN,*MAPDEN,,

STDAGE,*STDAGE,,

STDSZCD,*STDSZCD,,

FLDSZCD,*FLDSZCD,,

SITECLCD,*SITECLCD,,

SICOND,*SICOND,,

SIBASE,*SIBASE,,

SISP,*SISP,,

STDORGCD,*STDORGCD,,

STDORGSP,*STDORGSP,,

PROP_BASIS,*PROP_BASIS,,

CONDPROP_UNADJ,*CONDPROP_UNADJ,,

MICRPROP_UNADJ,*MICRPROP_UNADJ,,

SUBPPROP_UNADJ,*SUBPPROP_UNADJ,,

MACRPROP_UNADJ,*MACRPROP_UNADJ,,

SLOPE,*SLOPE,,

ASPECT,*ASPECT,,

PHYSCLCD,*PHYSCLCD,,

GSSTKCD,*GSSTKCD,,

ALSTKCD,*ALSTKCD,,

DSTRBCD1,*DSTRBCD1,,

DSTRBYR1,*DSTRBYR1,,

DSTRBCD2,*DSTRBCD2,,

DSTRBYR2,*DSTRBYR2,,

DSTRBCD3,*DSTRBCD3,,

DSTRBYR3,*DSTRBYR3,,

TRTCD1,*TRTCD1,,

TRTYR1,*TRTYR1,,

TRTCD2,*TRTCD2,,

TRTYR2,*TRTYR2,,

TRTCD3,*TRTCD3,,

TRTYR3,*TRTYR3,,

PRESNFCD,*PRESNFCD,,

BALIVE,*BALIVE,,

FLDAGE,*FLDAGE,,

ALSTK,*ALSTK,,

GSSTK,*GSSTK,,

FORTYPCDCALC,*FORTYPCDCALC,,

HABTYPCD1,*HABTYPCD1,,

HABTYPCD1_PUB_CD,*HABTYPCD1_PUB_CD,,

HABTYPCD1_DESCR_PUB_CD,*HABTYPCD1_DESCR_PUB_CD,,

HABTYPCD2,*HABTYPCD2,,

HABTYPCD2_PUB_CD,*HABTYPCD2_PUB_CD,,

HABTYPCD2_DESCR_PUB_CD,*HABTYPCD2_DESCR_PUB_CD,,

MIXEDCONFCD,*MIXEDCONFCD,,

VOL_LOC_GRP,*VOL_LOC_GRP,,

SITECLCDEST,*SITECLCDEST,,

SITETREE_TREE,*SITETREE_TREE,,

SITECL_METHOD,*SITECL_METHOD,,

CARBON_DOWN_DEAD,*CARBON_DOWN_DEAD,,

CARBON_LITTER,*CARBON_LITTER,,

CARBON_SOIL_ORG,*CARBON_SOIL_ORG,,

CARBON_STANDING_DEAD,*CARBON_STANDING_DEAD,,

CARBON_UNDERSTORY_AG,*CARBON_UNDERSTORY_AG,,

CARBON_UNDERSTORY_BG,*CARBON_UNDERSTORY_BG,,

CREATED_BY,*CREATED_BY,,

CREATED_DATE,*CREATED_DATE,,

CREATED_IN_INSTANCE,*CREATED_IN_INSTANCE,,

MODIFIED_BY,*MODIFIED_BY,,

MODIFIED_DATE,*MODIFIED_DATE,,

MODIFIED_IN_INSTANCE,*MODIFIED_IN_INSTANCE,,

CYCLE,*CYCLE,,

SUBCYCLE,*SUBCYCLE,,

SOIL_ROOTING_DEPTH_PNW,*SOIL_ROOTING_DEPTH_PNW,,

GROUND_LAND_CLASS_PNW,*GROUND_LAND_CLASS_PNW,,

PLANT_STOCKABILITY_FACTOR_PNW,*PLANT_STOCKABILITY_FACTOR_PNW,,

STND_COND_CD_PNWRS,*STND_COND_CD_PNWRS,,

STND_STRUC_CD_PNWRS,*STND_STRUC_CD_PNWRS,,

STUMP_CD_PNWRS,*STUMP_CD_PNWRS,,

FIRE_SRS,*FIRE_SRS,,

GRAZING_SRS,*GRAZING_SRS,,

HARVEST_TYPE1_SRS,*HARVEST_TYPE1_SRS,,

HARVEST_TYPE2_SRS,*HARVEST_TYPE2_SRS,,

HARVEST_TYPE3_SRS,*HARVEST_TYPE3_SRS,,

LAND_USE_SRS,*LAND_USE_SRS,,

OPERABILITY_SRS,*OPERABILITY_SRS,,

STAND_STRUCTURE_SRS,*STAND_STRUCTURE_SRS,,

oldgrowth,oldGrowth,,

Index_CN_index,*Index_CN_index,,

Index_PLT_CN_index,*Index_PLT_CN_index,,

Index_4_index,*Index_4_index,,

Index_5_index,*Index_5_index,,

Index_6_index,*Index_6_index,,

Index_7_index,*Index_7_index,,

Index_oldgrowth_index,*Index_oldgrowth_index,,

Put template:

<VegBIEN>

    <_setDefault id="-1">

        <source_id><source><shortname>FIA</shortname></source></source_id>

        <path>

            <_simplifyPath>

                <next>parent_id</next>

                <path>

                    <location>

                        <authorlocationcode>$PLOT</authorlocationcode>

                        <sourceaccessioncode>$PLT_CN</sourceaccessioncode>

                        <iscultivated><_not><value>$oldgrowth</value></_not></iscultivated>

                        <locationevent><authoreventcode>$CONDID</authoreventcode></locationevent>

                    </location>

                </path>

            </_simplifyPath>

        </path>

    </_setDefault>

</VegBIEN>

Inserted 5 new rows into database

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

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

CONDID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/2/_if[@name=""if locationID""]/else",

PLT_CN,"/location/_if[@name=""if subplot""]/else/sourceaccessioncode",

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

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

oldgrowth,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/else/_alt/1/_not/value",

CONDID,"/location/locationevent/_if[@name=""if subplot""]/else/authoreventcode",

CONDID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/cond/_exists",

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

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

CONDID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/authoreventcode",

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

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

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

oldgrowth,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/then/_alt/1/_not/value",

PLT_CN,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/cond/_exists",

PLT_CN,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/1",

ADFORCD,,** No join mapping for *ADFORCD ** 

ALSTK,,** No join mapping for *ALSTK ** 

ALSTKCD,,** No join mapping for *ALSTKCD ** 

ASPECT,,** No join mapping for *ASPECT ** 

BALIVE,,** No join mapping for *BALIVE ** 

CARBON_DOWN_DEAD,,** No join mapping for *CARBON_DOWN_DEAD ** 

CARBON_LITTER,,** No join mapping for *CARBON_LITTER ** 

CARBON_SOIL_ORG,,** No join mapping for *CARBON_SOIL_ORG ** 

CARBON_STANDING_DEAD,,** No join mapping for *CARBON_STANDING_DEAD ** 

CARBON_UNDERSTORY_AG,,** No join mapping for *CARBON_UNDERSTORY_AG ** 

CARBON_UNDERSTORY_BG,,** No join mapping for *CARBON_UNDERSTORY_BG ** 

CN,,** No join mapping for *CN ** 

CONDPROP_UNADJ,,** No join mapping for *CONDPROP_UNADJ ** 

COND_NONSAMPLE_REASN_CD,,** No join mapping for *COND_NONSAMPLE_REASN_CD ** 

COND_STATUS_CD,,** No join mapping for *COND_STATUS_CD ** 

COUNTYCD,,** No join mapping for *COUNTYCD ** 

CREATED_BY,,** No join mapping for *CREATED_BY ** 

CREATED_DATE,,** No join mapping for *CREATED_DATE ** 

CREATED_IN_INSTANCE,,** No join mapping for *CREATED_IN_INSTANCE ** 

CYCLE,,** No join mapping for *CYCLE ** 

DSTRBCD1,,** No join mapping for *DSTRBCD1 ** 

DSTRBCD2,,** No join mapping for *DSTRBCD2 ** 

DSTRBCD3,,** No join mapping for *DSTRBCD3 ** 

DSTRBYR1,,** No join mapping for *DSTRBYR1 ** 

DSTRBYR2,,** No join mapping for *DSTRBYR2 ** 

DSTRBYR3,,** No join mapping for *DSTRBYR3 ** 

FIRE_SRS,,** No join mapping for *FIRE_SRS ** 

FLDAGE,,** No join mapping for *FLDAGE ** 

FLDSZCD,,** No join mapping for *FLDSZCD ** 

FLDTYPCD,,** No join mapping for *FLDTYPCD ** 

FORINDCD,,** No join mapping for *FORINDCD ** 

FORTYPCD,,** No join mapping for *FORTYPCD ** 

FORTYPCDCALC,,** No join mapping for *FORTYPCDCALC ** 

GRAZING_SRS,,** No join mapping for *GRAZING_SRS ** 

GROUND_LAND_CLASS_PNW,,** No join mapping for *GROUND_LAND_CLASS_PNW ** 

GSSTK,,** No join mapping for *GSSTK ** 

GSSTKCD,,** No join mapping for *GSSTKCD ** 

HABTYPCD1,,** No join mapping for *HABTYPCD1 ** 

HABTYPCD1_DESCR_PUB_CD,,** No join mapping for *HABTYPCD1_DESCR_PUB_CD ** 

HABTYPCD1_PUB_CD,,** No join mapping for *HABTYPCD1_PUB_CD ** 

HABTYPCD2,,** No join mapping for *HABTYPCD2 ** 

HABTYPCD2_DESCR_PUB_CD,,** No join mapping for *HABTYPCD2_DESCR_PUB_CD ** 

HABTYPCD2_PUB_CD,,** No join mapping for *HABTYPCD2_PUB_CD ** 

HARVEST_TYPE1_SRS,,** No join mapping for *HARVEST_TYPE1_SRS ** 

HARVEST_TYPE2_SRS,,** No join mapping for *HARVEST_TYPE2_SRS ** 

HARVEST_TYPE3_SRS,,** No join mapping for *HARVEST_TYPE3_SRS ** 

INVYR,,** No join mapping for *INVYR ** 

Index_4_index,,** No join mapping for *Index_4_index ** 

Index_5_index,,** No join mapping for *Index_5_index ** 

Index_6_index,,** No join mapping for *Index_6_index ** 

Index_7_index,,** No join mapping for *Index_7_index ** 

Index_CN_index,,** No join mapping for *Index_CN_index ** 

Index_PLT_CN_index,,** No join mapping for *Index_PLT_CN_index ** 

Index_oldgrowth_index,,** No join mapping for *Index_oldgrowth_index ** 

LAND_USE_SRS,,** No join mapping for *LAND_USE_SRS ** 

MACRPROP_UNADJ,,** No join mapping for *MACRPROP_UNADJ ** 

MAPDEN,,** No join mapping for *MAPDEN ** 

MICRPROP_UNADJ,,** No join mapping for *MICRPROP_UNADJ ** 

MIXEDCONFCD,,** No join mapping for *MIXEDCONFCD ** 

MODIFIED_BY,,** No join mapping for *MODIFIED_BY ** 

MODIFIED_DATE,,** No join mapping for *MODIFIED_DATE ** 

MODIFIED_IN_INSTANCE,,** No join mapping for *MODIFIED_IN_INSTANCE ** 

OPERABILITY_SRS,,** No join mapping for *OPERABILITY_SRS ** 

OWNCD,,** No join mapping for *OWNCD ** 

OWNGRPCD,,** No join mapping for *OWNGRPCD ** 

PHYSCLCD,,** No join mapping for *PHYSCLCD ** 

PLANT_STOCKABILITY_FACTOR_PNW,,** No join mapping for *PLANT_STOCKABILITY_FACTOR_PNW ** 

PRESNFCD,,** No join mapping for *PRESNFCD ** 

PROP_BASIS,,** No join mapping for *PROP_BASIS ** 

RESERVCD,,** No join mapping for *RESERVCD ** 

SIBASE,,** No join mapping for *SIBASE ** 

SICOND,,** No join mapping for *SICOND ** 

SISP,,** No join mapping for *SISP ** 

SITECLCD,,** No join mapping for *SITECLCD ** 

SITECLCDEST,,** No join mapping for *SITECLCDEST ** 

SITECL_METHOD,,** No join mapping for *SITECL_METHOD ** 

SITETREE_TREE,,** No join mapping for *SITETREE_TREE ** 

SLOPE,,** No join mapping for *SLOPE ** 

SOIL_ROOTING_DEPTH_PNW,,** No join mapping for *SOIL_ROOTING_DEPTH_PNW ** 

STAND_STRUCTURE_SRS,,** No join mapping for *STAND_STRUCTURE_SRS ** 

STATECD,,** No join mapping for *STATECD ** 

STDAGE,,** No join mapping for *STDAGE ** 

STDORGCD,,** No join mapping for *STDORGCD ** 

STDORGSP,,** No join mapping for *STDORGSP ** 

STDSZCD,,** No join mapping for *STDSZCD ** 

STND_COND_CD_PNWRS,,** No join mapping for *STND_COND_CD_PNWRS ** 

STND_STRUC_CD_PNWRS,,** No join mapping for *STND_STRUC_CD_PNWRS ** 

STUMP_CD_PNWRS,,** No join mapping for *STUMP_CD_PNWRS ** 

SUBCYCLE,,** No join mapping for *SUBCYCLE ** 

SUBPPROP_UNADJ,,** No join mapping for *SUBPPROP_UNADJ ** 

TRTCD1,,** No join mapping for *TRTCD1 ** 

TRTCD2,,** No join mapping for *TRTCD2 ** 

TRTCD3,,** No join mapping for *TRTCD3 ** 

TRTYR1,,** No join mapping for *TRTYR1 ** 

TRTYR2,,** No join mapping for *TRTYR2 ** 

TRTYR3,,** No join mapping for *TRTYR3 ** 

UNITCD,,** No join mapping for *UNITCD ** 

VOL_LOC_GRP,,** No join mapping for *VOL_LOC_GRP ** 

PLT_CN,locationID,,

PLOT,locationName,,

CONDID,authorEventCode,,

*CN

*INVYR

*STATECD

*UNITCD

*COUNTYCD

*COND_STATUS_CD

*COND_NONSAMPLE_REASN_CD

*RESERVCD

*OWNCD

*OWNGRPCD

*FORINDCD

*ADFORCD

*FORTYPCD

*FLDTYPCD

*MAPDEN

*STDAGE

*STDSZCD

*FLDSZCD

*SITECLCD

*SICOND

*SIBASE

*SISP

*STDORGCD

*STDORGSP

*PROP_BASIS

*CONDPROP_UNADJ

*MICRPROP_UNADJ

*SUBPPROP_UNADJ

*MACRPROP_UNADJ

*SLOPE

*ASPECT

*PHYSCLCD

*GSSTKCD

*ALSTKCD

*DSTRBCD1

*DSTRBYR1

*DSTRBCD2

*DSTRBYR2

*DSTRBCD3

*DSTRBYR3

*TRTCD1

*TRTYR1

*TRTCD2

*TRTYR2

*TRTCD3

*TRTYR3

*PRESNFCD

*BALIVE

*FLDAGE

*ALSTK

*GSSTK

*FORTYPCDCALC

*HABTYPCD1

*HABTYPCD1_PUB_CD

*HABTYPCD1_DESCR_PUB_CD

*HABTYPCD2

*HABTYPCD2_PUB_CD

*HABTYPCD2_DESCR_PUB_CD

*MIXEDCONFCD

*VOL_LOC_GRP

*SITECLCDEST

*SITETREE_TREE

*SITECL_METHOD

*CARBON_DOWN_DEAD

*CARBON_LITTER

*CARBON_SOIL_ORG

*CARBON_STANDING_DEAD

*CARBON_UNDERSTORY_AG

*CARBON_UNDERSTORY_BG

*CREATED_BY

*CREATED_DATE

*CREATED_IN_INSTANCE

*MODIFIED_BY

*MODIFIED_DATE

*MODIFIED_IN_INSTANCE

*CYCLE

*SUBCYCLE

*SOIL_ROOTING_DEPTH_PNW

*GROUND_LAND_CLASS_PNW

*PLANT_STOCKABILITY_FACTOR_PNW

*STND_COND_CD_PNWRS

*STND_STRUC_CD_PNWRS

*STUMP_CD_PNWRS

*FIRE_SRS

*GRAZING_SRS

*HARVEST_TYPE1_SRS

*HARVEST_TYPE2_SRS

*HARVEST_TYPE3_SRS

*LAND_USE_SRS

*OPERABILITY_SRS

*STAND_STRUCTURE_SRS

*Index_CN_index

*Index_PLT_CN_index

*Index_4_index

*Index_5_index

*Index_6_index

*Index_7_index

*Index_oldgrowth_index

FIA,VegCore,Filter,Comments

TreeTag,tag,,

Genus,genus,,

SpecificEpithet,specificEpithet,,

MeasYear,yearCollected,,

MeasMon,monthCollected,,

MeasDay,dayCollected,,

DecimalLatitude,decimalLatitude,,

DecimalLongitude,decimalLongitude,,

PlotCD,locationID,,

StateProvince,stateProvince,,

County,county,,

DBH,diameterBreastHeight_in,,Assuming units based on the range and precision of values and location inside the U.S.

HOM,*HOM,,

BasalDiameter,basalDiameter_in,,Assuming units are the same as for DBH because the values are similar and they measure the same dimension

Height,height_ft,,"Assuming units based on the range of values, the height of the tallest tree [1], and location inside the U.S.

[1] ""The tallest living tree is believed to be a coast redwood [which] is 115.66 metres (379.5 ft) tall"" (http://en.wikipedia.org/wiki/Tree#Superlative_trees)"

Put template:

<VegBIEN>

    <_setDefault id="-1">

        <source_id><source><shortname>FIA</shortname></source></source_id>

        <path>

            <_simplifyPath>

                <next>parent_id</next>

                <path>

                    <location>

                        <sourceaccessioncode>$PlotCD</sourceaccessioncode>

                        <locationevent>

                            <taxonoccurrence>

                                <aggregateoccurrence>

                                    <collectiondate>

                                        <_date>

                                            <day>

                                                <_nullIf>

                                                    <null>0</null>

                                                    <type>float</type>

                                                    <value>$MeasDay</value>

                                                </_nullIf>

                                            </day>

                                            <month>

                                                <_nullIf>

                                                    <null>0</null>

                                                    <type>float</type>

                                                    <value>$MeasMon</value>

                                                </_nullIf>

                                            </month>

                                            <year>

                                                <_nullIf>

                                                    <null>0</null>

                                                    <type>float</type>

                                                    <value>$MeasYear</value>

                                                </_nullIf>

                                            </year>

                                        </_date>

                                    </collectiondate>

                                    <plantobservation>

                                        <stemobservation>

                                            <basaldiameter_m><_in_to_m><value>$BasalDiameter</value></_in_to_m></basaldiameter_m>

                                            <diameterbreastheight_m><_in_to_m><value>$DBH</value></_in_to_m></diameterbreastheight_m>

                                            <height_m><_ft_to_m><value>$Height</value></_ft_to_m></height_m>

                                            <tag>$TreeTag</tag>

                                        </stemobservation>

                                    </plantobservation>

                                </aggregateoccurrence>

                                <authortaxoncode>$TreeTag</authortaxoncode>

                                <taxondetermination>

                                    <taxonverbatim_id>

                                        <taxonverbatim>

                                            <taxonlabel_id>

                                                <taxonlabel>

                                                    <parent_id>

                                                        <taxonlabel>

                                                            <parent_id>

                                                                <taxonlabel>

                                                                    <rank>cultivar</rank>

                                                                    <parent_id>

                                                                        <taxonlabel>

                                                                            <rank>forma</rank>

                                                                            <parent_id>

                                                                                <taxonlabel>

                                                                                    <rank>variety</rank>

                                                                                    <parent_id>

                                                                                        <taxonlabel>

                                                                                            <rank>subspecies</rank>

                                                                                            <parent_id>

                                                                                                <taxonlabel>

                                                                                                    <rank>species</rank>

                                                                                                    <taxonepithet>$SpecificEpithet</taxonepithet>

                                                                                                    <parent_id>

                                                                                                        <taxonlabel>

                                                                                                            <rank>genus</rank>

                                                                                                            <taxonepithet>$Genus</taxonepithet>

                                                                                                        </taxonlabel>

                                                                                                    </parent_id>

                                                                                                </taxonlabel>

                                                                                            </parent_id>

                                                                                        </taxonlabel>

                                                                                    </parent_id>

                                                                                </taxonlabel>

                                                                            </parent_id>

                                                                        </taxonlabel>

                                                                    </parent_id>

                                                                </taxonlabel>

                                                            </parent_id>

                                                        </taxonlabel>

                                                    </parent_id>

                                                    <taxonomicname>

                                                        <_join_words>

                                                            <2>$Genus</2>

                                                            <3>$SpecificEpithet</3>

                                                        </_join_words>

                                                    </taxonomicname>

                                                </taxonlabel>

                                            </taxonlabel_id>

                                            <genus>$Genus</genus>

                                            <specific_epithet>$SpecificEpithet</specific_epithet>

                                        </taxonverbatim>

                                    </taxonverbatim_id>

                                </taxondetermination>

                            </taxonoccurrence>

                        </locationevent>

                        <locationplace>

                            <place_id>

                                <place>

                                    <coordinates_id>

                                        <coordinates>

                                            <latitude_deg>

                                                <_nullIf>

                                                    <null>0</null>

                                                    <type>float</type>

                                                    <value>$DecimalLatitude</value>

                                                </_nullIf>

                                            </latitude_deg>

                                            <longitude_deg>

                                                <_nullIf>

                                                    <null>0</null>

                                                    <type>float</type>

                                                    <value>$DecimalLongitude</value>

                                                </_nullIf>

                                            </longitude_deg>

                                        </coordinates>

                                    </coordinates_id>

                                    <county>$County</county>

                                    <matched_place_id>

                                        <place>

                                            <source_id><source><shortname>geoscrub</shortname></source></source_id>

                                            <coordinates_id>

                                                <coordinates>

                                                    <source_id><source><shortname>geoscrub</shortname></source></source_id>

                                                    <latitude_deg>

                                                        <_nullIf>

                                                            <null>0</null>

                                                            <type>float</type>

                                                            <value>$DecimalLatitude</value>

                                                        </_nullIf>

                                                    </latitude_deg>

                                                    <longitude_deg>

                                                        <_nullIf>

                                                            <null>0</null>

                                                            <type>float</type>

                                                            <value>$DecimalLongitude</value>

                                                        </_nullIf>

                                                    </longitude_deg>

                                                </coordinates>

                                            </coordinates_id>

                                            <county>$County</county>

                                            <stateprovince>$StateProvince</stateprovince>

                                        </place>

                                    </matched_place_id>

                                    <stateprovince>$StateProvince</stateprovince>

                                </place>

                            </place_id>

                        </locationplace>

                    </location>

                </path>

            </_simplifyPath>

        </path>

    </_setDefault>

</VegBIEN>

Inserted 23 new rows into database

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

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

PlotCD,"/location/_if[@name=""if subplot""]/else/sourceaccessioncode",

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

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

MeasDay,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value",

MeasMon,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value",

MeasYear,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value",

BasalDiameter,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/basaldiameter_m/_in_to_m/value,Assuming units are the same as for DBH because the values are similar and they measure the same dimension

DBH,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/diameterbreastheight_m/_in_to_m/value,Assuming units based on the range and precision of values and location inside the U.S.

Height,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/height_m/_ft_to_m/value,"Assuming units based on the range of values, the height of the tallest tree [1], and location inside the U.S.

[1] ""The tallest living tree is believed to be a coast redwood [which] is 115.66 metres (379.5 ft) tall"" (http://en.wikipedia.org/wiki/Tree#Superlative_trees)"

TreeTag,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/tag,

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

TreeTag,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/2",

SpecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=species]/taxonepithet",

Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/taxonepithet",

Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/2,

SpecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1,

Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/genus,

SpecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/specific_epithet,

DecimalLatitude,"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_nullIf:[null=0,type=float]/value",

DecimalLongitude,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value",

County,/location/locationplace/*_id/place/county,

DecimalLatitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,source_id/source/shortname=geoscrub]/*_id/coordinates:[source_id/source/shortname=geoscrub]/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"

DecimalLongitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,source_id/source/shortname=geoscrub]/*_id/coordinates:[source_id/source/shortname=geoscrub]/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"

County,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/county/_first/2,

StateProvince,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/stateprovince/_first/2,

StateProvince,/location/locationplace/*_id/place/stateprovince,

PlotCD,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/cond/_exists",

PlotCD,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/1",

HOM,,** No join mapping for *HOM ** 

#!/bin/bash

# :mode=transact-sql:

cd "$(dirname "$0")"

. ../../../lib/import.sh

psql <<'EOF'

ALTER TABLE :table ALTER COLUMN "PlotCD" TYPE bigint

USING "PlotCD"::bigint;

TreeTag,tag,,

MeasYear,yearCollected,,

MeasMon,monthCollected,,

MeasDay,dayCollected,,

PlotCD,locationID,,

*HOM