individualCode,//plantobservation/authorplantcode,

collectorNumber,//plantobservation/authorplantcode,

sex,"//plantobservation/definedvalue[*_id/userdefined[tablename=plantobservation,userdefinedname=sex]]/definedvalue","Brad: OMIT. Apparently not used by this institution and of uncertain applicability to plants. With other collections, *sometimes* used for phenological information (if specimen in flower, in fruit, sterile, etc.). If so, this is important information we should keep. Bob, Nick, anywhere for phenological information in VB and VX?; Aaron: Keeping it because it's useful for some collections"

individualObservationID,//plantobservation/sourceaccessioncode,

individualID,//plantobservation/sourceaccessioncode,

voucherType,"//specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/cond",

fieldNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2,

recordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2,

sex,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/definedvalue[*_id/userdefined[tablename=plantobservation,userdefinedname=sex]]:[@fkey=tablerecord_id]/definedvalue","Brad: OMIT. Apparently not used by this institution and of uncertain applicability to plants. With other collections, *sometimes* used for phenological information (if specimen in flower, in fruit, sterile, etc.). If so, this is important information we should keep. Bob, Nick, anywhere for phenological information in VB and VX?; Aaron: Keeping it because it's useful for some collections"

catalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else",

collectionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_join/1,Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name

fieldNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/else",

otherCatalogNumbers,,** No join mapping for otherCatalogNumbers ** 

ownerInstitutionCode,,** No join mapping for ownerInstitutionCode ** 

preparations,,** No join mapping for preparations ** 

rightsHolder,,** No join mapping for rightsHolder ** 

startDayOfYear,,** No join mapping for startDayOfYear ** 

typeStatus,,** No join mapping for typeStatus ** 

                                            </userdefined_id>

                                            <definedvalue>$sex</definedvalue>

                                        </definedvalue>

                                        <specimenreplicate>

                                            <catalognumber_dwc>$catalogNumber</catalognumber_dwc>

                                            <collectioncode_dwc>$collectionCode</collectioncode_dwc>

occurrenceRemarks

dynamicProperties

associatedTaxa

lifeStage

preparations

municipality

eventDate,/location/locationevent/obsstartdate/_alt/2/_dateRangeStart/value,

dateIdentified,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/determinationdate/_alt/1/_dateRangeStart/value",

recordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2,

catalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else",

collectionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_join/1,Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name

collectionID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_join/2,

municipality,,** No join mapping for municipality ** 

occurrenceRemarks,,** No join mapping for occurrenceRemarks ** 

ownerInstitutionCode,,** No join mapping for ownerInstitutionCode ** 

rightsHolder,,** No join mapping for rightsHolder ** 

type,,** No join mapping for type ** 

verbatimDepth,,** No join mapping for verbatimDepth ** 

                                <aggregateoccurrence>

                                    <plantobservation>

                                        <authorplantcode>$recordNumber</authorplantcode>

                                        <specimenreplicate>

                                            <catalognumber_dwc>$catalogNumber</catalognumber_dwc>

                                            <collectioncode_dwc>

basisOfRecord

geodeticDatum

georeferenceSources

language

georeferenceVerificationStatus

Ind,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/1,"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."

coll_number,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2/_alt/1,Brad: Map instead as for voucher_string

SourceVoucher,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2/_alt/2,"Brad: OMIT. This is the verbatim text, which includes both collectors name and collection number. I would use coll_number, below."

PlotObsID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/sourceaccessioncode/_first/2,"Brad: Neither is correct; this is just an internal ID for table plotObservations. However, it has the important property of uniquely identifying an ""observation"", which is an individual tree, in the case of an individual observation, or a records of a species with an associated count of individuals or measurement of percent cover, in the case of aggregate observations. Not sure where to store this. Main point is that it is not part of the original data, but an auto_increment added later."

DetType,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/cond/_eq:[right=indirect]/left","Brad: A SALVIAS value referring to the relationship between the voucher specimen and the observation. Affect how the identification of the specimen(latin name) is transferred to the observation. 'direct'=voucher specimen was collected from this same tree; they are one and the same individual. 'indirect'=voucher specimen was collected for a different individual, but the original data provider confirmed that this is the same species. 'default'=basically same as 'indirect'. 'uncollected'=no voucher specimen, data provider  asserted that this was the name but was unable to collect. The main different is that with 'direct', 'indirect', and 'default', the scientific name can be updated automatically based on the name attached to the specimen voucher (assuming you have a link to that data, presumably from a herbarium database. Whereas, if det_type='uncollected', the name can never change because there is no specimen."

DetType,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/cond/_eq:[right=indirect]/left","Brad: A SALVIAS value referring to the relationship between the voucher specimen and the observation. Affect how the identification of the specimen(latin name) is transferred to the observation. 'direct'=voucher specimen was collected from this same tree; they are one and the same individual. 'indirect'=voucher specimen was collected for a different individual, but the original data provider confirmed that this is the same species. 'default'=basically same as 'indirect'. 'uncollected'=no voucher specimen, data provider  asserted that this was the name but was unable to collect. The main different is that with 'direct', 'indirect', and 'default', the scientific name can be updated automatically based on the name attached to the specimen voucher (assuming you have a link to that data, presumably from a herbarium database. Whereas, if det_type='uncollected', the name can never change because there is no specimen."

name_status,,"** No non-empty join mapping for OMIT ** Brad: OMIT. Except, note that if species_status=3, this indicate that name is a morphospecies and not a standard latin name. Not exactly sure how to use this in BIEN, but could be useful during the name-scrubbing process with TNRS."

other_annotations,,** No join mapping for *other_annotations ** 

perp_dist,,** No join mapping for *perp_dist ** 

species_code,,** No join mapping for *species_code ** 

temp_liandbh,,** No join mapping for *temp_liandbh ** 

tmp_PlotObsID,,** No join mapping for *tmp_PlotObsID ** 

                                    <notes>$Notes</notes>

                                    <plantobservation>

                                        <authorplantcode>$Ind</authorplantcode>

                                        <sourceaccessioncode>$PlotObsID</sourceaccessioncode>

                                        <specimenreplicate>

                                            <collectionnumber>

*morphocf

*IsMorpho

*OrigAuth

*tmp_PlotObsID

*temp_liandbh

*tmp_del

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

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

Number,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2,

Barcode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else",

Number,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/else",

Barcode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/cond/_exists",

EW,,** No join mapping for *EW ** 

Majorarea,,** No join mapping for *Majorarea ** 

NS,,** No join mapping for *NS ** 

Prefix,,** No non-empty join mapping for UNUSED ** 

Suffix,,** No non-empty join mapping for UNUSED ** 

                                    <notes>$Notes</notes>

                                    <plantobservation>

                                        <authorplantcode>$Number</authorplantcode>

                                        <specimenreplicate>

                                            <catalognumber_dwc>$Barcode</catalognumber_dwc>

                                            <collectionnumber>$Number</collectionnumber>

*EW

*Alt

*Alt2

eventDate,/location/locationevent/obsstartdate/_alt/2/_dateRangeStart/value,

dateIdentified,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/determinationdate/_alt/1/_dateRangeStart/value",

recordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2,

catalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else",

collectionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_join/1,Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name

collectionID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_join/2,

occurrenceRemarks,,** No join mapping for occurrenceRemarks ** 

ownerInstitutionCode,,** No join mapping for ownerInstitutionCode ** 

references,,** No join mapping for references ** 

rightsHolder,,** No join mapping for rightsHolder ** 

type,,** No join mapping for type ** 

verbatimCoordinateSystem,,** No join mapping for verbatimCoordinateSystem ** 

                                <aggregateoccurrence>

                                    <plantobservation>

                                        <authorplantcode>$recordNumber</authorplantcode>

                                        <specimenreplicate>

                                            <catalognumber_dwc>$catalogNumber</catalognumber_dwc>

                                            <collectioncode_dwc>

verbatimSRS

references

verbatimCoordinateSystem

dynamicProperties

basisOfRecord

georeferenceSources

loanto,"/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_join/6/_label[label=""loaned to""]/value",

inorout,"/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_join/7/_label[label=""in or out""]/value",

collectno,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2,

accession,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else","Globally unique, although occasionally duplicated. [1] Bob says this is actually the catalogNumber.

[1] Using the following query:

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

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

filler,,"** No join mapping for *filler ** Where used, same as family"

sheetno,,** No join mapping for associatedMedia ** ?

                                    </notes>

                                    <plantobservation>

                                        <authorplantcode>$collectno</authorplantcode>

                                        <specimenreplicate>

                                            <catalognumber_dwc>$accession</catalognumber_dwc>

                                            <collectionnumber>$collectno</collectionnumber>

associatedMedia

*filler

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

recordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2,

sex,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/definedvalue[*_id/userdefined[tablename=plantobservation,userdefinedname=sex]]:[@fkey=tablerecord_id]/definedvalue","Brad: OMIT. Apparently not used by this institution and of uncertain applicability to plants. With other collections, *sometimes* used for phenological information (if specimen in flower, in fruit, sterile, etc.). If so, this is important information we should keep. Bob, Nick, anywhere for phenological information in VB and VX?; Aaron: Keeping it because it's useful for some collections"

catalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else",

recordNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/else",

catalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/cond/_exists",

processingstatus,,** No join mapping for *processingstatus ** 

recordEnteredBy,,** No join mapping for *recordEnteredBy ** 

recordedById,,** No join mapping for *recordedById ** 

sciname,,** No join mapping for *sciname ** 

startDayOfYear,,** No join mapping for startDayOfYear ** 

substrate,,** No join mapping for *substrate ** 

                                            </userdefined_id>

                                            <definedvalue>$sex</definedvalue>

                                        </definedvalue>

                                        <specimenreplicate>

                                            <catalognumber_dwc>$catalogNumber</catalognumber_dwc>

                                            <collectionnumber>$recordNumber</collectionnumber>

dynamicProperties

*verbatimAttributes

*attributes

lifeStage

preparations

municipality

identificationQualifier,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/taxonfit",

recordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2,

sex,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/definedvalue[*_id/userdefined[tablename=plantobservation,userdefinedname=sex]]:[@fkey=tablerecord_id]/definedvalue","Brad: OMIT. Apparently not used by this institution and of uncertain applicability to plants. With other collections, *sometimes* used for phenological information (if specimen in flower, in fruit, sterile, etc.). If so, this is important information we should keep. Bob, Nick, anywhere for phenological information in VB and VX?; Aaron: Keeping it because it's useful for some collections"

catalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else",

collectionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_join/1,Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name

collectionID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_join/2,

otherCatalogNumbers,,** No join mapping for otherCatalogNumbers ** 

ownerInstitutionCode,,** No join mapping for ownerInstitutionCode ** 

previousIdentifications,,** No join mapping for previousIdentifications ** 

rightsHolder,,** No join mapping for rightsHolder ** 

type,,** No join mapping for type ** 

typeStatus,,** No join mapping for typeStatus ** 

                                            </userdefined_id>

                                            <definedvalue>$sex</definedvalue>

                                        </definedvalue>

                                        <specimenreplicate>

                                            <catalognumber_dwc>$catalogNumber</catalognumber_dwc>

                                            <collectioncode_dwc>

typeStatus

occurrenceRemarks

associatedReferences

individualCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/1,

collectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2,

sex,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/definedvalue[*_id/userdefined[tablename=plantobservation,userdefinedname=sex]]:[@fkey=tablerecord_id]/definedvalue","Brad: OMIT. Apparently not used by this institution and of uncertain applicability to plants. With other collections, *sometimes* used for phenological information (if specimen in flower, in fruit, sterile, etc.). If so, this is important information we should keep. Bob, Nick, anywhere for phenological information in VB and VX?; Aaron: Keeping it because it's useful for some collections"

individualObservationID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/sourceaccessioncode/_first/1,

individualID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/sourceaccessioncode/_first/2,

voucherType,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/cond/_eq:[right=indirect]/left",