Extract Block Numbers From Address Ranges
The Police Department has requested a map with block numbers on the streets (ex. 100, 200, 300, etc.). I was wondering if there was an easy way to extract block numbers from address ranges without going through and creating them manually. Thanks.
Mapping Center Answer:
So, this depends on how your address ranges are coded into your street centerline data. Let's say you're the typical case, which is that the left- and right-side starting range fields exist. These fields contain the basis for a block number. In many cases one of these fields already has what you need. But let's say you've got the actual address ranges instead of the theoretical address ranges. If that's the case, then you'll want a new integer field that you will calculate as follows:
Int ( [L_ADD_FROM]/100 ) * 100
If you would like to post a comment, please login.