Im using OSM data as osm2pgsql-import (from extract.bbbike.org). And I want to draw all attractions ("tourism" = 'attraction').
The most of the attractions I found in the planet_osm_point table. But some are missing. I found them in the planet_osm_polygon table.
For example: A very important church and attraction is a building-shape in the polygon-table and is missing in the points table.
But I will draw ALL attractions as a point in a point-layer in my qgis. I’m sure that there is a elegant solution with postgis - but I’m very new to postgis and have no idea where to start.
To draw the points layer AND the polygon-centroids together is no solution for me.