I have not dealt with that specific problem, but I am working with SQL server with features converted to text strings (WKT) and mapping them over Bing Maps. SQL server stores the X,Y coordinate opposite of the way the Bing Maps API needs them, and a few other parens "()" formatting issues.... so I created a class in vb.net to rewrite the WKT stored in SQL Server flipping the XY coordinates on the fly.... Hopefully this will give you some ideas?
Imports Microsoft.VisualBasic
Namespace TSK.GML2VE
Public Class GML2VE
Private mGML As String = ""
Private mFeatureType As String = ""
Private mShapeID As String = ""
Private mFID As Integer = 0
Public Property ShapeID() As String
Get
Return mShapeID
End Get
Set(ShapeID As String)
mShapeID = ShapeID
End Set
End Property
Public Property FID() As Integer
Get
Return mFID
End Get
Set(FID As Integer)
mFID = FID
End Set
End Property
Public Property GML() As String
Get
Return mGML
End Get
Set(GML As String)
mGML = GML
End Set
End Property
Public Property FeatureType() As String
Get
Return mFeatureType
End Get
Set(FeatureType As String)
mFeatureType = FeatureType
End Set
End Property
Public Function VE() As String
If mGML = "" Or mFeatureType = "" Or mShapeID = "" Then
Return "Set GML, Feature Type"
Else
Dim WKT As String = ""
Dim Output As String = ""
Dim VEGM As String = ""
Select Case mFeatureType
Case "Point"
'Get the WKT representation of the object
WKT = mGML
'Replace the double brakets that surround the coordinate pair
WKT = Replace(WKT, "POINT (", "")
''Remove the closing double brackets
WKT = Replace(WKT, ")", "")
'Build the Pushpin/GMarker object from the coordinates
VEGM = ""
Dim Coords() = Split(Trim(WKT), " ")
VEGM = VEGM + "new VELatLong(" + Coords(1) + "," + Coords(0) + ")"
Output += "var " + mShapeID + "=new VEShape(VEShapeType.Pushpin, " + VEGM + ");"
Case "LineString"
'Get the WKT
WKT = mGML
'Remove the Line String definition and opening bracket
WKT = Replace(WKT, "LINESTRING (", "")
'Remove the last bracket
WKT = Replace(WKT, ")", "")
'Create an Array of each point in the LineString
Dim PointArray() As String = Split(WKT, ",")
'Loop through each point in the array
Dim i As Integer = 0
While i <= PointArray.Length - 1
'Split the pint into individual coordinates
Dim Coords() = Split(Trim(PointArray(i)), " ")
'Build an array of the equivalent point definitions
VEGM = VEGM + " new VELatLong(" + Coords(1) + "," + Coords(0) + "),"
'Go on to the next point
i = i + 1
End While
'Remove the trailing comma
VEGM = Left(VEGM, VEGM.Length - 1)
Output += "var " + mShapeID + "= new VEShape(VEShapeType.Polyline, [" + VEGM + "]);"
'Do Text and pretty stuff
Case "Polygon"
'Get the WKT representation of the object
WKT = mGML
'Replace the double brackets that surround the coordinate point pairs
WKT = Replace(WKT, "POLYGON ((", "")
'Remove the closing double brackets
WKT = Replace(WKT, "))", "")
'Create an array of each point in the Polygon
Dim PointArray() As String = Split(WKT, ",")
'Build the appropriate VE/GMaps Polygon object from the coordinates
VEGM = ""
Dim i As Integer = 0
While i <= PointArray.Length - 1
Dim Coords() = Split(Trim(PointArray(i)), " ")
Coords(0) = Coords(0).Replace("(", "")
Coords(1) = Coords(1).Replace(")", "")
VEGM = VEGM + "new VELatLong(" + Coords(1) + "," + Coords(0) + "),"
i = i + 1
End While
'Remove the last trailing comma
VEGM = Left(VEGM, VEGM.Length - 1)
'Add the constructor for the Polygon, and apply styling options
Output += "var " + mShapeID + "=new VEShape(VEShapeType.Polygon, [" + VEGM + "]);"
End Select
Return Output
End If
End Function
End Class
End Namespace
.... just roll with it
