PSPO & Alcohol Restriction Zones by UK Government | Demographics and Population Studies

About this Dataset

PSPO & Alcohol Restriction Zones

Dataset containing current and historic Public Space Protection Orders (PSPOs) , including Alcohol Restriction Zones (ARZ) in York. Please note that Designated Public Place Orders (DPPOs) were replaced by PSPOs in 2017. For further information on PSPOs please visit Council's website. *Please note that the data published within this dataset is a live API link to CYC's GIS server. Any changes made to the master copy of the data will be immediately reflected in the resources of this dataset. The date shown in the "Last Updated" field of each GIS resource reflects when the data was first published.
Publisher name: City of York Council
Last updated: 2024-06-13T04:06:31Z

Tables

York DPPOs (ARZs) - May 2015

@ukgov.alcohol_restriction_zones.york_dppos_arzs_may_2015

2.9 KB
21 rows
2 columns


CREATE TABLE york_dppos_arzs_may_2015 (
  "zonename" VARCHAR,
  "putinplacedate" TIMESTAMP
);

York PSPOs - October 2017 - 2021

@ukgov.alcohol_restriction_zones.york_pspos_october_2017_2021

2.45 KB
9 rows
2 columns


CREATE TABLE york_pspos_october_2017_2021 (
  "objectid" BIGINT,
  "pspo" VARCHAR
);

York PSPOs - 2022

@ukgov.alcohol_restriction_zones.york_pspos_2022

2.25 KB
2 rows
2 columns


CREATE TABLE york_pspos_2022 (
  "objectid" BIGINT,
  "pspo" VARCHAR
);