Questions tagged [street-address]

Street address refers to postal addresses, or delivery points, that can be used for physical delivery of mail or goods.

Street address refers to postal addresses, or delivery points, that can be used for physical delivery of mail or goods. Data quality is a big issue surrounding street addresses, because they are not simple strings or numbers such as an email address or phone number. Therefore capturing, storing, de-duplicating and verifying street addresses all pose challenges.

577 questions
2
votes
1 answer

Google places API Autocomplete restrict to business names only

I am using Google autocomplete API in a react app. By default, the user can enter a street address or the name of a business in the autocomplete search field and google will autocomplete it. How can I restrict the autocomplete field to only…
sotn
  • 1,833
  • 5
  • 35
  • 65
2
votes
1 answer

Extract number from address with regex

I need to extract number from french addresses. Here is my regex: \d+( |\d+|bte|-|boite|[\w] {1}|([a-z] ){1}){0,2} Example on regex101: https://regex101.com/r/ZP8DSV/1 It's partialy working but not for all the lines. I need to extract the number +…
Everno
  • 33
  • 5
2
votes
2 answers

Splitting address with various delimiters into street address, city, state, zip and country

My data is in Excel. I have several sheets of data where the address is always in the same column on every sheet. Examples of the address formats include: 1155 15th Street NW Suite 600 Washington, DC 20005 US 4600 Emperor Blvd #200 Durham, NC…
Kristan
  • 23
  • 4
2
votes
1 answer

How to apply a function over rows within a single column of a pandas data frame?

I am using an address parsing library which accepts strings in the following way import pyap test_address = """ 4998 Stairstep Lane Toronto ON """ addresses = pyap.parse(test_address, country='CA') for address in addresses: #…
Dominic Naimool
  • 313
  • 2
  • 11
2
votes
0 answers

Convert Multiple Addresses to Coordinates in Swift - IOS

I used this to be able to view one address at a time. Convert address to coordinates swift However, I would like to view an array of addresses (131) and their respective coordinates Here is my code: func convertAddressToCoordinates() { for…
magellan
  • 63
  • 7
2
votes
1 answer

IndexError: list index out of range when doing nested 'for'

I want to parsing Indonesian address using the tutorial I got here: https://codeburst.io/how-to-transform-unstructured-address-data-using-python-googles-maps-api-3eea326cb862 import requests import json import csv from tqdm import * def…
ebuzz168
  • 1,134
  • 2
  • 17
  • 39
2
votes
3 answers

Regex for extracting city from comma separated address

I have an address like this: 123 Main St, Los Angeles, CA, 90210 I'd like to capture just the city: Los Angeles I've beeing trying tomsething like this: (?:[^,]+),\s([^,]+) But I don't understand how to return just the 2nd group. Using a flag…
HWD
  • 1,547
  • 7
  • 36
  • 72
2
votes
0 answers

How to autofill and verify an address in a TextEdit (or another View) in Android

Im working on a Android application where I need to get an address (and in the future, find other address that are on a X distance from the first one, where X is another input from the user). I was thinking on getting typing address, and from there…
Patrick Vibild
  • 351
  • 4
  • 16
2
votes
2 answers

parsing address "label" fields in Excel, C#, VBA, other?

Someone's sent me a Word file full off address labels separated by tabs. See I'm trying to figure out the best way to import the addresses into individual records. Probably just go with NameLine, Address1, Address2 for each one (3 fields that I can…
Caveatrob
  • 12,667
  • 32
  • 107
  • 187
2
votes
0 answers

Get all addresses for specific place/company

What I'm trying to do is collect all addresses for list of companies and trying to get it with Google Map Api. For example when I search for "Burger King" at maps.google.com I recieve 600k+ results: 20 pages of detailed results I can use Way more…
Alex Kirs
  • 339
  • 2
  • 13
2
votes
3 answers

Calculate Distances Between Addresses Without Google Maps

I bascially want to create a search in our Sales Orders database to find items that where shipped within a range of a particular address. I can't use Google's API because: It will be a report and there is no way to display a Map at runtime, which…
Kratz
  • 4,280
  • 3
  • 32
  • 55
2
votes
0 answers

Standards for saving addresses and phone numbers in database

I'm working on putting together a new database schema. Basically we'll have a collection of companies, users, etc. All of these will have addresses/phone numbers. Instead of saving the addresses and phone numbers directly in the company or user…
Kristen
  • 443
  • 1
  • 12
  • 25
2
votes
1 answer

Hierarchical Fuzzy matching strategy for address matching

I am building an address matching module in R, where I would like to find a match of a list of inAddress against a database of all addresses dbAddress using R. Let's say the address contains street number, street name, postal code, city to be…
Kenny
  • 1,902
  • 6
  • 32
  • 61
2
votes
1 answer

Remove a portion of a randomized string over an entire dataframe column in R

Need help removing random text in a string that appears before an address (data set has ~5000 observations). Dataframe test2$address reads as follows: addresses <- c( "140 National Plz Oxon Hill, MD 20745", "6324 Windsor Mill Rd Gwynn Oak, MD…
Panther08
  • 33
  • 5
2
votes
2 answers

regex street number separator

I have a address field that I want to separate in street name and house-number suffix, first part of address (street-name) is not a problem but the second part for the house-number suffix is a bit tricky. In bold is the part that I want to…
H35am
  • 768
  • 2
  • 12
  • 32