AW: [pgrouting-dev] General question for understanding

[Hens,Markus M.]

hi,

I played a little bit around with OSGEO live tools.
I Understand that mapconfig.xml defines the relevant tags and that you have to add costs to these tags.
I did not understand if for example a way has a tag bridge=yes and a tag highway=motorway this way is saved two times in the db because every way has only one class_id.
how is it handled if there are two relevant tags for one way?

Best regards,

Markus
________________________________________
Von: pgrouting-dev-bounces at lists.osgeo.org [pgrouting-dev-bounces at lists.osgeo.org] im Auftrag von Daniel Kastl [daniel at georepublic.de]
Gesendet: Montag, 14. Februar 2011 15:25
An: pgRouting developers mailing list
Betreff: Re: [pgrouting-dev] General question for understanding

2011/2/14 Hens,Markus M. <m.hens at student.fontys.nl<mailto:m.hens at student.fontys.nl>>
Ok this is an good idea. I will do this. I only like to know if WRS is still up to date or an obsolete project. It would fit all my desires:-)


I can't say it's active anymore. I think I even didn't move the source code to Github when pgRouting migrated to Git. It didn't really fit and the documentation wasn't sufficient.
Georepublic is working on similar (more extended) project like the one called "WRS", but it's not that much done yet that we can make the source code available.

Daniel









Best regards
________________________________________
Von: pgrouting-dev-bounces at lists.osgeo.org<mailto:pgrouting-dev-bounces at lists.osgeo.org> [pgrouting-dev-bounces at lists.osgeo.org<mailto:pgrouting-dev-bounces at lists.osgeo.org>] im Auftrag von Daniel Kastl [daniel at georepublic.de<mailto:daniel at georepublic.de>]
Gesendet: Montag, 14. Februar 2011 14:40
An: pgRouting developers mailing list
Betreff: Re: [pgrouting-dev] General question for understanding

2011/2/14 Hens,Markus M. <m.hens at student.fontys.nl<mailto:m.hens at student.fontys.nl><mailto:m.hens at student.fontys.nl<mailto:m.hens at student.fontys.nl>>>
Hey Daniel,

Is it right, that only shooting star alg can handle turn restriction?
Does osm2pgrouting add the costs for me or do I have to add them on my own? So this would be much to do for only a little city:-) When I have one way , will osm2pgrouting add high costs for one direction automatically?


Hi Markus,

What about downloading the OSGeo Live DVD and taking one afternoon to do the workshop:
http://workshop.pgrouting.org/

This will for sure answer many of your questions.

Daniel

PS: http://www.ridethecity.com/ uses pgRouting and so you can see for example cities like there should be no problem.




Best regards,

Markus


________________________________________
Von: pgrouting-dev-bounces at lists.osgeo.org<mailto:pgrouting-dev-bounces at lists.osgeo.org><mailto:pgrouting-dev-bounces at lists.osgeo.org<mailto:pgrouting-dev-bounces at lists.osgeo.org>> [pgrouting-dev-bounces at lists.osgeo.org<mailto:pgrouting-dev-bounces at lists.osgeo.org><mailto:pgrouting-dev-bounces at lists.osgeo.org<mailto:pgrouting-dev-bounces at lists.osgeo.org>>] im Auftrag von Daniel Kastl [daniel at georepublic.de<mailto:daniel at georepublic.de><mailto:daniel at georepublic.de<mailto:daniel at georepublic.de>>]
Gesendet: Freitag, 11. Februar 2011 19:05
An: pgRouting developers mailing list
Betreff: Re: [pgrouting-dev] General question for understanding

2011/2/11 Hens,Markus M. <m.hens at student.fontys.nl<mailto:m.hens at student.fontys.nl><mailto:m.hens at student.fontys.nl<mailto:m.hens at student.fontys.nl>><mailto:m.hens at student.fontys.nl<mailto:m.hens at student.fontys.nl><mailto:m.hens at student.fontys.nl<mailto:m.hens at student.fontys.nl>>>>
Thank you for infos.

I will try. If i have further questions I will send an Email. But here comes my last for today: Are there experiences with pgRouting over complete planet.osm converted to routing db?

There was just someone reporting a few weeks ago that he could import all planet.osm ... but not with osm2pgrouting, I think.
But it's not really a good idea IMO. Coverage and quality can be very different for different regions, attributes might differ as well.
If you have a few days spare time to try the import, you can report us ;-)

pgRouting itself becomes slower with the amount of road data you select with your query. It doesn't matter how big the network is, that you imported, it matters how you make your query.

Daniel





________________________________________
Von: pgrouting-dev-bounces at lists.osgeo.org<mailto:pgrouting-dev-bounces at lists.osgeo.org><mailto:pgrouting-dev-bounces at lists.osgeo.org<mailto:pgrouting-dev-bounces at lists.osgeo.org>><mailto:pgrouting-dev-bounces at lists.osgeo.org<mailto:pgrouting-dev-bounces at lists.osgeo.org><mailto:pgrouting-dev-bounces at lists.osgeo.org<mailto:pgrouting-dev-bounces at lists.osgeo.org>>> [pgrouting-dev-bounces at lists.osgeo.org<mailto:pgrouting-dev-bounces at lists.osgeo.org><mailto:pgrouting-dev-bounces at lists.osgeo.org<mailto:pgrouting-dev-bounces at lists.osgeo.org>><mailto:pgrouting-dev-bounces at lists.osgeo.org<mailto:pgrouting-dev-bounces at lists.osgeo.org><mailto:pgrouting-dev-bounces at lists.osgeo.org<mailto:pgrouting-dev-bounces at lists.osgeo.org>>>] im Auftrag von Daniel Kastl [daniel at georepublic.de<mailto:daniel at georepublic.de><mailto:daniel at georepublic.de<mailto:daniel at georepublic.de>><mailto:daniel at georepublic.de<mailto:daniel at georepublic.de><mailto:daniel at georepublic.de<mailto:daniel at georepublic.de>>>]
Gesendet: Freitag, 11. Februar 2011 15:17
An: pgRouting developers mailing list
Betreff: Re: [pgrouting-dev] General question for understanding

Hi Markus.

It's only possible for nodes. But as somehow the vehicle that needs to pass this node also must pass one or more ways to this node, you could add the hight limitation as an attribute to the ways, right?
In you SQL query you could exclude all road links that contain a node that has a height limitation for example.

Daniel


2011/2/11 Hens,Markus M. <m.hens at student.fontys.nl<mailto:m.hens at student.fontys.nl><mailto:m.hens at student.fontys.nl<mailto:m.hens at student.fontys.nl>><mailto:m.hens at student.fontys.nl<mailto:m.hens at student.fontys.nl><mailto:m.hens at student.fontys.nl<mailto:m.hens at student.fontys.nl>>><mailto:m.hens at student.fontys.nl<mailto:m.hens at student.fontys.nl><mailto:m.hens at student.fontys.nl<mailto:m.hens at student.fontys.nl>><mailto:m.hens at student.fontys.nl<mailto:m.hens at student.fontys.nl><mailto:m.hens at student.fontys.nl<mailto:m.hens at student.fontys.nl>>>>>
Hi Daniel,

thank you for the information. I understand these informations but I have one more question.

If I have a node for example a bridge with an attribute for height and my vehicle is higher I would like to set the cost very high for the node.
My question is if it is possible to set cost for nodes or only for ways.

Markus
________________________________________
Von: pgrouting-dev-bounces at lists.osgeo.org<mailto:pgrouting-dev-bounces at lists.osgeo.org><mailto:pgrouting-dev-bounces at lists.osgeo.org<mailto:pgrouting-dev-bounces at lists.osgeo.org>><mailto:pgrouting-dev-bounces at lists.osgeo.org<mailto:pgrouting-dev-bounces at lists.osgeo.org><mailto:pgrouting-dev-bounces at lists.osgeo.org<mailto:pgrouting-dev-bounces at lists.osgeo.org>>><mailto:pgrouting-dev-bounces at lists.osgeo.org<mailto:pgrouting-dev-bounces at lists.osgeo.org><mailto:pgrouting-dev-bounces at lists.osgeo.org<mailto:pgrouting-dev-bounces at lists.osgeo.org>><mailto:pgrouting-dev-bounces at lists.osgeo.org<mailto:pgrouting-dev-bounces at lists.osgeo.org><mailto:pgrouting-dev-bounces at lists.osgeo.org<mailto:pgrouting-dev-bounces at lists.osgeo.org>>>> [pgrouting-dev-bounces at lists.osgeo.org<mailto:pgrouting-dev-bounces at lists.osgeo.org><mailto:pgrouting-dev-bounces at lists.osgeo.org<mailto:pgrouting-dev-bounces at lists.osgeo.org>><mailto:pgrouting-dev-bounces at lists.osgeo.org<mailto:pgrouting-dev-bounces at lists.osgeo.org><mailto:pgrouting-dev-bounces at lists.osgeo.org<mailto:pgrouting-dev-bounces at lists.osgeo.org>>><mailto:pgrouting-dev-bounces at lists.osgeo.org<mailto:pgrouting-dev-bounces at lists.osgeo.org><mailto:pgrouting-dev-bounces at lists.osgeo.org<mailto:pgrouting-dev-bounces at lists.osgeo.org>><mailto:pgrouting-dev-bounces at lists.osgeo.org<mailto:pgrouting-dev-bounces at lists.osgeo.org><mailto:pgrouting-dev-bounces at lists.osgeo.org<mailto:pgrouting-dev-bounces at lists.osgeo.org>>>>] im Auftrag von Daniel Kastl [daniel at georepublic.de<mailto:daniel at georepublic.de><mailto:daniel at georepublic.de<mailto:daniel at georepublic.de>><mailto:daniel at georepublic.de<mailto:daniel at georepublic.de><mailto:daniel at georepublic.de<mailto:daniel at georepublic.de>>><mailto:daniel at georepublic.de<mailto:daniel at georepublic.de><mailto:daniel at georepublic.de<mailto:daniel at georepublic.de>><mailto:daniel at georepublic.de<mailto:daniel at georepublic.de><mailto:daniel at georepublic.de<mailto:daniel at georepublic.de>>>>]
Gesendet: Freitag, 11. Februar 2011 14:47
An: pgRouting developers mailing list
Betreff: Re: [pgrouting-dev] General question for understanding

Hi Markus,

Now it worked ;-)

2011/2/11 Hens,Markus M. <m.hens at student.fontys.nl<mailto:m.hens at student.fontys.nl><mailto:m.hens at student.fontys.nl<mailto:m.hens at student.fontys.nl>><mailto:m.hens at student.fontys.nl<mailto:m.hens at student.fontys.nl><mailto:m.hens at student.fontys.nl<mailto:m.hens at student.fontys.nl>>><mailto:m.hens at student.fontys.nl<mailto:m.hens at student.fontys.nl><mailto:m.hens at student.fontys.nl<mailto:m.hens at student.fontys.nl>><mailto:m.hens at student.fontys.nl<mailto:m.hens at student.fontys.nl><mailto:m.hens at student.fontys.nl<mailto:m.hens at student.fontys.nl>>>><mailto:m.hens at student.fontys.nl<mailto:m.hens at student.fontys.nl><mailto:m.hens at student.fontys.nl<mailto:m.hens at student.fontys.nl>><mailto:m.hens at student.fontys.nl<mailto:m.hens at student.fontys.nl><mailto:m.hens at student.fontys.nl<mailto:m.hens at student.fontys.nl>>><mailto:m.hens at student.fontys.nl<mailto:m.hens at student.fontys.nl><mailto:m.hens at student.fontys.nl<mailto:m.hens at student.fontys.nl>><mailto:m.hens at student.fontys.nl<mailto:m.hens at student.fontys.nl><mailto:m.hens at student.fontys.nl<mailto:m.hens at student.fontys.nl>>>>>>
Hey all,

I am new to pgRouting and I have a general question.
When I have imported my osm data to pgRouting database and calculate a route via A* from x to y does the result contains any information about where it is allowed to drive?

The route shouldn't contain any roads in the result you're not allowed to drive at. It should instead return you another way instead.


For example would the result route me in an oneway street where I am not allowed to drive?

The "cost" attribute for a road link is the cost from start to end node, the "reverse_cost" attribute is the cost in the opposite direction: http://www.pgrouting.org/docs/1.x/astar.html
So a oneway street has very high cost in one of these two cost attributes. If this cost is very high it will always try to find another way ... except there is no other way. But you could easily check this if the result returns very high "cost"


Does the result really contains only the shortest path with no information about prohibitions or am I wrong?

Yes. You have to model your network that it reflects these prohibitions.

Daniel



Best regards,

Markus Hens_______________________________________________
pgrouting-dev mailing list
pgrouting-dev at lists.osgeo.org<mailto:pgrouting-dev at lists.osgeo.org><mailto:pgrouting-dev at lists.osgeo.org<mailto:pgrouting-dev at lists.osgeo.org>><mailto:pgrouting-dev at lists.osgeo.org<mailto:pgrouting-dev at lists.osgeo.org><mailto:pgrouting-dev at lists.osgeo.org<mailto:pgrouting-dev at lists.osgeo.org>>><mailto:pgrouting-dev at lists.osgeo.org<mailto:pgrouting-dev at lists.osgeo.org><mailto:pgrouting-dev at lists.osgeo.org<mailto:pgrouting-dev at lists.osgeo.org>><mailto:pgrouting-dev at lists.osgeo.org<mailto:pgrouting-dev at lists.osgeo.org><mailto:pgrouting-dev at lists.osgeo.org<mailto:pgrouting-dev at lists.osgeo.org>>>><mailto:pgrouting-dev at lists.osgeo.org<mailto:pgrouting-dev at lists.osgeo.org><mailto:pgrouting-dev at lists.osgeo.org<mailto:pgrouting-dev at lists.osgeo.org>><mailto:pgrouting-dev at lists.osgeo.org<mailto:pgrouting-dev at lists.osgeo.org><mailto:pgrouting-dev at lists.osgeo.org<mailto:pgrouting-dev at lists.osgeo.org>>><mailto:pgrouting-dev at lists.osgeo.org<mailto:pgrouting-dev at lists.osgeo.org><mailto:pgrouting-dev at lists.osgeo.org<mailto:pgrouting-dev at lists.osgeo.org>><mailto:pgrouting-dev at lists.osgeo.org<mailto:pgrouting-dev at lists.osgeo.org><mailto:pgrouting-dev at lists.osgeo.org<mailto:pgrouting-dev at lists.osgeo.org>>>>>
http://lists.osgeo.org/mailman/listinfo/pgrouting-dev



--
Georepublic UG & Georepublic Japan
eMail: daniel.kastl at georepublic.de<mailto:daniel.kastl at georepublic.de><mailto:daniel.kastl at georepublic.de<mailto:daniel.kastl at georepublic.de>><mailto:daniel.kastl at georepublic.de<mailto:daniel.kastl at georepublic.de><mailto:daniel.kastl at georepublic.de<mailto:daniel.kastl at georepublic.de>>><mailto:daniel.kastl at georepublic.de<mailto:daniel.kastl at georepublic.de><mailto:daniel.kastl at georepublic.de<mailto:daniel.kastl at georepublic.de>><mailto:daniel.kastl at georepublic.de<mailto:daniel.kastl at georepublic.de><mailto:daniel.kastl at georepublic.de<mailto:daniel.kastl at georepublic.de>>>><mailto:daniel.kastl at georepublic.de<mailto:daniel.kastl at georepublic.de><mailto:daniel.kastl at georepublic.de<mailto:daniel.kastl at georepublic.de>><mailto:daniel.kastl at georepublic.de<mailto:daniel.kastl at georepublic.de><mailto:daniel.kastl at georepublic.de<mailto:daniel.kastl at georepublic.de>>><mailto:daniel.kastl at georepublic.de<mailto:daniel.kastl at georepublic.de><mailto:daniel.kastl at georepublic.de<mailto:daniel.kastl at georepublic.de>><mailto:daniel.kastl at georepublic.de<mailto:daniel.kastl at georepublic.de><mailto:daniel.kastl at georepublic.de<mailto:daniel.kastl at georepublic.de>>>>>
Web: http://georepublic.de<http://georepublic.de/>
_______________________________________________
pgrouting-dev mailing list
pgrouting-dev at lists.osgeo.org<mailto:pgrouting-dev at lists.osgeo.org><mailto:pgrouting-dev at lists.osgeo.org<mailto:pgrouting-dev at lists.osgeo.org>><mailto:pgrouting-dev at lists.osgeo.org<mailto:pgrouting-dev at lists.osgeo.org><mailto:pgrouting-dev at lists.osgeo.org<mailto:pgrouting-dev at lists.osgeo.org>>><mailto:pgrouting-dev at lists.osgeo.org<mailto:pgrouting-dev at lists.osgeo.org><mailto:pgrouting-dev at lists.osgeo.org<mailto:pgrouting-dev at lists.osgeo.org>><mailto:pgrouting-dev at lists.osgeo.org<mailto:pgrouting-dev at lists.osgeo.org><mailto:pgrouting-dev at lists.osgeo.org<mailto:pgrouting-dev at lists.osgeo.org>>>>
http://lists.osgeo.org/mailman/listinfo/pgrouting-dev



--
Georepublic UG & Georepublic Japan
eMail: daniel.kastl at georepublic.de<mailto:daniel.kastl at georepublic.de><mailto:daniel.kastl at georepublic.de<mailto:daniel.kastl at georepublic.de>><mailto:daniel.kastl at georepublic.de<mailto:daniel.kastl at georepublic.de><mailto:daniel.kastl at georepublic.de<mailto:daniel.kastl at georepublic.de>>><mailto:daniel.kastl at georepublic.de<mailto:daniel.kastl at georepublic.de><mailto:daniel.kastl at georepublic.de<mailto:daniel.kastl at georepublic.de>><mailto:daniel.kastl at georepublic.de<mailto:daniel.kastl at georepublic.de><mailto:daniel.kastl at georepublic.de<mailto:daniel.kastl at georepublic.de>>>>
Web: http://georepublic.de<http://georepublic.de/>
_______________________________________________
pgrouting-dev mailing list
pgrouting-dev at lists.osgeo.org<mailto:pgrouting-dev at lists.osgeo.org><mailto:pgrouting-dev at lists.osgeo.org<mailto:pgrouting-dev at lists.osgeo.org>><mailto:pgrouting-dev at lists.osgeo.org<mailto:pgrouting-dev at lists.osgeo.org><mailto:pgrouting-dev at lists.osgeo.org<mailto:pgrouting-dev at lists.osgeo.org>>>
http://lists.osgeo.org/mailman/listinfo/pgrouting-dev



--
Georepublic UG & Georepublic Japan
eMail: daniel.kastl at georepublic.de<mailto:daniel.kastl at georepublic.de><mailto:daniel.kastl at georepublic.de<mailto:daniel.kastl at georepublic.de>><mailto:daniel.kastl at georepublic.de<mailto:daniel.kastl at georepublic.de><mailto:daniel.kastl at georepublic.de<mailto:daniel.kastl at georepublic.de>>>
Web: http://georepublic.de<http://georepublic.de/>
_______________________________________________
pgrouting-dev mailing list
pgrouting-dev at lists.osgeo.org<mailto:pgrouting-dev at lists.osgeo.org><mailto:pgrouting-dev at lists.osgeo.org<mailto:pgrouting-dev at lists.osgeo.org>>
http://lists.osgeo.org/mailman/listinfo/pgrouting-dev



--
Georepublic UG & Georepublic Japan
eMail: daniel.kastl at georepublic.de<mailto:daniel.kastl at georepublic.de><mailto:daniel.kastl at georepublic.de<mailto:daniel.kastl at georepublic.de>>
Web: http://georepublic.de<http://georepublic.de/>
_______________________________________________
pgrouting-dev mailing list
pgrouting-dev at lists.osgeo.org<mailto:pgrouting-dev at lists.osgeo.org>
http://lists.osgeo.org/mailman/listinfo/pgrouting-dev



--
Georepublic UG & Georepublic Japan
eMail: daniel.kastl at georepublic.de<mailto:daniel.kastl at georepublic.de>
Web: http://georepublic.de<http://georepublic.de/>