[postgis-users] simplify a linestring to n points

[Obe, Regina]

So would it work for you if you broke the linestrings into multiple
records such that each linestring in the record has at most 5000 points.
That's I think an easier task.  Well at least I can think of how to do
that anyrate.

So your tradeoff would be something like

5 records each with 20,000 points

to

20 records each with 5,000 points

 

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
richard -rw- weinberger
Sent: Tuesday, November 25, 2008 4:37 AM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] simplify a linestring to n points

hi!

2008/11/24 Obe, Regina <robe.dnd at cityofboston.gov>:
> I'm curious why you want to do this?

our databases holds a lot of
linestrings with more than 5000 points. these linestrings are
processed by external tools.
a few of this (crappy) tools can only handle linestrings with 500 or
less points.

cheers,
//richard
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
-----------------------------------------
The substance of this message, including any attachments, may be
confidential, legally privileged and/or exempt from disclosure
pursuant to Massachusetts law. It is intended
solely for the addressee. If you received this in error, please
contact the sender and delete the material from any computer.