03_st_difference_insert.sql

--
-- PostgreSQL database dump
--

-- Dumped from database version 9.5.4
-- Dumped by pg_dump version 9.5.4
DROP SCHEMA IF EXISTS test;
CREATE SCHEMA test;
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 row_security = off;

SET search_path = test, pg_catalog;

SET default_tablespace = '';

SET default_with_oids = false;

--
-- Name: test1; Type: TABLE; Schema: test; Owner: -
--

CREATE TABLE test1 (
    id integer NOT NULL,
    geom public.geometry(Polygon,5514)
);


--
-- Name: test1_id_seq; Type: SEQUENCE; Schema: test; Owner: -
--

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


--
-- Name: test1_id_seq; Type: SEQUENCE OWNED BY; Schema: test; Owner: -
--

ALTER SEQUENCE test1_id_seq OWNED BY test1.id;


--
-- Name: test2; Type: TABLE; Schema: test; Owner: -
--

CREATE TABLE test2 (
    id integer NOT NULL,
    geom public.geometry(Polygon,5514)
);


--
-- Name: test2_id_seq; Type: SEQUENCE; Schema: test; Owner: -
--

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


--
-- Name: test2_id_seq; Type: SEQUENCE OWNED BY; Schema: test; Owner: -
--

ALTER SEQUENCE test2_id_seq OWNED BY test2.id;


--
-- Name: test3_ogc_fid_seq; Type: SEQUENCE; Schema: test; Owner: -
--

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


--
-- Name: test_disjoint; Type: TABLE; Schema: test; Owner: -
--

CREATE TABLE test_disjoint (
    id integer NOT NULL,
    geom public.geometry(Point,5514)
);


--
-- Name: test_disjoint_id_seq; Type: SEQUENCE; Schema: test; Owner: -
--

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


--
-- Name: test_disjoint_id_seq; Type: SEQUENCE OWNED BY; Schema: test; Owner: -
--

ALTER SEQUENCE test_disjoint_id_seq OWNED BY test_disjoint.id;


--
-- Name: id; Type: DEFAULT; Schema: test; Owner: -
--

ALTER TABLE ONLY test1 ALTER COLUMN id SET DEFAULT nextval('test1_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: test; Owner: -
--

ALTER TABLE ONLY test2 ALTER COLUMN id SET DEFAULT nextval('test2_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: test; Owner: -
--

ALTER TABLE ONLY test_disjoint ALTER COLUMN id SET DEFAULT nextval('test_disjoint_id_seq'::regclass);


--
-- Data for Name: test1; Type: TABLE DATA; Schema: test; Owner: -
--

INSERT INTO test1 (id, geom) VALUES (1, '01030000208A1500000100000006000000951452B0C12822C12494668144B431C16EF852A2F82522C1CBF6596A48B331C1CA5FA6D8EA2322C16CBE8577D8B331C1CD302795682522C1804C85FE3CB531C13C774599C52722C19FAB702D0EB531C1951452B0C12822C12494668144B431C1');
INSERT INTO test1 (id, geom) VALUES (2, '01030000208A1500000100000008000000AD1493728E1F22C184CC3A74B4B331C1D0F33317D71D22C1B9D43790E6B431C157480718102022C14BFAF6388CB531C194A13A66372122C105357B5273B431C15F4FACA0862122C1C28A11D256B331C1822E4D45CF1F22C11A72AF92D1B231C159ADAA278B1E22C124DEF72AC3B231C1AD1493728E1F22C184CC3A74B4B331C1');
INSERT INTO test1 (id, geom) VALUES (3, '01030000208A1500000100000009000000547EC0F8192322C12014B10BCDB531C191D7F346412422C1D4B36D4940B631C1F00FC839B12322C1477A41C314B731C1054DFC790F2222C139D8D45E2AB731C1B51B38FB042122C14FCB77F509B731C1A779CB961A2122C1D2985BE343B631C1303342A7CE2122C147C4D26C93B531C1BD22DD837B2222C176E03C664BB531C1547EC0F8192322C12014B10BCDB531C1');
INSERT INTO test1 (id, geom) VALUES (4, '01030000208A15000001000000080000009243D1F3432722C1EEDC34AC18B631C1B78E4F458F2822C194DA8485A1B631C116C72338FF2722C1E8416DD0A4B731C121980FE06B2622C1E6265B6AA8B731C1E53EDC91442522C1F2ADB56896B731C1BA589664852522C1A061DF838FB631C16EF852A2F82522C1F312597811B631C19243D1F3432722C1EEDC34AC18B631C1');
INSERT INTO test1 (id, geom) VALUES (5, '01030000208A150000010000000800000095FFA3D82A1B22C1DB04A47B35B631C1D3BD7A36CD1A22C1F25CEA2190B431C1144698B3651722C1EE26C65597B431C161A6DB75F21622C1524B2D6B81B531C123E80418501722C1CF7D497D47B631C1CBB6D5AD561922C1C1DBDC185DB631C171B42587DF1922C14BFAF6388CB531C195FFA3D82A1B22C1DB04A47B35B631C1');


--
-- Name: test1_id_seq; Type: SEQUENCE SET; Schema: test; Owner: -
--

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


--
-- Data for Name: test2; Type: TABLE DATA; Schema: test; Owner: -
--

INSERT INTO test2 (id, geom) VALUES (1, '01030000208A1500000100000007000000BF8EBA307E2522C11FA8D35ECAB231C1C3C4DEFC762522C1C28A11D256B331C12B0458785D2622C19489B93E9BB331C136D54320CA2422C12494668144B431C11BF60D67702322C1031A69EC76B431C141A62FC8362322C1C9DB47044CB331C1BF8EBA307E2522C11FA8D35ECAB231C1');
INSERT INTO test2 (id, geom) VALUES (2, '01030000208A15000001000000080000009A433CDF322422C1428EAEA09AB531C18D06738AC32222C19FAB702D0EB531C118258DAAF22122C1B7B9252AEAB431C1775D619D622122C1578151377AB531C1303342A7CE2122C119C37AD9D7B531C141A62FC8362322C10906FC0EF1B531C179C93E4A652422C1148D560DDFB531C19A433CDF322422C1428EAEA09AB531C1');
INSERT INTO test2 (id, geom) VALUES (3, '01030000208A15000001000000070000004C70E1D21B1D22C1F577FC878CB431C1A506B44C901922C13CA21B7E20B431C19DFF0EC4191822C189025F40ADB331C13BF6B9142C1722C1B068EFF7F4B431C1345BF238B81822C117A86873DBB531C15F487203FF1C22C1360754A2ACB531C14C70E1D21B1D22C1F577FC878CB431C1');
INSERT INTO test2 (id, geom) VALUES (4, '01030000208A1500000100000006000000ACBD639D222A22C1524B2D6B81B531C1722E776EF12522C149DFE4D28FB531C1A24AE167A92522C17EE7E1EEC1B631C1951452B0C12822C18FA460B9A8B631C17235B10B792A22C19B2BBBB796B631C1ACBD639D222A22C1524B2D6B81B531C1');
INSERT INTO test2 (id, geom) VALUES (5, '01030000208A15000001000000070000004EDCBE7F1E2022C196EE5C4E16B231C1D7953590D22022C1E83A33331DB331C1FEAAFA00141F22C1AFB280A173B331C1B779A16DF81A22C1FD2DD6C9FCB231C1F808F987181C22C1ACE1FFE4F5B131C159ADAA278B1E22C1E24EA010A3B131C14EDCBE7F1E2022C196EE5C4E16B231C1');
INSERT INTO test2 (id, geom) VALUES (6, '01030000208A15000001000000060000008DFF38ED3B1E22C1CF7D497D47B631C1DA584212411922C1185ED7C95CB731C12EC02A5D441A22C181B862AB3FB831C1419FF52AAF1E22C16AAAADAE63B831C13198E5B6492022C1D033B8D3C8B731C18DFF38ED3B1E22C1CF7D497D47B631C1');
INSERT INTO test2 (id, geom) VALUES (7, '01030000208A150000010000000700000047483141322622C14829767C0EB431C1A0E53D582E2722C14829767C0EB431C17F6B40C3602722C1F9AD205485B431C1F27BA5E6B32622C1CA91B65ACDB431C194A87403BF2522C1C776A4F4D0B431C1ACB629009B2522C1205E42B54BB431C147483141322622C14829767C0EB431C1');


--
-- Name: test2_id_seq; Type: SEQUENCE SET; Schema: test; Owner: -
--

SELECT pg_catalog.setval('test2_id_seq', 7, true);


--
-- Name: test3_ogc_fid_seq; Type: SEQUENCE SET; Schema: test; Owner: -
--

SELECT pg_catalog.setval('test3_ogc_fid_seq', 6, true);


--
-- Data for Name: test_disjoint; Type: TABLE DATA; Schema: test; Owner: -
--

INSERT INTO test_disjoint (id, geom) VALUES (1, '01010000208A150000001E124B9E2622C1752ACE0FCAB331C1');
INSERT INTO test_disjoint (id, geom) VALUES (2, '01010000208A150000A51B6224272722C1B9D43790E6B431C1');
INSERT INTO test_disjoint (id, geom) VALUES (3, '01010000208A150000574F41B5972422C18B1D71A6A9B331C1');
INSERT INTO test_disjoint (id, geom) VALUES (4, '01010000208A15000041A62FC8362322C15615748A77B231C1');
INSERT INTO test_disjoint (id, geom) VALUES (5, '01010000208A150000419FF52AAF1E22C191B838821DB231C1');
INSERT INTO test_disjoint (id, geom) VALUES (6, '01010000208A1500008DF8FE4FB41922C164B7E0EE61B231C1');
INSERT INTO test_disjoint (id, geom) VALUES (7, '01010000208A150000DBC41FBF431C22C139D19AC1A2B231C1');
INSERT INTO test_disjoint (id, geom) VALUES (8, '01010000208A150000822E4D45CF1F22C1A546380982B331C1');
INSERT INTO test_disjoint (id, geom) VALUES (9, '01010000208A1500009A3C0242AB1F22C1F25CEA2190B431C1');
INSERT INTO test_disjoint (id, geom) VALUES (10, '01010000208A150000E0017E28C42022C1E9F0A1899EB431C1');
INSERT INTO test_disjoint (id, geom) VALUES (11, '01010000208A150000C787EB7EE51D22C1F1A67BCB0EB331C1');
INSERT INTO test_disjoint (id, geom) VALUES (12, '01010000208A15000029987ACB5A2322C1ECC122461CB631C1');
INSERT INTO test_disjoint (id, geom) VALUES (13, '01010000208A15000076FFF72A6F2722C1254AD5D7C5B531C1');
INSERT INTO test_disjoint (id, geom) VALUES (14, '01010000208A15000041AD6965BE2722C18102F454BEB631C1');
INSERT INTO test_disjoint (id, geom) VALUES (15, '01010000208A15000098D02495A81C22C1BCA5B84C64B631C1');
INSERT INTO test_disjoint (id, geom) VALUES (16, '01010000208A15000016B9AFFDEF1E22C1C1DBDC185DB631C1');
INSERT INTO test_disjoint (id, geom) VALUES (17, '01010000208A15000071BB5F24671E22C1524B2D6B81B531C1');
INSERT INTO test_disjoint (id, geom) VALUES (18, '01010000208A1500002017845BD21522C1B9D43790E6B431C1');
INSERT INTO test_disjoint (id, geom) VALUES (19, '01010000208A15000089C2DA83BB1922C19EF501D78CB331C1');
INSERT INTO test_disjoint (id, geom) VALUES (20, '01010000208A1500006F4F8277641B22C17A60F2DBC2B331C1');
INSERT INTO test_disjoint (id, geom) VALUES (21, '01010000208A150000318A717C3A1722C1BF6FFF6B5AB331C1');
INSERT INTO test_disjoint (id, geom) VALUES (22, '01010000208A150000848CB6B7C21922C197A4CBA497B331C1');
INSERT INTO test_disjoint (id, geom) VALUES (23, '01010000208A15000034622CD63F1D22C12279541B48B431C1');
INSERT INTO test_disjoint (id, geom) VALUES (24, '01010000208A150000CBCB8385ED2622C139D8D45E2AB731C1');
INSERT INTO test_disjoint (id, geom) VALUES (25, '01010000208A1500007A351CF7672722C11543C56360B731C1');
INSERT INTO test_disjoint (id, geom) VALUES (26, '01010000208A150000BCC47311882822C140290B911FB731C1');
INSERT INTO test_disjoint (id, geom) VALUES (27, '01010000208A1500006A2E0C83022922C106EBE9A8F4B531C1');
INSERT INTO test_disjoint (id, geom) VALUES (28, '01010000208A150000A4B6BE14AC2822C1A1C682930AB531C1');
INSERT INTO test_disjoint (id, geom) VALUES (29, '01010000208A1500003B12A2894A2922C12494668144B431C1');
INSERT INTO test_disjoint (id, geom) VALUES (30, '01010000208A150000ED45811ABB2622C1079A1E62EEB231C1');
INSERT INTO test_disjoint (id, geom) VALUES (31, '01010000208A150000AD1BCD0F162422C1153C8BC6D8B231C1');
INSERT INTO test_disjoint (id, geom) VALUES (32, '01010000208A1500000017D8AD162222C1B3E8A46D6CB331C1');
INSERT INTO test_disjoint (id, geom) VALUES (33, '01010000208A150000399F8A3FC02122C1FEE344207EB431C1');
INSERT INTO test_disjoint (id, geom) VALUES (34, '01010000208A1500001BEFD3C9E81E22C19324162F20B531C1');
INSERT INTO test_disjoint (id, geom) VALUES (35, '01010000208A1500001C5477D9631D22C16308AC3568B531C1');
INSERT INTO test_disjoint (id, geom) VALUES (36, '01010000208A1500002C5B874DC91B22C1683ED00161B531C1');


--
-- Name: test_disjoint_id_seq; Type: SEQUENCE SET; Schema: test; Owner: -
--

SELECT pg_catalog.setval('test_disjoint_id_seq', 36, true);


--
-- Name: test1_pkey; Type: CONSTRAINT; Schema: test; Owner: -
--

ALTER TABLE ONLY test1
    ADD CONSTRAINT test1_pkey PRIMARY KEY (id);


--
-- Name: test2_pkey; Type: CONSTRAINT; Schema: test; Owner: -
--

ALTER TABLE ONLY test2
    ADD CONSTRAINT test2_pkey PRIMARY KEY (id);


--
-- Name: test_disjoint_pkey; Type: CONSTRAINT; Schema: test; Owner: -
--

ALTER TABLE ONLY test_disjoint
    ADD CONSTRAINT test_disjoint_pkey PRIMARY KEY (id);


--
-- PostgreSQL database dump complete
--