TRT,VegCore,Filter,Comments

id,occurrenceID,,

maximumElevationInMeters,maximumElevationInMeters,,

dateIdentified,dateIdentified,,

specificEpithet,specificEpithet,,

locality,locality,,

reproductiveCondition,reproductiveCondition,,

continent,continent,,

infraspecificEpithet,infraspecificEpithet,,

typeStatus,typeStatus,,

occurrenceRemarks,occurrenceRemarks,,

associatedReferences,associatedReferences,,

decimalLongitude,decimalLongitude,,

verbatimLatitude,verbatimLatitude,,

georeferenceProtocol,georeferenceProtocol,,

verbatimElevation,verbatimElevation,,

verbatimLongitude,verbatimLongitude,,

type,dcterms:type,,

institutionID,institutionID,,

scientificNameAuthorship,scientificNameAuthorship,,

rights,dcterms:rights,,

rightsHolder,dcterms:rightsHolder,,

georeferencedBy,georeferencedBy,,

family,family,,

recordNumber,recordNumber,,

country,country,,

county,county,,

georeferenceRemarks,georeferenceRemarks,,

habitat,habitat,,

scientificName,scientificName,,

sex,sex,,

geodeticDatum,geodeticDatum,,

coordinateUncertaintyInMeters,coordinateUncertaintyInMeters,,

verbatimCoordinates,verbatimCoordinates,,

establishmentMeans,establishmentMeans,,

verbatimEventDate,verbatimEventDate,,

catalogNumber,catalogNumber,,

georeferenceVerificationStatus,georeferenceVerificationStatus,,

stateProvince,stateProvince,,

associatedMedia,associatedMedia,,

datasetID,datasetID,,

georeferencedDate,georeferencedDate,,

eventDate,eventDate,,

kingdom,kingdom,,

bibliographicCitation,dcterms:bibliographicCitation,,

taxonRank,taxonRank,,

nomenclaturalCode,nomenclaturalCode,,

identificationQualifier,identificationQualifier,,

datasetName,datasetName,,

decimalLatitude,decimalLatitude,,

ownerInstitutionCode,ownerInstitutionCode,,

basisOfRecord,basisOfRecord,,

georeferenceSources,georeferenceSources,,

previousIdentifications,previousIdentifications,,

verbatimCoordinateSystem,verbatimCoordinateSystem,,

locationRemarks,locationRemarks,,

genus,genus,,

institutionCode,institutionCode,,

higherClassification,higherClassification,,

verbatimSRS,verbatimSRS,,

municipality,municipality,,

identifiedBy,identifiedBy,,

otherCatalogNumbers,otherCatalogNumbers,,

collectionID,collectionID,,

language,dcterms:language,,

recordedBy,recordedBy,,

minimumElevationInMeters,minimumElevationInMeters,,

collectionCode,collectionCode,,

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

maximumElevationInMeters,/location/elevation_m/_alt/2/_avg/max,

minimumElevationInMeters,/location/elevation_m/_alt/2/_avg/min,

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,

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

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

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

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

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

establishmentMeans,"/location/locationevent/taxonoccurrence/iscultivated/_alt/2/_map:[cultivated=t,wild=f,*=]/value",

establishmentMeans,"/location/locationevent/taxonoccurrence/isnative/_map:[native=t,exotic=f,*=]/value",

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

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,

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

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

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

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

verbatimLatitude,/location/locationplace/*_id/place/*_id/coordinates/verbatimlatitude,

verbatimLongitude,/location/locationplace/*_id/place/*_id/coordinates/verbatimlongitude,

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

associatedReferences,,** No join mapping for associatedReferences ** 

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

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

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

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

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

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

georeferencedBy,,** No join mapping for georeferencedBy ** 

georeferencedDate,,** No join mapping for georeferencedDate ** 

higherClassification,,** No join mapping for higherClassification ** 

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

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

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

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

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

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

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

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

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

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

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

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

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

verbatimEventDate,,** No join mapping for verbatimEventDate ** 

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

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>

                    <_alt>

                        <1>

                            <_units>

                                <to>m</to>

                                <to></to>

                                <value>$verbatimElevation</value>

                            </_units>

                        </1>

                        <2>

                            <_avg>

                                <max>$maximumElevationInMeters</max>

                                <min>$minimumElevationInMeters</min>

                            </_avg>

                        </2>

                    </_alt>

                </elevation_m>

                <locationevent>

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

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

                    <taxonoccurrence>

                        <aggregateoccurrence>

                            <plantobservation>

                                <collectionnumber>$recordNumber</collectionnumber>

                                <definedvalue fkey="tablerecord_id">

                                    <userdefined_id>

                                        <userdefined>

                                            <tablename>plantobservation</tablename>

                                            <userdefinedname>sex</userdefinedname>

                                        </userdefined>

                                    </userdefined_id>

                                    <definedvalue>$sex</definedvalue>

                                </definedvalue>

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

                        <iscultivated>

                            <_map>

                                <cultivated>t</cultivated>

                                <wild>f</wild>

                                <*></*>

                                <value>$establishmentMeans</value>

                            </_map>

                        </iscultivated>

                        <isnative>

                            <_map>

                                <native>t</native>

                                <exotic>f</exotic>

                                <*></*>

                                <value>$establishmentMeans</value>

                            </_map>

                        </isnative>

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

                                                                                                                    <parent_id>

                                                                                                                        <taxonlabel>

                                                                                                                            <rank>class</rank>

                                                                                                                            <parent_id>

                                                                                                                                <taxonlabel>

                                                                                                                                    <rank>phylum</rank>

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

                            <taxonfit>$identificationQualifier</taxonfit>

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

                                    <coordsaccuracy_m><_noCV><value>$coordinateUncertaintyInMeters</value></_noCV></coordsaccuracy_m>

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

                                    <verbatimlatitude>$verbatimLatitude</verbatimlatitude>

                                    <verbatimlongitude>$verbatimLongitude</verbatimlongitude>

                                </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 42 new rows into database

reproductiveCondition

typeStatus

occurrenceRemarks

associatedReferences

georeferenceProtocol

dcterms:type

institutionID

dcterms:rights

dcterms:rightsHolder

georeferencedBy

georeferenceRemarks

geodeticDatum

verbatimCoordinates

verbatimEventDate

georeferenceVerificationStatus

associatedMedia

datasetID

georeferencedDate

dcterms:bibliographicCitation

nomenclaturalCode

datasetName

ownerInstitutionCode

basisOfRecord

georeferenceSources

previousIdentifications

verbatimCoordinateSystem

locationRemarks

higherClassification

verbatimSRS

municipality

otherCatalogNumbers

dcterms:language