Where did you get the data for the correlation between lat/long and post code? I could really do with this...
Hilary -- ----- Original Message ----- From: "Phil Rasmussen" <[EMAIL PROTECTED]> Newsgroups: cfaussie To: "CFAussie Mailing List" <[EMAIL PROTECTED]> Sent: Thursday, February 06, 2003 6:12 PM Subject: [cfaussie] Re: Postcode question > No no, I already have them all in the 1 table Steve. So I have all the > suburbs and their respective postcode/state/lat-long.....what I am trying to > do is now associate each suburb with its tourist region. So that in my > search system, I can then allow people to search an entire region, instead > of having to select individual suburbs or postcodes. Ie I have a table > called regions that just has Postcode | Region as the fields and uses > Postcode as the primary key. That way I can do a link between the 2 tables > on postcode and find out what regions they are in. Does this make sense? > > Phil > > "Steve Onnis" <[EMAIL PROTECTED]> wrote in message news:22689@cfaussie... > > > > If you have the suburbs, then all you need are the postcodes > > > > If the user searches by Postcode then get the long/lat and then search the > > suburbs with that criteria, and visa-versa > > > > should be able to look up between the 2 tables in either direction > > > > Regards > > > > Steve Onnis > > Domain Concept Designs > > +61 422 337 685 > > +61 3 9444 7504 > > > > http://www.domainconceptdesigns.com <http://www.domainconceptdesigns.com> > > > > ("If you think it can't be done, you haven't asked me!") - Steve Onnis > > > > > > > > > > > > -----Original Message----- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED]]On Behalf Of Phil > > Rasmussen > > Sent: Thursday, February 06, 2003 5:38 PM > > To: CFAussie Mailing List > > Subject: [cfaussie] Re: Postcode question > > > > > > 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/ > > > > > > > > > --- > 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/
