[postgis-users] river network labeling

[surya]

Dear Nicolas,

I have two tables. One table consists of geometries of 100 rivers with its 
tributaries. Each river and its tributaries (branches)  is  divided in more 
or less 10 segments, so i have 1000 river segments in one watershed. Second 
table cosists of segment attribute of each river  such as 
upstream-beginning-node (FROM) and downstream-ending- node (TO), segment 
name, river name, water level, etc. How I can join both tables and have 
segment attribute displayed in webmapping (f.e. Mapserver). I have ever seen 
example in road labeling, where they have attribute for each segment suc as 
fromleft, toleft, fromright, toright. What does this attributes refer to? Is 
it also possible to SQL-query which river tributaries (branches) flow into 
which certain river in this river network?

I hope my question does not take to much of your time.

best regards,

surya


----- Original Message ----- 
From: "Nicolas Ribot" <nicky666 at gmail.com>
To: <storma-ipb at indo.net.id>; "PostGIS Users Discussion" 
<postgis-users at postgis.refractions.net>
Sent: Monday, January 26, 2009 8:34 PM
Subject: Re: [postgis-users] river network labeling


>> Dear List,
>>
>> where can I find information on how to give label  for river
>> network in a big watershed.
>> best regards,
>>
>
> Hi,
>
> What do you mean by "to give label" ? do you want to update some
> attributes for a 'river' table, or do you want to display labels in
> some visual representation (desktop GIS, webmapping...) ?
>
> Nicolas
>