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.
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 <FromLeft> (or whatever side has the lower number) & " - " & <ToRight> (or whatever is larger) & " " & <StreetName>
To be more help you will need to show us and example of your data table.
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 <FromLeft> (or whatever side has the lower number) & " - " & <ToRight> (or whatever is larger) & " " & <StreetName>
To be more help you will need to show us and example of your data table.
The data that I was using was based off address points instead of road centerlines. I'm going about the labels for this project in a different way, but I'll utilize your suggested method if I come across annotated street info to work with.
