SpatialSQLfortheGeographer

Sample data and scripts using Microsoft spatial SQL. Code developed using SQL Server 2008 R2, but everything still works as of April 2016 up through Microsoft SQL Server 2014. Any suggestions or improvements are welcome. UPDATE, this should all still work as of July 2018, but some of the links in the blog postings are going to technical pages that are no longer supported. I will eventually get the links updated, but no promises!

All scripts and tables used here are based on the <a href="https://msdn.microsoft.com/en-us/library/cc280487.aspx">GEOMETRY data type</a>

Data used in scripts and tutorials can be downloaded <a href="http://www.benjaminspaulding.com/downloads/Tutorial_Spatial_Data.zip">here (it's a 28mb zip)</a>. All data originally downloaded from <a href="http://www.naturalearthdata.com/">Natural Earth's awesome website</a>

A number of tutorials are available from benjaminspaulding.com

Part 1 - <a href="http://www.benjaminspaulding.com/2011/11/15/spatial-sql-geographer-part-1-spatial-sql/">Welcome to Spatial SQL</a>

Part 2 - <a href ="https://www.benjaminspaulding.com/2011/11/21/spatial-sql-geographer-part-2-basic-spatial-sql-scripts/">Basic Spatial SQL Scripts</a>

Part 3 - <a href ="https://www.benjaminspaulding.com/2012/01/30/spatial-sql-geographer-part-3-basic-spatial-sql-scripts/">More Basic Spatial SQL Scripts</a>

Part 4 - <a href ="http://www.benjaminspaulding.com/2013/05/07/spatial-sql-multi-point-line/">Mulit-Point to Line Example</a>