-- Name: _plots_20_tnrs_input_names; Type: VIEW; Schema: public_validations; Owner: -

--

CREATE VIEW _plots_20_tnrs_input_names AS

 SELECT DISTINCT taxonlabel.taxonomicname AS tnrs_input_name

   FROM public.taxonlabel

  WHERE ((taxonlabel.source_id = ( SELECT public.source_by_shortname(("current_schema"())::text) AS source_by_shortname)) AND (taxonlabel.taxonomicname IS NOT NULL));

--

-- Name: _plots_21_tnrs_output_names; Type: VIEW; Schema: public_validations; Owner: -

--

CREATE VIEW _plots_21_tnrs_output_names AS

 SELECT DISTINCT taxon_scrub."concatenatedScientificName" AS tnrs_output_name

   FROM (public.taxonlabel

   JOIN "TNRS".taxon_scrub ON ((taxon_scrub."concatenatedScientificName" = taxonlabel.taxonomicname)))

  WHERE ((taxonlabel.source_id = ( SELECT public.source_by_shortname(("current_schema"())::text) AS source_by_shortname)) AND (taxon_scrub."concatenatedScientificName" IS NOT NULL));

--