SQL Art, Part 3: Happy Easter Fun in SSMS

More spatial fun, this time for Easter.

SQL Art 2: St Patrick’s Day in SSMS (Shamrock + Pint + Pixel Text)

Last time we turned SQL Server into a Christmas tree. Every year around St Patrick's Day I find myself doing something I can't fully justify. This year that thing was using SQL Server's spatial viewer to draw a shamrock and a pint of Guinness. Hope you have a happy St Patrick's Day and a few […]

GPX distance and time analysis in SQL Server

In this article we do a comparative analysis of the distance covered by two athletes during a race using the data of their GPX files.

Determining Whether Home Addresses Fall Within a Tornado Polygon Using Spatial Functions

Geographic information systems (GIS) play a critical role in emergency response planning and risk assessment. One of the key challenges in this field is determining whether a specific location falls within an area of interest. This capability is especially valuable for property and casualty (P&C) insurers, who need to assess their insured property exposure when severe weather events such as tornadoes occur.

Comparing Two Geospatial Series with Python

Learn how to use Python and pandas to compare two series of geospatial data and find the matches.

The Linestring

Spatial Data Type

It Just Runs Faster - Spatial

Modelling the world

SQL Server Spatial Indexes

Spatial Data in SQL Server has special indexing because it has to perform specialised functions. It is able, for example, to break down an indexed space into a grid hierarchy by using a technique called tessellation. This is a rules-based system that, when you compare a shape to an index, works out how many cells in the the grid hierarchy are touched by that shape , and how deep down the grid hierarchy to search. There is powerful magic in Spatial Indexes as Surenda and Roy explain.