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 , | 12 Comments