epsg:2065 projection is incorrect

[fordfrog]

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)

[pramsey]

Fixed in 2.0 at r10602 and in trunk at r10601

[rouault]

Paul, how do you track local changes in spatial_ref_sys with respect to the update process described in ​http://svn.osgeo.org/metacrs/geotiff/trunk/libgeotiff/csv/README ? There's a risk it get lost at the next update.

Ok, for the sake of completness, this issue is also reported as ​http://trac.osgeo.org/proj/ticket/185 and ​http://trac.osgeo.org/gdal/ticket/4762