About this Dataset

Outdoor Sports Facilities

This dataset shows a list of Leeds City Council (Parks and Countryside) and parish council managed outdoor recreation sites. It is recognised that some sections still need to be completed. If you can help improve this dataset please get in touch. Have we missed anything off?
Publisher name: Leeds City Council
Last updated: 2022-07-01T04:02:59Z

Tables

30/10/2014

@ukgov.outdoor_sports_facilities.n_30_10_2014

19.46 kB
496 rows
11 columns

CREATE TABLE n_30_10_2014 (
  "extractdate" TIMESTAMP,
  "organisationuri" VARCHAR,
  "organisationlabel" VARCHAR,
  "servicetypeuri" VARCHAR,
  "servicetypelabel" VARCHAR,
  "facilityname" VARCHAR,
  "activitytype" VARCHAR,
  "managedby" VARCHAR,
  "ward" VARCHAR,
  "address" VARCHAR,
  "postcode" VARCHAR
);

Playing Pitch Sizes

@ukgov.outdoor_sports_facilities.playing_pitch_sizes

3 kB
4 rows
3 columns

CREATE TABLE playing_pitch_sizes (
  "pitchtype" VARCHAR,
  "length_m" BIGINT  -- Length(m),
  "width_m" BIGINT  -- Width(m)
);