Bob, Doesn't quite make sense to me why translating before ST_Union would cause distortion if you are translating all the same amount.
What is the SRID of the data you are translating and what does your translate query and union query look like? Thanks, Regina -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Pawley Sent: Tuesday, July 08, 2008 5:30 PM To: PostGIS Users Discussion Subject: [postgis-users] ST_Translate I've imported a shapefile that requires six rows in the table. When I translate that shape, of six rows, to another location the shape becomes distorted. When I collect the six rows by using ST_Union, then translate the single row to the new position, there is no distortion. Is there a method of using ST_Translate, without also using ST_Union, and still avoid the distortion of the shape?? I need the geometries of the shape separate to be able to identify the parts of the shape I need. I seem to lose this informaion when I employ ST_Union. Bob _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users