Browse by Tags

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...
Posted 13 November 09 02:27 by EdKatibah | 1 Comments   
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...
Posted 07 October 09 09:02 by EdKatibah | 1 Comments   
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...
Posted 05 June 09 10:09 by EdKatibah | 7 Comments   
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...
Posted 05 June 09 10:15 by EdKatibah | 0 Comments   
"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...
Posted 18 May 09 03:27 by EdKatibah | 9 Comments   
"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...
Posted 17 May 09 09:53 by EdKatibah | 2 Comments   
"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...
Posted 16 May 09 07:04 by EdKatibah | 2 Comments   
"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...
Posted 09 May 09 09:35 by EdKatibah | 4 Comments   
"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...
Posted 09 May 09 09:29 by EdKatibah | 2 Comments   
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...
Posted 10 March 09 10:22 by EdKatibah | 1 Comments   
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...
Posted 20 January 09 11:56 by EdKatibah | 0 Comments   
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...
Posted 13 January 09 03:05 by EdKatibah | 10 Comments   
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...
Posted 28 December 08 09:29 by EdKatibah | 2 Comments   
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...
Posted 19 August 08 06:40 by EdKatibah | 3 Comments   
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...
Posted 25 July 08 07:06 by EdKatibah | 0 Comments   
More Posts Next page »

Search

This Blog

Legalese: All postings are provided "As Is" with no warranties, and confer no rights.

Syndication

Page view tracker