Baselight
Sign In

Carriageway And Footway Surface Defects

OpenDataNI

@ukgov.surface_defects

Surface Defects 2020/2021
@ukgov.surface_defects.surface_defects_2020_2021

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

  • 4.09 MB
  • 108840 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

DCD27-3080867-17BITMAC POTHOLE (CBPH)7050C0537_01 CASTLEROE RD: CURRAGH RD TO CAMUS LNNORTHERN DIVISIONCAUSEWAY COAST and GLENS WEST10/04/2020 11:29:00R2. R3, R4 Awaiting Action286121428644
DCD27-3080867-44BITMAC POTHOLE (CBPH)7050U3346_01 THE RHEE1: CURRAGH RD TO CURRAGH RDNORTHERN DIVISIONCAUSEWAY COAST and GLENS WEST15/04/2020 12:37:00R2. R3, R4 Awaiting Action289716423843
DCD39-3080724-25BITMAC POTHOLE (CBPH)7060U8562_01 DERRYHENNETT RD1: B0132 03 MADDAN RD TO C0193 04 DRUMHILLERY RDSOUTHERN DIVISIONARMAGH CITY BANBRIDGE and CRAIGAVON WEST16/04/2020 10:29:00R2. R3, R4 Awaiting Action280806334956
DCD39-3080724-26BITMAC POTHOLE (CBPH)7060U8562_01 DERRYHENNETT RD1: B0132 03 MADDAN RD TO C0193 04 DRUMHILLERY RDSOUTHERN DIVISIONARMAGH CITY BANBRIDGE and CRAIGAVON WEST16/04/2020 10:30:00R2. R3, R4 Awaiting Action281117334947
DCD39-3080724-27BITMAC POTHOLE (CBPH)7060U8562_01 DERRYHENNETT RD1: B0132 03 MADDAN RD TO C0193 04 DRUMHILLERY RDSOUTHERN DIVISIONARMAGH CITY BANBRIDGE and CRAIGAVON WEST16/04/2020 10:37:00R2. R3, R4 Awaiting Action281212334973
DCD39-3080724-43BITMAC POTHOLE (CBPH)7060U8545_01 U85451: U8542 01 TIVNACREE RD N TO U8542 01 TIVNACREE RD SSOUTHERN DIVISIONARMAGH CITY BANBRIDGE and CRAIGAVON WEST17/04/2020 09:04:00R2. R3, R4 Awaiting Action279958332912
DCD39-3080724-44BITMAC POTHOLE (CBPH)7060U8545_01 U85451: U8542 01 TIVNACREE RD N TO U8542 01 TIVNACREE RD SSOUTHERN DIVISIONARMAGH CITY BANBRIDGE and CRAIGAVON WEST17/04/2020 09:05:00R2. R3, R4 Awaiting Action279934332942
DCD39-3080724-45BITMAC POTHOLE (CBPH)7060U8545_01 U85451: U8542 01 TIVNACREE RD N TO U8542 01 TIVNACREE RD SSOUTHERN DIVISIONARMAGH CITY BANBRIDGE and CRAIGAVON WEST17/04/2020 09:07:00R2. R3, R4 Awaiting Action279786332983
DCD39-3080724-46BITMAC POTHOLE (CBPH)7060U8545_01 U85451: U8542 01 TIVNACREE RD N TO U8542 01 TIVNACREE RD SSOUTHERN DIVISIONARMAGH CITY BANBRIDGE and CRAIGAVON WEST17/04/2020 09:09:00R2. R3, R4 Awaiting Action279751332993
DCD39-3080783-13BITMAC POTHOLE (CBPH)7060U8605_01 CURRAGH LN1: C0196 01 DERRYNOOSE RD TO U8603 01 MULLYARD RDSOUTHERN DIVISIONARMAGH CITY BANBRIDGE and CRAIGAVON WEST21/04/2020 08:35:00R2. R3, R4 Awaiting Action279752330259

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