--

-- Name: analytical_stem; Type: TABLE; Schema: public; Owner: -; Tablespace: 

--

--

-- Name: ~type._traits_01_count_records; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: 

--

$_$;

SET search_path = public, pg_catalog;

--

--

CREATE VIEW _plots_02_list_of_project_names AS

   FROM (public.project p

   JOIN public.source s ON ((p.source_id = s.source_id)))

  WHERE (s.shortname = ("current_schema"())::text);

--

CREATE VIEW _plots_04_count_of_plots_in_each_project_in_this_source AS

    count(DISTINCT l.location_id) AS plots

   FROM (((public.location l

   JOIN public.locationevent le ON ((l.location_id = le.location_id)))

--

CREATE VIEW _plots_05_list_of_plot_codes_by_project AS

    l.authorlocationcode AS "plotCode"

   FROM (((public.location l

   JOIN public.locationevent le ON ((l.location_id = le.location_id)))

--

CREATE VIEW _plots_10_count_of_individuals_per_plot_in_each_project AS

    l.authorlocationcode AS plotcode, 

    sum(ao.count) AS individuals

   FROM ((((((public.project p

--

CREATE VIEW _plots_11_count_of_stems_per_plot_in_each_project AS

    l.authorlocationcode AS plotcode, 

    count(DISTINCT so.stemobservation_id) AS stems

   FROM ((((((((public.project p

--

CREATE VIEW _plots_12_count_of_verbatim_taxa_per_plot_in_each_project AS

    l.authorlocationcode AS plotcode, 

    count(DISTINCT btrim((((((((''::text || COALESCE(tv.family, ''::text)) || ' '::text) || COALESCE(tv.genus, ''::text)) || ' '::text) || COALESCE(tv.specific_epithet, ''::text)) || ' '::text) || COALESCE(tv.morphospecies, ''::text)))) AS taxa

   FROM (((((((public.project p

--

CREATE VIEW _plots_13_list_of_distinct_verbatim_taxa_in_each_plot_in_each_p AS

    l.authorlocationcode AS plotcode, 

    btrim((((((((''::text || COALESCE(tv.family, ''::text)) || ' '::text) || COALESCE(tv.genus, ''::text)) || ' '::text) || COALESCE(tv.specific_epithet, ''::text)) || ' '::text) || COALESCE(tv.morphospecies, ''::text))) AS taxon

   FROM (((((((public.project p

--

CREATE VIEW _plots_14_count_of_indiv_per_verbatim_taxon_per_plot_in_each_pr AS

    l.authorlocationcode AS plotcode, 

    btrim((((((((''::text || COALESCE(tv.family, ''::text)) || ' '::text) || COALESCE(tv.genus, ''::text)) || ' '::text) || COALESCE(tv.specific_epithet, ''::text)) || ' '::text) || COALESCE(tv.morphospecies, ''::text))) AS taxon, 

    sum(ao.count) AS individuals

--

CREATE VIEW _plots_15_pct_cover_of_each_verb_taxon_in_each_plot_in_each_pro AS

    l.authorlocationcode AS plotcode, 

    btrim((((((((''::text || COALESCE(tv.family, ''::text)) || ' '::text) || COALESCE(tv.genus, ''::text)) || ' '::text) || COALESCE(tv.specific_epithet, ''::text)) || ' '::text) || COALESCE(tv.morphospecies, ''::text))) AS taxon, 

    sum(ci.coverpercent) AS totalpercentcover

--

CREATE VIEW _plots_17_count_of_subplots_per_plot_for_each_project AS

    l.authorlocationcode AS plotcode, 

    count(DISTINCT sub_locationevent.locationevent_id) AS subplots

   FROM ((((public.project p

--

CREATE VIEW _plots_18_list_of_subplots_codes_for_each_plot_for_each_project AS

    l.authorlocationcode AS plotcode, 

    sub_locationevent.authoreventcode AS "subplotCode"

   FROM ((((public.project p

--

-- Name: ~type._traits_01_count_records; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: 

--