Integrating & using Spatial Data with SQL Server 2008/2012
Exploring the spatial aspects of your data is a powerful analytical technique to uncover patterns and then to take business decisions based upon them. Most commercial datasets contain spatial data but it may not be sql-ready. You no longer need to buy Oracle Spatial or go open-source to store and manage your spatial data, and expensive GIS systems are no longer required to display the data. This session will show you how to get started and enable you to realise the scope of spatial functionality in your favourite database system.
The session uses UK-sourced data so the Ordnance Survey national grid is explained and why this matters when manipulating data at the database level. UK spatial datasets are explained and explored - Postcodes from the Royal Mail, Address-Point, NLPG and AddressBase & MasterMap from the Ordnance Survey. It is likely that your data may contain one of these.
SQL Server 2008 introduced two new spatial data types - GEOMETRY & GEOGRAPHY. These data types and their application are explained. Using real data the use of SSIS and components from FME are demonstrated to import and transform your data. An SSIS package is built up to demonstrate this. Other data preparation techniques are explored. Once the data is imported into SQL a range of SQL queries are developed to explore the data and to expose patterns. The data is presented in a simple mapping application. The purpose of this is to show that what was previously available through an expensive and complex GIS system is now available at the database level, straight out of the box.
Having demonstrated what SQL Server is capable of some thought is given to how the map & your spatial data could be incorporated into applications and BI platforms.
Sorry, there are no downloads available for this session.
My first computer was an IBM System 370 kindly supplied by Royal Insurance. This encounter led to a permanent facination with databases. After 10 years in property management I became a full-time IT professional in 1994. Since then I have held a variety of roles including database developer, software support consultant, dba, techical project manager and programme manager. I worked on and implemented a variety of corporate systems including Finance & e-Procurement, Public Safety, Property Management, Sharepoint and Location Management using gazetteers and mapping systems.
I am now Technical Director of a Cambridge-based start-up, G S I Technologies specialising in .NET application & BI development using SQL Server.
I am a qualified Prince 2 practitioner and chartered member of the British Computer Society.
I have two teenage children, two dogs and a cat and when time permits(!!) am a keen cyclist.
The video is not available to view online.