Baselight
Sign In

Carriageway And Footway Surface Defects

OpenDataNI

@ukgov.surface_defects

Surface Defects 2008/2009
@ukgov.surface_defects.surface_defects_2008_2009

Surface Defects recorded between 1st April 2008and 31st March 2009

  • 3.41 MB
  • 159531 rows
  • 9 columns
instruction_reference

INSTRUCTION REFERENCE

defect_detail

DEFECT DETAIL

section_name

SECTION NAME

division

DIVISION

section_office

SECTION OFFICE

recorded_date

RECORDED DATE

defect_status

DEFECT STATUS

easting

EASTING

northing

NORTHING

NORTH1691164BITMAC DEFECTIVE (CBDF)7020C0064_01 CREBILLY RD1: A36 LARNE RD TO BRIDGE OVER M2 BALLYMENA BALLYMENANORTHERN DIVISIONLARNE / BALLYMENA11/11/2008 11:46:24Archive311526402431
NORTH1713595ASPHALT POTHOLE (CAPH)7020A0523_04 QUEEN ST1: RAILWAY STREET TO ANTRIM RD [AT BALLEE BURN] BALLYMENANORTHERN DIVISIONLARNE / BALLYMENA12/02/2009 14:29:18Archive310586402918
NORTH1713598ASPHALT POTHOLE (CAPH)7020A0523_02 BRIDGE ST2: BRIDGE STREET LINK TO HARRYVILLE BRIDGE BALLYMENANORTHERN DIVISIONLARNE / BALLYMENA12/02/2009 14:29:18Archive310656403072
NORTH1713599ASPHALT POTHOLE (CAPH)7020A0523_02 BRIDGE ST2: BRIDGE STREET LINK TO HARRYVILLE BRIDGE BALLYMENANORTHERN DIVISIONLARNE / BALLYMENA12/02/2009 14:29:18Archive310656403072
NORTH1691189ASPHALT UNEVEN (CAUN)7020A0008_93 ANTIVILLE RBT1: BALLYMENA RD(05) TO BALLYMENA RD (05) LARNENORTHERN DIVISIONLARNE / BALLYMENA11/11/2008 14:07:52Archive338667402168
NORTH1713597ASPHALT POTHOLE (CAPH)7020A0523_03 HARRYVILLE BRIDGE1: BRIDGE STREET TO RAILWAY STREET BALLYMENANORTHERN DIVISIONLARNE / BALLYMENA12/02/2009 14:29:18Archive310584403007
NORTH1713587BITMAC POTHOLE (CBPH)7020A0523_04 QUEEN ST1: RAILWAY STREET TO ANTRIM RD [AT BALLEE BURN] BALLYMENANORTHERN DIVISIONLARNE / BALLYMENA12/02/2009 14:29:18Archive310586402918
NORTH1713588BITMAC POTHOLE (CBPH)7020A0523_04 QUEEN ST1: RAILWAY STREET TO ANTRIM RD [AT BALLEE BURN] BALLYMENANORTHERN DIVISIONLARNE / BALLYMENA12/02/2009 14:29:18Archive310586402918
NORTH1632350BITMAC POTHOLE (CBPH)7020A0036_05 MOORFIELDS RD2: BALLYKEEL RBT TO B59 TULLY RD (RHS) BALLYMENANORTHERN DIVISIONLARNE / BALLYMENA02/04/2008 14:36:09Archive312551401816
NORTH1632351BITMAC POTHOLE (CBPH)7020A0036_05 MOORFIELDS RD2: BALLYKEEL RBT TO B59 TULLY RD (RHS) BALLYMENANORTHERN DIVISIONLARNE / BALLYMENA02/04/2008 14:36:09Archive312551401816

CREATE TABLE surface_defects_2008_2009 (
  "instruction_reference" VARCHAR,
  "defect_detail" VARCHAR,
  "section_name" VARCHAR,
  "division" VARCHAR,
  "section_office" VARCHAR,
  "recorded_date" VARCHAR,
  "defect_status" VARCHAR,
  "easting" BIGINT,
  "northing" BIGINT
);

Share link

Anyone who has the link will be able to view this.