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
<[email protected] <mailto:[email protected]>> 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
[email protected] <mailto:[email protected]>
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
[email protected]
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
--
-----------------
Randal Hale
North River Geographic Systems, Inc
http://www.northrivergeographic.com
423.653.3611 [email protected]
twitter:rjhale http://about.me/rjhale
http://www.northrivergeographic.com/spatial-connect
_______________________________________________
postgis-users mailing list
[email protected]
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
