Re: [postgis-users] ST_Translate

[Bob Pawley]

Hi Regina

Following is the query I am using.

The shapefile is also attached if any one wants to try it.

The shape was converted from a DXF file with the default SRID.

Bob
insert into entity (the_geom, position)
select
st_translate (public.process.the_geom,
st_x (st_centroid(spatial_ref.the_geom)) -
st_x (st_centroid (public.process.the_geom)),
st_y (st_centroid(spatial_ref.the_geom))-
st_y (st_centroid (public.process.the_geom))), ('i')
from  spatial_ref,  process
where spatial_ref.position_ = '1' ;






To: "'PostGIS Users Discussion'" <postgis-users@postgis.refractions.net>
Sent: Wednesday, July 09, 2008 12:11 AM
Subject: RE: [postgis-users] ST_Translate

----- Original Message ----- From: "Paragon Corporation" <[EMAIL PROTECTED]>

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.


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

When I collect the six rows by using ST_Union, then translate the single row http://postgis.refractions.net/mailman/listinfo/postgis-users

ButterFly Valve.shx
Description: Binary data

ButterFly Valve.dbf
Description: Binary data

ButterFly Valve.shp
Description: application/shapefile

_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users