[postgis-devel] Why is ST_Buffer returning Z -- more smurf code

Obe, Regina robe.dnd at cityofboston.gov
Wed Feb 4 07:18:59 PST 2009


Am I dreaming?  I was scanning the results of my torture test and
noticed this

	SELECT 'ST_MinimumBoundingCircle PolygonSet3D: Start Testing
POLYGON'; 
	BEGIN; 
	SELECT ST_AsEWKT(ST_MinimumBoundingCircle(foo1.the_geom,3))
			  
			FROM ((SELECT
ST_SetSRID(ST_MakePolygon(ST_AddPoint(ST_AddPoint(ST_MakeLine(ST_MakePoi
nt(i+m,j,m),ST_MakePoint(j+m,i-m,m)),ST_MakePoint(i,j,m)),ST_MakePointM(
i+m,j,m))),4326)  As the_geom 
		FROM generate_series(-10,50,20) As i 
			CROSS JOIN generate_series(50,70, 20) As j
			CROSS JOIN generate_series(1,2) As m)) As foo1;

	COMMIT;
	SELECT 'ST_MinimumBoundingCircle PolygonSet3D: End Testing
POLYGON';

The first record returns this
"SRID=4326;POLYGON((63.6335136523794 19.5 1,57.8547185774435
-2.06675682618968 1.7e-308,42.0667568261897 -17.8547185774434
1.7e-308,20.5000000000001 -23.6335136523794 1.7e-308,-1.06675682618963
-17.8547185774435 1.7e-308,-16.8547185774434 -2.0667568261898
1.7e-308,-22.6335136523794 19.4999999999999 1.7e-308,-16.8547185774435
41.0667568261896 1.7e-308,-1.06675682618985 56.8547185774434
1.7e-308,20.4999999999998 62.6335136523794 1.7e-308,42.0667568261895
56.8547185774436 1.7e-308,57.8547185774433 41.0667568261899
1.7e-308,63.6335136523794 19.5 1))"

Am I dreaming or do I see a Z index there.
MinimumBoundingCircle as its last call -- buffers the point it
determined to be the centroid.

Then I looked at the results of ST_Buffer and yes indeed when buffering
a 3d point it does
return 2.5 d circle or whatever.  Is this useful?
-----------------------------------------
The substance of this message, including any attachments, may be
confidential, legally privileged and/or exempt from disclosure
pursuant to Massachusetts law. It is intended
solely for the addressee. If you received this in error, please
contact the sender and delete the material from any computer.



More information about the postgis-devel mailing list