Investigating Cleveland

Dave Mattingly goes spatial on Cleveland:

From here, we can:

  • zoom in for more detail

  • hover over a building, road, or other feature to see its name or other column

  • display a label on the results

  • apply filters to only show parts of the data

  • change the widths of the features by changing the STBuffer

  • do lots of other cool stuff

Spatial types and display in SQL Server has always been a weak point for me, so I enjoy seeing the fruits of somebody who is very good at it.

Related Posts

Spheres In SQL Server

Slava Murygin continues his quest to build a graphics engine with spatial data: Couple of years ago I came up with an algorithm of drawing an ellipse using SQL Server spatial geometry: http://slavasql.blogspot.com/2015/02/drawing-ellipse-in-ssms.html I’ve used that algorithm to make a sphere and as in my previous blog of drawing 3D Cube I use external procedure to simplify the […]

Read More

Drawing Cubes With SQL Server Spatial

Slava Murygin has entered his cubism phase: Hey, there is a time to go level up and instead of drawing Spirals, Fractals and other cool stuff I decided to go 3D! So, the first my try will be drawing 3D cubes. As you know, SQL is not an Object Orienting Programming language, and I can’t […]

Read More

Categories

February 2016
MTWTFSS
« Jan Mar »
1234567
891011121314
15161718192021
22232425262728
29