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

:0,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",Enables the taxonoccurrence CHECK constraint to pass

:0,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/1,Enables the taxonoccurrence CHECK constraint to pass

Name_submitted,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/cond/_exists",

Name_matched,"/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/1",

Name_matched_accepted_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",Contains family based on matched name

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

Name_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/taxonname,

Name_matched_rank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/verbatimrank,

taxonoccurrence_id,/location/locationevent/taxonoccurrence/taxonoccurrence_id,

Accepted_name_lsid,,** No join mapping for *Accepted_name_lsid ** 

Accepted_name_species,,** No join mapping for *Accepted_name_species ** Also contains genus. Omitted because Accepted_name contains more info.

                            <taxonoccurrence>

                                <sourceaccessioncode>0</sourceaccessioncode>

                                <taxondetermination>

                                    <taxonverbatim_id>

                                        <taxonverbatim>

                                            <taxonlabel_id>

                                            <verbatimrank>$Name_matched_rank</verbatimrank>

                                        </taxonverbatim>

                                    </taxonverbatim_id>

                                </taxondetermination>

                                <taxonoccurrence_id>$taxonoccurrence_id</taxonoccurrence_id>

                            </taxonoccurrence>

individualObservationID,"/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/2/_if[@name=""if organism in AggregateOccurrence""]/else/_first/1",

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

occurrenceID,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/3,

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

taxonNameOrEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/cond/_exists",

verbatimScientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/cond/_exists",

dayIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value",

monthIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value",

yearIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value",

taxonRemarks,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/notes,

identificationQualifier,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/taxonfit,

originalTaxonName,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/taxonlabel:[source_id/source/shortname=TNRS]/taxonomicname/_join_words/1/_taxon_family_require_std/family/_nullIf/null/_first/1,

individualObservationID,"//taxonoccurrence/sourceaccessioncode/_if[@name=""if organism in AggregateOccurrence""]/else",

individualID,"//taxonoccurrence/sourceaccessioncode/_if[@name=""if organism in AggregateOccurrence""]/else",

occurrenceID,//taxonoccurrence/sourceaccessioncode,

identifiedBy,//taxonoccurrence/taxondetermination[]/*_id/party/fullname,

taxonNameOrEpithet,"//*_id/taxonlabel/_if[@name=""if has verbatim name""]/cond/_exists",

verbatimScientificName,"//*_id/taxonlabel/_if[@name=""if has verbatim name""]/cond/_exists",

dayIdentified,//taxonoccurrence/taxondetermination[]/determinationdate,

monthIdentified,//taxonoccurrence/taxondetermination[]/determinationdate,

yearIdentified,//taxonoccurrence/taxondetermination[]/determinationdate,

taxonRemarks,//taxonoccurrence/taxondetermination[]/notes,

identificationQualifier,//taxonoccurrence/taxondetermination[]/taxonfit,

originalTaxonName,//taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/taxonlabel/taxonomicname,