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

[Sebastian Walter]

Hi Fabian,


Fabian Rami wrote:
> I have now some good dataset and mapserver is displaying it very well.
>
> I ll try now to optimise the data (by simplification) for have a 
> faster result.
>
> I have put  my shapefile in a postgis database. There is a function in 
> Postgis called Simplify( ).
>
> 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 ?
>
I'm using lat/lon data and a value of 0.01 for simplify:
DATA "simplify(the_geom,0.01) from <table> using SRID=..."
This works really well.

Regards,
Sebastian