Spatial Users Forum

Problem with st_transform

Posted By: JORGE INFANTE
Date: Wednesday, 22 April 2009, at 10:54 p.m.

Hi, forum!

We are in Rosario, Argentina, working with coordinates transformation, from utm (meters) to geographic (lat, lon).
Working with the example in the online documentation (Example 2: Projecting data dynamically), we did generate new records for the tables spatial_ref_sys and spatial_references.
The steps:
a) Add a record for epsg-22185 (a new srid # 1202):
execute function se_createsrid(8223.64246705, 6335848.41072399,
5459374.50493382, 6380556.86838906, 'POSGAR 94 / Argentina 5');
b) Complete other fields:
update sde.spatial_ref_sys
set auth_name = 'EPSG', auth_srid = 22185, srtext =
'PROJCS["Gauss_Kruger_Faja5", GEOGCS["GCS_WGS_1984", DATUM["D_
WGS_1984",SPHEROID["WGS_1984",6378137,298.257223536]],
PRIMEM["Greenwich",0],UNIT["Degree",0.0174532925199433]],
PROJECTION["Transverse_Mercator"],PARAMETER["False_Easting",5500000.0],
PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-60.0],
PARAMETER["Scale_Factor",1.0],PARAMETER["Latitude_of_Origin",-90.0],
UNIT["Meter",1.0]]' where srid = 1202;
c) Create a new table for put data of Rosario:
create table mytable(se_row_id serial, the_geom st_geometry);
d) Add a record with values in meters:
insert into mytable(the_geom) values('1202 MULTIPOLYGON (((5439716.1698
6354410.48638, 5439717.07569 6354373.62259, 5439752.41517 6354363.09261,
5439773.35028 6354393.44852, 5439750.9494 6354422.73947, 5439716.1698 6354410.48638)))');
e) Try a transformation (meters to grades) of the record, from projection srid-1202 to srid-4 (epsg-4326, standard):
select st_transform(the_geom, 4) from mytable;

Here, we can see the error:
(USE46) - Incompatible coordinate reference systems in function ST_Transform.
The data in srtext fields are ok.
I'm thinking we have problems with others fields of the spatial_references table.

Can any help me?

TIA
jorge infante
dirección de catastro
municipalidad de rosario
rosario - santa fe - argentina

Messages In This Thread

• Problem with st_transform
  JORGE INFANTE -- Wednesday, 22 April 2009, at 10:54 p.m.
  • Re: Problem with st_transform
    ROBERT ULEMAN -- Friday, 24 April 2009, at 7:58 p.m.

Spatial Users Forum is maintained by Administrator with WebBBS 5.12.