--
-- PostgreSQL database dump
--

-- Dumped from database version 9.2.4
-- Dumped by pg_dump version 9.3beta2
-- Started on 2013-07-21 11:41:42

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;

CREATE SCHEMA ch08_staging;
SET search_path = ch08_staging, pg_catalog,public;

SET default_tablespace = '';



--
-- TOC entry 352 (class 1259 OID 10909055)
-- Name: cityboundary; Type: TABLE; Schema: ch08_staging; Owner: postgres; Tablespace: 
--

CREATE TABLE cityboundary (
    gid integer NOT NULL,
    shape_leng numeric,
    geom public.geometry(MultiLineString,4326)
);


ALTER TABLE ch08_staging.cityboundary OWNER TO postgres;

--
-- TOC entry 351 (class 1259 OID 10909053)
-- Name: cityboundary_gid_seq; Type: SEQUENCE; Schema: ch08_staging; Owner: postgres
--

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


ALTER TABLE ch08_staging.cityboundary_gid_seq OWNER TO postgres;

--
-- TOC entry 3991 (class 0 OID 0)
-- Dependencies: 351
-- Name: cityboundary_gid_seq; Type: SEQUENCE OWNED BY; Schema: ch08_staging; Owner: postgres
--

ALTER SEQUENCE cityboundary_gid_seq OWNED BY cityboundary.gid;


--
-- TOC entry 3861 (class 2604 OID 10909058)
-- Name: gid; Type: DEFAULT; Schema: ch08_staging; Owner: postgres
--

ALTER TABLE ONLY cityboundary ALTER COLUMN gid SET DEFAULT nextval('cityboundary_gid_seq'::regclass);


--
-- TOC entry 3986 (class 0 OID 10909055)
-- Dependencies: 352
-- Data for Name: cityboundary; Type: TABLE DATA; Schema: ch08_staging; Owner: postgres
--

INSERT INTO cityboundary (gid, shape_leng, geom) VALUES (1, 20247.6703741, '0105000020E61000000100000001020000002E000000F42D3FBB9DD85EC0ACF56ECD87394840E2D12EA347D85EC029719C5335394840B117AC17D6D75EC0E203836A4F394840983436284BD75EC016B642ED6F3948400FEACF47F4D65EC001866F4084394840C53E442546D65EC0956B8636AA3948400ED5554148D65EC0FF09158B63394840585A12F9D4D55EC0DEB0BE815E394840BA879D6C46D55EC0A8E0FF1E5A394840A50947B64AD55EC0FC46082C31384840AC24AAECFFD45EC01BCEDEE9293848402155728A11D55EC0706732E984374840591E379EC8D45EC0331BC14E7D374840C955F7DEA2D45EC017ED8A7079374840A8662CD9A6D45EC027C60CD8D336484077387F4BA8D45EC0A11E5D8F9836484019CF6D6FACD45EC0F4C5FD33F035484018DB8F55ADD45EC092D681EDCA354840C75D9843B0D45EC03E1ABEA4543548403DEE9428B1D45EC012287E752F3548409597A6FCB2D45EC05D9B9C71E334484056750D6EF4D45EC05D69FE3DE434484032D095F9E6D45EC0A625B7B3BD344840C6664012E7D45EC0AE899C90A63448409E43DF1B15D55EC02C283A12EF334840D85112BD92D55EC0CDCB76F30F344840C842EE6D5BD65EC0FCBF0979303348407F2BE9AB27D85EC0CB835EAC2B344840E916CFB909D95EC0F6E26B23CD3448408F1E97343BD95EC02EA982D6E7344840E8F13A1D7AD95EC0A699B44A023548408B853F1D33D95EC0072D1AEB8B354840DF649B550FD95EC04AE61E78F9354840F6740558F1D85EC05D79AF5365364840E09F8EB73CD95EC01E683A19DC364840BE29AB8E3BD95EC077D02C994337484037AA271E3BD95EC04CDAE9766A3748404940962C3AD95EC0FA3D1279BF37484089F5F81138D95EC08556E082CE3748409D98AF2231D95EC04070F91F013848408CD4495928D95EC0703DFE2A413848403FBBA56237D95EC09A17B1834B3848401A27605921D95EC0862408819D38484068BB70C50ED95EC0379F7684B238484048C4E2A9FCD85EC0D56F23B1D4384840F42D3FBB9DD85EC0ACF56ECD87394840');


--
-- TOC entry 3992 (class 0 OID 0)
-- Dependencies: 351
-- Name: cityboundary_gid_seq; Type: SEQUENCE SET; Schema: ch08_staging; Owner: postgres
--

SELECT pg_catalog.setval('cityboundary_gid_seq', 1, true);


--
-- TOC entry 3864 (class 2606 OID 10909063)
-- Name: cityboundary_pkey; Type: CONSTRAINT; Schema: ch08_staging; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY cityboundary
    ADD CONSTRAINT cityboundary_pkey PRIMARY KEY (gid);


--
-- TOC entry 3862 (class 1259 OID 10909064)
-- Name: cityboundary_geom_gist; Type: INDEX; Schema: ch08_staging; Owner: postgres; Tablespace: 
--

CREATE INDEX cityboundary_geom_gist ON cityboundary USING gist (geom);


-- Completed on 2013-07-21 11:41:42

--
-- PostgreSQL database dump complete
--

