Robert, i have this problem with borehole data the way i solve it is to make sure i createpoints on teh lat lon..
i then make a query of the whole table (select * from MyBore into myquery)) I then update mybore with a count of objects from MyQuery (set teh joins so that it is where objects in MYBORE intersect objects in MYQuery) this adds a temporary column to Mybore (COUNT_OF_MYQUERY) I then select * from Mybore where the COUNT_OF_MYQUERY is >1 (ie more than one bore at that loc..) hth r -----Original Message----- From: Robert DeRubeis [mailto:[EMAIL PROTECTED] Sent: 17 May 2004 17:02 To: [EMAIL PROTECTED] Cc: Kir Luong; Peter Horsb�ll M�ller Subject: Re: MI-L points with same lat/lon I've done this, and found that I have 100's of duplications of 2 or more, but I need all of the records that are duplicates. When a count query is done it does not select all records with matching lat/lon's. It returns, for example, Count Lat Lon 6 49.715709 -123.156264 5 49.709248 -124.916418 4 43.745795 -79.526276 etc, etc.. There are 15 records above with the same lat/lon. I need to be able to select all 15 records? -Bob "Kir Luong" <[EMAIL PROTECTED]> writes: >If the lat or long is the same then a count and group by function on >those variables should give you the records that are identical (group by >clause) and how many duplication (count function): >I'm not sure the mapinfo SqL...but something like: > >Select count(*),lat >from table1 >group by lat >having count(*) > 1; >execute; ===> returns a table of all lats that are duplicated and the >number of duplication > >likewise for the longs. Hope this helps. > >kir. > >-----Original Message----- >From: Robert DeRubeis [mailto:[EMAIL PROTECTED] >Sent: Friday, May 14, 2004 3:03 PM >To: [EMAIL PROTECTED] >Subject: MI-L points with same lat/lon > > >List- >Is there a way to select all records from one table where the values in 2 >different columns are identical? I wanted to select all records where the >lat of 1st record = lat of 2nd record AND lon of 1st record = lon of 2nd >record. I'm trying to identify where and how many points are right on top >of each other and if they need to be dispersed or better geocoding. > >The table has about 30,000 points and I'm using MIPro 6.5. >Thanks, >-Bob > > >--------------------------------------------------------------------- >List hosting provided by Directions Magazine | www.directionsmag.com | >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] >Message number: 11767 > > >This communication is intended for the use of the recipient to which it >is addressed, and may contain confidential, personal and or privileged >information. Please contact us immediately if you are not the intended >recipient of this communication, and do not copy, distribute, or take >action relying on it. Any communication received in error, or subsequent >reply, should be deleted or destroyed --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 11790 ********************************************************************* This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. . http://www.bgs.ac.uk ********************************************************************* --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 11791
