zdavatz / covid19_ch

covid19 map for Switzerland using Esri Maps.
http://covid19.ddrobotec.com
GNU General Public License v3.0
23 stars 8 forks source link

Show measures taken by Cantons on Map. #3

Open zdavatz opened 4 years ago

zdavatz commented 4 years ago

Measures_Corona_20_3.txt

zdavatz commented 4 years ago

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

JudithBouman2412 commented 4 years ago

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

zdavatz commented 4 years ago

Super Danke!

zdavatz commented 4 years ago

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

zdavatz commented 4 years ago

Can you use ; as delimiter?

JudithBouman2412 commented 4 years ago

Measures_Corona_20_3_location_2.txt

zdavatz commented 4 years ago

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 commented 4 years ago

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

baffelli commented 4 years ago

I will manually merge everything. Will take a while.

zdavatz commented 4 years ago

Ok, thank you!

baffelli commented 4 years ago

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

zdavatz commented 4 years ago

No problem. Just validate your file please.

kyrandesa commented 4 years ago

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)

zdavatz commented 4 years ago

good idea!

zdavatz commented 4 years ago

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

baffelli commented 4 years ago

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.

zdavatz commented 4 years ago

Yes please!

baffelli commented 4 years ago

Do you still need the wide format?

zdavatz commented 4 years ago

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