Utilizing UK Spatial Data in SQL Server 2008 R2 Reporting Services

Explore how to display UK geospatial data in SQL Server 2008 R2 Reporting Services by finding and importing Ordnance Survey Open Data. Learn how to represent the UK on a map, import data into SQL, and create example reports. Discover limitations and resources to kickstart your spatial data journey in SQL Server.

• UK Spatial Data
• SQL Server
• Reporting Services
• Geospatial Data
• Ordnance Survey

kaer212 Follow

Uploaded on Sep 22, 2024 | 0 Views

Download Presentation

Please find below an Image/Link to download the presentation.

The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author. Download presentation by click this link. If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.

Presentation Transcript

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

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

3. 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

4. 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/AdaTheDev/Ordnance-Survey-Code-Point-Data- Importer Shape2SQL Will import shapefiles into SQL http://www.sharpgis.net/page/SQL-Server-2008-Spatial-Tools.aspx

5. 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

6. Example Reports Heat Map Point data Bing Maps Overlay

7. 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/