Hi John Use the SQL functions SphericalArea(obj, "sq mi") or CartesianArea(obj, "sq mi"). Change the "sq mi" to units you want for the area (i.e. square metres - "sq m", or square kilometres - "sq km", etc.).
Don Mitchell -----Original Message----- From: John Nott [mailto:[EMAIL PROTECTED] Sent: October 7, 2004 6:46 AM To: [EMAIL PROTECTED] Subject: MI-L polygon Area Hello, Can someone remind me how to update a table so that I add a column showing the areas of all the polygons in the table. I know I add a column and click "update column" but what is the sql code for an area?? Thanks A Million!, - john John Nott Consultant/GIS Analyst ROGER TYM & PARTNERS Fairfax House, 15 Fulwood Place, London, WC1V 6HU t 020 7831 2711 f 020 7831 7653 e [EMAIL PROTECTED] w www.tymconsult.com The information in this email is confidential. It may also be legally privileged. It is intended only for the stated addressee(s) and access to it by any other person is unauthorised. If you are not an addressee, you must not disclose, copy, circulate or in any other way use or rely upon the information contained in this email. Such unauthorised use may be unlawful. If you have received this email in error, please reply immediately to this effect and delete it (and all copies) from your system (with thanks). This message and any attached files have been scanned for the presence of computer viruses. However, you are advised that you open any attachment at your own risk. --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 13626
