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

Receiving type error when trying to concatenate field values from csv in pandas

I am attempting to generate full street corner addresses out of fields taken from a .csv. I am using pandas and have written the following code to achieve this result. I am getting back a TypeError about a float object but none of the fields in my…
0
votes
1 answer

How to parse Postal Addresses from html (high tolerance - low strictness)

I am looking for ideas on how to extract postal addresses from various web sources. I'm using HtmlAgilityPack to convert the html to a XDocument (Csharp 4.0) Not looking to break down the address to components, rather just getting the address as a…
Andrew Harry
  • 13,773
  • 18
  • 67
  • 102
0
votes
1 answer

Database schema for room of a building

I have to create a booking software and I've started to design the database. The room may be in the any place of the world so I would like to have advice for address. Reading a lot of similary question I have designed this schema, what do you think…
luca
  • 3,248
  • 10
  • 66
  • 145
0
votes
2 answers

convert string to corresponding street number

I'm working with US addresses whose have an inconsistent format, E.G in the street number: 358 SEVENTH AVENUE MANHATTAN 10001 I need it to be as: 358 7th Ave, New York, NY 10001 Using a addresses parser like usaddress I can separate out the…
Luis Ramon Ramirez Rodriguez
  • 9,591
  • 27
  • 102
  • 181
0
votes
1 answer

Microsoft Word VBA multiple addresses - text box

Apologies in advance if this is already a question. I've developed a user form to auto populate some of the letters we send to stakeholders. I currently have an address section in the userform - textboxstreet textboxsuburb etc. User form in certain…
Damon M
  • 29
  • 8
0
votes
0 answers

Is there a way to format a mail address according to a given country's standard

Given all the pieces of a mail address (address line 1, line2, city, zip, state, country), is there a programmatic way to format a mail address according to a given country's format standard? From the Wiki of address formats it's not easy to spot a…
dev.e.loper
  • 35,446
  • 76
  • 161
  • 247
0
votes
0 answers

can an address autofill change the value of my input?

I have an html5 input field with autofill enabled for my address. When I type, my address shows in a drop-down below my input, however when i select my address from the drop down, nothing happens (i…
user1709076
  • 2,538
  • 9
  • 38
  • 59
0
votes
1 answer

Address picker not suggesting fields?

I'm trying to use an address picker on my form, located here: http://realendeavors.com/dmv-form/htmlform.htm I've followed all the steps outlined here: https://github.com/sgruhier/typeahead-addresspicker Any idea why, when typing in a sample address…
0
votes
1 answer

Update a field if the value of a pattern is true

This is my first question so please excuse the mistakes. I have a dataframe where the address is in one line and has many missing values and several errors. Address Braemor Drive, Clontarf, Co.Dublin Meadow Avenue, Dundrum Philipsburgh Avenue,…
ClareMc
  • 3
  • 1
0
votes
1 answer

locating an address in android phone

in my android application i have address, when i click a button i have to call google map api and show the exact location of that address.how to use that google map api in android , and also how to send the addess to the particular api to locate it?
Ads
  • 6,681
  • 12
  • 47
  • 72
0
votes
1 answer

Excel VBA address lookup

I am attempting to validate a list of several thousand addresses. I found this code which should compare my spreadsheet data into a google maps api, but I am erroring out on line 'Do While .Cells(r, 1) <> "". Can anyone help me out? I did enter a…
DHuber
  • 17
  • 1
  • 6
0
votes
2 answers

Is there a way to validate if a user types a street address with Google autocomplete?

In my signup form I have a field which requires that the user types in his/her address and city (autocomplete). Problem is that it's also possible for the user to just type his/her city without the street and submit the form. Does anyone has a…
0
votes
0 answers

Cross Referencing list of addresses to custom google maps

I would like to find for every address in my list, what is the constituency that the address belongs to. I have found this map, that lists the constituency by…
Wboy
  • 2,452
  • 2
  • 24
  • 45
0
votes
1 answer

How should I store in relational database geographical addresses?

I am building a real - estate platform and I want to document about how to store addresses in database. I have think some ways and show you, so please take me to the right way: I tried to bring to the client the flexibility to choose what fields to…
0
votes
2 answers

Java recognizing address information and breaking it apart into variables (no regex)

Does anyone have a recommended pseudo-algorithm for, given a string containing an address: Break apart the address apart into a Street variable, a City variable, a State variable, and a Zip variable The address string may be formatted in a number of…
littleK
  • 19,521
  • 30
  • 128
  • 188