I have a feature class with fields: Latitude, Longitude, Type, Magnitude, City, State, Comment.
If Latitude, Longitude , and Type are the same, I only want to keep the record with the highest Magnitude value (magnitude will vary usually).
However, sometimes there are duplicates in the data (all fields have duplicate values), so I would only want to keep one record.
I am guessing I would need to use a cursor. Or perhaps I could sort the data and create a new table using only the top unique records?
أكثر...
If Latitude, Longitude , and Type are the same, I only want to keep the record with the highest Magnitude value (magnitude will vary usually).
However, sometimes there are duplicates in the data (all fields have duplicate values), so I would only want to keep one record.
I am guessing I would need to use a cursor. Or perhaps I could sort the data and create a new table using only the top unique records?
أكثر...