--
-- PostgreSQL database dump
--

-- Dumped from database version 9.4.8
-- Dumped by pg_dump version 10.10 (Ubuntu 10.10-0ubuntu0.18.04.1)


SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET xmloption = content;
SET client_min_messages = warning;
SET row_security = off;

SET default_tablespace = '';

SET default_with_oids = false;

--
-- Name: age_types; Type: TABLE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE TABLE saintlouisdev.age_types (
    id integer NOT NULL,
    age_condition character varying(50) NOT NULL,
    description text
);


ALTER TABLE saintlouisdev.age_types OWNER TO saintlouisdev;

--
-- Name: age_types_id_seq; Type: SEQUENCE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE SEQUENCE saintlouisdev.age_types_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE saintlouisdev.age_types_id_seq OWNER TO saintlouisdev;

--
-- Name: age_types_id_seq; Type: SEQUENCE OWNED BY; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER SEQUENCE saintlouisdev.age_types_id_seq OWNED BY saintlouisdev.age_types.id;


--
-- Name: auth_group; Type: TABLE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE TABLE saintlouisdev.auth_group (
    id integer NOT NULL,
    name character varying(80) NOT NULL
);


ALTER TABLE saintlouisdev.auth_group OWNER TO saintlouisdev;

--
-- Name: auth_group_id_seq; Type: SEQUENCE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE SEQUENCE saintlouisdev.auth_group_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE saintlouisdev.auth_group_id_seq OWNER TO saintlouisdev;

--
-- Name: auth_group_id_seq; Type: SEQUENCE OWNED BY; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER SEQUENCE saintlouisdev.auth_group_id_seq OWNED BY saintlouisdev.auth_group.id;


--
-- Name: auth_group_permissions; Type: TABLE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE TABLE saintlouisdev.auth_group_permissions (
    id integer NOT NULL,
    group_id integer NOT NULL,
    permission_id integer NOT NULL
);


ALTER TABLE saintlouisdev.auth_group_permissions OWNER TO saintlouisdev;

--
-- Name: auth_group_permissions_id_seq; Type: SEQUENCE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE SEQUENCE saintlouisdev.auth_group_permissions_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE saintlouisdev.auth_group_permissions_id_seq OWNER TO saintlouisdev;

--
-- Name: auth_group_permissions_id_seq; Type: SEQUENCE OWNED BY; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER SEQUENCE saintlouisdev.auth_group_permissions_id_seq OWNED BY saintlouisdev.auth_group_permissions.id;


--
-- Name: auth_message; Type: TABLE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE TABLE saintlouisdev.auth_message (
    id integer NOT NULL,
    user_id integer NOT NULL,
    message text NOT NULL
);


ALTER TABLE saintlouisdev.auth_message OWNER TO saintlouisdev;

--
-- Name: auth_message_id_seq; Type: SEQUENCE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE SEQUENCE saintlouisdev.auth_message_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE saintlouisdev.auth_message_id_seq OWNER TO saintlouisdev;

--
-- Name: auth_message_id_seq; Type: SEQUENCE OWNED BY; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER SEQUENCE saintlouisdev.auth_message_id_seq OWNED BY saintlouisdev.auth_message.id;


--
-- Name: auth_permission; Type: TABLE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE TABLE saintlouisdev.auth_permission (
    id integer NOT NULL,
    name character varying(50) NOT NULL,
    content_type_id integer NOT NULL,
    codename character varying(100) NOT NULL
);


ALTER TABLE saintlouisdev.auth_permission OWNER TO saintlouisdev;

--
-- Name: auth_permission_id_seq; Type: SEQUENCE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE SEQUENCE saintlouisdev.auth_permission_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE saintlouisdev.auth_permission_id_seq OWNER TO saintlouisdev;

--
-- Name: auth_permission_id_seq; Type: SEQUENCE OWNED BY; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER SEQUENCE saintlouisdev.auth_permission_id_seq OWNED BY saintlouisdev.auth_permission.id;


--
-- Name: auth_user; Type: TABLE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE TABLE saintlouisdev.auth_user (
    id integer NOT NULL,
    username character varying(30) NOT NULL,
    first_name character varying(30) NOT NULL,
    last_name character varying(30) NOT NULL,
    email character varying(75) NOT NULL,
    password character varying(128) NOT NULL,
    is_staff boolean NOT NULL,
    is_active boolean NOT NULL,
    is_superuser boolean NOT NULL,
    last_login timestamp with time zone NOT NULL,
    date_joined timestamp with time zone NOT NULL
);


ALTER TABLE saintlouisdev.auth_user OWNER TO saintlouisdev;

--
-- Name: auth_user_groups; Type: TABLE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE TABLE saintlouisdev.auth_user_groups (
    id integer NOT NULL,
    user_id integer NOT NULL,
    group_id integer NOT NULL
);


ALTER TABLE saintlouisdev.auth_user_groups OWNER TO saintlouisdev;

--
-- Name: auth_user_groups_id_seq; Type: SEQUENCE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE SEQUENCE saintlouisdev.auth_user_groups_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE saintlouisdev.auth_user_groups_id_seq OWNER TO saintlouisdev;

--
-- Name: auth_user_groups_id_seq; Type: SEQUENCE OWNED BY; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER SEQUENCE saintlouisdev.auth_user_groups_id_seq OWNED BY saintlouisdev.auth_user_groups.id;


--
-- Name: auth_user_id_seq; Type: SEQUENCE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE SEQUENCE saintlouisdev.auth_user_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE saintlouisdev.auth_user_id_seq OWNER TO saintlouisdev;

--
-- Name: auth_user_id_seq; Type: SEQUENCE OWNED BY; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER SEQUENCE saintlouisdev.auth_user_id_seq OWNED BY saintlouisdev.auth_user.id;


--
-- Name: auth_user_user_permissions; Type: TABLE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE TABLE saintlouisdev.auth_user_user_permissions (
    id integer NOT NULL,
    user_id integer NOT NULL,
    permission_id integer NOT NULL
);


ALTER TABLE saintlouisdev.auth_user_user_permissions OWNER TO saintlouisdev;

--
-- Name: auth_user_user_permissions_id_seq; Type: SEQUENCE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE SEQUENCE saintlouisdev.auth_user_user_permissions_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE saintlouisdev.auth_user_user_permissions_id_seq OWNER TO saintlouisdev;

--
-- Name: auth_user_user_permissions_id_seq; Type: SEQUENCE OWNED BY; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER SEQUENCE saintlouisdev.auth_user_user_permissions_id_seq OWNED BY saintlouisdev.auth_user_user_permissions.id;


--
-- Name: blocks; Type: TABLE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE TABLE saintlouisdev.blocks (
    temporalobject_ptr_id integer NOT NULL
);


ALTER TABLE saintlouisdev.blocks OWNER TO saintlouisdev;

--
-- Name: building_forms; Type: TABLE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE TABLE saintlouisdev.building_forms (
    id integer NOT NULL,
    author_name character varying(50) NOT NULL,
    block_number character varying(10) NOT NULL,
    data_source character varying(50) NOT NULL,
    start_date date NOT NULL,
    start_valid boolean NOT NULL,
    end_date date NOT NULL,
    end_valid boolean NOT NULL,
    low_address integer NOT NULL,
    high_address integer NOT NULL,
    streetname character varying(50) NOT NULL,
    stories integer NOT NULL,
    height double precision NOT NULL,
    depth double precision NOT NULL,
    front_setback double precision NOT NULL,
    right_setback double precision NOT NULL,
    left_setback double precision NOT NULL,
    building_use character varying(50) NOT NULL,
    building_type character varying(50) NOT NULL,
    building_name character varying(50) NOT NULL,
    building_url character varying(200) NOT NULL,
    building_style character varying(50) NOT NULL,
    texture_type character varying(50) NOT NULL,
    model_file character varying(50) NOT NULL,
    bays integer NOT NULL,
    repetition integer NOT NULL,
    pattern character varying(31) NOT NULL,
    corners integer NOT NULL,
    roof_type integer NOT NULL,
    architect character varying(50) NOT NULL,
    comments text NOT NULL,
    description text NOT NULL,
    building_id integer NOT NULL,
    created_at date NOT NULL
);


ALTER TABLE saintlouisdev.building_forms OWNER TO saintlouisdev;

--
-- Name: building_forms_id_seq; Type: SEQUENCE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE SEQUENCE saintlouisdev.building_forms_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE saintlouisdev.building_forms_id_seq OWNER TO saintlouisdev;

--
-- Name: building_forms_id_seq; Type: SEQUENCE OWNED BY; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER SEQUENCE saintlouisdev.building_forms_id_seq OWNED BY saintlouisdev.building_forms.id;


--
-- Name: building_parts; Type: TABLE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE TABLE saintlouisdev.building_parts (
    temporalobject_ptr_id integer NOT NULL,
    building_id integer NOT NULL,
    object_name character varying(50),
    points text,
    scale character varying(50),
    rotation character varying(50),
    translation character varying(50),
    mirror character varying(50),
    nested integer,
    source character varying(20)
);


ALTER TABLE saintlouisdev.building_parts OWNER TO saintlouisdev;

--
-- Name: building_styles; Type: TABLE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE TABLE saintlouisdev.building_styles (
    id integer NOT NULL,
    building_style character varying(50) NOT NULL,
    start_year integer NOT NULL,
    end_year integer NOT NULL,
    description text
);


ALTER TABLE saintlouisdev.building_styles OWNER TO saintlouisdev;

--
-- Name: building_styles_id_seq; Type: SEQUENCE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE SEQUENCE saintlouisdev.building_styles_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE saintlouisdev.building_styles_id_seq OWNER TO saintlouisdev;

--
-- Name: building_styles_id_seq; Type: SEQUENCE OWNED BY; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER SEQUENCE saintlouisdev.building_styles_id_seq OWNED BY saintlouisdev.building_styles.id;


--
-- Name: building_types; Type: TABLE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE TABLE saintlouisdev.building_types (
    id integer NOT NULL,
    building_type character varying(50) NOT NULL,
    start_year integer NOT NULL,
    end_year integer NOT NULL,
    roof_type integer NOT NULL,
    bay_size double precision NOT NULL,
    structural_bay double precision NOT NULL,
    elevation double precision NOT NULL,
    floor_height double precision NOT NULL,
    first_height double precision NOT NULL,
    top_height double precision NOT NULL,
    first_ratio double precision NOT NULL,
    top_ratio double precision NOT NULL,
    mid_setback double precision NOT NULL,
    top_setback double precision NOT NULL,
    description text,
    building_style integer
);


ALTER TABLE saintlouisdev.building_types OWNER TO saintlouisdev;

--
-- Name: building_types_id_seq; Type: SEQUENCE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE SEQUENCE saintlouisdev.building_types_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE saintlouisdev.building_types_id_seq OWNER TO saintlouisdev;

--
-- Name: building_types_id_seq; Type: SEQUENCE OWNED BY; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER SEQUENCE saintlouisdev.building_types_id_seq OWNED BY saintlouisdev.building_types.id;


--
-- Name: building_uses; Type: TABLE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE TABLE saintlouisdev.building_uses (
    id integer NOT NULL,
    building_use character varying(50) NOT NULL,
    description text
);


ALTER TABLE saintlouisdev.building_uses OWNER TO saintlouisdev;

--
-- Name: building_uses_id_seq; Type: SEQUENCE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE SEQUENCE saintlouisdev.building_uses_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE saintlouisdev.building_uses_id_seq OWNER TO saintlouisdev;

--
-- Name: building_uses_id_seq; Type: SEQUENCE OWNED BY; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER SEQUENCE saintlouisdev.building_uses_id_seq OWNED BY saintlouisdev.building_uses.id;


--
-- Name: buildings; Type: TABLE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE TABLE saintlouisdev.buildings (
    temporalobject_ptr_id integer NOT NULL
);


ALTER TABLE saintlouisdev.buildings OWNER TO saintlouisdev;

--
-- Name: buildings_geo_front; Type: TABLE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE TABLE saintlouisdev.buildings_geo_front (
    id integer NOT NULL,
    building_id integer NOT NULL,
    geofront_id integer
);


ALTER TABLE saintlouisdev.buildings_geo_front OWNER TO saintlouisdev;

--
-- Name: buildings_geo_front_id_seq; Type: SEQUENCE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE SEQUENCE saintlouisdev.buildings_geo_front_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE saintlouisdev.buildings_geo_front_id_seq OWNER TO saintlouisdev;

--
-- Name: buildings_geo_front_id_seq; Type: SEQUENCE OWNED BY; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER SEQUENCE saintlouisdev.buildings_geo_front_id_seq OWNED BY saintlouisdev.buildings_geo_front.id;


--
-- Name: cesium_entities; Type: TABLE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE TABLE saintlouisdev.cesium_entities (
    temporalobject_ptr_id integer NOT NULL,
    entity_id integer NOT NULL,
    entity_type integer NOT NULL,
    entity_reference character varying(50) NOT NULL,
    height double precision NOT NULL,
    entity_name character varying(50),
    text character varying(600),
    info_box_visibility boolean,
    default_date date
);


ALTER TABLE saintlouisdev.cesium_entities OWNER TO saintlouisdev;

--
-- Name: cesium_entity_entity_id_seq; Type: SEQUENCE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE SEQUENCE saintlouisdev.cesium_entity_entity_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE saintlouisdev.cesium_entity_entity_id_seq OWNER TO saintlouisdev;

--
-- Name: cesium_entity_entity_id_seq; Type: SEQUENCE OWNED BY; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER SEQUENCE saintlouisdev.cesium_entity_entity_id_seq OWNED BY saintlouisdev.cesium_entities.entity_id;


--
-- Name: cesiumlatlong; Type: TABLE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE TABLE saintlouisdev.cesiumlatlong (
    building_id integer NOT NULL,
    ge_latitude double precision,
    ge_longitude double precision
);


ALTER TABLE saintlouisdev.cesiumlatlong OWNER TO saintlouisdev;

--
-- Name: city_defaults; Type: TABLE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE TABLE saintlouisdev.city_defaults (
    id integer NOT NULL,
    name character varying(50) NOT NULL,
    start_date date NOT NULL,
    end_date date NOT NULL,
    google_origin character varying(50) NOT NULL,
    srid integer,
    database_name text NOT NULL,
    db_connect text NOT NULL,
    default_parcel_width double precision NOT NULL,
    default_street_width double precision NOT NULL,
    default_walk_width double precision NOT NULL,
    block_tolerance double precision NOT NULL,
    pixel_tolerance integer NOT NULL,
    slope_tolerance double precision NOT NULL,
    point_extents integer NOT NULL,
    address_origin character varying(50) NOT NULL,
    max_depth double precision NOT NULL,
    max_front_set_back double precision NOT NULL,
    max_side_set_back double precision NOT NULL,
    max_height double precision NOT NULL,
    max_stories integer NOT NULL,
    image_server character varying(50) NOT NULL,
    path_city_gen character varying(50) NOT NULL,
    path_map_digitizer character varying(50) NOT NULL,
    path_texture_grabber character varying(50) NOT NULL,
    path_local character varying(50) NOT NULL,
    path_home character varying(50) NOT NULL,
    path_server character varying(50) NOT NULL,
    path_web character varying(50) NOT NULL,
    url_base_web text NOT NULL,
    url_base_texture text NOT NULL,
    url_base_inline text NOT NULL,
    texture_roof character varying(50) NOT NULL,
    texture_top character varying(50) NOT NULL,
    texture_mid character varying(50) NOT NULL,
    texture_base character varying(50) NOT NULL,
    "texture_wallDefault" character varying(50) NOT NULL,
    texture_foundation character varying(50) NOT NULL
);


ALTER TABLE saintlouisdev.city_defaults OWNER TO saintlouisdev;

--
-- Name: city_defaults_id_seq; Type: SEQUENCE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE SEQUENCE saintlouisdev.city_defaults_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE saintlouisdev.city_defaults_id_seq OWNER TO saintlouisdev;

--
-- Name: city_defaults_id_seq; Type: SEQUENCE OWNED BY; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER SEQUENCE saintlouisdev.city_defaults_id_seq OWNED BY saintlouisdev.city_defaults.id;


--
-- Name: city_directories; Type: TABLE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE TABLE saintlouisdev.city_directories (
    id integer NOT NULL,
    lastname character varying(50) NOT NULL,
    firstname character varying(50),
    mid_initial character varying(50),
    widow character varying(50),
    occupation character varying(100),
    business character varying(100),
    addr_num character varying(50),
    street_pre character varying(50),
    street_name character varying(50),
    street_suf character varying(50),
    location_memo character varying(50),
    clean character varying(5),
    image_file character varying(50),
    directory_year integer NOT NULL,
    description text NOT NULL
);


ALTER TABLE saintlouisdev.city_directories OWNER TO saintlouisdev;

--
-- Name: city_directories_id_seq; Type: SEQUENCE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE SEQUENCE saintlouisdev.city_directories_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE saintlouisdev.city_directories_id_seq OWNER TO saintlouisdev;

--
-- Name: city_directories_id_seq; Type: SEQUENCE OWNED BY; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER SEQUENCE saintlouisdev.city_directories_id_seq OWNED BY saintlouisdev.city_directories.id;


--
-- Name: city_networks; Type: TABLE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE TABLE saintlouisdev.city_networks (
    temporalobject_ptr_id integer NOT NULL,
    geo_streetsegment_id integer NOT NULL,
    sustain_index double precision,
    name character varying(50) NOT NULL
);


ALTER TABLE saintlouisdev.city_networks OWNER TO saintlouisdev;

--
-- Name: django_admin_log; Type: TABLE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE TABLE saintlouisdev.django_admin_log (
    id integer NOT NULL,
    action_time timestamp with time zone NOT NULL,
    user_id integer NOT NULL,
    content_type_id integer,
    object_id text,
    object_repr character varying(200) NOT NULL,
    action_flag smallint NOT NULL,
    change_message text NOT NULL,
    CONSTRAINT django_admin_log_action_flag_check CHECK ((action_flag >= 0))
);


ALTER TABLE saintlouisdev.django_admin_log OWNER TO saintlouisdev;

--
-- Name: django_admin_log_id_seq; Type: SEQUENCE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE SEQUENCE saintlouisdev.django_admin_log_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE saintlouisdev.django_admin_log_id_seq OWNER TO saintlouisdev;

--
-- Name: django_admin_log_id_seq; Type: SEQUENCE OWNED BY; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER SEQUENCE saintlouisdev.django_admin_log_id_seq OWNED BY saintlouisdev.django_admin_log.id;


--
-- Name: django_content_type; Type: TABLE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE TABLE saintlouisdev.django_content_type (
    id integer NOT NULL,
    name character varying(100) NOT NULL,
    app_label character varying(100) NOT NULL,
    model character varying(100) NOT NULL
);


ALTER TABLE saintlouisdev.django_content_type OWNER TO saintlouisdev;

--
-- Name: django_content_type_id_seq; Type: SEQUENCE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE SEQUENCE saintlouisdev.django_content_type_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE saintlouisdev.django_content_type_id_seq OWNER TO saintlouisdev;

--
-- Name: django_content_type_id_seq; Type: SEQUENCE OWNED BY; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER SEQUENCE saintlouisdev.django_content_type_id_seq OWNED BY saintlouisdev.django_content_type.id;


--
-- Name: django_session; Type: TABLE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE TABLE saintlouisdev.django_session (
    session_key character varying(40) NOT NULL,
    session_data text NOT NULL,
    expire_date timestamp with time zone NOT NULL
);


ALTER TABLE saintlouisdev.django_session OWNER TO saintlouisdev;

--
-- Name: django_site; Type: TABLE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE TABLE saintlouisdev.django_site (
    id integer NOT NULL,
    domain character varying(100) NOT NULL,
    name character varying(50) NOT NULL
);


ALTER TABLE saintlouisdev.django_site OWNER TO saintlouisdev;

--
-- Name: django_site_id_seq; Type: SEQUENCE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE SEQUENCE saintlouisdev.django_site_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE saintlouisdev.django_site_id_seq OWNER TO saintlouisdev;

--
-- Name: django_site_id_seq; Type: SEQUENCE OWNED BY; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER SEQUENCE saintlouisdev.django_site_id_seq OWNED BY saintlouisdev.django_site.id;


--
-- Name: dvbTest; Type: TABLE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE TABLE saintlouisdev."dvbTest" (
);


ALTER TABLE saintlouisdev."dvbTest" OWNER TO saintlouisdev;

--
-- Name: dynamic_types; Type: TABLE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE TABLE saintlouisdev.dynamic_types (
    id integer NOT NULL,
    dynamic_type character varying(50) NOT NULL,
    description text NOT NULL
);


ALTER TABLE saintlouisdev.dynamic_types OWNER TO saintlouisdev;

--
-- Name: dynamic_types_id_seq; Type: SEQUENCE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE SEQUENCE saintlouisdev.dynamic_types_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE saintlouisdev.dynamic_types_id_seq OWNER TO saintlouisdev;

--
-- Name: dynamic_types_id_seq; Type: SEQUENCE OWNED BY; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER SEQUENCE saintlouisdev.dynamic_types_id_seq OWNED BY saintlouisdev.dynamic_types.id;


--
-- Name: dynamics; Type: TABLE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE TABLE saintlouisdev.dynamics (
    temporalobject_ptr_id integer NOT NULL
);


ALTER TABLE saintlouisdev.dynamics OWNER TO saintlouisdev;

--
-- Name: external_id; Type: TABLE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE TABLE saintlouisdev.external_id (
    id integer NOT NULL,
    temporal_object_id integer NOT NULL,
    external_id character varying(50) NOT NULL
);


ALTER TABLE saintlouisdev.external_id OWNER TO saintlouisdev;

--
-- Name: external_id_id_seq; Type: SEQUENCE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE SEQUENCE saintlouisdev.external_id_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE saintlouisdev.external_id_id_seq OWNER TO saintlouisdev;

--
-- Name: external_id_id_seq; Type: SEQUENCE OWNED BY; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER SEQUENCE saintlouisdev.external_id_id_seq OWNED BY saintlouisdev.external_id.id;


--
-- Name: footprint_types; Type: TABLE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE TABLE saintlouisdev.footprint_types (
    id integer NOT NULL,
    footprint_type character varying(31) NOT NULL,
    description text
);


ALTER TABLE saintlouisdev.footprint_types OWNER TO saintlouisdev;

--
-- Name: footprint_types_id_seq; Type: SEQUENCE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE SEQUENCE saintlouisdev.footprint_types_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE saintlouisdev.footprint_types_id_seq OWNER TO saintlouisdev;

--
-- Name: footprint_types_id_seq; Type: SEQUENCE OWNED BY; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER SEQUENCE saintlouisdev.footprint_types_id_seq OWNED BY saintlouisdev.footprint_types.id;


--
-- Name: fronts; Type: TABLE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE TABLE saintlouisdev.fronts (
    temporalobject_ptr_id integer NOT NULL
);


ALTER TABLE saintlouisdev.fronts OWNER TO saintlouisdev;

--
-- Name: geo_blocks; Type: TABLE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE TABLE saintlouisdev.geo_blocks (
    temporalobject_ptr_id integer NOT NULL,
    block_id integer NOT NULL,
    points text,
    fixedstatus character varying(50),
    tolerance double precision,
    swcorner_id integer,
    source character varying(20),
    texture character varying(50)
);


ALTER TABLE saintlouisdev.geo_blocks OWNER TO saintlouisdev;

--
-- Name: geo_blocks_geo_front; Type: TABLE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE TABLE saintlouisdev.geo_blocks_geo_front (
    id integer NOT NULL,
    geoblock_id integer NOT NULL,
    geofront_id integer NOT NULL
);


ALTER TABLE saintlouisdev.geo_blocks_geo_front OWNER TO saintlouisdev;

--
-- Name: geo_blocks_geo_front_id_seq; Type: SEQUENCE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE SEQUENCE saintlouisdev.geo_blocks_geo_front_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE saintlouisdev.geo_blocks_geo_front_id_seq OWNER TO saintlouisdev;

--
-- Name: geo_blocks_geo_front_id_seq; Type: SEQUENCE OWNED BY; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER SEQUENCE saintlouisdev.geo_blocks_geo_front_id_seq OWNED BY saintlouisdev.geo_blocks_geo_front.id;


--
-- Name: geo_dynamics; Type: TABLE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE TABLE saintlouisdev.geo_dynamics (
    temporalobject_ptr_id integer NOT NULL,
    dynamic_id integer NOT NULL,
    objectname character varying(50) NOT NULL,
    scale character varying(50) NOT NULL,
    rotation character varying(50) NOT NULL,
    mirror character varying(50) NOT NULL,
    points text NOT NULL
);


ALTER TABLE saintlouisdev.geo_dynamics OWNER TO saintlouisdev;

--
-- Name: geo_footprints; Type: TABLE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE TABLE saintlouisdev.geo_footprints (
    temporalobject_ptr_id integer NOT NULL,
    building_id integer NOT NULL,
    stories integer,
    height double precision,
    first_floor_height double precision,
    top_floor_height double precision,
    pattern character varying(20),
    repetition integer,
    bay_width double precision,
    corners integer,
    points text NOT NULL,
    roof_type integer,
    footprint_type integer,
    texture_type integer,
    elevation double precision,
    source character varying(20),
    front_texture_id integer,
    wall_texture_id integer,
    foundation_texture_id integer,
    roof_texture_id integer
);


ALTER TABLE saintlouisdev.geo_footprints OWNER TO saintlouisdev;

--
-- Name: geo_fronts; Type: TABLE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE TABLE saintlouisdev.geo_fronts (
    temporalobject_ptr_id integer NOT NULL,
    front_id integer NOT NULL,
    points text NOT NULL,
    source character varying(20)
);


ALTER TABLE saintlouisdev.geo_fronts OWNER TO saintlouisdev;

--
-- Name: geo_fronts_address; Type: TABLE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE TABLE saintlouisdev.geo_fronts_address (
    id integer NOT NULL,
    geofront_id integer NOT NULL,
    vcaddress_id integer NOT NULL
);


ALTER TABLE saintlouisdev.geo_fronts_address OWNER TO saintlouisdev;

--
-- Name: geo_fronts_address_id_seq; Type: SEQUENCE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE SEQUENCE saintlouisdev.geo_fronts_address_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE saintlouisdev.geo_fronts_address_id_seq OWNER TO saintlouisdev;

--
-- Name: geo_fronts_address_id_seq; Type: SEQUENCE OWNED BY; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER SEQUENCE saintlouisdev.geo_fronts_address_id_seq OWNED BY saintlouisdev.geo_fronts_address.id;


--
-- Name: geo_intersections; Type: TABLE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE TABLE saintlouisdev.geo_intersections (
    temporalobject_ptr_id integer NOT NULL,
    points text NOT NULL,
    source character varying(20)
);


ALTER TABLE saintlouisdev.geo_intersections OWNER TO saintlouisdev;

--
-- Name: geo_meshes; Type: TABLE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE TABLE saintlouisdev.geo_meshes (
    temporalobject_ptr_id integer NOT NULL,
    building_id integer NOT NULL,
    filename character varying(50) NOT NULL,
    ge_filename character varying(100),
    ge_latitude double precision,
    ge_longitude double precision,
    ge_heading double precision,
    original_file character varying(255),
    source character varying(50),
    texture_prefix character varying(50)
);


ALTER TABLE saintlouisdev.geo_meshes OWNER TO saintlouisdev;

--
-- Name: geo_protos; Type: TABLE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE TABLE saintlouisdev.geo_protos (
    temporalobject_ptr_id integer NOT NULL,
    building_id integer NOT NULL,
    object_name character varying(50),
    points text,
    scale character varying(50),
    rotation character varying(50),
    translation character varying(50),
    mirror character varying(50),
    nested integer,
    source character varying(20)
);


ALTER TABLE saintlouisdev.geo_protos OWNER TO saintlouisdev;

--
-- Name: geo_shapes; Type: TABLE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE TABLE saintlouisdev.geo_shapes (
    temporalobject_ptr_id integer NOT NULL,
    shape_id integer NOT NULL,
    source character varying(20) NOT NULL,
    elevation double precision,
    points text NOT NULL
);


ALTER TABLE saintlouisdev.geo_shapes OWNER TO saintlouisdev;

--
-- Name: geo_sides; Type: TABLE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE TABLE saintlouisdev.geo_sides (
    id integer NOT NULL,
    geo_block_id integer NOT NULL,
    vc_streetname_id integer,
    increasing boolean,
    low_address integer,
    high_address integer,
    default_parcel_width double precision,
    side_index integer,
    address_increment integer,
    source character varying(20),
    assigned_high_address integer
);


ALTER TABLE saintlouisdev.geo_sides OWNER TO saintlouisdev;

--
-- Name: geo_sides_id_seq; Type: SEQUENCE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE SEQUENCE saintlouisdev.geo_sides_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE saintlouisdev.geo_sides_id_seq OWNER TO saintlouisdev;

--
-- Name: geo_sides_id_seq; Type: SEQUENCE OWNED BY; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER SEQUENCE saintlouisdev.geo_sides_id_seq OWNED BY saintlouisdev.geo_sides.id;


--
-- Name: geo_statics; Type: TABLE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE TABLE saintlouisdev.geo_statics (
    temporalobject_ptr_id integer NOT NULL,
    static_id integer NOT NULL,
    objectname character varying(50) NOT NULL,
    scale character varying(31) NOT NULL,
    rotation character varying(31) NOT NULL,
    mirror character varying(31),
    points text NOT NULL
);


ALTER TABLE saintlouisdev.geo_statics OWNER TO saintlouisdev;

--
-- Name: geo_streets; Type: TABLE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE TABLE saintlouisdev.geo_streets (
    temporalobject_ptr_id integer NOT NULL,
    width double precision,
    vc_streetname_id integer,
    points text,
    source character varying(20)
);


ALTER TABLE saintlouisdev.geo_streets OWNER TO saintlouisdev;

--
-- Name: geo_streetsegments; Type: TABLE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE TABLE saintlouisdev.geo_streetsegments (
    temporalobject_ptr_id integer NOT NULL,
    streetsegment_id integer NOT NULL,
    points text NOT NULL,
    vc_streetname_id integer,
    width double precision,
    source character varying(20)
);


ALTER TABLE saintlouisdev.geo_streetsegments OWNER TO saintlouisdev;

--
-- Name: gps_photos; Type: TABLE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE TABLE saintlouisdev.gps_photos (
    id integer NOT NULL,
    image_id integer NOT NULL,
    date_time character varying(45),
    date_time_original character varying(45),
    date_time_digitized character varying(45),
    y_resolution character varying(45),
    x_resolution character varying(45),
    pixel_x_dimension character varying(45),
    pixel_y_dimension character varying(45),
    focal_length character varying(45),
    focal_length_in_35mm_film character varying(45),
    subject_distance_range character varying(45),
    gps_map_datum character varying(45),
    gps_date_stamp character varying(45),
    gps_time_stamp character varying(45),
    gps_latitude_ref character varying(45),
    gps_latitude character varying(45),
    gps_longitude_ref character varying(45),
    gps_longitude character varying(45),
    gps_altitude character varying(45),
    gps_img_direction_ref character varying(45),
    gps_img_direction character varying(45),
    gps_satellites character varying(45),
    scene_capture_type character varying(45),
    exposure_mode character varying(45),
    exposure_time character varying(45),
    contrast character varying(45),
    sensing_method character varying(45),
    color_space character varying(45),
    orientation character varying(45),
    metering_mode character varying(45),
    resolution_unit character varying(45),
    white_balance character varying(45),
    f_number character varying(45),
    saturation character varying(45),
    light_source character varying(45),
    digital_zoom_ratio character varying(45),
    subsec_time character varying(45),
    exposure_program character varying(45),
    ycb_cr_positioning character varying(45),
    sharpness character varying(45),
    flash character varying(45),
    make character varying(45),
    model character varying(45),
    software character varying(45),
    subsec_time_orginal character varying(45),
    exposure_bias_value character varying(45),
    subsec_time_digitized character varying(45),
    max_aperture_value character varying(45),
    iso_speed_ratings character varying(45),
    custom_rendered character varying(45),
    compressed_bits_per_pixel character varying(45),
    gain_control character varying(45),
    dd_longitude double precision,
    dd_latitude double precision,
    filename character varying(45)
);


ALTER TABLE saintlouisdev.gps_photos OWNER TO saintlouisdev;

--
-- Name: gps_photos_id_seq; Type: SEQUENCE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE SEQUENCE saintlouisdev.gps_photos_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE saintlouisdev.gps_photos_id_seq OWNER TO saintlouisdev;

--
-- Name: gps_photos_id_seq; Type: SEQUENCE OWNED BY; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER SEQUENCE saintlouisdev.gps_photos_id_seq OWNED BY saintlouisdev.gps_photos.id;


--
-- Name: ground_overlays; Type: TABLE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE TABLE saintlouisdev.ground_overlays (
    temporalobject_ptr_id integer NOT NULL,
    name character varying(50) NOT NULL,
    points text NOT NULL,
    "order" integer NOT NULL,
    texture character varying(50),
    color character varying(8),
    corner1_latitude double precision,
    corner1_longitude double precision,
    corner2_latitude double precision,
    corner2_longitude double precision,
    corner3_latitude double precision,
    corner3_longitude double precision,
    corner4_latitude double precision,
    corner4_longitude double precision,
    repetitions integer,
    source character varying(20)
);


ALTER TABLE saintlouisdev.ground_overlays OWNER TO saintlouisdev;

--
-- Name: temporal_objects; Type: TABLE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE TABLE saintlouisdev.temporal_objects (
    id integer NOT NULL,
    block_number character varying(10),
    object_type_id integer,
    description text,
    vet_flag boolean,
    start_date_id integer,
    end_date_id integer
);


ALTER TABLE saintlouisdev.temporal_objects OWNER TO saintlouisdev;

--
-- Name: vc_dates; Type: TABLE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE TABLE saintlouisdev.vc_dates (
    id integer NOT NULL,
    value date NOT NULL,
    is_valid boolean,
    flag character varying(10)
);


ALTER TABLE saintlouisdev.vc_dates OWNER TO saintlouisdev;

--
-- Name: vc_addresses; Type: TABLE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE TABLE saintlouisdev.vc_addresses (
    id integer NOT NULL,
    vc_streetname_id integer NOT NULL,
    number_prefix character varying(10),
    address_number integer NOT NULL,
    number_suffix character varying(10),
    number_range character varying(16),
    separator character varying(10),
    zip_code character varying(10),
    blocknumber character varying(10)
);


ALTER TABLE saintlouisdev.vc_addresses OWNER TO saintlouisdev;

--
-- Name: vc_streetnames; Type: TABLE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE TABLE saintlouisdev.vc_streetnames (
    id integer NOT NULL,
    premodifier character varying(10),
    predirectional character varying(10),
    pretype character varying(10),
    streetname character varying(50) NOT NULL,
    posttype character varying(10),
    postdirectional character varying(10),
    postmodifier character varying(10),
    startyear integer,
    endyear integer,
    recur integer,
    ge_streetname text,
    aflag character varying(10)
);


ALTER TABLE saintlouisdev.vc_streetnames OWNER TO saintlouisdev;

--
-- Name: images; Type: TABLE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE TABLE saintlouisdev.images (
    id integer NOT NULL,
    indentifier_mdi character varying(50) NOT NULL,
    title text NOT NULL,
    title_alternative text,
    creator text,
    contributor character varying(50),
    coverage text,
    description text,
    subject text,
    date date,
    type character varying(50),
    relation text,
    source text,
    rights text,
    publisher character varying(50),
    language character varying(50),
    access_url text,
    thumbnail_url text,
    access_file_size character varying(50)
);


ALTER TABLE saintlouisdev.images OWNER TO saintlouisdev;

--
-- Name: images_id_seq1; Type: SEQUENCE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE SEQUENCE saintlouisdev.images_id_seq1
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE saintlouisdev.images_id_seq1 OWNER TO saintlouisdev;

--
-- Name: images_id_seq1; Type: SEQUENCE OWNED BY; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER SEQUENCE saintlouisdev.images_id_seq1 OWNED BY saintlouisdev.images.id;


--
-- Name: images_temporal_object; Type: TABLE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE TABLE saintlouisdev.images_temporal_object (
    id integer NOT NULL,
    image_id integer NOT NULL,
    temporalobject_id integer NOT NULL
);


ALTER TABLE saintlouisdev.images_temporal_object OWNER TO saintlouisdev;

--
-- Name: images_temporal_object_id_seq; Type: SEQUENCE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE SEQUENCE saintlouisdev.images_temporal_object_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE saintlouisdev.images_temporal_object_id_seq OWNER TO saintlouisdev;

--
-- Name: images_temporal_object_id_seq; Type: SEQUENCE OWNED BY; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER SEQUENCE saintlouisdev.images_temporal_object_id_seq OWNED BY saintlouisdev.images_temporal_object.id;


--
-- Name: land_uses; Type: TABLE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE TABLE saintlouisdev.land_uses (
    id integer NOT NULL,
    land_use character varying(50) NOT NULL,
    description text
);


ALTER TABLE saintlouisdev.land_uses OWNER TO saintlouisdev;

--
-- Name: land_uses_id_seq; Type: SEQUENCE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE SEQUENCE saintlouisdev.land_uses_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE saintlouisdev.land_uses_id_seq OWNER TO saintlouisdev;

--
-- Name: land_uses_id_seq; Type: SEQUENCE OWNED BY; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER SEQUENCE saintlouisdev.land_uses_id_seq OWNED BY saintlouisdev.land_uses.id;


--
-- Name: map_types; Type: TABLE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE TABLE saintlouisdev.map_types (
    id integer NOT NULL,
    map_type character varying(50) NOT NULL,
    description text
);


ALTER TABLE saintlouisdev.map_types OWNER TO saintlouisdev;

--
-- Name: map_types_id_seq; Type: SEQUENCE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE SEQUENCE saintlouisdev.map_types_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE saintlouisdev.map_types_id_seq OWNER TO saintlouisdev;

--
-- Name: map_types_id_seq; Type: SEQUENCE OWNED BY; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER SEQUENCE saintlouisdev.map_types_id_seq OWNED BY saintlouisdev.map_types.id;


--
-- Name: materials; Type: TABLE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE TABLE saintlouisdev.materials (
    id integer NOT NULL,
    material character varying(50) NOT NULL,
    material_type character varying(50),
    color character varying(50),
    description text
);


ALTER TABLE saintlouisdev.materials OWNER TO saintlouisdev;

--
-- Name: materials_id_seq; Type: SEQUENCE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE SEQUENCE saintlouisdev.materials_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE saintlouisdev.materials_id_seq OWNER TO saintlouisdev;

--
-- Name: materials_id_seq; Type: SEQUENCE OWNED BY; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER SEQUENCE saintlouisdev.materials_id_seq OWNED BY saintlouisdev.materials.id;


--
-- Name: object_relations; Type: TABLE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE TABLE saintlouisdev.object_relations (
    id integer NOT NULL,
    relation_id integer NOT NULL,
    from_object_id integer NOT NULL,
    to_object_id integer NOT NULL
);


ALTER TABLE saintlouisdev.object_relations OWNER TO saintlouisdev;

--
-- Name: object_relations_id_seq; Type: SEQUENCE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE SEQUENCE saintlouisdev.object_relations_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE saintlouisdev.object_relations_id_seq OWNER TO saintlouisdev;

--
-- Name: object_relations_id_seq; Type: SEQUENCE OWNED BY; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER SEQUENCE saintlouisdev.object_relations_id_seq OWNED BY saintlouisdev.object_relations.id;


--
-- Name: object_textures; Type: TABLE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE TABLE saintlouisdev.object_textures (
    id integer NOT NULL,
    temporal_object_id integer NOT NULL,
    name character varying(50) NOT NULL,
    filename character varying(50) NOT NULL,
    extent character varying(50),
    matrix character varying(50),
    description text
);


ALTER TABLE saintlouisdev.object_textures OWNER TO saintlouisdev;

--
-- Name: object_textures_id_seq; Type: SEQUENCE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE SEQUENCE saintlouisdev.object_textures_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE saintlouisdev.object_textures_id_seq OWNER TO saintlouisdev;

--
-- Name: object_textures_id_seq; Type: SEQUENCE OWNED BY; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER SEQUENCE saintlouisdev.object_textures_id_seq OWNED BY saintlouisdev.object_textures.id;


--
-- Name: object_types; Type: TABLE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE TABLE saintlouisdev.object_types (
    id integer NOT NULL,
    object_type character varying(50) NOT NULL,
    description character varying(255)
);


ALTER TABLE saintlouisdev.object_types OWNER TO saintlouisdev;

--
-- Name: object_types_id_seq; Type: SEQUENCE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE SEQUENCE saintlouisdev.object_types_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE saintlouisdev.object_types_id_seq OWNER TO saintlouisdev;

--
-- Name: object_types_id_seq; Type: SEQUENCE OWNED BY; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER SEQUENCE saintlouisdev.object_types_id_seq OWNED BY saintlouisdev.object_types.id;


--
-- Name: people; Type: TABLE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE TABLE saintlouisdev.people (
    temporalobject_ptr_id integer NOT NULL,
    geo_dynamic_id integer NOT NULL,
    first_name character varying(50) NOT NULL,
    middle_name character varying(50) NOT NULL,
    last_name character varying(50) NOT NULL,
    address_id character varying(50) NOT NULL,
    occupation integer NOT NULL,
    gender character varying(10) NOT NULL,
    social_class character varying(50) NOT NULL,
    fashion_code integer NOT NULL
);


ALTER TABLE saintlouisdev.people OWNER TO saintlouisdev;

--
-- Name: points_point; Type: TABLE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE TABLE saintlouisdev.points_point (
    id integer NOT NULL,
    polyline_id integer NOT NULL,
    index integer NOT NULL,
    lat double precision NOT NULL,
    lng double precision NOT NULL,
    x double precision NOT NULL,
    y double precision NOT NULL,
    created_at timestamp with time zone,
    updated_at timestamp with time zone
);


ALTER TABLE saintlouisdev.points_point OWNER TO saintlouisdev;

--
-- Name: points_point_id_seq; Type: SEQUENCE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE SEQUENCE saintlouisdev.points_point_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE saintlouisdev.points_point_id_seq OWNER TO saintlouisdev;

--
-- Name: points_point_id_seq; Type: SEQUENCE OWNED BY; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER SEQUENCE saintlouisdev.points_point_id_seq OWNED BY saintlouisdev.points_point.id;


--
-- Name: points_polyline; Type: TABLE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE TABLE saintlouisdev.points_polyline (
    id integer NOT NULL,
    geo_streets_id integer,
    name character varying(255),
    created_at timestamp with time zone,
    updated_at timestamp with time zone
);


ALTER TABLE saintlouisdev.points_polyline OWNER TO saintlouisdev;

--
-- Name: points_polyline_id_seq; Type: SEQUENCE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE SEQUENCE saintlouisdev.points_polyline_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE saintlouisdev.points_polyline_id_seq OWNER TO saintlouisdev;

--
-- Name: points_polyline_id_seq; Type: SEQUENCE OWNED BY; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER SEQUENCE saintlouisdev.points_polyline_id_seq OWNED BY saintlouisdev.points_polyline.id;


--
-- Name: relations; Type: TABLE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE TABLE saintlouisdev.relations (
    id integer NOT NULL,
    relation character varying(50) NOT NULL,
    description text NOT NULL
);


ALTER TABLE saintlouisdev.relations OWNER TO saintlouisdev;

--
-- Name: relations_id_seq; Type: SEQUENCE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE SEQUENCE saintlouisdev.relations_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE saintlouisdev.relations_id_seq OWNER TO saintlouisdev;

--
-- Name: relations_id_seq; Type: SEQUENCE OWNED BY; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER SEQUENCE saintlouisdev.relations_id_seq OWNED BY saintlouisdev.relations.id;


--
-- Name: resource_types; Type: TABLE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE TABLE saintlouisdev.resource_types (
    id integer NOT NULL,
    resource_type integer NOT NULL,
    format integer,
    description text
);


ALTER TABLE saintlouisdev.resource_types OWNER TO saintlouisdev;

--
-- Name: resource_types_id_seq; Type: SEQUENCE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE SEQUENCE saintlouisdev.resource_types_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE saintlouisdev.resource_types_id_seq OWNER TO saintlouisdev;

--
-- Name: resource_types_id_seq; Type: SEQUENCE OWNED BY; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER SEQUENCE saintlouisdev.resource_types_id_seq OWNED BY saintlouisdev.resource_types.id;


--
-- Name: roof_types; Type: TABLE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE TABLE saintlouisdev.roof_types (
    id integer NOT NULL,
    name character varying(31) NOT NULL,
    slope double precision,
    overhang double precision,
    fascia double precision,
    material_id integer NOT NULL,
    description text
);


ALTER TABLE saintlouisdev.roof_types OWNER TO saintlouisdev;

--
-- Name: roof_types_id_seq; Type: SEQUENCE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE SEQUENCE saintlouisdev.roof_types_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE saintlouisdev.roof_types_id_seq OWNER TO saintlouisdev;

--
-- Name: roof_types_id_seq; Type: SEQUENCE OWNED BY; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER SEQUENCE saintlouisdev.roof_types_id_seq OWNED BY saintlouisdev.roof_types.id;


--
-- Name: shape_types; Type: TABLE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE TABLE saintlouisdev.shape_types (
    id integer NOT NULL,
    name character varying(31) NOT NULL,
    description text
);


ALTER TABLE saintlouisdev.shape_types OWNER TO saintlouisdev;

--
-- Name: shape_types_id_seq; Type: SEQUENCE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE SEQUENCE saintlouisdev.shape_types_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE saintlouisdev.shape_types_id_seq OWNER TO saintlouisdev;

--
-- Name: shape_types_id_seq; Type: SEQUENCE OWNED BY; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER SEQUENCE saintlouisdev.shape_types_id_seq OWNED BY saintlouisdev.shape_types.id;


--
-- Name: shapes; Type: TABLE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE TABLE saintlouisdev.shapes (
    temporalobject_ptr_id integer NOT NULL
);


ALTER TABLE saintlouisdev.shapes OWNER TO saintlouisdev;

--
-- Name: static_types; Type: TABLE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE TABLE saintlouisdev.static_types (
    id integer NOT NULL,
    static_type character varying(50) NOT NULL,
    description text
);


ALTER TABLE saintlouisdev.static_types OWNER TO saintlouisdev;

--
-- Name: static_types_id_seq; Type: SEQUENCE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE SEQUENCE saintlouisdev.static_types_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE saintlouisdev.static_types_id_seq OWNER TO saintlouisdev;

--
-- Name: static_types_id_seq; Type: SEQUENCE OWNED BY; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER SEQUENCE saintlouisdev.static_types_id_seq OWNED BY saintlouisdev.static_types.id;


--
-- Name: statics; Type: TABLE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE TABLE saintlouisdev.statics (
    temporalobject_ptr_id integer NOT NULL
);


ALTER TABLE saintlouisdev.statics OWNER TO saintlouisdev;

--
-- Name: street_types; Type: TABLE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE TABLE saintlouisdev.street_types (
    id integer NOT NULL,
    name character varying(50) NOT NULL,
    description text
);


ALTER TABLE saintlouisdev.street_types OWNER TO saintlouisdev;

--
-- Name: street_types_id_seq; Type: SEQUENCE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE SEQUENCE saintlouisdev.street_types_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE saintlouisdev.street_types_id_seq OWNER TO saintlouisdev;

--
-- Name: street_types_id_seq; Type: SEQUENCE OWNED BY; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER SEQUENCE saintlouisdev.street_types_id_seq OWNED BY saintlouisdev.street_types.id;


--
-- Name: streetsegments; Type: TABLE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE TABLE saintlouisdev.streetsegments (
    temporalobject_ptr_id integer NOT NULL
);


ALTER TABLE saintlouisdev.streetsegments OWNER TO saintlouisdev;

--
-- Name: temp_table; Type: TABLE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE TABLE saintlouisdev.temp_table (
    points text
);


ALTER TABLE saintlouisdev.temp_table OWNER TO saintlouisdev;

--
-- Name: temporal_objects_id_seq; Type: SEQUENCE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE SEQUENCE saintlouisdev.temporal_objects_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE saintlouisdev.temporal_objects_id_seq OWNER TO saintlouisdev;

--
-- Name: temporal_objects_id_seq; Type: SEQUENCE OWNED BY; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER SEQUENCE saintlouisdev.temporal_objects_id_seq OWNED BY saintlouisdev.temporal_objects.id;


--
-- Name: texture_types; Type: TABLE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE TABLE saintlouisdev.texture_types (
    id integer NOT NULL,
    name character varying(50) NOT NULL,
    description text
);


ALTER TABLE saintlouisdev.texture_types OWNER TO saintlouisdev;

--
-- Name: texture_types_id_seq; Type: SEQUENCE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE SEQUENCE saintlouisdev.texture_types_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE saintlouisdev.texture_types_id_seq OWNER TO saintlouisdev;

--
-- Name: texture_types_id_seq; Type: SEQUENCE OWNED BY; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER SEQUENCE saintlouisdev.texture_types_id_seq OWNED BY saintlouisdev.texture_types.id;


--
-- Name: textures; Type: TABLE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE TABLE saintlouisdev.textures (
    id integer NOT NULL,
    image_id integer,
    texture_filename character varying(50) NOT NULL,
    name character varying(50),
    start_date date,
    end_date date,
    series integer,
    super_series integer,
    use_code integer,
    style_code integer,
    map_type integer,
    material_code integer,
    stories integer,
    color character varying(50),
    age_code integer,
    description text
);


ALTER TABLE saintlouisdev.textures OWNER TO saintlouisdev;

--
-- Name: textures_id_seq; Type: SEQUENCE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE SEQUENCE saintlouisdev.textures_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE saintlouisdev.textures_id_seq OWNER TO saintlouisdev;

--
-- Name: textures_id_seq; Type: SEQUENCE OWNED BY; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER SEQUENCE saintlouisdev.textures_id_seq OWNED BY saintlouisdev.textures.id;


--
-- Name: the_blocks; Type: TABLE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE TABLE saintlouisdev.the_blocks (
    temporalobject_ptr_id integer NOT NULL,
    block_id integer NOT NULL,
    land_use integer,
    floor_area_ratio double precision
);


ALTER TABLE saintlouisdev.the_blocks OWNER TO saintlouisdev;

--
-- Name: the_buildings; Type: TABLE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE TABLE saintlouisdev.the_buildings (
    temporalobject_ptr_id integer NOT NULL,
    building_id integer NOT NULL,
    architect character varying(50),
    building_type integer,
    building_style integer,
    building_use integer,
    building_name character varying(127),
    aka text
);


ALTER TABLE saintlouisdev.the_buildings OWNER TO saintlouisdev;

--
-- Name: the_dynamics; Type: TABLE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE TABLE saintlouisdev.the_dynamics (
    temporalobject_ptr_id integer NOT NULL,
    dynamic_id integer NOT NULL,
    dynamic_type integer NOT NULL,
    name character varying(50) NOT NULL,
    origin character varying(50) NOT NULL,
    frequency integer NOT NULL,
    speed integer NOT NULL,
    start_time date NOT NULL,
    end_time date NOT NULL
);


ALTER TABLE saintlouisdev.the_dynamics OWNER TO saintlouisdev;

--
-- Name: the_externals; Type: TABLE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE TABLE saintlouisdev.the_externals (
    id integer NOT NULL,
    the_history_id integer NOT NULL,
    resource_type integer,
    url character varying(200),
    source character varying(50),
    name character varying(50)
);


ALTER TABLE saintlouisdev.the_externals OWNER TO saintlouisdev;

--
-- Name: the_externals_id_seq; Type: SEQUENCE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE SEQUENCE saintlouisdev.the_externals_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE saintlouisdev.the_externals_id_seq OWNER TO saintlouisdev;

--
-- Name: the_externals_id_seq; Type: SEQUENCE OWNED BY; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER SEQUENCE saintlouisdev.the_externals_id_seq OWNED BY saintlouisdev.the_externals.id;


--
-- Name: the_fronts; Type: TABLE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE TABLE saintlouisdev.the_fronts (
    temporalobject_ptr_id integer NOT NULL,
    front_id integer NOT NULL,
    is_corner boolean,
    nextfront_id integer,
    walkability double precision
);


ALTER TABLE saintlouisdev.the_fronts OWNER TO saintlouisdev;

--
-- Name: the_histories; Type: TABLE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE TABLE saintlouisdev.the_histories (
    id integer NOT NULL,
    title character varying(50),
    start_date date,
    end_date date,
    keywords text,
    narrative text,
    iconic_image_id integer,
    caption text,
    source character varying(50),
    name character varying(50),
    temporal_object_id integer NOT NULL
);


ALTER TABLE saintlouisdev.the_histories OWNER TO saintlouisdev;

--
-- Name: the_histories_id_seq; Type: SEQUENCE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE SEQUENCE saintlouisdev.the_histories_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE saintlouisdev.the_histories_id_seq OWNER TO saintlouisdev;

--
-- Name: the_histories_id_seq; Type: SEQUENCE OWNED BY; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER SEQUENCE saintlouisdev.the_histories_id_seq OWNED BY saintlouisdev.the_histories.id;


--
-- Name: the_shapes; Type: TABLE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE TABLE saintlouisdev.the_shapes (
    temporalobject_ptr_id integer NOT NULL,
    shape_id integer NOT NULL,
    shape_type integer,
    name character varying(20),
    memo text
);


ALTER TABLE saintlouisdev.the_shapes OWNER TO saintlouisdev;

--
-- Name: the_statics; Type: TABLE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE TABLE saintlouisdev.the_statics (
    temporalobject_ptr_id integer NOT NULL,
    static_id integer NOT NULL,
    static_type_id integer NOT NULL,
    color character varying(31),
    function character varying(31),
    name character varying(50)
);


ALTER TABLE saintlouisdev.the_statics OWNER TO saintlouisdev;

--
-- Name: the_streetsegments; Type: TABLE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE TABLE saintlouisdev.the_streetsegments (
    temporalobject_ptr_id integer NOT NULL,
    streetsegment_id integer NOT NULL,
    street_type integer,
    volume_ped integer,
    volume_veh integer,
    direction character varying(15),
    vc_streetname_id integer,
    pavement_type integer,
    geo_streetsegment_id integer NOT NULL
);


ALTER TABLE saintlouisdev.the_streetsegments OWNER TO saintlouisdev;

--
-- Name: transforms; Type: TABLE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE TABLE saintlouisdev.transforms (
    id integer NOT NULL,
    temporal_object_id integer NOT NULL,
    scale_x double precision,
    scale_y double precision,
    scale_z double precision,
    translation_x double precision,
    translation_y double precision,
    translation_z double precision,
    rotation_x double precision,
    rotation_y double precision,
    rotation_z double precision,
    rotation_radians double precision
);


ALTER TABLE saintlouisdev.transforms OWNER TO saintlouisdev;

--
-- Name: transforms_id_seq; Type: SEQUENCE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE SEQUENCE saintlouisdev.transforms_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE saintlouisdev.transforms_id_seq OWNER TO saintlouisdev;

--
-- Name: transforms_id_seq; Type: SEQUENCE OWNED BY; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER SEQUENCE saintlouisdev.transforms_id_seq OWNED BY saintlouisdev.transforms.id;


--
-- Name: vc_addresses_id_seq; Type: SEQUENCE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE SEQUENCE saintlouisdev.vc_addresses_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE saintlouisdev.vc_addresses_id_seq OWNER TO saintlouisdev;

--
-- Name: vc_addresses_id_seq; Type: SEQUENCE OWNED BY; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER SEQUENCE saintlouisdev.vc_addresses_id_seq OWNED BY saintlouisdev.vc_addresses.id;


--
-- Name: vc_dates_id_seq; Type: SEQUENCE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE SEQUENCE saintlouisdev.vc_dates_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE saintlouisdev.vc_dates_id_seq OWNER TO saintlouisdev;

--
-- Name: vc_dates_id_seq; Type: SEQUENCE OWNED BY; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER SEQUENCE saintlouisdev.vc_dates_id_seq OWNED BY saintlouisdev.vc_dates.id;


--
-- Name: vc_dpw_buildingdata; Type: TABLE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE TABLE saintlouisdev.vc_dpw_buildingdata (
    id integer NOT NULL,
    block_number character varying(20) NOT NULL,
    side integer NOT NULL,
    building_id integer NOT NULL,
    depth double precision,
    front_setback double precision,
    right_setback double precision,
    left_setback double precision,
    address1 integer,
    address2 integer,
    streetname character varying(50),
    source character varying(20) NOT NULL
);


ALTER TABLE saintlouisdev.vc_dpw_buildingdata OWNER TO saintlouisdev;

--
-- Name: vc_dpw_buildingdata_id_seq; Type: SEQUENCE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE SEQUENCE saintlouisdev.vc_dpw_buildingdata_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE saintlouisdev.vc_dpw_buildingdata_id_seq OWNER TO saintlouisdev;

--
-- Name: vc_dpw_buildingdata_id_seq; Type: SEQUENCE OWNED BY; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER SEQUENCE saintlouisdev.vc_dpw_buildingdata_id_seq OWNED BY saintlouisdev.vc_dpw_buildingdata.id;


--
-- Name: vc_md_blocks; Type: TABLE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE TABLE saintlouisdev.vc_md_blocks (
    id integer NOT NULL,
    block_id integer NOT NULL,
    startdate date NOT NULL,
    enddate date NOT NULL,
    block_number character varying(10) NOT NULL,
    points text,
    clickpoints text,
    map_name character varying(50) NOT NULL
);


ALTER TABLE saintlouisdev.vc_md_blocks OWNER TO saintlouisdev;

--
-- Name: vc_md_blocks_id_seq; Type: SEQUENCE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE SEQUENCE saintlouisdev.vc_md_blocks_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE saintlouisdev.vc_md_blocks_id_seq OWNER TO saintlouisdev;

--
-- Name: vc_md_blocks_id_seq; Type: SEQUENCE OWNED BY; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER SEQUENCE saintlouisdev.vc_md_blocks_id_seq OWNED BY saintlouisdev.vc_md_blocks.id;


--
-- Name: vc_md_building_walls; Type: TABLE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE TABLE saintlouisdev.vc_md_building_walls (
    id integer NOT NULL,
    building_id integer NOT NULL,
    block_number character varying(10) NOT NULL,
    building_number integer NOT NULL,
    startdate date NOT NULL,
    enddate date NOT NULL,
    building_type character varying(50) NOT NULL,
    front_id integer NOT NULL,
    sides integer NOT NULL,
    points text,
    clickpoints text,
    index_pt integer NOT NULL,
    flag character varying(12) NOT NULL,
    map_name character varying(50) NOT NULL
);


ALTER TABLE saintlouisdev.vc_md_building_walls OWNER TO saintlouisdev;

--
-- Name: vc_md_building_walls_id_seq; Type: SEQUENCE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE SEQUENCE saintlouisdev.vc_md_building_walls_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE saintlouisdev.vc_md_building_walls_id_seq OWNER TO saintlouisdev;

--
-- Name: vc_md_building_walls_id_seq; Type: SEQUENCE OWNED BY; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER SEQUENCE saintlouisdev.vc_md_building_walls_id_seq OWNED BY saintlouisdev.vc_md_building_walls.id;


--
-- Name: vc_md_fronts; Type: TABLE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE TABLE saintlouisdev.vc_md_fronts (
    id integer NOT NULL,
    front_id integer NOT NULL,
    address_id integer NOT NULL,
    block_number character varying(50) NOT NULL,
    side_id integer NOT NULL,
    startdate date NOT NULL,
    enddate date NOT NULL,
    flag character varying(10) NOT NULL,
    points text,
    clickpoints text,
    is_corner_flag character varying(10) NOT NULL,
    front_index integer NOT NULL,
    map_name character varying(50) NOT NULL
);


ALTER TABLE saintlouisdev.vc_md_fronts OWNER TO saintlouisdev;

--
-- Name: vc_md_fronts_id_seq; Type: SEQUENCE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE SEQUENCE saintlouisdev.vc_md_fronts_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE saintlouisdev.vc_md_fronts_id_seq OWNER TO saintlouisdev;

--
-- Name: vc_md_fronts_id_seq; Type: SEQUENCE OWNED BY; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER SEQUENCE saintlouisdev.vc_md_fronts_id_seq OWNED BY saintlouisdev.vc_md_fronts.id;


--
-- Name: vc_streetnames_id_seq; Type: SEQUENCE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE SEQUENCE saintlouisdev.vc_streetnames_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE saintlouisdev.vc_streetnames_id_seq OWNER TO saintlouisdev;

--
-- Name: vc_streetnames_id_seq; Type: SEQUENCE OWNED BY; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER SEQUENCE saintlouisdev.vc_streetnames_id_seq OWNED BY saintlouisdev.vc_streetnames.id;


--
-- Name: viewpoints; Type: TABLE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE TABLE saintlouisdev.viewpoints (
    temporalobject_ptr_id integer NOT NULL,
    field_view integer,
    viewpoint_name character varying(50) NOT NULL,
    "position" character varying(127) NOT NULL,
    orientation character varying(50) NOT NULL,
    center_rotation character varying(127),
    set_bind boolean,
    jump boolean,
    metadata text,
    retain_offsets boolean,
    bind_time character varying(50),
    is_bound boolean
);


ALTER TABLE saintlouisdev.viewpoints OWNER TO saintlouisdev;

--
-- Name: walk_types; Type: TABLE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE TABLE saintlouisdev.walk_types (
    id integer NOT NULL,
    name character varying(50) NOT NULL,
    curb_width double precision NOT NULL,
    curb_depth double precision NOT NULL,
    paved_width double precision NOT NULL,
    planter_width double precision NOT NULL,
    planter_position character varying(50) NOT NULL,
    description text NOT NULL
);


ALTER TABLE saintlouisdev.walk_types OWNER TO saintlouisdev;

--
-- Name: walk_types_id_seq; Type: SEQUENCE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE SEQUENCE saintlouisdev.walk_types_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE saintlouisdev.walk_types_id_seq OWNER TO saintlouisdev;

--
-- Name: walk_types_id_seq; Type: SEQUENCE OWNED BY; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER SEQUENCE saintlouisdev.walk_types_id_seq OWNED BY saintlouisdev.walk_types.id;


--
-- Name: walks; Type: TABLE; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE TABLE saintlouisdev.walks (
    temporalobject_ptr_id integer NOT NULL,
    geo_side_id integer NOT NULL,
    walk_width double precision,
    walk_type integer,
    material integer
);


ALTER TABLE saintlouisdev.walks OWNER TO saintlouisdev;

--
-- Name: age_types id; Type: DEFAULT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.age_types ALTER COLUMN id SET DEFAULT nextval('saintlouisdev.age_types_id_seq'::regclass);


--
-- Name: auth_group id; Type: DEFAULT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.auth_group ALTER COLUMN id SET DEFAULT nextval('saintlouisdev.auth_group_id_seq'::regclass);


--
-- Name: auth_group_permissions id; Type: DEFAULT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.auth_group_permissions ALTER COLUMN id SET DEFAULT nextval('saintlouisdev.auth_group_permissions_id_seq'::regclass);


--
-- Name: auth_message id; Type: DEFAULT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.auth_message ALTER COLUMN id SET DEFAULT nextval('saintlouisdev.auth_message_id_seq'::regclass);


--
-- Name: auth_permission id; Type: DEFAULT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.auth_permission ALTER COLUMN id SET DEFAULT nextval('saintlouisdev.auth_permission_id_seq'::regclass);


--
-- Name: auth_user id; Type: DEFAULT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.auth_user ALTER COLUMN id SET DEFAULT nextval('saintlouisdev.auth_user_id_seq'::regclass);


--
-- Name: auth_user_groups id; Type: DEFAULT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.auth_user_groups ALTER COLUMN id SET DEFAULT nextval('saintlouisdev.auth_user_groups_id_seq'::regclass);


--
-- Name: auth_user_user_permissions id; Type: DEFAULT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.auth_user_user_permissions ALTER COLUMN id SET DEFAULT nextval('saintlouisdev.auth_user_user_permissions_id_seq'::regclass);


--
-- Name: building_forms id; Type: DEFAULT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.building_forms ALTER COLUMN id SET DEFAULT nextval('saintlouisdev.building_forms_id_seq'::regclass);


--
-- Name: building_styles id; Type: DEFAULT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.building_styles ALTER COLUMN id SET DEFAULT nextval('saintlouisdev.building_styles_id_seq'::regclass);


--
-- Name: building_types id; Type: DEFAULT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.building_types ALTER COLUMN id SET DEFAULT nextval('saintlouisdev.building_types_id_seq'::regclass);


--
-- Name: building_uses id; Type: DEFAULT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.building_uses ALTER COLUMN id SET DEFAULT nextval('saintlouisdev.building_uses_id_seq'::regclass);


--
-- Name: buildings_geo_front id; Type: DEFAULT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.buildings_geo_front ALTER COLUMN id SET DEFAULT nextval('saintlouisdev.buildings_geo_front_id_seq'::regclass);


--
-- Name: cesium_entities entity_id; Type: DEFAULT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.cesium_entities ALTER COLUMN entity_id SET DEFAULT nextval('saintlouisdev.cesium_entity_entity_id_seq'::regclass);


--
-- Name: city_defaults id; Type: DEFAULT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.city_defaults ALTER COLUMN id SET DEFAULT nextval('saintlouisdev.city_defaults_id_seq'::regclass);


--
-- Name: city_directories id; Type: DEFAULT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.city_directories ALTER COLUMN id SET DEFAULT nextval('saintlouisdev.city_directories_id_seq'::regclass);


--
-- Name: django_admin_log id; Type: DEFAULT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.django_admin_log ALTER COLUMN id SET DEFAULT nextval('saintlouisdev.django_admin_log_id_seq'::regclass);


--
-- Name: django_content_type id; Type: DEFAULT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.django_content_type ALTER COLUMN id SET DEFAULT nextval('saintlouisdev.django_content_type_id_seq'::regclass);


--
-- Name: django_site id; Type: DEFAULT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.django_site ALTER COLUMN id SET DEFAULT nextval('saintlouisdev.django_site_id_seq'::regclass);


--
-- Name: dynamic_types id; Type: DEFAULT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.dynamic_types ALTER COLUMN id SET DEFAULT nextval('saintlouisdev.dynamic_types_id_seq'::regclass);


--
-- Name: external_id id; Type: DEFAULT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.external_id ALTER COLUMN id SET DEFAULT nextval('saintlouisdev.external_id_id_seq'::regclass);


--
-- Name: footprint_types id; Type: DEFAULT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.footprint_types ALTER COLUMN id SET DEFAULT nextval('saintlouisdev.footprint_types_id_seq'::regclass);


--
-- Name: geo_blocks_geo_front id; Type: DEFAULT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.geo_blocks_geo_front ALTER COLUMN id SET DEFAULT nextval('saintlouisdev.geo_blocks_geo_front_id_seq'::regclass);


--
-- Name: geo_fronts_address id; Type: DEFAULT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.geo_fronts_address ALTER COLUMN id SET DEFAULT nextval('saintlouisdev.geo_fronts_address_id_seq'::regclass);


--
-- Name: geo_sides id; Type: DEFAULT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.geo_sides ALTER COLUMN id SET DEFAULT nextval('saintlouisdev.geo_sides_id_seq'::regclass);


--
-- Name: gps_photos id; Type: DEFAULT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.gps_photos ALTER COLUMN id SET DEFAULT nextval('saintlouisdev.gps_photos_id_seq'::regclass);


--
-- Name: images id; Type: DEFAULT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.images ALTER COLUMN id SET DEFAULT nextval('saintlouisdev.images_id_seq1'::regclass);


--
-- Name: images_temporal_object id; Type: DEFAULT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.images_temporal_object ALTER COLUMN id SET DEFAULT nextval('saintlouisdev.images_temporal_object_id_seq'::regclass);


--
-- Name: land_uses id; Type: DEFAULT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.land_uses ALTER COLUMN id SET DEFAULT nextval('saintlouisdev.land_uses_id_seq'::regclass);


--
-- Name: map_types id; Type: DEFAULT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.map_types ALTER COLUMN id SET DEFAULT nextval('saintlouisdev.map_types_id_seq'::regclass);


--
-- Name: materials id; Type: DEFAULT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.materials ALTER COLUMN id SET DEFAULT nextval('saintlouisdev.materials_id_seq'::regclass);


--
-- Name: object_relations id; Type: DEFAULT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.object_relations ALTER COLUMN id SET DEFAULT nextval('saintlouisdev.object_relations_id_seq'::regclass);


--
-- Name: object_textures id; Type: DEFAULT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.object_textures ALTER COLUMN id SET DEFAULT nextval('saintlouisdev.object_textures_id_seq'::regclass);


--
-- Name: object_types id; Type: DEFAULT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.object_types ALTER COLUMN id SET DEFAULT nextval('saintlouisdev.object_types_id_seq'::regclass);


--
-- Name: points_point id; Type: DEFAULT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.points_point ALTER COLUMN id SET DEFAULT nextval('saintlouisdev.points_point_id_seq'::regclass);


--
-- Name: points_polyline id; Type: DEFAULT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.points_polyline ALTER COLUMN id SET DEFAULT nextval('saintlouisdev.points_polyline_id_seq'::regclass);


--
-- Name: relations id; Type: DEFAULT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.relations ALTER COLUMN id SET DEFAULT nextval('saintlouisdev.relations_id_seq'::regclass);


--
-- Name: resource_types id; Type: DEFAULT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.resource_types ALTER COLUMN id SET DEFAULT nextval('saintlouisdev.resource_types_id_seq'::regclass);


--
-- Name: roof_types id; Type: DEFAULT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.roof_types ALTER COLUMN id SET DEFAULT nextval('saintlouisdev.roof_types_id_seq'::regclass);


--
-- Name: shape_types id; Type: DEFAULT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.shape_types ALTER COLUMN id SET DEFAULT nextval('saintlouisdev.shape_types_id_seq'::regclass);


--
-- Name: static_types id; Type: DEFAULT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.static_types ALTER COLUMN id SET DEFAULT nextval('saintlouisdev.static_types_id_seq'::regclass);


--
-- Name: street_types id; Type: DEFAULT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.street_types ALTER COLUMN id SET DEFAULT nextval('saintlouisdev.street_types_id_seq'::regclass);


--
-- Name: temporal_objects id; Type: DEFAULT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.temporal_objects ALTER COLUMN id SET DEFAULT nextval('saintlouisdev.temporal_objects_id_seq'::regclass);


--
-- Name: texture_types id; Type: DEFAULT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.texture_types ALTER COLUMN id SET DEFAULT nextval('saintlouisdev.texture_types_id_seq'::regclass);


--
-- Name: textures id; Type: DEFAULT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.textures ALTER COLUMN id SET DEFAULT nextval('saintlouisdev.textures_id_seq'::regclass);


--
-- Name: the_externals id; Type: DEFAULT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.the_externals ALTER COLUMN id SET DEFAULT nextval('saintlouisdev.the_externals_id_seq'::regclass);


--
-- Name: the_histories id; Type: DEFAULT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.the_histories ALTER COLUMN id SET DEFAULT nextval('saintlouisdev.the_histories_id_seq'::regclass);


--
-- Name: transforms id; Type: DEFAULT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.transforms ALTER COLUMN id SET DEFAULT nextval('saintlouisdev.transforms_id_seq'::regclass);


--
-- Name: vc_addresses id; Type: DEFAULT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.vc_addresses ALTER COLUMN id SET DEFAULT nextval('saintlouisdev.vc_addresses_id_seq'::regclass);


--
-- Name: vc_dates id; Type: DEFAULT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.vc_dates ALTER COLUMN id SET DEFAULT nextval('saintlouisdev.vc_dates_id_seq'::regclass);


--
-- Name: vc_dpw_buildingdata id; Type: DEFAULT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.vc_dpw_buildingdata ALTER COLUMN id SET DEFAULT nextval('saintlouisdev.vc_dpw_buildingdata_id_seq'::regclass);


--
-- Name: vc_md_blocks id; Type: DEFAULT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.vc_md_blocks ALTER COLUMN id SET DEFAULT nextval('saintlouisdev.vc_md_blocks_id_seq'::regclass);


--
-- Name: vc_md_building_walls id; Type: DEFAULT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.vc_md_building_walls ALTER COLUMN id SET DEFAULT nextval('saintlouisdev.vc_md_building_walls_id_seq'::regclass);


--
-- Name: vc_md_fronts id; Type: DEFAULT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.vc_md_fronts ALTER COLUMN id SET DEFAULT nextval('saintlouisdev.vc_md_fronts_id_seq'::regclass);


--
-- Name: vc_streetnames id; Type: DEFAULT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.vc_streetnames ALTER COLUMN id SET DEFAULT nextval('saintlouisdev.vc_streetnames_id_seq'::regclass);


--
-- Name: walk_types id; Type: DEFAULT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.walk_types ALTER COLUMN id SET DEFAULT nextval('saintlouisdev.walk_types_id_seq'::regclass);


--
-- Name: age_types age_types_pkey; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.age_types
    ADD CONSTRAINT age_types_pkey PRIMARY KEY (id);


--
-- Name: auth_group auth_group_name_key; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.auth_group
    ADD CONSTRAINT auth_group_name_key UNIQUE (name);


--
-- Name: auth_group_permissions auth_group_permissions_group_id_key; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.auth_group_permissions
    ADD CONSTRAINT auth_group_permissions_group_id_key UNIQUE (group_id, permission_id);


--
-- Name: auth_group_permissions auth_group_permissions_pkey; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.auth_group_permissions
    ADD CONSTRAINT auth_group_permissions_pkey PRIMARY KEY (id);


--
-- Name: auth_group auth_group_pkey; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.auth_group
    ADD CONSTRAINT auth_group_pkey PRIMARY KEY (id);


--
-- Name: auth_message auth_message_pkey; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.auth_message
    ADD CONSTRAINT auth_message_pkey PRIMARY KEY (id);


--
-- Name: auth_permission auth_permission_content_type_id_key; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.auth_permission
    ADD CONSTRAINT auth_permission_content_type_id_key UNIQUE (content_type_id, codename);


--
-- Name: auth_permission auth_permission_pkey; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.auth_permission
    ADD CONSTRAINT auth_permission_pkey PRIMARY KEY (id);


--
-- Name: auth_user_groups auth_user_groups_pkey; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.auth_user_groups
    ADD CONSTRAINT auth_user_groups_pkey PRIMARY KEY (id);


--
-- Name: auth_user_groups auth_user_groups_user_id_key; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.auth_user_groups
    ADD CONSTRAINT auth_user_groups_user_id_key UNIQUE (user_id, group_id);


--
-- Name: auth_user auth_user_pkey; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.auth_user
    ADD CONSTRAINT auth_user_pkey PRIMARY KEY (id);


--
-- Name: auth_user_user_permissions auth_user_user_permissions_pkey; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.auth_user_user_permissions
    ADD CONSTRAINT auth_user_user_permissions_pkey PRIMARY KEY (id);


--
-- Name: auth_user_user_permissions auth_user_user_permissions_user_id_key; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.auth_user_user_permissions
    ADD CONSTRAINT auth_user_user_permissions_user_id_key UNIQUE (user_id, permission_id);


--
-- Name: auth_user auth_user_username_key; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.auth_user
    ADD CONSTRAINT auth_user_username_key UNIQUE (username);


--
-- Name: blocks blocks_pkey; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.blocks
    ADD CONSTRAINT blocks_pkey PRIMARY KEY (temporalobject_ptr_id);


--
-- Name: building_forms building_forms_pkey; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.building_forms
    ADD CONSTRAINT building_forms_pkey PRIMARY KEY (id);


--
-- Name: building_parts building_parts_pkey; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.building_parts
    ADD CONSTRAINT building_parts_pkey PRIMARY KEY (temporalobject_ptr_id);


--
-- Name: building_styles building_styles_pkey; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.building_styles
    ADD CONSTRAINT building_styles_pkey PRIMARY KEY (id);


--
-- Name: building_types building_types_pkey; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.building_types
    ADD CONSTRAINT building_types_pkey PRIMARY KEY (id);


--
-- Name: building_uses building_uses_pkey; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.building_uses
    ADD CONSTRAINT building_uses_pkey PRIMARY KEY (id);


--
-- Name: buildings_geo_front buildings_geo_front_building_id_key; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.buildings_geo_front
    ADD CONSTRAINT buildings_geo_front_building_id_key UNIQUE (building_id, geofront_id);


--
-- Name: buildings_geo_front buildings_geo_front_pkey; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.buildings_geo_front
    ADD CONSTRAINT buildings_geo_front_pkey PRIMARY KEY (id);


--
-- Name: buildings buildings_pkey; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.buildings
    ADD CONSTRAINT buildings_pkey PRIMARY KEY (temporalobject_ptr_id);


--
-- Name: cesium_entities cesium_entity_pkey; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.cesium_entities
    ADD CONSTRAINT cesium_entity_pkey PRIMARY KEY (entity_id);


--
-- Name: cesiumlatlong cesiumlatlong_pkey; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.cesiumlatlong
    ADD CONSTRAINT cesiumlatlong_pkey PRIMARY KEY (building_id);


--
-- Name: city_defaults city_defaults_pkey; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.city_defaults
    ADD CONSTRAINT city_defaults_pkey PRIMARY KEY (id);


--
-- Name: city_directories city_directories_pkey; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.city_directories
    ADD CONSTRAINT city_directories_pkey PRIMARY KEY (id);


--
-- Name: city_networks city_networks_pkey; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.city_networks
    ADD CONSTRAINT city_networks_pkey PRIMARY KEY (temporalobject_ptr_id);


--
-- Name: django_admin_log django_admin_log_pkey; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.django_admin_log
    ADD CONSTRAINT django_admin_log_pkey PRIMARY KEY (id);


--
-- Name: django_content_type django_content_type_app_label_key; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.django_content_type
    ADD CONSTRAINT django_content_type_app_label_key UNIQUE (app_label, model);


--
-- Name: django_content_type django_content_type_pkey; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.django_content_type
    ADD CONSTRAINT django_content_type_pkey PRIMARY KEY (id);


--
-- Name: django_session django_session_pkey; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.django_session
    ADD CONSTRAINT django_session_pkey PRIMARY KEY (session_key);


--
-- Name: django_site django_site_pkey; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.django_site
    ADD CONSTRAINT django_site_pkey PRIMARY KEY (id);


--
-- Name: dynamic_types dynamic_types_pkey; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.dynamic_types
    ADD CONSTRAINT dynamic_types_pkey PRIMARY KEY (id);


--
-- Name: dynamics dynamics_pkey; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.dynamics
    ADD CONSTRAINT dynamics_pkey PRIMARY KEY (temporalobject_ptr_id);


--
-- Name: external_id external_id_pkey; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.external_id
    ADD CONSTRAINT external_id_pkey PRIMARY KEY (id);


--
-- Name: external_id external_id_temporal_object_id_key; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.external_id
    ADD CONSTRAINT external_id_temporal_object_id_key UNIQUE (temporal_object_id);


--
-- Name: footprint_types footprint_types_pkey; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.footprint_types
    ADD CONSTRAINT footprint_types_pkey PRIMARY KEY (id);


--
-- Name: fronts fronts_pkey; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.fronts
    ADD CONSTRAINT fronts_pkey PRIMARY KEY (temporalobject_ptr_id);


--
-- Name: geo_blocks_geo_front geo_blocks_geo_front_geoblock_id_key; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.geo_blocks_geo_front
    ADD CONSTRAINT geo_blocks_geo_front_geoblock_id_key UNIQUE (geoblock_id, geofront_id);


--
-- Name: geo_blocks_geo_front geo_blocks_geo_front_pkey; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.geo_blocks_geo_front
    ADD CONSTRAINT geo_blocks_geo_front_pkey PRIMARY KEY (id);


--
-- Name: geo_blocks geo_blocks_pkey; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.geo_blocks
    ADD CONSTRAINT geo_blocks_pkey PRIMARY KEY (temporalobject_ptr_id);


--
-- Name: geo_dynamics geo_dynamics_pkey; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.geo_dynamics
    ADD CONSTRAINT geo_dynamics_pkey PRIMARY KEY (temporalobject_ptr_id);


--
-- Name: geo_footprints geo_footprints_pkey; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.geo_footprints
    ADD CONSTRAINT geo_footprints_pkey PRIMARY KEY (temporalobject_ptr_id);


--
-- Name: geo_fronts_address geo_fronts_address_geofront_id_key; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.geo_fronts_address
    ADD CONSTRAINT geo_fronts_address_geofront_id_key UNIQUE (geofront_id, vcaddress_id);


--
-- Name: geo_fronts_address geo_fronts_address_pkey; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.geo_fronts_address
    ADD CONSTRAINT geo_fronts_address_pkey PRIMARY KEY (id);


--
-- Name: geo_fronts geo_fronts_pkey; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.geo_fronts
    ADD CONSTRAINT geo_fronts_pkey PRIMARY KEY (temporalobject_ptr_id);


--
-- Name: geo_intersections geo_intersections_pkey; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.geo_intersections
    ADD CONSTRAINT geo_intersections_pkey PRIMARY KEY (temporalobject_ptr_id);


--
-- Name: geo_meshes geo_meshes_pkey1; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.geo_meshes
    ADD CONSTRAINT geo_meshes_pkey1 PRIMARY KEY (temporalobject_ptr_id);


--
-- Name: geo_protos geo_protos_pkey; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.geo_protos
    ADD CONSTRAINT geo_protos_pkey PRIMARY KEY (temporalobject_ptr_id);


--
-- Name: geo_shapes geo_shapes_pkey; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.geo_shapes
    ADD CONSTRAINT geo_shapes_pkey PRIMARY KEY (temporalobject_ptr_id);


--
-- Name: geo_sides geo_sides_pkey; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.geo_sides
    ADD CONSTRAINT geo_sides_pkey PRIMARY KEY (id);


--
-- Name: geo_statics geo_statics_pkey; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.geo_statics
    ADD CONSTRAINT geo_statics_pkey PRIMARY KEY (temporalobject_ptr_id);


--
-- Name: geo_streets geo_streets_pkey; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.geo_streets
    ADD CONSTRAINT geo_streets_pkey PRIMARY KEY (temporalobject_ptr_id);


--
-- Name: geo_streetsegments geo_streetsegments_pkey; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.geo_streetsegments
    ADD CONSTRAINT geo_streetsegments_pkey PRIMARY KEY (temporalobject_ptr_id);


--
-- Name: gps_photos gps_photos_image_id_key; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.gps_photos
    ADD CONSTRAINT gps_photos_image_id_key UNIQUE (image_id);


--
-- Name: gps_photos gps_photos_pkey; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.gps_photos
    ADD CONSTRAINT gps_photos_pkey PRIMARY KEY (id);


--
-- Name: ground_overlays ground_overlays_pkey1; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.ground_overlays
    ADD CONSTRAINT ground_overlays_pkey1 PRIMARY KEY (temporalobject_ptr_id);


--
-- Name: images images_pkey1; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.images
    ADD CONSTRAINT images_pkey1 PRIMARY KEY (id);


--
-- Name: images_temporal_object images_temporal_object_image_id_key; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.images_temporal_object
    ADD CONSTRAINT images_temporal_object_image_id_key UNIQUE (image_id, temporalobject_id);


--
-- Name: images_temporal_object images_temporal_object_pkey; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.images_temporal_object
    ADD CONSTRAINT images_temporal_object_pkey PRIMARY KEY (id);


--
-- Name: land_uses land_uses_pkey; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.land_uses
    ADD CONSTRAINT land_uses_pkey PRIMARY KEY (id);


--
-- Name: map_types map_types_pkey; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.map_types
    ADD CONSTRAINT map_types_pkey PRIMARY KEY (id);


--
-- Name: materials materials_pkey; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.materials
    ADD CONSTRAINT materials_pkey PRIMARY KEY (id);


--
-- Name: object_relations object_relations_pkey; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.object_relations
    ADD CONSTRAINT object_relations_pkey PRIMARY KEY (id);


--
-- Name: object_textures object_textures_pkey; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.object_textures
    ADD CONSTRAINT object_textures_pkey PRIMARY KEY (id);


--
-- Name: object_types object_types_pkey; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.object_types
    ADD CONSTRAINT object_types_pkey PRIMARY KEY (id);


--
-- Name: people people_pkey; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.people
    ADD CONSTRAINT people_pkey PRIMARY KEY (temporalobject_ptr_id);


--
-- Name: points_point points_point_pkey; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.points_point
    ADD CONSTRAINT points_point_pkey PRIMARY KEY (id);


--
-- Name: points_polyline points_polyline_pkey; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.points_polyline
    ADD CONSTRAINT points_polyline_pkey PRIMARY KEY (id);


--
-- Name: relations relations_pkey; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.relations
    ADD CONSTRAINT relations_pkey PRIMARY KEY (id);


--
-- Name: resource_types resource_types_pkey; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.resource_types
    ADD CONSTRAINT resource_types_pkey PRIMARY KEY (id);


--
-- Name: roof_types roof_types_pkey; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.roof_types
    ADD CONSTRAINT roof_types_pkey PRIMARY KEY (id);


--
-- Name: shape_types shape_types_pkey; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.shape_types
    ADD CONSTRAINT shape_types_pkey PRIMARY KEY (id);


--
-- Name: shapes shapes_pkey; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.shapes
    ADD CONSTRAINT shapes_pkey PRIMARY KEY (temporalobject_ptr_id);


--
-- Name: static_types static_types_pkey; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.static_types
    ADD CONSTRAINT static_types_pkey PRIMARY KEY (id);


--
-- Name: statics statics_pkey; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.statics
    ADD CONSTRAINT statics_pkey PRIMARY KEY (temporalobject_ptr_id);


--
-- Name: street_types street_types_pkey; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.street_types
    ADD CONSTRAINT street_types_pkey PRIMARY KEY (id);


--
-- Name: streetsegments streetsegments_pkey; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.streetsegments
    ADD CONSTRAINT streetsegments_pkey PRIMARY KEY (temporalobject_ptr_id);


--
-- Name: temporal_objects temporal_objects_pkey; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.temporal_objects
    ADD CONSTRAINT temporal_objects_pkey PRIMARY KEY (id);


--
-- Name: texture_types texture_types_pkey; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.texture_types
    ADD CONSTRAINT texture_types_pkey PRIMARY KEY (id);


--
-- Name: textures textures_pkey; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.textures
    ADD CONSTRAINT textures_pkey PRIMARY KEY (id);


--
-- Name: the_blocks the_blocks_pkey; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.the_blocks
    ADD CONSTRAINT the_blocks_pkey PRIMARY KEY (temporalobject_ptr_id);


--
-- Name: the_buildings the_buildings_pkey; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.the_buildings
    ADD CONSTRAINT the_buildings_pkey PRIMARY KEY (temporalobject_ptr_id);


--
-- Name: the_dynamics the_dynamics_pkey; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.the_dynamics
    ADD CONSTRAINT the_dynamics_pkey PRIMARY KEY (temporalobject_ptr_id);


--
-- Name: the_externals the_externals_pkey; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.the_externals
    ADD CONSTRAINT the_externals_pkey PRIMARY KEY (id);


--
-- Name: the_fronts the_fronts_pkey; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.the_fronts
    ADD CONSTRAINT the_fronts_pkey PRIMARY KEY (temporalobject_ptr_id);


--
-- Name: the_histories the_histories_pkey; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.the_histories
    ADD CONSTRAINT the_histories_pkey PRIMARY KEY (id);


--
-- Name: the_shapes the_shapes_pkey; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.the_shapes
    ADD CONSTRAINT the_shapes_pkey PRIMARY KEY (temporalobject_ptr_id);


--
-- Name: the_statics the_statics_pkey; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.the_statics
    ADD CONSTRAINT the_statics_pkey PRIMARY KEY (temporalobject_ptr_id);


--
-- Name: the_streetsegments the_streetsegments_pkey; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.the_streetsegments
    ADD CONSTRAINT the_streetsegments_pkey PRIMARY KEY (temporalobject_ptr_id);


--
-- Name: transforms transforms_pkey; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.transforms
    ADD CONSTRAINT transforms_pkey PRIMARY KEY (id);


--
-- Name: transforms transforms_temporal_object_id_key; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.transforms
    ADD CONSTRAINT transforms_temporal_object_id_key UNIQUE (temporal_object_id);


--
-- Name: vc_addresses vc_addresses_pkey; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.vc_addresses
    ADD CONSTRAINT vc_addresses_pkey PRIMARY KEY (id);


--
-- Name: vc_dates vc_dates_pkey; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.vc_dates
    ADD CONSTRAINT vc_dates_pkey PRIMARY KEY (id);


--
-- Name: vc_dpw_buildingdata vc_dpw_buildingdata_pkey; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.vc_dpw_buildingdata
    ADD CONSTRAINT vc_dpw_buildingdata_pkey PRIMARY KEY (id);


--
-- Name: vc_md_blocks vc_md_blocks_pkey; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.vc_md_blocks
    ADD CONSTRAINT vc_md_blocks_pkey PRIMARY KEY (id);


--
-- Name: vc_md_building_walls vc_md_building_walls_pkey; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.vc_md_building_walls
    ADD CONSTRAINT vc_md_building_walls_pkey PRIMARY KEY (id);


--
-- Name: vc_md_fronts vc_md_fronts_pkey; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.vc_md_fronts
    ADD CONSTRAINT vc_md_fronts_pkey PRIMARY KEY (id);


--
-- Name: vc_streetnames vc_streetnames_pkey; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.vc_streetnames
    ADD CONSTRAINT vc_streetnames_pkey PRIMARY KEY (id);


--
-- Name: viewpoints viewpoints_pkey; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.viewpoints
    ADD CONSTRAINT viewpoints_pkey PRIMARY KEY (temporalobject_ptr_id);


--
-- Name: walk_types walk_types_pkey; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.walk_types
    ADD CONSTRAINT walk_types_pkey PRIMARY KEY (id);


--
-- Name: walks walks_pkey; Type: CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.walks
    ADD CONSTRAINT walks_pkey PRIMARY KEY (temporalobject_ptr_id);


--
-- Name: auth_message_user_id; Type: INDEX; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE INDEX auth_message_user_id ON saintlouisdev.auth_message USING btree (user_id);


--
-- Name: auth_permission_content_type_id; Type: INDEX; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE INDEX auth_permission_content_type_id ON saintlouisdev.auth_permission USING btree (content_type_id);


--
-- Name: building_forms_building_id; Type: INDEX; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE INDEX building_forms_building_id ON saintlouisdev.building_forms USING btree (building_id);


--
-- Name: building_parts_building_id; Type: INDEX; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE INDEX building_parts_building_id ON saintlouisdev.building_parts USING btree (building_id);


--
-- Name: city_networks_geo_streetsegment_id; Type: INDEX; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE INDEX city_networks_geo_streetsegment_id ON saintlouisdev.city_networks USING btree (geo_streetsegment_id);


--
-- Name: django_admin_log_content_type_id; Type: INDEX; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE INDEX django_admin_log_content_type_id ON saintlouisdev.django_admin_log USING btree (content_type_id);


--
-- Name: django_admin_log_user_id; Type: INDEX; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE INDEX django_admin_log_user_id ON saintlouisdev.django_admin_log USING btree (user_id);


--
-- Name: geo_blocks_block_id; Type: INDEX; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE INDEX geo_blocks_block_id ON saintlouisdev.geo_blocks USING btree (block_id);


--
-- Name: geo_dynamics_dynamic_id; Type: INDEX; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE INDEX geo_dynamics_dynamic_id ON saintlouisdev.geo_dynamics USING btree (dynamic_id);


--
-- Name: geo_footprints_building_id; Type: INDEX; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE INDEX geo_footprints_building_id ON saintlouisdev.geo_footprints USING btree (building_id);


--
-- Name: geo_fronts_front_id; Type: INDEX; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE INDEX geo_fronts_front_id ON saintlouisdev.geo_fronts USING btree (front_id);


--
-- Name: geo_protos_building_id; Type: INDEX; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE INDEX geo_protos_building_id ON saintlouisdev.geo_protos USING btree (building_id);


--
-- Name: geo_shapes_shape_id; Type: INDEX; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE INDEX geo_shapes_shape_id ON saintlouisdev.geo_shapes USING btree (shape_id);


--
-- Name: geo_sides_geo_block_id; Type: INDEX; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE INDEX geo_sides_geo_block_id ON saintlouisdev.geo_sides USING btree (geo_block_id);


--
-- Name: geo_sides_vc_streetname_id; Type: INDEX; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE INDEX geo_sides_vc_streetname_id ON saintlouisdev.geo_sides USING btree (vc_streetname_id);


--
-- Name: geo_statics_static_id; Type: INDEX; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE INDEX geo_statics_static_id ON saintlouisdev.geo_statics USING btree (static_id);


--
-- Name: geo_streets_vc_streetname_id; Type: INDEX; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE INDEX geo_streets_vc_streetname_id ON saintlouisdev.geo_streets USING btree (vc_streetname_id);


--
-- Name: geo_streetsegments_streetsegment_id; Type: INDEX; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE INDEX geo_streetsegments_streetsegment_id ON saintlouisdev.geo_streetsegments USING btree (streetsegment_id);


--
-- Name: geo_streetsegments_vc_streetname_id; Type: INDEX; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE INDEX geo_streetsegments_vc_streetname_id ON saintlouisdev.geo_streetsegments USING btree (vc_streetname_id);


--
-- Name: object_relations_from_object_id; Type: INDEX; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE INDEX object_relations_from_object_id ON saintlouisdev.object_relations USING btree (from_object_id);


--
-- Name: object_relations_relation_id; Type: INDEX; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE INDEX object_relations_relation_id ON saintlouisdev.object_relations USING btree (relation_id);


--
-- Name: object_relations_to_object_id; Type: INDEX; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE INDEX object_relations_to_object_id ON saintlouisdev.object_relations USING btree (to_object_id);


--
-- Name: object_textures_temporal_object_id; Type: INDEX; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE INDEX object_textures_temporal_object_id ON saintlouisdev.object_textures USING btree (temporal_object_id);


--
-- Name: people_geo_dynamic_id; Type: INDEX; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE INDEX people_geo_dynamic_id ON saintlouisdev.people USING btree (geo_dynamic_id);


--
-- Name: points_point_polyline_id; Type: INDEX; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE INDEX points_point_polyline_id ON saintlouisdev.points_point USING btree (polyline_id);


--
-- Name: points_polyline_geo_streets_id; Type: INDEX; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE INDEX points_polyline_geo_streets_id ON saintlouisdev.points_polyline USING btree (geo_streets_id);


--
-- Name: roof_types_material_id; Type: INDEX; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE INDEX roof_types_material_id ON saintlouisdev.roof_types USING btree (material_id);


--
-- Name: temporal_objects_end_date_id; Type: INDEX; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE INDEX temporal_objects_end_date_id ON saintlouisdev.temporal_objects USING btree (end_date_id);


--
-- Name: temporal_objects_object_type_id; Type: INDEX; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE INDEX temporal_objects_object_type_id ON saintlouisdev.temporal_objects USING btree (object_type_id);


--
-- Name: temporal_objects_start_date_id; Type: INDEX; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE INDEX temporal_objects_start_date_id ON saintlouisdev.temporal_objects USING btree (start_date_id);


--
-- Name: textures_image_id; Type: INDEX; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE INDEX textures_image_id ON saintlouisdev.textures USING btree (image_id);


--
-- Name: the_blocks_block_id; Type: INDEX; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE INDEX the_blocks_block_id ON saintlouisdev.the_blocks USING btree (block_id);


--
-- Name: the_buildings_building_id; Type: INDEX; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE INDEX the_buildings_building_id ON saintlouisdev.the_buildings USING btree (building_id);


--
-- Name: the_dynamics_dynamic_id; Type: INDEX; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE INDEX the_dynamics_dynamic_id ON saintlouisdev.the_dynamics USING btree (dynamic_id);


--
-- Name: the_externals_the_history_id; Type: INDEX; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE INDEX the_externals_the_history_id ON saintlouisdev.the_externals USING btree (the_history_id);


--
-- Name: the_fronts_front_id; Type: INDEX; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE INDEX the_fronts_front_id ON saintlouisdev.the_fronts USING btree (front_id);


--
-- Name: the_histories_iconic_image_id; Type: INDEX; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE INDEX the_histories_iconic_image_id ON saintlouisdev.the_histories USING btree (iconic_image_id);


--
-- Name: the_histories_temporal_object_id; Type: INDEX; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE INDEX the_histories_temporal_object_id ON saintlouisdev.the_histories USING btree (temporal_object_id);


--
-- Name: the_shapes_shape_id; Type: INDEX; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE INDEX the_shapes_shape_id ON saintlouisdev.the_shapes USING btree (shape_id);


--
-- Name: the_statics_static_id; Type: INDEX; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE INDEX the_statics_static_id ON saintlouisdev.the_statics USING btree (static_id);


--
-- Name: the_statics_static_type_id; Type: INDEX; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE INDEX the_statics_static_type_id ON saintlouisdev.the_statics USING btree (static_type_id);


--
-- Name: the_streetsegments_geo_streetsegment_id; Type: INDEX; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE INDEX the_streetsegments_geo_streetsegment_id ON saintlouisdev.the_streetsegments USING btree (geo_streetsegment_id);


--
-- Name: the_streetsegments_streetsegment_id; Type: INDEX; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE INDEX the_streetsegments_streetsegment_id ON saintlouisdev.the_streetsegments USING btree (streetsegment_id);


--
-- Name: the_streetsegments_vc_streetname_id; Type: INDEX; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE INDEX the_streetsegments_vc_streetname_id ON saintlouisdev.the_streetsegments USING btree (vc_streetname_id);


--
-- Name: vc_addresses_vc_streetname_id; Type: INDEX; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE INDEX vc_addresses_vc_streetname_id ON saintlouisdev.vc_addresses USING btree (vc_streetname_id);


--
-- Name: vc_dpw_buildingdata_building_id; Type: INDEX; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE INDEX vc_dpw_buildingdata_building_id ON saintlouisdev.vc_dpw_buildingdata USING btree (building_id);


--
-- Name: walks_geo_side_id; Type: INDEX; Schema: saintlouisdev; Owner: saintlouisdev
--

CREATE INDEX walks_geo_side_id ON saintlouisdev.walks USING btree (geo_side_id);


--
-- Name: auth_group_permissions auth_group_permissions_group_id_fkey; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.auth_group_permissions
    ADD CONSTRAINT auth_group_permissions_group_id_fkey FOREIGN KEY (group_id) REFERENCES saintlouisdev.auth_group(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: auth_group_permissions auth_group_permissions_permission_id_fkey; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.auth_group_permissions
    ADD CONSTRAINT auth_group_permissions_permission_id_fkey FOREIGN KEY (permission_id) REFERENCES saintlouisdev.auth_permission(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: auth_message auth_message_user_id_fkey; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.auth_message
    ADD CONSTRAINT auth_message_user_id_fkey FOREIGN KEY (user_id) REFERENCES saintlouisdev.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: auth_user_groups auth_user_groups_group_id_fkey; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.auth_user_groups
    ADD CONSTRAINT auth_user_groups_group_id_fkey FOREIGN KEY (group_id) REFERENCES saintlouisdev.auth_group(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: auth_user_groups auth_user_groups_user_id_fkey; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.auth_user_groups
    ADD CONSTRAINT auth_user_groups_user_id_fkey FOREIGN KEY (user_id) REFERENCES saintlouisdev.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: auth_user_user_permissions auth_user_user_permissions_permission_id_fkey; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.auth_user_user_permissions
    ADD CONSTRAINT auth_user_user_permissions_permission_id_fkey FOREIGN KEY (permission_id) REFERENCES saintlouisdev.auth_permission(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: auth_user_user_permissions auth_user_user_permissions_user_id_fkey; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.auth_user_user_permissions
    ADD CONSTRAINT auth_user_user_permissions_user_id_fkey FOREIGN KEY (user_id) REFERENCES saintlouisdev.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: blocks blocks_temporalobject_ptr_id_fkey; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.blocks
    ADD CONSTRAINT blocks_temporalobject_ptr_id_fkey FOREIGN KEY (temporalobject_ptr_id) REFERENCES saintlouisdev.temporal_objects(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: building_forms building_forms_building_id_fkey; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.building_forms
    ADD CONSTRAINT building_forms_building_id_fkey FOREIGN KEY (building_id) REFERENCES saintlouisdev.buildings(temporalobject_ptr_id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: building_parts building_parts_building_id_fkey; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.building_parts
    ADD CONSTRAINT building_parts_building_id_fkey FOREIGN KEY (building_id) REFERENCES saintlouisdev.buildings(temporalobject_ptr_id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: building_parts building_parts_temporalobject_ptr_id_fkey; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.building_parts
    ADD CONSTRAINT building_parts_temporalobject_ptr_id_fkey FOREIGN KEY (temporalobject_ptr_id) REFERENCES saintlouisdev.temporal_objects(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: buildings_geo_front buildings_geo_front_building_id_fkey; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.buildings_geo_front
    ADD CONSTRAINT buildings_geo_front_building_id_fkey FOREIGN KEY (building_id) REFERENCES saintlouisdev.buildings(temporalobject_ptr_id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: buildings_geo_front buildings_geo_front_geofront_id_fkey; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.buildings_geo_front
    ADD CONSTRAINT buildings_geo_front_geofront_id_fkey FOREIGN KEY (geofront_id) REFERENCES saintlouisdev.geo_fronts(temporalobject_ptr_id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: buildings buildings_temporalobject_ptr_id_fkey; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.buildings
    ADD CONSTRAINT buildings_temporalobject_ptr_id_fkey FOREIGN KEY (temporalobject_ptr_id) REFERENCES saintlouisdev.temporal_objects(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: cesium_entities cesium_entity_temporalobject_ptr_id_fkey; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.cesium_entities
    ADD CONSTRAINT cesium_entity_temporalobject_ptr_id_fkey FOREIGN KEY (temporalobject_ptr_id) REFERENCES saintlouisdev.temporal_objects(id);


--
-- Name: city_networks city_networks_geo_streetsegment_id_fkey; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.city_networks
    ADD CONSTRAINT city_networks_geo_streetsegment_id_fkey FOREIGN KEY (geo_streetsegment_id) REFERENCES saintlouisdev.geo_streetsegments(temporalobject_ptr_id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: city_networks city_networks_temporalobject_ptr_id_fkey; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.city_networks
    ADD CONSTRAINT city_networks_temporalobject_ptr_id_fkey FOREIGN KEY (temporalobject_ptr_id) REFERENCES saintlouisdev.temporal_objects(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: auth_permission content_type_id_refs_id_728de91f; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.auth_permission
    ADD CONSTRAINT content_type_id_refs_id_728de91f FOREIGN KEY (content_type_id) REFERENCES saintlouisdev.django_content_type(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: django_admin_log django_admin_log_content_type_id_fkey; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.django_admin_log
    ADD CONSTRAINT django_admin_log_content_type_id_fkey FOREIGN KEY (content_type_id) REFERENCES saintlouisdev.django_content_type(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: django_admin_log django_admin_log_user_id_fkey; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.django_admin_log
    ADD CONSTRAINT django_admin_log_user_id_fkey FOREIGN KEY (user_id) REFERENCES saintlouisdev.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: dynamics dynamics_temporalobject_ptr_id_fkey; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.dynamics
    ADD CONSTRAINT dynamics_temporalobject_ptr_id_fkey FOREIGN KEY (temporalobject_ptr_id) REFERENCES saintlouisdev.temporal_objects(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: external_id external_id_temporal_object_id_fkey; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.external_id
    ADD CONSTRAINT external_id_temporal_object_id_fkey FOREIGN KEY (temporal_object_id) REFERENCES saintlouisdev.temporal_objects(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: fronts fronts_temporalobject_ptr_id_fkey; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.fronts
    ADD CONSTRAINT fronts_temporalobject_ptr_id_fkey FOREIGN KEY (temporalobject_ptr_id) REFERENCES saintlouisdev.temporal_objects(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: geo_blocks geo_blocks_block_id_fkey; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.geo_blocks
    ADD CONSTRAINT geo_blocks_block_id_fkey FOREIGN KEY (block_id) REFERENCES saintlouisdev.blocks(temporalobject_ptr_id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: geo_blocks_geo_front geo_blocks_geo_front_geoblock_id_fkey; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.geo_blocks_geo_front
    ADD CONSTRAINT geo_blocks_geo_front_geoblock_id_fkey FOREIGN KEY (geoblock_id) REFERENCES saintlouisdev.geo_blocks(temporalobject_ptr_id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: geo_blocks_geo_front geo_blocks_geo_front_geofront_id_fkey; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.geo_blocks_geo_front
    ADD CONSTRAINT geo_blocks_geo_front_geofront_id_fkey FOREIGN KEY (geofront_id) REFERENCES saintlouisdev.geo_fronts(temporalobject_ptr_id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: geo_blocks geo_blocks_temporalobject_ptr_id_fkey; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.geo_blocks
    ADD CONSTRAINT geo_blocks_temporalobject_ptr_id_fkey FOREIGN KEY (temporalobject_ptr_id) REFERENCES saintlouisdev.temporal_objects(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: geo_dynamics geo_dynamics_dynamic_id_fkey; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.geo_dynamics
    ADD CONSTRAINT geo_dynamics_dynamic_id_fkey FOREIGN KEY (dynamic_id) REFERENCES saintlouisdev.dynamics(temporalobject_ptr_id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: geo_dynamics geo_dynamics_temporalobject_ptr_id_fkey; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.geo_dynamics
    ADD CONSTRAINT geo_dynamics_temporalobject_ptr_id_fkey FOREIGN KEY (temporalobject_ptr_id) REFERENCES saintlouisdev.temporal_objects(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: geo_footprints geo_footprints_building_id_fkey; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.geo_footprints
    ADD CONSTRAINT geo_footprints_building_id_fkey FOREIGN KEY (building_id) REFERENCES saintlouisdev.buildings(temporalobject_ptr_id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: geo_footprints geo_footprints_foundation_texture_id_fkey; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.geo_footprints
    ADD CONSTRAINT geo_footprints_foundation_texture_id_fkey FOREIGN KEY (foundation_texture_id) REFERENCES saintlouisdev.textures(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: geo_footprints geo_footprints_front_texture_id_fkey; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.geo_footprints
    ADD CONSTRAINT geo_footprints_front_texture_id_fkey FOREIGN KEY (front_texture_id) REFERENCES saintlouisdev.textures(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: geo_footprints geo_footprints_roof_texture_id_fkey; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.geo_footprints
    ADD CONSTRAINT geo_footprints_roof_texture_id_fkey FOREIGN KEY (roof_texture_id) REFERENCES saintlouisdev.textures(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: geo_footprints geo_footprints_temporalobject_ptr_id_fkey; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.geo_footprints
    ADD CONSTRAINT geo_footprints_temporalobject_ptr_id_fkey FOREIGN KEY (temporalobject_ptr_id) REFERENCES saintlouisdev.temporal_objects(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: geo_footprints geo_footprints_wall_texture_id_fkey; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.geo_footprints
    ADD CONSTRAINT geo_footprints_wall_texture_id_fkey FOREIGN KEY (wall_texture_id) REFERENCES saintlouisdev.textures(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: geo_fronts_address geo_fronts_address_geofront_id_fkey; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.geo_fronts_address
    ADD CONSTRAINT geo_fronts_address_geofront_id_fkey FOREIGN KEY (geofront_id) REFERENCES saintlouisdev.geo_fronts(temporalobject_ptr_id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: geo_fronts_address geo_fronts_address_vcaddress_id_fkey; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.geo_fronts_address
    ADD CONSTRAINT geo_fronts_address_vcaddress_id_fkey FOREIGN KEY (vcaddress_id) REFERENCES saintlouisdev.vc_addresses(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: geo_fronts geo_fronts_front_id_fkey; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.geo_fronts
    ADD CONSTRAINT geo_fronts_front_id_fkey FOREIGN KEY (front_id) REFERENCES saintlouisdev.fronts(temporalobject_ptr_id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: geo_fronts geo_fronts_temporalobject_ptr_id_fkey; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.geo_fronts
    ADD CONSTRAINT geo_fronts_temporalobject_ptr_id_fkey FOREIGN KEY (temporalobject_ptr_id) REFERENCES saintlouisdev.temporal_objects(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: geo_intersections geo_intersections_temporalobject_ptr_id_fkey; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.geo_intersections
    ADD CONSTRAINT geo_intersections_temporalobject_ptr_id_fkey FOREIGN KEY (temporalobject_ptr_id) REFERENCES saintlouisdev.temporal_objects(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: geo_meshes geo_meshes_building_id_fkey1; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.geo_meshes
    ADD CONSTRAINT geo_meshes_building_id_fkey1 FOREIGN KEY (building_id) REFERENCES saintlouisdev.buildings(temporalobject_ptr_id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: geo_meshes geo_meshes_temporalobject_ptr_id_fkey1; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.geo_meshes
    ADD CONSTRAINT geo_meshes_temporalobject_ptr_id_fkey1 FOREIGN KEY (temporalobject_ptr_id) REFERENCES saintlouisdev.temporal_objects(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: geo_protos geo_protos_building_id_fkey; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.geo_protos
    ADD CONSTRAINT geo_protos_building_id_fkey FOREIGN KEY (building_id) REFERENCES saintlouisdev.buildings(temporalobject_ptr_id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: geo_protos geo_protos_temporalobject_ptr_id_fkey; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.geo_protos
    ADD CONSTRAINT geo_protos_temporalobject_ptr_id_fkey FOREIGN KEY (temporalobject_ptr_id) REFERENCES saintlouisdev.temporal_objects(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: geo_shapes geo_shapes_shape_id_fkey; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.geo_shapes
    ADD CONSTRAINT geo_shapes_shape_id_fkey FOREIGN KEY (shape_id) REFERENCES saintlouisdev.shapes(temporalobject_ptr_id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: geo_shapes geo_shapes_temporalobject_ptr_id_fkey; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.geo_shapes
    ADD CONSTRAINT geo_shapes_temporalobject_ptr_id_fkey FOREIGN KEY (temporalobject_ptr_id) REFERENCES saintlouisdev.temporal_objects(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: geo_sides geo_sides_geo_block_id_fkey; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.geo_sides
    ADD CONSTRAINT geo_sides_geo_block_id_fkey FOREIGN KEY (geo_block_id) REFERENCES saintlouisdev.geo_blocks(temporalobject_ptr_id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: geo_statics geo_statics_static_id_fkey; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.geo_statics
    ADD CONSTRAINT geo_statics_static_id_fkey FOREIGN KEY (static_id) REFERENCES saintlouisdev.statics(temporalobject_ptr_id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: geo_statics geo_statics_temporalobject_ptr_id_fkey; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.geo_statics
    ADD CONSTRAINT geo_statics_temporalobject_ptr_id_fkey FOREIGN KEY (temporalobject_ptr_id) REFERENCES saintlouisdev.temporal_objects(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: geo_streets geo_streets_temporalobject_ptr_id_fkey; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.geo_streets
    ADD CONSTRAINT geo_streets_temporalobject_ptr_id_fkey FOREIGN KEY (temporalobject_ptr_id) REFERENCES saintlouisdev.temporal_objects(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: geo_streetsegments geo_streetsegments_streetsegment_id_fkey; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.geo_streetsegments
    ADD CONSTRAINT geo_streetsegments_streetsegment_id_fkey FOREIGN KEY (streetsegment_id) REFERENCES saintlouisdev.streetsegments(temporalobject_ptr_id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: geo_streetsegments geo_streetsegments_temporalobject_ptr_id_fkey; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.geo_streetsegments
    ADD CONSTRAINT geo_streetsegments_temporalobject_ptr_id_fkey FOREIGN KEY (temporalobject_ptr_id) REFERENCES saintlouisdev.temporal_objects(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: ground_overlays ground_overlays_temporalobject_ptr_id_fkey1; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.ground_overlays
    ADD CONSTRAINT ground_overlays_temporalobject_ptr_id_fkey1 FOREIGN KEY (temporalobject_ptr_id) REFERENCES saintlouisdev.temporal_objects(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: images_temporal_object images_temporal_object_image_id_fkey; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.images_temporal_object
    ADD CONSTRAINT images_temporal_object_image_id_fkey FOREIGN KEY (image_id) REFERENCES saintlouisdev.images(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: images_temporal_object images_temporal_object_temporalobject_id_fkey; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.images_temporal_object
    ADD CONSTRAINT images_temporal_object_temporalobject_id_fkey FOREIGN KEY (temporalobject_id) REFERENCES saintlouisdev.temporal_objects(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: object_relations object_relations_from_object_id_fkey; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.object_relations
    ADD CONSTRAINT object_relations_from_object_id_fkey FOREIGN KEY (from_object_id) REFERENCES saintlouisdev.temporal_objects(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: object_relations object_relations_to_object_id_fkey; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.object_relations
    ADD CONSTRAINT object_relations_to_object_id_fkey FOREIGN KEY (to_object_id) REFERENCES saintlouisdev.temporal_objects(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: object_textures object_textures_temporal_object_id_fkey; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.object_textures
    ADD CONSTRAINT object_textures_temporal_object_id_fkey FOREIGN KEY (temporal_object_id) REFERENCES saintlouisdev.temporal_objects(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: temporal_objects object_type_id_refs_id_316b80df; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.temporal_objects
    ADD CONSTRAINT object_type_id_refs_id_316b80df FOREIGN KEY (object_type_id) REFERENCES saintlouisdev.object_types(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: people people_geo_dynamic_id_fkey; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.people
    ADD CONSTRAINT people_geo_dynamic_id_fkey FOREIGN KEY (geo_dynamic_id) REFERENCES saintlouisdev.geo_dynamics(temporalobject_ptr_id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: people people_temporalobject_ptr_id_fkey; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.people
    ADD CONSTRAINT people_temporalobject_ptr_id_fkey FOREIGN KEY (temporalobject_ptr_id) REFERENCES saintlouisdev.temporal_objects(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: points_point points_point_polyline_id_fkey; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.points_point
    ADD CONSTRAINT points_point_polyline_id_fkey FOREIGN KEY (polyline_id) REFERENCES saintlouisdev.points_polyline(id) ON DELETE CASCADE;


--
-- Name: points_polyline points_polyline_geo_streets_id_fkey; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.points_polyline
    ADD CONSTRAINT points_polyline_geo_streets_id_fkey FOREIGN KEY (geo_streets_id) REFERENCES saintlouisdev.geo_streets(temporalobject_ptr_id) ON DELETE CASCADE;


--
-- Name: object_relations relation_id_refs_id_58f9de56; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.object_relations
    ADD CONSTRAINT relation_id_refs_id_58f9de56 FOREIGN KEY (relation_id) REFERENCES saintlouisdev.relations(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: roof_types roof_types_material_id_fkey; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.roof_types
    ADD CONSTRAINT roof_types_material_id_fkey FOREIGN KEY (material_id) REFERENCES saintlouisdev.materials(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: shapes shapes_temporalobject_ptr_id_fkey; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.shapes
    ADD CONSTRAINT shapes_temporalobject_ptr_id_fkey FOREIGN KEY (temporalobject_ptr_id) REFERENCES saintlouisdev.temporal_objects(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: the_statics static_type_id_refs_id_4deaa003; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.the_statics
    ADD CONSTRAINT static_type_id_refs_id_4deaa003 FOREIGN KEY (static_type_id) REFERENCES saintlouisdev.static_types(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: statics statics_temporalobject_ptr_id_fkey; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.statics
    ADD CONSTRAINT statics_temporalobject_ptr_id_fkey FOREIGN KEY (temporalobject_ptr_id) REFERENCES saintlouisdev.temporal_objects(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: streetsegments streetsegments_temporalobject_ptr_id_fkey; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.streetsegments
    ADD CONSTRAINT streetsegments_temporalobject_ptr_id_fkey FOREIGN KEY (temporalobject_ptr_id) REFERENCES saintlouisdev.temporal_objects(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: temporal_objects temporal_objects_end_date_id_fkey; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.temporal_objects
    ADD CONSTRAINT temporal_objects_end_date_id_fkey FOREIGN KEY (end_date_id) REFERENCES saintlouisdev.vc_dates(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: temporal_objects temporal_objects_start_date_id_fkey; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.temporal_objects
    ADD CONSTRAINT temporal_objects_start_date_id_fkey FOREIGN KEY (start_date_id) REFERENCES saintlouisdev.vc_dates(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: the_blocks the_blocks_block_id_fkey; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.the_blocks
    ADD CONSTRAINT the_blocks_block_id_fkey FOREIGN KEY (block_id) REFERENCES saintlouisdev.blocks(temporalobject_ptr_id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: the_blocks the_blocks_temporalobject_ptr_id_fkey; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.the_blocks
    ADD CONSTRAINT the_blocks_temporalobject_ptr_id_fkey FOREIGN KEY (temporalobject_ptr_id) REFERENCES saintlouisdev.temporal_objects(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: the_buildings the_buildings_building_id_fkey; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.the_buildings
    ADD CONSTRAINT the_buildings_building_id_fkey FOREIGN KEY (building_id) REFERENCES saintlouisdev.buildings(temporalobject_ptr_id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: the_buildings the_buildings_temporalobject_ptr_id_fkey; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.the_buildings
    ADD CONSTRAINT the_buildings_temporalobject_ptr_id_fkey FOREIGN KEY (temporalobject_ptr_id) REFERENCES saintlouisdev.temporal_objects(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: the_dynamics the_dynamics_dynamic_id_fkey; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.the_dynamics
    ADD CONSTRAINT the_dynamics_dynamic_id_fkey FOREIGN KEY (dynamic_id) REFERENCES saintlouisdev.dynamics(temporalobject_ptr_id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: the_dynamics the_dynamics_temporalobject_ptr_id_fkey; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.the_dynamics
    ADD CONSTRAINT the_dynamics_temporalobject_ptr_id_fkey FOREIGN KEY (temporalobject_ptr_id) REFERENCES saintlouisdev.temporal_objects(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: the_externals the_externals_the_history_id_fkey; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.the_externals
    ADD CONSTRAINT the_externals_the_history_id_fkey FOREIGN KEY (the_history_id) REFERENCES saintlouisdev.the_histories(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: the_fronts the_fronts_front_id_fkey; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.the_fronts
    ADD CONSTRAINT the_fronts_front_id_fkey FOREIGN KEY (front_id) REFERENCES saintlouisdev.fronts(temporalobject_ptr_id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: the_fronts the_fronts_temporalobject_ptr_id_fkey; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.the_fronts
    ADD CONSTRAINT the_fronts_temporalobject_ptr_id_fkey FOREIGN KEY (temporalobject_ptr_id) REFERENCES saintlouisdev.temporal_objects(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: the_histories the_histories_temporal_object_id_fkey; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.the_histories
    ADD CONSTRAINT the_histories_temporal_object_id_fkey FOREIGN KEY (temporal_object_id) REFERENCES saintlouisdev.temporal_objects(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: the_shapes the_shapes_shape_id_fkey; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.the_shapes
    ADD CONSTRAINT the_shapes_shape_id_fkey FOREIGN KEY (shape_id) REFERENCES saintlouisdev.shapes(temporalobject_ptr_id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: the_shapes the_shapes_temporalobject_ptr_id_fkey; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.the_shapes
    ADD CONSTRAINT the_shapes_temporalobject_ptr_id_fkey FOREIGN KEY (temporalobject_ptr_id) REFERENCES saintlouisdev.temporal_objects(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: the_statics the_statics_static_id_fkey; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.the_statics
    ADD CONSTRAINT the_statics_static_id_fkey FOREIGN KEY (static_id) REFERENCES saintlouisdev.statics(temporalobject_ptr_id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: the_statics the_statics_temporalobject_ptr_id_fkey; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.the_statics
    ADD CONSTRAINT the_statics_temporalobject_ptr_id_fkey FOREIGN KEY (temporalobject_ptr_id) REFERENCES saintlouisdev.temporal_objects(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: the_streetsegments the_streetsegments_geo_streetsegment_id_fkey; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.the_streetsegments
    ADD CONSTRAINT the_streetsegments_geo_streetsegment_id_fkey FOREIGN KEY (geo_streetsegment_id) REFERENCES saintlouisdev.geo_streetsegments(temporalobject_ptr_id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: the_streetsegments the_streetsegments_streetsegment_id_fkey; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.the_streetsegments
    ADD CONSTRAINT the_streetsegments_streetsegment_id_fkey FOREIGN KEY (streetsegment_id) REFERENCES saintlouisdev.streetsegments(temporalobject_ptr_id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: the_streetsegments the_streetsegments_temporalobject_ptr_id_fkey; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.the_streetsegments
    ADD CONSTRAINT the_streetsegments_temporalobject_ptr_id_fkey FOREIGN KEY (temporalobject_ptr_id) REFERENCES saintlouisdev.temporal_objects(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: transforms transforms_temporal_object_id_fkey; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.transforms
    ADD CONSTRAINT transforms_temporal_object_id_fkey FOREIGN KEY (temporal_object_id) REFERENCES saintlouisdev.temporal_objects(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: vc_dpw_buildingdata vc_dpw_buildingdata_building_id_fkey; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.vc_dpw_buildingdata
    ADD CONSTRAINT vc_dpw_buildingdata_building_id_fkey FOREIGN KEY (building_id) REFERENCES saintlouisdev.buildings(temporalobject_ptr_id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: the_streetsegments vc_streetname_id_refs_id_1fe00f4b; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.the_streetsegments
    ADD CONSTRAINT vc_streetname_id_refs_id_1fe00f4b FOREIGN KEY (vc_streetname_id) REFERENCES saintlouisdev.vc_streetnames(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: geo_sides vc_streetname_id_refs_id_29353dfb; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.geo_sides
    ADD CONSTRAINT vc_streetname_id_refs_id_29353dfb FOREIGN KEY (vc_streetname_id) REFERENCES saintlouisdev.vc_streetnames(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: vc_addresses vc_streetname_id_refs_id_77eb0290; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.vc_addresses
    ADD CONSTRAINT vc_streetname_id_refs_id_77eb0290 FOREIGN KEY (vc_streetname_id) REFERENCES saintlouisdev.vc_streetnames(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: geo_streetsegments vc_streetname_id_refs_id_b0961ed; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.geo_streetsegments
    ADD CONSTRAINT vc_streetname_id_refs_id_b0961ed FOREIGN KEY (vc_streetname_id) REFERENCES saintlouisdev.vc_streetnames(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: geo_streets vc_streetname_id_refs_id_e3e0063; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.geo_streets
    ADD CONSTRAINT vc_streetname_id_refs_id_e3e0063 FOREIGN KEY (vc_streetname_id) REFERENCES saintlouisdev.vc_streetnames(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: viewpoints viewpoints_temporalobject_ptr_id_fkey; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.viewpoints
    ADD CONSTRAINT viewpoints_temporalobject_ptr_id_fkey FOREIGN KEY (temporalobject_ptr_id) REFERENCES saintlouisdev.temporal_objects(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: walks walks_geo_side_id_fkey; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.walks
    ADD CONSTRAINT walks_geo_side_id_fkey FOREIGN KEY (geo_side_id) REFERENCES saintlouisdev.geo_sides(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: walks walks_temporalobject_ptr_id_fkey; Type: FK CONSTRAINT; Schema: saintlouisdev; Owner: saintlouisdev
--

ALTER TABLE ONLY saintlouisdev.walks
    ADD CONSTRAINT walks_temporalobject_ptr_id_fkey FOREIGN KEY (temporalobject_ptr_id) REFERENCES saintlouisdev.temporal_objects(id) DEFERRABLE INITIALLY DEFERRED;


--
-- PostgreSQL database dump complete
--