KNOWLEDGE BASE

Spatial Polygon File does not Intersect with Spatial Points File correctly in Tableau Desktop 2020.2


Published: 14 Jan 2021
Last Modified Date: 18 Jan 2021

Issue

When very small/narrow polygons are used, spatial intersection does not work correctly.
User-added image

Environment

  • Tableau Desktop 2020.2 - 2020.4 

Resolution

The small sliver polygons should be removed from the polygon file. 
  1. Open the polygon file in a geographic information system (GIS) or other tool for editing spatial files.  QGIS is a free and open source option that works well for this.
  2. If the file uses multipolygon geometries, convert them from multipart to single part
  3. Calculate the area for the single part polygons
  4. Delete the polygons with exceptionally small areas (typically much smaller than 1 square meter; generally in the order of 0.001 square meter)
  5. Collect the geometry back into multipart polygons
  6. Save your edits
  7. Refresh your datasource in Tableau, or replace with your edited spatial file, and try the join again
Example below:
User-added image

Cause

The issue may occur when very narrow/small polygons are used.
This is a known issue in Tableau Desktop that is under investigation by development team.
Did this article resolve the issue?