<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.6001.18226" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV dir=ltr align=left><SPAN class=890252522-03052009><FONT face=Arial
color=#0000ff size=2>Bob,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=890252522-03052009><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=890252522-03052009><FONT face=Arial
color=#0000ff size=2>hmm yes the Refractions site does seem to be down.
</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=890252522-03052009><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=890252522-03052009><FONT face=Arial
color=#0000ff size=2>Regarding your below. Try ST_SnaptoGrid.
So something like</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=890252522-03052009><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=890252522-03052009><FONT face=Arial
color=#0000ff size=2>SELECT ST_AsText(ST_SnaptoGrid('POINT(16616.6124472887
165000)', 1))</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=890252522-03052009><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=890252522-03052009><FONT face=Arial
color=#0000ff size=2>gives you </FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=890252522-03052009><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=890252522-03052009><FONT face=Arial
color=#0000ff size=2>POINT(16617 165000)</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=890252522-03052009><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=890252522-03052009><FONT face=Arial
color=#0000ff size=2>Leo</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=890252522-03052009><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=890252522-03052009><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of </B>Bob
Pawley<BR><B>Sent:</B> Sunday, May 03, 2009 6:10 PM<BR><B>To:</B> PostGIS Users
Discussion<BR><B>Subject:</B> [postgis-users] Blurred text<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV><FONT face=Arial size=2>Hi</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>My map has text some of which is
blurred.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>From researching I think the blurring may be
because the point reference for the text includes a decimal.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I wouild like to test my theory but I haven't been
able to discover how to either round off or truncate the decimal to a whole
number.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>For instance after a st_translate the point astext
is Point(16616.6124472887 165000). </FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Is it possiblle to make the return Point(16616(or
7) 165000)?</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Is the Postgis reflections site down?</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Bob</FONT></DIV></BODY></HTML>