22-25 April 2026

Geospatial + AI with SQL: From Public Data to Maps Using Just SQL

Proposed session for SQLBits 2026

TL; DR

Geospatial analytics doesn’t need specialist tools. This session shows how SQL can turn public housing data into analysis ready geospatial models and interactive maps, with practical patterns for performance and scale.

Session Details

Geospatial analytics doesn’t need specialist tooling, it needs good SQL.

In this session, we’ll use geospatial SQL functions combined with AI SQL Functions (yes, calling AI Models using SQL) powered parsing to transform public housing-sector data into interactive, insight-rich maps.

You’ll see:

Parsing semi-structured public datasets using SQL + AI

Enriching records with geospatial functions (points, joins, distances)

Creating analysis-ready geospatial models

Visualising results in AI/BI Genie and Fabric

Performance and modelling tips for large scale geospatial datasets

This is a hands-on, outcome driven session showing how SQL unlocks advanced analytics that teams often think are “too complex”.

Audience takeaway:
How to deliver impactful geospatial and AI-driven insights using what you already have: SQL.

3 things you'll get out of this session

Practical SQL patterns for building geospatial analytics without specialist tools How to combine AI-powered parsing with geospatial functions for real datasets Proven modelling and performance tips for scaling geospatial insights into Fabric