GeoRaptor: Importing a Shapefile into a table
Using GeoRaptor to Load Shapefile(s) into a table
Spatial Solutions Architect and Database Expert
Using GeoRaptor to Load Shapefile(s) into a table
A simple demonstration of how to map SDO_GEOMETRY data from two different sources.
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.
The following video shows the functionality GeoRaptor offers for selections made against the XXX_SDO_GEOM_METADATA system views.
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
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
This article demonstrates how an invalid polygon (and linestring) are handled by the different database spatial APIs with correction in 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.