HVAA,VegCore,Filter,Comments

:herbarium,referenceType,,

:specimen,observationGranularity,,

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

:specimen,"/_if[@name=""if specimen""]/else/source:[shortname/_first/2/_env:[name=source]]/observationtype",

:herbarium,"/_if[@name=""if specimen""]/else/source:[shortname/_first/2/_env:[name=source]]/sourcetype",

:specimen,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/cond/_eq:[right=plot]/left",

Put template:

<VegBIEN>

    <_setDefault id="-1">

        <source_id><source><shortname>HVAA</shortname></source></source_id>

        <path>

            <_simplifyPath>

                <next>parent_id</next>

                <path>

                    <source>

                        <shortname>HVAA</shortname>

                        <observationtype>specimen</observationtype>

                        <sourcetype>herbarium</sourcetype>

                    </source>

                </path>

            </_simplifyPath>

        </path>

    </_setDefault>

</VegBIEN>

Inserted 0 new rows into database

HVAA,VegCore,Filter,Comments

institutionCode,custodialInstitutions,,

collectionCode,collection,,

basisOfRecord,basisOfRecord,,

catalogNumber,catalogNumber,,

otherCatalogNumbers,otherCatalogNumbers,,

ownerInstitutionCode,ownerInstitutionCode,,

family,family,,

scientificName,scientificName,,

genus,genus,,

specificEpithet,specificEpithet,,

taxonRank,taxonRank,,

infraspecificEpithet,infraspecificEpithet,,

scientificNameAuthorship,scientificNameAuthorship,,

taxonRemarks,taxonRemarks,,

identifiedBy,identifiedBy,,

dateIdentified,dateIdentified,,

identificationReferences,identificationReferences,,

identificationRemarks,identificationRemarks,,

identificationQualifier,identificationQualifier,,

typeStatus,typeStatus,,

recordedBy,recordedBy,,

recordNumber,collectorNumber,,

eventDate,eventDate,,

year,year,,

month,month,,

day,day,,

startDayOfYear,startDayOfYear,,

endDayOfYear,endDayOfYear,,

verbatimEventDate,verbatimEventDate,,

habitat,habitat,,

fieldNotes,organismNotes,,

fieldNumber,collectorNumber,,

occurrenceRemarks,occurrenceRemarks,,

dynamicProperties,dynamicProperties,,

associatedTaxa,associatedTaxa,,

reproductiveCondition,reproductiveCondition,,

establishmentMeans,establishmentMeans,,

lifeStage,lifeStage,,

sex,sex,,

individualCount,individualCount,,

samplingProtocol,samplingProtocol,,

preparations,preparations,,

country,country,,

stateProvince,stateProvince,,

county,county,,

municipality,municipality,,

locality,locality,,

decimalLatitude,decimalLatitude,,

decimalLongitude,decimalLongitude,,

geodeticDatum,geodeticDatum,,

coordinateUncertaintyInMeters,coordinateUncertaintyInMeters,,

footprintWKT,footprintWKT,,

coordinatePrecision,*coordinatePrecision,,

locationRemarks,locationRemarks,,

verbatimCoordinates,verbatimCoordinates,,

verbatimCoordinateSystem,verbatimCoordinateSystem,,

georeferencedBy,georeferencedBy,,

georeferenceProtocol,georeferenceProtocol,,

georeferenceSources,georeferenceSources,,

georeferenceVerificationStatus,georeferenceVerificationStatus,,

georeferenceRemarks,georeferenceRemarks,,

minimumElevationInMeters,minimumElevationInMeters,,

maximumElevationInMeters,maximumElevationInMeters,,

verbatimElevation,verbatimElevation,,

disposition,disposition,,

modified,modified,,

language,language,,

rights,rights,,

rightsHolder,rightsHolder,,

accessRights,accessRights,,

symbiotaId,occurrenceID,,

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

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

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

institutionCode,"/_if[@name=""if specimen""]/else/source/shortname/_first/1",

symbiotaId,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_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",

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

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

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

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

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

rights,/location/accessconditions,

accessRights,/location/accesslevel,

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,

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

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

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

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

habitat,/location/iscultivated/_or/2/_locationnarrative_is_cultivated/locationnarrative/_join/3,

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

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,

dateIdentified,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/determinationdate/_alt/1/_dateRangeStart/value",

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

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

individualCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/count,

fieldNotes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,

fieldNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2,

recordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2,

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

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

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

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

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

institutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/name/_first/2",

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

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

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

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

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

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

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

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

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

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

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

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

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/_merge_prefix/prefix/_taxon_family_require_std/family,

scientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_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,

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

infraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_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/_merge_prefix/value/_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/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2,

scientificNameAuthorship,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_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,

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

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

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

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

recordNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/collectionnumber/_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,

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

verbatimCoordinates,/location/locationplace/*_id/place/*_id/coordinates/verbatimcoordinates,

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,

locationRemarks,/location/notespublic,

verbatimElevation,/location/verbatimelevation,

associatedTaxa,,** No join mapping for associatedTaxa ** 

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

coordinatePrecision,,** No join mapping for *coordinatePrecision ** 

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

disposition,,** No join mapping for disposition ** 

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

endDayOfYear,,** No join mapping for endDayOfYear ** 

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

identificationReferences,,** No join mapping for identificationReferences ** 

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

language,,** No join mapping for language ** 

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

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

month,,** No join mapping for month ** 

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

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

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

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

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

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

rightsHolder,,** No join mapping for rightsHolder ** 

startDayOfYear,,** No join mapping for startDayOfYear ** 

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

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

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

year,,** No join mapping for year ** 

Put template:

<VegBIEN>

    <_setDefault id="-1">

        <source_id><source><shortname>HVAA</shortname></source></source_id>

        <path>

            <_simplifyPath>

                <next>parent_id</next>

                <path>

                    <location>

                        <authorlocationcode>

                            <_alt>

                                <1>$symbiotaId</1>

                                <2>

                                    <_join>

                                        <1>$institutionCode</1>

                                        <2>$collectionCode</2>

                                        <3>$catalogNumber</3>

                                    </_join>

                                </2>

                            </_alt>

                        </authorlocationcode>

                        <accessconditions>$rights</accessconditions>

                        <accesslevel>$accessRights</accesslevel>

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

                        <iscultivated>

                            <_locationnarrative_is_cultivated>

                                <locationnarrative>

                                    <_join>

                                        <1>$locality</1>

                                        <3>$habitat</3>

                                    </_join>

                                </locationnarrative>

                            </_locationnarrative_is_cultivated>

                        </iscultivated>

                        <locationevent>

                            <method_id><method><name>$samplingProtocol</name></method></method_id>

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

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

                            <taxonoccurrence>

                                <aggregateoccurrence>

                                    <count>$individualCount</count>

                                    <notes>$fieldNotes</notes>

                                    <plantobservation>

                                        <authorplantcode>

                                            <_alt>

                                                <0>$fieldNumber</0>

                                                <1>$recordNumber</1>

                                            </_alt>

                                        </authorplantcode>

                                        <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>$collectionCode</collectioncode_dwc>

                                            <collectionnumber>

                                                <_alt>

                                                    <0>$fieldNumber</0>

                                                    <1>$recordNumber</1>

                                                </_alt>

                                            </collectionnumber>

                                            <institution_id>

                                                <sourcelist>

                                                    <name>$institutionCode</name>

                                                    <sourcename>

                                                        <name>

                                                            <_split>

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

                                                                <value>$institutionCode</value>

                                                            </_split>

                                                        </name>

                                                    </sourcename>

                                                </sourcelist>

                                            </institution_id>

                                            <sourceaccessioncode>$symbiotaId</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>$symbiotaId</sourceaccessioncode>

                                <taxondetermination>

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

                                    <taxonverbatim_id>

                                        <taxonverbatim>

                                            <taxonlabel_id>

                                                <taxonlabel>

                                                    <parent_id>

                                                        <taxonlabel>

                                                            <rank>$taxonRank</rank>

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

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

                                                        <_merge_prefix>

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

                                                            <value>

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

                                                            </value>

                                                        </_merge_prefix>

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

                                    <notes>$taxonRemarks</notes>

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

                                            <footprintgeometry_dwc>$footprintWKT</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>

                                            <verbatimcoordinates>$verbatimCoordinates</verbatimcoordinates>

                                        </coordinates>

                                    </coordinates_id>

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

                        <notespublic>$locationRemarks</notespublic>

                        <verbatimelevation>$verbatimElevation</verbatimelevation>

                    </location>

                </path>

            </_simplifyPath>

        </path>

    </_setDefault>

</VegBIEN>

Inserted 39 new rows into database

symbiotaId,occurrenceID,,

basisOfRecord

otherCatalogNumbers

ownerInstitutionCode

identificationReferences

identificationRemarks

typeStatus

year

month

day

startDayOfYear

endDayOfYear

verbatimEventDate

occurrenceRemarks

dynamicProperties

associatedTaxa

reproductiveCondition

lifeStage

preparations

municipality

geodeticDatum

*coordinatePrecision

verbatimCoordinateSystem

georeferencedBy

georeferenceProtocol

georeferenceSources

georeferenceVerificationStatus

georeferenceRemarks

disposition

modified

language

rightsHolder

Source

Specimen