UK Spatial Data into SQL Server 2008r 2

UK Spatial Data into SQL Server 2008/r 2 + Reporting Services Daniel Gaze & Neal Atkinson The Co-operative Group neal. atkinson@co-operative. coop daniel. gaze@coop. co. uk

Want to display UK based Geo. Spatial Data in Reporting services 3 questions: • Where is the data • How do I get it into SQL Server • How do I integrate it with my data

Finding the data • Ordnance Survey Open Data Contains: – GB post code data – Boundary Line data - County / Admin – Street Level maps – Location Finding data – Free to use https: //www. ordnancesurvey. co. uk/opendatadownload/products. html

Importing data into SQL • OS Code Point Data Importer – Visual Studio – Converts Postcode data (geometry) into Lat/Long coordinates (geography) – This allows you to display postcodes on bing/google maps https: //github. com/Ada. The. Dev/Ordnance-Survey-Code-Point-Data. Importer • Shape 2 SQL – Will import shapefiles into SQL http: //www. sharpgis. net/page/SQL-Server-2008 -Spatial-Tools. aspx

Representing UK on a map • Requires a Polygon dataset • Can use OS Boundary data – Complex polygons – Splits country into mix of two/three tier divisions • We’re using a simplified dataset showing traditional counties

Example Reports • Heat Map • Point data • Bing Maps Overlay

Finally • Limitations – free datasets, maybe not in the format you require, some missing data. • Just a starting point for you to start using UK based spatial data in SQL Server. • All information + links available on Martin Bell’s Blog – http: //sqlblogcasts. com/blogs/martinbell/