Hi, I developed osm2postgresql, so I can speak for this. It is based on osmosis, uses hstore storage, and does a lot of postprocessing (filtering buggy polygons, putting holes and multipart together based on geographical and tag criteria, generates meta-classes, etc.) If you want to do advanced queries, optimise them (e.g. index the hstore...) you will find quite many sql examples in the source code itself: http://sourceforge.net/projects/osm2postgresql/files/ Do not hesitate to ask questions or make suggestions on this tool, in this list or here: http://sourceforge.net/projects/osm2postgresql/forums (use the Help forum; or the "Open discussion" forum if you have a sourceforge login).
Hope this helps. Mayeulk _______________________________________________ dev mailing list [email protected] http://lists.openstreetmap.org/listinfo/dev
