Baselight
Sign In

Carriageway And Footway Surface Defects

OpenDataNI

@ukgov.surface_defects

Surface Defects 2019/2020
@ukgov.surface_defects.surface_defects_2019_2020

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

  • 4.67 MB
  • 123074 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

D1907190BITMAC POTHOLE (CBPH)7035U0444_10 TRENCHILL AV1: RASHEE RD TO TRENCHILL RD NEWTOWNABBEYNORTHERN DIVISIONANTRIM and NEWTOWNABBEY11/04/2019 16:08:01Further Information Required327574393177
D1914553BITMAC POTHOLE (CBPH)7125U9557_02 OLD ENNISKILLEN RD1: STRETCH 1 TO U9542 BALLYLUCAS RD FERMANAGHWESTERN DIVISIONFERMANAGH and OMAGH WEST03/07/2019 15:39:28Further Information Required227952341527
D1914564BITMAC POTHOLE (CBPH)7125U9542_01 BALLYLUCAS RD1: U9591 DERRYCLAWAN RD TO U9559 OLD ENNISKILLEN RD FERMANAGHWESTERN DIVISIONFERMANAGH and OMAGH WEST03/07/2019 16:43:12Further Information Required227632341914
D1918492BITMAC UNEVEN (CBUN)7065U7108_103 LAGMORE VIEW ROAD: LAGMORE GLEN TO NO 88 LAGMORE VIEW ROAD CDS BELFAST NORTHEASTERN DIVISIONBELFAST NORTH08/08/2019 11:38:12Further Information Required326975368754
D1919281BITMAC POTHOLE (CBPH)7060U5650_14 HILL ST2: C0174 13 GREEN RD TO END NEWRY and MOURNESOUTHERN DIVISIONNEWRY MOURNE and DOWN WEST28/08/2019 13:20:57Further Information Required304626328003
D1922917BITMAC POTHOLE (CBPH)7060U6288_05 DRUMALANE PK1: U6288 04 DRUMALANE PK TO U6288 06 DRUMALANE PK NEWRY and MOURNESOUTHERN DIVISIONNEWRY MOURNE and DOWN WEST30/09/2019 11:16:26Further Information Required308461325159
D1924173BITMAC POTHOLE (CBPH)7060U6215_02 AUGHNAHOORY RD1: U6216 01 AUGHNALOOPY RD TO U6217 01 MILL RD NEWRY and MOURNESOUTHERN DIVISIONNEWRY MOURNE and DOWN WEST17/10/2019 08:57:50Further Information Required331195315731
D1926870BITMAC RUTTED (CBRT)7125C0435_01 KINAWLEY RD1: B108 STRAGOWNA RD TO C436 INISHMORE RD FERMANAGHWESTERN DIVISIONFERMANAGH and OMAGH WEST30/10/2019 11:38:51Further Information Required222202331793
D1926878BITMAC RUTTED (CBRT)7125U8668_01 CORAGH RD1: C435 KINAWLEY RD TO END AT CONCRETE LN RHS 1338 FERMANAGHWESTERN DIVISIONFERMANAGH and OMAGH WEST30/10/2019 12:03:02Further Information Required222094331941
D1926891BITMAC RUTTED (CBRT)7125C0435_01 KINAWLEY RD1: B108 STRAGOWNA RD TO C436 INISHMORE RD FERMANAGHWESTERN DIVISIONFERMANAGH and OMAGH WEST30/10/2019 13:20:19Further Information Required220659333673

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