RE: MI Help with Canadian Provincial Abbreviations

[Dan Heuman]

Dara,

Take a look at this web site from Canada Post.

http://www.canadapost.ca/CPC2/addrm/addrguide/prov_symbols.html

Danny Heuman
Senior Director, Custom Research
Compusearch Inc.
Toronto, Ontario
Tel:  416-348-9180

> -Original Message-
> From: Thompson, Dara L. (RyTull) [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, July 25, 2000 10:55 AM
> To:   'MapInfo-L'
> Subject:  MI Help with Canadian Provincial Abbreviations
> 
> 
> Hello all.
> 
> I hope someone can help me.  
> 
> I am adding a 2-character field to the "Cncty_3k" file to identify the
> Canadian Province (or Territory).  As my source for the 2-digit code, I am
> using the "Province" column in the "Canada" table.  I believe that both
> tables are the supplied with MapInfo.
> 
> Here are the problems:
>   1).  The "Cncty_3k" file says that the provincial name  is
> "Nunvaut".  The "Canada" file says that it is spelled "Nunavut".  Which is
> correct?
>   2).  The "Canada" file says that the abbreviation for Nunavut is
> "NT".  That is the same abbreviation for the Northwest Territories.  Can
> someone tell me what the abbreviation is for the Northwest Territories as
> well as the Nuvaut Territory?
> 
> Thanks!
> 
>   -Dara Thompson
> --
> To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
> "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
--
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]

RE: MI How to Select NOT WITHIN

[Dan Heuman]

Thanks to all who came up with suggestions.  The key word in the query is
ANY.  Without it, the quesry doesn't work.  Thanks Justusson.

Thanks,

Danny Heuman

> -Original Message-
> From: Justusson Christer [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, May 17, 2000 1:22 AM
> To:   'Dan Heuman'
> Cc:   'MI_List_csn'
> Subject:  RE: MI How to Select NOT WITHIN
> 
> Hello!
> 
> The trick is where to place not. I think there is a techtip.
> 
> Select * from Table1 where not obj within any (select obj from Table2)
> 
> Best of regards
> Christer
> 
--
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]

MI How to Select NOT WITHIN

[Dan Heuman]

Hello All,

I have a polygon file (with 1 polygon) and a point file with 3000 points.  I
want to select all points that do not fall within the polygon.  How do I do
this?

Thanks,

Danny Heuman
--
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]