May 2009 - Posts

"Cartographic Adjustment" of Spatial Data for SQL Server Reporting Services, Part 5
The Report Builder, a component of Reporting Services, described in this post will be available as a separate download when the upcoming CTP2 release of SQL Server 2008 Release 2 (R2) is made available to the public, currently scheduled for August 2009. Read More...
"Cartographic Adjustment" of Spatial Data for SQL Server Reporting Services, Part 4
In the previous posts I indicated that this would be the last post in this series but it turned out that I was a bit optimistic. In order to make the final Report Builder post relevant, some interesting data for analysis was needed.  In this post Read More...
"Cartographic Adjustment" of Spatial Data for SQL Server Reporting Services, Part 3
In the previous posts we have covered items 1,2 and 3 of the workflow.  In this post we address item 4. Locate data source and download (Part 1) Load the data into SQL Server (Part 1) Remove unwanted features, simplify Alaska and Hawaii spatial features Read More...
"Cartographic Adjustment" of Spatial Data for SQL Server Reporting Services, Part 1
I was recently presented with the problem of taking a US States dataset, in geographic coordinates, and creating a database table whose spatial column would render in a similar fashion to the map, below, with the Alaska and Hawaii insets. The ultimate Read More...
"Cartographic Adjustment" of Spatial Data for SQL Server Reporting Services, Part 2
In the previous post we covered items 1 and 2 of the workflow.  In this post, we will cover item 3: Locate data source and download Load the data into SQL Server Remove unwanted features, simplify Alaska and Hawaii spatial features   "Reposition" Read More...

Search

This Blog

Syndication

Page view tracker