One of my big frustrations is that sometimes the information you need already exists somewhere, but you can’t get it. That’s what I had when I wanted to map Brussels’ train stations for use in an Android application. So I had only one option left: map it manually and see how I could get it loaded into my database.
I did not want to install an application for just a simple conversion, so I thought I would map the stations in Google Earth and save it as a KML, so I could read out the placemark names, latitudes, longitudes and altitudes to import them into my database using the CSV format. I made a little script that you could also use. It’s available here.
The script does nothing spectactular: it just looks up particular tags using xpath and formats it as a CSV. You have the option to download it or to just copy-paste the result from the web pages. Enjoy!
Go to Simple KML to CSV converter.
It‘s quite in here! Why not leave a response?