About this Dataset

Automatic Traffic Counters Data

*Please note that this dataset is no longer getting updated This dataset contains count data aggregated by hour for each of the automatic traffic counters (ATC) upgraded as part of City of York Council's STEP project.
Publisher name: City of York Council
Last updated: 2025-03-04T04:00:02Z

Tables

ATC - Counters Locations

@ukgov.automatic_traffic_counters_step.atc_counters_locations

12.04 kB
32 rows
13 columns

CREATE TABLE atc_counters_locations (
  "site_number" VARCHAR,
  "site_number_1" BIGINT,
  "counter_type" VARCHAR,
  "channel_directions" VARCHAR,
  "road" VARCHAR,
  "road_name" VARCHAR,
  "location_of_cabinet" VARCHAR,
  "first_junction" VARCHAR,
  "second_junction" VARCHAR,
  "file_number" VARCHAR,
  "comments" VARCHAR,
  "x_coordinates" DOUBLE,
  "y_coordinates" DOUBLE
);

ATC - Counts

@ukgov.automatic_traffic_counters_step.atc_counts

1.73 MB
229,822 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
);