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

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


Hi,

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.

Br,

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

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<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>
http://lists.openstreetmap.org/listinfo/dev


________________________________
If you reply to this email, your message will be added to the discussion below:
http://gis.638310.n2.nabble.com/Which-OSM-to-PostGreSQL-converter-shall-I-use-tp6571476p6645977.html
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