GeoRaptor: Direct Display of SDO_GEOMETRY / WKT text objects


When developing spatial sql solutions eg stored procedures, one often needs many methods for extracting and visualising geometry objects. GeoRaptor, in conjunction with SQL Developer and Oracle Spatial has a number of tools on offer.

This article presents a video showing how to display geometry objects in SDO_GEOMETRY / WKT / EWKT text format using GeoRator. The source of the EWKT is PostGIS generated using pgAdmin 4 and PostGIS.

The Jump To Geometry functionality detects the SRID of the input geometry text and chooses an appropriate view regardless as to which view initiated the jump. If a view does not exist for that SRID, the video shows how one can create a new view for the display of the geometry.