I need to extract all cities with lat lon coords from Czech Republic OSM with English names of suburb and cities. This is how I imported OSM file downloaded from Geofabrik:
Import went without errors. Then I used this 2 queries to extract lat lon coords and names of suburb and cities:
Example:
It's all done well, but I got only names on Czech language. How to get the same list but with English names of suburb and cities? asked 21 Sep '21, 16:13 akulin |
You have not imported the English names into your database. You will need to either modify the "style file" that comes with osm2pgsql to load the Then you can select answered 21 Sep '21, 16:37 Frederik Ramm ♦ 1
Akuli, please also keep in mind that not all places you are looking for will have a
(22 Sep '21, 08:20)
TZorn
|