1. Solutions Architecture. I discovered over the years that I am a pretty good systems and solutions architect. How does this apply to you? Well, let’s say you have a business problem you want to be solved. You have a bunch of technology options that provide a framework (or constraint) for delivery, and want toRead More
Sometimes it is a data quality requirement for linear data (roads, pipelines, transmission lines) that curves within the lines must have a radius greater than a particular amount. Recently a customer asked me to write some TSQL functions to help them run data quality checks over linear data loaded into a SQL Server 2008 geometryRead More
The background to this blog comes from two separate sources: the first is my testing of SQL Server 2008 “Katmai”, and secondly, a blog article that Charlie Savage wrote a while back on The Sad State of GIS Web Standards. Web Mapping Standards As an ex-GIS Manager who monitored GIS standards for possible deployment withinRead More
Introduction The OGC operators for geometry processing only support two polygon inputs. Additionally the Microsoft aggregate operators only include geometry union processing geometry::UnionAggregate and not overlay processing etc. UnionAggregate returns for all input polygons as the single Union (see above) does. Concept: Resolving all overlapping areas, without dissolving boundaries, is called “planar enforcing”. Planar enforcementRead More
Comment: This article was written about 10 years ago. Most of what is written is still relevant though the comments about disk usage and access do not apply if SSD is being used. Introduction There are lots of things one can do to improve performance in mapping environments because of a lot of the visualisationRead More
Introduction Warning: This article is long mainly because it includes the source code of the Hilbert, Morton and Peano key/curves. I would assert that space filling curves have always been overlooked in their use within GIS. Their existence was/is rarely taught at Universities, though at least in my day. Perhaps today it is different (butRead More
This blog presents functions for Bing Maps Tile System for TSQL. This support includes converting Latitude/Longitude pairs to Bing Maps QuadKeys. The source for the functions is over at the Mircosoft site – an article by James Schwartz. They are donated to the public domain. Some tests include: I hope this is of use toRead More
GIS Desktop Software is the bedrock of how most people experience Geographic Information Systems. A limited selection of such products are: ArcGIS Manifold MapInfo qGIS FME (Feature Manipulation Engine) – not strictly a GIS but it can do most of the above. I have experience with all of the above. If anyone wants some help,Read More
This article shows how to geocode points objects against grid cells without using spatial operators. The article also shows how to use space curve values such as generated by a Morton key algorithm as grid cell ids and thus geocodes.
The lack of an array datatype in TSQL can be overcome for geometry processing by use of a GeometryCollection as a data type and a set of methods to manipulate it.