Baselight

Automatic Traffic Counters Data

City of York Council

@ukgov.automatic_traffic_counters_step

ATC - Counters Locations
@ukgov.automatic_traffic_counters_step.atc_counters_locations

Location and metadata regarding the Automatic Traffic Counters (ATC)

  • 11.76 KB
  • 32 rows
  • 13 columns
site_number

Site Number

site_number_1

Site Number.1

counter_type

Counter Type

channel_directions

Channel Directions

road

Road

road_name

Road Name

location_of_cabinet

Location Of Cabinet

first_junction

First Junction

second_junction

Second Junction

file_number

File Number

comments

Comments

x_coordinates

X Coordinates

y_coordinates

Y Coordinates

YK756655VehicleChannel 1: South Channel 2: North B1363Wigginton RoadInbound741v----459423.6642457332.9391
YK76022VehicleChannel 1: North East Channel 2: South WestUnclassifiedAskham LaneOn Grass Verge (outbound)North of A1237 (3660km)Foxwood Lane/Askham Lane Roundabout281v----456295.8343449607.7604
YK76044VehicleChannel 1: West Channel 2: East A59Boroughbridge RoadOn Grass Verge (outbound)West of Beckfield LaneEast of Trenchard Road514c----456860.8106453035.3992
YK76055VehicleChannel 1 :West Channel 2: East A166Bridlington RoadOn Grass Verge (inbound)West of Church BalkEast of Bore Tree Baulk031v----465918.9997452469.0014
YK761111VehicleChannel 1: South Channel 2: North A19Fulford RoadOn Grass verge (inbound)132v0411461238.7649448358.268
YK761212VehicleChannel 1: North Channel 2: SouthA19Fulford RoadGrass Verge outside 11 Main Street013c----460916.2511449551.9763
YK761515VehicleChannel 1: West Channel 2: East A59Harrogate RoadA64Naburn Lane515v0382453854.5789453686.2229
YK761616VehicleChannel 1: North Channel 2: South UnclassifiedHaxby Road812v----460968.599455941.7573
YK762121VehicleChannel 1: East Channel 2: West A1079Hull Road027v0420462541.8061451278.2322
YK762626VehicleChannel 1: North East Channel 2: South West A1036Malton RoadOn grass verge - inbound874v----462351.7163454025.2559

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
);

Share link

Anyone who has the link will be able to view this.