GeoRaptor: Working with xxx_SDO_GEOM_METADATA records.
The following video shows the functionality GeoRaptor offers for selections made against the XXX_SDO_GEOM_METADATA system views.
Articles
GeoRaptor 18+: Downloading and Installing beta
Installing GeoRaptor for SQL Developer 18+ 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) forRead More
Oracle 21c: Locator is no 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
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
Geometry object size when exchanging of WKT/WKB encoded geometries.
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
Geometry Validity and Method Access
This article demonstrates how an invalid polygon (and linestring) are handled by the different database spatial APIs with correction in TSQL.
Linear Referencing System (LRS) Functions for TSQL
This articles logically steps through all the functions in a complete package of Linear Referencing functions that I have written for TSQL. The article both demonstrates the power of SQL Server Spatial but what can be done with TSQL.
My Services
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
Pseudo Array Implementation for SQL Server Spatial (Part 2)
Introduction Data Structure + Base Function Accessors and Setters Four functions are declared for processing geometry or geography data within the array. These are “wrappers” over _STArray. Examples Declare @array xml select ‘Empty Array’ as test, [dbo].[STNumArray](@array) as arraySize; test arraySize Empty Array 0 Set @array = [dbo].[_STArray](@array,1,’insert’,geometry::Point(1,2,0).STAsBinary(),0); select ‘Insert into Empty ‘ as test,Read More
CheckRadii: Identifying Tight Radius Curves sections within LineString geometry data
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