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/
