Baselight
Sign In

Carriageway And Footway Surface Defects

OpenDataNI

@ukgov.surface_defects

Surface Defects 2018/2019
@ukgov.surface_defects.surface_defects_2018_2019

Surface Defects recorded between 1st April 2018 to 31st March 2019

  • 5.04 MB
  • 159886 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

DCD43-3068716-38ASPHALT POTHOLE (CAPH)7050A0044_07 MAGHERAMORE RD3: LAGG RD TO ISLANDARRAGH RDNORTHERN DIVISIONCAUSEWAY COAST and GLENS EAST23/05/2018 15:52:00Works Order Issued307803436101
DCD124-3071761-74ASPHALT POTHOLE (CAPH)7050A0044_07 MAGHERAMORE RD3: LAGG RD TO ISLANDARRAGH RDNORTHERN DIVISIONCAUSEWAY COAST and GLENS EAST08/11/2018 11:01:00Completed307900436576
DCD124-3071761-81ASPHALT POTHOLE (CAPH)7050A0044_07 MAGHERAMORE RD3: LAGG RD TO ISLANDARRAGH RDNORTHERN DIVISIONCAUSEWAY COAST and GLENS EAST08/11/2018 12:03:00Completed307732435799
DCD124-3071761-82ASPHALT POTHOLE (CAPH)7050A0044_07 MAGHERAMORE RD3: LAGG RD TO ISLANDARRAGH RDNORTHERN DIVISIONCAUSEWAY COAST and GLENS EAST08/11/2018 12:07:00Completed307717435449
DCD124-3071761-83ASPHALT POTHOLE (CAPH)7050A0044_07 MAGHERAMORE RD3: LAGG RD TO ISLANDARRAGH RDNORTHERN DIVISIONCAUSEWAY COAST and GLENS EAST08/11/2018 12:09:00Completed307702435226
DCD89-3074023-42BITMAC POTHOLE (CBPH)7020U2049_01 CARMAGRIM LN1: U2047 CARMAGRIM RD TO U2046 PRIESTOWN RDNORTHERN DIVISIONMID and EAST ANTRIM20/02/2019 11:15:00Completed302029400514
DCD89-3073215-2BITMAC POTHOLE (CBPH)7020U2062_01 TAYLORSTOWN HILL1: C53 TAYLORSTOWN RD TO B18 ROGUERY RDNORTHERN DIVISIONMID and EAST ANTRIM08/01/2019 10:52:00Completed303589393987
D1817125BITMAC POTHOLE (CBPH)7020U2062_01 TAYLORSTOWN HILL1: C53 TAYLORSTOWN RD TO B18 ROGUERY RDNORTHERN DIVISIONMID and EAST ANTRIM04/07/2018 09:51:25Completed303061395267
D1810728BITMAC POTHOLE (CBPH)7020U2071_03 TUPPENNY RD1: U2072 BALLYKENNEDY RD TO U2070 STRAID RDNORTHERN DIVISIONMID and EAST ANTRIM30/04/2018 14:44:19Completed306636401015
DCD89-3068301-19BITMAC POTHOLE (CBPH)7020U2071_03 TUPPENNY RD1: U2072 BALLYKENNEDY RD TO U2070 STRAID RDNORTHERN DIVISIONMID and EAST ANTRIM02/05/2018 10:51:00Completed306644401018

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