GeoRaptor: Views and On The Fly Projection
This article demonstrates demonstrated “on the fly” projection via use of multiple views to map geographic data.
Simon Greener
GeoRaptor: Importing a Shapefile into a table
Using GeoRaptor to Load Shapefile(s) into a table
GeoRaptor: Simple Mapping
A simple demonstration of how to map SDO_GEOMETRY data from two different sources.
GeoRaptor: Visualising Geometry Objects
GeoRaptor can represent SDO_GEOMETRY data using a number of visual formats such as WKT, GML and KML, but also “enhanced” SDO_GEOMETRY formatting using colour and coordinate grouping. GeoRaptor even supports the visualiation of the actual geometry using a thumbnail.
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.
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
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.
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