Databases
StackOverflow2013
Postsdbo
POHow to find the distance between two ZipCodes using Java Code?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHow to find the distance between two ZipCodes using Java Code?
    primarykey
    data
    text
    <p>My requirements are similar to <a href="https://stackoverflow.com/questions/4778992/how-to-find-distance-between-two-addresses-java-server-side">this question</a>, except the fact that I am prohibited to use the latitude and longitude values. I want to caluclate the <strong>"walking"</strong> distance between two zipcodes. Later I would also require to query <strong>"who is within X kms ?"</strong></p> <p>I am not sure whether it is achievable or not. Is it really possible to find the distance between two given zipcodes ? <strong>I don't want the answers which will work only for US/UK zip codes.</strong> I need a generic solution which will work for any two zipcodes of the world. </p> <p>If the calculation of distance without using Langitude &amp; longitude is not possible then can I get the Langitude / longitude values of a given ZIPCODE ? (amazing) but How ? </p> <p>Any tutorial / example will be of great help..Since I am working on a commercial project cant use the <a href="http://code.google.com/apis/maps/documentation/directions/#DirectionsRequests" rel="nofollow noreferrer">Google Maps API</a>. So please don't suggest any other licensed services.</p> <p>Thanks in advance,</p> <p><strong>UPDATE</strong> one of the answers of <a href="https://stackoverflow.com/questions/4778992/how-to-find-distance-between-two-addresses-java-server-side">this question</a> suggests the use of <a href="http://dev.mysql.com/doc/refman/5.0/en/spatial-extensions.html" rel="nofollow noreferrer">MySQL</a> or <a href="http://postgis.refractions.net/documentation/manual-1.5/" rel="nofollow noreferrer">Postgress</a>... Will that work for me..?</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USAmit
    1. USAmit
    plurals
    1. PL
      singulars
      1. LTLinked
    2. PL
      singulars
      1. LTLinked
    3. PL
      singulars
      1. LTLinked
    1. PL
      singulars
      1. LTLinked
    2. PL
      singulars
      1. LTLinked
    3. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POHow to find the distance between two ZipCodes using Java Code?
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POHow to find the distance between two ZipCodes using Java Code?
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POHow to find the distance between two ZipCodes using Java Code?
      1. USAmit
      1. VTFavorite
    1. COYou said that you don't want to work with Lat/Lon values, but, it would be way easier if you Google those values beforehand, hardcode it in or something, and then make the math with that. (It's simple math to get distance from Lat/Lon)
      singulars
      1. POHow to find the distance between two ZipCodes using Java Code?
      1. USLouwHopley
    2. CODear artist you are under an illusion that it is possible postcodes are local to Countries and states and are not geological demarcations . You can only implement this locally even that if your local government\ council\postoffice has any such information. Other than sorry to say no Artist can paint this picture.
      singulars
      1. POHow to find the distance between two ZipCodes using Java Code?
      1. USShahzeb
    3. CO@Nideo your absolutely right. And it's not compulsory that you got the zipcode are available for every city, town, etc. may be you didn't get the exact location by zip code
      singulars
      1. POHow to find the distance between two ZipCodes using Java Code?
      1. USPratik
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload