Arthur Fuller
artful at rogers.com
Fri Aug 19 18:28:57 CDT 2005
And so was Yugoslavia and the USSR. Perhaps more interesting is the case of Quebec. The PQ (separatist party) wants the freedom to separate from Canada, but denies the freedom of the first-nations people within Quebec to separate from the wannabe nation Quebec. More than once it has occurred to me that the federal government should settle all outstanding Quebec-first nations land claims in favour of the first nations -- which would effectively place about 80% of Quebec under first-nations control. That would be that for separatism unless of course the PQ chose to conquer them again. -----Original Message----- From: dba-tech-bounces at databaseadvisors.com [mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of Peter Brawley Sent: August 19, 2005 12:23 PM To: Discussion of Hardware and Software issues Subject: Re: [dba-Tech] Nations, City States, mapping same, etc. More 'n two! 40+% of Quebeckers and a third of westerners want to separate. Canada is centrifugal. P. Arthur Fuller wrote: >Wannabe nations -- great concept! Actually, there are two `movements` in >Canada. Kenora wants to separate from Ontario and join Manitoba. Some people >in Toronto want to separate from Ontario and become a city-state-province. > >-----Original Message----- >From: dba-tech-bounces at databaseadvisors.com >[mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of MartyConnelly >Sent: August 19, 2005 1:19 AM >To: Discussion of Hardware and Software issues >Subject: Re: [dba-Tech] Nations, City States, mapping same, etc. > >If you are doing this for mailing look up IPU lists otherwise I would >use UN membership for political reasons >There are still small UN protectorships and nations and areas not >recognized by the UN, >The ISO list is about 10 years behind the times. >Vienna was divided into US, British, French, and Soviet occupation zones >194555. >Berlin was similar forgot the time frame but was considered West German >after western Allied Powers occupation zones dissolved. >Macau was Dutch colony till 99 as was Hong Kong British colony now >Chinese SAR Special Administrative Region. >as is Tibet but Chinese piked that in 50's. >Hong Kongers were once allowed a British Overseas passport that did not >give residence right in Britain. > >Singapore was part of Malaya British Colony, Three years after Malaya >independance majority 75% Chinese in Singapore >seperated 1963. >I haven't used the term City-State since the Hanseatic League dissolved. >Then in Canada you have first nations. >A rose is a rose. >Oh yes Texas can still secede or split into 4 states within the union. >The Turks and Caicos want to become Canada's 11 province. >The list is endless. Try nailing Jello to a wall it would be more fruitful. >Even the CIA factbook list is missing Nations or wannabes look up >Palestine, Chechyna. > >Arthur Fuller wrote: > > > >>Fortunately, there is a DB design question herein, else I'd have to post it >>on the OT list, which is way too noisy for me LOL. >> >>I was under the impression that Singapore was a city-state, but I googled a >>few things and discovered that it is considered a nation. Further, said URL >>(http://www.cia.gov/cia/publications/factbook/geos/sn.html) contains a very >>interesting set of columns, but I will confine this question to the set >>titled "Government", which includes: >> >>Country Name: >> Long form: Republic of Singapore >> Short form: Singapore >>Government Type: >>Capital: Singapore >>Administrative Divisions: >>Independence: >>National Holiday: >>Constitution: >>Legal System: >>Suffrage: >>Executive Branch: >>Judicial Branch: >>Legislative Branch: >>Political Parties and Leaders: >>Political Pressure Groups and Leaders: >>International Organization / Participation: >>Diplomatic Representation from the U.S.: >>Flag Description: >> >>(Fill in the blanks by visiting the URL above.) >> >>My questions are: >> >>1. Is Singapore a city, a nation-state or a nation? >>2. Are these terms obsolete? >>3. Was Singapore declared a nation simply so it could fit conveniently into >>the database? >>4. Are there any other cities to which we might ascribe the descriptor >>"city-state"? (Or do we fold all such potential candidates into "nations" >> >> >as > > >>this database does with Singapore?) >>5. Are there any parts of the nation of Singapore which are not parts of >> >> >the > > >>city Singapore? >>6. Prior to 1999, how was Hong Kong classified? (And currently, how is >> >> >Macao > > >>classified?) >>7. Prior to reunification, what was the status of Berlin? >>8. In post WWII, what was Vienna (c.f. "The Third Man", directed by Carol >>Reed and starring Orson Welles and Joseph Cotton)? A city-state? A city >>controlled by four armies? A remnant of pre-war Austrian glory? >> >>Opinions and references most welcome! And just to ensure that this stays in >>the DB realm, until now I have been using the ISO list of nations. Perhaps >> >> >I > > >>should expand my list of columns to include all these other attributes? >> >>TIA, >>Arthur >> >>_______________________________________________ >>dba-Tech mailing list >>dba-Tech at databaseadvisors.com >>http://databaseadvisors.com/mailman/listinfo/dba-tech >>Website: http://www.databaseadvisors.com >> >> >> >> >> >> > > >