I wanted to do some research on geospatial data support in SQL Server after attending Refresh Colombo July meeting.
There Janith did a small presentation on how to finding a bus route in Colombo. Here is his blog explaining how he has done it.
He has implemented the solution based on MYSQL database and I’m not quite sure about the database design used for the application.
This tended me to look at how we can implement such a thing in MS SQL Server and did some googling around the geospatial data support.
