> PS - I do want to include the distance in the output! would this be included > with teh facility in your toolbox and how do I do it with SQL (I presume it > is an option or would I need to create a new column (or update the dummy > column) with thr details?
The distance is included in the output from ToolBox and the records are sorted according to the distance as well. You also have 2 options for the output. The non-default looks like what you get from the SQL below. In SQL: select table1.id,table2.id,distance(centroidX(table1.obj),centroidY(table1.obj) ,centroidX(table2.obj),centroidY(table2.obj),"mi") from table1,table2 where table1.dummyfield=table2.dummyfield and table1.id<table2.id and distance(centroidX(table1.obj),centroidY(table1.obj),centroidX(table2.ob j),centroidY(table2.obj),"mi")<20 This is not sorted according to distance, so an additional step of SQL is needed to get that. That is however quite fast to do. Regards Uffe --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 7508
