HAVING count(DISTINCT census_date) > 1

-----"

no_of_individuals,/location/locationevent/taxonoccurrence/aggregateoccurrence/count,"Brad: This is a count of number of indiiduals for an *aggregate* observation. For VegBank, I'm not sure. Not exactly the same as stemCount. An individual tree could have 3 stems but would still only count as 1. We need to check with Bob on this."

census_no,"/location/locationevent/taxonoccurrence/aggregateoccurrence/definedvalue[*_id/userdefined[tablename=aggregateoccurrence,userdefinedname=censusNo]]:[@fkey=tablerecord_id]/definedvalue","Brad: Assigned by SALVIAS. 1 for first plot, then 2, 3, etc. I can't recall if we even have repeat censuses in SALVIAS. Probably not."

intercept_cm,/location/locationevent/taxonoccurrence/aggregateoccurrence/linecover_m,"Brad: This is an aggregate observation. Used in line-intercept methodology only, describes the point along centerline at which an individual intercepts the center line of the plot. Used to determin relative abundance."

individual_code,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber,"Brad: Code, if any, used by the data provider to indicate an individual tree. Scope is unknown, although typically this value is unique only within plot, or sometimes only within subplot."

                    <taxonoccurrence>

                        <aggregateoccurrence>

                            <count>$no_of_individuals</count>

                            <definedvalue fkey="tablerecord_id">

                                <userdefined_id>

                                    <userdefined>

authorObsCode,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/cond/_exists/_first/2",

authorObsCode,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/authorlocationcode",

obsStartDate,/location/locationevent/obsstartdate/_*/date/_alt/1,

currentTaxonName sec Weakley 2006,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/2/_alt/3,

currentTaxonName sec Weakley 2006,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/scientificname,

county,/location/locationplace/*_id/placepath/county,

                    <authoreventcode>$authorObsCode</authoreventcode>

                    <obsstartdate><_date><date>$obsStartDate</date></_date></obsstartdate>

                    <taxonoccurrence>

                        <authortaxoncode>$currentTaxonName sec Weakley 2006</authortaxoncode>

                        <taxondetermination><taxonpath_id><taxonpath><scientificname>$currentTaxonName sec Weakley 2006</scientificname></taxonpath></taxonpath_id></taxondetermination>

                    </taxonoccurrence>

HAVING count(DISTINCT census_date) > 1

-----"

NoInd,/location/locationevent/taxonoccurrence/aggregateoccurrence/count,"Brad: This is a count of number of indiiduals for an *aggregate* observation. For VegBank, I'm not sure. Not exactly the same as stemCount. An individual tree could have 3 stems but would still only count as 1. We need to check with Bob on this."

census_no,"/location/locationevent/taxonoccurrence/aggregateoccurrence/definedvalue[*_id/userdefined[tablename=aggregateoccurrence,userdefinedname=censusNo]]:[@fkey=tablerecord_id]/definedvalue","Brad: Assigned by SALVIAS. 1 for first plot, then 2, 3, etc. I can't recall if we even have repeat censuses in SALVIAS. Probably not."

intercept_cm,/location/locationevent/taxonoccurrence/aggregateoccurrence/linecover_m,"Brad: This is an aggregate observation. Used in line-intercept methodology only, describes the point along centerline at which an individual intercepts the center line of the plot. Used to determin relative abundance."

Notes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,

                    <taxonoccurrence>

                        <aggregateoccurrence>

                            <count>$NoInd</count>

                            <definedvalue fkey="tablerecord_id">

                                <userdefined_id>

                                    <userdefined>

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

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

individualCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/count,

censusNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/definedvalue[*_id/userdefined[tablename=aggregateoccurrence,userdefinedname=censusNo]]:[@fkey=tablerecord_id]/definedvalue",

volumeCanopy,/location/locationevent/taxonoccurrence/aggregateoccurrence/linecover_m,

fieldNotes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,