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?
[GIS] Filter by attribute to show only records with whole numbers
arcgis-10.0select-by-attribute
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:
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
andMOD 10
respectively, to show fewer points at even smaller scales.