Road Traffic Counts

CREATE TABLE round_count_data (
  "aadfyear" BIGINT,
  "year" TIMESTAMP,
  "cp" BIGINT,
  "region" VARCHAR,
  "localauthority" VARCHAR,
  "road" VARCHAR,
  "roadcategory" VARCHAR,
  "easting" BIGINT,
  "northing" BIGINT,
  "startjunction" VARCHAR,
  "endjunction" VARCHAR,
  "linklength_km" DOUBLE,
  "linklength_miles" DOUBLE,
  "pedalcycles" BIGINT,
  "motorcycles" BIGINT,
  "carstaxis" BIGINT,
  "busescoaches" BIGINT,
  "lightgoodsvehicles" BIGINT,
  "v2axlerigidhgv" BIGINT,
  "v3axlerigidhgv" BIGINT,
  "v4or5axlerigidhgv" BIGINT,
  "v3or4axleartichgv" BIGINT,
  "v5axleartichgv" BIGINT,
  "v6ormoreaxleartichgv" BIGINT,
  "allhgvs" BIGINT,
  "allmotorvehicles" BIGINT,
  "longitude" DOUBLE,
  "latitude" DOUBLE
);