<HTML dir=ltr><HEAD>
<META content="text/html; charset=unicode" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.7601.18129"></HEAD>
<BODY>
<DIV><FONT color=#000000 size=2 face=Arial>Is there a limit to the number of points or character linelengh that can be used to create a linestring?</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>I used QGis to trace some roads then exported the layer as a KML file. I wrote a script to create a table and add attributes to the table then copied the coordinates from the KML into the script after manipulating the punctuation and white space. When I open the attributes table only some of the lines showed geometry. I played with the script for a while and it seemd like there was a limit to somewhere around 4,000 characters. It did not seem to be a hard limit at 4,000 but it was pretty close.</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>If there is a limit is there a way to change the configuration to get past this? Some of the strings used with STY_GeomFromText where around 7,000 characters.</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>Bruce</FONT></DIV>
<DIV>
<BR>
<BR>
This message and any enclosures are intended only for the addressee. Please <BR>
notify the sender by email if you are not the intended recipient. If you are <BR>
not the intended recipient, you may not use, copy, disclose, or distribute this <BR>
message or its contents or enclosures to any other person and any such actions <BR>
may be unlawful. Ball reserves the right to monitor and review all messages <BR>
and enclosures sent to or from this email address.<BR>
</DIV></BODY></HTML>