Robert Edgson
Just a regular SQL pro who also likes to present.because there is nothing better to validate the depth of your knowledge.
SQLBits 2010
You can create UK maps with SSRS 2008 R2
Corporate data is expensive to create, expensive to report. Adding free data sources and mapping can lift the simplest of reports to a stunning presentation.
The Presentation will take the simplest export to excel report then combine the Ordnance survey open data with RS 2008 R2 to create an interactive visual map report.
“http://www.ordnancesurvey.co.uk/oswebsite/opendata/”
What types of data is available
UK Open data provides the back bone to the Geo – Coding to provide a post code to latitude and longitude translation.
An introduction to spatial data types and why the UK open data does not plot natively to Bing maps.
Demo data types
An introduction to the new Mapping features
Demo new mapping features
Linking mapping data to corporate data
Demo linking data
Creating your report
Demo combining mapping and open data
All of that done on SQL 2008 R2 express
Creating your own UK report templates
“http://www.ordnancesurvey.co.uk/oswebsite/opendata/”
What types of data is available
UK Open data provides the back bone to the Geo – Coding to provide a post code to latitude and longitude translation.
An introduction to spatial data types and why the UK open data does not plot natively to Bing maps.
Demo data types
An introduction to the new Mapping features
Demo new mapping features
Linking mapping data to corporate data
Demo linking data
Creating your report
Demo combining mapping and open data
All of that done on SQL 2008 R2 express
Creating your own UK report templates