[postgis-devel] bug in ST_DumpPoints with tinZ?

Rémi Cura remi.cura at gmail.com
Tue Apr 21 07:23:07 PDT 2015


Hey,
Looks like there is a bug in ST_DumpPoints function.
When dumping points from a geometry collection of 2 TINZ , I get only the
points from the first TINZ

Cheers,
Rémi-C

WITh the_geom AS (
SELECT ST_GeomFromText('
    GEOMETRYCOLLECTION Z (
    TIN Z (
    ((836.241149634773 897.300483196201 44.235890912421,836.301514870813
897.041404436852 44.1104526796975,836.017950228482 896.884733832257
43.9454852021886,836.241149634773 897.300483196201 44.235890912421))
    ,((835.975506914897 897.427922547385 44.231901206208,836.241149634773
897.300483196201 44.235890912421,836.017950228482 896.884733832257
43.9454852021886,835.975506914897 897.427922547385 44.231901206208))
    ,((836.591860570603 896.983802169256 44.159663511364,836.380792899112
896.56568049421 43.871332972056,836.301514870813 897.041404436852
44.1104526796975,836.591860570603 896.983802169256 44.159663511364))
    ,((836.380792899112 896.56568049421 43.871332972056,836.097517011938
896.608910488388 43.81619952029,836.150004759548 896.774504276466
43.9217307252124,836.380792899112 896.56568049421 43.871332972056))
    ,((836.017950228482 896.884733832257 43.9454852021886,835.45064342045
896.873195910527 43.781203211299,835.654709849234 897.25860253162
44.0496225866787,836.017950228482 896.884733832257 43.9454852021886))
    ,((836.301514870813 897.041404436852 44.1104526796975,836.150004759548
896.774504276466 43.9217307252124,836.017950228482 896.884733832257
43.9454852021886,836.301514870813 897.041404436852 44.1104526796975))
    ,((836.301514870813 897.041404436852 44.1104526796975,836.380792899112
896.56568049421 43.871332972056,836.150004759548 896.774504276466
43.9217307252124,836.301514870813 897.041404436852 44.1104526796975))
    ,((835.975506914897 897.427922547385 44.231901206208,836.017950228482
896.884733832257 43.9454852021886,835.654709849234 897.25860253162
44.0496225866787,835.975506914897 897.427922547385 44.231901206208)))
    ,TIN Z (((836.536976485104 896.821454836526
49.5327777663398,836.549588475402 896.827018373145
50.4900914338338,837.473971190125 896.797578118232
50.4948724829438,836.536976485104 896.821454836526 49.5327777663398))
    ,((837.464327730909 896.791698311544 49.5019932813068,836.536976485104
896.821454836526 49.5327777663398,837.473971190125 896.797578118232
50.4948724829438,837.464327730909 896.791698311544 49.5019932813068))))')
AS geom
    )
    SELECT dmp.path, dmpp.path, ST_AsText(dmpp.geom)
    FROM the_geom, ST_Dump(geom) as dmp, ST_DumpPoints(dmp.geom) as dmpp
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20150421/874d8b0d/attachment.html>


More information about the postgis-devel mailing list