Rune,
Cool name.
Go to the SQL Select dialog, and give this a shot:
Select: Stname, StopNumber, Avg(x), Avg(y)
>From Tables: Whatever
Group By: Stname
Good old agrregation functions. That should do it.
Good luck,
Jeff James
Vice President
Sage Software, Inc.
3423 Piedmont Road NE
Suite 550
Atlanta, GA 30305
www.sagesoft.com
Phone: 404.262.7478 Ext. 12
Fax: 404.832.3366
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of
[EMAIL PROTECTED]
Sent: Friday, September 17, 1999 6:55 AM
To: [EMAIL PROTECTED]
Subject: MI Well, I need "Average function"-help
Tony (who posted the org. message) worked out a solution on his own...well
done
on a friday, couldn't be me :-D
Well I got a simular problem. My GPS-buss-stops-files (puh!) looks something
like this:
Stname StopNumber x y
osloA 123 100 200
osloA 123 110 210
osloB 456 300 400
osloC 789 500 600
osloC 789 510 610
osloC 789 520 620
This means that the same busstop (stoppname/stopnumber) can have one, two,
three or more coordinates, because the buss can stop on both sides of the
road,
dependiing on the direction. There could also be more than one road, so that
the buss sometimes stop on one road (both sides), but other times take a
turn
to serve a different area.
I want to create a new file from the original, that gives me the avergage
coordinate for each unique stopname/number, simular to this:
Stame StopNumber x y
osloA 123 105 205
osloB 456 300 400
osloC 789 510 610
Could this be done? on a friday?
Best reg. Rune
ps: Wishes all a nice week-end.
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
