Phil, Steve suggested using the distribution center as the grouping method. We've used this on a recent site and it seems to be satisfactory for our clients purposes. Nothing is going to be 100% accurate. As Ayudh said without spending heaps of time manually mapping the postcodes to regions this is probably the best cost/time solution.
Rob -----Original Message----- From: Phil Rasmussen <[EMAIL PROTECTED]> Newsgroups: cfaussie To: CFAussie Mailing List <[EMAIL PROTECTED]> Date: Thursday, February 06, 2003 2:02 PM 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/
