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?
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:
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
Please try this (if data in the km column is stored as a number):
The modulo operation finds the remainder of division of one number by another.
I have just had a similar problem and used this work around.
Open the layer properties and select Definition query and use the expression below.
This will remove all rows with a
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?