[postgis-devel] [PostGIS] #1940: epsg:2065 projection is incorrect

[PostGIS]

#1940: epsg:2065 projection is incorrect
----------------------+-----------------------------------------------------
 Reporter:  fordfrog  |       Owner:  pramsey      
     Type:  defect    |      Status:  new          
 Priority:  medium    |   Milestone:  PostGIS 2.0.2
Component:  postgis   |     Version:  2.0.x        
 Keywords:            |  
----------------------+-----------------------------------------------------
 proj4text is not correct for this projection in spatial_ref_sys.

 here is what is returned with the installed projection:

 test=# select
 st_astext(st_transform(st_setsrid(st_geomfromtext('point(718346.93
 992772.22)'), 2065), 4326));
                 st_astext
 -----------------------------------------
  POINT(40.7273344172108 68.120719621313)
 (1 row)

 here is the update to the projection that fixes proj projection:

 test=# update spatial_ref_sys set proj4text = '+proj=krovak +lat_0=49.5
 +lon_0=42.5 +alpha=30.28813972222222 +k=0.9999 +x_0=-0 +y_0=-0
 +ellps=bessel +towgs84=570.8,85.7,462.8,4.998,1.587,5.261,3.56 +pm=ferro
 +to_meter=-1 +no_defs' where srid = 2065;
 UPDATE 1

 and here is the correct result:

 test=# select
 st_astext(st_transform(st_setsrid(st_geomfromtext('point(718346.93
 992772.22)'), 2065), 4326));
                 st_astext
 ------------------------------------------
  POINT(14.6666442538853 50.5646644202525)
 (1 row)

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/1940>
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.