[postgis-users] Replicating ArcGIS relationship classes in PostGIS

[Randal Hale]

QGIS gets close to replicating the ArcGIS Functionality of relationships 
- but that is stored in the QGIS project and not the data (comparable to 
storing the relationship class in the mxd). I think views are the only 
way to do this in postgis.

Randy


On 10/24/2014 09:14 AM, David Haynes wrote:
> 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 <mailto: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 <mailto:postgis-users at lists.osgeo.org>
>     http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
>
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users

-- 
-----------------
Randal Hale
North River Geographic Systems, Inc
http://www.northrivergeographic.com
423.653.3611 rjhale at northrivergeographic.com
twitter:rjhale     http://about.me/rjhale
http://www.northrivergeographic.com/spatial-connect

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20141024/6106118e/attachment.html>