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

--

--

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

--

--

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

--

CREATE TABLE `~type._plots_09_list_of_plots_which_use_line_intercept` (

    project_name varchar(255),

    plot_code varchar(255)

);

--

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

--

--

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

--

--

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

--

--

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

--

--

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

--

CREATE TYPE "keys_~type._plots_09_list_of_plots_which_use_line_intercept" AS (

	project_name text,

	plot_code text

);

--

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

--

CREATE TYPE "values__~type._plots_09_list_of_plots_which_use_line_intercept" AS (

	project_name text,

	plot_code text

);

--

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

--

CREATE TABLE "~type._plots_09_list_of_plots_which_use_line_intercept" (

    project_name text,

    plot_code text

);

--

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

--

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

    LANGUAGE sql IMMUTABLE

    AS $_$

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

$_$;

--

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

--

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

    LANGUAGE sql IMMUTABLE

    AS $_$

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

$_$;

--

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

--

CREATE VIEW _plots_09_list_of_plots_which_use_line_intercept 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.locationevent locationevent_1

   JOIN public.taxonoccurrence USING (locationevent_id))

   JOIN public.aggregateoccurrence USING (taxonoccurrence_id))

  WHERE ((locationevent_1.plot_id = plot.plot_id) AND (aggregateoccurrence.linecover_m IS NOT NULL))

 LIMIT 1)))

  ORDER BY plot.authorlocationcode;

--

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

--

--