CatalogNumberNumeric,catalogNumber,/_alt/1,

TimeCollected,eventTime,,

VerbatimCollectingDate,dateCollected,/_alt/0,

OriginalCoordinateSystem,verbatimSRS,,

GeorefMethod,georeferenceProtocol,,

LatLongComments,georeferenceRemarks,,

IdentificationModifier,identificationQualifier,,

AgeClass,lifeStage,,

GenBankNum,associatedSequences,"/_label[label=""GenBank""]/value",

RelatedCatalogedItems,relatedResourceID,/_alt/2,Used only when OtherCatalogNumbers is NULL

modified

basisOfRecord

eventTime

day

higherGeography

islandGroup

island

verbatimSRS

georeferenceProtocol

georeferenceRemarks

verbatimDepth

typeStatus

preparations

lifeStage

associatedSequences

relatedResourceID

relatedResourceID

ARIZ,VegCore,Filter,Comments

GlobalUniqueIdentifier,occurrenceID,,

DateLastModified,modified,,

BasisOfRecord,basisOfRecord,,

InstitutionCode,collection,,Column names are reversed

CollectionCode,custodialInstitutions,,Column names are reversed

CatalogNumber,catalogNumber,/_alt/2,Don't overwrite CatalogNumberNumeric

CatalogNumberNumeric,catalogNumber,/_alt/1,

Collector,recordedBy,,

CollectorNumber,collectorNumber,/_first/1,

FieldNumber,collectorNumber,/_first/2,Identical to CollectorNumber

YearCollected,yearCollected,,

MonthCollected,monthCollected,,

DayCollected,dayCollected,,

TimeCollected,eventTime,,

VerbatimCollectingDate,dateCollected,/_alt/0,

FieldNotes,organismNotes,,

JulianDay,day,,

HigherGeography,higherGeography,,

ContinentOcean,continent,,

IslandGroup,islandGroup,,

Island,island,,

Country,country,,

StateProvince,stateProvince,,

County,county,,

Locality,locality,,

DecimalLatitude,decimalLatitude,,

DecimalLongitude,decimalLongitude,,

HorizontalDatum,UNUSED,,

OriginalCoordinateSystem,verbatimSRS,,

VerbatimLatitude,UNUSED,,

VerbatimLongitude,UNUSED,,

GeorefMethod,georeferenceProtocol,,

CoordinateUncertaintyInMeters,coordinateUncertaintyInMeters,,

LatLongComments,georeferenceRemarks,,

BoundingBox,footprintWKT,,

MinimumElevationInMeters,minimumElevationInMeters,,"Contains some verbatim values, including ranges and units"

MaximumElevationInMeters,maximumElevationInMeters,,"Contains some verbatim values, including ranges and units"

VerbatimElevation,UNUSED,,

MinimumDepthInMeters,minimumDepthInMeters,,

MaximumDepthInMeters,maximumDepthInMeters,,

VerbatimDepth,verbatimDepth,,

ScientificName,taxonName,,

Kingdom,kingdom,,

Phylum,phylum,,

Class,class,,

Order,order,,

Family,family,,

Genus,genus,,

Species,specificEpithet,,

Subspecies,subspecies,,

ScientificNameAuthor,scientificName,,Contains the binomial in addition to the authority

IdentifiedBy,identifiedBy,,

IdentificationModifier,identificationQualifier,,

YearIdentified,yearIdentified,,

MonthIdentified,monthIdentified,,

DayIdentified,dayIdentified,,

TypeStatus,typeStatus,,

Sex,sex,,

Preparations,preparations,,

Tissues,UNUSED,,

IndividualCount,individualCount,,

AgeClass,lifeStage,,

GenBankNum,associatedSequences,"/_label[label=""GenBank""]/value",

OtherCatalogNumbers,relatedResourceID,/_alt/1,

RelatedCatalogedItems,relatedResourceID,/_alt/2,Used only when OtherCatalogNumbers is NULL

Remarks,taxonRemarks,,

Put template:

<VegBIEN>

    <_setDefault id="-1">

        <source_id><source><shortname>ARIZ</shortname></source></source_id>

        <path>

            <_simplifyPath>

                <next>parent_id</next>

                <path>

                    <location>

                        <authorlocationcode>

                            <_alt>

                                <1>$GlobalUniqueIdentifier</1>

                                <2>

                                    <_join>

                                        <1>$CollectionCode</1>

                                        <2>$InstitutionCode</2>

                                        <3>

                                            <_alt>

                                                <1>$CatalogNumberNumeric</1>

                                                <2>$CatalogNumber</2>

                                            </_alt>

                                        </3>

                                    </_join>

                                </2>

                            </_alt>

                        </authorlocationcode>

                        <elevation_m>

                            <_avg>

                                <max>$MaximumElevationInMeters</max>

                                <min>$MinimumElevationInMeters</min>

                            </_avg>

                        </elevation_m>

                        <iscultivated><_locationnarrative_is_cultivated><locationnarrative>$Locality</locationnarrative></_locationnarrative_is_cultivated></iscultivated>

                        <locationevent>

                            <taxonoccurrence>

                                <aggregateoccurrence>

                                    <collectiondate>

                                        <_alt>

                                            <1>$VerbatimCollectingDate</1>

                                            <2>

                                                <_date>

                                                    <day>

                                                        <_nullIf>

                                                            <null>0</null>

                                                            <type>float</type>

                                                            <value>$DayCollected</value>

                                                        </_nullIf>

                                                    </day>

                                                    <month>

                                                        <_nullIf>

                                                            <null>0</null>

                                                            <type>float</type>

                                                            <value>$MonthCollected</value>

                                                        </_nullIf>

                                                    </month>

                                                    <year>

                                                        <_nullIf>

                                                            <null>0</null>

                                                            <type>float</type>

                                                            <value>$YearCollected</value>

                                                        </_nullIf>

                                                    </year>

                                                </_date>

                                            </2>

                                        </_alt>

                                    </collectiondate>

                                    <count>$IndividualCount</count>

                                    <notes>$FieldNotes</notes>

                                    <plantobservation>

                                        <authorplantcode>$CollectorNumber</authorplantcode>

                                        <definedvalue fkey="tablerecord_id">

                                            <userdefined_id>

                                                <userdefined>

                                                    <tablename>plantobservation</tablename>

                                                    <userdefinedname>sex</userdefinedname>

                                                </userdefined>

                                            </userdefined_id>

                                            <definedvalue>$Sex</definedvalue>

                                        </definedvalue>

                                        <specimenreplicate>

                                            <catalognumber_dwc>

                                                <_alt>

                                                    <1>$CatalogNumberNumeric</1>

                                                    <2>$CatalogNumber</2>

                                                </_alt>

                                            </catalognumber_dwc>

                                            <collectioncode_dwc>$InstitutionCode</collectioncode_dwc>

                                            <collectionnumber>$CollectorNumber</collectionnumber>

                                            <institution_id>

                                                <sourcelist>

                                                    <name>$CollectionCode</name>

                                                    <sourcename>

                                                        <name>

                                                            <_split>

                                                                <separator>[,;] *</separator>

                                                                <value>$CollectionCode</value>

                                                            </_split>

                                                        </name>

                                                    </sourcename>

                                                </sourcelist>

                                            </institution_id>

                                            <sourceaccessioncode>$GlobalUniqueIdentifier</sourceaccessioncode>

                                        </specimenreplicate>

                                    </plantobservation>

                                </aggregateoccurrence>

                                <collector_id><party><fullname>$Collector</fullname></party></collector_id>

                                <sourceaccessioncode>$GlobalUniqueIdentifier</sourceaccessioncode>

                                <taxondetermination>

                                    <party_id><party><fullname>$IdentifiedBy</fullname></party></party_id>

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

                                                                                            <taxonepithet>$Subspecies</taxonepithet>

                                                                                            <parent_id>

                                                                                                <taxonlabel>

                                                                                                    <rank>species</rank>

                                                                                                    <taxonepithet>$Species</taxonepithet>

                                                                                                    <parent_id>

                                                                                                        <taxonlabel>

                                                                                                            <rank>genus</rank>

                                                                                                            <taxonepithet>$Genus</taxonepithet>

                                                                                                            <parent_id>

                                                                                                                <taxonlabel>

                                                                                                                    <rank>family</rank>

                                                                                                                    <taxonepithet>$Family</taxonepithet>

                                                                                                                    <parent_id>

                                                                                                                        <taxonlabel>

                                                                                                                            <rank>order</rank>

                                                                                                                            <taxonepithet>$Order</taxonepithet>

                                                                                                                            <parent_id>

                                                                                                                                <taxonlabel>

                                                                                                                                    <rank>class</rank>

                                                                                                                                    <taxonepithet>$Class</taxonepithet>

                                                                                                                                    <parent_id>

                                                                                                                                        <taxonlabel>

                                                                                                                                            <rank>phylum</rank>

                                                                                                                                            <taxonepithet>$Phylum</taxonepithet>

                                                                                                                                            <parent_id>

                                                                                                                                                <taxonlabel>

                                                                                                                                                    <rank>kingdom</rank>

                                                                                                                                                    <taxonepithet>$Kingdom</taxonepithet>

                                                                                                                                                </taxonlabel>

                                                                                                                                            </parent_id>

                                                                                                                                        </taxonlabel>

                                                                                                                                    </parent_id>

                                                                                                                                </taxonlabel>

                                                                                                                            </parent_id>

                                                                                                                        </taxonlabel>

                                                                                                                    </parent_id>

                                                                                                                </taxonlabel>

                                                                                                            </parent_id>

                                                                                                        </taxonlabel>

                                                                                                    </parent_id>

                                                                                                </taxonlabel>

                                                                                            </parent_id>

                                                                                        </taxonlabel>

                                                                                    </parent_id>

                                                                                </taxonlabel>

                                                                            </parent_id>

                                                                        </taxonlabel>

                                                                    </parent_id>

                                                                </taxonlabel>

                                                            </parent_id>

                                                        </taxonlabel>

                                                    </parent_id>

                                                    <taxonomicname>

                                                        <_merge_prefix>

                                                            <prefix><_taxon_family_require_std><family>$Family</family></_taxon_family_require_std></prefix>

                                                            <value>

                                                                <_alt>

                                                                    <1>$ScientificNameAuthor</1>

                                                                    <2>

                                                                        <_alt>

                                                                            <1>$ScientificName</1>

                                                                            <2>

                                                                                <_join_words>

                                                                                    <2>$Genus</2>

                                                                                    <3>$Species</3>

                                                                                    <4>$Subspecies</4>

                                                                                </_join_words>

                                                                            </2>

                                                                        </_alt>

                                                                    </2>

                                                                </_alt>

                                                            </value>

                                                        </_merge_prefix>

                                                    </taxonomicname>

                                                </taxonlabel>

                                            </taxonlabel_id>

                                            <family>$Family</family>

                                            <genus>$Genus</genus>

                                            <specific_epithet>$Species</specific_epithet>

                                            <taxonname>$ScientificName</taxonname>

                                            <taxonomicname>$ScientificNameAuthor</taxonomicname>

                                        </taxonverbatim>

                                    </taxonverbatim_id>

                                    <determinationdate>

                                        <_date>

                                            <day>

                                                <_nullIf>

                                                    <null>0</null>

                                                    <type>float</type>

                                                    <value>$DayIdentified</value>

                                                </_nullIf>

                                            </day>

                                            <month>

                                                <_nullIf>

                                                    <null>0</null>

                                                    <type>float</type>

                                                    <value>$MonthIdentified</value>

                                                </_nullIf>

                                            </month>

                                            <year>

                                                <_nullIf>

                                                    <null>0</null>

                                                    <type>float</type>

                                                    <value>$YearIdentified</value>

                                                </_nullIf>

                                            </year>

                                        </_date>

                                    </determinationdate>

                                    <notes>$Remarks</notes>

                                    <taxonfit>$IdentificationModifier</taxonfit>

                                </taxondetermination>

                            </taxonoccurrence>

                            <waterdepth_m>

                                <_avg>

                                    <max>$MaximumDepthInMeters</max>

                                    <min>$MinimumDepthInMeters</min>

                                </_avg>

                            </waterdepth_m>

                        </locationevent>

                        <locationnarrative>$Locality</locationnarrative>

                        <locationplace>

                            <place_id>

                                <place>

                                    <coordinates_id>

                                        <coordinates>

                                            <coordsaccuracy_m><_noCV><value>$CoordinateUncertaintyInMeters</value></_noCV></coordsaccuracy_m>

                                            <footprintgeometry_dwc>$BoundingBox</footprintgeometry_dwc>

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

                                    <continent>$ContinentOcean</continent>

                                    <country>$Country</country>

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

                                            <country>$Country</country>

                                            <county>$County</county>

                                            <stateprovince>$StateProvince</stateprovince>

                                        </place>

                                    </matched_place_id>

                                    <stateprovince>$StateProvince</stateprovince>

                                </place>

                            </place_id>

                        </locationplace>

                    </location>

                </path>

            </_simplifyPath>

        </path>

    </_setDefault>

</VegBIEN>

Inserted 42 new rows into database

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

GlobalUniqueIdentifier,"/_if[@name=""if specimen""]/cond/_exists",

CatalogNumberNumeric,"/_if[@name=""if specimen""]/cond/_exists/_alt/1",

CatalogNumber,"/_if[@name=""if specimen""]/cond/_exists/_alt/2",Don't overwrite CatalogNumberNumeric

CollectionCode,"/_if[@name=""if specimen""]/else/source/shortname/_first/1",Column names are reversed

GlobalUniqueIdentifier,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/1",

CatalogNumberNumeric,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/cond/_exists/_alt/1",

CatalogNumber,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/cond/_exists/_alt/2",Don't overwrite CatalogNumberNumeric

GlobalUniqueIdentifier,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/then/_join/1/_if[@name=""if specimen""]/cond/_exists",

CatalogNumberNumeric,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/then/_join/1/_if[@name=""if specimen""]/cond/_exists/_alt/1",

CatalogNumber,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/then/_join/1/_if[@name=""if specimen""]/cond/_exists/_alt/2",Don't overwrite CatalogNumberNumeric

CollectionCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/then/_join/1/_if[@name=""if specimen""]/then/_first/2",Column names are reversed

InstitutionCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/then/_join/2/_join/1",Column names are reversed

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

CatalogNumber,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/then/_join/3/_if[@name=""if indirect voucher""]/else/_alt/2",Don't overwrite CatalogNumberNumeric

MaximumElevationInMeters,/location/elevation_m/_alt/2/_avg/max,"Contains some verbatim values, including ranges and units"

MinimumElevationInMeters,/location/elevation_m/_alt/2/_avg/min,"Contains some verbatim values, including ranges and units"

GlobalUniqueIdentifier,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",

CollectorNumber,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists/_first/1",

FieldNumber,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists/_first/2",Identical to CollectorNumber

Locality,/location/iscultivated/_or/2/_locationnarrative_is_cultivated/locationnarrative/_join/1,

DayIdentified,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/determinationdate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value",

MonthIdentified,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/determinationdate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value",

YearIdentified,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/determinationdate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value",

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

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

VerbatimCollectingDate,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/1/_alt/0,

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

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,

FieldNotes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,

CollectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2/_first/1,

FieldNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2/_first/2,Identical to CollectorNumber

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"

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

CatalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else/_alt/2",Don't overwrite CatalogNumberNumeric

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

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

FieldNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/else/_first/2",Identical to CollectorNumber

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

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

CatalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/cond/_exists/_alt/2",Don't overwrite CatalogNumberNumeric

CollectionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/name/_first/2",Column names are reversed

CollectionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_first/2/_split:[separator=""[,;] *""]/value",Column names are reversed

GlobalUniqueIdentifier,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,

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

FieldNumber,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/3/_first/2",Identical to CollectorNumber

ScientificNameAuthor,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/3/_first/2",Contains the binomial in addition to the authority

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

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

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

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

FieldNumber,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists/_first/2",Identical to CollectorNumber

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

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

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

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

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

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

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

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

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

Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/prefix/_taxon_family_require_std/family,

ScientificNameAuthor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/1,Contains the binomial in addition to the authority

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

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

Species,/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,

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

Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/family,

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

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

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

ScientificNameAuthor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/taxonomicname,Contains the binomial in addition to the authority

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

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

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

CatalogNumberNumeric,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then/_alt/1",

CatalogNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then/_alt/2",Don't overwrite CatalogNumberNumeric

CollectorNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/then/_first/1",

FieldNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/then/_first/2",Identical to CollectorNumber

MaximumDepthInMeters,/location/locationevent/waterdepth_m/_avg/max,

MinimumDepthInMeters,/location/locationevent/waterdepth_m/_avg/min,

Locality,/location/locationnarrative/_merge/1,

CoordinateUncertaintyInMeters,/location/locationplace/*_id/place/*_id/coordinates/coordsaccuracy_m/_noCV/value,

BoundingBox,/location/locationplace/*_id/place/*_id/coordinates/footprintgeometry_dwc,

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

ContinentOcean,/location/locationplace/*_id/place/continent,

Country,/location/locationplace/*_id/place/country,

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"

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

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,

AgeClass,,** No join mapping for lifeStage ** 

BasisOfRecord,,** No join mapping for basisOfRecord ** 

DateLastModified,,** No join mapping for modified ** 

GenBankNum,,"** No join mapping for associatedSequences/_label[label=""GenBank""]/value ** "

GeorefMethod,,** No join mapping for georeferenceProtocol ** 

HigherGeography,,** No join mapping for higherGeography ** 

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

Island,,** No join mapping for island ** 

IslandGroup,,** No join mapping for islandGroup ** 

JulianDay,,** No join mapping for day ** 

LatLongComments,,** No join mapping for georeferenceRemarks ** 

OriginalCoordinateSystem,,** No join mapping for verbatimSRS ** 

OtherCatalogNumbers,,** No join mapping for relatedResourceID/_alt/1 ** 

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

RelatedCatalogedItems,,** No join mapping for relatedResourceID/_alt/2 ** Used only when OtherCatalogNumbers is NULL

TimeCollected,,** No join mapping for eventTime ** 

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

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

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

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

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

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

Specimen