[postgis-users] why isn't st_translate working for points and polysin same dataset?

[Michael Smedberg]

I think you need to set the SRID for the point you made, something like:

insert into stands
select
        tmp_stands.gid as id,
        tmp_stands.strata as strata,
        tmp_stands.initage as initage,
st_translate( tmp_stands.boundary, 500000, 5900000,0) as boundary,
st_translate( ST_SetSRID(ST_MakePoint( tmp_stands.landx,
tmp_stands.landy), 32755), 500000, 5900000 )  as location from
tmp_stands;


I didn't actually try it, so my apologies if this guess is wrong...

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Jeff
Hamann
Sent: Friday, January 30, 2009 10:59 AM
To: postgis-users at postgis.refractions.net
Subject: [postgis-users] why isn't st_translate working for points and
polysin same dataset?

I'm sure I must be doing something foolish, but I've hammered on this
for an hour or so, and can't seem to get this to complete. I'm trying to
translate a small dataset from a simple set of points and polygons:

                            Table "public.stands"
   Column  |   Type   |                      Modifiers
----------+----------+--------------------------------------------------
----------+----------+---
  id       | integer  | not null default
nextval('stands_id_seq'::regclass)
  strata   | integer  | not null
  initage  | integer  |
  boundary | geometry |
  location | geometry |
Indexes:
     "stands_pkey" PRIMARY KEY, btree (id)
     "stands_boundary_gist" gist (boundary)
     "stands_location_gist" gist (location) Check constraints:
     "enforce_dims_boundary" CHECK (ndims(boundary) = 2)
     "enforce_dims_location" CHECK (ndims(location) = 2)
     "enforce_geotype_boundary" CHECK (geometrytype(boundary) =
'MULTIPOLYGON'::text OR boundary IS NULL)
     "enforce_geotype_location" CHECK (geometrytype(location) =
'POINT'::text OR location IS NULL)
     "enforce_srid_boundary" CHECK (srid(boundary) = 32755)
     "enforce_srid_location" CHECK (srid(location) = 32755)

and when I try to populate the location field using the ST_MakePoint()
function, I seem to always get the same result:

delete from stands;
insert into stands
select
        tmp_stands.gid as id,
        tmp_stands.strata as strata,
        tmp_stands.initage as initage,
st_translate( tmp_stands.boundary, 500000, 5900000,0) as boundary,
st_translate( ST_MakePoint( tmp_stands.landx, tmp_stands.landy), 500000,
5900000 )  as location from tmp_stands;

ERROR:  new row for relation "stands" violates check constraint
"enforce_srid_location"

which I don't understand because when I remove the
st_translate(st_makepoint()) command, the boundary translated just fine.

In fact, I can't go back and update the locations no matter what values
I use. If the points (which are in the middle of the polygons) violate
the check constraints, then why do the boundaries translate just fine?

Jeff Hamann, PhD
Forest Informatics