Skip to content

Missing four fields in CREATE TABLE abp_street #6

Description

@golfalot

ref: OS_ABIslands_Ep84_05_2021_CSV_FULL/ID31_Org_Records.csv

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, -- missing
STREET_START_LONG DOUBLE PRECISION, -- missing
STREET_END_X DOUBLE PRECISION,
STREET_END_Y DOUBLE PRECISION,
STREET_END_LAT DOUBLE PRECISION, -- missing
STREET_END_LONG DOUBLE PRECISION, -- missing
STREET_TOLERANCE SMALLINT
)

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Fields

    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions