109 reputation
8
bio website
location
age
visits member for 2 years, 9 months
seen Mar 26 '13 at 8:45

Feb
29
accepted How to make routable OSM map
Feb
29
comment How to make routable OSM map
I did it with osm2po! It was not so easy, I had some errors, etc … but I did it. Thank you Daniel!
Feb
28
revised How to make routable OSM map
deleted 4 characters in body
Feb
28
asked How to make routable OSM map
Feb
28
awarded  Supporter
Feb
28
awarded  Scholar
Feb
28
accepted How to make pgRouting faster?
Feb
28
accepted PostgreSQL / PgRouting syntax error
Feb
13
comment How to use pgRouting's dijkstra_sp_delta_directed with WHERE clause?
So, my question is how to define buffer value to be as small as it can, but to provide enough records for routing. I am also thinking about ST_Expand function, if I found middle point and use ST_Expand I will have much more data, but I also have to define buffer value. And in that case speed will be lost?
Feb
13
comment How to use pgRouting's dijkstra_sp_delta_directed with WHERE clause?
This function works fine but … there is always some problem. My SRID is 4326. Where my two points are with different lat/lon everything is fine and buffer value 0.01 is ok. But if I have two points with similar latitude and different longitude my bounding box is very thin, so I must increase buffer value to 0.25-0.5. When I do this routing is slow again. Also, with buffer value 0.25 I got one route, but with buffer value 0.4 I got different route because there are more roads in this case.
Feb
10
comment Does pgRouting support turn-by-turn routing?
I don't know how to write these messages "Head west on", "Take the 2nd right", "Continue to folow" etc.
Feb
10
comment Does pgRouting support turn-by-turn routing?
I have all of this. I finished with routing, I have PgRouting Shorthest path output as gid and street name. But I want to have output like Google 1. Head west on 330th St toward Wagonwheel Rd 0.8 mi 2. Take the 2nd right onto US-56 E/​US-77 N Continue to follow US-77 N 10.4 mi 3. Turn left onto KS-4 W 28.7 mi 4. Turn right onto KS-4 W/​S Gypsum Valley Rd 1.0 mi 5. Turn left onto KS-4 W 10.0 mi
Feb
10
asked Does pgRouting support turn-by-turn routing?
Feb
10
comment pgRouting for postgresql 9.0?
I have win XP, Postgre 8.4 and pgRouting-1.03_pg-8.4.2. Where I can find pgRouting for Postgre 9.0? p.s. I can't add comment, so I wrote this as answer ...
Feb
10
answered How to use pgRouting's dijkstra_sp_delta_directed with WHERE clause?
Feb
10
comment How to make pgRouting faster?
Mario, demand is to make our own routing engine :) But, thanks to dkastl when I put indices on source and target it becomes much faster. Right now I have 3 countries, but in the future I will have whole Europe.
Feb
10
comment How to make pgRouting faster?
You can see this on Google routing screen ...
Feb
10
comment How to make pgRouting faster?
Highways are fastest roads, but usualy you have to pay toll on some segments. So there are people who wants to avoid tolls. Let say you go every day from town A to town B, it would be very expensive to pay toll, so you want to avoid this so you must go on some local road, not highway. Also, there are people who don't like highways, they rather choose some local roads which are more sightseeing ...
Feb
10
awarded  Commentator
Feb
10
comment How to make pgRouting faster?
My client has system for vehicle tracking, so he needs routing for cost optimisation. He wants me to make routing as Google has. Google is extemely fast, so my job is to be the same as Google :) Google has avoid tolls, avoid higways, fastest, shorthest route.