Cambridgeshire County Council Traffic Count Data

Cambridgeshire Insight

@ukgov.cambridgeshire_county_council_traffic_count_data1

Table List

2 tables(72.95 KB)

Traffic Counts 2009-13

Traffic Counts 2010-2014

Traffic Counts 2009-13

@ukgov.cambridgeshire_county_council_traffic_count_data1.traffic_counts_2009_13

30.6 KB
687 rows
10 columns

reference Reference	road_number Road Number	road_name Road Name	day Day	date Date	all_vehicle_flow All Vehicle Flow	hgv_flow HGV Flow	bus_coach_flow Bus Coach Flow	easting Easting	northing Northing
925	A1301	SAWSTON BYPASS	MONDAY	20121008	5967	239	54	548651.559	247998.731
475	U/C	SCIENCE PARK	TUESDAY	20090421	9854	51	115	546893.291	261442.902
477	U/C	SCIENCE PARK	WEDNESDAY	20090422	9733	42	116	546893.291	261442.902
479	U/C	SCIENCE PARK	THURSDAY	20090423	9037	68	84	546893.291	261442.902
476	U/C	SCIENCE PK ACCESS	TUESDAY	20090421	2882	12	18	546035.64	261847.377
478	U/C	SCIENCE PK ACCESS	WEDNESDAY	20090422	2965	15	16	546035.64	261847.377
480	U/C	SCIENCE PK ACCESS	THURSDAY	20090423	2841	6	17	546035.64	261847.377
471	A1134	ELIZABETH WAY	WEDNESDAY	20090318	23485	542	295	546063.945	259248.8
472	C292	VICTORIA AVENUE	WEDNESDAY	20090318	11891	156	543	545329.145	259358.569
469	C290	BRIDGE STREET	MONDAY	20090316	2393	33	723	544728.905	258940.499


CREATE TABLE traffic_counts_2009_13 (
  "reference" BIGINT,
  "road_number" VARCHAR,
  "road_name" VARCHAR,
  "day" VARCHAR,
  "date" BIGINT,
  "all_vehicle_flow" BIGINT,
  "hgv_flow" DOUBLE,
  "bus_coach_flow" DOUBLE,
  "easting" DOUBLE,
  "northing" DOUBLE
);