I forgot to mention that I didn't test whether the Where syntax ((LAT + "#" LONG) In (Select LAT_LONG From Selection Where NUMPOINTS > 1)) actually will work !
Peter Horsb�ll M�ller GIS Developer Geographical Information & IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk -----Original Message----- From: Peter Horsb�ll M�ller [mailto:[EMAIL PROTECTED] Sent: Saturday, May 15, 2004 9:53 AM To: Robert DeRubeis; [EMAIL PROTECTED] Subject: RE: MI-L points with same lat/lon Well, at least you can find out how many points are on top of one or several other points: In SQL Select: Columns: LAT, LONG, LAT + "#" LONG "LAT_LONG", Count(*) "NUMPOINTS" >From Tables: MYTABLE Group By: LAT, LONG Order By: NUMPOINTS Desc Now you get a grouped list of all the different LAT and LONG Values with the one that have many points at the same place at the top. To select these points, enter the following in SQL Select Columns: * >From Tables: MYTABLE Where: (LAT + "#" LONG) In (Select LAT_LONG From Selection Where NUMPOINTS > 1) HTH, Peter Horsb�ll M�ller GIS Developer Geographical Information & IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk -----Original Message----- From: Robert DeRubeis [mailto:[EMAIL PROTECTED] Sent: Friday, May 14, 2004 11: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 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 11769 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 11770
