[postgis-users] Moving point grid

[Maik Trömel]

Hello again,

I'm trying to run the following command:
nsumm=# UPDATE geom_pgsql_summe SET 
the_geom=transform(translate(transform (SetSRID(the_geom, 4326), 32632), 
13000, 13000), 4326);
ERROR:  new row for relation "geom_pgsql_summe" violates check 
constraint "enforce_srid_the_geom"
nsumm=#

I don't understand whats wrong.

Thanks for your help

Greetings
Maik

Guido Lemoine wrote:

> transform your points to a UTM projection (e.g. SRID=32632 for UTM 
> Zone 32 N,
> hopefully, they're all in one zone), then translate -13000, -13000 and 
> transform back
> to SRID=4326.
>
> select astext(transform(translate(transform(SetSRID(Makepoint(9.0, 
> 45.0), 4326), 32632), -13000, -13000), 4326));
>
> yields POINT(8.83539247380864 44.88285511722)
>
> GL
>
> Maik Trömel wrote:
>
>> Hi,
>>
>> i want to translate a dataset with a point grid 13 km into the west 
>> and 13 km into the south. The problem is that the points coordinates 
>> are in lat/lon. How can I move them in km?
>>
>> Thanks fpr your help!
>>
>> Greetings
>> Maik
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>