mrg

680 reputation

1215

bio	website
	location
	age
visits	member for	1 year, 9 months
	seen	just now
stats	profile views	69

I am currently working on a planning system for cycling, walking, sailing, etc. It is based on both a fixed network and a full OSM network. There is a web app for the planning of routes and a mobile app for the navigation of these routes.

Among others i have used the following tools: postgresql, postgis, pgrouting, QGIS, Open Jump, Google Maps, Osmdroid, leaflet.

Atm i am interested in fast routing solutions that allow me to route realtime on larger OSM datasets (>100K ways).

	680 reputation	bio	website		visits	member for	1 year, 9 months
1215 badges		location			seen	just now

summary answers questions tags badges favorites bounties reputation activity

60 Comments

suggestions reviews revisions comments badges posts accepts all

May 7	comment	Help choosing a suitable routing engine Karussell, thank you for the info! I had already found OSRM, but GraphHopper is new for me.
Mar 11	comment	How can I snap lines in PostGIS? A weird thing is that ST_RemovePoint and ST_AddPoint are 0 indexed but ST_PointN is 1 indexed.
Mar 8	comment	How can I snap lines in PostGIS? simplexia - I used St_RemovePoint and ST_AddPoint as a way to replace a vertex (as I couldn't find the ST_ReplacePoint you mentioned). It worked. If you upgrade your comment to an answer I will accept it as the answer I was looking for.
Feb 16	comment	How can I snap 2 lines in QGIS so the st_distance between them is 0? I do the tests in PostGIS.
Nov 30	comment	Why is pgrouting astar not consistent? Checking the boost library the default heuristic function seems to be (dx+dy)/2.
Nov 29	comment	Why is pgrouting astar not consistent? Could it be that the order i feed astar the rows determines which vertices he will examine first. Anticlockwise (see image) all vertices will be closer by than the first one clockwise. And once he discovers the target he doesn't test other shorter routes anymore?
Nov 29	comment	Why is pgrouting astar not consistent? Any idea why that works? The difference i see is that the numbers in EPSG4326 are much smaller.
Nov 29	comment	Why is pgrouting astar not consistent? I am using EPSG:28992 (RDNEW). This is in meters. Let me try 4326. If i transform the x's and y's into 4326 before astar it gives the correct answer.
Nov 27	comment	How do I stop event propagation with rightclick on Leaflet marker? I tried it, but the standard contextmenu i get in FF when i rightclick on an html page keeps popping up.
Nov 26	comment	How do I stop event propagation with rightclick on Leaflet marker? I used your snippet, but what happens is the same as with tmcw's solution. I rightclick my marker. It goes to the listening method. There it removes the marker (that is what rightclick should do for me) and then a context menu opens on the map where i clicked as if the whole marker thing didnt happen.
Nov 22	comment	How do I stop event propagation with rightclick on Leaflet marker? It doesn't seem to work. Have you tested this in Leaflet? And is your event a leaflet event or the original DOMMouseEvent fired by the browser?
Nov 21	comment	Is there a way to save manual QGIS changes to Postgis to SQL script? I meant spatial edits. It is easy to manually drag a line in QGIS but to repeat the exact same thing again is practically undoable.
Aug 28	comment	Why doesn't QGIS accept my manually altered geospatial column? It is more subtle than that. Check the last remark from Joris in blog.openstreetmap.nl/index.php/2012/01/21/rd . I presume you can read Dutch.
Aug 21	comment	Why doesn't QGIS accept my manually altered geospatial column? Layer CRS = EPSG:28992 - Amersfoort / RD New
Aug 21	comment	Why doesn't QGIS accept my manually altered geospatial column? I read now that creating a new project, add openlayer (project CRS will switch to EPSG:3857) and then opening my own layer it will reproject to EPSG:3857. But that also gives the same displacement as mentioned earlier. Having learned that the plugin i use works with EPSG:3857 is very helpful but unfortunately doesn't answer my original question why QGIS doesn't show metadata after i manually convert my geospatial column.
Aug 21	comment	Why doesn't QGIS accept my manually altered geospatial column? With my conversion to 900913 the map layer seems spot on with my own layer. Is that accidentally?
Apr 14	comment	Spatial query in PostgreSQL to find a route to a specific point? "to select a line from one point to another point" isn't a very clear question.
Feb 10	comment	How to make pgRouting faster? Maybe my interpretation of highways is wrong, but highways are very fast and usually free of charge right? Why avoid them?
Feb 10	comment	How to make pgRouting faster? @Route Maker - I am very interested in your results as i work with the same tools. You say your solution became much faster after placing indeces on source and target. How much faster did it become? You also seem to be filtering out highways, for what type of usage are you planning the routes?
Jan 23	comment	How to import selected features from QGIS to PostGIS? The extract that you do have i that in shapefile format too? If so then you can just use shp2pgsql to import it into postgresql.