Spatial Ed
Information and news on SQL Server Spatial and environs...
Browse by Tags
Bugs
CTP-6
February CTP
Spatial
SQL Server
My Overheating IBM ThinkPad T60p Laptop
My faithful old IBM T60p laptop has been with me for years. Over time, and every so slowly, it has been running hotter and hotter (especially when running complex spatial queries on SQL Server 2008 or generating map-based reports using the new SQL
Read More...
A Spatially-Enabled Dinner In Austin, Texas: Some Observations Outside the Office
Not having posted for a while, I thought I'd take a few minutes and provide some thoughts on spatial after successfully negotiating dinner here in Austin, Texas (October 6, 2009). I'm in town for the Texas GIS Forum, one of my favorite conferences,
Read More...
Working with Invalid Data and the SQL Server 2008 Geography Data Type, Part 2
In a long past post, Working with Invalid Data and the SQL Server 2008 Geography Data Type, Part 1b (August 2008), I discussed techniques for dealing with invalid data and the geography data type. In my last post, I listed the new geography validation
Read More...
Update to the SQL Server Spatial Tools project on CodePlex
As Isaac noted in his most recent post , the SQL Server Spatial Tools project on CodePlex has been updated with several new geography functions. This post provides additional detail on the new features: IsValidGeographyFromGeometry IsValidGeographyFromText
Read More...
"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...
Address Geocoding With SQL Server 2008 Spatial
In his new book, Beginning Spatial with SQL Server 2008 , Alastair Aitchison describes how to create a new CLR-based geocoding T-SQL function utilizing the MapPoint Web Service . Additionally, there is an SSIS -based MapPoint Batch Geocoder for
Read More...
Loading GeoNames Data Into SQL Server 2008 (the PowerShell, bcp way...)
In the first installment on this topic, I used a commercial text editor, EditPad Pro , to perform the Unicode file conversion and SQL Server BULK INSERT to load the data. In this installment, I'm going to change to workflow a bit to use of Microsoft's
Read More...
Loading GeoNames Data Into SQL Server 2008 (yet another way...)
In his post last year, Integrating Virtual Earth and GeoNames , Johannes described how to load the GeoNames database into SQL Server using the "Import Data" Wizard in SQL Server Management Studio. In his scenario, Johannes did not need to take
Read More...
Where is Ed?
After a rather lengthy hiatus, I'm back to blogging once again. I was awakened from my reverie by an old friend who noted that a few folks had wondered if I was still alive and kicking. Not to worry, I'm still busy with SQL Server Spatial.
Read More...
Working with Invalid Data and the SQL Server 2008 Geography Data Type, Part 1b
" Fixing" Polygon Ring Orientation in SQL Server 2008 using T-SQL In the last installment, I promised to try and correct invalid Geography data using FME. While I am making progress on that front, I decided to take a small detour and discuss
Read More...
GeoWeb 2008 Conference Dinner Cruise Photos (and SQL Server 2008 Spatial ;-)
On the Wednesday night GeoWeb 2008 dinner cruise around Vancouver harbor, several folks who had forgotten their cameras (and 1 who had broken their camera) noted that I was busy taking photos and asked if they could be made available. I am happy to report
Read More...
More Posts
Next page »
Search
This Blog
Home
About
Email
Legalese: All postings are provided "As Is" with no warranties, and confer no rights.
Tags
Bugs
CTP-6
February CTP
Spatial
SQL Server
Archives
November 2009 (1)
October 2009 (1)
June 2009 (2)
May 2009 (5)
March 2009 (1)
January 2009 (2)
December 2008 (1)
August 2008 (1)
July 2008 (2)
March 2008 (4)
February 2008 (2)
Syndication
RSS 2.0
Atom 1.0