Skip to main content

Supported data types for spatial data

Rich Talbot
  • Created
Date Posted:
Product: TIBCO Spotfire®

Problem:

Supported data types for spatial data


Solution:

When imported to TIBCO Spotfire, a shape using the SDE.ST_GEOMETRY data type will display as [..] instead of displaying the actual shape.  This is because many data sources use SDE.ST_GEOMETRY as the data type for the polygon column, which is not supported in Spotfire.

For example, when trying to read SDE.ST_GEOMETRY data through an Oracle data connector, you might also encounter the following error: 

ImportException at Spotfire.Dxp.Data:
An error occurred when executing a query in the external data source.
External error:
ORA-28578: protocol error during callback from an external procedure
ORA-06512: at "SDE.ST_GEOMETRY_SHAPELIB_PKG", line 67
ORA-06512: at "SDE.ST_GEOMETRY_OPERATORS", line 118

  To resolve, use the SDO_GEOMETRY data type instead. This site outlines how to convert SDE.ST_GEOMETRY to SDO_GEOMETRY, which will import successfully into Spotfire: External: ST_GEOMETRY to SDO_GEOMETRY

Related articles

Comments

0 comments

Article is closed for comments.