--
-- 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;

--
-- Name: verschn_fehler; Type: SCHEMA; Schema: -; Owner: postgres
--

CREATE SCHEMA verschn_fehler;


ALTER SCHEMA verschn_fehler OWNER TO postgres;

SET search_path = verschn_fehler, pg_catalog;

SET default_tablespace = '';

SET default_with_oids = false;

--
-- Name: intersection_result; Type: TABLE; Schema: verschn_fehler; Owner: postgres; Tablespace: 
--

CREATE TABLE intersection_result (
    intersection_geom public.geometry,
    gid integer NOT NULL
);


ALTER TABLE verschn_fehler.intersection_result OWNER TO postgres;

--
-- Name: intersection_result_gid_seq; Type: SEQUENCE; Schema: verschn_fehler; Owner: postgres
--

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


ALTER TABLE verschn_fehler.intersection_result_gid_seq OWNER TO postgres;

--
-- Name: intersection_result_gid_seq; Type: SEQUENCE OWNED BY; Schema: verschn_fehler; Owner: postgres
--

ALTER SEQUENCE intersection_result_gid_seq OWNED BY intersection_result.gid;


--
-- Name: object; Type: TABLE; Schema: verschn_fehler; Owner: postgres; Tablespace: 
--

CREATE TABLE object (
    id_0 integer NOT NULL,
    geom public.geometry(MultiPolygon,21781),
    id integer,
    text character varying(80)
);


ALTER TABLE verschn_fehler.object OWNER TO postgres;

--
-- Name: object_id_0_seq; Type: SEQUENCE; Schema: verschn_fehler; Owner: postgres
--

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


ALTER TABLE verschn_fehler.object_id_0_seq OWNER TO postgres;

--
-- Name: object_id_0_seq; Type: SEQUENCE OWNED BY; Schema: verschn_fehler; Owner: postgres
--

ALTER SEQUENCE object_id_0_seq OWNED BY object.id_0;


--
-- Name: parcels; Type: TABLE; Schema: verschn_fehler; Owner: postgres; Tablespace: 
--

CREATE TABLE parcels (
    id_0 integer NOT NULL,
    geom public.geometry(Polygon,21781),
    gid integer,
    id integer,
    name character varying(80),
    "Tabelle1_Field2" character varying
);


ALTER TABLE verschn_fehler.parcels OWNER TO postgres;

--
-- Name: parcels_id_0_seq; Type: SEQUENCE; Schema: verschn_fehler; Owner: postgres
--

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


ALTER TABLE verschn_fehler.parcels_id_0_seq OWNER TO postgres;

--
-- Name: parcels_id_0_seq; Type: SEQUENCE OWNED BY; Schema: verschn_fehler; Owner: postgres
--

ALTER SEQUENCE parcels_id_0_seq OWNED BY parcels.id_0;


--
-- Name: gid; Type: DEFAULT; Schema: verschn_fehler; Owner: postgres
--

ALTER TABLE ONLY intersection_result ALTER COLUMN gid SET DEFAULT nextval('intersection_result_gid_seq'::regclass);


--
-- Name: id_0; Type: DEFAULT; Schema: verschn_fehler; Owner: postgres
--

ALTER TABLE ONLY object ALTER COLUMN id_0 SET DEFAULT nextval('object_id_0_seq'::regclass);


--
-- Name: id_0; Type: DEFAULT; Schema: verschn_fehler; Owner: postgres
--

ALTER TABLE ONLY parcels ALTER COLUMN id_0 SET DEFAULT nextval('parcels_id_0_seq'::regclass);


--
-- Data for Name: intersection_result; Type: TABLE DATA; Schema: verschn_fehler; Owner: postgres
--

COPY intersection_result (intersection_geom, gid) FROM stdin;
0103000020155500000100000008000000546A9AD11DE52341479A83739E3F0441761513DA2AE523412FE8F8EBCD3E044121FF2485BBE42341E9037B54C73E0441A420108396E42341345DE9DE04420441C731B1ACF4E423411C2317C230420441E30E7B139AE423415F517955DA4704410DA7EC171AE52341BDCE5F0EDA3F0441546A9AD11DE52341479A83739E3F0441	1
0103000020155500000100000005000000DF9D041BE9E32341F6D3FDDE12560441E30E7B139AE423415F517955DA470441BD3B71DE8DE3234190347EC7D7520441B74CD71CDBE2234115A0398FA6560441DF9D041BE9E32341F6D3FDDE12560441	2
0103000020155500000100000005000000BA070E49F5E5234119041583684E0441E30E7B139AE423415F517955DA470441DF9D041BE9E32341F6D3FDDE12560441B41EB2B068E5234100C2050C41550441BA070E49F5E5234119041583684E0441	3
\.


--
-- Name: intersection_result_gid_seq; Type: SEQUENCE SET; Schema: verschn_fehler; Owner: postgres
--

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


--
-- Data for Name: object; Type: TABLE DATA; Schema: verschn_fehler; Owner: postgres
--

COPY object (id_0, geom, id, text) FROM stdin;
10	010600002015550000010000000103000000010000000D000000B74CD71CDBE2234115A0398FA6560441B41EB2B068E5234100C2050C41550441E9F7D8E458E62341165E33E18E490441B41EB2B068E52341A62E98C93D460441769A186195E523410D4395AB214004410DA7EC171AE52341BDCE5F0EDA3F0441761513DA2AE523412FE8F8EBCD3E044121FF2485BBE42341E9037B54C73E0441A420108396E42341345DE9DE04420441C731B1ACF4E423411C2317C230420441E30E7B139AE423415F517955DA470441BD3B71DE8DE3234190347EC7D7520441B74CD71CDBE2234115A0398FA6560441	1	\N
\.


--
-- Name: object_id_0_seq; Type: SEQUENCE SET; Schema: verschn_fehler; Owner: postgres
--

SELECT pg_catalog.setval('object_id_0_seq', 1, false);


--
-- Data for Name: parcels; Type: TABLE DATA; Schema: verschn_fehler; Owner: postgres
--

COPY parcels (id_0, geom, gid, id, name, "Tabelle1_Field2") FROM stdin;
1	010300002015550000010000000800000088C0139F8EE92341A656DBA2CD5F0441947C7397CCEA2341CBBF673B7C5404418A5A3A72DAE923418B1F3243A64C04418A5A3A72DAE923418B1F3243A64C044187FD43B7A2E52341BC7A7F77F93704414DAC5A2198E52341BC7A7F77F9370441E30E7B139AE423415F517955DA47044188C0139F8EE92341A656DBA2CD5F0441	3	3	drei	cc
2	01030000201555000001000000090000008A5A3A72DAE923418B1F3243A64C0441F1F972ACDDE923419420AFBA0E4D044162FB6752D6F623411429E165214F0441D12875FD8B0124419D20A0750C4404413978B50CB2E8234125E28E4C471004413978B50CB2E8234125E28E4C471004414DAC5A2198E52341BC7A7F77F937044187FD43B7A2E52341BC7A7F77F93704418A5A3A72DAE923418B1F3243A64C0441	1	1	erstes	aa
3	0103000020155500000100000006000000F1F972ACDDE923419420AFBA0E4D0441BAFFAF04C9EA2341D30A5DA15E5404413E95EC396EEC2341DCD065F8095904411F4002DC4EF6234168BD0BBF8051044162FB6752D6F623411429E165214F0441F1F972ACDDE923419420AFBA0E4D0441	4	4	vier	dd
4	01030000201555000001000000080000004212DEDA21E42341DEC091BD213804414DAC5A2198E52341BC7A7F77F9370441E30E7B139AE423415F517955DA470441922CF6AD71E32341531370A2AB5F0441282DA0E56DE2234167E257525E5F04413F4C0331ACDE234160F51E2C844A04413F4C0331ACDE234160F51E2C844A04414212DEDA21E42341DEC091BD21380441	12	12	\N	\N
5	0103000020155500000100000007000000922CF6AD71E32341531370A2AB5F0441282DA0E56DE2234167E257525E5F0441D264636368E12341444798D1E6640441F621D95890E923413A5815FAD55F044188C0139F8EE92341A656DBA2CD5F0441E30E7B139AE423415F517955DA470441922CF6AD71E32341531370A2AB5F0441	2	2	zwei	bb
\.


--
-- Name: parcels_id_0_seq; Type: SEQUENCE SET; Schema: verschn_fehler; Owner: postgres
--

SELECT pg_catalog.setval('parcels_id_0_seq', 5, true);


--
-- Name: intersection_result_pkey; Type: CONSTRAINT; Schema: verschn_fehler; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY intersection_result
    ADD CONSTRAINT intersection_result_pkey PRIMARY KEY (gid);


--
-- Name: object_pkey; Type: CONSTRAINT; Schema: verschn_fehler; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY object
    ADD CONSTRAINT object_pkey PRIMARY KEY (id_0);


--
-- Name: parcels_pkey; Type: CONSTRAINT; Schema: verschn_fehler; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY parcels
    ADD CONSTRAINT parcels_pkey PRIMARY KEY (id_0);


--
-- PostgreSQL database dump complete
--

