Author Archives: Stephan Deckers

Sorting and merging geometries in Oracle Spatial

Consider a requirement where an unsorted set of geometries needs to be merged into a single geometry. Take for instance the following set of geometries where: a Red dot indicates the startpoint The arrow indicates the drawing direction The label … Continue reading

Posted in G/Technology, Oracle, Oracle Spatial, PL/SQL | Tagged , , , , , | 5 Comments


The SDO_GEOM.VALIDATE_GEOMETRY_WITH_CONTEXT function fails for 3D Compound line strings geometries as discussed over here. This is illustrated by the following sample: 2d: produces: While the same geometry in 3d is considered invalid: A Quick workaround for this is to convert … Continue reading

Posted in Oracle, Oracle Spatial | 1 Comment

Invalid Fiber Couplers

Fiber Couplers are used to connect Fiber Inner Ducts in a Fiber Branch Enclosure. You can connect Fiber Inner Ducts using the Fiber Feature Editor by selecting the two Fiber Inner Ducts and choosing the ‘Couple’-icon : This will connect … Continue reading

Posted in G/Technology, Intergraph | Leave a comment

AdHoc Queries

Introduction G/Technology provides functionality to run dynamic queries, the so called ‘Ad-Hoc queries’. A Large telecom provider in the Netherlands is moving Fiber Cables from CRAMER to FOW and AdHoc-queries provide a great tool to analyze and visualize migrated data … Continue reading

Posted in G/Technology, Intergraph | Tagged , , | Leave a comment