[postgis-users] estimated extent and EPSG:5514

Martin Landa landa.martin at gmail.com
Mon Nov 21 06:49:10 PST 2016


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


More information about the postgis-users mailing list