Utilizing UK Spatial Data in SQL Server 2008 R2 Reporting Services
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
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
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/AdaTheDev/Ordnance-Survey-Code-Point-Data-
Importer
•
Shape2SQL
–
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/
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.
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.
E N D
Presentation Transcript
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
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
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/AdaTheDev/Ordnance-Survey-Code-Point-Data- Importer Shape2SQL 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/
