Take the 2-minute tour ×

I have an OpenStreetMap PostGIS database and would like to select specific data (for example all shops) of each tile (on a defined zoomlevel) on the planet. Is this possible to achieve and if yes, how?

share|improve this question
you need to retrieve vector data from postgis not raster - if your osm data is vector you can filter the subtype. –  Mapperz May 24 '12 at 17:21
I am sorry, but I'm a beginner to PostGIS. Could you maybe explain step by step what I have to do and point me to the documentation I should read? Thanks for any kind of help. –  Zahnfee May 30 '12 at 9:17

1 Answer 1

up vote 1 down vote accepted

Retrieve data in POSTGIS:

You need to import OSM vector data and then using postgis and qgis (Qauntum GIS) you can visualise your query results

PostGIS retrieval of amenity

SELECT amenity, name
FROM osm.osm_point
Group by amenity, name


share|improve this answer

Your Answer


