RE : [MI-L] MI-L : Funny One - Is there a way to select by boundarycolour?...

Fri, 02 Jun 2006 05:37:38 -0700

Title: Message
Hi,
 
No problem, it's a classical one in fact.
 
You've got a pretty nice and very useful tool here : http://members.iinet.net.au/~haycraft/iaa/
in Free Tools / SDS (Select by Drawing Style)
 
Have fun !
 
Robin.
 
#######
Extract :

Select By Drawing Style (SDS)

If you're a Mapinfo Pro user and you want to Select some rows of a table, not by values in the text fields, but by the Drawing Style of the objects in the Obj field, then it's a real chore.

For example if you need to select, from a table of Text objects, the rows containing Text features drawn with

  • Box background
  • Bold and Shadow effects
then you'll have to type

select * from TextTable into Selection
where (((StyleAttr(ObjectInfo(Obj,2),2)\256) mod 2)=0)
and (StyleAttr(ObjectInfo(Obj,2),5)<>-1)
and (((StyleAttr(ObjectInfo(Obj,2),2)\1) mod 2)=1)
and (((StyleAttr(ObjectInfo(Obj,2),2)\32) mod 2)=1)

SDS is query builder tool that lets you build and execute such queries through familiar style-picker dialogs.

 
 
 
-----Message d'origine-----
De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] De la part de John Nott
Envoyé : vendredi 2 juin 2006 12:25
À : [email protected]
Objet : [MI-L] MI-L : Funny One - Is there a way to select by boundarycolour?...

Hello All,

 

This is an odd one – I have received a table containing about 3,000 sites. Approximately half of which have been updated and half haven’t. The problem is that the data capture team doing the updates have simply coloured the updated sites red and the left the unupdated ones black – they haven’t added a column to the database unfortunately.

 

As you can imagine manually selecting all the red ones would be a pain as they are scattered amongst the table. Is there anyway or any tool that can select all the “red” site boundaries??

 

Told you it was a funny one!!

 

Cheers!

 

 

John Nott

Consultant/GIS Analyst

 

 

_______________________________________________
MapInfo-L mailing list
[email protected]
http://www.directionsmag.com/mailman/listinfo/mapinfo-l

Reply via email to