-
Notifications
You must be signed in to change notification settings - Fork 14
Missing four fields in CREATE TABLE abp_street #6
Description
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
)