[postgis-users] Replicating ArcGIS relationship classes in PostGIS

[David Haynes]

The only item that immediately springs to mind would be creating views to
preserve your join relationships. Any user that queried the view would
automatically have that underlying joined information available.

Perhaps you could explain more about the relationship classes you are
trying to implement.

On Thu, Oct 23, 2014 at 11:32 PM, Jochen Albrecht <jochen.albrecht at gmail.com
> wrote:

>
> I am working on behalf of a small non-profit that has so far used ArcGIS
> but is interested in moving open source. What kept them from making the
> move so far is that they are heavy users of relationship classes. The only
> discussion (inconclusive) that I could find was initiated by Lee
> Hachadoorian in 2008. Lots has changed since and I am wondering whether
> anybody has actually done this (implementing relationship classes in
> PostGIS). For example, back then, Lee suggested a trial-and-error approach
> to understand the encoding of relationship class tables. Have we gotten any
> further on this front? I am surprised that GIS Stack Exchange has no
> mentioning of this at all (assuming the search tools work).
> We are using relationship classes for 1:many and many:many relationships.
> This is not a problem for PostGIS; I just don't know how to migrate the
> geodatabase keeping those relationships intact.
> Cheers,
>      Jochen
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20141024/05565770/attachment.html>