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


Mar
12
awarded  Nice Question
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
11
revised How can I snap lines in PostGIS?
added 634 characters in body
Mar
11
awarded  Critic
Mar
11
accepted How can I snap lines in PostGIS?
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.
Mar
7
asked How can I snap lines in PostGIS?
Mar
5
awarded  Nice Question
Feb
17
revised How can I snap 2 lines in QGIS so the st_distance between them is 0?
edited title
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.
Feb
14
asked How can I snap 2 lines in QGIS so the st_distance between them is 0?
Jan
23
asked How can I assign road names from OSM to gis linestrings using open source tools?
Jan
7
accepted How do I stop event propagation with rightclick on Leaflet marker?
Dec
12
awarded  Revival
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
29
revised Why is pgrouting astar not consistent?
added 254 characters in body
Nov
29
asked Why is pgrouting astar not consistent?