KNOWLEDGE BASE

Error "Operation on mixed SRID geometries" When using PostgreSQL Spatial data source


Published: 22 May 2019
Last Modified Date: 22 May 2019

Issue

When using a PostgreSQL Spatial data source that contains geometry objects, the following error might occur: 

An error occurred while communicating with the PostgreSQL data source [...].
​Bad Connection: Tableau could not connect to the data source. ​ERROR: Operation on mixed SRID geometries;

Environment

  • Tableau Desktop 2019.2
  • PostgreSQL Spatial

Resolution

As a workaround, simplify the data before loading into Tableau. Use ST_Simplify to create a new field in the database.​ For more information about this geometry, see ST_Simplify in PostGIS, the spatial database extender for PostgreSQL.
Did this article resolve the issue?