[postgis-users] Optimizations: splitting large features

[David William Bitner]

Jeff--

The linear referencing functions along with a bit of PL/PGSQL can accomplish
this pretty well with a basic loop to divide a segment either by a distance
or into a specific number of segments to split the linear feature into.

David


> The other is to split features apart.  Instead, for example, of having
> one feature representing a river that snakes around over a large area,
> and hence has to be included in nearly every spatial query, break it
> apart into multiple features each of which represents a short segment of
> the river.
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20070427/11abafdd/attachment.html>