View Single Post

   
  #1 (permalink)  
Old 03-01-2008, 11:35 AM
Pacific Fox
 
Posts: n/a
Default SQL to calculate surrounding suburbs

Hello all,

Does anyone know the SQL statement for calculating surrounding suburbs,
or can point me in the right direction?
I have a database of Australian postal codes and their centroids in
longitude and latitude, I'd like to pass it either the long/lat or
postal code to calculate from. And preferably return distance as well,
in KM..

Thanks in advance.

Reply With Quote