<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=us-ascii" http-equiv=Content-Type>
<STYLE>.hmmessage P {
PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-LEFT: 0px; PADDING-RIGHT: 0px; PADDING-TOP: 0px
}
BODY.hmmessage {
FONT-FAMILY: Verdana; FONT-SIZE: 10pt
}
</STYLE>
<META name=GENERATOR content="MSHTML 8.00.7600.16535"></HEAD>
<BODY class=hmmessage>
<DIV dir=ltr align=left><SPAN class=438052700-05062010><FONT color=#0000ff
face=Arial>Paul,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=438052700-05062010><FONT color=#0000ff
face=Arial>Since you are just dealing with a point geometry, take a look at
ST_MakeBox3D</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=438052700-05062010><FONT color=#0000ff
face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=438052700-05062010><FONT color=#0000ff
face=Arial><A
href="http://www.postgis.org/documentation/manual-1.5SVN/ST_MakeBox3D.html">http://www.postgis.org/documentation/manual-1.5SVN/ST_MakeBox3D.html</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=438052700-05062010><FONT color=#0000ff
face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=438052700-05062010><FONT color=#0000ff
face=Arial>and ST_Translate</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=438052700-05062010><FONT color=#0000ff
face=Arial><A
href="http://www.postgis.org/documentation/manual-1.5SVN/ST_Translate.html">http://www.postgis.org/documentation/manual-1.5SVN/ST_Translate.html</A><A
href="http://www.postgis.org/documentation/manual-1.5SVN/ST_MakeEnvelope.html"></A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=438052700-05062010><FONT color=#0000ff
face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=438052700-05062010><FONT color=#0000ff
face=Arial>So the box would be</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=438052700-05062010><FONT color=#0000ff
face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=438052700-05062010><FONT color=#0000ff
face=Arial>SELECT ST_MakeBox3D(ST_Translate(point_geom, -10,-8,-6),
ST_Translate(point_geom, 10, 8, 6))</FONT></SPAN></DIV>
<DIV><SPAN class=438052700-05062010><FONT color=#0000ff
face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=438052700-05062010><FONT color=#0000ff face=Arial>Leo and
Regina</FONT></SPAN></DIV>
<DIV><SPAN class=438052700-05062010><FONT color=#0000ff face=Arial><A
href="http://www.postgis.us">http://www.postgis.us</A></FONT></SPAN></DIV>
<DIV><SPAN class=438052700-05062010></SPAN> </DIV>
<DIV dir=ltr align=left><BR></DIV>
<DIV dir=ltr lang=en-us class=OutlookMessageHeader align=left>
<HR tabIndex=-1>
<FONT face=Tahoma><B>From:</B> postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of </B>Paul
& Caroline Lewis<BR><B>Sent:</B> Friday, June 04, 2010 9:46 AM<BR><B>To:</B>
postgis-users@postgis.refractions.net<BR><B>Subject:</B> [postgis-users]
St_Expands<BR></FONT><BR></DIV>
<DIV></DIV>Hi All,<BR> 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.<BR> <BR>Thanks in advance,<BR> <BR>Paul<BR><BR>
<HR>
Hotmail: Free, trusted and rich email service. <A
href="https://signup.live.com/signup.aspx?id=60969" target=_new>Get it now.</A>
</BODY></HTML>