5

Anyone have a function or DLL that will convert KML to SqlGeography (SQLServer DataType)?

I'll write it out myself if i have to, but i'm surprised i can't find one out there.

capdragon
  • 14,565
  • 24
  • 107
  • 153

2 Answers2

3

I created a project to do it when I had this problem. I've got it open sourced now. (https://github.com/pharylon/kml2sql). If it isn't exactly what you need, SharpKML is a great library for getting started on your own project. (http://sharpkml.codeplex.com/).

Pharylon
  • 9,796
  • 3
  • 35
  • 59
1

Other people have had this problem. There are solutions but they are generally overkill. Here is a lighter solution:

http://consultingblogs.emc.com/stevewright/archive/2009/01/23/how-to-load-spatial-data-into-sql-server-2008-from-net.aspx

winwaed
  • 7,645
  • 6
  • 36
  • 81