Guia do Usuário do Cliente Web Spotfire®

Configuring WKB data for use with maps

When geographical data is located in a Well-Known Binary (WKB) column, but not originating from a shapefile or GeoJSON file, you can manually create the required coordinate columns using the spatial functions in the expression language in the add calculated column tool.

About this task

See also Spatial functions, Geographic location and geocoding and Specifying new geocoding tables.

Procedure

  1. Select Data > Add calculated column.
  2. Add the first spatial function, WKBEnvelopeXCenter, to the expression.
  3. Select the WKB column from your data table as the argument for the function, for example, WKBEnvelopeXCenter([WKB column]).
  4. Type a suitable Column name (e.g., XCenter) and click OK.
    The XCenter column is created and the correct property value is set on the MapChart.ColumnTypeId property.
  5. Repeat steps 2 to 4 with the other five Spatial functions.
  6. Now, create a map chart and use the data table with the newly created columns as the data table in the Data section of the Feature Layer Settings.