Last time, I used osm2postgresql, I had difficulties using it in PostgeSQL 9.x, but works in PostgreSQL 8.x.
Here's screenshot using Australia.osm.pbf, QGIS 1.7.1 mac os x and SVN osm2postgresql https://picasaweb.google.com/116847891529748214201/PostGISPostgreSQLOSM2PGSQLOSMToPostgreSQLAndQGIS171#5661639420915526386 Regards, Noli On 3/9/12, Mayeul Kauffmann <[email protected]> wrote: > Hi, > The tools mentioned are nice but hstore format is not recognised by > qgis. > That's why I created osm2postgresql: it's tailored to keep as much > information as possible (keep all tags; a few broken polygons are kept > as lines, a very few features that would crash postgis are kept as > nodes), and be accessible with QGIS. > You can filter directly within qgis using a full text representation of > the hstore. > Demo here: > http://www.youtube.com/watch?v=NBBYtH2svw0 > > If you are not on Linux, do not worry! Latest version was customized and > tested to work in a virtual machine. > More here: > http://wiki.openstreetmap.org/wiki/Osm2postgresql > > Even if you do not want to use the bash script, the sql code within the > script will give you many ideas. > No need to login to ask help in the help forum: > http://sourceforge.net/projects/osm2postgresql/forums/forum/1683571 > Regards, > Mayeul > > > > ----------------- > Mayeul Kauffmann > Le lundi 05 mars 2012 à 09:56 +0000, Alexandre Neto a écrit : >> the book "Postgis in action" has a very good explanation about >> Organizing spatial data, and the example used includes uploading a OSM >> database from Paris, using different data models. >> >> >> Also, Bostongis has a very nice tutorial of Loading OpenStreetMap >> data into PostGIS: An Almost Idiot's Guide >> >> >> Hope it helps. >> >> >> Alexandre Neto >> >> On Sun, Mar 4, 2012 at 4:26 AM, mick <[email protected]> wrote: >> I'm having a devil of a time getting my head around creating >> database to store parts of the open street map dataset. >> >> I wish to store some of the elements (relating to the >> landscape and the Roman occupation of Britain with the >> possibility of adding other periods) and only relevant tag >> values. >> >> Is there a wizzard that can help with this task or a genius >> who could develop one. >> >> My thoughts on the process are: >> >> scan the .osm file and create a list of keys that have been >> used >> >> present the list of keys for inclusion or exclusion >> >> produce code to create the table(s) according to the >> selections above >> >> create a process to import the file. >> >> I have no idea how much effort this would take or how >> universal this kind of tool would be. If it is too much work >> and/or too specific a few hints might get me going. >> >> mick >> _______________________________________________ >> Qgis-user mailing list >> [email protected] >> http://lists.osgeo.org/mailman/listinfo/qgis-user >> >> _______________________________________________ >> Qgis-user mailing list >> [email protected] >> http://lists.osgeo.org/mailman/listinfo/qgis-user > > > _______________________________________________ > Qgis-user mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/qgis-user > _______________________________________________ Qgis-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/qgis-user
