Simplify data ? shp2pgsql -> PostGis Simplify() -> pgsql2shp

[Gregor Mosheh]

> When i try Simplify like that Simplify(the_geom, 100000) and i do
> pgsql2shp i have a very small shapefile but road and pictures are not so
> good :)
> What value is recommended to have a good compromise between beauty and
> speed ?

There's this posting:
http://postgis.refractions.net/pipermail/postgis-users/2005-August/008890.html

Personally, I've never found a good simplify tolerance that worked with
any particular dataset I've used. I hope your luck is better than mine
was. :)