[OSM-dev] Which OSM to PostGreSQL converter shall I use?

jchen jingmin.chen at epfl.ch
Wed Aug 3 12:28:51 BST 2011


Thank you for your information.
Actually, I used osm2pgrouting  to get topological structure and osmosis to get other information since I also need the references to the nodes in ways and other tags information.


On Aug 2, 2011, at 8:44 PM, Mayeul Kauffmann [via GIS] wrote:

(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 :

> 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<http://Nabble.com>.
> _______________________________________________
> dev mailing list
> [hidden email]<x-msg://40/user/SendEmail.jtp?type=node&node=6645977&i=0>
> http://lists.openstreetmap.org/listinfo/dev

dev mailing list
[hidden email]<x-msg://40/user/SendEmail.jtp?type=node&node=6645977&i=1>

If you reply to this email, your message will be added to the discussion below:
To unsubscribe from Which OSM to PostGreSQL converter shall I use?, click here<http://gis.638310.n2.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=6571476&code=amluZ21pbi5jaGVuQGVwZmwuY2h8NjU3MTQ3NnwxMjMxMTg4NzI=>.

View this message in context: http://gis.638310.n2.nabble.com/Which-OSM-to-PostGreSQL-converter-shall-I-use-tp6571476p6648368.html
Sent from the Developer Discussion mailing list archive at Nabble.com.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/dev/attachments/20110803/0dc760b9/attachment.html>

More information about the dev mailing list