[postgis-devel] Issue 103 in postgis: Box3D always gets cast to 2D geometry

codesite-noreply at google.com codesite-noreply at google.com
Sun Jan 25 07:24:57 PST 2009


Status: New
Owner: robe.... at cityofboston.gov
Labels: Priority-Low

New issue 103 by robe.... at cityofboston.gov: Box3D always gets cast to 2D  
geometry
http://code.google.com/p/postgis/issues/detail?id=103

Actually not sure if this is solvable.  But ST_SetSRID, ST_Force_3DZ all
lose the Z coordinate value of a BOX3D.

Example:

SELECT ST_AsEWKT(ST_Force_3DZ(ST_Extent3D(foo.the_geom))) As b3extentpoly,
ST_Extent3D(foo.the_geom) As b3extent
FROM (SELECT ST_MakePoint(x,y,z) As the_geom
	FROM generate_series(1,3) As x
		CROSS JOIN generate_series(1,2) As y
		CROSS JOIN generate_series(0,2) As Z) As foo;

Yields:
b3extentpoly                                 b3extent
POLYGON((1 1 0,1 2 0,3 2 0,3 1 0,1 1 0)) ;BOX3D(1 1 0,3 2 2)

I would expect the POLYGON value to have some 2 z coords in there.



--
You received this message because you are listed in the owner
or CC fields of this issue, or because you starred this issue.
You may adjust your issue notification preferences at:
http://code.google.com/hosting/settings



More information about the postgis-devel mailing list