Home > SQL / BI > SQL Server Spatial Data Generator

SQL Server Spatial Data Generator

I had a chat with one of Microsoft SQL evangelists yesterday, talking about demos etc. and he pointed me to a very useful tool written by another Microsoftie, Mike Ormond. He has a Spatial Data Generator available on the web here which lets you draw shapes on Virtual Earth and outputs the latitude and longitude needed to insert the shape:

Mike Ormond's SQL Server 2008 Geospatial Data Generator

Very useful indeed if you’re playing with the geospatial data (in any system, not just MS SQL as it outputs WKT format) as it lets you create exciting data like this:

SQL Server's Binary Representation of Berkshire

Ok, marginally more exciting when it’s visualised properly:

SQL Server's Graphical Representation of Berkshire 

Ok, still not that exciting (anything featuring Bracknell’s going to be pretty disappointing) but it’s a great start to a demonstration of the spatial functions in SQL 2008, as you can then go on to do things like buffer zones:

It's not a snake, it's a 1km corridor around the M4

And then start to query for things like ‘Show me the towns within 1km of the M4’:

No Bracknell. Yay!

Good stuff! Well done Mike!

Categories: SQL / BI
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: