Hi, I can only provide a general solution that I know works as I have been shown it.
Basically it works by purchasing a postcode list from a mapping services company that lists the postcode and its longitude and latitude value. You then match it up to the suburb table by the postcode it has. To do a search or a grouping there is a formula that is sort of complex that determines the distances from postcodes. You could then just set up a central postcode within each region and stick this information into the formula. I know its vague, but it is a memory of a conversation some time ago. The system was built in CF. Hope that gives you another idea/angle. Blake ------------------------------------------------------------------------ ----------- Blake Foss Web Foot Forward p: 61 2 9340 4401 f: 61 2 8080 8190 m: 0410 747 620 e: [EMAIL PROTECTED] -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Phil Rasmussen Sent: Thursday, 6 February 2003 1:54 PM To: CFAussie Mailing List Subject: [cfaussie] Postcode question I am just fancying up our database, and have decided to implement a region feature for suburbs. Initially I was just going to create another table for regions, add all the regions in, and then associate a region to a suburb. Ie Regions would be..Gold Coast, Brisbane, Sunshine Coast, Cairns, Sydney... This however involves human intervention in going though every suburb and selecting the region its in, plus its a little clumsy. I figured that since the postcodes are already stored for every suburb, that I should create another table which contains all postcodes and the region they belong to. That way all suburbs will automatically be able to find what region they are in through a simple JOIN in the query. Then I got to thinking 1 step further, and maybe I should store a rule for each region. Ie, all postcodes that start with 40-- would be Brisbane, and so on for all regions. Anyone have something similar setup whereby they deduce regions from postcodes? Thanks, Phil --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.449 / Virus Database: 251 - Release Date: 29/01/2003 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/ --- You are currently subscribed to cfaussie as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
