SQL Server Error – SSMS GUI – Mismatch in column datatype and tessellation scheme

When below error occurs, remember to change the Tesselation scheme, in this case from Geometry grid to Geography auto [if the case]   Example code:   SET ARITHABORT ON SET CONCAT_NULL_YIELDS_NULL ON SET QUOTED_IDENTIFIER ON SET ANSI_NULLS ON SET ANSI_PADDING ON SET ANSI_WARNINGS ON SET NUMERIC_ROUNDABORT OFF   GO CREATE SPATIAL INDEX [SpatialIndex-Vegetation1] ON [dbo].[VEGETATION1] […]

Read More

Uploading ESRI Shapefile into Microsoft SQL Server 2008 Spatial Database

Microsoft SQL Server from release 2008, 2008 R2, 2012 and above, support spatial data types. Tool used for this – shape2sql – by Morten Nielsen/SharpGIS can be found by clicking here. Sample test data used was downloaded from here – OpenStreetMap and  here – Processed Coastline Data Screenshot After import into SQL, this translated in […]

Read More