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

Jun
25
comment Geocoding like Google - how to do this?
Thank you, it is useful site ... but spelling is not my primary problem. I must solve search engine first ...
Jun
25
comment Geocoding like Google - how to do this?
I have to implement my geocoding function both on web and desktop application. AJAX is for web, and how to do this on desktop application?
Jun
25
comment Geocoding like Google - how to do this?
Sorry, but I don’t understand how to implement addresses from my database in table Suggest. Should I put all addresses in field Title? For instance should I fill title field with all combination like this: Via Roma Palermo, Via Roma 2 Palermo, Via Roma 25 Palermo, Palermo via Romma, Palermo via Roma 67, …. etc Could you give me some example?
Apr
2
comment How to resolve case when routing result does not contain start and end point?
I did it with line interpolation, I locate SP with ST_Line_Locate_Point and then using ST_Line_Substring I am taking only SP-B part of the segment.
Mar
29
comment How to resolve case when routing result does not contain start and end point?
Well, I have some demands about routing ... User clicks the start point on the map, I am searching the nearest network segment and then I find the closest point on the network segment. I return lon/lat of that point and put pushpin on the map. From the network segment I take source. The same story for the end point, only I take target from the network segment. But I don't know direction of the segment and that makes problem. I have network table with fields source and target, and I use them for routing function.
Feb
29
comment How to make routable OSM map
I don't know. I check SHP and Memory option. I tried with Database and Direct file option and I have the same error. Could you send me somehow print screen picture to see your options. I have windows XP.
Feb
29
comment How to make routable OSM map
Right now I tried osm2po with Germany and I got Out of memory error.
Feb
29
comment How to make routable OSM map
I did it with Greece, but for Germany I got Out of memory error.
Feb
29
comment How to make routable OSM map
I tested with Greece because it is smaller...
Feb
29
comment How to make routable OSM map
What should I do to resolve this? I like this converter but for now it is not useful for me :(
Feb
29
comment How to make routable OSM map
I tried it, it looks nice but I get the error “Out of memory”. I have 4 GB RAM.
Feb
29
comment How to make routable OSM map
Yes, Underdark has very useful posts.
Feb
29
comment How to make routable OSM map
I have OSM2PostGIS, but I thought it is for Linux. I don’t know how to use it on Windows.
Feb
29
comment How to make routable OSM map
Thank you, I will try this later.
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
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
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 ...