<html style="direction: ltr;">
<head>
<meta content="text/html; charset=windows-1255"
http-equiv="Content-Type">
<style>body p { margin-bottom: 0cm; margin-top: 0pt; } </style>
</head>
<body style="direction: ltr;"
bidimailui-detected-decoding-type="preferred-charset"
bgcolor="#FFFFFF" text="#660000">
Can you be more specific as to what you mean by "two sets of
points". How do you determine, for each point in the table, which
other point you need the distance to?<br>
(I'm smelling a spatialite query here :-) )<br>
<br>
Also, distances in WGS84 will be in degrees. Perhaps a projection to
some flat CRS is in order? <br>
<br>
On 21/05/2012 11:25, M.E.Dodd wrote:
<blockquote
cite="mid:9932A16F9CE9264FAC3F2E0E008E1221013DD0D56D@KIELDERCMS1.open.ac.uk"
type="cite">
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1255">
<meta name="Generator" content="Microsoft Exchange Server">
<!-- converted from rtf -->
<style><!-- .EmailQuote { margin-left: 1pt; padding-left: 4pt; border-left: #800000 2px solid; } --></style>
<font face="Arial, sans-serif" size="2">
<div>Very simple question, how to add a column to a table
showing the distance between two sets of points in the table
(they are both in lat long wgs84 coordinates). There are
quite a number of calculations that can be done on a column
but distance does not
seem to be one of them. There are plugins that calculate
distance but they tend to do it between other types of object
or distance between all points not just the pairs as arranged
in the table.</div>
<div><font face="Calibri, sans-serif" size="2"> </font></div>
<div>Dr Mike Dodd</div>
<div>Department of Environment, Earth and Ecosystems</div>
<div>The Open University<br>
Walton Hall<br>
Milton Keynes<br>
MK7 6AA</div>
<div> </div>
<div><font face="Calibri, sans-serif" size="2"><a
moz-do-not-send="true" href="http://www.ispot.org.uk/"><font
color="#0000FF" face="Arial, sans-serif" size="2"><u>http://www.ispot.org.uk/</u></font></a></font></div>
<div><font face="Calibri, sans-serif" size="2"><a
moz-do-not-send="true"
href="http://www.floodplainmeadows.org.uk/"><font
color="#0000FF" face="Arial, sans-serif" size="2"><u>http://www.floodplainmeadows.org.uk/</u></font></a></font></div>
<div><a moz-do-not-send="true"
href="http://www.amanita-photolibrary.co.uk/HTML_Trees/">http://www.amanita-photolibrary.co.uk/HTML_Trees/</a></div>
<div> </div>
<div><font face="Calibri, sans-serif" size="2"> </font></div>
<div><font face="Calibri, sans-serif" size="2"> </font></div>
<div><font face="Calibri, sans-serif" size="2"> </font></div>
<div><font face="Calibri, sans-serif" size="2"> </font></div>
<div><font face="Calibri, sans-serif" size="2"> </font></div>
</font>
<p><br>
-- <br>
The Open University is incorporated by Royal Charter (RC
000391), an exempt charity in England & Wales and a charity
registered in Scotland (SC 038302).</p>
<br>
<br>
This mail was received via Mail-SeCure System.<br>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Qgis-user mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/qgis-user">http://lists.osgeo.org/mailman/listinfo/qgis-user</a>
This mail was received via Mail-SeCure System.
</pre>
</blockquote>
<p><br>
</p>
<br>
<pre class="moz-signature" cols="72">--
Micha Silver
052-3665918
</pre>
</body>
</html>