Extract all cities with lat lon coords from Slovakia

Question

I need to extract all cities with lat lon coords from Slovakia OSM.

This is how I imported OSM file downloaded from Geofabrik:

osm2pgsql --slim --username postgres --database gis --hstore slovakia-latest.osm
psql -U postgres -d gis
CREATE EXTENSION hstore;

Import went without errors.

What SELECT query should be to see 3 tables (city, latitude, longitude)?

Answer 1

0	`SELECT name, st_astext(st_transform(way, 4326)) FROM planet_osm_point WHERE place='city' OR place='town' ORDER BY name;` permanent link answered 21 Sep '21, 16:04 akulin 21●3●3●6 accept rate: 0% edited 22 Sep '21, 11:35