I have two point feature classes - one is the original data and one is the data after editing. I want to know how far each of the points moved in the editing process. How do I compare all of the points in the new data to the points in the old data that have the same ID# and display the distance between them? Also I have the standard license, so I don't have access to the Near or Generate Near Table tools.

  • What RDBMS are you using (i.e. SQL Server, Oracle, PostGIS)?
    – Conor
    Jul 1, 2014 at 18:52
  • Is it likely that the original feature will be the closest to the moved feature?
    – artwork21
    Jul 1, 2014 at 18:52

1 Answer 1


From a non scripting perspective, it would be fairly straightforward to do the following:

  1. Add two fields to each feature class: X1, Y1, X2, Y2
  2. Calculate Geometry to populate the fields with the coordinates
  3. Join the two feature classes by common ID#
  4. Add a 4th field, DIST
  5. Field calculator with Python

DIST = math.hypot(!X1!-!X2!, !Y1!-!Y2!)

  • 1
    out of curiosity, how well does this solution accommodate for points that span several projections? Would the distortion be significant?
    – Conor
    Jul 1, 2014 at 19:05
  • This works well for close points in say a single state plane system but not across global projections or similar. Jul 1, 2014 at 19:10
  • 1
    Data in a single feature class can't be in different projections (by definition, all geometries share a single coordinate reference).
    – Vince
    Jul 1, 2014 at 19:10
  • @Conor, it depends on the projections. Some projections emphasize area while others deal with distance. It would be strange if the two feature classes weren't in the same coordinate system, though...
    – Paul
    Jul 1, 2014 at 19:33
  • 1
    @MicheleCordini, the distance is in the units of the feature class. I you want different units, there's a handful of ways to accomplish that.
    – Paul
    Feb 11, 2016 at 17:47

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.