RE: MI Help with Canadian Provincial Abbreviations

[sidney . mclean]

Hi all,

I think this originally only went to Dara, so sorry for the duplication, but 
"Nunavut" is the correct spelling, and "NT" the abbreviation, same as for 
NWT, even though they're separate territories.  For other info on postal 
codes/abbreviations for provinces, territories and the like go to the Canada 
Post site, it's at:  www.canadapost.ca

Cheers,
-Sidney 

Sidney McLean
Child, Youth and Social Development Studies
Applied Research Branch-HRDC
165 Hotel de Ville
Phase II, 7th Floor
Hull, Quebec
K1A 0J2
-- Original Text --

From: "John Chioles" [EMAIL PROTECTED], on 2000-07-25 03:12 PM:

According to my sources
1) Nunavut is correct
2) NU is the abbreviation

-Original Message-
From: Lindsay Giles [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 25, 2000 12:13 PM
To: 'Thompson, Dara L. (RyTull)'; 'MapInfo-L'
Subject: RE: MI Help with Canadian Provincial Abbreviations


Hello Dara-
1) The correct spelling for it is "Nunavut"

2) To the best of my knowledge, they are both NT - all addresses I have 
seen within Nunavut carry NT as their descriptor. I could be wrong but I 
have not seen any other code.

Lindsay Giles
Senior GIS Analyst

AXYS Environmental Consulting Ltd
Suite 600-555 4th Ave. SW
Calgary, AB
T2P 3E7

e-mail: [EMAIL PROTECTED]
Main Office:403-269-5150
Direct Line:403-750-7671
Fax:403-269-5245
Visit our web site at http://www.axys.net




-Original Message-
From:   Thompson, Dara L. (RyTull) [SMTP:[EMAIL PROTECTED]]
Sent:   Tuesday, July 25, 2000 8: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]
--
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]

MI-SQL help

[sidney . mclean]

Hello all,

This seems to me to be a very simple question, but for some reason I can't 
find an answer so am hoping someone can help me out.  
I have two themes, one polygon, one point.  I would like to select out those 
polygon objects that have a high percentage of individuals in the population 
with certain specified characteristics (i.e. language spoken) but that do/do 
not contain the point objects.  The first part is no problem, nor is testing 
for containment, but it is testing for non-containment that I can't figure 
out.  I've tried using 'not' in various ways in my SQL queries, but with no 
success.  

Does anyone have any suggestions or experience with this?

Regards,
-Sidney 

Sidney McLean
Child, Youth and Social Development Studies
Applied Research Branch-HRDC
165 Hotel de Ville
Phase II, 7th Floor
Hull, Quebec
K1A 0J2
--
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 creating points from centroids

[Sidney . McLean]

Hello users,

I have a polygon coverage of Census Enumeration Areas for a particular urban 
region, from which I would like to create a point theme consisting solely of 
points located at the centroids of each Enumeration Area.  Has anyone done 
something like this before, and if so, how do you go about doing it?  Any 
help would really be appreciated.

Regards,
-Sidney 

- -

Sidney McLean
Income Security and Social Development Studies
Applied Research Branch
Human Resource Development Canada
165 Hotel de Ville
Phase II, 7th Floor
Hull, Quebec
K1A 0J2
--
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]