Jump to the following:

OS uses cookies to improve this website. Read about cookies

  • twitter
  • Google+
  • facebook

AddressBase Products

PostgreSQL AddressBase Premium SQL script requires minor adjustments

Sameer
    • 1 May 2019 09:50AM
    • 45 Views
    • Visits: 2
    • Discussions: 1
    • Responses: 0
    • Registered: 1 May 2019 09:26AM
    • Last active: 1 May 2019 03:08PM

    The CREATE TABLE statement for the "Street" record appears twice however the second one is correct as it contains column names for LAT/LON...


    --Street
    CREATE TABLE abp_street (
    RECORD_IDENTIFIER SMALLINT,
    CHANGE_TYPE CHARACTER VARYING(1),
    PRO_ORDER BIGINT,
    USRN INTEGER,
    RECORD_TYPE SMALLINT,
    SWA_ORG_REF_NAMING SMALLINT,
    STATE SMALLINT,
    STATE_DATE DATE,
    STREET_SURFACE SMALLINT,
    STREET_CLASSIFICATION SMALLINT,
    VERSION SMALLINT,
    STREET_START_DATE DATE,
    STREET_END_DATE DATE,
    LAST_UPDATE_DATE DATE,
    RECORD_ENTRY_DATE DATE,
    STREET_START_X DOUBLE PRECISION,
    STREET_START_Y DOUBLE PRECISION,
    STREET_END_X DOUBLE PRECISION,
    STREET_END_Y DOUBLE PRECISION,
    STREET_TOLERANCE SMALLINT
    );

    CREATE TABLE abp_street
    (
    RECORD_IDENTIFIER smallint,
    CHANGE_TYPE character varying(1),
    PRO_ORDER bigint,
    USRN integer,
    RECORD_TYPE smallint,
    SWA_ORG_REF_NAMING smallint,
    STATE smallint,
    STATE_DATE date,
    STREET_SURFACE smallint,
    STREET_CLASSIFICATION smallint,
    VERSION smallint,
    STREET_START_DATE date,
    STREET_END_DATE date,
    LAST_UPDATE_DATE date,
    RECORD_ENTRY_DATE date,
    STREET_START_X double precision,
    STREET_START_Y double precision,
    STREET_START_LAT double precision,
    STREET_START_LONG double precision,
    STREET_END_X double precision,
    STREET_END_Y double precision,
    STREET_END_LAT double precision,
    STREET_END_LONG double precision,
    STREET_TOLERANCE smallint
    );

    Thanks,
    Sameer

    No responses

    There may be responses for this discussion that are currently awaiting moderation and not visible yet.

    Please login or sign-up to respond to this discussion.

    © Ordnance Survey 2018