I have read that musicologists relate the tune to "Streets of Laredo", which is in turn an American WEstern version of the Irish song "the Rake of Mallow."

As for the New Orleans questions: I don't know about there ever having been a St. James Hospital, but it's certianly possible. The square is probably Jackson Square, home to the fabulous Cafe du Monde and the gateway to the French Quarter.