search

NLeSC / 3D_geospatial_risk_management

2 stars 0 forks source link

ST_Extrude giving incorrect output #58

Closed tomvantilburg closed 8 years ago

tomvantilburg commented 8 years ago

Query:

SELECT ST_AsText(ST_Extrude(St_GeometryFromText('POLYGON Z ((93779.45299999999 463764.217 3.733, 93785.962 463765.618 3.466, 93769.401 463766.159 3.491, 93779.45299999999 463764.217 3.733))'),0,0,10));

Incorrect result from MonetDB:

 "GEOMETRYCOLLECTION Z (POLYGON Z ((93779.45299999999 463764.217 3.733, 93769.401 463766.159 3.491, 93785.962 463765.618 3.466, 93779.45299999999 463764.217 3.733)), POLYGON Z ((93779.45299999999 463764.217 13.733, 93785.962 463765.618 13.466, 93769.401 463766.159 13.491, 93779.45299999999 463764.217 13.733)), POLYGON Z ((93779.45299999999 463764.217 3.733, 93779.45299999999 463764.217 13.733, 93769.401 463766.159 13.491, 93769.401 463766.159 3.491, 93779.45299999999 463764.217 3.733)), POLYGON Z ((93769.401 463766.159 3.491, 93769.401 463766.159 13.491, 93785.962 463765.618 13.466, 93785.962 463765.618 3.466, 93769.401 463766.159 3.491)), POLYGON Z ((93785.962 463765.618 3.466, 93785.962 463765.618 13.466, 93779.45299999999 463764.217 13.733, 93779.45299999999 463764.217 3.733, 93785.962 463765.618 3.466)))"

Correct result from Postgis:

POLYHEDRALSURFACE Z (((93779.453 463764.217 3.733,93769.401 463766.159 3.491,93785.962 463765.618 3.466,93779.453 463764.217 3.733)),((93779.453 463764.217 13.733,93785.962 463765.618 13.466,93769.401 463766.159 13.491,93779.453 463764.217 13.733)),((93779.453 463764.217 3.733,93779.453 463764.217 13.733,93769.401 463766.159 13.491,93769.401 463766.159 3.491,93779.453 463764.217 3.733)),((93769.401 463766.159 3.491,93769.401 463766.159 13.491,93785.962 463765.618 13.466,93785.962 463765.618 3.466,93769.401 463766.159 3.491)),((93785.962 463765.618 3.466,93785.962 463765.618 13.466,93779.453 463764.217 13.733,93779.453 463764.217 3.733,93785.962 463765.618 3.466)))
romulogoncalves commented 8 years ago

Fixed:

Changeset: 1a2ec665763f for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=1a2ec665763f