[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    Re: [postgis-users] Polygon length zero
From:       Fred Lehodey <lehodey () gmail ! com>
Date:       2010-04-23 18:36:42
Message-ID: h2kc417bbc91004231136g2a094003yd0f2ebde418554 () mail ! gmail ! com
[Download RAW message or body]

[Attachment #2 (multipart/alternative)]


Try ST_Perimeter() for areal geometries.

Fred


On Fri, Apr 23, 2010 at 6:45 PM, Andrea Peri 2007 <aperi2007@gmail.com>wrote:

> Hi,
>
> using this polygon:
> MULTIPOLYGON(((1 1, 2 3, 10 10, 1 1)))
>
> The Length return is zero.
>
> Perhaps I'm forget something ?
>
> This is my simply sql code.
>
> create table _uno (id serial primary key);
> SELECT AddGeometryColumn('_uno', 'geom', 3003, 'MULTIPOLYGON', 2);
> insert into _uno (geom) values (ST_GeomFromText('MULTIPOLYGON(((1 1, 2 3,
> 10 10, 1 1)))',3003));
> select st_length(geom) from _uno
>
> -------
> 0
>
> I'm using Postgres 8.4.3 - Postgis 1.5.1 on windows 7 - 64 bit.
>
> Thx,
>
> Andrea Peri.
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users@postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>

[Attachment #5 (text/html)]

Try ST_Perimeter() for areal geometries.<br><br>Fred<br><br><br><div \
class="gmail_quote">On Fri, Apr 23, 2010 at 6:45 PM, Andrea Peri 2007 <span \
dir="ltr">&lt;<a href="mailto:aperi2007@gmail.com">aperi2007@gmail.com</a>&gt;</span> \
wrote:<br> <blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; \
border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">Hi,<br> <br>
using this polygon:<br>
MULTIPOLYGON(((1 1, 2 3, 10 10, 1 1)))<br>
<br>
The Length return is zero.<br>
<br>
Perhaps I&#39;m forget something ?<br>
<br>
This is my simply sql code.<br>
<br>
create table _uno (id serial primary key);<br>
SELECT AddGeometryColumn(&#39;_uno&#39;, &#39;geom&#39;, 3003, \
&#39;MULTIPOLYGON&#39;, 2);<br> insert into _uno (geom) values \
(ST_GeomFromText(&#39;MULTIPOLYGON(((1 1, 2 3, 10 10, 1 1)))&#39;,3003));<br> select \
st_length(geom) from _uno<br> <br>
-------<br>
0<br>
<br>
I&#39;m using Postgres 8.4.3 - Postgis 1.5.1 on windows 7 - 64 bit.<br>
<br>
Thx,<br>
<br>
Andrea Peri.<br>
<br>
<br>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@postgis.refractions.net" \
target="_blank">postgis-users@postgis.refractions.net</a><br> <a \
href="http://postgis.refractions.net/mailman/listinfo/postgis-users" \
target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br> \
</blockquote></div><br>



_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users


[prev in list] [next in list] [prev in thread] [next in thread]