RE: [MI-L] CONTOUR QUERY

[Llewellyn, David]

Title: CONTOUR QUERY

Hi Peter,   Try putting in another column, type integer. If your contour values are decimals defined to one decimal place, then populate the integer column with ‘decimal column * 10’. Then use the integer column to do the filtering.   DecCol      IntCol 2.0            20 2.5            25 3.0            30   etc   You can use the Mod operator on the IntCol using a value of 10 to get just the 2.0 and 3.0 contours, inverting this selection on the sample above would give you just the 2.5 contour. There are other variations you can try. There may also be some issues with rounding, and you would need to check MapInfo behaviour on this, but this is the general idea.   Cheers David Llewellyn   -----Original Message----- From: Peter Hatton [mailto:[EMAIL PROTECTED] Sent: Thursday, 23 March 2006 11:18 AM To: mapinfo-l@lists.directionsmag.com Subject: [MI-L] CONTOUR QUERY                     Hi all,                                 We have a table of .5m increment contour data that is in Decimal (6,1) table structure format and has 1 column only, being a height value. What we would like to be able to do is sift out any heights of certain values ........ ie: 1.0m    2.0m   etc.  Am using the Mod Operator    such as ..... Mod 5=0 .. but am getting mixed results because of the .5 values.                 Hoping someone can assist ................. Many thanks in advance ..........                                                                                    Regards                                                                     Peter   Peter HATTON GIS Officer Greater Taree City Council 2 Pulteney Street TAREE 2430 phone 02 6592 5227 e-mail     [EMAIL PROTECTED] gov.au This e-mail has been scanned for viruses by MCI's Internet Managed Scanning Services - powered by MessageLabs. For further information visit http://www.mci.com This email and any files transmitted with it are intended solely for the use of the individual or entity to whom they are addressed. Greater Taree City Council is a government organisation and is subject to Freedom of Information legislation. You must assume that any material sent to Greater Taree City Council may be accessible by persons other than the intended recipient. The contents of this message may express views and opinions not necessarily shared by Greater Taree City Council. ***This Email, together with any attachments is intended for the addressee only. If you have received this Email in error please inform the sender immediately by return Email. Alternatively you can ring the National Native Title Tribunal on the toll free number 1800 640 501 and report the error. Please delete the Email and any copies from your computer and/or computer network. The Tribunal does not warrant that this email is virus free. The Tribunal has also implemented content filtering of Emails to restrict inappropriate and spam emails being received. Other emails which may contain viruses may also be blocked. In either case, and in any case the email may not reach its intended recipient. If the email is important you may wish to see confirmation of its receipt by placing that request in the text of the email. Please resend the email if you haven't received that confirmation as requested. ***

_______________________________________________
MapInfo-L mailing list
MapInfo-L@lists.directionsmag.com
http://www.directionsmag.com/mailman/listinfo/mapinfo-l