Name: Litter Bin Locations
Creator: UK Government
License: http://reference.data.gov.uk/id/open-government-licence

About this Dataset

Litter Bin Locations

Litter bin locations showing council bin id number and Easting and Northing
Publisher name: Leeds City Council
Last updated: 2022-07-01T04:02:18Z

Tables

January 2021

@ukgov.litter_bin_locations.january_2021

145.88 KB
3938 rows
19 columns


CREATE TABLE january_2021 (
  "objectid" BIGINT,
  "road_name" VARCHAR,
  "location" VARCHAR,
  "locationgroup" VARCHAR,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "ward" VARCHAR,
  "model" VARCHAR,
  "aperture" VARCHAR,
  "fixings" VARCHAR,
  "liner" VARCHAR,
  "signage" VARCHAR,
  "maincolour" VARCHAR,
  "condition" VARCHAR,
  "defects" VARCHAR,
  "route" VARCHAR,
  "comments" VARCHAR,
  "frequency" VARCHAR,
  "sequence" DOUBLE
);

July 2021

@ukgov.litter_bin_locations.july_2021

164.24 KB
4125 rows
25 columns


CREATE TABLE july_2021 (
  "objectid" BIGINT,
  "road_name" VARCHAR,
  "location" VARCHAR,
  "locationgroup" VARCHAR,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "ward" VARCHAR,
  "model" VARCHAR,
  "aperture" VARCHAR,
  "fixings" VARCHAR,
  "liner" VARCHAR,
  "signage" VARCHAR,
  "maincolour" VARCHAR,
  "condition" VARCHAR,
  "defects" VARCHAR,
  "route" VARCHAR,
  "comments" VARCHAR,
  "lastupdated" VARCHAR,
  "updatedby" VARCHAR,
  "frequency" VARCHAR,
  "sequence" DOUBLE,
  "created_user" VARCHAR,
  "created_date" VARCHAR,
  "last_edited_user" VARCHAR,
  "last_edited_date" TIMESTAMP
);

October 2020

@ukgov.litter_bin_locations.october_2020

149.73 KB
4184 rows
14 columns


CREATE TABLE october_2020 (
  "objectid" BIGINT,
  "road_name" VARCHAR,
  "location" VARCHAR,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "ward" VARCHAR,
  "model" VARCHAR,
  "condition" VARCHAR,
  "defects" VARCHAR,
  "comments" VARCHAR,
  "lastupdated" VARCHAR,
  "frequency" VARCHAR,
  "sequence" BIGINT,
  "binid" DOUBLE
);

September 2018

@ukgov.litter_bin_locations.september_2018

135.27 KB
3848 rows
14 columns


CREATE TABLE september_2018 (
  "objectid" BIGINT,
  "road_name" VARCHAR,
  "location" VARCHAR,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "ward" VARCHAR,
  "model" VARCHAR,
  "condition" VARCHAR,
  "defects" VARCHAR,
  "comments" VARCHAR,
  "lastupdated" TIMESTAMP,
  "frequency" VARCHAR,
  "sequence" VARCHAR,
  "binid" BIGINT
);

September 2020

@ukgov.litter_bin_locations.september_2020

140.03 KB
3970 rows
14 columns


CREATE TABLE september_2020 (
  "objectid" BIGINT,
  "road_name" VARCHAR,
  "location" VARCHAR,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "ward" VARCHAR,
  "model" VARCHAR,
  "condition" VARCHAR,
  "defects" VARCHAR,
  "comments" VARCHAR,
  "lastupdated" VARCHAR,
  "frequency" VARCHAR,
  "sequence" DOUBLE,
  "binid" BIGINT
);