-- Name: unscrubbed_taxondetermination_view; Type: VIEW; Schema: public; Owner: -

--

--

-- Name: VIEW unscrubbed_taxondetermination_view; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: unscrubbed_taxondetermination_view; Type: ACL; Schema: public; Owner: -

--

--

-- Name: unscrubbed_taxondetermination_view; Type: VIEW; Schema: public; Owner: -

--

CREATE VIEW unscrubbed_taxondetermination_view AS

    SELECT taxondetermination.taxonoccurrence_id, tnrs."Time_submitted", tnrs."Name_number", tnrs."Name_submitted", tnrs."Overall_score", tnrs."Name_matched", tnrs."Name_matched_rank", tnrs."Name_score", tnrs."Name_matched_author", tnrs."Name_matched_url", tnrs."Author_matched", tnrs."Author_score", tnrs."Family_matched", tnrs."Family_score", tnrs."Name_matched_accepted_family", tnrs."Genus_matched", tnrs."Genus_score", tnrs."Specific_epithet_matched", tnrs."Specific_epithet_score", tnrs."Infraspecific_rank", tnrs."Infraspecific_epithet_matched", tnrs."Infraspecific_epithet_score", tnrs."Infraspecific_rank_2", tnrs."Infraspecific_epithet_2_matched", tnrs."Infraspecific_epithet_2_score", tnrs."Annotations", tnrs."Unmatched_terms", tnrs."Taxonomic_status", tnrs."Accepted_name", tnrs."Accepted_name_author", tnrs."Accepted_name_rank", tnrs."Accepted_name_url", tnrs."Accepted_name_species", tnrs."Accepted_name_family", tnrs."Selected", tnrs."Source", tnrs."Warnings", tnrs."Accepted_name_lsid", tnrs."Accepted_scientific_name", tnrs."Max_score", tnrs_accepted."Time_submitted" AS "Accepted_name.Time_submitted", tnrs_accepted."Name_number" AS "Accepted_name.Name_number", tnrs_accepted."Name_submitted" AS "Accepted_name.Name_submitted", tnrs_accepted."Overall_score" AS "Accepted_name.Overall_score", tnrs_accepted."Name_matched" AS "Accepted_name.Name_matched", tnrs_accepted."Name_matched_rank" AS "Accepted_name.Name_matched_rank", tnrs_accepted."Name_score" AS "Accepted_name.Name_score", tnrs_accepted."Name_matched_author" AS "Accepted_name.Name_matched_author", tnrs_accepted."Name_matched_url" AS "Accepted_name.Name_matched_url", tnrs_accepted."Author_matched" AS "Accepted_name.Author_matched", tnrs_accepted."Author_score" AS "Accepted_name.Author_score", tnrs_accepted."Family_matched" AS "Accepted_name.Family_matched", tnrs_accepted."Family_score" AS "Accepted_name.Family_score", tnrs_accepted."Name_matched_accepted_family" AS "Accepted_name.Name_matched_accepted_family", tnrs_accepted."Genus_matched" AS "Accepted_name.Genus_matched", tnrs_accepted."Genus_score" AS "Accepted_name.Genus_score", tnrs_accepted."Specific_epithet_matched" AS "Accepted_name.Specific_epithet_matched", tnrs_accepted."Specific_epithet_score" AS "Accepted_name.Specific_epithet_score", tnrs_accepted."Infraspecific_rank" AS "Accepted_name.Infraspecific_rank", tnrs_accepted."Infraspecific_epithet_matched" AS "Accepted_name.Infraspecific_epithet_matched", tnrs_accepted."Infraspecific_epithet_score" AS "Accepted_name.Infraspecific_epithet_score", tnrs_accepted."Infraspecific_rank_2" AS "Accepted_name.Infraspecific_rank_2", tnrs_accepted."Infraspecific_epithet_2_matched" AS "Accepted_name.Infraspecific_epithet_2_matched", tnrs_accepted."Infraspecific_epithet_2_score" AS "Accepted_name.Infraspecific_epithet_2_score", tnrs_accepted."Annotations" AS "Accepted_name.Annotations", tnrs_accepted."Unmatched_terms" AS "Accepted_name.Unmatched_terms", tnrs_accepted."Taxonomic_status" AS "Accepted_name.Taxonomic_status", tnrs_accepted."Accepted_name" AS "Accepted_name.Accepted_name", tnrs_accepted."Accepted_name_author" AS "Accepted_name.Accepted_name_author", tnrs_accepted."Accepted_name_rank" AS "Accepted_name.Accepted_name_rank", tnrs_accepted."Accepted_name_url" AS "Accepted_name.Accepted_name_url", tnrs_accepted."Accepted_name_species" AS "Accepted_name.Accepted_name_species", tnrs_accepted."Accepted_name_family" AS "Accepted_name.Accepted_name_family", tnrs_accepted."Selected" AS "Accepted_name.Selected", tnrs_accepted."Source" AS "Accepted_name.Source", tnrs_accepted."Warnings" AS "Accepted_name.Warnings", tnrs_accepted."Accepted_name_lsid" AS "Accepted_name.Accepted_name_lsid", tnrs_accepted."Accepted_scientific_name" AS "Accepted_name.Accepted_scientific_name", tnrs_accepted."Max_score" AS "Accepted_name.Max_score" FROM ((((taxondetermination JOIN taxonverbatim USING (taxonverbatim_id)) JOIN taxonlabel USING (taxonlabel_id)) JOIN "TNRS".tnrs ON ((tnrs."Name_submitted" = taxonlabel.taxonomicname))) LEFT JOIN "TNRS".tnrs tnrs_accepted ON ((tnrs_accepted."Name_submitted" = tnrs."Accepted_scientific_name"))) WHERE ((taxondetermination.iscurrent AND (taxondetermination.source_id <> COALESCE((SELECT source.source_id FROM source WHERE (source.shortname = 'TNRS'::text)), 2147483647))) AND (tnrs."Max_score" >= (0.8)::double precision)) ORDER BY taxondetermination.taxonoccurrence_id;

--

-- Name: VIEW unscrubbed_taxondetermination_view; Type: COMMENT; Schema: public; Owner: -

--

COMMENT ON VIEW unscrubbed_taxondetermination_view IS 'Note that sorting on taxonoccurrence_id does not create sort order ambiguity between taxondeterminations with the same taxonoccurrence_id, because there is only one current determination per taxonoccurrence.';

--

-- Name: unscrubbed_taxondetermination_view; Type: ACL; Schema: public; Owner: -

--

REVOKE ALL ON TABLE unscrubbed_taxondetermination_view FROM PUBLIC;

REVOKE ALL ON TABLE unscrubbed_taxondetermination_view FROM bien;

GRANT ALL ON TABLE unscrubbed_taxondetermination_view TO bien;

GRANT SELECT ON TABLE unscrubbed_taxondetermination_view TO bien_read;

--