Wanted: A consumer-geek friendly triple store database management solution

For the hundredth time I contemplated the challenges of managing personal data with general purpose database management tools (FileMaker Pro for OS X and XP, Microsoft Access for XP) and special purpose database management tools (Address Book and iCal for OS X, Google Contacts and Calendar, Outlook for XP, 1Password for iPhone and OS X).

It’s really an intractable mess. There’s no practical way to move data between these stores (tab delimited files were never enough), much less synchronize data. Everything is in proprietary data stores – fundamentally hostile to data freedom.

Then a little bulb went off. Lately I’ve been slogging through Allemang and Handler’s “Semantic web for the working ontologist”. It’s heavy going, not least because the further you get from the early chapters the greater the underlying uncertainty. Will we really use OWL and SPARQL ten years from now?

On the other hand, the early stuff is persuasive, especially the descriptions of the RDF Triple Store and the RDFS data definition and transformation language. The above wikipedia link, as of today, doesn’t do justice to the real value of this work. To me the fundamental appeal is that there’s a solid and increasingly accepted specification for a universal data representation store that not only encodes data, but also metadata – the equivalent of column names, data types (strings, numbers, etc), table names, relationships and so on.

This stuff was created over the past 20+ years to integrate “say anything, anywhere” data sources across the Net [1]. The movement has been popularized by Tim (web ground zero) Berner-Lee in lots of semantic web presentations.

So we now have a standard way to represent data and data relationships, to manipulate both things across all platforms, the RDF Triple Store + RDFS combination. Heck, it can even manage graphs!

Bingo.

That’s how I want my data to live, whether it’s my Contacts or my Calendar or my Passwords everything else that’s not a document. Finally I’ll have the tools I need to, you know, manage my contacts and passwords and so on.

Sure, performance is an issue – but I’m not dealing with a trillion records. I’m dealing with a few thousand records. Stick the damned structure in RAM and build indices galore – I don’t care. The key thing is having a standard way to store and manipulate my data.

So all you niche vendors out there, all you guys that want to take the market away from FileMaker and especially Microsoft – give me a consumer-grade (think Bento – but less stupid) Triple Store based solution that will let me work with data across platforms and applications.

I’d appreciate it.

[1] Anyone remember Apple’s “HotSauce” Project X MCF work from the early 1990s? MCF moved to XML format then to Netscape and later joined the RDF development stream.

What gene studies reveal about the diversity and resilience of mind, and the limitations of psychiatric disease classification

This research further confirms results first published in Science three months ago. The continued blurring of the diagnostic boundaries between manic-depression and schizophrenia is significant, as is the relationship to control of the immune system. It has always been interesting to contemplate similarities between the immune and nervous systems …

BBC NEWS | Health | Gene clues to schizophrenia risk

Scientists have identified thousands of tiny genetic variations which together could account for more than a third of the inherited risk of schizophrenia…

… The findings came from work by three separate teams, who analysed DNA from thousands of people.

The studies - the biggest ever into the genetics of schizophrenia - appear in the journal Nature.

The findings suggest that schizophrenia is much more complex than previously thought, and can arise not only from rare genetic variants, but common ones as well…

… The researchers say that individually many of the genetic variations they have identified play only a tiny role in raising the risk of passing schizophrenia down the generations … "Cumulatively, they play a major role, accounting for at least one-third - and probably much more - of disease risk."

All three studies highlight genes found on Chromosome 6 in area known as the Major Histocompatibility Complex, which plays a role in the immune system, and in controlling when other genes are switched on and off.

The researchers believe this might help explain why environmental factors also seem to affect risk for schizophrenia…. For example, there is evidence that children whose mothers contract flu while pregnant have a higher risk.

In total the researchers identified 30,000 tiny genetic variants more common in people with schizophrenia.

A similar pattern was found in people with bipolar disorder…

… Dr Thomas Insel, of the US National Institute of Mental Health, said: "These new results recommend a fresh look at our diagnostic categories.

… "If some of the same genetic risks underlie schizophrenia and bipolar disorder, perhaps these disorders originate from some common vulnerability in brain development." …

It feels like we’re making a genuine leap forward in our understanding of the what some call the “connectopathies”. One of the more immediate implications is that we’re driving another nail into the increasingly problematic classificationd (nosologies, as in DSM IV) (see – psychiatric diagnoses, 200 years behind) of disturbances of the mind.

The BBC article claims that this is a new discovery of similarities between schizophrenia and bipolar disorder, but I posted on that in 2003 …

BBC NEWS | Health | Mental illnesses share gene flaw (September 2003)

… Sabine Bahn, who led the research, published in The Lancet, said: "We believe that our results provide strong evidence for oligodendrocyte and myelin dysfunction in schizophrenia and bipolar disorder.

"The high degree of correlation between the expression changes in schizophrenia and bipolar disorder provide compelling evidence for common pathophysiological pathways that may govern the disease phenotypes of schizophrenia and bipolar disorder." …

In particular childhood onset “bipolar disorder” seems to have a great deal in common with early onset schizophrenia.

In a more abstract direction this research provides some tantalizing hints about the diversity of mind/brain, and the emergent resilience of the brain/mind. Thousands of gene variants all affecting minds in unpredictable ways.

By comparison we can see the diversity of our bodies, but they’re really all somewhat familiar. From a distance a parade of human forms is not that interesting. Four feet to seven feet tall, a bit of pigment variation, some muscular variability – but really, not so different. Dogs are much more diverse.

I suspect though, that a parade of minds would be far more interesting. Minds twenty feet tall and 6 inches tall, minds wide and minds narrow …

The resilience of the mind is also reinforced by this study and the earlier Science article. One in twenty people have big, ugly, mutations that ought to mess their minds completely – and yet they function very well (at least in mid-life, who knows about senescence). Somehow our minds are able to construct themselves from a very diverse and often severely flawed substrate.

That last point is what I find most interesting …

For further reading, see also the links associated with this 2008 post of mine.

Another marker of the GOP's long fall - no more Jews

The GOP has reached another milestone in its quest for irrelevance ...

GOP loses last Jewish senator with Coleman loss

WASHINGTON - The defeat of incumbent Norm Coleman in the drawn-out Minnesota Senate race leaves Republicans without a Jewish senator for the first time in half a century.

Coleman's departure comes two months after the GOP's other Jewish member, Arlen Specter of Pennsylvania, switched parties to become a Democrat...

In the House, Eric Cantor of Virginia ... is the only Jewish Republican in the 435-member body. That's down from eight Jewish GOP members who served in the House during the 1990s.

The National Jewish Democratic Council lists 30 Jewish Democrats now serving in the House. The Senate will have 13 Jewish members as of next week when Franken, Coleman's rival in Minnesota, is sworn in. That's 11 Democrats and two independents who normally vote with the Democrats.

Ira Forman, CEO of the National Jewish Democratic Council, said the sharp drop in the number of Jewish Republicans in Congress paralleled the party's shift to the right. "It's a reflection of where the Republican Party has gone," he said. "It's left the Jewish community pretty cold."...

So how many Catholics are left in the GOP? There must be a few or else the GOP would be an almost 100% WASP shop now.

I think Minnesota has the only Muslim Representative (definitely Democrat), and I'm pretty sure the Democrats have all the de facto (dare we speak it?) atheists.

For Jewish representatives the House and Senate ratios are now 30:1 and 13:0. Pretty severe ratios, especially the latter.

So is anyone in the GOP paying attention at all?

No, I didn't think so.

Consumer Reports blogs

Epochs ago we subscribed to Consumer Reports. We eventually gave up on them. Their reviews didn't match my own experience, and I found I was getting more out the negative reviews on Amazon. Their technology reviews, in particular, were very different from my own assessments.

I was also very disappointed in how little use they made of their subscriber base. That must have driven more forward looking employees berserk. They had a loyal and informed customer base they could have tapped to do the sorts of things Amazon did.

They're still around though, still nonprofit and still rejecting advertising. They've joined the 20th century however -- they have a series of Consumer Reports blogs on Electronics, Cars, Home, Safety, Shopping and more. I'm going to try a few of them, especially those that don't involve software or electronics.

U.S. Bank's ID Shield makes me scream

U.S. Bank, alas, is my bank.

Recently they instituted new mandatory "security" feature they . I had to provide them with answers to a wide range of security questions.

Yes, the "security" questions that provide a yawning back door into your online data, because it's easier for a crook to get answers to the security questions than it is to get at a strong password. Security question attacks are how most celebrity email accounts are hacked.

Today I tried to sync my Quicken data and I was asked where my maternal grandparents live.

I don't know where the #$!%$ my maternal grandparents live. They died before I was born, back in the early part of the last century.

American Express does not do this to me. I respect American Express's security model; ever since I learned the hard way about the Visa/MC systems.

I can't tolerate the pain of switching checking accounts, but US Bank has earned my enmity. I'm going to make them send me paper statements until the last post person falls.

Update: It gets better. I looked up the answer to the security question in my password database. I'd used a longish passphrase, so I gave that back to US Bank. The web site croaked with an error (probably string overflow) and locked my account (yes, like this). They gave me a #$@% phone number to call. US Bank is dead to me.

In What City Did You Honeymoon?And other monstrously stupid bank security questions tells us these passphrases are the fault of RSA Mobile, who provides them to banks. I want a bank that's smart enough to pay for a smarter version of two factor authentication. For example:

... Instead of coming up with ever-more-ornate questions about teachers and toys, banks and security companies should push solutions that are safe and customer-friendly. While everyone hates calling customer service, confirming your identity on the phone (an out-of-band device) is way more secure than using an online form. RSA's Gaffan told me about a phone-based authentication system used by more than a dozen of the company's clients. At sign-up time, you enter your work, home, and cell numbers. If you lose your password, simply indicate whether you're at home, at work, or on your cell. To authenticate yourself, just answer your phone and type in a number that appears on your computer screen. There's nobody asking about your honeymoon and no stuffed animal names to remember. Sounds perfect to me. What's my favorite bank? The one that doesn't ask me stupid frigging questions...

Passwords are dying, and they may take the world's less intelligent banks down with them.

Update 7/1/09: Michael A. points out that parents and children know each other's secret questions (children may need to do a bit of social engineering). On the other hand, spouses don't. My wife and I share a US Bank account, and she doesn't know my "High School mascot". There's got to be a lawsuit in here somewhere. Children hacking parental bank accounts, spouses denied access, users denied access ... I fear we don't have enough hungry lawyers these days.

There's a simple solution for US Bank that would be a win-win. Provide an option for customers to choose an alternative authentication option. Customers using option B would be required to have a strong password (but not to change it routinely, that's been shown to harm security) and, if they need to reset it, to physically travel to a bank branch, present legal ID, and pay $20 cash to cover the extra costs.

Update 7/3/09: One common workaround for stupidity of this extraordinary magnitude is to come up with a single robust "backdoor" password and use it to answer every secret question. US Bank does not allow this, each "secret question" response must be unique. I need a smarter bank! I can't trust any entity this incompetent with our money and our identity.

I've asked Bruce Schneier if he could write an essay identifying banks who actually demonstrate a basic understanding of security principles. I've also written a note to REI, who's VISA card I like. Unfortunately REI use's US Bank ...

... I love my REI Visa card, and I use it all the time.

Unfortunately, US Bank has introduced new online banking security measures that are proof of security team incompetence...

... I can't use an online bank with an incompetent security team!

I'm sorry I'll have to give up my REI Visa card. I hope you'll consider this email when you evaluate your relationship with US Bank.

Dog food: now it's the fluoride

We don't know the safe levels for dogs. Apparently the fluoride comes from a high bone meal content in pet food ...

Fluoride in dog food - Pets' health at risk? | Environmental Working Group:

.... An independent laboratory test of popular dog food brands, commissioned by Environmental Working Group, revealed that the food we buy for our pets contains high levels of fluoride, a contaminant that may put dogs' health at risk.

Eight major national brands marketed for both puppies and adults contained fluoride in amounts between 1.6 and 2.5 times higher than the Environmental Protection Agency's maximum legal dose in drinking water... All 8 brands contain bone meal and animal byproducts, the likely source of the fluoride contamination.

Scientists have not studied the safety of high doses of fluoride for dogs....

It's hard to know what to make of this, except to reiterate that, in practice, libertarianism sucks.

Coleman is gone. At last.

It's a bit anti-climactic, but it's still good ...

The Associated Press: GOP's Coleman concedes, sending Franken to Senate

... Republican Norm Coleman has conceded to Democrat Al Franken in Minnesota's contested Senate race, ending a nearly eight-month recount and court fight.

Coleman conceded at a news conference in St. Paul, a few hours after a unanimous Minnesota Supreme Court ruled Tuesday the former 'Saturday Night Live' comedian and liberal commentator should be certified the winner...

...A spokesman for Senate Majority Leader Harry Reid says the earliest Franken would be seated is next week, because the Senate is out of session for the July 4 holiday."

Coleman steered to the wind. When Bush was powerful he was a conservative, when Bush weakened he was a "moderate". He was never a GOP rebel like the Senators from Maine.

Health Care reform and Climate change response (aka the survival of civilization) both got a big boost today. Of course there really aren't 60 certain votes for anything, but we're closer.

Now if we could just get rid of Pawlenty ...

States nobody should live in: add Georgia

One less state that a moral person would choose to live in ...

Editorial - Two Meals and Not Always Square - NYTimes.com

... Three days a week, Georgia now serves inmates only two meals...

Texas is another such.

Minnesota is a better choice.

Human progress and global climate change – are we good enough?

We are not what we were 20,000 years ago. We are not the people of 2,000 years past.

Hell, we’re not even the people I was born to.

We’re better than we were.

We’re better at damned near everything. I don’t know the how or why, but we’re still around 50 years post-fusion weapons. We got rid of Freon. We don’t routinely torture children in public schools. We have the ADA. We don’t smoke on airplanes. We have Obama. Gay unions, by whatever name, are inevitable. Religious fundamentalism in American is on the wane. We got rid of the torturers. Maybe this year, maybe ten years from now, America will guarantee good-enough health care to every American.

Progress happens. Lots of progress. Yeah, we go backwards, just like real estate, the Dow, and average July temperatures. Backwards – in the short term. Long term it’s one hell of a trend.

So I think that if the climate change riff on our smoldering Malthusian crisis had come along in 2060 that we’d be ok. Fifty more years of Singularity-free progress and we’d be ready to handle our CO2 problem.

Except it isn’t 2060, and we’re struggling big time. The US Congress has passed a bill that gets us about 5% of the distance, and the Senate is expected to suffocate it. To add injury to injury, those who argued against the bill were babbling gibberish.

I think we’ll still work something out. It’s the Obama effect; the boundaries of the impossible have moved. It’s going to take a lot of effort from the Rationalists however.

So I’ll start with an exercise. I’m going to try to invent a plausible argument against a Carbon Tax-equivalent like Cap and Trade.

For my first Denialist argument I’ll admit that the earth has been been growing warmer, on average, over the past 150 years. There’s no sense fighting on this point.

Then I’ll grant that CO2 might warm the earth, but I’ll say that particulates also cool the earth. Moreover, I’ll claim, we can’t trust simulation data so we  really don’t have good evidence that CO2 emissions are warming the globe. The effect may be solar in nature, and the historic relationship of global warming to CO2 rise is merely coincidence [1]. Therefore, I’ll argue, we need to do more research before acting on CO2 emissions.

That’s one. For my second argument I’ll grant that the earth is getting warmer and CO2 is the cause, but over the next 100 years it’s cheaper to adapt (build submerged homes) than it is to reduce CO2 output. Most likely, assuming we don’t vent the methane, we’ll only have a 3-4 degree Celsius warming by 2100 and that will only reduce GDP by 5%. By the time we get to 2060 we’ll be sucking yottawatts from parallel universes and we can dump the CO2 back into whatever cosmos we’ve depleted.

For my third argument I’ll grant the earth is getting warming, and that CO2 is the cause, and that we can’t “adapt” without risking human civilization and the lives of billions of people. In this case we should invest in terra-forming and climate engineering, such as CO2 sequestration or high altitude aerosol deposition, and forget about Carbon taxes.

So far I’ve come up with three semi-rational contrarian arguments all opposing a Carbon Tax (equivalent). I’ll call them “Solarian”, “Adaptionist”, and “GeoEngineering”. The three cover a spectrum from very weak (Solarian) to worthy of discussion (GeoEngineering).

The latter two are reasonable enough that most Rationalists would include aspects of them in a full-spectrum response. Personally I believe the “Adaptionist” argument makes unrealistic assumptions about the willingness of millions of humans to go gently in the night, and I think the GeoEngineering is astoundingly unlikely to work. Still, I think we’ll have to have some Adaptation (Leaving New Orleans…) and the GeoEngineering approaches do deserve study and testing.

Are there any quasi-Rational arguments against a Carbon Tax (or equivalent) that I’ve missed?

[1] An odd coincidence of course.

Finance transactions aren't so standard after all

In my job I'm familiar with the hellish stew of healthcare IT transactions.

Honestly, I'm a bit of an expert about that.

We always assume things are better in the simpler world of bank transactions.

That's probably true, but apparently they weren't so great 10 years ago ...

Charlie's Diary: How I got here in the end, part nine: the little start-up that could:

.... 1998 was a painful learning experience. It turns out that while the British banks all adhered to the APACS protocols for exchanging financial transactions, the protocols in question were prone to, ah, flexible interpretation — and each and every one of the banks interpreted them differently, seemingly in order to lock out their competitor's suppliers' EPOS terminals....

Standards are hard work, particularly when one's income depends on the standards not quite working.

Cyclopath.org: A GeoWiki for the Twin Cities metro area

Cyclopath is a Twin Cities Metro area bicycle map and "GeoWiki". It's operated by the University of Minnesota's GroupLens Research group. An associated Wiki provides news and documentation...

Welcome to Cyclopath, the geowiki for Twin Cities bicyclists. You can use Cyclopath to find routes and share information with other cyclists.Nobody knows where you can go, and what you will find when you get there, better than you, the bicycling community. Cyclopath enables bicyclists to harness this collective knowledge and build a comprehensive, up-to-date information resource by and for the community

This is what I'd thought long ago I might do with msptrails.org, but it's always been a future project for me.

A very nice local development.

Mysteries of Annandale Minnesota

Parental anxieties, not without foundation, led me to a secret location a few miles from my eldest son’s overnight camp. I was under cover, he was not to know I was positioned for first night emergency response.

My bolt hole was a very small AmericInn in Annandale, Minnesota, a town of 2,700 white people that’s somewhere southeast of Lake Wobegone …

My home is the “A” in the above, and Annandale is the “B”.

In the late 19th and early 20th centuries Annandale was a railway stop that morphed into an agricultural service center and a resort community. It later became a summer lake town and probably struggled economically. Now it’s gradually being absorbed into the monster sprawl between Minneapolis and St. Cloud. If life continues on the current path (unlikely post-Peak Oil) it will be fully exurban within 15 years.

Of course I had to explore. I started with the downtown, which looks like it made a serious effort at being tourist-friendly in the past decade. There’s a genuinely artistic fountain by the library, for example. On a Sunday things are quiet, so I ended up at Tootsie’s Bar and Grill here seen in the Google Street View ..

Yes, the friggin’ Google Street view. Think about it.

I’d had enough sense to put pants on, so they didn’t beat me up. Still, it ain’t the kind of place that sees a lot of strangers on a Sunday night. I made the mistake of sitting at a table. I think I could have died of old age there. I did better at the bar.

The white skin didn’t fool the locals. They could tell I didn’t belong.

I went to check out the library since I’ll need a place to work tomorrow. While I was sitting there the local cops pulled in. Coincidence, I’m sure.

I knew there had to be a mystery in Annandale, so before the cops chased me away I scanned the sat view of the town on my iPhone. Sure enough, this looked odd …

What was laid out in a grid like that, and what were the flat greenish areas? Street view didn’t go in there, and the satellite res was too low. It looks like a big parking lot, but the scale is wrong.

What could all those units be?

Think …

This is what used to be called a “trailer park”, the more correct term is modular home community (See also – a lot of American live in these communities, 10-15% maybe. They’re often hidden just out of sight). I’d guess there are about 300 units, so a good portion of Annandale lives here. These communities are too intimate for me to drive around in, but I did navigate back to check out the green area and I drove by some homes. The community looked more occupied than the rest of the town, with groups of teen and pre-teens in the streets.

The mystery areas, by the way, appear to be a manufactured wetland and the town dump. I think the latter is commonly found by modular home communities.

There are other mysteries near Annandale. One is a sign saying “Big Woods”. I had to chase that down, but the road turned to dirt and I ended up at in farmland. A sat map check didn’t show anything even remotely woody. So that one’s still a mystery.

On the other hand, I did turn up the Minnesota Pioneer Park in Annandale.

An Annandale historian tells the story. The Pioneer Park was built in the 1970s from the remnants of a train depot with the help of a group of reasonably prosperous and well connected summer residents who appeared to have an insane amount of time and energy. Thirty years later the park has seen better times, but I’ll look for a chance to get the kids out when it’s open.

Which led me to Annandale Online, the personal project of a Ms. Jill Bishop (emphases mine) …

Jill Bishop started the Annandale Online Website in 1999 while studying for a Masters of Liberal Studies. She had considered ethnography of the Annandale area for her project when she came across another city’s community website. In March 1999, Annandale Online became part of the internet after the City of Annandale okayed it. Now eight years later, Jill is still the website administrator of the site, which is sponsored by the City of Annandale. The website has grown from 50 pages when it was introduced to 600 pages of information. (A “page” can include many screens of information.)…

…The Annandale Online home page features a picture which is changed every week or two. Currently, it features a 1945 Annandale street scene. The sections include Events, Government, Library, School, Business, History, Advocate, Civic Groups, Religion-Spirituality, Health, Visitors, Other, and Weather.

The Events section includes the what, where and when of what’s going on each month in Annandale…

… There is also a link to a website in Finland listing Annandale area cemeteries and an alphabetical listing of burials in those cemeteries. This is a project completed by Ernest S. Lantto.

Annandale Online includes most everything a person would want to know about Annandale.

Actually, I don’t think it says much about the sociology and history of the modular homes, but it does hold rather a lot of information, including an explanation of how the town came to be (the page counter reads 1,263 today. If you read this, please do visit and kick the counter up a notch).

Mysteries, mostly, resolved.

I’m a great tourist.

Update: A visit to Tootsie’s should be balanced with a cup at In Hot Water on the other side of the tourist area (old main street). Superb organic/free trade coffee, great outdoor seating, small and welcoming indoor seating.

 

Alternative medicine and celebrity illness

Wealthy celebrities seem particularly prone to fantasy cures (see also - the Fall of Oprah). Unfortunately, they encourage others to make the same mistakes ...

What celebrity patients like Farrah Fawcett can teach us about cancer. - By Barron H. Lerner - Slate Magazine

Fawcett's case had another component that potentially sent the wrong message to other patients. In addition to the traditional cancer treatment she was receiving in the United States, the actress traveled to Germany six times to receive a combination of natural supplements and immune treatments not approved by the U.S. Food and Drug Administration. These trips were chronicled in a moving documentary, Farrah's Story, that aired on NBC in mid-May. In seeking this type of therapy, Fawcett mirrored a choice made by actor Steve McQueen, who futilely traveled to Mexico in 1980 in search of a cure for his malignant mesothelioma. McQueen's Mexican doctors treated him with dozens of enzymes and vitamins, coffee enemas, and an anti-cancer drug called Laetrile, which was ultimately shown to be worthless.

Did the alternative treatments help Fawcett? It is unlikely. As Laurence R. Sands, a Florida surgeon who treats anal cancer patients, told WebMD, there is no scientific proof that such immune system stimulants work. Nevertheless, one of the German doctors involved in Fawcett's case claimed that the treatments had shrunk her tumors and substantially prolonged her life.

Once again, media coverage of Fawcett's case, while ostensibly providing useful information, ran the risk of sending the exact wrong message. Thousands of desperate end-stage cancer patients traveled to Mexico upon hearing Steve McQueen's story. The new destination may now become Germany...

Well, maybe not so much to Germany given Fawcett's recent death.

I've written about science-free therapies before.

Health wars: The armies muster

Towards the end of the Lord of the Rings the armies of the West march upon Mordor. In the movie they're dwarfed by the vast hordes of Sauron.

That's how I see Obama's army (link mine, and I corrected the British "organising") ...

Healthcare - it's make or break for Barack Obama | World news | The Observer

... the town hall meeting is just one aspect of the political machine that Obama is deploying in order to force through healthcare reform. Obama's vast network of online supporters built up during his election campaign is now being swung behind the effort. Called Organizing for America, it has got 500,000 people to commit to volunteering for the healthcare cause. It has released its first advertisements and put paid staff in 31 states to organise locally. Another group, Healthcare for America NOW!, has raised $35m. It has 120 staff in more than 40 states and in April alone staged 102 events related to campaigning for change.

Thirty-five million dollars.

That's so sweet.

Sauron must be shaking in his booties.

Oh well. In the Lord of the Rings the point of Aragon's tiny army was to distract Sauron from the real goal -- tossing the Ring into the pit of fire. Maybe Obama has a top secret plan, and our pathetic forces need only distract the Enemies ....

How to choose a city to live in

Imagine you are an active geek, and that you can live in any city on earth.

Where do you go? For that matter, where might you want to visit?

There are all kinds of metrics you might consider, but there’s a single metric that produces this particular list:

1. Copenhagen, Denmark
2. Portland, Oregon
3. Munich, Germany
4. Montreal, Quebec
5. Perth, Australia
6. Amsterdam, Netherlands
7. Seattle, Washington
8. Paris, France
9. Minneapolis, Minnesota
10. Bogota, Columbia (yes)

What does Minneapolis have in common with Paris?! What joins Copenhagan and, yes, Bogota?!

Think ….

Think ….

This list. These are the world’s top 10 cities for bicycling.

I’ve lived most of my life in Montreal and Minneapolis, and I’ve bicycled Munich. It know it’s hard to credit, but there is something similar about those 3. Paris is an outlier, but then there’s no accounting for Paris.

Ok, so Bogota, which people my age associate with drug wars and extreme violence, is another outlier. Until I summarized this list I’d never have considered visiting Bogota. Now I guess I have to.

If you’re a US citizen you might now be considering Portland, Seattle and (yes!) Minneapolis. I know, it’s a bit mind blowing. Now consider this list …

1. Wisconsin
2. Minnesota
3. Massachusetts

These are the top 3 states for health care quality in a the recent NHQR State Snapshot report (I must confess, by the way, that Wisconsin is a better bicycling state than Minnesota, it’s just that it doesn’t have much in the way of an urban life.)

I live in Minnesota’s Twin Cities (St. Paul, the sleepier sib of Minneapolis), which in addition to being the #3 bike city in the USA is also home to the world’s largest and most attractive legal dog park.

Sometimes, you just get lucky.

Update: chrismealy tells us that his Seattle hometown doesn't belong on the list, and that Portland has cyclists but not infrastructure. He writes recommends a terrific bicycle blog (http://hembrow.blogspot.com/, I just subscribed) so I'll take his word for it.

I know Munich is extreme, and Montreal is only very good, so there's clearly a big drop after #3 on the list. That moves Minneapolis even further up.

Incidentally, this update gives me an excuse to post a picture of the bicycle I bought in 1976. My Raleigh International (see Sheldon Brown's page for an original ad photo) is going for the full refurb treatment at the local racing shop in honor of a coming birthday. This is the pre-refurb shop ...