Tom, set coordsys earth projection 8, 79, "m", -2, 49, 0.9996012717, 400000, -100000
This sets your session coordinates to OS BNG. Update <table name> Set <xcol> = CentroidX(obj) Update <table name> Set <ycol> = CentroidY(obj) Browse * From <table name> This updates your columns and browses the results. Hope that helps, Dave. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 18 May 2005 14:58 To: [email protected] Subject: MI-L CentroidX function to populate fields Hi List, I'm using MapInfo Professional 5.01 and an add-in called RLfinder, which finds repeat locations from a table, from the X and Y co-ordinates. I want to use the CentroidX function in Query>Select to populate the 'X' column and, unsurprisingly, CentroidY to populate 'Y'. I've done this before but can't remember the correct syntax - can anyone help? Regards, Tom Clements Crime Analyst, CWCIU Email text is not protectively marked ********************************************************************** It is the policy of the MPS that: MPS personnel (or agents working on behalf of the MPS) must not use MPS systems to author, transmit or store documents such as electronic mail (e-mail) messages or attachments: * containing racist, homophobic, sexist, defamatory, offensive, illegal or otherwise inappropriate material; * for other than official or semi-official MPS purposes; * containing material requiring a protective marking higher than RESTRICTED, (and not higher than NOT PROTECTIVELY MARKED across the internet) without the use of approved encryption; * containing personal data for use other than in accordance with the notification(s) under the Data Protection Act, 1998 of the system(s) from which the data originates. * This Email message has been scanned for viruses and contents. ********************************************************************** --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 16523 This message has been scanned for viruses by MailControl - (see http://bluepages.wsatkins.co.uk/?4318150) This email and any attached files are confidential and copyright protected. If you are not the addressee, any dissemination of this communication is strictly prohibited. Unless otherwise expressly agreed in writing, nothing stated in this communication shall be legally binding. --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 16524
