Hie all
I have a few addresses for a town, the start and the end house number of every street. I also have a the sequence in which the house numbers from the beginning to the end of each@ street.
The only way I know is to type the addresses one by one in excel or the attribute table however its too laborious considering the number of stands
I'm expecting that there is a way to I can tell ArcGIS the starting point, the end point and the sequence. if so how then can I do it????????
Thanks in advance
Ronnie
What is it you are attempting to do? You describe what data you have and then you launch into "The only way I know is to type the addresses"....
Joe
Thanks for helping me to clarify
I want to know how I can tell ArcGIS the starting point, the end point and the sequence so that it populates the remaining addresses in between
typing all the addresses would be too laborious since they are too many
But why would you want or need to do that? I'm purely speculating here, but it sounds like you want to create an address for every number between the low and high range you already have. In all the geocoding I've done in the past 20 years, I can tell you that a range of numbers is just that: a range. It does not indicate that there is an actual address for every number between the low and high.
However, back to your original post, there are different methods to create sequential numbers of a given step value. Here is a link for one using arcpy: 38517 - Create sequential numbers in a field using Python in the Field Calculator
It sounds like the objective is create addresses for parcels, given a known start and end value. The script Joe Borgione mentions works well - I've used it many times.
Notes on script:
Chris Donohue, GISP
The Attribute Assistant add-in can help you automate that. I guess it depends on how often you are going to be doing this and how many points (I am assuming you are creating address points.) you will be creating. If it is a lot of points it may be worth the time to figure out how the Attribute Assistant add-in works. I use it all the time to make data entry easier. Once you figure it out you start seeing other ways to use it.
The Attribute Assistant comes with most of the map templates for the Local Government Information Model. Try the Address Data Management map template. That map is intended to be used for new development and new addresses. The idea is you create a road centerline enter the ranges for that segment and then start creating site address points. The add-in fills in the house number and the street name and then concatenates them into a full address field.
For your needs I think you could use the GENERATE_ID method - setting the low address in the GENERATEID table and the increment value, then in the DynamicValue table create a line for your house number field and use the GENERATE_ID for the value method.