Maps and Geo-location are everywhere these days, but just how many of you still take that Latitude & Longitude you get from your mobile app and put the values into normal decimal columns in your database?
With Geo-Spatial SQL and a correctly configured spatial aware database you can take control of this data and do some very clever stuff with it.
Want to know how many of your customers live within a 10 mile radius of your office?
What about which is the nearest fast food restaurant to the person currently looking at your Facebook app?
or maybe you want to track where your delivery drivers are?
Spatial SQL can provide the answers to this and many other location and distribution based questions, and can produce some very interesting statistics for graphing & charting and market analysis.
In this session I'll introduce you to the concept of spatial SQL using Open Geo-consortium standards, most of which can be used with slight modification in the current versions of MS-SQL 2008 and up.
I'll give a high level overview to what is available, why you might want to use it and the type of operations that can be performed directly in your database along with some of the tools you can use to provide rich mapping and statistical visualisation in your .NET applications.
I'm a tech-head pure and simple, im a UK & Europe group manager for Lidnug, and I write software for fun, and for a living. bio from Twitter
Sign in to add slides, notes or videos to this session