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
3
votes
1 answer

SQL Server similar function like with postgres

Does SQL Server have an equivalent function to Postgres Similar to compare strings? I looking for something that will match str1 = "Flat 1, 110 Bob Street" str2 = "110, Bob St. Flat 1" so I can do select ... from t1 join t2 on…
jlondal
  • 43
  • 4
3
votes
7 answers

Parse A Steet Address into components

Does anyone have a php class, or regex to parse an address into components? At least, it should break up into these components: street info, state, zip, country
Andres
  • 5,002
  • 6
  • 31
  • 34
3
votes
10 answers

Which parts of an address should be required?

Say I am storing addresses in a DB table, in this fairly common break down: address_street_line_1, address_street_line_2, address_city, address_state, address_zip, address_country_id (Note: I have read the questions on splitting down further,…
xavi
3
votes
4 answers

Creating multiline Edit view in android with coding

I have created an EditText object dynamically but I haven't been able to create a multi-line EditText. I have tried this: EditText et1 = new EditText(this); et1.setHint("Enter Your…
Mahi Mali
  • 111
  • 3
  • 15
3
votes
1 answer

Regex for German address

I'm looking for a Regex pattern to find German addresses. The problem is that the format is a bit odd, and changes frequently, samples: Falcken Str. 45 F Heinrich-Heine-Straße 62A, Berlin-Kreuzberg Lindenstrasse 113; Kreuzberg; 10969…
Asaf
  • 8,106
  • 19
  • 66
  • 116
3
votes
7 answers

stripping street numbers from street addresses

Using Ruby (newb) and Regex, I'm trying to parse the street number from the street address. I'm not having trouble with the easy ones, but I need some help on: '6223 1/2 S FIGUEROA ST' ==> 'S FIGUEROA ST' Thanks for the help!! UPDATE(s): '6223 1/2…
kenny
  • 21,522
  • 8
  • 49
  • 87
2
votes
4 answers

Storing and querying postal addresses

I have a system with the concept of addresses (as in postal addresses). We have an Address table with fields Address1-4, City, PostCode. I am trying to figure out the best way to store this Address data so that it can be queried easily in the UI. …
Mike Q
  • 22,839
  • 20
  • 87
  • 129
2
votes
3 answers

Pulling international street addresses / phone numbers from free-form text

Hey, folks. I'm looking for some regular expressions to help grab street addresses and phone numbers from free-form text (a la Gmail). Given some text: "John, I went to the store today, and it was awesome! Did you hear that they moved to 500 Green…
spitzanator
  • 1,877
  • 4
  • 19
  • 29
2
votes
3 answers

Figure out if a string is a street address, suite number, shopping center, or something else

I'm using javascript to parse through some data and have run into a bit of a pickle. I have a field that is 1-3 lines of data. Usually it is only one line, representing a street address: 1234 Hollywood St. But sometimes it is something like…
Chris Dutrow
  • 48,402
  • 65
  • 188
  • 258
2
votes
2 answers

Does iOS have a standard way to enter and store a street address?

I'd like to prompt for a street address, in exactly the same way as the Contacts app. I could mimic its UI, but that would involve duplicating a lot of existing functionality; the country list, the way it re-configures based on the country…
DNS
  • 37,249
  • 18
  • 95
  • 132
2
votes
2 answers

How should an address be formatted for global sales

I'm trying to write an HTML form for entering your address, but I'm a bit stuck. At the moment it's for UK only, but starting to get global sales. There is a dropdown for county and a dropdown for country...but other countries don't neccessarily…
Paul
  • 9,409
  • 13
  • 64
  • 113
2
votes
4 answers

Looking for United States Address Validation Web Service

I'm looking for a United States Address Validation web service, as the title says. Also: I don't need maps I don't need Geo coding I do need: Validation that an address is real Address parsing Google's Maps / Bing Maps seemed good, but won't…
Ronnie Overby
  • 45,287
  • 73
  • 267
  • 346
2
votes
2 answers

Global Address Class information

I am trying to create a generic address class that could be used to store any address from any country. For example here in the UK we have post code where as in USA I think they use Zip code. I have few ideas in mind but I just wanted to see what…
Raha
  • 1,959
  • 3
  • 19
  • 28
2
votes
2 answers

Regular Expression to match addresses: problem with matching addresses with different structures

I am using regular expressions in order to match different part of street addresses (number of street, street, city...). So far, everything works except for the City, depending on the structure of the address: Some addresses I have in my data are…
ichbintim
  • 23
  • 3
2
votes
2 answers

I can't install libpostal library on Windows

I am having a hard time trying to install the library libpostal on a Windows system. I tried many times to install this library even with an other computer, but I didn't succeed. I have followed differents instructions :…