Comparing Two Geospatial Series with Python
Learn how to use Python and pandas to compare two series of geospatial data and find the matches.
2021-03-23
5,086 reads
Spatial Data
2020-04-14
553 reads
2017-05-01
865 reads
2017-03-31
929 reads
2016-03-09
1,151 reads
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.
2015-04-15
7,242 reads
Introduction to SQL Server Spatial Data
More and more applications require the handling of geospatial data. It is easy to store spatial data, but it takes rather more thought to retrieve and manipulate it. Tasks like searching neighborhoods, and calculating distances between points is often required from databases. But how do you start? Roy and Surenda take you through the basics.
2015-04-06
9,426 reads
2014-09-19
1,970 reads
Tuning Spatial Point Data Queries in SQL Server 2012
Spatial Point Data queries require particular tuning efforts to enhance performance and improve overall application through put. SQL Server 2012 introduces a few key new features and improvements to assist you in that goal.
2012-04-27
2,152 reads
2012-02-03
2,003 reads
Blogs
How to Learn SQL Without Quitting Your Day Job
Juggling meetings, deadlines, and family? Yeah, learning SQL might seem like climbing Mount Everest...
Friday Flyway Tips: Chaining Commands for State-based Deployments
By Steve Jones
One of the cool things I’ve seen with the new Flyway CLI is that...
A New Word: Querinous
By Steve Jones
querinous – adj. longing for a sense of certainty in a relationship; wishing there...
Forums
How to Avoid Incorrect Results When Using T-SQL Trigonometric Functions in SQL Server
Comments posted to this topic are about the item How to Avoid Incorrect Results...
The AG Secondary Logs
Comments posted to this topic are about the item The AG Secondary Logs
Simple(r) Coffee
Comments posted to this topic are about the item Simple(r) Coffee
Question of the Day
The AG Secondary Logs
What happens when an AG secondary receives a log record from the primary?
See possible answers