Baselight

Carriageway And Footway Surface Defects

OpenDataNI

@ukgov.surface_defects

Surface Defects 2024/2025
@ukgov.surface_defects.surface_defects_2024_2025

Surface Defects recorded between 1st April 2024 to 31st March 2025

  • 4.24 MB
  • 122488 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

DCD259196621CONCRETE DEFECTIVE (FCDF)7035F0803_06_3 RODNEY DR BE N1:EASTERN DIVISIONBELFAST NORTH10/01/2025 10:41:00Archive331630372980R3 - 4 Weeks10/01/2025 10:54:20Footpath
DCD259196626CONCRETE DEFECTIVE (FCDF)7035F0803_06_3 RODNEY DR BE N1:EASTERN DIVISIONBELFAST NORTH10/01/2025 10:44:00Archive331642373021R3 - 4 Weeks10/01/2025 10:54:20Footpath
DCD249108378CONCRETE DEFECTIVE (FCDF)7035F0803_06_3 RODNEY DR BE N1:EASTERN DIVISIONBELFAST NORTH01/07/2024 12:56:00Archive331642373023R3 - 4 Weeks01/07/2024 14:28:35Footpath
DCD259196630CONCRETE DEFECTIVE (FCDF)7035F0803_06_3 RODNEY DR BE N1:EASTERN DIVISIONBELFAST NORTH10/01/2025 10:47:00Completed331634372991R2 - 5 Working days16/01/2025 12:00:00Footpath
DCD259211447CONCRETE DEFECTIVE (FCDF)7035F0624_07_2 WELLINGTON CRT FP1:EASTERN DIVISIONBELFAST NORTH06/02/2025 12:19:00Completed333675373968R2 - 5 Working days12/02/2025 00:00:00Footpath
DCD259211443CONCRETE DEFECTIVE (FCDF)7035F0624_07_2 WELLINGTON CRT FP1:EASTERN DIVISIONBELFAST NORTH06/02/2025 12:17:00Completed333666373966R2 - 5 Working days12/02/2025 00:00:00Footpath
DCD249173057CONCRETE POTHOLE (CCPH)7035F0624_07_2 WELLINGTON CRT FP1:EASTERN DIVISIONBELFAST NORTH11/11/2024 11:47:00Completed333664373966R2 - 5 Working days12/11/2024 00:00:00Footpath
DCD249173060CONCRETE POTHOLE (CCPH)7035F0624_07_2 WELLINGTON CRT FP1:EASTERN DIVISIONBELFAST NORTH11/11/2024 11:49:00Completed333669373967R2 - 5 Working days12/11/2024 00:00:00Footpath
DCD249184446CONCRETE DEFECTIVE (FCDF)7035F0801_13_04 FALCARRAGH DR FP S1:EASTERN DIVISIONBELFAST NORTH03/12/2024 10:37:00Archive328349371138R3 - 4 Weeks03/12/2024 10:50:44Footpath
DCD249088890CONCRETE DEFECTIVE (FCDF)7035F0841_05_2 SANDYMOUNT ST BE N1:EASTERN DIVISIONBELFAST SOUTH29/05/2024 10:12:00Completed333587371989R2 - 5 Working days03/06/2024 12:00:00Footpath

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