<HTML dir=ltr><HEAD><TITLE>Re: [postgis-users] linestring limits</TITLE>
<META content="text/html; charset=unicode" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.7601.18129"></HEAD>
<BODY>
<DIV dir=ltr id=idOWAReplyText13562>
<DIV dir=ltr><FONT color=#000000 size=2 face=Arial>Hugues:</FONT></DIV>
<DIV dir=ltr><FONT size=2 face=Arial> Thanks for your reply. </FONT></DIV>
<DIV dir=ltr><FONT size=2 face=Arial></FONT> </DIV>
<DIV dir=ltr><FONT size=2 face=Arial>I looked at the attribute table in pgAdminIII. If everything is intact it will show an entry in the geometry column. executing "SELECT ST_AsText(shape)" should show all of the points in the geometry. All of the features appear in the table and all of the attributes for each feature appear but the features with more than around 4000 characters in the insert SQL did not show any geometries.</FONT></DIV>
<DIV dir=ltr><FONT size=2 face=Arial></FONT> </DIV>
<DIV dir=ltr><FONT size=2 face=Arial>Bruce</FONT></DIV></DIV>
<DIV dir=ltr><BR>
<HR tabIndex=-1>
<FONT size=2 face=Tahoma><B>From:</B> postgis-users-bounces@lists.osgeo.org on behalf of Hugues François<BR><B>Sent:</B> Fri 9/13/2013 2:49 PM<BR><B>To:</B> PostGIS Users Discussion<BR><B>Subject:</B> Re: [postgis-users] linestring limits<BR></FONT><BR></DIV>
<DIV>
<P><FONT size=2>Hello,<BR><BR>What do y ou mean by opening the attributes table and looked at geometries ? With pgadmin there are limitations on number of characters displayed. I dont know with qgis. Did y ou open the table as spatial data un qgis or openjump ? Does the expected number of geometries appear ?<BR><BR>Hugues<BR><BR>"Clay, Bruce" <bclay@ball.com> a écrit :<BR><BR>Is there a limit to the number of points or character linelengh that can be used to create a linestring?<BR><BR>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.<BR><BR>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.<BR><BR>Bruce<BR><BR><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>_______________________________________________<BR>postgis-users mailing list<BR>postgis-users@lists.osgeo.org<BR>https://urldefense.proofpoint.com/v1/url?u=http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users&k=1GMYaKjmAz8SrwAdnQ9klA%3D%3D%0A&r=K4H48yPCHyVPqNGGr1%2B9nQ%3D%3D%0A&m=ESWYkEphmpA5F2Qv%2F1WKyXL0rUWZS0H8dYZ5T7eBVno%3D%0A&s=9380e8cee7eaf59c91f10e1e0d80dc690dcaa5e675637ad91ecbdc21d6d6182a</FONT></P></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>