Baselight
Sign In

Carriageway And Footway Surface Defects

OpenDataNI

@ukgov.surface_defects

Surface Defects 2011/2012
@ukgov.surface_defects.surface_defects_2011_2012

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

  • 3.67 MB
  • 196222 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

SOUTH1735877BITMAC DEPRESSED (CBDP)7060P1406_12 CONNOLLY PLACE C/P: U1406 02 TRASNA WAY TO END CRAIGAVONSOUTHERN DIVISIONARMAGH CITY, BANBRIDGE & CRAIGAVON (EAST)15/06/2011 15:48:39Archive308195358083
NORTH1926936ASPHALT CRACKED (CACR)7050A3002_06 WATERSIDE1: LOWER CAPTAIN ST TO BANN BRIDGE COLERAINENORTHERN DIVISIONCAUSEWAY COAST & GLENS (WEST)07/04/2011 14:37:00Archive284424432434
NORTH1926939ASPHALT CRACKED (CACR)7050A0029_26 STRAND RD1: STRAND RD RBT TO BANN BRIDGE COLERAINENORTHERN DIVISIONCAUSEWAY COAST & GLENS (WEST)07/04/2011 14:37:00Archive284730431483
NORTH1927646BITMAC DEFECTIVE (CBDF)7050B0147_06 BALLINLEA RD1: DOUGHERY BRAE TO LISNAGAT RD MOYLENORTHERN DIVISIONCAUSEWAY COAST & GLENS (EAST)11/04/2011 09:08:14Archive303359433730
NORTH1927671BITMAC POTHOLE (CBPH)7050B0015_04 GRACEHILL RD2: BREGAGH RD TO DRONES RD MOYLENORTHERN DIVISIONCAUSEWAY COAST & GLENS (EAST)11/04/2011 09:08:14Archive304547431853
NORTH1927681BITMAC POTHOLE (CBPH)7050C0099_02 CARNBORE RD1: HAW RD TO TOBERDONEY RD MOYLENORTHERN DIVISIONCAUSEWAY COAST & GLENS (EAST)11/04/2011 09:08:38Archive295503439202
NORTH1928371BITMAC UNEVEN (CBUN)7020U2143_02 CIRCULAR RD1: OLD BALLYMONEY RD TO C60 DOURY RD BALLYMENANORTHERN DIVISIONLARNE / BALLYMENA12/04/2011 13:27:01Archive310229404477
NORTH1929112BITMAC POTHOLE (CBPH)7020B0094_02 DRUMAGROVE RD1: B64 SPRINGMOUNT RD TO U2151 LIMAVALLAGH RD BALLYMENANORTHERN DIVISIONLARNE / BALLYMENA13/04/2011 14:52:36Archive309591414568
NORTH1929140BITMAC UNEVEN (CBUN)7050B0185_05 STATION RD: STATION RD RBT TO PORTRUSH RD COLERAINENORTHERN DIVISIONCAUSEWAY COAST & GLENS (WEST)13/04/2011 14:57:59Archive282639438280
NORTH1930580BITMAC UNEVEN (CBUN)7050U3555_02 GLEBE VW PK1: GLEBE VW PK TO GLEBE VW PK COLERAINENORTHERN DIVISIONCAUSEWAY COAST & GLENS (WEST)18/04/2011 14:53:03Archive284225416805

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