New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Package Basel OGD datasets #11

Closed
loleg opened this Issue Feb 9, 2018 · 3 comments

Comments

Projects
None yet
1 participant
@loleg
Copy link
Contributor

loleg commented Feb 9, 2018

A number of datasets were suggested by the administration of the Canton of Basel for the upcoming Hackdays. The following information is being translated, converted, and put into a Data Package: https://github.com/foodopendata/foodstats-basel


Wir haben rund um das Thema Food veröffentlichte Geodaten und Statistikdaten. Beides sind offene Daten, jedoch noch keine state of the art OGD. D.h. sie sind noch nicht nachhaltig veröffentlicht. Konkret handelt es sich um folgende Datensätze: z.B. http://www.statistik.bs.ch/zahlen/tabellen.html

Aussenhandel

Exporte

  • T06.4.01 - Export nach Gewicht und Wert (monatliche Werte)
  • T06.4.02 - Export nach Verkehrsträger und Warengruppe
  • T06.4.03 - Export nach Verkehrsträger, Warengruppen und Wert 

Importe

  • T06.4.04 - Einfuhr nach Gewicht und Wert (monatliche Werte)
  • T06.4.05 - nach Verkehrsträger und Warengruppen in Netto-Tonnen
  • T06.4.06 - nach Verkehrsträger, Warengruppen und Wert

Transit

Landwirtschaft

Betriebe, Flächen, Tiere

Beide Themen sind auch im Indikatoren Portal und im Basler Atlas zu finden und können dort als CSV heruntergeladen/exportiert werden:

Leider nur auf dem Stadtplan und auf der Stadtplan-App angezeigt, (noch) nicht als einzelne Datensätze vorhanden:

@loleg

This comment has been minimized.

Copy link
Contributor Author

loleg commented Feb 16, 2018

We started a Data Package for the Landwirtschaft (Agriculture) data: https://github.com/foodopendata/foodstats-basel

Working screenshots

screenshot from 2018-02-16 23-39-35
Aggregating the data in Calc

screenshot from 2018-02-16 23-10-42
Inferring the schema using datapackage-py

screenshot from 2018-02-16 23-02-27
Inferring the schema using tableschema-jl (just for fun)

screenshot from 2018-02-16 23-42-32
Fixing validation errors from goodtables.io using Atom editor at midnight 🌃

screenshot from 2018-02-16 23-48-13
Yay! 🎉

@loleg loleg closed this Feb 16, 2018

@loleg

This comment has been minimized.

Copy link
Contributor Author

loleg commented Feb 19, 2018

Fun facts from this data, shared in the Hackdays team chat last weekend:

Chemical products account for 10x the value of all other products from the city combined

In 2016, according to T06.4.03.

The only industries visible on the graph of exports are textiles and precision machinery

screenshot from 2018-02-17 00-27-37

This is also the product group that accounts for more than 50% of the export by weight

screenshot from 2018-02-17 00-30-06

Recycling and waste accounting for about a quarter of the rest.

Just a couple decades ago at least, there was a sizeable population of agriculture workers

screenshot from 2018-02-17 00-32-05

Now it's stabilized at around 50 in the entire canton. (It's a small canton). That must be a hard working bunch, shipping 22'000 tonnes (2016) of product per year!

@loleg

This comment has been minimized.

Copy link
Contributor Author

loleg commented Feb 22, 2018

The Data Package has also been uploaded to the new DataHub for testing, though we are planning to publish it and others like it under an organisation and not private account. See:

https://datahub.io/loleg/foodstats-basel

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment