Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

This question Whats the easiest way to get sql 08 spatial data onto a map? (and many other articles) recommends Craig Dunn's Geoquery, but all the download links appear to be kaput.

SQL Server Managament Studio's spatial results tab will show a single dataset, and this MSDN article, Spatial Data Support In SQL Server 2008 mentions a workaround using UNION ALL to display point data overlayed on a map:

SELECT geog, cntry_name FROM SpatialSamples.dbo.cntry00

Whenever I try something similar, I only ever get a single resultset displayed.

Is there something built into either SQL Server 2008 or 2012 to do this?

share|improve this question
up vote 2 down vote accepted

I would use Excel 2013 - it has fairly easy Map integration which can take Lat+Lon, eg:

I would pull a SQL view through PowerPivot for easy derivation of .Lat and .Long, and for refreshing the data.

Alternatively SQL Server Reporting Services 2008 R2 or 2012 has similar Map integration, but the end user experience is static.

share|improve this answer
Thanks, I'll look into this. – Mitch Wheat May 3 '13 at 6:59

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.