SQL Spatial Data Rendered to Map Chart

I have ARCGIS spatial data in a SQL Server database view. It contains columns:

OBJECTID (int),

SHAPE (varbinary(max)),

XMin (float),

YMin (float),

XMax (float),

YMax (float),

XCenter (float),

YCenter (float)

After creating the Information Link, I noticed that the SHAPE column is not rendering. Spotfire is reading it as a Blob Data Type and the Properties are blank in the Data Folder before adding the columns to the Information Link. Is there a way to get Spotfire to recognize this spatial data, so that I do not have to add the Property Name =ContentType and Value = application/x-wkb as well as Propert Name = Mapchart.ColumnTypeId and Value = Geometry to the Properties in the Column Element within the DATA folder before adding it to the Information Link?

 Also, I have to add Property Name = Mapchart.ColumnTypeId for all the X and Y fields with their corresponding values (XMin,YMin,XMax,YMax,XCenter,YCenter).

(4) Answers

Login