Allow updating geometry in Field Calculator

Idea created by faribaultGIS on Jul 27, 2016
    New
    Score0

    Lets say I have two feature class,

     

    - Points A. All the points have a unique point_id.

    - Points B, these points have an ID that matches the point_id in the Points A class.

     

    I can join these two tables using the point_id.

     

    Now I would like to update the geometry of the points A feature class with the geometry with points B. This would be trivial in an SQL server...It would be very useful in ArcGIS file geodatabases.

     

        UPDATE Point_A a
        INNER JOIN Point_B
        ON a.point_id=b.point_id
        SET A.geom=B.geom;
    

     

    Perhaps this could apply to any type of geometry also.