mrg

675 reputation

1215

bio	website
	location
	age
visits	member for	1 year, 9 months
	seen	yesterday
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).

	675 reputation	bio	website		visits	member for	1 year, 9 months
1215 badges		location			seen	yesterday

summary answers questions tags badges favorites bounties reputation activity

129 Actions

suggestions reviews revisions comments badges posts accepts all

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
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?