-- Name: taxon_scrub.scrubbed_unique_taxon_name.*; Type: VIEW; Schema: TNRS; Owner: -

--

CREATE VIEW "taxon_scrub.scrubbed_unique_taxon_name.*" AS

 SELECT tnrs."Name_submitted" AS scrubbed_unique_taxon_name, 

    tnrs."Name_matched_rank" AS scrubbed_taxon_rank, 

    tnrs."Name_matched_accepted_family" AS scrubbed_family, 

    tnrs."Genus_matched" AS scrubbed_genus, 

    tnrs."Specific_epithet_matched" AS scrubbed_specific_epithet, 

    tnrs."Infraspecific_rank" AS scrubbed_infraspecific_rank, 

    tnrs."Infraspecific_epithet_matched" AS scrubbed_infraspecific_epithet, 

    tnrs."Name_matched_author" AS scrubbed_author, 

    tnrs."Name_matched" AS scrubbed_taxon_name_no_author

   FROM tnrs;

--

-- Name: taxon_scrub; Type: VIEW; Schema: TNRS; Owner: -

--

CREATE VIEW taxon_scrub AS

 SELECT "ValidMatchedTaxon".scrubbed_unique_taxon_name, 

    "ValidMatchedTaxon"."*Name_matched.batch", 

    "ValidMatchedTaxon"."concatenatedScientificName", 

    "ValidMatchedTaxon"."matchedTaxonName", 

    "ValidMatchedTaxon"."matchedTaxonRank", 

    "ValidMatchedTaxon"."*Name_matched.Name_score", 

    "ValidMatchedTaxon"."matchedScientificNameAuthorship", 

    "ValidMatchedTaxon"."matchedScientificNameID", 

    "ValidMatchedTaxon"."*Name_matched.Author_score", 

    "ValidMatchedTaxon"."matchedFamilyConfidence_fraction", 

    "ValidMatchedTaxon"."matchedFamily", 

    "ValidMatchedTaxon"."matchedGenus", 

    "ValidMatchedTaxon"."matchedGenusConfidence_fraction", 

    "ValidMatchedTaxon"."matchedSpecificEpithet", 

    "ValidMatchedTaxon"."matchedSpeciesConfidence_fraction", 

    "ValidMatchedTaxon"."matchedInfraspecificEpithet", 

    "ValidMatchedTaxon"."*Name_matched.Infraspecific_epithet_score", 

    "ValidMatchedTaxon"."identificationQualifier", 

    "ValidMatchedTaxon"."morphospeciesSuffix", 

    "ValidMatchedTaxon"."taxonomicStatus", 

    "ValidMatchedTaxon"."acceptedTaxonName", 

    "ValidMatchedTaxon"."acceptedScientificNameAuthorship", 

    "ValidMatchedTaxon"."acceptedTaxonRank", 

    "ValidMatchedTaxon"."acceptedScientificNameID", 

    "ValidMatchedTaxon"."*Name_matched.Accepted_name_species", 

    "ValidMatchedTaxon"."acceptedFamily", 

    "ValidMatchedTaxon"."*Name_matched.Selected", 

    "ValidMatchedTaxon"."*Name_matched.Source", 

    "ValidMatchedTaxon"."*Name_matched.Warnings", 

    "ValidMatchedTaxon"."*Name_matched.Accepted_name_lsid", 

    "ValidMatchedTaxon".taxon_scrub__is_valid_match, 

    "taxon_scrub.scrubbed_unique_taxon_name.*".scrubbed_taxon_rank, 

    "taxon_scrub.scrubbed_unique_taxon_name.*".scrubbed_family, 

    "taxon_scrub.scrubbed_unique_taxon_name.*".scrubbed_genus, 

    "taxon_scrub.scrubbed_unique_taxon_name.*".scrubbed_specific_epithet, 

    "taxon_scrub.scrubbed_unique_taxon_name.*".scrubbed_infraspecific_rank, 

    "taxon_scrub.scrubbed_unique_taxon_name.*".scrubbed_infraspecific_epithet, 

    "taxon_scrub.scrubbed_unique_taxon_name.*".scrubbed_author, 

    "taxon_scrub.scrubbed_unique_taxon_name.*".scrubbed_taxon_name_no_author

   FROM ("ValidMatchedTaxon"

   LEFT JOIN "taxon_scrub.scrubbed_unique_taxon_name.*" USING (scrubbed_unique_taxon_name));

--

-- Name: VIEW taxon_scrub; Type: COMMENT; Schema: TNRS; Owner: -

--

COMMENT ON VIEW taxon_scrub IS 'to update, use * as the column list';

--