[prev in list] [next in list] [prev in thread] [next in thread]
List: postgis-users
Subject: Re: [postgis-users] linestring limits
From: "Clay, Bruce" <bclay () ball ! com>
Date: 2013-09-16 13:28:39
Message-ID: C482FF98AE985A47B8C982FD429C9E34D8C0DF () daytonmsg2k3 ! AERO ! BALL ! COM
[Download RAW message or body]
--===============2618006446035746344==
Content-class: urn:content-classes:message
Content-Type: multipart/alternative;
boundary="----_=_NextPart_001_01CEB2E0.A76C88BA"
This is a multi-part message in MIME format.
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@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@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@lists.osgeo.org
https://urldefense.proofpoint.com/v1/url?u=http://lists.osgeo.org/cgi-bin/mailman/list \
info/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.
[Attachment #3 (unknown)]
<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=ht \
tp://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users&k=1GMYaKjmAz8SrwAdnQ9k \
lA%3D%3D%0A&r=K4H48yPCHyVPqNGGr1%2B9nQ%3D%3D%0A&m=ESWYkEphmpA5F2Qv%2F1WKyXL0rU \
WZS0H8dYZ5T7eBVno%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>
_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
--===============2618006446035746344==--
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic