topic Re: How to use an address range value to create a new record for each address within the range? in Addressing Questions

How to use an address range value to create a new record for each address within the range?

ShannonGrumbly2 — Tue, 20 Dec 2016 14:47:49 GMT

I have a shapefile of parcels which contains an address for each parcel. Some of these addresses are listed as ranges (e.g. 4422-88 Wissahickon Ave). Is there a way to create a new record for each address within that range? I essentially want many addresses associated with a parcel if the parcel contains many addresses. I am assuming it would require the use of a geocoder, but I am not sure how that could be utilized. Any advice would be great!

Re: How to use an address range value to create a new record for each address within the range?

JoeBorgione — Tue, 20 Dec 2016 15:12:48 GMT

Given the range you provide above, how many actual physical addresses are associated with it? Are there 66 (odd and even) or 33 (even only) or some combination? Do you need an actual point for each? If so, yes you'd want to geocode each address. Otherwise you could create a table record of each address by iterating through the range using a cursor in Python, but this is where I hand if off to Dan_Patterson‌ or dkwiens‌

Re: How to use an address range value to create a new record for each address within the range?

ShannonGrumbly2 — Tue, 20 Dec 2016 15:17:03 GMT

I just checked in our online software (not associated with ESRI/ArcGIS), and there are 3 addresses on file within that range. There will obviously be more or less addresses associated with other ranges. Maybe this becomes a question of how I can bring in data from our online system?

Re: How to use an address range value to create a new record for each address within the range?

JoeBorgione — Tue, 20 Dec 2016 15:25:44 GMT

That's why I thought I'd toss that out little tidbit out there; a range of values is often times misleading with respect to actuality. Just a guess, but there should be a way to get a data dump of what you are after from the source itself.

Re: How to use an address range value to create a new record for each address within the range?

TimWitt2 — Tue, 20 Dec 2016 15:33:30 GMT

Yes, with ranges everything is hypothetical. It is tough to create a point layer from ranges, unless you don't care about points that aren't real life addresses.

Re: How to use an address range value to create a new record for each address within the range?

ShannonGrumbly2 — Sun, 12 Dec 2021 10:53:31 GMT

I've decided that having points that may not be real life addresses is acceptable for this project. How would I go about using a cursor? I'm alright at Python, but cursors are not my forte.

I also found the following code to add the increments via Field Calculator (either in Desktop or Python):

rec=0  def autoIncrement():   global rec   pStart = 1    pInterval = 1   if (rec == 0):     rec = pStart    else:     rec += pInterval    return rec

autoIncrement()

Re: How to use an address range value to create a new record for each address within the range?

TimWitt2 — Thu, 22 Dec 2016 13:51:46 GMT

Hey Shannon,

just a quick question, you mentioned an only software that has all the addresses. What format is this information in?

Tim

Re: How to use an address range value to create a new record for each address within the range?

ShannonGrumbly2 — Thu, 22 Dec 2016 13:57:54 GMT

I'm not sure what you mean by "format" of the software, but it is a standalone system that is available with particular credentials. I'm not sure that I can access a list of each address, but it allows you to search for information given block number, parcel number, ID, etc. or any combination of those.

In terms of the actual addresses, I receive data in all formats. Static tables, Oracle database tables, views, so on and so forth. So I would like to have one table containing all addresses and any alias associated with an address.

I'm thinking that a Search Cursor/Insert Cursor can accomplish this (the first task of parsing address ranges into single addresses), but I'm not seeing much on any existing forums.

Re: How to use an address range value to create a new record for each address within the range?

TimWitt2 — Thu, 22 Dec 2016 14:04:23 GMT

Can you post a screenshot of an example row of your polygon layer?

I hoped that with an export (csv, excel spreadsheet) of the data in your online tool you could geocode those addresses.

Re: How to use an address range value to create a new record for each address within the range?

ShannonGrumbly2 — Thu, 22 Dec 2016 14:12:47 GMT

Sure. I used the 'Standardize Address' tool to create the HouseNum, PreDir, PreType, StreetName, SufType, and SufDir fields from 'ADDRESS'. As you can see, it didn't do a perfect job because it left prefix directions with the house number ranges.

Re: How to use an address range value to create a new record for each address within the range?

TimWitt2 — Thu, 22 Dec 2016 14:43:51 GMT

To just get the numbers create a new field called Number, right click the new field and choose Field Calculator. Switch parser to Python and type the following:

!HouseNum!.split(' ',1)[0]

then click ok

Re: How to use an address range value to create a new record for each address within the range?

JoeBorgione — Thu, 22 Dec 2016 16:03:15 GMT

I think the first thing I'd do is clean up those records where the HouseNum ends in N E W or S: Select them as such, and use a python statement smilar to what Tim provides to calc the PreDir field accordingly. Then you can just do a search and replace on ' %' (space any-character) and replace it with '' (no space, no character).

My guess is you got the predirs in your housnum field because there are extra spaces in your address field....

Re: How to use an address range value to create a new record for each address within the range?

ShannonGrumbly2 — Thu, 22 Dec 2016 16:04:59 GMT

How about if I wanted to remove the predirs in the housenum field, but write them to the actual predir field?

Re: How to use an address range value to create a new record for each address within the range?

JoeBorgione — Thu, 22 Dec 2016 16:08:44 GMT

I'm not smart enough to do that in one step. Tim probably is.... timw1984‌

Re: How to use an address range value to create a new record for each address within the range?

ShannonGrumbly2 — Thu, 22 Dec 2016 16:12:34 GMT

I thought I was close with this code (ending in "else: return my_direction"):

But it returns <Null> for any row where there is a W, E, S, or N attached to the end of the housenum.

Re: How to use an address range value to create a new record for each address within the range?

TimWitt2 — Thu, 22 Dec 2016 16:47:42 GMT

Shannon this worked for me:

Pre-Logic Script Code:

def SPLITTING(test, test2):
if (test2 =='') :
howmany = test.split(' ',1)
if (len(howmany) > 1):
return test.split(' ',1)[1]
elif (len(howmany) == 1):
return
else:
return test2

PreDir box

SPLITTING( !HouseNum!, !PreDir! )

Re: How to use an address range value to create a new record for each address within the range?

ShannonGrumbly2 — Thu, 22 Dec 2016 17:55:16 GMT

Thanks for your response, Tim. This code does not produce anything for housenum that ends with a W, E, S, or N for me.

This is a direct copy and paste from the table:

449-57 E

I'm not sure if there's a different character or something in that value that's different from what you have.. I get "WARNING 000405: No records within table."

Re: How to use an address range value to create a new record for each address within the range?

TimWitt2 — Thu, 22 Dec 2016 18:05:11 GMT

Would you be able to share a view rows of your table and upload it as a shapefile here? The first 4 I see in your screenshot would be perfect.

Re: How to use an address range value to create a new record for each address within the range?

ShannonGrumbly2 — Thu, 22 Dec 2016 18:21:45 GMT

Whoops! I was working in an older version of that table. It works in this table, though. Thank you!

Re: How to use an address range value to create a new record for each address within the range?

TimWitt2 — Thu, 22 Dec 2016 18:24:33 GMT

Glad it works!