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
DCD86-3064831-54	BITMAC POTHOLE (CBPH)	7020A0042_25 RACEVIEW RD: END OF DUAL C'WAY TO WOODSIDE RD	NORTHERN DIVISION	MID and EAST ANTRIM	22/09/2017 12:15:00	Completed	312651	404747
DCD86-3066191-18	BITMAC POTHOLE (FBPH)	7020A0042_25 RACEVIEW RD: END OF DUAL C'WAY TO WOODSIDE RD	NORTHERN DIVISION	MID and EAST ANTRIM	19/12/2017 11:54:00	Works Order Issued	312550	404700
DCD86-3067410-61	ASPHALT POTHOLE (CAPH)	7020A0043_05 GLENRAVEL RD: ISLANDSTOWN RD TO GLENSBRAE RD	NORTHERN DIVISION	MID and EAST ANTRIM	26/02/2018 12:06:00	Completed	313911	414739
DCD86-3065356-29	BITMAC EDGE DETERIORATION (FBED)	7020A0043_05 GLENRAVEL RD: ISLANDSTOWN RD TO GLENSBRAE RD	NORTHERN DIVISION	MID and EAST ANTRIM	24/10/2017 11:48:00	Completed	313506	413892
DCD86-3062270-21	ASPHALT POTHOLE (CAPH)	7020A0043_05 GLENRAVEL RD: ISLANDSTOWN RD TO GLENSBRAE RD	NORTHERN DIVISION	MID and EAST ANTRIM	27/04/2017 13:29:00	Completed	314679	415748
DCD86-3065669-3	ASPHALT POTHOLE (CAPH)	7020A0043_05 GLENRAVEL RD: ISLANDSTOWN RD TO GLENSBRAE RD	NORTHERN DIVISION	MID and EAST ANTRIM	22/01/2018 12:55:00	Completed	313349	413588
DCD86-3067410-54	ASPHALT POTHOLE (CAPH)	7020A0043_05 GLENRAVEL RD: ISLANDSTOWN RD TO GLENSBRAE RD	NORTHERN DIVISION	MID and EAST ANTRIM	26/02/2018 11:14:00	Completed	313483	413833
DCD86-3067449-52	ASPHALT POTHOLE (CAPH)	7020A0043_05 GLENRAVEL RD: ISLANDSTOWN RD TO GLENSBRAE RD	NORTHERN DIVISION	MID and EAST ANTRIM	16/03/2018 13:52:00	Completed	313911	414743
DCD86-3067410-60	ASPHALT POTHOLE (CAPH)	7020A0043_05 GLENRAVEL RD: ISLANDSTOWN RD TO GLENSBRAE RD	NORTHERN DIVISION	MID and EAST ANTRIM	26/02/2018 11:48:00	Completed	313786	414506
DCD86-3067410-56	ASPHALT POTHOLE (CAPH)	7020A0043_05 GLENRAVEL RD: ISLANDSTOWN RD TO GLENSBRAE RD	NORTHERN DIVISION	MID and EAST ANTRIM	26/02/2018 11:33:00	Completed	313715	414320


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