--

CREATE FUNCTION _dms_to_dd(value text DEFAULT NULL::text) RETURNS double precision

    AS $_$

SELECT (g[1]||'1')::integer*util._dms_to_dd(deg := g[2]::double precision, min := g[3]::double precision, sec := g[4]::double precision, dir := g[5]::util.compass_dir)

FROM 

--

CREATE FUNCTION join_strs_transform(state text, value text, delim text) RETURNS text

    AS $_$

SELECT $1 || $3 || $2

$_$;

--

CREATE FUNCTION raise_error_notice(msg text) RETURNS void

    AS $_$

SELECT util.raise_notice('ERROR:  '||$1)

$_$;

);

--

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

--

--

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

--

--

CREATE FUNCTION _cm_to_m(value double precision) RETURNS double precision

    AS $_$

SELECT $1/100.

$_$;

--

CREATE FUNCTION _filter_genus(value text) RETURNS text

    AS $_$

SELECT (CASE WHEN $1 ~ '\d' THEN NULL ELSE $1 END)

$_$;

--

CREATE FUNCTION _fraction_to_percent(value double precision) RETURNS double precision

    AS $_$

SELECT $1*100.

$_$;

--

CREATE FUNCTION _ft_to_m(value double precision) RETURNS double precision

    AS $_$

SELECT _in_to_m($1*12)

$_$;

--

CREATE FUNCTION _ha_to_m2(value double precision) RETURNS double precision

    AS $_$

SELECT $1*10000.

$_$;

--

CREATE FUNCTION _has_taxonomic_name(rank taxonrank) RETURNS boolean

    AS $_$

SELECT $1 >= 'family'

$_$;

--

CREATE FUNCTION _in_to_m(value double precision) RETURNS double precision

    AS $_$

SELECT $1*2.54/100.

$_$;

--

CREATE FUNCTION _km_to_m(value double precision) RETURNS double precision

    AS $_$

SELECT $1*1000.

$_$;

--

CREATE FUNCTION _locationnarrative_is_cultivated(locationnarrative text) RETURNS boolean

    AS $_$

SELECT bool_or(value)

FROM

--

CREATE FUNCTION _m2_to_ha(value double precision) RETURNS double precision

    AS $_$

SELECT $1/10000.

$_$;

--

CREATE FUNCTION _m_to_cm(value double precision) RETURNS double precision

    AS $_$

SELECT $1*100.

$_$;

--

CREATE FUNCTION _m_to_km(value double precision) RETURNS double precision

    AS $_$

SELECT $1/1000.

$_$;

--

CREATE FUNCTION _mm_to_m(value double precision) RETURNS double precision

    AS $_$

SELECT $1/1000.

$_$;

--

CREATE FUNCTION _percent_to_fraction(value double precision) RETURNS double precision

    AS $_$

SELECT $1/100.

$_$;

--

CREATE FUNCTION _taxon_family_require_std(family text) RETURNS text

    AS $_$

SELECT (CASE WHEN

    lower($1) LIKE '%aceae'

--

CREATE FUNCTION _taxonomic_name_is_epithet(rank taxonrank) RETURNS boolean

    AS $_$

SELECT $1 <= 'genus'

$_$;

);

SET search_path = public, pg_catalog;

--

--

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

--