ADDRESSBASE Database Tables

Copy 
CREATE TABLE tablename
(
  address character varying(255),
  uprn bigint NOT NULL,
  os_address_toid character varying(20),
  rm_udprn bigint,
  organisation_name character varying(60),
  department_name character varying(60),
  po_box_number character varying(6),
  building_name character varying(50),
  sub_building_name character varying(30),
  building_number integer,
  dependent_thoroughfare_name character varying(80),
  thoroughfare_name character varying(80),
  post_town character varying(35),
  double_dependent_locality character varying(35),
  dependent_locality character varying(35),
  postcode character(8),
  postcode_type character(1),
  x_coordinate double precision NOT NULL,
  y_coordinate double precision NOT NULL,
  rpc smallint NOT NULL,
  change_type character(1) NOT NULL,
  start_date date NOT NULL,
  last_update_date date NOT NULL,
  entry_date date,
  classification character(1) NOT NULL,
  process_date date,
  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:

  • organisation_name
  • department_name
  • po_box_number
  • building_name
  • sub_building_name
  • building_number
  • dependent_thoroughfare_name
  • thoroughfare_name
  • post_town
  • double_dependent_locality
  • dependent_locality
  • postcode
  • x_coordinate
  • y_coordinate

AddressBase classifications consist of just nine Primary codes. These are mapped onto integers 1000, 2000, etc. to 9000. The OS class is also available in the table in column classification.