[GIS] Filter by attribute to show only records with whole numbers

arcgis-10.0select-by-attribute

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?

Best Answer

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.

Related Question