[postgis-users] unioning a buffer - bug?
Lee
quimby5 at yahoo.com
Mon Sep 13 07:07:06 PDT 2010
So after some googling I see similar problems, but no solutions posted.
I am trying to union a buffer, but the query is returning no results. Here is
ultimately what I would like to achieve:
select st_union(st_buffer(the_geom,0.1)) as the_geom from
base.current_assessment_parcel
Here are some troubleshooting steps I have taken to try narrow it down:
select st_isvalid(the_geom) a from base.current_assessment_parcel group by a
TRUE
select st_isvalid(st_buffer(the_geom,0.1)) a from base.current_assessment_parcel
group by a
TRUE
select st_isvalid(st_union(the_geom)) from base.current_assessment_parcel
TRUE
select st_isvalid(st_union(st_buffer(the_geom,0.1))) from
base.current_assessment_parcel
NOTICE: TopologyException: found non-noded intersection between 586714
4.95189e+006, 586714 4.95189e+006 and 586714 4.95189e+006, 586739 4.9519e+006
586714 4.95189e+006
Total query runtime: 859 ms.
1 row retrieved.
(returns blank record)
And just for fun
select st_isvalid(st_buffer(st_union(the_geom),0.1)) a from
base.current_assessment_parcel
TRUE
I guess my next step would be to try the snap to grid functions, but the first
query above should work, shouldn't it?
Any help appreciated. Thanks.
Lee
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20100913/fccdb074/attachment.html>
More information about the postgis-users
mailing list