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


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
Jan
16
comment Is it possible to gray out a Google Maps map except for some area?
It comes down to making a Polygon in KML with an outerBoundaryIs, being the world and an innerBoundaryIs, being your area of interest. Apart from having difficulty styling the transparancy i keep getting holes in my semi-transparent layer when i zoom in. Anyone have any experience with that?
Jan
16
comment Is it possible to gray out a Google Maps map except for some area?
Is the use of Google Fusion Tables a must in this example? I'm not using that at the moment. I will download the github code and check what the requirements are.
Jan
16
comment Is it possible to gray out a Google Maps map except for some area?
This does indeed display the functionality i am looking for! I will have to dive into the source to see if it is easily implementable in my case. They are talking about hacks (i immediately get IE7 fears).
Jan
16
asked Is it possible to gray out a Google Maps map except for some area?
Jan
12
comment Find all of the ways that intersect a linestring
I find it a bit weird to use ST_DWithin for your needs. Do you check on distance = 0?
Jan
10
awarded  Nice Question
Jan
10
comment How does pgRouting shortest_path work?
This is indeed an answer to the title. Somehow i have a feeling that he kind of knows how it works but doesn't understand why it doesn't technically work for him.
Jan
10
comment How does pgRouting shortest_path work?
Do you have a tool like QGIS? If so, load your network with that and put the layer in Edit mode. That way you see all verices and you can probably spot missing vertices. Otherwise select vertices that are only 1 time a source or target and make them visible to see where they lie. Dead ends are ok, but somewhere inside your network is probably wrong.
Jan
10
comment How does pgRouting shortest_path work?
Start with a very simple case. The simplest test would be to route from a source to target on the same edge. If that doesn't work you might not have to correct columns. If it works test a target that is on a connecting edge. If that doesn't work your edges might not be correctedly conected, etc.
Jan
6
comment Generating very simple slippy map tiles
The documentation of Mapnik says that with the option -s (slim) it should run on the amount of memory you give it. However in my experience i still get out of memory exceptions with 8GB and/or it operates so slow that i fear it isn't doing anything useful anymore.