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

Fixing Street Address Regex Validation

After many hours of searching I have found a regex that validates the street address (just the street without city/state/zip). This is for US use only. It's been difficult to find any that would fit my needs or that worked with numbered streets. The…
EagleDude
  • 11
  • 1
1
vote
2 answers

Magento 2 - Get Customer Address Id through Shipping Address at Checkout Session

I'm having trouble with getting customer address Id as it returns a null value. This is what I have tried: $checkout = $this->_sessionCheckout->getQuote(); if ($checkout) { $shippingAddress = $checkout->getShippingAddress(); if…
1
vote
2 answers

how to view the map in an android app

in my app i want to show the location address, latitude and longitude and exact position of the user in the map. i am able to find the latitude and longitude. In my app i have a button named "View Map", when the user click on it i want to show the…
Siva K
  • 4,968
  • 14
  • 82
  • 161
1
vote
2 answers

How to store address in database

I am developing a CRM application that stores some data on companies we work with. Such as for example: CEO name and physical address of their head office. I will often need to look up for companies located in particular city and then sort the…
tnsaturday
  • 527
  • 2
  • 10
  • 31
1
vote
1 answer

R (regex) - removing apartment, unit, and other words from end of address

I have a large dataset of addresses that I plan to geocode in ArcGIS (Google geolocating is too expensive). Examples of the addresses are below. 9999 ST PAUL ST BSMT GARRISON BL & BOARMAN AVENUE REAR 1234 MAIN STREET 123 1234 MAIN ST UNIT1 ArcGIS…
user50313
  • 15
  • 4
1
vote
2 answers

Concatenate address lines efficiently

My database stores some standard address lines fields (address line 1,2.. City, Country, Postal/zip code) and I would like to concatenate them to a human form. I've written the following code but I'm not sure if this is very efficient with a bunch…
Ivan
  • 59
  • 1
  • 9
1
vote
1 answer

Python regex solution for extracting German address format

I'm trying hard to write a Python regex code for extracting German address as show below. Abc Gmbh Ensisheimer Straße 6-8 79346 Endingen Def Gmbh Keltenstr . 16 77971 Kippenheim Deutschland Ghi Deutschland Gmbh 53169 Bonn Jkl Gmbh Ensisheimer Str .…
Richie
  • 135
  • 1
  • 3
  • 12
1
vote
1 answer

How to store global addresses in database?

Currently we have the following US-centric database design for storing addresses: street_address_1 text street_address_2 text city text state_province text postal_code text country text But now I've learned that some countries do not use any…
William Entriken
  • 37,208
  • 23
  • 149
  • 195
1
vote
6 answers

How do you deal with duplicate street suffixes?

I have a system where users need to enter addresses. I am trying to limit duplicates of course and something I started noticing was becoming a big problem was some users putting in "Road" and others "Rd", therefore duplicates were creeping in. I…
Matt
1
vote
1 answer

How can I use a regex function to extract european streetnames, housing numbers and adjectives with pandas?

I have a dataframe with 6000 records and need to extract/split the column with streetname into: "Streetname", "Housingnumber" and "Adjectives". Unfortunately, the problem is not solved yet using regex functions because there is no structure in the…
Levi
  • 11
  • 1
1
vote
3 answers

Validate Street Address Format

I'm trying to validate the format of a street address in Google Forms using regex. I won't be able to confirm it's a real address, but I would like to at least validate that the string is: [numbers(max 6 digits)] [word(minimum one to max 8 words…
Drop04
  • 11
  • 1
  • 1
  • 4
1
vote
2 answers

I am trying to write a regex on powershell for the canadian addresses

this is the address method the number might be different 12 or 412 and how many words for the finch ave east 1460 Finch Ave East, Toronto, Ontario, A1A1A1 so I try…
user9545886
1
vote
1 answer

How to detect if a query string is relevant for a Google Map Static API lookup

I am currently developing a web app that uses Google's Static Map API, in order to display maps of places upon user's request. My problem is the following: How can I detect if a given string is relevant or not to searching Google Maps…
Gabriel S.
  • 1,961
  • 2
  • 20
  • 30
1
vote
3 answers

iPhone: Howto build a custom table view cell similar to contact address cell

this may have been discussed already but I cannot find the question. I need to display/edit an address in a table view. Looking at the address cell in the iPhones contacts app, it appears that they use a single cell for both displaying and editing…
drekka
  • 20,957
  • 14
  • 79
  • 135
1
vote
2 answers

Use address to create route with google maps (without latitude and longitude)

How can I use address for to create a route with google maps? Without use latitude and longitude, because in my firebase i don't use latitude and longitude. I use only full address. Example: John F.Kennedy International Airport, Van Wyck…