Is there any way to get region -> city -> road database for some specific country. In this case I need For Germany and Austria. Databases I'm working with is PostgreSQL with PostGIS extension.

Where can I get this?

  1. Data: Names of counties(regions), cities and roads. (Coordinates are bonus). Possible structure: county has many cities and roads. Road can belong to county and city or only county.
  2. Context: Georeferencing static retroreflection testing of road signs;
  3. Region: Germany and Austria;
  4. License: Possible open dat;
  5. Format: Simple tables, CSV or other of requested data;
  6. Authority: It's important to be checked data;
  7. Non-answers: Was seeking for something like this. But lack of data.
  • This question is vastly more suited to GIS.SE where it started. There is already a global database of open road data called Open Street Map, and most of the people who will be able to answer questions about it reside on that site. – John Powell May 31 '18 at 14:53
  • see this answer opendata.stackexchange.com/a/12430/1511, using the DACH file from OSM (geofabrik download) download.geofabrik.de/europe/dach.html – philshem Jun 1 '18 at 6:41
  • Thanks, Geofabrik was the thing I was looking for. – code monkey Jun 1 '18 at 10:10
  • marked as closed, based on the answer in the comments – philshem Jun 1 '18 at 13:38