742 reputation
1421
bio website
location
age
visits member for 2 years, 11 months
seen 12 hours ago

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
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.
Oct
26
awarded  Popular Question
Sep
5
revised How to check map tiles are loaded in OpenLayers?
Readability improvements
Sep
5
suggested suggested edit on How to check map tiles are loaded in OpenLayers?
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
27
accepted Why doesn't QGIS accept my manually altered geospatial column?
Aug
27
answered Why doesn't QGIS accept my manually altered geospatial column?
Aug
24
awarded  Yearling
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?
Aug
21
asked Why doesn't QGIS accept my manually altered geospatial column?
Jun
4
awarded  Fanatic
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
24
answered How to join lines in QGIS?
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.
Jan
22
revised How to import selected features from QGIS to PostGIS?
added 120 characters in body
Jan
22
answered How to import selected features from QGIS to PostGIS?