Correction, I was not using osm2postgresql but osm2pgsql http://wiki.openstreetmap.org/wiki/Osm2pgsql
Thanks. Noli On 3/9/12, Noli Sicad <[email protected]> wrote: > 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
