About this Dataset

Pedestrian Crossing Points

A dataset to show the traffic light crossing points in Leeds giving road name, postcode, easting and northing. The data consists of * road junctions which contain signalled crossing points. * signalled crossings which can consist of pedestrian crossings including Pelicans, Puffins, Toucans and One-can crossings Additional Information ---------------------- * For more information on pedestrian crossings please visit: * https://www.gov.uk/using-the-road-159-to-203/pedestrian-crossings-191-to-199
Publisher name: Leeds City Council
Last updated: 2024-09-14T09:45:47Z

Tables

2015

@ukgov.pedestrian_crossing_points.n_2015

31.72 KB
593 rows
6 columns


CREATE TABLE n_2015 (
  "reference_number" VARCHAR,
  "crossing_type" VARCHAR,
  "street_name" VARCHAR,
  "easting" BIGINT,
  "northing" BIGINT,
  "postcode" VARCHAR
);

2016

@ukgov.pedestrian_crossing_points.n_2016

31.65 KB
602 rows
6 columns


CREATE TABLE n_2016 (
  "reference_number" VARCHAR,
  "crossing_type" VARCHAR,
  "address" VARCHAR,
  "easting" BIGINT,
  "northing" BIGINT,
  "postcode" VARCHAR
);

2018

@ukgov.pedestrian_crossing_points.n_2018

34.86 KB
670 rows
6 columns


CREATE TABLE n_2018 (
  "installation_type" VARCHAR,
  "orn" VARCHAR,
  "address" VARCHAR,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "postcode" VARCHAR
);

2019

@ukgov.pedestrian_crossing_points.n_2019

35.97 KB
666 rows
7 columns


CREATE TABLE n_2019 (
  "orn" VARCHAR,
  "address" VARCHAR,
  "installation_type" VARCHAR,
  "ward" VARCHAR,
  "easting" BIGINT,
  "northing" BIGINT,
  "postcode" VARCHAR
);