MapInfo data filtering / query

1,180 views
Skip to first unread message

karpp...@gmail.com

unread,
Jan 13, 2014, 6:37:25 AM1/13/14
to mapi...@googlegroups.com
I want to display only certain data points from the table file on the map, for example, only points coded e.g. 310. How to do this?

Data Directions

unread,
Jan 13, 2014, 6:48:48 AM1/13/14
to mapi...@googlegroups.com

Run a Query > Select, and assuming your column is named “Locations” the query would either be:

 

Locations = “310” (if the column is a character field)

 

OR

 

Locations = 310 (if the column is a numerical field … no quotes required).

 

Then go to your Layer Control, turn off the display for the source “Point table” and add in your “Selection”

 

Only the “310” points will be shown.

 

Regards,

 

Bill

--
--
You received this message because you are subscribed to the
Google Groups "MapInfo-L" group.To post a message to this group, send
email to mapi...@googlegroups.com
To unsubscribe from this group, go to:
http://groups.google.com/group/mapinfo-l/subscribe?hl=en
For more options, information and links to MapInfo resources (searching
archives, feature requests, to visit our Wiki, visit the Welcome page at
http://groups.google.com/group/mapinfo-l?hl=en
 
---
You received this message because you are subscribed to the Google Groups "MapInfo-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mapinfo-l+...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

karpp...@gmail.com

unread,
Jan 13, 2014, 9:12:15 AM1/13/14
to mapi...@googlegroups.com
This is great, thank you!

I tried this, but did not manage to do this, I did not find any useful information in the instructions or manual.
The secret was the quotes...


Greetings,

PK

smart...@gmail.com

unread,
Jan 14, 2014, 12:36:44 AM1/14/14
to mapi...@googlegroups.com
Or, if you have a very recent version of MapInfo, you can do the same thing, somewhat more easily, through the Browser window's Filter dialog.  Once you get the filter set up the way you like, there's a Create Query menu item that turns that filter condition into a query, with an option to add it as a layer to your map. 
Reply all
Reply to author
Forward
0 new messages