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
Great news for all Oracle Spatial users: Locator is no more! So no longer do I have a write blog article constantly referring to Oracle Spatial or Locator: now it is just Oracle Spatial. And Spatial is no longer a separately licensed product for Enterprise Edition: it is simply available to anyone with a validRead More
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
Introduction The ordinates stored in an geometry objects, across all spatial data types do not have any rounding applied to their values. This is one aspect of data management that is seldom considered by most practitioners. Other articles in this website deal with how to round their values. This article is about a related topic”Read More
Introduction All database spatial types that I have worked with have constructors based on Well Known Text (WKT). When constructing a geometry all those types check the WKT’s structure. So, for example, the polygon below is wrong for two reasons: 1. It does not have its exterior ring correctly defined (eg “POLYGON((…))” ; 2. ItRead More
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
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