[Qgis-user] PostGIS database creation wizzard
Noli Sicad
nsicad at gmail.com
Thu Mar 8 13:05:47 PST 2012
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
>>
>
More information about the Qgis-user
mailing list