<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Tahoma
}
--></style>
</head>
<body class='hmmessage'><div dir='ltr'>
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:
normal">Dear all,<o:p></o:p></p><p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:
normal"><br></p>
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:
normal">I have two questions to ask:<o:p></o:p></p><p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:
normal"><br></p>
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:
normal">Q1: I have a table that has one geometry column and I want to calculate
distance (in Km) between two geometries which is in one column. I am using
select query as under, and wanted to know if this is the right way of doing
distance calculation between two points. Since, both the points are in one
table but in different rows so I am using select statement to pick the geom from
each row.<o:p></o:p></p>
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:
normal"><o:p> </o:p></p>
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:
normal">select st_distance_sphere((select the_geom from table_name where
place_name='PL1'), (select the_geom from table_name where place_name='PL2'))/1000;<o:p></o:p></p>
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:
normal"><o:p> </o:p></p>
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:
normal"><o:p> </o:p></p>
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:
normal">Q2: I have a table that has columns distance, direction, place_name and
geometry (with SRID 4326) as under.<o:p></o:p></p>
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:
normal">Id<span style="mso-tab-count:1"> </span>distance<span style="mso-tab-count:1"> </span>direction<span style="mso-tab-count:
1"> </span>Place_name<span style="mso-tab-count:1"> <span class="Apple-tab-span" style="white-space:pre"> </span></span>geom<o:p></o:p></p>
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:
normal">1<span style="mso-tab-count:1"> </span>42 km<span style="mso-tab-count:2"> </span>E<span style="mso-tab-count:
2"> </span>PL1<span style="mso-tab-count:2"> </span>some
geometry<o:p></o:p></p>
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:
normal"><o:p> </o:p></p>
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:
normal">Now I want to calculate new geometry with reference to given geometry based
on some distance and direction. Such that new geometry is at “42km E of some
reference geometry”. Is there a function that can do this? Or if someone can
point me to a specific link..<o:p></o:p></p>
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:
normal"><o:p> </o:p></p>
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:
normal">Thanks,<o:p></o:p></p>
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:
normal">YJ<o:p></o:p></p> </div></body>
</html>