Hi Folks, I have a table of statistical local areas (regions) and would like to append to the table the SLA codes (identifiers) of the neighbouring SLA regions for each record.
I'm guesing that I may have to create a looping query in MapBasic to create a new record for each incidence of a SLA and it's neighbouring region. I'd like to end up with a table looking like the following: SLA Int_SLA 1 2 1 3 1 4 2 1 Where each row is an instance of two SLAs that intersect. If someone knows of a previous reference to this I am happy to dig it out of the archives...but I have not been successfull in my searches. Something tells me the solution shouldn't have to be as tricky as I'm thinking. Can anyone suggest how I should approach this? Cheers, Alistair. *************************************************** Alistair Hart GIS Project Officer Health Surveillance Tropical Public Health Unit Network PO Box 1103 Cairns QLD 4870 Ph: 0740 503 628 Fax: 0740 311 440 E: [EMAIL PROTECTED] "Disease ecology is inherently integrative and spatial, and GIS provides the environment in which the biophysical, social, behavioural, and cultural worlds can be combined for a systemic understanding of health and disease" Tim U. Sunday (2000) *********************************************************************************** This email, including any attachments sent with it, is confidential and for the sole use of the intended recipient(s). This confidentiality is not waived or lost, if you receive it and you are not the intended recipient(s), or if it is transmitted/received in error. Any unauthorised use, alteration, disclosure, distribution or review of this email is prohibited. It may be subject to a statutory duty of confidentiality if it relates to health service matters. If you are not the intended recipient(s), or if you have received this email in error, you are asked to immediately notify the sender by telephone or by return email. You should also delete this email and destroy any hard copies produced. *********************************************************************************** --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 17320
