I am trying to generate Google static maps on the fly that include a path based on data I have in a MS SQL Server geometry column. I currently use the encoded path algorithm to reduce the length of my url string.
However it turns out that the string being generated is still too long. I have too many geometry linestrings. So I was wondering is it possible to combine the line strings (where the starting and ending coordinates are the same), either in SQL or C# before generating the path and sending the url off to Google?
Here is a sample of my data in geom column
(No column name)LINESTRING (31.027897651712518 -29.858451392908322, 31.027948551616905 -29.85869646633877)(No column name)LINESTRING (31.027897651712518 -29.858451392908322, 31.027948551616905 -29.85869646633877)(No column name)LINESTRING (31.02776493862363 -29.857810990928524, 31.027897651712518 -29.858451392908322)(No column name)LINESTRING (31.027948551616905 -29.85869646633877, 31.027966320785087 -29.858782024992379)(No column name)LINESTRING (31.027966320785087 -29.858782024992379, 31.027972894327576 -29.858813675360686)
أكثر...
However it turns out that the string being generated is still too long. I have too many geometry linestrings. So I was wondering is it possible to combine the line strings (where the starting and ending coordinates are the same), either in SQL or C# before generating the path and sending the url off to Google?
Here is a sample of my data in geom column
(No column name)LINESTRING (31.027897651712518 -29.858451392908322, 31.027948551616905 -29.85869646633877)(No column name)LINESTRING (31.027897651712518 -29.858451392908322, 31.027948551616905 -29.85869646633877)(No column name)LINESTRING (31.02776493862363 -29.857810990928524, 31.027897651712518 -29.858451392908322)(No column name)LINESTRING (31.027948551616905 -29.85869646633877, 31.027966320785087 -29.858782024992379)(No column name)LINESTRING (31.027966320785087 -29.858782024992379, 31.027972894327576 -29.858813675360686)
أكثر...