WIN,VegCore,Filter,Comments

id,occurrenceID,,

municipality,municipality,,

verbatimLongitude,verbatimLongitude,,

rightsHolder,dcterms:rightsHolder,,

scientificNameAuthorship,scientificNameAuthorship,,

associatedMedia,associatedMedia,,

verbatimSRS,verbatimSRS,,

dateIdentified,dateIdentified,,

datasetID,datasetID,,

bibliographicCitation,dcterms:bibliographicCitation,,

taxonRank,taxonRank,,

rights,dcterms:rights,,

occurrenceRemarks,occurrenceRemarks,,

verbatimElevation,verbatimElevation,,

eventDate,eventDate,,

recordNumber,recordNumber,,

county,county,,

type,dcterms:type,,

stateProvince,stateProvince,,

locality,locality,,

scientificName,scientificName,,

country,country,,

specificEpithet,specificEpithet,,

coordinateUncertaintyInMeters,coordinateUncertaintyInMeters,,

verbatimEventDate,verbatimEventDate,,

habitat,habitat,,

identifiedBy,identifiedBy,,

minimumElevationInMeters,minimumElevationInMeters,,

datasetName,datasetName,,

basisOfRecord,basisOfRecord,,

collectionID,collectionID,,

collectionCode,collectionCode,,

verbatimCoordinates,verbatimCoordinates,,

decimalLatitude,decimalLatitude,,

institutionCode,institutionCode,,

catalogNumber,catalogNumber,,

verbatimLatitude,verbatimLatitude,,

identificationRemarks,identificationRemarks,,

nomenclaturalCode,nomenclaturalCode,,

recordedBy,recordedBy,,

infraspecificEpithet,infraspecificEpithet,,

kingdom,kingdom,,

decimalLongitude,decimalLongitude,,

genus,genus,,

verbatimCoordinateSystem,verbatimCoordinateSystem,,

language,dcterms:language,,

geodeticDatum,geodeticDatum,,

ownerInstitutionCode,ownerInstitutionCode,,

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

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,

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,

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

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

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,

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

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,

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

                                            </taxonomicname>

                                        </taxonlabel>

                                    </taxonlabel_id>

                                    <author>$scientificNameAuthorship</author>

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

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

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

municipality

dcterms:rightsHolder

associatedMedia

verbatimSRS

datasetID

dcterms:bibliographicCitation

dcterms:rights

occurrenceRemarks

dcterms:type

verbatimEventDate

datasetName

basisOfRecord

verbatimCoordinates

identificationRemarks

nomenclaturalCode

verbatimCoordinateSystem

dcterms:language

geodeticDatum

ownerInstitutionCode