postal-address

mysql datatype for telephne number and address

Hello, I want to input telephone number in a form, including country code, extension create table if not exists employee( ` country_code_tel int(11), tel_number int(10), extension int(10), mobile bigint(20) ); If tel_number is larger than 15 bit, which datatype can i use, i'd...

How to look up ZIP/Postal Code by City using Google Maps API?

How can I extract a Postal Code or ZIP of a place by giving Google Maps a city on the map? Basically I'm looking for a free verification service for checking completed addresses for accurate details. I seem to remember the maps API can somehow provide a geographical point when given an address. Now I'm searching for a slightly reverse...

What webservices are available to obtain miles between two addresses?

Hi, I need to find a way to get miles (not a straight line) between two locations by passing the post addresses. If you consider the simplicity of implementation, efficiency and stability, which webservice(s) you can suggest? I would appreciate if you know any possible comparison list of relevant web-services. Thanks ...

Java library to validate postal addresses entered by users in App Engine app?

At first I thought the com.google.appengine.api.datastore.PostalAddress class was going to provide some way of validating addresses entered by users in an App Engine app but I don't even know how to instantiate this class - it doesn't have a public constructor. Is there a Java library that could be used in an App Engine app to validate...

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 do this in Java? Does this require regex? ...