Support Geospatial datatypes in Data Warehouse

[Saveen_Reddy]

Need to deal with a lot of mapping data.

[fbcideas_migusr]

Consider using Fabric Real Time Analytics KQL databases that have extensive support for geospatial data and analytics:

• Geospatial grid system - Fabric KQL Database | Microsoft Learn: https://learn.microsoft.com/en-us/azure/data-explorer/kusto/query/geospatial-grid-systems

[periclesrocha]

Hello and thanks for posting this idea. Could you give me a few scenarios where you work with Geospatial data types?

[josef_jurak]

Additional two similar ideas:

https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=470628aa-8f44-ef11-b4ac-6045bdbb350d

https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=6d72e835-ba33-ef11-a295-6045bdb16ed2

[josef_jurak]

+1

1) to make more compatible SQL surface area with SQL Server or Azure SQL Databases, especialy in migration scenearios

2) I know about spatial functions in Python or KQL, but if your architecture is focusing to relational DWH, is big pain to solve spatial needs (spatial datatypes, and simple spatial functions like distances, area, or intersects) outside DW,