Spatial Ed's blog

Information and news on spatial data support in Windows Azure SQL Database, SQL Server and environs...

Browse by Tags

Tagged Content List
  • Blog Post: Updated Spatial Features in the SQL Azure Q4 2011 Service Release

    The Q2 2011 Service Release of SQL Azure introduced the updated spatial data platform from SQL Server 2012. SQL Server 2012 spatial features are being released in SQL Azure in increments, beginning with Q2 2011 Service Release. With the introduction of the Q4 2011 Service Release for SQL Azure, a new...
  • Blog Post: Potential Side-Effects of Improved Spatial Precision in SQL Server 2012 and the SQL Azure September 2011 Service Release

    In Microsoft SQL Server 2012 (previously known as SQL Server Code-Name “Denali”), all constructions and relations are now done with 48 bits of precision, compared to 27 bits used in SQL Server 2008 and SQL Server 2008 R2. This can result in differences that range from how individual coordinates...
  • Blog Post: A Short Discussion On The ShortestLineTo() Method

    In a recent post to the SQL Server Spatial Forum , the subject of finding the closest point from one geometry to another resurfaced. While this was a difficult problem with SQL Server 2008, the new “Denali” CTP has introduced a method, ShortestLineTo(), which provides a solution to this problem. Taking...
  • Blog Post: New Spatial Features in SQL Server Code-Named “Denali” CTP1

      We have just released a white paper, New Spatial Features in SQL Server Code-Named “Denali” Community Technology Preview 1 , as your definitive guide to the spatial improvements in this release of SQL Server. Of course, you can’t take advantage of the new spatial features without the new server...
  • Blog Post: Loading ANSS Earthquake Data Into SQL Server 2008

    The Advanced National Seismic System (ANSS) maintains a comprehensive catalog of worldwide seismic events (typically earthquakes) which is a good source of spatial data for SQL Server 2008.  The ANSS Composite Catalog (formerly called the CNSS Earthquake Catalog) provides a search capability which...
  • Blog Post: Spatial Data Support Coming To SQL Azure

    Last Wednesday (March 17th), Dave Robinson of the SQL Azure Team announced upcoming support for spatial data in SQL Azure.  You can view the announcement at the MIX Conference in the video of Dave’s presentation, Building Web Applications with Microsoft SQL Azure (go to 18:40 on the timeline for...
  • Blog Post: Inside Microsoft SQL Server 2008: T-SQL Programming – Source Code and Spatial Data for Chapter 14

    In the previous post , the content for Chapter 14, Spatial Data, was presented.  This post will discuss the sample code and the spatial data associated with the chapter. SOURCE CODE .  The Source Code for Chapter 14 - Spatial Data is located in the zip file: TSQLProgramming20090901.zip (457...
  • Blog Post: Inside Microsoft SQL Sever 2008: T-SQL Programming, Chapter 14, Spatial Data

    In a shameless bit of self-promotion, I’d like to call attention to the new book, Inside Microsoft SQL Server 2008: T-SQL Programming (Microsoft Press). You can get further information on the book at Itzik’s blog or by going to Microsoft Press , but I wanted highlight Chapter 14 on spatial data in this...
  • Blog Post: 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 functions in the SQL Server Spatial Tools project...
  • Blog Post: "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.   This was to be the last post in this series...
  • Blog Post: "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 we describe where to find and how to load State-based...
  • Blog Post: "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 (Part 2) "Reposition" Alaska and...
  • Blog Post: "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 goal was to use the resulting table in the new map...
  • Blog Post: "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" Alaska and Hawaii cartographically...
  • Blog Post: 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 SQL Server 2008 which also uses the MapPoint Web Service...
  • Blog Post: 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 PowerShell for the Unicode file conversion and bcp...
  • Blog Post: 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 advantage of the spatial type support in SQL Server...
  • Blog Post: 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 an interesting but little known behavior of...
  • Blog Post: WORKING WITH INVALID DATA AND THE SQL SERVER 2008 GEOGRAPHY DATA TYPE, PART 1

    As many of you have already discovered, the Geography data type in SQL Server 2008 is very strict about the structure of the spatial data which it will accept. The Geometry data type, on the other hand, is much more forgiving about spatial data which does not conform to the rules defined in the OGC Simple...
  • Blog Post: SQL SERVER SPATIAL BUGS...

    As part of the Microsoft SQL Server 2008 February CTP Bug Bash Contest, we are looking for spatial bugs! The entrant with the largest number of reproducible non-duplicate SQL Server 2008 Spatial bugs submitted during the entry period will win an Xbox Elite. At last check, we had 1 entrant with 1 bug...
  • Blog Post: Introduction

    Welcome to my first blog effort. Many of you in the spatial world may already know me. For everyone else, I am the Spatial Program Manager for SQL Server. I’ve been working in the spatial/GIS field much longer than I wish to admit, with prior engagements at Informix Software and IBM in the recent past...
Page 1 of 1 (21 items)