Skip to Main Content
Spotfire Ideas Portal
Status Future Consideration
Product Spotfire
Categories Maps
Created by Guest
Created on May 4, 2017

Fuzzy matching of location names with map charts

When users are importing data with locations as names (city, state/province, or country) and the names do not exactly match what in the supplied maps, the user most drill into a map with labels to find the correct name; or go outside of Spotfire to find an alias that might match Spotfire's maps, or find the lat/long.   this is quite cumbersome for large data sets.  for examples Antwerp, Belgium--Spotfire has Antwerpen, Belgium or US for the United States of America.   If there was fuzzy logic embedded to help Spotfire and the user match the names from the input file to the map, this would be very helpful.  I have seen this functionality in other BI tools.

  • Attach files
  • Admin
    Arnaud Varin
    Reply
    |
    Jul 5, 2022

    Hello Michelle,

    We are committed to provide the best location analytics experience; with new innovative features recently introduced like multi-layer trellising, GeoJSON, image based mapping capabilities and many improvements made to the end-user experience on top of key capabilities like multi-layers, coordinate systems, real-time maps or automatic geocoding.

    Thank you for your input, it is very important to us. We review all ideas, read every comment and frequently review top voted items to see how they can fit into our development plans. Unfortunately it is not possible to address all requests right away.

    We are aware of the importance of this request and understand this is an area to improve in the OOTB product. In the meantime I would suggest to try out the geocoding data functions available here on TIBCO Community. The geocoder data function uses TIBCO GeoAnalytics online service to geocode data down to the address and also provide additional addresses components when available. We recently demonstrated the use of this function and others at the TIBCO Analytics Forum - available here on YouTube.

  • Guest
    Reply
    |
    Jul 5, 2022

    This is a Idea from 5 years ago. So far no improvement in this space has been made. Tableau, Power BI, Looker, Qlik, JMP, SuperSet, etc. all have the ability to search of locations. Spotfire is super outdated... in not having search/fuzzy matching or wild card-with list of options. Also, it is super difficult to find the areas that do not match, because the error box at the top left does not allow expanding or copying. I am so surprised this is not something that has been prioritized after five long years. Wow... is all that I can say.

  • Admin
    Arnaud Varin
    Reply
    |
    May 11, 2017

    Hello Michelle,

    Geocoding is something we plan to improve on a short/mid term window.
    Leveraging fuzzy match is part of it.

    Thanks!

    Arnaud