[postgis-users] How to get the centroid of an bounding box using st_extent

[Charlie Savage]

And example of this patch in use:

select asText(makebox2d('POINT(1.1111 2.22222)'::geometry, 'POINT(1.1111 
  2.22222)'::geometry)),
        asText(makebox2d('POINT(1.1111 2.22222)'::geometry, 
'POINT(1.1111  2.222222)'::geometry)),
        asText(makebox2d('POINT(1.1111 2.22222)'::geometry, 
'POINT(1.11111 2.222222)'::geometry)),

        asText(box3d(makebox2d('POINT(1.1111 2.22222)'::geometry, 
'POINT(1.1111  2.22222)'::geometry))),
        asText(box3d(makebox2d('POINT(1.1111 2.22222)'::geometry, 
'POINT(1.1111  2.222222)'::geometry))),
        asText(box3d(makebox2d('POINT(1.1111 2.22222)'::geometry, 
'POINT(1.11111 2.222222)'::geometry)))


"POINT(1.1110999584198 2.22221994400024)";

"LINESTRING(1.1110999584198 2.22221994400024,1.1110999584198 
2.22222208976746)";

"POLYGON((1.1110999584198 2.22221994400024,1.1110999584198 
2.22222208976746,1.11110997200012 2.22222208976746,1.11110997200012 
2.22221994400024,1.1110999584198 2.22221994400024))";

"POINT(1.1110999584198 2.22221994400024)";

"LINESTRING(1.1110999584198 2.22221994400024,1.1110999584198 
2.22222208976746)";

"POLYGON((1.1110999584198 2.22221994400024,1.1110999584198 
2.22222208976746,1.11110997200012 2.22222208976746,1.11110997200012 
2.22221994400024,1.1110999584198 2.22221994400024))"


Charlie
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/x-pkcs7-signature
Size: 3237 bytes
Desc: S/MIME Cryptographic Signature
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20070921/98762afe/attachment.bin>