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
1
vote
1 answer

Cherry pick an australian address from a page of text

I am trying to parse a prose paragraph for anything that might resemble an address. I have a database of addresses I am matching against and these are the only addresses I am interested in. I'm using a lamp server but technology specific answers…
Jason
  • 15,064
  • 15
  • 65
  • 105
1
vote
1 answer

Geocoding multi-line street addresses (Address1 / Address2)

Our app's postal-address entry UI is a two-line Address1/Address2 field like this (borrowing screenshot from Amazon.com). But real users' data entry is always messy. Some users will ignore our directions and will sometimes put the street address in…
Justin Grant
  • 44,807
  • 15
  • 124
  • 208
1
vote
4 answers

SQL: table design for ship/invoice address and SELECT CONCAT issue

I have a simple customers table designed this way (I report only some fields, the ones regarding this qeustions): + ----------- + --------------- + ---------------- + + customer_id + invoice_address + ship_address + + ----------- +…
Marco Demaio
  • 33,578
  • 33
  • 128
  • 159
1
vote
1 answer

Getting exact address with building number from reverse geocoding

Hello I'm using google maps in a mobile app and I'm using reverse geocoding to get the nearest address given a location(longitude, latitude). The returned address includes the street address but not the nearest building number in the street…
Muaz
  • 195
  • 2
  • 2
  • 11
1
vote
4 answers

Query returning records with duplicate data because of the wrong data in one of the columns

I have a record of an employee but my query is returning 2 records of this employee because the address column is different between the 2. How can solve this problem? Is it something that can be done? EMP_ID, CUS_LAST_NAME, CUS_FIRST_NAME, and…
EkansDasnakE
  • 67
  • 1
  • 10
1
vote
1 answer

Geocoding - Converting an address (in String form) into LatLng in GoogleMaps Java

I'm a beginner programmer, took a few courses in university and therefore don't have a complete understanding of the field. I figured I'd give a shot at coding an android application with GoogleMaps API and found the need to convert a user inputted…
Silber
  • 41
  • 1
  • 4
1
vote
1 answer

RegEX Positive Lookahead Guidance

I am trying to work up an expression to match the firm name in addresses like Vice President of Compliance 10004 South 152nd St. #A Omaha I tried using the following expression to match the Vice President of Compliance string but it doesn't seem…
pb_ng
  • 361
  • 1
  • 5
  • 19
1
vote
1 answer

Regex to match ZIP in an address

I have address blocks such as 10004 South 152nd St. #A Omaha Nebraska 68138 United States I am trying to find a RegEX that would match the ZIP code only and not pick up the number in the street. I tried \d+ but it picks up the first set of…
pb_ng
  • 361
  • 1
  • 5
  • 19
1
vote
1 answer

Here map 3.3. How to get current user position street name?

I am using android HERE sdk 3.3.0. I've find current location by using PositioningManager then onPositionUpdated triggered public void onPositionUpdated(PositioningManager.LocationMethod method,GeoPosition position,boolean isMapMatched) { …
Siarhei
  • 2,358
  • 3
  • 27
  • 63
1
vote
3 answers

RegExp: last symbol missing

I wrote a regular expression: ^(проезд|пл|пр-кт|пер|наб|линия|км|б-р|аллея|кв-л)\s(.+)[^\)]$ Which divides the string into street type and street name. Some streets have street location description, which i don't want to select. Here it…
Oleg Bizin
  • 169
  • 6
1
vote
1 answer

Cleanest way to set up a chain of fallbacks?

So, I am geocoding addresses from the Google Places API. There are 38 Google address component types, and we have ~5 in-house address component types, so I need a system of mapping a number of Google types to our in-house types, with fallbacks. For…
j_d
  • 2,818
  • 9
  • 50
  • 91
1
vote
3 answers

Address Validation with ZP4 from semaphore

We have an application and we were looking into adding address validation on the data we currently have on the database. Our stack is mainly node.js and MongoDB. I looked for a solution that was cost effective and I came across Semaphore ZP4. But…
erickeno
  • 188
  • 1
  • 12
1
vote
3 answers

Detect address from UITextView and show it map on tap

There is an option in UITextView properties to detect address from the the text view text. However I am not able to do that. The text view is not in editable mode. Do you know how to detect address from text view? Is there a format that the address…
AJ.
  • 1,443
  • 7
  • 19
  • 31
1
vote
1 answer

How do I look up a UK address based on house number and postcode?

Given a house number and postcode in the UK, how can I translate this into a full mailing address?
Emil Borconi
  • 3,326
  • 2
  • 24
  • 40
1
vote
4 answers

How would you sanitize the street number out of a postal address using Java?

To ensure data privacy, I have to publish a list of addresses after removing the street numbers. So, for example: 1600 Amphitheatre Parkway, Mountain View, CA needs to be published as Amphitheatre Parkway, Mountain View, CA What's the best way to…
natchy
  • 2,465
  • 2
  • 15
  • 6