I met with a gentleman today who needed to select random streets in Wilmington in order to do a field survey of urban forestry there. Here are the steps we took to do so:
Bottom is the smallest integer RANDBETWEEN will return.
Top is the largest integer RANDBETWEEN will return.
– with data added to ArcGIS, use “Frequency” tool to check that no duplicate values were generated
– do a regular one to one join, dropping out all values that don’t match. The result will be a random set of features — in this case, street segments.