Thanks for the solutions guys. I should have probably mentioned that I already have all the Australia Post postcodes in a table, and have lat/long co-ords for every suburb. I just figured that instead of manually entering regions into another table I could find some rules. Thats cool. Lucky we only cover QLD and Northern NSW at this point so I don't have too much to enter manually.
Oh and Ayudh I should have mentioned that the regions I want to specify are the tourism ones. So things like Gold Coast, Sunshine Coast....just the general regions that a tourist would relate to. I think I have no choice but to map these manually. Thanks all, Phil "Rob McLennan" <[EMAIL PROTECTED]> wrote in message news:22687@cfaussie... > > 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/ > > > > > --- 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/
