[postgis-devel] [PostGIS] #1676: Problem in converting from RT90(SRID=3021) to WGS84(SRID=4326)

PostGIS trac at osgeo.org
Sat Mar 10 04:49:50 PST 2012


#1676: Problem in converting from RT90(SRID=3021) to WGS84(SRID=4326)
------------------------+---------------------------------------------------
 Reporter:  arashamiri  |       Owner:  pramsey      
     Type:  defect      |      Status:  new          
 Priority:  high        |   Milestone:  PostGIS 1.4.3
Component:  postgis     |     Version:  1.5.X        
 Keywords:              |  
------------------------+---------------------------------------------------
 I try with two different versions of postgreSQL and postGIS.
 With the same SQL.

 I want to convert coordinates in RT90(SRID=3021) to WGS84(SRID=4326)

 Select * From ST_X(ST_Transform(ST_SetSRID(ST_Point(1335932, 6177809),
 3021), 4326)) as long, ST_Y(ST_Transform(ST_SetSRID(ST_Point(1335932,
 6177809), 3021), 4326)) as lat

 First: PostgresSQL versione 8.4  , postgis-1.4.2
 Result:
 Long: 13.198086050257
 Lat: 55.7017960558017


 Second: PostgresSQL versione 9.1  , postgis-1.5.3
 Result:
 Long:  13.1954101954645
 Lat:  55.7017121131652

 The first seems wrong. The results are actually the lat,long in the
 RT_1990(SRID=4124).

 The second seems correct and the results are in WGS84(SRID=4326) which
 they should be.

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/1676>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.


More information about the postgis-devel mailing list