Baselight
Sign In

Carriageway And Footway Surface Defects

OpenDataNI

@ukgov.surface_defects

Surface Defects 2021/2022
@ukgov.surface_defects.surface_defects_2021_2022

Surface Defects recorded between 1st April 2021 to 31st March 2022

  • 5.02 MB
  • 135855 rows
  • 11 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

DCD113-3088629-8ASPHALT POTHOLE (CAPH)7020B0095_04 GREYSTONE RD1: RATHBEG RBT TO END OF DUAL C'WAYNORTHERN DIVISIONANTRIM and NEWTOWNABBEY19/08/2021 11:10:00Completed318605387569R2 - 5 Working days06/09/2021 00:00:00
DCD101-3091664-9ASPHALT POTHOLE (CAPH)7020B0095_04 GREYSTONE RD1: RATHBEG RBT TO END OF DUAL C'WAYNORTHERN DIVISIONANTRIM and NEWTOWNABBEY02/03/2022 09:18:00Completed318684387746R2 - 5 Working days29/03/2022 00:00:00
DCD101-3091664-12ASPHALT POTHOLE (CAPH)7020B0095_04 GREYSTONE RD1: RATHBEG RBT TO END OF DUAL C'WAYNORTHERN DIVISIONANTRIM and NEWTOWNABBEY02/03/2022 09:26:00Completed318599387558R2 - 5 Working days29/03/2022 00:00:00
DCD101-3091664-11ASPHALT POTHOLE (CAPH)7020B0095_04 GREYSTONE RD1: RATHBEG RBT TO END OF DUAL C'WAYNORTHERN DIVISIONANTRIM and NEWTOWNABBEY02/03/2022 09:24:00Completed318608387575R2 - 5 Working days29/03/2022 00:00:00
DCD101-3091664-13ASPHALT POTHOLE (PAPH)7020B0095_04 GREYSTONE RD1: RATHBEG RBT TO END OF DUAL C'WAYNORTHERN DIVISIONANTRIM and NEWTOWNABBEY02/03/2022 09:29:00Completed318587387531R2 - 5 Working days29/03/2022 00:00:00
DCD101-3091664-14ASPHALT POTHOLE (CAPH)7020B0095_04 GREYSTONE RD1: RATHBEG RBT TO END OF DUAL C'WAYNORTHERN DIVISIONANTRIM and NEWTOWNABBEY02/03/2022 09:31:00Completed318572387498R2 - 5 Working days29/03/2022 00:00:00
DCD101-3091664-15ASPHALT POTHOLE (CAPH)7020B0095_04 GREYSTONE RD1: RATHBEG RBT TO END OF DUAL C'WAYNORTHERN DIVISIONANTRIM and NEWTOWNABBEY02/03/2022 09:35:00Completed318556387468R2 - 5 Working days29/03/2022 00:00:00
DCD101-3091664-10ASPHALT POTHOLE (CAPH)7020B0095_04 GREYSTONE RD1: RATHBEG RBT TO END OF DUAL C'WAYNORTHERN DIVISIONANTRIM and NEWTOWNABBEY02/03/2022 09:20:00Completed318666387710R2 - 5 Working days29/03/2022 00:00:00
DCD101-3091664-16ASPHALT POTHOLE (CAPH)7020B0095_04 GREYSTONE RD1: RATHBEG RBT TO END OF DUAL C'WAYNORTHERN DIVISIONANTRIM and NEWTOWNABBEY02/03/2022 09:40:00Completed318473387312R2 - 5 Working days29/03/2022 00:00:00
DCD113-3091108-12ASPHALT POTHOLE (CAPH)7020B0095_04 GREYSTONE RD1: RATHBEG RBT TO END OF DUAL C'WAYNORTHERN DIVISIONANTRIM and NEWTOWNABBEY14/01/2022 14:28:00Completed318533387432R2 - 5 Working days07/03/2022 00:00:00

CREATE TABLE surface_defects_2021_2022 (
  "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
);

Share link

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