Hi, (sorry for late reply) You can use osm2postgresql (different from osm2pgsql) and run pgrouting on top of it. See: http://wiki.openstreetmap.org/wiki/Osm2postgresql
It has built-in reprojection. If you need a simpler tool or sql-only code, you can look at the osm2postgresql code (bash file), you will find a lot of examples. Regards, Mayeul Le lundi 11 juillet 2011 à 09:01 -0700, jchen a écrit : > Hello, > > I need a postgresql database to do following jobs: > 1. A lot of shortest path tree constructions given an root node. > 2. A huge amount of queries for length of roads. ( any suggestion for > converting the coordinates to Cartesian system?) > 3. A few queries for nearby nodes given a point. > > Actually, I need these jobs for my map matching application. > > I tried to use osm2pgsql to generate a database. But it seems not > simple/efficient to accomplish job 1. I haven't tried others. And I hope > that I can get some useful information here. > > Thank you in advance! > > Best regards. > > Jingmin > > -- > View this message in context: > http://gis.638310.n2.nabble.com/Which-OSM-to-PostGreSQL-converter-shall-I-use-tp6571476p6571476.html > Sent from the Developer Discussion mailing list archive at Nabble.com. > > _______________________________________________ > dev mailing list > [email protected] > http://lists.openstreetmap.org/listinfo/dev _______________________________________________ dev mailing list [email protected] http://lists.openstreetmap.org/listinfo/dev
