8/10/2012 9:30:03 AM
Amit Bansal -
I often get this question; “I want to learn Spatial, where do I start?” or something similar. Not long ago, I had the same question.
Spatial Data, Spatial applications & systems is a specialized field, a different genre altogether. SQL DBAs & DEVs will find it very amusing & interesting to work with Spatial Data, but you may know, it’s serious business out there. All the GPS, GIS stuff; most of it that you see every day, is based on Spatial Data. But the question remains, what the heck it is? And where do I start.
I will point you the some posts that I have written that can help you get started. You can visit many online resources like blogs, etc, or just get a book. Apart from all that, I will suggest you to visit Wiki & http://www.opengeospatial.org/ (OGC) to get some introductions. Post that you can download a tool called Spatial Viewer from codeplex.com
This tool will help you to get started with learning basic spatial shapes and standards as per OGC. You can also perform basic operations on Spatial shapes like union and intersection.
After you download & install the tool, just start it and you are ready to play with spatial data. For example, in the following diagram, I have drawn a Polygon. While I draw the Polygon, you can see the coordinates on the right side.
You can select the coordinates on the right side (just click on it) and you get the T-SQL in a bottom pane (as shown below).
You can copy that SQL code and paste it in a new query window in SSMS and execute it. Note that I have put a select statement to output the content of the local variable and you have Spatial results tab that gets displayed (whenever there is spatial data in the result set).
I just wanted to introduce you to the tool. There’s a lot you can do with this tool. For example, draw 2 polygons, overlapping each other with some percentage, select both of them from the right pane, while holding the CTRL key, right click and explore the spatial operations that can be applied on the shapes. See below:
I leave the rest to you to explore.
And yes, here are the links to my earlier posts related to Spatial stuff in SQL Server:
If you liked this post, do like us on FaceBook at http://www.FaceBook.com/SQLServerGeeks
Have a SQL Server question? Join the fastest growing SQL Server facebook group at: http://www.facebook.com/groups/458103987564477/
Visit my FaceBook page at http://www.facebook.com/AmitRSBansalContribute on SQLServerGeeks.com: visit http://www.sqlservergeeks.com/default-category/write-for-us
Amit Bansal (Member since: 3/12/2011 4:59:54 PM)
Follow Amit at Twitter @A_Bansal : Amit Bansal is the CTO of eDominer Systems & Peopleware India. He is a consultant, trainer, writer, speaker & evangelist on SQL Server & Business Intelligence. A seasoned speaker; he speaks at major summits and conferences of Microsoft worldwide including TechED, MCT Summits, MSDN & TechNet conferences. Over the last 8 years, he has consulted, trained & mentored more than 6000 IT professionals on SQL Server & Business Intelligence and worked with top notch blue chip companies worldwide including Microsoft, Infosys, Wipro, RBS, HCL, HP, Siemens, IBM, Accenture, etc. He has delivered more than 400 workshops on SQL Server & Business Intelligence. Apart from holding many Microsoft credentials, he is also a Microsoft Most Valuable Professional (MVP) awardee on SQL Server. He is also one of the first Microsoft Certified Trainer in India. Amit has worked with Microsoft in India and US as a Subject Matter Expert in various capacities participating in OD sessions, technical reviewing, etc. He is also a very active community lead in Asia Pacific. Visit www.amitbansal.net to know more. Subscribe to Amit’s blog and be a member of his technical forum at www.SQLServerGeeks.com - an exclusive SQL Server portal. Visit www.peoplewareindia.com for Corporate Training solutions.
FaceBook – http://www.facebook.com/people/Amit-Bansal/525339346
LinkedIn – http://www.linkedin.com/pub/amit-bansal/7/121/755
View Amit Bansal 's profile
Leave a comment