I was inspired by someone else's work to try finding the Berlin property farthest from a subway station. In order to do that, I will need two things:

First, I need a shapefile of all the building addresses in Berlin. I believe I have found this here: http://opendata.esri-de.opendata.arcgis.com/datasets/d4ac5d6ff99140819d2033038664096c_0

I will also need a shapefile showing all the subway (U-Bahn) entrances in Berlin. Does anyone know of such a shapefile?

Bonus heaps of gratitude will come your way if you can dig up a shapefile of S-Bahn stations as well, though this is not strictly necessary. Note that I am looking for the entrances/stations, rather than the lines themselves.

Assuming I can locate a shapefile showing U-Bahn lines, I will be doing my analysis using python and QGIS. Here is the original inspiration for this project:



You could try using Overpass Turbo which can locate subway entrances in Berlin. You can click here to see the results or type the following query in the Overpass command box:



Overpass Turbo

To extract the data, click the Extract button and choose the file type (I chose .kml):

Export data

You can then load the exported data into your GIS software:


  • 2
    With the QuickOSM plugin, you get the Overpass results directly into QGIS as a points shapefile or geojson layer. Note that the kml format might loose some attributes. – AndreJ Oct 18 '16 at 9:53
  • @Patrick - Most welcome =) – Joseph Oct 20 '16 at 8:51

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.