772 reputation
1622
bio website
location
age
visits member for 3 years, 4 months
seen Dec 18 at 10:05

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


Nov
2
comment ST_Distance versus ST_Distance_Spheroid?
I was asking for clarification of your answer. You do realize that you answered something from more than 3 years ago?
Jun
18
comment Qgis on MacOS. Color picker does not show?
Did you manage to solve this? I am having the same problem in Ubuntu 12.04 and Qgis 2.2
Jan
8
comment How do I change an existing srs in QGis?
My QGis Dufour does not have that +towgs parameter. So where does it get its definition from?
Jan
6
comment How do I change an existing srs in QGis?
This discussion talks about the way the srs db is filled. So it kinda suggests it is used, but doesn't explain why my manual update of a record doesn't appear in the front end. Maybe there is some sort of cache somewhere? (i did reboot the machine as extra security)
Nov
30
comment Is there an open source directions webclient for pgRouting like the directions API from Google?
I have tried it and it is really good. Not only is it faster for big graphs but it can also give turn directions. It is not useless.
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.