-- Name: keys_~type._plots_08_list_of_plots_which_use_percent_cover; Type: TYPE; Schema: public_validations; Owner: -

--

--

-- Name: values__~type._plots_08_list_of_plots_which_use_percent_cover; Type: TYPE; Schema: public_validations; Owner: -

--

--

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

--

CREATE TABLE `~type._plots_08_list_of_plots_which_use_percent_cover` (

    project_name varchar(255),

    plot_code varchar(255)

);

--

-- Name: keys(`~type._plots_08_list_of_plots_which_use_percent_cover`); Type: FUNCTION; Schema: public_validations; Owner: -

--

--

-- Name: values_(`~type._plots_08_list_of_plots_which_use_percent_cover`); Type: FUNCTION; Schema: public_validations; Owner: -

--

--

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

--

--

-- Data for Name: ~type._plots_08_list_of_plots_which_use_percent_cover; Type: TABLE DATA; Schema: public_validations; Owner: -

--

--

-- Name: keys_~type._plots_08_list_of_plots_which_use_percent_cover; Type: TYPE; Schema: public_validations; Owner: -

--

CREATE TYPE "keys_~type._plots_08_list_of_plots_which_use_percent_cover" AS (

	project_name text,

	plot_code text

);

--

-- Name: values__~type._plots_08_list_of_plots_which_use_percent_cover; Type: TYPE; Schema: public_validations; Owner: -

--

CREATE TYPE "values__~type._plots_08_list_of_plots_which_use_percent_cover" AS (

	project_name text,

	plot_code text

);

--

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

--

CREATE TABLE "~type._plots_08_list_of_plots_which_use_percent_cover" (

    project_name text,

    plot_code text

);

--

-- Name: keys("~type._plots_08_list_of_plots_which_use_percent_cover"); Type: FUNCTION; Schema: public_validations; Owner: -

--

CREATE FUNCTION keys(value "~type._plots_08_list_of_plots_which_use_percent_cover") RETURNS "keys_~type._plots_08_list_of_plots_which_use_percent_cover"

    LANGUAGE sql IMMUTABLE

    AS $_$

SELECT ROW($1.project_name, $1.plot_code)::public_validations."keys_~type._plots_08_list_of_plots_which_use_percent_cover"

$_$;

--

-- Name: values_("~type._plots_08_list_of_plots_which_use_percent_cover"); Type: FUNCTION; Schema: public_validations; Owner: -

--

CREATE FUNCTION values_(value "~type._plots_08_list_of_plots_which_use_percent_cover") RETURNS "values__~type._plots_08_list_of_plots_which_use_percent_cover"

    LANGUAGE sql IMMUTABLE

    AS $_$

SELECT ROW($1.project_name, $1.plot_code)::public_validations."values__~type._plots_08_list_of_plots_which_use_percent_cover"

$_$;

--

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

--

CREATE VIEW _plots_08_list_of_plots_which_use_percent_cover AS

 SELECT project.projectname AS project_name, 

    plot.authorlocationcode AS plot_code

   FROM ((public.plot

   JOIN public.locationevent USING (plot_id))

   LEFT JOIN public.project USING (project_id))

  WHERE ((plot.source_id = ( SELECT public.source_by_shortname(("current_schema"())::text) AS source_by_shortname)) AND (EXISTS ( SELECT NULL::unknown AS unknown

   FROM (((public.location

   JOIN public.locationevent locationevent_1 USING (location_id))

   JOIN public.taxonoccurrence USING (locationevent_id))

   JOIN public.aggregateoccurrence USING (taxonoccurrence_id))

  WHERE ((location.plot_location_id = plot.plot_id) AND (aggregateoccurrence.cover_fraction IS NOT NULL))

 LIMIT 1)))

  ORDER BY plot.authorlocationcode;

--

-- Data for Name: ~type._plots_08_list_of_plots_which_use_percent_cover; Type: TABLE DATA; Schema: public_validations; Owner: -

--

--