[postgis-users] linestring limits

[Clay, Bruce]

Hugues:
  Thanks for your reply.  
 
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.
 
Bruce

________________________________

From: postgis-users-bounces at lists.osgeo.org on behalf of Hugues François
Sent: Fri 9/13/2013 2:49 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] linestring limits



Hello,

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 ?

Hugues

"Clay, Bruce" <bclay at ball.com> a écrit :

Is there a limit to the number of points or character linelengh that can be used to create a linestring?

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.

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.

Bruce



This message and any enclosures are intended only for the addressee.  Please
notify the sender by email if you are not the intended recipient.  If you are
not the intended recipient, you may not use, copy, disclose, or distribute this
message or its contents or enclosures to any other person and any such actions
may be unlawful.  Ball reserves the right to monitor and review all messages
and enclosures sent to or from this email address.
_______________________________________________
postgis-users mailing list
postgis-users at lists.osgeo.org
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



This message and any enclosures are intended only for the addressee.  Please 
notify the sender by email if you are not the intended recipient.  If you are 
not the intended recipient, you may not use, copy, disclose, or distribute this 
message or its contents or enclosures to any other person and any such actions 
may be unlawful.  Ball reserves the right to monitor and review all messages 
and enclosures sent to or from this email address.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20130916/6071f0c2/attachment.html>