Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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
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


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.