Route Maker

104 reputation

bio	website
	location
	age
visits	member for	1 year, 3 months
	seen	Mar 26 at 8:45
stats	profile views	46

	104 reputation	bio	website		visits	member for	1 year, 3 months
7 badges		location			seen	Mar 26 at 8:45

summary answers questions tags badges favorites bounties reputation activity

31 Comments

suggestions reviews revisions comments badges posts accepts all

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 ...