KNOWLEDGE BASE

Spatial Join Slow and Returns Inverted Results Using KML or SQL Spatial Data Imported from Shapefile or GeoJSON


Pubblicato: 06 Aug 2018
Data dell'ultima modifica: 17 Oct 2022

Problema

When using a data source based on a Shapefile or GeoJSON file that was imported into SQL Server, visualizations based on the resulting geographies may appear inverted, and the join slower than expected.

Ambiente

  • Tableau Desktop
  • Spatial Joins
  • Shapefiles 
  • GeoJSON 
  • SQL Server

Causa

The vertex order convention of Shapefiles is the reverse of the vertex order specified by SQL Server. 
Con questo articolo hai risolto il problema?