[postgis-users] St_Expands

[Paragon Corporation]

Paul,
Since you are just dealing with a point geometry, take a look at
ST_MakeBox3D
 
http://www.postgis.org/documentation/manual-1.5SVN/ST_MakeBox3D.html
 
and ST_Translate
http://www.postgis.org/documentation/manual-1.5SVN/ST_Translate.html
<http://www.postgis.org/documentation/manual-1.5SVN/ST_MakeEnvelope.html> 
 
So the box would be
 
SELECT ST_MakeBox3D(ST_Translate(point_geom, -10,-8,-6),
ST_Translate(point_geom, 10, 8, 6))
 
Leo and Regina
http://www.postgis.us
 

  _____  

From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Paul &
Caroline Lewis
Sent: Friday, June 04, 2010 9:46 AM
To: postgis-users at postgis.refractions.net
Subject: [postgis-users] St_Expands


Hi All,
    I need to generate a bounding box geometry around a point and St_Expands
seem to be heading in the right direction. However, I need to create it to
different dimensions in each axis. Currently, as I understand it
ST_Expands(point_geom, 10) will return me a bounding box extended 10
geometry units in the x, y and z axis. I would like to be able to do
ST_Expands(point_geom, 10, 8, 6) where it extends 10 units in X, 8 in Y and
6 in Z. Can anyone recommend how this might be done with the current PostGIS
1.5 functions toolset, I cannot thing of one at present, otherwise can
anyone point me in the right direction to a tutorial on how I might extend
this function from scratch in the current source code and re-compile it
locally.
 
Thanks in advance,
 
Paul


  _____  

Hotmail: Free, trusted and rich email service. Get it now.
<https://signup.live.com/signup.aspx?id=60969>  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20100604/ebfd5f7a/attachment.html>