Supported data types for spatial data

Supported data types for spatial data

book

Article ID: KB0077378

calendar_today

Updated On:

Products Versions
Spotfire Analyst All Versions

Description

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

 

Issue/Introduction

Using connectors to bring in spatial data from Oracle or SQL requires certain data types for geometry/polygon columns

Resolution

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:

Additional Information

External: ST_GEOMETRY to SDO_GEOMETRY
Powered by Wolken Software