HIBG,VegCore,Filter,Comments

id,occurrenceID,,

county,county,,

dateIdentified,dateIdentified,,

rightsHolder,dcterms:rightsHolder,,

verbatimSRS,verbatimSRS,,

references,dcterms:references,,

habitat,habitat,,

institutionID,institutionID,,

decimalLongitude,decimalLongitude,,

verbatimCoordinateSystem,verbatimCoordinateSystem,,

catalogNumber,catalogNumber,,

phylum,phylum,,

family,family,,

locationRemarks,locationRemarks,,

reproductiveCondition,reproductiveCondition,,

country,country,,

collectionID,collectionID,,

dynamicProperties,dynamicProperties,,

infraspecificEpithet,infraspecificEpithet,,

basisOfRecord,basisOfRecord,,

georeferenceSources,georeferenceSources,,

identifiedBy,identifiedBy,,

locality,locality,,

datasetName,datasetName,,

bibliographicCitation,dcterms:bibliographicCitation,,

datasetID,datasetID,,

institutionCode,institutionCode,,

recordNumber,recordNumber,,

order,order,,

kingdom,kingdom,,

specificEpithet,specificEpithet,,

informationWithheld,informationWithheld,,

verbatimDepth,verbatimDepth,,

geodeticDatum,geodeticDatum,,

associatedMedia,associatedMedia,,

nomenclaturalCode,nomenclaturalCode,,

waterBody,waterBody,,

rights,dcterms:rights,,

stateProvince,stateProvince,,

recordedBy,recordedBy,,

decimalLatitude,decimalLatitude,,

modified,dcterms:modified,,

verbatimCoordinates,verbatimCoordinates,,

continent,continent,,

identificationRemarks,identificationRemarks,,

georeferenceVerificationStatus,georeferenceVerificationStatus,,

occurrenceRemarks,occurrenceRemarks,,

municipality,municipality,,

genus,genus,,

taxonRank,taxonRank,,

type,dcterms:type,,

eventDate,eventDate,,

scientificName,scientificName,,

verbatimElevation,verbatimElevation,,

scientificNameAuthorship,scientificNameAuthorship,,

collectionCode,collectionCode,,

language,dcterms:language,,

ownerInstitutionCode,ownerInstitutionCode,,

class,class,,

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

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

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

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

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

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

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

verbatimElevation,"/location/elevation_m/_alt/1/_units:[to=m,to=]/value",

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

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

eventDate,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/cond/_exists",

eventDate,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/obsenddate/_alt/2/_dateRangeEnd/value",

eventDate,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/obsstartdate/_alt/2/_dateRangeStart/value",

eventDate,/location/locationevent/obsenddate/_alt/2/_dateRangeEnd/value,

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

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

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,

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

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

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

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

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

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

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

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

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

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

scientificName,"/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/2/_alt/1",

genus,"/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/2/_alt/2/_join_words/1/_alt/2/_join_words/2",

specificEpithet,"/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/2/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",

infraspecificEpithet,"/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/2/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond",

taxonRank,"/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/2/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then",

infraspecificEpithet,"/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/2/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2",

scientificNameAuthorship,"/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/2/_alt/2/_join_words/2",

dateIdentified,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/creationdate/_alt/1/_dateRangeStart/value,

taxonRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/rank",

taxonRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/taxonverbatim/verbatimrank",

specificEpithet,"/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]/_if[@name=""if is canonical name""]/then/matched_label_id/taxonlabel:[source_id/source/shortname=NCBI]/taxonomicname",

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]/_if[@name=""if is canonical name""]/then/matched_label_id/taxonlabel:[source_id/source/shortname=NCBI]/taxonomicname",

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

infraspecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/taxonepithet,

taxonRank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/rank,

taxonRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonepithet/_if[@name=""if taxonomic name is epithet""]/cond/_alt:[2=true]/1/_taxonomic_name_is_epithet/rank",

family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/1/_taxon_family_require_std/family,

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

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

specificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1,

infraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond",

taxonRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then",

infraspecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2,

scientificNameAuthorship,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/2,

scientificNameAuthorship,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/author,

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

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

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

scientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/taxonomicname,

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

dateIdentified,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/1/_dateRangeStart/value,

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

locality,/location/locationnarrative/_merge/1,

habitat,"/location/locationnarrative/_merge/3/_label[label=""habitat""]/value","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?"

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

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

verbatimElevation,/location/verbatimelevation,

associatedMedia,,** No join mapping for associatedMedia ** 

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

bibliographicCitation,,** No join mapping for dcterms:bibliographicCitation ** 

datasetID,,** No join mapping for datasetID ** 

datasetName,,** No join mapping for datasetName ** 

dynamicProperties,,** No join mapping for dynamicProperties ** 

geodeticDatum,,** No join mapping for geodeticDatum ** 

georeferenceSources,,** No join mapping for georeferenceSources ** 

georeferenceVerificationStatus,,** No join mapping for georeferenceVerificationStatus ** 

identificationRemarks,,** No join mapping for identificationRemarks ** 

informationWithheld,,** No join mapping for informationWithheld ** 

institutionID,,** No join mapping for institutionID ** 

language,,** No join mapping for dcterms:language ** 

locationRemarks,,** No join mapping for locationRemarks ** 

modified,,** No join mapping for dcterms:modified ** 

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

nomenclaturalCode,,** No join mapping for nomenclaturalCode ** 

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

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

references,,** No join mapping for dcterms:references ** 

reproductiveCondition,,** No join mapping for reproductiveCondition ** 

rights,,** No join mapping for dcterms:rights ** 

rightsHolder,,** No join mapping for dcterms:rightsHolder ** 

type,,** No join mapping for dcterms:type ** 

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

verbatimCoordinates,,** No join mapping for verbatimCoordinates ** 

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

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

waterBody,,** No join mapping for waterBody ** 

Put template:

<VegBIEN>

    <_simplifyPath id="-1">

        <next>parent_id</next>

        <path>

            <location>

                <authorlocationcode>

                    <_alt>

                        <1>$id</1>

                        <2>

                            <_join>

                                <1>$institutionCode</1>

                                <2>

                                    <_join>

                                        <1>$collectionCode</1>

                                        <2>$collectionID</2>

                                    </_join>

                                </2>

                                <3>$catalogNumber</3>

                            </_join>

                        </2>

                    </_alt>

                </authorlocationcode>

                <elevation_m>

                    <_units>

                        <to>m</to>

                        <to></to>

                        <value>$verbatimElevation</value>

                    </_units>

                </elevation_m>

                <locationevent>

                    <obsenddate><_dateRangeEnd><value>$eventDate</value></_dateRangeEnd></obsenddate>

                    <obsstartdate><_dateRangeStart><value>$eventDate</value></_dateRangeStart></obsstartdate>

                    <taxonoccurrence>

                        <aggregateoccurrence>

                            <plantobservation>

                                <collectionnumber>$recordNumber</collectionnumber>

                                <specimenreplicate>

                                    <catalognumber_dwc>$catalogNumber</catalognumber_dwc>

                                    <collectioncode_dwc>

                                        <_join>

                                            <1>$collectionCode</1>

                                            <2>$collectionID</2>

                                        </_join>

                                    </collectioncode_dwc>

                                    <institution_id><sourcename><name>$institutionCode</name></sourcename></institution_id>

                                    <sourceaccessioncode>$id</sourceaccessioncode>

                                </specimenreplicate>

                            </plantobservation>

                        </aggregateoccurrence>

                        <collector_id><party><fullname>$recordedBy</fullname></party></collector_id>

                        <sourceaccessioncode>$id</sourceaccessioncode>

                        <taxondetermination>

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

                            <taxonverbatim_id>

                                <taxonverbatim>

                                    <taxonlabel_id>

                                        <taxonlabel>

                                            <matched_label_id>

                                                <taxonlabel>

                                                    <source_id><source><shortname>TNRS</shortname></source></source_id>

                                                    <taxonomicname>

                                                        <_join_words>

                                                            <1><_taxon_family_require_std><family>$family</family></_taxon_family_require_std></1>

                                                            <2>

                                                                <_alt>

                                                                    <1>$scientificName</1>

                                                                    <2>

                                                                        <_join_words>

                                                                            <1>

                                                                                <_join_words>

                                                                                    <2>$genus</2>

                                                                                    <3>$specificEpithet</3>

                                                                                    <5>

                                                                                        <_join_words>

                                                                                            <1>

                                                                                                <_if name="if has infraspecificEpithet">

                                                                                                    <cond>$infraspecificEpithet</cond>

                                                                                                    <then>$taxonRank</then>

                                                                                                </_if>

                                                                                            </1>

                                                                                            <2>$infraspecificEpithet</2>

                                                                                        </_join_words>

                                                                                    </5>

                                                                                </_join_words>

                                                                            </1>

                                                                            <2>$scientificNameAuthorship</2>

                                                                        </_join_words>

                                                                    </2>

                                                                </_alt>

                                                            </2>

                                                        </_join_words>

                                                    </taxonomicname>

                                                </taxonlabel>

                                            </matched_label_id>

                                            <creationdate><_dateRangeStart><value>$dateIdentified</value></_dateRangeStart></creationdate>

                                            <parent_id>

                                                <taxonlabel>

                                                    <rank>$taxonRank</rank>

                                                    <taxonverbatim><verbatimrank>$taxonRank</verbatimrank></taxonverbatim>

                                                    <parent_id>

                                                        <taxonlabel>

                                                            <rank>cultivar</rank>

                                                            <parent_id>

                                                                <taxonlabel>

                                                                    <rank>forma</rank>

                                                                    <parent_id>

                                                                        <taxonlabel>

                                                                            <rank>variety</rank>

                                                                            <parent_id>

                                                                                <taxonlabel>

                                                                                    <rank>subspecies</rank>

                                                                                    <parent_id>

                                                                                        <taxonlabel>

                                                                                            <rank>species</rank>

                                                                                            <taxonepithet>$specificEpithet</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>

                                                    <taxonepithet>$infraspecificEpithet</taxonepithet>

                                                </taxonlabel>

                                            </parent_id>

                                            <rank>$taxonRank</rank>

                                            <taxonomicname>

                                                <_join_words>

                                                    <1><_taxon_family_require_std><family>$family</family></_taxon_family_require_std></1>

                                                    <2>

                                                        <_alt>

                                                            <1>$scientificName</1>

                                                            <2>

                                                                <_join_words>

                                                                    <1>

                                                                        <_join_words>

                                                                            <2>$genus</2>

                                                                            <3>$specificEpithet</3>

                                                                            <5>

                                                                                <_join_words>

                                                                                    <1>

                                                                                        <_if name="if has infraspecificEpithet">

                                                                                            <cond>$infraspecificEpithet</cond>

                                                                                            <then>$taxonRank</then>

                                                                                        </_if>

                                                                                    </1>

                                                                                    <2>$infraspecificEpithet</2>

                                                                                </_join_words>

                                                                            </5>

                                                                        </_join_words>

                                                                    </1>

                                                                    <2>$scientificNameAuthorship</2>

                                                                </_join_words>

                                                            </2>

                                                        </_alt>

                                                    </2>

                                                </_join_words>

                                            </taxonomicname>

                                        </taxonlabel>

                                    </taxonlabel_id>

                                    <author>$scientificNameAuthorship</author>

                                    <family>$family</family>

                                    <genus>$genus</genus>

                                    <specific_epithet>$specificEpithet</specific_epithet>

                                    <taxonomicname>$scientificName</taxonomicname>

                                    <verbatimrank>$taxonRank</verbatimrank>

                                </taxonverbatim>

                            </taxonverbatim_id>

                            <determinationdate><_dateRangeStart><value>$dateIdentified</value></_dateRangeStart></determinationdate>

                        </taxondetermination>

                    </taxonoccurrence>

                </locationevent>

                <locationnarrative>

                    <_merge>

                        <1>$locality</1>

                        <3>

                            <_label>

                                <label>habitat</label>

                                <value>$habitat</value>

                            </_label>

                        </3>

                    </_merge>

                </locationnarrative>

                <locationplace>

                    <place_id>

                        <place>

                            <coordinates_id>

                                <coordinates>

                                    <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>$continent</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>

                <verbatimelevation>$verbatimElevation</verbatimelevation>

            </location>

        </path>

    </_simplifyPath>

</VegBIEN>

Inserted 39 new rows into database

dcterms:rightsHolder

verbatimSRS

dcterms:references

institutionID

verbatimCoordinateSystem

locationRemarks

reproductiveCondition

dynamicProperties

basisOfRecord

georeferenceSources

datasetName

dcterms:bibliographicCitation

datasetID

informationWithheld

verbatimDepth

geodeticDatum

associatedMedia

nomenclaturalCode

waterBody

dcterms:rights

dcterms:modified

verbatimCoordinates

identificationRemarks

georeferenceVerificationStatus

occurrenceRemarks

municipality

dcterms:type

dcterms:language

ownerInstitutionCode