Several organisations are doing a very good job of curating & publishing open data about waste in Scotland but, the published data is not always "easy to use" for non-experts. We have see several references to this at open data conference events and on social media platforms:
Whilst statisticians/coders may think that it is reasonably simple to knead together these somewhat diverse datasets into a coherent knowledge, the interested layman doesn’t find it so easy.
One of the objectives of the Data Commons Scotland project is to address the "ease of use" issue over open data. The contents of this repository are the result of us re-working some of the existing source open data so that it is easier to use, understand, consume, parse, and all in one place. It may not be as detailed or have all the nuances as the source data - but aims to be better for the purposes of making the information accessible to non-experts.
We have processed the source data just enough to:
-
provide intuitive value-based cross-referencing between datasets
-
add a few fields whose values are generally useful but not easily derivable by a simple calculation (such as latitude & longitude)
-
make it available as simple CSV and JSON files in a Git repository.
We have not augmented the data with derived values that can be simply calculated, such as per-population amounts, averages, trends, totals, etc.
We have tried to rectify the inconsistencies that occur in the source data (in particular, the inconsistent labelling of waste materials and regions). However, this is still "work-in-progress" and we yet to tease out & make consistent further useful dimensions.
dataset |
source |
|||||||
---|---|---|---|---|---|---|---|---|
name |
description |
max date in data |
rows x cols |
data files |
supplied when |
supplier |
creator |
licence |
The per-furniture-category average weights of items sold. |
2019-08-31 |
164 x 3 |
2021-05-13 |
Alloa Community Enterprises |
Alloa Community Enterprises |
|||
The per-accounting-period per-furniture-category counts of items sold. |
2019-08-31 |
175 x 4 |
2021-05-13 |
Alloa Community Enterprises |
Alloa Community Enterprises |
|||
A per-furniture-category mapping to a Scottish Carbon Metric material. |
2019-08-31 |
164 x 3 |
2021-05-13 |
DCS |
DCS |
|||
The categorised quantities of the waste collected from household bins. |
2021-08-31 |
145 x 7 |
2021-09-23 |
Stirling council |
||||
The categorised quantities of the waste generated by industry & commerce. |
2018-12-31 |
8976 x 4 |
2021-01-18 |
SEPA |
||||
The categorised quantities of the waste generated by industry & commerce. |
2018-12-31 |
2640 x 4 |
2021-01-18 |
SEPA |
||||
Per-material weight-multipliers to calaculate CO2e amounts. This data has been copied from section 6.2 of The Scottish Carbon Metric. |
37 x 2 |
2021-07-12 |
ZWS |
|||||
EWC (European Waste Classification) codes and descriptions. Also a mapping to SEPA’s materials classification. |
973 x 3 |
2021-02-14 |
European Commission of the EU |
|||||
The per-year per-quarter per-material amount (weight and CO2e) of reused items. |
2021-09-30 |
390 x 7 |
2021-11-17 |
The Fair Share |
The Fair Share |
|||
Occupied residential dwelling counts. Useful for calculating per-household amounts. |
2020-12-31 |
320 x 3 |
2021-09-24 |
NRS |
||||
The carbon impact of the waste generated by household. |
2019-12-31 |
288 x 3 |
2021-01-30 |
SEPA |
||||
The categorised quantities of the ('managed') waste generated by household. |
2019-12-31 |
19008 x 5 |
2021-09-24 |
SEPA |
||||
(An anonymised subset of) An analysis of sampled bin collection contents. |
2014-03-14 |
1440 x 7 |
2020-10-07 |
ZWS |
ZWS |
|||
Meta level information. |
21 x 10 |
DCS |
DCS |
|||||
People counts. Useful for calculating per-citizen amounts. |
2019-12-31 |
288 x 3 |
2021-09-24 |
NRS |
||||
Scottish council areas with UK government codes and Wikidata IDs. |
34 x 3 |
DCS |
DCS |
|||||
SEPA’s waste materials classification. |
34 x 1 |
2021-02-15 |
SEPA |
|||||
The per-day number of people visiting the store. |
2021-04-14 |
360 x 3 |
2021-04-30 |
Transition Stirling |
Transition Stirling |
|||
The per-day amount of food flowing in/out of the organisation from/to partner organisations. |
2021-04-14 |
1350 x 4 |
2021-04-30 |
Transition Stirling |
Transition Stirling |
|||
The locations, services, capacities and per-year I/O of waste sites. |
2019-12-31 |
1254 x 13 |
2021-02-04 |
SEPA |
||||
The per-year per-material I/O of waste sites. |
2020-03-31 |
118333 x 5 |
2021-02-04 |
SEPA |