TRUNCATE geoscrub_input;

INSERT INTO geoscrub_input SELECT * FROM geoscrub_input_view;

-- Name: sync_geoscrub_input_to_view(); Type: FUNCTION; Schema: public; Owner: -

--

CREATE FUNCTION sync_geoscrub_input_to_view() RETURNS void

    LANGUAGE sql

    AS $$

DROP TABLE IF EXISTS geoscrub_input;

CREATE TABLE geoscrub_input AS SELECT * FROM geoscrub_input_view;

$$;

--

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

--

CREATE TABLE geoscrub_input (

    country text,

    "stateProvince" text,

    county text,

    "decimalLatitude" double precision,

    "decimalLongitude" double precision

);

--

-- Name: geoscrub_input_view; Type: VIEW; Schema: public; Owner: -

--

CREATE VIEW geoscrub_input_view AS

    SELECT DISTINCT analytical_aggregate.country, analytical_aggregate."stateProvince", analytical_aggregate.county, analytical_aggregate."decimalLatitude", analytical_aggregate."decimalLongitude" FROM analytical_aggregate;

--