777 reputation
1723
bio website
location
age
visits member for 3 years, 9 months
seen Dec 18 '14 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).


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 merge lines with slightly different endpoints 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
Jan
21
revised How to route over (partial) edges in pgrouting?
added 4 characters in body
Jan
21
comment How to route over (partial) edges in pgrouting?
I added the query i used for my OSM case (table generated by osm2pgrouting). It might look a bit complex but if you need to dig into this material for your own case it will become clear and else you can always contact me here for further explanation.
Jan
21
revised How to route over (partial) edges in pgrouting?
added 2076 characters in body
Jan
21
accepted How to route over (partial) edges in pgrouting?
Jan
21
answered How to route over (partial) edges in pgrouting?
Jan
21
revised Is it possible to gray out a Google Maps map except for some area?
added 725 characters in body
Jan
21
accepted Is it possible to gray out a Google Maps map except for some area?
Jan
17
comment Is it possible to gray out a Google Maps map except for some area?
KML's are rather slow in loading, so changing it all the time might give a very lazy effect. Apart from that wouldn't i have to change the name constantly to make sure the old kml doesn't get cached? I have a feeling that i need Google Fusion Tables knowledge.
Jan
17
awarded  Nice Question
Jan
16
revised Is it possible to gray out a Google Maps map except for some area?
added 422 characters in body; edited tags