THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » SQL » spatial   (RSS)
  • Converting Points to a Path

    Suppose your SQL table has a bunch of spatial points (geographies if you like) with an order in which they need to appear (such as time) and you want to convert them into a LineString, or path. One option is to convert the points into text, and do a bunch of string manipulation. I’m not so keen on that, even though it’s relatively ...
    Posted to Rob Farley (Weblog) by rob_farley on January 22, 2014
  • PASS Chapter map

    Displaying information on an interactive map really isn’t that hard to do. My friends John & Bronwen have been doing this stuff for ages through their company Soul Solutions, and have done lots of talks about how to do this. They have the ability to take that stuff far beyond what I can, but as it’s a significant aspect of data visualisation, ...
    Posted to Rob Farley (Weblog) by rob_farley on June 28, 2010
  • Fetching Latitude and Longitude Co-ordinates for Addresses using PowerShell

    Regular readers of my blog (at sqlblog.com – please let me know if you’re reading this elsewhere) may be aware that I’ve been doing more and more with spatial data recently. With the now-available SQL Server 2008 R2 Reporting Services including maps, it’s a topic that interests many people. Interestingly though, although many people have plenty ...
    Posted to Rob Farley (Weblog) by rob_farley on May 23, 2010
  • Spatial data from shapefiles (for T-SQL Tuesday #006)

    I’m giving a presentation on May 12th at the Adelaide .Net User Group, around the topic of spatial data, and in particular, the visualization of said data. Given that it’s about one the larger types, this post should also count towards Michael Coles’ T-SQL Tuesday on BLOB data. I wrote recently about my experience with exploded data, but what I ...
    Posted to Rob Farley (Weblog) by rob_farley on May 10, 2010
  • Merry Christmas

    The script below generates the geekiest Christmas card in the world.  To see it, follow these instructions: (1) Copy and paste the script below into SQL Server Management Studio 2008(2) Execute the script(3) Look at the ''Spatial Results'' tab in SSMS Merry Christmas! -- Begin copy here SELECT ...
    Posted to Michael Coles: Sergeant SQL (Weblog) by Mike C on December 22, 2009
  • NJSQL Saturday Event (10/24)

    The NJSQL user group is hosting a one-day Saturday SQL Server event at the Microsoft Iselin offices.  On October 24th Jacob Sebastian, Robert Pearl and I will be presenting on the following SQL Server topics: * T-SQL Defensive coding and exception handling best practices* Database forensics in SQL Server (''Who did it and ran?'')* SQL Server ...
    Posted to Michael Coles: Sergeant SQL (Weblog) by Mike C on October 6, 2009
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement