Questions tagged [address-parsing]

Breaking down the individual components of an address.

Filter by
Sorted by
Tagged with
2
votes
1answer
122 views

What are last four columns in Royal Mail CSV PAF data used for?

Royal mail provides detailed address data for the UK in a format called PAF. You can download sample PAF data here. Most of the field definitions can be found in the official documentation here, but ...
2
votes
2answers
317 views

Use field calculator to return the word after “unit”?

Working on ArcMap Desktop 10.5; the file in question lives in a file gdb. I have a polygon layer with a field of full property addresses (string) from which I need to extract ONLY the unit number, to ...
1
vote
0answers
131 views

Looking for a French Address Parser

I'm looking for an open source project or library to parse French addresses, i've been into github and i have tried a lot of those address parser but with no luck the result is not satisfying . what ...
4
votes
0answers
279 views

Customizing rules for Address Standardizer using PostGIS?

Following PostGIS documentation, I created a custom table for having different pagc_rules (also pagc_lex and pagc_gaz) so I can standardize/normalize addresses with different formats than the US where ...
1
vote
1answer
72 views

How does OpenStreetMap specify underspecified addresses?

I live in Austin, Texas. If I'm in Google Maps and I type in "2504 E Cesar Chavez", it takes me to an address in Austin and the panel on the left says "2504 E Cesar Chavez St, Austin, TX 78702". But ...
0
votes
1answer
193 views

Populate buildings polygons with address from TIGER address range

We have OSM shapefile of buildings polygons connected to OSM shpaefile of roads. And then from TIGER we have their well known address range table connected to roads again. So via roads we can connect ...
1
vote
1answer
552 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 ...
1
vote
1answer
86 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 ...
1
vote
1answer
1k 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
4k 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
143 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
7k 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
482 views

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

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
92 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
848 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 ...
10
votes
2answers
17k 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
1k 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 ...
9
votes
4answers
26k 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 ...