-- Name: _plots_10a_aggregate_observation_individual_counts; Type: VIEW; Schema: SALVIAS; Owner: -

--

CREATE VIEW _plots_10a_aggregate_observation_individual_counts AS

 SELECT p.project_name, 

    (pm."SiteCode")::text AS plot_code, 

    po."PlotObsID" AS individual_id, 

    po."NoInd" AS individuals

   FROM ((projects p

   JOIN "plotMetadata" pm ON ((p.project_id = pm.project_id)))

   JOIN "plotObservations" po ON ((pm."PlotID" = po."PlotID")))

  ORDER BY p.project_name, (pm."SiteCode")::text, po."PlotObsID";

--

-- Name: VIEW _plots_10a_aggregate_observation_individual_counts; Type: COMMENT; Schema: SALVIAS; Owner: -

--

COMMENT ON VIEW _plots_10a_aggregate_observation_individual_counts IS '

Note 1: `individuals` should be NULL for plots which use percent cover or line-intercept methods.

';

--

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

--

--

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

--

--

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

--

CREATE TABLE `~type._plots_10a_aggregate_observation_individual_counts` (

    project_name varchar(255),

    plot_code varchar(255),

    individual_id varchar(255),

    individuals int(11)

);

--

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

--

--

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

--

--

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

--

--

-- Name: VIEW _plots_10a_aggregate_observation_individual_counts; Type: COMMENT; Schema: public_validations; Owner: -

--

--

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

--

--

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

--

CREATE TYPE "keys_~type._plots_10a_aggregate_observation_individual_counts" AS (

	project_name text,

	plot_code text,

	individual_id text

);

--

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

--

CREATE TYPE "values__~type._plots_10a_aggregate_observation_individual_count" AS (

	individuals integer

);

--

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

--

CREATE TABLE "~type._plots_10a_aggregate_observation_individual_counts" (

    project_name text,

    plot_code text,

    individual_id text,

    individuals integer

);

--

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

--

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

    LANGUAGE sql IMMUTABLE

    AS $_$

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

$_$;

--

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

--

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

    LANGUAGE sql IMMUTABLE

    AS $_$

SELECT ROW($1.individuals)::public_validations."values__~type._plots_10a_aggregate_observation_individual_count"

$_$;

--

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

--

CREATE VIEW _plots_10a_aggregate_observation_individual_counts AS

 SELECT p.projectname AS project_name, 

    l.authorlocationcode AS plot_code, 

    ao.sourceaccessioncode AS individual_id, 

    ao.count AS individuals

   FROM ((((((public.project p

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

   JOIN public.place_visit ON ((p.project_id = place_visit.project_id)))

   JOIN public.locationevent le ON ((place_visit.locationevent_id = le.place_visit_id)))

   JOIN public.plot l ON ((place_visit.location_id = l.location_id)))

   JOIN public.taxonoccurrence o ON ((le.locationevent_id = o.locationevent_id)))

   JOIN public.aggregateoccurrence ao ON ((o.taxonoccurrence_id = ao.taxonoccurrence_id)))

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

  ORDER BY p.projectname, l.authorlocationcode, ao.sourceaccessioncode;

--

-- Name: VIEW _plots_10a_aggregate_observation_individual_counts; Type: COMMENT; Schema: public_validations; Owner: -

--

COMMENT ON VIEW _plots_10a_aggregate_observation_individual_counts IS '

Note 1: `individuals` should be NULL for plots which use percent cover or line-intercept methods.

';

--

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

--

--