|Thanks Brand. I've been doing an OS update all morning. I am very glad to be done with that. My primary source is the CIA World Factbook, but a very close second is the UN LOCODE data base here : http://www.unece.org/cefact/locode/ This was not on your UN Data list. In ACCESS, there are Country, Subdivision, and Port Codes (77k Ports).|
Do you have any suggestions on formats which might make the files more easily accessible for Spotfire ? Right now I have the source in OO Base (which has very fancy SQL available) I dump queries to a spreadsheet and then PERL it to XML.
Does the data update automatically (or nearly so) ?
There are "only" 106 local capitals involved for the NAFTA partners, so I think I'll make a page with sunlight (daylight) calculations, as a way to avoid (until next week) the tedious
work of verifying the "My World" files :o)
--- On Fri, 10/29/10, Niemann.Brand@epamail.epa.gov <Niemann.Brand@epamail.epa.gov> wrote:
From: Niemann.Brand@epamail.epa.gov <Niemann.Brand@epamail.epa.gov>
Subject: Re: My NAFTA
To: "Gannon Dick" <email@example.com>
Cc: "W3C eGov Interest Group" <firstname.lastname@example.org>
Date: Friday, October 29, 2010, 5:50 AM
Brandemail@example.com wrote: -----
To: W3C eGov Interest Group <firstname.lastname@example.org>
From: Gannon Dick <email@example.com>
Sent by: firstname.lastname@example.org
Date: 10/28/2010 05:44PM
Subject: My NAFTA
All three countries (Canada , Mexico  and United States ) are posted.
So why bother ?
Well, political geography is not like money. It has no time value.
Governance is a "Mature Industry". They had the same product last week
as this week. Political power is defined the same way as classical
physics defines Power, as the derivative of Work with respect to Time.
That in turn means that political systems do work like a Carnot Cycle
(Engine) with an increase in Entropy (Open System). For example, a
Province of the Roman Empire has no "Power" because it does no work (any
more), and Kansas has "Power" because it does work, but does not get a
little bit bigger each night as you expect of your savings account.
These files are a framework for trade origins and destinations. You
should be able to extract the geo "categories" needed for a given task.
What would be real cool is if somebody wrote an XSLT which wrote a PERL
Script which created a list of directories, say on a thumb drive. This
would give you a filing system exactly the right size for the task,
with the idea that if you have to expand you are doing something wrong