[postgis-users] Replicating ArcGIS relationship classes in PostGIS

[George Silva]

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 <
rjhale at 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.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
>>
>
>
>
> _______________________________________________
> postgis-users mailing listpostgis-users at lists.osgeo.orghttp://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
>
> --
> -----------------
> Randal Hale
> North River Geographic Systems, Inchttp://www.northrivergeographic.com423.653.3611 rjhale at northrivergeographic.com
> twitter:rjhale     http://about.me/rjhalehttp://www.northrivergeographic.com/spatial-connect
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>



-- 
George R. C. Silva
SIGMA Consultoria
----------------------------
http://www.consultoriasigma.com.br/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20141024/898ce19e/attachment.html>