<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=us-ascii" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.7601.17537"></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=078360708-07032011><FONT color=#0000ff
size=2 face=Arial>Use ST_DWithin instead. <A
href="http://www.postgis.org/documentation/manual-1.5SVN/ST_DWithin.html">http://www.postgis.org/documentation/manual-1.5SVN/ST_DWithin.html</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=078360708-07032011><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=078360708-07032011><FONT color=#0000ff
size=2 face=Arial>We cover this topic in detail in the first chapter of our book
which is a free download.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=078360708-07032011><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=078360708-07032011><FONT color=#0000ff
size=2 face=Arial><A
href="http://www.postgis.us/chapter_01">http://www.postgis.us/chapter_01</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=078360708-07032011><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=078360708-07032011><FONT color=#0000ff
size=2 face=Arial>Leo and Regina</FONT></SPAN></DIV><BR>
<DIV dir=ltr lang=en-us class=OutlookMessageHeader align=left>
<HR tabIndex=-1>
<FONT size=2 face=Tahoma><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of
</B>michal nagy<BR><B>Sent:</B> Monday, March 07, 2011 2:29 AM<BR><B>To:</B>
postgis-users@postgis.refractions.net<BR><B>Subject:</B> [postgis-users] meters
to degrees<BR></FONT><BR></DIV>
<DIV></DIV><FONT class=Apple-style-span size=3><SPAN
style="-webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px"
class=Apple-style-span><BR></SPAN></FONT>
<TABLE cellSpacing=0 cellPadding=3>
<TBODY>
<TR>
<TD></TD></TR></TBODY></TABLE><FONT class=Apple-style-span size=4><TT><FONT
color=#1a1a1a>Hello everyone,</FONT></TT><BR><BR><TT><FONT color=#1a1a1a>I am
new to Postgres and PostGIS. I have encountered one problem, that
I</FONT></TT><BR><TT><FONT color=#1a1a1a>can not deal with.I have table with
various points that have SRID=3044,</FONT></TT><BR><TT><FONT color=#1a1a1a>which
should be UTM zone including Jutland. I have created function
to</FONT></TT><BR><TT><FONT color=#1a1a1a>loop through all points in table and
check if they are within given</FONT></TT><BR><TT><FONT
color=#1a1a1a>radius(using geometry and function st_point_inside_circle). Now to
the</FONT></TT><BR><TT><FONT color=#1a1a1a>problem, for some reason
st_point_inside_circle takes radius in degrees,</FONT></TT><BR><TT><FONT
color=#1a1a1a>which is very inconvenient for me. I would really need to
change to</FONT></TT><BR><TT><FONT color=#1a1a1a>metres. If anyone has a
suggestion, pls let me know.</FONT></TT><BR><BR><TT><FONT color=#1a1a1a>Thank
you for help</FONT></TT><BR><BR><TT><FONT
color=#1a1a1a>Michal</FONT></TT></FONT> </BODY></HTML>