Monthly Archives: March 2011

More Drawing Fun with SQL Server… this time in Technicolor

It seems I’m not the only one with a penchant for expressing my artistic side with SQL Server. Earlier today, Alex Whittles posted a screenshot to twitter showing his version of the SQLBits logo rendered in SQL Server Management Studio, … Continue reading

Posted in Spatial, SQL Server | Tagged , , | 1 Comment

Google Maps –vs- Bing Maps –vs- OSM – Responsiveness of Data Corrections

Yesterday, Glenn Letham published an article on the GISuser website explaining how to report map errors on Google Maps, Bing Maps, Open Street Maps etc. Seeing as I’ve already made comparisons in some of my own recent blog posts concerning … Continue reading

Posted in Bing Maps, Open Street Maps, Spatial | Tagged , , , , , | 5 Comments

SQL Server Spatial – Coordinate Storage Precision

SQL Server stores geography and geometry coordinates as binary data, adhering to the IEEE-754 standard for binary floating-point arithmetic. Based on this standard, each coordinate is stored as a double-precision floating-point number that is 64 bits (8 bytes) long. However, … Continue reading

Posted in Spatial, SQL Server | Tagged , | Leave a comment

Alpha Shapes and Concave Hulls

One question that gets raised relatively frequently over at the MSDN Spatial forums is how to create a concave hull around a set of points. The answer given is normally the same – while SQL Server provides the STConvexHull() method to … Continue reading

Posted in Spatial, SQL Server | Tagged , | 9 Comments

Japan Earthquake Data Overload

Sometimes, it can be hard to understand and make informed decisions in a given situation because of a lack of appropriate data. Following the recent terrible events in Japan, however, we’ve experienced the opposite problem – there is a data … Continue reading

Posted in Bing Maps, Spatial, SQL Server | Tagged , , , , | Leave a comment

CiviCRM – Creating a Custom Report

One of my current projects involves developing and deploying a new membership/contact database and management information system for a large not-for-profit organisation. Having examined various off-the-shelf systems, including HighRise, the decision was made to go with a customised build of … Continue reading

Posted in Drupal | Tagged , | 4 Comments

Open Street Maps –vs- Ordnance Survey (A.K.A. the Mystery of Birkbeck road)

In a previous post I compared how Open Street Maps (OSM) compared to Bing Maps and Google Maps in terms of completeness, at least for a small part of the UK. In this post I’m going to look at how … Continue reading

Posted in Bing Maps, Open Street Maps, Spatial | Tagged , | 2 Comments