I created some near tables, with a max near distance of 8000m. It is extremely timely exporting these files to csv right now.

Is there a quick way in ArcGIS to delete observations that have a distance of more than 250m?

  • 2
    Copying a small set to a new table will always be faster than deleting the majority of features from an existing one.
    – Vince
    Oct 14, 2015 at 13:20
  • I have approx 200,000 observations to keep (and 200,000 to delete), is that too large to do a copy with?
    – Kelly
    Oct 14, 2015 at 15:03
  • 2
    DELETEs take longer than INSERTs; I would export to a new table for anything more than one quarter (or maybe one tenth) of the rows to be deleted.
    – Vince
    Oct 14, 2015 at 15:23

2 Answers 2


I would use the Table Select (Analysis) tool to select all the records with distance less than 250m out into a new table.


You can use the tool Make Query Table and specify your condition in the query.

  • For Input Tables specify your table.
  • Under Fields choose all of them.
  • Use NEAR_DIST <= 250 as an expression.

Output table contains only the rows where the NEAR_DIST is 250 or less.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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