[udig-devel] Database tables

[Jody Garnett]

Two answers one good and one bad (but you have to choose which is which):
- The subject of joins is part of the scope the new GeoTools Feature 
Model will try and address, this is a concern and we have the ability to 
fix it - but at current volunteer levels this is in "the next 6 months".
- The project I am working on now has this same requirement, we are 
using Hibernate to map our table into java beans (including joins such 
as your describe), and forcing the resulting objects out through a 
"HibernateDataStore", we have no plans for uDig integration but you 
could .... this is in the next few weeks.

You may be best served by constructing your join on the database side as 
a view, and then bringing in that view as a layer....

Jody
> 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
>
>
>
> _______________________________________________
> User-friendly Desktop Internet GIS (uDig)
> http://udig.refractions.net
> http://lists.refractions.net/mailman/listinfo/udig-devel
>