-- Name: unscrubbed_taxondetermination_view; Type: VIEW; 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" FROM (((taxondetermination LEFT JOIN taxonverbatim USING (taxonverbatim_id)) LEFT JOIN taxonlabel USING (taxonlabel_id)) LEFT JOIN "TNRS".tnrs ON ((tnrs."Name_submitted" = taxonlabel.taxonomicname))) WHERE (taxondetermination.iscurrent AND (taxondetermination.source_id <> source_by_shortname('TNRS'::text))) ORDER BY taxondetermination.taxondetermination_id;

--

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

--