gistfile1.sql

--
-- Name: categories; Type: TABLE; Schema: public; Owner: kalugamap; Tablespace: 
--

CREATE TABLE categories (
    id integer NOT NULL,
    ancestry character varying(255),
    "table" character varying(255),
    types character varying(255)[],
    name character varying(255) NOT NULL,
    description text,
    icon character varying(255),
    keywords character varying(255),
    default_object_name character varying(255),
    created_at timestamp without time zone NOT NULL,
    updated_at timestamp without time zone NOT NULL
);


ALTER TABLE public.categories OWNER TO kalugamap;

--
-- Name: categories_id_seq; Type: SEQUENCE; Schema: public; Owner: kalugamap
--

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


ALTER TABLE public.categories_id_seq OWNER TO kalugamap;

--
-- Name: categories_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: kalugamap
--

ALTER SEQUENCE categories_id_seq OWNED BY categories.id;


--
-- Name: geography_columns; Type: VIEW; Schema: public; Owner: postgres
--

CREATE VIEW geography_columns AS
    SELECT current_database() AS f_table_catalog, n.nspname AS f_table_schema, c.relname AS f_table_name, a.attname AS f_geography_column, geography_typmod_dims(a.atttypmod) AS coord_dimension, geography_typmod_srid(a.atttypmod) AS srid, geography_typmod_type(a.atttypmod) AS type FROM pg_class c, pg_attribute a, pg_type t, pg_namespace n WHERE ((((((t.typname = 'geography'::name) AND (a.attisdropped = false)) AND (a.atttypid = t.oid)) AND (a.attrelid = c.oid)) AND (c.relnamespace = n.oid)) AND (NOT pg_is_other_temp_schema(c.relnamespace)));


ALTER TABLE public.geography_columns OWNER TO postgres;

SET default_with_oids = true;

--
-- Name: geometry_columns; Type: TABLE; Schema: public; Owner: kalugamap; Tablespace: 
--

CREATE TABLE geometry_columns (
    f_table_catalog character varying(256) NOT NULL,
    f_table_schema character varying(256) NOT NULL,
    f_table_name character varying(256) NOT NULL,
    f_geometry_column character varying(256) NOT NULL,
    coord_dimension integer NOT NULL,
    srid integer NOT NULL,
    type character varying(30) NOT NULL
);


ALTER TABLE public.geometry_columns OWNER TO kalugamap;

SET default_with_oids = false;

--
-- Name: osm_barriers; Type: TABLE; Schema: public; Owner: kalugamap; Tablespace: 
--

CREATE TABLE osm_barriers (
    tags hstore,
    type character varying(100) NOT NULL,
    name character varying(255),
    osm_type character varying(10),
    id bigint NOT NULL,
    geometry geography(MultiLineString,4326)
);


ALTER TABLE public.osm_barriers OWNER TO kalugamap;

--
-- Name: osm_buildings; Type: TABLE; Schema: public; Owner: kalugamap; Tablespace: 
--

CREATE TABLE osm_buildings (
    tags hstore,
    type character varying(100) NOT NULL,
    postcode character varying(100),
    city character varying(255),
    street character varying(255),
    housenumber character varying(255),
    name character varying(255),
    osm_type character varying(10),
    id bigint NOT NULL,
    geometry geography(MultiPolygon,4326)
);


ALTER TABLE public.osm_buildings OWNER TO kalugamap;

--
-- Name: osm_objects; Type: TABLE; Schema: public; Owner: kalugamap; Tablespace: 
--

CREATE TABLE osm_objects (
    tags hstore,
    type character varying(100) NOT NULL,
    postcode character varying(100),
    city character varying(255),
    street character varying(255),
    housenumber character varying(255),
    types character varying(100)[],
    name character varying(255),
    osm_type character varying(10),
    id bigint NOT NULL,
    geometry geography(MultiPolygon,4326),
    center geography(Point,4326)
);


ALTER TABLE public.osm_objects OWNER TO kalugamap;

--
-- Name: osm_places; Type: TABLE; Schema: public; Owner: kalugamap; Tablespace: 
--

CREATE TABLE osm_places (
    tags hstore,
    type character varying(100) NOT NULL,
    name character varying(255),
    osm_type character varying(10),
    id bigint NOT NULL,
    geometry geography(MultiPolygon,4326),
    center geography(Point,4326)
);


ALTER TABLE public.osm_places OWNER TO kalugamap;

--
-- Name: osm_rails; Type: TABLE; Schema: public; Owner: kalugamap; Tablespace: 
--

CREATE TABLE osm_rails (
    tags hstore,
    type character varying(100) NOT NULL,
    name character varying(255),
    osm_type character varying(10),
    id bigint NOT NULL,
    geometry geography(LineString,4326)
);


ALTER TABLE public.osm_rails OWNER TO kalugamap;

--
-- Name: osm_roads; Type: TABLE; Schema: public; Owner: kalugamap; Tablespace: 
--

CREATE TABLE osm_roads (
    tags hstore,
    type character varying(100) NOT NULL,
    place_id bigint,
    ref character varying(255),
    name character varying(255),
    osm_type character varying(10),
    id bigint NOT NULL,
    geometry geography(LineString,4326)
);


ALTER TABLE public.osm_roads OWNER TO kalugamap;

--
-- Name: osm_squares; Type: TABLE; Schema: public; Owner: kalugamap; Tablespace: 
--

CREATE TABLE osm_squares (
    tags hstore,
    type character varying(100) NOT NULL,
    name character varying(255),
    osm_type character varying(10),
    id bigint NOT NULL,
    geometry geography(Polygon,4326)
);


ALTER TABLE public.osm_squares OWNER TO kalugamap;

--
-- Name: osm_streets; Type: TABLE; Schema: public; Owner: kalugamap; Tablespace: 
--

CREATE TABLE osm_streets (
    tags hstore,
    type character varying(100) NOT NULL,
    place_id bigint,
    city character varying(255),
    name character varying(255),
    osm_type character varying(10),
    id bigint NOT NULL,
    geometry geography(MultiLineString,4326),
    center geography(Point,4326)
);


ALTER TABLE public.osm_streets OWNER TO kalugamap;

--
-- Name: osm_territories; Type: TABLE; Schema: public; Owner: kalugamap; Tablespace: 
--

CREATE TABLE osm_territories (
    tags hstore,
    type character varying(100) NOT NULL,
    name character varying(255),
    osm_type character varying(10),
    id bigint NOT NULL,
    geometry geography(MultiPolygon,4326)
);


ALTER TABLE public.osm_territories OWNER TO kalugamap;

--
-- Name: osm_waterareas; Type: TABLE; Schema: public; Owner: kalugamap; Tablespace: 
--

CREATE TABLE osm_waterareas (
    tags hstore,
    type character varying(100) NOT NULL,
    name character varying(255),
    osm_type character varying(10),
    id bigint NOT NULL,
    geometry geography(MultiPolygon,4326)
);


ALTER TABLE public.osm_waterareas OWNER TO kalugamap;

--
-- Name: osm_waterways; Type: TABLE; Schema: public; Owner: kalugamap; Tablespace: 
--

CREATE TABLE osm_waterways (
    tags hstore,
    type character varying(100) NOT NULL,
    name character varying(255),
    osm_type character varying(10),
    id bigint NOT NULL,
    geometry geography(LineString,4326)
);


ALTER TABLE public.osm_waterways OWNER TO kalugamap;

--
-- Name: pages; Type: TABLE; Schema: public; Owner: kalugamap; Tablespace: 
--

CREATE TABLE pages (
    id integer NOT NULL,
    slug character varying(255),
    title character varying(255),
    body text,
    created_at timestamp without time zone NOT NULL,
    updated_at timestamp without time zone NOT NULL
);


ALTER TABLE public.pages OWNER TO kalugamap;

--
-- Name: pages_id_seq; Type: SEQUENCE; Schema: public; Owner: kalugamap
--

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


ALTER TABLE public.pages_id_seq OWNER TO kalugamap;

--
-- Name: pages_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: kalugamap
--

ALTER SEQUENCE pages_id_seq OWNED BY pages.id;


--
-- Name: photos; Type: TABLE; Schema: public; Owner: kalugamap; Tablespace: 
--

CREATE TABLE photos (
    id integer NOT NULL,
    service character varying(255),
    url character varying(255),
    title character varying(255),
    image_url character varying(255),
    thumb_url character varying(255),
    author_name character varying(255),
    author_url character varying(255),
    width integer,
    height integer,
    location geography(Point,4326) NOT NULL,
    created_at timestamp without time zone NOT NULL,
    updated_at timestamp without time zone NOT NULL
);


ALTER TABLE public.photos OWNER TO kalugamap;

--
-- Name: photos_id_seq; Type: SEQUENCE; Schema: public; Owner: kalugamap
--

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


ALTER TABLE public.photos_id_seq OWNER TO kalugamap;

--
-- Name: photos_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: kalugamap
--

ALTER SEQUENCE photos_id_seq OWNED BY photos.id;


--
-- Name: raw_osm_line; Type: TABLE; Schema: public; Owner: kalugamap; Tablespace: 
--

CREATE TABLE raw_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,
    oneway text,
    operator text,
    population text,
    power text,
    power_source text,
    place 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
);


ALTER TABLE public.raw_osm_line OWNER TO kalugamap;

--
-- Name: raw_osm_point; Type: TABLE; Schema: public; Owner: kalugamap; Tablespace: 
--

CREATE TABLE raw_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,
    oneway text,
    operator text,
    poi text,
    population text,
    power text,
    power_source text,
    place 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
);


ALTER TABLE public.raw_osm_point OWNER TO kalugamap;

--
-- Name: raw_osm_polygon; Type: TABLE; Schema: public; Owner: kalugamap; Tablespace: 
--

CREATE TABLE raw_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,
    oneway text,
    operator text,
    population text,
    power text,
    power_source text,
    place 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
);


ALTER TABLE public.raw_osm_polygon OWNER TO kalugamap;

--
-- Name: raw_osm_roads; Type: TABLE; Schema: public; Owner: kalugamap; Tablespace: 
--

CREATE TABLE raw_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,
    oneway text,
    operator text,
    population text,
    power text,
    power_source text,
    place 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
);


ALTER TABLE public.raw_osm_roads OWNER TO kalugamap;

--
-- Name: schema_migrations; Type: TABLE; Schema: public; Owner: kalugamap; Tablespace: 
--

CREATE TABLE schema_migrations (
    version character varying(255) NOT NULL
);


ALTER TABLE public.schema_migrations OWNER TO kalugamap;

--
-- Name: spatial_ref_sys; Type: TABLE; Schema: public; Owner: kalugamap; Tablespace: 
--

CREATE TABLE spatial_ref_sys (
    srid integer NOT NULL,
    auth_name character varying(256),
    auth_srid integer,
    srtext character varying(2048),
    proj4text character varying(2048)
);


ALTER TABLE public.spatial_ref_sys OWNER TO kalugamap;

--
-- Name: id; Type: DEFAULT; Schema: public; Owner: kalugamap
--

ALTER TABLE ONLY categories ALTER COLUMN id SET DEFAULT nextval('categories_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: kalugamap
--

ALTER TABLE ONLY pages ALTER COLUMN id SET DEFAULT nextval('pages_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: kalugamap
--

ALTER TABLE ONLY photos ALTER COLUMN id SET DEFAULT nextval('photos_id_seq'::regclass);


--
-- Name: categories_pkey; Type: CONSTRAINT; Schema: public; Owner: kalugamap; Tablespace: 
--

ALTER TABLE ONLY categories
    ADD CONSTRAINT categories_pkey PRIMARY KEY (id);


--
-- Name: geometry_columns_pk; Type: CONSTRAINT; Schema: public; Owner: kalugamap; Tablespace: 
--

ALTER TABLE ONLY geometry_columns
    ADD CONSTRAINT geometry_columns_pk PRIMARY KEY (f_table_catalog, f_table_schema, f_table_name, f_geometry_column);


--
-- Name: new_osm_barriers_pkey; Type: CONSTRAINT; Schema: public; Owner: kalugamap; Tablespace: 
--

ALTER TABLE ONLY osm_barriers
    ADD CONSTRAINT new_osm_barriers_pkey PRIMARY KEY (id);


--
-- Name: new_osm_buildings_pkey; Type: CONSTRAINT; Schema: public; Owner: kalugamap; Tablespace: 
--

ALTER TABLE ONLY osm_buildings
    ADD CONSTRAINT new_osm_buildings_pkey PRIMARY KEY (id);


--
-- Name: new_osm_objects_pkey; Type: CONSTRAINT; Schema: public; Owner: kalugamap; Tablespace: 
--

ALTER TABLE ONLY osm_objects
    ADD CONSTRAINT new_osm_objects_pkey PRIMARY KEY (id);


--
-- Name: new_osm_places_pkey; Type: CONSTRAINT; Schema: public; Owner: kalugamap; Tablespace: 
--

ALTER TABLE ONLY osm_places
    ADD CONSTRAINT new_osm_places_pkey PRIMARY KEY (id);


--
-- Name: new_osm_rails_pkey; Type: CONSTRAINT; Schema: public; Owner: kalugamap; Tablespace: 
--

ALTER TABLE ONLY osm_rails
    ADD CONSTRAINT new_osm_rails_pkey PRIMARY KEY (id);


--
-- Name: new_osm_roads_pkey; Type: CONSTRAINT; Schema: public; Owner: kalugamap; Tablespace: 
--

ALTER TABLE ONLY osm_roads
    ADD CONSTRAINT new_osm_roads_pkey PRIMARY KEY (id);


--
-- Name: new_osm_squares_pkey; Type: CONSTRAINT; Schema: public; Owner: kalugamap; Tablespace: 
--

ALTER TABLE ONLY osm_squares
    ADD CONSTRAINT new_osm_squares_pkey PRIMARY KEY (id);


--
-- Name: new_osm_streets_pkey; Type: CONSTRAINT; Schema: public; Owner: kalugamap; Tablespace: 
--

ALTER TABLE ONLY osm_streets
    ADD CONSTRAINT new_osm_streets_pkey PRIMARY KEY (id);


--
-- Name: new_osm_territories_pkey; Type: CONSTRAINT; Schema: public; Owner: kalugamap; Tablespace: 
--

ALTER TABLE ONLY osm_territories
    ADD CONSTRAINT new_osm_territories_pkey PRIMARY KEY (id);


--
-- Name: new_osm_waterareas_pkey; Type: CONSTRAINT; Schema: public; Owner: kalugamap; Tablespace: 
--

ALTER TABLE ONLY osm_waterareas
    ADD CONSTRAINT new_osm_waterareas_pkey PRIMARY KEY (id);


--
-- Name: new_osm_waterways_pkey; Type: CONSTRAINT; Schema: public; Owner: kalugamap; Tablespace: 
--

ALTER TABLE ONLY osm_waterways
    ADD CONSTRAINT new_osm_waterways_pkey PRIMARY KEY (id);


--
-- Name: pages_pkey; Type: CONSTRAINT; Schema: public; Owner: kalugamap; Tablespace: 
--

ALTER TABLE ONLY pages
    ADD CONSTRAINT pages_pkey PRIMARY KEY (id);


--
-- Name: photos_pkey; Type: CONSTRAINT; Schema: public; Owner: kalugamap; Tablespace: 
--

ALTER TABLE ONLY photos
    ADD CONSTRAINT photos_pkey PRIMARY KEY (id);


--
-- Name: spatial_ref_sys_pkey; Type: CONSTRAINT; Schema: public; Owner: kalugamap; Tablespace: 
--

ALTER TABLE ONLY spatial_ref_sys
    ADD CONSTRAINT spatial_ref_sys_pkey PRIMARY KEY (srid);


--
-- Name: categories_types_idx; Type: INDEX; Schema: public; Owner: kalugamap; Tablespace: 
--

CREATE INDEX categories_types_idx ON categories USING gin (types);


--
-- Name: index_categories_on_ancestry; Type: INDEX; Schema: public; Owner: kalugamap; Tablespace: 
--

CREATE INDEX index_categories_on_ancestry ON categories USING btree (ancestry);


--
-- Name: index_categories_on_name; Type: INDEX; Schema: public; Owner: kalugamap; Tablespace: 
--

CREATE UNIQUE INDEX index_categories_on_name ON categories USING btree (name);


--
-- Name: index_pages_on_slug; Type: INDEX; Schema: public; Owner: kalugamap; Tablespace: 
--

CREATE UNIQUE INDEX index_pages_on_slug ON pages USING btree (slug);


--
-- Name: index_photos_on_location; Type: INDEX; Schema: public; Owner: kalugamap; Tablespace: 
--

CREATE INDEX index_photos_on_location ON photos USING gist (location);


--
-- Name: index_photos_on_url; Type: INDEX; Schema: public; Owner: kalugamap; Tablespace: 
--

CREATE UNIQUE INDEX index_photos_on_url ON photos USING btree (url);


--
-- Name: osm_barriers_geometry_index; Type: INDEX; Schema: public; Owner: kalugamap; Tablespace: 
--

CREATE INDEX osm_barriers_geometry_index ON osm_barriers USING gist (geometry);


--
-- Name: osm_barriers_type_index; Type: INDEX; Schema: public; Owner: kalugamap; Tablespace: 
--

CREATE INDEX osm_barriers_type_index ON osm_barriers USING btree (type);


--
-- Name: osm_buildings_geometry_index; Type: INDEX; Schema: public; Owner: kalugamap; Tablespace: 
--

CREATE INDEX osm_buildings_geometry_index ON osm_buildings USING gist (geometry);


--
-- Name: osm_buildings_type_index; Type: INDEX; Schema: public; Owner: kalugamap; Tablespace: 
--

CREATE INDEX osm_buildings_type_index ON osm_buildings USING btree (type);


--
-- Name: osm_objects_geometry_index; Type: INDEX; Schema: public; Owner: kalugamap; Tablespace: 
--

CREATE INDEX osm_objects_geometry_index ON osm_objects USING gist (geometry);


--
-- Name: osm_objects_type_index; Type: INDEX; Schema: public; Owner: kalugamap; Tablespace: 
--

CREATE INDEX osm_objects_type_index ON osm_objects USING btree (type);


--
-- Name: osm_objects_types_index; Type: INDEX; Schema: public; Owner: kalugamap; Tablespace: 
--

CREATE INDEX osm_objects_types_index ON osm_objects USING gin (types);


--
-- Name: osm_places_geometry_index; Type: INDEX; Schema: public; Owner: kalugamap; Tablespace: 
--

CREATE INDEX osm_places_geometry_index ON osm_places USING gist (geometry);


--
-- Name: osm_places_type_index; Type: INDEX; Schema: public; Owner: kalugamap; Tablespace: 
--

CREATE INDEX osm_places_type_index ON osm_places USING btree (type);


--
-- Name: osm_rails_geometry_index; Type: INDEX; Schema: public; Owner: kalugamap; Tablespace: 
--

CREATE INDEX osm_rails_geometry_index ON osm_rails USING gist (geometry);


--
-- Name: osm_rails_type_index; Type: INDEX; Schema: public; Owner: kalugamap; Tablespace: 
--

CREATE INDEX osm_rails_type_index ON osm_rails USING btree (type);


--
-- Name: osm_roads_geometry_index; Type: INDEX; Schema: public; Owner: kalugamap; Tablespace: 
--

CREATE INDEX osm_roads_geometry_index ON osm_roads USING gist (geometry);


--
-- Name: osm_roads_type_index; Type: INDEX; Schema: public; Owner: kalugamap; Tablespace: 
--

CREATE INDEX osm_roads_type_index ON osm_roads USING btree (type);


--
-- Name: osm_squares_geometry_index; Type: INDEX; Schema: public; Owner: kalugamap; Tablespace: 
--

CREATE INDEX osm_squares_geometry_index ON osm_squares USING gist (geometry);


--
-- Name: osm_squares_type_index; Type: INDEX; Schema: public; Owner: kalugamap; Tablespace: 
--

CREATE INDEX osm_squares_type_index ON osm_squares USING btree (type);


--
-- Name: osm_streets_geometry_index; Type: INDEX; Schema: public; Owner: kalugamap; Tablespace: 
--

CREATE INDEX osm_streets_geometry_index ON osm_streets USING gist (geometry);


--
-- Name: osm_streets_type_index; Type: INDEX; Schema: public; Owner: kalugamap; Tablespace: 
--

CREATE INDEX osm_streets_type_index ON osm_streets USING btree (type);


--
-- Name: osm_territories_geometry_index; Type: INDEX; Schema: public; Owner: kalugamap; Tablespace: 
--

CREATE INDEX osm_territories_geometry_index ON osm_territories USING gist (geometry);


--
-- Name: osm_territories_type_index; Type: INDEX; Schema: public; Owner: kalugamap; Tablespace: 
--

CREATE INDEX osm_territories_type_index ON osm_territories USING btree (type);


--
-- Name: osm_waterareas_geometry_index; Type: INDEX; Schema: public; Owner: kalugamap; Tablespace: 
--

CREATE INDEX osm_waterareas_geometry_index ON osm_waterareas USING gist (geometry);


--
-- Name: osm_waterareas_type_index; Type: INDEX; Schema: public; Owner: kalugamap; Tablespace: 
--

CREATE INDEX osm_waterareas_type_index ON osm_waterareas USING btree (type);


--
-- Name: osm_waterways_geometry_index; Type: INDEX; Schema: public; Owner: kalugamap; Tablespace: 
--

CREATE INDEX osm_waterways_geometry_index ON osm_waterways USING gist (geometry);


--
-- Name: osm_waterways_type_index; Type: INDEX; Schema: public; Owner: kalugamap; Tablespace: 
--

CREATE INDEX osm_waterways_type_index ON osm_waterways USING btree (type);


--
-- Name: raw_osm_line_index; Type: INDEX; Schema: public; Owner: kalugamap; Tablespace: 
--

CREATE INDEX raw_osm_line_index ON raw_osm_line USING gist (way);


--
-- Name: raw_osm_point_index; Type: INDEX; Schema: public; Owner: kalugamap; Tablespace: 
--

CREATE INDEX raw_osm_point_index ON raw_osm_point USING gist (way);


--
-- Name: raw_osm_polygon_index; Type: INDEX; Schema: public; Owner: kalugamap; Tablespace: 
--

CREATE INDEX raw_osm_polygon_index ON raw_osm_polygon USING gist (way);


--
-- Name: raw_osm_roads_index; Type: INDEX; Schema: public; Owner: kalugamap; Tablespace: 
--

CREATE INDEX raw_osm_roads_index ON raw_osm_roads USING gist (way);


--
-- Name: unique_schema_migrations; Type: INDEX; Schema: public; Owner: kalugamap; Tablespace: 
--

CREATE UNIQUE INDEX unique_schema_migrations ON schema_migrations USING btree (version);