Baselight
Sign In

Carriageway And Footway Surface Defects

OpenDataNI

@ukgov.surface_defects

Surface Defects 2013/2014
@ukgov.surface_defects.surface_defects_2013_2014

Surface Defects recorded between 1st April 2013 and 31st March 2014

  • 4.29 MB
  • 167546 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

WEST1702875BITMAC DEPRESSED (CBDP)7125U8477_01 TONAGH RD1: U8525 GLENLEVAN RD TO C446 GLENNASHEEVAR RD FERMANAGHWESTERN DIVISIONFERMANAGH & OMAGH (WEST)19/09/2013 09:40:47Further Information Required211461352619
WEST1702876BITMAC DEPRESSED (CBDP)7125U8477_01 TONAGH RD1: U8525 GLENLEVAN RD TO C446 GLENNASHEEVAR RD FERMANAGHWESTERN DIVISIONFERMANAGH & OMAGH (WEST)19/09/2013 09:40:47Further Information Required211461352619
WEST1702877BITMAC DEPRESSED (CBDP)7125U8477_01 TONAGH RD1: U8525 GLENLEVAN RD TO C446 GLENNASHEEVAR RD FERMANAGHWESTERN DIVISIONFERMANAGH & OMAGH (WEST)19/09/2013 09:40:47Further Information Required211461352619
DRDNI124570-1BITMAC POTHOLE (CBPH)7035B0502_04 AGNES ST2: CRUMLIN RD1 TO SHANKILL RD1 BELFAST NORTHEASTERN DIVISIONCASTLEREAGH / LISBURN15/10/2013 09:37:00Further Information Required328861349734
DRDNI124570-9BITMAC POTHOLE (CBPH)7060U1352_39 ROSE COTTAGES1: START SOUTH TO END NORTH CRAIGAVONEASTERN DIVISIONCASTLEREAGH / LISBURN15/10/2013 11:16:00Further Information Required331604359999
DRDNI124570-19BITMAC POTHOLE (CBPH)7035A0002_84 SYDENHAM BY-PASS1: START OF M3 (CITY BOUND) TO DEE ST BRIDGE BELFAST SOUTHEASTERN DIVISIONCASTLEREAGH / LISBURN16/10/2013 09:20:00Further Information Required329173360454
DRDNI124570-20BITMAC POTHOLE (CBPH)7060U4462_12 KONVER HTS1: U4072 01 HILL ST TO U4462 13 KONVER HTS BANBRIDGEEASTERN DIVISIONCASTLEREAGH / LISBURN16/10/2013 09:56:00Further Information Required329719359919
DRDNI124570-21BITMAC POTHOLE (CBPH)7060U4462_12 KONVER HTS1: U4072 01 HILL ST TO U4462 13 KONVER HTS BANBRIDGEEASTERN DIVISIONCASTLEREAGH / LISBURN16/10/2013 10:09:00Further Information Required329715359907
DRDNI124570-25BITMAC POTHOLE (CBPH)7035A0002_83 SYDENHAM BY-PASS1: BRIDGE END FLYOVER1 TO BRIDGE END1 BELFAST SOUTHEASTERN DIVISIONCASTLEREAGH / LISBURN16/10/2013 10:39:00Further Information Required331286357755
DRDNI124570-26BITMAC POTHOLE (CBPH)7035A0002_83 SYDENHAM BY-PASS1: BRIDGE END FLYOVER1 TO BRIDGE END1 BELFAST SOUTHEASTERN DIVISIONCASTLEREAGH / LISBURN16/10/2013 10:40:00Further Information Required331299357733

CREATE TABLE surface_defects_2013_2014 (
  "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.