Recently, I wanted to display the places of residence of the members of my club on a map for a personal gimmick (IGOC members). I knew the addresses of the club members. But not the coordinates of their places of residence.
So I went in search of the coordinates and found what I was looking for at the Federal Office of Topography (swisstopo).
The data is available there as a CSV file. Details here: Swiss town coordinates.
How do I load this data into a database?
Loading the data with MariaDB/MySQL
MariaDB …
