Baselight
Sign In

Carriageway And Footway Surface Defects

OpenDataNI

@ukgov.surface_defects

Surface Defects 2022/2023
@ukgov.surface_defects.surface_defects_2022_2023

Surface Defects recorded between 1st April 2022 to 31st March 2023.

  • 5 MB
  • 134181 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

DCD238810580ASPHALT POTHOLE (CAPH)7060B0002_37 DROMORE RD2: B0009 01 NEW FORGE RD TO C0358 01 LISNASURE RDSOUTHERN DIVISIONARMAGH CITY BANBRIDGE and CRAIGAVON EAST24/02/2023 10:11:00Completed313777355166R2 - 5 Working days29/03/2023 00:00:00
DCD54-3101982-76BITMAC EDGE DETERIORATION (CBED)7125U8482_01 FASAGH RD1: C447 MELVIN RD TO U8498 MANGER RDWESTERN DIVISIONFERMANAGH and OMAGH WEST23/02/2023 13:31:00Completed191373356984R3 - 4 Weeks30/03/2023 00:00:00
DCD238810766ASPHALT POTHOLE (CAPH)7065A0025_24 DUBLIN RD RBT2: A0025 21 DUBLIN RD TO A0025 21 DUBLIN RDSOUTHERN DIVISIONNEWRY MOURNE and DOWN EAST24/02/2023 11:01:00Completed333750336050R2 - 5 Working days02/03/2023 00:00:00
DCD238811284ASPHALT POTHOLE (CAPH)7050A0026_05 UNION ST2: MILLBURN RD TO RAILWAY RDNORTHERN DIVISIONCAUSEWAY COAST and GLENS WEST25/02/2023 09:32:00Completed285277432708R2 - 5 Working days28/02/2023 00:00:00
DCD238811557BITMAC POTHOLE (CBPH)7050U3527_15 LOGUESTOWN IND EST: BUSHMILLS RD TO CUL DE SACNORTHERN DIVISIONCAUSEWAY COAST and GLENS WEST26/02/2023 12:39:00Completed285954433488R3 - 4 Weeks24/03/2023 00:00:00
DCD238811732BITMAC POTHOLE (CBPH)7060B0002_23 FRANCIS ST1: A0003 51 PORTADOWN RD TO C0706 01 KILN LNSOUTHERN DIVISIONARMAGH CITY BANBRIDGE and CRAIGAVON EAST27/02/2023 09:50:00Completed307334358396R2 - 5 Working days06/03/2023 00:00:00
DCD238811793ASPHALT POTHOLE (CAPH)7060B0002_23 FRANCIS ST1: A0003 51 PORTADOWN RD TO C0706 01 KILN LNSOUTHERN DIVISIONARMAGH CITY BANBRIDGE and CRAIGAVON EAST27/02/2023 10:19:00Completed307448358292R2 - 5 Working days06/03/2023 00:00:00
DCD238812000ASPHALT POTHOLE (FAPH)7035U0405_04 SANDYKNOWES AV1: SANDYKNOWES WAY1 TO ENDNORTHERN DIVISIONANTRIM and NEWTOWNABBEY27/02/2023 11:47:00Completed330598382781R3 - 4 Weeks21/04/2023 00:00:00
DCD238812545BITMAC POTHOLE (CBPH)7060C0316_02 CORCREAGHAN RD1: U6259 01 BALLYNAHATTEN RD TO U6253 01 DRUMMANMORE RDSOUTHERN DIVISIONNEWRY MOURNE and DOWN WEST28/02/2023 11:21:00Completed327773313300R2 - 5 Working days06/03/2023 00:00:00
DCD238812911BITMAC POTHOLE (FBPH)7065U6201_03 SLIEVECORRAGH AV1: SLIEVENAMADDY AV TO TULLYBRANNIGAN RDSOUTHERN DIVISIONNEWRY MOURNE and DOWN EAST28/02/2023 15:11:00Completed337099330891R3 - 4 Weeks27/03/2023 00:00:00

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