[postgis-users] update_geometry_stats() on PostGIS 0.8.1

[Markus Schaber]

Hi, all,

Markus Schaber schrieb:

>>It is surely updatable.
>>Get the one you have in 1.0.0.
>>Of course you'll have to build lwpostgis.sql with USE_VERSION=<your_pg_ver>.
>>Pre 800 stats computation and use is not changed.
>
> It turnet out to be not as easy, as the 1.0.0 version needs box2d which
> is not present under PostGIS 0.8.1. I'm afraid I'll have to dig into the
> code.
>
> I'll post my progress here.

I now use the update_geometry_stats() from 0.9.1 and also the
build_histogram2d(histogram2d,text,text,text) wrapper from there. This
combination seems to work (at least, it uses lots of CPU and I/O, and
does not abort with an error immediately :-)

For convenience, I attached those two definitions in this email. Maybe
this helps some other PostGIS 0.8.1 users out there.

Happy GISsing,
Markus
--
markus schaber | dipl. informatiker
logi-track ag | rennweg 14-16 | ch 8001 zürich
phone +41-43-888 62 52 | fax +41-43-888 62 53
mailto:schabios at logi-track.com | www.logi-track.com
-------------- next part --------------
A non-text attachment was scrubbed...
Name: newgeostats.sql
Type: text/x-sql
Size: 1048 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20050131/e634f68f/attachment.bin>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 256 bytes
Desc: OpenPGP digital signature
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20050131/e634f68f/attachment.pgp>