bien_web,VegCore,Filter,Comments

dataSourceID,*dataSourceID,,

dataSourceName,institutionCode,,

dataSourceNamePrimary,*dataSourceNamePrimary,,

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

plotCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/1",

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

dataSourceName,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_if[@name=""if catalogNumber""]/then/_join/1",

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

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

plotAreaHa,/location/area_m2/_ha_to_m2/value,

elevation_m,/location/elevation_m/_alt/1,

collectionNumber,"/location/iscultivated/_if[@name=""if TaxonOccurrence""]/cond/_exists",

isCultivated,"/location/iscultivated/_if[@name=""if TaxonOccurrence""]/else/_alt/2",

plotMethod,/location/locationevent/*_id/method/name,

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

pctCover,/location/locationevent/taxonoccurrence/aggregateoccurrence/cover_fraction/_percent_to_fraction/value,

collectionNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber,

dataSourceName,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcename/name,

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

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

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

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

collector,/location/locationevent/taxonoccurrence/collector_id/party/fullname,

collectionNumber,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",

isCultivated,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/then/_alt/2",

identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/fullname,

taxon,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[source_id/source/shortname=TNRS]/taxonomicname/_join_words/1/_taxon_family_require_std/family/_nullIf/null/_first/2",

family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[source_id/source/shortname=TNRS]/taxonomicname/_join_words/1/_taxon_family_require_std/family/_nullIf/value",

isValidLatLong,,** No join mapping for *isValidLatLong ** 

isValidLatLong_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation

localityDescription,,** No join mapping for *localityDescription ** 

observationID_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation

observationType,,** No join mapping for *observationType ** 

observationType_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation

                            <cover_fraction><_percent_to_fraction><value>$pctCover</value></_percent_to_fraction></cover_fraction>

                            <plantobservation>

                                <collectionnumber>$collectionNumber</collectionnumber>

                            </plantobservation>

                        </aggregateoccurrence>

                        <authortaxoncode>$collectionNumber</authortaxoncode>

                        <collector_id><party><fullname>$collector</fullname></party></collector_id>

                        <iscultivated>$isCultivated</iscultivated>

                        <taxondetermination>

                            <party_id><party><fullname>$identifiedBy</fullname></party></party_id>

                            <taxonverbatim_id>

dataSourceName,institutionCode,,

taxon,scientificName,,

taxonAuthor,scientificNameAuthorship,,

*dataSourceID

*dataSourceNamePrimary

*observationType