sql server 2008

Linear Referencing in SQL Server 2008

Linear referencing is used to define features in relation to existing line features. These new features can either be points or lines. For example a water monitoring station can be defined as 300m along a section of river, or a stretch of road can be defined as requiring repairs, from 220m along to 270m along. […]

Assigning Points to Polygons in SQL Server

A common requirement in GIS is to be able to find the number of points in a polygon to answer a question such as “how many towns are in this county.” With the spatial operations in SQL Server this can be calculated dynamically, however for large spatial datasets it can often take several minutes to […]

OGR Comes to SQL Server 2008 Spatial

OGR, created by Frank Warmerdam, is an open source library and set of command line utilities for reading and writing geospatial vector data using many different formats . It is the vector equivalent of GDAL which has similar functionality for rasters. The name of the library is a vestige from when OGR used to stand for […]

Does SQL Azure have Allure?

I love SQL Server 2008 spatial functionality. Not only because it has effectively killed off the middle-man GIS database software, but it even sticks to OGC standards allowing the same data and tables to be used in nearly all GIS software. However I have some reservations about the use of SQL Azure for GIS applications. […]

MapInfo and SQL Server 2008

For a new project I am working for the first time with MapInfo 10 “the world’s premier desktop mapping application.” In an effort to move away from MapInfo’s .tab files (the shapefile equivalent) I was keen to test out the direct connection to geometry stored in SQL Server 2008. Until version 9.5 data could only […]

Copying Spatial Data between SQL Server Databases

Aim – to copy a table containing geometry fields between two database servers. The task was made slightly trickier as the two servers are on two different domains. I wanted to use SQL rather than FME, or a SQL Server wizard, as it would be easier to script the process for the several tables I […]

MapServer and SQL Server 2008 Plug-in

The SQL Server 2008 plugin for MapServer is a “native driver modeled on the PostGIS driver to support SQL Server 2008’s newly added spatial capabilities.” It works fine for displaying data as WMS layers in OpenLayers however I ran into all sorts of problems when trying to use the GetFeatureInfo WMS query. With MapServer 5.2.1  […]