Skip to main content
Question

How to change from user attribute based relationship class to Global 'ID based relationship class and not losing the data .

  • February 21, 2019
  • 2 replies
  • 22 views
bhanu_v
Forum|alt.badge.img

I have a feature classes and table that have relationship class based on a user attribute field as PK-FK.(1-M) simple .This feature class also has Global Id's.

we are moving towards collecting this data now in Collector and as best practice want to move to a relationship class based on Global'Id.

I understand that I have to create a new relationship class as you cannot edit an existing one

but how do I do it without losing the data .

I would appreciate insights from anyone who attempted to do this

 

    2 replies

    M
    Forum|alt.badge.img+2
    • markatsafe
    • February 22, 2019

    @adi Did you try the Add GlobalID's tool in the Esri stack? You can accomplish this in FME but you'd have to build the workspace for each relationship as per the example described in "Introduction to Working with Geodatabase Relationship Classes"

    bhanu_v
    Forum|alt.badge.img
    • bhanu_v
    • Author
    • February 22, 2019
    markatsafe wrote:

    @adi Did you try the Add GlobalID's tool in the Esri stack? You can accomplish this in FME but you'd have to build the workspace for each relationship as per the example described in "Introduction to Working with Geodatabase Relationship Classes"

    Hello @MarkAtSafe,

    Thank you for your reply

    The feature class has global Id's populated in them but the relationship is not based on this global id ,

    The actual data Im working on is that

    I have a poles featureclass with PoleID (user generated Alphanumerc string)

    with related table of signs table has PoleID field where the PoleID is Foreign Key in this and its (1 to many) one pole has multiple signs attached to the pole.

    Now I want to change the relationship table to have relationship to be on Global'id

    how to change this without breaking the data.

     

    Reply


    Helpful Members This Week

    Community Stats

    31,504
    Posts
    119,425
    Replies
    39,122
    Members

    Latest FME

    Terms & ConditionsCookie settingsAccessibility statement

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie settings
    A product of
    Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.