covid19_ch icon indicating copy to clipboard operation
covid19_ch copied to clipboard

Show measures taken by Cantons on Map.

Open zdavatz opened this issue 4 years ago • 19 comments

Can you group the measure by Longitue and Latitude of the Cantons? Then we can put them on a Map. See here: https://github.com/zdavatz/covid19_ch/blob/master/data-cantons-csv/dd-covid19-ch-cantons-latest.csv

zdavatz avatar Mar 20 '20 10:03 zdavatz

I added the latitude and longitude here, for each canton I took the values of the Capital. Hope this helps!

Measures_Corona_20_3_location.txt

JudithBouman2412 avatar Mar 20 '20 11:03 JudithBouman2412

Super Danke!

zdavatz avatar Mar 20 '20 11:03 zdavatz

I will commit the file now, so you can send me a pull request later.

zdavatz avatar Mar 20 '20 11:03 zdavatz

Can you use ; as delimiter?

zdavatz avatar Mar 20 '20 11:03 zdavatz

file has been committed:

https://github.com/zdavatz/covid19_ch/commit/b3c94f39634212330ac0f346b6be75ae6410930f

Thank you!

@JudithBouman2412 Can you clone our Repo now, so you can send PRs in the future with updates?

zdavatz avatar Mar 20 '20 12:03 zdavatz

@JudithBouman2412 please see https://github.com/baffelli/covid-2019-measures/issues/2 @baffelli is collecting data as well. Please also start talking to him.

zdavatz avatar Mar 20 '20 13:03 zdavatz

I will manually merge everything. Will take a while.

baffelli avatar Mar 20 '20 13:03 baffelli

Ok, thank you!

zdavatz avatar Mar 20 '20 13:03 zdavatz

Can your scripts deal with long data formats? I can prepare an adapter otherwise

baffelli avatar Mar 20 '20 13:03 baffelli

No problem. Just validate your file please.

zdavatz avatar Mar 20 '20 13:03 zdavatz

You could try using that new tool from swisstopo: https://www.geo.admin.ch/de/news/aktuell.detail.news.html/geo-internet/news2019/news20190307.html - works also with cities (sadly not with cantons)

kyrandesa avatar Mar 20 '20 14:03 kyrandesa

good idea!

zdavatz avatar Mar 20 '20 14:03 zdavatz

file is now here: https://github.com/zdavatz/covid19_ch/tree/master/additional-infos

zdavatz avatar Mar 21 '20 09:03 zdavatz

So when I’m done with my dataset should I reformat it to wide format for your visualization? I can prepare an R script for that and create a PR Da: Zeno R.R. Davatz Inviato: sabato, 21 marzo 2020 10:46 A: zdavatz/covid19_ch Cc: Simone Baffelli; Mention Oggetto: Re: [zdavatz/covid19_ch] Show measures taken by Cantons on Map. (#3)

file is now here: https://github.com/zdavatz/covid19_ch/tree/master/additional-infos — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub, or unsubscribe.

baffelli avatar Mar 21 '20 09:03 baffelli

Yes please!

zdavatz avatar Mar 21 '20 09:03 zdavatz

Do you still need the wide format?

baffelli avatar Mar 26 '20 09:03 baffelli

You can change it if you have a better solution and send a PR please.

zdavatz avatar Mar 26 '20 09:03 zdavatz