-- Name: _01_count_records; Type: VIEW; Schema: public_validation_traits; Owner: -

--

--

-- Name: _02_count_trait_names; Type: VIEW; Schema: public_validation_traits; Owner: -

--

--

-- Name: _03_list_trait_names; Type: VIEW; Schema: public_validation_traits; Owner: -

--

--

-- Name: _04_count_records_per_trait; Type: VIEW; Schema: public_validation_traits; Owner: -

--

--

-- Name: _05_count_taxa; Type: VIEW; Schema: public_validation_traits; Owner: -

--

--

-- Name: _06_list_taxa; Type: VIEW; Schema: public_validation_traits; Owner: -

--

--

-- Name: _07_trait_value_and_units_for_first_5000_records; Type: VIEW; Schema: public_validation_traits; Owner: -

--

--

-- Name: _08_taxon_trait_and_value_for_first_5000_records; Type: VIEW; Schema: public_validation_traits; Owner: -

--

--

SET search_path = public_validation_traits, pg_catalog;

-- Name: _01_count_records; Type: VIEW; Schema: public_validation_traits; Owner: -

--

CREATE VIEW _01_count_records AS

 SELECT count(*) AS "totalRecords"

   FROM (public.trait

   JOIN public.taxonoccurrence USING (taxonoccurrence_id))

  WHERE (taxonoccurrence.source_id = public.source_by_shortname(("current_schema"())::text));

--

-- Name: _02_count_trait_names; Type: VIEW; Schema: public_validation_traits; Owner: -

--

CREATE VIEW _02_count_trait_names AS

 SELECT count(DISTINCT trait.name) AS traits

   FROM (public.trait

   JOIN public.taxonoccurrence USING (taxonoccurrence_id))

  WHERE (taxonoccurrence.source_id = public.source_by_shortname(("current_schema"())::text));

--

-- Name: _03_list_trait_names; Type: VIEW; Schema: public_validation_traits; Owner: -

--

CREATE VIEW _03_list_trait_names AS

 SELECT DISTINCT trait.name AS trait

   FROM (public.trait

   JOIN public.taxonoccurrence USING (taxonoccurrence_id))

  WHERE (taxonoccurrence.source_id = public.source_by_shortname(("current_schema"())::text))

  ORDER BY trait.name;

--

-- Name: _04_count_records_per_trait; Type: VIEW; Schema: public_validation_traits; Owner: -

--

CREATE VIEW _04_count_records_per_trait AS

 SELECT trait.name AS trait, 

    count(*) AS measurements

   FROM (public.trait

   JOIN public.taxonoccurrence USING (taxonoccurrence_id))

  WHERE (taxonoccurrence.source_id = public.source_by_shortname(("current_schema"())::text))

  GROUP BY trait.name

  ORDER BY trait.name;

--

-- Name: _05_count_taxa; Type: VIEW; Schema: public_validation_traits; Owner: -

--

CREATE VIEW _05_count_taxa AS

 SELECT count(DISTINCT ROW(taxonverbatim.taxonname, taxonverbatim.author)) AS taxa

   FROM public.taxonverbatim

  WHERE (taxonverbatim.source_id = public.source_by_shortname(("current_schema"())::text));

--

-- Name: _06_list_taxa; Type: VIEW; Schema: public_validation_traits; Owner: -

--

CREATE VIEW _06_list_taxa AS

 SELECT DISTINCT concat_ws(' '::text, taxonverbatim.taxonname, taxonverbatim.author) AS taxonwithauthor

   FROM public.taxonverbatim

  WHERE (taxonverbatim.source_id = public.source_by_shortname(("current_schema"())::text))

  ORDER BY concat_ws(' '::text, taxonverbatim.taxonname, taxonverbatim.author);

--

-- Name: _07_trait_value_and_units_for_first_5000_records; Type: VIEW; Schema: public_validation_traits; Owner: -

--

CREATE VIEW _07_trait_value_and_units_for_first_5000_records AS

 SELECT trait.name AS trait, 

    trait.value, 

    trait.units

   FROM (public.trait

   JOIN public.taxonoccurrence USING (taxonoccurrence_id))

  WHERE (taxonoccurrence.source_id = public.source_by_shortname(("current_schema"())::text))

  ORDER BY trait.name, trait.value, trait.units

 LIMIT 5000;

--

-- Name: _08_taxon_trait_and_value_for_first_5000_records; Type: VIEW; Schema: public_validation_traits; Owner: -

--

CREATE VIEW _08_taxon_trait_and_value_for_first_5000_records AS

 SELECT concat_ws(' '::text, taxonverbatim.taxonname, taxonverbatim.author) AS taxonwithauthor, 

    trait.name AS trait, 

    trait.value

   FROM ((public.taxonverbatim

   JOIN public.taxondetermination ON (((taxondetermination.taxonverbatim_id = taxonverbatim.taxonverbatim_id) AND taxondetermination.iscurrent)))

   JOIN public.trait USING (taxonoccurrence_id))

  WHERE (taxonverbatim.source_id = public.source_by_shortname(("current_schema"())::text))

  ORDER BY taxonverbatim.taxonname

 LIMIT 5000;

SET search_path = public, pg_catalog;

--