Hi, I've just released version 0.2 of osm2postgresql. The result is now easier to use with QGIS, thanks to a "class" field in each table (polygons, ways, nodes_with_tags) on which you can build your symbology.
Other features: # Fixes small streams, canals... on riverbanks (nicer rendering with QGIS, and labels from rivers no longer go in the middle of lakes!) # Keeps [almost] ALL tags (in two fields: 'tags' as text and 'tagshstore' as hstore): you may fine-tune your rendering with the 'tags' field using QGIS's rule-based renderer. # Optional: installs a postgres server and configure it; create a database (with postgis and hstore) # Loads OSM data into the database and process it; creates and fixes polygons This is still a work in progress. Hope it helps. Links: http://sourceforge.net/projects/osm2postgresql/ http://www.qgis.org/wiki/Using_OpenStreetMap_data http://wiki.openstreetmap.org/wiki/Osm2postgresql Mayeul Le dimanche 06 mars 2011 à 22:51 +0100, Mayeul Kauffmann a écrit : > Hi, > To help the use of OSM data in QGIS: > I created a bash script to automate the installation and configuration > of postgresql, to create a database (with postgis and hstore), to > download and run osmosis, load the data into postgres and process them > for displaying them on QGIS. The first steps are optional. > The script is available at: > http://sourceforge.net/projects/osm2postgresql/ > > The idea came from kimaidou's comment below. > It's not yet for linux beginners. It still needs some improvement but > with it I can do all the above in one command line. Ultimately I would > like to incorporate it somehow into QGIS to have a new OSM viewer. (I > discussed this with spatialite's developer but some postgres functions > are missing in sqlite.) > > Mayeul > > Le lundi 21 février 2011 à 09:17 +0100, kimaidou a écrit : > > Hi Mayeul and devs, > > > > Mayeul, I had a look at your wiki page which describes how to get and > > use OSM data. I think you should speak a bit more about pre-processed > > shapefiles, as it is much easier for people with no server/time/skills > > to open a shapefile in Qgis than setting up a complete OSM > > postgresql/postgis database. > > > _______________________________________________ > Qgis-developer mailing list > Qgis-developer@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/qgis-developer _______________________________________________ Qgis-developer mailing list Qgis-developer@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer