Filter by attribute to show only records with whole numbers

Question

Is there a way to show points that only contain whole numbers in a column (eg. 009, 010, 011 and NOT 9,1; 9,2; 9,3...) in ArcGIS 10?

Answer 1

This assumes the km column stores numbers, not strings.

Open the table.

Add a new column and name it whatever you want, I'll use wholenum in this example.

Right-click the wholenum column and choose Field Calculator.

Set the Parser to Python and put a check in Show Codeblock.

Enter this formula in the Pre-Logic Script Code field:

x = 0 
if [km] MOD 1 = 0 then
x = 1
endif

Put x in the km= field.

Click OK to close the Field Calculator.

Set this Definition Query on the layer: wholenum = 1.

Now it will only display points with whole number values. You could take similar steps to show every 5 km or 10 km point, by using MOD 5 and MOD 10 respectively, to show fewer points at even smaller scales.

Answer 2

Please try this (if data in the km column is stored as a number):

[km] mod 1 = 0

The modulo operation finds the remainder of division of one number by another.

Answer 3

Yes I want to select by attribute in ArcMap 10. The data contains the km-information of a railway network. The name of the column is "km" and the rows contain the distance from the zero point. Every 100m (000, 0,1; 0,2...) there is a point in my map, but I only want to show the whole km (1, 2...)

So I only want to show every 10th point, that`s why I want to select all the whole numbers. Otherwise the map is too overloaded with points... The km are stored as string! Any ideas?

Thanks!!