Philip, If you can't possibly avoid getting the duplicates, then there's a free tool by Jacques Paris that eliminates duplicate records according to different strategies. It can be found here and includes documentation explaining how it works: http://www.paris-pc-gis.com/ppcc/moreskimall.htm
Best regards, Jorge _______________________________________ Jorge Gil BArch MSc Simulation Developer SPACE SYNTAX 11 Riverside Studios 28 Park Street London SE1 9EQ United Kingdom direct +44 (0) 20 7940 1881 switchboard +44 (0) 20 7940 0000 fax +44 (0) 20 7940 0005 email [EMAIL PROTECTED] web www.spacesyntax.com _______________________________________ Space Syntax Limited. Registered Office: 30 City Road, London. EC1Y 2AB. Registered in England no 2404770. _______________________________________ This document is confidential to the addressee and may be privileged. Neither the confidentiality nor any privilege is waived, lost or destroyed by reason that it has been mistakenly transmitted to a person other than the addressee. If you are not the addressee please contact this office immediately. _______________________________________ -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 27 January 2005 19:36 To: [email protected] Subject: MI-L Duplicate Records Query Group, Can anyone give me a heads up on how to eliminate duplicate records in M 7.5. I'm making a new nation wide roads layer and there will be about 300,000-500,000 duplicate records because of the way I've been given the tab files. Each road segment has its own id number. Thanks -------------------------------------------------------------------- Philip Lesnik Research Systems Analyst, Market Research General Growth Properties, Inc. 110 N. Wacker Drive BSC 3-13 Chicago, IL 60606 312-960-2998 312-960-5519 (fax) [EMAIL PROTECTED] -------------------------------------------------------------------- ----------------------------------------- +++++++++++++++++++++++++++++++++++++++++++++++++++++++ Notice: This e-mail including attachments) is covered by the Electronic Communications Privacy Act, 18 U.S.C. �� 2510-2521, is confidential and may be legally privileged. If you are not the intended recipient, you are hereby notified that any retention, dissemination, distribution, or copying of this communication is strictly prohibited. Please reply to the sender that you have received the message in error, then delete it. Thank you. +++++++++++++++++++++++++++++++++++++++++++++++++++++++ --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 15023 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 15044
