[postgis-users] estimated extent and EPSG:5514

[Martin Landa]

Hi all,

I got strange estimated extent when working with data in S-JTSK
(EPSG:5514). ST_EstimatedExtent() returns completely wrong extent:

select st_estimated_extent('ruian', 'kraje', 'geom');
BOX(-909107.8125 -1233432.375,4522.92431640625 6136.4794921875)

The correct extent is:

select st_extent(geom) from ruian.kraje;
BOX(-904584.86 -1227295.83,-431726.85 -935236.59)

It's visible that East and North coordinates are completely wrong.
This is also probably reason why 'Zoom to layer' in QGIS do not work
properly.

Any idea? Thanks a lot! Martin

-- 
Martin Landa
http://geo.fsv.cvut.cz/gwiki/Landa
http://gismentors.cz/mentors/landa