--
-- PostgreSQL database dump
--

SET statement_timeout = 0;
SET lock_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SET check_function_bodies = false;
SET client_min_messages = warning;

SET search_path = public, pg_catalog;

SET default_tablespace = '';

SET default_with_oids = false;

--
-- Name: s1_main; Type: TABLE; Schema: public; Owner: ws; Tablespace: 
--

CREATE TABLE s1_main (
    prikey integer NOT NULL,
    parkey integer,
    _bad boolean DEFAULT false,
    _bad_reason text,
    _user text,
    _version text,
    _device text,
    _start timestamp with time zone,
    _end timestamp with time zone,
    _task_key text,
    name text,
    found text,
    street_number integer,
    street_name text,
    suburb_town text,
    site_name text,
    location text,
    location_other text,
    incident text,
    class text,
    hotshots text,
    hotshot_image text,
    risk text,
    risk_description text,
    waste_bins integer,
    recycling_bins integer,
    butt_bins integer,
    bins__bins_overflowing integer,
    bins__bins_repair integer,
    bins__bins_signage integer,
    source__passing_vehicles integer,
    source__passing_pedestrians integer,
    source__gathering_points_seats integer,
    source__schools integer,
    source__bank_atm integer,
    source__transport_stop integer,
    source__retail integer,
    source__food_outlets integer,
    source__outdoor_event integer,
    source__tourist_site integer,
    source__weather integer,
    source__other integer,
    source_other text,
    green_waste integer,
    building_waste integer,
    soils_fill integer,
    general_other integer,
    asbestos integer,
    other_material integer,
    mattresses integer,
    furniture integer,
    whitegoods integer,
    tyres integer,
    ewaste integer,
    car_bodies integer,
    evidence text,
    comments text,
    investigation text,
    cleanup text,
    cleanup_other text,
    instanceid text,
    the_geom geometry(Point,4326)
);


ALTER TABLE public.s1_main OWNER TO ws;

--
-- Name: s1_main_prikey_seq; Type: SEQUENCE; Schema: public; Owner: ws
--

CREATE SEQUENCE s1_main_prikey_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.s1_main_prikey_seq OWNER TO ws;

--
-- Name: s1_main_prikey_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ws
--

ALTER SEQUENCE s1_main_prikey_seq OWNED BY s1_main.prikey;


--
-- Name: prikey; Type: DEFAULT; Schema: public; Owner: ws
--

ALTER TABLE ONLY s1_main ALTER COLUMN prikey SET DEFAULT nextval('s1_main_prikey_seq'::regclass);


--
-- Data for Name: s1_main; Type: TABLE DATA; Schema: public; Owner: ws
--

COPY s1_main (prikey, parkey, _bad, _bad_reason, _user, _version, _device, _start, _end, _task_key, name, found, street_number, street_name, suburb_town, site_name, location, location_other, incident, class, hotshots, hotshot_image, risk, risk_description, waste_bins, recycling_bins, butt_bins, bins__bins_overflowing, bins__bins_repair, bins__bins_signage, source__passing_vehicles, source__passing_pedestrians, source__gathering_points_seats, source__schools, source__bank_atm, source__transport_stop, source__retail, source__food_outlets, source__outdoor_event, source__tourist_site, source__weather, source__other, source_other, green_waste, building_waste, soils_fill, general_other, asbestos, other_material, mattresses, furniture, whitegoods, tyres, ewaste, car_bodies, evidence, comments, investigation, cleanup, cleanup_other, instanceid, the_geom) FROM stdin;
1	0	f	\N	neil	6	353203050168908	2014-12-15 02:55:09.611+00	2014-12-15 20:49:46.042+00		NP	passing_by	\N	Station Road	Castlemaine	Station	other	Car Park	general_litter	commercial_industrial	2	attachments/s1_1/12bd34f2-92d2-48c8-805a-0faf947d7911.jpg	moderate	Actually no risk previous question should have had a option of none	2	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	North east of station building	no	cleanup_requested	\N	uuid:df0145d4-de22-49d5-b40b-976f83048540	0101000020E61000005E00F125DA0662405B7A55E3FC8742C0
2	0	f	\N	martin	6	webform	2014-12-15 23:41:53+00	2014-12-15 23:47:57+00		mp	passing_by	\N	50 Lonsdale Street	Melbourne	SV Cafe	private_land		illegal_dumping	commercial_industrial	3	\N			\N	\N	\N	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0		\N	\N	\N	1	\N	\N	\N	\N	\N	\N	\N	\N	Cafe items found		yes	immediate_cleanup		uuid:979112ce-cbe7-4968-be8f-869201d87aa9	0101000020E610000077D3D281111F6240C4CBD3B9A2E742C0
3	0	f	\N	neil	6	webform	2014-12-16 00:17:24+00	2014-12-16 00:21:01+00		NP	complaint_service_request	23	Lonsdale	Melbourne	Urban Workshop	building_site		illegal_dumping	commercial_industrial	3	attachments/s1_1/3aaf0c55-30ab-4345-afbb-29b40168f57e.png	moderate		\N	\N	\N	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0		\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N			yes	cleanup_requested		uuid:37011f06-7a04-491a-95d9-82f2b7640aa5	0101000020E6100000FFFFE755091F62404B4C63E487E742C0
\.


--
-- Name: s1_main_prikey_seq; Type: SEQUENCE SET; Schema: public; Owner: ws
--

SELECT pg_catalog.setval('s1_main_prikey_seq', 3, true);


--
-- Name: s1_main_pkey; Type: CONSTRAINT; Schema: public; Owner: ws; Tablespace: 
--

ALTER TABLE ONLY s1_main
    ADD CONSTRAINT s1_main_pkey PRIMARY KEY (prikey);


--
-- PostgreSQL database dump complete
--

