Baselight
Sign In

Carriageway And Footway Surface Defects

OpenDataNI

@ukgov.surface_defects

Surface Defects 2012/2013
@ukgov.surface_defects.surface_defects_2012_2013

Surface Defects recorded between 1st April 2012 and 31st March 2013

  • 3.43 MB
  • 179293 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

NORTH2059061BITMAC EDGE DETERIORATION (CBED)7050U4087_01 GLENBUSH RD1: COOLKEERAN RD TO SHELTON RD BALLYMONEYNORTHERN DIVISIONCAUSEWAY COAST & GLENS (EAST)26/09/2012 09:40:35Imports from VICII307897428648
NORTH2050952ASPHALT CRACKED (CACR)7050B0066_04 CRAIGMORE RD1: LANE ON RIGHT TO CASHEL RD COLERAINENORTHERN DIVISIONCAUSEWAY COAST & GLENS (WEST)20/08/2012 15:38:51R2. R3, R4 Awaiting Action278477422530
NORTH2046479BITMAC DEFECTIVE (CBDF)7050U2522_26 BRIAR HILL: BRIAR HILL TO CDS LIMAVADYNORTHERN DIVISIONCAUSEWAY COAST & GLENS (WEST)01/08/2012 14:35:41R2. R3, R4 Awaiting Action256486420641
NORTH2046480BITMAC RUTTED (CBRT)7050U2522_26 BRIAR HILL: BRIAR HILL TO CDS LIMAVADYNORTHERN DIVISIONCAUSEWAY COAST & GLENS (WEST)01/08/2012 14:35:41R2. R3, R4 Awaiting Action256486420641
NORTH2050497BITMAC RUTTED (CBRT)7020C0077_05 BALLYPOLLARD RD1: U4063 BALLYLIG RD TO A2 SHORE RD LARNENORTHERN DIVISIONLARNE / BALLYMENA17/08/2012 14:10:01R2. R3, R4 Awaiting Action342705398116
NORTH2070460BITMAC CRACKED (CBCR)7050U3533_09 OLD COLERAINE RD1: LARKHILL RD TO CUL DE SAC COLERAINENORTHERN DIVISIONCAUSEWAY COAST & GLENS (WEST)12/11/2012 14:48:19R2. R3, R4 Awaiting Action282094436847
NORTH2087610ASPHALT CRACKED (CACR)7050B0066_04 CRAIGMORE RD1: LANE ON RIGHT TO CASHEL RD COLERAINENORTHERN DIVISIONCAUSEWAY COAST & GLENS (WEST)04/02/2013 15:18:04R2. R3, R4 Awaiting Action278477422530
NORTH2094523BITMAC RUTTED (CBRT)7050U3366_02 BRONE RD1: BALLYAGAN RD TO MONEYCARRIE RD COLERAINENORTHERN DIVISIONCAUSEWAY COAST & GLENS (WEST)26/02/2013 15:45:29R2. R3, R4 Awaiting Action286578418128
NORTH2097697ASPHALT POTHOLE (CAPH)7020B0062_05 BALLYMENA RD3: U2028 OLD CULLYBACKEY RD TO U2027 SAND RD BALLYMENANORTHERN DIVISIONLARNE / BALLYMENA08/03/2013 14:55:23R2. R3, R4 Awaiting Action306166405505
EAST1894944ASPHALT POTHOLE (CAPH)7065C0298_01 DRUMBEG RD1: BALLYSKEAGH RD B103 TO HILLHALL RD B23 LISBURNEASTERN DIVISIONCASTLEREAGH / LISBURN19/04/2012 14:39:19R2. R3, R4 Awaiting Action330484366946

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