Questions tagged [address-parsing]

Breaking down the individual components of an address.

Filter by
Sorted by
Tagged with
6
votes
2answers
158 views

Extracting number from address string using QGIS

I have a table with addresses and I need to extract only the number from the attributes. The format is as follows: address VALLEY VIEW HOUSE, 36 HIGH VIEW, USHAW MOOR, DH7 7QQ 35 HIGH VIEW, USHAW ...
3
votes
3answers
200 views

Splitting string with house number in QGIS Field Calculator

I have a string field with housenumber which contains values like: housenumber 5 12 a 15 b 18 c What are the right expressions for the field calculator to write only the number in "field1&...
3
votes
1answer
225 views

Parsing KML file with FastKML

I try to parse a KML file to retrieve the polygon names and -coordinates. I try to do this with FastKML (also tried pykml and element.tree, but no result). Reading the KML seems to be good. However, ...
0
votes
0answers
13 views

How to split summary address received as response of ordnance survey address base

I am using an API to fetch search response from ordinance survey address base, the result includes a summary address field which contains full address in one line. The result can be ambiguous as ...
1
vote
1answer
52 views

In ModelBuilder use Parse Path (path and name) to get output FC name

I built a model (in ArcGIS 10.6) and the Parse Path tool is working well if I using the Name type. But I need to use the input .gdb name also into the output feature class name. e.g. Inputs: C:\...
3
votes
1answer
354 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
719 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
310 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
358 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
82 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
222 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
865 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
96 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
2k 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?
3
votes
2answers
6k 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
155 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
9k 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
485 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
95 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
929 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 ...
11
votes
2answers
24k 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
2k 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 ...
11
votes
4answers
30k 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 ...