Hi All,
Currently I am trying to append a column "Suburb" to a Streets (line object) table. Have suburb table (polygon objects) which will return the suburb name. Normally this would be easy and I would run an SQL Query along the lines of: SELECT Street.StreetName, Suburb.SuburbName FROM Street, Suburb WHERE Street.Obj INTERSECTS Suburb.Obj The problem however, is where a street crosses a suburb boundary two street objects are returned with the same name but different suburb attributes. Ultimately where there are to objects for the same street, I want to only store the one that has a greater length lying in that particular suburb. Can anyone help. I want to incorporate this in to a MapBasic script. The code would have to be as efficient as possible as the streets table has 250 000 records in it. Samuel Shelley GIS OFFICER FIRE MANAGEMENT UNIT TASMANIA FIRE SERVICE GPO Box 1526 HOBART, Tasmania AUSTRALIA, 7001 (CNR ARGYLE AND MELVILLE STS, HOBART 7000) EMAIL: [EMAIL PROTECTED] PHONE: (03) 6230 8735 FAX: (03) 6230 6647 IF CALLING FROM OUTSIDE AUSTRALIA REPLACE 03 WITH 613
