Here's an interesting article about the issue. Send me any song connected to a city that you know or write any comments about the topic.
From ‘The Streets of Philadelphia’ to ‘Viva Las Vegas,’ an interactive map of songs about your city (The Washington Post)Here's my hint for Dublin!!!!
And here's José Julián's hint for Dublin too (link to the version by the Dubliners):