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: [email protected] 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" <[email protected]> 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 [email protected] 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.
_______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
