THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

John Paul Cook

SQL Server 2008 Spatial Data

Once you start investigating SQL Server 2008 spatial features, you quickly discover that there are three problems:

  1. Loading useful data.
  2. Writing spatial queries.
  3. Seeing the results.

It's very easy to experience scope creep while sorting things out. For the absolute novice beginner, it's best to keep things simple. Loading real world datasets is something that can be deferred until a later day. The examples in SQL Server Books Online are simple and demonstrate what can be done. So, to get started, the only missing piece is a tool to let you see the query results visually. Free is a very appealing price point, so I recommend downloading and using Morton Nielsen's free viewer.

 

Published Tuesday, January 22, 2008 12:21 AM by John Paul Cook

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

ktegels said:

Morten also has a Shape File to SQL Server tool data thats very useful for problem number one. So is SSIS, but it takes some code.

Querying is the fun thing to learn, I agree, but once you have the OGC methods down, its pretty cool.

Visualization is key thing. Somebody with a big brain is going to figure out how to render maps in Reporting Services. And they are going to make a pretty penny selling it... :)

January 23, 2008 4:48 PM

Leave a Comment

(required) 
(required) 
Submit

About John Paul Cook

John Paul Cook is a Technology Solution Professional for Microsoft's data platform and works out of Microsoft's Houston office. Prior to joining Microsoft, he was a Microsoft SQL Server MVP. He is experienced in Microsoft SQL Server and Oracle database application design, development, and implementation. He has spoken at many conferences including Microsoft TechEd and the SQL PASS Summit. He has worked in oil and gas, financial, manufacturing, and healthcare industries. John is also a Registered Nurse who graduated from Vanderbilt University with a Master of Science in Nursing Informatics and is an active member of the Sigma Theta Tau nursing honor society. He volunteers as a nurse at safety net clinics. Contributing author to SQL Server MVP Deep Dives and SQL Server MVP Deep Dives Volume 2.

This Blog

Syndication

Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement