Name_number,OMIT,,Identifies name only within one TNRS batch. Omitted because not globally unique.

Name_submitted,OMIT,,Omitted because taxonoccurrence_id used to identify the taxonoccurrence instead

Name_matched,taxonName,,

Name_matched_rank,taxonRank,,

Name_matched_author,scientificNameAuthorship,/_first/1,Contains author based on matched name

Name_matched_url,scientificNameID,,

Author_matched,scientificNameAuthorship,/_first/2,Contains author in original string

Family_matched,family,/_first/2,Contains family in original string (uncommon)

Name_matched_accepted_family,family,/_first/1,Contains family based on matched name

Genus_matched,genus,,

Specific_epithet_matched,specificEpithet,,

Infraspecific_epithet_matched,infraspecificEpithet,,

Unmatched_terms,morphospeciesSuffix,,

Accepted_name,acceptedTaxonName,/_first/1,

Accepted_name_author,acceptedScientificNameAuthorship,/_first/1,

Accepted_name_rank,acceptedTaxonRank,/_first/1,

Accepted_name_family,acceptedFamily,/_first/1/_nullIf:[null=Unknown]/value,

Max_score,matchedTaxonConfidence_fraction,/_first/1,

Accepted_name.Name_number,OMIT,/_first/2,Identifies name only within one TNRS batch. Omitted because not globally unique.

Accepted_name.Name_submitted,acceptedScientificName,/_first/2,

Accepted_name.Overall_score,OMIT,/_first/2,Scores come from the matched name instead

Accepted_name.Name_matched,acceptedTaxonName,/_first/2,

Accepted_name.Name_matched_rank,acceptedTaxonRank,/_first/2,

Accepted_name.Name_score,OMIT,/_first/2,Scores come from the matched name instead

Accepted_name.Name_matched_author,acceptedScientificNameAuthorship,/_first/2/_first/1,

Accepted_name.Name_matched_url,acceptedScientificNameID,/_first/2,

Accepted_name.Author_matched,acceptedScientificNameAuthorship,/_first/2/_first/2,

Accepted_name.Author_score,OMIT,/_first/2,Scores come from the matched name instead

Accepted_name.Family_matched,acceptedFamily,/_first/2/_first/2,

Accepted_name.Family_score,OMIT,/_first/2,Scores come from the matched name instead

Accepted_name.Name_matched_accepted_family,acceptedFamily,/_first/2/_first/1,

Accepted_name.Genus_matched,acceptedGenus,/_first/2,

Accepted_name.Genus_score,OMIT,/_first/2,Scores come from the matched name instead

Accepted_name.Specific_epithet_matched,acceptedSpecificEpithet,/_first/2,

Accepted_name.Specific_epithet_score,OMIT,/_first/2,Scores come from the matched name instead

Accepted_name.Infraspecific_rank,OMIT,,Omitted because Accepted_name.Name_matched_rank is populated more often

Accepted_name.Infraspecific_epithet_matched,acceptedInfraspecificEpithet,/_first/2,

Accepted_name.Infraspecific_epithet_score,OMIT,/_first/2,Scores come from the matched name instead

Accepted_name.Infraspecific_epithet_2_score,OMIT,/_first/2,Scores come from the matched name instead

Accepted_name.Unmatched_terms,OMIT,/_first/2,Should be empty

Accepted_name.Taxonomic_status,acceptedTaxonomicStatus,/_first/2,

Accepted_name.Accepted_name,acceptedTaxonName,/_first/3,

Accepted_name.Accepted_name_author,acceptedScientificNameAuthorship,/_first/3,

Accepted_name.Accepted_name_rank,acceptedTaxonRank,/_first/3,

Accepted_name.Accepted_name_family,acceptedFamily,/_first/3,

Accepted_name.Accepted_scientific_name,acceptedScientificName,/_first/3,

Accepted_name.Max_score,OMIT,/_first/2,Scores come from the matched name instead

*Time_submitted

*Name_score

*Author_score

*Infraspecific_epithet_score

*Accepted_name_url

*Accepted_name_species

*Selected

source

*Warnings

*Accepted_name_lsid

*Accepted_name.Time_submitted

*Accepted_name.Annotations

acceptedTaxonomicStatus

*Accepted_name.Accepted_name_url

*Accepted_name.Accepted_name_species

*Accepted_name.Selected

*Accepted_name.Source

*Accepted_name.Warnings

*Accepted_name.Accepted_name_lsid

taxonoccurrence_id,Time_submitted,Name_number,Name_submitted,Overall_score,Name_matched,Name_matched_rank,Name_score,Name_matched_author,Name_matched_url,Author_matched,Author_score,Family_matched,Family_score,Name_matched_accepted_family,Genus_matched,Genus_score,Specific_epithet_matched,Specific_epithet_score,Infraspecific_rank,Infraspecific_epithet_matched,Infraspecific_epithet_score,Infraspecific_rank_2,Infraspecific_epithet_2_matched,Infraspecific_epithet_2_score,Annotations,Unmatched_terms,Taxonomic_status,Selected,Source,Warnings

TNRS,VegCore,Filter,Comments

taxonoccurrence_id,taxonOccurrencePkey,,

Time_submitted,*Time_submitted,,

Name_number,OMIT,,Identifies name only within one TNRS batch. Omitted because not globally unique.

Name_submitted,OMIT,,Omitted because taxonoccurrence_id used to identify the taxonoccurrence instead

Overall_score,matchedTaxonConfidence_fraction,/_first/2,Assuming is a fraction based on the range of values

Name_matched,taxonName,,

Name_matched_rank,taxonRank,,

Name_score,*Name_score,,

Name_matched_author,scientificNameAuthorship,/_first/1,Contains author based on matched name

Name_matched_url,scientificNameID,,

Author_matched,scientificNameAuthorship,/_first/2,Contains author in original string

Author_score,*Author_score,,

Family_matched,family,/_first/2,Contains family in original string (uncommon)

Family_score,matchedFamilyConfidence_fraction,,

Name_matched_accepted_family,family,/_first/1,Contains family based on matched name

Genus_matched,genus,,

Genus_score,matchedGenusConfidence_fraction,,

Specific_epithet_matched,specificEpithet,,

Specific_epithet_score,matchedSpeciesConfidence_fraction,,

Infraspecific_rank,OMIT,,Omitted because Name_matched_rank is populated more often

Infraspecific_epithet_matched,infraspecificEpithet,,

Infraspecific_epithet_score,*Infraspecific_epithet_score,,

Infraspecific_rank_2,UNUSED,,

Infraspecific_epithet_2_matched,UNUSED,,

Infraspecific_epithet_2_score,UNUSED,,

Annotations,identificationQualifier,,

Unmatched_terms,morphospeciesSuffix,,

Taxonomic_status,taxonomicStatus,,

Accepted_name,acceptedTaxonName,/_first/1,

Accepted_name_author,acceptedScientificNameAuthorship,/_first/1,

Accepted_name_rank,acceptedTaxonRank,/_first/1,

Accepted_name_url,*Accepted_name_url,/_first/1,

Accepted_name_species,*Accepted_name_species,/_first/1,Also contains genus. Omitted because Accepted_name contains more info.

Accepted_name_family,acceptedFamily,/_first/1/_nullIf:[null=Unknown]/value,

Selected,*Selected,,

Source,source,,

Warnings,*Warnings,,

Accepted_name_lsid,*Accepted_name_lsid,/_first/2,

Accepted_scientific_name,acceptedScientificName,/_first/1,

Max_score,matchedTaxonConfidence_fraction,/_first/1,

Accepted_name.Time_submitted,*Accepted_name.Time_submitted,/_first/2,

Accepted_name.Name_number,OMIT,/_first/2,Identifies name only within one TNRS batch. Omitted because not globally unique.

Accepted_name.Name_submitted,acceptedScientificName,/_first/2,

Accepted_name.Overall_score,OMIT,/_first/2,Scores come from the matched name instead

Accepted_name.Name_matched,acceptedTaxonName,/_first/2,

Accepted_name.Name_matched_rank,acceptedTaxonRank,/_first/2,

Accepted_name.Name_score,OMIT,/_first/2,Scores come from the matched name instead

Accepted_name.Name_matched_author,acceptedScientificNameAuthorship,/_first/2/_first/1,

Accepted_name.Name_matched_url,acceptedScientificNameID,/_first/2,

Accepted_name.Author_matched,acceptedScientificNameAuthorship,/_first/2/_first/2,

Accepted_name.Author_score,OMIT,/_first/2,Scores come from the matched name instead

Accepted_name.Family_matched,acceptedFamily,/_first/2/_first/2,

Accepted_name.Family_score,OMIT,/_first/2,Scores come from the matched name instead

Accepted_name.Name_matched_accepted_family,acceptedFamily,/_first/2/_first/1,

Accepted_name.Genus_matched,acceptedGenus,/_first/2,

Accepted_name.Genus_score,OMIT,/_first/2,Scores come from the matched name instead

Accepted_name.Specific_epithet_matched,acceptedSpecificEpithet,/_first/2,

Accepted_name.Specific_epithet_score,OMIT,/_first/2,Scores come from the matched name instead

Accepted_name.Infraspecific_rank,OMIT,,Omitted because Accepted_name.Name_matched_rank is populated more often

Accepted_name.Infraspecific_epithet_matched,acceptedInfraspecificEpithet,/_first/2,

Accepted_name.Infraspecific_epithet_score,OMIT,/_first/2,Scores come from the matched name instead

Accepted_name.Infraspecific_rank_2,UNUSED,/_first/2,

Accepted_name.Infraspecific_epithet_2_matched,UNUSED,/_first/2,

Accepted_name.Infraspecific_epithet_2_score,OMIT,/_first/2,Scores come from the matched name instead

Accepted_name.Annotations,*Accepted_name.Annotations,/_first/2,

Accepted_name.Unmatched_terms,OMIT,/_first/2,Should be empty

Accepted_name.Taxonomic_status,acceptedTaxonomicStatus,/_first/2,

Accepted_name.Accepted_name,acceptedTaxonName,/_first/3,

Accepted_name.Accepted_name_author,acceptedScientificNameAuthorship,/_first/3,

Accepted_name.Accepted_name_rank,acceptedTaxonRank,/_first/3,

Accepted_name.Accepted_name_url,*Accepted_name.Accepted_name_url,/_first/3,

Accepted_name.Accepted_name_species,*Accepted_name.Accepted_name_species,/_first/3,

Accepted_name.Accepted_name_family,acceptedFamily,/_first/3,

Accepted_name.Selected,*Accepted_name.Selected,/_first/2,

Accepted_name.Source,*Accepted_name.Source,/_first/2,

Accepted_name.Warnings,*Accepted_name.Warnings,/_first/2,

Accepted_name.Accepted_name_lsid,*Accepted_name.Accepted_name_lsid,/_first/3,

Accepted_name.Accepted_scientific_name,acceptedScientificName,/_first/3,

Accepted_name.Max_score,OMIT,/_first/2,Scores come from the matched name instead

:true,taxonIsCanonical,,"This table contains only canonicalized names. (Not all names are accepted, but those that aren’t don’t (yet) have an accepted match.)"

:matched,identificationType,,

:_,dateIdentified,/_now,

:0,taxonOccurrenceID,,Enables the taxonoccurrence CHECK constraint to pass

Put template:

<VegBIEN>

    <_setDefault id="-1">

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

        <path>

            <_simplifyPath>

                <next>parent_id</next>

                <path>

                    <location>

                        <locationevent>

                            <taxonoccurrence>

                                <taxondetermination>

                                    <determinationtype>accepted</determinationtype>

                                    <taxonverbatim_id>

                                        <taxonverbatim>

                                            <taxonlabel_id>

                                                <taxonlabel>

                                                    <taxonstatus>Accepted</taxonstatus>

                                                    <matched_label_id>0</matched_label_id>

                                                    <parent_id>

                                                        <taxonlabel>

                                                            <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>$Accepted_name.Specific_epithet_matched</taxonepithet>

                                                                                                    <parent_id>

                                                                                                        <taxonlabel>

                                                                                                            <rank>genus</rank>

                                                                                                            <matched_label_id>

                                                                                                                <taxonlabel>

                                                                                                                    <source_id><source><shortname>NCBI</shortname></source></source_id>

                                                                                                                    <taxonomicname>$Accepted_name.Genus_matched</taxonomicname>

                                                                                                                </taxonlabel>

                                                                                                            </matched_label_id>

                                                                                                            <taxonepithet>$Accepted_name.Genus_matched</taxonepithet>

                                                                                                            <parent_id>

                                                                                                                <taxonlabel>

                                                                                                                    <rank>family</rank>

                                                                                                                    <matched_label_id>

                                                                                                                        <taxonlabel>

                                                                                                                            <source_id><source><shortname>NCBI</shortname></source></source_id>

                                                                                                                            <taxonomicname>

                                                                                                                                <_nullIf>

                                                                                                                                    <null>Unknown</null>

                                                                                                                                    <value>$Accepted_name_family</value>

                                                                                                                                </_nullIf>

                                                                                                                            </taxonomicname>

                                                                                                                        </taxonlabel>

                                                                                                                    </matched_label_id>

                                                                                                                    <taxonepithet>

                                                                                                                        <_nullIf>

                                                                                                                            <null>Unknown</null>

                                                                                                                            <value>$Accepted_name_family</value>

                                                                                                                        </_nullIf>

                                                                                                                    </taxonepithet>

                                                                                                                </taxonlabel>

                                                                                                            </parent_id>

                                                                                                        </taxonlabel>

                                                                                                    </parent_id>

                                                                                                </taxonlabel>

                                                                                            </parent_id>

                                                                                        </taxonlabel>

                                                                                    </parent_id>

                                                                                </taxonlabel>

                                                                            </parent_id>

                                                                        </taxonlabel>

                                                                    </parent_id>

                                                                </taxonlabel>

                                                            </parent_id>

                                                            <rank>$Accepted_name_rank</rank>

                                                            <taxonepithet>$Accepted_name.Infraspecific_epithet_matched</taxonepithet>

                                                        </taxonlabel>

                                                    </parent_id>

                                                    <rank>$Accepted_name_rank</rank>

                                                    <sourceaccessioncode>$Accepted_name.Name_matched_url</sourceaccessioncode>

                                                    <taxonomicname>

                                                        <_merge_prefix>

                                                            <prefix>

                                                                <_taxon_family_require_std>

                                                                    <family>

                                                                        <_nullIf>

                                                                            <null>Unknown</null>

                                                                            <value>$Accepted_name_family</value>

                                                                        </_nullIf>

                                                                    </family>

                                                                </_taxon_family_require_std>

                                                            </prefix>

                                                            <value>

                                                                <_alt>

                                                                    <1>$Accepted_scientific_name</1>

                                                                    <2>

                                                                        <_join_words>

                                                                            <1>

                                                                                <_alt>

                                                                                    <1>$Accepted_name</1>

                                                                                    <2>

                                                                                        <_join_words>

                                                                                            <2>$Accepted_name.Genus_matched</2>

                                                                                            <3>$Accepted_name.Specific_epithet_matched</3>

                                                                                            <5>

                                                                                                <_join_words>

                                                                                                    <1>

                                                                                                        <_if name="if has infraspecificEpithet">

                                                                                                            <cond>$Accepted_name.Infraspecific_epithet_matched</cond>

                                                                                                            <then>$Accepted_name_rank</then>

                                                                                                        </_if>

                                                                                                    </1>

                                                                                                    <2>$Accepted_name.Infraspecific_epithet_matched</2>

                                                                                                </_join_words>

                                                                                            </5>

                                                                                        </_join_words>

                                                                                    </2>

                                                                                </_alt>

                                                                            </1>

                                                                            <2>$Accepted_name_author</2>

                                                                        </_join_words>

                                                                    </2>

                                                                </_alt>

                                                            </value>

                                                        </_merge_prefix>

                                                    </taxonomicname>

                                                </taxonlabel>

                                            </taxonlabel_id>

                                            <author>$Accepted_name_author</author>

                                            <family>

                                                <_nullIf>

                                                    <null>Unknown</null>

                                                    <value>$Accepted_name_family</value>

                                                </_nullIf>

                                            </family>

                                            <genus>$Accepted_name.Genus_matched</genus>

                                            <morphospecies>$Unmatched_terms</morphospecies>

                                            <specific_epithet>$Accepted_name.Specific_epithet_matched</specific_epithet>

                                            <taxonname>$Accepted_name</taxonname>

                                            <taxonomicname>$Accepted_scientific_name</taxonomicname>

                                            <verbatimrank>$Accepted_name_rank</verbatimrank>

                                        </taxonverbatim>

                                    </taxonverbatim_id>

                                    <determinationdate><_dateRangeStart><value><_now>_</_now></value></_dateRangeStart></determinationdate>

                                    <taxonconfidence>

                                        <_max>

                                            <1>$Family_score</1>

                                            <2>$Genus_score</2>

                                            <3>$Specific_epithet_score</3>

                                            <4>$Max_score</4>

                                        </_max>

                                    </taxonconfidence>

                                    <taxonfit>$Annotations</taxonfit>

                                </taxondetermination>

                                <sourceaccessioncode>0</sourceaccessioncode>

                                <taxondetermination>

                                    <taxonverbatim_id>

                                        <taxonverbatim>

                                            <taxonlabel_id>

                                                <taxonlabel>

                                                    <matched_label_id>0</matched_label_id>

                                                    <parent_id>

                                                        <taxonlabel>

                                                            <rank>$Name_matched_rank</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>$Specific_epithet_matched</taxonepithet>

                                                                                                    <parent_id>

                                                                                                        <taxonlabel>

                                                                                                            <rank>genus</rank>

                                                                                                            <taxonepithet>$Genus_matched</taxonepithet>

                                                                                                            <parent_id>

                                                                                                                <taxonlabel>

                                                                                                                    <rank>family</rank>

                                                                                                                    <taxonepithet>$Name_matched_accepted_family</taxonepithet>

                                                                                                                </taxonlabel>

                                                                                                            </parent_id>

                                                                                                        </taxonlabel>

                                                                                                    </parent_id>

                                                                                                </taxonlabel>

                                                                                            </parent_id>

                                                                                        </taxonlabel>

                                                                                    </parent_id>

                                                                                </taxonlabel>

                                                                            </parent_id>

                                                                        </taxonlabel>

                                                                    </parent_id>

                                                                </taxonlabel>

                                                            </parent_id>

                                                            <taxonepithet>$Infraspecific_epithet_matched</taxonepithet>

                                                        </taxonlabel>

                                                    </parent_id>

                                                    <rank>$Name_matched_rank</rank>

                                                    <sourceaccessioncode>$Name_matched_url</sourceaccessioncode>

                                                    <taxonomicname>

                                                        <_merge_prefix>

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

                                                            <value>

                                                                <_join_words>

                                                                    <1>

                                                                        <_alt>

                                                                            <1>$Name_matched</1>

                                                                            <2>

                                                                                <_join_words>

                                                                                    <2>$Genus_matched</2>

                                                                                    <3>$Specific_epithet_matched</3>

                                                                                    <5>

                                                                                        <_join_words>

                                                                                            <1>

                                                                                                <_if name="if has infraspecificEpithet">

                                                                                                    <cond>$Infraspecific_epithet_matched</cond>

                                                                                                    <then>$Name_matched_rank</then>

                                                                                                </_if>

                                                                                            </1>

                                                                                            <2>$Infraspecific_epithet_matched</2>

                                                                                        </_join_words>

                                                                                    </5>

                                                                                </_join_words>

                                                                            </2>

                                                                        </_alt>

                                                                    </1>

                                                                    <2>$Name_matched_author</2>

                                                                </_join_words>

                                                            </value>

                                                        </_merge_prefix>

                                                    </taxonomicname>

                                                    <taxonstatus>$Taxonomic_status</taxonstatus>

                                                </taxonlabel>

                                            </taxonlabel_id>

                                            <author>$Name_matched_author</author>

                                            <family>$Name_matched_accepted_family</family>

                                            <genus>$Genus_matched</genus>

                                            <morphospecies>$Unmatched_terms</morphospecies>

                                            <specific_epithet>$Specific_epithet_matched</specific_epithet>

                                            <taxonname>$Name_matched</taxonname>

                                            <verbatimrank>$Name_matched_rank</verbatimrank>

                                        </taxonverbatim>

                                    </taxonverbatim_id>

                                    <taxonconfidence>

                                        <_max>

                                            <1>$Family_score</1>

                                            <2>$Genus_score</2>

                                            <3>$Specific_epithet_score</3>

                                            <4>$Max_score</4>

                                        </_max>

                                    </taxonconfidence>

                                    <determinationdate><_dateRangeStart><value><_now>_</_now></value></_dateRangeStart></determinationdate>

                                    <determinationtype>matched</determinationtype>

                                    <taxonfit>$Annotations</taxonfit>

                                </taxondetermination>

                                <taxonoccurrence_id>$taxonoccurrence_id</taxonoccurrence_id>

                            </taxonoccurrence>

                        </locationevent>

                    </location>

                </path>

            </_simplifyPath>

        </path>

    </_setDefault>

</VegBIEN>

Inserted 0 new rows into database

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

:0,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",Enables the taxonoccurrence CHECK constraint to pass

Accepted_name,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/cond/_exists/_first/1",

Accepted_scientific_name,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/cond/_exists/_first/1",

Accepted_name.Name_matched,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/cond/_exists/_first/2",

Accepted_name.Name_submitted,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/cond/_exists/_first/2",

Accepted_name.Accepted_name,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/cond/_exists/_first/3",

Accepted_name.Accepted_scientific_name,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/cond/_exists/_first/3",

:true,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/*_id/taxonlabel:[taxonstatus=Accepted]/matched_label_id/_if[@name=""if is canonical name""]:[then=0]/cond","This table contains only canonicalized names. (Not all names are accepted, but those that aren’t don’t (yet) have an accepted match.)"

Accepted_name.Specific_epithet_matched,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/*_id/taxonlabel:[taxonstatus=Accepted]/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=species]/taxonepithet/_first/2",

:true,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/*_id/taxonlabel:[taxonstatus=Accepted]/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""]/cond/_exists","This table contains only canonicalized names. (Not all names are accepted, but those that aren’t don’t (yet) have an accepted match.)"

Accepted_name.Genus_matched,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/*_id/taxonlabel:[taxonstatus=Accepted]/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/_first/2",

Accepted_name.Genus_matched,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/*_id/taxonlabel:[taxonstatus=Accepted]/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/taxonepithet/_first/2",

:true,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/*_id/taxonlabel:[taxonstatus=Accepted]/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""]/cond/_exists","This table contains only canonicalized names. (Not all names are accepted, but those that aren’t don’t (yet) have an accepted match.)"

Accepted_name_family,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/*_id/taxonlabel:[taxonstatus=Accepted]/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/_first/1/_nullIf:[null=Unknown]/value",

Accepted_name.Name_matched_accepted_family,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/*_id/taxonlabel:[taxonstatus=Accepted]/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/_first/2/_first/1",

Accepted_name.Family_matched,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/*_id/taxonlabel:[taxonstatus=Accepted]/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/_first/2/_first/2",

Accepted_name.Accepted_name_family,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/*_id/taxonlabel:[taxonstatus=Accepted]/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/_first/3",

Accepted_name_family,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/*_id/taxonlabel:[taxonstatus=Accepted]/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=family]/taxonepithet/_first/1/_nullIf:[null=Unknown]/value",

Accepted_name.Name_matched_accepted_family,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/*_id/taxonlabel:[taxonstatus=Accepted]/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=family]/taxonepithet/_first/2/_first/1",

Accepted_name.Family_matched,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/*_id/taxonlabel:[taxonstatus=Accepted]/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=family]/taxonepithet/_first/2/_first/2",

Accepted_name.Accepted_name_family,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/*_id/taxonlabel:[taxonstatus=Accepted]/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=family]/taxonepithet/_first/3",

Accepted_name_rank,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/*_id/taxonlabel:[taxonstatus=Accepted]/parent_id/taxonlabel/rank/_first/1",

Accepted_name.Name_matched_rank,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/*_id/taxonlabel:[taxonstatus=Accepted]/parent_id/taxonlabel/rank/_first/2",

Accepted_name.Accepted_name_rank,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/*_id/taxonlabel:[taxonstatus=Accepted]/parent_id/taxonlabel/rank/_first/3",

Accepted_name.Infraspecific_epithet_matched,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/*_id/taxonlabel:[taxonstatus=Accepted]/parent_id/taxonlabel/taxonepithet/_first/2",

Accepted_name_rank,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/*_id/taxonlabel:[taxonstatus=Accepted]/rank/_first/1",

Accepted_name.Name_matched_rank,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/*_id/taxonlabel:[taxonstatus=Accepted]/rank/_first/2",

Accepted_name.Accepted_name_rank,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/*_id/taxonlabel:[taxonstatus=Accepted]/rank/_first/3",

Accepted_name.Name_matched_url,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/*_id/taxonlabel:[taxonstatus=Accepted]/sourceaccessioncode/_first/2",

Accepted_name_family,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/*_id/taxonlabel:[taxonstatus=Accepted]/taxonomicname/_merge_prefix/prefix/_taxon_family_require_std/family/_first/1/_nullIf:[null=Unknown]/value",

Accepted_name.Name_matched_accepted_family,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/*_id/taxonlabel:[taxonstatus=Accepted]/taxonomicname/_merge_prefix/prefix/_taxon_family_require_std/family/_first/2/_first/1",

Accepted_name.Family_matched,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/*_id/taxonlabel:[taxonstatus=Accepted]/taxonomicname/_merge_prefix/prefix/_taxon_family_require_std/family/_first/2/_first/2",

Accepted_name.Accepted_name_family,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/*_id/taxonlabel:[taxonstatus=Accepted]/taxonomicname/_merge_prefix/prefix/_taxon_family_require_std/family/_first/3",

Accepted_scientific_name,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/*_id/taxonlabel:[taxonstatus=Accepted]/taxonomicname/_merge_prefix/value/_alt/1/_first/1",

Accepted_name.Name_submitted,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/*_id/taxonlabel:[taxonstatus=Accepted]/taxonomicname/_merge_prefix/value/_alt/1/_first/2",

Accepted_name.Accepted_scientific_name,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/*_id/taxonlabel:[taxonstatus=Accepted]/taxonomicname/_merge_prefix/value/_alt/1/_first/3",

Accepted_name,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/*_id/taxonlabel:[taxonstatus=Accepted]/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/1/_first/1",

Accepted_name.Name_matched,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/*_id/taxonlabel:[taxonstatus=Accepted]/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/1/_first/2",

Accepted_name.Accepted_name,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/*_id/taxonlabel:[taxonstatus=Accepted]/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/1/_first/3",

Accepted_name.Genus_matched,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/*_id/taxonlabel:[taxonstatus=Accepted]/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/2/_first/2",

Accepted_name.Specific_epithet_matched,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/*_id/taxonlabel:[taxonstatus=Accepted]/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1/_first/2",

Accepted_name.Infraspecific_epithet_matched,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/*_id/taxonlabel:[taxonstatus=Accepted]/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond/_first/2",

Accepted_name_rank,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/*_id/taxonlabel:[taxonstatus=Accepted]/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then/_first/1",

Accepted_name.Name_matched_rank,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/*_id/taxonlabel:[taxonstatus=Accepted]/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then/_first/2",

Accepted_name.Accepted_name_rank,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/*_id/taxonlabel:[taxonstatus=Accepted]/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then/_first/3",

Accepted_name.Infraspecific_epithet_matched,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/*_id/taxonlabel:[taxonstatus=Accepted]/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2/_first/2",

Accepted_name_author,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/*_id/taxonlabel:[taxonstatus=Accepted]/taxonomicname/_merge_prefix/value/_alt/2/_join_words/2/_first/1",

Accepted_name.Name_matched_author,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/*_id/taxonlabel:[taxonstatus=Accepted]/taxonomicname/_merge_prefix/value/_alt/2/_join_words/2/_first/2/_first/1",

Accepted_name.Author_matched,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/*_id/taxonlabel:[taxonstatus=Accepted]/taxonomicname/_merge_prefix/value/_alt/2/_join_words/2/_first/2/_first/2",

Accepted_name.Accepted_name_author,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/*_id/taxonlabel:[taxonstatus=Accepted]/taxonomicname/_merge_prefix/value/_alt/2/_join_words/2/_first/3",

Accepted_name_author,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/author/_first/1",

Accepted_name.Name_matched_author,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/author/_first/2/_first/1",

Accepted_name.Author_matched,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/author/_first/2/_first/2",

Accepted_name.Accepted_name_author,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/author/_first/3",

Accepted_name_family,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/family/_first/1/_nullIf:[null=Unknown]/value",

Accepted_name.Name_matched_accepted_family,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/family/_first/2/_first/1",

Accepted_name.Family_matched,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/family/_first/2/_first/2",

Accepted_name.Accepted_name_family,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/family/_first/3",

Accepted_name.Genus_matched,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/genus/_first/2",

Unmatched_terms,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/morphospecies",

Accepted_name.Specific_epithet_matched,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/specific_epithet/_first/2",

Accepted_name,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/taxonname/_first/1",

Accepted_name.Name_matched,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/taxonname/_first/2",

Accepted_name.Accepted_name,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/taxonname/_first/3",

Accepted_scientific_name,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/taxonomicname/_first/1",

Accepted_name.Name_submitted,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/taxonomicname/_first/2",

Accepted_name.Accepted_scientific_name,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/taxonomicname/_first/3",

Accepted_name_rank,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/verbatimrank/_first/1",

Accepted_name.Name_matched_rank,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/verbatimrank/_first/2",

Accepted_name.Accepted_name_rank,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/verbatimrank/_first/3",

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

Family_score,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/taxonconfidence/_max/1",

Genus_score,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/taxonconfidence/_max/2",

Specific_epithet_score,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/taxonconfidence/_max/3",

Max_score,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/taxonconfidence/_max/4/_first/1",

Overall_score,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/taxonconfidence/_max/4/_first/2",Assuming is a fraction based on the range of values

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

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

:0,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",Enables the taxonoccurrence CHECK constraint to pass

:0,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/1,Enables the taxonoccurrence CHECK constraint to pass

:true,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]:[then=0]/cond","This table contains only canonicalized names. (Not all names are accepted, but those that aren’t don’t (yet) have an accepted match.)"

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

Specific_epithet_matched,"/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_matched,"/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",

Name_matched_accepted_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/_first/1",Contains family based on matched name

Family_matched,"/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/_first/2",Contains family in original string (uncommon)

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

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

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

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

Name_matched_accepted_family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/prefix/_taxon_family_require_std/family/_first/1,Contains family based on matched name

Family_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/prefix/_taxon_family_require_std/family/_first/2,Contains family in original string (uncommon)

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

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

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

:true,"/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/2/_if[@name=""if has verbatim name""]/cond/_exists","This table contains only canonicalized names. (Not all names are accepted, but those that aren’t don’t (yet) have an accepted match.)"

Unmatched_terms,"/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/2/_if[@name=""if has verbatim name""]/else",

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

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

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

Name_matched_author,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/2/_first/1,Contains author based on matched name

Author_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/2/_first/2,Contains author in original string

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

Name_matched_author,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/author/_first/1,Contains author based on matched name

Author_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/author/_first/2,Contains author in original string

Name_matched_accepted_family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/family/_first/1,Contains family based on matched name

Family_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/family/_first/2,Contains family in original string (uncommon)

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

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

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

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

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

:0,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/_if[@name=""if has taxondetermination""]/cond/_exists",Enables the taxonoccurrence CHECK constraint to pass

Family_score,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/_if[@name=""if has taxondetermination""]/then/taxonconfidence/_max/1",

Genus_score,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/_if[@name=""if has taxondetermination""]/then/taxonconfidence/_max/2",

Specific_epithet_score,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/_if[@name=""if has taxondetermination""]/then/taxonconfidence/_max/3",

Max_score,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/_if[@name=""if has taxondetermination""]/then/taxonconfidence/_max/4/_first/1",

Overall_score,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/_if[@name=""if has taxondetermination""]/then/taxonconfidence/_max/4/_first/2",Assuming is a fraction based on the range of values

:_,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/1/_dateRangeStart/value/_now,

:matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationtype,

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

taxonoccurrence_id,/location/locationevent/taxonoccurrence/taxonoccurrence_id,

Accepted_name.Accepted_name_lsid,,** No join mapping for *Accepted_name.Accepted_name_lsid/_first/3 ** 

Accepted_name.Accepted_name_species,,** No join mapping for *Accepted_name.Accepted_name_species/_first/3 ** 

Accepted_name.Accepted_name_url,,** No join mapping for *Accepted_name.Accepted_name_url/_first/3 ** 

Accepted_name.Annotations,,** No join mapping for *Accepted_name.Annotations/_first/2 ** 

Accepted_name.Author_score,,** No non-empty join mapping for OMIT/_first/2 ** Scores come from the matched name instead

Accepted_name.Family_score,,** No non-empty join mapping for OMIT/_first/2 ** Scores come from the matched name instead

Accepted_name.Genus_score,,** No non-empty join mapping for OMIT/_first/2 ** Scores come from the matched name instead

Accepted_name.Infraspecific_epithet_2_matched,,** No non-empty join mapping for UNUSED/_first/2 ** 

Accepted_name.Infraspecific_epithet_2_score,,** No non-empty join mapping for OMIT/_first/2 ** Scores come from the matched name instead

Accepted_name.Infraspecific_epithet_score,,** No non-empty join mapping for OMIT/_first/2 ** Scores come from the matched name instead

Accepted_name.Infraspecific_rank,,** No non-empty join mapping for OMIT ** Omitted because Accepted_name.Name_matched_rank is populated more often

Accepted_name.Infraspecific_rank_2,,** No non-empty join mapping for UNUSED/_first/2 ** 

Accepted_name.Max_score,,** No non-empty join mapping for OMIT/_first/2 ** Scores come from the matched name instead

Accepted_name.Name_number,,** No non-empty join mapping for OMIT/_first/2 ** Identifies name only within one TNRS batch. Omitted because not globally unique.

Accepted_name.Name_score,,** No non-empty join mapping for OMIT/_first/2 ** Scores come from the matched name instead

Accepted_name.Overall_score,,** No non-empty join mapping for OMIT/_first/2 ** Scores come from the matched name instead

Accepted_name.Selected,,** No join mapping for *Accepted_name.Selected/_first/2 ** 

Accepted_name.Source,,** No join mapping for *Accepted_name.Source/_first/2 ** 

Accepted_name.Specific_epithet_score,,** No non-empty join mapping for OMIT/_first/2 ** Scores come from the matched name instead

Accepted_name.Taxonomic_status,,** No join mapping for acceptedTaxonomicStatus/_first/2 ** 

Accepted_name.Time_submitted,,** No join mapping for *Accepted_name.Time_submitted/_first/2 ** 

Accepted_name.Unmatched_terms,,** No non-empty join mapping for OMIT/_first/2 ** Should be empty

Accepted_name.Warnings,,** No join mapping for *Accepted_name.Warnings/_first/2 ** 

Accepted_name_lsid,,** No join mapping for *Accepted_name_lsid/_first/2 ** 

Accepted_name_species,,** No join mapping for *Accepted_name_species/_first/1 ** Also contains genus. Omitted because Accepted_name contains more info.

Accepted_name_url,,** No join mapping for *Accepted_name_url/_first/1 ** 

Author_score,,** No join mapping for *Author_score ** 

Infraspecific_epithet_2_matched,,** No non-empty join mapping for UNUSED ** 

Infraspecific_epithet_2_score,,** No non-empty join mapping for UNUSED ** 

Infraspecific_epithet_score,,** No join mapping for *Infraspecific_epithet_score ** 

Infraspecific_rank,,** No non-empty join mapping for OMIT ** Omitted because Name_matched_rank is populated more often

Infraspecific_rank_2,,** No non-empty join mapping for UNUSED ** 

Name_number,,** No non-empty join mapping for OMIT ** Identifies name only within one TNRS batch. Omitted because not globally unique.

Name_score,,** No join mapping for *Name_score ** 

Name_submitted,,** No non-empty join mapping for OMIT ** Omitted because taxonoccurrence_id used to identify the taxonoccurrence instead

Selected,,** No join mapping for *Selected ** 

Source,,** No join mapping for source ** 

Time_submitted,,** No join mapping for *Time_submitted ** 

Warnings,,** No join mapping for *Warnings ** 

#!/bin/bash

# Adds scrubbed taxondeterminations to VegBIEN

# Usage: make inputs/.TNRS/public.unscrubbed_taxondetermination_view/scrub-remake [wait=1]

# Handle being run as a .make script

exec >&2

unset MAKEFLAGS MFLAGS

selfDir="$(dirname -- "$0")"

selfDirName="$(basename -- "$selfDir")"

# Use tnrs.make's lockfile because can't be importing while tnrs.make is

# scrubbing. tnrs.make leaves tnrs in an incomplete state while running because

# the accepted names are parsed *after* their matched names. Using a separate

# lockfile would cause some accepted names to be missing.

waitself "tnrs/tnrs.make"

# Config

let pause=2*60*60 # sec; = 2 hr

let maxPause=4*60*60 # sec; =4 hr; must be >= max partition import time (1.5 hr)

test "$pause" -le "$maxPause" || exit -1

unset n # ($n would limit the # rows/iteration, rather than the total rows)

cd "$selfDir/.." # needed by make

make () { env make --makefile=../input.Makefile "$@"; }

log_="$(make -s "$selfDirName"/log_file)"

exec >>"$log_" 2>&1

rowsAdded ()

{

    test -e "$log_" || { echo "Log does not exist: $log_" >&2; exit;}

    tail -100 "$log_"|grep -E '^Inserted [1-9][0-9]* new rows into database$' \

        >/dev/null

}

let totalPause=0

while true; do

    make "$selfDirName"/import

    if ! rowsAdded; then

        test -n "$wait" || break

        echo "Waited $totalPause sec total"

        let 'totalPause += pause'

        test "$totalPause" -gt "$maxPause" && break

        echo "Waiting $pause sec..."

        sleep "$pause" # wait for more rows

        continue # try again

    fi

    # otherwise, rows found

    let totalPause=0

done