Carriageway And Footway Surface Defects

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
DCD23-3057965-8	BITMAC POTHOLE (CBPH)	7020B0093_03 DUNMINNING RD: DUNEOIN RD TO DUNMINNING RD	NORTHERN DIVISION	MID and EAST ANTRIM	08/08/2016 12:57:00	Completed	304574	408066
DCD23-3057965-10	BITMAC POTHOLE (CBPH)	7020B0093_03 DUNMINNING RD: DUNEOIN RD TO DUNMINNING RD	NORTHERN DIVISION	MID and EAST ANTRIM	08/08/2016 13:09:00	Completed	304958	410146
DCD23-3059547-9	BITMAC DEFECTIVE (CBDF)	7020B0093_03 DUNMINNING RD: DUNEOIN RD TO DUNMINNING RD	NORTHERN DIVISION	MID and EAST ANTRIM	10/11/2016 12:36:00	Completed	304671	408469
DCD23-3059547-10	BITMAC POTHOLE (CBPH)	7020B0093_03 DUNMINNING RD: DUNEOIN RD TO DUNMINNING RD	NORTHERN DIVISION	MID and EAST ANTRIM	10/11/2016 12:41:00	Completed	304678	408234
DCD23-3057965-11	BITMAC POTHOLE (CBPH)	7020B0093_03 DUNMINNING RD: DUNEOIN RD TO DUNMINNING RD	NORTHERN DIVISION	MID and EAST ANTRIM	08/08/2016 13:10:00	Completed	304954	410120
DCD23-3061060-55	BITMAC POTHOLE (CBPH)	7020B0093_03 DUNMINNING RD: DUNEOIN RD TO DUNMINNING RD	NORTHERN DIVISION	MID and EAST ANTRIM	20/02/2017 14:32:00	Completed	304630	408416
DCD23-3061060-51	BITMAC POTHOLE (CBPH)	7020B0093_03 DUNMINNING RD: DUNEOIN RD TO DUNMINNING RD	NORTHERN DIVISION	MID and EAST ANTRIM	20/02/2017 14:16:00	Completed	304936	410012
DCD62-3060244-3	ASPHALT CRACKED (CACR)	7020B0052_04 PORTGLENONE RD: BALLYBOLLEN RD TO WHITESIDES RD	NORTHERN DIVISION	MID and EAST ANTRIM	10/01/2017 11:11:00	Completed	304304	395458
DCD14-3058731-5	ASPHALT RUTTED (CART)	7020B0059_01 TULLY RD2: A36 MOORFIELDS RD TO B53 KILGAD RD	NORTHERN DIVISION	MID and EAST ANTRIM	20/09/2016 12:14:00	Completed	314966	400841
DCD14-3061845-22	ASPHALT RUTTED (CART)	7020B0059_01 TULLY RD2: A36 MOORFIELDS RD TO B53 KILGAD RD	NORTHERN DIVISION	MID and EAST ANTRIM	30/03/2017 11:25:00	Completed	314953	400764


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