Re: [postgis-users] Replicating ArcGIS relationship classes in PostGIS
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.albre...@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@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
Re: [postgis-users] Replicating ArcGIS relationship classes in PostGIS
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.albre...@gmail.com mailto:jochen.albre...@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@lists.osgeo.org mailto:postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@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 rjh...@northrivergeographic.com twitter:rjhale http://about.me/rjhale http://www.northrivergeographic.com/spatial-connect ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
Re: [postgis-users] Replicating ArcGIS relationship classes in PostGIS
If I recall correctly, you can export the tables that keep the relationships. If not, create a join and export only the two columns you need. For m:m relationships it's a bit nastier, and if you are using a enterprise geodatabase, with let's say, Oracle or SQL Server, you can query those, for sure. On Fri, Oct 24, 2014 at 11:17 AM, Randal Hale rjh...@northrivergeographic.com wrote: 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.albre...@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@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users ___ postgis-users mailing listpostgis-users@lists.osgeo.orghttp://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users -- - Randal Hale North River Geographic Systems, Inchttp://www.northrivergeographic.com423.653.3611 rjh...@northrivergeographic.com twitter:rjhale http://about.me/rjhalehttp://www.northrivergeographic.com/spatial-connect ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users -- George R. C. Silva SIGMA Consultoria http://www.consultoriasigma.com.br/ ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
[postgis-users] Replicating ArcGIS relationship classes in PostGIS
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@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
