Downloading and Installing GeoRaptor 20

Installing GeoRaptor GeoRaptor is available as a full installable download from this site. Otherwise it can also be compiled from the public source which is available from github. To download GeoRaptor first go to the online shop and click on the GeoRaptor product. Note that there is no charge ($0) for the download but doRead More

Oracle Spatial Vector Acceleration: Flick the Switch

Introduction A lot has been written, positive and negative, about the speed of Oracle Spatial over the years, a lot of ill informed (I mean if you don’t use it, how can you criticize it?). But since Oracle Database 12c (12.1) there is no longer any doubt as to the speed of the product. Why?Read More

Linear Referencing System (LRS) Functions for TSQL

Introduction I have written a complete package of Linear Referencing functions in TSQL. They have been available for over two years. They have not been well advertised so here is an attempt to do so. The following tests expose pretty well all the functions in the package (they include some utility functions like STSegmentize). TheRead More

Overlaying Polygons in SQL Server Spatial

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

Space Filling Curve Functions For TSQL

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

Bing Maps Tile System Functions for TSQL

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

Geocoding Points Against a Grid of Cells/Tiles With/out Spatial Operators

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.