Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

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

1 Answer

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
ORDER BY amenity DESC

http://gfoss.sigaberto.org/?tag=osm-postgis

share|improve this answer
add comment

Your Answer

 
discard

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.