Top 5 Recent Articles
ARTICLES CATEGORIES
- Algorithms (22)
- All (399)
- Biography (1)
- Blog (44)
- Business Requirements (1)
- Commentary (1)
- Conversion (2)
- Customers (2)
- Data Models (1)
- Education (2)
- GeoRaptor (13)
- GPS (1)
- Image Processing (2)
- Import Export (8)
- Licensing (2)
- LiDAR (1)
- Linear Referencing (4)
- Manifold GIS (3)
- Mapping (1)
- MySQL Spatial (7)
- Networking and Routing (including Optimization) (5)
- Open Source (18)
- Oracle Spatial and Locator (194)
- Partitioning (1)
- PostGIS (36)
- Projections (1)
- Published Articles (1)
- qGIS (1)
- Recommendations (1)
- Services (1)
- Software Change Log (1)
- Source Code (37)
- Space Curves (9)
- Spatial Database Functions (109)
- Spatial DB comparison (1)
- Spatial XML Processing (11)
- SQL Server Spatial (92)
- Standards (3)
- Stored Procedure (17)
- Tessellation or Gridding (10)
- Tools (2)
- Topological Relationships (1)
- Training (2)
- Triangulation (2)
GeoRaptor: Direct Display of SDO_GEOMETRY / WKT text objects
Introduction
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.