2 Replies Latest reply on Apr 10, 2018 5:05 AM by Ken Flerlage

    Spatial vs decimal data type for mapping coordinates

    Tim Zalk

      I've read plenty on the spatial datatype versus decimal datatype in MS SQL Server for storing coordinates. I'm wondering if there's any performance difference when mapping in tableau? I'm currently building a database for use exclusively with tableau, and one of the dashboards we use is a map of customers, competitors, competitors customers, etc. The list of addresses is 15,000+ rows. Currently we're just mapping based on zip code, but recently we cleaned up the list and geocoded lon/lat for everything.

       

      In addition to performance, is there any benefit to using the spatial geography datatype over two decimal columns?