[Qgis-developer] Easy postgres setup and OSM pre-processing for QGIS [v.0.2]

[Mayeul Kauffmann]

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 at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-developer