Random Sampling

[N_JA]

Hello,

I have an attribute table with a list of IDs that extends to 8000+.

The study thats being done - has randomly selected households with an interval of 9.

How can I highlight just the selected household IDs on the map ?

Thank you !

Best,
N J A

[VinceAngelo]

That's not a random sample -- that's a systematic sample. For a random sample you'd need
to know the actual IDs to highlight them, but for a systematic sample you just need to know
the modulus operator for your database and the selection starting point, then you can select
using a WHERE clause, e.g., WHERE mod(id,9) = 1. Keep in mind that the range of a modulus
is [0..N-1], so mod(9,9) = 0. 

- V

PS: SQL-Server doesn't have a "mod" function, but it has an operator (e.g., WHERE id % 9 = 1)