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

--

CREATE VIEW taxon_best_match AS

 SELECT taxon_match.batch,

    taxon_match.match_num,

    taxon_match."Name_number",

    taxon_match."Name_submitted",

    taxon_match."Overall_score",

    taxon_match."Name_matched",

    taxon_match."Name_matched_rank",

    taxon_match."Name_score",

    taxon_match."Name_matched_author",

    taxon_match."Name_matched_url",

    taxon_match."Author_matched",

    taxon_match."Author_score",

    taxon_match."Family_matched",

    taxon_match."Family_score",

    taxon_match."Name_matched_accepted_family",

    taxon_match."Genus_matched",

    taxon_match."Genus_score",

    taxon_match."Specific_epithet_matched",

    taxon_match."Specific_epithet_score",

    taxon_match."Infraspecific_rank",

    taxon_match."Infraspecific_epithet_matched",

    taxon_match."Infraspecific_epithet_score",

    taxon_match."Infraspecific_rank_2",

    taxon_match."Infraspecific_epithet_2_matched",

    taxon_match."Infraspecific_epithet_2_score",

    taxon_match."Annotations",

    taxon_match."Unmatched_terms",

    taxon_match."Taxonomic_status",

    taxon_match."Accepted_name",

    taxon_match."Accepted_name_author",

    taxon_match."Accepted_name_rank",

    taxon_match."Accepted_name_url",

    taxon_match."Accepted_name_species",

    taxon_match."Accepted_name_family",

    taxon_match."Selected",

    taxon_match."Source",

    taxon_match."Warnings",

    taxon_match."Accepted_name_lsid",

    taxon_match.is_valid_match,

    taxon_match.scrubbed_unique_taxon_name

   FROM taxon_match

  WHERE (taxon_match."Selected" = 'true'::text);

--

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

--

COMMENT ON VIEW taxon_best_match IS '

to modify:

SELECT util.recreate_view(''"TNRS"."taxon_best_match"'', $$

SELECT __

$$);

';

--

-- Name: taxon_best_match; Type: ACL; Schema: TNRS; Owner: -

--

REVOKE ALL ON TABLE taxon_best_match FROM PUBLIC;

REVOKE ALL ON TABLE taxon_best_match FROM bien;

GRANT ALL ON TABLE taxon_best_match TO bien;

GRANT SELECT ON TABLE taxon_best_match TO bien_read;

--