Creating Annotation with a range of Addresses

Question

Hello everyone,

I'm working on a project in ArcMap that deals with address labels from a large scale. I've looked into ways to create a annotation feature class that represents addresses along the same road as a single range. For example, the addresses of 101 Main Street, 102 Main Street, 103 Main Street, and 104 Main Street would be displayed as 101 - 104 Main Street. However, I haven't been able to write up a SQL query that works or find the right settings to display this information as such. The program being used is ArcMap 10.7.1.

Thank you,

Zachary

RobertBorchert · Accepted Answer

I had a similar situation labeling Apartment numbers ranging from one number to another. Where are your address ranges stored. If your using road centerline data that has address ranges in it that would be best. Then you create a simply label (or whatever side has the lower number) & " - " & (or whatever is larger) & " " & To be more help you will need to show us and example of your data table.