There may be times when you may want to use local data tables for geocoding in map charts instead of the pre-loaded geocoding tables.

How to configure a table so TIBCO Spotfire recognizes it for geocoding

For Spotfire to recognize a data table for geocoding, certain Property fields must be set at the Column and Data Table level.

Under Data > Column Properties > Properties tab
The "MapChart.ColumnTypeId" property for the Latitude and Longitude columns should have the appropriate value. For example:

• [Latitude column] == YCenter
• [Longitude column] == XCenter

Under Data > Column Properties >General
The "DataType" for these columns must be set to "Real". Occasionally they are imported as "Currency". To adjust this, you can modify the data type during data import or if the data is already imported, use Insert > Transformation > "Change data types" to change to a real. See the Details on Change Data Types reference for more details.

Under Data >Data Table Properties > Properties
The Property "MapChart.IsGeocodingTable" must be set to "True"


Refer to  Setting Up New Geocoding Table in the Spotfire Analyst manual for more information on this topic. 

Doc: Setting Up New Geocoding Tables

• https://docs.tibco.com/pub/sfire-analyst/latest/doc/html/en-US/TIB_sfire-analyst_UsersGuide/index.htm#t=map_60%2Fmap_60_setting_up_new_geocoding_tables.htm

Doc: Details on Column Properties – Properties

• https://docs.tibco.com/pub/sfire-analyst/latest/doc/html/en-US/TIB_sfire-analyst_UsersGuide/index.htm#t=data%2Fdata_details_on_column_properties_properties.htm

Doc: Details on Change Data Types

• https://docs.tibco.com/pub/sfire-analyst/latest/doc/html/en-US/TIB_sfire-analyst_UsersGuide/index.htm#t=data%2Fdata_details_on_change_data_type.htm