737 reputation
1319
bio website
location
age
visits member for 2 years, 7 months
seen 7 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).


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?
Jan
22
comment How to import selected features from QGIS to PostGIS?
What is the source of your data? There are a lot of tools that let you import a bounding box from some source format into postgresql.
Jan
22
revised How to Run Ad Hoc Database Queries in Open Jump?
added 188 characters in body
Jan
22
answered How to Run Ad Hoc Database Queries in Open Jump?
Jan
21
revised How to route over (partial) edges in pgrouting?
added 197 characters in body