In my opinion, one of the biggest disadvantages of the pgsnapshot schema of Osmosis (compared to e.g. osm2gpsql) is the missing multipolygon support.
Years ago I created scripts for the OpenStreetBrowser, based on a pgsimple import (pgsnapshot was not yet available at that time), for multipolygon support and derivative tables. Those scripts were never released separately and therefore nobody knows about them (I guess). Now, I just adapted them to the pgsnapshot schema and Postgis 2.0 and concentrated on the multipolygon support (no derivative tables any more) and released them as separate repository: https://github.com/plepe/osmosis-multipolygon After an initial osmosis pgsnapshot import, you load those scripts and they will create a simple 'multipolygons' table with the columns: ( relation_id, tags, geometry ). If you use replication to keep your database up-to-date, the 'multipolygons' table will also update (the scripts overwrite the osmosisUpdate() function). Have fun! greetings, Stephan -- Seid unbequem, seid Sand, nicht Öl im Getriebe der Welt! - Günther Eich ,---------------------------------------------------------------------. | Stephan Bösch-Plepelits, | | Technische Universität Wien - Studien Informatik & Raumplanung | | Projects: | | > openstreetbrowser.org > couchsurfing.org > tubasis.at > bl.mud.at | | Contact: | | > Mail: [email protected] > Blog: plepe.at | | > Twitter: twitter.com/plepe > Jabber: [email protected] | `---------------------------------------------------------------------' _______________________________________________ dev mailing list [email protected] https://lists.openstreetmap.org/listinfo/dev
