[Qgis-user] PostGIS database creation wizzard

[Noli Sicad]

Correction, I was not using osm2postgresql but osm2pgsql

http://wiki.openstreetmap.org/wiki/Osm2pgsql

Thanks.

Noli

On 3/9/12, Noli Sicad <nsicad at gmail.com> 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 <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
>>
>