Skip to content
This repository has been archived by the owner on Feb 1, 2022. It is now read-only.

Convert landkreise.ods to landkreise.csv #64

Open
dasmur opened this issue Jun 14, 2020 · 4 comments
Open

Convert landkreise.ods to landkreise.csv #64

dasmur opened this issue Jun 14, 2020 · 4 comments

Comments

@dasmur
Copy link
Contributor

dasmur commented Jun 14, 2020

I think, it would be really awesome to convert the overview sheet from .ods to .csv.

Advantages:

  • github is able to render CSV files (see Rendering CSV and TSV data) and also includes a search bar. This would ease the process for anyone interested in this project to get a quick overview without having to download and open the sheet.
  • .csv is a plain-text file format and hence, changes to that file can easily be tracked and managed by git and humans.
@dadosch
Copy link
Collaborator

dadosch commented Jun 14, 2020

we actually had it as csv, but I think it was too large for github to display it (but I may be wrong here, I can't remember for sure.

Btw, I'm curios: How did you find this project? ;)

@dasmur
Copy link
Contributor Author

dasmur commented Jun 14, 2020

@dadosch Honestly, I had to check if github actually has a file size limit, because I totally missed this aspect and indeed, there exists a limit at 512 KB (it is even mentioned within the referenced page). Afterwards, I did a quick test and converted the current sheet locally to .csv which produced a file with approx. 17KB, hence this should be fine for github.
But even if this would exceed the limit at some point in future, I think the second aspect (plain-text) should not be underestimated. Since this file has to be modified for every new county added, errors can easily be introduced without noticing it and it can be really hard to track them down.

@dasmur
Copy link
Contributor Author

dasmur commented Jun 14, 2020

Regarding your second question (me find this project): Actually, I planned to use R to do some statistics on current corona data. In the beginning, I tried to use the RKI provided data on arcgis, but I was not able to identify the corresponding API documentation in a bearable amount of time. Hence, I searched for projects on github using the API (to be more precisely, I searched for any project being related to "corona germany" ;) ) in order to understand the usage. Even though, your project was not directly related to this goal, I liked the general idea.

@dadosch
Copy link
Collaborator

dadosch commented Jun 14, 2020

Regarding your second question (me find this project): Actually, I planned to use R to do some statistics on current corona data. In the beginning, I tried to use the RKI provided data on arcgis, but I was not able to identify the corresponding API documentation in a bearable amount of time. Hence, I searched for projects on github using the API (to be more precisely, I searched for any project being related to "corona germany" ;) ) in order to understand the usage. Even though, your project was not directly related to this goal, I liked the general idea.

Btw, do you know the efforts of "Risklayer, Karlsruhe"? They crowdsource every Kreis each day (without scripts, just humans) https://docs.google.com/spreadsheets/d/1wg-s4_Lz2Stil6spQEYFdZaBEp8nWW26gVyfHqvcl8s/edit

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants