RE: Deleting replicate data points in MI 5.0 table

1999-08-25 Thread Sue Port
Hi Tim, One way to get rid of your duplicate points would be to do a SQL with a "group by" and re-generate the points through the "Create Points" command. 1. Do the following SQL statement: Select {Tag},Format$(CentroidX(obj),"#.") "X", Format$(CentroidY(obj),"#.")"Y" >From {Ta

Deleting replicate data points in MI 5.0 table

1999-08-24 Thread Tim Haeusler
Hi MI People, I have what I thought to be a simple problem. I have a table in MI5.0 that contains 44000 location points with just a one column tag. My problem is that there are 14,000 points which are replicated in the data. Same tag-same point. (The data originates from a poorly maintained O