Bruen, Bruce
Bruce.Bruen at railcorp.nsw.gov.au
Wed Jun 15 20:58:43 CDT 2005
"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.