topic Re: selecting multiples of 10 in Geoprocessing Questions

selecting multiples of 10

PamBrangan — Thu, 11 Nov 2010 14:53:31 GMT

Hi - I have a data layer that has 5 ft contour intervals. I would like to extract only the contours that are multiples of 10, so that I can have a data layer that is 10 ft contours. What is the selection query I need to get this to work?

Thanks in advance for any help; I am tired of banging my head on this one!

Pam

Re: selecting multiples of 10

RichardFairhurst — Thu, 11 Nov 2010 19:39:42 GMT

Hi - I have a data layer that has 5 ft contour intervals. I would like to extract only the contours that are multiples of 10, so that I can have a data layer that is 10 ft contours. What is the selection query I need to get this to work?

Thanks in advance for any help; I am tired of banging my head on this one!

Pam

The SQl you need is for the MOD function. The syntax for its use depends on the database (PGDB, FGDB, SDE Oracle, etc.). I believe the syntax for a FGDB is something like the following (assumes your contours have a field called ELEVATION):

MOD([ELEVATION], 10) = 0

Re: selecting multiples of 10

PamBrangan — Fri, 12 Nov 2010 12:05:07 GMT

Thank you Richard! That did the trick. I'm going to save that query for future use.

Re: selecting multiples of 10

MatthewLeonard — Mon, 29 Jul 2024 19:48:11 GMT

I've found using MOD doesn't quite give me the result I want. If I use MOD(FIELD_NAME, 10) = 0, values like 10.1234, 20.1234 etc. will not get filtered out. The value seems to be evaluated as an integer, so 20.1234 gets evaluated as 20, so it meets the definition query.

Instead, I use FIELD_NAME/10 = ROUND(FIELD_NAME/10,0)

Re: selecting multiples of 10

RichardFairhurst — Sat, 03 Aug 2024 16:18:58 GMT

The original suggestion using MOD only reliably works if the field being evaluated is a Short, Long or Big Integer field. However, if the field being evaluated is a Float or Double and contains any values that are not whole numbers, the expression suggested by @MatthewLeonard is the way to go.

Re: selecting multiples of 10

MatthewLeonard — Sat, 03 Aug 2024 17:00:43 GMT

Well yeah, since the OP asked about contours, I suppose they weren’t dealing with any float/double values.