[postgis-users] estimated extent and EPSG:5514

[Paul Ramsey]

What does _postgis_stats( 'ruian.kraje', 'geom') do?

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

> Hi,
>
> 2016-11-21 15:41 GMT+01:00 Paul Ramsey <pramsey at cleverelephant.ca>:
> > 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.
>
> I am afraid that this not this case. This data has been imported and
> not touched in DB. ANALYZE will not help.
>
> ANALYZE ruian.kraje ;
> select st_estimated_extent('ruian', 'kraje', 'geom');
>                        st_estimated_extent
> -----------------------------------------------------------------
>  BOX(-909107.8125 -1233432.375,4522.92431640625 6136.4794921875)
>
> 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/c8413f85/attachment.html>