To say it upfront: This is a question that has already come up before in Stack Overflow but did not provide a manageable and legal solution for my problem (see below).

I have a database (in STATA format) of around 1,3 million addresses in Germany with street name, house number, zip code and city stored separately in different variables. For each of those I need the longitude and latitude which I then want to store in a (local) database and use later on in a statistical analysis (in the context of a research project). Note that this is a one-time request for each of those addresses!

Essentially, this poses four requirements on the service to be used:

  1. It needs to cover Germany (in particular its rural areas)
  2. It needs to be sufficiently exact, i.e. I am willing to take the imprecision of around 100m relative to the object placed at the corresponding address, preferably less of course
  3. My usage needs to comply with the terms of services
  4. It should be for free or the price should be reasonable / It should take a reasonable time to obtain the data (<= 4 weeks)

Before I look into licenses for commercial usage, I want to get an overview of free / reasonable priced services. Seen against this background, the third condition seems to rule out the big players like Google and Yahoo since they do not allow to store the data (see also discussion in GIS SE at Geocode address once in google maps, save in database, read geocoded result from there on).

I checked with an employee of Google Germany who claimed they would charge 10,000 EUR (which appears to be way too high, though).

Do any services come to your mind that suit those requirements? If so, do program codes exists to collect and store the data?

I have also raised this question in Stack Overflow where it was put on hold. Since I did not find restrictions for this kind of "preference question" for the GIS Q&A section, I am posting it here.


1 Answer 1


Geocode.xyz is free and covers Germany: http://geocode.xyz/DE (both forward and reverse geocoding)


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