--
-- PostgreSQL database dump
--

-- Started on 2009-09-05 22:47:11

SET client_encoding = 'UTF8';
SET standard_conforming_strings = off;
SET check_function_bodies = false;
SET client_min_messages = warning;
SET escape_string_warning = off;

SET search_path = public, pg_catalog;

SET default_tablespace = '';

SET default_with_oids = false;

--
-- TOC entry 3086 (class 1259 OID 20925)
-- Dependencies: 3395 3396 3397 1524 3
-- Name: polygon1; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE polygon1 (
    gid integer NOT NULL,
    code integer,
    the_geom geometry,
    CONSTRAINT enforce_dims_the_geom CHECK ((ndims(the_geom) = 2)),
    CONSTRAINT enforce_geotype_the_geom CHECK (((geometrytype(the_geom) = 'MULTIPOLYGON'::text) OR (the_geom IS NULL))),
    CONSTRAINT enforce_srid_the_geom CHECK ((srid(the_geom) = (-1)))
);


--
-- TOC entry 3085 (class 1259 OID 20923)
-- Dependencies: 3086 3
-- Name: polygon1_gid_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE polygon1_gid_seq
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


--
-- TOC entry 3404 (class 0 OID 0)
-- Dependencies: 3085
-- Name: polygon1_gid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE polygon1_gid_seq OWNED BY polygon1.gid;


--
-- TOC entry 3405 (class 0 OID 0)
-- Dependencies: 3085
-- Name: polygon1_gid_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

SELECT pg_catalog.setval('polygon1_gid_seq', 14, true);


--
-- TOC entry 3394 (class 2604 OID 20928)
-- Dependencies: 3085 3086 3086
-- Name: gid; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE polygon1 ALTER COLUMN gid SET DEFAULT nextval('polygon1_gid_seq'::regclass);


--
-- TOC entry 3401 (class 0 OID 20925)
-- Dependencies: 3086
-- Data for Name: polygon1; Type: TABLE DATA; Schema: public; Owner: -
--

INSERT INTO polygon1 (gid, code, the_geom) VALUES (2, 2, '[payload removed: 204 characters]');
INSERT INTO polygon1 (gid, code, the_geom) VALUES (6, 3, '[payload removed: 236 characters]');
INSERT INTO polygon1 (gid, code, the_geom) VALUES (7, 3, '[payload removed: 236 characters]');
INSERT INTO polygon1 (gid, code, the_geom) VALUES (8, 1, '[payload removed: 204 characters]');
INSERT INTO polygon1 (gid, code, the_geom) VALUES (9, 2, '[payload removed: 204 characters]');
INSERT INTO polygon1 (gid, code, the_geom) VALUES (10, 2, '[payload removed: 300 characters]');
INSERT INTO polygon1 (gid, code, the_geom) VALUES (11, 2, '[payload removed: 268 characters]');
INSERT INTO polygon1 (gid, code, the_geom) VALUES (12, 3, '[payload removed: 236 characters]');
INSERT INTO polygon1 (gid, code, the_geom) VALUES (13, 3, '[payload removed: 236 characters]');
INSERT INTO polygon1 (gid, code, the_geom) VALUES (14, 3, '[payload removed: 236 characters]');
INSERT INTO polygon1 (gid, code, the_geom) VALUES (1, 1, '[payload removed: 204 characters]');
INSERT INTO polygon1 (gid, code, the_geom) VALUES (3, 2, '[payload removed: 300 characters]');
INSERT INTO polygon1 (gid, code, the_geom) VALUES (4, 2, '[payload removed: 268 characters]');
INSERT INTO polygon1 (gid, code, the_geom) VALUES (5, 3, '[payload removed: 236 characters]');


--
-- TOC entry 3400 (class 2606 OID 20930)
-- Dependencies: 3086 3086
-- Name: polygon1_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY polygon1
    ADD CONSTRAINT polygon1_pkey PRIMARY KEY (gid);


--
-- TOC entry 3398 (class 1259 OID 20969)
-- Dependencies: 2672 3086
-- Name: polygon1_gist_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX polygon1_gist_idx ON polygon1 USING gist (the_geom);

ALTER TABLE polygon1 CLUSTER ON polygon1_gist_idx;


-- Completed on 2009-09-05 22:47:13

--
-- PostgreSQL database dump complete
--

