topic Re: Creating Annotation with a range of Addresses in ArcMap Questions

Creating Annotation with a range of Addresses

ZJKosel — Wed, 10 Mar 2021 21:12:15 GMT

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

Re: Creating Annotation with a range of Addresses

RobertBorchert — Thu, 18 Mar 2021 18:50:04 GMT

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.

Re: Creating Annotation with a range of Addresses

ZJKosel — Fri, 26 Mar 2021 18:46:06 GMT

Thanks for the advice RobertBorchert,

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.

Thanks,

ZJKosel