680 reputation
1215
bio website
location
age
visits member for 1 year, 9 months
seen 14 hours ago
stats profile views 69

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


Oct
17
awarded  Talkative
Sep
20
asked Is there an open source directions webclient for pgRouting like the directions API from Google?
Sep
15
comment Where can i find free mapnik map styles with focus on waterways?
@Igor, yes i have and will do if i can't find it somewhere and my own attempts don't match my goal.
Sep
14
comment Where can i find free mapnik map styles with focus on waterways?
Most waterway maps use a very bright sort of blue for water, as in example
Sep
14
asked Where can i find free mapnik map styles with focus on waterways?
Sep
12
comment Ogr2ogr projection problem- features are shifted 12 miles to the north?
Why don't you add the -s_srs EPSG:900913 parameter in your ogr2ogr command?
Sep
9
comment Is there a set of standard accessibility guidelines for online maps?
When you click the middle of that panning circle toolbar you go back to the original map state. What mouse action have you defined for that if you do not show controls?
Sep
6
awarded  Commentator
Sep
6
comment MySQL Query to fetch all cities and POI's near the route
I don't know how many possible points (cities) you have and what language you program, but it should be fairly easy to find a function on the net that calculates the distance between a line and a point. If you do this with the line pieces as i described above you are sure to get them in the right order. Unless you have some realtime timing constraints this should be doable for quite a few thousand poi's.
Sep
6
awarded  Editor
Sep
6
revised MySQL Query to fetch all cities and POI's near the route
deleted 13 characters in body
Sep
6
answered MySQL Query to fetch all cities and POI's near the route
Sep
3
answered What restrictions on KML/KMZ upload exist in Google Maps API v3?
Aug
30
comment Is there a way to save manual QGIS changes to Postgis to SQL script?
It might be handy to know that the output found in the logfile needs a bit of editing before you can use it in an SQL script. Make sure you add E before the bytestring and replace all occurrences of \ with \\ as in: geomfromwkb(E'\\001\\002\\000...
Aug
30
awarded  Scholar
Aug
30
accepted Is there a way to save manual QGIS changes to Postgis to SQL script?
Aug
30
comment Is there a way to save manual QGIS changes to Postgis to SQL script?
I tried it and it worked! Thank you for your good answer!
Aug
29
comment Is there a way to save manual QGIS changes to Postgis to SQL script?
This sounds like a very good idea. I will have to try this to see if this works. I will get back here after i have tried your suggestion.
Aug
28
comment How to load OSM data into PostGIS preserving all Tags?
You don't explain what tool you have used to import the shapefiles into Postgres (sometimes they omit fields except the strictly necessary ones) and you also forget to mention with what tool you view them.
Aug
28
asked Is there a way to save manual QGIS changes to Postgis to SQL script?