Sorry I gave you wrong information about the tourism region maps. Not from
ABS - they're from the Bureau of Tourism Research. The latest maps are at:
http://www.btr.gov.au/service/maps/TR01.pdf

Pretty high quality. You can open PDFs in PhotoShop and rasterize to any
resolution you like without pixellation.

Regards: Ayudh

+--------------------------------------------------------------+
| Turn on your Revenue Stream...                               |
| Bolt on a Virtual Cash Register to your e-commerce site now. |
| VeriPay from Xilo Online: http://www.xilo.com                |
+--------------------------------------------------------------+
----- Original Message -----
From: "Phil Rasmussen" <[EMAIL PROTECTED]>
Newsgroups: cfaussie
To: "CFAussie Mailing List" <[EMAIL PROTECTED]>
Sent: Thursday, February 06, 2003 12:54
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/

Reply via email to