About this Dataset

Stumpd Counters 2019 Devonport And The Hoe

Footfall counters - Devonport park, Autumn 2019. The Hoe, Christmas 2019 This is an evolving dataset being progressed by the Future Parks Accelerator programme: https://www.plymouth.gov.uk/workingcollaboratively1/dataandtech1
Publisher name: Plymouth City Council
Last updated: 2024-09-14T16:30:49Z

Tables

Counters

@ukgov.stumpd_counters_2019_devonport_park.counters

5.23 KB
10 rows
6 columns


CREATE TABLE counters (
  "index" BIGINT,
  "n__park_id" VARCHAR,
  "n__counter_id" VARCHAR,
  "n__location_description" VARCHAR,
  "n__latitude" DOUBLE,
  "n__longitude" DOUBLE
);

Hoecounters

@ukgov.stumpd_counters_2019_devonport_park.hoecounters

5.32 KB
13 rows
6 columns


CREATE TABLE hoecounters (
  "index" BIGINT,
  "n__park_id" VARCHAR,
  "n__counter_id" VARCHAR,
  "n__location_description" VARCHAR,
  "n__latitude" DOUBLE,
  "n__longitude" DOUBLE
);

Hoe-observations

@ukgov.stumpd_counters_2019_devonport_park.hoe_observations

1.79 MB
170946 rows
5 columns


CREATE TABLE hoe_observations (
  "index" BIGINT,
  "n__counterid" VARCHAR,
  "n__date" TIMESTAMP,
  "n__time" VARCHAR,
  "n__triggers" BIGINT
);

Observations

@ukgov.stumpd_counters_2019_devonport_park.observations

2.65 MB
257133 rows
5 columns


CREATE TABLE observations (
  "index" BIGINT,
  "n__counterid" VARCHAR,
  "n__date" TIMESTAMP,
  "n__time" VARCHAR,
  "n__triggers" BIGINT
);

Parks

@ukgov.stumpd_counters_2019_devonport_park.parks

4.17 KB
3 rows
5 columns


CREATE TABLE parks (
  "name" VARCHAR,
  "n__id_string" VARCHAR,
  "n__address" VARCHAR,
  "n__description" VARCHAR,
  "n__more_info" VARCHAR
);