Breaking down the individual components of an address.

learn more… | top users | synonyms

1
vote
1answer
30 views

How do I move the last two characters of a column within the attribute table to another column?

I have data in a column that looks like the below example: El Monte CA I need to move the last 2 characters to a separate column. Which function in the field calculator will deliver those results?
1
vote
1answer
72 views

How to split attributes using FME

I am trying to split an attribute into its component pieces with FME. Ex: 1707 WILLINGTON ST, PHILADELPHIA PA 19121 into: 1707 WILLINGTON ST, PHILADELPHIA, PA, and 19121 I am using the ...
2
votes
1answer
65 views

Replace Expression in Field Calculator to include a Numeric Range

There has to be an easier way to clean up address data, I hope? GeoCoding, I need to remove APT# and any number or letter that follows.
8
votes
4answers
1k views

How to split single address field into 4 fields (House No., Direction, Name, Suffix)

I have to do some massaging of our parcel data to make it usable by a program in sheriff helicopters. The program requires one of the following address formats within the fields: Our addresses are ...
2
votes
0answers
250 views

ArcGIS for Javascript : Locate Widget Activate Popup for Layers X > Z?

Using ArcGIS for Javascript I have a map with a City Council District feature layer. I would like for the user to enter their address in the 'Address Finder' / Locate Widget (that's what it's called ...
0
votes
1answer
66 views

Why ArcGIS turn Front Rd to Frontage Rd

I did a google search and a search in the ArcGIS forum. Does anyone know why when ArcGIS Desktop standardize an address such as "285 LAKE FRONT RD" and turn it into "Frontage Road"? It's a fairly ...
5
votes
3answers
463 views

Cleaning up data in Excel for use in QGIS

I am trying to clean up a large .txt dataset in Excel. I think that a macro or another application may be able to clean up the data they way I want but I have limited programming skills. I need to ...
7
votes
2answers
3k views

How to return individual address components (city, state, etc.) from GeoPy geocoder?

I'm using GeoPy to geocode addresses to lat,lng. I would also like to extract the itemized address components (street, city, state, zip) for each address. GeoPy returns a string with the address -- ...
4
votes
3answers
423 views

Is it ok to replace “#” in address with “Suite” for millions of addresses of businesses?

I have a big list of addresses of businesses that I am trying to "normalize". What keeps happening is that, every now and then I verify the address of the place by going to their website and all too ...
3
votes
4answers
7k views

Can I use the Google Geocoding API to parse and standardize address data?

I need to parse single-field addresses into multiple fields such as address number, street name, street type, etc. Esri has the Standardize Addresses tool in the Geocoding Tools toolbox, but I am ...