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

--

CREATE VIEW "taxon_scrub.scrubbed_unique_taxon_name.*" AS

 SELECT taxon_match."*Name_submitted" AS scrubbed_unique_taxon_name,

    taxon_match."*Name_matched_rank" AS scrubbed_taxon_rank,

    COALESCE(taxon_match."*Name_matched_accepted_family", taxon_match."*Family_matched") AS scrubbed_family,

    taxon_match."*Genus_matched" AS scrubbed_genus,

    taxon_match."*Specific_epithet_matched" AS scrubbed_specific_epithet,

    taxon_match."*Infraspecific_rank" AS scrubbed_infraspecific_rank,

    taxon_match."*Infraspecific_epithet_matched" AS scrubbed_infraspecific_epithet,

    taxon_match."*Name_matched_author" AS scrubbed_author,

    taxon_match."*Name_matched" AS scrubbed_taxon_name_no_author,

    (taxon_match."*Name_matched" || COALESCE((' '::text || taxon_match."*Name_matched_author"), ''::text)) AS scrubbed_taxon_name_with_author

   FROM taxon_match;

--

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

--

COMMENT ON VIEW "taxon_scrub.scrubbed_unique_taxon_name.*" IS '

to modify:

SELECT util.recreate_view(''"TNRS"."taxon_scrub.scrubbed_unique_taxon_name.*"'', $$

SELECT __

$$);

scrubbed_family: Name_matched_accepted_family was missing from the TNRS results at one point, so Family_matched is used as a workaround to populate this. the workaround is for *accepted names only*, as no opinion names do not have an Accepted_name_family to prepend to the scrubbed name to parse.

';

--

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

--

REVOKE ALL ON TABLE "taxon_scrub.scrubbed_unique_taxon_name.*" FROM PUBLIC;

REVOKE ALL ON TABLE "taxon_scrub.scrubbed_unique_taxon_name.*" FROM bien;

GRANT ALL ON TABLE "taxon_scrub.scrubbed_unique_taxon_name.*" TO bien;

GRANT SELECT ON TABLE "taxon_scrub.scrubbed_unique_taxon_name.*" TO bien_read;

--

--

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

--

--

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

--

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

--

--

--

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

--

CREATE VIEW "taxon_scrub.scrubbed_unique_taxon_name.*" AS

 SELECT taxon_match."*Name_submitted" AS scrubbed_unique_taxon_name,

    taxon_match."*Name_matched_rank" AS scrubbed_taxon_rank,

    COALESCE(taxon_match."*Name_matched_accepted_family", taxon_match."*Family_matched") AS scrubbed_family,

    taxon_match."*Genus_matched" AS scrubbed_genus,

    taxon_match."*Specific_epithet_matched" AS scrubbed_specific_epithet,

    taxon_match."*Infraspecific_rank" AS scrubbed_infraspecific_rank,

    taxon_match."*Infraspecific_epithet_matched" AS scrubbed_infraspecific_epithet,

    taxon_match."*Name_matched_author" AS scrubbed_author,

    taxon_match."*Name_matched" AS scrubbed_taxon_name_no_author,

    (taxon_match."*Name_matched" || COALESCE((' '::text || taxon_match."*Name_matched_author"), ''::text)) AS scrubbed_taxon_name_with_author

   FROM taxon_match;

--

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

--

COMMENT ON VIEW "taxon_scrub.scrubbed_unique_taxon_name.*" IS '

to modify:

SELECT util.recreate_view(''"TNRS"."taxon_scrub.scrubbed_unique_taxon_name.*"'', $$

SELECT __

$$);

scrubbed_family: Name_matched_accepted_family was missing from the TNRS results at one point, so Family_matched is used as a workaround to populate this. the workaround is for *accepted names only*, as no opinion names do not have an Accepted_name_family to prepend to the scrubbed name to parse.

';

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

--

REVOKE ALL ON TABLE "taxon_scrub.scrubbed_unique_taxon_name.*" FROM PUBLIC;

REVOKE ALL ON TABLE "taxon_scrub.scrubbed_unique_taxon_name.*" FROM bien;

GRANT ALL ON TABLE "taxon_scrub.scrubbed_unique_taxon_name.*" TO bien;

GRANT SELECT ON TABLE "taxon_scrub.scrubbed_unique_taxon_name.*" TO bien_read;

--