VASCAN,VegCore,Filter,Comments

id,taxonID,,

nameAccordingTo,nameAccordingTo,,

nameAccordingToID,nameAccordingToID,,

datasetID,datasetID,,

references,dcterms:references,,

specificEpithet,specificEpithet,,

higherClassification,higherClassification,,

genus,genus,,

order,order,,

rightsHolder,dcterms:rightsHolder,,

bibliographicCitation,dcterms:bibliographicCitation,,

language,dcterms:language,,

family,family,,

acceptedNameUsageID,acceptedNameUsageID,,

rights,dcterms:rights,,

taxonRank,taxonRank,,

taxonomicStatus,taxonomicStatus,,

infraspecificEpithet,infraspecificEpithet,,

datasetName,datasetName,,

class,class,,

parentNameUsage,parentNameUsage,,

parentNameUsageID,parentNameUsageID,,

modified,dcterms:modified,,

acceptedNameUsage,acceptedNameUsage,,

scientificNameAuthorship,scientificNameAuthorship,,

subgenus,subgenus,,

scientificName,scientificName,,

kingdom,kingdom,,

nomenclaturalCode,nomenclaturalCode,,

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

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

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

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

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

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

genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/_if[@name=""if is canonical name""]/then/matched_label_id/taxonlabel:[source_id/source/shortname=NCBI]/taxonomicname",

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

family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=family]/_if[@name=""if is canonical name""]/then/matched_label_id/taxonlabel:[source_id/source/shortname=NCBI]/taxonomicname",

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

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

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

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,

id,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/sourceaccessioncode,

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,

taxonomicStatus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonstatus,

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,

acceptedNameUsage,,** No join mapping for acceptedNameUsage ** 

acceptedNameUsageID,,** No join mapping for acceptedNameUsageID ** 

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

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

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

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

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

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

nameAccordingTo,,** No join mapping for nameAccordingTo ** 

nameAccordingToID,,** No join mapping for nameAccordingToID ** 

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

parentNameUsage,,** No join mapping for parentNameUsage ** 

parentNameUsageID,,** No join mapping for parentNameUsageID ** 

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

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

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

subgenus,,** No join mapping for subgenus ** 

Put template:

<VegBIEN>

    <_simplifyPath id="-1">

        <next>parent_id</next>

        <path>

            <location>

                <locationevent>

                    <taxonoccurrence>

                        <taxondetermination>

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

                                            <parent_id>

                                                <taxonlabel>

                                                    <rank>$taxonRank</rank>

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

                                                    <parent_id>

                                                        <taxonlabel>

                                                            <rank>cultivar</rank>

                                                            <parent_id>

                                                                <taxonlabel>

                                                                    <rank>forma</rank>

                                                                    <parent_id>

                                                                        <taxonlabel>

                                                                            <rank>variety</rank>

                                                                            <parent_id>

                                                                                <taxonlabel>

                                                                                    <rank>subspecies</rank>

                                                                                    <parent_id>

                                                                                        <taxonlabel>

                                                                                            <rank>species</rank>

                                                                                            <taxonepithet>$specificEpithet</taxonepithet>

                                                                                            <parent_id>

                                                                                                <taxonlabel>

                                                                                                    <rank>genus</rank>

                                                                                                    <taxonepithet>$genus</taxonepithet>

                                                                                                    <parent_id>

                                                                                                        <taxonlabel>

                                                                                                            <rank>family</rank>

                                                                                                            <taxonepithet>$family</taxonepithet>

                                                                                                            <parent_id>

                                                                                                                <taxonlabel>

                                                                                                                    <rank>order</rank>

                                                                                                                    <taxonepithet>$order</taxonepithet>

                                                                                                                    <parent_id>

                                                                                                                        <taxonlabel>

                                                                                                                            <rank>class</rank>

                                                                                                                            <taxonepithet>$class</taxonepithet>

                                                                                                                            <parent_id>

                                                                                                                                <taxonlabel>

                                                                                                                                    <rank>phylum</rank>

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

                                            <sourceaccessioncode>$id</sourceaccessioncode>

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

                                            <taxonstatus>$taxonomicStatus</taxonstatus>

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

                        </taxondetermination>

                    </taxonoccurrence>

                </locationevent>

            </location>

        </path>

    </_simplifyPath>

</VegBIEN>

Inserted 13 new rows into database

nameAccordingTo

nameAccordingToID

datasetID

dcterms:references

higherClassification

dcterms:rightsHolder

dcterms:bibliographicCitation

dcterms:language

acceptedNameUsageID

dcterms:rights

datasetName

parentNameUsage

parentNameUsageID

dcterms:modified

acceptedNameUsage

subgenus

nomenclaturalCode