[Qgis-user] PostGIS database creation wizzard

[Noli Sicad]

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 <mayeul.kauffmann at free.fr> 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 <bareman at tpg.com.au> 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
>>         Qgis-user at lists.osgeo.org
>>         http://lists.osgeo.org/mailman/listinfo/qgis-user
>>
>> _______________________________________________
>> Qgis-user mailing list
>> Qgis-user at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/qgis-user
>
>
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-user
>