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 -~----------~----~----~----~------~----~------~--~---
