[postgis-users] Blurred text

[Greg Williamson]

Bob --

I does in fact seem as if the postGIS site is having issues today ...

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.

You could try retrieving the X and Y coordinates and cast them to integers, something like:

X(point)::integer, Y(point)::integer ... cumbersome but it should trim off those decimal points.

HTH,

Greg Williamson




________________________________
From: Bob Pawley <rjpawley at shaw.ca>
To: PostGIS Users Discussion <postgis-users at postgis.refractions.net>
Sent: Sunday, May 3, 2009 2:10:03 PM
Subject: [postgis-users] Blurred text

 
Hi
 
My map has text some of which is 
blurred.
 
>From researching I think the blurring may be 
because the point reference for the text includes a decimal.
 
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.
 
For instance after a st_translate the point astext 
is Point(16616.6124472887 165000). 
 
Is it possiblle to make the return Point(16616(or 
7) 165000)?
 
Is the Postgis reflections site down?
 
Bob


      
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20090503/f6ad5a7d/attachment.html>