Automatic Traffic Counters Data
City of York Council
@ukgov.automatic_traffic_counters_step
Table List
- 2 tables(1.66 MB)
ATC - Counts
@ukgov.automatic_traffic_counters_step.atc_counts
- 1.65 MB
- 229822 rows
- 18 columns
CREATE TABLE atc_counts (
"countdate" TIMESTAMP,
"counthour" VARCHAR,
"site_number" BIGINT,
"channel_id" BIGINT,
"site_title" VARCHAR,
"channel_name" VARCHAR,
"total_count" BIGINT,
"motorcycle_count" BIGINT,
"car_count" BIGINT,
"car_trailer_count" BIGINT,
"heavy_van_count" BIGINT,
"lgv_count" BIGINT,
"rigid_count" BIGINT,
"rigid_trailer_count" BIGINT,
"articulated_hgv_count" BIGINT,
"minibus_count" BIGINT,
"bus_count" BIGINT,
"cycle_count" BIGINT
);