How to convert an ESRI Shape-file into SQL Server 2008?

sql-server-2008 geospatial esri shapefile
Kristian Frost picture Kristian Frost · Aug 17, 2010 · Viewed 7.8k times · Source

I have a shapefile that I would like to upload to a spatial SQL Server 2008. I have tried using this tool: SQL Server 2008 Spatial Tools. But without luck.

Does anyone know any other (free) tools for doing this?

Answer

Dave Lowther picture Dave Lowther · Aug 20, 2010

You can use ogr2ogr to convert from shapefile to GML (or many other formats) and then use SQL Server's GeomFromGML to import. You will need to call GeomFromGML for each feature in your shapefile, but that's a relatively easy program to write.

Related questions

SQL Server 2008 Spatial: find a point in polygon

I am using SQL Server 2008 spatial data types. I have a table with all States (as polygons) as data type GEOMETRY. Now I want to check if a point's coordinates (latitudes, longitudes) as data type GEOGRAPHY, is inside that State …

Read More
Selecting a good SQL Server 2008 spatial index with large polygons

I'm having some fun trying to pick a decent SQL Server 2008 spatial index setup for a data set I am dealing with. The dataset is polygons, representing contours over the whole globe. There are 106,000 rows in the table, the polygons …

Read More
SQL 2008 geography & geometry - which to use?

I'm creating a Google map mashup and am using SQL 2008. I will have a large number of points on the earth and will want to perform various calculations on them in SQL - such as selecting all points contained within …

Read More