Breaking down the individual components of an address.

learn more… | top users | synonyms

0
votes
1answer
37 views

Nominatim UK for geocoding: problem with house numbers

I am testing a few random "addresses string" with Nominatim (https://nominatim.openstreetmap.org/). It looks ok to find the street, but it doesn't look able to pick the right coordinates on the same ...
0
votes
0answers
35 views

Parsing addresses with ambiguous data

I have data of phone numbers and village names collected from the villagers via forms. Because of various reasons the data is inaccurate or incomplete. The idea is to validate these two data points ...
1
vote
1answer
36 views

Identify a Massachusetts Municipality from address

I am trying to create or utilize a lookup table to identify which Massachusetts Municipality my address is in. Do you know of an online resource available, or a way to identify the municiaplity uses ...
0
votes
1answer
80 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?
2
votes
2answers
842 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
85 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
3k 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 ...
3
votes
0answers
361 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
73 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
566 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 ...
8
votes
2answers
6k 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
617 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 ...
4
votes
4answers
12k 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 ...