Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Whats the easiest way to get sql 08 spatial data onto a map?

I've got a DB with a whole bunch of records containing lat and long of points I want to get onto a map. The level of detail I need is down to Australian street level and up to the country level and it can be either pure map data (suburbs, streets, etc) or aerial photos. This is purely for personal purposes and the output doesn't need to be production quality. I assume either Bing maps or Google Earth is the way to go - can anyone point me in the right direction for a very fast, simple implementation? Thanks!

like image 462
Troy Hunt Avatar asked Nov 05 '22 19:11

Troy Hunt


1 Answers

This could be some start - http://msdn.microsoft.com/en-us/magazine/dd434647.aspx#id0080059

SQL Server Management Studio 2008 includes a simple visualizer in the form of a Spatial results tab in the Query results window. This visualizer works with a geography or geometry column in the query results and plots the spatial data types on a grid. If multiple spatial columns appear in the query results, you can choose the one to visualize. The column to be displayed must be in the SQL Server binary format; using ToString() or STAsText() won't work with the visualizer.

like image 146
Svetlozar Angelov Avatar answered Nov 15 '22 05:11

Svetlozar Angelov