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

--

CREATE TYPE "keys_~type._specimens_13a_list_of_all_verbatim_lat_long" AS (

	"verbatimLatitude" text,

	"verbatimLongitude" text

);

--

-- Name: TYPE "keys_~type._specimens_13a_list_of_all_verbatim_lat_long"; Type: COMMENT; Schema: public_validations; Owner: -

--

COMMENT ON TYPE "keys_~type._specimens_13a_list_of_all_verbatim_lat_long" IS '

autogenerated

';

--

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

--

CREATE TYPE "keys_~type._specimens_13b_list_of_all_decimal_lat_long" AS (

	"decimalLatitude" double precision,

	"decimalLongitude" double precision

);

--

-- Name: TYPE "keys_~type._specimens_13b_list_of_all_decimal_lat_long"; Type: COMMENT; Schema: public_validations; Owner: -

--

COMMENT ON TYPE "keys_~type._specimens_13b_list_of_all_decimal_lat_long" IS '

autogenerated

';

--

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

--

CREATE TYPE "values__~type._specimens_13a_list_of_all_verbatim_lat_long" AS (

	"verbatimLatitude" text,

	"verbatimLongitude" text

);

--

-- Name: TYPE "values__~type._specimens_13a_list_of_all_verbatim_lat_long"; Type: COMMENT; Schema: public_validations; Owner: -

--

COMMENT ON TYPE "values__~type._specimens_13a_list_of_all_verbatim_lat_long" IS '

autogenerated

';

--

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

--

CREATE TYPE "values__~type._specimens_13b_list_of_all_decimal_lat_long" AS (

	"decimalLatitude" double precision,

	"decimalLongitude" double precision

);

--

-- Name: TYPE "values__~type._specimens_13b_list_of_all_decimal_lat_long"; Type: COMMENT; Schema: public_validations; Owner: -

--

COMMENT ON TYPE "values__~type._specimens_13b_list_of_all_decimal_lat_long" IS '

autogenerated

';

--

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

--

CREATE TABLE "~type._specimens_13a_list_of_all_verbatim_lat_long" (

    "verbatimLatitude" text,

    "verbatimLongitude" text

);

--

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

--

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

    LANGUAGE sql IMMUTABLE

    AS $_$

SELECT ROW($1."verbatimLatitude", $1."verbatimLongitude")::public_validations."keys_~type._specimens_13a_list_of_all_verbatim_lat_long"

$_$;

--

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

--

CREATE TABLE "~type._specimens_13b_list_of_all_decimal_lat_long" (

    "decimalLatitude" double precision,

    "decimalLongitude" double precision

);

--

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

--

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

    LANGUAGE sql IMMUTABLE

    AS $_$

SELECT ROW($1."decimalLatitude", $1."decimalLongitude")::public_validations."keys_~type._specimens_13b_list_of_all_decimal_lat_long"

$_$;

--

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

--

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

    LANGUAGE sql IMMUTABLE

    AS $_$

SELECT ROW($1."verbatimLatitude", $1."verbatimLongitude")::public_validations."values__~type._specimens_13a_list_of_all_verbatim_lat_long"

$_$;

--

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

--

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

    LANGUAGE sql IMMUTABLE

    AS $_$

SELECT ROW($1."decimalLatitude", $1."decimalLongitude")::public_validations."values__~type._specimens_13b_list_of_all_decimal_lat_long"

$_$;

--

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

--

CREATE VIEW _specimens_13a_list_of_all_verbatim_lat_long AS

 SELECT DISTINCT COALESCE(coordinates.verbatimlatitude, (coordinates.latitude_deg)::text) AS "verbatimLatitude", 

    COALESCE(coordinates.verbatimlatitude, (coordinates.longitude_deg)::text) AS "verbatimLongitude"

   FROM public.coordinates

  WHERE (((coordinates.source_id = ( SELECT public.source_by_shortname(("current_schema"())::text) AS source_by_shortname)) AND ((coordinates.verbatimlatitude IS NOT NULL) OR (coordinates.latitude_deg IS NOT NULL))) AND ((coordinates.verbatimlongitude IS NOT NULL) OR (coordinates.longitude_deg IS NOT NULL)));

--

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

--

CREATE VIEW _specimens_13b_list_of_all_decimal_lat_long AS

 SELECT DISTINCT coordinates.latitude_deg AS "decimalLatitude", 

    coordinates.longitude_deg AS "decimalLongitude"

   FROM public.coordinates

  WHERE (((coordinates.source_id = ( SELECT public.source_by_shortname(("current_schema"())::text) AS source_by_shortname)) AND (coordinates.latitude_deg IS NOT NULL)) AND (coordinates.longitude_deg IS NOT NULL));

--

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

--

--

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

--

--