[Qgis-user] PostGIS database creation wizzard

[mick]

On Fri, 9 Mar 2012 08:05:47 +1100
Noli Sicad <nsicad at gmail.com> wrote:

Thanks to all who offered advice, I'm still looking into what is most comfortable for me, in between hospital stays, so its taking me more effort and time than usual.

mick

> 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