[AccessD] Australia - find nearest location

OK - thanks Bruce. At least I know not to waste my time trying that - and if client really wants it then I know to look further....
Kath
  ----- Original Message ----- 
  From: Bruen, Bruce 
  To: Access Developers discussion and problem solving 
  Sent: Thursday, June 16, 2005 11:58 AM
  Subject: RE: [AccessD] Australia - find nearest location


  "Basically what I need to know is whether proximity in number =
  proximity in distance - I am guessing that it won't always be the
  case..."

  You have guessed correctly.  It wont work, a) the original postcodes
  were allocated as a loose function of distance from the mail clearance
  centre - (way back in the 60's??)
  b)since then new codes have been allocated and old ones modified and
  reallocated under a series of illogic that thoroughly eliminates any
  possibility of determining relative geographic co-ordinates across
  Australia.  However, there is a correlation between a postcode and a
  thing, IIRC, a mail delivery point (which in some cases goes down to a
  building or even a location within a building.) APO has occassionally
  published this database but I haven't seen or had any use for it for
  over 4 years - so I've lost the access to it.

  Sensis, yahoo/local and even the website that lists your company have
  functionality that provides this type of lookup but I'm d*mned if I know
  how they do it.

  regards
  bruce


  -----Original Message-----
  From: accessd-bounces at databaseadvisors.com
  [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kath Pelletti
  Sent: Tuesday, 14 June 2005 7:06 PM
  To: Access Developers discussion and problem solving
  Subject: Re: [AccessD] Australia - find nearest location

  Thanks Michael - I think I need to learn about the way / rules that
  postcodes are allocated in my region - that way I may be able to create
  some sort of process. Just thought someone may have looked into that
  before.

  Basically what I need to know is whether proximity in number = proximity
  in distance - I am guessing that it won't always be the case...

  Kath


  ----- Original Message -----
    From: Michael Maddison
    To: Access Developers discussion and problem solving
    Sent: Friday, June 10, 2005 10:48 AM
    Subject: RE: [AccessD] Australia - find nearest location


    Never tried myself, but the discussions here recently on MapPoint
  might
    lead the way.

    cheers

    Michael M

    Hi all - Just wondering whether there happens to be anyone on list who
    may already have done this - 

    I'm writing a new system for a training company and they want add a
    geographic search capability - ie. they would like to enter a suburb
  or
    postcode and the system displays will show the courses which run
  closest
    to them geographically.

    Any tips? Or if anyone has done this at all - can you tell me what
  your
    approach was?

    Thanks - rgds

    ______________________________________________
    Kath Pelletti
    Software Design & Solutions Pty Ltd.
    Ph: 9505-6714
    Fax: 9505-6430
    KP at SDSOnline.net
    --
    AccessD mailing list
    AccessD at databaseadvisors.com
    http://databaseadvisors.com/mailman/listinfo/accessd
    Website: http://www.databaseadvisors.com
    --
    AccessD mailing list
    AccessD at databaseadvisors.com
    http://databaseadvisors.com/mailman/listinfo/accessd
    Website: http://www.databaseadvisors.com
  --
  AccessD mailing list
  AccessD at databaseadvisors.com
  http://databaseadvisors.com/mailman/listinfo/accessd
  Website: http://www.databaseadvisors.com
   
   
  This e-mail and any attachments may contain confidential information that is intended solely for the use of the intended recipient and may be subject to copyright. If you receive this e-mail in error, please notify the sender immediately and delete the e-mail and its attachments from your system.  You must not disclose, copy or use any part of this e-mail if you are not the intended recipient.  Any opinion expressed in this e-mail and any attachments is not an opinion of RailCorp unless stated or apparent from its content. RailCorp is not responsible for any unauthorised alterations to this e-mail or any attachments. RailCorp will not incur any liability resulting directly or indirectly as a result of the recipient accessing any of the attached files that may contain a virus.
  -- 
  AccessD mailing list
  AccessD at databaseadvisors.com
  http://databaseadvisors.com/mailman/listinfo/accessd
  Website: http://www.databaseadvisors.com