<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<STYLE>.hmmessage P {
PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-TOP: 0px
}
BODY.hmmessage {
FONT-SIZE: 10pt; FONT-FAMILY: Tahoma
}
</STYLE>
<META content="MSHTML 6.00.6000.16481" name=GENERATOR></HEAD>
<BODY class=hmmessage>
<DIV dir=ltr align=left><SPAN class=753383012-18092008>
<DIV dir=ltr align=left><SPAN class=940132812-18092008><FONT face=Arial
color=#0000ff><SPAN class=753383012-18092008>Eehab,</SPAN></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=940132812-18092008><FONT face=Arial
color=#0000ff><SPAN class=753383012-18092008></SPAN></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=940132812-18092008><FONT face=Arial
color=#0000ff>If you are just dealing with point geometries and you care about
just <SPAN class=753383012-18092008>3d </SPAN>distance rather than
representation, then , use ST_Length3D. There is <SPAN
class=753383012-18092008>n</SPAN>o distance 3d, but there is a length
3d.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=940132812-18092008><FONT face=Arial
color=#0000ff></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=940132812-18092008><FONT face=Arial><FONT
color=#0000ff>Although I think I answered this question before so maybe there
was something wrong with my answer.<SPAN class=753383012-18092008> It
would be helpful to know what was wrong with the answer. I admit I didn't really
try it.</SPAN></FONT></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=940132812-18092008><FONT face=Arial><FONT
color=#0000ff><SPAN
class=753383012-18092008></SPAN></FONT></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=940132812-18092008><FONT face=Arial><FONT
color=#0000ff><SPAN class=753383012-18092008>Also shouldn't your visual result
be a sphere rather than a cylinder? Where is your cylinder coming
from?</SPAN></FONT></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=940132812-18092008><FONT face=Arial><FONT
color=#0000ff><SPAN
class=753383012-18092008></SPAN></FONT></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=940132812-18092008><FONT face=Arial><FONT
color=#0000ff><SPAN class=753383012-18092008>Anyrate here is my answer
again</SPAN></FONT></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=940132812-18092008><FONT face=Arial><FONT
color=#0000ff><SPAN
class=753383012-18092008></SPAN></FONT></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=940132812-18092008><FONT face=Arial><FONT
color=#0000ff><SPAN class=753383012-18092008>In this case, I'm going to assume p
is ST_MakePoint(1,2,3) and your 3d limiting distance is
10</SPAN></FONT></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=940132812-18092008><FONT face=Arial><FONT
color=#0000ff><SPAN
class=753383012-18092008></SPAN></FONT></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=940132812-18092008><FONT face=Arial><FONT
color=#0000ff><SPAN class=753383012-18092008>SELECT gid,
the_geom</SPAN></FONT></FONT></SPAN></DIV></SPAN></DIV>
<DIV><SPAN class=753383012-18092008></SPAN><FONT face=Arial><FONT
color=#0000ff>FROM sometable<SPAN class=753383012-18092008>, (SELECT
ST_MakePoint(1,2,3) As the_geom) As p</SPAN></FONT></FONT></DIV>
<DIV><SPAN class=753383012-18092008></SPAN><SPAN
class=753383012-18092008></SPAN><FONT face=Arial><FONT color=#0000ff>W<SPAN
class=753383012-18092008>HERE ST_DWithin(sometable.the_geom, p.the_geom,
10)</SPAN></FONT></FONT></DIV>
<DIV><FONT><FONT color=#0000ff><SPAN
class=753383012-18092008></SPAN></FONT></FONT><SPAN
class=753383012-18092008></SPAN><FONT face=Arial><FONT color=#0000ff>A<SPAN
class=753383012-18092008>ND ST_Length3D(ST_MakeLine(sometable.the_geom,
p.the_geom)) < 10</SPAN></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><SPAN
class=753383012-18092008></SPAN></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><SPAN class=753383012-18092008>(The
ST_DWithin even though its a 2d check, will be useful because it will use
indexes and any 3D check would have to pass the 2D
check)</SPAN></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><SPAN
class=753383012-18092008></SPAN></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><SPAN
class=753383012-18092008>Thanks,</SPAN></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><SPAN
class=753383012-18092008>Regina</SPAN></FONT></FONT></DIV>
<DIV><BR></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr 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>eehab
hamzeh<BR><B>Sent:</B> Thursday, September 18, 2008 5:41 AM<BR><B>To:</B> Kevin
Neufeld; PostGIS Users Discussion<BR><B>Subject:</B> RE: [postgis-users] make
the buffer in 3d<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV style="TEXT-ALIGN: left">Kevin, <BR><BR>Thank you, i need to:<BR><BR>1)
create buffer in 3d. I mean the resulted buffer should have z value.<BR>the z
value will be equal to the radius value.<BR><BR></DIV>2) select all features
that are intersect this cylinder, or inside this cylinder.<BR><BR>Thanks
<BR><BR><BR><BR><BR>
<HR>
Get news, entertainment and everything you care about at Live.com. <A
href="http://www.live.com/getstarted.aspx " target=_new>Check it out!</A>
</BODY></HTML>
<HTML><BODY><P><hr size=1></P>
<P><STRONG>
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.
</STRONG></P></BODY></HTML>
<P><hr size=1></P>
<P><STRONG><font size="2" color="339900"> Help make the earth a greener place. If at all possible resist printing this email and join us in saving paper. </p> <p> </font></STRONG></P>