Playing with the DB of SG bus stop locations and google map API.
My goal is to try to draw the route of the bus services … but the DB has no info about the order of the stops per service (there is info of which services stop for each bus stop). Following are some experiments, with display about bus service 124.
First try was kind of funny (not unexpected!) as I draw the bus route “as stops are found in DB” … which apparently is from left to right:
So, to get a better idea of the bus route, I’m trying to draw the shortest path … better and even quite enough:
But of course this is inexact map as:
- this shortest route uses all bus stops without taking care of which ones are on the way to go or the way to go back (this data is not in my DB);
- the length of the path does not depend of the road … those are only straight lines!
But anyway, this give a better view of the bus service than nothing or a guide book of bus stop names …


May 24, 2008 at 3:45 pm
Of course, a better solution would be to grab some more info from the online web sites … but I liked the shortest path optimization algorithm
May 28, 2008 at 2:34 pm
[...] … following Posted by khigia under General This post is a following to the previous post about drawing SG bus route with google map [...]
May 30, 2008 at 5:57 pm
Hello! So I guess this is your blog
(hint:garfield)
This is very similar to my final year project:-p (it’s something for tourist, tell you “where to shop”, “where to eat”, “how to get there” etc)
Hehe can expect some help from a skilled programmer…
May 31, 2008 at 2:16 am
Hum … looks like a really promising final year project!
. Would be happy to help if I can.
From what I guess, this is very interesting in fact if the web site can help tourists to plan their journey from A to Z.
And as far I’m concern it is *very* interesting if it tell me where to eat
May 31, 2008 at 3:36 am
The flow will be like this:
1) tourist search for places of interest
2) tourist adds places of interest to the “planner”
3) based on the location, operating hour etc, the planner plan a most suitable trip for the tourist (a(1hr)->b(2hr)->c(2hr)->etc)
4) tourist made some adjustment
5) tourist get a map with the trip information drawn on it (“10am-12am at placeX”, “how to get there” etc)
So far it’s still a *boring* project…
Will try to show you at the next meeting
June 11, 2008 at 3:34 pm
[...] of simulated annealing to deduce Singapore bus service from a database of bus stops (see previous posts about Google Map [...]
February 11, 2010 at 9:55 am
Do you still have that Singapore bus stop database? The link http://www.singeo.com.sg/?p=100 is down – says it will be back soon, but I’m not sure what that means…