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
4,657 reads
Learn how to use Python and pandas to compare two series of geospatial data and find the matches.
2021-03-23
4,657 reads
2020-04-14
552 reads
2017-05-01
862 reads
2017-03-31
928 reads
2016-03-09
1,148 reads
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
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,965 reads
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
1,999 reads
By Steve Jones
At the PASS Data Community Summit in 2024, Redgate launched Test Data Manager (TDM),...
By Rayis Imayev
(2024-Mar-16) I have been a big fan of using the Excel application for various tasks...
You might know the feeling: you’re writing code in a Notebook in Microsoft Fabric...
I've been exploring various methods to monitor and alert for long-running queries in SQL...
Hi everyone I need to find the last business of the week. In most...
Please share a situation when enabling and taking further advantage of DBCC TRACEON -...
How can I run SQL Agent with SQL Server Express 2022?
See possible answers