--
-- PostgreSQL database dump
--

-- Dumped from database version 9.3.5
-- Dumped by pg_dump version 9.4beta1
-- Started on 2014-09-07 01:53:43

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;

--
-- TOC entry 7 (class 2615 OID 9036982)
-- Name: po; Type: SCHEMA; Schema: -; Owner: postgres
--

CREATE SCHEMA po;


ALTER SCHEMA po OWNER TO postgres;


SET default_tablespace = '';

SET default_with_oids = false;

--
-- TOC entry 190 (class 1259 OID 9040077)
-- Name: chicago_dem; Type: TABLE; Schema: po; Owner: postgres; Tablespace: 
--

CREATE TABLE chicago_dem (
    rid integer NOT NULL,
    rast raster,
    filename text
);


ALTER TABLE chicago_dem OWNER TO postgres;

--
-- TOC entry 189 (class 1259 OID 9040075)
-- Name: chicago_dem_rid_seq; Type: SEQUENCE; Schema: po; Owner: postgres
--

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


ALTER TABLE chicago_dem_rid_seq OWNER TO postgres;

--
-- TOC entry 3507 (class 0 OID 0)
-- Dependencies: 189
-- Name: chicago_dem_rid_seq; Type: SEQUENCE OWNED BY; Schema: po; Owner: postgres
--

ALTER SEQUENCE chicago_dem_rid_seq OWNED BY chicago_dem.rid;


--
-- TOC entry 188 (class 1259 OID 9023085)
-- Name: chicago_pics; Type: TABLE; Schema: po; Owner: postgres; Tablespace: 
--

CREATE TABLE chicago_pics (
    rid integer NOT NULL,
    rast raster,
    filename text
);


ALTER TABLE chicago_pics OWNER TO postgres;

--
-- TOC entry 187 (class 1259 OID 9023083)
-- Name: chicago_pics_rid_seq; Type: SEQUENCE; Schema: po; Owner: postgres
--

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


ALTER TABLE chicago_pics_rid_seq OWNER TO postgres;

--
-- TOC entry 3508 (class 0 OID 0)
-- Dependencies: 187
-- Name: chicago_pics_rid_seq; Type: SEQUENCE OWNED BY; Schema: po; Owner: postgres
--

ALTER SEQUENCE chicago_pics_rid_seq OWNED BY chicago_pics.rid;


--
-- TOC entry 192 (class 1259 OID 9049669)
-- Name: planet_osm_line; Type: TABLE; Schema: po; Owner: postgres; Tablespace: 
--

CREATE TABLE planet_osm_line (
    osm_id bigint,
    access text,
    "addr:housename" text,
    "addr:housenumber" text,
    "addr:interpolation" text,
    admin_level text,
    aerialway text,
    aeroway text,
    amenity text,
    area text,
    barrier text,
    bicycle text,
    brand text,
    bridge text,
    boundary text,
    building text,
    construction text,
    covered text,
    culvert text,
    cutting text,
    denomination text,
    disused text,
    embankment text,
    foot text,
    "generator:source" text,
    harbour text,
    highway text,
    historic text,
    horse text,
    intermittent text,
    junction text,
    landuse text,
    layer text,
    leisure text,
    lock text,
    man_made text,
    military text,
    motorcar text,
    name text,
    "natural" text,
    office text,
    oneway text,
    operator text,
    place text,
    population text,
    power text,
    power_source text,
    public_transport text,
    railway text,
    ref text,
    religion text,
    route text,
    service text,
    shop text,
    sport text,
    surface text,
    toll text,
    tourism text,
    "tower:type" text,
    tracktype text,
    tunnel text,
    water text,
    waterway text,
    wetland text,
    width text,
    wood text,
    z_order integer,
    way_area real,
    tags hstore,
    way geometry(LineString,900913)
);


ALTER TABLE planet_osm_line OWNER TO postgres;

--
-- TOC entry 191 (class 1259 OID 9049658)
-- Name: planet_osm_point; Type: TABLE; Schema: po; Owner: postgres; Tablespace: 
--

CREATE TABLE planet_osm_point (
    osm_id bigint,
    access text,
    "addr:housename" text,
    "addr:housenumber" text,
    "addr:interpolation" text,
    admin_level text,
    aerialway text,
    aeroway text,
    amenity text,
    area text,
    barrier text,
    bicycle text,
    brand text,
    bridge text,
    boundary text,
    building text,
    capital text,
    construction text,
    covered text,
    culvert text,
    cutting text,
    denomination text,
    disused text,
    ele text,
    embankment text,
    foot text,
    "generator:source" text,
    harbour text,
    highway text,
    historic text,
    horse text,
    intermittent text,
    junction text,
    landuse text,
    layer text,
    leisure text,
    lock text,
    man_made text,
    military text,
    motorcar text,
    name text,
    "natural" text,
    office text,
    oneway text,
    operator text,
    place text,
    poi text,
    population text,
    power text,
    power_source text,
    public_transport text,
    railway text,
    ref text,
    religion text,
    route text,
    service text,
    shop text,
    sport text,
    surface text,
    toll text,
    tourism text,
    "tower:type" text,
    tunnel text,
    water text,
    waterway text,
    wetland text,
    width text,
    wood text,
    z_order integer,
    tags hstore,
    way geometry(Point,900913),
    geog geography(Point,4326)
);


ALTER TABLE planet_osm_point OWNER TO postgres;

--
-- TOC entry 194 (class 1259 OID 9049690)
-- Name: planet_osm_polygon; Type: TABLE; Schema: po; Owner: postgres; Tablespace: 
--

CREATE TABLE planet_osm_polygon (
    osm_id bigint,
    access text,
    "addr:housename" text,
    "addr:housenumber" text,
    "addr:interpolation" text,
    admin_level text,
    aerialway text,
    aeroway text,
    amenity text,
    area text,
    barrier text,
    bicycle text,
    brand text,
    bridge text,
    boundary text,
    building text,
    construction text,
    covered text,
    culvert text,
    cutting text,
    denomination text,
    disused text,
    embankment text,
    foot text,
    "generator:source" text,
    harbour text,
    highway text,
    historic text,
    horse text,
    intermittent text,
    junction text,
    landuse text,
    layer text,
    leisure text,
    lock text,
    man_made text,
    military text,
    motorcar text,
    name text,
    "natural" text,
    office text,
    oneway text,
    operator text,
    place text,
    population text,
    power text,
    power_source text,
    public_transport text,
    railway text,
    ref text,
    religion text,
    route text,
    service text,
    shop text,
    sport text,
    surface text,
    toll text,
    tourism text,
    "tower:type" text,
    tracktype text,
    tunnel text,
    water text,
    waterway text,
    wetland text,
    width text,
    wood text,
    z_order integer,
    way_area real,
    tags hstore,
    way geometry(Geometry,900913)
);


ALTER TABLE planet_osm_polygon OWNER TO postgres;

--
-- TOC entry 193 (class 1259 OID 9049680)
-- Name: planet_osm_roads; Type: TABLE; Schema: po; Owner: postgres; Tablespace: 
--

CREATE TABLE planet_osm_roads (
    osm_id bigint,
    access text,
    "addr:housename" text,
    "addr:housenumber" text,
    "addr:interpolation" text,
    admin_level text,
    aerialway text,
    aeroway text,
    amenity text,
    area text,
    barrier text,
    bicycle text,
    brand text,
    bridge text,
    boundary text,
    building text,
    construction text,
    covered text,
    culvert text,
    cutting text,
    denomination text,
    disused text,
    embankment text,
    foot text,
    "generator:source" text,
    harbour text,
    highway text,
    historic text,
    horse text,
    intermittent text,
    junction text,
    landuse text,
    layer text,
    leisure text,
    lock text,
    man_made text,
    military text,
    motorcar text,
    name text,
    "natural" text,
    office text,
    oneway text,
    operator text,
    place text,
    population text,
    power text,
    power_source text,
    public_transport text,
    railway text,
    ref text,
    religion text,
    route text,
    service text,
    shop text,
    sport text,
    surface text,
    toll text,
    tourism text,
    "tower:type" text,
    tracktype text,
    tunnel text,
    water text,
    waterway text,
    wetland text,
    width text,
    wood text,
    z_order integer,
    way_area real,
    tags hstore,
    way geometry(LineString,900913),
    id integer NOT NULL,
    topo topology.topogeometry,
    CONSTRAINT check_topogeom_topo CHECK (((((topo).topology_id = 1) AND ((topo).layer_id = 1)) AND ((topo).type = 2)))
);


ALTER TABLE planet_osm_roads OWNER TO postgres;

--
-- TOC entry 201 (class 1259 OID 9072343)
-- Name: planet_osm_roads_id_seq; Type: SEQUENCE; Schema: po; Owner: postgres
--

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


ALTER TABLE planet_osm_roads_id_seq OWNER TO postgres;

--
-- TOC entry 3513 (class 0 OID 0)
-- Dependencies: 201
-- Name: planet_osm_roads_id_seq; Type: SEQUENCE OWNED BY; Schema: po; Owner: postgres
--

ALTER SEQUENCE planet_osm_roads_id_seq OWNED BY planet_osm_roads.id;


--
-- TOC entry 3350 (class 2604 OID 9040080)
-- Name: rid; Type: DEFAULT; Schema: po; Owner: postgres
--

ALTER TABLE ONLY chicago_dem ALTER COLUMN rid SET DEFAULT nextval('chicago_dem_rid_seq'::regclass);


--
-- TOC entry 3349 (class 2604 OID 9023088)
-- Name: rid; Type: DEFAULT; Schema: po; Owner: postgres
--

ALTER TABLE ONLY chicago_pics ALTER COLUMN rid SET DEFAULT nextval('chicago_pics_rid_seq'::regclass);


--
-- TOC entry 3362 (class 2604 OID 9072345)
-- Name: id; Type: DEFAULT; Schema: po; Owner: postgres
--

ALTER TABLE ONLY planet_osm_roads ALTER COLUMN id SET DEFAULT nextval('planet_osm_roads_id_seq'::regclass);


--
-- TOC entry 3509 (class 0 OID 0)
-- Dependencies: 192
-- Name: planet_osm_line; Type: ACL; Schema: po; Owner: postgres
--

REVOKE ALL ON TABLE planet_osm_line FROM PUBLIC;
REVOKE ALL ON TABLE planet_osm_line FROM postgres;
GRANT ALL ON TABLE planet_osm_line TO postgres;
GRANT SELECT ON TABLE planet_osm_line TO PUBLIC;


--
-- TOC entry 3510 (class 0 OID 0)
-- Dependencies: 191
-- Name: planet_osm_point; Type: ACL; Schema: po; Owner: postgres
--

REVOKE ALL ON TABLE planet_osm_point FROM PUBLIC;
REVOKE ALL ON TABLE planet_osm_point FROM postgres;
GRANT ALL ON TABLE planet_osm_point TO postgres;
GRANT SELECT ON TABLE planet_osm_point TO PUBLIC;


--
-- TOC entry 3511 (class 0 OID 0)
-- Dependencies: 194
-- Name: planet_osm_polygon; Type: ACL; Schema: po; Owner: postgres
--

REVOKE ALL ON TABLE planet_osm_polygon FROM PUBLIC;
REVOKE ALL ON TABLE planet_osm_polygon FROM postgres;
GRANT ALL ON TABLE planet_osm_polygon TO postgres;
GRANT SELECT ON TABLE planet_osm_polygon TO PUBLIC;


--
-- TOC entry 3512 (class 0 OID 0)
-- Dependencies: 193
-- Name: planet_osm_roads; Type: ACL; Schema: po; Owner: postgres
--

REVOKE ALL ON TABLE planet_osm_roads FROM PUBLIC;
REVOKE ALL ON TABLE planet_osm_roads FROM postgres;
GRANT ALL ON TABLE planet_osm_roads TO postgres;
GRANT SELECT ON TABLE planet_osm_roads TO PUBLIC;


-- Completed on 2014-09-07 01:53:43

--
-- PostgreSQL database dump complete
--

