ADDRESSBASE PLUS Database

Copy 
CREATE TABLE tablename
(
  address character varying(255),
  uprn bigint NOT NULL,
  rm_udprn integer,
  change_type character(1) NOT NULL,
  state smallint,
  state_date date,
  classification character(6) NOT NULL,
  parent_uprn bigint,
  x_coordinate double precision NOT NULL,
  y_coordinate double precision NOT NULL,
  rpc smallint NOT NULL,
  local_custodian_code integer NOT NULL,
  start_date date NOT NULL,
  end_date date,
  last_update_date date NOT NULL,
  entry_date date,
  organisation_name character varying(100),
  blpu_organisation character varying(100),
  department_name character varying(60),
  scottish_department_name character varying(60),
  building_name character varying(100),
  sub_building_name character varying(30),
  sao_start_number integer,
  sao_start_suffix character(2),
  sao_end_number integer,
  sao_end_suffix character(2),
  sao_text character varying(90),
  alt_language_sao_text character varying(90),
  pao_start_number integer,
  pao_start_suffix character(2),
  pao_end_number integer,
  pao_end_suffix character(2),
  pao_text character varying(90),
  alt_language_pao_text character varying(90),
  usrn bigint NOT NULL,
  usrn_match_indicator character(1),
  area_name character varying(35),
  blpu_level character varying(30),
  official_flag character(1),
  os_address_toid character varying(20),
  os_address_toid_version integer,
  os_roadlink_toid character varying(20),
  os_roadlink_toid_version integer,
  os_topo_toid character varying(20),
  os_topo_toid_version integer,
  voa_ct_record bigint,
  voa_ndr_record bigint,
  street_description character varying(100),
  alt_language_street_description character varying(100),
  dependent_thoroughfare_name character varying(80),
  thoroughfare_name character varying(80),
  welsh_dependent_thoroughfare_name character varying(80),
  welsh_thoroughfare_name character varying(80),
  double_dependent_locality character varying(35),
  dependent_locality character varying(35),
  locality_name character varying(35),
  welsh_dependent_locality character varying(35),
  welsh_double_dependent_locality character varying(35),
  town_name character varying(30),
  administrative_area character varying(30),
  post_town character varying(35),
  postcode character(8),
  postcode_locator character(8),
  postcode_type character(1),
  postal_address character(1),
  po_box_number character varying(6),
  ward_code character varying(9),
  parish_code character varying(9),
  process_date date,
  multi_occ_count integer,
  voa_ndr_p_desc_code character varying(5),
  voa_ndr_scat_code character varying(4),
  alt_language character varying(3),
  feature_code integer,
  geometry geometry,
  CONSTRAINT tablename _pkey PRIMARY KEY (uprn)
)

The following columns are added by the Address Loader:

  • address
  • feature_code
  • geometry (except Microsoft Access)

The Address Loader will, if requested, create a ‘gazetteer-friendly’ view, i.e. one with no spatial column.

By default this view will contain the following columns:

  • x_coordinate
  • y_coordinate
  • organisation_name
  • blpu_organisation
  • department_name
  • scottish_department_name
  • building_name
  • sub_building_name
  • sao_start_number
  • sao_start_suffix
  • sao_end_number
  • sao_end_suffix
  • sao_text
  • alt_language_sao_text
  • pao_start_number
  • pao_start_suffix
  • pao_end_number
  • pao_end_suffix
  • pao_text
  • area_name
  • street_description
  • dependent_thoroughfare_name
  • thoroughfare_name
  • welsh_dependent_thoroughfare_name
  • welsh_thoroughfare_name
  • double_dependent_locality
  • dependent_locality
  • locality_name
  • welsh_dependent_locality
  • welsh_double_dependent_locality
  • town_name
  • administrative_area
  • post_town
  • postcode
  • postcode_locator
  • po_box_number
  • ward_code
  • parish_code
  • multi_occ_count

AddressBase Plus classifications consist of the nine Primary codes with Secondary codes.

The Address Loader creates feature codes based on just the Primary codes. The full OS class is available in the table in column classification.