Baselight

Carriageway And Footway Surface Defects

OpenDataNI

@ukgov.surface_defects

Surface Defects 2014/2015
@ukgov.surface_defects.surface_defects_2014_2015

Surface Defects recorded between 1st April 2014 and 31st March 2015

  • 6.38 MB
  • 137301 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

DCD82-1007411-50BITMAC EDGE DETERIORATION (CBED)7060U1113_01 - TULLYDAGAN RD1: U1111 01 SCOTS LN TO B0012 03 CORNAKINNEGAR RD - CRAIGAVONSOUTHERN DIVISIONARMAGH CITY, BANBRIDGE & CRAIGAVON (EAST)07/10/2014 10:59:00R2. R3, R4 Awaiting Action309436361262
DCD29-1008312-49BITMAC EDGE DETERIORATION ON RURAL UNKERBED RD WITHIN 250MM OF RD EDGE (CBER)7050U3376_02 - DRUMSARAGH RD1: EDENBANE RD TO DRUMAGARNER RD - COLERAINENORTHERN DIVISIONCAUSEWAY COAST & GLENS (WEST)15/10/2014 09:13:00R2. R3, R4 Awaiting Action290830411153
DCD29-1008312-52BITMAC EDGE DETERIORATION ON RURAL UNKERBED RD WITHIN 250MM OF RD EDGE (CBER)7050U3376_02 - DRUMSARAGH RD1: EDENBANE RD TO DRUMAGARNER RD - COLERAINENORTHERN DIVISIONCAUSEWAY COAST & GLENS (WEST)15/10/2014 09:21:00R2. R3, R4 Awaiting Action290647411577
DCD29-1008312-53BITMAC EDGE DETERIORATION ON RURAL UNKERBED RD WITHIN 250MM OF RD EDGE (CBER)7050U3376_02 - DRUMSARAGH RD1: EDENBANE RD TO DRUMAGARNER RD - COLERAINENORTHERN DIVISIONCAUSEWAY COAST & GLENS (WEST)15/10/2014 09:28:00R2. R3, R4 Awaiting Action290661411544
DCD29-1008312-66BITMAC POTHOLE (CBPH)7050U3376_03 - HILLHEAD RD2: DRUMSARAGH RD TO BOVEEDY RD - COLERAINENORTHERN DIVISIONCAUSEWAY COAST & GLENS (WEST)15/10/2014 11:33:00R2. R3, R4 Awaiting Action289822412180
DCD82-1007867-83BITMAC POTHOLE (CBPH)7060U1206_01 - TAUGHLUMNY RD1: U1205 02 DRUMNABREEZE RD TO C0360 01 STEPS RD - CRAIGAVONSOUTHERN DIVISIONARMAGH CITY, BANBRIDGE & CRAIGAVON (EAST)27/10/2014 12:05:00R2. R3, R4 Awaiting Action315303357558
DCD79-1008916-75ASPHALT DEFECTIVE (CADF)7035A0052_07 - CRUMLIN RD1: UPPER HIGHTOWN RD TO FLUSH RD - BELFAST NORTHEASTERN DIVISIONBELFAST NORTH06/11/2014 11:56:00R2. R3, R4 Awaiting Action330794378057
DCD82-1008918-44BITMAC EDGE DETERIORATION (CBED)7060U1312_02 - BALLYLOUGH RD2: C0352 05 LOWTOWN RD TO A0026 07 BANBRIDGE RD - CRAIGAVONSOUTHERN DIVISIONARMAGH CITY, BANBRIDGE & CRAIGAVON (EAST)24/11/2014 12:26:00R2. R3, R4 Awaiting Action310834351214
DCD82-1008918-57BITMAC POTHOLE (CBPH)7060U1316_01 - KNOCKNAGORE RD1: U1312 01 BALLYLOUGH RD TO C0364 02 CLARE RD - CRAIGAVONSOUTHERN DIVISIONARMAGH CITY, BANBRIDGE & CRAIGAVON (EAST)24/11/2014 16:22:00R2. R3, R4 Awaiting Action308640351771
DCD90-1009160-21BITMAC POTHOLE (CBPH)7125U8497_02 - TEN FOOT RD1: A46 LOUGH SHORE RD TO B81 MONEA RD - FERMANAGHWESTERN DIVISIONFERMANAGH & OMAGH (WEST)26/11/2014 10:47:00R2. R3, R4 Awaiting Action220686345820

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