<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:times new roman,new york,times,serif;font-size:12pt"><div>Bob --<br><br>I does in fact seem as if the postGIS site is having issues today ...<br><br>This is perhaps better directed at the mailing list(s) for the display tool you are using (Mapserver ? JUMP ? Other ?) as postGIS only provides data, not display capabilities.<br><br>You could try retrieving the X and Y coordinates and cast them to integers, something like:<br><br>X(point)::integer, Y(point)::integer ... cumbersome but it should trim off those decimal points.<br><br>HTH,<br><br>Greg Williamson<br></div><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;"><br><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;"><font face="Tahoma" size="2"><hr size="1"><b><span style="font-weight: bold;">From:</span></b> Bob Pawley
<rjpawley@shaw.ca><br><b><span style="font-weight: bold;">To:</span></b> PostGIS Users Discussion <postgis-users@postgis.refractions.net><br><b><span style="font-weight: bold;">Sent:</span></b> Sunday, May 3, 2009 2:10:03 PM<br><b><span style="font-weight: bold;">Subject:</span></b> [postgis-users] Blurred text<br></font><br>
<style></style>
<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></div></div></div><br>
</body></html>