[postgis-users] - The greater length River inside one Watershed

[Marcello Benigno]

Hi All,

I need a query that returns the greater length of river within a
watershed. Does
anyone have any suggestions on how I can solve this problem?

The rivers are formed by segments. if each were a continuous line would be
easy.

Here is a print-screen of the problem, in yellow is what would be the result of
the query.

Thanks in advance,
-- 
*Marcello Benigno B. de Barros Filho*
Prof. do Curso Superior de Tecnologia em Geoprocessamento - IFPB
Mestre em Ciências Geodésicas e Tecnologias da Geoinformação - UFPE
http://profmarcello.blogspot.com
http://about.me/marcello.benigno
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20110426/7718f536/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Screenshot.png
Type: image/png
Size: 124285 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20110426/7718f536/attachment.png>