[OSM-dev] Which OSM to PostGreSQL converter shall I use?
mayeul.kauffmann at free.fr
Tue Aug 2 19:43:58 BST 2011
(sorry for late reply)
You can use osm2postgresql (different from osm2pgsql) and run pgrouting
on top of it. See:
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.
Le lundi 11 juillet 2011 à 09:01 -0700, jchen a écrit :
> 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.
> 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
> dev at openstreetmap.org
More information about the dev