[Qgis-user] PostGIS database creation wizzard

[Mayeul Kauffmann]

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