[pgrouting-users] Bug in pgr_pointsasPolygon
Dave Potts
mrdapotts at gmail.com
Thu Feb 23 23:44:06 PST 2017
I think I may have found an issue with the pgr_pointsasPolygon function
I have a collection off points, I have assumed that the
pgr_pointsasPolygon would draw a bounding polygon around all the points.
What seems to happen is that I get two very small polygon generated
Example as follows
insert into bug_output(the_geom) select st_setsrid(the_geom,3857) from
pgr_pointsasPolygon('select id, st_x(the_geom) as x, st_y(the_geom) as y
from bug_input',0) as the_geom ;
Two small polygons generated
I try the following
insert into bug_output(the_geom) select
st_multi((st_convexhull(st_collect(the_geom)))) from bug_input;
I get only large bounding polygon
I have checked the results with qgis
IF I have made a mistake please tell me
(dump of bug_input table attached)
Dave
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20170224/1c01516d/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: bug.sql
Type: application/sql
Size: 23413 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20170224/1c01516d/attachment-0001.bin>
More information about the Pgrouting-users
mailing list