[udig-devel] Database tables

[Robbie Jameson]

Hi,

I've got what seems to be a fairly stupid question but it has lots of
consequences.

Say we have a postgis server with a table containing a lot of road segments
(multi linestrings) that make up a road network.

We would like to use udig to display the road network in a layer on a map
(easy - just point to the road network table), but also to be able to
decorate segments of the road with custom attributes that would ideally be
contained in another table in the database.

Is it possible to display these special segments in another layer on the map
without having to copy the geometrical information into the other custom
table? More precisely is it possible to display these segments in another
layer if they are only referencing by id segments in the original road
network table.

Thanks in advance for any guidance,

Robbie Jameson