I am storing geography types in a table and need to extract KML snippets.
The best way I can determine to do this is the get the data out using asGML(). This gets me really close - but the format of the coordinates are different.
In GML the coordinates look like this (lat/lng space delimited) 37.883559999437914 -122.24446999957762 37.883635999905707 -122.24458899986539
What I need is a way to get the elements out like the following (lng/lat comma delimited) -122.24446999957762, 37.883559999437914, -122.24458899986539, 37.883635999905707Any help would be greatly appreciated. I'm stuck.
asked May 03 '12 at 10:17 AM in Default
Maybe you could look at [this project on CodePlex by Bob Beauchemin]: h ttp://sqlservertokml.codeplex.com/
answered May 03 '12 at 10:57 AM
Kev Riley ♦♦