Baselight

Carriageway And Footway Surface Defects

OpenDataNI

@ukgov.surface_defects

Surface Defects 2015/2016
@ukgov.surface_defects.surface_defects_2015_2016

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

  • 4.32 MB
  • 125265 rows
  • 9 columns
instruction_reference

INSTRUCTION REFERENCE

defect_detail

DEFECT DETAIL

division

DIVISION

section_office

SECTION OFFICE

section_name

SECTION NAME

recorded_date

RECORDED DATE

defect_status

DEFECT STATUS

easting

EASTING

northing

NORTHING

DCD35-3044740-14BITMAC POTHOLE (CBPH)SOUTHERN DIVISIONARMAGH CITY, BANBRIDGE & CRAIGAVON (EAST)7060U4462_14 - KILN LN2: A0026 10 LURGAN RD TO U4072 01 HILL ST - BANBRIDGE01/04/2015 07:10:00Completed312253347010
DCD13-3044905-7BITMAC POTHOLE (CBPH)WESTERN DIVISIONFERMANAGH & OMAGH (EAST)7125B0048_04 - GORTIN RD1: U1269 KILLYBRACK RD TO U1271 GLENCAM RD - OMAGH01/04/2015 07:06:00Completed245268373628
DCD13-3044905-8BITMAC POTHOLE (CBPH)WESTERN DIVISIONFERMANAGH & OMAGH (EAST)7125B0048_04 - GORTIN RD1: U1269 KILLYBRACK RD TO U1271 GLENCAM RD - OMAGH01/04/2015 07:08:00Works Order Issued245275373606
DCD35-3044740-16BITMAC POTHOLE (CBPH)SOUTHERN DIVISIONARMAGH CITY, BANBRIDGE & CRAIGAVON (EAST)7060U4462_14 - KILN LN2: A0026 10 LURGAN RD TO U4072 01 HILL ST - BANBRIDGE01/04/2015 07:14:00Completed312528347041
DCD35-3044740-17BITMAC POTHOLE (CBPH)SOUTHERN DIVISIONARMAGH CITY, BANBRIDGE & CRAIGAVON (EAST)7060U4462_14 - KILN LN2: A0026 10 LURGAN RD TO U4072 01 HILL ST - BANBRIDGE01/04/2015 07:15:00Completed312552347044
DCD35-3044740-18BITMAC POTHOLE (CBPH)SOUTHERN DIVISIONARMAGH CITY, BANBRIDGE & CRAIGAVON (EAST)7060U4462_14 - KILN LN2: A0026 10 LURGAN RD TO U4072 01 HILL ST - BANBRIDGE01/04/2015 07:18:00Completed312793346994
DCD35-3044740-19BITMAC POTHOLE (CBPH)SOUTHERN DIVISIONARMAGH CITY, BANBRIDGE & CRAIGAVON (EAST)7060U4462_14 - KILN LN2: A0026 10 LURGAN RD TO U4072 01 HILL ST - BANBRIDGE01/04/2015 07:20:00Completed312883347023
DCD35-3044740-15BITMAC POTHOLE (CBPH)SOUTHERN DIVISIONARMAGH CITY, BANBRIDGE & CRAIGAVON (EAST)7060U4462_14 - KILN LN2: A0026 10 LURGAN RD TO U4072 01 HILL ST - BANBRIDGE01/04/2015 07:12:00Completed312325347045
DCD13-3044905-9BITMAC POTHOLE (CBPH)WESTERN DIVISIONFERMANAGH & OMAGH (EAST)7125B0048_03 - MOUNTJOY RD2: B48 DRUMRAGH AV TO U1269 KILLYBRACK RD - OMAGH01/04/2015 07:14:00Completed245290373458
DCD13-3044905-10BITMAC POTHOLE (CBPH)WESTERN DIVISIONFERMANAGH & OMAGH (EAST)7125B0048_03 - MOUNTJOY RD2: B48 DRUMRAGH AV TO U1269 KILLYBRACK RD - OMAGH01/04/2015 07:17:00Completed245294373451

CREATE TABLE surface_defects_2015_2016 (
  "instruction_reference" VARCHAR,
  "defect_detail" VARCHAR,
  "division" VARCHAR,
  "section_office" VARCHAR,
  "section_name" VARCHAR,
  "recorded_date" VARCHAR,
  "defect_status" VARCHAR,
  "easting" BIGINT,
  "northing" BIGINT
);

Share link

Anyone who has the link will be able to view this.