http://www.mapds.com.au/solutions_locators.shtml
----- Original Message ----- From: "Robin Hilliard" <[EMAIL PROTECTED]> To: <cfaussie@googlegroups.com> Sent: Wednesday, February 22, 2006 10:39 PM Subject: [cfaussie] Re: Postcode search > > Hi Kay, > > Starting with the basics the raw data you need is the lat/lon of the > dealers and a database of "postcode centroids" (e.g. the Gazetteer of > Australia, product code 06 from Geoscience Australia, p15 of > catalogue: http://www.ga.gov.au/servlet/BigObjFileManager? > bigobjid=GA7015 - internet use license is $1620) Then you look up > the centroid lat/lon for your postcode/suburb combination in the > gazetteer and write something like: > > SELECT TOP 10 > FROM dealers > ORDER BY (centroidlat - dealers.lat)^2 + (centroidlon - dealers.lon)^2 > > Or whatever the geospatial index equivalent is in your database (most > dbs seem to have these add ons these days). Note this sorts on the > square of the distance which is faster - no need to take square root > as you just need the order. > > This gets you the ordered list, you could then hook them into the > whereis directions API when they selected a dealer. If you want to > draw maps like the sample site you gave you might want to talk to > Kirk Mower at ESRI and see what he has. > > Cheers, > Robin > > > ______________ > > Robin Hilliard > Director - RocketBoots Pty Ltd > Professional Services for Macromedia Technologies > http://www.rocketboots.com.au > > For schedule/availability call Pamela Higgins: > w +61 7 5451 0362 > m +61 419 677 151 > e [EMAIL PROTECTED] > > or Direct: > m +61 418 414 341 > f +61 2 9798 0070 > e [EMAIL PROTECTED] > > *** Webdu, Webdu, We want you at a Webdu *** > > > On 22/02/2006, at 5:48 PM, Kay Smoljak wrote: > >> >> Heyas, >> >> Does anyone know of a postcode search service like: >> http://tyrepower.business.com.au/profileimages/37176.htm >> but not run by business.com.au? >> >> Cheers! >> >> -- >> Kay Smoljak >> http://kay.zombiecoder.com/ >> > > > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~----------~----~----~----~------~----~------~--~---