Ask A Cartographer

Extract Block Numbers From Address Ranges

June 10 2010 | 1 comment
Categories: Map Data


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



Thank you! posted by Stuart Blumberg on Jun 14 2010 6:20AM
That is exactly what I needed!! You have saved me tons of time!! Thanks a million!

If you would like to post a comment, please login.

Contact Us | Legal | Privacy |