Jam SQL Studio View SQL Server Geometry on a Map
A cross-platform viewer for SQL Server geometry and geography. Jam SQL Studio decodes the MSSQL spatial types and maps them in the results grid, a peek popover, a Query Editor Map tab, and a multi-layer Spatial Explorer — on Mac, Windows, and Linux, not just Windows.
Free for personal use • No account required • Mac, Windows, Linux
SQL Server stores spatial data as the geometry and geography CLR types, and SQL Server Management Studio shows a Spatial results tab when a query returns one. That's a genuinely useful viewer — but it only runs on Windows, and it's tied to the SSMS grid. If you work on a Mac, or you want the map alongside filters, layers, and export, you need another option.
Jam SQL Studio decodes SQL Server geometry and geography over the driver and renders them on a map on macOS, Windows, and Linux. Because it's a multi-engine SQL client, the same map surfaces also cover PostGIS, MySQL, Oracle, and SQLite — one viewer, five spatial databases.
SQL Server Geometry Viewer Comparison
How Jam SQL Studio compares to other ways of viewing SQL Server spatial data on a map.
| Feature | Jam SQL Studio | SSMS | Azure Data Studio | DBeaver |
|---|---|---|---|---|
| Map geometry / geography from SQL results | ✓ | ✓ Spatial results tab | ✗ | ✓ Spatial viewer |
| Cross-platform (Mac / Win / Linux) | ✓ | ✗ Windows only | Retired Feb 2026 | ✓ |
| Decodes both geometry and geography | ✓ | ✓ | ✗ | ✓ |
| Per-cell peek map in the grid | ✓ Both grids | Result tab | ✗ | ✓ |
| Curved geometry render + copy-stays-curved | ✓ | Display | ✗ | Varies |
| Copy WKT / Copy GeoJSON from a cell | ✓ | Via query | ✗ | Via query |
| Map-area filter chips that emit T-SQL (bbox / distance) | ✓ | ✗ | ✗ | ✗ |
| Stack multiple query results as map layers | ✓ Spatial Explorer | One result set | ✗ | Limited |
| Also maps PostGIS / MySQL / Oracle / SQLite | ✓ 5 engines | ✗ SQL Server | ✗ | ✓ |
| Free tier | ✓ | ✓ | Retired | ✓ Community |
How to View SQL Server Geometry in Jam SQL Studio
From a geometry column to a map without booting into Windows.
Run a query that returns spatial data
Connect to your SQL Server (or Azure SQL) database and run a normal SELECT. Jam SQL Studio recognizes geometry and geography columns and shows a one-line summary in the grid instead of the raw CLR blob.
Peek a single feature
Click the peek button on any spatial cell for a fit-to-data mini map. Copy WKT or Copy GeoJSON straight from the popover, and use Load full geometry when a shape is too large to inline.
Plot every row on the Map tab
Switch the Query Editor results to the Map view to see all rows together, colored by a column with a live feature count. The map fetches an optional OpenFreeMap basemap (on by default, opt-out) and falls back to a planar graticule with no network when you turn it off or work offline.
Browse and filter by map view
Open the table in the Table Explorer and use the map pane for two-way row-to-feature selection. Add bounding-box or distance filter chips and Jam SQL Studio writes the T-SQL predicate for you; Filter by map view limits rows to the visible extent.
Overlay layers in Spatial Explorer
The Spatial Explorer workspace stacks multiple query or table layers, each with its own color, label column, feature cap, order, and visibility. The full mechanics are in the spatial guide.
A SQL Server Spatial Viewer That Runs Everywhere
Visualize, inspect, and export geometry and geography without a Windows-only tool.
Grid Summary & Peek
Spatial cells show a type/point-count/SRID summary and a peek map in both the Query Editor and Table Explorer grids.
Map Results Tab
Plot a full result set on a basemap, color by a column, and read a live feature count from the Query Editor.
Spatial Filter Chips
Bounding-box and distance chips emit real T-SQL, turning a map interaction into a reproducible query predicate.
Curves Stay Curved
CircularString and CompoundCurve arcs render on the map, while Copy WKT keeps the shape curved (a CircularString stays a CircularString, not the flattened display version).
Spatial Explorer Layers
Stack multiple queries and tables as colored layers with labels, caps, ordering, and visibility toggles.
Mac, Windows & Linux
Everything works on all three platforms — no remote desktop into Windows just to see a shape on a map.
Frequently Asked Questions
Common questions about viewing SQL Server geometry and geography on a map.
How do I view SQL Server geometry on a map?
Run a query that returns a SQL Server geometry or geography column. Each spatial cell shows a one-line summary and a peek button that opens a fit-to-data mini map. Switch the results to the Map tab to plot every row together, or use the Table Explorer map pane and the Spatial Explorer workspace for larger, multi-layer maps. It works on macOS, Windows, and Linux.
Can I view SQL Server spatial data on a Mac?
Yes. SQL Server Management Studio's Spatial results tab is Windows-only, but Jam SQL Studio is a cross-platform desktop app that decodes and maps SQL Server geometry and geography on macOS, Windows, and Linux.
Does it support both geometry and geography?
Yes. Jam SQL Studio decodes both SQL Server spatial CLR types — geometry and geography — through the driver and renders them on the map, reading the SRID to project coordinates.
Does it handle curved geometry like CircularString or CompoundCurve?
Yes. Curved SQL Server geometry (CircularString, CompoundCurve, CurvePolygon) is linearized client-side so the arcs render on the map, while Copy WKT keeps the shape curved (a CircularString stays a CircularString, not the flattened display version) rather than a densified approximation.
Can I copy the geometry as WKT or GeoJSON?
Yes. From the peek popover you can Copy WKT or Copy GeoJSON for any SQL Server geometry or geography value; grid copy (Ctrl+C) and CSV / XLSX export emit WKT. Either way you can paste it into another tool or a support ticket. The free WKT viewer is handy for a quick browser check.
Can I filter SQL Server spatial data by map bounds?
Yes. The Table Explorer map pane adds bounding-box and distance filter chips that emit T-SQL, plus a Filter by map view action that constrains rows to the visible map extent.
Can I edit geometry on the map?
No. Jam SQL Studio visualizes and exports spatial data — Copy WKT and Copy GeoJSON — but does not draw or edit features on the map. It is the viewer and export path, not a GIS authoring editor.
What other databases' spatial data does it map?
In addition to SQL Server, Jam SQL Studio decodes and maps spatial data from PostgreSQL/PostGIS, MySQL, Oracle (SDO_GEOMETRY), and SQLite (SpatiaLite and GeoPackage), so one tool covers spatial across all five relational engines.
Map Your SQL Server Spatial Data Anywhere
Download Jam SQL Studio free and view geometry and geography on Mac, Windows, or Linux.
Explore More
See how Jam SQL Studio handles spatial data and SQL Server.
Further reading: Spatial & PostGIS guide · Free WKT viewer · Query Editor · Table Explorer