Peter Brawley
peter.brawley at earthlink.net
Fri Aug 19 11:23:15 CDT 2005
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 >> >> >> >> >> >> > > > -------------- next part -------------- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.338 / Virus Database: 267.10.13/78 - Release Date: 8/19/2005