Baselight
Sign In

Carriageway And Footway Surface Defects

OpenDataNI

@ukgov.surface_defects

Surface Defects 2025 To Date
@ukgov.surface_defects.surface_defects_2025_to_date

Surface Defects recorded between 1st April 2025 to date.

  • 550.18 KB
  • 13999 rows
  • 12 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

response_time_name

RESPONSE TIME NAME

actual_completion_date

ACTUAL COMPLETION DATE

class_name

CLASS NAME

DCD259253801BITMAC POTHOLE (CBPH)7125B0018_10 LOUP RD1: SPRINGHILL RD LHS TO BALLYGROOBY LN U2222WESTERN DIVISIONMID ULSTER NORTH01/04/2025 08:59:00Completed286915383509R2 - 5 Working days08/04/2025 00:00:00B Class
DCD259253851BITMAC POTHOLE (CBPH)7125B0160_04 ANNAGHQUIN RD1: BALLYNAKILLY RD LHS TO COOKSTOWN RDWESTERN DIVISIONMID ULSTER NORTH01/04/2025 09:37:00Completed278925370929R2 - 5 Working days04/04/2025 00:00:00B Class
DCD259253882BITMAC POTHOLE (CBPH)7065U7025_03 SEYMOUR PK2: END AT NO.13 TO END AT NO.28 (North to South)EASTERN DIVISIONCASTLEREAGH and LISBURN01/04/2025 09:47:00Completed327724363833R2 - 5 Working days08/04/2025 00:00:00Unclassified
DCD259253898BITMAC POTHOLE (CBPH)7125B0160_04 ANNAGHQUIN RD1: BALLYNAKILLY RD LHS TO COOKSTOWN RDWESTERN DIVISIONMID ULSTER NORTH01/04/2025 09:54:00Completed277818370930R2 - 5 Working days04/04/2025 00:00:00B Class
DCD259253917BITMAC POTHOLE (CBPH)7125B0160_04 ANNAGHQUIN RD1: BALLYNAKILLY RD LHS TO COOKSTOWN RDWESTERN DIVISIONMID ULSTER NORTH01/04/2025 09:57:00Completed277800370926R2 - 5 Working days04/04/2025 00:00:00B Class
DCD259253965BITMAC POTHOLE (CBPH)7060U6294_07 ERSKINE ST1: A0027 46 CANAL ST TO U6294 04 CANAL QUAYSOUTHERN DIVISIONNEWRY MOURNE and DOWN WEST01/04/2025 10:15:00Completed308521327051R2 - 5 Working days04/04/2025 00:00:00Unclassified
DCD259253984ASPHALT POTHOLE (CAPH)7035U0129_01 GLENCREGAGH RD1: UPPER KNOCKBREDA RD1 TO MANSE RD3EASTERN DIVISIONCASTLEREAGH and LISBURN01/04/2025 10:20:00Completed335595370361R1 - 1 Calendar Day02/04/2025 00:00:00Unclassified
DCD259254035BITMAC POTHOLE (FBPH)7065B0176_05 KILLOUGH RD1: BALLYNOE RD C286 TO ARDGLASS RD B1SOUTHERN DIVISIONNEWRY MOURNE and DOWN EAST01/04/2025 10:42:00Completed348796343440R2 - 5 Working days07/04/2025 00:00:00B Class
DCD259254049BITMAC POTHOLE (FBPH)7065B0176_05 KILLOUGH RD1: BALLYNOE RD C286 TO ARDGLASS RD B1SOUTHERN DIVISIONNEWRY MOURNE and DOWN EAST01/04/2025 10:47:00Completed348819343432R2 - 5 Working days07/04/2025 00:00:00B Class
DCD259254067ASPHALT POTHOLE (CAPH)7050C0577_06 INISCARN RD:SOUTHWAY TO EASTWAY RBTWESTERN DIVISIONLONDONDERRY and STRABANE01/04/2025 10:51:00Completed241840416104R2 - 5 Working days03/04/2025 00:00:00C Class

CREATE TABLE surface_defects_2025_to_date (
  "instruction_reference" VARCHAR,
  "defect_detail" VARCHAR,
  "section_name" VARCHAR,
  "division" VARCHAR,
  "section_office" VARCHAR,
  "recorded_date" VARCHAR,
  "defect_status" VARCHAR,
  "easting" BIGINT,
  "northing" BIGINT,
  "response_time_name" VARCHAR,
  "actual_completion_date" VARCHAR,
  "class_name" VARCHAR
);

Share link

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