[postgis-users] ST_NPoints from polygons

Etienne B. Racine etiennebr at gmail.com
Mon Jul 1 11:38:05 PDT 2019


Thanks!

Le lun. 1 juil. 2019 à 11:25, Martin Davis <mtnclimb at gmail.com> a écrit :

> Yes, that is correct.
>
> As per the Simple Features for SQL standard, Linear Rings include a
> closing point which is equal to the start point, and all points are
> included in the count.  Polygons are made up of rings, so inherit this
> behaviour.
>
> On Mon, Jul 1, 2019, 4:46 AM Etienne B. Racine <etiennebr at gmail.com>
> wrote:
>
>>
>> Hi list,
>>
>> I'm implementing postgis compatible functions for R, so I wanted to make
>> sure I had the right behavior. I wanted to check that the behavior of
>> ST_NPoints was consistent with expectations.
>> SELECT ST_NPoints('POLYGON((0 0, 1 1, 2 0, 0 0))'::geometry);
>> #>  st_npoints
>> #> ------------
>> #>           4
>> I would have expected that the repeated vertex wouldn't be counted (a
>> triangle would have 3 vertices). The doc (*Return the number of points
>> in a geometry*) seems to imply that the behavior is correct though,
>> since a point isn't necessarly a vertex; but it still leaves room to
>> interpretation.
>>
>> Etienne
>>
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at lists.osgeo.org
>> https://lists.osgeo.org/mailman/listinfo/postgis-users
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20190701/1a00f3ce/attachment.html>


More information about the postgis-users mailing list