[OSM-dev] Ways and tags to separate tables?

2010-02-04 Thread Jukka Rahkonen
Hi, Osm2pgsql is fine and fast utility for importing OSM data into PostGIS, but it is mainly made for Mapnik rendering. For that it is OK to import just a subset of tags and make a wide schema with an own column for each tag. However, sometimes it would nice to get all the tags available in some

Re: [OSM-dev] Ways and tags to separate tables?

2010-02-04 Thread jamesmikedup...@googlemail.com
you could run a tagscanner tool like I have posted elsewhere and then just generate a stylesheet. It would be possible to modify the osm2pgsql tool, I have patches for it as well. Right now I am a bit busy, but when I have nothing to do; could look into it. mike On Thu, Feb 4, 2010 at 11:34 AM,

Re: [OSM-dev] Ways and tags to separate tables?

2010-02-04 Thread Frederik Ramm
Hi, Jukka Rahkonen wrote: Has anybody made yet a tool which separates ways and tags to different tables? Yes, Brett Henderson has, it's called Osmosis ;-) Osmosis can generate a database schema that has all the data plus geometry columns. Bye Frederik

Re: [OSM-dev] Ways and tags to separate tables?

2010-02-04 Thread Jukka Rahkonen
Frederik Ramm frederik at remote.org writes: Hi, Jukka Rahkonen wrote: Has anybody made yet a tool which separates ways and tags to different tables? Yes, Brett Henderson has, it's called Osmosis Osmosis can generate a database schema that has all the data plus geometry columns.

Re: [OSM-dev] Ways and tags to separate tables?

2010-02-04 Thread Emilie Laffray
On 4 February 2010 11:00, Jukka Rahkonen jukka.rahko...@mmmtike.fi wrote: Frederik Ramm frederik at remote.org writes: Hi, Jukka Rahkonen wrote: Has anybody made yet a tool which separates ways and tags to different tables? Yes, Brett Henderson has, it's called Osmosis Osmosis