Speeding up load time for huge SHP files
Jan Hartmann
j.l.h.hartmann at UVA.NL
Mon Aug 20 04:57:08 PDT 2007
Thanks Sebastian. I had heard of that, but I never used it, based on my
expeience with ArcView and ArcGIS; crashes and funny maps.
Jan
Sebastian Walter wrote:
> Hi,
>
> Jan Hartmann wrote:
>> How would you produce that simplified version is none is available
>> already?
>
> A very conveniant way of simplifying big shapefiles is dumping them in
> PostGis/Postgresql using shape2pgsql, then creating a new geometry
> column and fill the data with "UPDATE <table> SET <newcolumn> =
> simplify(the_geom,0.01)
> where the 0.01 is the tolerance factor, this number works well for me in
> longlat units. Then you can dump the table back to a shapefile using
> pgsql2shp.
>
> This way, simplifying huge shapefiles is really fast and stable, while
> in ArcGIS it's taking hours, and then just crashes.
>
> Regards,
> Sebastian
>
More information about the MapServer-users
mailing list