Remove building name from address before geocoding

david_berg

I came across a problem today while building a workflow using the Geocoder where I get a large number of failed geocoding attempts because the addresses being passed through have proper building names in the address field (e.g., 100 N Tryon Street Ste XXX Bank of America Corporate Ctr). The Orig_Cass_Errorstring shows up as "Unknown Street". I don't want to create a specific rule for just BoA Corp Ctr as there are far too many examples like it for that to be a viable solution.

Has anyone ever run into this problem and/or found a solution?

Thanks in advance!

David

RodL

I wonder if you could build a process that might use the list of Street Suffix Abbreviations (as found in http://pe.usps.gov/text/pub28/28apc_002.htm) to identify where the "end" of the address might be.

What I'm thinking is to use a Find Replace tool with that list and replace anything there that matches with some unique indicator. You could then use RegEx to parse out everything before/after that indicator (assuming that most of what would be after would be building information), and then join back to your original list to get back the original Street Suffix?

Not sure how effective it would be, but if you are dealing with a large data set, it might get you a large part of the way...you could even possibly build out your rules from the "after" component of the RegEx process.

Just a thought...