[postgis-users] estimated extent and EPSG:5514

[Paul Ramsey]

Estimated extent works by looking at the table stats. If you had some extra
data and then delete it, the stats might still reflect the original extent
of the full table. Re-running ANALYZE might refresh them.

On Mon, Nov 21, 2016 at 5:07 AM, Martin Landa <landa.martin at gmail.com>
wrote:

> 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
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20161121/6afa4b74/attachment.html>