MartyConnelly
martyconnelly at shaw.ca
Thu Jun 16 18:50:56 CDT 2005
Same thing in Canada. The post office wil provide a new postal code to a recently completed building complex. However the do have a database that is purchaseable that will give the geo coordinates of the postal code either to the building or the block face centroid. Except for Santa Claus's postal code H0H0H0 and the geo centroid is sort of obvious. Kath Pelletti wrote: >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 > > -- Marty Connelly Victoria, B.C. Canada