[postgis-users] transform params

toni hernández toni at sigte.udg.edu
Mon Jan 19 07:49:43 PST 2009


I have a postgis table with the srid=23031.

If I overlay this table with a WMS on some sofware (gvSIG; ArcGIS), 
everything fits perfectly but when I transform the postgis table to 
23030 and try the overlay to the same WMS (configuring now the WMS to 
work with epsg=23030) the overlay does not fit anymore. There is a 
difference of 70 metres difference (give or take)

And whats more.. if I export my postgis table to a shp file and then use 
the shp file to transform the coordinates from ArcGIS (again from 23031 
to 23030) the overlay with the same WMS fits again.

So I guess postgis is not doing the transformation as I need.

I thinks I have to change some params in the spatial_ref_sys table but 
have no idea what these parameters are.

This is what the spatial_ref_sys for srid=23030 looks like:

srText field:

PROJCS["ED50 / UTM zone 

+proj=utm +zone=30 +ellps=intl +units=m +no_defs

 From ArcGIS I have this OUTPUT properties after the transformation:


Anyone can help?

thanks in advance.

More information about the postgis-users mailing list