SQL Spatial Data Rendered to Map Chart
I have ARCGIS spatial data in a SQL Server database view. It contains columns:
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).