[postgis-tickets] [PostGIS] #4158: ST_Subdivide unable to subdivide isochrone
PostGIS
trac at osgeo.org
Sun Aug 26 11:58:44 PDT 2018
#4158: ST_Subdivide unable to subdivide isochrone
----------------------+---------------------------
Reporter: komzpa | Owner: pramsey
Type: defect | Status: new
Priority: medium | Milestone: PostGIS 2.5.0
Component: postgis | Version: 2.4.x
Resolution: | Keywords:
----------------------+---------------------------
Comment (by komzpa):
Issue is that POLYGON Z cannot be subdivided. If we clamp it to 2D it
works:
{{{
21:18:59 [kom] > update eventspace_isochrones set geom = ST_Force2D(geom);
UPDATE 31
Time: 551,953 ms
21:20:26 [kom] > with complex_areas_to_subdivide as (delete from
eventspace_isochrones
where ST_NPoints(geom) > 255
returning minute, geom)
insert into eventspace_isochrones (minute, geom)
select minute,
ST_Subdivide(geom, 255) geom
from complex_areas_to_subdivide;
INSERT 0 9304
Time: 9014,916 ms (00:09,015)
}}}
--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/4158#comment:1>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.
More information about the postgis-tickets
mailing list