Baselight
Sign In

Carriageway And Footway Surface Defects

OpenDataNI

@ukgov.surface_defects

Surface Defects 2009/2010
@ukgov.surface_defects.surface_defects_2009_2010

Surface Defects recorded between 1st April 2009 and 31st March 2010

  • 3.58 MB
  • 198681 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

NORTH1727460BITMAC DEFECTIVE (CBDF)7050A2002_02 CLOONEY RD2: DUNLADE RD TO CARNAMUFF RD LIMAVADYNORTHERN DIVISIONCAUSEWAY COAST & GLENS (WEST)01/04/2009 12:36:20Archive257928421340
NORTH1727470BITMAC UNEVEN (CBUN)7020U4150_06 GLENBURN AV1: GLENBURN PARK (05) TO DEAD END (CDS 2L) LARNENORTHERN DIVISIONLARNE / BALLYMENA01/04/2009 14:48:13Archive340423399923
NORTH1728970ASPHALT CRACKED (CACR)7050B0017_03 CLOYFIN RD1: BALLYLAGAN RD TO BALLYBOGEY RD COLERAINENORTHERN DIVISIONCAUSEWAY COAST & GLENS (WEST)06/04/2009 14:32:34Archive288060435383
NORTH1728979BITMAC UNEVEN (CBUN)7050A3002_35 PORTSTEWART RD3: DUNDOOAN RD TO AGHERTON LANE1 COLERAINENORTHERN DIVISIONCAUSEWAY COAST & GLENS (WEST)06/04/2009 14:34:58Archive283736434889
NORTH1728986BITMAC UNEVEN (CBUN)7050A3002_14 STRAND RD4: STRAND RD RBT TO THE DIAMOND RBT COLERAINENORTHERN DIVISIONCAUSEWAY COAST & GLENS (WEST)06/04/2009 14:34:58Archive281442436920
NORTH1727499BITMAC UNEVEN (CBUN)7050U3550_08 BALLYWILLAN CRES: B'WILLAN CRES TO CDS COLERAINENORTHERN DIVISIONCAUSEWAY COAST & GLENS (WEST)01/04/2009 14:49:06Archive286691439548
NORTH1729067BITMAC DEPRESSED (CBDP)7050B0190_01 BELRAUGH RD1: LEGAVALLON RD TO COOLNASILLAGH RD COLERAINENORTHERN DIVISIONCAUSEWAY COAST & GLENS (WEST)06/04/2009 15:14:12Archive276164415200
NORTH1730152BITMAC POTHOLE (CBPH)7020A0036_06 MOORFIELDS RD3: B59 TULLY RD (RHS) TO U2098 SCOTTSTOWN RD (RHS) BALLYMENANORTHERN DIVISIONLARNE / BALLYMENA09/04/2009 14:48:54Archive314968400851
NORTH1730153ASPHALT POTHOLE (CAPH)7020A0036_05 MOORFIELDS RD2: BALLYKEEL RBT TO B59 TULLY RD (RHS) BALLYMENANORTHERN DIVISIONLARNE / BALLYMENA09/04/2009 14:48:54Archive312551401816
NORTH1730154ASPHALT DEFECTIVE (CADF)7020A0036_05 MOORFIELDS RD2: BALLYKEEL RBT TO B59 TULLY RD (RHS) BALLYMENANORTHERN DIVISIONLARNE / BALLYMENA09/04/2009 14:48:54Archive312551401816

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